DBA Data[Home] [Help]

APPS.GHR_PRH_BUS dependencies on GHR_PA_ROUTING_HISTORY

Line 100: (p_pa_request_id in ghr_pa_routing_history.pa_request_id%TYPE

96: -- Access Status:
97: -- Internal Table Handler Use Only.
98: --
99: Procedure chk_pa_request_id
100: (p_pa_request_id in ghr_pa_routing_history.pa_request_id%TYPE
101: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
102: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
103: ) is
104: --

Line 101: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

97: -- Internal Table Handler Use Only.
98: --
99: Procedure chk_pa_request_id
100: (p_pa_request_id in ghr_pa_routing_history.pa_request_id%TYPE
101: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
102: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
103: ) is
104: --
105: l_exists boolean := FALSE;

Line 102: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE

98: --
99: Procedure chk_pa_request_id
100: (p_pa_request_id in ghr_pa_routing_history.pa_request_id%TYPE
101: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
102: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
103: ) is
104: --
105: l_exists boolean := FALSE;
106: l_proc varchar2(72);

Line 190: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

186: -- Access Status:
187: -- Internal Table Handler Use Only.
188: --
189: procedure chk_groupbox_id
190: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
191: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
192: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
193: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
194: )is

Line 192: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE

188: --
189: procedure chk_groupbox_id
190: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
191: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
192: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
193: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
194: )is
195:
196: --

Line 193: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE

189: procedure chk_groupbox_id
190: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
191: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
192: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
193: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
194: )is
195:
196: --
197: l_exists boolean := false;

Line 282: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

278: -- Internal Table Handler Use Only.
279: --
280:
281: Procedure chk_user_name
282: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
283: ,p_user_name in ghr_pa_routing_history.user_name%TYPE
284: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
285: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
286: ) is

Line 283: ,p_user_name in ghr_pa_routing_history.user_name%TYPE

279: --
280:
281: Procedure chk_user_name
282: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
283: ,p_user_name in ghr_pa_routing_history.user_name%TYPE
284: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
285: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
286: ) is
287: --

Line 284: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE

280:
281: Procedure chk_user_name
282: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
283: ,p_user_name in ghr_pa_routing_history.user_name%TYPE
284: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
285: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
286: ) is
287: --
288: l_proc varchar2(72) ;

Line 285: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE

281: Procedure chk_user_name
282: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
283: ,p_user_name in ghr_pa_routing_history.user_name%TYPE
284: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
285: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
286: ) is
287: --
288: l_proc varchar2(72) ;
289: l_exists boolean := false;

Line 386: (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE

382: -- Access Status:
383: -- Internal Table Handler Use Only.
384: --
385: Procedure chk_routing_list_id
386: (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
387: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
388: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
389: ) is
390: --

Line 387: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

383: -- Internal Table Handler Use Only.
384: --
385: Procedure chk_routing_list_id
386: (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
387: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
388: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
389: ) is
390: --
391: l_exists boolean := false;

Line 388: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE

384: --
385: Procedure chk_routing_list_id
386: (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
387: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
388: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
389: ) is
390: --
391: l_exists boolean := false;
392: l_proc varchar2(72) := g_package||'chk_routing_list_id';

Line 470: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

466: -- Access Status:
467: -- Internal Table Handler Use Only.
468: --
469: procedure chk_rout_user_sequ_numb
470: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
471: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
472: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number%TYPE
473: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
474: )is

Line 471: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE

467: -- Internal Table Handler Use Only.
468: --
469: procedure chk_rout_user_sequ_numb
470: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
471: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
472: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number%TYPE
473: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
474: )is
475:

Line 472: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number%TYPE

468: --
469: procedure chk_rout_user_sequ_numb
470: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
471: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
472: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number%TYPE
473: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
474: )is
475:
476: --

Line 473: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE

469: procedure chk_rout_user_sequ_numb
470: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
471: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
472: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number%TYPE
473: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
474: )is
475:
476: --
477: l_exists boolean := FALSE;