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.

[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on PSP_PAYROLL_CONTROLS

Line 250: FROM psp_payroll_controls ppc,

246: p_return_status OUT NOCOPY VARCHAR2) IS
247: --- replaced p_run_type with g_run_type for 244657
248: CURSOR pc_batch_cur IS
249: SELECT distinct ppc.batch_name
250: FROM psp_payroll_controls ppc,
251: psp_adjustment_control_table pact
252: WHERE ppc.status_code = decode(g_run_type, 'N', 'N', 'R', 'I')
253: AND ppc.source_type = 'A'
254: AND ppc.batch_name = pact.adjustment_batch_name

Line 273: FROM psp_payroll_controls

269: payroll_source_code,
270: time_period_id,
271: batch_name,
272: gms_phase
273: FROM psp_payroll_controls
274: WHERE source_type = 'A'
275: AND ((adj_sum_batch_name is null) OR
276: (adj_sum_batch_name is not null and run_id is not null))
277: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)

Line 286: from psp_payroll_controls

282:
283: --- added cursor for 2444657
284: CURSOR derive_run_mode IS
285: select decode(count(*), 0, 'N', 'R')
286: from psp_payroll_controls
287: where source_type = 'A'
288: and adj_sum_batch_name = p_adj_sum_batch_name
289: and status_code = 'I';
290:

Line 293: FROM psp_payroll_controls

289: and status_code = 'I';
290:
291: CURSOR batch_name_exist_cur IS
292: SELECT count(*)
293: FROM psp_payroll_controls
294: WHERE adj_sum_batch_name = p_adj_sum_batch_name
295: AND source_type = 'A' -- Bug 2133056
296: AND g_run_type <> 'R';
297:

Line 379: UPDATE psp_payroll_controls

375: CLOSE payroll_control_cur;
376: EXIT;
377: else
378: if g_run_type = 'N' then
379: UPDATE psp_payroll_controls
380: SET status_code = 'I',
381: adj_sum_batch_name = p_adj_sum_batch_name,
382: run_id = g_run_id
383: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;

Line 384: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' IF updated psp_payroll_controls count: '||SQL%rowcount);

380: SET status_code = 'I',
381: adj_sum_batch_name = p_adj_sum_batch_name,
382: run_id = g_run_id
383: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
384: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' IF updated psp_payroll_controls count: '||SQL%rowcount);
385:
386: else
387: UPDATE psp_payroll_controls
388: SET run_id = g_run_id

Line 387: UPDATE psp_payroll_controls

383: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
384: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' IF updated psp_payroll_controls count: '||SQL%rowcount);
385:
386: else
387: UPDATE psp_payroll_controls
388: SET run_id = g_run_id
389: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
390: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' ELSE updated psp_payroll_controls count: '||SQL%rowcount);
391:

Line 390: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' ELSE updated psp_payroll_controls count: '||SQL%rowcount);

386: else
387: UPDATE psp_payroll_controls
388: SET run_id = g_run_id
389: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
390: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' ELSE updated psp_payroll_controls count: '||SQL%rowcount);
391:
392: end if;
393: end if;
394:

Line 414: FROM psp_payroll_controls

410: p_return_status OUT NOCOPY VARCHAR2) IS
411:
412: CURSOR pc_batch_cur IS
413: SELECT distinct batch_name
414: FROM psp_payroll_controls
415: WHERE source_type = 'A'
416: AND adj_sum_batch_name = p_adj_sum_batch_name
417: AND (dist_dr_amount is not null or dist_cr_amount is not null)
418: -- AND (gl_phase = 'GL_Tie_Back' OR gms_phase = 'GMS_Tie_Back') : Bug 1776606 : Commented out

Line 437: FROM psp_payroll_controls

433: time_period_id,
434: batch_name,
435: gl_phase,
436: gms_phase
437: FROM psp_payroll_controls
438: WHERE source_type = 'A'
439: AND batch_name = p_batch_name
440: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
441: AND status_code = 'I'

Line 513: FROM psp_payroll_controls

