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_PSD_UPGRADE_PKG dependencies on PAY_US_PSD_UPGRADE_PKG

Line 1: PACKAGE BODY pay_us_psd_upgrade_pkg AS

1: PACKAGE BODY pay_us_psd_upgrade_pkg AS
2: /*$Header: pyuspsdu.pkb 120.4.12020000.3 2012/09/04 05:51:33 pracagra noship $*/
3:
4: /* This function will be used to see if the UPGRADE Process needs to process
5: for the PSDCODE change. It will return 'N' if the change was already

Line 54: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.l_upgrade_needed');

50: l_count NUMBER;
51:
52: BEGIN
53:
54: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.l_upgrade_needed');
55:
56: /*Populate the details only for the first time. This function if passed with NULL values for all
57: parameters indicates if we have any PSDCODEs that need upgrade by giving TRUE or FALSE. If
58: a specific PSDCODE Change details are passed as input, indication will be given if the UPGRADE

Line 120: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.l_upgrade_needed');

116: END IF;
117:
118: hr_utility.trace('Returning '||l_upgrade_needed);
119:
120: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.l_upgrade_needed');
121:
122: RETURN l_upgrade_needed;
123:
124: END upgrade_needed;

Line 143: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.get_pay_patch_status_entry');

139: l_status pay_patch_status.status%TYPE;
140:
141: BEGIN
142:
143: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.get_pay_patch_status_entry');
144:
145: l_mode := p_mode;
146:
147: /*Get the PAY_PATCH_STATUS ID of the Previous Successful execution of

Line 346: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.get_pay_patch_status_entry');

342: /*End of GENARATE Mode*/
343:
344: END IF; /*l_mode IF */
345:
346: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.get_pay_patch_status_entry');
347:
348: RETURN l_id;
349:
350: END get_pay_patch_status_entry;

Line 360: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.create_jsd_element_set');

356: l_element_set_id pay_element_sets.element_set_id%TYPE;
357:
358: BEGIN
359:
360: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.create_jsd_element_set');
361:
362: /*Create the Element set for Elements having Jurisdiction Code as Input Value*/
363:
364: SELECT pay_element_sets_s.nextval

Line 399: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.create_jsd_element_set');

395: AND piv.name = 'Jurisdiction';
396:
397: hr_utility.trace('Created Element Set with Name : US_JSD_ELEMENTS_'||p_pay_patch_status_id||', Element Set ID :'||l_element_set_id);
398:
399: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.create_jsd_element_set');
400:
401: END create_jsd_element_set;
402:
403: PROCEDURE perform_initial_setup(p_payroll_action_id NUMBER) IS

Line 411: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.perform_initial_setup');

407: l_pay_patch_status_id pay_patch_status.id%TYPE;
408:
409: BEGIN
410:
411: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.perform_initial_setup');
412:
413: l_upgrade_needed := upgrade_needed();
414:
415: IF l_upgrade_needed = 'Y' THEN

Line 450: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.perform_initial_setup');

446: fnd_file.put_line(fnd_file.log,'No Processing required');
447:
448: END IF; /*l_upgrade_needed IF*/
449:
450: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.perform_initial_setup');
451:
452: END perform_initial_setup;
453:
454: PROCEDURE generate_assignment(p_assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 504: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

500: substr(pumg.city_name,15,5),
501: state_code||'-'||county_code||'-'||old_city_code
502: FROM pay_us_modified_geocodes pumg
503: WHERE pumg.process_type = 'PA'
504: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
505: pumg.county_code,
506: pumg.old_city_code,
507: pumg.city_name)='Y'
508: ORDER BY pumg.state_code,pumg.county_code,pumg.old_city_code;

Line 516: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg1.state_code,

512: substr(pumg1.city_name,8,6)
513: FROM pay_us_modified_geocodes pumg1,
514: pay_us_modified_geocodes pumg2
515: WHERE pumg1.process_type = 'PA'
516: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg1.state_code,
517: pumg1.county_code,
518: pumg1.old_city_code,
519: pumg1.city_name)='Y'
520: AND pumg2.process_type = 'PA'

Line 521: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg2.state_code,

517: pumg1.county_code,
518: pumg1.old_city_code,
519: pumg1.city_name)='Y'
520: AND pumg2.process_type = 'PA'
521: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg2.state_code,
522: pumg2.county_code,
523: pumg2.old_city_code,
524: pumg2.city_name)='Y'
525: AND pumg1.rowid <> pumg2.rowid

Line 542: hr_utility.trace('Inside pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID :'||p_assignment_id);

