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_ENC_SUM_TRAN dependencies on PSP_ENC_CONTROLS

Line 497: -- This procedure generates a RUN_ID and updates PSP_ENC_CONTROLS table with

493: END;
494:
495: -- ##########################################################################
496: -- This procedure begins the encumbrance summarization process
497: -- This procedure generates a RUN_ID and updates PSP_ENC_CONTROLS table with
498: -- the RUN_ID and sets the ACTION_CODE = 'I' where
499: -- ACTION_TYPE in ('N', 'Q', 'U') and ACTION_CODE = 'N'
500: -- Included 'Q' for Quick Update Enh. 2143723
501: -- ##########################################################################

Line 511: FROM psp_enc_controls

507: CURSOR enc_control_cur IS
508: SELECT enc_control_id,
509: payroll_id,
510: time_period_id
511: FROM psp_enc_controls
512: WHERE payroll_action_id = p_payroll_action_id
513: -- WHERE payroll_id = nvl(p_payroll_id, payroll_id)
514: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
515: AND action_type IN ('N', 'Q', 'U') -- Included 'Q' for Quick Upd. Enh. 2143723

Line 546: UPDATE psp_enc_controls

542: p_return_status := fnd_api.g_ret_sts_success;
543: EXIT;
544: END IF;
545:
546: UPDATE psp_enc_controls
547: SET action_code = 'I',
548: run_id = g_run_id
549: WHERE enc_control_id = enc_control_rec.enc_control_id
550: AND time_period_id = enc_control_rec.time_period_id;

Line 566: -- This procedure updates the table PSP_ENC_CONTROLS with ACTION_CODE = 'P',

562: END;
563: -- ##########################################################################
564: -- This procedure ends the encumbrance summarization process
565:
566: -- This procedure updates the table PSP_ENC_CONTROLS with ACTION_CODE = 'P',
567: -- if the program is completed with a return code of success and if the
568: -- return code is failed it updates ACTION_CODE = 'N'.
569:
570: -- When the program returns a failure status, it also updates PSP_ENC_LINES

Line 617: UPDATE psp_enc_controls pec

