DBA Data[Home] [Help]

APPS.GHR_PRH_BUS dependencies on GHR_PA_ROUTING_HISTORY

Line 38: (p_pa_request_id in ghr_pa_routing_history.pa_request_id%TYPE

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:

Line 39: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

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:

Line 40: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE

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

Line 73: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

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

Line 75: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE

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:

Line 76: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE

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

Line 106: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

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

Line 107: ,p_user_name in ghr_pa_routing_history.user_name%TYPE

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

Line 108: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE

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:

Line 109: ,P_object_version_number in ghr_pa_routing_history.object_version_number%TYPE

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

Line 140: (p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE

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:

Line 141: ,p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

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

Line 142: ,p_object_Version_number in ghr_pa_routing_history.object_version_number%TYPE

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

Line 174: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE

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

Line 175: ,p_routing_list_id in ghr_pa_routing_history.routing_list_id%TYPE

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

Line 176: ,p_routing_seq_number in ghr_pa_routing_history.routing_seq_number %TYPE

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

Line 177: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE

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