18: end loop;
19:
20: for i in 1..ghr_api.ghr_gbx_index loop
21:
22: wf_event.AddParameterToList('USER_NAME',ghr_api.ghr_gbx_tab(i).name,l_parms);
23: wf_event.AddParameterToList('DisplayName', ghr_api.ghr_gbx_tab(i).display_name, l_parms);
24: wf_event.AddParameterToList('description', ghr_api.ghr_gbx_tab(i).description, l_parms);
25: wf_event.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_parms);
26: wf_event.AddParameterToList('preferredLanguage', l_language, l_parms);
19:
20: for i in 1..ghr_api.ghr_gbx_index loop
21:
22: wf_event.AddParameterToList('USER_NAME',ghr_api.ghr_gbx_tab(i).name,l_parms);
23: wf_event.AddParameterToList('DisplayName', ghr_api.ghr_gbx_tab(i).display_name, l_parms);
24: wf_event.AddParameterToList('description', ghr_api.ghr_gbx_tab(i).description, l_parms);
25: wf_event.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_parms);
26: wf_event.AddParameterToList('preferredLanguage', l_language, l_parms);
27: wf_event.AddParameterToList('orclNLSTerritory', l_territory,l_parms);
20: for i in 1..ghr_api.ghr_gbx_index loop
21:
22: wf_event.AddParameterToList('USER_NAME',ghr_api.ghr_gbx_tab(i).name,l_parms);
23: wf_event.AddParameterToList('DisplayName', ghr_api.ghr_gbx_tab(i).display_name, l_parms);
24: wf_event.AddParameterToList('description', ghr_api.ghr_gbx_tab(i).description, l_parms);
25: wf_event.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_parms);
26: wf_event.AddParameterToList('preferredLanguage', l_language, l_parms);
27: wf_event.AddParameterToList('orclNLSTerritory', l_territory,l_parms);
28: wf_event.AddParameterToList('mail',null,l_parms);
21:
22: wf_event.AddParameterToList('USER_NAME',ghr_api.ghr_gbx_tab(i).name,l_parms);
23: wf_event.AddParameterToList('DisplayName', ghr_api.ghr_gbx_tab(i).display_name, l_parms);
24: wf_event.AddParameterToList('description', ghr_api.ghr_gbx_tab(i).description, l_parms);
25: wf_event.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_parms);
26: wf_event.AddParameterToList('preferredLanguage', l_language, l_parms);
27: wf_event.AddParameterToList('orclNLSTerritory', l_territory,l_parms);
28: wf_event.AddParameterToList('mail',null,l_parms);
29: wf_event.AddParameterToList('FacsimileTelephoneNumber',null,l_parms);
22: wf_event.AddParameterToList('USER_NAME',ghr_api.ghr_gbx_tab(i).name,l_parms);
23: wf_event.AddParameterToList('DisplayName', ghr_api.ghr_gbx_tab(i).display_name, l_parms);
24: wf_event.AddParameterToList('description', ghr_api.ghr_gbx_tab(i).description, l_parms);
25: wf_event.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_parms);
26: wf_event.AddParameterToList('preferredLanguage', l_language, l_parms);
27: wf_event.AddParameterToList('orclNLSTerritory', l_territory,l_parms);
28: wf_event.AddParameterToList('mail',null,l_parms);
29: wf_event.AddParameterToList('FacsimileTelephoneNumber',null,l_parms);
30: wf_event.AddParameterToList('orclIsEnabled','ACTIVE',l_parms);
23: wf_event.AddParameterToList('DisplayName', ghr_api.ghr_gbx_tab(i).display_name, l_parms);
24: wf_event.AddParameterToList('description', ghr_api.ghr_gbx_tab(i).description, l_parms);
25: wf_event.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_parms);
26: wf_event.AddParameterToList('preferredLanguage', l_language, l_parms);
27: wf_event.AddParameterToList('orclNLSTerritory', l_territory,l_parms);
28: wf_event.AddParameterToList('mail',null,l_parms);
29: wf_event.AddParameterToList('FacsimileTelephoneNumber',null,l_parms);
30: wf_event.AddParameterToList('orclIsEnabled','ACTIVE',l_parms);
31: wf_event.AddParameterToList('ExpirationDate',null,l_parms);
24: wf_event.AddParameterToList('description', ghr_api.ghr_gbx_tab(i).description, l_parms);
25: wf_event.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_parms);
26: wf_event.AddParameterToList('preferredLanguage', l_language, l_parms);
27: wf_event.AddParameterToList('orclNLSTerritory', l_territory,l_parms);
28: wf_event.AddParameterToList('mail',null,l_parms);
29: wf_event.AddParameterToList('FacsimileTelephoneNumber',null,l_parms);
30: wf_event.AddParameterToList('orclIsEnabled','ACTIVE',l_parms);
31: wf_event.AddParameterToList('ExpirationDate',null,l_parms);
32: wf_event.AddParameterToList('orclWFOrigSystem','GBX',l_parms);
25: wf_event.AddParameterToList('orclWorkFlowNotificationPref', 'QUERY', l_parms);
26: wf_event.AddParameterToList('preferredLanguage', l_language, l_parms);
27: wf_event.AddParameterToList('orclNLSTerritory', l_territory,l_parms);
28: wf_event.AddParameterToList('mail',null,l_parms);
29: wf_event.AddParameterToList('FacsimileTelephoneNumber',null,l_parms);
30: wf_event.AddParameterToList('orclIsEnabled','ACTIVE',l_parms);
31: wf_event.AddParameterToList('ExpirationDate',null,l_parms);
32: wf_event.AddParameterToList('orclWFOrigSystem','GBX',l_parms);
33: wf_event.AddParameterToList('orclWFOrigSystemID',ghr_api.ghr_gbx_tab(i).groupbox_id,l_parms);
26: wf_event.AddParameterToList('preferredLanguage', l_language, l_parms);
27: wf_event.AddParameterToList('orclNLSTerritory', l_territory,l_parms);
28: wf_event.AddParameterToList('mail',null,l_parms);
29: wf_event.AddParameterToList('FacsimileTelephoneNumber',null,l_parms);
30: wf_event.AddParameterToList('orclIsEnabled','ACTIVE',l_parms);
31: wf_event.AddParameterToList('ExpirationDate',null,l_parms);
32: wf_event.AddParameterToList('orclWFOrigSystem','GBX',l_parms);
33: wf_event.AddParameterToList('orclWFOrigSystemID',ghr_api.ghr_gbx_tab(i).groupbox_id,l_parms);
34:
27: wf_event.AddParameterToList('orclNLSTerritory', l_territory,l_parms);
28: wf_event.AddParameterToList('mail',null,l_parms);
29: wf_event.AddParameterToList('FacsimileTelephoneNumber',null,l_parms);
30: wf_event.AddParameterToList('orclIsEnabled','ACTIVE',l_parms);
31: wf_event.AddParameterToList('ExpirationDate',null,l_parms);
32: wf_event.AddParameterToList('orclWFOrigSystem','GBX',l_parms);
33: wf_event.AddParameterToList('orclWFOrigSystemID',ghr_api.ghr_gbx_tab(i).groupbox_id,l_parms);
34:
35: wf_local_synch.propagate_role
28: wf_event.AddParameterToList('mail',null,l_parms);
29: wf_event.AddParameterToList('FacsimileTelephoneNumber',null,l_parms);
30: wf_event.AddParameterToList('orclIsEnabled','ACTIVE',l_parms);
31: wf_event.AddParameterToList('ExpirationDate',null,l_parms);
32: wf_event.AddParameterToList('orclWFOrigSystem','GBX',l_parms);
33: wf_event.AddParameterToList('orclWFOrigSystemID',ghr_api.ghr_gbx_tab(i).groupbox_id,l_parms);
34:
35: wf_local_synch.propagate_role
36: (p_orig_system => 'GBX',
29: wf_event.AddParameterToList('FacsimileTelephoneNumber',null,l_parms);
30: wf_event.AddParameterToList('orclIsEnabled','ACTIVE',l_parms);
31: wf_event.AddParameterToList('ExpirationDate',null,l_parms);
32: wf_event.AddParameterToList('orclWFOrigSystem','GBX',l_parms);
33: wf_event.AddParameterToList('orclWFOrigSystemID',ghr_api.ghr_gbx_tab(i).groupbox_id,l_parms);
34:
35: wf_local_synch.propagate_role
36: (p_orig_system => 'GBX',
37: p_orig_system_id => ghr_api.ghr_gbx_tab(i).groupbox_id,