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_TEM_DEL dependencies on PQH_TEM_SHD

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

Line 64: pqh_tem_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_tem_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_tem_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_tem_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_tem_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_tem_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'post_delete';
148: --
149: Begin

Line 160: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name

156: --
157: pqh_tem_rkd.after_delete
158: (
159: p_template_id =>p_rec.template_id
160: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
161: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
162: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
163: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag

Line 161: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name

157: pqh_tem_rkd.after_delete
158: (
159: p_template_id =>p_rec.template_id
160: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
161: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
162: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
163: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id

Line 162: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag

158: (
159: p_template_id =>p_rec.template_id
160: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
161: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
162: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
163: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag

Line 163: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag

159: p_template_id =>p_rec.template_id
160: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
161: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
162: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
163: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
167: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number

Line 164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag

160: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
161: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
162: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
163: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
167: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
168: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd

Line 165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id

161: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
162: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
163: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
167: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
168: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
169: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd

Line 166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag

162: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
163: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
167: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
168: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
169: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
170: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code

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

163: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
167: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
168: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
169: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
170: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
171: );

Line 168: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd

164: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
167: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
168: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
169: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
170: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
171: );
172: --

Line 169: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd

165: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
167: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
168: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
169: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
170: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
171: );
172: --
173: exception

Line 170: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code

166: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
167: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
168: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
169: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
170: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
171: );
172: --
173: exception
174: --

Line 195: p_rec in pqh_tem_shd.g_rec_type

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

Line 205: pqh_tem_shd.lck

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

Line 240: l_rec pqh_tem_shd.g_rec_type;

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