509: -- WHERE batch_name = g_gms_batch_name
510: WHERE batch_name IN (SELECT GMS_BATCH_NAME
511: FROM psp_summary_lines
512: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id
513: FROM psp_payroll_controls
514: WHERE adj_sum_batch_name =p_adj_sum_batch_name))
515: ---AND transaction_status_code = 'A' delete 'R' also, for 2445196
516: AND transaction_source in ('OLD', 'GOLD');
517:

Line 526: FROM psp_payroll_controls

522: -- where batch_name = g_gms_batch_name
523: WHERE batch_name IN (SELECT GMS_BATCH_NAME
524: FROM psp_summary_lines
525: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id
526: FROM psp_payroll_controls
527: WHERE adj_sum_batch_name =p_adj_sum_batch_name))
528: and transaction_source = 'GOLD';
529:
530: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' delete from gms_transaction_interface_all count : '||sql%rowcount);

Line 565: UPDATE psp_payroll_controls

561:
562: CLOSE adj_lines_cur;
563:
564: IF (l_sum_count =0) and (l_adj_count =0) THEN
565: UPDATE psp_payroll_controls
566: SET status_code = 'P'
567: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
568: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' UPDATE psp_payroll_controls status_code P count: '||sql%rowcount);
569:

Line 568: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' UPDATE psp_payroll_controls status_code P count: '||sql%rowcount);

564: IF (l_sum_count =0) and (l_adj_count =0) THEN
565: UPDATE psp_payroll_controls
566: SET status_code = 'P'
567: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
568: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' UPDATE psp_payroll_controls status_code P count: '||sql%rowcount);
569:
570: END IF;
571:
572: END LOOP;

Line 595: FROM psp_payroll_controls

591: p_return_status OUT NOCOPY VARCHAR2) IS
592:
593: CURSOR pc_batch_cur IS
594: SELECT distinct batch_name
595: FROM psp_payroll_controls
596: WHERE source_type = 'A'
597: AND status_code = 'I'
598: AND run_id = nvl(g_run_id, run_id)
599: AND gl_phase is null

Line 614: FROM psp_payroll_controls

610: payroll_source_code,
611: time_period_id,
612: batch_name,
613: gl_posting_override_date
614: FROM psp_payroll_controls
615: WHERE batch_name = p_batch_name
616: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
617: AND source_type = 'A'
618: AND status_code = 'I'

Line 793: update psp_payroll_controls

789: FETCH gl_sum_lines_cursor INTO gl_sum_lines_rec;
790: l_rec_count := l_rec_count + 1;
791: IF gl_sum_lines_cursor%NOTFOUND THEN
792: if (l_rec_count > 1) then
793: update psp_payroll_controls
794: set gl_phase = 'Summarize_GL_Lines'
795: where payroll_control_id = payroll_control_rec.payroll_control_id;
796: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updating psp_payroll_controls gl_phase to Summarize_GL_Lines for control_id: '||payroll_control_rec.payroll_control_id);
797:

Line 796: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updating psp_payroll_controls gl_phase to Summarize_GL_Lines for control_id: '||payroll_control_rec.payroll_control_id);

792: if (l_rec_count > 1) then
793: update psp_payroll_controls
794: set gl_phase = 'Summarize_GL_Lines'
795: where payroll_control_id = payroll_control_rec.payroll_control_id;
796: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updating psp_payroll_controls gl_phase to Summarize_GL_Lines for control_id: '||payroll_control_rec.payroll_control_id);
797:
798: end if;
799: CLOSE gl_sum_lines_cursor;
800: EXIT;

Line 1188: FROM psp_payroll_controls

1184: p_return_status OUT NOCOPY VARCHAR2) IS
1185:
1186: CURSOR pc_batch_cur IS
1187: SELECT distinct batch_name
1188: FROM psp_payroll_controls
1189: WHERE adj_sum_batch_name = p_adj_sum_batch_name
1190: AND source_type = 'A'
1191: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
1192: AND status_code = 'I'

Line 1207: FROM psp_payroll_controls

1203: time_period_id,
1204: batch_name,
1205: -- Introduced for bug fix 2916848
1206: currency_code
1207: FROM psp_payroll_controls
1208: WHERE batch_name = p_batch_name
1209: AND source_type = 'A'
1210: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
1211: AND status_code = 'I'

Line 1527: update psp_payroll_controls

1523: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');
1524: fnd_msg_pub.add;
1525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1526: ELSE
1527: update psp_payroll_controls
1528: set gl_phase = 'Submitted_Import_Request'
1529: --where payroll_control_id = gl_batch_rec.payroll_control_id; Replaced this line for Bug 2133056
1530: where source_type = 'A'
1531: and batch_name = pc_batch_rec.batch_name;

Line 1659: FROM psp_payroll_controls

1655: p_return_status OUT NOCOPY VARCHAR2) IS
1656:
1657: CURSOR pc_batch_cur IS
1658: SELECT distinct batch_name
1659: FROM psp_payroll_controls
1660: WHERE adj_sum_batch_name = p_adj_sum_batch_name
1661: AND (dist_dr_amount is not null and dist_cr_amount is not null)
1662: AND source_type = 'A'
1663: AND status_code = 'I'

Line 1687: FROM psp_payroll_controls

1683:
1684: CURSOR gl_tie_back_cur(p_batch_name IN VARCHAR2) IS
1685: SELECT payroll_control_id,
1686: source_type
1687: FROM psp_payroll_controls
1688: WHERE batch_name = p_batch_name
1689: AND (dist_dr_amount is not null and dist_cr_amount is not null)
1690: AND source_type = 'A'
1691: AND status_code = 'I'

Line 1749: psp_payroll_controls PPC

1745: -- Included the following cursors here for accessing local varibales for bug fix 1765678
1746: CURSOR summary_group_cur IS
1747: SELECT PSL.group_id
1748: FROM psp_summary_lines PSL,
1749: psp_payroll_controls PPC
1750: WHERE PPC.payroll_control_id = PSL.payroll_control_id
1751: -- WHERE payroll_control_id = gl_tie_back_rec.payroll_control_id
1752: AND PPC.batch_name = pc_batch_rec.batch_name
1753: AND PPC.source_type = 'A'

Line 1807: update psp_payroll_controls

1803: END IF;
1804: CLOSE gl_interface_status_cur;
1805:
1806: if l_status_new > 0 then
1807: update psp_payroll_controls
1808: set gl_phase = 'Summarize_GL_Lines'
1809: where gl_phase = 'Submitted_Import_Request'
1810: and batch_name = pc_batch_rec.batch_name; --- 3184075
1811: ---and adj_sum_batch_name = p_adj_sum_batch_name;

Line 1812: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updating psp_payroll_controls gl_phase to

1808: set gl_phase = 'Summarize_GL_Lines'
1809: where gl_phase = 'Submitted_Import_Request'
1810: and batch_name = pc_batch_rec.batch_name; --- 3184075
1811: ---and adj_sum_batch_name = p_adj_sum_batch_name;
1812: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updating psp_payroll_controls gl_phase to
1813: Summarize_GL_Lines for batch_name: '||pc_batch_rec.batch_name||' count: '||sql%rowcount);
1814:
1815:
1816: delete from gl_interface

Line 1844: UPDATE psp_payroll_controls

1840: IF gl_tie_back_cur%NOTFOUND then
1841: CLOSE gl_tie_back_cur;
1842: EXIT;
1843: END IF;
1844: UPDATE psp_payroll_controls
1845: SET gl_phase = 'GL_Tie_Back'
1846: WHERE payroll_control_id = gl_tie_back_rec.payroll_control_id;
1847: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_payroll_controls set gl_phase to GL_Tie_Back count: '||sql%rowcount||' for control_id : '||gl_tie_back_rec.payroll_control_id);
1848:

Line 1847: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_payroll_controls set gl_phase to GL_Tie_Back count: '||sql%rowcount||' for control_id : '||gl_tie_back_rec.payroll_control_id);

1843: END IF;
1844: UPDATE psp_payroll_controls
1845: SET gl_phase = 'GL_Tie_Back'
1846: WHERE payroll_control_id = gl_tie_back_rec.payroll_control_id;
1847: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_payroll_controls set gl_phase to GL_Tie_Back count: '||sql%rowcount||' for control_id : '||gl_tie_back_rec.payroll_control_id);
1848:
1849:
1850: -- Replaced the earlier 'select stmt.' code with new 'cursor' code for bug fix 1765678
1851:

Line 1946: UPDATE psp_payroll_controls

1942: psp_adjustment_lines_history then deleted from psp_adjustment_lines for summary_line_id : '||l_summary_line_id);
1943:
1944: END LOOP;
1945:
1946: UPDATE psp_payroll_controls
1947: SET gl_dr_amount = nvl(gl_dr_amount,0) + l_dr_summary_amount,
1948: gl_cr_amount = nvl(gl_cr_amount,0) + l_cr_summary_amount
1949: WHERE payroll_control_id = gl_tie_back_rec.payroll_control_id;
1950:

Line 1951: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_payroll_controls set gl_dr_amount and gl_cr_amount for cotrol_id : '||gl_tie_back_rec.payroll_control_id);

1947: SET gl_dr_amount = nvl(gl_dr_amount,0) + l_dr_summary_amount,
1948: gl_cr_amount = nvl(gl_cr_amount,0) + l_cr_summary_amount
1949: WHERE payroll_control_id = gl_tie_back_rec.payroll_control_id;
1950:
1951: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_payroll_controls set gl_dr_amount and gl_cr_amount for cotrol_id : '||gl_tie_back_rec.payroll_control_id);
1952:
1953:
1954: END IF;
1955: END LOOP; -- end loop for gl_tie_back_cur

Line 2066: FROM psp_payroll_controls

2062: (l_control_rec_credit <> l_control_rec_debit) then /* Bug 1977893 */
2063: IF p_source_type = 'A' THEN
2064:
2065: SELECT payroll_id INTO l_payroll_id
2066: FROM psp_payroll_controls
2067: WHERE payroll_control_id = p_payroll_control_id;
2068:
2069: BEGIN
2070: -- Replaced the earlier 'select stmt.' code with new 'cursor' code , inserted new code for bug fix 1765678

Line 2368: FROM psp_payroll_controls

2364: p_return_status OUT NOCOPY VARCHAR2) IS
2365:
2366: CURSOR pc_batch_cur IS
2367: SELECT distinct batch_name
2368: FROM psp_payroll_controls
2369: WHERE adj_sum_batch_name = p_adj_sum_batch_name
2370: AND source_type = 'A'
2371: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
2372: AND status_code = 'I'

Line 2386: FROM psp_payroll_controls

2382: source_type,
2383: payroll_source_code,
2384: time_period_id,
2385: batch_name
2386: FROM psp_payroll_controls
2387: WHERE batch_name = p_batch_name
2388: AND source_type = 'A'
2389: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
2390: AND status_code = 'I'

Line 2572: UPDATE psp_payroll_controls

2568: l_rec_count := l_rec_count + 1;
2569: IF gms_sum_lines_cursor%NOTFOUND THEN
2570: if (l_rec_count > 1 ) then
2571: g_gms_avail := 'Y';
2572: UPDATE psp_payroll_controls
2573: SET gms_phase = 'Summarize_GMS_Lines'
2574: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
2575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updating psp_payroll_controls gms_phase to Summarize_GMS_Lines for control_id: '||payroll_control_rec.payroll_control_id);
2576:

Line 2575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updating psp_payroll_controls gms_phase to Summarize_GMS_Lines for control_id: '||payroll_control_rec.payroll_control_id);

2571: g_gms_avail := 'Y';
2572: UPDATE psp_payroll_controls
2573: SET gms_phase = 'Summarize_GMS_Lines'
2574: WHERE payroll_control_id = payroll_control_rec.payroll_control_id;
2575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updating psp_payroll_controls gms_phase to Summarize_GMS_Lines for control_id: '||payroll_control_rec.payroll_control_id);
2576:
2577: end if;
2578: CLOSE gms_sum_lines_cursor;
2579: EXIT;

Line 2823: FROM psp_payroll_controls

2819: p_return_status OUT NOCOPY VARCHAR2) IS
2820:
2821: CURSOR pc_batch_cur IS
2822: SELECT distinct batch_name
2823: FROM psp_payroll_controls
2824: WHERE adj_sum_batch_name = p_adj_sum_batch_name
2825: AND source_type = 'A'
2826: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
2827: AND gms_phase = 'Summarize_GMS_Lines'

Line 2843: FROM psp_payroll_controls

2839: time_period_id,
2840: batch_name,
2841: -- Introduced the following for bug fix 2916848
2842: currency_code
2843: FROM psp_payroll_controls
2844: WHERE batch_name = p_batch_name
2845: AND source_type = 'A'
2846: AND (dist_dr_amount IS NOT NULL OR dist_cr_amount IS NOT NULL)
2847: AND gms_phase = 'Summarize_GMS_Lines'

Line 3003: FROM psp_payroll_controls ppc,

2999: call_status_tab call_status_type;
3000:
3001: CURSOR operating_unit_csr IS
3002: SELECT distinct org_id
3003: FROM psp_payroll_controls ppc,
3004: psp_summary_lines psl
3005: WHERE ppc.payroll_control_id = psl.payroll_control_id
3006: AND ppc.adj_sum_batch_name = p_adj_sum_batch_name
3007: AND ppc.source_type = 'A'

Line 3161: -- UPDATE psp_payroll_controls

3157: LOOP
3158: FETCH gms_interface_cursor INTO gms_interface_rec;
3159: IF gms_interface_cursor%NOTFOUND THEN
3160: -- if (l_rec_count > 0) then
3161: -- UPDATE psp_payroll_controls
3162: -- SET gms_phase = 'Transfer_GMS_Lines'
3163: -- WHERE payroll_control_id = gms_batch_rec.payroll_control_id;
3164: -- end if;
3165: CLOSE gms_interface_cursor;

Line 3483: WHERE payroll_control_id IN(select payroll_control_id from psp_payroll_controls

3479: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated pa_transaction_interface_all set batch_name to '||l_gms_stat_batch_name||' for STAT records count: '||sql%rowcount);
3480:
3481: UPDATE psp_summary_lines
3482: SET gms_batch_name = l_gms_stat_batch_name
3483: WHERE payroll_control_id IN(select payroll_control_id from psp_payroll_controls
3484: where run_id = g_run_id
3485: and currency_code = 'STAT')
3486: AND gms_batch_name = l_gms_batch_name
3487: AND status_code = 'N'

Line 3547: UPDATE psp_payroll_controls

3543: FETCH payroll_control_id_cur BULK COLLECT INTO r_payroll_controls.payroll_control_id;
3544: CLOSE payroll_control_id_cur;
3545:
3546: FORALL I IN 1..r_payroll_controls.payroll_control_id.COUNT
3547: UPDATE psp_payroll_controls
3548: SET gms_phase = 'Submitted_Import_Request'
3549: WHERE payroll_control_id = r_payroll_controls.payroll_control_id(I);
3550:
3551:

Line 3554: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updating psp_payroll_controls count: '||sql%bulk_rowcount(I));

3550:
3551:
3552: FOR I IN 1..r_payroll_controls.payroll_control_id.COUNT
3553: LOOP
3554: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updating psp_payroll_controls count: '||sql%bulk_rowcount(I));
3555: END LOOP;
3556:
3557: END LOOP; --13502385
3558:

Line 3640: UPDATE psp_payroll_controls

3636: FETCH payroll_control_id_cur BULK COLLECT INTO r_payroll_controls.payroll_control_id;
3637: CLOSE payroll_control_id_cur;
3638:
3639: FORALL I IN 1..r_payroll_controls.payroll_control_id.COUNT
3640: UPDATE psp_payroll_controls
3641: SET gms_phase = 'Submitted_Import_Request'
3642: WHERE payroll_control_id = r_payroll_controls.payroll_control_id(I);
3643:
3644: FOR I IN 1..r_payroll_controls.payroll_control_id.COUNT

Line 3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updating psp_payroll_controls count: '||sql%bulk_rowcount(I));

3642: WHERE payroll_control_id = r_payroll_controls.payroll_control_id(I);
3643:
3644: FOR I IN 1..r_payroll_controls.payroll_control_id.COUNT
3645: LOOP
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updating psp_payroll_controls count: '||sql%bulk_rowcount(I));
3647: END LOOP;
3648:
3649:
3650:

Line 3717: FROM psp_payroll_controls

3713: p_return_status OUT NOCOPY VARCHAR2) IS
3714:
3715: CURSOR pc_batch_cur IS
3716: SELECT distinct batch_name
3717: FROM psp_payroll_controls
3718: WHERE adj_sum_batch_name = p_adj_sum_batch_name
3719: AND (dist_dr_amount is not null and dist_cr_amount is not null)
3720: AND source_type = 'A'
3721: AND status_code = 'I'

