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