APPS.PAY_US_PSD_UPGRADE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1713: WHERE pugu.table_name = 'HR_ORGANIZATION_INFORMATION'

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
1717: AND nvl(pugu.status,'P') <> 'C';

Line 1824: /*Start of HR_ORGANIZATION_INFORMATION Section*/

1820: hr_utility.trace('Done with FF_ARCHIVE_ITEMS');
1821: /*End of FF_ARCHIVE_ITEMS Section*/
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,

Line 1840: ,'HR_ORGANIZATION_INFORMATION'

1836: description)
1837: SELECT DISTINCT l_id
1838: ,hou.organization_id
1839: ,hoi.org_information_id
1840: ,'HR_ORGANIZATION_INFORMATION'
1841: ,hoi.org_information10
1842: ,replace(hoi.org_information10,substr(pumg.city_name,1,6),substr(pumg.city_name,8,6))
1843: ,pumg.process_type
1844: ,l_date

Line 1847: FROM hr_organization_information hoi,

1843: ,pumg.process_type
1844: ,l_date
1845: ,l_mode
1846: ,substr(pumg.city_name,8,6)
1847: FROM hr_organization_information hoi,
1848: hr_organization_units hou,
1849: pay_us_modified_geocodes pumg
1850: WHERE hoi.org_information_context='PSD Reporting Rules'
1851: AND substr(hoi.org_information10,1,6) = substr(pumg.city_name,1,6)

Line 1859: hr_utility.trace('Done with HR_ORGANIZATION_INFORMATION');

1855: pumg.county_code,
1856: pumg.old_city_code,
1857: pumg.city_name)='Y';
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:

Line 1861: /*End of HR_ORGANIZATION_INFORMATION Section*/

1857: pumg.city_name)='Y';
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:

Line 1892: UPDATE hr_organization_information

1888: FETCH get_hr_org_upgrade_details INTO l_table_name,l_table_value_id,
1889: l_old_jurisdiction_code,l_new_jurisdiction_code;
1890: EXIT WHEN get_hr_org_upgrade_details%NOTFOUND;
1891:
1892: UPDATE hr_organization_information
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:

Line 2083: hr_organization_information hoi,

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'
2087: AND pugu.process_mode = p_mode

Line 2123: hr_organization_information hoi,

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'
2127: AND pugu.process_mode = p_mode

Line 2144: AND pugu.table_name not in ('HR_ORGANIZATION_INFORMATION', 'FF_ARCHIVE_ITEMS')

2140: AND pugu.process_type = 'PA'
2141: AND pugu.process_mode = p_mode
2142: AND pugu.process_date = p_date
2143: AND pugu.assignment_id > 0
2144: AND pugu.table_name not in ('HR_ORGANIZATION_INFORMATION', 'FF_ARCHIVE_ITEMS')
2145: AND NVL(pugu.status,'NULL') = DECODE(p_status,'ALL',NVL(pugu.status,'NULL'),p_status));
2146:
2147: -- Added for bug 14213838.
2148: CURSOR get_gre_counts(p_id NUMBER,p_mode VARCHAR2,p_date DATE,p_status VARCHAR2) IS

Line 2157: AND pugu.table_name ='HR_ORGANIZATION_INFORMATION'

2153: AND pugu.process_type = 'PA'
2154: AND pugu.process_mode = p_mode
2155: AND pugu.process_date = p_date
2156: AND pugu.assignment_id > 0
2157: AND pugu.table_name ='HR_ORGANIZATION_INFORMATION'
2158: AND NVL(pugu.status,'NULL') = DECODE(p_status,'ALL',NVL(pugu.status,'NULL'),p_status));
2159:
2160: -- Added for bug 14213838.
2161: CURSOR get_ff_archive_counts(p_id NUMBER,p_mode VARCHAR2,p_date DATE,p_status VARCHAR2) IS

Line 2205: l_hr_organization_information VARCHAR2(10);

2201: l_gre_id NUMBER;
2202: l_print_gre_name hr_organization_units.name%TYPE;
2203: l_print_gre_id NUMBER;
2204: l_ff_archive_item_contexts VARCHAR2(10);
2205: l_hr_organization_information VARCHAR2(10);
2206: l_total_gre_changes NUMBER;
2207: l_success_gre_changes NUMBER;
2208: l_error_gre_changes NUMBER;
2209: l_not_process_gre_changes NUMBER;

Line 2421: fnd_file.put_line(fnd_file.output,'HR_ORGANIZATION_INFORMATIONHOI');

2417:
2418: fnd_file.put_line(fnd_file.output,'

Abbrevation for Table Name

Update Details

Line 2440: l_hr_organization_information :='No';

2436: l_print_gre_name := l_gre_name;
2437: l_print_gre_id := l_gre_id;
2438: l_print_old_juri_code := l_old_jurisdiction_code;
2439: l_print_new_juri_code := l_new_jurisdiction_code;
2440: l_hr_organization_information :='No';
2441:
2442: WHILE (get_gre_update_details%FOUND)
2443: LOOP
2444:

Line 2450: IF l_table_name = 'HR_ORGANIZATION_INFORMATION' THEN

2446: AND (l_print_old_juri_code = l_old_jurisdiction_code) AND (l_print_new_juri_code = l_new_jurisdiction_code) THEN
2447:
2448: /*Same GRE record for another table. Update the corresponing table flag.*/
2449:
2450: IF l_table_name = 'HR_ORGANIZATION_INFORMATION' THEN
2451:
2452: l_hr_organization_information := 'Yes';
2453:
2454: END IF;

Line 2452: l_hr_organization_information := 'Yes';

2448: /*Same GRE record for another table. Update the corresponing table flag.*/
2449:
2450: IF l_table_name = 'HR_ORGANIZATION_INFORMATION' THEN
2451:
2452: l_hr_organization_information := 'Yes';
2453:
2454: END IF;
2455:
2456: ELSE

Line 2461: fnd_file.put_line(fnd_file.output,'

2457:
2458: /*New GRE/New PSD Code so print the existing GRE details first*/
2459:
2460: fnd_file.put_line(fnd_file.output,'

Line 2467: l_hr_organization_information :='No';

2463: l_print_gre_name := l_gre_name;
2464: l_print_gre_id := l_gre_id;
2465: l_print_old_juri_code := l_old_jurisdiction_code;
2466: l_print_new_juri_code := l_new_jurisdiction_code;
2467: l_hr_organization_information :='No';
2468:
2469: IF l_table_name = 'HR_ORGANIZATION_INFORMATION' THEN
2470:
2471: l_hr_organization_information := 'Yes';

Line 2469: IF l_table_name = 'HR_ORGANIZATION_INFORMATION' THEN

2465: l_print_old_juri_code := l_old_jurisdiction_code;
2466: l_print_new_juri_code := l_new_jurisdiction_code;
2467: l_hr_organization_information :='No';
2468:
2469: IF l_table_name = 'HR_ORGANIZATION_INFORMATION' THEN
2470:
2471: l_hr_organization_information := 'Yes';
2472:
2473: END IF;

Line 2471: l_hr_organization_information := 'Yes';

2467: l_hr_organization_information :='No';
2468:
2469: IF l_table_name = 'HR_ORGANIZATION_INFORMATION' THEN
2470:
2471: l_hr_organization_information := 'Yes';
2472:
2473: END IF;
2474:
2475: END IF;

Line 2484: fnd_file.put_line(fnd_file.output,'

2480:
2481: /*No more records exist. Print the last GRE details*/
2482:
2483: fnd_file.put_line(fnd_file.output,'