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_FYN_DEL dependencies on PQH_FYN_SHD

Line 45: Procedure delete_dml(p_rec in pqh_fyn_shd.g_rec_type) is

41: -- Internal Row Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in pqh_fyn_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 64: pqh_fyn_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_fyn_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
67: Raise;
68: End delete_dml;

Line 102: Procedure pre_delete(p_rec in pqh_fyn_shd.g_rec_type) is

98: -- Internal Row Handler Use Only.
99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure pre_delete(p_rec in pqh_fyn_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin

Line 145: p_effective_date in date,p_rec in pqh_fyn_shd.g_rec_type) is

141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure post_delete(
145: p_effective_date in date,p_rec in pqh_fyn_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'post_delete';
148: --
149: Begin

Line 160: ,p_transaction_category_id_o =>pqh_fyn_shd.g_old_rec.transaction_category_id

156: --
157: pqh_fyn_rkd.after_delete
158: (
159: p_fyi_notified_id =>p_rec.fyi_notified_id
160: ,p_transaction_category_id_o =>pqh_fyn_shd.g_old_rec.transaction_category_id
161: ,p_transaction_id_o =>pqh_fyn_shd.g_old_rec.transaction_id
162: ,p_notification_event_cd_o =>pqh_fyn_shd.g_old_rec.notification_event_cd
163: ,p_notified_type_cd_o =>pqh_fyn_shd.g_old_rec.notified_type_cd
164: ,p_notified_name_o =>pqh_fyn_shd.g_old_rec.notified_name

Line 161: ,p_transaction_id_o =>pqh_fyn_shd.g_old_rec.transaction_id

157: pqh_fyn_rkd.after_delete
158: (
159: p_fyi_notified_id =>p_rec.fyi_notified_id
160: ,p_transaction_category_id_o =>pqh_fyn_shd.g_old_rec.transaction_category_id
161: ,p_transaction_id_o =>pqh_fyn_shd.g_old_rec.transaction_id
162: ,p_notification_event_cd_o =>pqh_fyn_shd.g_old_rec.notification_event_cd
163: ,p_notified_type_cd_o =>pqh_fyn_shd.g_old_rec.notified_type_cd
164: ,p_notified_name_o =>pqh_fyn_shd.g_old_rec.notified_name
165: ,p_notification_date_o =>pqh_fyn_shd.g_old_rec.notification_date

Line 162: ,p_notification_event_cd_o =>pqh_fyn_shd.g_old_rec.notification_event_cd

158: (
159: p_fyi_notified_id =>p_rec.fyi_notified_id
160: ,p_transaction_category_id_o =>pqh_fyn_shd.g_old_rec.transaction_category_id
161: ,p_transaction_id_o =>pqh_fyn_shd.g_old_rec.transaction_id
162: ,p_notification_event_cd_o =>pqh_fyn_shd.g_old_rec.notification_event_cd
163: ,p_notified_type_cd_o =>pqh_fyn_shd.g_old_rec.notified_type_cd
164: ,p_notified_name_o =>pqh_fyn_shd.g_old_rec.notified_name
165: ,p_notification_date_o =>pqh_fyn_shd.g_old_rec.notification_date
166: ,p_status_o =>pqh_fyn_shd.g_old_rec.status

Line 163: ,p_notified_type_cd_o =>pqh_fyn_shd.g_old_rec.notified_type_cd

159: p_fyi_notified_id =>p_rec.fyi_notified_id
160: ,p_transaction_category_id_o =>pqh_fyn_shd.g_old_rec.transaction_category_id
161: ,p_transaction_id_o =>pqh_fyn_shd.g_old_rec.transaction_id
162: ,p_notification_event_cd_o =>pqh_fyn_shd.g_old_rec.notification_event_cd
163: ,p_notified_type_cd_o =>pqh_fyn_shd.g_old_rec.notified_type_cd
164: ,p_notified_name_o =>pqh_fyn_shd.g_old_rec.notified_name
165: ,p_notification_date_o =>pqh_fyn_shd.g_old_rec.notification_date
166: ,p_status_o =>pqh_fyn_shd.g_old_rec.status
167: ,p_object_version_number_o =>pqh_fyn_shd.g_old_rec.object_version_number

Line 164: ,p_notified_name_o =>pqh_fyn_shd.g_old_rec.notified_name

160: ,p_transaction_category_id_o =>pqh_fyn_shd.g_old_rec.transaction_category_id
161: ,p_transaction_id_o =>pqh_fyn_shd.g_old_rec.transaction_id
162: ,p_notification_event_cd_o =>pqh_fyn_shd.g_old_rec.notification_event_cd
163: ,p_notified_type_cd_o =>pqh_fyn_shd.g_old_rec.notified_type_cd
164: ,p_notified_name_o =>pqh_fyn_shd.g_old_rec.notified_name
165: ,p_notification_date_o =>pqh_fyn_shd.g_old_rec.notification_date
166: ,p_status_o =>pqh_fyn_shd.g_old_rec.status
167: ,p_object_version_number_o =>pqh_fyn_shd.g_old_rec.object_version_number
168: );

Line 165: ,p_notification_date_o =>pqh_fyn_shd.g_old_rec.notification_date

161: ,p_transaction_id_o =>pqh_fyn_shd.g_old_rec.transaction_id
162: ,p_notification_event_cd_o =>pqh_fyn_shd.g_old_rec.notification_event_cd
163: ,p_notified_type_cd_o =>pqh_fyn_shd.g_old_rec.notified_type_cd
164: ,p_notified_name_o =>pqh_fyn_shd.g_old_rec.notified_name
165: ,p_notification_date_o =>pqh_fyn_shd.g_old_rec.notification_date
166: ,p_status_o =>pqh_fyn_shd.g_old_rec.status
167: ,p_object_version_number_o =>pqh_fyn_shd.g_old_rec.object_version_number
168: );
169: --

Line 166: ,p_status_o =>pqh_fyn_shd.g_old_rec.status

162: ,p_notification_event_cd_o =>pqh_fyn_shd.g_old_rec.notification_event_cd
163: ,p_notified_type_cd_o =>pqh_fyn_shd.g_old_rec.notified_type_cd
164: ,p_notified_name_o =>pqh_fyn_shd.g_old_rec.notified_name
165: ,p_notification_date_o =>pqh_fyn_shd.g_old_rec.notification_date
166: ,p_status_o =>pqh_fyn_shd.g_old_rec.status
167: ,p_object_version_number_o =>pqh_fyn_shd.g_old_rec.object_version_number
168: );
169: --
170: exception

Line 167: ,p_object_version_number_o =>pqh_fyn_shd.g_old_rec.object_version_number

163: ,p_notified_type_cd_o =>pqh_fyn_shd.g_old_rec.notified_type_cd
164: ,p_notified_name_o =>pqh_fyn_shd.g_old_rec.notified_name
165: ,p_notification_date_o =>pqh_fyn_shd.g_old_rec.notification_date
166: ,p_status_o =>pqh_fyn_shd.g_old_rec.status
167: ,p_object_version_number_o =>pqh_fyn_shd.g_old_rec.object_version_number
168: );
169: --
170: exception
171: --

Line 192: p_rec in pqh_fyn_shd.g_rec_type

188: -- ----------------------------------------------------------------------------
189: Procedure del
190: (
191: p_effective_date in date,
192: p_rec in pqh_fyn_shd.g_rec_type
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'del';
196: --

Line 202: pqh_fyn_shd.lck

198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: -- We must lock the row which we need to delete.
201: --
202: pqh_fyn_shd.lck
203: (
204: p_rec.fyi_notified_id,
205: p_rec.object_version_number
206: );

Line 237: l_rec pqh_fyn_shd.g_rec_type;

233: p_fyi_notified_id in number,
234: p_object_version_number in number
235: ) is
236: --
237: l_rec pqh_fyn_shd.g_rec_type;
238: l_proc varchar2(72) := g_package||'del';
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);