1 PACKAGE MSC_WS_ATP AS
2 /* $Header: MSCWATPS.pls 120.2 2008/03/12 03:00:35 bnaghi noship $ */
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 QuanitytOrderedOut 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 );
122
123 PROCEDURE GetPromiseDate_Public(
124 status OUT nocopy VARCHAR2,
125 UserName IN VARCHAR2,
126 RespName IN VARCHAR2,
127 RespApplName IN VARCHAR2,
128 SecurityGroupName IN VARCHAR2,
129 Language IN VARCHAR2,
130 InstanceId IN MscNumberArr ,
131 InventoryItemId IN MscNumberArr,
132 InventoryItemName IN MscChar40Arr,
133 SourceOrganizationId IN MscNumberArr ,
134 SourceOrganizationCode IN MscChar7Arr ,
135 OrganizationId IN MscNumberArr ,
136 Identifier IN MscNumberArr ,
137 DemandSourceHeaderId IN MscNumberArr ,
138 DemandSourceDelivery IN MscChar30Arr ,
139 DemandSourceType IN MscNumberArr ,
140 CallingModule IN MscNumberArr ,
141 CustomerId IN MscNumberArr ,
142 CustomerSiteId IN MscNumberArr ,
143 QuantityOrdered IN MscNumberArr ,
144 QuantityUOM IN MscChar3Arr ,
145 RequestedShipDate IN MscDateArr,
146 RequestedArrivalDate IN MscDateArr ,
147 LatestAcceptableDate IN MscDateArr ,
148 DeliveryLeadTime IN MscNumberArr ,
149 ShipMethod IN MscChar30Arr ,
150 DemandClass IN MscChar30Arr ,
151 ShipSetName IN MscChar30Arr ,
152 ArrivalSetName IN MscChar30Arr ,
153 OverrideFlag IN MscChar1Arr ,
154 Action IN MscNumberArr ,
155 InsertFlag IN MscNumberArr ,
156 OEFlag IN MscChar1Arr ,
157 OrderNumber IN MscNumberArr ,
158 OldSourceOrganizationId IN MscNumberArr ,
159 OldDemandClass IN MscChar30Arr ,
160 Attribute01 IN MscNumberArr ,
161 Attribute02 IN MscNumberArr ,
162 CustomerCountry IN MscChar60Arr ,
163 CustomerState IN MscChar60Arr ,
164 CustomerCity IN MscChar60Arr ,
165 CustomerPostalCode IN MscChar60Arr ,
166 SubstitutionTypeCode IN MscNumberArr ,
167 ReqItemDetailFlag IN MscNumberArr ,
168 SalesRep IN MscChar255Arr ,
169 CustomerContact IN MscChar255Arr ,
170 TopModelLineId IN MscNumberArr ,
171 ATOParentModelLineId IN MscNumberArr ,
172 ATOModelLineId IN MscNumberArr ,
173 ParentLineId IN MscNumberArr ,
174 MatchItemId IN MscNumberArr ,
175 ConfigItemLineId IN MscNumberArr ,
176 ValidationOrg IN MscNumberArr ,
177 ComponentSequenceID IN MscNumberArr ,
178 ComponentCode IN MscChar255Arr ,
179 LineNumber IN MscChar80Arr ,
180 IncludedItemFlag IN MscNumberArr ,
181 PickComponentsFlag IN MscChar1Arr ,
182 CascadeModelInfoToComp IN MscNumberArr ,
183 SequenceNumber IN MscNumberArr ,
184 InternalOrgId IN MscNumberArr ,
185 PartySiteId IN MscNumberArr ,
186 PartOfSet IN MscChar1Arr ,
187
188 InstanceIdOut OUT nocopy MscNumberArr,
189 InventoryItemIdOut OUT nocopy MscNumberArr,
190 InventoryItemNameOut OUT nocopy MscChar40Arr,
191 SourceOrganizationIdOut OUT nocopy MscNumberArr,
192 SourceOrganizationCodeOut OUT nocopy MscChar7Arr,
193 OrganizationIdOut OUT nocopy MscNumberArr,
194 IdentifierOut OUT nocopy MscNumberArr,
195 DemandSourceHeaderIdOut OUT nocopy MscNumberArr,
196 DemandSourceDeliveryOut OUT nocopy MscChar30Arr,
197 DemandSourceTypeOut OUT nocopy MscNumberArr,
198 CustomerIdOut OUT nocopy MscNumberArr,
199 CustomerSiteIdOut OUT nocopy MscNumberArr,
200 QuanitytOrderedOut OUT nocopy MscNumberArr,
201 QuantityUOMOut OUT nocopy MscChar3Arr,
202 RequestedShipDateOut OUT nocopy MscDateArr,
203 RequestedArrivalDateOut OUT nocopy MscDateArr,
204 LatestAcceptableDateOut OUT nocopy MscDateArr,
205 DeliveryLeadTimeOut OUT nocopy MscNumberArr,
206 ShipMethodOut OUT nocopy MscChar30Arr,
207 DemandClassOut OUT nocopy MscChar30Arr,
208 ShipSetNameOut OUT nocopy MscChar30Arr,
209 ArrivalSetNameOut OUT nocopy MscChar30Arr,
210 OverrideFlagOut OUT nocopy MscChar1Arr,
211 ShipDateOut OUT nocopy MscDateArr,
212 ArrivalDateOut OUT nocopy MscDateArr,
213 AvailableQuantityOut OUT nocopy MscNumberArr,
214 RequestedDateQuantityOut OUT nocopy MscNumberArr,
215 GroupShipDateOut OUT nocopy MscDateArr,
216 GroupArrivalDateOut OUT nocopy MscDateArr,
217 AtpLeadTimeOut OUT nocopy MscNumberArr,
218 ErrorCodeOut OUT nocopy MscNumberArr,
219 EndPeggingIdOut OUT nocopy MscNumberArr,
220 OldSourceOrganizationIdOut OUT nocopy MscNumberArr,
221 OldDemandClassOut OUT nocopy MscChar30Arr,
222 RequestItemIdOut OUT nocopy MscNumberArr,
223 ReqItemReqDateQtyOut OUT nocopy MscNumberArr,
224 ReqItemAvailableDateOut OUT nocopy MscDateArr,
225 ReqItemAvailableDateQtyOut OUT nocopy MscNumberArr,
226 RequestItemNameOut OUT nocopy MscChar40Arr,
227 OldInventoryItemIdOut OUT nocopy MscNumberArr,
228 SubstFlagOut OUT nocopy MscNumberArr,
229 BaseModelIdOut OUT nocopy MscNumberArr,
230 OssErrorCodeOut OUT nocopy MscNumberArr,
231 MatchedItemNameOut OUT nocopy MscChar255Arr,
232 CascadeModelInfoToCompOut OUT nocopy MscNumberArr,
233 PlanIdOut OUT nocopy MscNumberArr
234 );
235 END MSC_WS_ATP;