eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RHT_UPD dependencies on PQH_RHT_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_rht_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_rht_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 95: pqh_rht_shd.constraint_error

91: --
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: pqh_rht_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: pqh_rht_shd.constraint_error

Line 99: pqh_rht_shd.constraint_error

95: pqh_rht_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: pqh_rht_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: pqh_rht_shd.constraint_error

Line 103: pqh_rht_shd.constraint_error

99: pqh_rht_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: pqh_rht_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: Raise;
107: End update_dml;

Line 141: Procedure pre_update(p_rec in pqh_rht_shd.g_rec_type) is

137: -- Internal Row Handler Use Only.
138: --
139: -- {End Of Comments}
140: -- ----------------------------------------------------------------------------
141: Procedure pre_update(p_rec in pqh_rht_shd.g_rec_type) is
142: --
143: l_proc varchar2(72) := g_package||'pre_update';
144: --
145: Begin

Line 184: p_effective_date in date,p_rec in pqh_rht_shd.g_rec_type) is

180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure post_update(
184: p_effective_date in date,p_rec in pqh_rht_shd.g_rec_type) is
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --
188: Begin

Line 222: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd

218: ,p_to_range_name =>p_rec.to_range_name
219: ,p_list_range_name =>p_rec.list_range_name
220: ,p_object_version_number =>p_rec.object_version_number
221: ,p_effective_date =>p_effective_date
222: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
223: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
224: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
225: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id

Line 223: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments

219: ,p_list_range_name =>p_rec.list_range_name
220: ,p_object_version_number =>p_rec.object_version_number
221: ,p_effective_date =>p_effective_date
222: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
223: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
224: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
225: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id

Line 224: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id

220: ,p_object_version_number =>p_rec.object_version_number
221: ,p_effective_date =>p_effective_date
222: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
223: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
224: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
225: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id

Line 225: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id

221: ,p_effective_date =>p_effective_date
222: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
223: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
224: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
225: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id

Line 226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id

222: ,p_approval_cd_o =>pqh_rht_shd.g_old_rec.approval_cd
223: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
224: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
225: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id

Line 227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id

223: ,p_comments_o =>pqh_rht_shd.g_old_rec.comments
224: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
225: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id

Line 228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id

224: ,p_forwarded_by_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_assignment_id
225: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id

Line 229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id

225: ,p_forwarded_by_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_member_id
226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id

Line 230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id

226: ,p_forwarded_by_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_position_id
227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date

Line 231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id

227: ,p_forwarded_by_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_user_id
228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id

Line 232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id

228: ,p_forwarded_by_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_by_role_id
229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id

Line 233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id

229: ,p_forwarded_to_assignment_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_assignment_id
230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id

Line 234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date

230: ,p_forwarded_to_member_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_member_id
231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id

Line 235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id

231: ,p_forwarded_to_position_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_position_id
232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd

Line 236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id

232: ,p_forwarded_to_user_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_user_id
233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
240: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name

Line 237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id

233: ,p_forwarded_to_role_id_o =>pqh_rht_shd.g_old_rec.forwarded_to_role_id
234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
240: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
241: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name

Line 238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id

234: ,p_notification_date_o =>pqh_rht_shd.g_old_rec.notification_date
235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
240: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
241: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
242: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name

Line 239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd

235: ,p_pos_structure_version_id_o =>pqh_rht_shd.g_old_rec.pos_structure_version_id
236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
240: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
241: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
242: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
243: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number

Line 240: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name

236: ,p_routing_category_id_o =>pqh_rht_shd.g_old_rec.routing_category_id
237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
240: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
241: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
242: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
243: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number
244: );

Line 241: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name

237: ,p_transaction_category_id_o =>pqh_rht_shd.g_old_rec.transaction_category_id
238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
240: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
241: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
242: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
243: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number
244: );
245: --

Line 242: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name

238: ,p_transaction_id_o =>pqh_rht_shd.g_old_rec.transaction_id
239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
240: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
241: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
242: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
243: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number
244: );
245: --
246: exception

Line 243: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number

239: ,p_user_action_cd_o =>pqh_rht_shd.g_old_rec.user_action_cd
240: ,p_from_range_name_o =>pqh_rht_shd.g_old_rec.from_range_name
241: ,p_to_range_name_o =>pqh_rht_shd.g_old_rec.to_range_name
242: ,p_list_range_name_o =>pqh_rht_shd.g_old_rec.list_range_name
243: ,p_object_version_number_o =>pqh_rht_shd.g_old_rec.object_version_number
244: );
245: --
246: exception
247: --