Line 3736: FROM psp_payroll_controls

3732: payroll_source_code,
3733: time_period_id,
3734: batch_name,
3735: currency_code -- 6902514
3736: FROM psp_payroll_controls
3737: WHERE batch_name = p_batch_name
3738: AND (dist_dr_amount is not null and dist_cr_amount is not null)
3739: AND source_type = 'A'
3740: AND status_code = 'I'

Line 3925: update psp_payroll_controls

3921: where gms_batch_name = l_gms_batch_name
3922: and payroll_control_id = gms_tie_back_rec.payroll_control_id;
3923: */
3924: -- Added following update for 2133056
3925: update psp_payroll_controls
3926: set gms_phase = 'Summarize_GMS_Lines'
3927: where gms_phase is not null
3928: and adj_sum_batch_name = p_adj_sum_batch_name;
3929:

Line 3930: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_payroll_controls set gms_phase to Summarize_GMS_Lines

3926: set gms_phase = 'Summarize_GMS_Lines'
3927: where gms_phase is not null
3928: and adj_sum_batch_name = p_adj_sum_batch_name;
3929:
3930: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_payroll_controls set gms_phase to Summarize_GMS_Lines
3931: for adj_sum_batch_name: '||p_adj_sum_batch_name||' count: '||sql%rowcount);
3932:
3933: commit;
3934: return false;

Line 3999: from psp_payroll_controls

3995:
3996: delete psp_summary_lines
3997: where payroll_control_id in
3998: (select payroll_control_id
3999: from psp_payroll_controls
4000: where source_type = 'A'
4001: and adj_sum_batch_name = p_adj_sum_batch_name);
4002:
4003: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from psp_summary_lines count: '||sql%rowcount);

Line 4005: update psp_payroll_controls

4001: and adj_sum_batch_name = p_adj_sum_batch_name);
4002:
4003: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from psp_summary_lines count: '||sql%rowcount);
4004:
4005: update psp_payroll_controls
4006: set gms_phase = null
4007: where gms_phase is not null
4008: and source_type = 'A'
4009: and adj_sum_batch_name = p_adj_sum_batch_name;

Line 4011: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_payroll_controls set gms_phase to null count: '||sql%rowcount);

4007: where gms_phase is not null
4008: and source_type = 'A'
4009: and adj_sum_batch_name = p_adj_sum_batch_name;
4010:
4011: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_payroll_controls set gms_phase to null count: '||sql%rowcount);
4012:
4013: commit;
4014: return false;
4015:

Line 4151: update psp_payroll_controls

4147: -- fnd_message.set_token('ERR_NAME', l_trx_rejection_code);
4148: get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
4149: fnd_msg_pub.add;
4150: /* 1685685 added update statement...to clean pa tables in cleanup_batch_details..Venkat.*/
4151: update psp_payroll_controls
4152: set gms_phase = 'GMS_Tie_Back'
4153: where payroll_control_id = gms_tie_back_rec.payroll_control_id;
4154: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_payroll_controls for control_id = '||gms_tie_back_rec.payroll_control_id);
4155:

Line 4154: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_payroll_controls for control_id = '||gms_tie_back_rec.payroll_control_id);

4150: /* 1685685 added update statement...to clean pa tables in cleanup_batch_details..Venkat.*/
4151: update psp_payroll_controls
4152: set gms_phase = 'GMS_Tie_Back'
4153: where payroll_control_id = gms_tie_back_rec.payroll_control_id;
4154: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' updated psp_payroll_controls for control_id = '||gms_tie_back_rec.payroll_control_id);
4155:
4156: cleanup_batch_details(gms_tie_back_rec.payroll_control_id,null);
4157: close gms_tie_back_cur;
4158: CLOSE gms_batch_name_cur;

Line 4194: UPDATE psp_payroll_controls

