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_US_USER_CITY_UPGRADE_PKG dependencies on PAY_PATCH_STATUS

Line 10: l_id pay_patch_status.id%TYPE;

6: --
7: --
8: l_count NUMBER;
9: l_upgrade_needed VARCHAR2(2);
10: l_id pay_patch_status.id%TYPE;
11: l_patch_name pay_patch_status.patch_name%TYPE;
12: l_applied_date DATE;
13: l_mode VARCHAR2(8);
14:

Line 11: l_patch_name pay_patch_status.patch_name%TYPE;

7: --
8: l_count NUMBER;
9: l_upgrade_needed VARCHAR2(2);
10: l_id pay_patch_status.id%TYPE;
11: l_patch_name pay_patch_status.patch_name%TYPE;
12: l_applied_date DATE;
13: l_mode VARCHAR2(8);
14:
15: BEGIN

Line 28: pay_patch_status pps

24:
25: SELECT DECODE(count(0),0,'N','Y')
26: INTO l_upgrade_needed
27: FROM pay_us_geo_update pugu,
28: pay_patch_status pps
29: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
30: AND pps.phase = 'TO_BE_UPDATED'
31: AND pps.process_type = 'USER_CITY_UPGRADE'
32: AND pps.legislation_code = 'US'

Line 57: SELECT pay_patch_status_s.NEXTVAL

53: INTO l_mode
54: FROM pay_payroll_actions ppa
55: WHERE ppa.payroll_action_id = pactid;
56:
57: SELECT pay_patch_status_s.NEXTVAL
58: INTO l_id FROM dual;
59:
60: l_applied_date := trunc(sysdate);
61:

Line 64: INSERT INTO pay_patch_status

60: l_applied_date := trunc(sysdate);
61:
62: l_patch_name := 'USER_CITY_UPGRADE_'||TO_CHAR(sysdate,'DDMONYYYY');
63:
64: INSERT INTO pay_patch_status
65: (id,
66: patch_number,
67: patch_name,
68: phase,

Line 104: pay_patch_status pps

100: 'D',
101: l_patch_name,
102: NULL
103: FROM pay_us_geo_update pugu,
104: pay_patch_status pps
105: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
106: AND pps.phase = 'TO_BE_UPDATED'
107: AND pps.process_type = 'USER_CITY_UPGRADE'
108: AND pps.legislation_code = 'US'

Line 124: hr_utility.trace('Created PAY_PATCH_STATUS Entry with ID :'||l_id);

120: AND pumg.old_city_code = substr(pugu.old_juri_code,8,4)
121: AND pumg.process_type = 'D'
122: AND pumg.patch_name = l_patch_name);
123:
124: hr_utility.trace('Created PAY_PATCH_STATUS Entry with ID :'||l_id);
125: fnd_file.put_line(fnd_file.log,'Created PAY_PATCH_STATUS Entry with ID :'||l_id);
126:
127: sqlstr := ' SELECT DISTINCT paf.person_id
128: FROM per_all_assignments_f paf,

Line 125: fnd_file.put_line(fnd_file.log,'Created PAY_PATCH_STATUS Entry with ID :'||l_id);

121: AND pumg.process_type = 'D'
122: AND pumg.patch_name = l_patch_name);
123:
124: hr_utility.trace('Created PAY_PATCH_STATUS Entry with ID :'||l_id);
125: fnd_file.put_line(fnd_file.log,'Created PAY_PATCH_STATUS Entry with ID :'||l_id);
126:
127: sqlstr := ' SELECT DISTINCT paf.person_id
128: FROM per_all_assignments_f paf,
129: pay_us_emp_city_tax_rules_f pect,

Line 131: pay_patch_status pps

127: sqlstr := ' SELECT DISTINCT paf.person_id
128: FROM per_all_assignments_f paf,
129: pay_us_emp_city_tax_rules_f pect,
130: pay_us_geo_update pugu,
131: pay_patch_status pps
132: WHERE pect.assignment_id = paf.assignment_id
133: AND substr(pugu.old_juri_code,1,2) = pect.state_code
134: AND substr(pugu.old_juri_code,4,3) = pect.county_code
135: AND substr(pugu.old_juri_code,8,4) = pect.city_code

Line 191: pay_patch_status pps

