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.IGC_CBC_PO_YEAR_END_PKG dependencies on GL_BC_PACKETS

Line 1802: SELECT gl_bc_packets_s.nextval

1798: IF (g_debug_mode = 'Y') THEN
1799: Put_Debug_Msg (l_full_path,p_debug_msg => 'Starting Req Adjustments for POs');
1800: END IF;
1801: -- cancel the requisition encumbrance in the previous year
1802: SELECT gl_bc_packets_s.nextval
1803: INTO l_packet_id
1804: FROM DUAL;
1805:
1806: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST

Line 1807: INSERT INTO gl_bc_packets

1803: INTO l_packet_id
1804: FROM DUAL;
1805:
1806: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
1807: INSERT INTO gl_bc_packets
1808: (
1809: packet_id,
1810: Ledger_id,
1811: je_source_name,

Line 2010: Put_Debug_Msg (l_full_path,p_debug_msg => 'Completed insert to gl_bc_packets');

2006:
2007: -- COMMIT;
2008:
2009: IF (g_debug_mode = 'Y') THEN
2010: Put_Debug_Msg (l_full_path,p_debug_msg => 'Completed insert to gl_bc_packets');
2011: END IF;
2012: l_result_code := gl_funds_checker_pkg.glxfck(
2013: p_sobid => p_sobid,
2014: p_packetid => l_packet_id,

Line 2038: SELECT gl_bc_packets_s.nextval

2034: Put_Debug_Msg (l_full_path,p_debug_msg => 'Completed prev year adjustment');
2035: END IF;
2036:
2037: -- Now repeat the above to cancel the requisition encumbrances in the current year
2038: SELECT gl_bc_packets_s.nextval
2039: INTO l_packet_id
2040: FROM DUAL;
2041:
2042: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST

Line 2043: INSERT INTO gl_bc_packets

2039: INTO l_packet_id
2040: FROM DUAL;
2041:
2042: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2043: INSERT INTO gl_bc_packets
2044: (
2045: packet_id,
2046: Ledger_id,
2047: je_source_name,

Line 2245: Put_Debug_Msg (l_full_path,p_debug_msg => 'Completed insert to gl_bc_packets');

2241:
2242: -- COMMIT;
2243:
2244: IF (g_debug_mode = 'Y') THEN
2245: Put_Debug_Msg (l_full_path,p_debug_msg => 'Completed insert to gl_bc_packets');
2246: END IF;
2247: l_result_code := gl_funds_checker_pkg.glxfck(
2248: p_sobid => p_sobid,
2249: p_packetid => l_packet_id,

Line 2276: SELECT gl_bc_packets_s.nextval

2272: IF (g_debug_mode = 'Y') THEN
2273: Put_Debug_Msg (l_full_path,p_debug_msg => 'Starting Req Adjustments for Releases');
2274: END IF;
2275: -- cancel the requisition encumbrance in the previous year
2276: SELECT gl_bc_packets_s.nextval
2277: INTO l_packet_id
2278: FROM DUAL;
2279:
2280: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST

Line 2281: INSERT INTO gl_bc_packets

2277: INTO l_packet_id
2278: FROM DUAL;
2279:
2280: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2281: INSERT INTO gl_bc_packets
2282: (
2283: packet_id,
2284: Ledger_id,
2285: je_source_name,

Line 2497: SELECT gl_bc_packets_s.nextval

2493: Put_Debug_Msg (l_full_path,p_debug_msg => 'Completed prev year adjustment');
2494: END IF;
2495:
2496: -- Now repeat the above to cancel the requisition encumbrances in the current year
2497: SELECT gl_bc_packets_s.nextval
2498: INTO l_packet_id
2499: FROM DUAL;
2500:
2501: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST

Line 2502: INSERT INTO gl_bc_packets

2498: INTO l_packet_id
2499: FROM DUAL;
2500:
2501: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2502: INSERT INTO gl_bc_packets
2503: (
2504: packet_id,
2505: Ledger_id,
2506: je_source_name,

Line 2723: SELECT gl_bc_packets_s.nextval

2719: IF (g_debug_mode = 'Y') THEN
2720: Put_Debug_Msg (l_full_path,p_debug_msg => 'Starting PO Adjustments for Releases');
2721: END IF;
2722: -- cancel the PO encumbrance in the previous year
2723: SELECT gl_bc_packets_s.nextval
2724: INTO l_packet_id
2725: FROM DUAL;
2726:
2727: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST

Line 2728: INSERT INTO gl_bc_packets

2724: INTO l_packet_id
2725: FROM DUAL;
2726:
2727: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2728: INSERT INTO gl_bc_packets
2729: (
2730: packet_id,
2731: Ledger_id,
2732: je_source_name,

Line 2917: SELECT gl_bc_packets_s.nextval

2913: Put_Debug_Msg (l_full_path,p_debug_msg => 'Completed prev year adjustment');
2914: END IF;
2915:
2916: -- Now repeat the above to cancel the requisition encumbrances in the current year
2917: SELECT gl_bc_packets_s.nextval
2918: INTO l_packet_id
2919: FROM DUAL;
2920:
2921: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST

Line 2922: INSERT INTO gl_bc_packets

2918: INTO l_packet_id
2919: FROM DUAL;
2920:
2921: FORALL l_index IN p_distribution_id_tbl.FIRST .. p_distribution_id_tbl.LAST
2922: INSERT INTO gl_bc_packets
2923: (
2924: packet_id,
2925: Ledger_id,
2926: je_source_name,