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.BEN_PDT_UPD dependencies on BEN_PDT_SHD

Line 55: (p_rec in out nocopy ben_pdt_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ben_pdt_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 120: ben_pdt_shd.constraint_error

116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ben_pdt_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --

Line 125: ben_pdt_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ben_pdt_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --

Line 130: ben_pdt_shd.constraint_error

126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ben_pdt_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;

Line 170: (p_rec in ben_pdt_shd.g_rec_type

166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_update
170: (p_rec in ben_pdt_shd.g_rec_type
171: ) is
172: --
173: l_proc varchar2(72) := g_package||'pre_update';
174: --

Line 215: ,p_rec in ben_pdt_shd.g_rec_type

211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_update
214: (p_effective_date in date
215: ,p_rec in ben_pdt_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --

Line 303: => ben_pdt_shd.g_old_rec.person_id

299: => p_rec.pdt_attribute30
300: ,p_object_version_number
301: => p_rec.object_version_number
302: ,p_person_id_o
303: => ben_pdt_shd.g_old_rec.person_id
304: ,p_business_group_id_o
305: => ben_pdt_shd.g_old_rec.business_group_id
306: ,p_check_num_o
307: => ben_pdt_shd.g_old_rec.check_num

Line 305: => ben_pdt_shd.g_old_rec.business_group_id

301: => p_rec.object_version_number
302: ,p_person_id_o
303: => ben_pdt_shd.g_old_rec.person_id
304: ,p_business_group_id_o
305: => ben_pdt_shd.g_old_rec.business_group_id
306: ,p_check_num_o
307: => ben_pdt_shd.g_old_rec.check_num
308: ,p_pymt_dt_o
309: => ben_pdt_shd.g_old_rec.pymt_dt

Line 307: => ben_pdt_shd.g_old_rec.check_num

303: => ben_pdt_shd.g_old_rec.person_id
304: ,p_business_group_id_o
305: => ben_pdt_shd.g_old_rec.business_group_id
306: ,p_check_num_o
307: => ben_pdt_shd.g_old_rec.check_num
308: ,p_pymt_dt_o
309: => ben_pdt_shd.g_old_rec.pymt_dt
310: ,p_pymt_amt_o
311: => ben_pdt_shd.g_old_rec.pymt_amt

Line 309: => ben_pdt_shd.g_old_rec.pymt_dt

305: => ben_pdt_shd.g_old_rec.business_group_id
306: ,p_check_num_o
307: => ben_pdt_shd.g_old_rec.check_num
308: ,p_pymt_dt_o
309: => ben_pdt_shd.g_old_rec.pymt_dt
310: ,p_pymt_amt_o
311: => ben_pdt_shd.g_old_rec.pymt_amt
312: ,p_pdt_attribute_category_o
313: => ben_pdt_shd.g_old_rec.pdt_attribute_category

Line 311: => ben_pdt_shd.g_old_rec.pymt_amt

307: => ben_pdt_shd.g_old_rec.check_num
308: ,p_pymt_dt_o
309: => ben_pdt_shd.g_old_rec.pymt_dt
310: ,p_pymt_amt_o
311: => ben_pdt_shd.g_old_rec.pymt_amt
312: ,p_pdt_attribute_category_o
313: => ben_pdt_shd.g_old_rec.pdt_attribute_category
314: ,p_pdt_attribute1_o
315: => ben_pdt_shd.g_old_rec.pdt_attribute1

Line 313: => ben_pdt_shd.g_old_rec.pdt_attribute_category

309: => ben_pdt_shd.g_old_rec.pymt_dt
310: ,p_pymt_amt_o
311: => ben_pdt_shd.g_old_rec.pymt_amt
312: ,p_pdt_attribute_category_o
313: => ben_pdt_shd.g_old_rec.pdt_attribute_category
314: ,p_pdt_attribute1_o
315: => ben_pdt_shd.g_old_rec.pdt_attribute1
316: ,p_pdt_attribute2_o
317: => ben_pdt_shd.g_old_rec.pdt_attribute2

Line 315: => ben_pdt_shd.g_old_rec.pdt_attribute1

311: => ben_pdt_shd.g_old_rec.pymt_amt
312: ,p_pdt_attribute_category_o
313: => ben_pdt_shd.g_old_rec.pdt_attribute_category
314: ,p_pdt_attribute1_o
315: => ben_pdt_shd.g_old_rec.pdt_attribute1
316: ,p_pdt_attribute2_o
317: => ben_pdt_shd.g_old_rec.pdt_attribute2
318: ,p_pdt_attribute3_o
319: => ben_pdt_shd.g_old_rec.pdt_attribute3

Line 317: => ben_pdt_shd.g_old_rec.pdt_attribute2

313: => ben_pdt_shd.g_old_rec.pdt_attribute_category
314: ,p_pdt_attribute1_o
315: => ben_pdt_shd.g_old_rec.pdt_attribute1
316: ,p_pdt_attribute2_o
317: => ben_pdt_shd.g_old_rec.pdt_attribute2
318: ,p_pdt_attribute3_o
319: => ben_pdt_shd.g_old_rec.pdt_attribute3
320: ,p_pdt_attribute4_o
321: => ben_pdt_shd.g_old_rec.pdt_attribute4

Line 319: => ben_pdt_shd.g_old_rec.pdt_attribute3

315: => ben_pdt_shd.g_old_rec.pdt_attribute1
316: ,p_pdt_attribute2_o
317: => ben_pdt_shd.g_old_rec.pdt_attribute2
318: ,p_pdt_attribute3_o
319: => ben_pdt_shd.g_old_rec.pdt_attribute3
320: ,p_pdt_attribute4_o
321: => ben_pdt_shd.g_old_rec.pdt_attribute4
322: ,p_pdt_attribute5_o
323: => ben_pdt_shd.g_old_rec.pdt_attribute5

Line 321: => ben_pdt_shd.g_old_rec.pdt_attribute4

317: => ben_pdt_shd.g_old_rec.pdt_attribute2
318: ,p_pdt_attribute3_o
319: => ben_pdt_shd.g_old_rec.pdt_attribute3
320: ,p_pdt_attribute4_o
321: => ben_pdt_shd.g_old_rec.pdt_attribute4
322: ,p_pdt_attribute5_o
323: => ben_pdt_shd.g_old_rec.pdt_attribute5
324: ,p_pdt_attribute6_o
325: => ben_pdt_shd.g_old_rec.pdt_attribute6

Line 323: => ben_pdt_shd.g_old_rec.pdt_attribute5

319: => ben_pdt_shd.g_old_rec.pdt_attribute3
320: ,p_pdt_attribute4_o
321: => ben_pdt_shd.g_old_rec.pdt_attribute4
322: ,p_pdt_attribute5_o
323: => ben_pdt_shd.g_old_rec.pdt_attribute5
324: ,p_pdt_attribute6_o
325: => ben_pdt_shd.g_old_rec.pdt_attribute6
326: ,p_pdt_attribute7_o
327: => ben_pdt_shd.g_old_rec.pdt_attribute7

Line 325: => ben_pdt_shd.g_old_rec.pdt_attribute6

321: => ben_pdt_shd.g_old_rec.pdt_attribute4
322: ,p_pdt_attribute5_o
323: => ben_pdt_shd.g_old_rec.pdt_attribute5
324: ,p_pdt_attribute6_o
325: => ben_pdt_shd.g_old_rec.pdt_attribute6
326: ,p_pdt_attribute7_o
327: => ben_pdt_shd.g_old_rec.pdt_attribute7
328: ,p_pdt_attribute8_o
329: => ben_pdt_shd.g_old_rec.pdt_attribute8

Line 327: => ben_pdt_shd.g_old_rec.pdt_attribute7

323: => ben_pdt_shd.g_old_rec.pdt_attribute5
324: ,p_pdt_attribute6_o
325: => ben_pdt_shd.g_old_rec.pdt_attribute6
326: ,p_pdt_attribute7_o
327: => ben_pdt_shd.g_old_rec.pdt_attribute7
328: ,p_pdt_attribute8_o
329: => ben_pdt_shd.g_old_rec.pdt_attribute8
330: ,p_pdt_attribute9_o
331: => ben_pdt_shd.g_old_rec.pdt_attribute9

Line 329: => ben_pdt_shd.g_old_rec.pdt_attribute8

325: => ben_pdt_shd.g_old_rec.pdt_attribute6
326: ,p_pdt_attribute7_o
327: => ben_pdt_shd.g_old_rec.pdt_attribute7
328: ,p_pdt_attribute8_o
329: => ben_pdt_shd.g_old_rec.pdt_attribute8
330: ,p_pdt_attribute9_o
331: => ben_pdt_shd.g_old_rec.pdt_attribute9
332: ,p_pdt_attribute10_o
333: => ben_pdt_shd.g_old_rec.pdt_attribute10

Line 331: => ben_pdt_shd.g_old_rec.pdt_attribute9

327: => ben_pdt_shd.g_old_rec.pdt_attribute7
328: ,p_pdt_attribute8_o
329: => ben_pdt_shd.g_old_rec.pdt_attribute8
330: ,p_pdt_attribute9_o
331: => ben_pdt_shd.g_old_rec.pdt_attribute9
332: ,p_pdt_attribute10_o
333: => ben_pdt_shd.g_old_rec.pdt_attribute10
334: ,p_pdt_attribute11_o
335: => ben_pdt_shd.g_old_rec.pdt_attribute11

Line 333: => ben_pdt_shd.g_old_rec.pdt_attribute10

329: => ben_pdt_shd.g_old_rec.pdt_attribute8
330: ,p_pdt_attribute9_o
331: => ben_pdt_shd.g_old_rec.pdt_attribute9
332: ,p_pdt_attribute10_o
333: => ben_pdt_shd.g_old_rec.pdt_attribute10
334: ,p_pdt_attribute11_o
335: => ben_pdt_shd.g_old_rec.pdt_attribute11
336: ,p_pdt_attribute12_o
337: => ben_pdt_shd.g_old_rec.pdt_attribute12

Line 335: => ben_pdt_shd.g_old_rec.pdt_attribute11

331: => ben_pdt_shd.g_old_rec.pdt_attribute9
332: ,p_pdt_attribute10_o
333: => ben_pdt_shd.g_old_rec.pdt_attribute10
334: ,p_pdt_attribute11_o
335: => ben_pdt_shd.g_old_rec.pdt_attribute11
336: ,p_pdt_attribute12_o
337: => ben_pdt_shd.g_old_rec.pdt_attribute12
338: ,p_pdt_attribute13_o
339: => ben_pdt_shd.g_old_rec.pdt_attribute13

Line 337: => ben_pdt_shd.g_old_rec.pdt_attribute12

333: => ben_pdt_shd.g_old_rec.pdt_attribute10
334: ,p_pdt_attribute11_o
335: => ben_pdt_shd.g_old_rec.pdt_attribute11
336: ,p_pdt_attribute12_o
337: => ben_pdt_shd.g_old_rec.pdt_attribute12
338: ,p_pdt_attribute13_o
339: => ben_pdt_shd.g_old_rec.pdt_attribute13
340: ,p_pdt_attribute14_o
341: => ben_pdt_shd.g_old_rec.pdt_attribute14

Line 339: => ben_pdt_shd.g_old_rec.pdt_attribute13

335: => ben_pdt_shd.g_old_rec.pdt_attribute11
336: ,p_pdt_attribute12_o
337: => ben_pdt_shd.g_old_rec.pdt_attribute12
338: ,p_pdt_attribute13_o
339: => ben_pdt_shd.g_old_rec.pdt_attribute13
340: ,p_pdt_attribute14_o
341: => ben_pdt_shd.g_old_rec.pdt_attribute14
342: ,p_pdt_attribute15_o
343: => ben_pdt_shd.g_old_rec.pdt_attribute15

Line 341: => ben_pdt_shd.g_old_rec.pdt_attribute14

337: => ben_pdt_shd.g_old_rec.pdt_attribute12
338: ,p_pdt_attribute13_o
339: => ben_pdt_shd.g_old_rec.pdt_attribute13
340: ,p_pdt_attribute14_o
341: => ben_pdt_shd.g_old_rec.pdt_attribute14
342: ,p_pdt_attribute15_o
343: => ben_pdt_shd.g_old_rec.pdt_attribute15
344: ,p_pdt_attribute16_o
345: => ben_pdt_shd.g_old_rec.pdt_attribute16

Line 343: => ben_pdt_shd.g_old_rec.pdt_attribute15

339: => ben_pdt_shd.g_old_rec.pdt_attribute13
340: ,p_pdt_attribute14_o
341: => ben_pdt_shd.g_old_rec.pdt_attribute14
342: ,p_pdt_attribute15_o
343: => ben_pdt_shd.g_old_rec.pdt_attribute15
344: ,p_pdt_attribute16_o
345: => ben_pdt_shd.g_old_rec.pdt_attribute16
346: ,p_pdt_attribute17_o
347: => ben_pdt_shd.g_old_rec.pdt_attribute17

Line 345: => ben_pdt_shd.g_old_rec.pdt_attribute16

341: => ben_pdt_shd.g_old_rec.pdt_attribute14
342: ,p_pdt_attribute15_o
343: => ben_pdt_shd.g_old_rec.pdt_attribute15
344: ,p_pdt_attribute16_o
345: => ben_pdt_shd.g_old_rec.pdt_attribute16
346: ,p_pdt_attribute17_o
347: => ben_pdt_shd.g_old_rec.pdt_attribute17
348: ,p_pdt_attribute18_o
349: => ben_pdt_shd.g_old_rec.pdt_attribute18

Line 347: => ben_pdt_shd.g_old_rec.pdt_attribute17

343: => ben_pdt_shd.g_old_rec.pdt_attribute15
344: ,p_pdt_attribute16_o
345: => ben_pdt_shd.g_old_rec.pdt_attribute16
346: ,p_pdt_attribute17_o
347: => ben_pdt_shd.g_old_rec.pdt_attribute17
348: ,p_pdt_attribute18_o
349: => ben_pdt_shd.g_old_rec.pdt_attribute18
350: ,p_pdt_attribute19_o
351: => ben_pdt_shd.g_old_rec.pdt_attribute19

Line 349: => ben_pdt_shd.g_old_rec.pdt_attribute18

345: => ben_pdt_shd.g_old_rec.pdt_attribute16
346: ,p_pdt_attribute17_o
347: => ben_pdt_shd.g_old_rec.pdt_attribute17
348: ,p_pdt_attribute18_o
349: => ben_pdt_shd.g_old_rec.pdt_attribute18
350: ,p_pdt_attribute19_o
351: => ben_pdt_shd.g_old_rec.pdt_attribute19
352: ,p_pdt_attribute20_o
353: => ben_pdt_shd.g_old_rec.pdt_attribute20

Line 351: => ben_pdt_shd.g_old_rec.pdt_attribute19

347: => ben_pdt_shd.g_old_rec.pdt_attribute17
348: ,p_pdt_attribute18_o
349: => ben_pdt_shd.g_old_rec.pdt_attribute18
350: ,p_pdt_attribute19_o
351: => ben_pdt_shd.g_old_rec.pdt_attribute19
352: ,p_pdt_attribute20_o
353: => ben_pdt_shd.g_old_rec.pdt_attribute20
354: ,p_pdt_attribute21_o
355: => ben_pdt_shd.g_old_rec.pdt_attribute21

Line 353: => ben_pdt_shd.g_old_rec.pdt_attribute20

349: => ben_pdt_shd.g_old_rec.pdt_attribute18
350: ,p_pdt_attribute19_o
351: => ben_pdt_shd.g_old_rec.pdt_attribute19
352: ,p_pdt_attribute20_o
353: => ben_pdt_shd.g_old_rec.pdt_attribute20
354: ,p_pdt_attribute21_o
355: => ben_pdt_shd.g_old_rec.pdt_attribute21
356: ,p_pdt_attribute22_o
357: => ben_pdt_shd.g_old_rec.pdt_attribute22

Line 355: => ben_pdt_shd.g_old_rec.pdt_attribute21

351: => ben_pdt_shd.g_old_rec.pdt_attribute19
352: ,p_pdt_attribute20_o
353: => ben_pdt_shd.g_old_rec.pdt_attribute20
354: ,p_pdt_attribute21_o
355: => ben_pdt_shd.g_old_rec.pdt_attribute21
356: ,p_pdt_attribute22_o
357: => ben_pdt_shd.g_old_rec.pdt_attribute22
358: ,p_pdt_attribute23_o
359: => ben_pdt_shd.g_old_rec.pdt_attribute23

Line 357: => ben_pdt_shd.g_old_rec.pdt_attribute22

353: => ben_pdt_shd.g_old_rec.pdt_attribute20
354: ,p_pdt_attribute21_o
355: => ben_pdt_shd.g_old_rec.pdt_attribute21
356: ,p_pdt_attribute22_o
357: => ben_pdt_shd.g_old_rec.pdt_attribute22
358: ,p_pdt_attribute23_o
359: => ben_pdt_shd.g_old_rec.pdt_attribute23
360: ,p_pdt_attribute24_o
361: => ben_pdt_shd.g_old_rec.pdt_attribute24

Line 359: => ben_pdt_shd.g_old_rec.pdt_attribute23

355: => ben_pdt_shd.g_old_rec.pdt_attribute21
356: ,p_pdt_attribute22_o
357: => ben_pdt_shd.g_old_rec.pdt_attribute22
358: ,p_pdt_attribute23_o
359: => ben_pdt_shd.g_old_rec.pdt_attribute23
360: ,p_pdt_attribute24_o
361: => ben_pdt_shd.g_old_rec.pdt_attribute24
362: ,p_pdt_attribute25_o
363: => ben_pdt_shd.g_old_rec.pdt_attribute25

Line 361: => ben_pdt_shd.g_old_rec.pdt_attribute24

357: => ben_pdt_shd.g_old_rec.pdt_attribute22
358: ,p_pdt_attribute23_o
359: => ben_pdt_shd.g_old_rec.pdt_attribute23
360: ,p_pdt_attribute24_o
361: => ben_pdt_shd.g_old_rec.pdt_attribute24
362: ,p_pdt_attribute25_o
363: => ben_pdt_shd.g_old_rec.pdt_attribute25
364: ,p_pdt_attribute26_o
365: => ben_pdt_shd.g_old_rec.pdt_attribute26

Line 363: => ben_pdt_shd.g_old_rec.pdt_attribute25

359: => ben_pdt_shd.g_old_rec.pdt_attribute23
360: ,p_pdt_attribute24_o
361: => ben_pdt_shd.g_old_rec.pdt_attribute24
362: ,p_pdt_attribute25_o
363: => ben_pdt_shd.g_old_rec.pdt_attribute25
364: ,p_pdt_attribute26_o
365: => ben_pdt_shd.g_old_rec.pdt_attribute26
366: ,p_pdt_attribute27_o
367: => ben_pdt_shd.g_old_rec.pdt_attribute27

Line 365: => ben_pdt_shd.g_old_rec.pdt_attribute26

361: => ben_pdt_shd.g_old_rec.pdt_attribute24
362: ,p_pdt_attribute25_o
363: => ben_pdt_shd.g_old_rec.pdt_attribute25
364: ,p_pdt_attribute26_o
365: => ben_pdt_shd.g_old_rec.pdt_attribute26
366: ,p_pdt_attribute27_o
367: => ben_pdt_shd.g_old_rec.pdt_attribute27
368: ,p_pdt_attribute28_o
369: => ben_pdt_shd.g_old_rec.pdt_attribute28

Line 367: => ben_pdt_shd.g_old_rec.pdt_attribute27

363: => ben_pdt_shd.g_old_rec.pdt_attribute25
364: ,p_pdt_attribute26_o
365: => ben_pdt_shd.g_old_rec.pdt_attribute26
366: ,p_pdt_attribute27_o
367: => ben_pdt_shd.g_old_rec.pdt_attribute27
368: ,p_pdt_attribute28_o
369: => ben_pdt_shd.g_old_rec.pdt_attribute28
370: ,p_pdt_attribute29_o
371: => ben_pdt_shd.g_old_rec.pdt_attribute29

Line 369: => ben_pdt_shd.g_old_rec.pdt_attribute28

365: => ben_pdt_shd.g_old_rec.pdt_attribute26
366: ,p_pdt_attribute27_o
367: => ben_pdt_shd.g_old_rec.pdt_attribute27
368: ,p_pdt_attribute28_o
369: => ben_pdt_shd.g_old_rec.pdt_attribute28
370: ,p_pdt_attribute29_o
371: => ben_pdt_shd.g_old_rec.pdt_attribute29
372: ,p_pdt_attribute30_o
373: => ben_pdt_shd.g_old_rec.pdt_attribute30

Line 371: => ben_pdt_shd.g_old_rec.pdt_attribute29

367: => ben_pdt_shd.g_old_rec.pdt_attribute27
368: ,p_pdt_attribute28_o
369: => ben_pdt_shd.g_old_rec.pdt_attribute28
370: ,p_pdt_attribute29_o
371: => ben_pdt_shd.g_old_rec.pdt_attribute29
372: ,p_pdt_attribute30_o
373: => ben_pdt_shd.g_old_rec.pdt_attribute30
374: ,p_object_version_number_o
375: => ben_pdt_shd.g_old_rec.object_version_number

Line 373: => ben_pdt_shd.g_old_rec.pdt_attribute30

369: => ben_pdt_shd.g_old_rec.pdt_attribute28
370: ,p_pdt_attribute29_o
371: => ben_pdt_shd.g_old_rec.pdt_attribute29
372: ,p_pdt_attribute30_o
373: => ben_pdt_shd.g_old_rec.pdt_attribute30
374: ,p_object_version_number_o
375: => ben_pdt_shd.g_old_rec.object_version_number
376: );
377: --

Line 375: => ben_pdt_shd.g_old_rec.object_version_number

371: => ben_pdt_shd.g_old_rec.pdt_attribute29
372: ,p_pdt_attribute30_o
373: => ben_pdt_shd.g_old_rec.pdt_attribute30
374: ,p_object_version_number_o
375: => ben_pdt_shd.g_old_rec.object_version_number
376: );
377: --
378: exception
379: --

Line 435: (p_rec in out nocopy ben_pdt_shd.g_rec_type

431: --
432: -- {End Of Comments}
433: -- ----------------------------------------------------------------------------
434: Procedure convert_defs
435: (p_rec in out nocopy ben_pdt_shd.g_rec_type
436: ) is
437: --
438: Begin
439: --

Line 447: ben_pdt_shd.g_old_rec.person_id;

443: -- is being used then we must set to the 'current' argument value.
444: --
445: If (p_rec.person_id = hr_api.g_number) then
446: p_rec.person_id :=
447: ben_pdt_shd.g_old_rec.person_id;
448: End If;
449: If (p_rec.business_group_id = hr_api.g_number) then
450: p_rec.business_group_id :=
451: ben_pdt_shd.g_old_rec.business_group_id;

Line 451: ben_pdt_shd.g_old_rec.business_group_id;

447: ben_pdt_shd.g_old_rec.person_id;
448: End If;
449: If (p_rec.business_group_id = hr_api.g_number) then
450: p_rec.business_group_id :=
451: ben_pdt_shd.g_old_rec.business_group_id;
452: End If;
453: If (p_rec.check_num = hr_api.g_varchar2) then
454: p_rec.check_num :=
455: ben_pdt_shd.g_old_rec.check_num;

Line 455: ben_pdt_shd.g_old_rec.check_num;

451: ben_pdt_shd.g_old_rec.business_group_id;
452: End If;
453: If (p_rec.check_num = hr_api.g_varchar2) then
454: p_rec.check_num :=
455: ben_pdt_shd.g_old_rec.check_num;
456: End If;
457: If (p_rec.pymt_dt = hr_api.g_date) then
458: p_rec.pymt_dt :=
459: ben_pdt_shd.g_old_rec.pymt_dt;

Line 459: ben_pdt_shd.g_old_rec.pymt_dt;

455: ben_pdt_shd.g_old_rec.check_num;
456: End If;
457: If (p_rec.pymt_dt = hr_api.g_date) then
458: p_rec.pymt_dt :=
459: ben_pdt_shd.g_old_rec.pymt_dt;
460: End If;
461: If (p_rec.pymt_amt = hr_api.g_number) then
462: p_rec.pymt_amt :=
463: ben_pdt_shd.g_old_rec.pymt_amt;

Line 463: ben_pdt_shd.g_old_rec.pymt_amt;

459: ben_pdt_shd.g_old_rec.pymt_dt;
460: End If;
461: If (p_rec.pymt_amt = hr_api.g_number) then
462: p_rec.pymt_amt :=
463: ben_pdt_shd.g_old_rec.pymt_amt;
464: End If;
465: If (p_rec.pdt_attribute_category = hr_api.g_varchar2) then
466: p_rec.pdt_attribute_category :=
467: ben_pdt_shd.g_old_rec.pdt_attribute_category;

Line 467: ben_pdt_shd.g_old_rec.pdt_attribute_category;

463: ben_pdt_shd.g_old_rec.pymt_amt;
464: End If;
465: If (p_rec.pdt_attribute_category = hr_api.g_varchar2) then
466: p_rec.pdt_attribute_category :=
467: ben_pdt_shd.g_old_rec.pdt_attribute_category;
468: End If;
469: If (p_rec.pdt_attribute1 = hr_api.g_varchar2) then
470: p_rec.pdt_attribute1 :=
471: ben_pdt_shd.g_old_rec.pdt_attribute1;

Line 471: ben_pdt_shd.g_old_rec.pdt_attribute1;

467: ben_pdt_shd.g_old_rec.pdt_attribute_category;
468: End If;
469: If (p_rec.pdt_attribute1 = hr_api.g_varchar2) then
470: p_rec.pdt_attribute1 :=
471: ben_pdt_shd.g_old_rec.pdt_attribute1;
472: End If;
473: If (p_rec.pdt_attribute2 = hr_api.g_varchar2) then
474: p_rec.pdt_attribute2 :=
475: ben_pdt_shd.g_old_rec.pdt_attribute2;

Line 475: ben_pdt_shd.g_old_rec.pdt_attribute2;

471: ben_pdt_shd.g_old_rec.pdt_attribute1;
472: End If;
473: If (p_rec.pdt_attribute2 = hr_api.g_varchar2) then
474: p_rec.pdt_attribute2 :=
475: ben_pdt_shd.g_old_rec.pdt_attribute2;
476: End If;
477: If (p_rec.pdt_attribute3 = hr_api.g_varchar2) then
478: p_rec.pdt_attribute3 :=
479: ben_pdt_shd.g_old_rec.pdt_attribute3;

Line 479: ben_pdt_shd.g_old_rec.pdt_attribute3;

475: ben_pdt_shd.g_old_rec.pdt_attribute2;
476: End If;
477: If (p_rec.pdt_attribute3 = hr_api.g_varchar2) then
478: p_rec.pdt_attribute3 :=
479: ben_pdt_shd.g_old_rec.pdt_attribute3;
480: End If;
481: If (p_rec.pdt_attribute4 = hr_api.g_varchar2) then
482: p_rec.pdt_attribute4 :=
483: ben_pdt_shd.g_old_rec.pdt_attribute4;

Line 483: ben_pdt_shd.g_old_rec.pdt_attribute4;

479: ben_pdt_shd.g_old_rec.pdt_attribute3;
480: End If;
481: If (p_rec.pdt_attribute4 = hr_api.g_varchar2) then
482: p_rec.pdt_attribute4 :=
483: ben_pdt_shd.g_old_rec.pdt_attribute4;
484: End If;
485: If (p_rec.pdt_attribute5 = hr_api.g_varchar2) then
486: p_rec.pdt_attribute5 :=
487: ben_pdt_shd.g_old_rec.pdt_attribute5;

Line 487: ben_pdt_shd.g_old_rec.pdt_attribute5;

483: ben_pdt_shd.g_old_rec.pdt_attribute4;
484: End If;
485: If (p_rec.pdt_attribute5 = hr_api.g_varchar2) then
486: p_rec.pdt_attribute5 :=
487: ben_pdt_shd.g_old_rec.pdt_attribute5;
488: End If;
489: If (p_rec.pdt_attribute6 = hr_api.g_varchar2) then
490: p_rec.pdt_attribute6 :=
491: ben_pdt_shd.g_old_rec.pdt_attribute6;

Line 491: ben_pdt_shd.g_old_rec.pdt_attribute6;

487: ben_pdt_shd.g_old_rec.pdt_attribute5;
488: End If;
489: If (p_rec.pdt_attribute6 = hr_api.g_varchar2) then
490: p_rec.pdt_attribute6 :=
491: ben_pdt_shd.g_old_rec.pdt_attribute6;
492: End If;
493: If (p_rec.pdt_attribute7 = hr_api.g_varchar2) then
494: p_rec.pdt_attribute7 :=
495: ben_pdt_shd.g_old_rec.pdt_attribute7;

Line 495: ben_pdt_shd.g_old_rec.pdt_attribute7;

491: ben_pdt_shd.g_old_rec.pdt_attribute6;
492: End If;
493: If (p_rec.pdt_attribute7 = hr_api.g_varchar2) then
494: p_rec.pdt_attribute7 :=
495: ben_pdt_shd.g_old_rec.pdt_attribute7;
496: End If;
497: If (p_rec.pdt_attribute8 = hr_api.g_varchar2) then
498: p_rec.pdt_attribute8 :=
499: ben_pdt_shd.g_old_rec.pdt_attribute8;

Line 499: ben_pdt_shd.g_old_rec.pdt_attribute8;

495: ben_pdt_shd.g_old_rec.pdt_attribute7;
496: End If;
497: If (p_rec.pdt_attribute8 = hr_api.g_varchar2) then
498: p_rec.pdt_attribute8 :=
499: ben_pdt_shd.g_old_rec.pdt_attribute8;
500: End If;
501: If (p_rec.pdt_attribute9 = hr_api.g_varchar2) then
502: p_rec.pdt_attribute9 :=
503: ben_pdt_shd.g_old_rec.pdt_attribute9;

Line 503: ben_pdt_shd.g_old_rec.pdt_attribute9;

499: ben_pdt_shd.g_old_rec.pdt_attribute8;
500: End If;
501: If (p_rec.pdt_attribute9 = hr_api.g_varchar2) then
502: p_rec.pdt_attribute9 :=
503: ben_pdt_shd.g_old_rec.pdt_attribute9;
504: End If;
505: If (p_rec.pdt_attribute10 = hr_api.g_varchar2) then
506: p_rec.pdt_attribute10 :=
507: ben_pdt_shd.g_old_rec.pdt_attribute10;

Line 507: ben_pdt_shd.g_old_rec.pdt_attribute10;

503: ben_pdt_shd.g_old_rec.pdt_attribute9;
504: End If;
505: If (p_rec.pdt_attribute10 = hr_api.g_varchar2) then
506: p_rec.pdt_attribute10 :=
507: ben_pdt_shd.g_old_rec.pdt_attribute10;
508: End If;
509: If (p_rec.pdt_attribute11 = hr_api.g_varchar2) then
510: p_rec.pdt_attribute11 :=
511: ben_pdt_shd.g_old_rec.pdt_attribute11;

Line 511: ben_pdt_shd.g_old_rec.pdt_attribute11;

507: ben_pdt_shd.g_old_rec.pdt_attribute10;
508: End If;
509: If (p_rec.pdt_attribute11 = hr_api.g_varchar2) then
510: p_rec.pdt_attribute11 :=
511: ben_pdt_shd.g_old_rec.pdt_attribute11;
512: End If;
513: If (p_rec.pdt_attribute12 = hr_api.g_varchar2) then
514: p_rec.pdt_attribute12 :=
515: ben_pdt_shd.g_old_rec.pdt_attribute12;

Line 515: ben_pdt_shd.g_old_rec.pdt_attribute12;

511: ben_pdt_shd.g_old_rec.pdt_attribute11;
512: End If;
513: If (p_rec.pdt_attribute12 = hr_api.g_varchar2) then
514: p_rec.pdt_attribute12 :=
515: ben_pdt_shd.g_old_rec.pdt_attribute12;
516: End If;
517: If (p_rec.pdt_attribute13 = hr_api.g_varchar2) then
518: p_rec.pdt_attribute13 :=
519: ben_pdt_shd.g_old_rec.pdt_attribute13;

Line 519: ben_pdt_shd.g_old_rec.pdt_attribute13;

515: ben_pdt_shd.g_old_rec.pdt_attribute12;
516: End If;
517: If (p_rec.pdt_attribute13 = hr_api.g_varchar2) then
518: p_rec.pdt_attribute13 :=
519: ben_pdt_shd.g_old_rec.pdt_attribute13;
520: End If;
521: If (p_rec.pdt_attribute14 = hr_api.g_varchar2) then
522: p_rec.pdt_attribute14 :=
523: ben_pdt_shd.g_old_rec.pdt_attribute14;

Line 523: ben_pdt_shd.g_old_rec.pdt_attribute14;

519: ben_pdt_shd.g_old_rec.pdt_attribute13;
520: End If;
521: If (p_rec.pdt_attribute14 = hr_api.g_varchar2) then
522: p_rec.pdt_attribute14 :=
523: ben_pdt_shd.g_old_rec.pdt_attribute14;
524: End If;
525: If (p_rec.pdt_attribute15 = hr_api.g_varchar2) then
526: p_rec.pdt_attribute15 :=
527: ben_pdt_shd.g_old_rec.pdt_attribute15;

Line 527: ben_pdt_shd.g_old_rec.pdt_attribute15;

523: ben_pdt_shd.g_old_rec.pdt_attribute14;
524: End If;
525: If (p_rec.pdt_attribute15 = hr_api.g_varchar2) then
526: p_rec.pdt_attribute15 :=
527: ben_pdt_shd.g_old_rec.pdt_attribute15;
528: End If;
529: If (p_rec.pdt_attribute16 = hr_api.g_varchar2) then
530: p_rec.pdt_attribute16 :=
531: ben_pdt_shd.g_old_rec.pdt_attribute16;

Line 531: ben_pdt_shd.g_old_rec.pdt_attribute16;

527: ben_pdt_shd.g_old_rec.pdt_attribute15;
528: End If;
529: If (p_rec.pdt_attribute16 = hr_api.g_varchar2) then
530: p_rec.pdt_attribute16 :=
531: ben_pdt_shd.g_old_rec.pdt_attribute16;
532: End If;
533: If (p_rec.pdt_attribute17 = hr_api.g_varchar2) then
534: p_rec.pdt_attribute17 :=
535: ben_pdt_shd.g_old_rec.pdt_attribute17;

Line 535: ben_pdt_shd.g_old_rec.pdt_attribute17;

531: ben_pdt_shd.g_old_rec.pdt_attribute16;
532: End If;
533: If (p_rec.pdt_attribute17 = hr_api.g_varchar2) then
534: p_rec.pdt_attribute17 :=
535: ben_pdt_shd.g_old_rec.pdt_attribute17;
536: End If;
537: If (p_rec.pdt_attribute18 = hr_api.g_varchar2) then
538: p_rec.pdt_attribute18 :=
539: ben_pdt_shd.g_old_rec.pdt_attribute18;

Line 539: ben_pdt_shd.g_old_rec.pdt_attribute18;

535: ben_pdt_shd.g_old_rec.pdt_attribute17;
536: End If;
537: If (p_rec.pdt_attribute18 = hr_api.g_varchar2) then
538: p_rec.pdt_attribute18 :=
539: ben_pdt_shd.g_old_rec.pdt_attribute18;
540: End If;
541: If (p_rec.pdt_attribute19 = hr_api.g_varchar2) then
542: p_rec.pdt_attribute19 :=
543: ben_pdt_shd.g_old_rec.pdt_attribute19;

Line 543: ben_pdt_shd.g_old_rec.pdt_attribute19;

539: ben_pdt_shd.g_old_rec.pdt_attribute18;
540: End If;
541: If (p_rec.pdt_attribute19 = hr_api.g_varchar2) then
542: p_rec.pdt_attribute19 :=
543: ben_pdt_shd.g_old_rec.pdt_attribute19;
544: End If;
545: If (p_rec.pdt_attribute20 = hr_api.g_varchar2) then
546: p_rec.pdt_attribute20 :=
547: ben_pdt_shd.g_old_rec.pdt_attribute20;

Line 547: ben_pdt_shd.g_old_rec.pdt_attribute20;

543: ben_pdt_shd.g_old_rec.pdt_attribute19;
544: End If;
545: If (p_rec.pdt_attribute20 = hr_api.g_varchar2) then
546: p_rec.pdt_attribute20 :=
547: ben_pdt_shd.g_old_rec.pdt_attribute20;
548: End If;
549: If (p_rec.pdt_attribute21 = hr_api.g_varchar2) then
550: p_rec.pdt_attribute21 :=
551: ben_pdt_shd.g_old_rec.pdt_attribute21;

Line 551: ben_pdt_shd.g_old_rec.pdt_attribute21;

547: ben_pdt_shd.g_old_rec.pdt_attribute20;
548: End If;
549: If (p_rec.pdt_attribute21 = hr_api.g_varchar2) then
550: p_rec.pdt_attribute21 :=
551: ben_pdt_shd.g_old_rec.pdt_attribute21;
552: End If;
553: If (p_rec.pdt_attribute22 = hr_api.g_varchar2) then
554: p_rec.pdt_attribute22 :=
555: ben_pdt_shd.g_old_rec.pdt_attribute22;

Line 555: ben_pdt_shd.g_old_rec.pdt_attribute22;

551: ben_pdt_shd.g_old_rec.pdt_attribute21;
552: End If;
553: If (p_rec.pdt_attribute22 = hr_api.g_varchar2) then
554: p_rec.pdt_attribute22 :=
555: ben_pdt_shd.g_old_rec.pdt_attribute22;
556: End If;
557: If (p_rec.pdt_attribute23 = hr_api.g_varchar2) then
558: p_rec.pdt_attribute23 :=
559: ben_pdt_shd.g_old_rec.pdt_attribute23;

Line 559: ben_pdt_shd.g_old_rec.pdt_attribute23;

555: ben_pdt_shd.g_old_rec.pdt_attribute22;
556: End If;
557: If (p_rec.pdt_attribute23 = hr_api.g_varchar2) then
558: p_rec.pdt_attribute23 :=
559: ben_pdt_shd.g_old_rec.pdt_attribute23;
560: End If;
561: If (p_rec.pdt_attribute24 = hr_api.g_varchar2) then
562: p_rec.pdt_attribute24 :=
563: ben_pdt_shd.g_old_rec.pdt_attribute24;

Line 563: ben_pdt_shd.g_old_rec.pdt_attribute24;

559: ben_pdt_shd.g_old_rec.pdt_attribute23;
560: End If;
561: If (p_rec.pdt_attribute24 = hr_api.g_varchar2) then
562: p_rec.pdt_attribute24 :=
563: ben_pdt_shd.g_old_rec.pdt_attribute24;
564: End If;
565: If (p_rec.pdt_attribute25 = hr_api.g_varchar2) then
566: p_rec.pdt_attribute25 :=
567: ben_pdt_shd.g_old_rec.pdt_attribute25;

Line 567: ben_pdt_shd.g_old_rec.pdt_attribute25;

563: ben_pdt_shd.g_old_rec.pdt_attribute24;
564: End If;
565: If (p_rec.pdt_attribute25 = hr_api.g_varchar2) then
566: p_rec.pdt_attribute25 :=
567: ben_pdt_shd.g_old_rec.pdt_attribute25;
568: End If;
569: If (p_rec.pdt_attribute26 = hr_api.g_varchar2) then
570: p_rec.pdt_attribute26 :=
571: ben_pdt_shd.g_old_rec.pdt_attribute26;

Line 571: ben_pdt_shd.g_old_rec.pdt_attribute26;

567: ben_pdt_shd.g_old_rec.pdt_attribute25;
568: End If;
569: If (p_rec.pdt_attribute26 = hr_api.g_varchar2) then
570: p_rec.pdt_attribute26 :=
571: ben_pdt_shd.g_old_rec.pdt_attribute26;
572: End If;
573: If (p_rec.pdt_attribute27 = hr_api.g_varchar2) then
574: p_rec.pdt_attribute27 :=
575: ben_pdt_shd.g_old_rec.pdt_attribute27;

Line 575: ben_pdt_shd.g_old_rec.pdt_attribute27;

571: ben_pdt_shd.g_old_rec.pdt_attribute26;
572: End If;
573: If (p_rec.pdt_attribute27 = hr_api.g_varchar2) then
574: p_rec.pdt_attribute27 :=
575: ben_pdt_shd.g_old_rec.pdt_attribute27;
576: End If;
577: If (p_rec.pdt_attribute28 = hr_api.g_varchar2) then
578: p_rec.pdt_attribute28 :=
579: ben_pdt_shd.g_old_rec.pdt_attribute28;

Line 579: ben_pdt_shd.g_old_rec.pdt_attribute28;

575: ben_pdt_shd.g_old_rec.pdt_attribute27;
576: End If;
577: If (p_rec.pdt_attribute28 = hr_api.g_varchar2) then
578: p_rec.pdt_attribute28 :=
579: ben_pdt_shd.g_old_rec.pdt_attribute28;
580: End If;
581: If (p_rec.pdt_attribute29 = hr_api.g_varchar2) then
582: p_rec.pdt_attribute29 :=
583: ben_pdt_shd.g_old_rec.pdt_attribute29;

Line 583: ben_pdt_shd.g_old_rec.pdt_attribute29;

579: ben_pdt_shd.g_old_rec.pdt_attribute28;
580: End If;
581: If (p_rec.pdt_attribute29 = hr_api.g_varchar2) then
582: p_rec.pdt_attribute29 :=
583: ben_pdt_shd.g_old_rec.pdt_attribute29;
584: End If;
585: If (p_rec.pdt_attribute30 = hr_api.g_varchar2) then
586: p_rec.pdt_attribute30 :=
587: ben_pdt_shd.g_old_rec.pdt_attribute30;

Line 587: ben_pdt_shd.g_old_rec.pdt_attribute30;

583: ben_pdt_shd.g_old_rec.pdt_attribute29;
584: End If;
585: If (p_rec.pdt_attribute30 = hr_api.g_varchar2) then
586: p_rec.pdt_attribute30 :=
587: ben_pdt_shd.g_old_rec.pdt_attribute30;
588: End If;
589: --
590: End convert_defs;
591: --

Line 597: ,p_rec in out nocopy ben_pdt_shd.g_rec_type

593: -- |---------------------------------< upd >----------------------------------|
594: -- ----------------------------------------------------------------------------
595: Procedure upd
596: (p_effective_date in date
597: ,p_rec in out nocopy ben_pdt_shd.g_rec_type
598: ) is
599: --
600: l_proc varchar2(72) := g_package||'upd';
601: --

Line 607: ben_pdt_shd.lck

603: hr_utility.set_location('Entering:'||l_proc, 5);
604: --
605: -- We must lock the row which we need to update.
606: --
607: ben_pdt_shd.lck
608: (p_rec.pymt_check_det_id
609: ,p_rec.object_version_number
610: );
611: --

Line 691: l_rec ben_pdt_shd.g_rec_type;

687: ,p_pdt_attribute29 in varchar2 default hr_api.g_varchar2
688: ,p_pdt_attribute30 in varchar2 default hr_api.g_varchar2
689: ) is
690: --
691: l_rec ben_pdt_shd.g_rec_type;
692: l_proc varchar2(72) := g_package||'upd';
693: --
694: Begin
695: hr_utility.set_location('Entering:'||l_proc, 5);

Line 701: ben_pdt_shd.convert_args

697: -- Call conversion function to turn arguments into the
698: -- l_rec structure.
699: --
700: l_rec :=
701: ben_pdt_shd.convert_args
702: (p_pymt_check_det_id
703: ,p_person_id
704: ,p_business_group_id
705: ,p_check_num