DBA Data[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