538: l_archive_item_id NUMBER; -- Added for bug 14213838.
539:
540: BEGIN
541:
542: hr_utility.trace('Inside pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID :'||p_assignment_id);
543:
544: SELECT person_id
545: INTO l_person_id
546: FROM per_all_assignments_f

Line 585: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

581: AND substr(puar.jurisdiction_code,1,2) = '39'
582: AND (substr(puar.jurisdiction_code,4,6) = substr(pumg.city_name,1,6) or
583: substr(puar.jurisdiction_code,11,6) = substr(pumg.city_name,1,6))
584: AND pumg.process_type = 'PA'
585: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
586: pumg.county_code,
587: pumg.old_city_code,
588: pumg.city_name)='Y';
589:

Line 638: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

634: AND substr(peev.screen_entry_value,1,2) = '39'
635: AND (substr(peev.screen_entry_value,4,6) = substr(pumg.city_name,1,6) or
636: substr(peev.screen_entry_value,11,6) = substr(pumg.city_name,1,6))
637: AND pumg.process_type = 'PA'
638: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
639: pumg.county_code,
640: pumg.old_city_code,
641: pumg.city_name)='Y';
642:

Line 697: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

693: AND pumg.process_type = 'PA'
694: AND pet.element_type_id = piv.element_type_id
695: AND piv.name = 'Jurisdiction'
696: AND pet.element_type_id = prr.element_type_id
697: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
698: pumg.county_code,
699: pumg.old_city_code,
700: pumg.city_name)='Y';
701:

Line 752: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

748: AND pet.legislation_code = 'US'
749: AND pet.element_type_id = piv.element_type_id
750: AND prv.input_value_id = piv.input_value_id
751: AND piv.name = 'Jurisdiction'
752: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
753: pumg.county_code,
754: pumg.old_city_code,
755: pumg.city_name)='Y';
756:

Line 817: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

813: AND substr(pai.jurisdiction_code,1,2) = '39'
814: AND (substr(pai.jurisdiction_code,4,6) = substr(pumg.city_name,1,6) or
815: substr(pai.jurisdiction_code,11,6) = substr(pumg.city_name,1,6))
816: AND pumg.process_type = 'PA'
817: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
818: pumg.county_code,
819: pumg.old_city_code,
820: pumg.city_name)='Y';
821:

Line 885: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

881: AND substr(faic.context,1,2) = '39'
882: AND (substr(faic.context,4,6) = substr(pumg.city_name,1,6) or
883: substr(faic.context,11,6) = substr(pumg.city_name,1,6))
884: AND pumg.process_type = 'PA'
885: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
886: pumg.county_code,
887: pumg.old_city_code,
888: pumg.city_name)='Y';
889: END LOOP; /*Archive Item ID Loop*/

Line 923: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

919: AND pect.jurisdiction_code = pumg.state_code||'-'||pumg.county_code||'-'||pumg.old_city_code
920: AND pugu.description = substr(pumg.city_name,8,6)
921: AND nvl(pect.school_district_code,substr(pumg.city_name,15,5)) <> substr(pumg.city_name,15,5)
922: AND pumg.process_type = 'PA'
923: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
924: pumg.county_code,
925: pumg.old_city_code,
926: pumg.city_name)='Y'
927: AND pcsd.state_code = pumg.state_code

Line 990: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.generate_assignment');

986: /*UPGRADE Mode Ends*/
987:
988: END IF;
989:
990: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.generate_assignment');
991:
992: EXCEPTION
993:
994: WHEN OTHERS THEN

Line 996: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID '||p_assignment_id);

992: EXCEPTION
993:
994: WHEN OTHERS THEN
995:
996: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID '||p_assignment_id);
997: fnd_file.put_line(fnd_file.log,'SQLERRM = ' || SQLERRM);
998: hr_utility.trace('Exception raised in pay_us_psdcode_upgrade_pkg.generate_assignment');
999: hr_utility.trace('SQLERRM = ' || SQLERRM);
1000:

Line 1052: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.upgrade_assignment for '||p_assignment_id);

1048: l_table_order NUMBER;
1049:
1050: BEGIN
1051:
1052: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.upgrade_assignment for '||p_assignment_id);
1053:
1054: OPEN get_emp_upgrade_details(p_id,p_mode,p_date,p_assignment_id);
1055: FETCH get_emp_upgrade_details INTO l_table_name,l_table_value_id,
1056: l_old_jurisdiction_code,l_new_jurisdiction_code,l_table_order;

Line 1149: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.upgrade_assignment');

1145: END IF;
1146:
1147: CLOSE get_emp_upgrade_details;
1148:
1149: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.upgrade_assignment');
1150:
1151: EXCEPTION
1152:
1153: WHEN OTHERS THEN

Line 1163: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.upgrade_assignment for Assignment ID '||p_assignment_id);

1159: AND process_date = p_date
1160: AND process_type = 'PA'
1161: AND assignment_id = p_assignment_id;
1162:
1163: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.upgrade_assignment for Assignment ID '||p_assignment_id);
1164: hr_utility.trace('Exception raised in pay_us_psdcode_upgrade_pkg.upgrade_assignment');
1165: hr_utility.trace('SQLERRM = ' || SQLERRM);
1166: hr_utility.raise_error;
1167:

Line 1182: hr_utility.trace('Entered pay_us_psd_upgrade_pkg.range_cursor');

1178: l_date DATE;
1179:
1180: BEGIN
1181:
1182: hr_utility.trace('Entered pay_us_psd_upgrade_pkg.range_cursor');
1183:
1184: /*Range cursor will be determined based on the necessity for upgrade*/
1185:
1186: hr_utility.trace('Doing Initial Setup');

Line 1218: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

1214: AND pect.state_code = pumg.state_code
1215: AND pect.county_code = pumg.county_code
1216: AND pect.city_code = pumg.old_city_code
1217: AND :pactid IS NOT NULL
1218: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
1219: pumg.county_code,
1220: pumg.old_city_code,
1221: pumg.city_name) = ''Y''
1222: ORDER BY paf.person_id';

Line 1262: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.range_cursor');

1258:
1259: hr_utility.trace('Range Cursor is');
1260: hr_utility.trace(sqlstr);
1261:
1262: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.range_cursor');
1263:
1264: END range_cursor;
1265:
1266: PROCEDURE action_creation (pactid IN NUMBER,

Line 1291: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

1287: AND pumg.old_city_code = ectr.city_code
1288: AND pumg.process_type = 'PA'
1289: AND ectr.assignment_id = paf.assignment_id
1290: AND paf.person_id BETWEEN p_stperson AND p_endperson
1291: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
1292: pumg.county_code,
1293: pumg.old_city_code,
1294: pumg.city_name)='Y';
1295:

Line 1326: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.action_creation');

1322: l_date DATE;
1323:
1324: BEGIN
1325:
1326: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.action_creation');
1327: hr_utility.trace('Action Creation called with below details');
1328: hr_utility.trace('pactid :'||pactid);
1329: hr_utility.trace('stperson :'||stperson);
1330: hr_utility.trace('endperson :'||endperson);

Line 1402: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.action_creation');

1398: END LOOP;
1399:
1400: END IF;
1401:
1402: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.action_creation');
1403:
1404: EXCEPTION
1405:
1406: WHEN OTHERS THEN

Line 1408: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.action_creation');

1404: EXCEPTION
1405:
1406: WHEN OTHERS THEN
1407:
1408: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.action_creation');
1409: fnd_file.put_line(fnd_file.log,sqlerrm);
1410:
1411: END action_creation;
1412:

Line 1442: hr_utility.trace('Inside pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID : '||p_xfr_action_id);

1438: BEGIN
1439:
1440: l_upgrade_needed := upgrade_needed();
1441:
1442: hr_utility.trace('Inside pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID : '||p_xfr_action_id);
1443:
1444: OPEN c_xfr_info (p_xfr_action_id);
1445:
1446: FETCH c_xfr_info into l_payroll_action_id,

Line 1490: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID : '||p_xfr_action_id);

1486: upgrade_assignment(l_object_id,l_id,l_date,l_mode);
1487:
1488: END IF;
1489:
1490: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID : '||p_xfr_action_id);
1491:
1492: EXCEPTION
1493:
1494: WHEN OTHERS THEN

Line 1496: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID '||p_xfr_action_id);

1492: EXCEPTION
1493:
1494: WHEN OTHERS THEN
1495:
1496: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID '||p_xfr_action_id);
1497: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);
1498: hr_utility.raise_error;
1499:
1500: END archive_code;

Line 1580: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.invalidate_run_balances');

1576: l_balance_load_date DATE;
1577:
1578: BEGIN
1579:
1580: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.invalidate_run_balances');
1581:
1582: l_print_business_group_id := -1;
1583:
1584: SELECT id,applied_date

Line 1674: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.invalidate_run_balances');

