[Home] [Help]
770: endperson in number,
771: chunk in number) is
772: --
773: l_temp_person_id per_all_people_f.person_id%TYPE;
774: l_lockingactid pay_assignment_actions.assignment_action_id%TYPE;
775: l_business_group_id number;
776: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
777: --
778: cursor csr_actions(cp_pactid number
805: where ppa.payroll_action_id = pactid;
806: if l_legislation_code is null then
807: --
808: for people_rec in csr_actions_no_leg(pactid, stperson, endperson) loop
809: select pay_assignment_actions_s.nextval into l_lockingactid
810: from dual;
811: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure
812: -- archive_data needs it to process a person.
813: hr_nonrun_asact.insact(lockingactid => l_lockingactid,
821: else
822: -- only process those belonging to a specific legislation
823: --
824: for people_rec in csr_actions(pactid, stperson, endperson, l_legislation_code) loop
825: select pay_assignment_actions_s.nextval into l_lockingactid
826: from dual;
827: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure
828: -- archive_data needs it to process a person.
829: hr_nonrun_asact.insact(lockingactid => l_lockingactid,
920: l_num_rows_processed number;
921: --
922: cursor csr_person is
923: select ass.object_id
924: from pay_assignment_actions ass
925: where ass.assignment_action_id = p_assactid;
926: --
927: cursor csr_get_person(cp_person_id number) is
928: select rowid row_id