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_CMT_UPD dependencies on BEN_CMT_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_cmt_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_cmt_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ben_cmt_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_cmt_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_cm_dlvry_mthd_typ Row
68: --
69: update ben_cm_dlvry_mthd_typ

Line 111: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status

107: dflt_flag = p_rec.dflt_flag,
108: object_version_number = p_rec.object_version_number
109: where cm_dlvry_mthd_typ_id = p_rec.cm_dlvry_mthd_typ_id;
110: --
111: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: --
115: Exception

Line 118: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status

114: --
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
119: ben_cmt_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated

Line 119: ben_cmt_shd.constraint_error

115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
119: ben_cmt_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status

Line 123: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status

119: ben_cmt_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
124: ben_cmt_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated

Line 124: ben_cmt_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
124: ben_cmt_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status

Line 128: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status

124: ben_cmt_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
129: ben_cmt_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status

Line 129: ben_cmt_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
129: ben_cmt_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;

Line 132: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status

128: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
129: ben_cmt_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;
134: End update_dml;
135: --
136: -- ----------------------------------------------------------------------------

Line 168: Procedure pre_update(p_rec in ben_cmt_shd.g_rec_type) is

164: -- Internal Row Handler Use Only.
165: --
166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168: Procedure pre_update(p_rec in ben_cmt_shd.g_rec_type) is
169: --
170: l_proc varchar2(72) := g_package||'pre_update';
171: --
172: Begin

Line 211: p_effective_date in date,p_rec in ben_cmt_shd.g_rec_type) is

207: --
208: -- {End Of Comments}
209: -- ----------------------------------------------------------------------------
210: Procedure post_update(
211: p_effective_date in date,p_rec in ben_cmt_shd.g_rec_type) is
212: --
213: l_proc varchar2(72) := g_package||'post_update';
214: --
215: Begin

Line 264: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd

260: ,p_cmt_attribute9 =>p_rec.cmt_attribute9
261: ,p_dflt_flag =>p_rec.dflt_flag
262: ,p_object_version_number =>p_rec.object_version_number
263: ,p_effective_date =>p_effective_date
264: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
265: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
266: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
267: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10

Line 265: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id

261: ,p_dflt_flag =>p_rec.dflt_flag
262: ,p_object_version_number =>p_rec.object_version_number
263: ,p_effective_date =>p_effective_date
264: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
265: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
266: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
267: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11

Line 266: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id

262: ,p_object_version_number =>p_rec.object_version_number
263: ,p_effective_date =>p_effective_date
264: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
265: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
266: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
267: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12

Line 267: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1

263: ,p_effective_date =>p_effective_date
264: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
265: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
266: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
267: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13

Line 268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10

264: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
265: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
266: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
267: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14

Line 269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11

265: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
266: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
267: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15

Line 270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12

266: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
267: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16

Line 271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13

267: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17

Line 272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14

268: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18

Line 273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15

269: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19

Line 274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16

270: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2

Line 275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17

271: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20

Line 276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18

272: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21

Line 277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19

273: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22

Line 278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2

274: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23

Line 279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20

275: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24

Line 280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21

276: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25

Line 281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22

277: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26

Line 282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23

278: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27

Line 283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24

279: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28

Line 284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25

280: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29

Line 285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26

281: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3

Line 286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27

282: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30

Line 287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28

283: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag

Line 288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29

284: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category

Line 289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3

285: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4

Line 290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30

286: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5

Line 291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag

287: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6

Line 292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category

288: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7

Line 293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4

289: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
297: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8

Line 294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5

290: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
297: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
298: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9

Line 295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6

291: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
297: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
298: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
299: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag

Line 296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7

292: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
297: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
298: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
299: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
300: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number

Line 297: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8

293: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
297: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
298: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
299: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
300: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number
301: );

Line 298: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9

294: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
297: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
298: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
299: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
300: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number
301: );
302: --

Line 299: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag

295: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
297: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
298: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
299: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
300: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number
301: );
302: --
303: exception

Line 300: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number

296: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
297: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
298: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
299: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
300: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number
301: );
302: --
303: exception
304: --

Line 362: Procedure convert_defs(p_rec in out nocopy ben_cmt_shd.g_rec_type) is

358: -- Internal Row Handler Use Only.
359: --
360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure convert_defs(p_rec in out nocopy ben_cmt_shd.g_rec_type) is
363: --
364: l_proc varchar2(72) := g_package||'convert_defs';
365: --
366: Begin

