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