[Home] [Help]
316: l_end_date1 date;
317: l_end_date2 date;
318: l_end_date3 date;
319: l_payroll_action_created boolean := false;
320: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
321: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
322:
323:
324: /* Variable holding the balance to be tested. */
512:
513: /* Update the population status of the payroll action to indicate that all
514: the assignment actions have been created for it. */
515:
516: update pay_payroll_actions ppa
517: set ppa.action_population_status = 'C'
518: where ppa.payroll_action_id = l_payroll_action_id;
519:
520: commit;
637:
638: /* Request has been accepted so update payroll action with the
639: request details. */
640:
641: update pay_payroll_actions ppa
642: set ppa.request_id = l_request_id
643: where ppa.payroll_action_id = p_payroll_action_id;
644:
645: /* Issue a commit to synchronise the concurrent manager. */
758: l_reporting_year,
759: l_reporting_quarter,
760: l_trans_legal_co_id,
761: l_business_group_id
762: from pay_payroll_actions PA
763: where PA.payroll_action_id = p_payroll_action_id;
764:
765:
766: update pay_payroll_actions pa
762: from pay_payroll_actions PA
763: where PA.payroll_action_id = p_payroll_action_id;
764:
765:
766: update pay_payroll_actions pa
767: set PA.action_status = 'M'
768: where PA.payroll_action_id = p_payroll_action_id;
769:
770: update pay_assignment_actions AA
878: c_quarter_start date;
879: c_quarter_end date;
880: c_reporting_year varchar2(4);
881: c_reporting_quarter varchar2(4);
882: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
883: l_trans_legal_co_id number;
884: l_request_id number;
885: l_format varchar2(30);
886: l_report_type varchar2(5);