Assignment_Set_Creation_API

Assignment_Set_Creation_API


--Assignment_Set_Creation_API
DECLARE
   l_payroll_id            NUMBER := 61;
   l_assignment_set_name   VARCHAR2 (500) := 'XXPK_ASSIGNMENT_SET_API';
   out_assignment_set_id     NUMBER := NULL;
BEGIN


   BEGIN
      hr_jp_ast_utility_pkg.
       create_asg_set (p_assignment_set_name   => l_assignment_set_name,
                       p_business_group_id     => 81,
                       p_payroll_id            => l_payroll_id,
                       p_assignment_set_id     =>  out_assignment_set_id );
      COMMIT;

      DBMS_OUTPUT.put_line ( out_assignment_set_id  || ' has been Created Successfully !!!');
   EXCEPTION
      WHEN OTHERS
      THEN
         DBMS_OUTPUT.put_line ('Inner Exception: ' || SQLERRM);
   END;
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line ('Main Exception: ' || SQLERRM);

END;