APPS.OE_ORDER_COPY_UTIL dependencies on OE_HOLD_SOURCES_PVT

Line 870: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;

866: IS
867: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Hdr_Holds';
868: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
869: k NUMBER := 1;
870: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;
871: l_return_status VARCHAR2(1);
872: l_v_number NUMBER;
873:
874: --

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

906:
907: -- Load Order Based holds for Copying
908:
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE' , 2 ) ;
911: END IF;
912:
913: OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE(p_header_id,
914: l_hold_source_tbl,

Line 913: OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE(p_header_id,

909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE' , 2 ) ;
911: END IF;
912:
913: OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE(p_header_id,
914: l_hold_source_tbl,
915: l_return_status);
916:
917: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920:
921: IF l_debug_level > 0 THEN
922: oe_debug_pub.add( 'AFTER OE_HOLD_SOURCES_PVT.QUERY_HOLD_SOURCE' , 2 ) ;
923: END IF;
924:
925: IF (l_hold_source_tbl.COUNT > 0) THEN
926: FOR curr in l_hold_source_tbl.FIRST .. l_hold_source_tbl.LAST LOOP

Line 1118: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;

1114: IS
1115: l_api_name CONSTANT VARCHAR(30) := 'Load_and_Init_Line_Holds';
1116: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1117: k NUMBER := 1;
1118: l_hold_source_tbl OE_Hold_Sources_PVT.Hold_Source_TBL;
1119: l_return_status VARCHAR2(1);
1120:
1121: --
1122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

1131:
1132: -- Load Order Based holds for Copying
1133:
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source' , 2 ) ;
1136: END IF;
1137:
1138: OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source(p_line_id,
1139: l_hold_source_tbl,

Line 1138: OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source(p_line_id,

1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'CALLING OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source' , 2 ) ;
1136: END IF;
1137:
1138: OE_HOLD_SOURCES_PVT.Query_Line__Hold_Source(p_line_id,
1139: l_hold_source_tbl,
1140: l_return_status);
1141:
1142: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN