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_SUMMARY_LINES

Line 424: from psp_summary_lines

420:
421: if (payroll_control_rec.phase = 'Submitted_TI_Request') then
422: select max(gms_batch_name)
423: into l_gms_batch_name
424: from psp_summary_lines
425: where payroll_control_id = payroll_control_rec.payroll_control_id;
426:
427: select count(*)
428: into l_ti_not_complete

Line 567: DELETE FROM psp_summary_lines

563: If l_line_counter = 0 then
564:
565: /* commented for 2445196
566: -- delete any rejected summary lines
567: DELETE FROM psp_summary_lines
568: WHERE payroll_control_id = payroll_control_rec.payroll_control_id
569: AND status_code = 'R';
570: */
571:

Line 599: DELETE FROM psp_summary_lines

595: WHERE ppgd.payroll_control_id = payroll_control_rec.payroll_control_id;
596:
597: IF l_line_counter = 0 THEN
598: /* commented for 2445196
599: DELETE FROM psp_summary_lines
600: WHERE payroll_control_id = payroll_control_rec.payroll_control_id
601: AND status_code = 'R';
602: */
603:

Line 1180: SELECT PSP_SUMMARY_LINES_S.NEXTVAL

1176: psp_general.get_gms_effective_date(p_person_id,l_gms_posting_effective_date);
1177: END IF;
1178: -- Code ended for Enhancement Employee Assignment with Zero Work Days
1179:
1180: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
1181: INTO P_SUMMARY_LINE_ID
1182: FROM DUAL;
1183: INSERT INTO PSP_SUMMARY_LINES(
1184: SUMMARY_LINE_ID,

Line 1183: INSERT INTO PSP_SUMMARY_LINES(

1179:
1180: SELECT PSP_SUMMARY_LINES_S.NEXTVAL
1181: INTO P_SUMMARY_LINE_ID
1182: FROM DUAL;
1183: INSERT INTO PSP_SUMMARY_LINES(
1184: SUMMARY_LINE_ID,
1185: PERSON_ID,
1186: ASSIGNMENT_ID,
1187: TIME_PERIOD_ID,

Line 1369: FROM psp_summary_lines psl

1365: psl.attribute27,
1366: psl.attribute28,
1367: psl.attribute29,
1368: psl.attribute30
1369: FROM psp_summary_lines psl
1370: WHERE psl.status_code = 'N'
1371: AND psl.gl_code_combination_id IS NOT NULL
1372: AND psl.payroll_control_id = l_payroll_control_id;
1373:

Line 1474: -- update psp_summary_lines with group_id

1470:
1471: LOOP
1472: FETCH gl_payroll_control_cursor INTO gl_payroll_control_rec;
1473: EXIT WHEN gl_payroll_control_cursor%NOTFOUND;
1474: -- update psp_summary_lines with group_id
1475:
1476: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' update psp_summary_lines with group_id : '||l_group_id);
1477:
1478: UPDATE psp_summary_lines

Line 1476: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' update psp_summary_lines with group_id : '||l_group_id);

1472: FETCH gl_payroll_control_cursor INTO gl_payroll_control_rec;
1473: EXIT WHEN gl_payroll_control_cursor%NOTFOUND;
1474: -- update psp_summary_lines with group_id
1475:
1476: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' update psp_summary_lines with group_id : '||l_group_id);
1477:
1478: UPDATE psp_summary_lines
1479: SET group_id = l_group_id
1480: WHERE status_code = 'N'

Line 1478: UPDATE psp_summary_lines

1474: -- update psp_summary_lines with group_id
1475:
1476: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' update psp_summary_lines with group_id : '||l_group_id);
1477:
1478: UPDATE psp_summary_lines
1479: SET group_id = l_group_id
1480: WHERE status_code = 'N'
1481: AND gl_code_combination_id IS NOT NULL
1482: AND payroll_control_id = gl_payroll_control_rec.payroll_control_id;

Line 1551: from psp_summary_lines

1547:
1548: else --- 2444657 ...phase = Submitted_JI_Request
1549: select group_id
1550: into l_group_id
1551: from psp_summary_lines
1552: where payroll_control_id in
1553: (SELECT payroll_control_id
1554: FROM psp_payroll_controls
1555: WHERE source_type = gl_batch_rec.source_type

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 1815: FROM psp_summary_lines

1811: p_return_status OUT NOCOPY VARCHAR2) IS
1812: CURSOR gl_tie_back_success_cur IS
1813: SELECT summary_line_id,
1814: dr_cr_flag,summary_amount
1815: FROM psp_summary_lines
1816: WHERE group_id = p_group_id
1817: AND payroll_control_id = p_payroll_control_id;
1818:
1819: CURSOR gl_tie_back_reject_cur IS

Line 1826: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

1822: FROM gl_interface
1823: WHERE group_id = p_group_id
1824: AND set_of_books_id = p_set_of_books_id
1825: AND user_je_source_name = 'OLD'
1826: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
1827: WHERE GROUP_ID = p_group_id
1828: AND payroll_control_id = p_payroll_control_id);
1829:
1830:

Line 2032: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

2028: from gl_interface
2029: where status = 'NEW'
2030: and group_id = p_group_id
2031: and user_je_source_name = 'OLD'
2032: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
2033: WHERE GROUP_ID = p_group_id
2034: AND payroll_control_id = p_payroll_control_id);
2035:
2036: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_no_run: '||l_no_run);

Line 2043: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

2039:
2040: delete from gl_interface
2041: where group_id = p_group_id
2042: and user_je_source_name = 'OLD'
2043: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
2044: WHERE GROUP_ID = p_group_id
2045: AND payroll_control_id = p_payroll_control_id);
2046:
2047: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface count: '||sql%rowcount);

Line 2050: delete from psp_summary_lines

2046:
2047: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface count: '||sql%rowcount);
2048:
2049:
2050: delete from psp_summary_lines
2051: where payroll_control_id = p_payroll_control_id
2052: and group_id = p_group_id;
2053: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from psp_summary_lines count: '||sql%rowcount);
2054:

Line 2053: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from psp_summary_lines count: '||sql%rowcount);

2049:
2050: delete from psp_summary_lines
2051: where payroll_control_id = p_payroll_control_id
2052: and group_id = p_group_id;
2053: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from psp_summary_lines count: '||sql%rowcount);
2054:
2055: --- bug 4328598 -- fix begin
2056:
2057: -- get the source name

Line 2098: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

2094: FROM gl_interface
2095: WHERE group_id = p_group_id
2096: AND user_je_source_name = 'OLD'
2097: AND set_of_books_id = p_set_of_books_id
2098: AND reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
2099: WHERE GROUP_ID = p_group_id
2100: AND payroll_control_id = p_payroll_control_id);
2101:
2102:

Line 2121: UPDATE psp_summary_lines

2117: CLOSE gl_tie_back_reject_cur;
2118: EXIT;
2119: END IF;
2120: -- update summary_lines with the reject status code
2121: UPDATE psp_summary_lines
2122: SET interface_status = l_status, status_code = 'R'
2123: WHERE summary_line_id = to_number(l_reference6);
2124:
2125: OPEN assign_susp_ac_cur(to_number(l_reference6));

Line 2177: from psp_summary_lines where summary_line_id = to_number(l_reference6);

2173: l_reversal_ac_failed := 'Y';
2174:
2175: if x_lines_glccid is null then
2176: select gl_code_combination_id into x_lines_glccid
2177: from psp_summary_lines where summary_line_id = to_number(l_reference6);
2178: end if;
2179:
2180: ELSE
2181:

Line 2390: and reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898

2386: delete gl_interface
2387: where group_id = p_group_id
2388: and set_of_books_id = p_set_of_books_id
2389: AND user_je_source_name = l_user_je_source_name
2390: and reference6 in(select summary_line_id FROM psp_summary_lines -- Bug 7376898
2391: WHERE GROUP_ID = p_group_id
2392: AND payroll_control_id = p_payroll_control_id);
2393: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gl_interface count: '||sql%rowcount);
2394:

Line 2412: FROM psp_summary_lines

2408: p_period_end_date,distribution_date)
2409: WHERE suspense_reason_code like 'ST:%'
2410: AND summary_line_id
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);

Line 2428: FROM psp_summary_lines

2424: p_period_end_date,distribution_date)
2425: WHERE suspense_reason_code like 'ST:%'
2426: AND summary_line_id
2427: IN (SELECT summary_line_id
2428: FROM psp_summary_lines
2429: WHERE payroll_control_id = p_payroll_control_id);
2430: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 2 updated psp_pre_gen_dist_lines count: '||sql%rowcount);
2431: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_effective_date: '||l_effective_date);
2432:

Line 2481: FROM psp_summary_lines

2477: p_period_end_date,distribution_date)
2478: WHERE suspense_reason_code like 'ST:%'
2479: AND summary_line_id
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);

