[Home] [Help]
PACKAGE: APPS.WIP_WS_UTIL
Source
1 package wip_ws_util as
2 /* $Header: wipwsuts.pls 120.12.12010000.3 2008/09/16 21:40:04 awongwai 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 function get_instance_name
21 (
22 p_instance_name varchar2,
23 p_serial_number varchar2
24 ) return VARCHAR2;
25
26
27 function get_preference_value_code(
28 p_pref_id number,
29 p_resp_key varchar2,
30 p_org_id number,
31 p_dept_id number
32 ) return varchar2;
33
34 function get_preference_level_id(
35 p_pref_id number,
36 p_resp_key varchar2,
37 p_org_id number,
38 p_dept_id number
39 ) return number;
40
41 function get_preference_value_code(p_pref_id number, p_level_id number) return varchar2;
42
43 function get_jobop_name(p_job_name varchar2, p_op_seq number) return varchar2;
44
45 procedure retrieve_first_shift
46 (
47 p_org_id number,
48 p_dept_id number,
49 p_resource_id number,
50 p_date date,
51 x_shift_seq out nocopy number,
52 x_shift_num out nocopy number,
53 x_shift_start_date out nocopy date,
54 x_shift_end_date out nocopy date,
55 x_shift_string out nocopy varchar2
56 );
57
58 function get_component_avail(p_org_id number, p_component_id number) return number;
59
60 function get_employee_name(p_employee_id number, p_date date) return varchar2;
61
62 function get_appended_date(p_date date, p_time number) return date;
63
64 function get_next_date(p_date date) return date;
65
66 function get_next_work_date_by_calcode(p_calendar_code varchar2, p_date date) return date;
67
68 function get_next_work_date_by_org_id(p_org_id number, p_date date) return date;
69
70 function get_first_workday(p_org_id number, p_dept_id number, p_date date) return date;
71
72 function get_calendar_code(p_org_id number) return varchar2;
73
74 function get_shift_info_for_display(p_org_id number, p_shift_seq number, p_shift_num number) return varchar2;
75
76 function get_job_note_header(p_wip_entity_id number, p_op_seq number, p_employee_id number) return varchar2;
77
78 function get_employee_id(p_employee_number varchar2, p_org_id number) return number;
79
80 procedure clear_msg_stack;
81
82 function get_current_resp_key return varchar2;
83
84 procedure append_job_note(p_wip_entity_id number, p_msg varchar2,
85 p_init_msg_list IN VARCHAR2,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2);
89
90 procedure append_job_note(p_wip_entity_id number, p_clob_msg clob,
91 p_init_msg_list IN VARCHAR2,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2);
95
96 procedure append_exception_note(p_exception_id number, p_msg varchar2,
97 p_init_msg_list IN VARCHAR2,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2);
101
102 function get_projected_completion_date
103 (
104 p_organization_id number,
105 p_wip_entity_id number,
106 p_op_seq_num number,
107 p_resource_seq_num number,
108 p_resource_id number,
109 p_instance_id number,
110 p_start_date date
111 ) return date;
112
113 procedure set_legal_entity_ctx(
114 p_org_id number);
115
116 function get_instance_name(p_resource_id IN NUMBER,
117 p_instance_id IN NUMBER,
118 p_serial_number IN VARCHAR2) return VARCHAR2;
119
120 procedure init_timezone;
121
122 function get_page_title(p_oahp varchar2, p_oasf varchar2) return varchar2;
123
124 function get_multival_pref_seq(p_pref_id IN NUMBER,
125 p_level_id IN NUMBER,
126 p_attribute_name IN VARCHAR2,
127 p_attribute_val IN VARCHAR2) return NUMBER;
128
129 function get_multival_pref_val_code(p_pref_id IN NUMBER,
130 p_level_id IN NUMBER,
131 p_seq_num IN NUMBER,
132 p_attribute_name IN VARCHAR2) return VARCHAR2;
133
134 g_logLevel NUMBER:= fnd_log.g_current_runtime_level;
135 procedure log_time(p_msg IN VARCHAR2, p_date IN DATE DEFAULT SYSDATE);
136
137 FUNCTION get_lock_handle (
138 p_org_id IN NUMBER,
139 p_lock_prefix IN Varchar2) RETURN VARCHAR2;
140
141 PROCEDURE get_lock(
142 x_return_status OUT nocopy varchar2,
143 x_msg_count OUT nocopy number,
144 x_msg_data OUT nocopy varchar2,
145 x_lock_status OUT nocopy number,
146 p_org_id IN NUMBER,
147 p_lock_prefix IN Varchar2);
148
149 PROCEDURE release_lock(
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_org_id IN NUMBER,
154 p_lock_prefix IN varchar2);
155 PROCEDURE trace_log(p_msg IN VARCHAR2);
156
157 --functions for checking shortages in MES workorders tab in supervisor dashboard
158 FUNCTION check_comp_shortage(p_wip_entity_id IN NUMBER,
159 p_org_id IN NUMBER) RETURN NUMBER;
160
161 FUNCTION check_res_shortage(p_wip_entity_id IN NUMBER,
162 p_org_id IN NUMBER) RETURN NUMBER;
163
164 FUNCTION get_csh_calc_level(p_org_id Number) return NUMBER;
165
166
167 PROCEDURE log_for_duplicate_concurrent(
168 p_org_id in number,
169 p_program_name in varchar2);
170
171 FUNCTION get_no_of_running_concurrent(
172 p_program_application_id in number,
173 p_concurrent_program_id in number,
174 p_org_id in number) RETURN NUMBER;
175
176
177
178 end wip_ws_util;
179