613: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'Calling move_rej_lines_to_arch');
614: move_rej_lines_to_arch(p_payroll_action_id);
615: END IF;
616:
617: UPDATE psp_enc_controls pec
618: SET action_code = 'P'
619: WHERE payroll_action_id = p_payroll_action_id
620: AND NOT EXISTS (SELECT 1
621: FROM psp_enc_summary_lines pesl

Line 739: FROM psp_enc_controls

735: payroll_id,
736: time_period_id,
737: gl_phase,
738: gms_phase
739: FROM psp_enc_controls
740: WHERE payroll_action_id = p_payroll_action_id
741: -- WHERE payroll_id = nvl(p_payroll_id, payroll_id)
742: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
743: AND action_type IN ('N', 'Q', 'U') -- Included 'Q' for Quick Upd. Enh. 2143723.

Line 760: -- ,psp_enc_controls pec

756: / * Included as part of Bug fix #1776606 * /
757: CURSOR gl_gms_line_count_cur IS
758: SELECT count(*)
759: FROM psp_enc_lines pel
760: -- ,psp_enc_controls pec
761: WHERE pel.enc_control_id= enc_control_rec.enc_control_id
762: AND pel.time_period_id = enc_control_rec.time_period_id
763: AND pel.encumbrance_amount<>0
764: AND pel.business_group_id = g_business_group_id

Line 793: update psp_enc_controls

789:
790: IF (enc_control_rec.gl_phase is null and enc_control_rec.gms_phase is null) then
791: rollback;
792: / * ELSIF (enc_control_rec.gl_phase = 'Transfer' or enc_control_rec.gms_phase = 'Transfer') then
793: update psp_enc_controls
794: set action_code = 'I'
795: where enc_control_id = enc_control_rec.enc_control_id; * / --- commented for 2479579
796: ELSE
797:

Line 804: -- in psp_enc_controls to 'P' or 'N'

800: WHERE enc_control_id = enc_control_rec.enc_control_id
801: AND status_code = 'N';
802:
803: -- This part is used to delete the rejected summary lines, mark the status_code
804: -- in psp_enc_controls to 'P' or 'N'
805: / * Commented as part of bug fix #1776606
806: SELECT nvl(sum(encumbrance_amount),0)
807: INTO l_o_enc_sum
808: FROM psp_enc_lines pel

Line 809: -- ,psp_enc_controls pec

805: / * Commented as part of bug fix #1776606
806: SELECT nvl(sum(encumbrance_amount),0)
807: INTO l_o_enc_sum
808: FROM psp_enc_lines pel
809: -- ,psp_enc_controls pec
810: WHERE pel.enc_control_id = enc_control_rec.enc_control_id
811: AND pel.time_period_id = enc_control_rec.time_period_id
812: AND pel.business_group_id = g_business_group_id
813: AND pel.set_of_books_id = g_set_of_books_id; * /

Line 826: UPDATE psp_enc_controls

822: DELETE FROM psp_enc_summary_lines
823: WHERE enc_control_id = enc_control_rec.enc_control_id
824: AND status_code = 'R'; * /
825:
826: UPDATE psp_enc_controls
827: SET action_code = 'P',
828: run_id = NULL
829: WHERE enc_control_id = enc_control_rec.enc_control_id;
830:

Line 832: UPDATE psp_enc_controls

828: run_id = NULL
829: WHERE enc_control_id = enc_control_rec.enc_control_id;
830:
831: ELSE
832: UPDATE psp_enc_controls
833: SET action_code = 'N',
834: run_id = NULL
835: WHERE enc_control_id = enc_control_rec.enc_control_id;
836: END IF;

Line 843: UPDATE psp_enc_controls

839: DELETE FROM psp_enc_summary_lines
840: WHERE enc_control_id = enc_control_rec.enc_control_id
841: AND status_code = 'R';
842:
843: UPDATE psp_enc_controls
844: SET action_code = 'P',
845: run_id = NULL
846: WHERE enc_control_id = enc_control_rec.enc_control_id;
847:

Line 849: UPDATE psp_enc_controls

845: run_id = NULL
846: WHERE enc_control_id = enc_control_rec.enc_control_id;
847:
848: ELSE
849: UPDATE psp_enc_controls
850: SET action_code = 'N',
851: run_id = NULL
852: WHERE enc_control_id = enc_control_rec.enc_control_id;
853: END IF; * /

Line 936: FROM psp_enc_controls

932: CURSOR enc_control_cur IS
933: SELECT enc_control_id,
934: payroll_id,
935: time_period_id
936: FROM psp_enc_controls
937: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
938: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
939: AND action_type IN ('N', 'Q', 'U') -- Included 'Q' for Quick Upd. Enh. 2143723.
940: AND action_code = 'I'

Line 1261: update psp_enc_controls

1257: IF enc_sum_lines_p1_cur%ROWCOUNT = 0 THEN
1258: CLOSE enc_sum_lines_p1_cur;
1259: EXIT;
1260: ELSIF enc_sum_lines_p1_cur%NOTFOUND THEN
1261: update psp_enc_controls
1262: set gl_phase = 'Summarize' ---NULL ... for 2444657
1263: where enc_control_id = enc_control_rec.enc_control_id;
1264: CLOSE enc_sum_lines_p1_cur;
1265: EXIT;

Line 1393: update psp_enc_controls

1389: IF enc_sum_lines_p2_cur%ROWCOUNT = 0 THEN
1390: CLOSE enc_sum_lines_p2_cur;
1391: EXIT;
1392: ELSIF enc_sum_lines_p2_cur%NOTFOUND THEN
1393: update psp_enc_controls
1394: set gl_phase = 'Summarize' ---NULL for 2444657
1395: where enc_control_id = enc_control_rec.enc_control_id;
1396: CLOSE enc_sum_lines_p2_cur;
1397: EXIT;

Line 1458: update psp_enc_controls

1454: IF enc_sum_lines_p3_cur%ROWCOUNT = 0 THEN
1455: CLOSE enc_sum_lines_p3_cur;
1456: EXIT;
1457: ELSIF enc_sum_lines_p3_cur%NOTFOUND THEN
1458: update psp_enc_controls
1459: set gl_phase = 'Summarize' ---NULL commented for 2444657
1460: where enc_control_id = enc_control_rec.enc_control_id;
1461: CLOSE enc_sum_lines_p3_cur;
1462: EXIT;

Line 1526: update psp_enc_controls

1522: IF enc_sum_lines_g1_cur%ROWCOUNT = 0 THEN
1523: CLOSE enc_sum_lines_g1_cur;
1524: EXIT;
1525: ELSIF enc_sum_lines_g1_cur%NOTFOUND THEN
1526: update psp_enc_controls
1527: set gl_phase = 'Summarize' --- replaced NULL for 2444657
1528: where enc_control_id = enc_control_rec.enc_control_id;
1529: CLOSE enc_sum_lines_g1_cur;
1530: EXIT;

Line 1589: update psp_enc_controls

1585: IF enc_sum_lines_g2_cur%ROWCOUNT = 0 THEN
1586: CLOSE enc_sum_lines_g2_cur;
1587: EXIT;
1588: ELSIF enc_sum_lines_g2_cur%NOTFOUND THEN
1589: update psp_enc_controls
1590: set gl_phase = 'Summarize' ---replaced NULL for 2444657
1591: where enc_control_id = enc_control_rec.enc_control_id;
1592: CLOSE enc_sum_lines_g2_cur;
1593: EXIT;

Line 1652: update psp_enc_controls

1648: IF enc_sum_lines_g3_cur%ROWCOUNT = 0 THEN
1649: CLOSE enc_sum_lines_g3_cur;
1650: EXIT;
1651: ELSIF enc_sum_lines_g3_cur%NOTFOUND THEN
1652: update psp_enc_controls
1653: set gl_phase = 'Summarize' -- replaced NULL for 2444657
1654: where enc_control_id = enc_control_rec.enc_control_id;
1655: CLOSE enc_sum_lines_g3_cur;
1656: EXIT;

Line 1860: FROM psp_enc_controls

1856: SELECT enc_control_id,
1857: payroll_id,
1858: time_period_id,
1859: gl_phase --- added for 2444657
1860: FROM psp_enc_controls
1861: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
1862: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
1863: AND action_type IN ('N', 'Q', 'U') -- Included 'Q' for Quick Upd. Enh. 2143723.
1864: AND action_code = 'I'

Line 2215: UPDATE psp_enc_controls

2211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2212:
2213: ELSE
2214: / ***** Converted the following UPDATE to BULK for R12 performance fixes
2215: UPDATE psp_enc_controls
2216: SET gl_phase = 'Transfer'
2217: WHERE enc_control_id in (select distinct enc_control_id
2218: from psp_enc_summary_lines
2219: where group_id = l_group_id);

Line 2228: UPDATE psp_enc_controls

2224: FETCH enc_control_id_cur BULK COLLECT INTO r_enc_controls.enc_control_id;
2225: CLOSE enc_control_id_cur;
2226:
2227: FORALL I IN 1..r_enc_controls.enc_control_id.COUNT
2228: UPDATE psp_enc_controls
2229: SET gl_phase = 'Transfer'
2230: WHERE enc_control_id = r_enc_controls.enc_control_id(I);
2231:
2232: r_enc_controls.enc_control_id.DELETE;

Line 2358: FROM psp_enc_controls

2354: AND gl_code_combination_id IS NOT NULL;
2355:
2356: CURSOR enc_control_id_cur IS
2357: SELECT enc_control_id
2358: FROM psp_enc_controls
2359: WHERE payroll_action_id = p_payroll_action_id;
2360: BEGIN
2361: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering Transfer to GL Interface');
2362:

Line 2453: psp_enc_controls pec

2449: pesl.attribute24, pesl.attribute25, pesl.attribute26,
2450: pesl.attribute27, pesl.attribute28, pesl.attribute29,
2451: pesl.attribute30
2452: FROM psp_enc_summary_lines pesl,
2453: psp_enc_controls pec
2454: WHERE pec.enc_control_id = pesl.enc_control_id
2455: AND pec.payroll_action_id = p_payroll_action_id
2456: AND pesl.status_code = 'N'
2457: AND pesl.gl_code_combination_id is NOT NULL

Line 2505: UPDATE psp_enc_controls

2501:
2502: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' r_enc_controls.enc_control_id.COUNT: ' || r_enc_controls.enc_control_id.COUNT);
2503:
2504: FORALL I IN 1..r_enc_controls.enc_control_id.COUNT
2505: UPDATE psp_enc_controls
2506: SET gl_phase = 'Transfer'
2507: WHERE enc_control_id = r_enc_controls.enc_control_id(I);
2508:
2509:

Line 2516: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase to ''Transfer'' in psp_enc_controls count:'||g_bulk_row_count);

2512: loop
2513: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
2514: end loop;
2515:
2516: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase to ''Transfer'' in psp_enc_controls count:'||g_bulk_row_count);
2517:
2518: r_enc_controls.enc_control_id.DELETE;
2519:
2520: COMMIT;

Line 2724: FROM psp_enc_controls

2720: / *
2721: CURSOR enc_control_cur IS
2722: SELECT enc_control_id,
2723: time_period_id
2724: FROM psp_enc_controls
2725: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
2726: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
2727: AND action_type IN ('N', 'Q', 'U') -- Included 'Q' for Quick Upd. Enh. 2143723.
2728: AND action_code = 'I'

Line 2958: UPDATE psp_enc_controls

2954: AND group_id = p_group_id;
2955:
2956: IF l_cnt_gl_interface > 0 THEN
2957: / * Start bug#2142865 Moved the code after loop to above * /
2958: UPDATE psp_enc_controls
2959: SET gl_phase = 'TieBack'
2960: WHERE run_id = g_run_id;
2961: / * End bug#2142865 * /
2962: OPEN gl_tie_back_reject_cur;

Line 3150: UPDATE psp_enc_controls

3146: END LOOP;
3147: END LOOP;
3148: / * Commented as a part of bug#2142865
3149: Moved the same code up
3150: UPDATE psp_enc_controls
3151: SET gl_phase = 'TieBack'
3152: WHERE enc_control_id = p_enc_control_id;* /
3153: / * GL encumbrance does not have reversal lines: bug 2030232
3154: IF l_reversal_ac_failed = 'Y' THEN