Line 2496: FROM psp_summary_lines

2492: p_period_end_date,distribution_date)
2493: WHERE suspense_reason_code like 'ST:%'
2494: AND summary_line_id
2495: IN ( SELECT summary_line_id
2496: FROM psp_summary_lines
2497: WHERE payroll_control_id = p_payroll_control_id );
2498:
2499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 3 updated psp_pre_gen_dist_lines count: '||sql%rowcount);
2500: --fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_effective_date: '||l_effective_date);

Line 2569: -- update records in psp_summary_lines as 'A'

2565: IF gl_tie_back_success_cur%NOTFOUND THEN
2566: CLOSE gl_tie_back_success_cur;
2567: EXIT;
2568: END IF;
2569: -- update records in psp_summary_lines as 'A'
2570: UPDATE psp_summary_lines
2571: SET status_code = 'A'
2572: WHERE summary_line_id = l_summary_line_id;
2573:

Line 2570: UPDATE psp_summary_lines

2566: CLOSE gl_tie_back_success_cur;
2567: EXIT;
2568: END IF;
2569: -- update records in psp_summary_lines as 'A'
2570: UPDATE psp_summary_lines
2571: SET status_code = 'A'
2572: WHERE summary_line_id = l_summary_line_id;
2573:
2574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_summary_lines set status_code = A count: '||sql%rowcount);

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

2570: UPDATE psp_summary_lines
2571: SET status_code = 'A'
2572: WHERE summary_line_id = l_summary_line_id;
2573:
2574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_summary_lines set status_code = A count: '||sql%rowcount);
2575:
2576: IF l_dr_cr_flag = 'D' THEN
2577: l_dr_summary_amount := l_dr_summary_amount + l_summary_amount;
2578: ELSIF l_dr_cr_flag = 'C' THEN

Line 3705: FROM psp_summary_lines psl

3701: psl.attribute8,
3702: psl.attribute9,
3703: psl.attribute10,
3704: org_id
3705: FROM psp_summary_lines psl
3706: WHERE psl.status_code = 'N'
3707: AND psl.gl_code_combination_id IS NULL
3708: AND psl.payroll_control_id = p_payroll_control_id;
3709:

Line 3762: FROM psp_summary_lines psl

3758:
3759:
3760: Cursor operating_unit_csr(p_payroll_control_id IN NUMBER) IS -- change
3761: SELECT Distinct org_id
3762: FROM psp_summary_lines psl
3763: WHERE psl.status_code = 'N'
3764: AND psl.gl_code_combination_id IS NULL
3765: AND psl.payroll_control_id = p_payroll_control_id;
3766:

Line 3863: -- update psp_summary_lines with gms batch name

3859: INTO l_gms_batch_name
3860: FROM dual;
3861: */
3862: -- R12 MOAC Uptake. Moved this code to loop
3863: -- update psp_summary_lines with gms batch name
3864: FOR I in 1..org_id_tab.count
3865: LOOP
3866: UPDATE psp_summary_lines
3867: SET gms_batch_name = gms_batch_name_tab(i) -- R12 MOAC uptake. changed from l_gms_batch_name

Line 3866: UPDATE psp_summary_lines

3862: -- R12 MOAC Uptake. Moved this code to loop
3863: -- update psp_summary_lines with gms batch name
3864: FOR I in 1..org_id_tab.count
3865: LOOP
3866: UPDATE psp_summary_lines
3867: SET gms_batch_name = gms_batch_name_tab(i) -- R12 MOAC uptake. changed from l_gms_batch_name
3868: WHERE payroll_control_id = gms_batch_rec.payroll_control_id
3869: AND status_code = 'N'
3870: AND gl_code_combination_id IS NULL

Line 3873: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_summary_lines set status_code for org_id'||org_id_tab(i)||' to N count: '||sql%rowcount);

3869: AND status_code = 'N'
3870: AND gl_code_combination_id IS NULL
3871: AND org_id = org_id_tab(i); -- R12 MOAC uptake
3872:
3873: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_summary_lines set status_code for org_id'||org_id_tab(i)||' to N count: '||sql%rowcount);
3874:
3875: END LOOP;
3876:
3877:

Line 4148: from psp_summary_lines

4144: for i in 1..org_id_tab.count
4145: loop
4146: select gms_batch_name
4147: into gms_batch_name_tab(i) -- change
4148: from psp_summary_lines
4149: where payroll_control_id = gms_batch_rec.payroll_control_id
4150: and org_id = org_id_tab(i)
4151: and project_id is not null
4152: and rownum = 1;

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 4313: FROM psp_summary_lines