4190: close gms_tie_back_success_cur;
4191: exit;
4192: ELSIF gms_tie_back_success_cur%NOTFOUND THEN
4193:
4194: UPDATE psp_payroll_controls
4195: SET gms_phase = 'GMS_Tie_Back'
4196: WHERE payroll_control_id = l_control_id;
4197:
4198: CLOSE gms_tie_back_success_cur;

Line 4262: UPDATE psp_payroll_controls

4258:
4259:
4260: END LOOP; -- End loop for gms_tie_back_success_cur
4261:
4262: UPDATE psp_payroll_controls
4263: SET ogm_dr_amount = nvl(ogm_dr_amount,0) + l_dr_summary_amount,
4264: ogm_cr_amount = nvl(ogm_cr_amount,0) + l_cr_summary_amount
4265: WHERE payroll_control_id = gms_tie_back_rec.payroll_control_id;
4266:

Line 4267: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_payroll_controls set ogm_dr_amount and ogm_cr_amount for cotrol_id : '||gms_tie_back_rec.payroll_control_id);

4263: SET ogm_dr_amount = nvl(ogm_dr_amount,0) + l_dr_summary_amount,
4264: ogm_cr_amount = nvl(ogm_cr_amount,0) + l_cr_summary_amount
4265: WHERE payroll_control_id = gms_tie_back_rec.payroll_control_id;
4266:
4267: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Updated psp_payroll_controls set ogm_dr_amount and ogm_cr_amount for cotrol_id : '||gms_tie_back_rec.payroll_control_id);
4268:
4269: END IF;
4270: END LOOP; -- End Loop for gms_batch_name_cur
4271:

Line 4444: psp_payroll_controls ppc

4440: cursor adj_batch_cur (p_batch_name IN VARCHAR2) IS
4441: select orig_source_type,
4442: orig_line_id
4443: from psp_adjustment_lines pal,
4444: psp_payroll_controls ppc
4445: WHERE ppc.source_type ='A'
4446: AND ppc.batch_name = p_batch_name
4447: AND pal.payroll_control_id = ppc.payroll_control_id
4448: AND pal.reversal_entry_flag IS NULL

Line 4453: psp_payroll_controls ppc

4449: UNION ALL -- added hist table for 2133056
4450: SELECT palh.orig_source_type,
4451: palh.orig_line_id
4452: FROM psp_adjustment_lines_history palh,
4453: psp_payroll_controls ppc
4454: WHERE palh.reversal_entry_flag IS NULL
4455: AND ppc.source_type ='A'
4456: AND ppc.batch_name = p_batch_name
4457: AND palh.payroll_control_id = ppc.payroll_control_id

Line 4465: FROM psp_payroll_controls

4461:
4462: -- Included the following cursors for bug fix 1765678
4463: CURSOR gl_gms_phase_batch_name_cur IS
4464: SELECT gl_phase, gms_phase, batch_name
4465: FROM psp_payroll_controls
4466: WHERE payroll_control_id = p_payroll_control_id;
4467:
4468: -- Tuned following stmt 2133056
4469: CURSOR group_name_cur IS

Line 4512: from psp_payroll_controls

4508: (select to_char(summary_line_id)
4509: from psp_summary_lines
4510: where payroll_control_id in
4511: (select payroll_control_id
4512: from psp_payroll_controls
4513: where batch_name = l_batch_name
4514: and source_type='A'))); ----- Added this delete for Bug 2133056
4515:
4516:

Line 4524: from psp_payroll_controls

4520: (select to_char(summary_line_id)
4521: from psp_summary_lines
4522: where payroll_control_id in
4523: (select payroll_control_id
4524: from psp_payroll_controls
4525: where batch_name = l_batch_name
4526: and source_type='A')); --Added for bug 1685685
4527:
4528: /***********************************************************************

Line 4538: from psp_payroll_controls

4534: (select to_char(summary_line_id)
4535: from psp_summary_lines
4536: where payroll_control_id in
4537: (select payroll_control_id
4538: from psp_payroll_controls
4539: where batch_name = l_batch_name
4540: and source_type = 'A'));
4541: ********************************************************************************/
4542:

Line 4554: from psp_payroll_controls PPC

