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.4 2006/03/19 20:52:17 mkimizuk noship $ */
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 182: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_CHG_APPR_STATUS

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

Line 216: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID

212:
213:
214: -- Adding event parameters to the list
215: WF_EVENT.AddParameterToList
216: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID
217: ,p_value => to_char(p_change_id)
218: ,p_parameterList => l_param_list
219: );
220:

Line 222: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE

218: ,p_parameterList => l_param_list
219: );
220:
221: WF_EVENT.AddParameterToList
222: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE
223: ,p_value => l_base_cm_code
224: ,p_parameterList => l_param_list
225: );
226:

Line 229: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACT_TYPE_CODE

225: );
226:
227:
228: WF_EVENT.AddParameterToList
229: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACT_TYPE_CODE
230: ,p_value => p_action_type
231: ,p_parameterList => l_param_list
232: );
233:

Line 235: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_ACTION_ID

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

Line 242: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_POST_COMMENT

238: );
239:
240: -- Raise event
241: WF_EVENT.RAISE
242: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_POST_COMMENT
243: ,p_event_key => p_change_id
244: ,p_parameters => l_param_list
245: );
246:

Line 276: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID

272:
273:
274: -- Adding event parameters to the list
275: WF_EVENT.AddParameterToList
276: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID
277: ,p_value => to_char(p_change_id)
278: ,p_parameterList => l_param_list
279: );
280:

Line 282: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE

278: ,p_parameterList => l_param_list
279: );
280:
281: WF_EVENT.AddParameterToList
282: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE
283: ,p_value => l_base_cm_code
284: ,p_parameterList => l_param_list
285: );
286:

Line 289: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_CREATE

285: );
286:
287: -- Raise event
288: WF_EVENT.RAISE
289: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_CREATE
290: ,p_event_key => p_change_id
291: ,p_parameters => l_param_list
292: );
293:

Line 322: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID

318: END IF ;
319:
320: -- Adding event parameters to the list
321: WF_EVENT.AddParameterToList
322: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_CHANGE_ID
323: ,p_value => to_char(p_change_id)
324: ,p_parameterList => l_param_list
325: );
326:

Line 328: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE

324: ,p_parameterList => l_param_list
325: );
326:
327: WF_EVENT.AddParameterToList
328: ( p_name => ENG_CHANGE_BES_UTIL.G_BES_PARAM_BASE_CM_TYPE_CODE
329: ,p_value => l_base_cm_code
330: ,p_parameterList => l_param_list
331: );
332:

Line 335: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_UPDATE

331: );
332:
333: -- Raise event
334: WF_EVENT.RAISE
335: ( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_UPDATE
336: ,p_event_key => p_change_id
337: ,p_parameters => l_param_list
338: );
339:

Line 349: END ENG_CHANGE_BES_UTIL;

345:
346: END Raise_Update_Change_Event ;
347:
348:
349: END ENG_CHANGE_BES_UTIL;
350: