APPS.PAY_BATCH_BALANCE_ADJ_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 29: l_pac_id pay_payroll_actions.payroll_action_id%TYPE;

25: p_act_parameter_group_id in number default null
26: ) return number is
27: --
28: l_request_id number := 0;
29: l_pac_id pay_payroll_actions.payroll_action_id%TYPE;
30: l_batch_status pay_balance_batch_headers.batch_status%TYPE := null;
31: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.SUBMIT_CONC_REQUEST';
32: --
33: begin

Line 461: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

457: ( p_batch_id in number,
458: p_batch_group_id in number )
459: is
460: --
461: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
462: l_proc varchar2(72) := 'PAY_BATCH_BALANCE_ADJ_PKG.ROLLBACK_BATCH';
463:
464: l_message_source_id_tbl hr_entry.number_table;
465: l_message_source_type_tbl hr_entry.varchar2_table;

Line 481: from pay_payroll_actions pact

477: and batch_group_status = 'T';
478: --
479: cursor csr_payroll_action (p_batch_group_id number) is
480: select pact.payroll_action_id
481: from pay_payroll_actions pact
482: where pact.batch_id = p_batch_group_id
483: and pact.action_type = 'B';
484: --and pact.batch_process_mode = 'TRANSFER';
485: --

Line 633: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

629: l_message_level_tbl hr_entry.varchar2_table;
630: l_message_text_tbl varchar240_table;
631: l_count binary_integer := 0;
632: l_error_text pay_message_lines.line_text%type;
633: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
634: p_batch_name pay_balance_batch_headers.batch_name%type;
635:
636: --
637:

Line 764: update pay_payroll_actions

760: raise process_batch_failed;
761: end;
762:
763: -- Updating the payroll action table
764: update pay_payroll_actions
765: set batch_id = group_csr.batch_group_id
766: where payroll_action_id=l_payroll_action_id
767: and action_type ='B';
768: