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 FF_ARCHIVE_ITEMS

Line 494: FROM ff_archive_items fai

490:
491: -- Added for bug 14213838.
492: CURSOR get_psd_archive_item_id(l_assignment_action_id NUMBER) IS
493: SELECT fai.archive_item_id
494: FROM ff_archive_items fai
495: WHERE fai.context1=l_assignment_action_id;
496:
497: CURSOR get_psdcode_details IS
498: SELECT substr(pumg.city_name,1,6),

Line 896: hr_utility.trace('Done with ff_archive_items_contexts');

892: END IF; /* tab_assignment_action_id.COUNT IF */
893:
894: CLOSE get_psd_archive_asg_actions;
895:
896: hr_utility.trace('Done with ff_archive_items_contexts');
897:
898: /*End of FF_ARCHIVE_ITEM_CONTEXTS Section*/
899:
900: /*Check if the assignment is attached to Jurisdiction Code which has multiple school districts

Line 1727: WHERE pugu.table_name = 'FF_ARCHIVE_ITEMS'

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

Line 1773: /Start of FF_ARCHIVE_ITEMS Section/

1769: IF l_mode = 'GENERATE' THEN
1770:
1771: -- Added for bug 14213838.
1772:
1773: /*Start of FF_ARCHIVE_ITEMS Section*/
1774:
1775: SELECT user_entity_id
1776: INTO l_er_psd_entity_id
1777: FROM ff_user_entities

Line 1799: ,'FF_ARCHIVE_ITEMS'

1795: description)
1796: SELECT DISTINCT l_id
1797: ,l_psd_pact_id
1798: ,fai.archive_item_id
1799: ,'FF_ARCHIVE_ITEMS'
1800: ,fai.value
1801: ,replace(fai.value,substr(pumg.city_name,1,6),substr(pumg.city_name,8,6))
1802: ,pumg.process_type
1803: ,l_date

Line 1806: FROM ff_archive_items fai,

1802: ,pumg.process_type
1803: ,l_date
1804: ,l_mode
1805: ,substr(pumg.city_name,8,6)
1806: FROM ff_archive_items fai,
1807: pay_us_modified_geocodes pumg
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)

Line 1820: hr_utility.trace('Done with FF_ARCHIVE_ITEMS');

1816: END LOOP;
1817:
1818: CLOSE get_psd_pact_id;
1819:
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*/

Line 1821: /End of FF_ARCHIVE_ITEMS Section/

1817:
1818: CLOSE get_psd_pact_id;
1819:
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:

Line 1918: UPDATE ff_archive_items

1914: FETCH get_ff_archive_upgrade_details INTO l_table_name,l_table_value_id,
1915: l_old_jurisdiction_code,l_new_jurisdiction_code;
1916: EXIT WHEN get_ff_archive_upgrade_details%NOTFOUND;
1917:
1918: UPDATE ff_archive_items
1919: SET value = l_new_jurisdiction_code
1920: WHERE archive_item_id = l_table_value_id
1921: AND value = l_old_jurisdiction_code;
1922:

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 2170: AND pugu.table_name ='FF_ARCHIVE_ITEMS'

2166: AND pugu.process_type = 'PA'
2167: AND pugu.process_mode = p_mode
2168: AND pugu.process_date = p_date
2169: AND pugu.assignment_id > 0
2170: AND pugu.table_name ='FF_ARCHIVE_ITEMS'
2171: AND NVL(pugu.status,'NULL') = DECODE(p_status,'ALL',NVL(pugu.status,'NULL'),p_status));
2172:
2173: l_upgrade_needed VARCHAR2(2);
2174: l_id pay_patch_status.id%TYPE;

Line 2648: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table has been successfully updated
');

2644: and l_total_gre_changes = l_success_gre_changes
2645: and l_total_ff_arch_changes = l_success_ff_arch_changes) THEN
2646:
2647: IF(l_total_ff_arch_changes<>0) THEN
2648: fnd_file.put_line(fnd_file.output,'

Employer PSD Codes related data in FF_ARCHIVE_ITEMS table has been successfully updated

');
2649: END IF;
2650:
2651: fnd_file.put_line(fnd_file.output,'

Upgrade Process completed successfully

');
2652:

Line 2655: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table not updated successfully
');

2651: fnd_file.put_line(fnd_file.output,'

Upgrade Process completed successfully

');
2652:
2653: ELSE
2654: IF(l_error_ff_arch_changes<>0) THEN
2655: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table not updated successfully
');
2656: END IF;
2657:
2658: fnd_file.put_line(fnd_file.output,'

Upgrade Process incomplete.Verify assignments/GREs in error and rerun the Upgrade process

');
2659: