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.PSP_SUM_TRANS dependencies on PSP_DISTRIBUTION_LINES

Line 546: DELETE FROM psp_distribution_lines

542: to compare .. Basically to check the number of lines in dist lines ...instead of summing on dist amount
543: for deciding wether to change control rec status to either 'P' or 'N' */
544: IF payroll_control_rec.source_type = 'O' OR payroll_control_rec.source_type = 'N' THEN
545:
546: DELETE FROM psp_distribution_lines
547: WHERE distribution_amount = 0
548: AND payroll_sub_line_id IN (
549: select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id IN (
550: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (

Line 556: FROM psp_distribution_lines pdl,

552: payroll_control_rec.payroll_control_id)));
553:
554: SELECT count(*)
555: INTO l_line_counter
556: FROM psp_distribution_lines pdl,
557: psp_payroll_sub_lines ppsl,
558: psp_payroll_lines ppl
559: WHERE ppl.payroll_control_id = payroll_control_rec.payroll_control_id
560: AND ppl.payroll_line_id = ppsl.payroll_line_id

Line 694: psp_distribution_lines pdl

690: psp_default_labor_schedules pdls,
691: psp_payroll_controls ppc,
692: psp_payroll_lines ppl,
693: psp_payroll_sub_lines ppsl,
694: psp_distribution_lines pdl
695: WHERE pdl.status_code = 'N'
696: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
697: AND ppsl.payroll_line_id = ppl.payroll_line_id
698: AND ppl.payroll_control_id = ppc.payroll_control_id

Line 777: psp_distribution_lines pdl

773: FROM psp_payroll_controls ppc,
774: psp_payroll_lines ppl,
775: psp_payroll_sub_lines ppsl,
776: psp_organization_accounts pos,
777: psp_distribution_lines pdl
778: WHERE pdl.status_code = 'N'
779: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
780: AND ppsl.payroll_line_id = ppl.payroll_line_id
781: AND ppl.payroll_control_id = ppc.payroll_control_id

Line 992: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines setting summary_line_id : '||l_summary_line_id);

988: l_dist_line_id := dist_line_id(j);
989:
990: IF gl_sum_lines_rec.tab_flag = 'D' THEN
991:
992: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines setting summary_line_id : '||l_summary_line_id);
993:
994: UPDATE psp_distribution_lines
995: SET summary_line_id = l_summary_line_id WHERE distribution_line_id = l_dist_line_id;
996: ELSIF gl_sum_lines_rec.tab_flag = 'P' THEN

Line 994: UPDATE psp_distribution_lines

990: IF gl_sum_lines_rec.tab_flag = 'D' THEN
991:
992: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines setting summary_line_id : '||l_summary_line_id);
993:
994: UPDATE psp_distribution_lines
995: SET summary_line_id = l_summary_line_id WHERE distribution_line_id = l_dist_line_id;
996: ELSIF gl_sum_lines_rec.tab_flag = 'P' THEN
997:
998: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_pre_gen_dist_lines setting summary_line_id : '||l_summary_line_id);

Line 1091: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines status_code to N and summary_line_id to '||l_summary_line_id||' for dist_line_id: '||l_dist_line_id);

1087: FOR j IN 1 .. dist_line_id.COUNT LOOP
1088: l_dist_line_id := dist_line_id(j);
1089:
1090: IF gl_sum_lines_rec.tab_flag = 'D' THEN
1091: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines status_code to N and summary_line_id to '||l_summary_line_id||' for dist_line_id: '||l_dist_line_id);
1092:
1093: UPDATE psp_distribution_lines
1094: SET summary_line_id = l_summary_line_id,
1095: status_code = 'N'

Line 1093: UPDATE psp_distribution_lines

1089:
1090: IF gl_sum_lines_rec.tab_flag = 'D' THEN
1091: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines status_code to N and summary_line_id to '||l_summary_line_id||' for dist_line_id: '||l_dist_line_id);
1092:
1093: UPDATE psp_distribution_lines
1094: SET summary_line_id = l_summary_line_id,
1095: status_code = 'N'
1096: WHERE distribution_line_id = l_dist_line_id;
1097: ELSIF gl_sum_lines_rec.tab_flag = 'P' THEN

Line 1099: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines status_code to N and summary_line_id to '||l_summary_line_id||' for dist_line_id: '||l_dist_line_id);

1095: status_code = 'N'
1096: WHERE distribution_line_id = l_dist_line_id;
1097: ELSIF gl_sum_lines_rec.tab_flag = 'P' THEN
1098:
1099: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines status_code to N and summary_line_id to '||l_summary_line_id||' for dist_line_id: '||l_dist_line_id);
1100:
1101: UPDATE psp_pre_gen_dist_lines
1102: SET summary_line_id = l_summary_line_id,
1103: status_code = 'N'

Line 1668: -- mark the successfully transferred records as 'A' in psp_summary_lines and psp_distribution_lines

1664: FETCH gl_payroll_control_cursor INTO gl_payroll_control_rec;
1665: EXIT WHEN gl_payroll_control_cursor%NOTFOUND;
1666:
1667:
1668: -- mark the successfully transferred records as 'A' in psp_summary_lines and psp_distribution_lines
1669: -- and transfer the successful records to the history table
1670: -- 1874696:changed l_period_end_date to NULL in tie back call
1671: -- Bug 22663344 reverted null value to l_period_end_date
1672: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gl_tie_back');

Line 1838: FROM psp_distribution_lines pdl

1834: pdl.distribution_date,
1835: pdl.suspense_org_account_id,
1836: pdl.reversal_entry_flag,
1837: pdl.effective_date -- Bug 7040943 Added
1838: FROM psp_distribution_lines pdl
1839: WHERE pdl.summary_line_id = p_summary_line_id
1840: UNION
1841: SELECT ppgd.rowid,
1842: ppgd.pre_gen_dist_line_id line_id,

Line 1866: psp_distribution_lines pdl

1862: FROM hr_all_organization_units hou,
1863: per_assignments_f paf,
1864: psp_payroll_lines ppl,
1865: psp_payroll_sub_lines ppsl,
1866: psp_distribution_lines pdl
1867: WHERE pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
1868: AND ppsl.payroll_line_id = ppl.payroll_line_id
1869: AND pdl.distribution_line_id = p_line_id
1870: AND ppl.assignment_id = paf.assignment_id

Line 1994: psp_distribution_lines pdl

1990: ppl.assignment_id,
1991: ppl.person_id
1992: from psp_payroll_lines ppl,
1993: psp_payroll_sub_lines ppsl,
1994: psp_distribution_lines pdl
1995: where pdl.distribution_line_id = x_line_id
1996: and pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
1997: and ppsl.payroll_line_id = ppl.payroll_line_id
1998: union all

Line 2146: from psp_distribution_lines

2142: FROM psp_payroll_lines
2143: WHERE payroll_control_id = p_payroll_control_id
2144: and payroll_line_id = (select payroll_line_id from psp_payroll_sub_lines
2145: where payroll_sub_line_id = (select payroll_sub_line_id
2146: from psp_distribution_lines
2147: where distribution_line_id = x_line_id));
2148: END IF;
2149:
2150: -- Get the name and gl_ccid of the suspense account used

Line 2339: UPDATE PSP_DISTRIBUTION_LINES

2335: IF p_source_type = 'O' OR p_source_type = 'N' THEN
2336:
2337: /* Added the following for Bug 3065866 */
2338:
2339: UPDATE PSP_DISTRIBUTION_LINES
2340: SET pre_distribution_run_flag = gl_project_flag
2341: WHERE rowid = l_rowid;
2342:
2343: /* End of code changes for Bug 3065866 */

Line 2345: UPDATE psp_distribution_lines

2341: WHERE rowid = l_rowid;
2342:
2343: /* End of code changes for Bug 3065866 */
2344:
2345: UPDATE psp_distribution_lines
2346: SET suspense_org_account_id = l_organization_account_id,
2347: suspense_reason_code = 'ST:' || l_status,
2348: gl_project_flag = l_gl_project_flag,
2349: status_code = 'N',

Line 2354: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 1 updated psp_distribution_lines count: '||sql%rowcount);

2350: effective_date = l_effective_date, --- for Bug 2663344
2351: suspense_auto_glccid = l_new_glccid, --- added suspense_auto for 5080403
2352: suspense_auto_exp_type = l_new_expenditure_type
2353: WHERE rowid = l_rowid;
2354: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 1 updated psp_distribution_lines count: '||sql%rowcount);
2355: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_effective_date: '||l_effective_date);
2356:
2357: ELSIF p_source_type = 'P' THEN
2358: UPDATE psp_pre_gen_dist_lines

Line 2403: UPDATE psp_distribution_lines