Line 305: Procedure convert_defs(p_rec in out nocopy pqh_rht_shd.g_rec_type) is

301: -- Internal Row Handler Use Only.
302: --
303: -- {End Of Comments}
304: -- ----------------------------------------------------------------------------
305: Procedure convert_defs(p_rec in out nocopy pqh_rht_shd.g_rec_type) is
306: --
307: l_proc varchar2(72) := g_package||'convert_defs';
308: --
309: Begin

Line 320: pqh_rht_shd.g_old_rec.approval_cd;

316: -- is being used then we must set to the 'current' argument value.
317: --
318: If (p_rec.approval_cd = hr_api.g_varchar2) then
319: p_rec.approval_cd :=
320: pqh_rht_shd.g_old_rec.approval_cd;
321: End If;
322: If (p_rec.comments = hr_api.g_varchar2) then
323: p_rec.comments :=
324: pqh_rht_shd.g_old_rec.comments;

Line 324: pqh_rht_shd.g_old_rec.comments;

320: pqh_rht_shd.g_old_rec.approval_cd;
321: End If;
322: If (p_rec.comments = hr_api.g_varchar2) then
323: p_rec.comments :=
324: pqh_rht_shd.g_old_rec.comments;
325: End If;
326: If (p_rec.forwarded_by_assignment_id = hr_api.g_number) then
327: p_rec.forwarded_by_assignment_id :=
328: pqh_rht_shd.g_old_rec.forwarded_by_assignment_id;

Line 328: pqh_rht_shd.g_old_rec.forwarded_by_assignment_id;

324: pqh_rht_shd.g_old_rec.comments;
325: End If;
326: If (p_rec.forwarded_by_assignment_id = hr_api.g_number) then
327: p_rec.forwarded_by_assignment_id :=
328: pqh_rht_shd.g_old_rec.forwarded_by_assignment_id;
329: End If;
330: If (p_rec.forwarded_by_member_id = hr_api.g_number) then
331: p_rec.forwarded_by_member_id :=
332: pqh_rht_shd.g_old_rec.forwarded_by_member_id;

Line 332: pqh_rht_shd.g_old_rec.forwarded_by_member_id;

328: pqh_rht_shd.g_old_rec.forwarded_by_assignment_id;
329: End If;
330: If (p_rec.forwarded_by_member_id = hr_api.g_number) then
331: p_rec.forwarded_by_member_id :=
332: pqh_rht_shd.g_old_rec.forwarded_by_member_id;
333: End If;
334: If (p_rec.forwarded_by_position_id = hr_api.g_number) then
335: p_rec.forwarded_by_position_id :=
336: pqh_rht_shd.g_old_rec.forwarded_by_position_id;

Line 336: pqh_rht_shd.g_old_rec.forwarded_by_position_id;

332: pqh_rht_shd.g_old_rec.forwarded_by_member_id;
333: End If;
334: If (p_rec.forwarded_by_position_id = hr_api.g_number) then
335: p_rec.forwarded_by_position_id :=
336: pqh_rht_shd.g_old_rec.forwarded_by_position_id;
337: End If;
338: If (p_rec.forwarded_by_user_id = hr_api.g_number) then
339: p_rec.forwarded_by_user_id :=
340: pqh_rht_shd.g_old_rec.forwarded_by_user_id;

Line 340: pqh_rht_shd.g_old_rec.forwarded_by_user_id;

336: pqh_rht_shd.g_old_rec.forwarded_by_position_id;
337: End If;
338: If (p_rec.forwarded_by_user_id = hr_api.g_number) then
339: p_rec.forwarded_by_user_id :=
340: pqh_rht_shd.g_old_rec.forwarded_by_user_id;
341: End If;
342: If (p_rec.forwarded_by_role_id = hr_api.g_number) then
343: p_rec.forwarded_by_role_id :=
344: pqh_rht_shd.g_old_rec.forwarded_by_role_id;

Line 344: pqh_rht_shd.g_old_rec.forwarded_by_role_id;

340: pqh_rht_shd.g_old_rec.forwarded_by_user_id;
341: End If;
342: If (p_rec.forwarded_by_role_id = hr_api.g_number) then
343: p_rec.forwarded_by_role_id :=
344: pqh_rht_shd.g_old_rec.forwarded_by_role_id;
345: End If;
346: If (p_rec.forwarded_to_assignment_id = hr_api.g_number) then
347: p_rec.forwarded_to_assignment_id :=
348: pqh_rht_shd.g_old_rec.forwarded_to_assignment_id;

