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: --
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;
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);
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
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: --
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;
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
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: --
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) ;
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;
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: --
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;
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';
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
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:
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: --
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;