94: -- Access Status:
95: -- Internal Table Handler Use Only.
96: --
97: Procedure chk_position_description_id
98: (p_position_description_id in ghr_pd_routing_history.position_description_id%TYPE
99: ,p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
100: ,p_object_Version_number in ghr_pd_routing_history.object_version_number%TYPE
101: ) is
102: --
95: -- Internal Table Handler Use Only.
96: --
97: Procedure chk_position_description_id
98: (p_position_description_id in ghr_pd_routing_history.position_description_id%TYPE
99: ,p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
100: ,p_object_Version_number in ghr_pd_routing_history.object_version_number%TYPE
101: ) is
102: --
103: l_exists boolean := FALSE;
96: --
97: Procedure chk_position_description_id
98: (p_position_description_id in ghr_pd_routing_history.position_description_id%TYPE
99: ,p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
100: ,p_object_Version_number in ghr_pd_routing_history.object_version_number%TYPE
101: ) is
102: --
103: l_exists boolean := FALSE;
104: l_proc varchar2(72) := g_package||'chk_position_description_id';
183: -- Access Status:
184: -- Internal Table Handler Use Only.
185: --
186: procedure chk_groupbox_id
187: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
188: ,p_position_description_id in ghr_position_descriptions.position_description_id%TYPE
189: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE
190: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
191: )is
185: --
186: procedure chk_groupbox_id
187: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
188: ,p_position_description_id in ghr_position_descriptions.position_description_id%TYPE
189: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE
190: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
191: )is
192:
193: --
186: procedure chk_groupbox_id
187: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
188: ,p_position_description_id in ghr_position_descriptions.position_description_id%TYPE
189: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE
190: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
191: )is
192:
193: --
194: l_exists boolean := false;
270: -- Internal Table Handler Use Only.
271: --
272:
273: Procedure chk_user_name
274: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
275: ,p_user_name in ghr_pd_routing_history.user_name%TYPE
276: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE
277: ,P_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
278: ) is
271: --
272:
273: Procedure chk_user_name
274: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
275: ,p_user_name in ghr_pd_routing_history.user_name%TYPE
276: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE
277: ,P_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
278: ) is
279: --
272:
273: Procedure chk_user_name
274: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
275: ,p_user_name in ghr_pd_routing_history.user_name%TYPE
276: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE
277: ,P_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
278: ) is
279: --
280: l_proc varchar2(72) := g_package ||'chk_user_name';
273: Procedure chk_user_name
274: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
275: ,p_user_name in ghr_pd_routing_history.user_name%TYPE
276: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE
277: ,P_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
278: ) is
279: --
280: l_proc varchar2(72) := g_package ||'chk_user_name';
281: l_exists boolean := false;
381: -- Access Status:
382: -- Internal Table Handler Use Only.
383: --
384: Procedure chk_routing_list_id
385: (p_routing_list_id in ghr_pd_routing_history.routing_list_id%TYPE
386: ,p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
387: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
388: ) is
389: --
382: -- Internal Table Handler Use Only.
383: --
384: Procedure chk_routing_list_id
385: (p_routing_list_id in ghr_pd_routing_history.routing_list_id%TYPE
386: ,p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
387: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
388: ) is
389: --
390: l_exists boolean := false;
383: --
384: Procedure chk_routing_list_id
385: (p_routing_list_id in ghr_pd_routing_history.routing_list_id%TYPE
386: ,p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
387: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
388: ) is
389: --
390: l_exists boolean := false;
391: l_proc varchar2(72) := g_package||'chk_routing_list_id';
465: -- Access Status:
466: -- Internal Table Handler Use Only.
467: --
468: procedure chk_rout_user_sequ_numb
469: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
470: ,p_routing_list_id in ghr_pd_routing_history.routing_list_id%TYPE
471: ,p_routing_seq_number in ghr_pd_routing_history.routing_seq_number%TYPE
472: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
473: )is
466: -- Internal Table Handler Use Only.
467: --
468: procedure chk_rout_user_sequ_numb
469: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
470: ,p_routing_list_id in ghr_pd_routing_history.routing_list_id%TYPE
471: ,p_routing_seq_number in ghr_pd_routing_history.routing_seq_number%TYPE
472: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
473: )is
474:
467: --
468: procedure chk_rout_user_sequ_numb
469: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
470: ,p_routing_list_id in ghr_pd_routing_history.routing_list_id%TYPE
471: ,p_routing_seq_number in ghr_pd_routing_history.routing_seq_number%TYPE
472: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
473: )is
474:
475: --
468: procedure chk_rout_user_sequ_numb
469: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
470: ,p_routing_list_id in ghr_pd_routing_history.routing_list_id%TYPE
471: ,p_routing_seq_number in ghr_pd_routing_history.routing_seq_number%TYPE
472: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
473: )is
474:
475: --
476: l_exists boolean := FALSE;