4309: p_return_status OUT NOCOPY VARCHAR2) IS
4310: CURSOR gms_tie_back_success_cur IS
4311: SELECT summary_line_id,
4312: dr_cr_flag,summary_amount
4313: FROM psp_summary_lines
4314: WHERE gms_batch_name = p_gms_batch_name;
4315:
4316:
4317: CURSOR gms_tie_back_reject_cur IS

Line 4532: From PSP_SUMMARY_LINES PSL

4528: summary_lines_rec SUMMARY_LINES_TYPE;
4529:
4530: Cursor SUMMARY_LINES_csr IS
4531: Select SUMMARY_LINE_ID, to_CHAR(SUMMARY_LINE_ID) , GMS_BATCH_NAME
4532: From PSP_SUMMARY_LINES PSL
4533: where PSL.GMS_BATCH_NAME = p_gms_batch_name;
4534: -- Bug 4369939: Performance fix END
4535:
4536:

Line 4591: delete from psp_summary_lines

4587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gms_transaction_interface_all count:'||sql%rowcount);
4588:
4589: end if;
4590:
4591: delete from psp_summary_lines
4592: where gms_batch_name = to_number(p_gms_batch_name)
4593: and payroll_control_id = p_payroll_control_id;
4594: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from psp_summary_lines count:'||sql%rowcount);
4595:

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

4590:
4591: delete from psp_summary_lines
4592: where gms_batch_name = to_number(p_gms_batch_name)
4593: and payroll_control_id = p_payroll_control_id;
4594: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from psp_summary_lines count:'||sql%rowcount);
4595:
4596:
4597:
4598: elsif (get_completion_rec.transaction_status_code = 'I' AND -- change

Line 4686: UPDATE psp_summary_lines

4682: -- update summary_lines with the reject status code
4683: IF l_trx_status_code in ('R', 'PO', 'PI', 'PR') THEN
4684: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' status_code in R, PO,PI,PR');
4685:
4686: UPDATE psp_summary_lines
4687: SET interface_status = l_trx_reject_code, status_code = 'R',
4688: expenditure_ending_date = l_expenditure_ending_date, -- added 5 fields for 2445196
4689: expenditure_id = l_expenditure_id, interface_id=l_interface_id,
4690: expenditure_item_id=l_expenditure_item_id, txn_interface_id=l_txn_interface_id

Line 4692: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_summary_lines for rejected records count: '||sql%rowcount);

4688: expenditure_ending_date = l_expenditure_ending_date, -- added 5 fields for 2445196
4689: expenditure_id = l_expenditure_id, interface_id=l_interface_id,
4690: expenditure_item_id=l_expenditure_item_id, txn_interface_id=l_txn_interface_id
4691: WHERE summary_line_id = to_number(l_orig_trx_reference);
4692: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_summary_lines for rejected records count: '||sql%rowcount);
4693:
4694: ELSIF l_trx_status_code = 'A' THEN
4695: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' status_code A');
4696:

Line 4697: UPDATE psp_summary_lines

4693:
4694: ELSIF l_trx_status_code = 'A' THEN
4695: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' status_code A');
4696:
4697: UPDATE psp_summary_lines
4698: SET interface_status = l_trx_reject_code, status_code = 'A',
4699: expenditure_ending_date = l_expenditure_ending_date, -- added 5 fields for 2445196
4700: expenditure_id = l_expenditure_id, interface_id=l_interface_id,
4701: expenditure_item_id=l_expenditure_item_id, txn_interface_id=l_txn_interface_id

Line 4704: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_summary_lines for accepted records count: '||sql%rowcount);

4700: expenditure_id = l_expenditure_id, interface_id=l_interface_id,
4701: expenditure_item_id=l_expenditure_item_id, txn_interface_id=l_txn_interface_id
4702: WHERE summary_line_id = to_number(l_orig_trx_reference);
4703:
4704: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_summary_lines for accepted records count: '||sql%rowcount);
4705:
4706: SELECT summary_amount,dr_cr_flag
4707: INTO l_summary_amount,l_dr_cr_flag
4708: FROM psp_summary_lines

Line 4708: FROM psp_summary_lines

