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 77: pqh_tem_shd.constraint_error

73: --
74: Exception
75: When hr_api.child_integrity_violated then
76: -- Child integrity has been violated
77: pqh_tem_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When Others Then
80: Raise;
81: End delete_dml;

Line 115: Procedure pre_delete(p_rec in pqh_tem_shd.g_rec_type) is

111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in pqh_tem_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin

Line 158: p_effective_date in date,p_rec in pqh_tem_shd.g_rec_type) is

154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure post_delete(
158: p_effective_date in date,p_rec in pqh_tem_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'post_delete';
161: --
162: Begin

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

169: --
170: pqh_tem_rkd.after_delete
171: (
172: p_template_id =>p_rec.template_id
173: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
174: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
175: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
176: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
177: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag

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

170: pqh_tem_rkd.after_delete
171: (
172: p_template_id =>p_rec.template_id
173: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
174: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
175: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
176: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
177: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
178: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id

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

171: (
172: p_template_id =>p_rec.template_id
173: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
174: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
175: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
176: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
177: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
178: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
179: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag

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

172: p_template_id =>p_rec.template_id
173: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
174: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
175: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
176: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
177: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
178: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
179: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
180: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number

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

173: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
174: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
175: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
176: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
177: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
178: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
179: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
180: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
181: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd

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

174: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
175: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
176: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
177: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
178: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
179: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
180: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
181: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
182: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd

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

175: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
176: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
177: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
178: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
179: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
180: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
181: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
182: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
183: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code

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

176: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
177: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
178: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
179: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
180: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
181: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
182: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
183: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
184: );

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

177: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
178: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
179: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
180: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
181: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
182: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
183: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
184: );
185: --

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

178: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
179: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
180: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
181: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
182: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
183: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
184: );
185: --
186: exception

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

179: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
180: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
181: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
182: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
183: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
184: );
185: --
186: exception
187: --

Line 208: p_rec in pqh_tem_shd.g_rec_type

204: -- ----------------------------------------------------------------------------
205: Procedure del
206: (
207: p_effective_date in date,
208: p_rec in pqh_tem_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'del';
212: --

Line 218: pqh_tem_shd.lck

214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: -- We must lock the row which we need to delete.
217: --
218: pqh_tem_shd.lck
219: (
220: p_rec.template_id,
221: p_rec.object_version_number
222: );

Line 253: l_rec pqh_tem_shd.g_rec_type;

249: p_template_id in number,
250: p_object_version_number in number
251: ) is
252: --
253: l_rec pqh_tem_shd.g_rec_type;
254: l_proc varchar2(72) := g_package||'del';
255: --
256: Begin
257: hr_utility.set_location('Entering:'||l_proc, 5);