Line 377: ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd;

373: -- is being used then we must set to the 'current' argument value.
374: --
375: If (p_rec.cm_dlvry_mthd_typ_cd = hr_api.g_varchar2) then
376: p_rec.cm_dlvry_mthd_typ_cd :=
377: ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd;
378: End If;
379: If (p_rec.business_group_id = hr_api.g_number) then
380: p_rec.business_group_id :=
381: ben_cmt_shd.g_old_rec.business_group_id;

Line 381: ben_cmt_shd.g_old_rec.business_group_id;

377: ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd;
378: End If;
379: If (p_rec.business_group_id = hr_api.g_number) then
380: p_rec.business_group_id :=
381: ben_cmt_shd.g_old_rec.business_group_id;
382: End If;
383: If (p_rec.cm_typ_id = hr_api.g_number) then
384: p_rec.cm_typ_id :=
385: ben_cmt_shd.g_old_rec.cm_typ_id;

Line 385: ben_cmt_shd.g_old_rec.cm_typ_id;

381: ben_cmt_shd.g_old_rec.business_group_id;
382: End If;
383: If (p_rec.cm_typ_id = hr_api.g_number) then
384: p_rec.cm_typ_id :=
385: ben_cmt_shd.g_old_rec.cm_typ_id;
386: End If;
387: If (p_rec.cmt_attribute1 = hr_api.g_varchar2) then
388: p_rec.cmt_attribute1 :=
389: ben_cmt_shd.g_old_rec.cmt_attribute1;

Line 389: ben_cmt_shd.g_old_rec.cmt_attribute1;

385: ben_cmt_shd.g_old_rec.cm_typ_id;
386: End If;
387: If (p_rec.cmt_attribute1 = hr_api.g_varchar2) then
388: p_rec.cmt_attribute1 :=
389: ben_cmt_shd.g_old_rec.cmt_attribute1;
390: End If;
391: If (p_rec.cmt_attribute10 = hr_api.g_varchar2) then
392: p_rec.cmt_attribute10 :=
393: ben_cmt_shd.g_old_rec.cmt_attribute10;

Line 393: ben_cmt_shd.g_old_rec.cmt_attribute10;

389: ben_cmt_shd.g_old_rec.cmt_attribute1;
390: End If;
391: If (p_rec.cmt_attribute10 = hr_api.g_varchar2) then
392: p_rec.cmt_attribute10 :=
393: ben_cmt_shd.g_old_rec.cmt_attribute10;
394: End If;
395: If (p_rec.cmt_attribute11 = hr_api.g_varchar2) then
396: p_rec.cmt_attribute11 :=
397: ben_cmt_shd.g_old_rec.cmt_attribute11;

Line 397: ben_cmt_shd.g_old_rec.cmt_attribute11;

393: ben_cmt_shd.g_old_rec.cmt_attribute10;
394: End If;
395: If (p_rec.cmt_attribute11 = hr_api.g_varchar2) then
396: p_rec.cmt_attribute11 :=
397: ben_cmt_shd.g_old_rec.cmt_attribute11;
398: End If;
399: If (p_rec.cmt_attribute12 = hr_api.g_varchar2) then
400: p_rec.cmt_attribute12 :=
401: ben_cmt_shd.g_old_rec.cmt_attribute12;

Line 401: ben_cmt_shd.g_old_rec.cmt_attribute12;

397: ben_cmt_shd.g_old_rec.cmt_attribute11;
398: End If;
399: If (p_rec.cmt_attribute12 = hr_api.g_varchar2) then
400: p_rec.cmt_attribute12 :=
401: ben_cmt_shd.g_old_rec.cmt_attribute12;
402: End If;
403: If (p_rec.cmt_attribute13 = hr_api.g_varchar2) then
404: p_rec.cmt_attribute13 :=
405: ben_cmt_shd.g_old_rec.cmt_attribute13;

Line 405: ben_cmt_shd.g_old_rec.cmt_attribute13;

401: ben_cmt_shd.g_old_rec.cmt_attribute12;
402: End If;
403: If (p_rec.cmt_attribute13 = hr_api.g_varchar2) then
404: p_rec.cmt_attribute13 :=
405: ben_cmt_shd.g_old_rec.cmt_attribute13;
406: End If;
407: If (p_rec.cmt_attribute14 = hr_api.g_varchar2) then
408: p_rec.cmt_attribute14 :=
409: ben_cmt_shd.g_old_rec.cmt_attribute14;

