APPS.PAY_US_PSD_UPGRADE_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 870: ,'FF_ARCHIVE_ITEM_CONTEXTS'

866: SELECT DISTINCT p_id
867: ,p_assignment_id
868: ,l_person_id
869: ,faic.archive_item_id
870: ,'FF_ARCHIVE_ITEM_CONTEXTS'
871: ,faic.context
872: ,replace(faic.context,substr(pumg.city_name,1,6),substr(pumg.city_name,8,6))
873: ,pumg.process_type
874: ,p_date

Line 877: FROM ff_archive_item_contexts faic,

873: ,pumg.process_type
874: ,p_date
875: ,p_mode
876: ,substr(pumg.city_name,8,6)
877: FROM ff_archive_item_contexts faic,
878: pay_us_modified_geocodes pumg
879: WHERE faic.archive_item_id = l_archive_item_id
880: AND length(faic.context) = 16
881: AND substr(faic.context,1,2) = '39'

Line 898: /*End of FF_ARCHIVE_ITEM_CONTEXTS Section*/

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
901: with same PSD Code. In that case need to see if the Assignment is attached to the school
902: district that had PSD Code change or not. If the school district is different then no need to

Line 1099: ELSIF l_table_name = 'FF_ARCHIVE_ITEM_CONTEXTS' THEN

1095: AND action_information_category = 'US PSD'
1096: AND jurisdiction_code = l_old_jurisdiction_code;
1097:
1098: -- Added for bug 14213838.
1099: ELSIF l_table_name = 'FF_ARCHIVE_ITEM_CONTEXTS' THEN
1100:
1101: UPDATE ff_archive_item_contexts
1102: SET context = l_new_jurisdiction_code
1103: WHERE archive_item_id = l_table_value_id

Line 1101: UPDATE ff_archive_item_contexts

1097:
1098: -- Added for bug 14213838.
1099: ELSIF l_table_name = 'FF_ARCHIVE_ITEM_CONTEXTS' THEN
1100:
1101: UPDATE ff_archive_item_contexts
1102: SET context = l_new_jurisdiction_code
1103: WHERE archive_item_id = l_table_value_id
1104: AND context = l_old_jurisdiction_code;
1105:

Line 2204: l_ff_archive_item_contexts VARCHAR2(10);

2200: l_gre_name hr_organization_units.name%TYPE;
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;

Line 2275: fnd_file.put_line(fnd_file.output,'FF_ARCHIVE_ITEM_CONTEXTSFAIC'); -- Added for bug 14213838.

2271: fnd_file.put_line(fnd_file.output,'PAY_ELEMENT_ENTRY_VALUES_FPEEV');
2272: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULTSPRR');
2273: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULT_VALUESPRRV');
2274: fnd_file.put_line(fnd_file.output,'PAY_ACTION_INFORMATIONPAI');
2275: fnd_file.put_line(fnd_file.output,'FF_ARCHIVE_ITEM_CONTEXTSFAIC'); -- Added for bug 14213838.
2276: fnd_file.put_line(fnd_file.output,'');
2277:
2278: fnd_file.put_line(fnd_file.output,'

Update Details

Line 2304: l_ff_archive_item_contexts := 'No'; -- Added for bug 14213838.

2300: l_pay_element_entry_values_f := 'No';
2301: l_pay_run_results := 'No';
2302: l_pay_run_result_values := 'No';
2303: l_pay_action_information := 'No';
2304: l_ff_archive_item_contexts := 'No'; -- Added for bug 14213838.
2305:
2306: WHILE (get_emp_update_details%FOUND)
2307: LOOP
2308:

Line 2335: ELSIF l_table_name = 'FF_ARCHIVE_ITEM_CONTEXTS' THEN

2331:
2332: l_pay_action_information := 'Yes';
2333:
2334: -- Added for bug 14213838.
2335: ELSIF l_table_name = 'FF_ARCHIVE_ITEM_CONTEXTS' THEN
2336:
2337: l_ff_archive_item_contexts := 'Yes';
2338:
2339: END IF;

Line 2337: l_ff_archive_item_contexts := 'Yes';

2333:
2334: -- Added for bug 14213838.
2335: ELSIF l_table_name = 'FF_ARCHIVE_ITEM_CONTEXTS' THEN
2336:
2337: l_ff_archive_item_contexts := 'Yes';
2338:
2339: END IF;
2340:
2341: ELSE

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

2343: /*New Employee/New Assignment/New Jurisdiction so print the existing employee details first*/
2344:
2345: fnd_file.put_line(fnd_file.output,'

Line 2358: l_ff_archive_item_contexts :='No'; -- Added for bug 14213838.

2354: l_pay_element_entry_values_f := 'No';
2355: l_pay_run_results := 'No';
2356: l_pay_run_result_values := 'No';
2357: l_pay_action_information := 'No';
2358: l_ff_archive_item_contexts :='No'; -- Added for bug 14213838.
2359:
2360: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN
2361:
2362: l_pay_us_asg_reporting := 'Yes';

Line 2381: ELSIF l_table_name = 'FF_ARCHIVE_ITEM_CONTEXTS' THEN

2377:
2378: l_pay_action_information := 'Yes';
2379:
2380: -- Added for bug 14213838.
2381: ELSIF l_table_name = 'FF_ARCHIVE_ITEM_CONTEXTS' THEN
2382:
2383: l_ff_archive_item_contexts := 'Yes';
2384:
2385:

Line 2383: l_ff_archive_item_contexts := 'Yes';

2379:
2380: -- Added for bug 14213838.
2381: ELSIF l_table_name = 'FF_ARCHIVE_ITEM_CONTEXTS' THEN
2382:
2383: l_ff_archive_item_contexts := 'Yes';
2384:
2385:
2386: END IF;
2387:

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

2394: /*No more records exist. Print the last employee details*/
2395:
2396: fnd_file.put_line(fnd_file.output,'