34: -- Internal Table Handler Use Only.
35: --
36:
37: Procedure chk_pa_request_id
38: (p_pa_request_id in ghr_pa_routing_history.pa_request_id%TYPE
39: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
40: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
41: );
42:
35: --
36:
37: Procedure chk_pa_request_id
38: (p_pa_request_id in ghr_pa_routing_history.pa_request_id%TYPE
39: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
40: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
41: );
42:
43:
36:
37: Procedure chk_pa_request_id
38: (p_pa_request_id in ghr_pa_routing_history.pa_request_id%TYPE
39: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
40: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
41: );
42:
43:
44: --
69: -- Access Status:
70: -- Internal Table Handler Use Only.
71: --
72: procedure chk_groupbox_id
73: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
74: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
75: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
76: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
77: );
71: --
72: procedure chk_groupbox_id
73: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
74: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
75: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
76: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
77: );
78:
79:
72: procedure chk_groupbox_id
73: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
74: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
75: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
76: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
77: );
78:
79:
80: -- ----------------------------------------------------------------------------
102: -- Internal Table Handler Use Only.
103: --
104:
105: Procedure chk_user_name
106: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
107: ,p_user_name in ghr_pa_routing_history.user_name%TYPE
108: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
109: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
110: );
103: --
104:
105: Procedure chk_user_name
106: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
107: ,p_user_name in ghr_pa_routing_history.user_name%TYPE
108: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
109: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
110: );
111: --
104:
105: Procedure chk_user_name
106: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
107: ,p_user_name in ghr_pa_routing_history.user_name%TYPE
108: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
109: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
110: );
111: --
112:
105: Procedure chk_user_name
106: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
107: ,p_user_name in ghr_pa_routing_history.user_name%TYPE
108: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
109: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
110: );
111: --
112:
113: -- ---------------------------------------------------------------------------
136: -- Internal Table Handler Use Only.
137: --
138:
139: Procedure chk_routing_list_id
140: (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
141: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
142: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
143: );
144:
137: --
138:
139: Procedure chk_routing_list_id
140: (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
141: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
142: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
143: );
144:
145: -- -- ----------------------------------------------------------------------------
138:
139: Procedure chk_routing_list_id
140: (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
141: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
142: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE
143: );
144:
145: -- -- ----------------------------------------------------------------------------
146: -- |---------------------------< chk_rout_user_sequ_numb>----------------------------|
170: -- Access Status:
171: -- Internal Table Handler Use Only.
172: --
173: procedure chk_rout_user_sequ_numb
174: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
175: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
176: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number %TYPE
177: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
178: );
171: -- Internal Table Handler Use Only.
172: --
173: procedure chk_rout_user_sequ_numb
174: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
175: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
176: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number %TYPE
177: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
178: );
179: --
172: --
173: procedure chk_rout_user_sequ_numb
174: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
175: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
176: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number %TYPE
177: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
178: );
179: --
180: --
173: procedure chk_rout_user_sequ_numb
174: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
175: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE
176: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number %TYPE
177: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
178: );
179: --
180: --
181: -- ----------------------------------------------------------------------------