[Home] [Help]
PACKAGE: APPS.CSP_PLANNED_ORDERS
Source
1 PACKAGE CSP_PLANNED_ORDERS AUTHID CURRENT_USER AS
2 /* $Header: cspvppos.pls 120.0 2005/07/12 13:15:29 phegde noship $ */
3
4 -- Purpose: To create planned orders for a warehouse
5 --
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- phegde 6/13/2005 Created package
10
11 TYPE line_rec_type IS RECORD
12 ( supplied_item_id NUMBER,
13 planned_order_type VARCHAR2(30),
14 source_organization_id NUMBER,
15 quantity NUMBER,
16 uom_code VARCHAR2(30),
17 plan_date DATE
18 );
19
20 TYPE line_Tbl_Type IS TABLE OF Line_Rec_Type
21 INDEX BY BINARY_INTEGER;
22
23 PROCEDURE create_orders
24 ( p_api_version IN NUMBER
25 , p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
26 , p_commit IN VARCHAR2 := FND_API.G_FALSE
27 , p_organization_id NUMBER
28 , p_inventory_item_id NUMBER
29 , px_line_tbl CSP_PLANNED_ORDERS.Line_Tbl_Type
30 , x_return_status OUT NOCOPY VARCHAR2
31 , x_msg_count OUT NOCOPY NUMBER
32 , x_msg_data OUT NOCOPY VARCHAR2);
33
34 END; -- Package spec