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: APPS.MSC_GANTT_PKG

Source


1 PACKAGE MSC_GANTT_PKG AUTHID CURRENT_USER AS
2 /* $Header: MSCGNTPS.pls 120.2 2006/09/18 20:51:16 pabram noship $  */
3 
4 
5   -- p_query_id is null for just orders, demands,
6 	-- will be the parent_query_id in case of peg up/down.
7   -- p_filter_type, filter_type_list 1, filter_type_mfq 2,
8 	-- filter_type_folder_id 3, filter_type_where_stmt 4, filter_type_among 5..
9   -- p_view_type, demand_view 1, order_view 2..
10   -- p_peg_type, 0 just orders, 1  peg down, -1 peg up, 2 peg_up_and_down..
11   -- p_refresh true/false to refresh the view with new data
12 
13   function orderView(p_query_id in number,
14     p_plan_id number, p_list varchar2, p_filter_type number,
15     p_view_type number, p_peg_type number,
16     p_node_count out nocopy varchar2,
17     p_refresh boolean default false) return number;
18 
19 procedure updateResUnitsDirectly(p_query_id number,
20   p_node_type number, p_inst_id number, p_trx_id number,
21   p_assigned_units_hours number,
22   p_return_status OUT NOCOPY varchar2,
23   p_out OUT NOCOPY varchar2);
24 
25 procedure updateResHoursDirectly(p_query_id number,
26   p_node_type number, p_inst_id number, p_trx_id number,
27   p_resource_hours number, p_return_status OUT NOCOPY varchar2,
28   p_out OUT NOCOPY varchar2);
29 
30   function addSimuAltResToView(p_query_id number,
31     p_view_type number, p_node_type number, p_node_list varchar2,
32     p_out out nocopy varchar2) return number;
33 
34   function addResToResView(p_from_query_id number, p_to_query_id in out nocopy number,
35     p_from_index number, p_critical number) return number;
36 
37   function addSuppToSuppView(p_from_query_id number, p_to_query_id in out nocopy number,
38     p_from_index number) return number;
39 
40 function AddToOrdersView(p_from_query_id number, p_to_query_id in out nocopy number,
41   p_from_index number, p_from_view_type number,
42   p_context_value varchar2, p_context_value2 varchar2 default null) return number;
43 
44   -- p_query_id is null for initial calculation,
45 	-- will be passed to fetch next set using p_from_index, p_to_index..
46   -- p_filter_type, filter_type_list 1, filter_type_mfq 2,
47 	-- filter_type_folder_id 3, filter_type_where_stmt 4, filter_type_among 5..
48   -- p_view_type, RES_ACTIVITIES_VIEW 3, RES_UNITS_VIEW 4, RES_HOURS_VIEW 5;
49   -- p_from_index number, p_to_index number row_index range to show
50   -- p_name_data contains the hgrid data
51   -- p_require_data contains the req data for res/supp
52   -- p_setup_data contains the setup data for res
53   -- p_avail_data contains the avail data for res/supp
54   -- p_batched_res_act boolean default false, <individual vs batched >
55 	--   RES_ACT_INDIVIDUAL null or 1, RES_ACT_BATCHED 2;
56   -- p_display_type number default null,
57 	--  DISPLAY_NONE 1, DISPLAY_LATE 2, DISPLAY_EARLY 3, DISPLAY_FIRM 4, DISPLAY_OVERLOAD 5;
58   -- p_refresh true/false to refresh the view with new data
59 
60   function resourceView (p_query_id in out nocopy number,
61     p_plan_id number, p_list varchar2,
62     p_filter_type number, p_view_type number,
63     p_from_index number, p_to_index number,
64     p_name_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
65     p_require_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
66     p_avail_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
67     p_batched_res_act number default null,
68     p_display_type number default null,
69     p_refresh boolean default false,
70     p_sort_column varchar2 default null,
71     p_sort_order varchar2 default null,
72     p_change_view boolean default false,
73     p_folder_id number default null) return number;
74 
75   -- p_query_id is null for initial calculation,
76 	-- will be passed to fetch next set using p_from_index, p_to_index..
77   -- p_filter_type, filter_type_list 1, filter_type_mfq 2,
78 	-- filter_type_folder_id 3, filter_type_where_stmt 4, filter_type_among 5..
79   -- p_view_type, RES_ACTIVITIES_VIEW 3, RES_UNITS_VIEW 4, RES_HOURS_VIEW 5;
80   -- p_from_index number, p_to_index number row_index range to show
81   -- p_name_data contains the hgrid data
82   -- p_avail_data - avail stream
83   -- p_net_cum_avail_data - net cumulative avail stream
84   -- p_consume_curr_data - consumed in current bucket stream
85   -- p_consume_future_data - consumed in future bucket stream
86   -- p_overload_data - overload stream
87   -- p_refresh true/false to refresh the view with new data
88 
89   function supplierView(p_query_id in out nocopy number,
90     p_plan_id number, p_list varchar2,
91     p_filter_type number, p_view_type number,
92     p_from_index number, p_to_index number,
93     p_name_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
94     p_supp_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
95     p_refresh boolean default false,
96     p_sort_column varchar2 default null,
97     p_sort_order varchar2 default null) return number;
98 
99   procedure sortResSuppView(p_query_id number,
100     p_view_type number, p_from_index number, p_to_index number,
101     p_name_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
102     p_sort_column varchar2 default null,
103     p_sort_order varchar2 default null);
104 
105   -- p_query_id
106   -- p_view_type, ORDER_VIEW 2, RES_ACTIVITIES_VIEW 3
107   -- p_node_type <JOB_NODE, RES_NODE, COPROD_NODE>
108   -- p_firm_type <firm, unfirm for supply>, <8 firm types for res req>
109   -- p_start_date, p_end_date <firm start and firm end dates>
110   -- p_row_index_list is (inst_id, trx id),(inst_id, trx_id)
111   -- p_return_status 'OK' or 'ERROR'
112   -- p_out the error type
113   -- p_out_data the sequence list <group seq id, group seq number>, ...
114   -- p_res_firm_seq if true will be sequence firmed.
115 
116   procedure firmUnfirm(p_query_id number,
117     p_view_type number, p_node_type number,
118     p_firm_type number,
119     p_start_date date, p_end_date date,
120     p_trx_list varchar2,
121     p_return_status OUT NOCOPY varchar2,
122     p_out OUT NOCOPY varchar2,
123     p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
124     p_validate_flag boolean default true,
125     p_res_firm_seq boolean default false,
126     p_batched_res_act boolean default false);
127 
128   -- p_query_id
129   -- p_view_type, ORDER_VIEW 2, RES_ACTIVITIES_VIEW 3
130   -- p_from_node_type, p_to_node_type is not null between 2 rows
131   -- p_from_trx_list, p_to_trx_list is not null between 2 rows
132   -- p_start_date, p_end_date start and end dates of node
133   -- p_duration for sequence firming move
134   -- p_return_status 'OK' or 'ERROR'
135   -- p_out the error type
136 
137   procedure moveNode(p_query_id number, p_view_type number,
138     p_node_type number, p_to_node_type number,
139     p_trx_list varchar2, p_to_trx_list varchar2,
140     p_start_date date, p_end_date date, p_duration varchar2,
141     p_return_status OUT NOCOPY varchar2,
142     p_out OUT NOCOPY varchar2,
143     p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
144     p_validate_flag boolean default true,
145     p_res_firm_seq boolean default false,
146     p_batched_res_act boolean default false);
147 
148   -- p_node_type - valid values RES_NODE, RES_INST_NODE
149   -- p_to_node_type - valid values RES_NODE, RES_INST_NODE,
150 	--   is not null between 2 rows
151   -- p_firm_type 0..7 for res req
152   -- p_trx_list is (inst_id, trx id),(inst_id, trx_id)
153   -- p_to_trx_list is (res_id,res_inst_id, serial_number, alt_number)
154   -- p_start_date, p_end_date <firm start and firm end dates>
155   -- p_duration in long type for sequence firming move, is it supported from form
156   -- p_return_status 'OK' or 'ERROR'
157   -- p_out the error type
158   -- p_out_data the sequence list <group seq id, group seq number>, ...
159   -- p_validate_flag boolean default true,
160   -- p_res_firm_seq boolean default false,
161 
162   procedure moveAndFirm(p_node_type number, p_to_node_type number,
163     p_firm_type number, p_trx_list varchar2, p_to_trx_list varchar2,
164     p_start_date date, p_end_date date, p_duration varchar2,
165     p_return_status OUT NOCOPY varchar2, p_out OUT NOCOPY varchar2,
166     p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
167     p_validate_flag boolean default true,
168     p_res_firm_seq boolean default false);
169 
170   --p_trx_list is (inst_id, trx id),(inst_id, trx_id)
171   procedure resCharges(p_query_id number,
172     p_trx_list varchar2, p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl);
173 
174   --p_row_indexes is list of row_indexes separated by commas
175   -- output. from_row_index, from_start_date, from_end_date
176   --to_row_index, to_start_date, to_end_date, dependency_type
177 
178   procedure segmentPegging(p_query_id number,
179     p_trx_list varchar2, p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl);
180 
181 --wrapper
182 
183 --sets the user perference id and will be used thereafter
184 procedure getUserPref(p_pref_id number);
185 
186 function getPlanInfo(p_plan_id number) return varchar2;
187 
188 function isPlanGanttEnabled(p_plan_id number) return boolean;
189 function isPlanDSEnabled(p_plan_id number) return boolean;
190 
191 procedure getSimuResource(p_plan_id number,
192   p_transaction_id number, p_instance_id number,
193   p_name OUT NOCOPY varchar2, p_id OUT NOCOPY varchar2,
194   p_node_type number default null);
195 
196 procedure getAltResource(p_plan_id number,
197   p_transaction_id number, p_instance_id number,
198   p_name OUT NOCOPY varchar2, p_id OUT NOCOPY varchar2,
199   p_node_type number default null,
200   p_from_form number default null);
201 
202 function getResult(p_query_id number,
203   p_from_index number, p_to_index number,
204   p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
205   p_node_level number default null,
206   p_sort_node number default null,
207   p_sort_column varchar2 default null,
208   p_sort_order varchar2 default null,
209   p_res_nodes_only varchar2 default null) return number;
210 
211 function getEndDemandIds(p_plan_id number, p_view_type number, p_node_type number,
212   p_trx_list varchar2, p_date1 date default null, p_date2 date default null) return number;
213 
214 procedure getProperty(p_plan_id number, p_instance_id number,
215   p_transaction_id number, p_type number, p_view_type number,
216   v_pro out NOCOPY varchar2, v_demand out NOCOPY varchar2);
217 
218 --5516790 bugfix
219 function getNewViewStartDate(p_node_type number, p_trx_id number, p_to_view_type number) return date;
220 
221 function getDebugProfile return varchar2;
222 
223 END MSC_GANTT_PKG;