187: SELECT DISTINCT ectr.assignment_id
188: FROM per_all_assignments_f paf,
189: pay_us_emp_city_tax_rules_f ectr,
190: pay_us_geo_update pugu,
191: pay_patch_status pps
192: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
193: AND pps.phase = 'TO_BE_UPDATED'
194: AND pps.process_type = 'USER_CITY_UPGRADE'
195: AND pps.legislation_code = 'US'

Line 269: FROM pay_patch_status pps

265: WHERE paa.object_action_id = p_assignment_action_id;
266:
267: CURSOR c_patch_details(p_mode VARCHAR2) IS
268: SELECT pps.id,pps.patch_name
269: FROM pay_patch_status pps
270: WHERE pps.patch_name LIKE 'USER_CITY_UPGRADE%'
271: AND pps.legislation_code = 'US'
272: AND pps.status = 'P'
273: AND pps.description = p_mode

Line 276: FROM pay_patch_status pps1

272: AND pps.status = 'P'
273: AND pps.description = p_mode
274: AND NOT EXISTS
275: (SELECT NULL
276: FROM pay_patch_status pps1
277: WHERE pps1.id > pps.id
278: AND pps1.patch_name LIKE 'USER_CITY_UPGRADE%'
279: AND pps.legislation_code = 'US')
280: ORDER BY pps.id DESC;

Line 290: l_id pay_patch_status.id%TYPE;

286:
287: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
288: l_assignment_id pay_assignment_actions.object_id%TYPE;
289: l_mode VARCHAR2(8);
290: l_id pay_patch_status.id%TYPE;
291: l_patch_name pay_patch_status.patch_name%TYPE;
292:
293: BEGIN
294:

Line 291: l_patch_name pay_patch_status.patch_name%TYPE;

287: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
288: l_assignment_id pay_assignment_actions.object_id%TYPE;
289: l_mode VARCHAR2(8);
290: l_id pay_patch_status.id%TYPE;
291: l_patch_name pay_patch_status.patch_name%TYPE;
292:
293: BEGIN
294:
295: hr_utility.trace('Inside pay_us_user_city_upgrade_pkg.archive_code');

Line 359: pay_patch_status pps

355: pugu.new_juri_code,
356: substr(pugu.description,3) city_name,
357: substr(pugu.description,1,1) primary_flag
358: FROM pay_us_geo_update pugu,
359: pay_patch_status pps
360: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
361: AND pps.phase = 'TO_BE_UPDATED'
362: AND pps.process_type = 'USER_CITY_UPGRADE'
363: AND pps.legislation_code = 'US'

Line 371: l_id pay_patch_status.id%TYPE;

367: AND pugu.process_mode = pps.phase;
368:
369: l_upgrade_needed VARCHAR2(2);
370: l_mode VARCHAR2(8);
371: l_id pay_patch_status.id%TYPE;
372: l_process_type pay_us_geo_update.process_type%TYPE;
373: l_applied_date DATE;
374: l_total_assignments NUMBER;
375: l_success_assignments NUMBER;

Line 398: pay_patch_status pps

394:
395: SELECT DECODE(count(0),0,'N','Y')
396: INTO l_upgrade_needed
397: FROM pay_us_geo_update pugu,
398: pay_patch_status pps
399: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
400: AND pps.phase = 'TO_BE_UPDATED'
401: AND pps.process_type = 'USER_CITY_UPGRADE'
402: AND pps.legislation_code = 'US'

Line 412: FROM pay_patch_status pps

408: IF l_upgrade_needed = 'Y' THEN
409:
410: SELECT id,applied_date
411: INTO l_id,l_applied_date
412: FROM pay_patch_status pps
413: WHERE pps.patch_name LIKE 'USER_CITY_UPGRADE%'
414: AND pps.legislation_code = 'US'
415: AND pps.status = 'P'
416: AND pps.description = l_mode

Line 419: FROM pay_patch_status pps1

415: AND pps.status = 'P'
416: AND pps.description = l_mode
417: AND NOT EXISTS
418: (SELECT NULL
419: FROM pay_patch_status pps1
420: WHERE pps1.id > pps.id
421: AND pps1.patch_name LIKE 'USER_CITY_UPGRADE%'
422: AND pps1.legislation_code = 'US');
423:

