[Home] [Help]
65: p_start_person_id in per_all_people_f.person_id%type,
66: p_end_person_id in per_all_people_f.person_id%type,
67: p_chunk in number) is
68:
69: v_next_action_id pay_assignment_actions.assignment_action_id%type;
70:
71: l_x_hk_archive_message varchar2(100);
72: l_full_or_partial varchar2(15);
73: l_reporting_year varchar2(4);
76: l_error number;
77:
78:
79: cursor next_action_id is
80: select pay_assignment_actions_s.nextval
81: from dual;
82: --
83: -- Cursor to select the parameters for the current IR56B run.
84: --
123: from per_assignments_f paaf,
124: per_people_f papf,
125: pay_payroll_actions ppa, -- report payroll action
126: pay_payroll_actions ppa2, -- archive payroll action
127: pay_assignment_actions paa
128: where ppa.payroll_action_id = c_payroll_action_id
129: and papf.person_id between c_start_person_id and c_end_person_id
130: and papf.person_id = paaf.person_id
131: and papf.business_group_id = ppa.business_group_id
192: end if;
193: end if;
194:
195: -- loop through the assignments returned from the main cursor and for each
196: -- one that has no errors create the pay_assignment_actions entry.
197:
198: if l_error = 0 then
199:
200: for process_rec in process_assignments (p_payroll_action_id,
252: l_count NUMBER := 0;
253: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
254: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;
255: l_full_or_partial varchar2(15);
256: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
257:
258: l_number_of_copies NUMBER := 0; /*Reverted fix for 2810178 */
259: l_request_id NUMBER := 0;
260: l_print_return BOOLEAN;
460: -----------------------------------------------------------------------------
461:
462: function get_archive_value
463: (p_archive_name in ff_user_entities.user_entity_name%type,
464: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
465: return ff_archive_items.value%type is
466:
467: l_value ff_archive_items.value%type;
468: e_no_value_found exception;