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 383: (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE

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

Line 384: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

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

Line 385: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE

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

Line 467: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

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

Line 468: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE

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

Line 469: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number%TYPE

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

Line 470: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE

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