APPS.GHR_GROUPBOXES_AD_STM dependencies on GHR_API

Line 7: for i in 1..ghr_api.ghr_gbx_index loop

3: DECLARE
4: l_parms wf_parameter_list_t;
5: begin
6: -- construct attribute list --
7: for i in 1..ghr_api.ghr_gbx_index loop
8: wf_event.AddParameterToList('DELETE','TRUE', l_parms);
9:
10: wf_event.AddParameterToList('orclWFOrigSystem','GBX',l_parms);
11: wf_event.AddParameterToList('orclWFOrigSystemID',ghr_api.ghr_gbx_tab(i).groupbox_id,l_parms);

Line 11: wf_event.AddParameterToList('orclWFOrigSystemID',ghr_api.ghr_gbx_tab(i).groupbox_id,l_parms);

7: for i in 1..ghr_api.ghr_gbx_index loop
8: wf_event.AddParameterToList('DELETE','TRUE', l_parms);
9:
10: wf_event.AddParameterToList('orclWFOrigSystem','GBX',l_parms);
11: wf_event.AddParameterToList('orclWFOrigSystemID',ghr_api.ghr_gbx_tab(i).groupbox_id,l_parms);
12:
13: -- added to synchronize the wf_local_roles table
14: wf_local_synch.propagate_role
15: (p_orig_system => 'GBX',

Line 16: p_orig_system_id => ghr_api.ghr_gbx_tab(i).groupbox_id,

12:
13: -- added to synchronize the wf_local_roles table
14: wf_local_synch.propagate_role
15: (p_orig_system => 'GBX',
16: p_orig_system_id => ghr_api.ghr_gbx_tab(i).groupbox_id,
17: p_attributes => l_parms,
18: p_expiration_date => sysdate
19: );
20: end loop;

Line 21: ghr_api.ghr_gbx_index := 0;

17: p_attributes => l_parms,
18: p_expiration_date => sysdate
19: );
20: end loop;
21: ghr_api.ghr_gbx_index := 0;
22:
23: end GHR_GROUPBOXES_AD_STM;