4704: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_summary_lines for accepted records count: '||sql%rowcount);
4705:
4706: SELECT summary_amount,dr_cr_flag
4707: INTO l_summary_amount,l_dr_cr_flag
4708: FROM psp_summary_lines
4709: WHERE summary_line_id = to_number(l_orig_trx_reference) ;
4710: hr_utility.trace('entered gms_tie_back4');
4711: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered gms_tie_back4');
4712:

Line 5158: FROM psp_summary_lines

5154: p_period_end_date,distribution_date)
5155: WHERE suspense_reason_code like 'ST:%'
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

Line 5173: FROM psp_summary_lines

5169: p_period_end_date,distribution_date)
5170: WHERE suspense_reason_code like 'ST:%'
5171: AND summary_line_id
5172: IN (SELECT summary_line_id
5173: FROM psp_summary_lines
5174: WHERE payroll_control_id = p_payroll_control_id);
5175: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_pre_gen_dist_lines count: '||sql%rowcount);
5176:
5177:

Line 5217: FROM psp_summary_lines

5213: suspense_reason_code = NULL
5214: WHERE suspense_reason_code like 'ST:%'
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

Line 5231: FROM psp_summary_lines

5227: suspense_reason_code = NULL
5228: WHERE suspense_reason_code like 'ST:%'
5229: AND summary_line_id
5230: IN( SELECT summary_line_id
5231: FROM psp_summary_lines
5232: WHERE payroll_control_id = p_payroll_control_id);
5233: END IF;
5234: /* End of Bug 3065866 */
5235:

Line 5274: UPDATE PSP_SUMMARY_LINES PSL

5270: CLOSE SUMMARY_LINES_CSR;
5271:
5272: FOR i in 1.. SUMMARY_LINES_REC.L_SUMMARY_LINE_ID.count
5273: LOOP
5274: UPDATE PSP_SUMMARY_LINES PSL
5275: Set (PSL.STATUS_CODE, PSL.EXPENDITURE_ENDING_DATE,PSL.EXPENDITURE_ID,
5276: PSL.INTERFACE_ID,PSL.EXPENDITURE_ITEM_ID,PSL.TXN_INTERFACE_ID) =
5277: ( SELECT 'A', PTXN.EXPENDITURE_ENDING_DATE,PTXN.EXPENDITURE_ID, PTXN.INTERFACE_ID,
5278: PTXN.EXPENDITURE_ITEM_ID,PTXN.TXN_INTERFACE_ID

Line 5287: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_summary_lines table SQL%ROWCOUNT: '||SQL%ROWCOUNT);

5283: )
5284: WHERE --GMS_BATCH_NAME = SUMMARY_LINES_REC.L_GMS_BATCH_NAME(i) AND
5285: PSL.SUMMARY_LINE_ID = SUMMARY_LINES_REC.L_SUMMARY_LINE_ID(i);
5286:
5287: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_summary_lines table SQL%ROWCOUNT: '||SQL%ROWCOUNT);
5288: END LOOP;
5289:
5290: /*
5291: -- changed to update all sum lines at one shot for 2445196

Line 5292: UPDATE psp_summary_lines PSL

5288: END LOOP;
5289:
5290: /*
5291: -- changed to update all sum lines at one shot for 2445196
5292: UPDATE psp_summary_lines PSL
5293: SET (PSL.status_code, PSL.expenditure_ending_date,PSL.expenditure_id,
5294: PSL.interface_id,PSL.expenditure_item_id,PSL.txn_interface_id) =
5295: (select 'A', PTXN.expenditure_ending_date,PTXN.expenditure_id,
5296: PTXN.interface_id,PTXN.expenditure_item_id,PTXN.txn_interface_id

Line 5317: -- update records in psp_summary_lines as 'A' moved this stmnt from here to above for 2445196.

5313: CLOSE gms_tie_back_success_cur;
5314: EXIT;
5315: END IF;
5316: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Summary line id: '||l_summary_line_id);
5317: -- update records in psp_summary_lines as 'A' moved this stmnt from here to above for 2445196.
5318:
5319: IF l_dr_cr_flag = 'D' THEN
5320: l_dr_summary_amount := l_dr_summary_amount + l_summary_amount;
5321: ELSIF l_dr_cr_flag = 'C' THEN

Line 6095: psp_summary_lines psl

6091: group by person_id,effort_report_id;
6092: cursor check_emp_overlap is
6093: select count(*)
6094: from psp_Eff_reports per,
6095: psp_summary_lines psl
6096: where per.person_id = psl.person_id
6097: and psl.payroll_control_id in
6098: (select payroll_control_id
6099: from psp_payroll_controls