[Home] [Help]
PACKAGE: APPS.WIP_WS_EMBEDDED_ANALYTICS_PK
Source
1 package WIP_WS_EMBEDDED_ANALYTICS_PK as
2 /* $Header: wipwseas.pls 120.5 2008/03/18 00:21:17 awongwai noship $ */
3
4 /*============================================================================+
5 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
6 | All rights reserved. |
7 | Oracle Manufacturing |
8 +=============================================================================+
9 |
10 | FILE NAME : WIPWSEAS.sql
11 | DESCRIPTION :
12 | This package contains specification for all APIs related to
13 MES First Pass Yield and Parts per Million Defects module
14 |
15 | HISTORY : created 10-DEC-07
16 | Nitikorn Tangjeerawong 10-DEC-2007 Creating Initial Version
17 |
18
19 *============================================================================*/
20
21 gUserId number;
22 gLoginId number;
23
24 g_logLevel NUMBER := FND_LOG.g_current_runtime_level;
25 g_user_id NUMBER := FND_GLOBAL.user_id;
26 g_login_id NUMBER := FND_GLOBAL.login_id;
27 g_prog_appid NUMBER := FND_PROFILE.value('RESP_APPL_ID');
28 g_prog_id NUMBER := FND_PROFILE.value('PROGRAM_ID');
29 g_prog_run_date DATE := sysdate;
30 g_request_id NUMBER := FND_PROFILE.value('REQUEST_ID');
31 g_init_obj_ver NUMBER := 1;
32
33 /* Package constants */
34
35 FUNCTION get_shift_info(
36 p_org_id IN NUMBER,
37 p_department_id IN NUMBER,
38 p_transaction_date IN DATE) RETURN NUMBER;
39
40 PROCEDURE populate_fpy_raw_data(
41 p_execution_date DATE,
42 p_cutoff_date DATE,
43 p_org_id NUMBER,
44 x_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE calc_fpy_per_jobop_day_shift(
47 p_execution_date DATE,
48 p_cutoff_date DATE,
49 p_org_id NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE calc_fpy_per_jobop_day(
53 p_execution_date DATE,
54 p_cutoff_date DATE,
55 p_org_id NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2);
57
58 PROCEDURE calc_fpy_per_jobop_week(
59 p_execution_date DATE,
60 p_cutoff_date DATE,
61 p_org_id NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2);
63
64
65
66 PROCEDURE calc_fpy_per_jobop_week_shift(
67 p_execution_date DATE,
68 p_cutoff_date DATE,
69 p_org_id NUMBER,
70 x_return_status OUT NOCOPY VARCHAR2);
71
72 PROCEDURE calc_fpy_per_job_day(
73 p_execution_date DATE,
74 p_cutoff_date DATE,
75 p_org_id NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2);
77
78 PROCEDURE calc_fpy_per_job_day_shift(
79 p_execution_date DATE,
80 p_cutoff_date DATE,
81 p_org_id NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2);
83
84 PROCEDURE calc_fpy_per_job_week(
85 p_execution_date DATE,
86 p_cutoff_date DATE,
87 p_org_id NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2);
89
90 PROCEDURE calc_fpy_per_job_week_shift(
91 p_execution_date DATE,
92 p_cutoff_date DATE,
93 p_org_id NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2);
95
96 PROCEDURE calc_fpy_per_dept_day_shift(
97 p_execution_date DATE,
98 p_cutoff_date DATE,
99 p_org_id NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2);
101
102 PROCEDURE calc_fpy_per_dept_day(
103 p_execution_date DATE,
104 p_cutoff_date DATE,
105 p_org_id NUMBER,
106 x_return_status OUT NOCOPY VARCHAR2);
107
108 PROCEDURE calc_fpy_per_dept_week_shift(
109 p_execution_date DATE,
110 p_cutoff_date DATE,
111 p_org_id NUMBER,
112 x_return_status OUT NOCOPY VARCHAR2);
113
114 PROCEDURE calc_fpy_per_dept_week(
115 p_execution_date DATE,
116 p_cutoff_date DATE,
117 p_org_id NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2);
119
120 PROCEDURE calc_fpy_all_depts_day_shift(
121 p_execution_date DATE,
122 p_cutoff_date DATE,
123 p_org_id NUMBER,
124 x_return_status OUT NOCOPY VARCHAR2);
125
126 PROCEDURE calc_fpy_all_depts_day(
127 p_execution_date DATE,
128 p_cutoff_date DATE,
129 p_org_id NUMBER,
130 x_return_status OUT NOCOPY VARCHAR2);
131
132 PROCEDURE calc_fpy_all_depts_week_shift(
133 p_execution_date DATE,
134 p_cutoff_date DATE,
135 p_org_id NUMBER,
136 x_return_status OUT NOCOPY VARCHAR2);
137
138 PROCEDURE calc_fpy_all_depts_week(
139 p_execution_date DATE,
140 p_cutoff_date DATE,
141 p_org_id NUMBER,
142 x_return_status OUT NOCOPY VARCHAR2);
143
144 PROCEDURE calc_fpy_per_assm_day_shift(
145 p_execution_date DATE,
146 p_cutoff_date DATE,
147 p_org_id NUMBER,
148 x_return_status OUT NOCOPY VARCHAR2);
149
150 PROCEDURE calc_fpy_per_assm_day(
151 p_execution_date DATE,
152 p_cutoff_date DATE,
153 p_org_id NUMBER,
154 x_return_status OUT NOCOPY VARCHAR2);
155
156 PROCEDURE calc_fpy_per_assm_week_shift(
157 p_execution_date DATE,
158 p_cutoff_date DATE,
159 p_org_id NUMBER,
160 x_return_status OUT NOCOPY VARCHAR2);
161
162 PROCEDURE calc_fpy_per_assm_week(
163 p_execution_date DATE,
164 p_cutoff_date DATE,
165 p_org_id NUMBER,
166 x_return_status OUT NOCOPY VARCHAR2);
167
168 ---------------------- Group call
169
170 PROCEDURE calc_fpy_for_jobop_all(
171 p_execution_date DATE,
172 p_cutoff_date DATE,
173 p_org_id NUMBER,
174 x_return_status OUT NOCOPY VARCHAR2);
175
176 PROCEDURE calc_fpy_for_job_all(
177 p_execution_date DATE,
178 p_cutoff_date DATE,
179 p_org_id NUMBER,
180 x_return_status OUT NOCOPY VARCHAR2);
181
182 PROCEDURE calc_fpy_for_assm_all(
183 p_execution_date DATE,
184 p_cutoff_date DATE,
185 p_org_id NUMBER,
186 x_return_status OUT NOCOPY VARCHAR2);
187
188 PROCEDURE calc_fpy_for_dept_all(
189 p_execution_date DATE,
190 p_cutoff_date DATE,
191 p_org_id NUMBER,
192 x_return_status OUT NOCOPY VARCHAR2);
193
194 PROCEDURE calc_fpy_for_all_depts_all(
195 p_execution_date DATE,
196 p_cutoff_date DATE,
197 p_org_id NUMBER,
198 x_return_status OUT NOCOPY VARCHAR2);
199
200 FUNCTION get_start_shift_date_to_calc(p_org_id IN NUMBER,
201 p_department_id IN NUMBER,
202 p_execution_date IN DATE) return DATE;
203
204 PROCEDURE delete_old_and_replacing_data(
205 p_calc_start_date IN DATE,
206 p_retention_boundary IN DATE,
207 p_org_id IN NUMBER,
208 x_return_status OUT NOCOPY VARCHAR2);
209
210 PROCEDURE wip_ws_fpykpi_conc_prog(
211 errbuf out nocopy varchar2,
212 retcode out nocopy varchar2,
213 p_org_id in number);
214
215 PROCEDURE wip_ws_ppmdkpi_conc_prog(
216 errbuf out nocopy varchar2,
217 retcode out nocopy varchar2,
218 p_org_id in number);
219
220 FUNCTION get_shift_info_for_date (
221 p_org_id in number,
222 p_dept_id in number,
223 p_resource_id in number,
224 p_date in date
225 ) return varchar2;
226
227 FUNCTION get_shift_seq(p_shift_info VARCHAR2) RETURN VARCHAR2;
228
229 FUNCTION get_shift_num(p_shift_info VARCHAR2) RETURN NUMBER;
230
231 FUNCTION get_shift_start_date(p_shift_info VARCHAR2) RETURN DATE;
232
233 PROCEDURE populate_ppm_defects_data(
234 p_start_date DATE,
235 p_org_id NUMBER,
236 x_return_status OUT NOCOPY VARCHAR2);
237
238
239
240
241
242 END WIP_WS_EMBEDDED_ANALYTICS_PK;