DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on GL_BC_PACKETS_S

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 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 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 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 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 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