DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on OE_PURCHASE_RELEASE_PVT

Line 1207: OE_Purchase_Release_PVT.Purchase_Release to release the

1203:
1204: /*-----------------------------------------------------------------------
1205: Procedure : Release the line to Purchasing
1206: Description: This procedure validates the line and calls
1207: OE_Purchase_Release_PVT.Purchase_Release to release the
1208: line to purchase (i.e: insert into req interface tables).
1209: ----------------------------------------------------------------------- */
1210:
1211: PROCEDURE Release_to_purchasing(

Line 1220: l_drop_ship_line_rec OE_Purchase_Release_PVT.Drop_Ship_Line_Rec_Type;

1216: resultout in out nocopy varchar2) /* file.sql.39 change */
1217: IS
1218: l_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_header_rec OE_Order_PUB.Header_Rec_Type;
1220: l_drop_ship_line_rec OE_Purchase_Release_PVT.Drop_Ship_Line_Rec_Type;
1221: l_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1222: ll_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1223: l_return_status VARCHAR2(1);
1224: l_msg_count NUMBER;

Line 1221: l_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;

1217: IS
1218: l_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_header_rec OE_Order_PUB.Header_Rec_Type;
1220: l_drop_ship_line_rec OE_Purchase_Release_PVT.Drop_Ship_Line_Rec_Type;
1221: l_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1222: ll_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1223: l_return_status VARCHAR2(1);
1224: l_msg_count NUMBER;
1225: l_msg_data VARCHAR2(2000);

Line 1222: ll_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;

1218: l_line_rec OE_Order_PUB.Line_Rec_Type;
1219: l_header_rec OE_Order_PUB.Header_Rec_Type;
1220: l_drop_ship_line_rec OE_Purchase_Release_PVT.Drop_Ship_Line_Rec_Type;
1221: l_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1222: ll_drop_ship_tbl OE_Purchase_Release_PVT.Drop_Ship_Tbl_Type;
1223: l_return_status VARCHAR2(1);
1224: l_msg_count NUMBER;
1225: l_msg_data VARCHAR2(2000);
1226: l_dummy VARCHAR2(240);

Line 1450: OE_Purchase_Release_PVT.Purchase_Release

1446: IF l_debug_level > 0 THEN
1447: oe_debug_pub.add('Calling Purchase Release' ) ;
1448: END IF;
1449:
1450: OE_Purchase_Release_PVT.Purchase_Release
1451: (p_api_version_number => 1.0
1452: ,p_drop_ship_tbl => l_drop_ship_tbl
1453: ,x_drop_ship_tbl => ll_drop_ship_tbl
1454: ,p_mode => 'ONLINE'