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_OTP_DEL dependencies on BEN_OTP_SHD

Line 54: (p_rec in out nocopy ben_otp_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_otp_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 66: ben_otp_shd.g_api_dml := true; -- Set the api dml status

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: ben_otp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: ben_otp_shd.g_api_dml := false; -- Unset the api dml status

71: delete from ben_optip_f
72: where optip_id = p_rec.optip_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: ben_otp_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

Line 77: ben_otp_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: ben_otp_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

Line 86: ben_otp_shd.g_api_dml := false; -- Unset the api dml status

82: delete from ben_optip_f
83: where optip_id = p_rec.optip_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --

Line 93: ben_otp_shd.g_api_dml := false; -- Unset the api dml status

89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
94: Raise;
95: --
96: End dt_delete_dml;
97: --

Line 102: (p_rec in out nocopy ben_otp_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_otp_shd.g_rec_type
103: ,p_effective_date in date
104: ,p_datetrack_mode in varchar2
105: ,p_validation_start_date in date
106: ,p_validation_end_date in date

Line 159: (p_rec in out nocopy ben_otp_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_pre_delete
159: (p_rec in out nocopy ben_otp_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 174: := ben_otp_shd.g_old_rec.effective_start_date;

170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date
174: := ben_otp_shd.g_old_rec.effective_start_date;
175: --
176: If (p_datetrack_mode = hr_api.g_delete) then
177: p_rec.effective_end_date := p_validation_start_date - 1;
178: Else

Line 184: ben_otp_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: ben_otp_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.optip_id
187: ,p_new_effective_end_date => p_rec.effective_end_date
188: ,p_validation_start_date => p_validation_start_date

Line 233: (p_rec in out nocopy ben_otp_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out nocopy ben_otp_shd.g_rec_type
234: ,p_effective_date in date
235: ,p_datetrack_mode in varchar2
236: ,p_validation_start_date in date
237: ,p_validation_end_date in date

Line 293: (p_rec in ben_otp_shd.g_rec_type

289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_delete
293: (p_rec in ben_otp_shd.g_rec_type
294: ,p_effective_date in date
295: ,p_datetrack_mode in varchar2
296: ,p_validation_start_date in date
297: ,p_validation_end_date in date

Line 322: => ben_otp_shd.g_old_rec.effective_start_date

318: => p_rec.effective_start_date
319: ,p_effective_end_date
320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => ben_otp_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => ben_otp_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => ben_otp_shd.g_old_rec.business_group_id

Line 324: => ben_otp_shd.g_old_rec.effective_end_date

320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => ben_otp_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => ben_otp_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => ben_otp_shd.g_old_rec.business_group_id
327: ,p_pgm_id_o
328: => ben_otp_shd.g_old_rec.pgm_id

Line 326: => ben_otp_shd.g_old_rec.business_group_id

322: => ben_otp_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => ben_otp_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => ben_otp_shd.g_old_rec.business_group_id
327: ,p_pgm_id_o
328: => ben_otp_shd.g_old_rec.pgm_id
329: ,p_ptip_id_o
330: => ben_otp_shd.g_old_rec.ptip_id

Line 328: => ben_otp_shd.g_old_rec.pgm_id

324: => ben_otp_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => ben_otp_shd.g_old_rec.business_group_id
327: ,p_pgm_id_o
328: => ben_otp_shd.g_old_rec.pgm_id
329: ,p_ptip_id_o
330: => ben_otp_shd.g_old_rec.ptip_id
331: ,p_pl_typ_id_o
332: => ben_otp_shd.g_old_rec.pl_typ_id

Line 330: => ben_otp_shd.g_old_rec.ptip_id

326: => ben_otp_shd.g_old_rec.business_group_id
327: ,p_pgm_id_o
328: => ben_otp_shd.g_old_rec.pgm_id
329: ,p_ptip_id_o
330: => ben_otp_shd.g_old_rec.ptip_id
331: ,p_pl_typ_id_o
332: => ben_otp_shd.g_old_rec.pl_typ_id
333: ,p_opt_id_o
334: => ben_otp_shd.g_old_rec.opt_id

Line 332: => ben_otp_shd.g_old_rec.pl_typ_id

328: => ben_otp_shd.g_old_rec.pgm_id
329: ,p_ptip_id_o
330: => ben_otp_shd.g_old_rec.ptip_id
331: ,p_pl_typ_id_o
332: => ben_otp_shd.g_old_rec.pl_typ_id
333: ,p_opt_id_o
334: => ben_otp_shd.g_old_rec.opt_id
335: ,p_cmbn_ptip_opt_id_o
336: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id

Line 334: => ben_otp_shd.g_old_rec.opt_id

330: => ben_otp_shd.g_old_rec.ptip_id
331: ,p_pl_typ_id_o
332: => ben_otp_shd.g_old_rec.pl_typ_id
333: ,p_opt_id_o
334: => ben_otp_shd.g_old_rec.opt_id
335: ,p_cmbn_ptip_opt_id_o
336: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id
337: ,p_legislation_code_o
338: => ben_otp_shd.g_old_rec.legislation_code

Line 336: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id

332: => ben_otp_shd.g_old_rec.pl_typ_id
333: ,p_opt_id_o
334: => ben_otp_shd.g_old_rec.opt_id
335: ,p_cmbn_ptip_opt_id_o
336: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id
337: ,p_legislation_code_o
338: => ben_otp_shd.g_old_rec.legislation_code
339: ,p_legislation_subgroup_o
340: => ben_otp_shd.g_old_rec.legislation_subgroup

Line 338: => ben_otp_shd.g_old_rec.legislation_code

334: => ben_otp_shd.g_old_rec.opt_id
335: ,p_cmbn_ptip_opt_id_o
336: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id
337: ,p_legislation_code_o
338: => ben_otp_shd.g_old_rec.legislation_code
339: ,p_legislation_subgroup_o
340: => ben_otp_shd.g_old_rec.legislation_subgroup
341: ,p_otp_attribute_category_o
342: => ben_otp_shd.g_old_rec.otp_attribute_category

Line 340: => ben_otp_shd.g_old_rec.legislation_subgroup

336: => ben_otp_shd.g_old_rec.cmbn_ptip_opt_id
337: ,p_legislation_code_o
338: => ben_otp_shd.g_old_rec.legislation_code
339: ,p_legislation_subgroup_o
340: => ben_otp_shd.g_old_rec.legislation_subgroup
341: ,p_otp_attribute_category_o
342: => ben_otp_shd.g_old_rec.otp_attribute_category
343: ,p_otp_attribute1_o
344: => ben_otp_shd.g_old_rec.otp_attribute1

Line 342: => ben_otp_shd.g_old_rec.otp_attribute_category

338: => ben_otp_shd.g_old_rec.legislation_code
339: ,p_legislation_subgroup_o
340: => ben_otp_shd.g_old_rec.legislation_subgroup
341: ,p_otp_attribute_category_o
342: => ben_otp_shd.g_old_rec.otp_attribute_category
343: ,p_otp_attribute1_o
344: => ben_otp_shd.g_old_rec.otp_attribute1
345: ,p_otp_attribute2_o
346: => ben_otp_shd.g_old_rec.otp_attribute2

Line 344: => ben_otp_shd.g_old_rec.otp_attribute1

340: => ben_otp_shd.g_old_rec.legislation_subgroup
341: ,p_otp_attribute_category_o
342: => ben_otp_shd.g_old_rec.otp_attribute_category
343: ,p_otp_attribute1_o
344: => ben_otp_shd.g_old_rec.otp_attribute1
345: ,p_otp_attribute2_o
346: => ben_otp_shd.g_old_rec.otp_attribute2
347: ,p_otp_attribute3_o
348: => ben_otp_shd.g_old_rec.otp_attribute3

Line 346: => ben_otp_shd.g_old_rec.otp_attribute2

342: => ben_otp_shd.g_old_rec.otp_attribute_category
343: ,p_otp_attribute1_o
344: => ben_otp_shd.g_old_rec.otp_attribute1
345: ,p_otp_attribute2_o
346: => ben_otp_shd.g_old_rec.otp_attribute2
347: ,p_otp_attribute3_o
348: => ben_otp_shd.g_old_rec.otp_attribute3
349: ,p_otp_attribute4_o
350: => ben_otp_shd.g_old_rec.otp_attribute4

Line 348: => ben_otp_shd.g_old_rec.otp_attribute3

344: => ben_otp_shd.g_old_rec.otp_attribute1
345: ,p_otp_attribute2_o
346: => ben_otp_shd.g_old_rec.otp_attribute2
347: ,p_otp_attribute3_o
348: => ben_otp_shd.g_old_rec.otp_attribute3
349: ,p_otp_attribute4_o
350: => ben_otp_shd.g_old_rec.otp_attribute4
351: ,p_otp_attribute5_o
352: => ben_otp_shd.g_old_rec.otp_attribute5

Line 350: => ben_otp_shd.g_old_rec.otp_attribute4

346: => ben_otp_shd.g_old_rec.otp_attribute2
347: ,p_otp_attribute3_o
348: => ben_otp_shd.g_old_rec.otp_attribute3
349: ,p_otp_attribute4_o
350: => ben_otp_shd.g_old_rec.otp_attribute4
351: ,p_otp_attribute5_o
352: => ben_otp_shd.g_old_rec.otp_attribute5
353: ,p_otp_attribute6_o
354: => ben_otp_shd.g_old_rec.otp_attribute6

Line 352: => ben_otp_shd.g_old_rec.otp_attribute5

348: => ben_otp_shd.g_old_rec.otp_attribute3
349: ,p_otp_attribute4_o
350: => ben_otp_shd.g_old_rec.otp_attribute4
351: ,p_otp_attribute5_o
352: => ben_otp_shd.g_old_rec.otp_attribute5
353: ,p_otp_attribute6_o
354: => ben_otp_shd.g_old_rec.otp_attribute6
355: ,p_otp_attribute7_o
356: => ben_otp_shd.g_old_rec.otp_attribute7

Line 354: => ben_otp_shd.g_old_rec.otp_attribute6

350: => ben_otp_shd.g_old_rec.otp_attribute4
351: ,p_otp_attribute5_o
352: => ben_otp_shd.g_old_rec.otp_attribute5
353: ,p_otp_attribute6_o
354: => ben_otp_shd.g_old_rec.otp_attribute6
355: ,p_otp_attribute7_o
356: => ben_otp_shd.g_old_rec.otp_attribute7
357: ,p_otp_attribute8_o
358: => ben_otp_shd.g_old_rec.otp_attribute8

Line 356: => ben_otp_shd.g_old_rec.otp_attribute7

352: => ben_otp_shd.g_old_rec.otp_attribute5
353: ,p_otp_attribute6_o
354: => ben_otp_shd.g_old_rec.otp_attribute6
355: ,p_otp_attribute7_o
356: => ben_otp_shd.g_old_rec.otp_attribute7
357: ,p_otp_attribute8_o
358: => ben_otp_shd.g_old_rec.otp_attribute8
359: ,p_otp_attribute9_o
360: => ben_otp_shd.g_old_rec.otp_attribute9

Line 358: => ben_otp_shd.g_old_rec.otp_attribute8

354: => ben_otp_shd.g_old_rec.otp_attribute6
355: ,p_otp_attribute7_o
356: => ben_otp_shd.g_old_rec.otp_attribute7
357: ,p_otp_attribute8_o
358: => ben_otp_shd.g_old_rec.otp_attribute8
359: ,p_otp_attribute9_o
360: => ben_otp_shd.g_old_rec.otp_attribute9
361: ,p_otp_attribute10_o
362: => ben_otp_shd.g_old_rec.otp_attribute10

Line 360: => ben_otp_shd.g_old_rec.otp_attribute9

356: => ben_otp_shd.g_old_rec.otp_attribute7
357: ,p_otp_attribute8_o
358: => ben_otp_shd.g_old_rec.otp_attribute8
359: ,p_otp_attribute9_o
360: => ben_otp_shd.g_old_rec.otp_attribute9
361: ,p_otp_attribute10_o
362: => ben_otp_shd.g_old_rec.otp_attribute10
363: ,p_otp_attribute11_o
364: => ben_otp_shd.g_old_rec.otp_attribute11

Line 362: => ben_otp_shd.g_old_rec.otp_attribute10

358: => ben_otp_shd.g_old_rec.otp_attribute8
359: ,p_otp_attribute9_o
360: => ben_otp_shd.g_old_rec.otp_attribute9
361: ,p_otp_attribute10_o
362: => ben_otp_shd.g_old_rec.otp_attribute10
363: ,p_otp_attribute11_o
364: => ben_otp_shd.g_old_rec.otp_attribute11
365: ,p_otp_attribute12_o
366: => ben_otp_shd.g_old_rec.otp_attribute12

Line 364: => ben_otp_shd.g_old_rec.otp_attribute11

360: => ben_otp_shd.g_old_rec.otp_attribute9
361: ,p_otp_attribute10_o
362: => ben_otp_shd.g_old_rec.otp_attribute10
363: ,p_otp_attribute11_o
364: => ben_otp_shd.g_old_rec.otp_attribute11
365: ,p_otp_attribute12_o
366: => ben_otp_shd.g_old_rec.otp_attribute12
367: ,p_otp_attribute13_o
368: => ben_otp_shd.g_old_rec.otp_attribute13

Line 366: => ben_otp_shd.g_old_rec.otp_attribute12

362: => ben_otp_shd.g_old_rec.otp_attribute10
363: ,p_otp_attribute11_o
364: => ben_otp_shd.g_old_rec.otp_attribute11
365: ,p_otp_attribute12_o
366: => ben_otp_shd.g_old_rec.otp_attribute12
367: ,p_otp_attribute13_o
368: => ben_otp_shd.g_old_rec.otp_attribute13
369: ,p_otp_attribute14_o
370: => ben_otp_shd.g_old_rec.otp_attribute14

Line 368: => ben_otp_shd.g_old_rec.otp_attribute13

364: => ben_otp_shd.g_old_rec.otp_attribute11
365: ,p_otp_attribute12_o
366: => ben_otp_shd.g_old_rec.otp_attribute12
367: ,p_otp_attribute13_o
368: => ben_otp_shd.g_old_rec.otp_attribute13
369: ,p_otp_attribute14_o
370: => ben_otp_shd.g_old_rec.otp_attribute14
371: ,p_otp_attribute15_o
372: => ben_otp_shd.g_old_rec.otp_attribute15

Line 370: => ben_otp_shd.g_old_rec.otp_attribute14

366: => ben_otp_shd.g_old_rec.otp_attribute12
367: ,p_otp_attribute13_o
368: => ben_otp_shd.g_old_rec.otp_attribute13
369: ,p_otp_attribute14_o
370: => ben_otp_shd.g_old_rec.otp_attribute14
371: ,p_otp_attribute15_o
372: => ben_otp_shd.g_old_rec.otp_attribute15
373: ,p_otp_attribute16_o
374: => ben_otp_shd.g_old_rec.otp_attribute16

Line 372: => ben_otp_shd.g_old_rec.otp_attribute15

368: => ben_otp_shd.g_old_rec.otp_attribute13
369: ,p_otp_attribute14_o
370: => ben_otp_shd.g_old_rec.otp_attribute14
371: ,p_otp_attribute15_o
372: => ben_otp_shd.g_old_rec.otp_attribute15
373: ,p_otp_attribute16_o
374: => ben_otp_shd.g_old_rec.otp_attribute16
375: ,p_otp_attribute17_o
376: => ben_otp_shd.g_old_rec.otp_attribute17

Line 374: => ben_otp_shd.g_old_rec.otp_attribute16

370: => ben_otp_shd.g_old_rec.otp_attribute14
371: ,p_otp_attribute15_o
372: => ben_otp_shd.g_old_rec.otp_attribute15
373: ,p_otp_attribute16_o
374: => ben_otp_shd.g_old_rec.otp_attribute16
375: ,p_otp_attribute17_o
376: => ben_otp_shd.g_old_rec.otp_attribute17
377: ,p_otp_attribute18_o
378: => ben_otp_shd.g_old_rec.otp_attribute18

Line 376: => ben_otp_shd.g_old_rec.otp_attribute17

372: => ben_otp_shd.g_old_rec.otp_attribute15
373: ,p_otp_attribute16_o
374: => ben_otp_shd.g_old_rec.otp_attribute16
375: ,p_otp_attribute17_o
376: => ben_otp_shd.g_old_rec.otp_attribute17
377: ,p_otp_attribute18_o
378: => ben_otp_shd.g_old_rec.otp_attribute18
379: ,p_otp_attribute19_o
380: => ben_otp_shd.g_old_rec.otp_attribute19

Line 378: => ben_otp_shd.g_old_rec.otp_attribute18

374: => ben_otp_shd.g_old_rec.otp_attribute16
375: ,p_otp_attribute17_o
376: => ben_otp_shd.g_old_rec.otp_attribute17
377: ,p_otp_attribute18_o
378: => ben_otp_shd.g_old_rec.otp_attribute18
379: ,p_otp_attribute19_o
380: => ben_otp_shd.g_old_rec.otp_attribute19
381: ,p_otp_attribute20_o
382: => ben_otp_shd.g_old_rec.otp_attribute20

Line 380: => ben_otp_shd.g_old_rec.otp_attribute19

376: => ben_otp_shd.g_old_rec.otp_attribute17
377: ,p_otp_attribute18_o
378: => ben_otp_shd.g_old_rec.otp_attribute18
379: ,p_otp_attribute19_o
380: => ben_otp_shd.g_old_rec.otp_attribute19
381: ,p_otp_attribute20_o
382: => ben_otp_shd.g_old_rec.otp_attribute20
383: ,p_otp_attribute21_o
384: => ben_otp_shd.g_old_rec.otp_attribute21

Line 382: => ben_otp_shd.g_old_rec.otp_attribute20

378: => ben_otp_shd.g_old_rec.otp_attribute18
379: ,p_otp_attribute19_o
380: => ben_otp_shd.g_old_rec.otp_attribute19
381: ,p_otp_attribute20_o
382: => ben_otp_shd.g_old_rec.otp_attribute20
383: ,p_otp_attribute21_o
384: => ben_otp_shd.g_old_rec.otp_attribute21
385: ,p_otp_attribute22_o
386: => ben_otp_shd.g_old_rec.otp_attribute22

Line 384: => ben_otp_shd.g_old_rec.otp_attribute21

380: => ben_otp_shd.g_old_rec.otp_attribute19
381: ,p_otp_attribute20_o
382: => ben_otp_shd.g_old_rec.otp_attribute20
383: ,p_otp_attribute21_o
384: => ben_otp_shd.g_old_rec.otp_attribute21
385: ,p_otp_attribute22_o
386: => ben_otp_shd.g_old_rec.otp_attribute22
387: ,p_otp_attribute23_o
388: => ben_otp_shd.g_old_rec.otp_attribute23

Line 386: => ben_otp_shd.g_old_rec.otp_attribute22

382: => ben_otp_shd.g_old_rec.otp_attribute20
383: ,p_otp_attribute21_o
384: => ben_otp_shd.g_old_rec.otp_attribute21
385: ,p_otp_attribute22_o
386: => ben_otp_shd.g_old_rec.otp_attribute22
387: ,p_otp_attribute23_o
388: => ben_otp_shd.g_old_rec.otp_attribute23
389: ,p_otp_attribute24_o
390: => ben_otp_shd.g_old_rec.otp_attribute24

Line 388: => ben_otp_shd.g_old_rec.otp_attribute23

384: => ben_otp_shd.g_old_rec.otp_attribute21
385: ,p_otp_attribute22_o
386: => ben_otp_shd.g_old_rec.otp_attribute22
387: ,p_otp_attribute23_o
388: => ben_otp_shd.g_old_rec.otp_attribute23
389: ,p_otp_attribute24_o
390: => ben_otp_shd.g_old_rec.otp_attribute24
391: ,p_otp_attribute25_o
392: => ben_otp_shd.g_old_rec.otp_attribute25

Line 390: => ben_otp_shd.g_old_rec.otp_attribute24

386: => ben_otp_shd.g_old_rec.otp_attribute22
387: ,p_otp_attribute23_o
388: => ben_otp_shd.g_old_rec.otp_attribute23
389: ,p_otp_attribute24_o
390: => ben_otp_shd.g_old_rec.otp_attribute24
391: ,p_otp_attribute25_o
392: => ben_otp_shd.g_old_rec.otp_attribute25
393: ,p_otp_attribute26_o
394: => ben_otp_shd.g_old_rec.otp_attribute26

Line 392: => ben_otp_shd.g_old_rec.otp_attribute25

388: => ben_otp_shd.g_old_rec.otp_attribute23
389: ,p_otp_attribute24_o
390: => ben_otp_shd.g_old_rec.otp_attribute24
391: ,p_otp_attribute25_o
392: => ben_otp_shd.g_old_rec.otp_attribute25
393: ,p_otp_attribute26_o
394: => ben_otp_shd.g_old_rec.otp_attribute26
395: ,p_otp_attribute27_o
396: => ben_otp_shd.g_old_rec.otp_attribute27

Line 394: => ben_otp_shd.g_old_rec.otp_attribute26

390: => ben_otp_shd.g_old_rec.otp_attribute24
391: ,p_otp_attribute25_o
392: => ben_otp_shd.g_old_rec.otp_attribute25
393: ,p_otp_attribute26_o
394: => ben_otp_shd.g_old_rec.otp_attribute26
395: ,p_otp_attribute27_o
396: => ben_otp_shd.g_old_rec.otp_attribute27
397: ,p_otp_attribute28_o
398: => ben_otp_shd.g_old_rec.otp_attribute28

Line 396: => ben_otp_shd.g_old_rec.otp_attribute27

392: => ben_otp_shd.g_old_rec.otp_attribute25
393: ,p_otp_attribute26_o
394: => ben_otp_shd.g_old_rec.otp_attribute26
395: ,p_otp_attribute27_o
396: => ben_otp_shd.g_old_rec.otp_attribute27
397: ,p_otp_attribute28_o
398: => ben_otp_shd.g_old_rec.otp_attribute28
399: ,p_otp_attribute29_o
400: => ben_otp_shd.g_old_rec.otp_attribute29

Line 398: => ben_otp_shd.g_old_rec.otp_attribute28

394: => ben_otp_shd.g_old_rec.otp_attribute26
395: ,p_otp_attribute27_o
396: => ben_otp_shd.g_old_rec.otp_attribute27
397: ,p_otp_attribute28_o
398: => ben_otp_shd.g_old_rec.otp_attribute28
399: ,p_otp_attribute29_o
400: => ben_otp_shd.g_old_rec.otp_attribute29
401: ,p_otp_attribute30_o
402: => ben_otp_shd.g_old_rec.otp_attribute30

Line 400: => ben_otp_shd.g_old_rec.otp_attribute29

396: => ben_otp_shd.g_old_rec.otp_attribute27
397: ,p_otp_attribute28_o
398: => ben_otp_shd.g_old_rec.otp_attribute28
399: ,p_otp_attribute29_o
400: => ben_otp_shd.g_old_rec.otp_attribute29
401: ,p_otp_attribute30_o
402: => ben_otp_shd.g_old_rec.otp_attribute30
403: ,p_object_version_number_o
404: => ben_otp_shd.g_old_rec.object_version_number

Line 402: => ben_otp_shd.g_old_rec.otp_attribute30

398: => ben_otp_shd.g_old_rec.otp_attribute28
399: ,p_otp_attribute29_o
400: => ben_otp_shd.g_old_rec.otp_attribute29
401: ,p_otp_attribute30_o
402: => ben_otp_shd.g_old_rec.otp_attribute30
403: ,p_object_version_number_o
404: => ben_otp_shd.g_old_rec.object_version_number
405: );
406: --

Line 404: => ben_otp_shd.g_old_rec.object_version_number

400: => ben_otp_shd.g_old_rec.otp_attribute29
401: ,p_otp_attribute30_o
402: => ben_otp_shd.g_old_rec.otp_attribute30
403: ,p_object_version_number_o
404: => ben_otp_shd.g_old_rec.object_version_number
405: );
406: --
407: exception
408: --

Line 426: ,p_rec in out nocopy ben_otp_shd.g_rec_type

422: -- ----------------------------------------------------------------------------
423: Procedure del
424: (p_effective_date in date
425: ,p_datetrack_mode in varchar2
426: ,p_rec in out nocopy ben_otp_shd.g_rec_type
427: ) is
428: --
429: l_proc varchar2(72) := g_package||'del';
430: l_validation_start_date date;

Line 442: ben_otp_shd.lck

438: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
439: --
440: -- We must lock the row which we need to delete.
441: --
442: ben_otp_shd.lck
443: (p_effective_date => p_effective_date
444: ,p_datetrack_mode => p_datetrack_mode
445: ,p_optip_id => p_rec.optip_id
446: ,p_object_version_number => p_rec.object_version_number

Line 505: l_rec ben_otp_shd.g_rec_type;

501: ,p_effective_start_date out nocopy date
502: ,p_effective_end_date out nocopy date
503: ) is
504: --
505: l_rec ben_otp_shd.g_rec_type;
506: l_proc varchar2(72) := g_package||'del';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);