Line 428: UPDATE pay_patch_status

424: IF l_mode = 'DEBUG' THEN
425:
426: pay_us_user_city_upgrade_pkg.generate_output(l_mode,l_upgrade_needed);
427:
428: UPDATE pay_patch_status
429: SET status = 'C'
430: WHERE legislation_code = 'US'
431: AND id = l_id
432: AND status = 'P'

Line 461: pay_patch_status pps

457: INTO l_assignments_to_be_updated
458: FROM per_all_assignments_f paf,
459: pay_us_emp_city_tax_rules_f pect,
460: pay_us_geo_update pugu,
461: pay_patch_status pps
462: WHERE pect.assignment_id = paf.assignment_id
463: AND substr(pugu.old_juri_code,1,2) = pect.state_code
464: AND substr(pugu.old_juri_code,4,3) = pect.county_code
465: AND substr(pugu.old_juri_code,8,4) = pect.city_code

Line 578: FROM pay_patch_status pps

574: UPDATE pay_us_geo_update pugu
575: SET process_mode = 'UPDATED'
576: WHERE EXISTS
577: (SELECT NULL
578: FROM pay_patch_status pps
579: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
580: AND pps.phase = 'TO_BE_UPDATED'
581: AND pps.process_type = 'USER_CITY_UPGRADE'
582: AND pps.legislation_code = 'US'

Line 588: UPDATE pay_patch_status pps

584: AND pugu.process_date = pps.applied_date
585: AND pugu.process_type = pps.process_type
586: AND pugu.process_mode = pps.phase);
587:
588: UPDATE pay_patch_status pps
589: SET phase = 'UPDATED'
590: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
591: AND pps.phase = 'TO_BE_UPDATED'
592: AND pps.process_type = 'USER_CITY_UPGRADE'

Line 595: UPDATE pay_patch_status

591: AND pps.phase = 'TO_BE_UPDATED'
592: AND pps.process_type = 'USER_CITY_UPGRADE'
593: AND pps.legislation_code = 'US';
594:
595: UPDATE pay_patch_status
596: SET status = 'C'
597: WHERE legislation_code = 'US'
598: AND id = l_id
599: AND status = 'P'

Line 604: UPDATE pay_patch_status

600: AND description = l_mode;
601:
602: ELSE
603:
604: UPDATE pay_patch_status
605: SET status = 'E'
606: WHERE legislation_code = 'US'
607: AND id = l_id
608: AND status = 'P'

Line 647: pay_patch_status pps,

643: substr(pugu.description,3) city_name,
644: pugu.old_juri_code,
645: pugu.new_juri_code
646: FROM pay_us_geo_update pugu,
647: pay_patch_status pps,
648: pay_us_states pus,
649: pay_us_counties puc
650: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
651: AND pps.phase = 'TO_BE_UPDATED'

Line 759: l_id pay_patch_status.id%TYPE;

755: AND pugu.table_value_id is null
756: AND DECODE(pugu.status,'C','C','E')
757: = DECODE(p_status,'ALL',DECODE(pugu.status,'C','C','E'),p_status));
758:
759: l_id pay_patch_status.id%TYPE;
760: l_applied_date DATE;
761: l_state_name pay_us_states.state_name%TYPE;
762: l_state_abbrev pay_us_states.state_abbrev%TYPE;
763: l_county_name pay_us_counties.county_name%TYPE;

Line 789: FROM pay_patch_status pps

785: IF p_upgrade_needed = 'Y' THEN
786:
787: SELECT id,applied_date
788: INTO l_id,l_applied_date
789: FROM pay_patch_status pps
790: WHERE pps.patch_name LIKE 'USER_CITY_UPGRADE%'
791: AND pps.legislation_code = 'US'
792: AND pps.status = 'P'
793: AND pps.description = p_mode

Line 796: FROM pay_patch_status pps1

792: AND pps.status = 'P'
793: AND pps.description = p_mode
794: AND NOT EXISTS
795: (SELECT NULL
796: FROM pay_patch_status pps1
797: WHERE pps1.id > pps.id
798: AND pps1.patch_name LIKE 'USER_CITY_UPGRADE%'
799: AND pps1.legislation_code = 'US');
800: