APPS.PAY_SG_IRAS_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 104: v_next_action_id pay_assignment_actions.assignment_action_id%type;

100: p_start_person_id in per_all_people_f.person_id%type,
101: p_end_person_id in per_all_people_f.person_id%type,
102: p_chunk in number) is
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%type;
105: v_archive_action_id pay_assignment_actions.assignment_action_id%type;
106: v_type ff_database_items.user_name%type;
107:
108: cursor next_action_id is

Line 105: v_archive_action_id pay_assignment_actions.assignment_action_id%type;

101: p_end_person_id in per_all_people_f.person_id%type,
102: p_chunk in number) is
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%type;
105: v_archive_action_id pay_assignment_actions.assignment_action_id%type;
106: v_type ff_database_items.user_name%type;
107:
108: cursor next_action_id is
109: select pay_assignment_actions_s.nextval

Line 109: select pay_assignment_actions_s.nextval

105: v_archive_action_id pay_assignment_actions.assignment_action_id%type;
106: v_type ff_database_items.user_name%type;
107:
108: cursor next_action_id is
109: select pay_assignment_actions_s.nextval
110: from dual;
111:
112: cursor process_assignments
113: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 131: pay_assignment_actions pac

127: and exists /* Bug No : 2242653 */
128: (select null
129: from
130: pay_payroll_actions ppa,
131: pay_assignment_actions pac
132: where ppa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters)
133: and ppa.action_type = 'X'
134: and ppa.action_status = 'C'
135: and ppa.payroll_action_id = pac.payroll_action_id

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

139: (
140: select pai.locking_action_id
141: from
142: pay_action_interlocks pai,
143: pay_assignment_actions paa1,--assignment action id of the action that locks archive
144: pay_assignment_actions paa2, -- assignment action id of the magtape
145: pay_payroll_actions ppa1, -- payroll action id of the process that locks archive
146: pay_payroll_actions ppa2 -- payroll action id of the magtape process
147: where pai.locked_action_id = paa1.assignment_action_id -- archive is locked

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

140: select pai.locking_action_id
141: from
142: pay_action_interlocks pai,
143: pay_assignment_actions paa1,--assignment action id of the action that locks archive
144: pay_assignment_actions paa2, -- assignment action id of the magtape
145: pay_payroll_actions ppa1, -- payroll action id of the process that locks archive
146: pay_payroll_actions ppa2 -- payroll action id of the magtape process
147: where pai.locked_action_id = paa1.assignment_action_id -- archive is locked
148: and pai.locking_action_id = paa2.assignment_action_id -- mgtape is looking the archive

Line 173: pay_assignment_actions aacs,

169: pay_core_utils.get_parameter('ARCHIVE_RUN_ID', pa.legislative_parameters)
170: ) /* Bug#4888368 */
171: ))
172: or (g_report_type='A' AND exists (select '' from
173: pay_assignment_actions aacs,
174: pay_payroll_Actions ppas,
175: ff_archive_items ffis,
176: ff_database_items fdis
177: where ffis.context1 = aacs.assignment_action_id

Line 194: (c_payroll_action_id pay_assignment_actions.payroll_action_id%type,

190: and pei.pei_information1 is not null
191: and pei.information_type = 'HR_IR21_PROCESSING_DATES_SG');
192:
193: cursor locked_action
194: (c_payroll_action_id pay_assignment_actions.payroll_action_id%type,
195: c_assignment_id pay_assignment_actions.assignment_id%type) is
196: select pac.assignment_action_id
197: from pay_assignment_actions pac
198: where pac.assignment_id = c_assignment_id

Line 195: c_assignment_id pay_assignment_actions.assignment_id%type) is

191: and pei.information_type = 'HR_IR21_PROCESSING_DATES_SG');
192:
193: cursor locked_action
194: (c_payroll_action_id pay_assignment_actions.payroll_action_id%type,
195: c_assignment_id pay_assignment_actions.assignment_id%type) is
196: select pac.assignment_action_id
197: from pay_assignment_actions pac
198: where pac.assignment_id = c_assignment_id
199: and pac.payroll_action_id = c_payroll_action_id;

Line 197: from pay_assignment_actions pac

193: cursor locked_action
194: (c_payroll_action_id pay_assignment_actions.payroll_action_id%type,
195: c_assignment_id pay_assignment_actions.assignment_id%type) is
196: select pac.assignment_action_id
197: from pay_assignment_actions pac
198: where pac.assignment_id = c_assignment_id
199: and pac.payroll_action_id = c_payroll_action_id;
200:
201: begin

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

259: -- Used to actually perform the archival of data. We are not archiving
260: -- any data here, so this is null.
261: ------------------------------------------------------------------------
262: procedure archive_code
263: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
264: p_effective_date in date) is
265:
266: begin
267: hr_utility.set_location('Start of archive_code',8);