APPS.PAY_US_GEO_UPD_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 907: --Retrieve all affected rows in the ff_archive_item_contexts table.

903: pac_rec pac_cur%ROWTYPE;
904:
905:
906:
907: --Retrieve all affected rows in the ff_archive_item_contexts table.
908: --This cursor will check for a specific geocode that is passed in.
909: --The passed in geocode will be the old one from pay_us_modified_geocodes.
910: --We are joining with the archive item id, so we don't need this logic
911: --in the procedure archive_items.

Line 917: ff_archive_item_contexts faic,

913: /* CURSOR fac_cur(assign_id NUMBER, geocode VARCHAR2) IS
914: SELECT distinct paa.assignment_action_id,
915: faic.context old_juri_code, faic.archive_item_id, ffc.context_id
916: FROM ff_archive_items fai,
917: ff_archive_item_contexts faic,
918: pay_assignment_actions paa,
919: pay_payroll_actions ppa,
920: ff_contexts ffc
921: WHERE ppa.report_type = 'YREND'

Line 935: and pugu.table_name = 'FF_ARCHIVE_ITEM_CONTEXTS'

931: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
932: where pugu.assignment_id = assign_id
933: and pugu.table_value_id = faic.archive_item_id
934: and pugu.old_juri_code = faic.context
935: and pugu.table_name = 'FF_ARCHIVE_ITEM_CONTEXTS'
936: and pugu.process_mode = g_mode
937: and pugu.process_type = g_process_type
938: and pugu.id = g_geo_phase_id);
939: */

Line 948: ff_archive_item_contexts faic,

944: faic.context old_juri_code,
945: faic.archive_item_id,
946: ffc.context_id
947: FROM ff_archive_items fai,
948: ff_archive_item_contexts faic,
949: pay_assignment_actions paa,
950: pay_payroll_actions ppa,
951: ff_contexts ffc
952: WHERE ppa.report_type in ('T4', 'T4A', 'RL1', 'RL2', 'YREND')

Line 966: and pugu.table_name = 'FF_ARCHIVE_ITEM_CONTEXTS'

962: and not exists (select 'Y' from PAY_US_GEO_UPDATE pugu
963: where pugu.assignment_id = assign_id
964: and pugu.table_value_id = faic.archive_item_id
965: and pugu.old_juri_code = faic.context
966: and pugu.table_name = 'FF_ARCHIVE_ITEM_CONTEXTS'
967: and pugu.process_mode = g_mode
968: and pugu.process_type = g_process_type
969: and pugu.id = g_geo_phase_id);
970: fac_rec fac_cur%ROWTYPE;

Line 1802: UPDATE ff_archive_item_contexts ffaic

1798: hr_utility.trace('Before update of archive item contexts for assignment_id: '||to_char(p_assign_id));
1799:
1800: IF G_MODE = 'UPGRADE' THEN
1801:
1802: UPDATE ff_archive_item_contexts ffaic
1803: SET ffaic.context = p_new_juri_code
1804: WHERE ffaic.context = p_old_juri_code
1805: AND ffaic.context_id = p_context_id
1806: AND ffaic.archive_item_id = p_archive_item_id;

Line 1820: p_location => 'FF_ARCHIVE_ITEM_CONTEXTS',

1816: p_person_id => p_person_id,
1817: p_assign_id => p_assign_id,
1818: p_old_juri_code => p_old_juri_code,
1819: p_new_juri_code => p_new_juri_code,
1820: p_location => 'FF_ARCHIVE_ITEM_CONTEXTS',
1821: p_id => p_archive_item_id);
1822:
1823:
1824: ELSE

Line 1834: p_location => 'FF_ARCHIVE_ITEM_CONTEXTS',

1830: p_person_id => p_person_id,
1831: p_assign_id => p_assign_id,
1832: p_old_juri_code => p_old_juri_code,
1833: p_new_juri_code => p_new_juri_code,
1834: p_location => 'FF_ARCHIVE_ITEM_CONTEXTS',
1835: p_id => p_archive_item_id);
1836:
1837: END IF;
1838:

Line 2809: -- Update ff archive item contexts

2805:
2806: --
2807: --
2808:
2809: -- Update ff archive item contexts
2810:
2811:
2812: OPEN fac_cur(main_assign_id, main_old_juri_code);
2813: LOOP