APPS.BEN_PRY_DEL dependencies on BEN_PRY_SHD

Line 54: (p_rec in out nocopy ben_pry_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_pry_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_pry_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_pry_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_pry_shd.g_api_dml := false; -- Unset the api dml status

71: delete from ben_prtt_rmt_aprvd_fr_pymt_f
72: where prtt_rmt_aprvd_fr_pymt_id = p_rec.prtt_rmt_aprvd_fr_pymt_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: ben_pry_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_pry_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: ben_pry_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_pry_shd.g_api_dml := false; -- Unset the api dml status

82: delete from ben_prtt_rmt_aprvd_fr_pymt_f
83: where prtt_rmt_aprvd_fr_pymt_id = p_rec.prtt_rmt_aprvd_fr_pymt_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: ben_pry_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_pry_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_pry_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_pry_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_pry_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_pry_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_pre_delete
159: (p_rec in out nocopy ben_pry_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_pry_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_pry_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_pry_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: ben_pry_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.prtt_rmt_aprvd_fr_pymt_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_pry_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out nocopy ben_pry_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_pry_shd.g_rec_type

289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_delete
293: (p_rec in ben_pry_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_pry_shd.g_old_rec.prtt_reimbmt_rqst_id

318: => p_rec.effective_start_date
319: ,p_effective_end_date
320: => p_rec.effective_end_date
321: ,p_prtt_reimbmt_rqst_id_o
322: => ben_pry_shd.g_old_rec.prtt_reimbmt_rqst_id
323: ,p_effective_start_date_o
324: => ben_pry_shd.g_old_rec.effective_start_date
325: ,p_effective_end_date_o
326: => ben_pry_shd.g_old_rec.effective_end_date

Line 324: => ben_pry_shd.g_old_rec.effective_start_date

320: => p_rec.effective_end_date
321: ,p_prtt_reimbmt_rqst_id_o
322: => ben_pry_shd.g_old_rec.prtt_reimbmt_rqst_id
323: ,p_effective_start_date_o
324: => ben_pry_shd.g_old_rec.effective_start_date
325: ,p_effective_end_date_o
326: => ben_pry_shd.g_old_rec.effective_end_date
327: ,p_apprvd_fr_pymt_num_o
328: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num

Line 326: => ben_pry_shd.g_old_rec.effective_end_date

322: => ben_pry_shd.g_old_rec.prtt_reimbmt_rqst_id
323: ,p_effective_start_date_o
324: => ben_pry_shd.g_old_rec.effective_start_date
325: ,p_effective_end_date_o
326: => ben_pry_shd.g_old_rec.effective_end_date
327: ,p_apprvd_fr_pymt_num_o
328: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num
329: ,p_adjmt_flag_o
330: => ben_pry_shd.g_old_rec.adjmt_flag

Line 328: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num

324: => ben_pry_shd.g_old_rec.effective_start_date
325: ,p_effective_end_date_o
326: => ben_pry_shd.g_old_rec.effective_end_date
327: ,p_apprvd_fr_pymt_num_o
328: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num
329: ,p_adjmt_flag_o
330: => ben_pry_shd.g_old_rec.adjmt_flag
331: ,p_aprvd_fr_pymt_amt_o
332: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt

Line 330: => ben_pry_shd.g_old_rec.adjmt_flag

326: => ben_pry_shd.g_old_rec.effective_end_date
327: ,p_apprvd_fr_pymt_num_o
328: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num
329: ,p_adjmt_flag_o
330: => ben_pry_shd.g_old_rec.adjmt_flag
331: ,p_aprvd_fr_pymt_amt_o
332: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt
333: ,p_pymt_stat_cd_o
334: => ben_pry_shd.g_old_rec.pymt_stat_cd

Line 332: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt

328: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num
329: ,p_adjmt_flag_o
330: => ben_pry_shd.g_old_rec.adjmt_flag
331: ,p_aprvd_fr_pymt_amt_o
332: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt
333: ,p_pymt_stat_cd_o
334: => ben_pry_shd.g_old_rec.pymt_stat_cd
335: ,p_pymt_stat_rsn_cd_o
336: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd

Line 334: => ben_pry_shd.g_old_rec.pymt_stat_cd

330: => ben_pry_shd.g_old_rec.adjmt_flag
331: ,p_aprvd_fr_pymt_amt_o
332: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt
333: ,p_pymt_stat_cd_o
334: => ben_pry_shd.g_old_rec.pymt_stat_cd
335: ,p_pymt_stat_rsn_cd_o
336: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd
337: ,p_pymt_stat_ovrdn_rsn_cd_o
338: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd

Line 336: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd

332: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt
333: ,p_pymt_stat_cd_o
334: => ben_pry_shd.g_old_rec.pymt_stat_cd
335: ,p_pymt_stat_rsn_cd_o
336: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd
337: ,p_pymt_stat_ovrdn_rsn_cd_o
338: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
339: ,p_pymt_stat_prr_to_ovrd_cd_o
340: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd

Line 338: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd

334: => ben_pry_shd.g_old_rec.pymt_stat_cd
335: ,p_pymt_stat_rsn_cd_o
336: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd
337: ,p_pymt_stat_ovrdn_rsn_cd_o
338: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
339: ,p_pymt_stat_prr_to_ovrd_cd_o
340: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd
341: ,p_business_group_id_o
342: => ben_pry_shd.g_old_rec.business_group_id

Line 340: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd

336: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd
337: ,p_pymt_stat_ovrdn_rsn_cd_o
338: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
339: ,p_pymt_stat_prr_to_ovrd_cd_o
340: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd
341: ,p_business_group_id_o
342: => ben_pry_shd.g_old_rec.business_group_id
343: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
344: ,p_pry_attribute_category_o

Line 342: => ben_pry_shd.g_old_rec.business_group_id

338: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
339: ,p_pymt_stat_prr_to_ovrd_cd_o
340: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd
341: ,p_business_group_id_o
342: => ben_pry_shd.g_old_rec.business_group_id
343: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
344: ,p_pry_attribute_category_o
345: => ben_pry_shd.g_old_rec.pry_attribute_category
346: ,p_pry_attribute1_o

Line 343: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id

339: ,p_pymt_stat_prr_to_ovrd_cd_o
340: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd
341: ,p_business_group_id_o
342: => ben_pry_shd.g_old_rec.business_group_id
343: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
344: ,p_pry_attribute_category_o
345: => ben_pry_shd.g_old_rec.pry_attribute_category
346: ,p_pry_attribute1_o
347: => ben_pry_shd.g_old_rec.pry_attribute1

Line 345: => ben_pry_shd.g_old_rec.pry_attribute_category

341: ,p_business_group_id_o
342: => ben_pry_shd.g_old_rec.business_group_id
343: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
344: ,p_pry_attribute_category_o
345: => ben_pry_shd.g_old_rec.pry_attribute_category
346: ,p_pry_attribute1_o
347: => ben_pry_shd.g_old_rec.pry_attribute1
348: ,p_pry_attribute2_o
349: => ben_pry_shd.g_old_rec.pry_attribute2

Line 347: => ben_pry_shd.g_old_rec.pry_attribute1

343: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
344: ,p_pry_attribute_category_o
345: => ben_pry_shd.g_old_rec.pry_attribute_category
346: ,p_pry_attribute1_o
347: => ben_pry_shd.g_old_rec.pry_attribute1
348: ,p_pry_attribute2_o
349: => ben_pry_shd.g_old_rec.pry_attribute2
350: ,p_pry_attribute3_o
351: => ben_pry_shd.g_old_rec.pry_attribute3

Line 349: => ben_pry_shd.g_old_rec.pry_attribute2

345: => ben_pry_shd.g_old_rec.pry_attribute_category
346: ,p_pry_attribute1_o
347: => ben_pry_shd.g_old_rec.pry_attribute1
348: ,p_pry_attribute2_o
349: => ben_pry_shd.g_old_rec.pry_attribute2
350: ,p_pry_attribute3_o
351: => ben_pry_shd.g_old_rec.pry_attribute3
352: ,p_pry_attribute4_o
353: => ben_pry_shd.g_old_rec.pry_attribute4

Line 351: => ben_pry_shd.g_old_rec.pry_attribute3

347: => ben_pry_shd.g_old_rec.pry_attribute1
348: ,p_pry_attribute2_o
349: => ben_pry_shd.g_old_rec.pry_attribute2
350: ,p_pry_attribute3_o
351: => ben_pry_shd.g_old_rec.pry_attribute3
352: ,p_pry_attribute4_o
353: => ben_pry_shd.g_old_rec.pry_attribute4
354: ,p_pry_attribute5_o
355: => ben_pry_shd.g_old_rec.pry_attribute5

Line 353: => ben_pry_shd.g_old_rec.pry_attribute4

349: => ben_pry_shd.g_old_rec.pry_attribute2
350: ,p_pry_attribute3_o
351: => ben_pry_shd.g_old_rec.pry_attribute3
352: ,p_pry_attribute4_o
353: => ben_pry_shd.g_old_rec.pry_attribute4
354: ,p_pry_attribute5_o
355: => ben_pry_shd.g_old_rec.pry_attribute5
356: ,p_pry_attribute6_o
357: => ben_pry_shd.g_old_rec.pry_attribute6

Line 355: => ben_pry_shd.g_old_rec.pry_attribute5

351: => ben_pry_shd.g_old_rec.pry_attribute3
352: ,p_pry_attribute4_o
353: => ben_pry_shd.g_old_rec.pry_attribute4
354: ,p_pry_attribute5_o
355: => ben_pry_shd.g_old_rec.pry_attribute5
356: ,p_pry_attribute6_o
357: => ben_pry_shd.g_old_rec.pry_attribute6
358: ,p_pry_attribute7_o
359: => ben_pry_shd.g_old_rec.pry_attribute7

Line 357: => ben_pry_shd.g_old_rec.pry_attribute6

353: => ben_pry_shd.g_old_rec.pry_attribute4
354: ,p_pry_attribute5_o
355: => ben_pry_shd.g_old_rec.pry_attribute5
356: ,p_pry_attribute6_o
357: => ben_pry_shd.g_old_rec.pry_attribute6
358: ,p_pry_attribute7_o
359: => ben_pry_shd.g_old_rec.pry_attribute7
360: ,p_pry_attribute8_o
361: => ben_pry_shd.g_old_rec.pry_attribute8

Line 359: => ben_pry_shd.g_old_rec.pry_attribute7

355: => ben_pry_shd.g_old_rec.pry_attribute5
356: ,p_pry_attribute6_o
357: => ben_pry_shd.g_old_rec.pry_attribute6
358: ,p_pry_attribute7_o
359: => ben_pry_shd.g_old_rec.pry_attribute7
360: ,p_pry_attribute8_o
361: => ben_pry_shd.g_old_rec.pry_attribute8
362: ,p_pry_attribute9_o
363: => ben_pry_shd.g_old_rec.pry_attribute9

Line 361: => ben_pry_shd.g_old_rec.pry_attribute8

357: => ben_pry_shd.g_old_rec.pry_attribute6
358: ,p_pry_attribute7_o
359: => ben_pry_shd.g_old_rec.pry_attribute7
360: ,p_pry_attribute8_o
361: => ben_pry_shd.g_old_rec.pry_attribute8
362: ,p_pry_attribute9_o
363: => ben_pry_shd.g_old_rec.pry_attribute9
364: ,p_pry_attribute10_o
365: => ben_pry_shd.g_old_rec.pry_attribute10

Line 363: => ben_pry_shd.g_old_rec.pry_attribute9

359: => ben_pry_shd.g_old_rec.pry_attribute7
360: ,p_pry_attribute8_o
361: => ben_pry_shd.g_old_rec.pry_attribute8
362: ,p_pry_attribute9_o
363: => ben_pry_shd.g_old_rec.pry_attribute9
364: ,p_pry_attribute10_o
365: => ben_pry_shd.g_old_rec.pry_attribute10
366: ,p_pry_attribute11_o
367: => ben_pry_shd.g_old_rec.pry_attribute11

Line 365: => ben_pry_shd.g_old_rec.pry_attribute10

361: => ben_pry_shd.g_old_rec.pry_attribute8
362: ,p_pry_attribute9_o
363: => ben_pry_shd.g_old_rec.pry_attribute9
364: ,p_pry_attribute10_o
365: => ben_pry_shd.g_old_rec.pry_attribute10
366: ,p_pry_attribute11_o
367: => ben_pry_shd.g_old_rec.pry_attribute11
368: ,p_pry_attribute12_o
369: => ben_pry_shd.g_old_rec.pry_attribute12

Line 367: => ben_pry_shd.g_old_rec.pry_attribute11

363: => ben_pry_shd.g_old_rec.pry_attribute9
364: ,p_pry_attribute10_o
365: => ben_pry_shd.g_old_rec.pry_attribute10
366: ,p_pry_attribute11_o
367: => ben_pry_shd.g_old_rec.pry_attribute11
368: ,p_pry_attribute12_o
369: => ben_pry_shd.g_old_rec.pry_attribute12
370: ,p_pry_attribute13_o
371: => ben_pry_shd.g_old_rec.pry_attribute13

Line 369: => ben_pry_shd.g_old_rec.pry_attribute12

365: => ben_pry_shd.g_old_rec.pry_attribute10
366: ,p_pry_attribute11_o
367: => ben_pry_shd.g_old_rec.pry_attribute11
368: ,p_pry_attribute12_o
369: => ben_pry_shd.g_old_rec.pry_attribute12
370: ,p_pry_attribute13_o
371: => ben_pry_shd.g_old_rec.pry_attribute13
372: ,p_pry_attribute14_o
373: => ben_pry_shd.g_old_rec.pry_attribute14

Line 371: => ben_pry_shd.g_old_rec.pry_attribute13

367: => ben_pry_shd.g_old_rec.pry_attribute11
368: ,p_pry_attribute12_o
369: => ben_pry_shd.g_old_rec.pry_attribute12
370: ,p_pry_attribute13_o
371: => ben_pry_shd.g_old_rec.pry_attribute13
372: ,p_pry_attribute14_o
373: => ben_pry_shd.g_old_rec.pry_attribute14
374: ,p_pry_attribute15_o
375: => ben_pry_shd.g_old_rec.pry_attribute15

Line 373: => ben_pry_shd.g_old_rec.pry_attribute14

369: => ben_pry_shd.g_old_rec.pry_attribute12
370: ,p_pry_attribute13_o
371: => ben_pry_shd.g_old_rec.pry_attribute13
372: ,p_pry_attribute14_o
373: => ben_pry_shd.g_old_rec.pry_attribute14
374: ,p_pry_attribute15_o
375: => ben_pry_shd.g_old_rec.pry_attribute15
376: ,p_pry_attribute16_o
377: => ben_pry_shd.g_old_rec.pry_attribute16

Line 375: => ben_pry_shd.g_old_rec.pry_attribute15

371: => ben_pry_shd.g_old_rec.pry_attribute13
372: ,p_pry_attribute14_o
373: => ben_pry_shd.g_old_rec.pry_attribute14
374: ,p_pry_attribute15_o
375: => ben_pry_shd.g_old_rec.pry_attribute15
376: ,p_pry_attribute16_o
377: => ben_pry_shd.g_old_rec.pry_attribute16
378: ,p_pry_attribute17_o
379: => ben_pry_shd.g_old_rec.pry_attribute17

Line 377: => ben_pry_shd.g_old_rec.pry_attribute16

373: => ben_pry_shd.g_old_rec.pry_attribute14
374: ,p_pry_attribute15_o
375: => ben_pry_shd.g_old_rec.pry_attribute15
376: ,p_pry_attribute16_o
377: => ben_pry_shd.g_old_rec.pry_attribute16
378: ,p_pry_attribute17_o
379: => ben_pry_shd.g_old_rec.pry_attribute17
380: ,p_pry_attribute18_o
381: => ben_pry_shd.g_old_rec.pry_attribute18

Line 379: => ben_pry_shd.g_old_rec.pry_attribute17

375: => ben_pry_shd.g_old_rec.pry_attribute15
376: ,p_pry_attribute16_o
377: => ben_pry_shd.g_old_rec.pry_attribute16
378: ,p_pry_attribute17_o
379: => ben_pry_shd.g_old_rec.pry_attribute17
380: ,p_pry_attribute18_o
381: => ben_pry_shd.g_old_rec.pry_attribute18
382: ,p_pry_attribute19_o
383: => ben_pry_shd.g_old_rec.pry_attribute19

Line 381: => ben_pry_shd.g_old_rec.pry_attribute18

377: => ben_pry_shd.g_old_rec.pry_attribute16
378: ,p_pry_attribute17_o
379: => ben_pry_shd.g_old_rec.pry_attribute17
380: ,p_pry_attribute18_o
381: => ben_pry_shd.g_old_rec.pry_attribute18
382: ,p_pry_attribute19_o
383: => ben_pry_shd.g_old_rec.pry_attribute19
384: ,p_pry_attribute20_o
385: => ben_pry_shd.g_old_rec.pry_attribute20

Line 383: => ben_pry_shd.g_old_rec.pry_attribute19

379: => ben_pry_shd.g_old_rec.pry_attribute17
380: ,p_pry_attribute18_o
381: => ben_pry_shd.g_old_rec.pry_attribute18
382: ,p_pry_attribute19_o
383: => ben_pry_shd.g_old_rec.pry_attribute19
384: ,p_pry_attribute20_o
385: => ben_pry_shd.g_old_rec.pry_attribute20
386: ,p_pry_attribute21_o
387: => ben_pry_shd.g_old_rec.pry_attribute21

Line 385: => ben_pry_shd.g_old_rec.pry_attribute20

381: => ben_pry_shd.g_old_rec.pry_attribute18
382: ,p_pry_attribute19_o
383: => ben_pry_shd.g_old_rec.pry_attribute19
384: ,p_pry_attribute20_o
385: => ben_pry_shd.g_old_rec.pry_attribute20
386: ,p_pry_attribute21_o
387: => ben_pry_shd.g_old_rec.pry_attribute21
388: ,p_pry_attribute22_o
389: => ben_pry_shd.g_old_rec.pry_attribute22

Line 387: => ben_pry_shd.g_old_rec.pry_attribute21

383: => ben_pry_shd.g_old_rec.pry_attribute19
384: ,p_pry_attribute20_o
385: => ben_pry_shd.g_old_rec.pry_attribute20
386: ,p_pry_attribute21_o
387: => ben_pry_shd.g_old_rec.pry_attribute21
388: ,p_pry_attribute22_o
389: => ben_pry_shd.g_old_rec.pry_attribute22
390: ,p_pry_attribute23_o
391: => ben_pry_shd.g_old_rec.pry_attribute23

Line 389: => ben_pry_shd.g_old_rec.pry_attribute22

385: => ben_pry_shd.g_old_rec.pry_attribute20
386: ,p_pry_attribute21_o
387: => ben_pry_shd.g_old_rec.pry_attribute21
388: ,p_pry_attribute22_o
389: => ben_pry_shd.g_old_rec.pry_attribute22
390: ,p_pry_attribute23_o
391: => ben_pry_shd.g_old_rec.pry_attribute23
392: ,p_pry_attribute24_o
393: => ben_pry_shd.g_old_rec.pry_attribute24

Line 391: => ben_pry_shd.g_old_rec.pry_attribute23

387: => ben_pry_shd.g_old_rec.pry_attribute21
388: ,p_pry_attribute22_o
389: => ben_pry_shd.g_old_rec.pry_attribute22
390: ,p_pry_attribute23_o
391: => ben_pry_shd.g_old_rec.pry_attribute23
392: ,p_pry_attribute24_o
393: => ben_pry_shd.g_old_rec.pry_attribute24
394: ,p_pry_attribute25_o
395: => ben_pry_shd.g_old_rec.pry_attribute25

Line 393: => ben_pry_shd.g_old_rec.pry_attribute24

389: => ben_pry_shd.g_old_rec.pry_attribute22
390: ,p_pry_attribute23_o
391: => ben_pry_shd.g_old_rec.pry_attribute23
392: ,p_pry_attribute24_o
393: => ben_pry_shd.g_old_rec.pry_attribute24
394: ,p_pry_attribute25_o
395: => ben_pry_shd.g_old_rec.pry_attribute25
396: ,p_pry_attribute26_o
397: => ben_pry_shd.g_old_rec.pry_attribute26

Line 395: => ben_pry_shd.g_old_rec.pry_attribute25

391: => ben_pry_shd.g_old_rec.pry_attribute23
392: ,p_pry_attribute24_o
393: => ben_pry_shd.g_old_rec.pry_attribute24
394: ,p_pry_attribute25_o
395: => ben_pry_shd.g_old_rec.pry_attribute25
396: ,p_pry_attribute26_o
397: => ben_pry_shd.g_old_rec.pry_attribute26
398: ,p_pry_attribute27_o
399: => ben_pry_shd.g_old_rec.pry_attribute27

Line 397: => ben_pry_shd.g_old_rec.pry_attribute26

393: => ben_pry_shd.g_old_rec.pry_attribute24
394: ,p_pry_attribute25_o
395: => ben_pry_shd.g_old_rec.pry_attribute25
396: ,p_pry_attribute26_o
397: => ben_pry_shd.g_old_rec.pry_attribute26
398: ,p_pry_attribute27_o
399: => ben_pry_shd.g_old_rec.pry_attribute27
400: ,p_pry_attribute28_o
401: => ben_pry_shd.g_old_rec.pry_attribute28

Line 399: => ben_pry_shd.g_old_rec.pry_attribute27

395: => ben_pry_shd.g_old_rec.pry_attribute25
396: ,p_pry_attribute26_o
397: => ben_pry_shd.g_old_rec.pry_attribute26
398: ,p_pry_attribute27_o
399: => ben_pry_shd.g_old_rec.pry_attribute27
400: ,p_pry_attribute28_o
401: => ben_pry_shd.g_old_rec.pry_attribute28
402: ,p_pry_attribute29_o
403: => ben_pry_shd.g_old_rec.pry_attribute29

Line 401: => ben_pry_shd.g_old_rec.pry_attribute28

397: => ben_pry_shd.g_old_rec.pry_attribute26
398: ,p_pry_attribute27_o
399: => ben_pry_shd.g_old_rec.pry_attribute27
400: ,p_pry_attribute28_o
401: => ben_pry_shd.g_old_rec.pry_attribute28
402: ,p_pry_attribute29_o
403: => ben_pry_shd.g_old_rec.pry_attribute29
404: ,p_pry_attribute30_o
405: => ben_pry_shd.g_old_rec.pry_attribute30

Line 403: => ben_pry_shd.g_old_rec.pry_attribute29

399: => ben_pry_shd.g_old_rec.pry_attribute27
400: ,p_pry_attribute28_o
401: => ben_pry_shd.g_old_rec.pry_attribute28
402: ,p_pry_attribute29_o
403: => ben_pry_shd.g_old_rec.pry_attribute29
404: ,p_pry_attribute30_o
405: => ben_pry_shd.g_old_rec.pry_attribute30
406: ,p_object_version_number_o
407: => ben_pry_shd.g_old_rec.object_version_number

Line 405: => ben_pry_shd.g_old_rec.pry_attribute30

401: => ben_pry_shd.g_old_rec.pry_attribute28
402: ,p_pry_attribute29_o
403: => ben_pry_shd.g_old_rec.pry_attribute29
404: ,p_pry_attribute30_o
405: => ben_pry_shd.g_old_rec.pry_attribute30
406: ,p_object_version_number_o
407: => ben_pry_shd.g_old_rec.object_version_number
408: );
409: --

Line 407: => ben_pry_shd.g_old_rec.object_version_number

403: => ben_pry_shd.g_old_rec.pry_attribute29
404: ,p_pry_attribute30_o
405: => ben_pry_shd.g_old_rec.pry_attribute30
406: ,p_object_version_number_o
407: => ben_pry_shd.g_old_rec.object_version_number
408: );
409: --
410: exception
411: --

Line 429: ,p_rec in out nocopy ben_pry_shd.g_rec_type

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

Line 445: ben_pry_shd.lck

441: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
442: --
443: -- We must lock the row which we need to delete.
444: --
445: ben_pry_shd.lck
446: (p_effective_date => p_effective_date
447: ,p_datetrack_mode => p_datetrack_mode
448: ,p_prtt_rmt_aprvd_fr_pymt_id => p_rec.prtt_rmt_aprvd_fr_pymt_id
449: ,p_object_version_number => p_rec.object_version_number

Line 508: l_rec ben_pry_shd.g_rec_type;

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