Line 348: pqh_rht_shd.g_old_rec.forwarded_to_assignment_id;

344: pqh_rht_shd.g_old_rec.forwarded_by_role_id;
345: End If;
346: If (p_rec.forwarded_to_assignment_id = hr_api.g_number) then
347: p_rec.forwarded_to_assignment_id :=
348: pqh_rht_shd.g_old_rec.forwarded_to_assignment_id;
349: End If;
350: If (p_rec.forwarded_to_member_id = hr_api.g_number) then
351: p_rec.forwarded_to_member_id :=
352: pqh_rht_shd.g_old_rec.forwarded_to_member_id;

Line 352: pqh_rht_shd.g_old_rec.forwarded_to_member_id;

348: pqh_rht_shd.g_old_rec.forwarded_to_assignment_id;
349: End If;
350: If (p_rec.forwarded_to_member_id = hr_api.g_number) then
351: p_rec.forwarded_to_member_id :=
352: pqh_rht_shd.g_old_rec.forwarded_to_member_id;
353: End If;
354: If (p_rec.forwarded_to_position_id = hr_api.g_number) then
355: p_rec.forwarded_to_position_id :=
356: pqh_rht_shd.g_old_rec.forwarded_to_position_id;

Line 356: pqh_rht_shd.g_old_rec.forwarded_to_position_id;

352: pqh_rht_shd.g_old_rec.forwarded_to_member_id;
353: End If;
354: If (p_rec.forwarded_to_position_id = hr_api.g_number) then
355: p_rec.forwarded_to_position_id :=
356: pqh_rht_shd.g_old_rec.forwarded_to_position_id;
357: End If;
358: If (p_rec.forwarded_to_user_id = hr_api.g_number) then
359: p_rec.forwarded_to_user_id :=
360: pqh_rht_shd.g_old_rec.forwarded_to_user_id;

Line 360: pqh_rht_shd.g_old_rec.forwarded_to_user_id;

356: pqh_rht_shd.g_old_rec.forwarded_to_position_id;
357: End If;
358: If (p_rec.forwarded_to_user_id = hr_api.g_number) then
359: p_rec.forwarded_to_user_id :=
360: pqh_rht_shd.g_old_rec.forwarded_to_user_id;
361: End If;
362: If (p_rec.forwarded_to_role_id = hr_api.g_number) then
363: p_rec.forwarded_to_role_id :=
364: pqh_rht_shd.g_old_rec.forwarded_to_role_id;

Line 364: pqh_rht_shd.g_old_rec.forwarded_to_role_id;

360: pqh_rht_shd.g_old_rec.forwarded_to_user_id;
361: End If;
362: If (p_rec.forwarded_to_role_id = hr_api.g_number) then
363: p_rec.forwarded_to_role_id :=
364: pqh_rht_shd.g_old_rec.forwarded_to_role_id;
365: End If;
366: If (p_rec.notification_date = hr_api.g_date) then
367: p_rec.notification_date :=
368: pqh_rht_shd.g_old_rec.notification_date;

Line 368: pqh_rht_shd.g_old_rec.notification_date;

364: pqh_rht_shd.g_old_rec.forwarded_to_role_id;
365: End If;
366: If (p_rec.notification_date = hr_api.g_date) then
367: p_rec.notification_date :=
368: pqh_rht_shd.g_old_rec.notification_date;
369: End If;
370: If (p_rec.pos_structure_version_id = hr_api.g_number) then
371: p_rec.pos_structure_version_id :=
372: pqh_rht_shd.g_old_rec.pos_structure_version_id;

Line 372: pqh_rht_shd.g_old_rec.pos_structure_version_id;

368: pqh_rht_shd.g_old_rec.notification_date;
369: End If;
370: If (p_rec.pos_structure_version_id = hr_api.g_number) then
371: p_rec.pos_structure_version_id :=
372: pqh_rht_shd.g_old_rec.pos_structure_version_id;
373: End If;
374: If (p_rec.routing_category_id = hr_api.g_number) then
375: p_rec.routing_category_id :=
376: pqh_rht_shd.g_old_rec.routing_category_id;

Line 376: pqh_rht_shd.g_old_rec.routing_category_id;

372: pqh_rht_shd.g_old_rec.pos_structure_version_id;
373: End If;
374: If (p_rec.routing_category_id = hr_api.g_number) then
375: p_rec.routing_category_id :=
376: pqh_rht_shd.g_old_rec.routing_category_id;
377: End If;
378: If (p_rec.transaction_category_id = hr_api.g_number) then
379: p_rec.transaction_category_id :=
380: pqh_rht_shd.g_old_rec.transaction_category_id;

