1: PACKAGE BODY jtf_rs_wf_events_pub AS
2: /* $Header: jtfrswpb.pls 120.0 2005/05/11 08:23:27 appldev ship $ */
3:
4: /*****************************************************************************************
5: ******************************************************************************************/
5: ******************************************************************************************/
6:
7: /* Package variables. */
8:
9: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_WF_EVENTS_PUB';
10:
11: FUNCTION item_key(p_event_name IN VARCHAR2) RETURN VARCHAR2
12: /* Return Item_Key according to Resource Event to be raised
13: Item_Key is
9: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_WF_EVENTS_PUB';
10:
11: FUNCTION item_key(p_event_name IN VARCHAR2) RETURN VARCHAR2
12: /* Return Item_Key according to Resource Event to be raised
13: Item_Key is
15: l_key varchar2(240);
16: BEGIN
17: SELECT p_event_name ||'-'|| jtf_rs_wf_event_guid_s.nextval INTO l_key FROM DUAL;
13: Item_Key is
14: IS
15: l_key varchar2(240);
16: BEGIN
17: SELECT p_event_name ||'-'|| jtf_rs_wf_event_guid_s.nextval INTO l_key FROM DUAL;
18: RETURN l_key;
19: END item_key;
20:
21: PROCEDURE create_resource
67: l_key := item_key(l_event_name);
68:
69: -- initialization of object variables
70:
71: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
72: wf_event.AddParameterToList('RESOURCE_NAME',l_resource_name,l_list);
73: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
74: wf_event.AddParameterToList('USER_ID',l_user_id,l_list);
75: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
68:
69: -- initialization of object variables
70:
71: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
72: wf_event.AddParameterToList('RESOURCE_NAME',l_resource_name,l_list);
73: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
74: wf_event.AddParameterToList('USER_ID',l_user_id,l_list);
75: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
76: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
69: -- initialization of object variables
70:
71: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
72: wf_event.AddParameterToList('RESOURCE_NAME',l_resource_name,l_list);
73: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
74: wf_event.AddParameterToList('USER_ID',l_user_id,l_list);
75: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
76: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
77:
70:
71: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
72: wf_event.AddParameterToList('RESOURCE_NAME',l_resource_name,l_list);
73: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
74: wf_event.AddParameterToList('USER_ID',l_user_id,l_list);
75: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
76: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
77:
78: -- Raise Event
71: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
72: wf_event.AddParameterToList('RESOURCE_NAME',l_resource_name,l_list);
73: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
74: wf_event.AddParameterToList('USER_ID',l_user_id,l_list);
75: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
76: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
77:
78: -- Raise Event
79: wf_event.raise(
72: wf_event.AddParameterToList('RESOURCE_NAME',l_resource_name,l_list);
73: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
74: wf_event.AddParameterToList('USER_ID',l_user_id,l_list);
75: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
76: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
77:
78: -- Raise Event
79: wf_event.raise(
80: p_event_name => l_event_name
75: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
76: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
77:
78: -- Raise Event
79: wf_event.raise(
80: p_event_name => l_event_name
81: ,p_event_key => l_key
82: ,p_parameters => l_list
83: );
132: l_key := item_key(l_event_name);
133:
134: -- initialization of object variables
135:
136: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
137: wf_event.AddParameterToList('REPLACEMENT_RESOURCE_ID',l_repl_resource_id,l_list);
138: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
139:
140: -- Raise Event
133:
134: -- initialization of object variables
135:
136: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
137: wf_event.AddParameterToList('REPLACEMENT_RESOURCE_ID',l_repl_resource_id,l_list);
138: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
139:
140: -- Raise Event
141: wf_event.raise(
134: -- initialization of object variables
135:
136: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
137: wf_event.AddParameterToList('REPLACEMENT_RESOURCE_ID',l_repl_resource_id,l_list);
138: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
139:
140: -- Raise Event
141: wf_event.raise(
142: p_event_name => l_event_name
137: wf_event.AddParameterToList('REPLACEMENT_RESOURCE_ID',l_repl_resource_id,l_list);
138: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
139:
140: -- Raise Event
141: wf_event.raise(
142: p_event_name => l_event_name
143: ,p_event_key => l_key
144: ,p_parameters => l_list
145: );
247: l_key := item_key(l_event_name);
248:
249: -- initialization of object variables
250:
251: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
252: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
253: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
254: wf_event.AddParameterToList('OLD_USER_ID',res_rec.user_id,l_list);
255: wf_event.AddParameterToList('NEW_USER_ID',l_new_user_id,l_list);
248:
249: -- initialization of object variables
250:
251: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
252: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
253: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
254: wf_event.AddParameterToList('OLD_USER_ID',res_rec.user_id,l_list);
255: wf_event.AddParameterToList('NEW_USER_ID',l_new_user_id,l_list);
256:
249: -- initialization of object variables
250:
251: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
252: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
253: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
254: wf_event.AddParameterToList('OLD_USER_ID',res_rec.user_id,l_list);
255: wf_event.AddParameterToList('NEW_USER_ID',l_new_user_id,l_list);
256:
257: -- Raise Event
250:
251: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
252: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
253: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
254: wf_event.AddParameterToList('OLD_USER_ID',res_rec.user_id,l_list);
255: wf_event.AddParameterToList('NEW_USER_ID',l_new_user_id,l_list);
256:
257: -- Raise Event
258: wf_event.raise(
251: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
252: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
253: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
254: wf_event.AddParameterToList('OLD_USER_ID',res_rec.user_id,l_list);
255: wf_event.AddParameterToList('NEW_USER_ID',l_new_user_id,l_list);
256:
257: -- Raise Event
258: wf_event.raise(
259: p_event_name => l_event_name
254: wf_event.AddParameterToList('OLD_USER_ID',res_rec.user_id,l_list);
255: wf_event.AddParameterToList('NEW_USER_ID',l_new_user_id,l_list);
256:
257: -- Raise Event
258: wf_event.raise(
259: p_event_name => l_event_name
260: ,p_event_key => l_key
261: ,p_parameters => l_list
262: );
278: l_key := item_key(l_event_name);
279:
280: -- initialization of object variables
281:
282: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
283: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
284: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
285: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rec.start_date_active,l_list);
286: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
279:
280: -- initialization of object variables
281:
282: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
283: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
284: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
285: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rec.start_date_active,l_list);
286: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
287: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rec.end_date_active,l_list);
280: -- initialization of object variables
281:
282: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
283: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
284: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
285: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rec.start_date_active,l_list);
286: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
287: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rec.end_date_active,l_list);
288: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
281:
282: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
283: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
284: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
285: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rec.start_date_active,l_list);
286: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
287: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rec.end_date_active,l_list);
288: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
289:
282: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
283: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
284: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
285: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rec.start_date_active,l_list);
286: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
287: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rec.end_date_active,l_list);
288: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
289:
290: -- Raise Event
283: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
284: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
285: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rec.start_date_active,l_list);
286: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
287: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rec.end_date_active,l_list);
288: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
289:
290: -- Raise Event
291: wf_event.raise(
284: wf_event.AddParameterToList('RESOURCE_NAME',l_new_resource_name,l_list);
285: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rec.start_date_active,l_list);
286: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
287: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rec.end_date_active,l_list);
288: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
289:
290: -- Raise Event
291: wf_event.raise(
292: p_event_name => l_event_name
287: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rec.end_date_active,l_list);
288: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
289:
290: -- Raise Event
291: wf_event.raise(
292: p_event_name => l_event_name
293: ,p_event_key => l_key
294: ,p_parameters => l_list
295: );
356: l_key := item_key(l_event_name);
357:
358: -- initialization of object variables
359:
360: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
361: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
362: wf_event.AddParameterToList('OLD_RESOURCE_NAME',res_rec.resource_name,l_list);
363: wf_event.AddParameterToList('NEW_RESOURCE_NAME',l_new_resource_name,l_list);
364: wf_event.AddParameterToList('OLD_TIME_ZONE',res_rec.time_zone,l_list);
357:
358: -- initialization of object variables
359:
360: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
361: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
362: wf_event.AddParameterToList('OLD_RESOURCE_NAME',res_rec.resource_name,l_list);
363: wf_event.AddParameterToList('NEW_RESOURCE_NAME',l_new_resource_name,l_list);
364: wf_event.AddParameterToList('OLD_TIME_ZONE',res_rec.time_zone,l_list);
365: wf_event.AddParameterToList('NEW_TIME_ZONE',l_new_time_zone,l_list);
358: -- initialization of object variables
359:
360: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
361: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
362: wf_event.AddParameterToList('OLD_RESOURCE_NAME',res_rec.resource_name,l_list);
363: wf_event.AddParameterToList('NEW_RESOURCE_NAME',l_new_resource_name,l_list);
364: wf_event.AddParameterToList('OLD_TIME_ZONE',res_rec.time_zone,l_list);
365: wf_event.AddParameterToList('NEW_TIME_ZONE',l_new_time_zone,l_list);
366: wf_event.AddParameterToList('OLD_COST_PER_HR',res_rec.cost_per_hr,l_list);
359:
360: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
361: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
362: wf_event.AddParameterToList('OLD_RESOURCE_NAME',res_rec.resource_name,l_list);
363: wf_event.AddParameterToList('NEW_RESOURCE_NAME',l_new_resource_name,l_list);
364: wf_event.AddParameterToList('OLD_TIME_ZONE',res_rec.time_zone,l_list);
365: wf_event.AddParameterToList('NEW_TIME_ZONE',l_new_time_zone,l_list);
366: wf_event.AddParameterToList('OLD_COST_PER_HR',res_rec.cost_per_hr,l_list);
367: wf_event.AddParameterToList('NEW_COST_PER_HR',l_new_cost_per_hr,l_list);
360: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
361: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
362: wf_event.AddParameterToList('OLD_RESOURCE_NAME',res_rec.resource_name,l_list);
363: wf_event.AddParameterToList('NEW_RESOURCE_NAME',l_new_resource_name,l_list);
364: wf_event.AddParameterToList('OLD_TIME_ZONE',res_rec.time_zone,l_list);
365: wf_event.AddParameterToList('NEW_TIME_ZONE',l_new_time_zone,l_list);
366: wf_event.AddParameterToList('OLD_COST_PER_HR',res_rec.cost_per_hr,l_list);
367: wf_event.AddParameterToList('NEW_COST_PER_HR',l_new_cost_per_hr,l_list);
368: wf_event.AddParameterToList('OLD_PRIMARY_LANGUAGE',res_rec.primary_language,l_list);
361: wf_event.AddParameterToList('CATEGORY',l_category,l_list);
362: wf_event.AddParameterToList('OLD_RESOURCE_NAME',res_rec.resource_name,l_list);
363: wf_event.AddParameterToList('NEW_RESOURCE_NAME',l_new_resource_name,l_list);
364: wf_event.AddParameterToList('OLD_TIME_ZONE',res_rec.time_zone,l_list);
365: wf_event.AddParameterToList('NEW_TIME_ZONE',l_new_time_zone,l_list);
366: wf_event.AddParameterToList('OLD_COST_PER_HR',res_rec.cost_per_hr,l_list);
367: wf_event.AddParameterToList('NEW_COST_PER_HR',l_new_cost_per_hr,l_list);
368: wf_event.AddParameterToList('OLD_PRIMARY_LANGUAGE',res_rec.primary_language,l_list);
369: wf_event.AddParameterToList('NEW_PRIMARY_LANGUAGE',l_new_primary_language,l_list);
362: wf_event.AddParameterToList('OLD_RESOURCE_NAME',res_rec.resource_name,l_list);
363: wf_event.AddParameterToList('NEW_RESOURCE_NAME',l_new_resource_name,l_list);
364: wf_event.AddParameterToList('OLD_TIME_ZONE',res_rec.time_zone,l_list);
365: wf_event.AddParameterToList('NEW_TIME_ZONE',l_new_time_zone,l_list);
366: wf_event.AddParameterToList('OLD_COST_PER_HR',res_rec.cost_per_hr,l_list);
367: wf_event.AddParameterToList('NEW_COST_PER_HR',l_new_cost_per_hr,l_list);
368: wf_event.AddParameterToList('OLD_PRIMARY_LANGUAGE',res_rec.primary_language,l_list);
369: wf_event.AddParameterToList('NEW_PRIMARY_LANGUAGE',l_new_primary_language,l_list);
370: wf_event.AddParameterToList('OLD_SECONDARY_LANGUAGE',res_rec.secondary_language,l_list);
363: wf_event.AddParameterToList('NEW_RESOURCE_NAME',l_new_resource_name,l_list);
364: wf_event.AddParameterToList('OLD_TIME_ZONE',res_rec.time_zone,l_list);
365: wf_event.AddParameterToList('NEW_TIME_ZONE',l_new_time_zone,l_list);
366: wf_event.AddParameterToList('OLD_COST_PER_HR',res_rec.cost_per_hr,l_list);
367: wf_event.AddParameterToList('NEW_COST_PER_HR',l_new_cost_per_hr,l_list);
368: wf_event.AddParameterToList('OLD_PRIMARY_LANGUAGE',res_rec.primary_language,l_list);
369: wf_event.AddParameterToList('NEW_PRIMARY_LANGUAGE',l_new_primary_language,l_list);
370: wf_event.AddParameterToList('OLD_SECONDARY_LANGUAGE',res_rec.secondary_language,l_list);
371: wf_event.AddParameterToList('NEW_SECONDARY_LANGUAGE',l_new_secondary_language,l_list);
364: wf_event.AddParameterToList('OLD_TIME_ZONE',res_rec.time_zone,l_list);
365: wf_event.AddParameterToList('NEW_TIME_ZONE',l_new_time_zone,l_list);
366: wf_event.AddParameterToList('OLD_COST_PER_HR',res_rec.cost_per_hr,l_list);
367: wf_event.AddParameterToList('NEW_COST_PER_HR',l_new_cost_per_hr,l_list);
368: wf_event.AddParameterToList('OLD_PRIMARY_LANGUAGE',res_rec.primary_language,l_list);
369: wf_event.AddParameterToList('NEW_PRIMARY_LANGUAGE',l_new_primary_language,l_list);
370: wf_event.AddParameterToList('OLD_SECONDARY_LANGUAGE',res_rec.secondary_language,l_list);
371: wf_event.AddParameterToList('NEW_SECONDARY_LANGUAGE',l_new_secondary_language,l_list);
372: wf_event.AddParameterToList('OLD_IES_AGENT_LOGIN',res_rec.ies_agent_login,l_list);
365: wf_event.AddParameterToList('NEW_TIME_ZONE',l_new_time_zone,l_list);
366: wf_event.AddParameterToList('OLD_COST_PER_HR',res_rec.cost_per_hr,l_list);
367: wf_event.AddParameterToList('NEW_COST_PER_HR',l_new_cost_per_hr,l_list);
368: wf_event.AddParameterToList('OLD_PRIMARY_LANGUAGE',res_rec.primary_language,l_list);
369: wf_event.AddParameterToList('NEW_PRIMARY_LANGUAGE',l_new_primary_language,l_list);
370: wf_event.AddParameterToList('OLD_SECONDARY_LANGUAGE',res_rec.secondary_language,l_list);
371: wf_event.AddParameterToList('NEW_SECONDARY_LANGUAGE',l_new_secondary_language,l_list);
372: wf_event.AddParameterToList('OLD_IES_AGENT_LOGIN',res_rec.ies_agent_login,l_list);
373: wf_event.AddParameterToList('NEW_IES_AGENT_LOGIN',l_new_ies_agent_login,l_list);
366: wf_event.AddParameterToList('OLD_COST_PER_HR',res_rec.cost_per_hr,l_list);
367: wf_event.AddParameterToList('NEW_COST_PER_HR',l_new_cost_per_hr,l_list);
368: wf_event.AddParameterToList('OLD_PRIMARY_LANGUAGE',res_rec.primary_language,l_list);
369: wf_event.AddParameterToList('NEW_PRIMARY_LANGUAGE',l_new_primary_language,l_list);
370: wf_event.AddParameterToList('OLD_SECONDARY_LANGUAGE',res_rec.secondary_language,l_list);
371: wf_event.AddParameterToList('NEW_SECONDARY_LANGUAGE',l_new_secondary_language,l_list);
372: wf_event.AddParameterToList('OLD_IES_AGENT_LOGIN',res_rec.ies_agent_login,l_list);
373: wf_event.AddParameterToList('NEW_IES_AGENT_LOGIN',l_new_ies_agent_login,l_list);
374: wf_event.AddParameterToList('OLD_SERVER_GROUP_ID',res_rec.server_group_id,l_list);
367: wf_event.AddParameterToList('NEW_COST_PER_HR',l_new_cost_per_hr,l_list);
368: wf_event.AddParameterToList('OLD_PRIMARY_LANGUAGE',res_rec.primary_language,l_list);
369: wf_event.AddParameterToList('NEW_PRIMARY_LANGUAGE',l_new_primary_language,l_list);
370: wf_event.AddParameterToList('OLD_SECONDARY_LANGUAGE',res_rec.secondary_language,l_list);
371: wf_event.AddParameterToList('NEW_SECONDARY_LANGUAGE',l_new_secondary_language,l_list);
372: wf_event.AddParameterToList('OLD_IES_AGENT_LOGIN',res_rec.ies_agent_login,l_list);
373: wf_event.AddParameterToList('NEW_IES_AGENT_LOGIN',l_new_ies_agent_login,l_list);
374: wf_event.AddParameterToList('OLD_SERVER_GROUP_ID',res_rec.server_group_id,l_list);
375: wf_event.AddParameterToList('NEW_SERVER_GROUP_ID',l_new_server_group_id,l_list);
368: wf_event.AddParameterToList('OLD_PRIMARY_LANGUAGE',res_rec.primary_language,l_list);
369: wf_event.AddParameterToList('NEW_PRIMARY_LANGUAGE',l_new_primary_language,l_list);
370: wf_event.AddParameterToList('OLD_SECONDARY_LANGUAGE',res_rec.secondary_language,l_list);
371: wf_event.AddParameterToList('NEW_SECONDARY_LANGUAGE',l_new_secondary_language,l_list);
372: wf_event.AddParameterToList('OLD_IES_AGENT_LOGIN',res_rec.ies_agent_login,l_list);
373: wf_event.AddParameterToList('NEW_IES_AGENT_LOGIN',l_new_ies_agent_login,l_list);
374: wf_event.AddParameterToList('OLD_SERVER_GROUP_ID',res_rec.server_group_id,l_list);
375: wf_event.AddParameterToList('NEW_SERVER_GROUP_ID',l_new_server_group_id,l_list);
376: wf_event.AddParameterToList('OLD_ASSIGNED_TO_GROUP_ID',res_rec.assigned_to_group_id,l_list);
369: wf_event.AddParameterToList('NEW_PRIMARY_LANGUAGE',l_new_primary_language,l_list);
370: wf_event.AddParameterToList('OLD_SECONDARY_LANGUAGE',res_rec.secondary_language,l_list);
371: wf_event.AddParameterToList('NEW_SECONDARY_LANGUAGE',l_new_secondary_language,l_list);
372: wf_event.AddParameterToList('OLD_IES_AGENT_LOGIN',res_rec.ies_agent_login,l_list);
373: wf_event.AddParameterToList('NEW_IES_AGENT_LOGIN',l_new_ies_agent_login,l_list);
374: wf_event.AddParameterToList('OLD_SERVER_GROUP_ID',res_rec.server_group_id,l_list);
375: wf_event.AddParameterToList('NEW_SERVER_GROUP_ID',l_new_server_group_id,l_list);
376: wf_event.AddParameterToList('OLD_ASSIGNED_TO_GROUP_ID',res_rec.assigned_to_group_id,l_list);
377: wf_event.AddParameterToList('NEW_ASSIGNED_TO_GROUP_ID',l_new_assigned_to_group_id,l_list);
370: wf_event.AddParameterToList('OLD_SECONDARY_LANGUAGE',res_rec.secondary_language,l_list);
371: wf_event.AddParameterToList('NEW_SECONDARY_LANGUAGE',l_new_secondary_language,l_list);
372: wf_event.AddParameterToList('OLD_IES_AGENT_LOGIN',res_rec.ies_agent_login,l_list);
373: wf_event.AddParameterToList('NEW_IES_AGENT_LOGIN',l_new_ies_agent_login,l_list);
374: wf_event.AddParameterToList('OLD_SERVER_GROUP_ID',res_rec.server_group_id,l_list);
375: wf_event.AddParameterToList('NEW_SERVER_GROUP_ID',l_new_server_group_id,l_list);
376: wf_event.AddParameterToList('OLD_ASSIGNED_TO_GROUP_ID',res_rec.assigned_to_group_id,l_list);
377: wf_event.AddParameterToList('NEW_ASSIGNED_TO_GROUP_ID',l_new_assigned_to_group_id,l_list);
378: wf_event.AddParameterToList('OLD_COST_CENTER',res_rec.cost_center,l_list);
371: wf_event.AddParameterToList('NEW_SECONDARY_LANGUAGE',l_new_secondary_language,l_list);
372: wf_event.AddParameterToList('OLD_IES_AGENT_LOGIN',res_rec.ies_agent_login,l_list);
373: wf_event.AddParameterToList('NEW_IES_AGENT_LOGIN',l_new_ies_agent_login,l_list);
374: wf_event.AddParameterToList('OLD_SERVER_GROUP_ID',res_rec.server_group_id,l_list);
375: wf_event.AddParameterToList('NEW_SERVER_GROUP_ID',l_new_server_group_id,l_list);
376: wf_event.AddParameterToList('OLD_ASSIGNED_TO_GROUP_ID',res_rec.assigned_to_group_id,l_list);
377: wf_event.AddParameterToList('NEW_ASSIGNED_TO_GROUP_ID',l_new_assigned_to_group_id,l_list);
378: wf_event.AddParameterToList('OLD_COST_CENTER',res_rec.cost_center,l_list);
379: wf_event.AddParameterToList('NEW_COST_CENTER',l_new_cost_center,l_list);
372: wf_event.AddParameterToList('OLD_IES_AGENT_LOGIN',res_rec.ies_agent_login,l_list);
373: wf_event.AddParameterToList('NEW_IES_AGENT_LOGIN',l_new_ies_agent_login,l_list);
374: wf_event.AddParameterToList('OLD_SERVER_GROUP_ID',res_rec.server_group_id,l_list);
375: wf_event.AddParameterToList('NEW_SERVER_GROUP_ID',l_new_server_group_id,l_list);
376: wf_event.AddParameterToList('OLD_ASSIGNED_TO_GROUP_ID',res_rec.assigned_to_group_id,l_list);
377: wf_event.AddParameterToList('NEW_ASSIGNED_TO_GROUP_ID',l_new_assigned_to_group_id,l_list);
378: wf_event.AddParameterToList('OLD_COST_CENTER',res_rec.cost_center,l_list);
379: wf_event.AddParameterToList('NEW_COST_CENTER',l_new_cost_center,l_list);
380: wf_event.AddParameterToList('OLD_CHARGE_TO_COST_CENTER',res_rec.charge_to_cost_center,l_list);
373: wf_event.AddParameterToList('NEW_IES_AGENT_LOGIN',l_new_ies_agent_login,l_list);
374: wf_event.AddParameterToList('OLD_SERVER_GROUP_ID',res_rec.server_group_id,l_list);
375: wf_event.AddParameterToList('NEW_SERVER_GROUP_ID',l_new_server_group_id,l_list);
376: wf_event.AddParameterToList('OLD_ASSIGNED_TO_GROUP_ID',res_rec.assigned_to_group_id,l_list);
377: wf_event.AddParameterToList('NEW_ASSIGNED_TO_GROUP_ID',l_new_assigned_to_group_id,l_list);
378: wf_event.AddParameterToList('OLD_COST_CENTER',res_rec.cost_center,l_list);
379: wf_event.AddParameterToList('NEW_COST_CENTER',l_new_cost_center,l_list);
380: wf_event.AddParameterToList('OLD_CHARGE_TO_COST_CENTER',res_rec.charge_to_cost_center,l_list);
381: wf_event.AddParameterToList('NEW_CHARGE_TO_COST_CENTER',l_new_charge_to_cost_center,l_list);
374: wf_event.AddParameterToList('OLD_SERVER_GROUP_ID',res_rec.server_group_id,l_list);
375: wf_event.AddParameterToList('NEW_SERVER_GROUP_ID',l_new_server_group_id,l_list);
376: wf_event.AddParameterToList('OLD_ASSIGNED_TO_GROUP_ID',res_rec.assigned_to_group_id,l_list);
377: wf_event.AddParameterToList('NEW_ASSIGNED_TO_GROUP_ID',l_new_assigned_to_group_id,l_list);
378: wf_event.AddParameterToList('OLD_COST_CENTER',res_rec.cost_center,l_list);
379: wf_event.AddParameterToList('NEW_COST_CENTER',l_new_cost_center,l_list);
380: wf_event.AddParameterToList('OLD_CHARGE_TO_COST_CENTER',res_rec.charge_to_cost_center,l_list);
381: wf_event.AddParameterToList('NEW_CHARGE_TO_COST_CENTER',l_new_charge_to_cost_center,l_list);
382: wf_event.AddParameterToList('OLD_COMPENSATION_CURRENCY_CODE',res_rec.compensation_currency_code,l_list);
375: wf_event.AddParameterToList('NEW_SERVER_GROUP_ID',l_new_server_group_id,l_list);
376: wf_event.AddParameterToList('OLD_ASSIGNED_TO_GROUP_ID',res_rec.assigned_to_group_id,l_list);
377: wf_event.AddParameterToList('NEW_ASSIGNED_TO_GROUP_ID',l_new_assigned_to_group_id,l_list);
378: wf_event.AddParameterToList('OLD_COST_CENTER',res_rec.cost_center,l_list);
379: wf_event.AddParameterToList('NEW_COST_CENTER',l_new_cost_center,l_list);
380: wf_event.AddParameterToList('OLD_CHARGE_TO_COST_CENTER',res_rec.charge_to_cost_center,l_list);
381: wf_event.AddParameterToList('NEW_CHARGE_TO_COST_CENTER',l_new_charge_to_cost_center,l_list);
382: wf_event.AddParameterToList('OLD_COMPENSATION_CURRENCY_CODE',res_rec.compensation_currency_code,l_list);
383: wf_event.AddParameterToList('NEW_COMPENSATION_CURRENCY_CODE',l_new_comp_currency_code,l_list);
376: wf_event.AddParameterToList('OLD_ASSIGNED_TO_GROUP_ID',res_rec.assigned_to_group_id,l_list);
377: wf_event.AddParameterToList('NEW_ASSIGNED_TO_GROUP_ID',l_new_assigned_to_group_id,l_list);
378: wf_event.AddParameterToList('OLD_COST_CENTER',res_rec.cost_center,l_list);
379: wf_event.AddParameterToList('NEW_COST_CENTER',l_new_cost_center,l_list);
380: wf_event.AddParameterToList('OLD_CHARGE_TO_COST_CENTER',res_rec.charge_to_cost_center,l_list);
381: wf_event.AddParameterToList('NEW_CHARGE_TO_COST_CENTER',l_new_charge_to_cost_center,l_list);
382: wf_event.AddParameterToList('OLD_COMPENSATION_CURRENCY_CODE',res_rec.compensation_currency_code,l_list);
383: wf_event.AddParameterToList('NEW_COMPENSATION_CURRENCY_CODE',l_new_comp_currency_code,l_list);
384: wf_event.AddParameterToList('OLD_COMMISSIONABLE_FLAG',res_rec.commissionable_flag,l_list);
377: wf_event.AddParameterToList('NEW_ASSIGNED_TO_GROUP_ID',l_new_assigned_to_group_id,l_list);
378: wf_event.AddParameterToList('OLD_COST_CENTER',res_rec.cost_center,l_list);
379: wf_event.AddParameterToList('NEW_COST_CENTER',l_new_cost_center,l_list);
380: wf_event.AddParameterToList('OLD_CHARGE_TO_COST_CENTER',res_rec.charge_to_cost_center,l_list);
381: wf_event.AddParameterToList('NEW_CHARGE_TO_COST_CENTER',l_new_charge_to_cost_center,l_list);
382: wf_event.AddParameterToList('OLD_COMPENSATION_CURRENCY_CODE',res_rec.compensation_currency_code,l_list);
383: wf_event.AddParameterToList('NEW_COMPENSATION_CURRENCY_CODE',l_new_comp_currency_code,l_list);
384: wf_event.AddParameterToList('OLD_COMMISSIONABLE_FLAG',res_rec.commissionable_flag,l_list);
385: wf_event.AddParameterToList('NEW_COMMISSIONABLE_FLAG',l_new_commissionable_flag,l_list);
378: wf_event.AddParameterToList('OLD_COST_CENTER',res_rec.cost_center,l_list);
379: wf_event.AddParameterToList('NEW_COST_CENTER',l_new_cost_center,l_list);
380: wf_event.AddParameterToList('OLD_CHARGE_TO_COST_CENTER',res_rec.charge_to_cost_center,l_list);
381: wf_event.AddParameterToList('NEW_CHARGE_TO_COST_CENTER',l_new_charge_to_cost_center,l_list);
382: wf_event.AddParameterToList('OLD_COMPENSATION_CURRENCY_CODE',res_rec.compensation_currency_code,l_list);
383: wf_event.AddParameterToList('NEW_COMPENSATION_CURRENCY_CODE',l_new_comp_currency_code,l_list);
384: wf_event.AddParameterToList('OLD_COMMISSIONABLE_FLAG',res_rec.commissionable_flag,l_list);
385: wf_event.AddParameterToList('NEW_COMMISSIONABLE_FLAG',l_new_commissionable_flag,l_list);
386: wf_event.AddParameterToList('OLD_HOLD_REASON_CODE',res_rec.hold_reason_code,l_list);
379: wf_event.AddParameterToList('NEW_COST_CENTER',l_new_cost_center,l_list);
380: wf_event.AddParameterToList('OLD_CHARGE_TO_COST_CENTER',res_rec.charge_to_cost_center,l_list);
381: wf_event.AddParameterToList('NEW_CHARGE_TO_COST_CENTER',l_new_charge_to_cost_center,l_list);
382: wf_event.AddParameterToList('OLD_COMPENSATION_CURRENCY_CODE',res_rec.compensation_currency_code,l_list);
383: wf_event.AddParameterToList('NEW_COMPENSATION_CURRENCY_CODE',l_new_comp_currency_code,l_list);
384: wf_event.AddParameterToList('OLD_COMMISSIONABLE_FLAG',res_rec.commissionable_flag,l_list);
385: wf_event.AddParameterToList('NEW_COMMISSIONABLE_FLAG',l_new_commissionable_flag,l_list);
386: wf_event.AddParameterToList('OLD_HOLD_REASON_CODE',res_rec.hold_reason_code,l_list);
387: wf_event.AddParameterToList('NEW_HOLD_REASON_CODE',l_new_hold_reason_code,l_list);
380: wf_event.AddParameterToList('OLD_CHARGE_TO_COST_CENTER',res_rec.charge_to_cost_center,l_list);
381: wf_event.AddParameterToList('NEW_CHARGE_TO_COST_CENTER',l_new_charge_to_cost_center,l_list);
382: wf_event.AddParameterToList('OLD_COMPENSATION_CURRENCY_CODE',res_rec.compensation_currency_code,l_list);
383: wf_event.AddParameterToList('NEW_COMPENSATION_CURRENCY_CODE',l_new_comp_currency_code,l_list);
384: wf_event.AddParameterToList('OLD_COMMISSIONABLE_FLAG',res_rec.commissionable_flag,l_list);
385: wf_event.AddParameterToList('NEW_COMMISSIONABLE_FLAG',l_new_commissionable_flag,l_list);
386: wf_event.AddParameterToList('OLD_HOLD_REASON_CODE',res_rec.hold_reason_code,l_list);
387: wf_event.AddParameterToList('NEW_HOLD_REASON_CODE',l_new_hold_reason_code,l_list);
388: wf_event.AddParameterToList('OLD_HOLD_PAYMENT',res_rec.hold_payment,l_list);
381: wf_event.AddParameterToList('NEW_CHARGE_TO_COST_CENTER',l_new_charge_to_cost_center,l_list);
382: wf_event.AddParameterToList('OLD_COMPENSATION_CURRENCY_CODE',res_rec.compensation_currency_code,l_list);
383: wf_event.AddParameterToList('NEW_COMPENSATION_CURRENCY_CODE',l_new_comp_currency_code,l_list);
384: wf_event.AddParameterToList('OLD_COMMISSIONABLE_FLAG',res_rec.commissionable_flag,l_list);
385: wf_event.AddParameterToList('NEW_COMMISSIONABLE_FLAG',l_new_commissionable_flag,l_list);
386: wf_event.AddParameterToList('OLD_HOLD_REASON_CODE',res_rec.hold_reason_code,l_list);
387: wf_event.AddParameterToList('NEW_HOLD_REASON_CODE',l_new_hold_reason_code,l_list);
388: wf_event.AddParameterToList('OLD_HOLD_PAYMENT',res_rec.hold_payment,l_list);
389: wf_event.AddParameterToList('NEW_HOLD_PAYMENT',l_new_hold_payment,l_list);
382: wf_event.AddParameterToList('OLD_COMPENSATION_CURRENCY_CODE',res_rec.compensation_currency_code,l_list);
383: wf_event.AddParameterToList('NEW_COMPENSATION_CURRENCY_CODE',l_new_comp_currency_code,l_list);
384: wf_event.AddParameterToList('OLD_COMMISSIONABLE_FLAG',res_rec.commissionable_flag,l_list);
385: wf_event.AddParameterToList('NEW_COMMISSIONABLE_FLAG',l_new_commissionable_flag,l_list);
386: wf_event.AddParameterToList('OLD_HOLD_REASON_CODE',res_rec.hold_reason_code,l_list);
387: wf_event.AddParameterToList('NEW_HOLD_REASON_CODE',l_new_hold_reason_code,l_list);
388: wf_event.AddParameterToList('OLD_HOLD_PAYMENT',res_rec.hold_payment,l_list);
389: wf_event.AddParameterToList('NEW_HOLD_PAYMENT',l_new_hold_payment,l_list);
390: wf_event.AddParameterToList('OLD_COMP_SERVICE_TEAM_ID',res_rec.comp_service_team_id,l_list);
383: wf_event.AddParameterToList('NEW_COMPENSATION_CURRENCY_CODE',l_new_comp_currency_code,l_list);
384: wf_event.AddParameterToList('OLD_COMMISSIONABLE_FLAG',res_rec.commissionable_flag,l_list);
385: wf_event.AddParameterToList('NEW_COMMISSIONABLE_FLAG',l_new_commissionable_flag,l_list);
386: wf_event.AddParameterToList('OLD_HOLD_REASON_CODE',res_rec.hold_reason_code,l_list);
387: wf_event.AddParameterToList('NEW_HOLD_REASON_CODE',l_new_hold_reason_code,l_list);
388: wf_event.AddParameterToList('OLD_HOLD_PAYMENT',res_rec.hold_payment,l_list);
389: wf_event.AddParameterToList('NEW_HOLD_PAYMENT',l_new_hold_payment,l_list);
390: wf_event.AddParameterToList('OLD_COMP_SERVICE_TEAM_ID',res_rec.comp_service_team_id,l_list);
391: wf_event.AddParameterToList('NEW_COMP_SERVICE_TEAM_ID',l_new_comp_service_team_id,l_list);
384: wf_event.AddParameterToList('OLD_COMMISSIONABLE_FLAG',res_rec.commissionable_flag,l_list);
385: wf_event.AddParameterToList('NEW_COMMISSIONABLE_FLAG',l_new_commissionable_flag,l_list);
386: wf_event.AddParameterToList('OLD_HOLD_REASON_CODE',res_rec.hold_reason_code,l_list);
387: wf_event.AddParameterToList('NEW_HOLD_REASON_CODE',l_new_hold_reason_code,l_list);
388: wf_event.AddParameterToList('OLD_HOLD_PAYMENT',res_rec.hold_payment,l_list);
389: wf_event.AddParameterToList('NEW_HOLD_PAYMENT',l_new_hold_payment,l_list);
390: wf_event.AddParameterToList('OLD_COMP_SERVICE_TEAM_ID',res_rec.comp_service_team_id,l_list);
391: wf_event.AddParameterToList('NEW_COMP_SERVICE_TEAM_ID',l_new_comp_service_team_id,l_list);
392: wf_event.AddParameterToList('OLD_SUPPORT_SITE_ID',res_rec.support_site_id,l_list);
385: wf_event.AddParameterToList('NEW_COMMISSIONABLE_FLAG',l_new_commissionable_flag,l_list);
386: wf_event.AddParameterToList('OLD_HOLD_REASON_CODE',res_rec.hold_reason_code,l_list);
387: wf_event.AddParameterToList('NEW_HOLD_REASON_CODE',l_new_hold_reason_code,l_list);
388: wf_event.AddParameterToList('OLD_HOLD_PAYMENT',res_rec.hold_payment,l_list);
389: wf_event.AddParameterToList('NEW_HOLD_PAYMENT',l_new_hold_payment,l_list);
390: wf_event.AddParameterToList('OLD_COMP_SERVICE_TEAM_ID',res_rec.comp_service_team_id,l_list);
391: wf_event.AddParameterToList('NEW_COMP_SERVICE_TEAM_ID',l_new_comp_service_team_id,l_list);
392: wf_event.AddParameterToList('OLD_SUPPORT_SITE_ID',res_rec.support_site_id,l_list);
393: wf_event.AddParameterToList('NEW_SUPPORT_SITE_ID',l_new_support_site_id,l_list);
386: wf_event.AddParameterToList('OLD_HOLD_REASON_CODE',res_rec.hold_reason_code,l_list);
387: wf_event.AddParameterToList('NEW_HOLD_REASON_CODE',l_new_hold_reason_code,l_list);
388: wf_event.AddParameterToList('OLD_HOLD_PAYMENT',res_rec.hold_payment,l_list);
389: wf_event.AddParameterToList('NEW_HOLD_PAYMENT',l_new_hold_payment,l_list);
390: wf_event.AddParameterToList('OLD_COMP_SERVICE_TEAM_ID',res_rec.comp_service_team_id,l_list);
391: wf_event.AddParameterToList('NEW_COMP_SERVICE_TEAM_ID',l_new_comp_service_team_id,l_list);
392: wf_event.AddParameterToList('OLD_SUPPORT_SITE_ID',res_rec.support_site_id,l_list);
393: wf_event.AddParameterToList('NEW_SUPPORT_SITE_ID',l_new_support_site_id,l_list);
394:
387: wf_event.AddParameterToList('NEW_HOLD_REASON_CODE',l_new_hold_reason_code,l_list);
388: wf_event.AddParameterToList('OLD_HOLD_PAYMENT',res_rec.hold_payment,l_list);
389: wf_event.AddParameterToList('NEW_HOLD_PAYMENT',l_new_hold_payment,l_list);
390: wf_event.AddParameterToList('OLD_COMP_SERVICE_TEAM_ID',res_rec.comp_service_team_id,l_list);
391: wf_event.AddParameterToList('NEW_COMP_SERVICE_TEAM_ID',l_new_comp_service_team_id,l_list);
392: wf_event.AddParameterToList('OLD_SUPPORT_SITE_ID',res_rec.support_site_id,l_list);
393: wf_event.AddParameterToList('NEW_SUPPORT_SITE_ID',l_new_support_site_id,l_list);
394:
395: -- Raise Event
388: wf_event.AddParameterToList('OLD_HOLD_PAYMENT',res_rec.hold_payment,l_list);
389: wf_event.AddParameterToList('NEW_HOLD_PAYMENT',l_new_hold_payment,l_list);
390: wf_event.AddParameterToList('OLD_COMP_SERVICE_TEAM_ID',res_rec.comp_service_team_id,l_list);
391: wf_event.AddParameterToList('NEW_COMP_SERVICE_TEAM_ID',l_new_comp_service_team_id,l_list);
392: wf_event.AddParameterToList('OLD_SUPPORT_SITE_ID',res_rec.support_site_id,l_list);
393: wf_event.AddParameterToList('NEW_SUPPORT_SITE_ID',l_new_support_site_id,l_list);
394:
395: -- Raise Event
396: wf_event.raise(
389: wf_event.AddParameterToList('NEW_HOLD_PAYMENT',l_new_hold_payment,l_list);
390: wf_event.AddParameterToList('OLD_COMP_SERVICE_TEAM_ID',res_rec.comp_service_team_id,l_list);
391: wf_event.AddParameterToList('NEW_COMP_SERVICE_TEAM_ID',l_new_comp_service_team_id,l_list);
392: wf_event.AddParameterToList('OLD_SUPPORT_SITE_ID',res_rec.support_site_id,l_list);
393: wf_event.AddParameterToList('NEW_SUPPORT_SITE_ID',l_new_support_site_id,l_list);
394:
395: -- Raise Event
396: wf_event.raise(
397: p_event_name => l_event_name
392: wf_event.AddParameterToList('OLD_SUPPORT_SITE_ID',res_rec.support_site_id,l_list);
393: wf_event.AddParameterToList('NEW_SUPPORT_SITE_ID',l_new_support_site_id,l_list);
394:
395: -- Raise Event
396: wf_event.raise(
397: p_event_name => l_event_name
398: ,p_event_key => l_key
399: ,p_parameters => l_list
400: );
451: l_key := item_key(l_event_name);
452:
453: -- initialization of object variables
454:
455: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
456:
457: -- Raise Event
458: wf_event.raise(
459: p_event_name => l_event_name
454:
455: wf_event.AddParameterToList('RESOURCE_ID',l_resource_id,l_list);
456:
457: -- Raise Event
458: wf_event.raise(
459: p_event_name => l_event_name
460: ,p_event_key => l_key
461: ,p_parameters => l_list
462: );
527: l_key := item_key(l_event_name);
528:
529: -- initialization of object variables
530:
531: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
532: wf_event.AddParameterToList('ROLE_TYPE_CODE',l_role_type_code,l_list);
533: wf_event.AddParameterToList('ROLE_CODE',l_role_code,l_list);
534: wf_event.AddParameterToList('ROLE_NAME',l_role_name,l_list);
535: wf_event.AddParameterToList('ROLE_DESC',l_role_desc,l_list);
528:
529: -- initialization of object variables
530:
531: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
532: wf_event.AddParameterToList('ROLE_TYPE_CODE',l_role_type_code,l_list);
533: wf_event.AddParameterToList('ROLE_CODE',l_role_code,l_list);
534: wf_event.AddParameterToList('ROLE_NAME',l_role_name,l_list);
535: wf_event.AddParameterToList('ROLE_DESC',l_role_desc,l_list);
536: wf_event.AddParameterToList('ACTIVE_FLAG',l_active_flag,l_list);
529: -- initialization of object variables
530:
531: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
532: wf_event.AddParameterToList('ROLE_TYPE_CODE',l_role_type_code,l_list);
533: wf_event.AddParameterToList('ROLE_CODE',l_role_code,l_list);
534: wf_event.AddParameterToList('ROLE_NAME',l_role_name,l_list);
535: wf_event.AddParameterToList('ROLE_DESC',l_role_desc,l_list);
536: wf_event.AddParameterToList('ACTIVE_FLAG',l_active_flag,l_list);
537: wf_event.AddParameterToList('MEMBER_FLAG',l_member_flag,l_list);
530:
531: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
532: wf_event.AddParameterToList('ROLE_TYPE_CODE',l_role_type_code,l_list);
533: wf_event.AddParameterToList('ROLE_CODE',l_role_code,l_list);
534: wf_event.AddParameterToList('ROLE_NAME',l_role_name,l_list);
535: wf_event.AddParameterToList('ROLE_DESC',l_role_desc,l_list);
536: wf_event.AddParameterToList('ACTIVE_FLAG',l_active_flag,l_list);
537: wf_event.AddParameterToList('MEMBER_FLAG',l_member_flag,l_list);
538: wf_event.AddParameterToList('ADMIN_FLAG',l_admin_flag,l_list);
531: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
532: wf_event.AddParameterToList('ROLE_TYPE_CODE',l_role_type_code,l_list);
533: wf_event.AddParameterToList('ROLE_CODE',l_role_code,l_list);
534: wf_event.AddParameterToList('ROLE_NAME',l_role_name,l_list);
535: wf_event.AddParameterToList('ROLE_DESC',l_role_desc,l_list);
536: wf_event.AddParameterToList('ACTIVE_FLAG',l_active_flag,l_list);
537: wf_event.AddParameterToList('MEMBER_FLAG',l_member_flag,l_list);
538: wf_event.AddParameterToList('ADMIN_FLAG',l_admin_flag,l_list);
539: wf_event.AddParameterToList('LEAD_FLAG',l_lead_flag,l_list);
532: wf_event.AddParameterToList('ROLE_TYPE_CODE',l_role_type_code,l_list);
533: wf_event.AddParameterToList('ROLE_CODE',l_role_code,l_list);
534: wf_event.AddParameterToList('ROLE_NAME',l_role_name,l_list);
535: wf_event.AddParameterToList('ROLE_DESC',l_role_desc,l_list);
536: wf_event.AddParameterToList('ACTIVE_FLAG',l_active_flag,l_list);
537: wf_event.AddParameterToList('MEMBER_FLAG',l_member_flag,l_list);
538: wf_event.AddParameterToList('ADMIN_FLAG',l_admin_flag,l_list);
539: wf_event.AddParameterToList('LEAD_FLAG',l_lead_flag,l_list);
540: wf_event.AddParameterToList('MANAGER_FLAG',l_manager_flag,l_list);
533: wf_event.AddParameterToList('ROLE_CODE',l_role_code,l_list);
534: wf_event.AddParameterToList('ROLE_NAME',l_role_name,l_list);
535: wf_event.AddParameterToList('ROLE_DESC',l_role_desc,l_list);
536: wf_event.AddParameterToList('ACTIVE_FLAG',l_active_flag,l_list);
537: wf_event.AddParameterToList('MEMBER_FLAG',l_member_flag,l_list);
538: wf_event.AddParameterToList('ADMIN_FLAG',l_admin_flag,l_list);
539: wf_event.AddParameterToList('LEAD_FLAG',l_lead_flag,l_list);
540: wf_event.AddParameterToList('MANAGER_FLAG',l_manager_flag,l_list);
541:
534: wf_event.AddParameterToList('ROLE_NAME',l_role_name,l_list);
535: wf_event.AddParameterToList('ROLE_DESC',l_role_desc,l_list);
536: wf_event.AddParameterToList('ACTIVE_FLAG',l_active_flag,l_list);
537: wf_event.AddParameterToList('MEMBER_FLAG',l_member_flag,l_list);
538: wf_event.AddParameterToList('ADMIN_FLAG',l_admin_flag,l_list);
539: wf_event.AddParameterToList('LEAD_FLAG',l_lead_flag,l_list);
540: wf_event.AddParameterToList('MANAGER_FLAG',l_manager_flag,l_list);
541:
542: -- Raise Event
535: wf_event.AddParameterToList('ROLE_DESC',l_role_desc,l_list);
536: wf_event.AddParameterToList('ACTIVE_FLAG',l_active_flag,l_list);
537: wf_event.AddParameterToList('MEMBER_FLAG',l_member_flag,l_list);
538: wf_event.AddParameterToList('ADMIN_FLAG',l_admin_flag,l_list);
539: wf_event.AddParameterToList('LEAD_FLAG',l_lead_flag,l_list);
540: wf_event.AddParameterToList('MANAGER_FLAG',l_manager_flag,l_list);
541:
542: -- Raise Event
543: wf_event.raise(
536: wf_event.AddParameterToList('ACTIVE_FLAG',l_active_flag,l_list);
537: wf_event.AddParameterToList('MEMBER_FLAG',l_member_flag,l_list);
538: wf_event.AddParameterToList('ADMIN_FLAG',l_admin_flag,l_list);
539: wf_event.AddParameterToList('LEAD_FLAG',l_lead_flag,l_list);
540: wf_event.AddParameterToList('MANAGER_FLAG',l_manager_flag,l_list);
541:
542: -- Raise Event
543: wf_event.raise(
544: p_event_name => l_event_name
539: wf_event.AddParameterToList('LEAD_FLAG',l_lead_flag,l_list);
540: wf_event.AddParameterToList('MANAGER_FLAG',l_manager_flag,l_list);
541:
542: -- Raise Event
543: wf_event.raise(
544: p_event_name => l_event_name
545: ,p_event_key => l_key
546: ,p_parameters => l_list
547: );
640: l_key := item_key(l_event_name);
641:
642: -- initialization of object variables
643:
644: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
645: wf_event.AddParameterToList('OLD_ROLE_TYPE_CODE',res_role_rec.role_type_code,l_list);
646: wf_event.AddParameterToList('NEW_ROLE_TYPE_CODE',l_new_role_type_code,l_list);
647: wf_event.AddParameterToList('OLD_ROLE_CODE',res_role_rec.role_code,l_list);
648: wf_event.AddParameterToList('NEW_ROLE_CODE',l_new_role_code,l_list);
641:
642: -- initialization of object variables
643:
644: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
645: wf_event.AddParameterToList('OLD_ROLE_TYPE_CODE',res_role_rec.role_type_code,l_list);
646: wf_event.AddParameterToList('NEW_ROLE_TYPE_CODE',l_new_role_type_code,l_list);
647: wf_event.AddParameterToList('OLD_ROLE_CODE',res_role_rec.role_code,l_list);
648: wf_event.AddParameterToList('NEW_ROLE_CODE',l_new_role_code,l_list);
649: wf_event.AddParameterToList('OLD_ROLE_NAME',res_role_rec.role_name,l_list);
642: -- initialization of object variables
643:
644: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
645: wf_event.AddParameterToList('OLD_ROLE_TYPE_CODE',res_role_rec.role_type_code,l_list);
646: wf_event.AddParameterToList('NEW_ROLE_TYPE_CODE',l_new_role_type_code,l_list);
647: wf_event.AddParameterToList('OLD_ROLE_CODE',res_role_rec.role_code,l_list);
648: wf_event.AddParameterToList('NEW_ROLE_CODE',l_new_role_code,l_list);
649: wf_event.AddParameterToList('OLD_ROLE_NAME',res_role_rec.role_name,l_list);
650: wf_event.AddParameterToList('NEW_ROLE_NAME',l_new_role_name,l_list);
643:
644: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
645: wf_event.AddParameterToList('OLD_ROLE_TYPE_CODE',res_role_rec.role_type_code,l_list);
646: wf_event.AddParameterToList('NEW_ROLE_TYPE_CODE',l_new_role_type_code,l_list);
647: wf_event.AddParameterToList('OLD_ROLE_CODE',res_role_rec.role_code,l_list);
648: wf_event.AddParameterToList('NEW_ROLE_CODE',l_new_role_code,l_list);
649: wf_event.AddParameterToList('OLD_ROLE_NAME',res_role_rec.role_name,l_list);
650: wf_event.AddParameterToList('NEW_ROLE_NAME',l_new_role_name,l_list);
651: wf_event.AddParameterToList('OLD_ROLE_DESC',res_role_rec.role_desc,l_list);
644: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
645: wf_event.AddParameterToList('OLD_ROLE_TYPE_CODE',res_role_rec.role_type_code,l_list);
646: wf_event.AddParameterToList('NEW_ROLE_TYPE_CODE',l_new_role_type_code,l_list);
647: wf_event.AddParameterToList('OLD_ROLE_CODE',res_role_rec.role_code,l_list);
648: wf_event.AddParameterToList('NEW_ROLE_CODE',l_new_role_code,l_list);
649: wf_event.AddParameterToList('OLD_ROLE_NAME',res_role_rec.role_name,l_list);
650: wf_event.AddParameterToList('NEW_ROLE_NAME',l_new_role_name,l_list);
651: wf_event.AddParameterToList('OLD_ROLE_DESC',res_role_rec.role_desc,l_list);
652: wf_event.AddParameterToList('NEW_ROLE_DESC',l_new_role_desc,l_list);
645: wf_event.AddParameterToList('OLD_ROLE_TYPE_CODE',res_role_rec.role_type_code,l_list);
646: wf_event.AddParameterToList('NEW_ROLE_TYPE_CODE',l_new_role_type_code,l_list);
647: wf_event.AddParameterToList('OLD_ROLE_CODE',res_role_rec.role_code,l_list);
648: wf_event.AddParameterToList('NEW_ROLE_CODE',l_new_role_code,l_list);
649: wf_event.AddParameterToList('OLD_ROLE_NAME',res_role_rec.role_name,l_list);
650: wf_event.AddParameterToList('NEW_ROLE_NAME',l_new_role_name,l_list);
651: wf_event.AddParameterToList('OLD_ROLE_DESC',res_role_rec.role_desc,l_list);
652: wf_event.AddParameterToList('NEW_ROLE_DESC',l_new_role_desc,l_list);
653: wf_event.AddParameterToList('OLD_ACTIVE_FLAG',res_role_rec.active_flag,l_list);
646: wf_event.AddParameterToList('NEW_ROLE_TYPE_CODE',l_new_role_type_code,l_list);
647: wf_event.AddParameterToList('OLD_ROLE_CODE',res_role_rec.role_code,l_list);
648: wf_event.AddParameterToList('NEW_ROLE_CODE',l_new_role_code,l_list);
649: wf_event.AddParameterToList('OLD_ROLE_NAME',res_role_rec.role_name,l_list);
650: wf_event.AddParameterToList('NEW_ROLE_NAME',l_new_role_name,l_list);
651: wf_event.AddParameterToList('OLD_ROLE_DESC',res_role_rec.role_desc,l_list);
652: wf_event.AddParameterToList('NEW_ROLE_DESC',l_new_role_desc,l_list);
653: wf_event.AddParameterToList('OLD_ACTIVE_FLAG',res_role_rec.active_flag,l_list);
654: wf_event.AddParameterToList('NEW_ACTIVE_FLAG',l_new_active_flag,l_list);
647: wf_event.AddParameterToList('OLD_ROLE_CODE',res_role_rec.role_code,l_list);
648: wf_event.AddParameterToList('NEW_ROLE_CODE',l_new_role_code,l_list);
649: wf_event.AddParameterToList('OLD_ROLE_NAME',res_role_rec.role_name,l_list);
650: wf_event.AddParameterToList('NEW_ROLE_NAME',l_new_role_name,l_list);
651: wf_event.AddParameterToList('OLD_ROLE_DESC',res_role_rec.role_desc,l_list);
652: wf_event.AddParameterToList('NEW_ROLE_DESC',l_new_role_desc,l_list);
653: wf_event.AddParameterToList('OLD_ACTIVE_FLAG',res_role_rec.active_flag,l_list);
654: wf_event.AddParameterToList('NEW_ACTIVE_FLAG',l_new_active_flag,l_list);
655: wf_event.AddParameterToList('OLD_MEMBER_FLAG',res_role_rec.member_flag,l_list);
648: wf_event.AddParameterToList('NEW_ROLE_CODE',l_new_role_code,l_list);
649: wf_event.AddParameterToList('OLD_ROLE_NAME',res_role_rec.role_name,l_list);
650: wf_event.AddParameterToList('NEW_ROLE_NAME',l_new_role_name,l_list);
651: wf_event.AddParameterToList('OLD_ROLE_DESC',res_role_rec.role_desc,l_list);
652: wf_event.AddParameterToList('NEW_ROLE_DESC',l_new_role_desc,l_list);
653: wf_event.AddParameterToList('OLD_ACTIVE_FLAG',res_role_rec.active_flag,l_list);
654: wf_event.AddParameterToList('NEW_ACTIVE_FLAG',l_new_active_flag,l_list);
655: wf_event.AddParameterToList('OLD_MEMBER_FLAG',res_role_rec.member_flag,l_list);
656: wf_event.AddParameterToList('NEW_MEMBER_FLAG',l_new_member_flag,l_list);
649: wf_event.AddParameterToList('OLD_ROLE_NAME',res_role_rec.role_name,l_list);
650: wf_event.AddParameterToList('NEW_ROLE_NAME',l_new_role_name,l_list);
651: wf_event.AddParameterToList('OLD_ROLE_DESC',res_role_rec.role_desc,l_list);
652: wf_event.AddParameterToList('NEW_ROLE_DESC',l_new_role_desc,l_list);
653: wf_event.AddParameterToList('OLD_ACTIVE_FLAG',res_role_rec.active_flag,l_list);
654: wf_event.AddParameterToList('NEW_ACTIVE_FLAG',l_new_active_flag,l_list);
655: wf_event.AddParameterToList('OLD_MEMBER_FLAG',res_role_rec.member_flag,l_list);
656: wf_event.AddParameterToList('NEW_MEMBER_FLAG',l_new_member_flag,l_list);
657: wf_event.AddParameterToList('OLD_ADMIN_FLAG',res_role_rec.admin_flag,l_list);
650: wf_event.AddParameterToList('NEW_ROLE_NAME',l_new_role_name,l_list);
651: wf_event.AddParameterToList('OLD_ROLE_DESC',res_role_rec.role_desc,l_list);
652: wf_event.AddParameterToList('NEW_ROLE_DESC',l_new_role_desc,l_list);
653: wf_event.AddParameterToList('OLD_ACTIVE_FLAG',res_role_rec.active_flag,l_list);
654: wf_event.AddParameterToList('NEW_ACTIVE_FLAG',l_new_active_flag,l_list);
655: wf_event.AddParameterToList('OLD_MEMBER_FLAG',res_role_rec.member_flag,l_list);
656: wf_event.AddParameterToList('NEW_MEMBER_FLAG',l_new_member_flag,l_list);
657: wf_event.AddParameterToList('OLD_ADMIN_FLAG',res_role_rec.admin_flag,l_list);
658: wf_event.AddParameterToList('NEW_ADMIN_FLAG',l_new_admin_flag,l_list);
651: wf_event.AddParameterToList('OLD_ROLE_DESC',res_role_rec.role_desc,l_list);
652: wf_event.AddParameterToList('NEW_ROLE_DESC',l_new_role_desc,l_list);
653: wf_event.AddParameterToList('OLD_ACTIVE_FLAG',res_role_rec.active_flag,l_list);
654: wf_event.AddParameterToList('NEW_ACTIVE_FLAG',l_new_active_flag,l_list);
655: wf_event.AddParameterToList('OLD_MEMBER_FLAG',res_role_rec.member_flag,l_list);
656: wf_event.AddParameterToList('NEW_MEMBER_FLAG',l_new_member_flag,l_list);
657: wf_event.AddParameterToList('OLD_ADMIN_FLAG',res_role_rec.admin_flag,l_list);
658: wf_event.AddParameterToList('NEW_ADMIN_FLAG',l_new_admin_flag,l_list);
659: wf_event.AddParameterToList('OLD_LEAD_FLAG',res_role_rec.lead_flag,l_list);
652: wf_event.AddParameterToList('NEW_ROLE_DESC',l_new_role_desc,l_list);
653: wf_event.AddParameterToList('OLD_ACTIVE_FLAG',res_role_rec.active_flag,l_list);
654: wf_event.AddParameterToList('NEW_ACTIVE_FLAG',l_new_active_flag,l_list);
655: wf_event.AddParameterToList('OLD_MEMBER_FLAG',res_role_rec.member_flag,l_list);
656: wf_event.AddParameterToList('NEW_MEMBER_FLAG',l_new_member_flag,l_list);
657: wf_event.AddParameterToList('OLD_ADMIN_FLAG',res_role_rec.admin_flag,l_list);
658: wf_event.AddParameterToList('NEW_ADMIN_FLAG',l_new_admin_flag,l_list);
659: wf_event.AddParameterToList('OLD_LEAD_FLAG',res_role_rec.lead_flag,l_list);
660: wf_event.AddParameterToList('NEW_LEAD_FLAG',l_new_lead_flag,l_list);
653: wf_event.AddParameterToList('OLD_ACTIVE_FLAG',res_role_rec.active_flag,l_list);
654: wf_event.AddParameterToList('NEW_ACTIVE_FLAG',l_new_active_flag,l_list);
655: wf_event.AddParameterToList('OLD_MEMBER_FLAG',res_role_rec.member_flag,l_list);
656: wf_event.AddParameterToList('NEW_MEMBER_FLAG',l_new_member_flag,l_list);
657: wf_event.AddParameterToList('OLD_ADMIN_FLAG',res_role_rec.admin_flag,l_list);
658: wf_event.AddParameterToList('NEW_ADMIN_FLAG',l_new_admin_flag,l_list);
659: wf_event.AddParameterToList('OLD_LEAD_FLAG',res_role_rec.lead_flag,l_list);
660: wf_event.AddParameterToList('NEW_LEAD_FLAG',l_new_lead_flag,l_list);
661: wf_event.AddParameterToList('OLD_MANAGER_FLAG',res_role_rec.manager_flag,l_list);
654: wf_event.AddParameterToList('NEW_ACTIVE_FLAG',l_new_active_flag,l_list);
655: wf_event.AddParameterToList('OLD_MEMBER_FLAG',res_role_rec.member_flag,l_list);
656: wf_event.AddParameterToList('NEW_MEMBER_FLAG',l_new_member_flag,l_list);
657: wf_event.AddParameterToList('OLD_ADMIN_FLAG',res_role_rec.admin_flag,l_list);
658: wf_event.AddParameterToList('NEW_ADMIN_FLAG',l_new_admin_flag,l_list);
659: wf_event.AddParameterToList('OLD_LEAD_FLAG',res_role_rec.lead_flag,l_list);
660: wf_event.AddParameterToList('NEW_LEAD_FLAG',l_new_lead_flag,l_list);
661: wf_event.AddParameterToList('OLD_MANAGER_FLAG',res_role_rec.manager_flag,l_list);
662: wf_event.AddParameterToList('NEW_MANAGER_FLAG',l_new_manager_flag,l_list);
655: wf_event.AddParameterToList('OLD_MEMBER_FLAG',res_role_rec.member_flag,l_list);
656: wf_event.AddParameterToList('NEW_MEMBER_FLAG',l_new_member_flag,l_list);
657: wf_event.AddParameterToList('OLD_ADMIN_FLAG',res_role_rec.admin_flag,l_list);
658: wf_event.AddParameterToList('NEW_ADMIN_FLAG',l_new_admin_flag,l_list);
659: wf_event.AddParameterToList('OLD_LEAD_FLAG',res_role_rec.lead_flag,l_list);
660: wf_event.AddParameterToList('NEW_LEAD_FLAG',l_new_lead_flag,l_list);
661: wf_event.AddParameterToList('OLD_MANAGER_FLAG',res_role_rec.manager_flag,l_list);
662: wf_event.AddParameterToList('NEW_MANAGER_FLAG',l_new_manager_flag,l_list);
663:
656: wf_event.AddParameterToList('NEW_MEMBER_FLAG',l_new_member_flag,l_list);
657: wf_event.AddParameterToList('OLD_ADMIN_FLAG',res_role_rec.admin_flag,l_list);
658: wf_event.AddParameterToList('NEW_ADMIN_FLAG',l_new_admin_flag,l_list);
659: wf_event.AddParameterToList('OLD_LEAD_FLAG',res_role_rec.lead_flag,l_list);
660: wf_event.AddParameterToList('NEW_LEAD_FLAG',l_new_lead_flag,l_list);
661: wf_event.AddParameterToList('OLD_MANAGER_FLAG',res_role_rec.manager_flag,l_list);
662: wf_event.AddParameterToList('NEW_MANAGER_FLAG',l_new_manager_flag,l_list);
663:
664: -- Raise Event
657: wf_event.AddParameterToList('OLD_ADMIN_FLAG',res_role_rec.admin_flag,l_list);
658: wf_event.AddParameterToList('NEW_ADMIN_FLAG',l_new_admin_flag,l_list);
659: wf_event.AddParameterToList('OLD_LEAD_FLAG',res_role_rec.lead_flag,l_list);
660: wf_event.AddParameterToList('NEW_LEAD_FLAG',l_new_lead_flag,l_list);
661: wf_event.AddParameterToList('OLD_MANAGER_FLAG',res_role_rec.manager_flag,l_list);
662: wf_event.AddParameterToList('NEW_MANAGER_FLAG',l_new_manager_flag,l_list);
663:
664: -- Raise Event
665: wf_event.raise(
658: wf_event.AddParameterToList('NEW_ADMIN_FLAG',l_new_admin_flag,l_list);
659: wf_event.AddParameterToList('OLD_LEAD_FLAG',res_role_rec.lead_flag,l_list);
660: wf_event.AddParameterToList('NEW_LEAD_FLAG',l_new_lead_flag,l_list);
661: wf_event.AddParameterToList('OLD_MANAGER_FLAG',res_role_rec.manager_flag,l_list);
662: wf_event.AddParameterToList('NEW_MANAGER_FLAG',l_new_manager_flag,l_list);
663:
664: -- Raise Event
665: wf_event.raise(
666: p_event_name => l_event_name
661: wf_event.AddParameterToList('OLD_MANAGER_FLAG',res_role_rec.manager_flag,l_list);
662: wf_event.AddParameterToList('NEW_MANAGER_FLAG',l_new_manager_flag,l_list);
663:
664: -- Raise Event
665: wf_event.raise(
666: p_event_name => l_event_name
667: ,p_event_key => l_key
668: ,p_parameters => l_list
669: );
721: l_key := item_key(l_event_name);
722:
723: -- initialization of object variables
724:
725: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
726:
727: -- Raise Event
728: wf_event.raise(
729: p_event_name => l_event_name
724:
725: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
726:
727: -- Raise Event
728: wf_event.raise(
729: p_event_name => l_event_name
730: ,p_event_key => l_key
731: ,p_parameters => l_list
732: );
790: l_key := item_key(l_event_name);
791:
792: -- initialization of object variables
793:
794: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
795: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
796: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
797: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
798: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
791:
792: -- initialization of object variables
793:
794: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
795: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
796: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
797: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
798: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
799: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
792: -- initialization of object variables
793:
794: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
795: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
796: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
797: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
798: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
799: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
800:
793:
794: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
795: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
796: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
797: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
798: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
799: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
800:
801: -- Raise Event
794: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
795: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
796: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
797: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
798: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
799: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
800:
801: -- Raise Event
802: wf_event.raise(
795: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
796: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
797: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
798: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
799: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
800:
801: -- Raise Event
802: wf_event.raise(
803: p_event_name => l_event_name
798: wf_event.AddParameterToList('START_DATE_ACTIVE',l_start_date_active,l_list);
799: wf_event.AddParameterToList('END_DATE_ACTIVE',l_end_date_active,l_list);
800:
801: -- Raise Event
802: wf_event.raise(
803: p_event_name => l_event_name
804: ,p_event_key => l_key
805: ,p_parameters => l_list
806: );
884: l_key := item_key(l_event_name);
885:
886: -- initialization of object variables
887:
888: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
889: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
890: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
891: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
892: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rolerelate_rec.start_date_active,l_list);
885:
886: -- initialization of object variables
887:
888: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
889: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
890: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
891: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
892: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rolerelate_rec.start_date_active,l_list);
893: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
886: -- initialization of object variables
887:
888: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
889: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
890: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
891: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
892: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rolerelate_rec.start_date_active,l_list);
893: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
894: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rolerelate_rec.end_date_active,l_list);
887:
888: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
889: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
890: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
891: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
892: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rolerelate_rec.start_date_active,l_list);
893: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
894: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rolerelate_rec.end_date_active,l_list);
895: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
888: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
889: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
890: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
891: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
892: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rolerelate_rec.start_date_active,l_list);
893: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
894: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rolerelate_rec.end_date_active,l_list);
895: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
896:
889: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',l_role_resource_type,l_list);
890: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
891: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
892: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rolerelate_rec.start_date_active,l_list);
893: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
894: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rolerelate_rec.end_date_active,l_list);
895: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
896:
897: -- Raise Event
890: wf_event.AddParameterToList('ROLE_RESOURCE_ID',l_role_resource_id,l_list);
891: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
892: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rolerelate_rec.start_date_active,l_list);
893: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
894: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rolerelate_rec.end_date_active,l_list);
895: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
896:
897: -- Raise Event
898: wf_event.raise(
891: wf_event.AddParameterToList('ROLE_ID',l_role_id,l_list);
892: wf_event.AddParameterToList('OLD_START_DATE_ACTIVE',res_rolerelate_rec.start_date_active,l_list);
893: wf_event.AddParameterToList('NEW_START_DATE_ACTIVE',l_new_start_date_active,l_list);
894: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rolerelate_rec.end_date_active,l_list);
895: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
896:
897: -- Raise Event
898: wf_event.raise(
899: p_event_name => l_event_name
894: wf_event.AddParameterToList('OLD_END_DATE_ACTIVE',res_rolerelate_rec.end_date_active,l_list);
895: wf_event.AddParameterToList('NEW_END_DATE_ACTIVE',l_new_end_date_active,l_list);
896:
897: -- Raise Event
898: wf_event.raise(
899: p_event_name => l_event_name
900: ,p_event_key => l_key
901: ,p_parameters => l_list
902: );
967: l_key := item_key(l_event_name);
968:
969: -- initialization of object variables
970:
971: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
972: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',del_rolerelate_rec.role_resource_type,l_list);
973: wf_event.AddParameterToList('ROLE_RESOURCE_ID',del_rolerelate_rec.role_resource_id,l_list);
974: wf_event.AddParameterToList('ROLE_ID',del_rolerelate_rec.role_id,l_list);
975:
968:
969: -- initialization of object variables
970:
971: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
972: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',del_rolerelate_rec.role_resource_type,l_list);
973: wf_event.AddParameterToList('ROLE_RESOURCE_ID',del_rolerelate_rec.role_resource_id,l_list);
974: wf_event.AddParameterToList('ROLE_ID',del_rolerelate_rec.role_id,l_list);
975:
976: -- Raise Event
969: -- initialization of object variables
970:
971: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
972: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',del_rolerelate_rec.role_resource_type,l_list);
973: wf_event.AddParameterToList('ROLE_RESOURCE_ID',del_rolerelate_rec.role_resource_id,l_list);
974: wf_event.AddParameterToList('ROLE_ID',del_rolerelate_rec.role_id,l_list);
975:
976: -- Raise Event
977: wf_event.raise(
970:
971: wf_event.AddParameterToList('ROLE_RELATE_ID',l_role_relate_id,l_list);
972: wf_event.AddParameterToList('ROLE_RESOURCE_TYPE',del_rolerelate_rec.role_resource_type,l_list);
973: wf_event.AddParameterToList('ROLE_RESOURCE_ID',del_rolerelate_rec.role_resource_id,l_list);
974: wf_event.AddParameterToList('ROLE_ID',del_rolerelate_rec.role_id,l_list);
975:
976: -- Raise Event
977: wf_event.raise(
978: p_event_name => l_event_name
973: wf_event.AddParameterToList('ROLE_RESOURCE_ID',del_rolerelate_rec.role_resource_id,l_list);
974: wf_event.AddParameterToList('ROLE_ID',del_rolerelate_rec.role_id,l_list);
975:
976: -- Raise Event
977: wf_event.raise(
978: p_event_name => l_event_name
979: ,p_event_key => l_key
980: ,p_parameters => l_list
981: );
988: ROLLBACK TO del_rolerelate_publish_save;
989: x_return_status := fnd_api.g_ret_sts_unexp_error;
990: END delete_resource_role_relate;
991:
992: END jtf_rs_wf_events_pub;