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 1801: SELECT gl_bc_packets_s.nextval

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

Line 1806: INSERT INTO gl_bc_packets

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

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

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

Line 2037: SELECT gl_bc_packets_s.nextval

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

Line 2042: INSERT INTO gl_bc_packets

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

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

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

Line 2275: SELECT gl_bc_packets_s.nextval

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

Line 2280: INSERT INTO gl_bc_packets

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

Line 2496: SELECT gl_bc_packets_s.nextval

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

Line 2501: INSERT INTO gl_bc_packets

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

Line 2722: SELECT gl_bc_packets_s.nextval

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

Line 2727: INSERT INTO gl_bc_packets

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

Line 2916: SELECT gl_bc_packets_s.nextval

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

Line 2921: INSERT INTO gl_bc_packets

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