APPS.GHR_API dependencies on GHR_PA_ROUTING_HISTORY

Line 3855: p_action_taken in ghr_pa_routing_history.action_taken%type,

3851: -- --------------------------------------------------------------------------
3852:
3853: Procedure call_workflow
3854: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3855: p_action_taken in ghr_pa_routing_history.action_taken%type,
3856: p_old_action_taken in ghr_pa_routing_history.action_taken%type default null,
3857: p_error in varchar2 default null
3858: )
3859: is

Line 3856: p_old_action_taken in ghr_pa_routing_history.action_taken%type default null,

3852:
3853: Procedure call_workflow
3854: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3855: p_action_taken in ghr_pa_routing_history.action_taken%type,
3856: p_old_action_taken in ghr_pa_routing_history.action_taken%type default null,
3857: p_error in varchar2 default null
3858: )
3859: is
3860: --

Line 3862: l_pa_routing_history_rec ghr_pa_routing_history%rowtype;

3858: )
3859: is
3860: --
3861: l_proc varchar2(72) := 'Call_workflow';
3862: l_pa_routing_history_rec ghr_pa_routing_history%rowtype;
3863: l_forward_to_name ghr_pa_routing_history.user_name%type;
3864: l_cnt number;
3865: l_act_cnt number;
3866: l_groupbox_id number;

Line 3863: l_forward_to_name ghr_pa_routing_history.user_name%type;

3859: is
3860: --
3861: l_proc varchar2(72) := 'Call_workflow';
3862: l_pa_routing_history_rec ghr_pa_routing_history%rowtype;
3863: l_forward_to_name ghr_pa_routing_history.user_name%type;
3864: l_cnt number;
3865: l_act_cnt number;
3866: l_groupbox_id number;
3867: l_user_name ghr_pa_routing_history.user_name%type;

Line 3867: l_user_name ghr_pa_routing_history.user_name%type;

3863: l_forward_to_name ghr_pa_routing_history.user_name%type;
3864: l_cnt number;
3865: l_act_cnt number;
3866: l_groupbox_id number;
3867: l_user_name ghr_pa_routing_history.user_name%type;
3868: l_object_version_number ghr_pa_requests.object_version_number%type;
3869:
3870: Cursor c_par is
3871: select par.object_version_number

Line 3877: from ghr_pa_routing_history

3873: where par.pa_request_id = p_pa_request_id;
3874:
3875: Cursor c_routing_count is
3876: select count(*) cnt
3877: from ghr_pa_routing_history
3878: where pa_request_id = p_pa_request_id;
3879:
3880: Cursor c_routing_action is
3881: select count(1) act_cnt

Line 3882: from ghr_pa_routing_history

3878: where pa_request_id = p_pa_request_id;
3879:
3880: Cursor c_routing_action is
3881: select count(1) act_cnt
3882: from ghr_pa_routing_history
3883: where pa_request_id = p_pa_request_id
3884: and action_taken = 'INITIATED';
3885: /* Bug# 5634964. The existing code is like l_cnt =2 and l_cnt>2 are wrote without considering the action_taken
3886: of 'INITIATED'. When user routed to inbox there will be one record in the ghr_pa_routing_history table with

Line 3886: of 'INITIATED'. When user routed to inbox there will be one record in the ghr_pa_routing_history table with

3882: from ghr_pa_routing_history
3883: where pa_request_id = p_pa_request_id
3884: and action_taken = 'INITIATED';
3885: /* Bug# 5634964. The existing code is like l_cnt =2 and l_cnt>2 are wrote without considering the action_taken
3886: of 'INITIATED'. When user routed to inbox there will be one record in the ghr_pa_routing_history table with
3887: action_taken as 'INTIATED'. To work existing code for INITIATED actoons, added the above cursor*/
3888:
3889: Cursor c_forwarding_name is
3890: select pa_routing_history_id,

Line 3912: from ghr_pa_routing_history

3908: nature_of_action_id,
3909: noa_family_code,
3910: second_nature_of_action_id,
3911: object_version_number
3912: from ghr_pa_routing_history
3913: where pa_request_id = p_pa_request_id
3914: order by pa_routing_history_id desc;
3915:
3916: Cursor c_groupbox_name is