APPS.PAY_SG_IRAS_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 42: v_next_action_id pay_assignment_actions.assignment_action_id%type;

38: p_start_person_id in per_all_people_f.person_id%type,
39: p_end_person_id in per_all_people_f.person_id%type,
40: p_chunk in number) is
41:
42: v_next_action_id pay_assignment_actions.assignment_action_id%type;
43: v_archive_action_id pay_assignment_actions.assignment_action_id%type;
44:
45: cursor next_action_id is
46: select pay_assignment_actions_s.nextval

Line 43: v_archive_action_id pay_assignment_actions.assignment_action_id%type;

39: p_end_person_id in per_all_people_f.person_id%type,
40: p_chunk in number) is
41:
42: v_next_action_id pay_assignment_actions.assignment_action_id%type;
43: v_archive_action_id pay_assignment_actions.assignment_action_id%type;
44:
45: cursor next_action_id is
46: select pay_assignment_actions_s.nextval
47: from dual;

Line 46: select pay_assignment_actions_s.nextval

42: v_next_action_id pay_assignment_actions.assignment_action_id%type;
43: v_archive_action_id pay_assignment_actions.assignment_action_id%type;
44:
45: cursor next_action_id is
46: select pay_assignment_actions_s.nextval
47: from dual;
48:
49: cursor process_assignments
50: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 67: pay_assignment_actions pac

63: and exists /* Bug No : 2242653 */
64: (select null
65: from
66: pay_payroll_actions ppa,
67: pay_assignment_actions pac
68: where ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters)
69: and ppa.action_type = 'X'
70: and ppa.action_status = 'C'
71: and ppa.payroll_action_id = pac.payroll_action_id

Line 79: pay_assignment_actions paa1,--assignment action id of the action that locks archive

75: (
76: select pai.locking_action_id
77: from
78: pay_action_interlocks pai,
79: pay_assignment_actions paa1,--assignment action id of the action that locks archive
80: pay_assignment_actions paa2, -- assignment action id of the magtape
81: pay_payroll_actions ppa1, -- payroll action id of the process that locks archive
82: pay_payroll_actions ppa2 -- payroll action id of the magtape process
83: where pai.locked_action_id = paa1.assignment_action_id -- archive is locked

Line 80: pay_assignment_actions paa2, -- assignment action id of the magtape

76: select pai.locking_action_id
77: from
78: pay_action_interlocks pai,
79: pay_assignment_actions paa1,--assignment action id of the action that locks archive
80: pay_assignment_actions paa2, -- assignment action id of the magtape
81: pay_payroll_actions ppa1, -- payroll action id of the process that locks archive
82: pay_payroll_actions ppa2 -- payroll action id of the magtape process
83: where pai.locked_action_id = paa1.assignment_action_id -- archive is locked
84: and pai.locking_action_id = paa2.assignment_action_id -- mgtape is looking the archive

Line 115: (c_payroll_action_id pay_assignment_actions.payroll_action_id%type,

111: and pei.pei_information1 is not null
112: and pei.information_type = 'HR_IR21_PROCESSING_DATES_SG');
113:
114: cursor locked_action
115: (c_payroll_action_id pay_assignment_actions.payroll_action_id%type,
116: c_assignment_id pay_assignment_actions.assignment_id%type) is
117: select pac.assignment_action_id
118: from pay_assignment_actions pac
119: where pac.assignment_id = c_assignment_id

Line 116: c_assignment_id pay_assignment_actions.assignment_id%type) is

112: and pei.information_type = 'HR_IR21_PROCESSING_DATES_SG');
113:
114: cursor locked_action
115: (c_payroll_action_id pay_assignment_actions.payroll_action_id%type,
116: c_assignment_id pay_assignment_actions.assignment_id%type) is
117: select pac.assignment_action_id
118: from pay_assignment_actions pac
119: where pac.assignment_id = c_assignment_id
120: and pac.payroll_action_id = c_payroll_action_id;

Line 118: from pay_assignment_actions pac

114: cursor locked_action
115: (c_payroll_action_id pay_assignment_actions.payroll_action_id%type,
116: c_assignment_id pay_assignment_actions.assignment_id%type) is
117: select pac.assignment_action_id
118: from pay_assignment_actions pac
119: where pac.assignment_id = c_assignment_id
120: and pac.payroll_action_id = c_payroll_action_id;
121:
122: begin

Line 177: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

173: -- Used to actually perform the archival of data. We are not archiving
174: -- any data here, so this is null.
175: ------------------------------------------------------------------------
176: procedure archive_code
177: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
178: p_effective_date in date) is
179:
180: begin
181: hr_utility.set_location('Start of archive_code',8);