eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYMENT_SUMMARY_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 10: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

6: g_debug boolean := TRUE; --Bug3132178
7:
8:
9: procedure range_code
10: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
11: p_sql out NOCOPY varchar2) is
12: begin
13: -- hr_utility.trace_on(null, 'magtape');
14: hr_utility.set_location('Start of range_code',1);

Line 19: ' pay_payroll_actions pa ' ||

15: /*Bug2920725 Corrected base tables to support security model*/
16:
17: p_sql := ' select distinct p.person_id' ||
18: ' from per_people_f p,' ||
19: ' pay_payroll_actions pa ' ||
20: ' where pa.payroll_action_id = :payroll_action_id' ||
21: ' and p.business_group_id = pa.business_group_id' ||
22: ' order by p.person_id';
23:

Line 102: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

98: -- Actions.
99: -----------------------------------------------------------------------+
100:
101: procedure assignment_action_code
102: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
103: p_start_person_id in per_all_people_f.person_id%type,
104: p_end_person_id in per_all_people_f.person_id%type,
105: p_chunk in number) is
106:

Line 115: l_archive_payroll_action pay_payroll_actions.payroll_action_id%type;

111: l_payment_summary_type varchar2(5) := 'O'; /* bug 6630375 */
112:
113: ------start of Bug3132178-----------------------------------------------------
114: l_testing_flag varchar2(5):='N';
115: l_archive_payroll_action pay_payroll_actions.payroll_action_id%type;
116:
117:
118: CURSOR get_parameters
119: IS

Line 123: FROM pay_payroll_actions ppa

119: IS
120: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),
121: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),
122: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */
123: FROM pay_payroll_actions ppa
124: WHERE ppa.payroll_Action_id = p_payroll_action_id;
125:
126:
127: CURSOR process_assignments_val

Line 128: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

124: WHERE ppa.payroll_Action_id = p_payroll_action_id;
125:
126:
127: CURSOR process_assignments_val
128: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
129: c_start_person_id in per_all_people_f.person_id%type,
130: c_end_person_id in per_all_people_f.person_id%type)
131: IS
132: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',

Line 147: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

143:
144: /* 9113084 - Added range cursor for above cursor process_assignments_val */
145: /* 9113084 - Cursor to fetch assignments for Data File Validation when RANGE_PERSON_ID is enabled */
146: CURSOR rg_process_assignments_val
147: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
148: c_chunk IN NUMBER)
149: IS
150: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
151: paa.assignment_action_id ps_report_id,

Line 170: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

166:
167:
168: /*Bug2920725 Corrected base tables to support security model*/
169: CURSOR process_assignments
170: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
171: c_start_person_id in per_all_people_f.person_id%type,
172: c_end_person_id in per_all_people_f.person_id%type) is
173: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
174: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)

Line 175: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

171: c_start_person_id in per_all_people_f.person_id%type,
172: c_end_person_id in per_all_people_f.person_id%type) is
173: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
174: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
175: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
176: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
177: INDEX (p PER_PEOPLE_F_PK)
178: INDEX(a PER_ASSIGNMENTS_F_PK) */
179: DISTINCT 'ASSIGNMENT_ACTION_ID=C',

Line 182: FROM pay_payroll_actions mpa,

178: INDEX(a PER_ASSIGNMENTS_F_PK) */
179: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
180: ppac.assignment_action_id ps_report_id,
181: ppac.assignment_id
182: FROM pay_payroll_actions mpa,
183: per_people_f p,
184: per_assignments_f a,
185: pay_payroll_actions apa,
186: pay_assignment_actions apac,

Line 185: pay_payroll_actions apa,

181: ppac.assignment_id
182: FROM pay_payroll_actions mpa,
183: per_people_f p,
184: per_assignments_f a,
185: pay_payroll_actions apa,
186: pay_assignment_actions apac,
187: pay_payroll_actions ppa,
188: pay_assignment_actions ppac,
189: pay_action_interlocks ppai

Line 187: pay_payroll_actions ppa,

183: per_people_f p,
184: per_assignments_f a,
185: pay_payroll_actions apa,
186: pay_assignment_actions apac,
187: pay_payroll_actions ppa,
188: pay_assignment_actions ppac,
189: pay_action_interlocks ppai
190: WHERE mpa.payroll_action_id =c_payroll_action_id
191: AND p.person_id = a.person_id

Line 215: pay_payroll_actions paas

