APPS.PQH_CRD_DEL dependencies on PQH_CRD_SHD

Line 86: (p_rec in pqh_crd_shd.g_rec_type

82: --
83: -- {End Of Comments}
84: -- ----------------------------------------------------------------------------
85: Procedure delete_dml
86: (p_rec in pqh_crd_shd.g_rec_type
87: ) is
88: --
89: l_proc varchar2(72) := g_package||'delete_dml';
90: --

Line 109: pqh_crd_shd.constraint_error

105: Exception
106: When hr_api.child_integrity_violated then
107: -- Child integrity has been violated
108: --
109: pqh_crd_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;

Line 148: Procedure pre_delete(p_rec in pqh_crd_shd.g_rec_type) is

144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_delete(p_rec in pqh_crd_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_delete';
151: --
152: Begin

Line 190: Procedure post_delete(p_rec in pqh_crd_shd.g_rec_type) is

186: -- Internal Row Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- -----------------------------------------------------------------------------
190: Procedure post_delete(p_rec in pqh_crd_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_delete';
193: --
194: Begin

Line 207: => pqh_crd_shd.g_old_rec.short_name

203: pqh_crd_rkd.after_delete
204: (p_criteria_rate_defn_id
205: => p_rec.criteria_rate_defn_id
206: ,p_short_name_o
207: => pqh_crd_shd.g_old_rec.short_name
208: ,p_uom_o
209: => pqh_crd_shd.g_old_rec.uom
210: ,p_currency_code_o
211: => pqh_crd_shd.g_old_rec.currency_code

Line 209: => pqh_crd_shd.g_old_rec.uom

205: => p_rec.criteria_rate_defn_id
206: ,p_short_name_o
207: => pqh_crd_shd.g_old_rec.short_name
208: ,p_uom_o
209: => pqh_crd_shd.g_old_rec.uom
210: ,p_currency_code_o
211: => pqh_crd_shd.g_old_rec.currency_code
212: ,p_reference_period_cd_o
213: => pqh_crd_shd.g_old_rec.reference_period_cd

Line 211: => pqh_crd_shd.g_old_rec.currency_code

207: => pqh_crd_shd.g_old_rec.short_name
208: ,p_uom_o
209: => pqh_crd_shd.g_old_rec.uom
210: ,p_currency_code_o
211: => pqh_crd_shd.g_old_rec.currency_code
212: ,p_reference_period_cd_o
213: => pqh_crd_shd.g_old_rec.reference_period_cd
214: ,p_define_max_rate_flag_o
215: => pqh_crd_shd.g_old_rec.define_max_rate_flag

Line 213: => pqh_crd_shd.g_old_rec.reference_period_cd

209: => pqh_crd_shd.g_old_rec.uom
210: ,p_currency_code_o
211: => pqh_crd_shd.g_old_rec.currency_code
212: ,p_reference_period_cd_o
213: => pqh_crd_shd.g_old_rec.reference_period_cd
214: ,p_define_max_rate_flag_o
215: => pqh_crd_shd.g_old_rec.define_max_rate_flag
216: ,p_define_min_rate_flag_o
217: => pqh_crd_shd.g_old_rec.define_min_rate_flag

Line 215: => pqh_crd_shd.g_old_rec.define_max_rate_flag

211: => pqh_crd_shd.g_old_rec.currency_code
212: ,p_reference_period_cd_o
213: => pqh_crd_shd.g_old_rec.reference_period_cd
214: ,p_define_max_rate_flag_o
215: => pqh_crd_shd.g_old_rec.define_max_rate_flag
216: ,p_define_min_rate_flag_o
217: => pqh_crd_shd.g_old_rec.define_min_rate_flag
218: ,p_define_mid_rate_flag_o
219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag

Line 217: => pqh_crd_shd.g_old_rec.define_min_rate_flag

213: => pqh_crd_shd.g_old_rec.reference_period_cd
214: ,p_define_max_rate_flag_o
215: => pqh_crd_shd.g_old_rec.define_max_rate_flag
216: ,p_define_min_rate_flag_o
217: => pqh_crd_shd.g_old_rec.define_min_rate_flag
218: ,p_define_mid_rate_flag_o
219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
220: ,p_define_std_rate_flag_o
221: => pqh_crd_shd.g_old_rec.define_std_rate_flag

Line 219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag

215: => pqh_crd_shd.g_old_rec.define_max_rate_flag
216: ,p_define_min_rate_flag_o
217: => pqh_crd_shd.g_old_rec.define_min_rate_flag
218: ,p_define_mid_rate_flag_o
219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
220: ,p_define_std_rate_flag_o
221: => pqh_crd_shd.g_old_rec.define_std_rate_flag
222: ,p_rate_calc_cd_o
223: => pqh_crd_shd.g_old_rec.rate_calc_cd

Line 221: => pqh_crd_shd.g_old_rec.define_std_rate_flag

217: => pqh_crd_shd.g_old_rec.define_min_rate_flag
218: ,p_define_mid_rate_flag_o
219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
220: ,p_define_std_rate_flag_o
221: => pqh_crd_shd.g_old_rec.define_std_rate_flag
222: ,p_rate_calc_cd_o
223: => pqh_crd_shd.g_old_rec.rate_calc_cd
224: ,p_rate_calc_rule_o
225: => pqh_crd_shd.g_old_rec.rate_calc_rule

Line 223: => pqh_crd_shd.g_old_rec.rate_calc_cd

219: => pqh_crd_shd.g_old_rec.define_mid_rate_flag
220: ,p_define_std_rate_flag_o
221: => pqh_crd_shd.g_old_rec.define_std_rate_flag
222: ,p_rate_calc_cd_o
223: => pqh_crd_shd.g_old_rec.rate_calc_cd
224: ,p_rate_calc_rule_o
225: => pqh_crd_shd.g_old_rec.rate_calc_rule
226: ,p_preferential_rate_cd_o
227: => pqh_crd_shd.g_old_rec.preferential_rate_cd

Line 225: => pqh_crd_shd.g_old_rec.rate_calc_rule

221: => pqh_crd_shd.g_old_rec.define_std_rate_flag
222: ,p_rate_calc_cd_o
223: => pqh_crd_shd.g_old_rec.rate_calc_cd
224: ,p_rate_calc_rule_o
225: => pqh_crd_shd.g_old_rec.rate_calc_rule
226: ,p_preferential_rate_cd_o
227: => pqh_crd_shd.g_old_rec.preferential_rate_cd
228: ,p_preferential_rate_rule_o
229: => pqh_crd_shd.g_old_rec.preferential_rate_rule

Line 227: => pqh_crd_shd.g_old_rec.preferential_rate_cd

223: => pqh_crd_shd.g_old_rec.rate_calc_cd
224: ,p_rate_calc_rule_o
225: => pqh_crd_shd.g_old_rec.rate_calc_rule
226: ,p_preferential_rate_cd_o
227: => pqh_crd_shd.g_old_rec.preferential_rate_cd
228: ,p_preferential_rate_rule_o
229: => pqh_crd_shd.g_old_rec.preferential_rate_rule
230: ,p_rounding_cd_o
231: => pqh_crd_shd.g_old_rec.rounding_cd

Line 229: => pqh_crd_shd.g_old_rec.preferential_rate_rule

225: => pqh_crd_shd.g_old_rec.rate_calc_rule
226: ,p_preferential_rate_cd_o
227: => pqh_crd_shd.g_old_rec.preferential_rate_cd
228: ,p_preferential_rate_rule_o
229: => pqh_crd_shd.g_old_rec.preferential_rate_rule
230: ,p_rounding_cd_o
231: => pqh_crd_shd.g_old_rec.rounding_cd
232: ,p_rounding_rule_o
233: => pqh_crd_shd.g_old_rec.rounding_rule

Line 231: => pqh_crd_shd.g_old_rec.rounding_cd

227: => pqh_crd_shd.g_old_rec.preferential_rate_cd
228: ,p_preferential_rate_rule_o
229: => pqh_crd_shd.g_old_rec.preferential_rate_rule
230: ,p_rounding_cd_o
231: => pqh_crd_shd.g_old_rec.rounding_cd
232: ,p_rounding_rule_o
233: => pqh_crd_shd.g_old_rec.rounding_rule
234: ,p_business_group_id_o
235: => pqh_crd_shd.g_old_rec.business_group_id

Line 233: => pqh_crd_shd.g_old_rec.rounding_rule

229: => pqh_crd_shd.g_old_rec.preferential_rate_rule
230: ,p_rounding_cd_o
231: => pqh_crd_shd.g_old_rec.rounding_cd
232: ,p_rounding_rule_o
233: => pqh_crd_shd.g_old_rec.rounding_rule
234: ,p_business_group_id_o
235: => pqh_crd_shd.g_old_rec.business_group_id
236: ,p_legislation_code_o
237: => pqh_crd_shd.g_old_rec.legislation_code

Line 235: => pqh_crd_shd.g_old_rec.business_group_id

231: => pqh_crd_shd.g_old_rec.rounding_cd
232: ,p_rounding_rule_o
233: => pqh_crd_shd.g_old_rec.rounding_rule
234: ,p_business_group_id_o
235: => pqh_crd_shd.g_old_rec.business_group_id
236: ,p_legislation_code_o
237: => pqh_crd_shd.g_old_rec.legislation_code
238: ,p_attribute_category_o
239: => pqh_crd_shd.g_old_rec.attribute_category

Line 237: => pqh_crd_shd.g_old_rec.legislation_code

233: => pqh_crd_shd.g_old_rec.rounding_rule
234: ,p_business_group_id_o
235: => pqh_crd_shd.g_old_rec.business_group_id
236: ,p_legislation_code_o
237: => pqh_crd_shd.g_old_rec.legislation_code
238: ,p_attribute_category_o
239: => pqh_crd_shd.g_old_rec.attribute_category
240: ,p_attribute1_o
241: => pqh_crd_shd.g_old_rec.attribute1

Line 239: => pqh_crd_shd.g_old_rec.attribute_category

235: => pqh_crd_shd.g_old_rec.business_group_id
236: ,p_legislation_code_o
237: => pqh_crd_shd.g_old_rec.legislation_code
238: ,p_attribute_category_o
239: => pqh_crd_shd.g_old_rec.attribute_category
240: ,p_attribute1_o
241: => pqh_crd_shd.g_old_rec.attribute1
242: ,p_attribute2_o
243: => pqh_crd_shd.g_old_rec.attribute2

Line 241: => pqh_crd_shd.g_old_rec.attribute1

237: => pqh_crd_shd.g_old_rec.legislation_code
238: ,p_attribute_category_o
239: => pqh_crd_shd.g_old_rec.attribute_category
240: ,p_attribute1_o
241: => pqh_crd_shd.g_old_rec.attribute1
242: ,p_attribute2_o
243: => pqh_crd_shd.g_old_rec.attribute2
244: ,p_attribute3_o
245: => pqh_crd_shd.g_old_rec.attribute3

Line 243: => pqh_crd_shd.g_old_rec.attribute2

239: => pqh_crd_shd.g_old_rec.attribute_category
240: ,p_attribute1_o
241: => pqh_crd_shd.g_old_rec.attribute1
242: ,p_attribute2_o
243: => pqh_crd_shd.g_old_rec.attribute2
244: ,p_attribute3_o
245: => pqh_crd_shd.g_old_rec.attribute3
246: ,p_attribute4_o
247: => pqh_crd_shd.g_old_rec.attribute4

Line 245: => pqh_crd_shd.g_old_rec.attribute3

241: => pqh_crd_shd.g_old_rec.attribute1
242: ,p_attribute2_o
243: => pqh_crd_shd.g_old_rec.attribute2
244: ,p_attribute3_o
245: => pqh_crd_shd.g_old_rec.attribute3
246: ,p_attribute4_o
247: => pqh_crd_shd.g_old_rec.attribute4
248: ,p_attribute5_o
249: => pqh_crd_shd.g_old_rec.attribute5

Line 247: => pqh_crd_shd.g_old_rec.attribute4

243: => pqh_crd_shd.g_old_rec.attribute2
244: ,p_attribute3_o
245: => pqh_crd_shd.g_old_rec.attribute3
246: ,p_attribute4_o
247: => pqh_crd_shd.g_old_rec.attribute4
248: ,p_attribute5_o
249: => pqh_crd_shd.g_old_rec.attribute5
250: ,p_attribute6_o
251: => pqh_crd_shd.g_old_rec.attribute6

Line 249: => pqh_crd_shd.g_old_rec.attribute5

245: => pqh_crd_shd.g_old_rec.attribute3
246: ,p_attribute4_o
247: => pqh_crd_shd.g_old_rec.attribute4
248: ,p_attribute5_o
249: => pqh_crd_shd.g_old_rec.attribute5
250: ,p_attribute6_o
251: => pqh_crd_shd.g_old_rec.attribute6
252: ,p_attribute7_o
253: => pqh_crd_shd.g_old_rec.attribute7

Line 251: => pqh_crd_shd.g_old_rec.attribute6

247: => pqh_crd_shd.g_old_rec.attribute4
248: ,p_attribute5_o
249: => pqh_crd_shd.g_old_rec.attribute5
250: ,p_attribute6_o
251: => pqh_crd_shd.g_old_rec.attribute6
252: ,p_attribute7_o
253: => pqh_crd_shd.g_old_rec.attribute7
254: ,p_attribute8_o
255: => pqh_crd_shd.g_old_rec.attribute8

Line 253: => pqh_crd_shd.g_old_rec.attribute7

249: => pqh_crd_shd.g_old_rec.attribute5
250: ,p_attribute6_o
251: => pqh_crd_shd.g_old_rec.attribute6
252: ,p_attribute7_o
253: => pqh_crd_shd.g_old_rec.attribute7
254: ,p_attribute8_o
255: => pqh_crd_shd.g_old_rec.attribute8
256: ,p_attribute9_o
257: => pqh_crd_shd.g_old_rec.attribute9

Line 255: => pqh_crd_shd.g_old_rec.attribute8

251: => pqh_crd_shd.g_old_rec.attribute6
252: ,p_attribute7_o
253: => pqh_crd_shd.g_old_rec.attribute7
254: ,p_attribute8_o
255: => pqh_crd_shd.g_old_rec.attribute8
256: ,p_attribute9_o
257: => pqh_crd_shd.g_old_rec.attribute9
258: ,p_attribute10_o
259: => pqh_crd_shd.g_old_rec.attribute10

Line 257: => pqh_crd_shd.g_old_rec.attribute9

253: => pqh_crd_shd.g_old_rec.attribute7
254: ,p_attribute8_o
255: => pqh_crd_shd.g_old_rec.attribute8
256: ,p_attribute9_o
257: => pqh_crd_shd.g_old_rec.attribute9
258: ,p_attribute10_o
259: => pqh_crd_shd.g_old_rec.attribute10
260: ,p_attribute11_o
261: => pqh_crd_shd.g_old_rec.attribute11

Line 259: => pqh_crd_shd.g_old_rec.attribute10

255: => pqh_crd_shd.g_old_rec.attribute8
256: ,p_attribute9_o
257: => pqh_crd_shd.g_old_rec.attribute9
258: ,p_attribute10_o
259: => pqh_crd_shd.g_old_rec.attribute10
260: ,p_attribute11_o
261: => pqh_crd_shd.g_old_rec.attribute11
262: ,p_attribute12_o
263: => pqh_crd_shd.g_old_rec.attribute12

Line 261: => pqh_crd_shd.g_old_rec.attribute11

257: => pqh_crd_shd.g_old_rec.attribute9
258: ,p_attribute10_o
259: => pqh_crd_shd.g_old_rec.attribute10
260: ,p_attribute11_o
261: => pqh_crd_shd.g_old_rec.attribute11
262: ,p_attribute12_o
263: => pqh_crd_shd.g_old_rec.attribute12
264: ,p_attribute13_o
265: => pqh_crd_shd.g_old_rec.attribute13

Line 263: => pqh_crd_shd.g_old_rec.attribute12

259: => pqh_crd_shd.g_old_rec.attribute10
260: ,p_attribute11_o
261: => pqh_crd_shd.g_old_rec.attribute11
262: ,p_attribute12_o
263: => pqh_crd_shd.g_old_rec.attribute12
264: ,p_attribute13_o
265: => pqh_crd_shd.g_old_rec.attribute13
266: ,p_attribute14_o
267: => pqh_crd_shd.g_old_rec.attribute14

Line 265: => pqh_crd_shd.g_old_rec.attribute13

261: => pqh_crd_shd.g_old_rec.attribute11
262: ,p_attribute12_o
263: => pqh_crd_shd.g_old_rec.attribute12
264: ,p_attribute13_o
265: => pqh_crd_shd.g_old_rec.attribute13
266: ,p_attribute14_o
267: => pqh_crd_shd.g_old_rec.attribute14
268: ,p_attribute15_o
269: => pqh_crd_shd.g_old_rec.attribute15

Line 267: => pqh_crd_shd.g_old_rec.attribute14

263: => pqh_crd_shd.g_old_rec.attribute12
264: ,p_attribute13_o
265: => pqh_crd_shd.g_old_rec.attribute13
266: ,p_attribute14_o
267: => pqh_crd_shd.g_old_rec.attribute14
268: ,p_attribute15_o
269: => pqh_crd_shd.g_old_rec.attribute15
270: ,p_attribute16_o
271: => pqh_crd_shd.g_old_rec.attribute16

Line 269: => pqh_crd_shd.g_old_rec.attribute15

265: => pqh_crd_shd.g_old_rec.attribute13
266: ,p_attribute14_o
267: => pqh_crd_shd.g_old_rec.attribute14
268: ,p_attribute15_o
269: => pqh_crd_shd.g_old_rec.attribute15
270: ,p_attribute16_o
271: => pqh_crd_shd.g_old_rec.attribute16
272: ,p_attribute17_o
273: => pqh_crd_shd.g_old_rec.attribute17

Line 271: => pqh_crd_shd.g_old_rec.attribute16

267: => pqh_crd_shd.g_old_rec.attribute14
268: ,p_attribute15_o
269: => pqh_crd_shd.g_old_rec.attribute15
270: ,p_attribute16_o
271: => pqh_crd_shd.g_old_rec.attribute16
272: ,p_attribute17_o
273: => pqh_crd_shd.g_old_rec.attribute17
274: ,p_attribute18_o
275: => pqh_crd_shd.g_old_rec.attribute18

Line 273: => pqh_crd_shd.g_old_rec.attribute17

269: => pqh_crd_shd.g_old_rec.attribute15
270: ,p_attribute16_o
271: => pqh_crd_shd.g_old_rec.attribute16
272: ,p_attribute17_o
273: => pqh_crd_shd.g_old_rec.attribute17
274: ,p_attribute18_o
275: => pqh_crd_shd.g_old_rec.attribute18
276: ,p_attribute19_o
277: => pqh_crd_shd.g_old_rec.attribute19

Line 275: => pqh_crd_shd.g_old_rec.attribute18

271: => pqh_crd_shd.g_old_rec.attribute16
272: ,p_attribute17_o
273: => pqh_crd_shd.g_old_rec.attribute17
274: ,p_attribute18_o
275: => pqh_crd_shd.g_old_rec.attribute18
276: ,p_attribute19_o
277: => pqh_crd_shd.g_old_rec.attribute19
278: ,p_attribute20_o
279: => pqh_crd_shd.g_old_rec.attribute20

Line 277: => pqh_crd_shd.g_old_rec.attribute19

273: => pqh_crd_shd.g_old_rec.attribute17
274: ,p_attribute18_o
275: => pqh_crd_shd.g_old_rec.attribute18
276: ,p_attribute19_o
277: => pqh_crd_shd.g_old_rec.attribute19
278: ,p_attribute20_o
279: => pqh_crd_shd.g_old_rec.attribute20
280: ,p_attribute21_o
281: => pqh_crd_shd.g_old_rec.attribute21

Line 279: => pqh_crd_shd.g_old_rec.attribute20

275: => pqh_crd_shd.g_old_rec.attribute18
276: ,p_attribute19_o
277: => pqh_crd_shd.g_old_rec.attribute19
278: ,p_attribute20_o
279: => pqh_crd_shd.g_old_rec.attribute20
280: ,p_attribute21_o
281: => pqh_crd_shd.g_old_rec.attribute21
282: ,p_attribute22_o
283: => pqh_crd_shd.g_old_rec.attribute22

Line 281: => pqh_crd_shd.g_old_rec.attribute21

277: => pqh_crd_shd.g_old_rec.attribute19
278: ,p_attribute20_o
279: => pqh_crd_shd.g_old_rec.attribute20
280: ,p_attribute21_o
281: => pqh_crd_shd.g_old_rec.attribute21
282: ,p_attribute22_o
283: => pqh_crd_shd.g_old_rec.attribute22
284: ,p_attribute23_o
285: => pqh_crd_shd.g_old_rec.attribute23

Line 283: => pqh_crd_shd.g_old_rec.attribute22

279: => pqh_crd_shd.g_old_rec.attribute20
280: ,p_attribute21_o
281: => pqh_crd_shd.g_old_rec.attribute21
282: ,p_attribute22_o
283: => pqh_crd_shd.g_old_rec.attribute22
284: ,p_attribute23_o
285: => pqh_crd_shd.g_old_rec.attribute23
286: ,p_attribute24_o
287: => pqh_crd_shd.g_old_rec.attribute24

Line 285: => pqh_crd_shd.g_old_rec.attribute23

281: => pqh_crd_shd.g_old_rec.attribute21
282: ,p_attribute22_o
283: => pqh_crd_shd.g_old_rec.attribute22
284: ,p_attribute23_o
285: => pqh_crd_shd.g_old_rec.attribute23
286: ,p_attribute24_o
287: => pqh_crd_shd.g_old_rec.attribute24
288: ,p_attribute25_o
289: => pqh_crd_shd.g_old_rec.attribute25

Line 287: => pqh_crd_shd.g_old_rec.attribute24

283: => pqh_crd_shd.g_old_rec.attribute22
284: ,p_attribute23_o
285: => pqh_crd_shd.g_old_rec.attribute23
286: ,p_attribute24_o
287: => pqh_crd_shd.g_old_rec.attribute24
288: ,p_attribute25_o
289: => pqh_crd_shd.g_old_rec.attribute25
290: ,p_attribute26_o
291: => pqh_crd_shd.g_old_rec.attribute26

Line 289: => pqh_crd_shd.g_old_rec.attribute25

285: => pqh_crd_shd.g_old_rec.attribute23
286: ,p_attribute24_o
287: => pqh_crd_shd.g_old_rec.attribute24
288: ,p_attribute25_o
289: => pqh_crd_shd.g_old_rec.attribute25
290: ,p_attribute26_o
291: => pqh_crd_shd.g_old_rec.attribute26
292: ,p_attribute27_o
293: => pqh_crd_shd.g_old_rec.attribute27

Line 291: => pqh_crd_shd.g_old_rec.attribute26

287: => pqh_crd_shd.g_old_rec.attribute24
288: ,p_attribute25_o
289: => pqh_crd_shd.g_old_rec.attribute25
290: ,p_attribute26_o
291: => pqh_crd_shd.g_old_rec.attribute26
292: ,p_attribute27_o
293: => pqh_crd_shd.g_old_rec.attribute27
294: ,p_attribute28_o
295: => pqh_crd_shd.g_old_rec.attribute28

Line 293: => pqh_crd_shd.g_old_rec.attribute27

289: => pqh_crd_shd.g_old_rec.attribute25
290: ,p_attribute26_o
291: => pqh_crd_shd.g_old_rec.attribute26
292: ,p_attribute27_o
293: => pqh_crd_shd.g_old_rec.attribute27
294: ,p_attribute28_o
295: => pqh_crd_shd.g_old_rec.attribute28
296: ,p_attribute29_o
297: => pqh_crd_shd.g_old_rec.attribute29

Line 295: => pqh_crd_shd.g_old_rec.attribute28

291: => pqh_crd_shd.g_old_rec.attribute26
292: ,p_attribute27_o
293: => pqh_crd_shd.g_old_rec.attribute27
294: ,p_attribute28_o
295: => pqh_crd_shd.g_old_rec.attribute28
296: ,p_attribute29_o
297: => pqh_crd_shd.g_old_rec.attribute29
298: ,p_attribute30_o
299: => pqh_crd_shd.g_old_rec.attribute30

Line 297: => pqh_crd_shd.g_old_rec.attribute29

293: => pqh_crd_shd.g_old_rec.attribute27
294: ,p_attribute28_o
295: => pqh_crd_shd.g_old_rec.attribute28
296: ,p_attribute29_o
297: => pqh_crd_shd.g_old_rec.attribute29
298: ,p_attribute30_o
299: => pqh_crd_shd.g_old_rec.attribute30
300: ,p_object_version_number_o
301: => pqh_crd_shd.g_old_rec.object_version_number

Line 299: => pqh_crd_shd.g_old_rec.attribute30

295: => pqh_crd_shd.g_old_rec.attribute28
296: ,p_attribute29_o
297: => pqh_crd_shd.g_old_rec.attribute29
298: ,p_attribute30_o
299: => pqh_crd_shd.g_old_rec.attribute30
300: ,p_object_version_number_o
301: => pqh_crd_shd.g_old_rec.object_version_number
302: );
303: --

Line 301: => pqh_crd_shd.g_old_rec.object_version_number

297: => pqh_crd_shd.g_old_rec.attribute29
298: ,p_attribute30_o
299: => pqh_crd_shd.g_old_rec.attribute30
300: ,p_object_version_number_o
301: => pqh_crd_shd.g_old_rec.object_version_number
302: );
303: --
304: exception
305: --

Line 321: (p_rec in pqh_crd_shd.g_rec_type

317: -- ----------------------------------------------------------------------------
318: -- |---------------------------------< del >----------------------------------|
319: -- ----------------------------------------------------------------------------
320: Procedure del
321: (p_rec in pqh_crd_shd.g_rec_type
322: ) is
323: --
324: l_proc varchar2(72) := g_package||'del';
325: --

Line 331: pqh_crd_shd.lck

327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- We must lock the row which we need to delete.
330: --
331: pqh_crd_shd.lck
332: (p_rec.criteria_rate_defn_id
333: ,p_rec.object_version_number
334: );
335: --

Line 368: l_rec pqh_crd_shd.g_rec_type;

364: (p_criteria_rate_defn_id in number
365: ,p_object_version_number in number
366: ) is
367: --
368: l_rec pqh_crd_shd.g_rec_type;
369: l_proc varchar2(72) := g_package||'del';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);