2399:
2400: /* Added the following for the Bug 3065866 */
2401:
2402: IF p_source_type = 'O' OR p_source_type = 'N' THEN
2403: UPDATE psp_distribution_lines
2404: SET suspense_org_account_id = NULL,
2405: suspense_reason_code = NULL,
2406: gl_project_flag = pre_distribution_run_flag,
2407: effective_date = decode(pre_distribution_run_flag,'G',

Line 2415: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 2 updated psp_distribution_lines count: '||sql%rowcount);

2411: IN (SELECT summary_line_id
2412: FROM psp_summary_lines
2413: WHERE payroll_control_id = p_payroll_control_id);
2414:
2415: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 2 updated psp_distribution_lines count: '||sql%rowcount);
2416: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_effective_date: '||l_effective_date);
2417:
2418: ELSIF p_source_type = 'P' THEN
2419:

Line 2472: UPDATE psp_distribution_lines

2468:
2469: IF p_source_type = 'O' OR p_source_type = 'N' THEN
2470:
2471:
2472: UPDATE psp_distribution_lines
2473: SET suspense_org_account_id = NULL,
2474: suspense_reason_code = NULL,
2475: gl_project_flag = pre_distribution_run_flag,
2476: effective_date = decode(pre_distribution_run_flag,'G',

Line 2484: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 3 updated psp_distribution_lines count: '||sql%rowcount);

2480: IN (SELECT summary_line_id
2481: FROM psp_summary_lines
2482: WHERE payroll_control_id = p_payroll_control_id );
2483:
2484: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 3 updated psp_distribution_lines count: '||sql%rowcount);
2485: --fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_effective_date: '||l_effective_date);
2486:
2487: ELSIF p_source_type = 'P' THEN
2488: UPDATE psp_pre_gen_dist_lines

Line 2584: UPDATE psp_distribution_lines

2580: END IF;
2581:
2582: IF p_source_type = 'O' OR p_source_type = 'N' THEN
2583:
2584: UPDATE psp_distribution_lines
2585: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2586: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code = A count: '||sql%rowcount);
2587:
2588: -- move the transferred records to psp_distribution_lines_history

Line 2586: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code = A count: '||sql%rowcount);

2582: IF p_source_type = 'O' OR p_source_type = 'N' THEN
2583:
2584: UPDATE psp_distribution_lines
2585: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2586: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code = A count: '||sql%rowcount);
2587:
2588: -- move the transferred records to psp_distribution_lines_history
2589: INSERT INTO psp_distribution_lines_history
2590: (distribution_line_id,payroll_sub_line_id,distribution_date,

Line 2588: -- move the transferred records to psp_distribution_lines_history

2584: UPDATE psp_distribution_lines
2585: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2586: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code = A count: '||sql%rowcount);
2587:
2588: -- move the transferred records to psp_distribution_lines_history
2589: INSERT INTO psp_distribution_lines_history
2590: (distribution_line_id,payroll_sub_line_id,distribution_date,
2591: effective_date,distribution_amount,status_code,suspense_reason_code,
2592: effort_report_id,version_num,schedule_line_id,

Line 2589: INSERT INTO psp_distribution_lines_history

2585: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2586: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code = A count: '||sql%rowcount);
2587:
2588: -- move the transferred records to psp_distribution_lines_history
2589: INSERT INTO psp_distribution_lines_history
2590: (distribution_line_id,payroll_sub_line_id,distribution_date,
2591: effective_date,distribution_amount,status_code,suspense_reason_code,
2592: effort_report_id,version_num,schedule_line_id,
2593: summary_line_id,default_org_account_id,suspense_org_account_id,

Line 2618: FROM psp_distribution_lines

2614: cap_excess_glccid, cap_excess_award_id, cap_excess_task_id,
2615: cap_excess_project_id, cap_excess_exp_type, cap_excess_exp_org_id,
2616: funding_source_code, annual_salary_cap, cap_excess_dist_line_id,
2617: suspense_auto_exp_type, suspense_auto_glccid, adj_account_flag
2618: FROM psp_distribution_lines
2619: WHERE status_code = 'A'
2620: AND summary_line_id = l_summary_line_id;
2621:
2622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' inserted into psp_distribution_lines_history count: '||sql%rowcount);

Line 2622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' inserted into psp_distribution_lines_history count: '||sql%rowcount);

2618: FROM psp_distribution_lines
2619: WHERE status_code = 'A'
2620: AND summary_line_id = l_summary_line_id;
2621:
2622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' inserted into psp_distribution_lines_history count: '||sql%rowcount);
2623:
2624: DELETE FROM psp_distribution_lines
2625: WHERE status_code = 'A'
2626: AND summary_line_id = l_summary_line_id;

Line 2624: DELETE FROM psp_distribution_lines

2620: AND summary_line_id = l_summary_line_id;
2621:
2622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' inserted into psp_distribution_lines_history count: '||sql%rowcount);
2623:
2624: DELETE FROM psp_distribution_lines
2625: WHERE status_code = 'A'
2626: AND summary_line_id = l_summary_line_id;
2627:
2628: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from psp_distribution_lines count: '||sql%rowcount);

Line 2628: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from psp_distribution_lines count: '||sql%rowcount);

2624: DELETE FROM psp_distribution_lines
2625: WHERE status_code = 'A'
2626: AND summary_line_id = l_summary_line_id;
2627:
2628: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from psp_distribution_lines count: '||sql%rowcount);
2629:
2630: ELSIF p_source_type = 'P' THEN
2631:
2632: UPDATE psp_pre_gen_dist_lines

Line 2745: FROM psp_distribution_lines pdl,

2741: round(sum(pdl.distribution_amount), p_precision) reversal_dist_amount,-- Changed rounding from 2 to p_precision
2742: -- For Bug 2916848
2743: pdl.business_group_id,
2744: pdl.set_of_books_id
2745: FROM psp_distribution_lines pdl,
2746: psp_payroll_sub_lines ppsl,
2747: psp_payroll_lines ppl,
2748: psp_payroll_controls ppc
2749: WHERE ppc.payroll_control_id = p_payroll_control_id

Line 2802: DELETE FROM psp_distribution_lines

2798: BEGIN
2799:
2800: IF p_source_type = 'O' OR p_source_type = 'N' THEN
2801:
2802: DELETE FROM psp_distribution_lines
2803: WHERE reversal_entry_flag = 'Y'
2804: AND status_code = 'N'
2805: AND payroll_sub_line_id IN (
2806: select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id IN (

Line 2822: insert into psp_distribution_lines

2818: EXIT;
2819: END IF;
2820:
2821: -- insert the reversal entry record into distribution lines
2822: insert into psp_distribution_lines
2823: (distribution_line_id,payroll_sub_line_id,distribution_date,effective_date,
2824: distribution_amount,status_code,gl_project_flag,reversal_entry_flag,
2825: business_group_id, set_of_books_id)
2826: values

Line 2827: (PSP_DISTRIBUTION_LINES_S.NEXTVAL,dist_reversal_entry_rec.payroll_sub_line_id,

2823: (distribution_line_id,payroll_sub_line_id,distribution_date,effective_date,
2824: distribution_amount,status_code,gl_project_flag,reversal_entry_flag,
2825: business_group_id, set_of_books_id)
2826: values
2827: (PSP_DISTRIBUTION_LINES_S.NEXTVAL,dist_reversal_entry_rec.payroll_sub_line_id,
2828: dist_reversal_entry_rec.effective_date,dist_reversal_entry_rec.effective_date,
2829: dist_reversal_entry_rec.reversal_dist_amount,'N','G','Y',
2830: dist_reversal_entry_rec.business_group_id, dist_reversal_entry_rec.set_of_books_id);
2831:

Line 2837: FROM psp_distribution_lines pdl,

2833:
2834: select sum(decode(reversal_entry_flag, 'Y', distribution_amount, 0)) cr_amount,
2835: sum(decode(reversal_entry_flag, 'Y', 0, distribution_amount)) dr_amount
2836: INTO l_cr_amount, l_dr_amount
2837: FROM psp_distribution_lines pdl,
2838: psp_payroll_sub_lines ppsl,
2839: psp_payroll_lines ppl,
2840: psp_payroll_controls ppc
2841: WHERE ppc.payroll_control_id = p_payroll_control_id

Line 2901: values (psp_distribution_lines_s.nextval, pg_reversal_entry_rec.distribution_interface_id,

2897: element_type_id, distribution_date, effective_date, distribution_amount,
2898: dr_cr_flag, payroll_control_id, source_type, source_code, time_period_id,
2899: batch_name, status_code, set_of_books_id, business_group_id, gl_code_combination_id,
2900: reversal_entry_flag)
2901: values (psp_distribution_lines_s.nextval, pg_reversal_entry_rec.distribution_interface_id,
2902: pg_reversal_entry_rec.person_id, pg_reversal_entry_rec.assignment_id,
2903: pg_reversal_entry_rec.element_type_id, pg_reversal_entry_rec.distribution_date,
2904: pg_reversal_entry_rec.effective_date, pg_reversal_entry_rec.reversal_dist_amount,
2905: pg_reversal_entry_rec.dr_cr_flag, p_payroll_control_id, pg_reversal_entry_rec.source_type,

Line 3205: psp_distribution_lines pdl

3201: psp_default_labor_schedules pdls,
3202: psp_payroll_controls ppc,
3203: psp_payroll_lines ppl,
3204: psp_payroll_sub_lines ppsl,
3205: psp_distribution_lines pdl
3206: WHERE pdl.status_code = 'N'
3207: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
3208: AND ppsl.payroll_line_id = ppl.payroll_line_id
3209: AND ppl.payroll_control_id = ppc.payroll_control_id

Line 3298: psp_distribution_lines pdl

3294: FROM psp_organization_accounts pos,
3295: psp_payroll_controls ppc,
3296: psp_payroll_lines ppl,
3297: psp_payroll_sub_lines ppsl,
3298: psp_distribution_lines pdl
3299: WHERE pdl.status_code = 'N'
3300: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
3301: AND ppsl.payroll_line_id = ppl.payroll_line_id
3302: AND ppl.payroll_control_id = ppc.payroll_control_id

Line 3521: UPDATE psp_distribution_lines

3517: l_dist_line_id := dist_line_id(j);
3518: --dbms_output.put_line('Dist_line_id to be updated = '||to_char(l_dist_line_id));
3519:
3520: IF gms_sum_lines_rec.tab_flag = 'D' THEN
3521: UPDATE psp_distribution_lines
3522: SET summary_line_id = l_summary_line_id WHERE distribution_line_id = l_dist_line_id;
3523: ELSIF gms_sum_lines_rec.tab_flag = 'P' THEN
3524: UPDATE psp_pre_gen_dist_lines
3525: SET summary_line_id = l_summary_line_id WHERE pre_gen_dist_line_id = l_dist_line_id;

Line 3622: UPDATE psp_distribution_lines

3618: l_dist_line_id := dist_line_id(j);
3619: --dbms_output.put_line('Dist_line_id to be updated = '||to_char(l_dist_line_id));
3620:
3621: IF gms_sum_lines_rec.tab_flag = 'D' THEN
3622: UPDATE psp_distribution_lines
3623: SET summary_line_id = l_summary_line_id,
3624: status_code = 'N'
3625: WHERE distribution_line_id = l_dist_line_id;
3626: ELSIF gms_sum_lines_rec.tab_flag = 'P' THEN

Line 4243: -- mark the successfully transferred records as 'A' in psp_summary_lines and psp_distribution_lines

4239: p_business_group_id ,
4240: p_set_of_books_id );
4241: ENd if;
4242:
4243: -- mark the successfully transferred records as 'A' in psp_summary_lines and psp_distribution_lines
4244: -- and transfer the successful records to the history table
4245: --- Bug 2663344 reverted NULL to l_period_end_date in tie back call
4246: hr_utility.trace(' before loop for gms_tie_back');
4247: FOR I in 1..org_id_tab.count

Line 4336: FROM psp_distribution_lines pdl

4332: SELECT pdl.rowid,
4333: pdl.distribution_line_id line_id,
4334: pdl.distribution_date,
4335: pdl.suspense_org_account_id
4336: FROM psp_distribution_lines pdl
4337: WHERE pdl.summary_line_id = p_summary_line_id
4338: UNION
4339: SELECT ppgd.rowid,
4340: ppgd.pre_gen_dist_line_id line_id,

Line 4360: psp_distribution_lines pdl

4356: FROM hr_all_organization_units hou,
4357: per_assignments_f paf,
4358: psp_payroll_lines ppl,
4359: psp_payroll_sub_lines ppsl,
4360: psp_distribution_lines pdl
4361: WHERE paf.assignment_id = ppl.assignment_id
4362: AND hou.organization_id = paf.organization_id
4363: AND pdl.distribution_line_id = p_line_id
4364: AND ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id

Line 4488: psp_distribution_lines pdl

4484: ppl.assignment_id,
4485: ppl.person_id
4486: from psp_payroll_lines ppl,
4487: psp_payroll_sub_lines ppsl,
4488: psp_distribution_lines pdl
4489: where pdl.distribution_line_id = x_line_id
4490: and pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
4491: and ppsl.payroll_line_id = ppl.payroll_line_id
4492: union all

Line 4747: from psp_distribution_lines

4743: FROM psp_payroll_lines
4744: WHERE payroll_control_id = p_payroll_control_id
4745: and payroll_line_id = (select payroll_line_id from psp_payroll_sub_lines
4746: where payroll_sub_line_id = (select payroll_sub_line_id
4747: from psp_distribution_lines
4748: where distribution_line_id = x_line_id));
4749: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' from psp_payroll_lines: l_pay_action_type, l_effective_date'||l_pay_action_type||l_effective_date);
4750:
4751: /*Bug 7376898 End*/

Line 4761: UPDATE psp_distribution_lines

4757: IF l_trx_status_code = 'A' THEN
4758: IF p_source_type = 'O' OR p_source_type = 'N' THEN
4759: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Payroll type O or N');
4760:
4761: UPDATE psp_distribution_lines
4762: SET status_code = 'A'
4763: WHERE rowid = l_rowid;
4764:
4765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_distribution_lines set status_code A count: '||sql%rowcount);

Line 4765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_distribution_lines set status_code A count: '||sql%rowcount);

4761: UPDATE psp_distribution_lines
4762: SET status_code = 'A'
4763: WHERE rowid = l_rowid;
4764:
4765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_distribution_lines set status_code A count: '||sql%rowcount);
4766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code in psp_distribution_lines to A for rowid :'||l_rowid);
4767:
4768: INSERT INTO psp_distribution_lines_history
4769: (distribution_line_id,payroll_sub_line_id,distribution_date,

Line 4766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code in psp_distribution_lines to A for rowid :'||l_rowid);

4762: SET status_code = 'A'
4763: WHERE rowid = l_rowid;
4764:
4765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_distribution_lines set status_code A count: '||sql%rowcount);
4766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code in psp_distribution_lines to A for rowid :'||l_rowid);
4767:
4768: INSERT INTO psp_distribution_lines_history
4769: (distribution_line_id,payroll_sub_line_id,distribution_date,
4770: effective_date,distribution_amount,status_code,suspense_reason_code,

Line 4768: INSERT INTO psp_distribution_lines_history

4764:
4765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_distribution_lines set status_code A count: '||sql%rowcount);
4766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code in psp_distribution_lines to A for rowid :'||l_rowid);
4767:
4768: INSERT INTO psp_distribution_lines_history
4769: (distribution_line_id,payroll_sub_line_id,distribution_date,
4770: effective_date,distribution_amount,status_code,suspense_reason_code,
4771: effort_report_id,version_num,schedule_line_id,summary_line_id,
4772: default_org_account_id,suspense_org_account_id,

Line 4797: FROM psp_distribution_lines

4793: cap_excess_glccid, cap_excess_award_id, cap_excess_task_id,
4794: cap_excess_project_id, cap_excess_exp_type, cap_excess_exp_org_id,
4795: funding_source_code, annual_salary_cap, cap_excess_dist_line_id,
4796: suspense_auto_exp_type, suspense_auto_glccid, adj_account_flag
4797: FROM psp_distribution_lines
4798: WHERE status_code = 'A'
4799: AND summary_line_id = to_number(l_orig_trx_reference);
4800:
4801: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference

Line 4801: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference

4797: FROM psp_distribution_lines
4798: WHERE status_code = 'A'
4799: AND summary_line_id = to_number(l_orig_trx_reference);
4800:
4801: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference
4802: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
4803: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' after insert into dist lines');
4804:
4805: hr_utility.trace('after insert into dist lines');

Line 4806: DELETE FROM psp_distribution_lines

4802: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
4803: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' after insert into dist lines');
4804:
4805: hr_utility.trace('after insert into dist lines');
4806: DELETE FROM psp_distribution_lines
4807: WHERE status_code = 'A'
4808: AND summary_line_id = to_number(l_orig_trx_reference);
4809:
4810: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from psp_distribution_lines for summary_line_id: '||l_orig_trx_reference

Line 4810: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from psp_distribution_lines for summary_line_id: '||l_orig_trx_reference

4806: DELETE FROM psp_distribution_lines
4807: WHERE status_code = 'A'
4808: AND summary_line_id = to_number(l_orig_trx_reference);
4809:
4810: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from psp_distribution_lines for summary_line_id: '||l_orig_trx_reference
4811: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
4812:
4813: --moved the two del stmnts above for 2445196
4814:

Line 4887: UPDATE psp_distribution_lines

4883:
4884: /* Commented For Bug 3065866
4885:
4886: IF p_source_type = 'O' OR p_source_type = 'N' THEN
4887: UPDATE psp_distribution_lines
4888: SET suspense_reason_code = l_trx_reject_code,
4889: status_code = 'N'
4890: WHERE rowid = l_rowid;
4891: ELSIF p_source_type = 'P' THEN

Line 5072: UPDATE psp_distribution_lines

5068: IF p_source_type = 'O' OR p_source_type = 'N' THEN
5069:
5070: /* Added for Bug 3065866 */
5071:
5072: UPDATE psp_distribution_lines
5073: SET pre_distribution_run_flag = gl_project_flag
5074: WHERE rowid = l_rowid;
5075:
5076: /* End of changes for Bug 3065866*/

Line 5077: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_distribution_lines for rowid: '||l_rowid||' with l_effective_date'||l_effective_date);

5073: SET pre_distribution_run_flag = gl_project_flag
5074: WHERE rowid = l_rowid;
5075:
5076: /* End of changes for Bug 3065866*/
5077: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_distribution_lines for rowid: '||l_rowid||' with l_effective_date'||l_effective_date);
5078: UPDATE psp_distribution_lines
5079: SET suspense_org_account_id = l_organization_account_id,
5080: suspense_reason_code = 'ST:' || l_trx_reject_code,
5081: gl_project_flag = l_gl_project_flag,

Line 5078: UPDATE psp_distribution_lines

5074: WHERE rowid = l_rowid;
5075:
5076: /* End of changes for Bug 3065866*/
5077: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_distribution_lines for rowid: '||l_rowid||' with l_effective_date'||l_effective_date);
5078: UPDATE psp_distribution_lines
5079: SET suspense_org_account_id = l_organization_account_id,
5080: suspense_reason_code = 'ST:' || l_trx_reject_code,
5081: gl_project_flag = l_gl_project_flag,
5082: status_code = 'N',

Line 5087: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set pre_distribution_run_flag count: '||sql%rowcount);

5083: -- effective_date = l_effective_date, ---uncommented this line for Bug 2663344 -- Commented for Bug 10181561
5084: suspense_auto_glccid = l_new_glccid, --- added suspense_auto for 5080403
5085: suspense_auto_exp_type = l_new_expenditure_type
5086: WHERE rowid = l_rowid;
5087: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set pre_distribution_run_flag count: '||sql%rowcount);
5088:
5089: ELSIF p_source_type = 'P' THEN
5090: UPDATE psp_pre_gen_dist_lines
5091: SET suspense_org_account_id = l_organization_account_id,

Line 5147: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines for p_payroll_control_id: '||p_payroll_control_id);

5143: /* Added this code for Bug 3065866 */
5144: IF p_source_type = 'O' OR p_source_type = 'N' THEN
5145:
5146:
5147: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines for p_payroll_control_id: '||p_payroll_control_id);
5148:
5149: UPDATE psp_distribution_lines
5150: SET suspense_org_account_id = NULL,
5151: suspense_reason_code = NULL,

Line 5149: UPDATE psp_distribution_lines

5145:
5146:
5147: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines for p_payroll_control_id: '||p_payroll_control_id);
5148:
5149: UPDATE psp_distribution_lines
5150: SET suspense_org_account_id = NULL,
5151: suspense_reason_code = NULL,
5152: gl_project_flag = pre_distribution_run_flag,
5153: effective_date = decode(pre_distribution_run_flag,'G',

Line 5160: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines count: '||sql%rowcount);

5156: AND summary_line_id
5157: IN ( SELECT summary_line_id
5158: FROM psp_summary_lines
5159: WHERE payroll_control_id = p_payroll_control_id);
5160: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines count: '||sql%rowcount);
5161:
5162: ELSIF p_source_type = 'P' THEN
5163: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_pre_gen_distribution_lines for p_payroll_control_id: '||p_payroll_control_id);
5164:

Line 5211: UPDATE psp_distribution_lines

5207:
5208: IF p_source_type = 'O' OR p_source_type = 'N' THEN
5209: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type O or N');
5210:
5211: UPDATE psp_distribution_lines
5212: SET suspense_org_account_id = NULL,
5213: suspense_reason_code = NULL
5214: WHERE suspense_reason_code like 'ST:%'
5215: AND summary_line_id

Line 5219: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines for p_payroll_control_id: '||p_payroll_control_id);

5215: AND summary_line_id
5216: IN( SELECT summary_line_id
5217: FROM psp_summary_lines
5218: WHERE payroll_control_id = p_payroll_control_id);
5219: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updating psp_distribution_lines for p_payroll_control_id: '||p_payroll_control_id);
5220:
5221: ELSIF p_source_type = 'P' THEN
5222:
5223: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type P');

Line 5328: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_distribution_lines for summary_line_id'||l_summary_line_id);

5324: END IF;
5325:
5326: IF p_source_type = 'O' OR p_source_type = 'N' THEN
5327:
5328: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_distribution_lines for summary_line_id'||l_summary_line_id);
5329:
5330: UPDATE psp_distribution_lines
5331: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);

Line 5330: UPDATE psp_distribution_lines

5326: IF p_source_type = 'O' OR p_source_type = 'N' THEN
5327:
5328: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_distribution_lines for summary_line_id'||l_summary_line_id);
5329:
5330: UPDATE psp_distribution_lines
5331: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);
5333:
5334:

Line 5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);

5328: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_distribution_lines for summary_line_id'||l_summary_line_id);
5329:
5330: UPDATE psp_distribution_lines
5331: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);
5333:
5334:
5335: -- move the transferred records to psp_distribution_lines_history
5336: INSERT INTO psp_distribution_lines_history

Line 5335: -- move the transferred records to psp_distribution_lines_history

5331: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);
5333:
5334:
5335: -- move the transferred records to psp_distribution_lines_history
5336: INSERT INTO psp_distribution_lines_history
5337: (distribution_line_id,payroll_sub_line_id,distribution_date,
5338: effective_date,distribution_amount,status_code,suspense_reason_code,
5339: effort_report_id,version_num,schedule_line_id,summary_line_id,

Line 5336: INSERT INTO psp_distribution_lines_history

5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);
5333:
5334:
5335: -- move the transferred records to psp_distribution_lines_history
5336: INSERT INTO psp_distribution_lines_history
5337: (distribution_line_id,payroll_sub_line_id,distribution_date,
5338: effective_date,distribution_amount,status_code,suspense_reason_code,
5339: effort_report_id,version_num,schedule_line_id,summary_line_id,
5340: default_org_account_id,suspense_org_account_id,

Line 5365: FROM psp_distribution_lines

5361: cap_excess_glccid, cap_excess_award_id, cap_excess_task_id,
5362: cap_excess_project_id, cap_excess_exp_type, cap_excess_exp_org_id,
5363: funding_source_code, annual_salary_cap, cap_excess_dist_line_id,
5364: suspense_auto_exp_type, suspense_auto_glccid, adj_account_flag
5365: FROM psp_distribution_lines
5366: WHERE status_code = 'A'
5367: AND summary_line_id = l_summary_line_id;
5368:
5369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference

Line 5369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference

5365: FROM psp_distribution_lines
5366: WHERE status_code = 'A'
5367: AND summary_line_id = l_summary_line_id;
5368:
5369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference
5370: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
5371:
5372: DELETE FROM psp_distribution_lines
5373: WHERE status_code = 'A'

Line 5372: DELETE FROM psp_distribution_lines

5368:
5369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference
5370: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
5371:
5372: DELETE FROM psp_distribution_lines
5373: WHERE status_code = 'A'
5374: AND summary_line_id = l_summary_line_id;
5375: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from psp_distribution_lines for summary_line_id: '||l_orig_trx_reference
5376: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);

Line 5375: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from psp_distribution_lines for summary_line_id: '||l_orig_trx_reference

5371:
5372: DELETE FROM psp_distribution_lines
5373: WHERE status_code = 'A'
5374: AND summary_line_id = l_summary_line_id;
5375: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from psp_distribution_lines for summary_line_id: '||l_orig_trx_reference
5376: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
5377:
5378: -- Moved the purging of xface lines from here below LOOP, for Bug 2445196
5379: ELSIF p_source_type = 'P' THEN

Line 5424: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from psp_distribution_lines for summary_line_id: '||l_orig_trx_reference

5420:
5421: DELETE FROM psp_pre_gen_dist_lines
5422: WHERE status_code = 'A'
5423: AND summary_line_id = l_summary_line_id;
5424: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from psp_distribution_lines for summary_line_id: '||l_orig_trx_reference
5425: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
5426:
5427: --Moved delete xface stmnts from here to below for bug 2445196:
5428: END IF;

Line 5777: Psp_distribution_lines_history DLH,

5773: Select per.effort_report_id,
5774: per.person_id,
5775: MIN(dlh.summary_line_id) summary_line_id
5776: From psp_eff_reports per,
5777: Psp_distribution_lines_history DLH,
5778: Psp_payroll_controls ppc,
5779: psp_payroll_sub_lines psub,
5780: psp_payroll_lines ppl
5781: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id

Line 5821: Psp_distribution_lines_history DLH,

5817: Select per.effort_report_id,
5818: per.person_id,
5819: dlh.summary_line_id summary_line_id
5820: From psp_eff_reports per,
5821: Psp_distribution_lines_history DLH,
5822: Psp_payroll_controls ppc,
5823: psp_payroll_sub_lines psub,
5824: psp_payroll_lines ppl
5825: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id

Line 5970: Psp_distribution_lines_history DLH,

5966: Select per.effort_report_id,
5967: per.person_id,
5968: MIN(dlh.summary_line_id) summary_line_id
5969: From psp_eff_reports per,
5970: Psp_distribution_lines_history DLH,
5971: Psp_payroll_controls ppc,
5972: psp_payroll_sub_lines psub,
5973: psp_payroll_lines ppl,
5974: psp_eff_report_details perd

Line 6018: Psp_distribution_lines_history DLH,

6014: Select per.effort_report_id,
6015: per.person_id,
6016: dlh.summary_line_id summary_line_id
6017: From psp_eff_reports per,
6018: Psp_distribution_lines_history DLH,
6019: Psp_payroll_controls ppc,
6020: psp_payroll_sub_lines psub,
6021: psp_payroll_lines ppl,
6022: psp_eff_report_details perd