Search This Blog

Wednesday, May 1, 2013

Delete Approved Salary Proposal - Oracle Payroll


DECLARE
     -- Start of Variable declarations, Initialize Variables with appropriate values to test the script
     -- VARCHAR2 size is set to 2000 by default, please enter target table name to retrieve the exact limit
     -- Input Variables
     V_PAY_PROPOSAL_ID               NUMBER;
     V_BUSINESS_GROUP_ID             NUMBER;
     V_OBJECT_VERSION_NUMBER         NUMBER;
     V_VALIDATE                      BOOLEAN;
     -- Output Variables
     V_SALARY_WARNING                BOOLEAN;
BEGIN
     -- Calling API HR_MAINTAIN_PROPOSAL_API.DELETE_SALARY_PROPOSAL
     HR_MAINTAIN_PROPOSAL_API.DELETE_SALARY_PROPOSAL(P_PAY_PROPOSAL_ID              => V_PAY_PROPOSAL_ID
                                                    ,P_BUSINESS_GROUP_ID            => V_BUSINESS_GROUP_ID
                                                    ,P_OBJECT_VERSION_NUMBER        => V_OBJECT_VERSION_NUMBER
                                                    ,P_VALIDATE                     => V_VALIDATE
                                                    ,P_SALARY_WARNING               => V_SALARY_WARNING
                                                    );
exception when others then;
     dbms_output.put_line.put_line('error : ' || sqlerrm);
END;

No comments:

Post a Comment