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_PCD_DEL dependencies on BEN_PCD_SHD

Line 54: (p_rec in out nocopy ben_pcd_shd.g_rec_type,

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_pcd_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) is

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

62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: ben_pcd_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_pcd_shd.g_api_dml := false; -- Unset the api dml status

71: delete from ben_per_cm_prvdd_f
72: where per_cm_prvdd_id = p_rec.per_cm_prvdd_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_pcd_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_pcd_shd.g_api_dml := true; -- Set the api dml status
79: --

Line 78: ben_pcd_shd.g_api_dml := true; -- Set the api dml status

74: --
75: ben_pcd_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_pcd_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --

Line 87: ben_pcd_shd.g_api_dml := false; -- Unset the api dml status

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

Line 94: ben_pcd_shd.g_api_dml := false; -- Unset the api dml status

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

Line 102: (p_rec in out nocopy ben_pcd_shd.g_rec_type,

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_pcd_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) is

Line 156: (p_rec in out nocopy ben_pcd_shd.g_rec_type,

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ben_pcd_shd.g_rec_type,
157: p_effective_date in date,
158: p_datetrack_mode in varchar2,
159: p_validation_start_date in date,
160: p_validation_end_date in date) is

Line 169: p_rec.effective_start_date := ben_pcd_shd.g_old_rec.effective_start_date;

165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := ben_pcd_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = 'DELETE') then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: ben_pcd_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_pcd_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.per_cm_prvdd_id,
182: p_new_effective_end_date => p_rec.effective_end_date,
183: p_validation_start_date => p_validation_start_date,