Line 409: ben_cmt_shd.g_old_rec.cmt_attribute14;

405: ben_cmt_shd.g_old_rec.cmt_attribute13;
406: End If;
407: If (p_rec.cmt_attribute14 = hr_api.g_varchar2) then
408: p_rec.cmt_attribute14 :=
409: ben_cmt_shd.g_old_rec.cmt_attribute14;
410: End If;
411: If (p_rec.cmt_attribute15 = hr_api.g_varchar2) then
412: p_rec.cmt_attribute15 :=
413: ben_cmt_shd.g_old_rec.cmt_attribute15;

Line 413: ben_cmt_shd.g_old_rec.cmt_attribute15;

409: ben_cmt_shd.g_old_rec.cmt_attribute14;
410: End If;
411: If (p_rec.cmt_attribute15 = hr_api.g_varchar2) then
412: p_rec.cmt_attribute15 :=
413: ben_cmt_shd.g_old_rec.cmt_attribute15;
414: End If;
415: If (p_rec.cmt_attribute16 = hr_api.g_varchar2) then
416: p_rec.cmt_attribute16 :=
417: ben_cmt_shd.g_old_rec.cmt_attribute16;

Line 417: ben_cmt_shd.g_old_rec.cmt_attribute16;

413: ben_cmt_shd.g_old_rec.cmt_attribute15;
414: End If;
415: If (p_rec.cmt_attribute16 = hr_api.g_varchar2) then
416: p_rec.cmt_attribute16 :=
417: ben_cmt_shd.g_old_rec.cmt_attribute16;
418: End If;
419: If (p_rec.cmt_attribute17 = hr_api.g_varchar2) then
420: p_rec.cmt_attribute17 :=
421: ben_cmt_shd.g_old_rec.cmt_attribute17;

Line 421: ben_cmt_shd.g_old_rec.cmt_attribute17;

417: ben_cmt_shd.g_old_rec.cmt_attribute16;
418: End If;
419: If (p_rec.cmt_attribute17 = hr_api.g_varchar2) then
420: p_rec.cmt_attribute17 :=
421: ben_cmt_shd.g_old_rec.cmt_attribute17;
422: End If;
423: If (p_rec.cmt_attribute18 = hr_api.g_varchar2) then
424: p_rec.cmt_attribute18 :=
425: ben_cmt_shd.g_old_rec.cmt_attribute18;

Line 425: ben_cmt_shd.g_old_rec.cmt_attribute18;

421: ben_cmt_shd.g_old_rec.cmt_attribute17;
422: End If;
423: If (p_rec.cmt_attribute18 = hr_api.g_varchar2) then
424: p_rec.cmt_attribute18 :=
425: ben_cmt_shd.g_old_rec.cmt_attribute18;
426: End If;
427: If (p_rec.cmt_attribute19 = hr_api.g_varchar2) then
428: p_rec.cmt_attribute19 :=
429: ben_cmt_shd.g_old_rec.cmt_attribute19;

Line 429: ben_cmt_shd.g_old_rec.cmt_attribute19;

425: ben_cmt_shd.g_old_rec.cmt_attribute18;
426: End If;
427: If (p_rec.cmt_attribute19 = hr_api.g_varchar2) then
428: p_rec.cmt_attribute19 :=
429: ben_cmt_shd.g_old_rec.cmt_attribute19;
430: End If;
431: If (p_rec.cmt_attribute2 = hr_api.g_varchar2) then
432: p_rec.cmt_attribute2 :=
433: ben_cmt_shd.g_old_rec.cmt_attribute2;

Line 433: ben_cmt_shd.g_old_rec.cmt_attribute2;

429: ben_cmt_shd.g_old_rec.cmt_attribute19;
430: End If;
431: If (p_rec.cmt_attribute2 = hr_api.g_varchar2) then
432: p_rec.cmt_attribute2 :=
433: ben_cmt_shd.g_old_rec.cmt_attribute2;
434: End If;
435: If (p_rec.cmt_attribute20 = hr_api.g_varchar2) then
436: p_rec.cmt_attribute20 :=
437: ben_cmt_shd.g_old_rec.cmt_attribute20;

Line 437: ben_cmt_shd.g_old_rec.cmt_attribute20;