211: AND NOT EXISTS /* 5471093 */
212: (SELECT /*+ ORDERED */ locked_action_id
213: FROM pay_action_interlocks pail,
214: pay_assignment_actions paa1,
215: pay_payroll_actions paas
216: WHERE paas.action_type='X'
217: and paas.action_status='C'
218: AND paas.report_type='AU_PS_DATA_FILE'
219: AND paa1.payroll_action_id = paas.payroll_action_id

Line 234: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

230: -- Used when RANGE_PERSON_ID feature is enabled
231: --------------------------------------------------------------------+
232: */
233:
234: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
235: c_chunk IN NUMBER)
236: IS
237: SELECT /*+ INDEX (mpa PAY_PAYROLL_ACTIONS_PK)
238: INDEX (ppr PAY_POPULATION_RANGES_N4)

Line 237: SELECT /*+ INDEX (mpa PAY_PAYROLL_ACTIONS_PK)

233:
234: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
235: c_chunk IN NUMBER)
236: IS
237: SELECT /*+ INDEX (mpa PAY_PAYROLL_ACTIONS_PK)
238: INDEX (ppr PAY_POPULATION_RANGES_N4)
239: INDEX (p PER_PEOPLE_F_PK)
240: INDEX (apa PAY_PAYROLL_ACTIONS_N52)
241: INDEX (a PER_ASSIGNMENTS_F_N12)

Line 240: INDEX (apa PAY_PAYROLL_ACTIONS_N52)

236: IS
237: SELECT /*+ INDEX (mpa PAY_PAYROLL_ACTIONS_PK)
238: INDEX (ppr PAY_POPULATION_RANGES_N4)
239: INDEX (p PER_PEOPLE_F_PK)
240: INDEX (apa PAY_PAYROLL_ACTIONS_N52)
241: INDEX (a PER_ASSIGNMENTS_F_N12)
242: INDEX (apac PAY_ASSIGNMENT_ACTIONS_N51)
243: INDEX (ppai PAY_ACTION_INTERLOCKS_FK2)
244: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)

Line 249: FROM pay_payroll_actions mpa,

245: */
246: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
247: ppac.assignment_action_id ps_report_id,
248: ppac.assignment_id
249: FROM pay_payroll_actions mpa,
250: pay_population_ranges ppr,
251: per_people_f p,
252: per_assignments_f a,
253: pay_payroll_actions apa,

Line 253: pay_payroll_actions apa,

249: FROM pay_payroll_actions mpa,
250: pay_population_ranges ppr,
251: per_people_f p,
252: per_assignments_f a,
253: pay_payroll_actions apa,
254: pay_assignment_actions apac,
255: pay_payroll_actions ppa,
256: pay_assignment_actions ppac,
257: pay_action_interlocks ppai

Line 255: pay_payroll_actions ppa,

251: per_people_f p,
252: per_assignments_f a,
253: pay_payroll_actions apa,
254: pay_assignment_actions apac,
255: pay_payroll_actions ppa,
256: pay_assignment_actions ppac,
257: pay_action_interlocks ppai
258: WHERE mpa.payroll_action_id = c_payroll_action_id
259: AND ppr.payroll_action_id = mpa.payroll_action_id

Line 288: pay_payroll_actions paas

284: AND NOT EXISTS /* 5471093 */
285: (SELECT locked_action_id
286: FROM pay_action_interlocks pail,
287: pay_assignment_actions paa1,
288: pay_payroll_actions paas
289: WHERE paas.report_type='AU_PS_DATA_FILE'
290: AND paas.report_qualifier = 'AU'
291: AND paas.report_category = 'REPORT'
292: AND paas.action_status='C'

Line 300: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

296: AND pail.locked_action_id = ppac.assignment_action_id);
297:
298:
299: CURSOR process_assignments_val_amend /* bug 6630375 */
300: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
301: c_start_person_id in per_all_people_f.person_id%type,
302: c_end_person_id in per_all_people_f.person_id%type)
303: IS
304: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',

Line 309: pay_payroll_actions ppa

305: paa.assignment_action_id ps_report_id,
306: paa.assignment_id
307: FROM pay_assignment_actions paa,
308: per_assignments_f a,
309: pay_payroll_actions ppa
310: WHERE ppa.payroll_action_id = c_payroll_action_id
311: AND ppa.payroll_action_id = paa.payroll_action_id
312: AND ppa.action_status = 'C'
313: AND a.assignment_id = paa.assignment_id

Line 323: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

319:
320: /* 9113084 - Added below range cursor for above cursor process_assignments_val_amend */
321: /* 9113084 - Cursor to fetch assigments for Amended Data File Validation when RANGE_PERSON_ID is enabled */
322: CURSOR range_assignments_val_amend
323: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
324: c_chunk IN NUMBER)
325: IS
326: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
327: paa.assignment_action_id ps_report_id,

Line 344: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

340: AND a.person_id = ppr.person_id ;
341:
342:
343: CURSOR process_assignments_amend /* bug 6630375 */
344: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
345: c_start_person_id in per_all_people_f.person_id%type,
346: c_end_person_id in per_all_people_f.person_id%type) is
347: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
348: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)

