[Home] [Help]
PACKAGE: APPS.WIP_WS_UTIL
Source
1 package wip_ws_util AUTHID CURRENT_USER as
2 /* $Header: wipwsuts.pls 120.15.12020000.4 2012/12/25 00:43:54 hliew ship $ */
3
4 g_timezone_enabled BOOLEAN := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
5 fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
6 fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
7 fnd_profile.value('CLIENT_TIMEZONE_ID') <>
8 fnd_profile.value('SERVER_TIMEZONE_ID'));
9
10 g_client_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
11 g_server_id NUMBER := fnd_profile.value('SERVER_TIMEZONE_ID');
12
13 --start constants for bugfix 6755623
14 g_pref_id_comp_short NUMBER := 33;
15 g_pref_level_id_site NUMBER := 1;
16 g_pref_val_mast_org_att VARCHAR2(30) := 'masterorg';
17 g_pref_val_calclevel_att VARCHAR2(30) := 'calclevel';
18 --end constants for bugfix 6755623
19
20
21 g_pref_id_attachment Number := 2;
22
23 g_att_src_discrete_job Number := 1;
24 g_att_src_job_operation Number := 2;
25 g_att_src_assembly_item Number := 3;
26 g_att_src_bill_header Number := 4;
27 g_att_src_rtg_header Number := 5;
28 g_att_src_bill_comps Number := 6;
29 g_att_src_so_header Number := 7;
30 g_att_src_so_line Number := 8;
31
32 function get_instance_name
33 (
34 p_instance_name varchar2,
35 p_serial_number varchar2
36 ) return VARCHAR2;
37
38
39 function get_preference_value_code(
40 p_pref_id number,
41 p_resp_key varchar2,
42 p_org_id number,
43 p_dept_id number
44 ) return varchar2;
45
46 function get_preference_level_id(
47 p_pref_id number,
48 p_resp_key varchar2,
49 p_org_id number,
50 p_dept_id number
51 ) return number;
52
53 function get_preference_value_code(p_pref_id number, p_level_id number) return varchar2;
54
55 function get_jobop_name(p_job_name varchar2, p_op_seq number) return varchar2;
56
57 procedure retrieve_first_shift
58 (
59 p_org_id number,
60 p_dept_id number,
61 p_resource_id number,
62 p_date date,
63 x_shift_seq out nocopy number,
64 x_shift_num out nocopy number,
65 x_shift_start_date out nocopy date,
66 x_shift_end_date out nocopy date,
67 x_shift_string out nocopy varchar2
68 );
69
70 function get_component_avail(p_org_id number, p_component_id number) return number;
71
72 function get_employee_name(p_employee_id number, p_date date) return varchar2;
73
74 function get_appended_date(p_date date, p_time number) return date;
75
76 function get_next_date(p_date date) return date;
77
78 function get_next_work_date_by_calcode(p_calendar_code varchar2, p_date date) return date;
79
80 function get_next_work_date_by_org_id(p_org_id number, p_date date) return date;
81
82 function get_first_workday(p_org_id number, p_dept_id number, p_date date) return date;
83
84 function get_calendar_code(p_org_id number) return varchar2;
85
86 function get_shift_info_for_display(p_org_id number, p_shift_seq number, p_shift_num number) return varchar2;
87
88 function get_job_note_header(p_wip_entity_id number, p_op_seq number, p_employee_id number) return varchar2;
89
90 function get_employee_id(p_employee_number varchar2,
91 p_org_id number) return number;
92
93 procedure clear_msg_stack;
94
95 function get_current_resp_key return varchar2;
96
97 procedure append_job_note(p_wip_entity_id number, p_msg varchar2,
98 p_init_msg_list IN VARCHAR2,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2);
102
103 procedure append_job_note(p_wip_entity_id number, p_clob_msg clob,
104 p_init_msg_list IN VARCHAR2,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2);
108
109 procedure append_exception_note(p_exception_id number, p_msg varchar2,
110 p_init_msg_list IN VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2);
114
115 function get_projected_completion_date
116 (
117 p_organization_id number,
118 p_wip_entity_id number,
119 p_op_seq_num number,
120 p_resource_seq_num number,
121 p_resource_id number,
122 p_instance_id number,
123 p_start_date date
124 ) return date;
125
126 procedure set_legal_entity_ctx(
127 p_org_id number);
128
129 function get_instance_name(p_resource_id IN NUMBER,
130 p_instance_id IN NUMBER,
131 p_serial_number IN VARCHAR2) return VARCHAR2;
132
133 procedure init_timezone;
134
135 function get_page_title(p_oahp varchar2, p_oasf varchar2) return varchar2;
136
137 function get_multival_pref_seq(p_pref_id IN NUMBER,
138 p_level_id IN NUMBER,
139 p_attribute_name IN VARCHAR2,
140 p_attribute_val IN VARCHAR2) return NUMBER;
141
142 function get_multival_pref_val_code(p_pref_id IN NUMBER,
143 p_level_id IN NUMBER,
144 p_seq_num IN NUMBER,
145 p_attribute_name IN VARCHAR2) return VARCHAR2;
146
147 g_logLevel NUMBER:= fnd_log.g_current_runtime_level;
148 procedure log_time(p_msg IN VARCHAR2, p_date IN DATE DEFAULT SYSDATE);
149
150 FUNCTION get_lock_handle (
151 p_org_id IN NUMBER,
152 p_lock_prefix IN Varchar2) RETURN VARCHAR2;
153
154 PROCEDURE get_lock(
155 x_return_status OUT nocopy varchar2,
156 x_msg_count OUT nocopy number,
157 x_msg_data OUT nocopy varchar2,
158 x_lock_status OUT nocopy number,
159 p_org_id IN NUMBER,
160 p_lock_prefix IN Varchar2);
161
162 PROCEDURE release_lock(
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_org_id IN NUMBER,
167 p_lock_prefix IN varchar2);
168 PROCEDURE trace_log(p_msg IN VARCHAR2);
169
170 --functions for checking shortages in MES workorders tab in supervisor dashboard
171 FUNCTION check_comp_shortage(p_wip_entity_id IN NUMBER,
172 p_org_id IN NUMBER) RETURN NUMBER;
173
174 FUNCTION check_res_shortage(p_wip_entity_id IN NUMBER,
175 p_org_id IN NUMBER) RETURN NUMBER;
176
177 FUNCTION get_csh_calc_level(p_org_id Number) return NUMBER;
178
179
180 PROCEDURE log_for_duplicate_concurrent(
181 p_org_id in number,
182 p_program_name in varchar2);
183
184 FUNCTION get_no_of_running_concurrent(
185 p_program_application_id in number,
186 p_concurrent_program_id in number,
187 p_org_id in number) RETURN NUMBER;
188
189
190 function check_attachment_exists(p_org_id in number,
191 p_job_id in number,
192 p_op_seq in number,
193 p_dep_id in number)
194 return number;
195
196 /*ER 12961989, Arrow Enhancement*/
197 function get_shift_info( p_emp_id in number,
198 p_org_id in number)
199 return varchar2;
200
201 function get_clock_info(p_emp_id in number,
202 p_org_id in number)
203 return varchar2;
204
205 function get_assy_serial_issue_qty(p_org_id in number,
206 p_job_id in number,
207 p_op_seq in number,
208 p_assy_item_id in number,
209 p_assy_serial in varchar2,
210 p_comp_item_id in number)
211 return number;
212
213 function get_assy_serial_issue_qty(p_org_id in number,
214 p_job_id in number,
215 p_op_seq in number,
216 p_assy_item_id in number,
217 p_assy_serial in varchar2,
218 p_comp_item_id in number,
219 p_comp_code in number)
220 return number;
221
222 end wip_ws_util;
223