433: ben_cmt_shd.g_old_rec.cmt_attribute2;
434: End If;
435: If (p_rec.cmt_attribute20 = hr_api.g_varchar2) then
436: p_rec.cmt_attribute20 :=
437: ben_cmt_shd.g_old_rec.cmt_attribute20;
438: End If;
439: If (p_rec.cmt_attribute21 = hr_api.g_varchar2) then
440: p_rec.cmt_attribute21 :=
441: ben_cmt_shd.g_old_rec.cmt_attribute21;

Line 441: ben_cmt_shd.g_old_rec.cmt_attribute21;

437: ben_cmt_shd.g_old_rec.cmt_attribute20;
438: End If;
439: If (p_rec.cmt_attribute21 = hr_api.g_varchar2) then
440: p_rec.cmt_attribute21 :=
441: ben_cmt_shd.g_old_rec.cmt_attribute21;
442: End If;
443: If (p_rec.cmt_attribute22 = hr_api.g_varchar2) then
444: p_rec.cmt_attribute22 :=
445: ben_cmt_shd.g_old_rec.cmt_attribute22;

Line 445: ben_cmt_shd.g_old_rec.cmt_attribute22;

441: ben_cmt_shd.g_old_rec.cmt_attribute21;
442: End If;
443: If (p_rec.cmt_attribute22 = hr_api.g_varchar2) then
444: p_rec.cmt_attribute22 :=
445: ben_cmt_shd.g_old_rec.cmt_attribute22;
446: End If;
447: If (p_rec.cmt_attribute23 = hr_api.g_varchar2) then
448: p_rec.cmt_attribute23 :=
449: ben_cmt_shd.g_old_rec.cmt_attribute23;

Line 449: ben_cmt_shd.g_old_rec.cmt_attribute23;

445: ben_cmt_shd.g_old_rec.cmt_attribute22;
446: End If;
447: If (p_rec.cmt_attribute23 = hr_api.g_varchar2) then
448: p_rec.cmt_attribute23 :=
449: ben_cmt_shd.g_old_rec.cmt_attribute23;
450: End If;
451: If (p_rec.cmt_attribute24 = hr_api.g_varchar2) then
452: p_rec.cmt_attribute24 :=
453: ben_cmt_shd.g_old_rec.cmt_attribute24;

Line 453: ben_cmt_shd.g_old_rec.cmt_attribute24;

449: ben_cmt_shd.g_old_rec.cmt_attribute23;
450: End If;
451: If (p_rec.cmt_attribute24 = hr_api.g_varchar2) then
452: p_rec.cmt_attribute24 :=
453: ben_cmt_shd.g_old_rec.cmt_attribute24;
454: End If;
455: If (p_rec.cmt_attribute25 = hr_api.g_varchar2) then
456: p_rec.cmt_attribute25 :=
457: ben_cmt_shd.g_old_rec.cmt_attribute25;

Line 457: ben_cmt_shd.g_old_rec.cmt_attribute25;

453: ben_cmt_shd.g_old_rec.cmt_attribute24;
454: End If;
455: If (p_rec.cmt_attribute25 = hr_api.g_varchar2) then
456: p_rec.cmt_attribute25 :=
457: ben_cmt_shd.g_old_rec.cmt_attribute25;
458: End If;
459: If (p_rec.cmt_attribute26 = hr_api.g_varchar2) then
460: p_rec.cmt_attribute26 :=
461: ben_cmt_shd.g_old_rec.cmt_attribute26;

Line 461: ben_cmt_shd.g_old_rec.cmt_attribute26;

457: ben_cmt_shd.g_old_rec.cmt_attribute25;
458: End If;
459: If (p_rec.cmt_attribute26 = hr_api.g_varchar2) then
460: p_rec.cmt_attribute26 :=
461: ben_cmt_shd.g_old_rec.cmt_attribute26;
462: End If;
463: If (p_rec.cmt_attribute27 = hr_api.g_varchar2) then
464: p_rec.cmt_attribute27 :=
465: ben_cmt_shd.g_old_rec.cmt_attribute27;

Line 465: ben_cmt_shd.g_old_rec.cmt_attribute27;

461: ben_cmt_shd.g_old_rec.cmt_attribute26;
462: End If;
463: If (p_rec.cmt_attribute27 = hr_api.g_varchar2) then
464: p_rec.cmt_attribute27 :=
465: ben_cmt_shd.g_old_rec.cmt_attribute27;
466: End If;
467: If (p_rec.cmt_attribute28 = hr_api.g_varchar2) then
468: p_rec.cmt_attribute28 :=
469: ben_cmt_shd.g_old_rec.cmt_attribute28;

