APPS.GHR_API dependencies on GHR_PA_ROUTING_HISTORY

Line 3862: p_action_taken in ghr_pa_routing_history.action_taken%type,

3858: -- --------------------------------------------------------------------------
3859:
3860: Procedure call_workflow
3861: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3862: p_action_taken in ghr_pa_routing_history.action_taken%type,
3863: p_old_action_taken in ghr_pa_routing_history.action_taken%type default null,
3864: p_error in varchar2 default null
3865: )
3866: is

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

3859:
3860: Procedure call_workflow
3861: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3862: p_action_taken in ghr_pa_routing_history.action_taken%type,
3863: p_old_action_taken in ghr_pa_routing_history.action_taken%type default null,
3864: p_error in varchar2 default null
3865: )
3866: is
3867: --

Line 3869: l_pa_routing_history_rec ghr_pa_routing_history%rowtype;

3865: )
3866: is
3867: --
3868: l_proc varchar2(72) := 'Call_workflow';
3869: l_pa_routing_history_rec ghr_pa_routing_history%rowtype;
3870: l_forward_to_name ghr_pa_routing_history.user_name%type;
3871: l_cnt number;
3872: l_act_cnt number;
3873: l_groupbox_id number;

Line 3870: l_forward_to_name ghr_pa_routing_history.user_name%type;

3866: is
3867: --
3868: l_proc varchar2(72) := 'Call_workflow';
3869: l_pa_routing_history_rec ghr_pa_routing_history%rowtype;
3870: l_forward_to_name ghr_pa_routing_history.user_name%type;
3871: l_cnt number;
3872: l_act_cnt number;
3873: l_groupbox_id number;
3874: l_user_name ghr_pa_routing_history.user_name%type;

Line 3874: l_user_name ghr_pa_routing_history.user_name%type;

3870: l_forward_to_name ghr_pa_routing_history.user_name%type;
3871: l_cnt number;
3872: l_act_cnt number;
3873: l_groupbox_id number;
3874: l_user_name ghr_pa_routing_history.user_name%type;
3875: l_object_version_number ghr_pa_requests.object_version_number%type;
3876:
3877: Cursor c_par is
3878: select par.object_version_number

Line 3884: from ghr_pa_routing_history

3880: where par.pa_request_id = p_pa_request_id;
3881:
3882: Cursor c_routing_count is
3883: select count(*) cnt
3884: from ghr_pa_routing_history
3885: where pa_request_id = p_pa_request_id;
3886:
3887: Cursor c_routing_action is
3888: select count(1) act_cnt

Line 3889: from ghr_pa_routing_history

3885: where pa_request_id = p_pa_request_id;
3886:
3887: Cursor c_routing_action is
3888: select count(1) act_cnt
3889: from ghr_pa_routing_history
3890: where pa_request_id = p_pa_request_id
3891: and action_taken = 'INITIATED';
3892: /* Bug# 5634964. The existing code is like l_cnt =2 and l_cnt>2 are wrote without considering the action_taken
3893: of 'INITIATED'. When user routed to inbox there will be one record in the ghr_pa_routing_history table with

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

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

Line 3919: from ghr_pa_routing_history

3915: nature_of_action_id,
3916: noa_family_code,
3917: second_nature_of_action_id,
3918: object_version_number
3919: from ghr_pa_routing_history
3920: where pa_request_id = p_pa_request_id
3921: order by pa_routing_history_id desc;
3922:
3923: Cursor c_groupbox_name is