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_CET_DEL dependencies on PQH_CET_SHD

Line 45: Procedure delete_dml(p_rec in pqh_cet_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_cet_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 62: pqh_cet_shd.constraint_error

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

Line 100: Procedure pre_delete(p_rec in pqh_cet_shd.g_rec_type) is

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

Line 143: p_effective_date in date,p_rec in pqh_cet_shd.g_rec_type) is

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

Line 158: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id

154: --
155: pqh_cet_rkd.after_delete
156: (
157: p_copy_entity_txn_id =>p_rec.copy_entity_txn_id
158: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
159: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
160: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
161: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
162: ,p_context_o =>pqh_cet_shd.g_old_rec.context

Line 159: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id

155: pqh_cet_rkd.after_delete
156: (
157: p_copy_entity_txn_id =>p_rec.copy_entity_txn_id
158: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
159: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
160: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
161: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
162: ,p_context_o =>pqh_cet_shd.g_old_rec.context
163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date

Line 160: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id

156: (
157: p_copy_entity_txn_id =>p_rec.copy_entity_txn_id
158: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
159: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
160: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
161: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
162: ,p_context_o =>pqh_cet_shd.g_old_rec.context
163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date

Line 161: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode

157: p_copy_entity_txn_id =>p_rec.copy_entity_txn_id
158: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
159: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
160: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
161: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
162: ,p_context_o =>pqh_cet_shd.g_old_rec.context
163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies

Line 162: ,p_context_o =>pqh_cet_shd.g_old_rec.context

158: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
159: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
160: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
161: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
162: ,p_context_o =>pqh_cet_shd.g_old_rec.context
163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name

Line 163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date

159: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
160: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
161: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
162: ,p_context_o =>pqh_cet_shd.g_old_rec.context
163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd

Line 164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date

160: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
161: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
162: ,p_context_o =>pqh_cet_shd.g_old_rec.context
163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
168: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with

Line 165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies

161: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
162: ,p_context_o =>pqh_cet_shd.g_old_rec.context
163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
168: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
169: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by

Line 166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name

162: ,p_context_o =>pqh_cet_shd.g_old_rec.context
163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
168: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
169: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
170: ,p_status_o =>pqh_cet_shd.g_old_rec.status

Line 167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd

163: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
168: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
169: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
170: ,p_status_o =>pqh_cet_shd.g_old_rec.status
171: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number

Line 168: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with

164: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
168: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
169: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
170: ,p_status_o =>pqh_cet_shd.g_old_rec.status
171: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number
172: );

Line 169: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by

165: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
168: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
169: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
170: ,p_status_o =>pqh_cet_shd.g_old_rec.status
171: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number
172: );
173: --

Line 170: ,p_status_o =>pqh_cet_shd.g_old_rec.status

166: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
168: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
169: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
170: ,p_status_o =>pqh_cet_shd.g_old_rec.status
171: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number
172: );
173: --
174: exception

Line 171: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number

167: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
168: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
169: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
170: ,p_status_o =>pqh_cet_shd.g_old_rec.status
171: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number
172: );
173: --
174: exception
175: --

Line 196: p_rec in pqh_cet_shd.g_rec_type

192: -- ----------------------------------------------------------------------------
193: Procedure del
194: (
195: p_effective_date in date,
196: p_rec in pqh_cet_shd.g_rec_type
197: ) is
198: --
199: l_proc varchar2(72) := g_package||'del';
200: --

Line 206: pqh_cet_shd.lck

202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: -- We must lock the row which we need to delete.
205: --
206: pqh_cet_shd.lck
207: (
208: p_rec.copy_entity_txn_id,
209: p_rec.object_version_number
210: );

Line 241: l_rec pqh_cet_shd.g_rec_type;

237: p_copy_entity_txn_id in number,
238: p_object_version_number in number
239: ) is
240: --
241: l_rec pqh_cet_shd.g_rec_type;
242: l_proc varchar2(72) := g_package||'del';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);