Line 469: ben_cmt_shd.g_old_rec.cmt_attribute28;

465: ben_cmt_shd.g_old_rec.cmt_attribute27;
466: End If;
467: If (p_rec.cmt_attribute28 = hr_api.g_varchar2) then
468: p_rec.cmt_attribute28 :=
469: ben_cmt_shd.g_old_rec.cmt_attribute28;
470: End If;
471: If (p_rec.cmt_attribute29 = hr_api.g_varchar2) then
472: p_rec.cmt_attribute29 :=
473: ben_cmt_shd.g_old_rec.cmt_attribute29;

Line 473: ben_cmt_shd.g_old_rec.cmt_attribute29;

469: ben_cmt_shd.g_old_rec.cmt_attribute28;
470: End If;
471: If (p_rec.cmt_attribute29 = hr_api.g_varchar2) then
472: p_rec.cmt_attribute29 :=
473: ben_cmt_shd.g_old_rec.cmt_attribute29;
474: End If;
475: If (p_rec.cmt_attribute3 = hr_api.g_varchar2) then
476: p_rec.cmt_attribute3 :=
477: ben_cmt_shd.g_old_rec.cmt_attribute3;

Line 477: ben_cmt_shd.g_old_rec.cmt_attribute3;

473: ben_cmt_shd.g_old_rec.cmt_attribute29;
474: End If;
475: If (p_rec.cmt_attribute3 = hr_api.g_varchar2) then
476: p_rec.cmt_attribute3 :=
477: ben_cmt_shd.g_old_rec.cmt_attribute3;
478: End If;
479: If (p_rec.cmt_attribute30 = hr_api.g_varchar2) then
480: p_rec.cmt_attribute30 :=
481: ben_cmt_shd.g_old_rec.cmt_attribute30;

Line 481: ben_cmt_shd.g_old_rec.cmt_attribute30;

477: ben_cmt_shd.g_old_rec.cmt_attribute3;
478: End If;
479: If (p_rec.cmt_attribute30 = hr_api.g_varchar2) then
480: p_rec.cmt_attribute30 :=
481: ben_cmt_shd.g_old_rec.cmt_attribute30;
482: End If;
483: If (p_rec.rqd_flag = hr_api.g_varchar2) then
484: p_rec.rqd_flag :=
485: ben_cmt_shd.g_old_rec.rqd_flag;

Line 485: ben_cmt_shd.g_old_rec.rqd_flag;

481: ben_cmt_shd.g_old_rec.cmt_attribute30;
482: End If;
483: If (p_rec.rqd_flag = hr_api.g_varchar2) then
484: p_rec.rqd_flag :=
485: ben_cmt_shd.g_old_rec.rqd_flag;
486: End If;
487: If (p_rec.cmt_attribute_category = hr_api.g_varchar2) then
488: p_rec.cmt_attribute_category :=
489: ben_cmt_shd.g_old_rec.cmt_attribute_category;

Line 489: ben_cmt_shd.g_old_rec.cmt_attribute_category;

485: ben_cmt_shd.g_old_rec.rqd_flag;
486: End If;
487: If (p_rec.cmt_attribute_category = hr_api.g_varchar2) then
488: p_rec.cmt_attribute_category :=
489: ben_cmt_shd.g_old_rec.cmt_attribute_category;
490: End If;
491: If (p_rec.cmt_attribute4 = hr_api.g_varchar2) then
492: p_rec.cmt_attribute4 :=
493: ben_cmt_shd.g_old_rec.cmt_attribute4;

Line 493: ben_cmt_shd.g_old_rec.cmt_attribute4;

489: ben_cmt_shd.g_old_rec.cmt_attribute_category;
490: End If;
491: If (p_rec.cmt_attribute4 = hr_api.g_varchar2) then
492: p_rec.cmt_attribute4 :=
493: ben_cmt_shd.g_old_rec.cmt_attribute4;
494: End If;
495: If (p_rec.cmt_attribute5 = hr_api.g_varchar2) then
496: p_rec.cmt_attribute5 :=
497: ben_cmt_shd.g_old_rec.cmt_attribute5;

Line 497: ben_cmt_shd.g_old_rec.cmt_attribute5;