Line 349: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

345: c_start_person_id in per_all_people_f.person_id%type,
346: c_end_person_id in per_all_people_f.person_id%type) is
347: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
348: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
349: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
350: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
351: INDEX (p PER_PEOPLE_F_PK)
352: INDEX(a PER_ASSIGNMENTS_F_PK) */
353: DISTINCT 'ASSIGNMENT_ACTION_ID=C',

Line 356: FROM pay_payroll_actions mpa,

352: INDEX(a PER_ASSIGNMENTS_F_PK) */
353: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
354: ppac.assignment_action_id ps_report_id,
355: ppac.assignment_id
356: FROM pay_payroll_actions mpa,
357: per_people_f p,
358: per_assignments_f a,
359: pay_payroll_actions apa,
360: pay_assignment_actions apac,

Line 359: pay_payroll_actions apa,

355: ppac.assignment_id
356: FROM pay_payroll_actions mpa,
357: per_people_f p,
358: per_assignments_f a,
359: pay_payroll_actions apa,
360: pay_assignment_actions apac,
361: pay_payroll_actions ppa,
362: pay_assignment_actions ppac,
363: pay_action_interlocks ppai

Line 361: pay_payroll_actions ppa,

357: per_people_f p,
358: per_assignments_f a,
359: pay_payroll_actions apa,
360: pay_assignment_actions apac,
361: pay_payroll_actions ppa,
362: pay_assignment_actions ppac,
363: pay_action_interlocks ppai
364: WHERE mpa.payroll_action_id =c_payroll_action_id
365: AND p.person_id = a.person_id

Line 390: pay_payroll_actions paas

386: AND NOT EXISTS /* 5471093 */
387: (SELECT /*+ ORDERED */ locked_action_id
388: FROM pay_action_interlocks pail,
389: pay_assignment_actions paa1,
390: pay_payroll_actions paas
391: WHERE paas.action_type='X'
392: and paas.action_status='C'
393: AND paas.report_type='AU_PS_DATA_FILE'
394: AND paa1.payroll_action_id = paas.payroll_action_id

Line 402: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

398:
399: /* 9113084 - Added Range Cursor for above cursor process_assignments_amend */
400: /* 9113084 - Cursor fetches assignments for Amended Data File when RANGE_PERSON_ID is enabled */
401: CURSOR rg_process_assignments_amend
402: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
403: c_chunk IN NUMBER) is
404: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
405: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
406: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

Line 406: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

402: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
403: c_chunk IN NUMBER) is
404: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
405: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
406: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
407: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
408: INDEX (p PER_PEOPLE_F_PK)
409: INDEX(a PER_ASSIGNMENTS_F_PK) */
410: DISTINCT 'ASSIGNMENT_ACTION_ID=C',

Line 413: FROM pay_payroll_actions mpa,

409: INDEX(a PER_ASSIGNMENTS_F_PK) */
410: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
411: ppac.assignment_action_id ps_report_id,
412: ppac.assignment_id
413: FROM pay_payroll_actions mpa,
414: per_people_f p,
415: per_assignments_f a,
416: pay_payroll_actions apa,
417: pay_assignment_actions apac,

Line 416: pay_payroll_actions apa,

412: ppac.assignment_id
413: FROM pay_payroll_actions mpa,
414: per_people_f p,
415: per_assignments_f a,
416: pay_payroll_actions apa,
417: pay_assignment_actions apac,
418: pay_payroll_actions ppa,
419: pay_assignment_actions ppac,
420: pay_action_interlocks ppai,

Line 418: pay_payroll_actions ppa,

414: per_people_f p,
415: per_assignments_f a,
416: pay_payroll_actions apa,
417: pay_assignment_actions apac,
418: pay_payroll_actions ppa,
419: pay_assignment_actions ppac,
420: pay_action_interlocks ppai,
421: pay_population_ranges ppr
422: WHERE mpa.payroll_action_id =c_payroll_action_id

Line 450: pay_payroll_actions paas

446: AND NOT EXISTS
447: (SELECT /*+ ORDERED */ locked_action_id
448: FROM pay_action_interlocks pail,
449: pay_assignment_actions paa1,
450: pay_payroll_actions paas
451: WHERE paas.action_type='X'
452: and paas.action_status='C'
453: AND paas.report_type='AU_PS_DATA_FILE'
454: AND paa1.payroll_action_id = paas.payroll_action_id

Line 696: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

692: -- assume that no archival of data is required.
693: ------------------------------------------------------------------------+
694:
695: procedure initialization_code
696: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
697: begin
698: IF g_debug THEN
699: hr_utility.set_location('Start of initialization_code',6);
700: END IF;