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 PAY_ACTION_INFORMATION

Line 769: /Start of PAY_ACTION_INFORMATION Section/

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);
772: FETCH get_archive_asg_actions BULK COLLECT INTO tab_assignment_action_id;
773:

Line 800: ,'PAY_ACTION_INFORMATION'

796: SELECT DISTINCT p_id
797: ,p_assignment_id
798: ,l_person_id
799: ,pai.action_information_id
800: ,'PAY_ACTION_INFORMATION'
801: ,pai.jurisdiction_code
802: ,replace(pai.jurisdiction_code,substr(pumg.city_name,1,6),substr(pumg.city_name,8,6))
803: ,pumg.process_type
804: ,p_date

Line 807: FROM pay_action_information pai,

803: ,pumg.process_type
804: ,p_date
805: ,p_mode
806: ,substr(pumg.city_name,8,6)
807: FROM pay_action_information pai,
808: pay_us_modified_geocodes pumg
809: WHERE pai.action_context_id = tab_assignment_action_id(i)
810: AND pai.action_context_type = 'AAP'
811: AND pai.action_information_category = 'US PSD'

Line 828: hr_utility.trace('Done with PAY_ACTION_INFORMATION');

824: END IF; /* tab_assignment_action_id.COUNT IF */
825:
826: CLOSE get_archive_asg_actions;
827:
828: hr_utility.trace('Done with PAY_ACTION_INFORMATION');
829:
830: /*End of PAY_ACTION_INFORMATION Section*/
831:
832: -- Added for bug 14213838.

Line 830: /End of PAY_ACTION_INFORMATION Section/

826: CLOSE get_archive_asg_actions;
827:
828: hr_utility.trace('Done with PAY_ACTION_INFORMATION');
829:
830: /*End of PAY_ACTION_INFORMATION Section*/
831:
832: -- Added for bug 14213838.
833: /*Start of FF_ARCHVIE_ITEMS_CONTEXTS Section*/
834:

Line 1018: 'PAY_ACTION_INFORMATION',2,

1014: pugu.old_juri_code,
1015: pugu.new_juri_code,
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.

Line 1089: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN

1085: SET result_value = l_new_jurisdiction_code
1086: WHERE run_result_id = l_table_value_id
1087: AND result_value = l_old_jurisdiction_code;
1088:
1089: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN
1090:
1091: UPDATE pay_action_information
1092: SET jurisdiction_code = l_new_jurisdiction_code
1093: WHERE action_information_id = l_table_value_id

Line 1091: UPDATE pay_action_information

1087: AND result_value = l_old_jurisdiction_code;
1088:
1089: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN
1090:
1091: UPDATE pay_action_information
1092: SET jurisdiction_code = l_new_jurisdiction_code
1093: WHERE action_information_id = l_table_value_id
1094: AND action_context_type = 'AAP'
1095: AND action_information_category = 'US PSD'

Line 2193: l_pay_action_information VARCHAR2(10);

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;
2196: l_error_assignments NUMBER;
2197: l_not_process_assignments NUMBER;

Line 2274: fnd_file.put_line(fnd_file.output,'PAY_ACTION_INFORMATIONPAI');

2270: fnd_file.put_line(fnd_file.output,'PAY_US_ASG_REPORTINGPUAR');
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 2303: l_pay_action_information := 'No';

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:
2306: WHILE (get_emp_update_details%FOUND)
2307: LOOP

Line 2330: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN

2326: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2327:
2328: l_pay_run_result_values := 'Yes';
2329:
2330: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN
2331:
2332: l_pay_action_information := 'Yes';
2333:
2334: -- Added for bug 14213838.

Line 2332: l_pay_action_information := 'Yes';

2328: l_pay_run_result_values := 'Yes';
2329:
2330: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' 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:

Line 2347: fnd_file.put_line(fnd_file.output,''||l_pay_action_information||''||l_ff_archive_item_contexts||'');

2343: /*New Employee/New Assignment/New Jurisdiction so print the existing employee details first*/
2344:
2345: fnd_file.put_line(fnd_file.output,''||l_print_full_name||''||l_print_emp_assignment_id||''||l_print_old_juri_code||''||l_print_new_juri_code||'');
2346: fnd_file.put_line(fnd_file.output,''||l_pay_us_asg_reporting||''||l_pay_element_entry_values_f||''||l_pay_run_results||''||l_pay_run_result_values||'');
2347: fnd_file.put_line(fnd_file.output,''||l_pay_action_information||''||l_ff_archive_item_contexts||'');
2348:
2349: l_print_full_name := l_full_name;
2350: l_print_emp_assignment_id := l_emp_assignment_id;
2351: l_print_old_juri_code := l_old_jurisdiction_code;

Line 2357: l_pay_action_information := 'No';

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:
2360: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN
2361:

Line 2376: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN

2372: ELSIF l_table_name = 'PAY_RUN_RESULT_VALUES' THEN
2373:
2374: l_pay_run_result_values := 'Yes';
2375:
2376: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' THEN
2377:
2378: l_pay_action_information := 'Yes';
2379:
2380: -- Added for bug 14213838.

Line 2378: l_pay_action_information := 'Yes';

2374: l_pay_run_result_values := 'Yes';
2375:
2376: ELSIF l_table_name = 'PAY_ACTION_INFORMATION' 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:

Line 2398: fnd_file.put_line(fnd_file.output,''||l_pay_action_information||''||l_ff_archive_item_contexts||'');

2394: /*No more records exist. Print the last employee details*/
2395:
2396: fnd_file.put_line(fnd_file.output,''||l_print_full_name||''||l_print_emp_assignment_id||''||l_print_old_juri_code||''||l_print_new_juri_code||'');
2397: fnd_file.put_line(fnd_file.output,''||l_pay_us_asg_reporting||''||l_pay_element_entry_values_f||''||l_pay_run_results||''||l_pay_run_result_values||'');
2398: fnd_file.put_line(fnd_file.output,''||l_pay_action_information||''||l_ff_archive_item_contexts||'');
2399: END IF;
2400:
2401: END LOOP;
2402: