1 PACKAGE CTO_ATP_INTERFACE_PK AUTHID CURRENT_USER AS
2 /* $Header: CTOATPIS.pls 115.9 2002/11/19 18:53:53 ssheth ship $ */
3
4 /* flag to indicate valid line in a ship set */
5 TYPE FLAG_TBL_TYPE is table of boolean index by binary_integer ;
6
7 PROCEDURE Create_Atp_Bom(p_atp_bom in out NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
8 x_return_status out varchar2,
9 x_msg_data out varchar2,
10 x_msg_count out number);
11
12 PROCEDURE Extend_Atp_Bom(p_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
13 x_return_status out varchar2,
14 x_msg_data out varchar2,
15 x_msg_count out number);
16
17 PROCEDURE Populate_Mandatory_components(p_atp_bom IN OUT NOCOPY MRP_ATP_PUB.atp_bom_rec_typ,
18 p_index IN Number,
19 X_return_status OUT Varchar2,
20 X_Msg_count OUT Number,
21 X_Msg_Data OUT Varchar2);
22
23 procedure get_atp_bom(
24 p_shipset in out NOCOPY MRP_ATP_PUB.ATP_REC_TYP
25 , p_atp_bom_rec out NOCOPY MRP_ATP_PUB.ATP_BOM_REC_TYP
26 , x_return_status out varchar2
27 , x_msg_count out number
28 , x_msg_data out varchar2
29 );
30
31
32 PROCEDURE get_model_sourcing_org(
33 p_inventory_item_id NUMBER
34 , p_organization_id NUMBER
35 , p_sourcing_rule_exists out varchar2
36 , p_sourcing_org out NUMBER
37 , p_source_type out NUMBER
38 , p_transit_lead_time out NUMBER
39 , x_return_status out varchar2
40 , p_line_id in number default null
41 , p_ship_set_name in varchar2 default null
42 ) ;
43
44
45
46 PROCEDURE CREATE_CTO_MODEL_DEMAND (
47 p_shipset IN OUT NOCOPY MRP_ATP_PUB.ATP_REC_TYP,
48 p_session_id IN number,
49 p_shipset_status IN MRP_ATP_PUB.SHIPSET_STATUS_REC_TYPE,
50 xreturn_status OUT varchar2,
51 xmsgcount OUT number,
52 xmsgdata OUT varchar2);
53
54 PROCEDURE CREATE_CTO_ITEM_DEMAND(x_return_status out varchar2,
55 x_msg_count out number,
56 x_msg_data out varchar2);
57
58
59
60 G_OE_VALIDATION_ORG Number;
61 END CTO_ATP_INTERFACE_PK ;