[Home] [Help]
PACKAGE: APPS.INV_EXTATP_GRP
Source
1 PACKAGE INV_EXTATP_GRP AUTHID CURRENT_USER AS
2 /* $Header: INVGEAPS.pls 120.2 2005/09/20 14:11:30 ichoudhu ship $ */
3
4 --
5 -- Package
6 -- INV_EXTATP_GRP
7 -- Purpose
8 -- External ATP
9 -- History
10 -- 09/04/96 mfisher created
11 -- 07/26/97 nsriniva added support for APS integration
12 --
13
14 -- Constants for Error Codes
15 G_ALL_SUCCESS CONSTANT INTEGER := 0;
16 G_RETURN_ERROR CONSTANT INTEGER := 2;
17 G_INVALID_ACTION CONSTANT INTEGER := 1;
18 G_RETURN_WARNING CONSTANT INTEGER := -1;
19 G_ATP_REQ_QTY_FAIL CONSTANT INTEGER := 52;
20 G_ATP_NO_GROUP_DATE CONSTANT INTEGER := 50;
21
22 G_ATP_INQUIRY CONSTANT VARCHAR2(20) := 'ATP INQUIRY';
23 G_DEMAND CONSTANT VARCHAR2(20) := 'DEMAND';
24 G_UNDEMAND CONSTANT VARCHAR2(20) := 'UNDEMAND';
25
26 TYPE ATP_Group_Rec_Typ is RECORD (
27 Row_Id RowId,
28 Schedule_Group_Id Number,
29 ATP_Group_Id Number,
30 Ext_ATP_Group_Id Number,
31 Action_Code Number,
32 Action Varchar2(20),
33 Processing_Order Number,
34 Item_Id Number,
35 Organization_Id Number,
36 Organization_Code Varchar2(10),
37 Sales_Order_Number Varchar2(40),
38 Sales_Order_Type Varchar2(40),
39 OE_Source_Code Varchar2(40),
40 Order_Identifier Varchar2(120),
41 Order_Type_Id Number,
42 Creation_Date Date,
43 Customer_Name Varchar2(50),
44 Shipment_Schedule_Line_Id Number,
45 Line_Number Number,
46 Line_Item_Quantity Number,
47 User_Delivery Varchar2(30),
48 Item_Segment1 Varchar2(40),
49 Item_Segment2 Varchar2(40),
50 Item_Segment3 Varchar2(40),
51 Item_Segment4 Varchar2(40),
52 Item_Segment5 Varchar2(40),
53 Item_Segment6 Varchar2(40),
54 Item_Segment7 Varchar2(40),
55 Item_Segment8 Varchar2(40),
56 Item_Segment9 Varchar2(40),
57 Item_Segment10 Varchar2(40),
58 Item_Segment11 Varchar2(40),
59 Item_Segment12 Varchar2(40),
60 Item_Segment13 Varchar2(40),
61 Item_Segment14 Varchar2(40),
62 Item_Segment15 Varchar2(40),
63 Item_Segment16 Varchar2(40),
64 Item_Segment17 Varchar2(40),
65 Item_Segment18 Varchar2(40),
66 Item_Segment19 Varchar2(40),
67 Item_Segment20 Varchar2(40),
68 BOM_Level Number,
69 Demand_Type Number,
70 BOM_Item_Type Number,
71 ATO_Flag Varchar2(1),
72 Selling_Price Number,
73 Requirement_Date Date,
74 Request_Date_ATP_Quantity Number,
75 Earliest_ATP_Date Date,
76 Earliest_ATP_Date_Quantity Number,
77 Request_ATP_Date Date,
78 Request_ATP_Date_Quantity Number,
79 Group_Available_Date Date,
80 Error_Code Number,
81 Error_Explanation Varchar2(240) );
82
83 TYPE Bom_Rec_Typ is RECORD (
84 Row_Id RowId,
85 Bill_Sequence_Id Number,
86 Item_Id Number,
87 Component_Item_Id Number,
88 Comp_Item_Segment1 Varchar2(40),
89 Comp_Item_Segment2 Varchar2(40),
90 Comp_Item_Segment3 Varchar2(40),
91 Comp_Item_Segment4 Varchar2(40),
92 Comp_Item_Segment5 Varchar2(40),
93 Comp_Item_Segment6 Varchar2(40),
94 Comp_Item_Segment7 Varchar2(40),
95 Comp_Item_Segment8 Varchar2(40),
96 Comp_Item_Segment9 Varchar2(40),
97 Comp_Item_Segment10 Varchar2(40),
98 Comp_Item_Segment11 Varchar2(40),
99 Comp_Item_Segment12 Varchar2(40),
100 Comp_Item_Segment13 Varchar2(40),
101 Comp_Item_Segment14 Varchar2(40),
102 Comp_Item_Segment15 Varchar2(40),
103 Comp_Item_Segment16 Varchar2(40),
104 Comp_Item_Segment17 Varchar2(40),
105 Comp_Item_Segment18 Varchar2(40),
106 Comp_Item_Segment19 Varchar2(40),
107 Comp_Item_Segment20 Varchar2(40),
108 Organization_Id Number,
109 Organization_Code Varchar2(10),
110 Component_Quantity Number);
111
112 TYPE Routing_Rec_Typ is RECORD (
113 Row_Id RowId,
114 Routing_Id Number,
115 Item_Id Number,
116 Component_Item_Id Number,
117 Organization_Id Number,
118 Organization_Code Varchar2(10),
119 Operation_Code Varchar2(10),
120 Operation_Type Varchar2(10),
121 Department_Id Number,
122 Department_Code Varchar2(10),
123 Resource_Id Number,
124 Resource_Code Varchar2(10),
125 Rate Number,
126 Resource_Uom Varchar2(10));
127
128 TYPE ATP_Group_Tab_Typ is TABLE of ATP_Group_Rec_Typ
129 INDEX BY BINARY_INTEGER ;
130
131 TYPE Bom_Tab_Typ is TABLE of Bom_Rec_Typ
132 INDEX BY BINARY_INTEGER ;
133
134 TYPE Routing_Tab_Typ is TABLE of Routing_Rec_Typ
135 INDEX BY BINARY_INTEGER ;
136
137 FUNCTION Call_ATP( group_id number,
138 insert_flag number,
139 partial_flag number,
140 mrp_status number,
141 schedule_flag number,
142 session_id number,
143 err_message IN OUT NOCOPY varchar2,
144 err_translate IN OUT NOCOPY number)
145 RETURN NUMBER;
146
147 END INV_EXTATP_GRP;