Line 227: (p_rec in out nocopy ben_pcd_shd.g_rec_type,

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_delete
227: (p_rec in out nocopy ben_pcd_shd.g_rec_type,
228: p_effective_date in date,
229: p_datetrack_mode in varchar2,
230: p_validation_start_date in date,
231: p_validation_end_date in date) is

Line 285: (p_rec in ben_pcd_shd.g_rec_type,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_pcd_shd.g_rec_type,
286: p_effective_date in date,
287: p_datetrack_mode in varchar2,
288: p_validation_start_date in date,
289: p_validation_end_date in date) is

Line 309: ,p_effective_start_date_o =>ben_pcd_shd.g_old_rec.effective_start_date

305: ,p_validation_start_date =>p_validation_start_date
306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pcd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcd_shd.g_old_rec.effective_end_date
311: ,p_rqstd_flag_o =>ben_pcd_shd.g_old_rec.rqstd_flag
312: ,p_inspn_rqd_flag_o =>ben_pcd_shd.g_old_rec.inspn_rqd_flag
313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd

Line 310: ,p_effective_end_date_o =>ben_pcd_shd.g_old_rec.effective_end_date

306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pcd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcd_shd.g_old_rec.effective_end_date
311: ,p_rqstd_flag_o =>ben_pcd_shd.g_old_rec.rqstd_flag
312: ,p_inspn_rqd_flag_o =>ben_pcd_shd.g_old_rec.inspn_rqd_flag
313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd
314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt

Line 311: ,p_rqstd_flag_o =>ben_pcd_shd.g_old_rec.rqstd_flag

307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pcd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcd_shd.g_old_rec.effective_end_date
311: ,p_rqstd_flag_o =>ben_pcd_shd.g_old_rec.rqstd_flag
312: ,p_inspn_rqd_flag_o =>ben_pcd_shd.g_old_rec.inspn_rqd_flag
313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd
314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt
315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd

Line 312: ,p_inspn_rqd_flag_o =>ben_pcd_shd.g_old_rec.inspn_rqd_flag

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>ben_pcd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcd_shd.g_old_rec.effective_end_date
311: ,p_rqstd_flag_o =>ben_pcd_shd.g_old_rec.rqstd_flag
312: ,p_inspn_rqd_flag_o =>ben_pcd_shd.g_old_rec.inspn_rqd_flag
313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd
314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt
315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd
316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd

Line 313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd

309: ,p_effective_start_date_o =>ben_pcd_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>ben_pcd_shd.g_old_rec.effective_end_date
311: ,p_rqstd_flag_o =>ben_pcd_shd.g_old_rec.rqstd_flag
312: ,p_inspn_rqd_flag_o =>ben_pcd_shd.g_old_rec.inspn_rqd_flag
313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd
314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt
315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd
316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd
317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd

Line 314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt

310: ,p_effective_end_date_o =>ben_pcd_shd.g_old_rec.effective_end_date
311: ,p_rqstd_flag_o =>ben_pcd_shd.g_old_rec.rqstd_flag
312: ,p_inspn_rqd_flag_o =>ben_pcd_shd.g_old_rec.inspn_rqd_flag
313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd
314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt
315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd
316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd
317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd
318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt

Line 315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd

311: ,p_rqstd_flag_o =>ben_pcd_shd.g_old_rec.rqstd_flag
312: ,p_inspn_rqd_flag_o =>ben_pcd_shd.g_old_rec.inspn_rqd_flag
313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd
314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt
315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd
316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd
317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd
318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt
319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num

Line 316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd

312: ,p_inspn_rqd_flag_o =>ben_pcd_shd.g_old_rec.inspn_rqd_flag
313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd
314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt
315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd
316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd
317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd
318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt
319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num
320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt

Line 317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd

313: ,p_resnd_rsn_cd_o =>ben_pcd_shd.g_old_rec.resnd_rsn_cd
314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt
315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd
316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd
317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd
318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt
319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num
320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt
321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt

Line 318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt

314: ,p_resnd_cmnt_txt_o =>ben_pcd_shd.g_old_rec.resnd_cmnt_txt
315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd
316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd
317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd
318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt
319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num
320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt
321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt
322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id

Line 319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num

315: ,p_per_cm_prvdd_stat_cd_o =>ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd
316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd
317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd
318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt
319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num
320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt
321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt
322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id
323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id

Line 320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt

316: ,p_cm_dlvry_med_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_med_cd
317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd
318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt
319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num
320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt
321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt
322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id
323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id
324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id

Line 321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt

317: ,p_cm_dlvry_mthd_cd_o =>ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd
318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt
319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num
320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt
321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt
322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id
323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id
324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id
325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category

Line 322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id

318: ,p_sent_dt_o =>ben_pcd_shd.g_old_rec.sent_dt
319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num
320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt
321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt
322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id
323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id
324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id
325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category
326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1

Line 323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id

319: ,p_instnc_num_o =>ben_pcd_shd.g_old_rec.instnc_num
320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt
321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt
322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id
323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id
324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id
325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category
326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1
327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2

Line 324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id

320: ,p_to_be_sent_dt_o =>ben_pcd_shd.g_old_rec.to_be_sent_dt
321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt
322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id
323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id
324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id
325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category
326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1
327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2
328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3

Line 325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category

321: ,p_dlvry_instn_txt_o =>ben_pcd_shd.g_old_rec.dlvry_instn_txt
322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id
323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id
324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id
325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category
326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1
327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2
328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3
329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4

Line 326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1

322: ,p_per_cm_id_o =>ben_pcd_shd.g_old_rec.per_cm_id
323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id
324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id
325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category
326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1
327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2
328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3
329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4
330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5

Line 327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2

323: ,p_address_id_o =>ben_pcd_shd.g_old_rec.address_id
324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id
325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category
326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1
327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2
328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3
329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4
330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5
331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6

Line 328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3

324: ,p_business_group_id_o =>ben_pcd_shd.g_old_rec.business_group_id
325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category
326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1
327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2
328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3
329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4
330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5
331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6
332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7

Line 329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4

325: ,p_pcd_attribute_category_o =>ben_pcd_shd.g_old_rec.pcd_attribute_category
326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1
327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2
328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3
329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4
330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5
331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6
332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7
333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8

Line 330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5

326: ,p_pcd_attribute1_o =>ben_pcd_shd.g_old_rec.pcd_attribute1
327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2
328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3
329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4
330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5
331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6
332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7
333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8
334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9

Line 331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6

327: ,p_pcd_attribute2_o =>ben_pcd_shd.g_old_rec.pcd_attribute2
328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3
329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4
330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5
331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6
332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7
333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8
334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9
335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10

Line 332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7

328: ,p_pcd_attribute3_o =>ben_pcd_shd.g_old_rec.pcd_attribute3
329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4
330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5
331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6
332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7
333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8
334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9
335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10
336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11

Line 333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8

329: ,p_pcd_attribute4_o =>ben_pcd_shd.g_old_rec.pcd_attribute4
330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5
331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6
332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7
333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8
334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9
335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10
336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11
337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12

Line 334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9

330: ,p_pcd_attribute5_o =>ben_pcd_shd.g_old_rec.pcd_attribute5
331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6
332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7
333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8
334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9
335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10
336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11
337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12
338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13

Line 335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10

331: ,p_pcd_attribute6_o =>ben_pcd_shd.g_old_rec.pcd_attribute6
332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7
333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8
334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9
335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10
336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11
337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12
338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13
339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14

Line 336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11

332: ,p_pcd_attribute7_o =>ben_pcd_shd.g_old_rec.pcd_attribute7
333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8
334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9
335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10
336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11
337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12
338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13
339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14
340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15

Line 337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12

333: ,p_pcd_attribute8_o =>ben_pcd_shd.g_old_rec.pcd_attribute8
334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9
335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10
336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11
337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12
338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13
339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14
340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15
341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16

Line 338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13

334: ,p_pcd_attribute9_o =>ben_pcd_shd.g_old_rec.pcd_attribute9
335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10
336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11
337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12
338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13
339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14
340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15
341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16
342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17

Line 339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14

335: ,p_pcd_attribute10_o =>ben_pcd_shd.g_old_rec.pcd_attribute10
336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11
337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12
338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13
339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14
340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15
341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16
342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17
343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18

Line 340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15

336: ,p_pcd_attribute11_o =>ben_pcd_shd.g_old_rec.pcd_attribute11
337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12
338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13
339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14
340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15
341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16
342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17
343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18
344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19

Line 341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16

337: ,p_pcd_attribute12_o =>ben_pcd_shd.g_old_rec.pcd_attribute12
338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13
339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14
340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15
341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16
342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17
343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18
344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19
345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20

Line 342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17

338: ,p_pcd_attribute13_o =>ben_pcd_shd.g_old_rec.pcd_attribute13
339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14
340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15
341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16
342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17
343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18
344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19
345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20
346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21

Line 343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18

339: ,p_pcd_attribute14_o =>ben_pcd_shd.g_old_rec.pcd_attribute14
340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15
341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16
342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17
343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18
344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19
345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20
346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21
347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22

Line 344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19

340: ,p_pcd_attribute15_o =>ben_pcd_shd.g_old_rec.pcd_attribute15
341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16
342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17
343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18
344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19
345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20
346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21
347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22
348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23

Line 345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20

341: ,p_pcd_attribute16_o =>ben_pcd_shd.g_old_rec.pcd_attribute16
342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17
343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18
344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19
345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20
346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21
347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22
348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23
349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24

Line 346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21

342: ,p_pcd_attribute17_o =>ben_pcd_shd.g_old_rec.pcd_attribute17
343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18
344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19
345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20
346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21
347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22
348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23
349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24
350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25

Line 347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22

343: ,p_pcd_attribute18_o =>ben_pcd_shd.g_old_rec.pcd_attribute18
344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19
345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20
346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21
347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22
348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23
349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24
350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25
351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26

Line 348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23

344: ,p_pcd_attribute19_o =>ben_pcd_shd.g_old_rec.pcd_attribute19
345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20
346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21
347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22
348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23
349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24
350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25
351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26
352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27

Line 349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24

345: ,p_pcd_attribute20_o =>ben_pcd_shd.g_old_rec.pcd_attribute20
346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21
347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22
348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23
349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24
350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25
351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26
352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27
353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28

Line 350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25

346: ,p_pcd_attribute21_o =>ben_pcd_shd.g_old_rec.pcd_attribute21
347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22
348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23
349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24
350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25
351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26
352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27
353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28
354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29

Line 351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26

347: ,p_pcd_attribute22_o =>ben_pcd_shd.g_old_rec.pcd_attribute22
348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23
349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24
350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25
351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26
352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27
353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28
354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29
355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30

Line 352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27

348: ,p_pcd_attribute23_o =>ben_pcd_shd.g_old_rec.pcd_attribute23
349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24
350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25
351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26
352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27
353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28
354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29
355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30
356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id

Line 353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28

349: ,p_pcd_attribute24_o =>ben_pcd_shd.g_old_rec.pcd_attribute24
350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25
351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26
352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27
353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28
354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29
355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30
356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id
357: ,p_program_application_id_o =>ben_pcd_shd.g_old_rec.program_application_id

Line 354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29

350: ,p_pcd_attribute25_o =>ben_pcd_shd.g_old_rec.pcd_attribute25
351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26
352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27
353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28
354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29
355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30
356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id
357: ,p_program_application_id_o =>ben_pcd_shd.g_old_rec.program_application_id
358: ,p_program_id_o =>ben_pcd_shd.g_old_rec.program_id

Line 355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30

351: ,p_pcd_attribute26_o =>ben_pcd_shd.g_old_rec.pcd_attribute26
352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27
353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28
354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29
355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30
356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id
357: ,p_program_application_id_o =>ben_pcd_shd.g_old_rec.program_application_id
358: ,p_program_id_o =>ben_pcd_shd.g_old_rec.program_id
359: ,p_program_update_date_o =>ben_pcd_shd.g_old_rec.program_update_date

Line 356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id

352: ,p_pcd_attribute27_o =>ben_pcd_shd.g_old_rec.pcd_attribute27
353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28
354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29
355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30
356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id
357: ,p_program_application_id_o =>ben_pcd_shd.g_old_rec.program_application_id
358: ,p_program_id_o =>ben_pcd_shd.g_old_rec.program_id
359: ,p_program_update_date_o =>ben_pcd_shd.g_old_rec.program_update_date
360: ,p_object_version_number_o =>ben_pcd_shd.g_old_rec.object_version_number

Line 357: ,p_program_application_id_o =>ben_pcd_shd.g_old_rec.program_application_id

353: ,p_pcd_attribute28_o =>ben_pcd_shd.g_old_rec.pcd_attribute28
354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29
355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30
356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id
357: ,p_program_application_id_o =>ben_pcd_shd.g_old_rec.program_application_id
358: ,p_program_id_o =>ben_pcd_shd.g_old_rec.program_id
359: ,p_program_update_date_o =>ben_pcd_shd.g_old_rec.program_update_date
360: ,p_object_version_number_o =>ben_pcd_shd.g_old_rec.object_version_number
361: );

