[Home] [Help]
PACKAGE: APPS.MSC_GET_BIS_VALUES
Source
1 PACKAGE msc_get_bis_values AS
2 /* $Header: MSCBISUS.pls 120.1.12010000.2 2008/07/24 23:50:06 hulu ship $ */
3
4 FUNCTION late_orders(arg_plan_id IN NUMBER,
5 arg_instance_id IN NUMBER,
6 arg_organization_id IN NUMBER,
7 arg_start_date IN DATE,
8 arg_end_date IN DATE,
9 arg_inventory_item_Id IN NUMBER DEFAULT NULL,
10 arg_project_id IN NUMBER DEFAULT NULL,
11 arg_task_id IN NUMBER DEFAULT NULL,
12 arg_category_id IN NUMBER DEFAULT NULL,
13 arg_category_name IN VARCHAR2 DEFAULT NULL,
14 arg_category_set_id IN NUMBER DEFAULT NULL,
15 arg_product_family_id IN NUMBER DEFAULT NULL)
16 RETURN NUMBER;
17 /*satyagi ds enhancement :--------------------------------------------------------------------------------*/
18 FUNCTION get_actuals(p_plan_id IN NUMBER,
19 p_instance_id IN NUMBER,
20 p_organization_id IN NUMBER,
21 i IN NUMBER,
22 p_inventory_item_id IN NUMBER DEFAULT NULL,
23 p_project_id IN NUMBER DEFAULT NULL,
24 p_task_id IN NUMBER DEFAULT NULL,
25 p_dept_id IN NUMBER DEFAULT NULL,
26 p_res_id IN NUMBER DEFAULT NULL,
27 p_dept_class IN VARCHAR2 DEFAULT NULL,
28 p_res_group IN VARCHAR2 DEFAULT NULL,
29 p_category_id IN NUMBER DEFAULT NULL,
30 p_category_name IN VARCHAR2 DEFAULT NULL,
31 p_category_set_id IN NUMBER DEFAULT NULL,
32 p_product_family_id IN NUMBER DEFAULT NULL,
33 p_sup_id IN NUMBER DEFAULT NULL,
34 p_sup_site_id IN NUMBER DEFAULT NULL ,
35 p_res_instance_id IN NUMBER DEFAULT NULL ,
36 p_res_inst_serial_number IN varchar2 DEFAULT NULL) RETURN number;
37
38 /*-------------------------------------------------------------------------------satyagi ds enhancement */
39
40 FUNCTION check_periods(p_plan_id IN NUMBER) RETURN NUMBER;
41
42 PROCEDURE populate_plan_date(p_plan_id IN NUMBER);
43
44 PROCEDURE get_item_margin(p_plan_id IN NUMBER,
45 p_instance_id IN NUMBER,
46 p_organization_id IN NUMBER,
47 p_item_id IN NUMBER,
48 p_out1 OUT NOCOPY NUMBER,
49 p_out2 OUT NOCOPY NUMBER,
50 p_out3 OUT NOCOPY NUMBER);
51
52 PROCEDURE get_margin(p_plan_id IN NUMBER,
53 p_instance_id IN NUMBER,
54 p_organization_id IN NUMBER,
55 p_product_family_id IN number,
56 p_chart IN NUMBER,
57 p_out1 OUT NOCOPY NUMBER,
58 p_out2 OUT NOCOPY NUMBER,
59 p_out3 OUT NOCOPY NUMBER,
60 p_out4 OUT NOCOPY NUMBER,
61 p_out5 OUT NOCOPY NUMBER);
62
63 PROCEDURE get_item_margin_trend(p_plan_id IN NUMBER,
64 p_instance_id IN NUMBER,
65 p_organization_id IN NUMBER,
66 p_item_id IN NUMBER,
67 p_out1 OUT NOCOPY VARCHAR2,
68 p_out2 OUT NOCOPY VARCHAR2,
69 p_out3 OUT NOCOPY VARCHAR2);
70
71 PROCEDURE get_margin_trend(p_plan_id IN NUMBER,
72 p_instance_id IN NUMBER,
73 p_organization_id IN NUMBER,
74 p_product_family_id in number,
75 p_chart IN NUMBER,
76 p_out1 OUT NOCOPY VARCHAR2,
77 p_out2 OUT NOCOPY VARCHAR2,
78 p_out3 OUT NOCOPY VARCHAR2,
79 p_out4 OUT NOCOPY VARCHAR2,
80 p_out5 OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE get_margin_by_org(p_plan_id IN NUMBER,
84 p_row_count OUT NOCOPY NUMBER,
85 p_org OUT NOCOPY VARCHAR2,
86 p_margin OUT NOCOPY VARCHAR2);
87
88
89 PROCEDURE get_period_name(p_period_list OUT NOCOPY VARCHAR2,
90 p_period_count OUT NOCOPY NUMBER);
91
92 /*satyagi ds enhancement :--------------------------------------------------------------------------------*/
93 PROCEDURE get_trend_actuals(p_plan_id IN NUMBER,
94 p_instance_id IN NUMBER,
95 p_org_id IN NUMBER,
96 i IN NUMBER,
97 p_inventory_item_id IN NUMBER DEFAULT NULL,
98 p_project_id IN NUMBER DEFAULT NULL,
99 p_task_id IN NUMBER DEFAULT NULL,
100 p_dept_id IN NUMBER DEFAULT NULL,
101 p_res_id IN NUMBER DEFAULT NULL,
102 p_dept_class IN VARCHAR2 DEFAULT NULL,
103 p_res_group IN VARCHAR2 DEFAULT NULL,
104 p_category_id IN NUMBER DEFAULT NULL,
105 p_category_name IN VARCHAR2 DEFAULT NULL,
106 p_category_set_id IN NUMBER DEFAULT NULL,
107 p_product_family_id IN NUMBER DEFAULT NULL,
108 p_sup_id IN NUMBER DEFAULT NULL,
109 p_sup_site_id IN NUMBER DEFAULT NULL,
110 p_value_string OUT NOCOPY VARCHAR2 ,
111 p_res_instance_id IN NUMBER DEFAULT NULL,
112 p_res_inst_serial_number IN varchar2 DEFAULT NULL
113 );
114 /*-------------------------------------------------------------------------------satyagi ds enhancement :*/
115
116 FUNCTION get_targets(p_chart_type IN NUMBER, p_instance_id IN NUMBER,
117 p_org_id IN NUMBER,
118 p_time_level varchar2 DEFAULT NULL) RETURN NUMBER;
119
120 FUNCTION get_targets_trend(p_chart_type IN NUMBER, p_instance_id IN NUMBER,
121 p_org_id IN NUMBER) RETURN VARCHAR2;
122
123 -- PRAGMA RESTRICT_REFERENCES(get_actuals, WNDS, WNPS);
124 -- PRAGMA RESTRICT_REFERENCES(get_trend_actuals, WNDS, WNPS);
125 -- PRAGMA RESTRICT_REFERENCES (late_orders, WNDS, WNPS);
126
127 FUNCTION construct_res_where(p_organization_id number,
128 p_instance_id number,
129 p_dept_id number,
130 p_res_id number,
131 p_res_group varchar2,
132 p_dept_class varchar2,
133 p_start_date date default null,
134 p_end_date date default null) RETURN varchar2;
135
136 /*satyagi ds enhancement :--------------------------------------------------------------------------------*/
137
138 FUNCTION construct_res_instance_where(p_organization_id number,
139 p_instance_id number,
140 p_dept_id number,
141 p_res_id number,
142 p_res_group varchar2,
143 p_dept_class varchar2,
144 p_start_date date default null,
145 p_end_date date default null ,
146 p_res_instance_id number ,
147 p_res_inst_serial_number varchar2 ) RETURN varchar2 ;
148
149 /*-------------------------------------------------------------------------------satyagi ds enhancement :*/
150
151 FUNCTION construct_bis_where(p_date boolean,
152 p_organization_id number,
153 p_instance_id number,
154 p_inventory_item_id number,
155 p_project_id number,
156 p_task_id number,
157 p_category_id number,
158 p_category_name IN VARCHAR2 DEFAULT NULL,
159 p_category_set_id number,
160 p_product_family_id number,
161 p_start_date date default null,
162 p_end_date date default null) RETURN varchar2;
163 FUNCTION get_service_level(p_plan_id IN NUMBER,
164 p_instance_id IN NUMBER,
165 p_organization_id IN NUMBER,
166 p_item_id IN NUMBER,
167 p_start_date date default null,
168 p_end_date date default null,
169 p_use_old_demand_qty number default null ) RETURN NUMBER;
170 FUNCTION service_data_exist(p_plan_id IN NUMBER,
171 p_instance_id IN NUMBER,
172 p_organization_id IN NUMBER,
173 p_item_id IN NUMBER) RETURN BOOLEAN;
174 FUNCTION service_target(p_plan IN NUMBER, p_instance_id IN NUMBER,
175 p_org_id IN NUMBER, p_item_id IN NUMBER) RETURN NUMBER;
176 FUNCTION service_target_trend(p_plan_id IN NUMBER, p_instance_id IN NUMBER,
177 p_org_id IN NUMBER, p_item_id IN NUMBER) RETURN VARCHAR2;
178 FUNCTION get_inventory_value(p_plan_id IN NUMBER,
179 p_instance_id IN NUMBER,
180 p_organization_id IN NUMBER,
181 p_item_id IN NUMBER) return NUMBER;
182
183 FUNCTION inventory_value_trend(p_plan_id IN NUMBER,
184 p_instance_id IN NUMBER,
185 p_organization_id IN NUMBER,
186 p_item_id IN NUMBER
187 ) return VARCHAR2;
188
189 FUNCTION construct_sup_where(p_organization_id number,
190 p_instance_id number,
191 p_item_id number,
192 p_sup_id number,
193 p_sup_site_id number) RETURN varchar2;
194
195
196 --Procedure call_get_actuals;
197
198 Procedure refresh_data(errbuf OUT NOCOPY VARCHAR2,
199 retcode OUT NOCOPY NUMBER,
200 p_plan_id number,
201 p_plan_type number);
202
203 Procedure refresh_data(errbuf OUT NOCOPY VARCHAR2,
204 retcode OUT NOCOPY NUMBER,
205 p_plan_id number);
206
207 Function IsKPIAvail(p_plan_id number) return number;
208
209 PROCEDURE set_kpi_refresh_status(p_plan_id number,p_status varchar2);
210 Procedure refresh_kpi_data(p_plan_id number);
211
212 Procedure refresh_one_table(errbuf OUT NOCOPY VARCHAR2,
213 retcode OUT NOCOPY NUMBER,
214 p_plan_id number,
215 p_kpi_table number,
216 p_plan_type number);
217
218 Procedure ui_post_plan(errbuf OUT NOCOPY VARCHAR2,
219 retcode OUT NOCOPY NUMBER,
220 p_plan_id IN number);
221
222 FUNCTION get_tp_cost(p_plan_id IN NUMBER,
223 p_instance_id IN NUMBER,
224 p_organization_id IN NUMBER,
225 p_item_id IN NUMBER,
226 p_start_date date default null,
227 p_end_date date default null,
228 p_planner_code varchar2 default null) RETURN NUMBER;
229
230 FUNCTION get_target_service_level(p_plan_id IN NUMBER,
231 p_instance_id IN NUMBER,
232 p_organization_id IN NUMBER,
233 p_item_id IN NUMBER,
234 p_start_date date default null,
235 p_end_date date default null) RETURN NUMBER;
236 END msc_get_bis_values;