[Home] [Help]
PACKAGE: APPS.MSC_GET_GANTT_DATA
Source
1 PACKAGE Msc_Get_GANTT_DATA AUTHID CURRENT_USER AS
2 /* $Header: MSCGNTDS.pls 120.1 2005/06/17 15:36:31 appldev $ */
3
4 END_DEMAND_NODE CONSTANT number :=0;
5 JOB_NODE CONSTANT number :=1;
6 OP_NODE CONSTANT number :=2;
7 RES_NODE CONSTANT number :=3;
8 END_JOB_NODE CONSTANT number :=4;
9 PREV_NODE CONSTANT number :=-1;
10 NEXT_NODE CONSTANT number :=-2;
11
12 TYPE char20Tbl IS TABLE OF varchar2(20) index by binary_integer;
13 TYPE char80Tbl IS TABLE OF varchar2(80) index by binary_integer;
14 TYPE numberTbl IS TABLE OF number index by binary_integer;
15
16 TYPE Child_REC_TYPE is RECORD (
17 record_count numberTbl,
18 start_date char20Tbl,
19 end_date char20Tbl,
20 name char80Tbl,
21 transaction_id numberTbl,
22 status numberTbl,
23 applied numberTbl,
24 supply_type char80Tbl,
25 instance_id numberTbl,
26 res_firm_flag numberTbl,
27 sup_firm_flag numberTbl,
28 late_flag numberTbl
29 );
30
31 TYPE longCharTbl IS TABLE of varchar2(200) index by binary_integer;
32 TYPE maxCharTbl IS TABLE of varchar2(32000);
33
34 TYPE PEG_REC_TYPE is RECORD (
35 parent_index numberTbl,
36 next_record numberTbl,
37 org_id numberTbl,
38 department_id numberTbl,
39 transaction_id numberTbl,
40 instance_id numberTbl,
41 op_seq numberTbl,
42 type numberTbl,
43 path longCharTbl,
44 name longCharTbl,
45 firm_flag numberTbl,
46 start_date char20Tbl,
47 end_date char20Tbl,
48 status numberTbl,
49 applied numberTbl,
50 res_firm_flag numberTbl,
51 late_flag numberTbl,
52 early_start_date char20Tbl,
53 early_end_date char20Tbl,
54 latest_start_date char20Tbl,
55 latest_end_date char20Tbl,
56 u_early_start_date char20Tbl,
57 u_early_end_date char20Tbl,
58 min_start_date char20Tbl,
59 critical_flag numberTbl,
60 supply_type numberTbl,
61 new_path longCharTbl
62 );
63
64 FUNCTION get_debug_mode return varchar2;
65
66 FUNCTION replace_seperator(old_string varchar2) return varchar2 ;
67
68 Procedure setFetchRow(p_supply_limit number,
69 p_resource_limit number);
70
71 Function fetchDeptResCode(p_plan_id number,
72 v_instance_id number,
73 v_org_id number,
74 v_dept_id number,
75 v_res_id number) RETURN varchar2;
76
77 Procedure fetchAllResource(p_plan_id number,
78 p_where varchar2,
79 v_name OUT NOCOPY varchar2);
80
81 Procedure fetchResourceData(p_plan_id number,
82 p_res_list varchar2,
83 p_fetch_type varchar2 default null,
84 v_require_data OUT NOCOPY Child_REC_TYPE,
85 v_name OUT NOCOPY varchar2);
86
87 Procedure fetchLoadData(p_plan_id number,
88 p_res_list varchar2,
89 p_start varchar2 DEFAULT NULL,
90 p_end varchar2 DEFAULT NULL,
91 v_require_data IN OUT NOCOPY maxCharTbl,
92 v_avail_data OUT NOCOPY varchar2);
93
94 Function loadAltResource(p_plan_id number,
95 p_transaction_id number,
96 p_instance_id number,
97 p_alt_resource number,
98 p_alt_num number)
99 return Varchar2;
100
101 Function firmResource(p_plan_id number,
102 p_transaction_id number,
103 p_instance_id number,
104 p_firm_type number,
105 p_start varchar2,
106 p_end varchar2) return Varchar2;
107
108 PROCEDURE fetchAltResource(p_plan_id number,
109 p_transaction_id number,
110 p_instance_id number,
111 v_name OUT NOCOPY varchar2,
112 v_id OUT NOCOPY varchar2);
113
114 PROCEDURE fetchSimultaneousRes(p_plan_id number,
115 p_transaction_id number,
116 p_instance_id number,
117 v_name OUT NOCOPY varchar2,
118 v_id OUT NOCOPY varchar2);
119
120 PROCEDURE fetchPropertyData(p_plan_id number,
121 p_transaction_id number,
122 p_instance_id number,
123 v_job OUT NOCOPY varchar2,
124 v_demand OUT NOCOPY varchar2);
125
126 Procedure fetchDemandData( p_plan_id number,
127 p_instance_id number,
128 v_transaction_id number,
129 v_org_id number,
130 v_demand out NOCOPY varchar2) ;
131
132 Procedure fetchRescheduleData(p_plan_id number,
133 p_instance_id number,
134 p_org_id number,
135 p_dept_id number,
136 p_res_id number,
137 p_time varchar2,
138 v_require_data OUT NOCOPY varchar2);
139
140 Procedure fetchRescheduleData(p_plan_id number,
141 p_instance_id number,
142 p_transaction_id number,
143 v_require_data OUT NOCOPY varchar2);
144
145 Function get_MTQ_time(p_transaction_id number,
146 p_plan_id number,
147 p_instance_id number) return number;
148
149 Procedure ValidateTime(p_plan_id number,
150 p_transaction_id number,
151 p_instance_id number,
152 p_start varchar2,
153 p_end varchar2,
154 p_return_status OUT NOCOPY varchar2,
155 p_out OUT NOCOPY varchar2);
156
157 FUNCTION IsTimeFenceCrossed(p_plan_id number,
158 p_transaction_id number,
159 p_instance_id number,
160 p_start varchar2)
161 RETURN varchar2;
162
163 Procedure ValidateAndMove(p_plan_id number,
164 p_transaction_id number,
165 p_instance_id number,
166 p_start varchar2,
167 p_end varchar2,
168 p_return_status OUT NOCOPY varchar2,
169 p_out OUT NOCOPY varchar2,
170 p_out2 OUT NOCOPY boolean);
171
172 Function usingBatchableRes(p_plan_id number,
173 p_transaction_id number,
174 p_instance_id number) return boolean;
175
176 Procedure MoveResource(p_plan_id number,
177 p_transaction_id number,
178 p_instance_id number,
179 p_start varchar2,
180 p_end varchar2,
181 p_return_status OUT NOCOPY varchar2,
182 p_out OUT NOCOPY varchar2);
183
184 Function get_start_date(p_plan_id number,
185 p_transaction_id number,
186 p_instance_id number)
187 return date;
188
189 Function get_end_date(p_plan_id number,
190 p_transaction_id number,
191 p_instance_id number)
192 return date;
193
194 Procedure findRequest(p_plan_id number,
195 p_where varchar2,
196 v_resource_list OUT NOCOPY varchar2,
197 v_supply_list OUT NOCOPY varchar2);
198
199 FUNCTION constructSupplyRequest(p_from_block varchar2,
200 p_plan_id number,
201 p_where varchar2) Return varchar2;
202
203 FUNCTION constructResourceRequest(p_from_block varchar2,
204 p_plan_id number,
205 p_where varchar2) RETURN varchar2;
206
207 FUNCTION constructRequest(p_type varchar2,
208 p_plan_id number,
209 p_where varchar2,
210 p_from_block varchar2) RETURN varchar2;
211
212 Function get_result(start_index IN number, v_return_data OUT NOCOPY varchar2,
213 next_index OUT NOCOPY number)
214 return boolean;
215
216 Procedure explode_children(p_plan_id number,
217 p_critical number default -1);
218
219 Procedure get_end_pegging(p_plan_id number);
220
221 Procedure get_property(p_plan_id number, p_instance_id number,
222 p_transaction_id number,
223 p_type number, v_pro out NOCOPY varchar2,
224 v_demand out NOCOPY varchar2)
225 ;
226
227 Procedure init;
228
229 Function print_one_record(i number) Return varchar2;
230
231 Procedure fetchSupplyData(p_plan_id number, p_supply_list varchar2,
232 p_fetch_type varchar2 default null);
233
234 Function get_plan_time (p_plan_id number) return varchar2;
235
236 Procedure validate_and_move_end_job (p_plan_id number,
237 p_supply_id number,
238 p_end varchar2,
239 p_return_status OUT NOCOPY varchar2,
240 p_out out NOCOPY varchar2);
241
242 Procedure fetchSupplierLoadData(p_plan_id number,
243 p_supplier_list varchar2,
244 p_start varchar2 default null,
245 p_end varchar2 default null,
246 v_require_data IN OUT NOCOPY maxCharTbl,
247 v_avail_data IN OUT NOCOPY maxCharTbl);
248
249 Procedure fetchLateDemandData(p_plan_id number, p_demand_id number,
250 p_critical number default -1);
251
252 Procedure fetchAllSupplier(p_plan_id number,
253 v_name OUT NOCOPY varchar2);
254
255 Procedure fetchAllLateDemand(p_plan_id number,
256 p_demand_id number,
257 v_name OUT NOCOPY varchar2);
258
259 Function isCriticalSupply(p_plan_id number,
260 p_end_demand_id number,
261 p_transaction_id number,
262 p_inst_id number) Return number;
263
264 Function isCriticalRes(p_plan_id number,
265 p_end_demand_id number,
266 p_transaction_id number,
267 p_inst_id number,
268 p_operation_seq_id number,
269 p_routing_seq_id number) Return number;
270
271 Function supplyType(p_order_type number, p_make_buy_code number,
272 p_org_id number,p_source_org_id number) return number;
273
274 Function actualStartDate(p_order_type number, p_make_buy_code number,
275 p_org_id number,p_source_org_id number,
276 p_dock_date date, p_wip_start_date date,
277 p_ship_date date, p_schedule_date date)
278 return varchar2 ;
279
280 Function fetchSupplierPriority(p_plan_id number,
281 p_instance_id number,
282 p_org_id number,
283 p_item_id number,
284 p_supplier_id number,
285 p_start varchar2,
286 p_end varchar2) return varchar2;
287
288 Function fetchResourcePriority(p_plan_id number,
289 p_instance_id number,
290 p_org_id number,
291 p_dept_id number,
292 p_resource_id number,
293 p_start varchar2,
294 p_end varchar2) return varchar2;
295
296 Function get_dmd_priority(p_plan_id number,
297 p_instance_id number,
298 p_transaction_id number) return number;
299 Function get_new_result(start_index IN number,
300 v_return_data OUT NOCOPY varchar2,
301 next_index OUT NOCOPY number)
302 return boolean;
303
304 Procedure start_fetch(p_fetch_type IN varchar2,
305 v_return_data OUT NOCOPY varchar2,
306 start_index OUT NOCOPY number);
307 Function modify_parent_path(i number) return varchar2;
308
309 FUNCTION isSupplyLate(p_plan_id number,
310 p_instance_id number,
311 p_organization_id number,
312 p_inventory_item_id number,
313 p_transaction_id number) RETURN NUMBER;
314
315 Function order_number(p_order_type number, p_order_number varchar2,
316 p_plan_id number, p_inst_id number,
317 p_transaction_id number, p_disposition_id number)
318 return varchar2;
319
320 END Msc_Get_GANTT_DATA;