eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.XX_BPEL_EBS11I10ATPCHECK

Source


1 PACKAGE BODY XX_BPEL_EBS11I10ATPCHECK AS
2 /* $Header: MSCATPJB.pls 120.0.12010000.1 2009/02/04 07:19:28 sbnaik noship $ */
3 
4  FUNCTION PL_TO_SQL1(aPlsqlItem MSC_ATP_BPEL.ATP_REC_SCALAR_TYP)
5    RETURN MSC_ATP_BPEL_ATP_REC_SCALAR_T IS
6  aSqlItem MSC_ATP_BPEL_ATP_REC_SCALAR_T;
7  BEGIN
8  -- initialize the object
9  aSqlItem := MSC_ATP_BPEL_ATP_REC_SCALAR_T(NULL, NULL, NULL, NULL, NULL,
10  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
11  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
12  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
13  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
14  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
15  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
16  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
17  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
18  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
19  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
20  NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL );
21 
22  aSqlItem.ROW_ID := aPlsqlItem.ROW_ID;
23  aSqlItem.INSTANCE_ID := aPlsqlItem.INSTANCE_ID;
24  aSqlItem.INVENTORY_ITEM_ID := aPlsqlItem.INVENTORY_ITEM_ID;
25  aSqlItem.INVENTORY_ITEM_NAME := aPlsqlItem.INVENTORY_ITEM_NAME;
26  aSqlItem.SOURCE_ORGANIZATION_ID := aPlsqlItem.SOURCE_ORGANIZATION_ID;
27  aSqlItem.SOURCE_ORGANIZATION_CODE := aPlsqlItem.SOURCE_ORGANIZATION_CODE;
28  aSqlItem.ORGANIZATION_ID := aPlsqlItem.ORGANIZATION_ID;
29  aSqlItem.IDENTIFIER := aPlsqlItem.IDENTIFIER;
30  aSqlItem.DEMAND_SOURCE_HEADER_ID := aPlsqlItem.DEMAND_SOURCE_HEADER_ID;
31  aSqlItem.DEMAND_SOURCE_DELIVERY := aPlsqlItem.DEMAND_SOURCE_DELIVERY;
32  aSqlItem.DEMAND_SOURCE_TYPE := aPlsqlItem.DEMAND_SOURCE_TYPE;
33  aSqlItem.SCENARIO_ID := aPlsqlItem.SCENARIO_ID;
34  aSqlItem.CALLING_MODULE := aPlsqlItem.CALLING_MODULE;
35  aSqlItem.CUSTOMER_ID := aPlsqlItem.CUSTOMER_ID;
36  aSqlItem.CUSTOMER_SITE_ID := aPlsqlItem.CUSTOMER_SITE_ID;
37  aSqlItem.DESTINATION_TIME_ZONE := aPlsqlItem.DESTINATION_TIME_ZONE;
38  aSqlItem.QUANTITY_ORDERED := aPlsqlItem.QUANTITY_ORDERED;
39  aSqlItem.QUANTITY_UOM := aPlsqlItem.QUANTITY_UOM;
40  aSqlItem.REQUESTED_SHIP_DATE := aPlsqlItem.REQUESTED_SHIP_DATE;
41  aSqlItem.REQUESTED_ARRIVAL_DATE := aPlsqlItem.REQUESTED_ARRIVAL_DATE;
42  aSqlItem.EARLIEST_ACCEPTABLE_DATE := aPlsqlItem.EARLIEST_ACCEPTABLE_DATE;
43  aSqlItem.LATEST_ACCEPTABLE_DATE := aPlsqlItem.LATEST_ACCEPTABLE_DATE;
44  aSqlItem.DELIVERY_LEAD_TIME := aPlsqlItem.DELIVERY_LEAD_TIME;
45  aSqlItem.FREIGHT_CARRIER := aPlsqlItem.FREIGHT_CARRIER;
46  aSqlItem.SHIP_METHOD := aPlsqlItem.SHIP_METHOD;
47  aSqlItem.DEMAND_CLASS := aPlsqlItem.DEMAND_CLASS;
48  aSqlItem.SHIP_SET_NAME := aPlsqlItem.SHIP_SET_NAME;
49  aSqlItem.ARRIVAL_SET_NAME := aPlsqlItem.ARRIVAL_SET_NAME;
50  aSqlItem.OVERRIDE_FLAG := aPlsqlItem.OVERRIDE_FLAG;
51  aSqlItem.ACTION := aPlsqlItem.ACTION;
52  aSqlItem.SHIP_DATE := aPlsqlItem.SHIP_DATE;
53  aSqlItem.ARRIVAL_DATE := aPlsqlItem.ARRIVAL_DATE;
54  aSqlItem.AVAILABLE_QUANTITY := aPlsqlItem.AVAILABLE_QUANTITY;
55  aSqlItem.REQUESTED_DATE_QUANTITY := aPlsqlItem.REQUESTED_DATE_QUANTITY;
56  aSqlItem.GROUP_SHIP_DATE := aPlsqlItem.GROUP_SHIP_DATE;
57  aSqlItem.GROUP_ARRIVAL_DATE := aPlsqlItem.GROUP_ARRIVAL_DATE;
58  aSqlItem.VENDOR_ID := aPlsqlItem.VENDOR_ID;
59  aSqlItem.VENDOR_NAME := aPlsqlItem.VENDOR_NAME;
60  aSqlItem.VENDOR_SITE_ID := aPlsqlItem.VENDOR_SITE_ID;
61  aSqlItem.VENDOR_SITE_NAME := aPlsqlItem.VENDOR_SITE_NAME;
62  aSqlItem.INSERT_FLAG := aPlsqlItem.INSERT_FLAG;
63  aSqlItem.OE_FLAG := aPlsqlItem.OE_FLAG;
64  aSqlItem.ATP_LEAD_TIME := aPlsqlItem.ATP_LEAD_TIME;
65  aSqlItem.ERROR_CODE := aPlsqlItem.ERROR_CODE;
66  aSqlItem.MESSAGE := aPlsqlItem.MESSAGE;
67  aSqlItem.END_PEGGING_ID := aPlsqlItem.END_PEGGING_ID;
68  aSqlItem.ORDER_NUMBER := aPlsqlItem.ORDER_NUMBER;
69  aSqlItem.OLD_SOURCE_ORGANIZATION_ID :=
70  aPlsqlItem.OLD_SOURCE_ORGANIZATION_ID;
71  aSqlItem.OLD_DEMAND_CLASS := aPlsqlItem.OLD_DEMAND_CLASS;
72  aSqlItem.ATO_DELETE_FLAG := aPlsqlItem.ATO_DELETE_FLAG;
73  aSqlItem.ATTRIBUTE_01 := aPlsqlItem.ATTRIBUTE_01;
74  aSqlItem.ATTRIBUTE_02 := aPlsqlItem.ATTRIBUTE_02;
75  aSqlItem.ATTRIBUTE_03 := aPlsqlItem.ATTRIBUTE_03;
76  aSqlItem.ATTRIBUTE_04 := aPlsqlItem.ATTRIBUTE_04;
77  aSqlItem.ATTRIBUTE_05 := aPlsqlItem.ATTRIBUTE_05;
78  aSqlItem.ATTRIBUTE_06 := aPlsqlItem.ATTRIBUTE_06;
79  aSqlItem.ATTRIBUTE_07 := aPlsqlItem.ATTRIBUTE_07;
80  aSqlItem.ATTRIBUTE_08 := aPlsqlItem.ATTRIBUTE_08;
81  aSqlItem.ATTRIBUTE_09 := aPlsqlItem.ATTRIBUTE_09;
82  aSqlItem.ATTRIBUTE_10 := aPlsqlItem.ATTRIBUTE_10;
83  aSqlItem.CUSTOMER_NAME := aPlsqlItem.CUSTOMER_NAME;
84  aSqlItem.CUSTOMER_CLASS := aPlsqlItem.CUSTOMER_CLASS;
85  aSqlItem.CUSTOMER_LOCATION := aPlsqlItem.CUSTOMER_LOCATION;
86  aSqlItem.CUSTOMER_COUNTRY := aPlsqlItem.CUSTOMER_COUNTRY;
87  aSqlItem.CUSTOMER_STATE := aPlsqlItem.CUSTOMER_STATE;
88  aSqlItem.CUSTOMER_CITY := aPlsqlItem.CUSTOMER_CITY;
89  aSqlItem.CUSTOMER_POSTAL_CODE := aPlsqlItem.CUSTOMER_POSTAL_CODE;
90  aSqlItem.SUBSTITUTION_TYP_CODE := aPlsqlItem.SUBSTITUTION_TYP_CODE;
91  aSqlItem.REQ_ITEM_DETAIL_FLAG := aPlsqlItem.REQ_ITEM_DETAIL_FLAG;
92  aSqlItem.REQUEST_ITEM_ID := aPlsqlItem.REQUEST_ITEM_ID;
93  aSqlItem.REQ_ITEM_REQ_DATE_QTY := aPlsqlItem.REQ_ITEM_REQ_DATE_QTY;
94  aSqlItem.REQ_ITEM_AVAILABLE_DATE := aPlsqlItem.REQ_ITEM_AVAILABLE_DATE;
95  aSqlItem.REQ_ITEM_AVAILABLE_DATE_QTY :=  aPlsqlItem.REQ_ITEM_AVAILABLE_DATE_QTY;
96  aSqlItem.REQUEST_ITEM_NAME := aPlsqlItem.REQUEST_ITEM_NAME;
97  aSqlItem.OLD_INVENTORY_ITEM_ID := aPlsqlItem.OLD_INVENTORY_ITEM_ID;
98  aSqlItem.SALES_REP := aPlsqlItem.SALES_REP;
99  aSqlItem.CUSTOMER_CONTACT := aPlsqlItem.CUSTOMER_CONTACT;
100  aSqlItem.SUBST_FLAG := aPlsqlItem.SUBST_FLAG;
101  aSqlItem.TOP_MODEL_LINE_ID := aPlsqlItem.TOP_MODEL_LINE_ID;
102  aSqlItem.ATO_PARENT_MODEL_LINE_ID := aPlsqlItem.ATO_PARENT_MODEL_LINE_ID;
103  aSqlItem.ATO_MODEL_LINE_ID := aPlsqlItem.ATO_MODEL_LINE_ID;
104  aSqlItem.PARENT_LINE_ID := aPlsqlItem.PARENT_LINE_ID;
105  aSqlItem.MATCH_ITEM_ID := aPlsqlItem.MATCH_ITEM_ID;
106  aSqlItem.CONFIG_ITEM_LINE_ID := aPlsqlItem.CONFIG_ITEM_LINE_ID;
107  aSqlItem.VALIDATION_ORG := aPlsqlItem.VALIDATION_ORG;
108  aSqlItem.COMPONENT_SEQUENCE_ID := aPlsqlItem.COMPONENT_SEQUENCE_ID;
109  aSqlItem.COMPONENT_CODE := aPlsqlItem.COMPONENT_CODE;
110  aSqlItem.LINE_NUMBER := aPlsqlItem.LINE_NUMBER;
111  aSqlItem.INCLUDED_ITEM_FLAG := aPlsqlItem.INCLUDED_ITEM_FLAG;
112  aSqlItem.ATP_FLAG := aPlsqlItem.ATP_FLAG;
113  aSqlItem.ATP_COMPONENTS_FLAG := aPlsqlItem.ATP_COMPONENTS_FLAG;
114  aSqlItem.WIP_SUPPLY_TYPE := aPlsqlItem.WIP_SUPPLY_TYPE;
115  aSqlItem.BOM_ITEM_TYPE := aPlsqlItem.BOM_ITEM_TYPE;
116  aSqlItem.MANDATORY_ITEM_FLAG := aPlsqlItem.MANDATORY_ITEM_FLAG;
117  aSqlItem.PICK_COMPONENTS_FLAG := aPlsqlItem.PICK_COMPONENTS_FLAG;
118  aSqlItem.BASE_MODEL_ID := aPlsqlItem.BASE_MODEL_ID;
119  aSqlItem.OSS_ERROR_CODE := aPlsqlItem.OSS_ERROR_CODE;
120  aSqlItem.MATCHED_ITEM_NAME := aPlsqlItem.MATCHED_ITEM_NAME;
121  aSqlItem.CASCADE_MODEL_INFO_TO_COMP :=  aPlsqlItem.CASCADE_MODEL_INFO_TO_COMP;
122  aSqlItem.SEQUENCE_NUMBER := aPlsqlItem.SEQUENCE_NUMBER;
123  aSqlItem.FIRM_FLAG := aPlsqlItem.FIRM_FLAG;
124  aSqlItem.ORDER_LINE_NUMBER := aPlsqlItem.ORDER_LINE_NUMBER;
125  aSqlItem.OPTION_NUMBER := aPlsqlItem.OPTION_NUMBER;
126  aSqlItem.SHIPMENT_NUMBER := aPlsqlItem.SHIPMENT_NUMBER;
127  aSqlItem.ITEM_DESC := aPlsqlItem.ITEM_DESC;
128  aSqlItem.OLD_LINE_SCHEDULE_DATE := aPlsqlItem.OLD_LINE_SCHEDULE_DATE;
129  aSqlItem.OLD_SOURCE_ORGANIZATION_CODE := aPlsqlItem.OLD_SOURCE_ORGANIZATION_CODE;
130  aSqlItem.FIRM_SOURCE_ORG_ID := aPlsqlItem.FIRM_SOURCE_ORG_ID;
131  aSqlItem.FIRM_SOURCE_ORG_CODE := aPlsqlItem.FIRM_SOURCE_ORG_CODE;
132  aSqlItem.FIRM_SHIP_DATE := aPlsqlItem.FIRM_SHIP_DATE;
133  aSqlItem.FIRM_ARRIVAL_DATE := aPlsqlItem.FIRM_ARRIVAL_DATE;
134  aSqlItem.SHIP_METHOD_TEXT := aPlsqlItem.SHIP_METHOD_TEXT;
135  aSqlItem.SHIP_SET_ID := aPlsqlItem.SHIP_SET_ID;
136  aSqlItem.ARRIVAL_SET_ID := aPlsqlItem.ARRIVAL_SET_ID;
137  aSqlItem.PROJECT_ID := aPlsqlItem.PROJECT_ID;
138  aSqlItem.TASK_ID := aPlsqlItem.TASK_ID;
139  aSqlItem.PROJECT_NUMBER := aPlsqlItem.PROJECT_NUMBER;
140  aSqlItem.TASK_NUMBER := aPlsqlItem.TASK_NUMBER;
141  aSqlItem.ATTRIBUTE_11 := aPlsqlItem.ATTRIBUTE_11;
142  aSqlItem.ATTRIBUTE_12 := aPlsqlItem.ATTRIBUTE_12;
143  aSqlItem.ATTRIBUTE_13 := aPlsqlItem.ATTRIBUTE_13;
144  aSqlItem.ATTRIBUTE_14 := aPlsqlItem.ATTRIBUTE_14;
145  aSqlItem.ATTRIBUTE_15 := aPlsqlItem.ATTRIBUTE_15;
146  aSqlItem.ATTRIBUTE_16 := aPlsqlItem.ATTRIBUTE_16;
147  aSqlItem.ATTRIBUTE_17 := aPlsqlItem.ATTRIBUTE_17;
148  aSqlItem.ATTRIBUTE_18 := aPlsqlItem.ATTRIBUTE_18;
149  aSqlItem.ATTRIBUTE_19 := aPlsqlItem.ATTRIBUTE_19;
150  aSqlItem.ATTRIBUTE_20 := aPlsqlItem.ATTRIBUTE_20;
151  aSqlItem.ATTRIBUTE_21 := aPlsqlItem.ATTRIBUTE_21;
152  aSqlItem.ATTRIBUTE_22 := aPlsqlItem.ATTRIBUTE_22;
153  aSqlItem.ATTRIBUTE_23 := aPlsqlItem.ATTRIBUTE_23;
154  aSqlItem.ATTRIBUTE_24 := aPlsqlItem.ATTRIBUTE_24;
155  aSqlItem.ATTRIBUTE_25 := aPlsqlItem.ATTRIBUTE_25;
156  aSqlItem.ATTRIBUTE_26 := aPlsqlItem.ATTRIBUTE_26;
157  aSqlItem.ATTRIBUTE_27 := aPlsqlItem.ATTRIBUTE_27;
158  aSqlItem.ATTRIBUTE_28 := aPlsqlItem.ATTRIBUTE_28;
159  aSqlItem.ATTRIBUTE_29 := aPlsqlItem.ATTRIBUTE_29;
160  aSqlItem.ATTRIBUTE_30 := aPlsqlItem.ATTRIBUTE_30;
161  aSqlItem.ATF_DATE := aPlsqlItem.ATF_DATE;
162  aSqlItem.PLAN_ID := aPlsqlItem.PLAN_ID;
163  aSqlItem.ORIGINAL_REQUEST_DATE := aPlsqlItem.ORIGINAL_REQUEST_DATE;
164  aSqlItem.RECEIVING_CAL_CODE := aPlsqlItem.RECEIVING_CAL_CODE;
165  aSqlItem.INTRANSIT_CAL_CODE := aPlsqlItem.INTRANSIT_CAL_CODE;
166  aSqlItem.SHIPPING_CAL_CODE := aPlsqlItem.SHIPPING_CAL_CODE;
167  aSqlItem.MANUFACTURING_CAL_CODE := aPlsqlItem.MANUFACTURING_CAL_CODE;
168  aSqlItem.INTERNAL_ORG_ID := aPlsqlItem.INTERNAL_ORG_ID;
169  aSqlItem.FIRST_VALID_SHIP_ARRIVAL_DATE :=
170  aPlsqlItem.FIRST_VALID_SHIP_ARRIVAL_DATE;
171  aSqlItem.PARTY_SITE_ID := aPlsqlItem.PARTY_SITE_ID;
172  RETURN aSqlItem;
173  END PL_TO_SQL1;
174 
175  FUNCTION SQL_TO_PL1(aSqlItem MSC_ATP_BPEL_ATP_REC_SCALAR_T)
176  RETURN MSC_ATP_BPEL.ATP_REC_SCALAR_TYP IS
177  aPlsqlItem MSC_ATP_BPEL.ATP_REC_SCALAR_TYP;
178  BEGIN
179  aPlsqlItem.ROW_ID := aSqlItem.ROW_ID;
180  aPlsqlItem.INSTANCE_ID := aSqlItem.INSTANCE_ID;
181  aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;
182  aPlsqlItem.INVENTORY_ITEM_NAME := aSqlItem.INVENTORY_ITEM_NAME;
183  aPlsqlItem.SOURCE_ORGANIZATION_ID := aSqlItem.SOURCE_ORGANIZATION_ID;
184  aPlsqlItem.SOURCE_ORGANIZATION_CODE := aSqlItem.SOURCE_ORGANIZATION_CODE;
185  aPlsqlItem.ORGANIZATION_ID := aSqlItem.ORGANIZATION_ID;
186  aPlsqlItem.IDENTIFIER := aSqlItem.IDENTIFIER;
187  aPlsqlItem.DEMAND_SOURCE_HEADER_ID := aSqlItem.DEMAND_SOURCE_HEADER_ID;
188  aPlsqlItem.DEMAND_SOURCE_DELIVERY := aSqlItem.DEMAND_SOURCE_DELIVERY;
189  aPlsqlItem.DEMAND_SOURCE_TYPE := aSqlItem.DEMAND_SOURCE_TYPE;
190  aPlsqlItem.SCENARIO_ID := aSqlItem.SCENARIO_ID;
191  aPlsqlItem.CALLING_MODULE := aSqlItem.CALLING_MODULE;
192  aPlsqlItem.CUSTOMER_ID := aSqlItem.CUSTOMER_ID;
193  aPlsqlItem.CUSTOMER_SITE_ID := aSqlItem.CUSTOMER_SITE_ID;
194  aPlsqlItem.DESTINATION_TIME_ZONE := aSqlItem.DESTINATION_TIME_ZONE;
195  aPlsqlItem.QUANTITY_ORDERED := aSqlItem.QUANTITY_ORDERED;
196  aPlsqlItem.QUANTITY_UOM := aSqlItem.QUANTITY_UOM;
197  aPlsqlItem.REQUESTED_SHIP_DATE := aSqlItem.REQUESTED_SHIP_DATE;
198  aPlsqlItem.REQUESTED_ARRIVAL_DATE := aSqlItem.REQUESTED_ARRIVAL_DATE;
199  aPlsqlItem.EARLIEST_ACCEPTABLE_DATE := aSqlItem.EARLIEST_ACCEPTABLE_DATE;
200  aPlsqlItem.LATEST_ACCEPTABLE_DATE := aSqlItem.LATEST_ACCEPTABLE_DATE;
201  aPlsqlItem.DELIVERY_LEAD_TIME := aSqlItem.DELIVERY_LEAD_TIME;
202  aPlsqlItem.FREIGHT_CARRIER := aSqlItem.FREIGHT_CARRIER;
203  aPlsqlItem.SHIP_METHOD := aSqlItem.SHIP_METHOD;
204  aPlsqlItem.DEMAND_CLASS := aSqlItem.DEMAND_CLASS;
205  aPlsqlItem.SHIP_SET_NAME := aSqlItem.SHIP_SET_NAME;
206  aPlsqlItem.ARRIVAL_SET_NAME := aSqlItem.ARRIVAL_SET_NAME;
207  aPlsqlItem.OVERRIDE_FLAG := aSqlItem.OVERRIDE_FLAG;
208  aPlsqlItem.ACTION := aSqlItem.ACTION;
209  aPlsqlItem.SHIP_DATE := aSqlItem.SHIP_DATE;
210  aPlsqlItem.ARRIVAL_DATE := aSqlItem.ARRIVAL_DATE;
211  aPlsqlItem.AVAILABLE_QUANTITY := aSqlItem.AVAILABLE_QUANTITY;
212  aPlsqlItem.REQUESTED_DATE_QUANTITY := aSqlItem.REQUESTED_DATE_QUANTITY;
213  aPlsqlItem.GROUP_SHIP_DATE := aSqlItem.GROUP_SHIP_DATE;
214  aPlsqlItem.GROUP_ARRIVAL_DATE := aSqlItem.GROUP_ARRIVAL_DATE;
215  aPlsqlItem.VENDOR_ID := aSqlItem.VENDOR_ID;
216  aPlsqlItem.VENDOR_NAME := aSqlItem.VENDOR_NAME;
217  aPlsqlItem.VENDOR_SITE_ID := aSqlItem.VENDOR_SITE_ID;
218  aPlsqlItem.VENDOR_SITE_NAME := aSqlItem.VENDOR_SITE_NAME;
219  aPlsqlItem.INSERT_FLAG := aSqlItem.INSERT_FLAG;
220  aPlsqlItem.OE_FLAG := aSqlItem.OE_FLAG;
221  aPlsqlItem.ATP_LEAD_TIME := aSqlItem.ATP_LEAD_TIME;
222  aPlsqlItem.ERROR_CODE := aSqlItem.ERROR_CODE;
223  aPlsqlItem.MESSAGE := aSqlItem.MESSAGE;
224  aPlsqlItem.END_PEGGING_ID := aSqlItem.END_PEGGING_ID;
225  aPlsqlItem.ORDER_NUMBER := aSqlItem.ORDER_NUMBER;
226  aPlsqlItem.OLD_SOURCE_ORGANIZATION_ID := aSqlItem.OLD_SOURCE_ORGANIZATION_ID;
227  aPlsqlItem.OLD_DEMAND_CLASS := aSqlItem.OLD_DEMAND_CLASS;
228  aPlsqlItem.ATO_DELETE_FLAG := aSqlItem.ATO_DELETE_FLAG;
229  aPlsqlItem.ATTRIBUTE_01 := aSqlItem.ATTRIBUTE_01;
230  aPlsqlItem.ATTRIBUTE_02 := aSqlItem.ATTRIBUTE_02;
231  aPlsqlItem.ATTRIBUTE_03 := aSqlItem.ATTRIBUTE_03;
232  aPlsqlItem.ATTRIBUTE_04 := aSqlItem.ATTRIBUTE_04;
233  aPlsqlItem.ATTRIBUTE_05 := aSqlItem.ATTRIBUTE_05;
234  aPlsqlItem.ATTRIBUTE_06 := aSqlItem.ATTRIBUTE_06;
235  aPlsqlItem.ATTRIBUTE_07 := aSqlItem.ATTRIBUTE_07;
236  aPlsqlItem.ATTRIBUTE_08 := aSqlItem.ATTRIBUTE_08;
237  aPlsqlItem.ATTRIBUTE_09 := aSqlItem.ATTRIBUTE_09;
238  aPlsqlItem.ATTRIBUTE_10 := aSqlItem.ATTRIBUTE_10;
239  aPlsqlItem.CUSTOMER_NAME := aSqlItem.CUSTOMER_NAME;
240  aPlsqlItem.CUSTOMER_CLASS := aSqlItem.CUSTOMER_CLASS;
241  aPlsqlItem.CUSTOMER_LOCATION := aSqlItem.CUSTOMER_LOCATION;
242  aPlsqlItem.CUSTOMER_COUNTRY := aSqlItem.CUSTOMER_COUNTRY;
243  aPlsqlItem.CUSTOMER_STATE := aSqlItem.CUSTOMER_STATE;
244  aPlsqlItem.CUSTOMER_CITY := aSqlItem.CUSTOMER_CITY;
245  aPlsqlItem.CUSTOMER_POSTAL_CODE := aSqlItem.CUSTOMER_POSTAL_CODE;
246  aPlsqlItem.SUBSTITUTION_TYP_CODE := aSqlItem.SUBSTITUTION_TYP_CODE;
247  aPlsqlItem.REQ_ITEM_DETAIL_FLAG := aSqlItem.REQ_ITEM_DETAIL_FLAG;
248  aPlsqlItem.REQUEST_ITEM_ID := aSqlItem.REQUEST_ITEM_ID;
249  aPlsqlItem.REQ_ITEM_REQ_DATE_QTY := aSqlItem.REQ_ITEM_REQ_DATE_QTY;
250  aPlsqlItem.REQ_ITEM_AVAILABLE_DATE := aSqlItem.REQ_ITEM_AVAILABLE_DATE;
251  aPlsqlItem.REQ_ITEM_AVAILABLE_DATE_QTY :=  aSqlItem.REQ_ITEM_AVAILABLE_DATE_QTY;
252  aPlsqlItem.REQUEST_ITEM_NAME := aSqlItem.REQUEST_ITEM_NAME;
253  aPlsqlItem.OLD_INVENTORY_ITEM_ID := aSqlItem.OLD_INVENTORY_ITEM_ID;
254  aPlsqlItem.SALES_REP := aSqlItem.SALES_REP;
255  aPlsqlItem.CUSTOMER_CONTACT := aSqlItem.CUSTOMER_CONTACT;
256  aPlsqlItem.SUBST_FLAG := aSqlItem.SUBST_FLAG;
257  aPlsqlItem.TOP_MODEL_LINE_ID := aSqlItem.TOP_MODEL_LINE_ID;
258  aPlsqlItem.ATO_PARENT_MODEL_LINE_ID := aSqlItem.ATO_PARENT_MODEL_LINE_ID;
259  aPlsqlItem.ATO_MODEL_LINE_ID := aSqlItem.ATO_MODEL_LINE_ID;
260  aPlsqlItem.PARENT_LINE_ID := aSqlItem.PARENT_LINE_ID;
261  aPlsqlItem.MATCH_ITEM_ID := aSqlItem.MATCH_ITEM_ID;
262  aPlsqlItem.CONFIG_ITEM_LINE_ID := aSqlItem.CONFIG_ITEM_LINE_ID;
263  aPlsqlItem.VALIDATION_ORG := aSqlItem.VALIDATION_ORG;
264  aPlsqlItem.COMPONENT_SEQUENCE_ID := aSqlItem.COMPONENT_SEQUENCE_ID;
265  aPlsqlItem.COMPONENT_CODE := aSqlItem.COMPONENT_CODE;
266  aPlsqlItem.LINE_NUMBER := aSqlItem.LINE_NUMBER;
267  aPlsqlItem.INCLUDED_ITEM_FLAG := aSqlItem.INCLUDED_ITEM_FLAG;
268  aPlsqlItem.ATP_FLAG := aSqlItem.ATP_FLAG;
269  aPlsqlItem.ATP_COMPONENTS_FLAG := aSqlItem.ATP_COMPONENTS_FLAG;
270  aPlsqlItem.WIP_SUPPLY_TYPE := aSqlItem.WIP_SUPPLY_TYPE;
271  aPlsqlItem.BOM_ITEM_TYPE := aSqlItem.BOM_ITEM_TYPE;
272  aPlsqlItem.MANDATORY_ITEM_FLAG := aSqlItem.MANDATORY_ITEM_FLAG;
273  aPlsqlItem.PICK_COMPONENTS_FLAG := aSqlItem.PICK_COMPONENTS_FLAG;
274  aPlsqlItem.BASE_MODEL_ID := aSqlItem.BASE_MODEL_ID;
275  aPlsqlItem.OSS_ERROR_CODE := aSqlItem.OSS_ERROR_CODE;
276  aPlsqlItem.MATCHED_ITEM_NAME := aSqlItem.MATCHED_ITEM_NAME;
277  aPlsqlItem.CASCADE_MODEL_INFO_TO_COMP := aSqlItem.CASCADE_MODEL_INFO_TO_COMP;
278  aPlsqlItem.SEQUENCE_NUMBER := aSqlItem.SEQUENCE_NUMBER;
279  aPlsqlItem.FIRM_FLAG := aSqlItem.FIRM_FLAG;
280  aPlsqlItem.ORDER_LINE_NUMBER := aSqlItem.ORDER_LINE_NUMBER;
281  aPlsqlItem.OPTION_NUMBER := aSqlItem.OPTION_NUMBER;
282  aPlsqlItem.SHIPMENT_NUMBER := aSqlItem.SHIPMENT_NUMBER;
283  aPlsqlItem.ITEM_DESC := aSqlItem.ITEM_DESC;
284  aPlsqlItem.OLD_LINE_SCHEDULE_DATE := aSqlItem.OLD_LINE_SCHEDULE_DATE;
285  aPlsqlItem.OLD_SOURCE_ORGANIZATION_CODE := aSqlItem.OLD_SOURCE_ORGANIZATION_CODE;
286  aPlsqlItem.FIRM_SOURCE_ORG_ID := aSqlItem.FIRM_SOURCE_ORG_ID;
287  aPlsqlItem.FIRM_SOURCE_ORG_CODE := aSqlItem.FIRM_SOURCE_ORG_CODE;
288  aPlsqlItem.FIRM_SHIP_DATE := aSqlItem.FIRM_SHIP_DATE;
289  aPlsqlItem.FIRM_ARRIVAL_DATE := aSqlItem.FIRM_ARRIVAL_DATE;
290  aPlsqlItem.SHIP_METHOD_TEXT := aSqlItem.SHIP_METHOD_TEXT;
291  aPlsqlItem.SHIP_SET_ID := aSqlItem.SHIP_SET_ID;
292  aPlsqlItem.ARRIVAL_SET_ID := aSqlItem.ARRIVAL_SET_ID;
293  aPlsqlItem.PROJECT_ID := aSqlItem.PROJECT_ID;
294  aPlsqlItem.TASK_ID := aSqlItem.TASK_ID;
295  aPlsqlItem.PROJECT_NUMBER := aSqlItem.PROJECT_NUMBER;
296  aPlsqlItem.TASK_NUMBER := aSqlItem.TASK_NUMBER;
297  aPlsqlItem.ATTRIBUTE_11 := aSqlItem.ATTRIBUTE_11;
298  aPlsqlItem.ATTRIBUTE_12 := aSqlItem.ATTRIBUTE_12;
299  aPlsqlItem.ATTRIBUTE_13 := aSqlItem.ATTRIBUTE_13;
300  aPlsqlItem.ATTRIBUTE_14 := aSqlItem.ATTRIBUTE_14;
301  aPlsqlItem.ATTRIBUTE_15 := aSqlItem.ATTRIBUTE_15;
302  aPlsqlItem.ATTRIBUTE_16 := aSqlItem.ATTRIBUTE_16;
303  aPlsqlItem.ATTRIBUTE_17 := aSqlItem.ATTRIBUTE_17;
304  aPlsqlItem.ATTRIBUTE_18 := aSqlItem.ATTRIBUTE_18;
305  aPlsqlItem.ATTRIBUTE_19 := aSqlItem.ATTRIBUTE_19;
306  aPlsqlItem.ATTRIBUTE_20 := aSqlItem.ATTRIBUTE_20;
307  aPlsqlItem.ATTRIBUTE_21 := aSqlItem.ATTRIBUTE_21;
308  aPlsqlItem.ATTRIBUTE_22 := aSqlItem.ATTRIBUTE_22;
309  aPlsqlItem.ATTRIBUTE_23 := aSqlItem.ATTRIBUTE_23;
310  aPlsqlItem.ATTRIBUTE_24 := aSqlItem.ATTRIBUTE_24;
311  aPlsqlItem.ATTRIBUTE_25 := aSqlItem.ATTRIBUTE_25;
312  aPlsqlItem.ATTRIBUTE_26 := aSqlItem.ATTRIBUTE_26;
313  aPlsqlItem.ATTRIBUTE_27 := aSqlItem.ATTRIBUTE_27;
314  aPlsqlItem.ATTRIBUTE_28 := aSqlItem.ATTRIBUTE_28;
315  aPlsqlItem.ATTRIBUTE_29 := aSqlItem.ATTRIBUTE_29;
316  aPlsqlItem.ATTRIBUTE_30 := aSqlItem.ATTRIBUTE_30;
317  aPlsqlItem.ATF_DATE := aSqlItem.ATF_DATE;
318  aPlsqlItem.PLAN_ID := aSqlItem.PLAN_ID;
319  aPlsqlItem.ORIGINAL_REQUEST_DATE := aSqlItem.ORIGINAL_REQUEST_DATE;
320  aPlsqlItem.RECEIVING_CAL_CODE := aSqlItem.RECEIVING_CAL_CODE;
321  aPlsqlItem.INTRANSIT_CAL_CODE := aSqlItem.INTRANSIT_CAL_CODE;
322  aPlsqlItem.SHIPPING_CAL_CODE := aSqlItem.SHIPPING_CAL_CODE;
323  aPlsqlItem.MANUFACTURING_CAL_CODE := aSqlItem.MANUFACTURING_CAL_CODE;
324  aPlsqlItem.INTERNAL_ORG_ID := aSqlItem.INTERNAL_ORG_ID;
325  aPlsqlItem.FIRST_VALID_SHIP_ARRIVAL_DATE := aSqlItem.FIRST_VALID_SHIP_ARRIVAL_DATE;
326  aPlsqlItem.PARTY_SITE_ID := aSqlItem.PARTY_SITE_ID;
327  RETURN aPlsqlItem;
328  END SQL_TO_PL1;
329 
330  FUNCTION PL_TO_SQL0(aPlsqlItem MSC_ATP_BPEL.ATP_REC_TABLE_TYP)
331    RETURN MSC_ATP_BPEL_ATP_REC_TABLE_TY IS
332  aSqlItem MSC_ATP_BPEL_ATP_REC_TABLE_TY;
333  BEGIN
334  -- initialize the table
335  aSqlItem := MSC_ATP_BPEL_ATP_REC_TABLE_TY();
336  aSqlItem.EXTEND(aPlsqlItem.COUNT);
337  FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
338  aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL1(aPlsqlItem(I));
339  END LOOP;
340  RETURN aSqlItem;
341  END PL_TO_SQL0;
342 
343  FUNCTION SQL_TO_PL0(aSqlItem MSC_ATP_BPEL_ATP_REC_TABLE_TY)
344  RETURN MSC_ATP_BPEL.ATP_REC_TABLE_TYP IS
345  aPlsqlItem MSC_ATP_BPEL.ATP_REC_TABLE_TYP;
346  BEGIN
347  FOR I IN 1..aSqlItem.COUNT LOOP
348  aPlsqlItem(I) := SQL_TO_PL1(aSqlItem(I));
349  END LOOP;
350  RETURN aPlsqlItem;
351  END SQL_TO_PL0;
352 
353  PROCEDURE MSC_ATP_BPEL$CALL_ATP_BPEL (P_SESSION_ID IN OUT NOCOPY NUMBER,P_ATP_TAB
354  MSC_ATP_BPEL_ATP_REC_TABLE_TY,X_ATP_TAB OUT NOCOPY
355  MSC_ATP_BPEL_ATP_REC_TABLE_TY,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_DATA OUT
356  NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER) IS
357        P_ATP_TAB_ APPS.MSC_ATP_BPEL.ATP_REC_TABLE_TYP;
358        X_ATP_TAB_ APPS.MSC_ATP_BPEL.ATP_REC_TABLE_TYP;
359  BEGIN
360        P_ATP_TAB_ := XX_BPEL_EBS11I10ATPCHECK.SQL_TO_PL0(P_ATP_TAB);
361 
362  APPS.MSC_ATP_BPEL.CALL_ATP_BPEL(P_SESSION_ID,P_ATP_TAB_,X_ATP_TAB_,X_RETURN_STATUS,X_MSG_DATA,X_MSG_COUNT);
363        X_ATP_TAB := XX_BPEL_EBS11I10ATPCHECK.PL_TO_SQL0(X_ATP_TAB_);
364  END MSC_ATP_BPEL$CALL_ATP_BPEL;
365 
366  END XX_BPEL_EBS11I10ATPCHECK;