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_GEO_UPDATE

Line 30: FROM pay_us_geo_update pugu,

26: FROM pay_us_modified_geocodes pumg
27: WHERE process_type = 'PA'
28: AND NOT EXISTS
29: (SELECT NULL
30: FROM pay_us_geo_update pugu,
31: pay_patch_status pps
32: WHERE pugu.process_type = 'PA'
33: AND pugu.process_mode = 'UPGRADE'
34: AND pugu.process_date = pps.applied_date

Line 182: UPDATE pay_us_geo_update

178: UPDATE pay_patch_status
179: SET status = 'P'
180: WHERE id = l_id;
181:
182: UPDATE pay_us_geo_update
183: SET status = 'C'
184: WHERE id = l_id
185: AND process_type = 'PA'
186: AND process_mode = l_mode

Line 190: UPDATE pay_us_geo_update

186: AND process_mode = l_mode
187: AND process_date = l_date
188: AND status = 'P';
189:
190: UPDATE pay_us_geo_update
191: SET status = NULL
192: WHERE id = l_id
193: AND process_type = 'PA'
194: AND process_mode = l_mode

Line 245: UPDATE /+PARALLEL/ pay_us_geo_update

241: (l_id,'1111111',l_patch_name,'UPGRADE',l_status,l_date,'US',l_mode);
242:
243: hr_utility.trace('Created UPGRADE pay_patch_status entry with ID : '||l_id);
244:
245: UPDATE /*+PARALLEL*/ pay_us_geo_update
246: SET id = l_id,
247: process_date = l_date,
248: process_mode = l_mode,
249: status = NULL

Line 306: DELETE FROM pay_us_geo_update

302: /*Delete Data from earlier GENERATE run before starting the current one*/
303:
304: hr_utility.trace('Delete any Data generated earlier before the current one');
305:
306: DELETE FROM pay_us_geo_update
307: WHERE process_type = 'PA'
308: AND process_mode = 'GENERATE'
309: AND id IN
310: (SELECT id

Line 556: INSERT INTO pay_us_geo_update

552: /*GENERATE Mode Ends*/
553:
554: /*Start of PAY_US_ASG_REPORTING Section*/
555:
556: INSERT INTO pay_us_geo_update
557: (id,
558: assignment_id,
559: person_id,
560: table_name,

Line 596: INSERT INTO pay_us_geo_update

592: /*End of PAY_US_ASG_REPORTING Section*/
593:
594: /*Start of PAY_ELEMENT_ENTRY_VALUES_F Section*/
595:
596: INSERT INTO pay_us_geo_update
597: (id,
598: assignment_id,
599: person_id,
600: table_value_id,

Line 661: INSERT INTO pay_us_geo_update

657: LOOP
658:
659: /*Start of PAY_RUN_RESULTS Section*/
660:
661: INSERT INTO pay_us_geo_update
662: (id,
663: assignment_id,
664: person_id,
665: table_value_id,

Line 709: INSERT INTO pay_us_geo_update

705: IF SQL%ROWCOUNT > 0 THEN
706:
707: /*Start of PAY_RUN_RESULT_VALUES Section*/
708:
709: INSERT INTO pay_us_geo_update
710: (id,
711: assignment_id,
712: person_id,
713: table_value_id,

Line 784: INSERT INTO pay_us_geo_update

780: hr_utility.trace('asg id'||p_assignment_id);
781: hr_utility.trace('mode'||p_mode);
782: hr_utility.trace('archive action id'||tab_assignment_action_id(i));
783:
784: INSERT INTO pay_us_geo_update
785: (id,
786: assignment_id,
787: person_id,
788: table_value_id,

Line 854: INSERT INTO pay_us_geo_update

850: LOOP
851: FETCH get_psd_archive_item_id INTO l_archive_item_id;
852: EXIT WHEN get_psd_archive_item_id%NOTFOUND;
853:
854: INSERT INTO pay_us_geo_update
855: (id,
856: assignment_id,
857: person_id,
858: table_value_id,

Line 907: DELETE FROM pay_us_geo_update pugu

903: do any update. So need to delete that assignment updates for that PSD Update. We are doing this
904: check here instead of in the beginning because we do not want to miss any other PSD Code updates
905: for this assignment*/
906:
907: DELETE FROM pay_us_geo_update pugu
908: WHERE pugu.process_type = 'PA'
909: AND pugu.process_mode = p_mode
910: AND pugu.process_date = p_date
911: AND pugu.id = p_id

Line 938: UPDATE pay_us_geo_update

934:
935: WHILE (get_psdcode_details%FOUND)
936: LOOP
937:
938: UPDATE pay_us_geo_update
939: SET new_juri_code = replace(new_juri_code,l_old_psd_code,l_new_psd_code)
940: WHERE process_type = 'PA'
941: AND process_mode = p_mode
942: AND process_date = p_date

Line 960: UPDATE pay_us_geo_update

956:
957: WHILE (get_swap_psdcode_details%FOUND)
958: LOOP
959:
960: UPDATE pay_us_geo_update
961: SET new_juri_code = substr(old_juri_code,1,3)||substr(old_juri_code,11,6)||'-'||substr(old_juri_code,4,6)
962: WHERE process_type = 'PA'
963: AND process_mode = p_mode
964: AND process_date = p_date

Line 1023: FROM pay_us_geo_update pugu

1019: 'PAY_ELEMENT_ENTRY_VALUES_F',3,
1020: 'PAY_RUN_RESULTS',4,
1021: 'PAY_RUN_RESULT_VALUES',5,
1022: 'FF_ARCHVIE_ITEM_CONTEXTS', 6) table_order -- Added for bug 14213838.
1023: FROM pay_us_geo_update pugu
1024: WHERE pugu.id = p_id
1025: AND pugu.process_type = 'PA'
1026: AND pugu.process_mode = p_mode
1027: AND pugu.process_date = p_date

Line 1036: FROM pay_us_geo_update pugu

1032: CURSOR get_emp_counts(p_id NUMBER,p_mode VARCHAR2,p_date DATE,
1033: p_status VARCHAR2) IS
1034: SELECT COUNT(0)
1035: FROM (SELECT DISTINCT assignment_id
1036: FROM pay_us_geo_update pugu
1037: WHERE pugu.id = p_id
1038: AND pugu.process_type = 'PA'
1039: AND pugu.process_mode = p_mode
1040: AND pugu.process_date = p_date

Line 1135: UPDATE pay_us_geo_update

1131: /*End of Bug14082784 Changes */
1132:
1133: /*As we are done with the processing of an assignment, we will update the status to P*/
1134:
1135: UPDATE pay_us_geo_update
1136: SET status = 'P'
1137: WHERE id = p_id
1138: AND process_mode = p_mode
1139: AND process_date = p_date

Line 1155: UPDATE pay_us_geo_update

1151: EXCEPTION
1152:
1153: WHEN OTHERS THEN
1154:
1155: UPDATE pay_us_geo_update
1156: SET status = 'E'
1157: WHERE id = p_id
1158: AND process_mode = p_mode
1159: AND process_date = p_date

Line 1226: /*Under UPGRADE Mode, we already have Assignment changes present in pay_us_geo_update

1222: ORDER BY paf.person_id';
1223:
1224: ELSE
1225:
1226: /*Under UPGRADE Mode, we already have Assignment changes present in pay_us_geo_update
1227: table. So we will use the pay_us_geo_update table as source for Range Cursor*/
1228:
1229: SELECT id,applied_date
1230: INTO l_id,l_date

Line 1227: table. So we will use the pay_us_geo_update table as source for Range Cursor*/

1223:
1224: ELSE
1225:
1226: /*Under UPGRADE Mode, we already have Assignment changes present in pay_us_geo_update
1227: table. So we will use the pay_us_geo_update table as source for Range Cursor*/
1228:
1229: SELECT id,applied_date
1230: INTO l_id,l_date
1231: FROM pay_patch_status

Line 1238: FROM pay_us_geo_update pugu

1234: AND status = 'P'
1235: AND description = l_mode;
1236:
1237: sqlstr := ' SELECT DISTINCT pugu.person_id
1238: FROM pay_us_geo_update pugu
1239: WHERE pugu.id = '||l_id||
1240: ' AND pugu.process_type = ''PA'' '||
1241: 'AND pugu.process_mode = '''||l_mode||''' '||
1242: 'AND pugu.process_date = TO_DATE('''||TO_CHAR(l_date,'DD-MM-YYYY')||''',''DD-MM-YYYY'')'||

Line 1300: p_id pay_us_geo_update.id%TYPE,

1296: CURSOR c_upgrade_assignments
1297: (
1298: p_stperson NUMBER,
1299: p_endperson NUMBER,
1300: p_id pay_us_geo_update.id%TYPE,
1301: p_date DATE,
1302: p_mode pay_us_geo_update.process_mode%TYPE
1303: ) IS
1304: SELECT DISTINCT pugu.assignment_id

Line 1302: p_mode pay_us_geo_update.process_mode%TYPE

1298: p_stperson NUMBER,
1299: p_endperson NUMBER,
1300: p_id pay_us_geo_update.id%TYPE,
1301: p_date DATE,
1302: p_mode pay_us_geo_update.process_mode%TYPE
1303: ) IS
1304: SELECT DISTINCT pugu.assignment_id
1305: FROM pay_us_geo_update pugu,
1306: per_all_assignments_f paf

Line 1305: FROM pay_us_geo_update pugu,

1301: p_date DATE,
1302: p_mode pay_us_geo_update.process_mode%TYPE
1303: ) IS
1304: SELECT DISTINCT pugu.assignment_id
1305: FROM pay_us_geo_update pugu,
1306: per_all_assignments_f paf
1307: WHERE pugu.id = p_id
1308: AND pugu.process_type = 'PA'
1309: AND pugu.process_mode = p_mode

Line 1512: pay_us_geo_update pugu,

1508: pbg.name,
1509: pbv.balance_validation_id
1510: FROM per_business_groups pbg,
1511: per_all_assignments_f paf,
1512: pay_us_geo_update pugu,
1513: pay_balance_types pbt,
1514: pay_defined_balances pdb,
1515: pay_balance_validation pbv
1516: WHERE pugu.id = p_id

Line 1685: FROM pay_us_geo_update pugu

1681:
1682: CURSOR get_emp_counts(p_id NUMBER,p_mode VARCHAR2,p_date DATE,p_status VARCHAR2) IS
1683: SELECT COUNT(0)
1684: FROM (SELECT DISTINCT assignment_id
1685: FROM pay_us_geo_update pugu
1686: WHERE pugu.id = p_id
1687: AND pugu.process_type = 'PA'
1688: AND pugu.process_mode = p_mode
1689: AND pugu.process_date = p_date

Line 1712: FROM pay_us_geo_update pugu

1708: pugu.table_name,
1709: pugu.table_value_id,
1710: pugu.old_juri_code,
1711: pugu.new_juri_code
1712: FROM pay_us_geo_update pugu
1713: WHERE pugu.table_name = 'HR_ORGANIZATION_INFORMATION'
1714: AND pugu.process_type = 'PA'
1715: AND pugu.process_mode = p_mode
1716: AND pugu.process_date = p_date

Line 1726: FROM pay_us_geo_update pugu

1722: pugu.table_name,
1723: pugu.table_value_id,
1724: pugu.old_juri_code,
1725: pugu.new_juri_code
1726: FROM pay_us_geo_update pugu
1727: WHERE pugu.table_name = 'FF_ARCHIVE_ITEMS'
1728: AND pugu.process_type = 'PA'
1729: AND pugu.process_mode = p_mode
1730: AND pugu.process_date = p_date

Line 1785: INSERT INTO pay_us_geo_update

1781: LOOP
1782: FETCH get_psd_pact_id INTO l_psd_pact_id;
1783: EXIT WHEN get_psd_pact_id%NOTFOUND;
1784:
1785: INSERT INTO pay_us_geo_update
1786: (id,
1787: assignment_id,
1788: table_value_id,
1789: table_name,

Line 1826: INSERT INTO pay_us_geo_update

1822:
1823: -- Added for bug 14213838.
1824: /*Start of HR_ORGANIZATION_INFORMATION Section*/
1825:
1826: INSERT INTO pay_us_geo_update
1827: (id,
1828: assignment_id,
1829: table_value_id,
1830: table_name,

Line 1897: UPDATE pay_us_geo_update

1893: SET org_information10 = l_new_jurisdiction_code
1894: WHERE org_information_id = l_table_value_id
1895: AND org_information10 = l_old_jurisdiction_code;
1896:
1897: UPDATE pay_us_geo_update
1898: SET status = 'P'
1899: WHERE id = l_id
1900: AND process_mode = l_mode
1901: AND process_date = l_date

Line 1923: UPDATE pay_us_geo_update

1919: SET value = l_new_jurisdiction_code
1920: WHERE archive_item_id = l_table_value_id
1921: AND value = l_old_jurisdiction_code;
1922:
1923: UPDATE pay_us_geo_update
1924: SET status = 'P'
1925: WHERE id = l_id
1926: AND process_mode = l_mode
1927: AND process_date = l_date

Line 1937: UPDATE pay_us_geo_update

1933: END LOOP;
1934:
1935: CLOSE get_ff_archive_upgrade_details;
1936:
1937: UPDATE pay_us_geo_update
1938: SET status = 'C'
1939: WHERE id = l_id
1940: AND process_type = 'PA'
1941: AND process_mode = l_mode

Line 1945: UPDATE pay_us_geo_update

1941: AND process_mode = l_mode
1942: AND process_date = l_date
1943: AND status = 'P';
1944:
1945: UPDATE pay_us_geo_update
1946: SET status = 'E'
1947: WHERE id = l_id
1948: AND process_type = 'PA'
1949: AND process_mode = l_mode

Line 1976: INSERT INTO pay_us_geo_update

1972:
1973: IF l_total_assignments = l_success_assignments
1974: AND l_error_assignments = 0 THEN
1975:
1976: INSERT INTO pay_us_geo_update
1977: (id,
1978: assignment_id,
1979: old_juri_code,
1980: new_juri_code,

Line 2056: FROM pay_us_geo_update pugu,

2052: pugu.assignment_id,
2053: pugu.old_juri_code,
2054: pugu.new_juri_code,
2055: pugu.table_name
2056: FROM pay_us_geo_update pugu,
2057: per_all_people_f ppf
2058: WHERE pugu.id = p_id
2059: AND pugu.process_type = 'PA'
2060: AND pugu.process_mode = p_mode

Line 2082: FROM pay_us_geo_update pugu,

2078: hou.organization_id,
2079: substr(pugu.old_juri_code,1,6),
2080: substr(pugu.new_juri_code,1,6),
2081: pugu.table_name
2082: FROM pay_us_geo_update pugu,
2083: hr_organization_information hoi,
2084: hr_organization_units hou
2085: WHERE pugu.id = p_id
2086: AND pugu.process_type = 'PA'

Line 2100: FROM pay_us_geo_update pugu,

2096: CURSOR get_emp_in_error(p_id NUMBER,p_mode VARCHAR2,p_date DATE) IS
2097: SELECT DISTINCT
2098: substr(ppf.full_name,1,100),
2099: pugu.assignment_id
2100: FROM pay_us_geo_update pugu,
2101: per_all_people_f ppf
2102: WHERE pugu.id = p_id
2103: AND pugu.process_type = 'PA'
2104: AND pugu.process_mode = p_mode

Line 2122: FROM pay_us_geo_update pugu,

2118: CURSOR get_gre_in_error(p_id NUMBER,p_mode VARCHAR2,p_date DATE) IS
2119: SELECT DISTINCT
2120: substr(hou.name,1,100),
2121: hou.organization_id
2122: FROM pay_us_geo_update pugu,
2123: hr_organization_information hoi,
2124: hr_organization_units hou
2125: WHERE pugu.id = p_id
2126: AND pugu.process_type = 'PA'

Line 2138: FROM pay_us_geo_update pugu

2134:
2135: CURSOR get_emp_counts(p_id NUMBER,p_mode VARCHAR2,p_date DATE,p_status VARCHAR2) IS
2136: SELECT COUNT(0)
2137: FROM (SELECT DISTINCT assignment_id
2138: FROM pay_us_geo_update pugu
2139: WHERE pugu.id = p_id
2140: AND pugu.process_type = 'PA'
2141: AND pugu.process_mode = p_mode
2142: AND pugu.process_date = p_date

Line 2151: FROM pay_us_geo_update pugu

2147: -- Added for bug 14213838.
2148: CURSOR get_gre_counts(p_id NUMBER,p_mode VARCHAR2,p_date DATE,p_status VARCHAR2) IS
2149: SELECT COUNT(0)
2150: FROM (SELECT DISTINCT assignment_id
2151: FROM pay_us_geo_update pugu
2152: WHERE pugu.id = p_id
2153: AND pugu.process_type = 'PA'
2154: AND pugu.process_mode = p_mode
2155: AND pugu.process_date = p_date

Line 2164: FROM pay_us_geo_update pugu

2160: -- Added for bug 14213838.
2161: CURSOR get_ff_archive_counts(p_id NUMBER,p_mode VARCHAR2,p_date DATE,p_status VARCHAR2) IS
2162: SELECT COUNT(0)
2163: FROM (SELECT DISTINCT table_value_id
2164: FROM pay_us_geo_update pugu
2165: WHERE pugu.id = p_id
2166: AND pugu.process_type = 'PA'
2167: AND pugu.process_mode = p_mode
2168: AND pugu.process_date = p_date