Line 358: ,p_program_id_o =>ben_pcd_shd.g_old_rec.program_id

354: ,p_pcd_attribute29_o =>ben_pcd_shd.g_old_rec.pcd_attribute29
355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30
356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id
357: ,p_program_application_id_o =>ben_pcd_shd.g_old_rec.program_application_id
358: ,p_program_id_o =>ben_pcd_shd.g_old_rec.program_id
359: ,p_program_update_date_o =>ben_pcd_shd.g_old_rec.program_update_date
360: ,p_object_version_number_o =>ben_pcd_shd.g_old_rec.object_version_number
361: );
362: --

Line 359: ,p_program_update_date_o =>ben_pcd_shd.g_old_rec.program_update_date

355: ,p_pcd_attribute30_o =>ben_pcd_shd.g_old_rec.pcd_attribute30
356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id
357: ,p_program_application_id_o =>ben_pcd_shd.g_old_rec.program_application_id
358: ,p_program_id_o =>ben_pcd_shd.g_old_rec.program_id
359: ,p_program_update_date_o =>ben_pcd_shd.g_old_rec.program_update_date
360: ,p_object_version_number_o =>ben_pcd_shd.g_old_rec.object_version_number
361: );
362: --
363: exception

Line 360: ,p_object_version_number_o =>ben_pcd_shd.g_old_rec.object_version_number

