APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_US_ASG_REPORTING

Line 554: /*Start of PAY_US_ASG_REPORTING Section*/

550: IF p_mode = 'GENERATE' THEN
551:
552: /*GENERATE Mode Ends*/
553:
554: /*Start of PAY_US_ASG_REPORTING Section*/
555:
556: INSERT INTO pay_us_geo_update
557: (id,
558: assignment_id,

Line 570: ,'PAY_US_ASG_REPORTING'

566: description)
567: SELECT DISTINCT p_id
568: ,p_assignment_id
569: ,l_person_id
570: ,'PAY_US_ASG_REPORTING'
571: ,puar.jurisdiction_code
572: ,replace(puar.jurisdiction_code,substr(pumg.city_name,1,6),substr(pumg.city_name,8,6))
573: ,pumg.process_type
574: ,p_date

Line 577: FROM pay_us_asg_reporting puar,

573: ,pumg.process_type
574: ,p_date
575: ,p_mode
576: ,substr(pumg.city_name,8,6)
577: FROM pay_us_asg_reporting puar,
578: pay_us_modified_geocodes pumg
579: WHERE puar.assignment_id = p_assignment_id
580: AND length(puar.jurisdiction_code) = 16
581: AND substr(puar.jurisdiction_code,1,2) = '39'

Line 590: hr_utility.trace('Done with PAY_US_ASG_REPORTING');

586: pumg.county_code,
587: pumg.old_city_code,
588: pumg.city_name)='Y';
589:
590: hr_utility.trace('Done with PAY_US_ASG_REPORTING');
591:
592: /*End of PAY_US_ASG_REPORTING Section*/
593:
594: /*Start of PAY_ELEMENT_ENTRY_VALUES_F Section*/

Line 592: /*End of PAY_US_ASG_REPORTING Section*/

588: pumg.city_name)='Y';
589:
590: hr_utility.trace('Done with PAY_US_ASG_REPORTING');
591:
592: /*End of PAY_US_ASG_REPORTING Section*/
593:
594: /*Start of PAY_ELEMENT_ENTRY_VALUES_F Section*/
595:
596: INSERT INTO pay_us_geo_update

Line 1017: 'PAY_US_ASG_REPORTING',1,

1013: pugu.table_value_id,
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,

Line 1061: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN

1057:
1058: WHILE (get_emp_upgrade_details%FOUND)
1059: LOOP
1060:
1061: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN
1062:
1063: UPDATE pay_us_asg_reporting
1064: SET jurisdiction_code= l_new_jurisdiction_code
1065: WHERE assignment_id = p_assignment_id

Line 1063: UPDATE pay_us_asg_reporting

1059: LOOP
1060:
1061: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN
1062:
1063: UPDATE pay_us_asg_reporting
1064: SET jurisdiction_code= l_new_jurisdiction_code
1065: WHERE assignment_id = p_assignment_id
1066: AND jurisdiction_code = l_old_jurisdiction_code;
1067:

Line 1116: /*See if there are any duplicate records in PAY_US_ASG_REPORTING resulted due to

1112: IF (get_emp_upgrade_details%NOTFOUND) THEN
1113:
1114: /*Bug14082784 Changes */
1115:
1116: /*See if there are any duplicate records in PAY_US_ASG_REPORTING resulted due to
1117: the latest changes. In case, if any are present, remove the duplicate records
1118: to retain single record. Below delete statement achieves this.*/
1119:
1120: DELETE FROM pay_us_asg_reporting

Line 1120: DELETE FROM pay_us_asg_reporting

1116: /*See if there are any duplicate records in PAY_US_ASG_REPORTING resulted due to
1117: the latest changes. In case, if any are present, remove the duplicate records
1118: to retain single record. Below delete statement achieves this.*/
1119:
1120: DELETE FROM pay_us_asg_reporting
1121: WHERE ROWID IN (
1122: SELECT a.ROWID
1123: FROM pay_us_asg_reporting a,
1124: pay_us_asg_reporting b

Line 1123: FROM pay_us_asg_reporting a,

1119:
1120: DELETE FROM pay_us_asg_reporting
1121: WHERE ROWID IN (
1122: SELECT a.ROWID
1123: FROM pay_us_asg_reporting a,
1124: pay_us_asg_reporting b
1125: WHERE a.assignment_id = p_assignment_id
1126: AND a.assignment_id = b.assignment_id
1127: AND a.tax_unit_id=b.tax_unit_id

Line 1124: pay_us_asg_reporting b

1120: DELETE FROM pay_us_asg_reporting
1121: WHERE ROWID IN (
1122: SELECT a.ROWID
1123: FROM pay_us_asg_reporting a,
1124: pay_us_asg_reporting b
1125: WHERE a.assignment_id = p_assignment_id
1126: AND a.assignment_id = b.assignment_id
1127: AND a.tax_unit_id=b.tax_unit_id
1128: AND a.jurisdiction_code=b.jurisdiction_code

Line 2189: l_pay_us_asg_reporting VARCHAR2(10);

2185: l_print_full_name per_all_people_f.full_name%TYPE;
2186: l_print_emp_assignment_id NUMBER;
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);

Line 2270: fnd_file.put_line(fnd_file.output,'PAY_US_ASG_REPORTINGPUAR');

2266:
2267: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

Line 2299: l_pay_us_asg_reporting := 'No';

2295: l_print_full_name := l_full_name;
2296: l_print_emp_assignment_id := l_emp_assignment_id;
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';

Line 2314: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN

2310: AND (l_print_old_juri_code = l_old_jurisdiction_code) AND (l_print_new_juri_code = l_new_jurisdiction_code) THEN
2311:
2312: /*Same employee record for another table. Update the corresponing table flag.*/
2313:
2314: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN
2315:
2316: l_pay_us_asg_reporting := 'Yes';
2317:
2318: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN

Line 2316: l_pay_us_asg_reporting := 'Yes';

2312: /*Same employee record for another table. Update the corresponing table flag.*/
2313:
2314: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN
2315:
2316: l_pay_us_asg_reporting := 'Yes';
2317:
2318: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
2319:
2320: l_pay_element_entry_values_f := 'Yes';

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

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

Line 2353: l_pay_us_asg_reporting := 'No';

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;
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';

Line 2360: IF l_table_name = 'PAY_US_ASG_REPORTING' THEN

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';
2363:
2364: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN

Line 2362: l_pay_us_asg_reporting := 'Yes';

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';
2363:
2364: ELSIF l_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
2365:
2366: l_pay_element_entry_values_f := 'Yes';

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

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