Line 3289: UPDATE psp_enc_controls

3285: AND enc_control_id = p_enc_control_id;
3286:
3287: END LOOP;
3288:
3289: UPDATE psp_enc_controls
3290: SET summ_gl_dr_amount = l_dr_summary_amount,
3291: summ_gl_cr_amount = l_cr_summary_amount,
3292: gl_phase = 'TieBack'
3293: WHERE enc_control_id = p_enc_control_id;

Line 3761: UPDATE psp_enc_controls

3757: END IF;
3758: END IF;
3759:
3760: FORALL recno IN 1..r_interface.status.COUNT
3761: UPDATE psp_enc_controls
3762: SET gl_phase = 'TieBack'
3763: WHERE enc_control_id IN (SELECT pesl.enc_control_id
3764: FROM psp_enc_summary_lines pesl
3765: WHERE pesl.enc_summary_line_id = r_interface.enc_summary_line_id(recno));

Line 3776: UPDATE psp_enc_controls

3772:
3773: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' TieBack count: '||g_bulk_row_count);
3774:
3775: FORALL recno IN 1..r_interface.status.COUNT
3776: UPDATE psp_enc_controls
3777: SET gl_phase = 'Summarize'
3778: WHERE enc_control_id IN (SELECT pesl.enc_control_id
3779: FROM psp_enc_summary_lines pesl
3780: WHERE pesl.enc_summary_line_id = r_interface.enc_summary_line_id(recno)

Line 3868: UPDATE psp_enc_controls pec

3864:
3865:
3866:
3867: FORALL recno IN 1..r_interface.enc_control_id.COUNT
3868: UPDATE psp_enc_controls pec
3869: SET gl_phase = 'TieBack',
3870: summ_gl_dr_amount = NVL(summ_gl_dr_amount, 0) + DECODE(r_interface.dr_cr_flag(recno), 'D', r_interface.summary_amount(recno), 0),
3871: summ_gl_cr_amount = NVL(summ_gl_cr_amount, 0) + DECODE(r_interface.dr_cr_flag(recno), 'C', r_interface.summary_amount(recno), 0)
3872: WHERE enc_control_id = r_interface.enc_control_id(recno);

Line 3880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase, summ_gl_dr_amount, summ_gl_cr_amount in psp_enc_controls count: '||g_bulk_row_count);

3876: loop
3877: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
3878: end loop;
3879:
3880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase, summ_gl_dr_amount, summ_gl_cr_amount in psp_enc_controls count: '||g_bulk_row_count);
3881: END IF;
3882: ELSE
3883: g_process_complete := FALSE;
3884: END IF;

Line 4117: FROM psp_enc_controls

4113: CURSOR enc_control_cur IS
4114: SELECT enc_control_id,
4115: payroll_id,
4116: time_period_id
4117: FROM psp_enc_controls
4118: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
4119: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
4120: AND action_type IN ('N', 'Q', 'U') -- Included 'Q' for Quick Upd. Enh. 2143723.
4121: AND action_code = 'I'

Line 4328: update psp_enc_controls

4324: IF enc_sum_lines_p_cur%ROWCOUNT = 0 THEN
4325: CLOSE enc_sum_lines_p_cur;
4326: EXIT;
4327: ELSIF enc_sum_lines_p_cur%NOTFOUND THEN
4328: update psp_enc_controls
4329: set gms_phase = 'Summarize' ---NULL commented for 2444657
4330: where enc_control_id = enc_control_rec.enc_control_id;
4331: CLOSE enc_sum_lines_p_cur;
4332: EXIT;

Line 4484: update psp_enc_controls

4480: IF enc_sum_lines_g_cur%ROWCOUNT = 0 THEN
4481: CLOSE enc_sum_lines_g_cur;
4482: EXIT;
4483: ELSIF enc_sum_lines_g_cur%NOTFOUND THEN
4484: update psp_enc_controls
4485: set gms_phase = NULL
4486: where enc_control_id = enc_control_rec.enc_control_id;
4487: CLOSE enc_sum_lines_g_cur;
4488: EXIT;

Line 4625: psp_enc_controls pec

4621: hr_organization_units hou,
4622: pa_projects_all ppa,
4623: pa_tasks_expend_v pt, -- Bug : 16391366 (20/03/2013)
4624: per_time_periods ptp,
4625: psp_enc_controls pec
4626: ,per_all_people_f papf --Added for Bug 10126350
4627: WHERE pec.payroll_action_id = p_payroll_action_id
4628: AND pec.enc_control_id = pesl.enc_control_id
4629: AND pesl.status_code = 'N'

Line 5062: UPDATE psp_enc_controls

5058: FETCH enc_control_id_cur BULK COLLECT INTO r_enc_controls.enc_control_id;
5059: CLOSE enc_control_id_cur;
5060:
5061: FORALL I IN 1..r_enc_controls.enc_control_id.COUNT
5062: UPDATE psp_enc_controls
5063: SET gms_phase = 'Transfer'
5064: WHERE enc_control_id = r_enc_controls.enc_control_id(I);
5065:
5066: g_bulk_row_count :=0;

Line 5072: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''Transfer'' in psp_enc_controls count ' ||g_bulk_row_count);

5068: loop
5069: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
5070: end loop;
5071:
5072: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''Transfer'' in psp_enc_controls count ' ||g_bulk_row_count);
5073:
5074: r_enc_controls.enc_control_id.DELETE;
5075: END IF;
5076: END LOOP;

Line 5473: UPDATE psp_enc_controls

5469: AND transaction_status_code in ('R', 'PI', 'PR', 'PO');
5470:
5471: IF l_cnt_gms_interface > 0 THEN
5472: / * Start bug#2142865 Added the code to update the gms_phase * /
5473: UPDATE psp_enc_controls
5474: SET gms_phase = 'TieBack'
5475: WHERE run_id = g_run_id;
5476: / * End bug#2142865 * /
5477: OPEN gms_tie_back_reject_cur;

Line 5718: UPDATE psp_enc_controls

5714:
5715: END LOOP; --end loop2 assign suspense account
5716: END LOOP; -- end loop1
5717:
5718: UPDATE psp_enc_controls
5719: SET summ_ogm_dr_amount = l_dr_summary_amount,
5720: summ_ogm_cr_amount = l_cr_summary_amount
5721: --gms_phase = 'TieBack' Commented for Bug#2142865 , same moved above
5722: WHERE enc_control_id = p_enc_control_id;

Line 5867: UPDATE psp_enc_controls

5863: and transaction_status_code = 'A'
5864: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id); * /
5865: END LOOP;
5866:
5867: UPDATE psp_enc_controls
5868: SET summ_ogm_dr_amount = l_dr_summary_amount,
5869: summ_ogm_cr_amount = l_cr_summary_amount,
5870: gms_phase = 'TieBack'
5871: WHERE enc_control_id = p_enc_control_id;

Line 6567: UPDATE psp_enc_controls pec

6563: END IF;
6564: END IF;
6565:
6566: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6567: UPDATE psp_enc_controls pec
6568: SET summ_ogm_dr_amount = NVL(pec.summ_ogm_dr_amount, 0) + DECODE(r_success_recs.dr_cr_flag(recno), 'D', r_success_recs.summary_amount(recno), 0),
6569: summ_ogm_cr_amount = NVL(pec.summ_ogm_cr_amount, 0) + DECODE(r_success_recs.dr_cr_flag(recno), 'C', r_success_recs.summary_amount(recno), 0)
6570: WHERE enc_control_id = r_success_recs.enc_control_id(recno);
6571:

Line 6572: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update summ_ogm_cr_amount, summ_ogm_dr_amount in psp_enc_controls');

6568: SET summ_ogm_dr_amount = NVL(pec.summ_ogm_dr_amount, 0) + DECODE(r_success_recs.dr_cr_flag(recno), 'D', r_success_recs.summary_amount(recno), 0),
6569: summ_ogm_cr_amount = NVL(pec.summ_ogm_cr_amount, 0) + DECODE(r_success_recs.dr_cr_flag(recno), 'C', r_success_recs.summary_amount(recno), 0)
6570: WHERE enc_control_id = r_success_recs.enc_control_id(recno);
6571:
6572: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update summ_ogm_cr_amount, summ_ogm_dr_amount in psp_enc_controls');
6573:
6574: r_reject_recs.enc_summary_line_id.DELETE;
6575: r_reject_recs.enc_control_id.DELETE;
6576: r_reject_recs.reason_code.DELETE;

