[Home] [Help]
PACKAGE: APPS.MSC_ATPUI_UTIL
Source
1 PACKAGE MSC_ATPUI_UTIL AS
2 /* $Header: MSCATPUS.pls 120.1 2005/06/17 13:21:46 appldev $ */
3
4 TYPE number_arr IS TABLE OF number;
5 TYPE char1_arr IS TABLE of varchar2(1);
6 TYPE char3_arr IS TABLE OF varchar2(3);
7 TYPE char7_arr IS TABLE OF varchar2(7);
8 TYPE char10_arr IS TABLE OF varchar2(10);
9 TYPE char15_arr IS TABLE of varchar2(15);
10 TYPE char20_arr IS TABLE of varchar2(20);
11 TYPE char30_arr IS TABLE OF varchar2(30);
12 TYPE char40_arr IS TABLE OF varchar2(40);
13 TYPE char60_arr IS TABLE OF varchar2(60);
14 TYPE char80_arr IS TABLE of varchar2(80);
15 TYPE char255_arr IS TABLE of varchar2(255);
16 TYPE char2000_arr IS TABLE of varchar2(2000);
17 TYPE date_arr IS TABLE OF date;
18
19 --mrp_atp_schedule_temp table struct
20 TYPE ATP_SCHEDULE_TEMP_TYP is RECORD (
21 ACTION number_arr := number_arr(),
22 CALLING_MODULE number_arr := number_arr(),
23 SESSION_ID number_arr := number_arr(),
24 ORDER_HEADER_ID number_arr := number_arr(),
25 ORDER_LINE_ID number_arr := number_arr(),
26 INVENTORY_ITEM_ID number_arr := number_arr(),
27 ORGANIZATION_ID number_arr := number_arr(),
28 SR_INSTANCE_ID number_arr := number_arr(),
29 ORGANIZATION_CODE char7_arr := char7_arr(),
30 ORDER_NUMBER number_arr := number_arr(),
31 SOURCE_ORGANIZATION_ID number_arr := number_arr(),
32 CUSTOMER_ID number_arr := number_arr(),
33 CUSTOMER_SITE_ID number_arr := number_arr(),
34 DESTINATION_TIME_ZONE char30_arr := char30_arr(),
35 QUANTITY_ORDERED number_arr := number_arr(),
36 UOM_CODE char3_arr := char3_arr(),
37 REQUESTED_SHIP_DATE date_arr := date_arr(),
38 REQUESTED_ARRIVAL_DATE date_arr := date_arr(),
39 LATEST_ACCEPTABLE_DATE date_arr := date_arr(),
40 DELIVERY_LEAD_TIME number_arr := number_arr(),
41 FREIGHT_CARRIER char30_arr := char30_arr(),
42 SHIP_METHOD char30_arr := char30_arr(),
43 DEMAND_CLASS char30_arr := char30_arr(),
44 SHIP_SET_NAME char30_arr := char30_arr(),
45 ARRIVAL_SET_NAME char30_arr := char30_arr(),
46 OVERRIDE_FLAG char1_arr := char1_arr(),
47 SCHEDULED_SHIP_DATE date_arr := date_arr(),
48 SCHEDULED_ARRIVAL_DATE date_arr := date_arr(),
49 AVAILABLE_QUANTITY number_arr := number_arr(),
50 REQUESTED_DATE_QUANTITY number_arr := number_arr(),
51 GROUP_SHIP_DATE date_arr := date_arr(),
52 GROUP_ARRIVAL_DATE date_arr := date_arr(),
53 VENDOR_ID number_arr := number_arr(),
54 VENDOR_SITE_ID number_arr := number_arr(),
55 INSERT_FLAG number_arr := number_arr(),
56 ERROR_CODE char255_arr := char255_arr(),
57 ERROR_MESSAGE char255_arr := char255_arr(),
58 SEQUENCE_NUMBER number_arr := number_arr(),
59 FIRM_FLAG number_arr := number_arr(),
60 INVENTORY_ITEM_NAME char255_arr := char255_arr(),
61 SOURCE_ORGANIZATION_CODE char7_arr := char7_arr(),
62 INSTANCE_ID1 number_arr := number_arr(),
63 ORDER_LINE_NUMBER number_arr := number_arr(),
64 PROMISE_DATE date_arr := date_arr(),
65 CUSTOMER_NAME char255_arr := char255_arr(),
66 CUSTOMER_LOCATION char40_arr := char40_arr(),
67 OLD_LINE_SCHEDULE_DATE date_arr := date_arr(),
68 OLD_SOURCE_ORGANIZATION_CODE char7_arr := char7_arr(),
69 SCENARIO_ID number_arr := number_arr(),
70 VENDOR_NAME char80_arr := char80_arr(),
71 VENDOR_SITE_NAME char255_arr := char255_arr(),
72 STATUS_FLAG number_arr := number_arr(),
73 MDI_ROWID char30_arr := char30_arr(),
74 DEMAND_SOURCE_TYPE number_arr := number_arr(),
75 DEMAND_SOURCE_DELIVERY char30_arr := char30_arr(),
76 ATP_LEAD_TIME number_arr := number_arr(),
77 OE_FLAG char1_arr := char1_arr(),
78 ITEM_DESC char255_arr := char255_arr(),
79 INTRANSIT_LEAD_TIME number_arr := number_arr(),
80 SHIP_METHOD_TEXT char255_arr := char255_arr(),
81 END_PEGGING_ID number_arr := number_arr(),
82 SHIP_SET_ID number_arr := number_arr(),
83 ARRIVAL_SET_ID number_arr := number_arr(),
84 SHIPMENT_NUMBER number_arr := number_arr(),
85 OPTION_NUMBER number_arr := number_arr(),
86 PROJECT_ID number_arr := number_arr(),
87 TASK_ID number_arr := number_arr(),
88 PROJECT_NUMBER char30_arr := char30_arr(),
89 TASK_NUMBER char30_arr := char30_arr(),
90 EXCEPTION1 number_arr := number_arr(),
91 EXCEPTION2 number_arr := number_arr(),
92 EXCEPTION3 number_arr := number_arr(),
93 EXCEPTION4 number_arr := number_arr(),
94 EXCEPTION5 number_arr := number_arr(),
95 EXCEPTION6 number_arr := number_arr(),
96 EXCEPTION7 number_arr := number_arr(),
97 EXCEPTION8 number_arr := number_arr(),
98 EXCEPTION9 number_arr := number_arr(),
99 EXCEPTION10 number_arr := number_arr(),
100 EXCEPTION11 number_arr := number_arr(),
101 EXCEPTION12 number_arr := number_arr(),
102 EXCEPTION13 number_arr := number_arr(),
103 EXCEPTION14 number_arr := number_arr(),
104 EXCEPTION15 number_arr := number_arr(),
105 FIRM_SOURCE_ORG_ID number_arr := number_arr(),
106 FIRM_SOURCE_ORG_CODE char7_arr := char7_arr(),
107 FIRM_SHIP_DATE date_arr := date_arr(),
108 FIRM_ARRIVAL_DATE date_arr := date_arr(),
109 OLD_SOURCE_ORGANIZATION_ID number_arr := number_arr(),
110 OLD_DEMAND_CLASS char30_arr := char30_arr(),
111 ATTRIBUTE_06 char30_arr := char30_arr(),
112 REQUEST_ITEM_ID number_arr := number_arr(),
113 REQUEST_ITEM_NAME char255_arr := char255_arr(),
114 REQ_ITEM_AVAILABLE_DATE date_arr := date_arr(),
115 REQ_ITEM_AVAILABLE_DATE_QTY number_arr := number_arr(),
116 REQ_ITEM_REQ_DATE_QTY number_arr := number_arr(),
117 SALES_REP char255_arr := char255_arr(),
118 CUSTOMER_CONTACT char255_arr := char255_arr(),
119 SUBST_FLAG number_arr := number_arr(),
120 SUBSTITUTION_TYP_CODE number_arr := number_arr(),
121 REQ_ITEM_DETAIL_FLAG number_arr := number_arr(),
122 OLD_INVENTORY_ITEM_ID number_arr := number_arr(),
123 COMPILE_DESIGNATOR char10_arr := char10_arr(),
124 CREATION_DATE date_arr := date_arr(),
125 CREATED_BY number_arr := number_arr(),
126 LAST_UPDATE_DATE date_arr := date_arr(),
127 LAST_UPDATED_BY number_arr := number_arr(),
128 LAST_UPDATE_LOGIN number_arr := number_arr(),
129 FLOW_STATUS_CODE char30_arr := char30_arr(),
130 ASSIGNMENT_SET_ID number_arr := number_arr(),
131 DIAGNOSTIC_ATP_FLAG number_arr := number_arr() );
132
133 --the mrp_atp_details_temp struct
134 TYPE ATP_details_rec_type is RECORD (
135 SESSION_ID number_arr := number_arr(),
136 ORDER_LINE_ID number_arr := number_arr(),
137 PEGGING_ID number_arr := number_arr(),
138 PARENT_PEGGING_ID number_arr := number_arr(),
139 ATP_LEVEL number_arr := number_arr(),
140 REQUEST_ITEM_ID number_arr := number_arr(),
141 INVENTORY_ITEM_ID number_arr := number_arr(),
142 INVENTORY_ITEM_NAME char255_arr := char255_arr(),
143 ORGANIZATION_ID number_arr := number_arr(),
144 ORGANIZATION_CODE char7_arr := char7_arr(),
145 DEPARTMENT_ID number_arr := number_arr(),
146 DEPARTMENT_CODE char10_arr := char10_arr(),
147 RESOURCE_ID number_arr := number_arr(),
148 RESOURCE_CODE char10_arr := char10_arr(),
149 SUPPLIER_ID number_arr := number_arr(),
150 SUPPLIER_NAME char80_arr := char80_arr(),
151 SUPPLIER_SITE_ID number_arr := number_arr(),
152 SUPPLIER_SITE_NAME char15_arr := char15_arr(),
153 FROM_ORGANIZATION_ID number_arr := number_arr(),
154 FROM_ORGANIZATION_CODE char3_arr := char3_arr(),
155 FROM_LOCATION_ID number_arr := number_arr(),
156 FROM_LOCATION_CODE char20_arr := char20_arr(),
157 TO_ORGANIZATION_ID number_arr := number_arr(),
158 TO_ORGANIZATION_CODE char3_arr := char3_arr(),
159 TO_LOCATION_ID number_arr := number_arr(),
160 TO_LOCATION_CODE char20_arr := char20_arr(),
161 SHIP_METHOD char30_arr := char30_arr(),
162 UOM_CODE char3_arr := char3_arr(),
163 IDENTIFIER1 number_arr := number_arr(),
164 IDENTIFIER2 number_arr := number_arr(),
165 IDENTIFIER3 number_arr := number_arr(),
166 IDENTIFIER4 number_arr := number_arr(),
167 SUPPLY_DEMAND_TYPE number_arr := number_arr(),
168 SUPPLY_DEMAND_DATE date_arr := date_arr(),
169 SUPPLY_DEMAND_QUANTITY number_arr := number_arr(),
170 SUPPLY_DEMAND_SOURCE_TYPE number_arr := number_arr(),
171 ALLOCATED_QUANTITY number_arr := number_arr(),
172 SOURCE_TYPE number_arr := number_arr(),
173 RECORD_TYPE number_arr := number_arr(),
174 TOTAL_SUPPLY_QUANTITY number_arr := number_arr(),
175 TOTAL_DEMAND_QUANTITY number_arr := number_arr(),
176 PERIOD_START_DATE date_arr := date_arr(),
177 PERIOD_QUANTITY number_arr := number_arr(),
178 CUMULATIVE_QUANTITY number_arr := number_arr(),
179 WEIGHT_CAPACITY number_arr := number_arr(),
180 VOLUME_CAPACITY number_arr := number_arr(),
181 WEIGHT_UOM char3_arr := char3_arr(),
182 VOLUME_UOM char3_arr := char3_arr(),
183 PERIOD_END_DATE date_arr := date_arr(),
184 SCENARIO_ID number_arr := number_arr(),
185 DISPOSITION_TYPE number_arr := number_arr(),
186 DISPOSITION_NAME char80_arr := char80_arr(),
187 REQUEST_ITEM_NAME char255_arr := char255_arr(),
188 SUPPLY_DEMAND_SOURCE_TYPE_NAME char80_arr := char80_arr(),
189 END_PEGGING_ID number_arr := number_arr(),
190 CONSTRAINT_FLAG char1_arr := char1_arr(),
191 NUMBER1 number_arr := number_arr(),
192 CHAR1 char40_arr := char40_arr(),
193 COMPONENT_IDENTIFIER number_arr := number_arr(),
194 BATCHABLE_FLAG number_arr := number_arr(),
195 DEST_INV_ITEM_ID number_arr := number_arr(),
196 SUPPLIER_ATP_DATE date_arr := date_arr(),
197 SUMMARY_FLAG char1_arr := char1_arr(),
198 PTF_DATE date_arr := date_arr(),
199 CREATION_DATE date_arr := date_arr(),
200 CREATED_BY number_arr := number_arr(),
201 LAST_UPDATE_DATE date_arr := date_arr(),
202 LAST_UPDATED_BY number_arr := number_arr(),
203 LAST_UPDATE_LOGIN number_arr := number_arr(),
204 FIXED_LEAD_TIME number_arr := number_arr(),
205 VARIABLE_LEAD_TIME number_arr := number_arr(),
206 PREPROCESSING_LEAD_TIME number_arr := number_arr(),
207 PROCESSING_LEAD_TIME number_arr := number_arr(),
208 POSTPROCESSING_LEAD_TIME number_arr := number_arr(),
209 INTRANSIT_LEAD_TIME number_arr := number_arr(),
210 ATP_RULE char80_arr := char80_arr(),
211 ALLOCATION_RULE char80_arr := char80_arr(),
212 INFINITE_TIME_FENCE date_arr := date_arr(),
213 INFINITE_TIME_FENCE_TYPE number_arr := number_arr(),
214 SUBSTITUTION_WINDOW number_arr := number_arr(),
215 REQUIRED_QUANTITY number_arr := number_arr(),
216 ROUNDING_CONTROL number_arr := number_arr(),
217 ATP_FLAG char1_arr := char1_arr(),
218 ATP_COMPONENT_FLAG char1_arr := char1_arr(),
219 REQUIRED_DATE date_arr := date_arr(),
220 OPERATION_SEQUENCE_ID number_arr := number_arr(),
221 SOURCING_RULE_NAME char30_arr := char30_arr(),
222 OFFSET number_arr := number_arr(),
223 EFFICIENCY number_arr := number_arr(),
224 OWNING_DEPARTMENT_ID number_arr := number_arr(),
225 REVERSE_CUM_YIELD number_arr := number_arr(),
226 BASIS_TYPE number_arr := number_arr(),
227 BATCH_FLAG char255_arr := char255_arr(),
228 USAGE number_arr := number_arr(),
229 CONSTRAINT_TYPE number_arr := number_arr(),
230 CONSTRAINT_DATE date_arr := date_arr(),
231 CRITICAL_PATH number_arr := number_arr(),
232 PEGGING_TYPE number_arr := number_arr(),
233 ASSIGNED_UNITS number_arr := number_arr(),
234 UTILIZATION number_arr := number_arr(),
235 ATP_RULE_ID number_arr := number_arr(),
236 OWNING_DEPARTMENT char10_arr := char10_arr(),
237 ATP_RULE_NAME char80_arr := char80_arr(),
238 PLAN_NAME char80_arr := char80_arr(),
239 CONSTRAINED_PATH number_arr := number_arr(),
240 PLAN_ID number_arr := number_arr(),
241 DEMAND_CLASS char80_arr := char80_arr(),
242 CLASS char80_arr := char80_arr(),
243 CUSTOMER_NAME char80_arr := char80_arr(),
244 CUSTOMER_SITE_NAME char80_arr := char80_arr(),
245 ALLOCATED_SUPPLY_QUANTITY number_arr := number_arr(),
246 SUPPLY_ADJUSTMENT_QUANTITY number_arr := number_arr(),
247 BACKWARD_FORWARD_QUANTITY number_arr := number_arr(),
248 BACKWARD_QUANTITY number_arr := number_arr(),
249 DEMAND_ADJUSTMENT_QUANTITY number_arr := number_arr(),
250 ADJUSTED_AVAILABILITY_QUANTITY number_arr := number_arr(),
251 ALLOCATION_PERCENT number_arr := number_arr(),
252 ACTUAL_ALLOCATION_PERCENT number_arr := number_arr(),
253 ADJUSTED_CUM_QUANTITY number_arr := number_arr(),
254 CUSTOMER_ID number_arr := number_arr(),
255 CUSTOMER_SITE_ID number_arr := number_arr()
256 );
257
258 PROCEDURE populate_schedule_temp_table(p_atp_schedule_temp IN MSC_ATPUI_UTIL.ATP_SCHEDULE_TEMP_TYP,
259 p_return_status out nocopy VARCHAR2,
260 p_error_message out nocopy VARCHAR2);
261 PROCEDURE get_schedule_temp_rows(p_session_id in NUMBER,
262 p_return_status out nocopy VARCHAR2,
263 p_error_message out nocopy VARCHAR2);
264
265 PROCEDURE populate_details_temp_table(p_atp_details_temp IN MSC_ATPUI_UTIL.ATP_details_rec_type,
266 p_return_status out nocopy VARCHAR2,
267 p_error_message out nocopy VARCHAR2);
268 PROCEDURE get_details_temp_rows(p_atp_details_temp IN OUT NoCopy MSC_ATPUI_UTIL.ATP_details_rec_type,
269 p_session_id in NUMBER,
270 p_return_status out nocopy VARCHAR2,
271 p_error_message out nocopy VARCHAR2);
272
273 PROCEDURE populate_mrp_atp_temp_tables(p_session_id in NUMBER,
274 p_return_status out nocopy VARCHAR2,
275 p_error_message out nocopy VARCHAR2);
276
277
278 END MSC_ATPUI_UTIL;