Line 380: pqh_rht_shd.g_old_rec.transaction_category_id;

376: pqh_rht_shd.g_old_rec.routing_category_id;
377: End If;
378: If (p_rec.transaction_category_id = hr_api.g_number) then
379: p_rec.transaction_category_id :=
380: pqh_rht_shd.g_old_rec.transaction_category_id;
381: End If;
382: If (p_rec.transaction_id = hr_api.g_number) then
383: p_rec.transaction_id :=
384: pqh_rht_shd.g_old_rec.transaction_id;

Line 384: pqh_rht_shd.g_old_rec.transaction_id;

380: pqh_rht_shd.g_old_rec.transaction_category_id;
381: End If;
382: If (p_rec.transaction_id = hr_api.g_number) then
383: p_rec.transaction_id :=
384: pqh_rht_shd.g_old_rec.transaction_id;
385: End If;
386: If (p_rec.user_action_cd = hr_api.g_varchar2) then
387: p_rec.user_action_cd :=
388: pqh_rht_shd.g_old_rec.user_action_cd;

Line 388: pqh_rht_shd.g_old_rec.user_action_cd;

384: pqh_rht_shd.g_old_rec.transaction_id;
385: End If;
386: If (p_rec.user_action_cd = hr_api.g_varchar2) then
387: p_rec.user_action_cd :=
388: pqh_rht_shd.g_old_rec.user_action_cd;
389: End If;
390: If (p_rec.from_range_name = hr_api.g_varchar2) then
391: p_rec.from_range_name :=
392: pqh_rht_shd.g_old_rec.from_range_name;

Line 392: pqh_rht_shd.g_old_rec.from_range_name;

388: pqh_rht_shd.g_old_rec.user_action_cd;
389: End If;
390: If (p_rec.from_range_name = hr_api.g_varchar2) then
391: p_rec.from_range_name :=
392: pqh_rht_shd.g_old_rec.from_range_name;
393: End If;
394: If (p_rec.to_range_name = hr_api.g_varchar2) then
395: p_rec.to_range_name :=
396: pqh_rht_shd.g_old_rec.to_range_name;

Line 396: pqh_rht_shd.g_old_rec.to_range_name;

392: pqh_rht_shd.g_old_rec.from_range_name;
393: End If;
394: If (p_rec.to_range_name = hr_api.g_varchar2) then
395: p_rec.to_range_name :=
396: pqh_rht_shd.g_old_rec.to_range_name;
397: End If;
398: If (p_rec.list_range_name = hr_api.g_varchar2) then
399: p_rec.list_range_name :=
400: pqh_rht_shd.g_old_rec.list_range_name;

Line 400: pqh_rht_shd.g_old_rec.list_range_name;

396: pqh_rht_shd.g_old_rec.to_range_name;
397: End If;
398: If (p_rec.list_range_name = hr_api.g_varchar2) then
399: p_rec.list_range_name :=
400: pqh_rht_shd.g_old_rec.list_range_name;
401: End If;
402:
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 414: p_rec in out nocopy pqh_rht_shd.g_rec_type

410: -- ----------------------------------------------------------------------------
411: Procedure upd
412: (
413: p_effective_date in date,
414: p_rec in out nocopy pqh_rht_shd.g_rec_type
415: ) is
416: --
417: l_proc varchar2(72) := g_package||'upd';
418: --

Line 424: pqh_rht_shd.lck

420: hr_utility.set_location('Entering:'||l_proc, 5);
421: --
422: -- We must lock the row which we need to update.
423: --
424: pqh_rht_shd.lck
425: (
426: p_rec.routing_history_id,
427: p_rec.object_version_number
428: );

Line 485: l_rec pqh_rht_shd.g_rec_type;

481: p_list_range_name in varchar2 default hr_api.g_varchar2,
482: p_object_version_number in out nocopy number
483: ) is
484: --
485: l_rec pqh_rht_shd.g_rec_type;
486: l_proc varchar2(72) := g_package||'upd';
487: --
488: Begin
489: hr_utility.set_location('Entering:'||l_proc, 5);

Line 495: pqh_rht_shd.convert_args

491: -- Call conversion function to turn arguments into the
492: -- l_rec structure.
493: --
494: l_rec :=
495: pqh_rht_shd.convert_args
496: (
497: p_routing_history_id,
498: p_approval_cd,
499: p_comments,