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

Line 551: -- liquidate 'L' and picks up the necessary rows from PSP_ENC_CONTROLS,

547: -- This procedure begins the encumbrance liquidation process
548:
549: -- Included action_code 'Q' for Quick Update
550: -- This procedure identifies whether the call is for update ('Q', 'U') or
551: -- liquidate 'L' and picks up the necessary rows from PSP_ENC_CONTROLS,
552: -- generates a RUN_ID and updates PSP_ENC_CONTROLS table with
553: -- the RUN_ID and sets the ACTION_CODE = 'I' where
554: -- ACTION_TYPE in ('N', 'U', 'Q') and ACTION_CODE = 'P'
555:

Line 552: -- generates a RUN_ID and updates PSP_ENC_CONTROLS table with

548:
549: -- Included action_code 'Q' for Quick Update
550: -- This procedure identifies whether the call is for update ('Q', 'U') or
551: -- liquidate 'L' and picks up the necessary rows from PSP_ENC_CONTROLS,
552: -- generates a RUN_ID and updates PSP_ENC_CONTROLS table with
553: -- the RUN_ID and sets the ACTION_CODE = 'I' where
554: -- ACTION_TYPE in ('N', 'U', 'Q') and ACTION_CODE = 'P'
555:
556: -- If the call is for update it will retireve all the rows with time_period_id

Line 572: FROM psp_enc_controls

568: l_payroll_id NUMBER(15);
569:
570: CURSOR payroll_id_cur IS
571: SELECT DISTINCT payroll_id
572: FROM psp_enc_controls
573: WHERE payroll_action_id = p_payroll_action_id;
574:
575: /* Bug 5642002: Replaced earned date with period end date */
576: CURSOR payroll_run_date_cur IS

Line 629: FROM psp_enc_controls pec

625: NVL(run_id, 0),
626: gl_phase,
627: gms_phase,
628: batch_name
629: FROM psp_enc_controls pec
630: WHERE payroll_action_id = p_payroll_action_id
631: -- WHERE payroll_id = p_payroll_id
632: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
633: AND action_type IN ('N', 'U', 'Q')

Line 667: FROM psp_enc_controls pec

663: NVL(run_id, 0),
664: gl_phase,
665: gms_phase,
666: batch_name
667: FROM psp_enc_controls pec
668: WHERE payroll_action_id = p_payroll_action_id
669: -- WHERE payroll_id = p_payroll_id
670: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
671: AND action_type IN ('N', 'U', 'Q')

Line 706: FROM psp_enc_controls pec

702: NVL(run_id, 0),
703: gl_phase,
704: gms_phase,
705: batch_name
706: FROM psp_enc_controls pec
707: WHERE payroll_id = p_payroll_id
708: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
709: AND action_type IN ('N', 'U', 'Q')
710: AND action_code IN ('P', 'IT')

Line 736: psp_enc_controls pec,

732: DECODE(pesl.status_code, 'A', 'Accepted', 'L', 'Liquidated', 'S', 'Superceded', 'N', 'New', 'R', 'Rejected', pesl.status_code) status_code,
733: SUM(pesl.summary_amount),
734: COUNT(1)
735: FROM psp_enc_summary_lines pesl,
736: psp_enc_controls pec,
737: per_assignments_f paf,
738: per_people_f ppf
739: WHERE pesl.enc_control_id = pec.enc_control_id
740: AND paf.assignment_id = pesl.assignment_id

Line 809: FROM psp_enc_controls pec

805: CURSOR enc_control_cur1(p_max_time_period NUMBER) IS
806: SELECT enc_control_id,
807: payroll_id,
808: time_period_id
809: FROM psp_enc_controls pec
810: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
811: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
812: AND action_type in ('N', 'U', 'Q') -- Included 'Q' for Enh. 2143723
813: AND action_code in ('P','IL') --- added 'IL' for 2444657

Line 823: FROM psp_enc_controls pec

819: CURSOR enc_control_cur3 IS
820: SELECT enc_control_id,
821: payroll_id,
822: time_period_id
823: FROM psp_enc_controls pec
824: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
825: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
826: AND action_type in ('N', 'U', 'Q')
827: AND action_code in ('P','IL')

Line 864: FROM psp_enc_controls pec

860: CURSOR enc_control_cur2 (p_max_time_period NUMBER)IS
861: SELECT enc_control_id,
862: payroll_id,
863: time_period_id
864: FROM psp_enc_controls pec
865: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
866: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
867: AND action_type in ('N', 'U', 'Q') -- Included 'Q' for Enh. 2143723
868: AND action_code in ('P','IU') --- added 'IU' for 2444657

Line 935: UPDATE psp_enc_controls

931: CLOSE enc_control_cur1;
932: EXIT;
933: END IF;
934:
935: UPDATE psp_enc_controls
936: SET action_code = 'IL', / * Changed from 'I' for Restart Update/Quick Update Encumbrance Lines * /
937: run_id = g_run_id
938: -- gms_phase = null,
939: -- gl_phase = null commented null for 2444657

Line 961: UPDATE psp_enc_controls

957: CLOSE enc_control_cur2;
958: EXIT;
959: END IF;
960:
961: UPDATE psp_enc_controls
962: SET action_code = 'IU',/ * Changed from 'I' for Restart Update/Quick Update Encumbrance Lines * /
963: run_id = g_run_id
964: WHERE enc_control_id = enc_control_rec2.enc_control_id;
965: --insert into psp_stout values(55,'after updating psp_enc_controls');

Line 965: --insert into psp_stout values(55,'after updating psp_enc_controls');

961: UPDATE psp_enc_controls
962: SET action_code = 'IU',/ * Changed from 'I' for Restart Update/Quick Update Encumbrance Lines * /
963: run_id = g_run_id
964: WHERE enc_control_id = enc_control_rec2.enc_control_id;
965: --insert into psp_stout values(55,'after updating psp_enc_controls');
966: ----commit; Bug 2039196: commented this unnecessary commit.
967: END LOOP;
968: END IF;
969: else --- introduced else for 3413373

Line 988: UPDATE psp_enc_controls

984: CLOSE enc_control_cur3;
985: EXIT;
986: END IF;
987:
988: UPDATE psp_enc_controls
989: SET action_code = 'IL',
990: run_id = g_run_id
991: WHERE enc_control_id = enc_control_rec3.enc_control_id;
992:

Line 1037: UPDATE psp_enc_controls pec

1033: r_enc_controls.run_id, r_enc_controls.gl_phase,
1034: r_enc_controls.gms_phase, r_enc_controls.batch_name;
1035: CLOSE enc_control_status_cur1;
1036:
1037: UPDATE psp_enc_controls pec
1038: SET action_code = 'IL',
1039: run_id = g_run_id,
1040: liquidate_request_id = g_request_id
1041: WHERE payroll_id = l_payroll_id

Line 1066: UPDATE psp_enc_controls pec

1062: r_enc_controls.run_id, r_enc_controls.gl_phase,
1063: r_enc_controls.gms_phase, r_enc_controls.batch_name;
1064: CLOSE enc_control_status_cur2;
1065:
1066: UPDATE psp_enc_controls pec
1067: SET action_code = 'IU',
1068: run_id = g_run_id,
1069: liquidate_request_id = g_request_id
1070: WHERE payroll_id = l_payroll_id

Line 1100: UPDATE psp_enc_controls pec

1096: r_enc_controls.run_id, r_enc_controls.gl_phase,
1097: r_enc_controls.gms_phase, r_enc_controls.batch_name;
1098: CLOSE enc_control_status_cur3;
1099:
1100: UPDATE psp_enc_controls pec
1101: SET action_code = 'IT',
1102: run_id = g_run_id,
1103: liquidate_request_id = g_request_id
1104: WHERE payroll_id = p_payroll_id

Line 1222: -- This procedure updates the table PSP_ENC_CONTROLS with ACTION_CODE = 'L',

1218:
1219: -- ##########################################################################
1220: -- This procedure ends the encumbrance liquidation process
1221:
1222: -- This procedure updates the table PSP_ENC_CONTROLS with ACTION_CODE = 'L',
1223: -- if the program is completed with a return code of success and if the
1224: -- return code is failed it updates ACTION_CODE = 'P'
1225:
1226: -- When the program returns a failure status, it also updates

Line 1239: --FROM psp_enc_controls

1235: p_set_of_books_id IN NUMBER,
1236: p_return_status OUT NOCOPY VARCHAR2) IS
1237: CURSOR enc_control_cur IS
1238: SELECT DISTINCT enc_control_id
1239: --FROM psp_enc_controls
1240: FROM psp_enc_summary_lines
1241: --WHERE payroll_id = p_payroll_id
1242: WHERE payroll_action_id = p_payroll_action_id
1243: --AND run_id = g_run_id

Line 1276: FROM psp_enc_controls pec

1272: run_id,
1273: gl_phase,
1274: gms_phase,
1275: batch_name
1276: FROM psp_enc_controls pec
1277: --WHERE payroll_id = p_payroll_id
1278: WHERE payroll_action_id = p_payroll_action_id
1279: AND run_id = g_run_id
1280: AND business_group_id = g_bg_id

Line 1303: psp_enc_controls pec,

1299: DECODE(pesl.status_code, 'A', 'Accepted', 'L', 'Liquidated', 'S', 'Superceded', 'N', 'New', 'R', 'Rejected', pesl.status_code) status_code,
1300: SUM(pesl.summary_amount),
1301: COUNT(1)
1302: FROM psp_enc_summary_lines pesl,
1303: psp_enc_controls pec,
1304: per_assignments_f paf,
1305: per_people_f ppf
1306: WHERE pesl.enc_control_id = pec.enc_control_id
1307: AND paf.assignment_id = pesl.assignment_id

Line 1426: UPDATE psp_enc_controls

1422:
1423: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated change_flag to ''L'' in psp_enc_lines_history for lines that are liquidated');
1424:
1425: FORALL recno IN 1..t_enc_control_id.COUNT
1426: UPDATE psp_enc_controls
1427: SET action_code = 'L'
1428: WHERE enc_control_id = t_enc_control_id(recno)
1429: AND NOT EXISTS (SELECT 1
1430: FROM psp_enc_summary_lines pesl

Line 1434: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated action_code to ''L'' in psp_enc_controls for control records whose enc summary lines are completely liquidated');

1430: FROM psp_enc_summary_lines pesl
1431: WHERE pesl.enc_control_id = t_enc_control_id(recno)
1432: AND status_code IN ('N','R','A'));
1433:
1434: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated action_code to ''L'' in psp_enc_controls for control records whose enc summary lines are completely liquidated');
1435:
1436: FORALL recno IN 1..t_enc_control_id.COUNT
1437: UPDATE psp_enc_controls
1438: SET action_code = 'P'

Line 1437: UPDATE psp_enc_controls

1433:
1434: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated action_code to ''L'' in psp_enc_controls for control records whose enc summary lines are completely liquidated');
1435:
1436: FORALL recno IN 1..t_enc_control_id.COUNT
1437: UPDATE psp_enc_controls
1438: SET action_code = 'P'
1439: WHERE enc_control_id = t_enc_control_id(recno)
1440: AND EXISTS (SELECT 1
1441: FROM psp_enc_summary_lines pesl

Line 1445: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated action_code to ''P'' in psp_enc_controls for control records whose enc summary lines aren''t completely liquidated');

1441: FROM psp_enc_summary_lines pesl
1442: WHERE pesl.enc_control_id = t_enc_control_id(recno)
1443: AND status_code = 'A');
1444:
1445: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated action_code to ''P'' in psp_enc_controls for control records whose enc summary lines aren''t completely liquidated');
1446:
1447: UPDATE psp_enc_processes
1448: SET process_phase = 'completed',
1449: process_status = 'P'

Line 1666: FROM psp_enc_controls

1662: payroll_id,
1663: time_period_id,
1664: gl_phase,
1665: gms_phase
1666: FROM psp_enc_controls
1667: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
1668: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
1669: AND action_type in ('N', 'U', 'Q') -- Included 'Q' for Enh. 2143723
1670: AND action_code = DECODE(p_action_type,'U','IU','Q','IU','IL') / * Restart Update/Quick Update Encumbrance Lines Changes * /

Line 1769: UPDATE psp_enc_controls

1765: AND status_code = 'R';
1766:
1767: -- update status_code to 'P' in psp_payroll_controls
1768:
1769: UPDATE psp_enc_controls
1770: SET action_code = 'P',
1771: run_id = NULL
1772: WHERE enc_control_id = enc_control_rec.enc_control_id;
1773: ELSIF l_status_code = 'L' THEN

Line 1777: UPDATE psp_enc_controls

1773: ELSIF l_status_code = 'L' THEN
1774: -- NULL;
1775: if p_Action_type='L' and p_mode = 'N' then -- added p_mode for Bug 2039196
1776:
1777: UPDATE psp_enc_controls
1778: SET action_code = 'L',
1779: run_id = NULL
1780: WHERE enc_control_id = enc_control_rec.enc_control_id;
1781: update psp_enc_Controls set action_code='L' where

Line 1781: update psp_enc_Controls set action_code='L' where

1777: UPDATE psp_enc_controls
1778: SET action_code = 'L',
1779: run_id = NULL
1780: WHERE enc_control_id = enc_control_rec.enc_control_id;
1781: update psp_enc_Controls set action_code='L' where
1782: time_period_id=enc_control_rec.time_period_id and
1783: payroll_id=p_payroll_id;
1784:
1785: --required to update all previous records as well for this T.p to liquidated

Line 1800: update psp_enc_controls set action_code='P', run_id=null

1796: Control Records will have a status of 'L' if no accepted SummaryLines exist
1797: OR to 'P', if present, regardless of whether it is invoked in 'L', 'Q' and 'U' modes
1798: / * Added so that status not left in I * /
1799: if p_action_type IN ('Q', 'U') then -- Included 'Q' for Enh. 2143723
1800: update psp_enc_controls set action_code='P', run_id=null
1801: where enc_control_id=enc_control_rec.enc_control_id;
1802: elsif p_action_type = 'L' and p_mode ='R' then --- Bug 2039196: Introduced this condition
1803:
1804: -- Moved the following SELECT into cursor summary_line_count_cur

Line 1818: update psp_enc_controls set action_code='L' ---, run_id=null ...commented run_id = null for 3473294

1814: FETCH summary_line_count_cur INTO l_line_count;
1815: CLOSE summary_line_count_cur;
1816:
1817: if l_line_count = 0 then
1818: update psp_enc_controls set action_code='L' ---, run_id=null ...commented run_id = null for 3473294
1819: where enc_control_id=enc_control_rec.enc_control_id;
1820: else
1821: --- removed the code that leaves controls at IU for 3473294
1822: update psp_enc_controls set action_code='P' ---, run_id=null

Line 1822: update psp_enc_controls set action_code='P' ---, run_id=null

1818: update psp_enc_controls set action_code='L' ---, run_id=null ...commented run_id = null for 3473294
1819: where enc_control_id=enc_control_rec.enc_control_id;
1820: else
1821: --- removed the code that leaves controls at IU for 3473294
1822: update psp_enc_controls set action_code='P' ---, run_id=null
1823: where enc_control_id=enc_control_rec.enc_control_id;
1824: end if;
1825: -- end if; Commented this for enh. 2143723
1826: END LOOP; --enc control cur

Line 1868: DELETE FROM psp_enc_controls

1864: FETCH pending_enc_lines_cur INTO l_new_line_count;
1865: CLOSE pending_enc_lines_cur;
1866:
1867: IF (l_new_line_count = 0) THEN
1868: DELETE FROM psp_enc_controls
1869: WHERE action_type = p_action_type
1870: AND payroll_id = p_payroll_id
1871: AND action_code = 'N';
1872: END IF;

Line 1954: FROM psp_enc_controls pec

