APPS.OE_ORDER_COPY_UTIL dependencies on OE_HOLD_SOURCES_PVT

Line 942: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;

938: IS
939: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Holds';
940: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
941: k NUMBER := 1;
942: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;
943: l_return_status VARCHAR2(1);
944: l_v_number NUMBER;
945:
946: --

Line 982: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE' , 2 ) ;

978:
979: -- Load Order Based holds for Copying
980:
981: IF l_debug_level > 0 THEN
982: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE' , 2 ) ;
983: END IF;
984:
985: OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE(p_header_id,
986: l_hold_source_tbl,

Line 985: OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE(p_header_id,

981: IF l_debug_level > 0 THEN
982: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE' , 2 ) ;
983: END IF;
984:
985: OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE(p_header_id,
986: l_hold_source_tbl,
987: l_return_status);
988:
989: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 994: oe_debug_pub.add( 'AFTER OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE' , 2 ) ;

990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992:
993: IF l_debug_level > 0 THEN
994: oe_debug_pub.add( 'AFTER OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE' , 2 ) ;
995: END IF;
996:
997: IF (l_hold_source_tbl.COUNT > 0) THEN
998: FOR curr in l_hold_source_tbl.FIRST .. l_hold_source_tbl.LAST LOOP

Line 1190: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;

1186: IS
1187: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Line_Holds';
1188: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1189: k NUMBER := 1;
1190: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;
1191: l_return_status VARCHAR2(1);
1192:
1193: --
1194: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1207: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source' , 2 ) ;

1203:
1204: -- Load Order Based holds for Copying
1205:
1206: IF l_debug_level > 0 THEN
1207: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source' , 2 ) ;
1208: END IF;
1209:
1210: OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source(p_line_id,
1211: l_hold_source_tbl,

Line 1210: OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source(p_line_id,

1206: IF l_debug_level > 0 THEN
1207: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source' , 2 ) ;
1208: END IF;
1209:
1210: OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source(p_line_id,
1211: l_hold_source_tbl,
1212: l_return_status);
1213:
1214: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN