1 PACKAGE MSC_WS_ATP AUTHID CURRENT_USER AS
2 /* $Header: MSCWATPS.pls 120.4 2011/03/11 09:29:53 aksaxena ship $ */
3
4
5 -- =============================================================
6 -- Desc: Calculates the order promise date based on material and
7 -- resource availability across the supply chain. Accepts information
8 -- about an item or group of items, checks availability for the item(s)
9 -- and returns the availability picture for the items.
10 -- This procedure doesn't do any validations, just passes input parameters
11 -- to MRP_ATP_PUB.Call_ATP procedure and returns 46 output parameters
12 -- Output: possible output statuses are
13 -- SUCCESS, ERROR_ATP, ERROR_UNEXPECTED
14 -- =============================================================
15 PROCEDURE GetPromiseDate(
16 status OUT nocopy VARCHAR2,
17 InstanceId IN MscNumberArr ,
18 InventoryItemId IN MscNumberArr,
19 InventoryItemName IN MscChar40Arr,
20 SourceOrganizationId IN MscNumberArr ,
21 SourceOrganizationCode IN MscChar7Arr ,
22 OrganizationId IN MscNumberArr ,
23 Identifier IN MscNumberArr ,
24 DemandSourceHeaderId IN MscNumberArr ,
25 DemandSourceDelivery IN MscChar30Arr ,
26 DemandSourceType IN MscNumberArr ,
27 CallingModule IN MscNumberArr ,
28 CustomerId IN MscNumberArr ,
29 CustomerSiteId IN MscNumberArr ,
30 QuantityOrdered IN MscNumberArr ,
31 QuantityUOM IN MscChar3Arr ,
32 RequestedShipDate IN MscDateArr,
33 RequestedArrivalDate IN MscDateArr ,
34 LatestAcceptableDate IN MscDateArr ,
35 DeliveryLeadTime IN MscNumberArr ,
36 ShipMethod IN MscChar30Arr ,
37 DemandClass IN MscChar30Arr ,
38 ShipSetName IN MscChar30Arr ,
39 ArrivalSetName IN MscChar30Arr ,
40 OverrideFlag IN MscChar1Arr ,
41 Action IN MscNumberArr ,
42 InsertFlag IN MscNumberArr ,
43 OEFlag IN MscChar1Arr ,
44 OrderNumber IN MscNumberArr ,
45 OldSourceOrganizationId IN MscNumberArr ,
46 OldDemandClass IN MscChar30Arr ,
47 Attribute01 IN MscNumberArr ,
48 Attribute02 IN MscNumberArr ,
49 CustomerCountry IN MscChar60Arr ,
50 CustomerState IN MscChar60Arr ,
51 CustomerCity IN MscChar60Arr ,
52 CustomerPostalCode IN MscChar60Arr ,
53 SubstitutionTypeCode IN MscNumberArr ,
54 ReqItemDetailFlag IN MscNumberArr ,
55 SalesRep IN MscChar255Arr ,
56 CustomerContact IN MscChar255Arr ,
57 TopModelLineId IN MscNumberArr ,
58 ATOParentModelLineId IN MscNumberArr ,
59 ATOModelLineId IN MscNumberArr ,
60 ParentLineId IN MscNumberArr ,
61 MatchItemId IN MscNumberArr ,
62 ConfigItemLineId IN MscNumberArr ,
63 ValidationOrg IN MscNumberArr ,
64 ComponentSequenceID IN MscNumberArr ,
65 ComponentCode IN MscChar255Arr ,
66 LineNumber IN MscChar80Arr ,
67 IncludedItemFlag IN MscNumberArr ,
68 PickComponentsFlag IN MscChar1Arr ,
69 CascadeModelInfoToComp IN MscNumberArr ,
70 SequenceNumber IN MscNumberArr ,
71 InternalOrgId IN MscNumberArr ,
72 PartySiteId IN MscNumberArr ,
73 PartOfSet IN MscChar1Arr ,
74
75 InstanceIdOut OUT nocopy MscNumberArr,
76 InventoryItemIdOut OUT nocopy MscNumberArr,
77 InventoryItemNameOut OUT nocopy MscChar40Arr,
78 SourceOrganizationIdOut OUT nocopy MscNumberArr,
79 SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
80 OrganizationIdOut OUT nocopy MscNumberArr,
81 IdentifierOut OUT nocopy MscNumberArr,
82 DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
83 DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
84 DemandSourceTypeOut OUT nocopy MscNumberArr,
85 CustomerIdOut OUT nocopy MscNumberArr,
86 CustomerSiteIdOut OUT nocopy MscNumberArr,
87 QuantityOrderedOut OUT nocopy MscNumberArr,
88 QuantityUOMOut OUT nocopy MscChar3Arr,
89 RequestedShipDateOut OUT nocopy MscDateArr,
90 RequestedArrivalDateOut OUT nocopy MscDateArr,
91 LatestAcceptableDateOut OUT nocopy MscDateArr,
92 DeliveryLeadTimeOut OUT nocopy MscNumberArr,
93 ShipMethodOut OUT nocopy MscChar30Arr,
94 DemandClassOut OUT nocopy MscChar30Arr,
95 ShipSetNameOut OUT nocopy MscChar30Arr,
96 ArrivalSetNameOut OUT nocopy MscChar30Arr,
97 OverrideFlagOut OUT nocopy MscChar1Arr,
98 ShipDateOut OUT nocopy MscDateArr,
99 ArrivalDateOut OUT nocopy MscDateArr,
100 AvailableQuantityOut OUT nocopy MscNumberArr,
101 RequestedDateQuantityOut OUT nocopy MscNumberArr,
102 GroupShipDateOut OUT nocopy MscDateArr,
103 GroupArrivalDateOut OUT nocopy MscDateArr,
104 AtpLeadTimeOut OUT nocopy MscNumberArr,
105 ErrorCodeOut OUT nocopy MscNumberArr,
106 EndPeggingIdOut OUT nocopy MscNumberArr,
107 OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
108 OldDemandClassOut OUT nocopy MscChar30Arr,
109 RequestItemIdOut OUT nocopy MscNumberArr,
110 ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
111 ReqItemAvailableDateOut OUT nocopy MscDateArr,
112 ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
113 RequestItemNameOut OUT nocopy MscChar40Arr,
114 OldInventoryItemIdOut OUT nocopy MscNumberArr,
115 SubstFlagOut OUT nocopy MscNumberArr,
116 BaseModelIdOut OUT nocopy MscNumberArr,
117 OssErrorCodeOut OUT nocopy MscNumberArr,
118 MatchedItemNameOut OUT nocopy MscChar255Arr,
119 CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
120 PlanIdOut OUT nocopy MscNumberArr,
121 SessionId IN NUMBER,
122 UserId IN NUMBER,
123 RespId IN NUMBER,
124 AppId IN NUMBER
125 );
126
127 PROCEDURE GetPromiseDate_Public(
128 status OUT nocopy VARCHAR2,
129 UserName IN VARCHAR2,
130 RespName IN VARCHAR2,
131 RespApplName IN VARCHAR2,
132 SecurityGroupName IN VARCHAR2,
133 Language IN VARCHAR2,
134 InstanceId IN MscNumberArr ,
135 InventoryItemId IN MscNumberArr,
136 InventoryItemName IN MscChar40Arr,
137 SourceOrganizationId IN MscNumberArr ,
138 SourceOrganizationCode IN MscChar7Arr ,
139 OrganizationId IN MscNumberArr ,
140 Identifier IN MscNumberArr ,
141 DemandSourceHeaderId IN MscNumberArr ,
142 DemandSourceDelivery IN MscChar30Arr ,
143 DemandSourceType IN MscNumberArr ,
144 CallingModule IN MscNumberArr ,
145 CustomerId IN MscNumberArr ,
146 CustomerSiteId IN MscNumberArr ,
147 QuantityOrdered IN MscNumberArr ,
148 QuantityUOM IN MscChar3Arr ,
149 RequestedShipDate IN MscDateArr,
150 RequestedArrivalDate IN MscDateArr ,
151 LatestAcceptableDate IN MscDateArr ,
152 DeliveryLeadTime IN MscNumberArr ,
153 ShipMethod IN MscChar30Arr ,
154 DemandClass IN MscChar30Arr ,
155 ShipSetName IN MscChar30Arr ,
156 ArrivalSetName IN MscChar30Arr ,
157 OverrideFlag IN MscChar1Arr ,
158 Action IN MscNumberArr ,
159 InsertFlag IN MscNumberArr ,
160 OEFlag IN MscChar1Arr ,
161 OrderNumber IN MscNumberArr ,
162 OldSourceOrganizationId IN MscNumberArr ,
163 OldDemandClass IN MscChar30Arr ,
164 Attribute01 IN MscNumberArr ,
165 Attribute02 IN MscNumberArr ,
166 CustomerCountry IN MscChar60Arr ,
167 CustomerState IN MscChar60Arr ,
168 CustomerCity IN MscChar60Arr ,
169 CustomerPostalCode IN MscChar60Arr ,
170 SubstitutionTypeCode IN MscNumberArr ,
171 ReqItemDetailFlag IN MscNumberArr ,
172 SalesRep IN MscChar255Arr ,
173 CustomerContact IN MscChar255Arr ,
174 TopModelLineId IN MscNumberArr ,
175 ATOParentModelLineId IN MscNumberArr ,
176 ATOModelLineId IN MscNumberArr ,
177 ParentLineId IN MscNumberArr ,
178 MatchItemId IN MscNumberArr ,
179 ConfigItemLineId IN MscNumberArr ,
180 ValidationOrg IN MscNumberArr ,
181 ComponentSequenceID IN MscNumberArr ,
182 ComponentCode IN MscChar255Arr ,
183 LineNumber IN MscChar80Arr ,
184 IncludedItemFlag IN MscNumberArr ,
185 PickComponentsFlag IN MscChar1Arr ,
186 CascadeModelInfoToComp IN MscNumberArr ,
187 SequenceNumber IN MscNumberArr ,
188 InternalOrgId IN MscNumberArr ,
189 PartySiteId IN MscNumberArr ,
190 PartOfSet IN MscChar1Arr ,
191
192 InstanceIdOut OUT nocopy MscNumberArr,
193 InventoryItemIdOut OUT nocopy MscNumberArr,
194 InventoryItemNameOut OUT nocopy MscChar40Arr,
195 SourceOrganizationIdOut OUT nocopy MscNumberArr,
196 SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
197 OrganizationIdOut OUT nocopy MscNumberArr,
198 IdentifierOut OUT nocopy MscNumberArr,
199 DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
200 DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
201 DemandSourceTypeOut OUT nocopy MscNumberArr,
202 CustomerIdOut OUT nocopy MscNumberArr,
203 CustomerSiteIdOut OUT nocopy MscNumberArr,
204 QuantityOrderedOut OUT nocopy MscNumberArr,
205 QuantityUOMOut OUT nocopy MscChar3Arr,
206 RequestedShipDateOut OUT nocopy MscDateArr,
207 RequestedArrivalDateOut OUT nocopy MscDateArr,
208 LatestAcceptableDateOut OUT nocopy MscDateArr,
209 DeliveryLeadTimeOut OUT nocopy MscNumberArr,
210 ShipMethodOut OUT nocopy MscChar30Arr,
211 DemandClassOut OUT nocopy MscChar30Arr,
212 ShipSetNameOut OUT nocopy MscChar30Arr,
213 ArrivalSetNameOut OUT nocopy MscChar30Arr,
214 OverrideFlagOut OUT nocopy MscChar1Arr,
215 ShipDateOut OUT nocopy MscDateArr,
216 ArrivalDateOut OUT nocopy MscDateArr,
217 AvailableQuantityOut OUT nocopy MscNumberArr,
218 RequestedDateQuantityOut OUT nocopy MscNumberArr,
219 GroupShipDateOut OUT nocopy MscDateArr,
220 GroupArrivalDateOut OUT nocopy MscDateArr,
221 AtpLeadTimeOut OUT nocopy MscNumberArr,
222 ErrorCodeOut OUT nocopy MscNumberArr,
223 EndPeggingIdOut OUT nocopy MscNumberArr,
224 OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
225 OldDemandClassOut OUT nocopy MscChar30Arr,
226 RequestItemIdOut OUT nocopy MscNumberArr,
227 ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
228 ReqItemAvailableDateOut OUT nocopy MscDateArr,
229 ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
230 RequestItemNameOut OUT nocopy MscChar40Arr,
231 OldInventoryItemIdOut OUT nocopy MscNumberArr,
232 SubstFlagOut OUT nocopy MscNumberArr,
233 BaseModelIdOut OUT nocopy MscNumberArr,
234 OssErrorCodeOut OUT nocopy MscNumberArr,
235 MatchedItemNameOut OUT nocopy MscChar255Arr,
236 CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
237 PlanIdOut OUT nocopy MscNumberArr,
238 SessionId IN NUMBER,
239 UserId IN NUMBER,
240 RespId IN NUMBER,
241 AppId IN NUMBER
242 );
243 END MSC_WS_ATP;
[Home] [Help]