DBA Data[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;