1950: DECODE(g_dff_grouping_option, 'Y', pesl.attribute9, NULL) attribute9,
1951: DECODE(g_dff_grouping_option, 'Y', pesl.attribute10, NULL) attribute10
1952: FROM psp_enc_summary_lines pesl
1953: WHERE pesl.enc_control_id IN (SELECT pec.enc_control_id
1954: FROM psp_enc_controls pec
1955: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
1956: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
1957: AND pec.run_id = g_run_id
1958: AND pec.business_group_id = g_bg_id

Line 1993: FROM psp_enc_controls pec

1989: DECODE(g_dff_grouping_option, 'Y', pesl.attribute9, NULL) attribute9,
1990: DECODE(g_dff_grouping_option, 'Y', pesl.attribute10, NULL) attribute10
1991: FROM psp_enc_summary_lines pesl
1992: WHERE pesl.enc_control_id IN (SELECT pec.enc_control_id
1993: FROM psp_enc_controls pec
1994: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
1995: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
1996: AND pec.run_id = g_run_id
1997: AND pec.business_group_id = g_bg_id

Line 2036: FROM psp_enc_controls pec

2032: DECODE(g_dff_grouping_option, 'Y', pesl.attribute9, NULL) attribute9,
2033: DECODE(g_dff_grouping_option, 'Y', pesl.attribute10, NULL) attribute10
2034: FROM psp_enc_summary_lines pesl
2035: WHERE pesl.enc_control_id IN (SELECT pec.enc_control_id
2036: FROM psp_enc_controls pec
2037: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
2038: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
2039: AND pec.run_id = g_run_id
2040: AND pec.business_group_id = g_bg_id

Line 2080: FROM psp_enc_controls pec

2076: DECODE(g_dff_grouping_option, 'Y', pesl.attribute9, NULL) attribute9,
2077: DECODE(g_dff_grouping_option, 'Y', pesl.attribute10, NULL) attribute10
2078: FROM psp_enc_summary_lines pesl
2079: WHERE enc_control_id IN (SELECT pec.enc_control_id
2080: FROM psp_enc_controls pec
2081: WHERE pec.payroll_id = NVL(p_payroll_id, pec.payroll_id)
2082: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
2083: AND pec.run_id = g_run_id
2084: AND pec.business_group_id = g_bg_id

Line 2230: UPDATE psp_enc_controls

2226:
2227: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code to ''S'' in psp_enc_summary_lines');
2228:
2229: FORALL recno IN 1..r_liq_lines.enc_summary_line_id.COUNT
2230: UPDATE psp_enc_controls
2231: SET gl_phase = 'Summarize'
2232: WHERE enc_control_id = r_liq_lines.enc_control_id(recno);
2233:
2234: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase to ''Summarize'' in psp_enc_controls');

Line 2234: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase to ''Summarize'' in psp_enc_controls');

2230: UPDATE psp_enc_controls
2231: SET gl_phase = 'Summarize'
2232: WHERE enc_control_id = r_liq_lines.enc_control_id(recno);
2233:
2234: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase to ''Summarize'' in psp_enc_controls');
2235:
2236: p_return_status := fnd_api.g_ret_sts_success;
2237:
2238: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');

Line 2262: FROM psp_enc_controls

2258: CURSOR enc_control_cur IS
2259: SELECT enc_control_id,
2260: payroll_id,
2261: time_period_id
2262: FROM psp_enc_controls
2263: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
2264: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
2265: AND action_type in ('N', 'U', 'Q') -- Included 'Q' for Enh. 2143723
2266: AND action_code IN ('IL','IU') -- Replaced I with IL and IU for Bug#2142865

Line 2324: psp_enc_lines_history pelh, psp_enc_controls pec

2320: AND (p_action_type='L' or
2321: (p_action_type='U' and
2322: pelh.assignment_id IN
2323: (SELECT distinct pelh.assignment_id FROM
2324: psp_enc_lines_history pelh, psp_enc_controls pec
2325: WHERE pec.enc_control_id=p_enc_control_id AND
2326: pelh.time_period_id=pec.time_period_id and pelh.change_flag='N')));
2327: Above cursor modified for bug fixes 1832670 and 1776752
2328:

Line 2414: update psp_enc_controls

2410: l_count := l_count + 1;
2411: END LOOP;
2412:
2413: if l_count > 0 then
2414: update psp_enc_controls
2415: set gl_phase = 'Summarize' --- replaced NULL for 2444657
2416: where enc_control_id = enc_control_rec.enc_control_id;
2417: l_count := 0;
2418: end if;

Line 2601: FROM psp_enc_controls

2597: SELECT enc_control_id,
2598: payroll_id,
2599: time_period_id,
2600: gl_phase ---added for 2444657
2601: FROM psp_enc_controls
2602: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
2603: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
2604: AND action_type in ('N', 'Q', 'U') -- Included 'Q' for Enh. 2143723
2605: AND action_code IN ('IT', 'IL','IU') -- Replaced I with IL and IU for Bug#2142865

Line 2723: FROM psp_enc_controls pec

2719: SELECT DISTINCT group_id
2720: FROM psp_enc_summary_lines pesl
2721: WHERE pesl.payroll_action_id = p_payroll_action_id
2722: /*WHERE enc_control_id IN (SELECT pec.enc_control_id
2723: FROM psp_enc_controls pec
2724: WHERE pec.payroll_id = NVL(p_payroll_id, pec.payroll_id)
2725: AND action_type IN ('N', 'U', 'Q')
2726: AND action_code IN ('IT', 'IL', 'IU')
2727: AND pec.run_id = g_run_id

Line 2783: FROM psp_enc_controls pec

2779: AND gl_code_combination_id IS NOT NULL
2780: AND superceded_line_id IS NOT NULL
2781: AND payroll_action_id = p_payroll_action_id;
2782: /* AND enc_control_id IN (SELECT pec.enc_control_id
2783: FROM psp_enc_controls pec
2784: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
2785: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
2786: AND action_type IN ('N', 'U', 'Q')
2787: AND action_code IN ('IT', 'IL', 'IU')

Line 2834: psp_enc_controls pec

2830: attribute24, attribute25, attribute26,
2831: attribute27, attribute28, attribute29,
2832: attribute30
2833: FROM psp_enc_summary_lines pesl,
2834: psp_enc_controls pec
2835: WHERE pec.enc_control_id = pesl.enc_control_id
2836: AND pesl.status_code = 'N'
2837: AND pesl.gl_code_combination_id is NOT NULL
2838: AND superceded_line_id IS NOT NULL

Line 2841: FROM psp_enc_controls pec

2837: AND pesl.gl_code_combination_id is NOT NULL
2838: AND superceded_line_id IS NOT NULL
2839: AND pesl.payroll_action_id = p_payroll_action_id;
2840: /* AND enc_control_id IN (SELECT pec.enc_control_id
2841: FROM psp_enc_controls pec
2842: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
2843: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
2844: AND action_type IN ('N', 'U', 'Q')
2845: AND action_code IN ('IT', 'IL', 'IU')

Line 3072: update psp_enc_controls

3068: ELSE
3069: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Journal Import (req_id: ' || req_id || ')');
3070: -- insert into psp_stout values(94, 'transfer in Gl');
3071: /***** Converted the following UPDATE TO BULK for R12 performance fixes (bug 4507892)
3072: update psp_enc_controls
3073: set gl_phase = 'Transfer'
3074: where enc_control_id in (select distinct enc_control_id
3075: from psp_enc_summary_lines
3076: where group_id = l_group_id);

Line 3086: UPDATE psp_enc_controls

3082:
3083: 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);
3084:
3085: FORALL I IN 1..r_enc_controls.enc_control_id.COUNT
3086: UPDATE psp_enc_controls
3087: SET gl_phase = 'Transfer'
3088: WHERE enc_control_id = r_enc_controls.enc_control_id(I);
3089:
3090: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase to ''Transfer'' in psp_enc_controls');

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

3086: UPDATE psp_enc_controls
3087: SET gl_phase = 'Transfer'
3088: WHERE enc_control_id = r_enc_controls.enc_control_id(I);
3089:
3090: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase to ''Transfer'' in psp_enc_controls');
3091:
3092: r_enc_controls.enc_control_id.DELETE;
3093: -- End of Changes for bug fix 4507892
3094:

Line 3622: UPDATE psp_enc_controls pec

3618: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from psp_enc_summary_lines');
3619:
3620: -- Introduced the following for bug fix 4625734
3621: FORALL recno IN 1..r_enc_controls.enc_control_id.COUNT
3622: UPDATE psp_enc_controls pec
3623: SET gl_phase = 'TieBack'
3624: WHERE enc_control_id = r_enc_controls.enc_control_id(recno);
3625: -- End of changes for bug fix 4625734
3626:

Line 3701: UPDATE psp_enc_controls

3697: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_rejected_group_id: ' || g_rejected_group_id);
3698: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' SQL%ROWCOUNT: ' || SQL%ROWCOUNT);
3699:
3700: FORALL recno IN 1..r_interface.status.COUNT
3701: UPDATE psp_enc_controls
3702: SET gl_phase = 'TieBack'
3703: WHERE enc_control_id IN (SELECT pesl.enc_control_id
3704: FROM psp_enc_summary_lines pesl
3705: WHERE pesl.enc_summary_line_id = r_interface.enc_summary_line_id(recno));

Line 3710: UPDATE psp_enc_controls

3706:
3707: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' TieBack SQL%ROWCOUNT: ' || SQL%ROWCOUNT);
3708:
3709: FORALL recno IN 1..r_interface.status.COUNT
3710: UPDATE psp_enc_controls
3711: SET gl_phase = 'Summarize'
3712: WHERE enc_control_id IN (SELECT pesl.enc_control_id
3713: FROM psp_enc_summary_lines pesl
3714: WHERE pesl.enc_summary_line_id = r_interface.enc_summary_line_id(recno)

Line 3746: UPDATE psp_enc_controls pec

3742: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated respective lines in psp_enc_lines_history to ''L'' status SQL%ROWCOUNT: ' || SQL%ROWCOUNT);
3743: END IF;
3744:
3745: FORALL recno IN 1..r_interface.enc_control_id.COUNT
3746: UPDATE psp_enc_controls pec
3747: SET gl_phase = 'TieBack',
3748: summ_gl_dr_amount = NVL(summ_gl_dr_amount, 0) + DECODE(r_interface.dr_cr_flag(recno), 'D', r_interface.summary_amount(recno), 0),
3749: summ_gl_cr_amount = NVL(summ_gl_cr_amount, 0) + DECODE(r_interface.dr_cr_flag(recno), 'C', r_interface.summary_amount(recno), 0)
3750: WHERE enc_control_id = r_interface.enc_control_id(recno);

Line 3751: 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 SQL%ROWCOUNT: ' || SQL%ROWCOUNT);

3747: SET gl_phase = 'TieBack',
3748: summ_gl_dr_amount = NVL(summ_gl_dr_amount, 0) + DECODE(r_interface.dr_cr_flag(recno), 'D', r_interface.summary_amount(recno), 0),
3749: summ_gl_cr_amount = NVL(summ_gl_cr_amount, 0) + DECODE(r_interface.dr_cr_flag(recno), 'C', r_interface.summary_amount(recno), 0)
3750: WHERE enc_control_id = r_interface.enc_control_id(recno);
3751: 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 SQL%ROWCOUNT: ' || SQL%ROWCOUNT);
3752: END IF;
3753:
3754: /***** Commented the following for bug fix 4625734
3755: IF l_cnt_gl_interface > 0 THEN

Line 3905: UPDATE psp_enc_controls

3901: Record for invalid suspense reason in control record record so
3902: that Restart Update can derive the failed point * /
3903: IF l_return_value <> 'PROFILE_VAL_DATE_MATCHES' THEN
3904: IF p_action_type IN ('Q','U') THEN
3905: UPDATE psp_enc_controls
3906: SET gl_phase = 'INVALID_SUSPENSE'
3907: WHERE enc_control_id = p_enc_control_id;
3908: END IF;
3909: g_invalid_suspense:='Y';

Line 3926: UPDATE psp_enc_controls

3922: x_susp_nf_org_name := l_orig_org_name;
3923: x_susp_nf_date := l_encumbrance_date; Commented for bug 2056877 * /
3924: / * Added for Restart Update/Quick Update Encumbrance Lines Enh. * /
3925: IF p_action_type IN ('Q','U') THEN
3926: UPDATE psp_enc_controls
3927: SET gl_phase = 'INVALID_SUSPENSE'
3928: WHERE enc_control_id = p_enc_control_id;
3929: END IF;
3930: g_invalid_suspense:='Y';

Line 4021: update psp_enc_controls

4017: End of comment for Enh. 2768298 Removal of suspense posting in Enc. Liquidation ***** /
4018:
4019: END LOOP;
4020: if nvl(g_gl_run,FALSE) then
4021: update psp_enc_controls
4022: set gl_phase = 'Summarize' --- replaced 'TieBack' .... for 2444657
4023: where enc_control_id = p_enc_control_id;
4024: else
4025: update psp_enc_controls --- introduced else part for 3413373

Line 4025: update psp_enc_controls --- introduced else part for 3413373

4021: update psp_enc_controls
4022: set gl_phase = 'Summarize' --- replaced 'TieBack' .... for 2444657
4023: where enc_control_id = p_enc_control_id;
4024: else
4025: update psp_enc_controls --- introduced else part for 3413373
4026: set gl_phase = 'TieBack'
4027: where enc_control_id = p_enc_control_id;
4028: end if;
4029: / * commented: Bug 2039196

Line 4041: UPDATE psp_enc_controls

4037: / ***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
4038: IF l_suspense_ac_failed = 'Y' THEN
4039: / * Added for Restart Update/Quick Update Encumbrance Lines Enh. * /
4040: IF p_action_type IN ('Q','U') THEN
4041: UPDATE psp_enc_controls
4042: SET gl_phase = 'INVALID_SUSPENSE'
4043: WHERE enc_control_id = p_enc_control_id;
4044: END IF;
4045: -- removed statement set invalid susp to 'Y' for 2479579

Line 4117: UPDATE psp_enc_controls

4113:
4114: * /
4115:
4116: if l_dr_cr_flag = 'D' then
4117: UPDATE psp_enc_controls
4118: SET summ_gl_cr_amount = l_dr_summary_amount
4119: WHERE enc_control_id = p_enc_control_id;
4120: elsif l_dr_cr_flag = 'C' then
4121: UPDATE psp_enc_controls

Line 4121: UPDATE psp_enc_controls

4117: UPDATE psp_enc_controls
4118: SET summ_gl_cr_amount = l_dr_summary_amount
4119: WHERE enc_control_id = p_enc_control_id;
4120: elsif l_dr_cr_flag = 'C' then
4121: UPDATE psp_enc_controls
4122: SET summ_gl_dr_amount = l_cr_summary_amount
4123: WHERE enc_control_id = p_enc_control_id;
4124: end if;
4125: --- moved this stmnt from below endif..for 2444657

Line 4126: update psp_enc_controls

4122: SET summ_gl_dr_amount = l_cr_summary_amount
4123: WHERE enc_control_id = p_enc_control_id;
4124: end if;
4125: --- moved this stmnt from below endif..for 2444657
4126: update psp_enc_controls
4127: set gl_phase = 'TieBack'
4128: where enc_control_id = p_enc_control_id;
4129:
4130: END IF;

Line 4388: FROM psp_enc_controls pec

4384: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
4385: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
4386: FROM psp_enc_summary_lines pesl
4387: WHERE enc_control_id IN (SELECT pec.enc_control_id
4388: FROM psp_enc_controls pec
4389: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
4390: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
4391: AND action_type IN ('N', 'U', 'Q')
4392: AND action_code = 'IL'

Line 4434: FROM psp_enc_controls pec

4430: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
4431: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
4432: FROM psp_enc_summary_lines pesl
4433: WHERE enc_control_id IN (SELECT pec.enc_control_id
4434: FROM psp_enc_controls pec
4435: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
4436: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
4437: AND action_type IN ('N', 'U', 'Q')
4438: AND action_code = 'IU'

Line 4484: FROM psp_enc_controls pec

4480: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
4481: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
4482: FROM psp_enc_summary_lines pesl
4483: WHERE enc_control_id IN (SELECT pec.enc_control_id
4484: FROM psp_enc_controls pec
4485: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
4486: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
4487: AND action_type IN ('N', 'U', 'Q')
4488: AND action_code = 'IU'

Line 4535: FROM psp_enc_controls pec

4531: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
4532: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
4533: FROM psp_enc_summary_lines pesl
4534: WHERE enc_control_id IN (SELECT pec.enc_control_id
4535: FROM psp_enc_controls pec
4536: WHERE pec.payroll_id = NVL(p_payroll_id, pec.payroll_id)
4537: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
4538: AND action_type IN ('N', 'U', 'Q')
4539: AND action_code = 'IT'

Line 4712: UPDATE psp_enc_controls

4708:
4709: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code to ''S'' in psp_enc_summary_lines');
4710:
4711: FORALL recno IN 1..r_liq_lines.enc_summary_line_id.COUNT
4712: UPDATE psp_enc_controls
4713: SET gms_phase = 'Summarize'
4714: WHERE enc_control_id = r_liq_lines.enc_control_id(recno);
4715:
4716: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''Summarize'' in psp_enc_controls');

Line 4716: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''Summarize'' in psp_enc_controls');

4712: UPDATE psp_enc_controls
4713: SET gms_phase = 'Summarize'
4714: WHERE enc_control_id = r_liq_lines.enc_control_id(recno);
4715:
4716: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''Summarize'' in psp_enc_controls');
4717:
4718: p_return_status := fnd_api.g_ret_sts_success;
4719:
4720: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');

Line 4744: FROM psp_enc_controls

4740: CURSOR enc_control_cur IS
4741: SELECT enc_control_id,
4742: payroll_id,
4743: time_period_id
4744: FROM psp_enc_controls
4745: WHERE payroll_id = nvl(p_payroll_id, payroll_id)
4746: AND (total_dr_amount IS NOT NULL OR total_cr_amount IS NOT NULL)
4747: AND action_type in ('N', 'Q', 'U') -- Included 'Q' for Enh. 2143723
4748: AND action_code IN ('IL','IU') -- Replaced I with IL and IU for Bug#2142865

Line 4812: psp_enc_controls pec

4808:
4809: AND (p_action_type='L') or
4810: (p_action_type='U' and
4811: pesl.assignment_id in (select pelh.assignment_id FROM psp_enc_lines_history pelh,
4812: psp_enc_controls pec
4813: where pec.enc_control_id=p_enc_control_id AND
4814: pelh.time_period_id=pec.time_period_id
4815: and pelh.change_flag='N'));
4816:

Line 4846: update psp_enc_controls

4842: G_GMS_AVAILABLE := FALSE;
4843: CLOSE enc_liq_cur;
4844: EXIT;
4845: ELSIF enc_liq_cur%NOTFOUND THEN
4846: update psp_enc_controls
4847: set gms_phase = 'Summarize' --- replaced NULL...for 2444657
4848: where enc_control_id = enc_control_rec.enc_control_id;
4849:
4850: G_GMS_AVAILABLE := TRUE;

Line 5001: psp_enc_controls pec

4997: pa_projects_all ppa,
4998: pa_tasks pt,
4999: per_time_periods ptp,
5000: per_all_people_f papf,
5001: psp_enc_controls pec
5002: WHERE pesl.payroll_action_id = p_payroll_action_id
5003: AND pec.enc_control_id = pesl.enc_control_id
5004: AND pesl.status_code = 'N'
5005: AND pesl.gl_code_combination_id is NULL

Line 5094: FROM psp_enc_controls pec

5090: SELECT DISTINCT gms_batch_name
5091: FROM psp_enc_summary_lines pesl
5092: WHERE pesl.payroll_action_id = p_payroll_action_id
5093: /*WHERE enc_control_id IN (SELECT pec.enc_control_id
5094: FROM psp_enc_controls pec
5095: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
5096: AND pec.run_id = g_run_id
5097: AND pec.business_group_id = g_bg_id
5098: AND pec.set_of_books_id = g_sob_id

Line 5748: update psp_enc_controls

5744: ELSE
5745: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');
5746:
5747: /***** Modified teh following update to BULK UPDATE for R12 performance fixes (bug 4507892)
5748: update psp_enc_controls
5749: set gms_phase = 'Transfer'
5750: where enc_control_id in (select distinct enc_control_id
5751: from psp_enc_summary_lines
5752: where gms_batch_name = g_gms_batch_name); --- replaced with global for 3473294

Line 5760: UPDATE psp_enc_controls

5756: FETCH enc_control_id_cur BULK COLLECT INTO r_enc_controls.enc_control_id;
5757: CLOSE enc_control_id_cur;
5758:
5759: FORALL I IN 1..r_enc_controls.enc_control_id.COUNT
5760: UPDATE psp_enc_controls
5761: SET gms_phase = 'Transfer'
5762: WHERE enc_control_id = r_enc_controls.enc_control_id(I);
5763:
5764: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''Transfer'' in psp_enc_controls SQL%ROWCOUNT: ' || SQL%ROWCOUNT);

Line 5764: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''Transfer'' in psp_enc_controls SQL%ROWCOUNT: ' || SQL%ROWCOUNT);

5760: UPDATE psp_enc_controls
5761: SET gms_phase = 'Transfer'
5762: WHERE enc_control_id = r_enc_controls.enc_control_id(I);
5763:
5764: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''Transfer'' in psp_enc_controls SQL%ROWCOUNT: ' || SQL%ROWCOUNT);
5765:
5766: r_enc_controls.enc_control_id.DELETE;
5767: -- End of changes for bug fix 4507892
5768: END IF;

Line 6273: UPDATE psp_enc_controls pec

6269: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from psp_enc_summary_lines');
6270:
6271: -- Introduced the folowing for bug fix 4625734
6272: FORALL recno IN 1..r_enc_controls.enc_control_id.COUNT
6273: UPDATE psp_enc_controls pec
6274: SET gms_phase = 'TieBack'
6275: WHERE enc_control_id = r_enc_controls.enc_control_id(recno);
6276:
6277: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''TieBack'' in psp_enc_controls');

Line 6277: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''TieBack'' in psp_enc_controls');

6273: UPDATE psp_enc_controls pec
6274: SET gms_phase = 'TieBack'
6275: WHERE enc_control_id = r_enc_controls.enc_control_id(recno);
6276:
6277: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''TieBack'' in psp_enc_controls');
6278:
6279: r_enc_controls.enc_control_id.DELETE;
6280: g_liq_has_failed_transactions := TRUE;
6281: -- End of changes for bug fix 4625734

Line 6380: UPDATE psp_enc_controls pec

6376:
6377: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' r_success_recs.enc_summary_line_id.COUNT: ' || r_success_recs.enc_summary_line_id.COUNT);
6378:
6379: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6380: UPDATE psp_enc_controls pec
6381: SET gms_phase = 'TieBack',
6382: 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),
6383: 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)
6384: WHERE enc_control_id = r_success_recs.enc_control_id(recno);

Line 6386: 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');

6382: 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),
6383: 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)
6384: WHERE enc_control_id = r_success_recs.enc_control_id(recno);
6385:
6386: 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');
6387:
6388: r_reject_recs.enc_summary_line_id.DELETE;
6389: r_reject_recs.enc_control_id.DELETE;
6390: r_reject_recs.reason_code.DELETE;

Line 6554: UPDATE psp_enc_controls

6550: ---------------------------------------------------------------------- * /
6551: / * Added for Restart Update/Quick Update Encumbrance Lines Enh. * /
6552: IF l_return_value <> 'PROFILE_VAL_DATE_MATCHES' THEN
6553: IF p_action_type IN ('Q','U') THEN
6554: UPDATE psp_enc_controls
6555: SET gms_phase='INVALID_SUSPENSE'
6556: WHERE enc_control_id=p_enc_control_id;
6557: END IF;
6558: g_invalid_suspense:='Y';

Line 6576: UPDATE psp_enc_controls

6572: x_susp_nf_org_name := l_orig_org_name;
6573: x_susp_nf_date := l_encumbrance_date; Bug 2056877 * /
6574: / * Added for Restart Update/Quick Update Encumbrance Lines * /
6575: IF p_action_type IN ('Q','U') THEN
6576: UPDATE psp_enc_controls
6577: SET gms_phase = 'INVALID_SUSPENSE'
6578: WHERE enc_control_id = p_enc_control_id;
6579: END IF;
6580: g_invalid_suspense:='Y';

Line 6663: UPDATE psp_enc_controls

6659: END LOOP;
6660: End of comment for Enh. 2768298 Removal of suspense posting in Enc. Liquidation ***** /
6661: END LOOP;
6662:
6663: UPDATE psp_enc_controls
6664: SET summ_ogm_cr_amount = nvl(summ_ogm_cr_amount, 0) + l_cr_summary_amount,
6665: summ_ogm_dr_amount = nvl(summ_ogm_dr_amount, 0) + l_dr_summary_amount,
6666: gms_phase = 'TieBack'
6667: WHERE enc_control_id = p_enc_control_id;

Line 6679: UPDATE psp_enc_controls

6675: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6676: fnd_msg_pub.add;
6677: / * Added the below IF condition for Restart Update/Quick Update Encumbrance Lines Enh. * /
6678: IF p_action_type IN ('Q','U') THEN
6679: UPDATE psp_enc_controls
6680: SET gms_phase = 'INVALID_SUSPENSE'
6681: WHERE enc_control_id = p_enc_control_id;
6682: END IF;
6683: --g_invalid_suspense:='Y'; commented for 2479579

Line 6729: UPDATE psp_enc_controls pec

6725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated change_flag to ''L'' in psp_enc_lines_history for employee level liquidation');
6726: END IF;
6727:
6728: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6729: UPDATE psp_enc_controls pec
6730: SET gms_phase = 'TieBack',
6731: 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),
6732: 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)
6733: WHERE enc_control_id = r_success_recs.enc_control_id(recno);

Line 6735: 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');

6731: 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),
6732: 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)
6733: WHERE enc_control_id = r_success_recs.enc_control_id(recno);
6734:
6735: 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');
6736:
6737: r_success_recs.enc_summary_line_id.DELETE;
6738: r_success_recs.enc_control_id.DELETE;
6739: r_success_recs.reason_code.DELETE;

Line 6800: UPDATE psp_enc_controls

6796: and gl_project_flag = 'P'
6797: and gms_batch_name=p_gms_batch_name
6798: and status_code = 'A';
6799: * /
6800: UPDATE psp_enc_controls
6801: SET summ_ogm_cr_amount = l_cr_summary_amount,
6802: summ_ogm_dr_amount = l_dr_summary_amount,
6803: gms_phase = 'TieBack'
6804: WHERE enc_control_id = p_enc_control_id;

Line 7036: from psp_enc_controls CTRL

7032: --- left with 'S'
7033: / ***** Modified the following cursor for bug fix 4625734
7034: cursor inprogress_controls_cur is
7035: select CTRL.payroll_id, min(CTRL.time_period_id) time_period_id
7036: from psp_enc_controls CTRL
7037: where CTRL.action_code = 'IT'
7038: and (CTRL.payroll_id, CTRL.time_period_id) in
7039: (select ASG.payroll_id, min(PER.time_period_id)
7040: from per_all_assignments_f ASG,

Line 7055: FROM psp_enc_controls pec

7051: SELECT pec.liquidate_request_id,
7052: pec.payroll_id,
7053: MIN(pec.time_period_id),
7054: MIN(enc_control_id)
7055: FROM psp_enc_controls pec
7056: WHERE pec.action_code = 'IT'
7057: GROUP BY pec.liquidate_request_id, pec.payroll_id;
7058:
7059: l_request_id NUMBER(15);

Line 7159: UPDATE psp_enc_controls

7155:
7156: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' t_enc_control_id.COUNT: ' || t_enc_control_id.COUNT);
7157:
7158: FORALL recno IN 1..t_enc_control_id.COUNT
7159: UPDATE psp_enc_controls
7160: SET number_of_dr = (SELECT number_of_dr - COUNT(1)
7161: FROM psp_enc_lines
7162: WHERE enc_control_id = t_enc_control_id(recno)
7163: AND dr_cr_flag = 'D'

Line 7214: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated number_of_dr, number_of_cr, total_dr_amount, total_cr_amount, gl_dr_amount, gl_cr_amount, ogm_dr_amount, ogm_cr_cmount in psp_enc_controls');

7210: AND person_id = p_person_id
7211: AND encumbrance_date > p_actual_term_date)
7212: WHERE enc_control_id = t_enc_control_id(recno);
7213:
7214: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated number_of_dr, number_of_cr, total_dr_amount, total_cr_amount, gl_dr_amount, gl_cr_amount, ogm_dr_amount, ogm_cr_cmount in psp_enc_controls');
7215:
7216: DELETE psp_enc_lines
7217: WHERE person_id = p_person_id
7218: AND encumbrance_date > p_actual_term_date;