356: ,p_request_id_o =>ben_pcd_shd.g_old_rec.request_id
357: ,p_program_application_id_o =>ben_pcd_shd.g_old_rec.program_application_id
358: ,p_program_id_o =>ben_pcd_shd.g_old_rec.program_id
359: ,p_program_update_date_o =>ben_pcd_shd.g_old_rec.program_update_date
360: ,p_object_version_number_o =>ben_pcd_shd.g_old_rec.object_version_number
361: );
362: --
363: exception
364: --

Line 384: p_rec in out nocopy ben_pcd_shd.g_rec_type,

380: -- |---------------------------------< del >----------------------------------|
381: -- ----------------------------------------------------------------------------
382: Procedure del
383: (
384: p_rec in out nocopy ben_pcd_shd.g_rec_type,
385: p_effective_date in date,
386: p_datetrack_mode in varchar2
387: ) is
388: --

Line 402: ben_pcd_shd.lck

398: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
399: --
400: -- We must lock the row which we need to delete.
401: --
402: ben_pcd_shd.lck
403: (p_effective_date => p_effective_date,
404: p_datetrack_mode => p_datetrack_mode,
405: p_per_cm_prvdd_id => p_rec.per_cm_prvdd_id,
406: p_object_version_number => p_rec.object_version_number,

Line 460: l_rec ben_pcd_shd.g_rec_type;

456: p_effective_date in date,
457: p_datetrack_mode in varchar2
458: ) is
459: --
460: l_rec ben_pcd_shd.g_rec_type;
461: l_proc varchar2(72) := g_package||'del';
462: --
463: Begin
464: hr_utility.set_location('Entering:'||l_proc, 5);