493: ben_cmt_shd.g_old_rec.cmt_attribute4;
494: End If;
495: If (p_rec.cmt_attribute5 = hr_api.g_varchar2) then
496: p_rec.cmt_attribute5 :=
497: ben_cmt_shd.g_old_rec.cmt_attribute5;
498: End If;
499: If (p_rec.cmt_attribute6 = hr_api.g_varchar2) then
500: p_rec.cmt_attribute6 :=
501: ben_cmt_shd.g_old_rec.cmt_attribute6;

Line 501: ben_cmt_shd.g_old_rec.cmt_attribute6;

497: ben_cmt_shd.g_old_rec.cmt_attribute5;
498: End If;
499: If (p_rec.cmt_attribute6 = hr_api.g_varchar2) then
500: p_rec.cmt_attribute6 :=
501: ben_cmt_shd.g_old_rec.cmt_attribute6;
502: End If;
503: If (p_rec.cmt_attribute7 = hr_api.g_varchar2) then
504: p_rec.cmt_attribute7 :=
505: ben_cmt_shd.g_old_rec.cmt_attribute7;

Line 505: ben_cmt_shd.g_old_rec.cmt_attribute7;

501: ben_cmt_shd.g_old_rec.cmt_attribute6;
502: End If;
503: If (p_rec.cmt_attribute7 = hr_api.g_varchar2) then
504: p_rec.cmt_attribute7 :=
505: ben_cmt_shd.g_old_rec.cmt_attribute7;
506: End If;
507: If (p_rec.cmt_attribute8 = hr_api.g_varchar2) then
508: p_rec.cmt_attribute8 :=
509: ben_cmt_shd.g_old_rec.cmt_attribute8;

Line 509: ben_cmt_shd.g_old_rec.cmt_attribute8;

505: ben_cmt_shd.g_old_rec.cmt_attribute7;
506: End If;
507: If (p_rec.cmt_attribute8 = hr_api.g_varchar2) then
508: p_rec.cmt_attribute8 :=
509: ben_cmt_shd.g_old_rec.cmt_attribute8;
510: End If;
511: If (p_rec.cmt_attribute9 = hr_api.g_varchar2) then
512: p_rec.cmt_attribute9 :=
513: ben_cmt_shd.g_old_rec.cmt_attribute9;

Line 513: ben_cmt_shd.g_old_rec.cmt_attribute9;

509: ben_cmt_shd.g_old_rec.cmt_attribute8;
510: End If;
511: If (p_rec.cmt_attribute9 = hr_api.g_varchar2) then
512: p_rec.cmt_attribute9 :=
513: ben_cmt_shd.g_old_rec.cmt_attribute9;
514: End If;
515: If (p_rec.dflt_flag = hr_api.g_varchar2) then
516: p_rec.dflt_flag :=
517: ben_cmt_shd.g_old_rec.dflt_flag;

Line 517: ben_cmt_shd.g_old_rec.dflt_flag;

513: ben_cmt_shd.g_old_rec.cmt_attribute9;
514: End If;
515: If (p_rec.dflt_flag = hr_api.g_varchar2) then
516: p_rec.dflt_flag :=
517: ben_cmt_shd.g_old_rec.dflt_flag;
518: End If;
519:
520: --
521: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 531: p_rec in out nocopy ben_cmt_shd.g_rec_type

527: -- ----------------------------------------------------------------------------
528: Procedure upd
529: (
530: p_effective_date in date,
531: p_rec in out nocopy ben_cmt_shd.g_rec_type
532: ) is
533: --
534: l_proc varchar2(72) := g_package||'upd';
535: --

Line 541: ben_cmt_shd.lck

537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: -- We must lock the row which we need to update.
540: --
541: ben_cmt_shd.lck
542: (
543: p_rec.cm_dlvry_mthd_typ_id,
544: p_rec.object_version_number
545: );

Line 617: l_rec ben_cmt_shd.g_rec_type;

613: p_dflt_flag in varchar2 default hr_api.g_varchar2,
614: p_object_version_number in out nocopy number
615: ) is
616: --
617: l_rec ben_cmt_shd.g_rec_type;
618: l_proc varchar2(72) := g_package||'upd';
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);

Line 627: ben_cmt_shd.convert_args

623: -- Call conversion function to turn arguments into the
624: -- l_rec structure.
625: --
626: l_rec :=
627: ben_cmt_shd.convert_args
628: (
629: p_cm_dlvry_mthd_typ_id,
630: p_cm_dlvry_mthd_typ_cd,
631: p_business_group_id,