1670: END LOOP;
1671:
1672: CLOSE get_run_balance_details;
1673:
1674: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.invalidate_run_balances');
1675:
1676: END invalidate_run_balances;
1677:
1678: PROCEDURE deinitialization (p_payroll_action_id IN NUMBER) IS

Line 1751: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.deinitialization');

1747: l_er_psd_entity_id NUMBER;
1748:
1749: BEGIN
1750:
1751: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.deinitialization');
1752:
1753: OPEN c_mode(p_payroll_action_id);
1754: FETCH c_mode into l_mode;
1755: close c_mode;

Line 1812: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

1808: WHERE fai.context1 = l_psd_pact_id
1809: AND fai.user_entity_id = l_er_psd_entity_id
1810: AND fai.value= substr(pumg.city_name,1,6)
1811: AND pumg.process_type = 'PA'
1812: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
1813: pumg.county_code,
1814: pumg.old_city_code,
1815: pumg.city_name)='Y';
1816: END LOOP;

Line 1854: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

1850: WHERE hoi.org_information_context='PSD Reporting Rules'
1851: AND substr(hoi.org_information10,1,6) = substr(pumg.city_name,1,6)
1852: AND pumg.process_type = 'PA'
1853: AND hou.organization_id =hoi.organization_id
1854: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
1855: pumg.county_code,
1856: pumg.old_city_code,
1857: pumg.city_name)='Y';
1858:

Line 1862: pay_us_psd_upgrade_pkg.generate_output(l_mode);

1858:
1859: hr_utility.trace('Done with HR_ORGANIZATION_INFORMATION');
1860:
1861: /*End of HR_ORGANIZATION_INFORMATION Section*/
1862: pay_us_psd_upgrade_pkg.generate_output(l_mode);
1863:
1864: invalidate_run_balances(l_mode);
1865:
1866: DELETE FROM pay_element_type_rules

Line 1957: pay_us_psd_upgrade_pkg.generate_output(l_mode);

1953: FROM pay_temp_object_actions
1954: WHERE payroll_action_id = p_payroll_action_id
1955: AND action_status = 'E');
1956:
1957: pay_us_psd_upgrade_pkg.generate_output(l_mode);
1958:
1959: invalidate_run_balances(l_mode);
1960:
1961: OPEN get_emp_counts(l_id,l_mode,l_date,'ALL');

Line 1995: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

1991: l_mode,
1992: 'C'
1993: FROM pay_us_modified_geocodes pumg
1994: WHERE pumg.process_type = 'PA'
1995: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
1996: pumg.county_code,
1997: pumg.old_city_code,
1998: pumg.city_name)='Y';
1999:

Line 2026: pay_us_psd_upgrade_pkg.generate_output(l_mode);

2022: END IF; /* l_mode IF */
2023:
2024: ELSE
2025:
2026: pay_us_psd_upgrade_pkg.generate_output(l_mode);
2027:
2028: END IF; /* l_upgrade_needed IF*/
2029:
2030: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.deinitialization');

Line 2030: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.deinitialization');

2026: pay_us_psd_upgrade_pkg.generate_output(l_mode);
2027:
2028: END IF; /* l_upgrade_needed IF*/
2029:
2030: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.deinitialization');
2031:
2032: END deinitialization;
2033:
2034: PROCEDURE generate_output(p_mode VARCHAR2) IS

Line 2043: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,

2039: substr(pumg.city_name,15,5),
2040: state_code||'-'||county_code||'-'||old_city_code
2041: FROM pay_us_modified_geocodes pumg
2042: WHERE pumg.process_type = 'PA'
2043: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
2044: pumg.county_code,
2045: pumg.old_city_code,
2046: pumg.city_name)='Y'
2047: ORDER BY state_code,county_code,old_city_code;

Line 2217: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.generate_output');

2213: l_not_process_ff_arch_changes NUMBER;
2214:
2215: BEGIN
2216:
2217: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.generate_output');
2218:
2219: l_upgrade_needed := upgrade_needed();
2220:
2221: fnd_file.put_line(fnd_file.output,'PSDCODE Upgrade Details');

Line 2677: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.generate_output');

2673: fnd_file.put_line(fnd_file.output,'

No Processing required

');
2674:
2675: END IF; /* l_upgrade_needed IF*/
2676:
2677: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.generate_output');
2678:
2679: END generate_output;
2680:
2681: END pay_us_psd_upgrade_pkg;

Line 2681: END pay_us_psd_upgrade_pkg;

2677: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.generate_output');
2678:
2679: END generate_output;
2680:
2681: END pay_us_psd_upgrade_pkg;