APPS.PQH_VER_DEL dependencies on PQH_VER_SHD

Line 52: (p_rec in pqh_ver_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in pqh_ver_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: pqh_ver_shd.constraint_error

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

Line 114: Procedure pre_delete(p_rec in pqh_ver_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in pqh_ver_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in pqh_ver_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => pqh_ver_shd.g_old_rec.wrkplc_vldtn_id

164: pqh_ver_rkd.after_delete
165: (p_wrkplc_vldtn_ver_id
166: => p_rec.wrkplc_vldtn_ver_id
167: ,p_wrkplc_vldtn_id_o
168: => pqh_ver_shd.g_old_rec.wrkplc_vldtn_id
169: ,p_version_number_o
170: => pqh_ver_shd.g_old_rec.version_number
171: ,p_business_group_id_o
172: => pqh_ver_shd.g_old_rec.business_group_id

Line 170: => pqh_ver_shd.g_old_rec.version_number

166: => p_rec.wrkplc_vldtn_ver_id
167: ,p_wrkplc_vldtn_id_o
168: => pqh_ver_shd.g_old_rec.wrkplc_vldtn_id
169: ,p_version_number_o
170: => pqh_ver_shd.g_old_rec.version_number
171: ,p_business_group_id_o
172: => pqh_ver_shd.g_old_rec.business_group_id
173: ,p_tariff_contract_code_o
174: => pqh_ver_shd.g_old_rec.tariff_contract_code

Line 172: => pqh_ver_shd.g_old_rec.business_group_id

168: => pqh_ver_shd.g_old_rec.wrkplc_vldtn_id
169: ,p_version_number_o
170: => pqh_ver_shd.g_old_rec.version_number
171: ,p_business_group_id_o
172: => pqh_ver_shd.g_old_rec.business_group_id
173: ,p_tariff_contract_code_o
174: => pqh_ver_shd.g_old_rec.tariff_contract_code
175: ,p_tariff_group_code_o
176: => pqh_ver_shd.g_old_rec.tariff_group_code

Line 174: => pqh_ver_shd.g_old_rec.tariff_contract_code

170: => pqh_ver_shd.g_old_rec.version_number
171: ,p_business_group_id_o
172: => pqh_ver_shd.g_old_rec.business_group_id
173: ,p_tariff_contract_code_o
174: => pqh_ver_shd.g_old_rec.tariff_contract_code
175: ,p_tariff_group_code_o
176: => pqh_ver_shd.g_old_rec.tariff_group_code
177: ,p_remuneration_job_descripti_o
178: => pqh_ver_shd.g_old_rec.remuneration_job_description

Line 176: => pqh_ver_shd.g_old_rec.tariff_group_code

172: => pqh_ver_shd.g_old_rec.business_group_id
173: ,p_tariff_contract_code_o
174: => pqh_ver_shd.g_old_rec.tariff_contract_code
175: ,p_tariff_group_code_o
176: => pqh_ver_shd.g_old_rec.tariff_group_code
177: ,p_remuneration_job_descripti_o
178: => pqh_ver_shd.g_old_rec.remuneration_job_description
179: ,p_job_group_id_o
180: => pqh_ver_shd.g_old_rec.job_group_id

Line 178: => pqh_ver_shd.g_old_rec.remuneration_job_description

174: => pqh_ver_shd.g_old_rec.tariff_contract_code
175: ,p_tariff_group_code_o
176: => pqh_ver_shd.g_old_rec.tariff_group_code
177: ,p_remuneration_job_descripti_o
178: => pqh_ver_shd.g_old_rec.remuneration_job_description
179: ,p_job_group_id_o
180: => pqh_ver_shd.g_old_rec.job_group_id
181: ,p_remuneration_job_id_o
182: => pqh_ver_shd.g_old_rec.remuneration_job_id

Line 180: => pqh_ver_shd.g_old_rec.job_group_id

176: => pqh_ver_shd.g_old_rec.tariff_group_code
177: ,p_remuneration_job_descripti_o
178: => pqh_ver_shd.g_old_rec.remuneration_job_description
179: ,p_job_group_id_o
180: => pqh_ver_shd.g_old_rec.job_group_id
181: ,p_remuneration_job_id_o
182: => pqh_ver_shd.g_old_rec.remuneration_job_id
183: ,p_derived_grade_id_o
184: => pqh_ver_shd.g_old_rec.derived_grade_id

Line 182: => pqh_ver_shd.g_old_rec.remuneration_job_id

178: => pqh_ver_shd.g_old_rec.remuneration_job_description
179: ,p_job_group_id_o
180: => pqh_ver_shd.g_old_rec.job_group_id
181: ,p_remuneration_job_id_o
182: => pqh_ver_shd.g_old_rec.remuneration_job_id
183: ,p_derived_grade_id_o
184: => pqh_ver_shd.g_old_rec.derived_grade_id
185: ,p_derived_case_group_id_o
186: => pqh_ver_shd.g_old_rec.derived_case_group_id

Line 184: => pqh_ver_shd.g_old_rec.derived_grade_id

180: => pqh_ver_shd.g_old_rec.job_group_id
181: ,p_remuneration_job_id_o
182: => pqh_ver_shd.g_old_rec.remuneration_job_id
183: ,p_derived_grade_id_o
184: => pqh_ver_shd.g_old_rec.derived_grade_id
185: ,p_derived_case_group_id_o
186: => pqh_ver_shd.g_old_rec.derived_case_group_id
187: ,p_derived_subcasgrp_id_o
188: => pqh_ver_shd.g_old_rec.derived_subcasgrp_id

Line 186: => pqh_ver_shd.g_old_rec.derived_case_group_id

182: => pqh_ver_shd.g_old_rec.remuneration_job_id
183: ,p_derived_grade_id_o
184: => pqh_ver_shd.g_old_rec.derived_grade_id
185: ,p_derived_case_group_id_o
186: => pqh_ver_shd.g_old_rec.derived_case_group_id
187: ,p_derived_subcasgrp_id_o
188: => pqh_ver_shd.g_old_rec.derived_subcasgrp_id
189: ,p_user_enterable_grade_id_o
190: => pqh_ver_shd.g_old_rec.user_enterable_grade_id

Line 188: => pqh_ver_shd.g_old_rec.derived_subcasgrp_id

184: => pqh_ver_shd.g_old_rec.derived_grade_id
185: ,p_derived_case_group_id_o
186: => pqh_ver_shd.g_old_rec.derived_case_group_id
187: ,p_derived_subcasgrp_id_o
188: => pqh_ver_shd.g_old_rec.derived_subcasgrp_id
189: ,p_user_enterable_grade_id_o
190: => pqh_ver_shd.g_old_rec.user_enterable_grade_id
191: ,p_user_enterable_case_group__o
192: => pqh_ver_shd.g_old_rec.user_enterable_case_group_id

Line 190: => pqh_ver_shd.g_old_rec.user_enterable_grade_id

186: => pqh_ver_shd.g_old_rec.derived_case_group_id
187: ,p_derived_subcasgrp_id_o
188: => pqh_ver_shd.g_old_rec.derived_subcasgrp_id
189: ,p_user_enterable_grade_id_o
190: => pqh_ver_shd.g_old_rec.user_enterable_grade_id
191: ,p_user_enterable_case_group__o
192: => pqh_ver_shd.g_old_rec.user_enterable_case_group_id
193: ,p_user_enterable_subcasgrp_i_o
194: => pqh_ver_shd.g_old_rec.user_enterable_subcasgrp_id

Line 192: => pqh_ver_shd.g_old_rec.user_enterable_case_group_id

188: => pqh_ver_shd.g_old_rec.derived_subcasgrp_id
189: ,p_user_enterable_grade_id_o
190: => pqh_ver_shd.g_old_rec.user_enterable_grade_id
191: ,p_user_enterable_case_group__o
192: => pqh_ver_shd.g_old_rec.user_enterable_case_group_id
193: ,p_user_enterable_subcasgrp_i_o
194: => pqh_ver_shd.g_old_rec.user_enterable_subcasgrp_id
195: ,p_freeze_o
196: => pqh_ver_shd.g_old_rec.freeze

Line 194: => pqh_ver_shd.g_old_rec.user_enterable_subcasgrp_id

190: => pqh_ver_shd.g_old_rec.user_enterable_grade_id
191: ,p_user_enterable_case_group__o
192: => pqh_ver_shd.g_old_rec.user_enterable_case_group_id
193: ,p_user_enterable_subcasgrp_i_o
194: => pqh_ver_shd.g_old_rec.user_enterable_subcasgrp_id
195: ,p_freeze_o
196: => pqh_ver_shd.g_old_rec.freeze
197: ,p_object_version_number_o
198: => pqh_ver_shd.g_old_rec.object_version_number

Line 196: => pqh_ver_shd.g_old_rec.freeze

192: => pqh_ver_shd.g_old_rec.user_enterable_case_group_id
193: ,p_user_enterable_subcasgrp_i_o
194: => pqh_ver_shd.g_old_rec.user_enterable_subcasgrp_id
195: ,p_freeze_o
196: => pqh_ver_shd.g_old_rec.freeze
197: ,p_object_version_number_o
198: => pqh_ver_shd.g_old_rec.object_version_number
199: );
200: --

Line 198: => pqh_ver_shd.g_old_rec.object_version_number

194: => pqh_ver_shd.g_old_rec.user_enterable_subcasgrp_id
195: ,p_freeze_o
196: => pqh_ver_shd.g_old_rec.freeze
197: ,p_object_version_number_o
198: => pqh_ver_shd.g_old_rec.object_version_number
199: );
200: --
201: exception
202: --

Line 218: (p_rec in pqh_ver_shd.g_rec_type

214: -- ----------------------------------------------------------------------------
215: -- |---------------------------------< del >----------------------------------|
216: -- ----------------------------------------------------------------------------
217: Procedure del
218: (p_rec in pqh_ver_shd.g_rec_type
219: ) is
220: --
221: l_proc varchar2(72) := g_package||'del';
222: --

Line 228: pqh_ver_shd.lck

224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: -- We must lock the row which we need to delete.
227: --
228: pqh_ver_shd.lck
229: (p_rec.wrkplc_vldtn_ver_id
230: ,p_rec.object_version_number
231: );
232: --

Line 265: l_rec pqh_ver_shd.g_rec_type;

261: (p_wrkplc_vldtn_ver_id in number
262: ,p_object_version_number in number
263: ) is
264: --
265: l_rec pqh_ver_shd.g_rec_type;
266: l_proc varchar2(72) := g_package||'del';
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);