4550: (select to_char(PSL.summary_line_id)
4551: from psp_summary_lines PSL
4552: where PSL.payroll_control_id in
4553: (select PPC.payroll_control_id
4554: from psp_payroll_controls PPC
4555: where PPC.batch_name=l_batch_name
4556: and PPC.source_type='A')))
4557: and 0 = (select count(*)
4558: from pa_expenditure_items_all ITEMS

Line 4571: from psp_payroll_controls

4567: (select to_char(summary_line_id)
4568: from psp_summary_lines
4569: where payroll_control_id in
4570: (select payroll_control_id
4571: from psp_payroll_controls
4572: where batch_name = l_batch_name
4573: and source_type = 'A'));
4574: ******************************************************************************/
4575: -- 1662816 start

Line 4630: FROM psp_payroll_controls ppc

4626:
4627: delete from psp_adjustment_lines_history
4628: where payroll_control_id in --- Corrected this statment 2133056
4629: ( SELECT ppc.payroll_control_id
4630: FROM psp_payroll_controls ppc
4631: WHERE ppc.batch_name = l_batch_name
4632: AND ppc.source_type = 'A');
4633:
4634:

Line 4640: from psp_payroll_controls

4636: where batch_name = l_batch_name;
4637:
4638: delete from psp_summary_lines
4639: where payroll_control_id in (select payroll_control_id
4640: from psp_payroll_controls
4641: where batch_name = l_batch_name
4642: and source_type = 'A'); --- added this condn 2133056
4643:
4644: delete from psp_payroll_controls

Line 4644: delete from psp_payroll_controls

4640: from psp_payroll_controls
4641: where batch_name = l_batch_name
4642: and source_type = 'A'); --- added this condn 2133056
4643:
4644: delete from psp_payroll_controls
4645: where batch_name = l_batch_name and
4646: source_type = 'A'; --- added this condn 2133056
4647:
4648: delete from psp_adjustment_control_table

Line 4661: FROM psp_payroll_controls

4657: PROCEDURE check_interface_status(p_target_name IN VARCHAR2,
4658: p_adj_sum_batch_name IN VARCHAR2) IS
4659: CURSOR pc_batch_cur IS
4660: SELECT distinct batch_name
4661: FROM psp_payroll_controls
4662: WHERE source_type = 'A'
4663: AND adj_sum_batch_name = p_adj_sum_batch_name
4664: AND status_code = 'I';
4665:

Line 4668: FROM psp_payroll_controls

4664: AND status_code = 'I';
4665:
4666: CURSOR payroll_control_cur(p_batch_name IN VARCHAR2) IS
4667: SELECT payroll_control_id
4668: FROM psp_payroll_controls
4669: WHERE batch_name = p_batch_name
4670: AND status_code = 'I'
4671: AND decode(p_target_name, 'GL', gl_phase, gms_phase) = 'Submitted_Import_Request'
4672: AND source_type = 'A';

Line 4756: update psp_payroll_controls

4752: END IF;
4753: CLOSE gl_interface_status_cur;
4754:
4755: if l_status_new > 0 then
4756: update psp_payroll_controls
4757: set gl_phase = 'Summarize_GL_Lines'
4758: where gl_phase = 'Submitted_Import_Request'
4759: and payroll_control_id = payroll_control_rec.payroll_control_id;
4760:

Line 4795: update psp_payroll_controls

4791: END IF;
4792: CLOSE pa_txn_int_status_p_cur;
4793:
4794: if (l_status_p > 0) then
4795: update psp_payroll_controls
4796: set gms_phase = NULL
4797: where payroll_control_id = payroll_control_rec.payroll_control_id
4798: and gms_phase = 'Submitted_Import_Request';
4799:

Line 4862: l_currency_code psp_payroll_controls.currency_code%TYPE;

4858: l_distribution_start_date DATE;
4859: l_distribution_end_date DATE;
4860: l_person_name VARCHAR2(80);
4861: l_error VARCHAR2(200);
4862: l_currency_code psp_payroll_controls.currency_code%TYPE;
4863:
4864: -- Included the following cursors here for accessing local variables for bug fix 1765678
4865: CURSOR adjustment_control_cur IS
4866: SELECT adjustment_batch_name, person_id, assignment_id, element_type_id,