643: hr_utility.trace('Done with PAY_ELEMENT_ENTRY_VALUES_F');
644:
645: /*End of PAY_ELEMENT_ENTRY_VALUES_F Section*/
646:
647: /* For tables PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES, first
648: assignment_action_id will be queried and using that we will look into these
649: tables */
650:
651: OPEN get_assignment_actions(p_assignment_id);
655:
656: FOR i IN tab_assignment_action_id.FIRST..tab_assignment_action_id.LAST
657: LOOP
658:
659: /*Start of PAY_RUN_RESULTS Section*/
660:
661: INSERT INTO pay_us_geo_update
662: (id,
663: assignment_id,
673: SELECT DISTINCT p_id
674: ,p_assignment_id
675: ,l_person_id
676: ,prr.run_result_id
677: ,'PAY_RUN_RESULTS'
678: ,prr.jurisdiction_code
679: ,replace(prr.jurisdiction_code,substr(pumg.city_name,1,6),substr(pumg.city_name,8,6))
680: ,pumg.process_type
681: ,p_date
680: ,pumg.process_type
681: ,p_date
682: ,p_mode
683: ,substr(pumg.city_name,8,6)
684: FROM pay_run_results prr,
685: pay_us_modified_geocodes pumg,
686: pay_element_types_f pet,
687: pay_input_values_f piv
688: WHERE prr.assignment_action_id = tab_assignment_action_id(i)
699: pumg.old_city_code,
700: pumg.city_name)='Y';
701:
702:
703: /*End of PAY_RUN_RESULTS Section*/
704:
705: IF SQL%ROWCOUNT > 0 THEN
706:
707: /*Start of PAY_RUN_RESULT_VALUES Section*/
728: ,pumg.process_type
729: ,p_date
730: ,p_mode
731: ,substr(pumg.city_name,8,6)
732: FROM pay_run_results prr,
733: pay_run_result_values prv,
734: pay_us_modified_geocodes pumg,
735: pay_element_types_f pet,
736: pay_input_values_f piv,
763: END IF;
764:
765: CLOSE get_assignment_actions;
766:
767: hr_utility.trace('Done with PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES');
768:
769: /*Start of PAY_ACTION_INFORMATION Section*/
770:
771: OPEN get_archive_asg_actions(p_assignment_id);
1016: decode(pugu.table_name,
1017: 'PAY_US_ASG_REPORTING',1,
1018: 'PAY_ACTION_INFORMATION',2,
1019: 'PAY_ELEMENT_ENTRY_VALUES_F',3,
1020: 'PAY_RUN_RESULTS',4,
1021: 'PAY_RUN_RESULT_VALUES',5,
1022: 'FF_ARCHVIE_ITEM_CONTEXTS', 6) table_order -- Added for bug 14213838.
1023: FROM pay_us_geo_update pugu
1024: WHERE pugu.id = p_id
1071: SET screen_entry_value = l_new_jurisdiction_code
1072: WHERE element_entry_value_id = l_table_value_id
1073: AND screen_entry_value = l_old_jurisdiction_code;
1074:
1075: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
1076:
1077: UPDATE pay_run_results
1078: SET jurisdiction_code = l_new_jurisdiction_code
1079: WHERE run_result_id = l_table_value_id
1073: AND screen_entry_value = l_old_jurisdiction_code;
1074:
1075: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
1076:
1077: UPDATE pay_run_results
1078: SET jurisdiction_code = l_new_jurisdiction_code
1079: WHERE run_result_id = l_table_value_id
1080: AND jurisdiction_code = l_old_jurisdiction_code;
1081:
2187: l_print_old_juri_code VARCHAR2(16);
2188: l_print_new_juri_code VARCHAR2(16);
2189: l_pay_us_asg_reporting VARCHAR2(10);
2190: l_pay_element_entry_values_f VARCHAR2(10);
2191: l_pay_run_results VARCHAR2(10);
2192: l_pay_run_result_values VARCHAR2(10);
2193: l_pay_action_information VARCHAR2(10);
2194: l_total_assignments NUMBER;
2195: l_success_assignments NUMBER;
2268: fnd_file.put_line(fnd_file.output,'
Table Name | Abbrevation |
---|---|
PAY_US_ASG_REPORTING | PUAR |
PAY_ELEMENT_ENTRY_VALUES_F | PEEV |
PAY_RUN_RESULTS | PRR |
PAY_RUN_RESULT_VALUES | PRRV |
PAY_ACTION_INFORMATION | PAI |
FF_ARCHIVE_ITEM_CONTEXTS | FAIC |
2297: l_print_old_juri_code := l_old_jurisdiction_code;
2298: l_print_new_juri_code := l_new_jurisdiction_code;
2299: l_pay_us_asg_reporting := 'No';
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:
2318: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
2319:
2320: l_pay_element_entry_values_f := 'Yes';
2321:
2322: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
2323:
2324: l_pay_run_results := 'Yes';
2325:
2326: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2320: l_pay_element_entry_values_f := 'Yes';
2321:
2322: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
2323:
2324: l_pay_run_results := 'Yes';
2325:
2326: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2327:
2328: l_pay_run_result_values := 'Yes';
2342:
2343: /*New Employee/New Assignment/New Jurisdiction so print the existing employee details first*/
2344:
2345: fnd_file.put_line(fnd_file.output,'
2351: l_print_old_juri_code := l_old_jurisdiction_code;
2352: l_print_new_juri_code := l_new_jurisdiction_code;
2353: l_pay_us_asg_reporting := 'No';
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:
2364: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
2365:
2366: l_pay_element_entry_values_f := 'Yes';
2367:
2368: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
2369:
2370: l_pay_run_results := 'Yes';
2371:
2372: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2366: l_pay_element_entry_values_f := 'Yes';
2367:
2368: ELSIF l_table_name = 'PAY_RUN_RESULTS' THEN
2369:
2370: l_pay_run_results := 'Yes';
2371:
2372: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2373:
2374: l_pay_run_result_values := 'Yes';
2393:
2394: /*No more records exist. Print the last employee details*/
2395:
2396: fnd_file.put_line(fnd_file.output,'