12: begin
13:
14: -- Populating the structure wf_parameter_list_t
15:
16: WF_EVENT.AddParameterToList(p_name => 'USER_NAME',
17: p_value => p_role_name,
18: p_parameterlist => p_params);
19:
20: WF_EVENT.AddParameterToList(p_name => 'DISPLAYNAME',
16: WF_EVENT.AddParameterToList(p_name => 'USER_NAME',
17: p_value => p_role_name,
18: p_parameterlist => p_params);
19:
20: WF_EVENT.AddParameterToList(p_name => 'DISPLAYNAME',
21: p_value => p_display_name,
22: p_parameterlist => p_params);
23:
24: WF_EVENT.AddParameterToList(p_name => 'DESCRIPTION',
20: WF_EVENT.AddParameterToList(p_name => 'DISPLAYNAME',
21: p_value => p_display_name,
22: p_parameterlist => p_params);
23:
24: WF_EVENT.AddParameterToList(p_name => 'DESCRIPTION',
25: p_value => p_description,
26: p_parameterlist => p_params);
27:
28: WF_EVENT.AddParameterToList(p_name => 'OWNER_TAG',
24: WF_EVENT.AddParameterToList(p_name => 'DESCRIPTION',
25: p_value => p_description,
26: p_parameterlist => p_params);
27:
28: WF_EVENT.AddParameterToList(p_name => 'OWNER_TAG',
29: p_value => p_owner_tag,
30: p_parameterlist => p_params);
31:
32: -- Setting the default values
30: p_parameterlist => p_params);
31:
32: -- Setting the default values
33:
34: WF_EVENT.AddParameterToList(p_name => 'ORCLNLSTERRITORY',
35: p_value => 'AMERICA',
36: p_parameterlist => p_params);
37:
38: WF_EVENT.AddParameterToList(p_name => 'RAISEERRORS',
34: WF_EVENT.AddParameterToList(p_name => 'ORCLNLSTERRITORY',
35: p_value => 'AMERICA',
36: p_parameterlist => p_params);
37:
38: WF_EVENT.AddParameterToList(p_name => 'RAISEERRORS',
39: p_value => 'TRUE',
40: p_parameterlist => p_params);
41:
42: l_notif_preference := NVL(wf_pref.get_pref('-WF_DEFAULT-', 'MAILTYPE'), 'QUERY');
40: p_parameterlist => p_params);
41:
42: l_notif_preference := NVL(wf_pref.get_pref('-WF_DEFAULT-', 'MAILTYPE'), 'QUERY');
43:
44: WF_EVENT.AddParameterToList(p_name => 'orclWorkFlowNotificationPref',
45: p_value => l_notif_preference,
46: p_parameterlist => p_params);
47:
48: end populateRecord;
195: p_owner_tag => p_owner_tag,
196: p_description => p_description,
197: p_params => l_params );
198:
199: WF_EVENT.AddParameterToList(p_name => 'UPDATEONLY',
200: p_value => 'TRUE',
201: p_parameterlist => l_params);
202:
203:
200: p_value => 'TRUE',
201: p_parameterlist => l_params);
202:
203:
204: WF_EVENT.AddParameterToList(p_name => 'WFSYNCH_OVERWRITE',
205: p_value => 'TRUE',
206: p_parameterlist => l_params);
207:
208: WF_LOCAL_SYNCH.propagate_role(p_orig_system => p_orig_system,