DBA Data[Home] [Help]

APPS.ENG_CHANGE_BES_UTIL dependencies on ENG_CHANGE_BES_UTIL

Line 1: PACKAGE BODY ENG_CHANGE_BES_UTIL AS

1: PACKAGE BODY ENG_CHANGE_BES_UTIL AS
2: /* $Header: ENGUBESB.pls 120.6 2011/06/01 07:35:57 evwang ship $ */
3:
4: -- ---------------------------------------------------------------------------
5: -- Global variables and constants

Line 7: G_PKG_NAME VARCHAR2(30) := 'ENG_CHANGE_BES_UTIL';

3:
4: -- ---------------------------------------------------------------------------
5: -- Global variables and constants
6: -- ---------------------------------------------------------------------------
7: G_PKG_NAME VARCHAR2(30) := 'ENG_CHANGE_BES_UTIL';
8:
9:
10:
11: /********************************************************************

Line 95: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID

91: END IF ;
92:
93: -- Adding event parameters to the list
94: WF_EVENT.AddParameterToList
95: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID
96: ,p_value => to_char(p_change_id)
97: ,p_parameterList => l_param_list
98: );
99:

Line 101: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE

97: ,p_parameterList => l_param_list
98: );
99:
100: WF_EVENT.AddParameterToList
101: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE
102: ,p_value => l_base_cm_code
103: ,p_parameterList => l_param_list
104: );
105:

Line 107: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_STATUS_CODE

103: ,p_parameterList => l_param_list
104: );
105:
106: WF_EVENT.AddParameterToList
107: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_STATUS_CODE
108: ,p_value => to_char(p_status_code)
109: ,p_parameterList => l_param_list
110: );
111:

Line 113: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACT_TYPE_CODE

109: ,p_parameterList => l_param_list
110: );
111:
112: WF_EVENT.AddParameterToList
113: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACT_TYPE_CODE
114: ,p_value => p_action_type
115: ,p_parameterList => l_param_list
116: );
117:

Line 120: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACTION_ID

116: );
117:
118:
119: WF_EVENT.AddParameterToList
120: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACTION_ID
121: ,p_value => to_char(p_action_id)
122: ,p_parameterList => l_param_list
123: );
124:

Line 127: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_CHG_STATUS

123: );
124:
125: -- Raise event
126: WF_EVENT.RAISE
127: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_CHG_STATUS
128: ,p_event_key => p_change_id
129: ,p_parameters => l_param_list
130: );
131: l_param_list.DELETE;

Line 160: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID

156: END IF ;
157:
158:
159: WF_EVENT.AddParameterToList
160: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID
161: ,p_value => to_char(p_change_id)
162: ,p_parameterList => l_param_list
163: );
164: WF_EVENT.AddParameterToList

Line 165: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE

161: ,p_value => to_char(p_change_id)
162: ,p_parameterList => l_param_list
163: );
164: WF_EVENT.AddParameterToList
165: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE
166: ,p_value => l_base_cm_code
167: ,p_parameterList => l_param_list
168: );
169: WF_EVENT.AddParameterToList

Line 170: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_NEW_APPR_STS_CODE

166: ,p_value => l_base_cm_code
167: ,p_parameterList => l_param_list
168: );
169: WF_EVENT.AddParameterToList
170: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_NEW_APPR_STS_CODE
171: ,p_value => p_appr_status
172: ,p_parameterList => l_param_list
173: );
174: WF_EVENT.AddParameterToList

Line 175: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_WF_STATUS_CODE

171: ,p_value => p_appr_status
172: ,p_parameterList => l_param_list
173: );
174: WF_EVENT.AddParameterToList
175: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_WF_STATUS_CODE
176: ,p_value => p_wf_route_status
177: ,p_parameterList => l_param_list
178: );
179:

Line 183: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_CHG_APPR_STATUS

179:
180: BEGIN
181: -- Raise event
182: WF_EVENT.RAISE
183: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_CHG_APPR_STATUS
184: ,p_event_key => p_change_id
185: ,p_parameters => l_param_list
186: );
187: l_param_list.DELETE;

Line 229: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID

225:
226:
227: -- Adding event parameters to the list
228: WF_EVENT.AddParameterToList
229: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID
230: ,p_value => to_char(p_change_id)
231: ,p_parameterList => l_param_list
232: );
233:

Line 235: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE

231: ,p_parameterList => l_param_list
232: );
233:
234: WF_EVENT.AddParameterToList
235: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE
236: ,p_value => l_base_cm_code
237: ,p_parameterList => l_param_list
238: );
239:

Line 242: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACT_TYPE_CODE

238: );
239:
240:
241: WF_EVENT.AddParameterToList
242: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACT_TYPE_CODE
243: ,p_value => p_action_type
244: ,p_parameterList => l_param_list
245: );
246:

Line 248: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACTION_ID

244: ,p_parameterList => l_param_list
245: );
246:
247: WF_EVENT.AddParameterToList
248: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACTION_ID
249: ,p_value => to_char(p_action_id)
250: ,p_parameterList => l_param_list
251: );
252:

Line 255: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_POST_COMMENT

251: );
252:
253: -- Raise event
254: WF_EVENT.RAISE
255: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_POST_COMMENT
256: ,p_event_key => p_change_id
257: ,p_parameters => l_param_list
258: );
259:

Line 289: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID

285:
286:
287: -- Adding event parameters to the list
288: WF_EVENT.AddParameterToList
289: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID
290: ,p_value => to_char(p_change_id)
291: ,p_parameterList => l_param_list
292: );
293:

Line 295: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE

291: ,p_parameterList => l_param_list
292: );
293:
294: WF_EVENT.AddParameterToList
295: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE
296: ,p_value => l_base_cm_code
297: ,p_parameterList => l_param_list
298: );
299:

Line 302: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_CREATE

298: );
299:
300: -- Raise event
301: WF_EVENT.RAISE
302: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_CREATE
303: ,p_event_key => p_change_id
304: ,p_parameters => l_param_list
305: );
306:

Line 335: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID

331: END IF ;
332:
333: -- Adding event parameters to the list
334: WF_EVENT.AddParameterToList
335: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID
336: ,p_value => to_char(p_change_id)
337: ,p_parameterList => l_param_list
338: );
339:

Line 341: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE

337: ,p_parameterList => l_param_list
338: );
339:
340: WF_EVENT.AddParameterToList
341: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE
342: ,p_value => l_base_cm_code
343: ,p_parameterList => l_param_list
344: );
345:

Line 348: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_UPDATE

344: );
345:
346: -- Raise event
347: WF_EVENT.RAISE
348: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_UPDATE
349: ,p_event_key => p_change_id
350: ,p_parameters => l_param_list
351: );
352:

Line 362: END ENG_CHANGE_BES_UTIL;

358:
359: END Raise_Update_Change_Event ;
360:
361:
362: END ENG_CHANGE_BES_UTIL;
363: