APPS.PAY_US_GEO_UPD_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

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

1112: pac_rec pac_cur%ROWTYPE;
1113:
1114:
1115:
1116: --Retrieve all affected rows in the ff_archive_item_contexts table.
1117: --This cursor will check for a specific geocode that is passed in.
1118: --The passed in geocode will be the old one from pay_us_modified_geocodes.
1119: --We are joining with the archive item id, so we don't need this logic
1120: --in the procedure archive_items.

Line 1126: ff_archive_item_contexts faic,

1122: /* CURSOR fac_cur(assign_id NUMBER, geocode VARCHAR2) IS
1123: SELECT distinct paa.assignment_action_id,
1124: faic.context old_juri_code, faic.archive_item_id, ffc.context_id
1125: FROM ff_archive_items fai,
1126: ff_archive_item_contexts faic,
1127: pay_assignment_actions paa,
1128: pay_payroll_actions ppa,
1129: ff_contexts ffc
1130: WHERE ppa.report_type = 'YREND'

Line 1144: and pugu.table_name = 'FF_ARCHIVE_ITEM_CONTEXTS'

1140: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1141: where pugu.assignment_id = assign_id
1142: and pugu.table_value_id = faic.archive_item_id
1143: and pugu.old_juri_code = faic.context
1144: and pugu.table_name = 'FF_ARCHIVE_ITEM_CONTEXTS'
1145: and pugu.process_mode = g_mode
1146: and pugu.process_type = g_process_type
1147: and pugu.id = g_geo_phase_id);
1148: */

Line 1157: ff_archive_item_contexts faic,

1153: faic.context old_juri_code,
1154: faic.archive_item_id,
1155: ffc.context_id
1156: FROM ff_archive_items fai,
1157: ff_archive_item_contexts faic,
1158: pay_assignment_actions paa,
1159: pay_payroll_actions ppa,
1160: ff_contexts ffc
1161: WHERE ppa.report_type in ('T4', 'T4A', 'RL1', 'RL2', 'YREND')

Line 1175: and pugu.table_name = 'FF_ARCHIVE_ITEM_CONTEXTS'

1171: and not exists (select 'Y' from PAY_US_GEO_UPDATE pugu
1172: where pugu.assignment_id = assign_id
1173: and pugu.table_value_id = faic.archive_item_id
1174: and pugu.old_juri_code = faic.context
1175: and pugu.table_name = 'FF_ARCHIVE_ITEM_CONTEXTS'
1176: and pugu.process_mode = g_mode
1177: and pugu.process_type = g_process_type
1178: and pugu.id = g_geo_phase_id);
1179: fac_rec fac_cur%ROWTYPE;

Line 2092: UPDATE ff_archive_item_contexts ffaic

2088: hr_utility.trace('Before update of archive item contexts for assignment_id: '||to_char(p_assign_id));
2089:
2090: IF G_MODE = 'UPGRADE' THEN
2091:
2092: UPDATE ff_archive_item_contexts ffaic
2093: SET ffaic.context = p_new_juri_code
2094: WHERE ffaic.context = p_old_juri_code
2095: AND ffaic.context_id = p_context_id
2096: AND ffaic.archive_item_id = p_archive_item_id;

Line 2110: p_location => 'FF_ARCHIVE_ITEM_CONTEXTS',

2106: p_person_id => p_person_id,
2107: p_assign_id => p_assign_id,
2108: p_old_juri_code => p_old_juri_code,
2109: p_new_juri_code => p_new_juri_code,
2110: p_location => 'FF_ARCHIVE_ITEM_CONTEXTS',
2111: p_id => p_archive_item_id);
2112:
2113:
2114: ELSE

Line 2124: p_location => 'FF_ARCHIVE_ITEM_CONTEXTS',

2120: p_person_id => p_person_id,
2121: p_assign_id => p_assign_id,
2122: p_old_juri_code => p_old_juri_code,
2123: p_new_juri_code => p_new_juri_code,
2124: p_location => 'FF_ARCHIVE_ITEM_CONTEXTS',
2125: p_id => p_archive_item_id);
2126:
2127: END IF;
2128:

Line 3102: -- Update ff archive item contexts

3098:
3099: --
3100: --
3101:
3102: -- Update ff archive item contexts
3103:
3104:
3105: OPEN fac_cur(main_assign_id, main_old_juri_code);
3106: LOOP