51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ben_pcp_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: ben_pcp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the ben_pl_pcp Row
69: --
70: update ben_pl_pcp
115: ,pcp_attribute30 = p_rec.pcp_attribute30
116: ,object_version_number = p_rec.object_version_number
117: where pl_pcp_id = p_rec.pl_pcp_id;
118: --
119: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: --
123: Exception
122: --
123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
127: ben_pcp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
127: ben_pcp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
127: ben_pcp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
132: ben_pcp_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
132: ben_pcp_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
132: ben_pcp_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
137: ben_pcp_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
137: ben_pcp_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;
136: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
137: ben_pcp_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;
142: End update_dml;
143: --
144: -- ----------------------------------------------------------------------------
173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure pre_update
177: (p_rec in ben_pcp_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package||'pre_update';
181: --
217: --
218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: Procedure post_update
221: (p_rec in ben_pcp_shd.g_rec_type
222: ) is
223: --
224: l_proc varchar2(72) := g_package||'post_update';
225: --
318: => p_rec.pcp_attribute30
319: ,p_object_version_number
320: => p_rec.object_version_number
321: ,p_pl_id_o
322: => ben_pcp_shd.g_old_rec.pl_id
323: ,p_business_group_id_o
324: => ben_pcp_shd.g_old_rec.business_group_id
325: ,p_pcp_strt_dt_cd_o
326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
320: => p_rec.object_version_number
321: ,p_pl_id_o
322: => ben_pcp_shd.g_old_rec.pl_id
323: ,p_business_group_id_o
324: => ben_pcp_shd.g_old_rec.business_group_id
325: ,p_pcp_strt_dt_cd_o
326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
327: ,p_pcp_dsgn_cd_o
328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
322: => ben_pcp_shd.g_old_rec.pl_id
323: ,p_business_group_id_o
324: => ben_pcp_shd.g_old_rec.business_group_id
325: ,p_pcp_strt_dt_cd_o
326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
327: ,p_pcp_dsgn_cd_o
328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
329: ,p_pcp_dpnt_dsgn_cd_o
330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
324: => ben_pcp_shd.g_old_rec.business_group_id
325: ,p_pcp_strt_dt_cd_o
326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
327: ,p_pcp_dsgn_cd_o
328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
329: ,p_pcp_dpnt_dsgn_cd_o
330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
331: ,p_pcp_rpstry_flag_o
332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
326: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
327: ,p_pcp_dsgn_cd_o
328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
329: ,p_pcp_dpnt_dsgn_cd_o
330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
331: ,p_pcp_rpstry_flag_o
332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
333: ,p_pcp_can_keep_flag_o
334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
328: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
329: ,p_pcp_dpnt_dsgn_cd_o
330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
331: ,p_pcp_rpstry_flag_o
332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
333: ,p_pcp_can_keep_flag_o
334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
335: ,p_pcp_radius_o
336: => ben_pcp_shd.g_old_rec.pcp_radius
330: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
331: ,p_pcp_rpstry_flag_o
332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
333: ,p_pcp_can_keep_flag_o
334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
335: ,p_pcp_radius_o
336: => ben_pcp_shd.g_old_rec.pcp_radius
337: ,p_pcp_radius_uom_o
338: => ben_pcp_shd.g_old_rec.pcp_radius_uom
332: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
333: ,p_pcp_can_keep_flag_o
334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
335: ,p_pcp_radius_o
336: => ben_pcp_shd.g_old_rec.pcp_radius
337: ,p_pcp_radius_uom_o
338: => ben_pcp_shd.g_old_rec.pcp_radius_uom
339: ,p_pcp_radius_warn_flag_o
340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
334: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
335: ,p_pcp_radius_o
336: => ben_pcp_shd.g_old_rec.pcp_radius
337: ,p_pcp_radius_uom_o
338: => ben_pcp_shd.g_old_rec.pcp_radius_uom
339: ,p_pcp_radius_warn_flag_o
340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
341: ,p_pcp_num_chgs_o
342: => ben_pcp_shd.g_old_rec.pcp_num_chgs
336: => ben_pcp_shd.g_old_rec.pcp_radius
337: ,p_pcp_radius_uom_o
338: => ben_pcp_shd.g_old_rec.pcp_radius_uom
339: ,p_pcp_radius_warn_flag_o
340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
341: ,p_pcp_num_chgs_o
342: => ben_pcp_shd.g_old_rec.pcp_num_chgs
343: ,p_pcp_num_chgs_uom_o
344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
338: => ben_pcp_shd.g_old_rec.pcp_radius_uom
339: ,p_pcp_radius_warn_flag_o
340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
341: ,p_pcp_num_chgs_o
342: => ben_pcp_shd.g_old_rec.pcp_num_chgs
343: ,p_pcp_num_chgs_uom_o
344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
345: ,p_pcp_attribute_category_o
346: => ben_pcp_shd.g_old_rec.pcp_attribute_category
340: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
341: ,p_pcp_num_chgs_o
342: => ben_pcp_shd.g_old_rec.pcp_num_chgs
343: ,p_pcp_num_chgs_uom_o
344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
345: ,p_pcp_attribute_category_o
346: => ben_pcp_shd.g_old_rec.pcp_attribute_category
347: ,p_pcp_attribute1_o
348: => ben_pcp_shd.g_old_rec.pcp_attribute1
342: => ben_pcp_shd.g_old_rec.pcp_num_chgs
343: ,p_pcp_num_chgs_uom_o
344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
345: ,p_pcp_attribute_category_o
346: => ben_pcp_shd.g_old_rec.pcp_attribute_category
347: ,p_pcp_attribute1_o
348: => ben_pcp_shd.g_old_rec.pcp_attribute1
349: ,p_pcp_attribute2_o
350: => ben_pcp_shd.g_old_rec.pcp_attribute2
344: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
345: ,p_pcp_attribute_category_o
346: => ben_pcp_shd.g_old_rec.pcp_attribute_category
347: ,p_pcp_attribute1_o
348: => ben_pcp_shd.g_old_rec.pcp_attribute1
349: ,p_pcp_attribute2_o
350: => ben_pcp_shd.g_old_rec.pcp_attribute2
351: ,p_pcp_attribute3_o
352: => ben_pcp_shd.g_old_rec.pcp_attribute3
346: => ben_pcp_shd.g_old_rec.pcp_attribute_category
347: ,p_pcp_attribute1_o
348: => ben_pcp_shd.g_old_rec.pcp_attribute1
349: ,p_pcp_attribute2_o
350: => ben_pcp_shd.g_old_rec.pcp_attribute2
351: ,p_pcp_attribute3_o
352: => ben_pcp_shd.g_old_rec.pcp_attribute3
353: ,p_pcp_attribute4_o
354: => ben_pcp_shd.g_old_rec.pcp_attribute4
348: => ben_pcp_shd.g_old_rec.pcp_attribute1
349: ,p_pcp_attribute2_o
350: => ben_pcp_shd.g_old_rec.pcp_attribute2
351: ,p_pcp_attribute3_o
352: => ben_pcp_shd.g_old_rec.pcp_attribute3
353: ,p_pcp_attribute4_o
354: => ben_pcp_shd.g_old_rec.pcp_attribute4
355: ,p_pcp_attribute5_o
356: => ben_pcp_shd.g_old_rec.pcp_attribute5
350: => ben_pcp_shd.g_old_rec.pcp_attribute2
351: ,p_pcp_attribute3_o
352: => ben_pcp_shd.g_old_rec.pcp_attribute3
353: ,p_pcp_attribute4_o
354: => ben_pcp_shd.g_old_rec.pcp_attribute4
355: ,p_pcp_attribute5_o
356: => ben_pcp_shd.g_old_rec.pcp_attribute5
357: ,p_pcp_attribute6_o
358: => ben_pcp_shd.g_old_rec.pcp_attribute6
352: => ben_pcp_shd.g_old_rec.pcp_attribute3
353: ,p_pcp_attribute4_o
354: => ben_pcp_shd.g_old_rec.pcp_attribute4
355: ,p_pcp_attribute5_o
356: => ben_pcp_shd.g_old_rec.pcp_attribute5
357: ,p_pcp_attribute6_o
358: => ben_pcp_shd.g_old_rec.pcp_attribute6
359: ,p_pcp_attribute7_o
360: => ben_pcp_shd.g_old_rec.pcp_attribute7
354: => ben_pcp_shd.g_old_rec.pcp_attribute4
355: ,p_pcp_attribute5_o
356: => ben_pcp_shd.g_old_rec.pcp_attribute5
357: ,p_pcp_attribute6_o
358: => ben_pcp_shd.g_old_rec.pcp_attribute6
359: ,p_pcp_attribute7_o
360: => ben_pcp_shd.g_old_rec.pcp_attribute7
361: ,p_pcp_attribute8_o
362: => ben_pcp_shd.g_old_rec.pcp_attribute8
356: => ben_pcp_shd.g_old_rec.pcp_attribute5
357: ,p_pcp_attribute6_o
358: => ben_pcp_shd.g_old_rec.pcp_attribute6
359: ,p_pcp_attribute7_o
360: => ben_pcp_shd.g_old_rec.pcp_attribute7
361: ,p_pcp_attribute8_o
362: => ben_pcp_shd.g_old_rec.pcp_attribute8
363: ,p_pcp_attribute9_o
364: => ben_pcp_shd.g_old_rec.pcp_attribute9
358: => ben_pcp_shd.g_old_rec.pcp_attribute6
359: ,p_pcp_attribute7_o
360: => ben_pcp_shd.g_old_rec.pcp_attribute7
361: ,p_pcp_attribute8_o
362: => ben_pcp_shd.g_old_rec.pcp_attribute8
363: ,p_pcp_attribute9_o
364: => ben_pcp_shd.g_old_rec.pcp_attribute9
365: ,p_pcp_attribute10_o
366: => ben_pcp_shd.g_old_rec.pcp_attribute10
360: => ben_pcp_shd.g_old_rec.pcp_attribute7
361: ,p_pcp_attribute8_o
362: => ben_pcp_shd.g_old_rec.pcp_attribute8
363: ,p_pcp_attribute9_o
364: => ben_pcp_shd.g_old_rec.pcp_attribute9
365: ,p_pcp_attribute10_o
366: => ben_pcp_shd.g_old_rec.pcp_attribute10
367: ,p_pcp_attribute11_o
368: => ben_pcp_shd.g_old_rec.pcp_attribute11
362: => ben_pcp_shd.g_old_rec.pcp_attribute8
363: ,p_pcp_attribute9_o
364: => ben_pcp_shd.g_old_rec.pcp_attribute9
365: ,p_pcp_attribute10_o
366: => ben_pcp_shd.g_old_rec.pcp_attribute10
367: ,p_pcp_attribute11_o
368: => ben_pcp_shd.g_old_rec.pcp_attribute11
369: ,p_pcp_attribute12_o
370: => ben_pcp_shd.g_old_rec.pcp_attribute12
364: => ben_pcp_shd.g_old_rec.pcp_attribute9
365: ,p_pcp_attribute10_o
366: => ben_pcp_shd.g_old_rec.pcp_attribute10
367: ,p_pcp_attribute11_o
368: => ben_pcp_shd.g_old_rec.pcp_attribute11
369: ,p_pcp_attribute12_o
370: => ben_pcp_shd.g_old_rec.pcp_attribute12
371: ,p_pcp_attribute13_o
372: => ben_pcp_shd.g_old_rec.pcp_attribute13
366: => ben_pcp_shd.g_old_rec.pcp_attribute10
367: ,p_pcp_attribute11_o
368: => ben_pcp_shd.g_old_rec.pcp_attribute11
369: ,p_pcp_attribute12_o
370: => ben_pcp_shd.g_old_rec.pcp_attribute12
371: ,p_pcp_attribute13_o
372: => ben_pcp_shd.g_old_rec.pcp_attribute13
373: ,p_pcp_attribute14_o
374: => ben_pcp_shd.g_old_rec.pcp_attribute14
368: => ben_pcp_shd.g_old_rec.pcp_attribute11
369: ,p_pcp_attribute12_o
370: => ben_pcp_shd.g_old_rec.pcp_attribute12
371: ,p_pcp_attribute13_o
372: => ben_pcp_shd.g_old_rec.pcp_attribute13
373: ,p_pcp_attribute14_o
374: => ben_pcp_shd.g_old_rec.pcp_attribute14
375: ,p_pcp_attribute15_o
376: => ben_pcp_shd.g_old_rec.pcp_attribute15
370: => ben_pcp_shd.g_old_rec.pcp_attribute12
371: ,p_pcp_attribute13_o
372: => ben_pcp_shd.g_old_rec.pcp_attribute13
373: ,p_pcp_attribute14_o
374: => ben_pcp_shd.g_old_rec.pcp_attribute14
375: ,p_pcp_attribute15_o
376: => ben_pcp_shd.g_old_rec.pcp_attribute15
377: ,p_pcp_attribute16_o
378: => ben_pcp_shd.g_old_rec.pcp_attribute16
372: => ben_pcp_shd.g_old_rec.pcp_attribute13
373: ,p_pcp_attribute14_o
374: => ben_pcp_shd.g_old_rec.pcp_attribute14
375: ,p_pcp_attribute15_o
376: => ben_pcp_shd.g_old_rec.pcp_attribute15
377: ,p_pcp_attribute16_o
378: => ben_pcp_shd.g_old_rec.pcp_attribute16
379: ,p_pcp_attribute17_o
380: => ben_pcp_shd.g_old_rec.pcp_attribute17
374: => ben_pcp_shd.g_old_rec.pcp_attribute14
375: ,p_pcp_attribute15_o
376: => ben_pcp_shd.g_old_rec.pcp_attribute15
377: ,p_pcp_attribute16_o
378: => ben_pcp_shd.g_old_rec.pcp_attribute16
379: ,p_pcp_attribute17_o
380: => ben_pcp_shd.g_old_rec.pcp_attribute17
381: ,p_pcp_attribute18_o
382: => ben_pcp_shd.g_old_rec.pcp_attribute18
376: => ben_pcp_shd.g_old_rec.pcp_attribute15
377: ,p_pcp_attribute16_o
378: => ben_pcp_shd.g_old_rec.pcp_attribute16
379: ,p_pcp_attribute17_o
380: => ben_pcp_shd.g_old_rec.pcp_attribute17
381: ,p_pcp_attribute18_o
382: => ben_pcp_shd.g_old_rec.pcp_attribute18
383: ,p_pcp_attribute19_o
384: => ben_pcp_shd.g_old_rec.pcp_attribute19
378: => ben_pcp_shd.g_old_rec.pcp_attribute16
379: ,p_pcp_attribute17_o
380: => ben_pcp_shd.g_old_rec.pcp_attribute17
381: ,p_pcp_attribute18_o
382: => ben_pcp_shd.g_old_rec.pcp_attribute18
383: ,p_pcp_attribute19_o
384: => ben_pcp_shd.g_old_rec.pcp_attribute19
385: ,p_pcp_attribute20_o
386: => ben_pcp_shd.g_old_rec.pcp_attribute20
380: => ben_pcp_shd.g_old_rec.pcp_attribute17
381: ,p_pcp_attribute18_o
382: => ben_pcp_shd.g_old_rec.pcp_attribute18
383: ,p_pcp_attribute19_o
384: => ben_pcp_shd.g_old_rec.pcp_attribute19
385: ,p_pcp_attribute20_o
386: => ben_pcp_shd.g_old_rec.pcp_attribute20
387: ,p_pcp_attribute21_o
388: => ben_pcp_shd.g_old_rec.pcp_attribute21
382: => ben_pcp_shd.g_old_rec.pcp_attribute18
383: ,p_pcp_attribute19_o
384: => ben_pcp_shd.g_old_rec.pcp_attribute19
385: ,p_pcp_attribute20_o
386: => ben_pcp_shd.g_old_rec.pcp_attribute20
387: ,p_pcp_attribute21_o
388: => ben_pcp_shd.g_old_rec.pcp_attribute21
389: ,p_pcp_attribute22_o
390: => ben_pcp_shd.g_old_rec.pcp_attribute22
384: => ben_pcp_shd.g_old_rec.pcp_attribute19
385: ,p_pcp_attribute20_o
386: => ben_pcp_shd.g_old_rec.pcp_attribute20
387: ,p_pcp_attribute21_o
388: => ben_pcp_shd.g_old_rec.pcp_attribute21
389: ,p_pcp_attribute22_o
390: => ben_pcp_shd.g_old_rec.pcp_attribute22
391: ,p_pcp_attribute23_o
392: => ben_pcp_shd.g_old_rec.pcp_attribute23
386: => ben_pcp_shd.g_old_rec.pcp_attribute20
387: ,p_pcp_attribute21_o
388: => ben_pcp_shd.g_old_rec.pcp_attribute21
389: ,p_pcp_attribute22_o
390: => ben_pcp_shd.g_old_rec.pcp_attribute22
391: ,p_pcp_attribute23_o
392: => ben_pcp_shd.g_old_rec.pcp_attribute23
393: ,p_pcp_attribute24_o
394: => ben_pcp_shd.g_old_rec.pcp_attribute24
388: => ben_pcp_shd.g_old_rec.pcp_attribute21
389: ,p_pcp_attribute22_o
390: => ben_pcp_shd.g_old_rec.pcp_attribute22
391: ,p_pcp_attribute23_o
392: => ben_pcp_shd.g_old_rec.pcp_attribute23
393: ,p_pcp_attribute24_o
394: => ben_pcp_shd.g_old_rec.pcp_attribute24
395: ,p_pcp_attribute25_o
396: => ben_pcp_shd.g_old_rec.pcp_attribute25
390: => ben_pcp_shd.g_old_rec.pcp_attribute22
391: ,p_pcp_attribute23_o
392: => ben_pcp_shd.g_old_rec.pcp_attribute23
393: ,p_pcp_attribute24_o
394: => ben_pcp_shd.g_old_rec.pcp_attribute24
395: ,p_pcp_attribute25_o
396: => ben_pcp_shd.g_old_rec.pcp_attribute25
397: ,p_pcp_attribute26_o
398: => ben_pcp_shd.g_old_rec.pcp_attribute26
392: => ben_pcp_shd.g_old_rec.pcp_attribute23
393: ,p_pcp_attribute24_o
394: => ben_pcp_shd.g_old_rec.pcp_attribute24
395: ,p_pcp_attribute25_o
396: => ben_pcp_shd.g_old_rec.pcp_attribute25
397: ,p_pcp_attribute26_o
398: => ben_pcp_shd.g_old_rec.pcp_attribute26
399: ,p_pcp_attribute27_o
400: => ben_pcp_shd.g_old_rec.pcp_attribute27
394: => ben_pcp_shd.g_old_rec.pcp_attribute24
395: ,p_pcp_attribute25_o
396: => ben_pcp_shd.g_old_rec.pcp_attribute25
397: ,p_pcp_attribute26_o
398: => ben_pcp_shd.g_old_rec.pcp_attribute26
399: ,p_pcp_attribute27_o
400: => ben_pcp_shd.g_old_rec.pcp_attribute27
401: ,p_pcp_attribute28_o
402: => ben_pcp_shd.g_old_rec.pcp_attribute28
396: => ben_pcp_shd.g_old_rec.pcp_attribute25
397: ,p_pcp_attribute26_o
398: => ben_pcp_shd.g_old_rec.pcp_attribute26
399: ,p_pcp_attribute27_o
400: => ben_pcp_shd.g_old_rec.pcp_attribute27
401: ,p_pcp_attribute28_o
402: => ben_pcp_shd.g_old_rec.pcp_attribute28
403: ,p_pcp_attribute29_o
404: => ben_pcp_shd.g_old_rec.pcp_attribute29
398: => ben_pcp_shd.g_old_rec.pcp_attribute26
399: ,p_pcp_attribute27_o
400: => ben_pcp_shd.g_old_rec.pcp_attribute27
401: ,p_pcp_attribute28_o
402: => ben_pcp_shd.g_old_rec.pcp_attribute28
403: ,p_pcp_attribute29_o
404: => ben_pcp_shd.g_old_rec.pcp_attribute29
405: ,p_pcp_attribute30_o
406: => ben_pcp_shd.g_old_rec.pcp_attribute30
400: => ben_pcp_shd.g_old_rec.pcp_attribute27
401: ,p_pcp_attribute28_o
402: => ben_pcp_shd.g_old_rec.pcp_attribute28
403: ,p_pcp_attribute29_o
404: => ben_pcp_shd.g_old_rec.pcp_attribute29
405: ,p_pcp_attribute30_o
406: => ben_pcp_shd.g_old_rec.pcp_attribute30
407: ,p_object_version_number_o
408: => ben_pcp_shd.g_old_rec.object_version_number
402: => ben_pcp_shd.g_old_rec.pcp_attribute28
403: ,p_pcp_attribute29_o
404: => ben_pcp_shd.g_old_rec.pcp_attribute29
405: ,p_pcp_attribute30_o
406: => ben_pcp_shd.g_old_rec.pcp_attribute30
407: ,p_object_version_number_o
408: => ben_pcp_shd.g_old_rec.object_version_number
409: );
410: --
404: => ben_pcp_shd.g_old_rec.pcp_attribute29
405: ,p_pcp_attribute30_o
406: => ben_pcp_shd.g_old_rec.pcp_attribute30
407: ,p_object_version_number_o
408: => ben_pcp_shd.g_old_rec.object_version_number
409: );
410: --
411: exception
412: --
464: --
465: -- {End Of Comments}
466: -- ----------------------------------------------------------------------------
467: Procedure convert_defs
468: (p_rec in out nocopy ben_pcp_shd.g_rec_type
469: ) is
470: --
471: Begin
472: --
476: -- is being used then we must set to the 'current' argument value.
477: --
478: If (p_rec.pl_id = hr_api.g_number) then
479: p_rec.pl_id :=
480: ben_pcp_shd.g_old_rec.pl_id;
481: End If;
482: If (p_rec.business_group_id = hr_api.g_number) then
483: p_rec.business_group_id :=
484: ben_pcp_shd.g_old_rec.business_group_id;
480: ben_pcp_shd.g_old_rec.pl_id;
481: End If;
482: If (p_rec.business_group_id = hr_api.g_number) then
483: p_rec.business_group_id :=
484: ben_pcp_shd.g_old_rec.business_group_id;
485: End If;
486: If (p_rec.pcp_strt_dt_cd = hr_api.g_varchar2) then
487: p_rec.pcp_strt_dt_cd :=
488: ben_pcp_shd.g_old_rec.pcp_strt_dt_cd;
484: ben_pcp_shd.g_old_rec.business_group_id;
485: End If;
486: If (p_rec.pcp_strt_dt_cd = hr_api.g_varchar2) then
487: p_rec.pcp_strt_dt_cd :=
488: ben_pcp_shd.g_old_rec.pcp_strt_dt_cd;
489: End If;
490: If (p_rec.pcp_dsgn_cd = hr_api.g_varchar2) then
491: p_rec.pcp_dsgn_cd :=
492: ben_pcp_shd.g_old_rec.pcp_dsgn_cd;
488: ben_pcp_shd.g_old_rec.pcp_strt_dt_cd;
489: End If;
490: If (p_rec.pcp_dsgn_cd = hr_api.g_varchar2) then
491: p_rec.pcp_dsgn_cd :=
492: ben_pcp_shd.g_old_rec.pcp_dsgn_cd;
493: End If;
494: If (p_rec.pcp_dpnt_dsgn_cd = hr_api.g_varchar2) then
495: p_rec.pcp_dpnt_dsgn_cd :=
496: ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd;
492: ben_pcp_shd.g_old_rec.pcp_dsgn_cd;
493: End If;
494: If (p_rec.pcp_dpnt_dsgn_cd = hr_api.g_varchar2) then
495: p_rec.pcp_dpnt_dsgn_cd :=
496: ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd;
497: End If;
498: If (p_rec.pcp_rpstry_flag = hr_api.g_varchar2) then
499: p_rec.pcp_rpstry_flag :=
500: ben_pcp_shd.g_old_rec.pcp_rpstry_flag;
496: ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd;
497: End If;
498: If (p_rec.pcp_rpstry_flag = hr_api.g_varchar2) then
499: p_rec.pcp_rpstry_flag :=
500: ben_pcp_shd.g_old_rec.pcp_rpstry_flag;
501: End If;
502: If (p_rec.pcp_can_keep_flag = hr_api.g_varchar2) then
503: p_rec.pcp_can_keep_flag :=
504: ben_pcp_shd.g_old_rec.pcp_can_keep_flag;
500: ben_pcp_shd.g_old_rec.pcp_rpstry_flag;
501: End If;
502: If (p_rec.pcp_can_keep_flag = hr_api.g_varchar2) then
503: p_rec.pcp_can_keep_flag :=
504: ben_pcp_shd.g_old_rec.pcp_can_keep_flag;
505: End If;
506: If (p_rec.pcp_radius = hr_api.g_number) then
507: p_rec.pcp_radius :=
508: ben_pcp_shd.g_old_rec.pcp_radius;
504: ben_pcp_shd.g_old_rec.pcp_can_keep_flag;
505: End If;
506: If (p_rec.pcp_radius = hr_api.g_number) then
507: p_rec.pcp_radius :=
508: ben_pcp_shd.g_old_rec.pcp_radius;
509: End If;
510: If (p_rec.pcp_radius_uom = hr_api.g_varchar2) then
511: p_rec.pcp_radius_uom :=
512: ben_pcp_shd.g_old_rec.pcp_radius_uom;
508: ben_pcp_shd.g_old_rec.pcp_radius;
509: End If;
510: If (p_rec.pcp_radius_uom = hr_api.g_varchar2) then
511: p_rec.pcp_radius_uom :=
512: ben_pcp_shd.g_old_rec.pcp_radius_uom;
513: End If;
514: If (p_rec.pcp_radius_warn_flag = hr_api.g_varchar2) then
515: p_rec.pcp_radius_warn_flag :=
516: ben_pcp_shd.g_old_rec.pcp_radius_warn_flag;
512: ben_pcp_shd.g_old_rec.pcp_radius_uom;
513: End If;
514: If (p_rec.pcp_radius_warn_flag = hr_api.g_varchar2) then
515: p_rec.pcp_radius_warn_flag :=
516: ben_pcp_shd.g_old_rec.pcp_radius_warn_flag;
517: End If;
518: If (p_rec.pcp_num_chgs = hr_api.g_number) then
519: p_rec.pcp_num_chgs :=
520: ben_pcp_shd.g_old_rec.pcp_num_chgs;
516: ben_pcp_shd.g_old_rec.pcp_radius_warn_flag;
517: End If;
518: If (p_rec.pcp_num_chgs = hr_api.g_number) then
519: p_rec.pcp_num_chgs :=
520: ben_pcp_shd.g_old_rec.pcp_num_chgs;
521: End If;
522: If (p_rec.pcp_num_chgs_uom = hr_api.g_varchar2) then
523: p_rec.pcp_num_chgs_uom :=
524: ben_pcp_shd.g_old_rec.pcp_num_chgs_uom;
520: ben_pcp_shd.g_old_rec.pcp_num_chgs;
521: End If;
522: If (p_rec.pcp_num_chgs_uom = hr_api.g_varchar2) then
523: p_rec.pcp_num_chgs_uom :=
524: ben_pcp_shd.g_old_rec.pcp_num_chgs_uom;
525: End If;
526: If (p_rec.pcp_attribute_category = hr_api.g_varchar2) then
527: p_rec.pcp_attribute_category :=
528: ben_pcp_shd.g_old_rec.pcp_attribute_category;
524: ben_pcp_shd.g_old_rec.pcp_num_chgs_uom;
525: End If;
526: If (p_rec.pcp_attribute_category = hr_api.g_varchar2) then
527: p_rec.pcp_attribute_category :=
528: ben_pcp_shd.g_old_rec.pcp_attribute_category;
529: End If;
530: If (p_rec.pcp_attribute1 = hr_api.g_varchar2) then
531: p_rec.pcp_attribute1 :=
532: ben_pcp_shd.g_old_rec.pcp_attribute1;
528: ben_pcp_shd.g_old_rec.pcp_attribute_category;
529: End If;
530: If (p_rec.pcp_attribute1 = hr_api.g_varchar2) then
531: p_rec.pcp_attribute1 :=
532: ben_pcp_shd.g_old_rec.pcp_attribute1;
533: End If;
534: If (p_rec.pcp_attribute2 = hr_api.g_varchar2) then
535: p_rec.pcp_attribute2 :=
536: ben_pcp_shd.g_old_rec.pcp_attribute2;
532: ben_pcp_shd.g_old_rec.pcp_attribute1;
533: End If;
534: If (p_rec.pcp_attribute2 = hr_api.g_varchar2) then
535: p_rec.pcp_attribute2 :=
536: ben_pcp_shd.g_old_rec.pcp_attribute2;
537: End If;
538: If (p_rec.pcp_attribute3 = hr_api.g_varchar2) then
539: p_rec.pcp_attribute3 :=
540: ben_pcp_shd.g_old_rec.pcp_attribute3;
536: ben_pcp_shd.g_old_rec.pcp_attribute2;
537: End If;
538: If (p_rec.pcp_attribute3 = hr_api.g_varchar2) then
539: p_rec.pcp_attribute3 :=
540: ben_pcp_shd.g_old_rec.pcp_attribute3;
541: End If;
542: If (p_rec.pcp_attribute4 = hr_api.g_varchar2) then
543: p_rec.pcp_attribute4 :=
544: ben_pcp_shd.g_old_rec.pcp_attribute4;
540: ben_pcp_shd.g_old_rec.pcp_attribute3;
541: End If;
542: If (p_rec.pcp_attribute4 = hr_api.g_varchar2) then
543: p_rec.pcp_attribute4 :=
544: ben_pcp_shd.g_old_rec.pcp_attribute4;
545: End If;
546: If (p_rec.pcp_attribute5 = hr_api.g_varchar2) then
547: p_rec.pcp_attribute5 :=
548: ben_pcp_shd.g_old_rec.pcp_attribute5;
544: ben_pcp_shd.g_old_rec.pcp_attribute4;
545: End If;
546: If (p_rec.pcp_attribute5 = hr_api.g_varchar2) then
547: p_rec.pcp_attribute5 :=
548: ben_pcp_shd.g_old_rec.pcp_attribute5;
549: End If;
550: If (p_rec.pcp_attribute6 = hr_api.g_varchar2) then
551: p_rec.pcp_attribute6 :=
552: ben_pcp_shd.g_old_rec.pcp_attribute6;
548: ben_pcp_shd.g_old_rec.pcp_attribute5;
549: End If;
550: If (p_rec.pcp_attribute6 = hr_api.g_varchar2) then
551: p_rec.pcp_attribute6 :=
552: ben_pcp_shd.g_old_rec.pcp_attribute6;
553: End If;
554: If (p_rec.pcp_attribute7 = hr_api.g_varchar2) then
555: p_rec.pcp_attribute7 :=
556: ben_pcp_shd.g_old_rec.pcp_attribute7;
552: ben_pcp_shd.g_old_rec.pcp_attribute6;
553: End If;
554: If (p_rec.pcp_attribute7 = hr_api.g_varchar2) then
555: p_rec.pcp_attribute7 :=
556: ben_pcp_shd.g_old_rec.pcp_attribute7;
557: End If;
558: If (p_rec.pcp_attribute8 = hr_api.g_varchar2) then
559: p_rec.pcp_attribute8 :=
560: ben_pcp_shd.g_old_rec.pcp_attribute8;
556: ben_pcp_shd.g_old_rec.pcp_attribute7;
557: End If;
558: If (p_rec.pcp_attribute8 = hr_api.g_varchar2) then
559: p_rec.pcp_attribute8 :=
560: ben_pcp_shd.g_old_rec.pcp_attribute8;
561: End If;
562: If (p_rec.pcp_attribute9 = hr_api.g_varchar2) then
563: p_rec.pcp_attribute9 :=
564: ben_pcp_shd.g_old_rec.pcp_attribute9;
560: ben_pcp_shd.g_old_rec.pcp_attribute8;
561: End If;
562: If (p_rec.pcp_attribute9 = hr_api.g_varchar2) then
563: p_rec.pcp_attribute9 :=
564: ben_pcp_shd.g_old_rec.pcp_attribute9;
565: End If;
566: If (p_rec.pcp_attribute10 = hr_api.g_varchar2) then
567: p_rec.pcp_attribute10 :=
568: ben_pcp_shd.g_old_rec.pcp_attribute10;
564: ben_pcp_shd.g_old_rec.pcp_attribute9;
565: End If;
566: If (p_rec.pcp_attribute10 = hr_api.g_varchar2) then
567: p_rec.pcp_attribute10 :=
568: ben_pcp_shd.g_old_rec.pcp_attribute10;
569: End If;
570: If (p_rec.pcp_attribute11 = hr_api.g_varchar2) then
571: p_rec.pcp_attribute11 :=
572: ben_pcp_shd.g_old_rec.pcp_attribute11;
568: ben_pcp_shd.g_old_rec.pcp_attribute10;
569: End If;
570: If (p_rec.pcp_attribute11 = hr_api.g_varchar2) then
571: p_rec.pcp_attribute11 :=
572: ben_pcp_shd.g_old_rec.pcp_attribute11;
573: End If;
574: If (p_rec.pcp_attribute12 = hr_api.g_varchar2) then
575: p_rec.pcp_attribute12 :=
576: ben_pcp_shd.g_old_rec.pcp_attribute12;
572: ben_pcp_shd.g_old_rec.pcp_attribute11;
573: End If;
574: If (p_rec.pcp_attribute12 = hr_api.g_varchar2) then
575: p_rec.pcp_attribute12 :=
576: ben_pcp_shd.g_old_rec.pcp_attribute12;
577: End If;
578: If (p_rec.pcp_attribute13 = hr_api.g_varchar2) then
579: p_rec.pcp_attribute13 :=
580: ben_pcp_shd.g_old_rec.pcp_attribute13;
576: ben_pcp_shd.g_old_rec.pcp_attribute12;
577: End If;
578: If (p_rec.pcp_attribute13 = hr_api.g_varchar2) then
579: p_rec.pcp_attribute13 :=
580: ben_pcp_shd.g_old_rec.pcp_attribute13;
581: End If;
582: If (p_rec.pcp_attribute14 = hr_api.g_varchar2) then
583: p_rec.pcp_attribute14 :=
584: ben_pcp_shd.g_old_rec.pcp_attribute14;
580: ben_pcp_shd.g_old_rec.pcp_attribute13;
581: End If;
582: If (p_rec.pcp_attribute14 = hr_api.g_varchar2) then
583: p_rec.pcp_attribute14 :=
584: ben_pcp_shd.g_old_rec.pcp_attribute14;
585: End If;
586: If (p_rec.pcp_attribute15 = hr_api.g_varchar2) then
587: p_rec.pcp_attribute15 :=
588: ben_pcp_shd.g_old_rec.pcp_attribute15;
584: ben_pcp_shd.g_old_rec.pcp_attribute14;
585: End If;
586: If (p_rec.pcp_attribute15 = hr_api.g_varchar2) then
587: p_rec.pcp_attribute15 :=
588: ben_pcp_shd.g_old_rec.pcp_attribute15;
589: End If;
590: If (p_rec.pcp_attribute16 = hr_api.g_varchar2) then
591: p_rec.pcp_attribute16 :=
592: ben_pcp_shd.g_old_rec.pcp_attribute16;
588: ben_pcp_shd.g_old_rec.pcp_attribute15;
589: End If;
590: If (p_rec.pcp_attribute16 = hr_api.g_varchar2) then
591: p_rec.pcp_attribute16 :=
592: ben_pcp_shd.g_old_rec.pcp_attribute16;
593: End If;
594: If (p_rec.pcp_attribute17 = hr_api.g_varchar2) then
595: p_rec.pcp_attribute17 :=
596: ben_pcp_shd.g_old_rec.pcp_attribute17;
592: ben_pcp_shd.g_old_rec.pcp_attribute16;
593: End If;
594: If (p_rec.pcp_attribute17 = hr_api.g_varchar2) then
595: p_rec.pcp_attribute17 :=
596: ben_pcp_shd.g_old_rec.pcp_attribute17;
597: End If;
598: If (p_rec.pcp_attribute18 = hr_api.g_varchar2) then
599: p_rec.pcp_attribute18 :=
600: ben_pcp_shd.g_old_rec.pcp_attribute18;
596: ben_pcp_shd.g_old_rec.pcp_attribute17;
597: End If;
598: If (p_rec.pcp_attribute18 = hr_api.g_varchar2) then
599: p_rec.pcp_attribute18 :=
600: ben_pcp_shd.g_old_rec.pcp_attribute18;
601: End If;
602: If (p_rec.pcp_attribute19 = hr_api.g_varchar2) then
603: p_rec.pcp_attribute19 :=
604: ben_pcp_shd.g_old_rec.pcp_attribute19;
600: ben_pcp_shd.g_old_rec.pcp_attribute18;
601: End If;
602: If (p_rec.pcp_attribute19 = hr_api.g_varchar2) then
603: p_rec.pcp_attribute19 :=
604: ben_pcp_shd.g_old_rec.pcp_attribute19;
605: End If;
606: If (p_rec.pcp_attribute20 = hr_api.g_varchar2) then
607: p_rec.pcp_attribute20 :=
608: ben_pcp_shd.g_old_rec.pcp_attribute20;
604: ben_pcp_shd.g_old_rec.pcp_attribute19;
605: End If;
606: If (p_rec.pcp_attribute20 = hr_api.g_varchar2) then
607: p_rec.pcp_attribute20 :=
608: ben_pcp_shd.g_old_rec.pcp_attribute20;
609: End If;
610: If (p_rec.pcp_attribute21 = hr_api.g_varchar2) then
611: p_rec.pcp_attribute21 :=
612: ben_pcp_shd.g_old_rec.pcp_attribute21;
608: ben_pcp_shd.g_old_rec.pcp_attribute20;
609: End If;
610: If (p_rec.pcp_attribute21 = hr_api.g_varchar2) then
611: p_rec.pcp_attribute21 :=
612: ben_pcp_shd.g_old_rec.pcp_attribute21;
613: End If;
614: If (p_rec.pcp_attribute22 = hr_api.g_varchar2) then
615: p_rec.pcp_attribute22 :=
616: ben_pcp_shd.g_old_rec.pcp_attribute22;
612: ben_pcp_shd.g_old_rec.pcp_attribute21;
613: End If;
614: If (p_rec.pcp_attribute22 = hr_api.g_varchar2) then
615: p_rec.pcp_attribute22 :=
616: ben_pcp_shd.g_old_rec.pcp_attribute22;
617: End If;
618: If (p_rec.pcp_attribute23 = hr_api.g_varchar2) then
619: p_rec.pcp_attribute23 :=
620: ben_pcp_shd.g_old_rec.pcp_attribute23;
616: ben_pcp_shd.g_old_rec.pcp_attribute22;
617: End If;
618: If (p_rec.pcp_attribute23 = hr_api.g_varchar2) then
619: p_rec.pcp_attribute23 :=
620: ben_pcp_shd.g_old_rec.pcp_attribute23;
621: End If;
622: If (p_rec.pcp_attribute24 = hr_api.g_varchar2) then
623: p_rec.pcp_attribute24 :=
624: ben_pcp_shd.g_old_rec.pcp_attribute24;
620: ben_pcp_shd.g_old_rec.pcp_attribute23;
621: End If;
622: If (p_rec.pcp_attribute24 = hr_api.g_varchar2) then
623: p_rec.pcp_attribute24 :=
624: ben_pcp_shd.g_old_rec.pcp_attribute24;
625: End If;
626: If (p_rec.pcp_attribute25 = hr_api.g_varchar2) then
627: p_rec.pcp_attribute25 :=
628: ben_pcp_shd.g_old_rec.pcp_attribute25;
624: ben_pcp_shd.g_old_rec.pcp_attribute24;
625: End If;
626: If (p_rec.pcp_attribute25 = hr_api.g_varchar2) then
627: p_rec.pcp_attribute25 :=
628: ben_pcp_shd.g_old_rec.pcp_attribute25;
629: End If;
630: If (p_rec.pcp_attribute26 = hr_api.g_varchar2) then
631: p_rec.pcp_attribute26 :=
632: ben_pcp_shd.g_old_rec.pcp_attribute26;
628: ben_pcp_shd.g_old_rec.pcp_attribute25;
629: End If;
630: If (p_rec.pcp_attribute26 = hr_api.g_varchar2) then
631: p_rec.pcp_attribute26 :=
632: ben_pcp_shd.g_old_rec.pcp_attribute26;
633: End If;
634: If (p_rec.pcp_attribute27 = hr_api.g_varchar2) then
635: p_rec.pcp_attribute27 :=
636: ben_pcp_shd.g_old_rec.pcp_attribute27;
632: ben_pcp_shd.g_old_rec.pcp_attribute26;
633: End If;
634: If (p_rec.pcp_attribute27 = hr_api.g_varchar2) then
635: p_rec.pcp_attribute27 :=
636: ben_pcp_shd.g_old_rec.pcp_attribute27;
637: End If;
638: If (p_rec.pcp_attribute28 = hr_api.g_varchar2) then
639: p_rec.pcp_attribute28 :=
640: ben_pcp_shd.g_old_rec.pcp_attribute28;
636: ben_pcp_shd.g_old_rec.pcp_attribute27;
637: End If;
638: If (p_rec.pcp_attribute28 = hr_api.g_varchar2) then
639: p_rec.pcp_attribute28 :=
640: ben_pcp_shd.g_old_rec.pcp_attribute28;
641: End If;
642: If (p_rec.pcp_attribute29 = hr_api.g_varchar2) then
643: p_rec.pcp_attribute29 :=
644: ben_pcp_shd.g_old_rec.pcp_attribute29;
640: ben_pcp_shd.g_old_rec.pcp_attribute28;
641: End If;
642: If (p_rec.pcp_attribute29 = hr_api.g_varchar2) then
643: p_rec.pcp_attribute29 :=
644: ben_pcp_shd.g_old_rec.pcp_attribute29;
645: End If;
646: If (p_rec.pcp_attribute30 = hr_api.g_varchar2) then
647: p_rec.pcp_attribute30 :=
648: ben_pcp_shd.g_old_rec.pcp_attribute30;
644: ben_pcp_shd.g_old_rec.pcp_attribute29;
645: End If;
646: If (p_rec.pcp_attribute30 = hr_api.g_varchar2) then
647: p_rec.pcp_attribute30 :=
648: ben_pcp_shd.g_old_rec.pcp_attribute30;
649: End If;
650: --
651: End convert_defs;
652: --
654: -- |---------------------------------< upd >----------------------------------|
655: -- ----------------------------------------------------------------------------
656: Procedure upd
657: (p_effective_date in date,
658: p_rec in out nocopy ben_pcp_shd.g_rec_type )
659: is
660: --
661: l_proc varchar2(72) := g_package||'upd';
662: --
664: hr_utility.set_location('Entering:'||l_proc, 5);
665: --
666: -- We must lock the row which we need to update.
667: --
668: ben_pcp_shd.lck
669: (p_rec.pl_pcp_id
670: ,p_rec.object_version_number
671: );
672: --
747: ,p_pcp_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcp_attribute30 in varchar2 default hr_api.g_varchar2
749: ) is
750: --
751: l_rec ben_pcp_shd.g_rec_type;
752: l_proc varchar2(72) := g_package||'upd';
753: --
754: Begin
755: hr_utility.set_location('Entering:'||l_proc, 5);
757: -- Call conversion function to turn arguments into the
758: -- l_rec structure.
759: --
760: l_rec :=
761: ben_pcp_shd.convert_args
762: (p_pl_pcp_id
763: ,p_pl_id
764: ,p_business_group_id
765: ,p_pcp_strt_dt_cd