DBA Data[Home] [Help]

APPS.GHR_PDH_BUS dependencies on GHR_PD_ROUTING_HISTORY

Line 98: (p_position_description_id in ghr_pd_routing_history.position_description_id%TYPE

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

Line 99: ,p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE

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;

Line 100: ,p_object_Version_number in ghr_pd_routing_history.object_version_number%TYPE

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

Line 187: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE

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

Line 189: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE

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

Line 190: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE

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;

Line 274: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE

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

Line 275: ,p_user_name in ghr_pd_routing_history.user_name%TYPE

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

Line 276: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE

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

Line 277: ,P_object_version_number in ghr_pd_routing_history.object_version_number%TYPE

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;

Line 385: (p_routing_list_id in ghr_pd_routing_history.routing_list_id%TYPE

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

Line 386: ,p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE

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;

Line 387: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE

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

Line 469: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE

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

Line 470: ,p_routing_list_id in ghr_pd_routing_history.routing_list_id%TYPE

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:

Line 471: ,p_routing_seq_number in ghr_pd_routing_history.routing_seq_number%TYPE

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

Line 472: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE

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;