[Home] [Help]
PACKAGE: APPS.MSC_ATP_BPEL
Source
1 PACKAGE MSC_ATP_BPEL AUTHID CURRENT_USER AS
2 /* $Header: MSCATPBS.pls 120.0 2007/12/18 10:12:42 arrsubra noship $ */
3
4 TYPE ATP_Rec_Scalar_Typ is RECORD (
5 Row_Id varchar2(30),
6 Instance_Id number,
7 Inventory_Item_Id number,
8 Inventory_Item_Name varchar2(40),
9 Source_Organization_Id number,
10 Source_Organization_Code varchar2(7),
11 Organization_Id number,
12 Identifier number,
13 Demand_Source_Header_Id number,
14 Demand_Source_Delivery varchar2(30),
15 Demand_Source_Type number,
16 Scenario_Id number,
17 Calling_Module number,
18 Customer_Id number,
19 Customer_Site_Id number,
20 Destination_Time_Zone varchar2(30),
21 Quantity_Ordered number,
22 Quantity_UOM varchar2(3),
23 Requested_Ship_Date date,
24 Requested_Arrival_Date date,
25 Earliest_Acceptable_Date date,
26 Latest_Acceptable_Date date,
27 Delivery_Lead_Time number,
28 Freight_Carrier varchar2(30),
29 Ship_Method varchar2(30),
30 Demand_Class varchar2(30),
31 Ship_Set_Name varchar2(30),
32 Arrival_Set_Name varchar2(30),
33 Override_Flag varchar2(1),
34 Action number,
35 Ship_Date date,
36 Arrival_date date,
37 Available_Quantity number,
38 Requested_Date_Quantity number,
39 Group_Ship_Date date,
40 Group_Arrival_Date date,
41 Vendor_Id number,
42 Vendor_Name varchar2(80),
43 Vendor_Site_Id number,
44 Vendor_Site_Name varchar2(80),
45 Insert_Flag number,
46 OE_Flag varchar2(1),
47 Atp_Lead_Time number,
48 Error_Code number,
49 Message varchar2(2000),
50 End_Pegging_Id number,
51 Order_Number number,
52 Old_Source_Organization_Id number,
53 Old_Demand_Class varchar2(30),
54 ato_delete_flag varchar2(1),
55 attribute_01 number,
56 attribute_02 number,
57 attribute_03 number,
58 attribute_04 number,
59 attribute_05 varchar2(30),
60 attribute_06 varchar2(30),
61 attribute_07 varchar2(30),
62 attribute_08 varchar2(30),
63 attribute_09 date,
64 attribute_10 date,
65 customer_name varchar2(255),
66 customer_class varchar2(30),
67 customer_location varchar2(40),
68 customer_country varchar2(60),
69 customer_state varchar2(60),
70 customer_city varchar2(60),
71 customer_postal_code varchar2(60),
72 substitution_typ_code number,
73 req_item_detail_flag number,
74 request_item_id number,
75 req_item_req_date_qty number,
76 req_item_available_date date,
77 req_item_available_date_qty number,
78 request_item_name varchar2(40),
79 old_inventory_item_id number,
80 sales_rep varchar2(255),
81 customer_contact varchar2(255),
82 subst_flag number,
83 Top_Model_line_id number,
84 ATO_Parent_Model_Line_Id number,
85 ATO_Model_Line_Id number,
86 Parent_line_id number,
87 match_item_id number,
88 Config_item_line_id number,
89 Validation_Org number,
90 Component_Sequence_ID number,
91 Component_Code varchar2(255),
92 line_number varchar2(80),
93 included_item_flag number,
94 atp_flag varchar2(1),
95 atp_components_flag varchar2(1),
96 wip_supply_type number,
97 bom_item_type number,
98 mandatory_item_flag number,
99 pick_components_flag varchar2(1),
100 base_model_id number,
101 OSS_ERROR_CODE number,
102 matched_item_name varchar2(255),
103 cascade_model_info_to_comp number,
104 sequence_number number,
105 firm_flag number,
106 order_line_number number,
107 option_number number,
108 shipment_number number,
109 item_desc varchar2(255),
110 old_line_schedule_date date,
111 old_source_organization_code varchar2(7),
112 firm_source_org_id number,
113 firm_source_org_code varchar2(7),
114 firm_ship_date date,
115 firm_arrival_date date,
116 ship_method_text varchar2(255),
117 ship_set_id number,
118 arrival_set_id number,
119 PROJECT_ID number,
120 TASK_ID number,
121 PROJECT_NUMBER varchar2(30),
122 TASK_NUMBER varchar2(30),
123 attribute_11 number,
124 attribute_12 number,
125 attribute_13 number,
126 attribute_14 number,
127 attribute_15 varchar2(30),
128 attribute_16 varchar2(30),
129 attribute_17 varchar2(30),
130 attribute_18 varchar2(30),
131 attribute_19 date,
132 attribute_20 date,
133 Attribute_21 number,
134 attribute_22 number,
135 attribute_23 number,
136 attribute_24 number,
137 attribute_25 varchar2(30),
138 attribute_26 varchar2(30),
139 attribute_27 varchar2(30),
140 attribute_28 varchar2(30),
141 attribute_29 date,
142 attribute_30 date,
143 atf_date date,
144 plan_id number,
145 original_request_date date,
146 receiving_cal_code varchar2(14),
147 intransit_cal_code varchar2(14),
148 shipping_cal_code varchar2(14),
149 manufacturing_cal_code varchar2(14),
150 internal_org_id number,
151 first_valid_ship_arrival_date date,
152 party_site_id number,
153 part_of_set varchar2(1) --Added in 12.0
154 /* Next 3 fields belong to ER 1879787 - not ported to 12.0
155 available_qty_orig_uom number,
156 requested_date_qty_orig_uom number,
157 Primary_UOM varchar2(3)
158 */
159 );
160
161 TYPE ATP_Rec_Table_Typ IS TABLE OF ATP_Rec_Scalar_Typ INDEX BY BINARY_INTEGER ;
162
163
164 /* This procedure Call_ATP_BPEL will be the ATP API to be
165 called when J Publisher is used.
166 It will internally call PROCEDURE ATP_Rec_convert_tab
167 to convert table of record to record of tables.
168 Now call existing ATP API MRP_ATP_PUB.Call_ATP.
169 Then call PROCEDURE ATP_Rec_convert_rec to convert the record of tables
170 (output of MRP_ATP_PUB.Call_ATP) to table of record.
171 These are passed as OUT parameters to Call_ATP_Wrapper API.
172 */
173
174
175 PROCEDURE ATP_Rec_convert_tab(
176 p_atp_tab IN MSC_ATP_BPEL.ATP_Rec_Table_Typ,
177 x_atp_rec OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ );
178
179 PROCEDURE ATP_Rec_convert_rec(
180 p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
181 p_atp_tab OUT NoCopy MSC_ATP_BPEL.ATP_Rec_Table_Typ);
182
183 PROCEDURE Call_ATP_BPEL(
184 p_session_id IN OUT NoCopy NUMBER,
185 p_atp_tab IN MSC_ATP_BPEL.ATP_Rec_Table_Typ,
186 x_atp_tab OUT NoCopy MSC_ATP_BPEL.ATP_Rec_Table_Typ,
187 x_return_status OUT NoCopy VARCHAR2,
188 x_msg_data OUT NoCopy VARCHAR2,
189 x_msg_count OUT NoCopy NUMBER );
190
191 END MSC_ATP_BPEL;