Line 6656: UPDATE psp_enc_controls pec

6652: end loop;
6653: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines from psp_enc_lines that are summarized and trasnferred to target systems'||g_bulk_row_count);
6654:
6655: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6656: UPDATE psp_enc_controls pec
6657: SET gms_phase = 'TieBack',
6658: summ_ogm_dr_amount = NVL(pec.summ_ogm_dr_amount, 0) + DECODE(r_success_recs.dr_cr_flag(recno), 'D', r_success_recs.summary_amount(recno), 0),
6659: summ_ogm_cr_amount = NVL(pec.summ_ogm_cr_amount, 0) + DECODE(r_success_recs.dr_cr_flag(recno), 'C', r_success_recs.summary_amount(recno), 0)
6660: WHERE enc_control_id = r_success_recs.enc_control_id(recno);

Line 6668: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summ_ogm_cr_amount, summ_ogm_dr_amount, gms_phase in psp_enc_controls count: '||g_bulk_row_count);

6664: loop
6665: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
6666: end loop;
6667:
6668: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summ_ogm_cr_amount, summ_ogm_dr_amount, gms_phase in psp_enc_controls count: '||g_bulk_row_count);
6669:
6670: r_success_recs.enc_summary_line_id.DELETE;
6671: r_success_recs.enc_control_id.DELETE;
6672: r_success_recs.reason_code.DELETE;