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

Line 51: Procedure delete_dml(p_rec in ben_cmt_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_cmt_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

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

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_cmt_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_cm_dlvry_mthd_typ row.
61: --
62: delete from ben_cm_dlvry_mthd_typ

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

61: --
62: delete from ben_cm_dlvry_mthd_typ
63: where cm_dlvry_mthd_typ_id = p_rec.cm_dlvry_mthd_typ_id;
64: --
65: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

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

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
73: ben_cmt_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_cmt_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
73: ben_cmt_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

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

72: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
73: ben_cmt_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_cmt_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in ben_cmt_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_cmt_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

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

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_cmt_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

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

166: --
167: ben_cmt_rkd.after_delete
168: (
169: p_cm_dlvry_mthd_typ_id =>p_rec.cm_dlvry_mthd_typ_id
170: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
171: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
172: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
173: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
174: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10

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

167: ben_cmt_rkd.after_delete
168: (
169: p_cm_dlvry_mthd_typ_id =>p_rec.cm_dlvry_mthd_typ_id
170: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
171: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
172: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
173: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
174: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
175: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11

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

168: (
169: p_cm_dlvry_mthd_typ_id =>p_rec.cm_dlvry_mthd_typ_id
170: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
171: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
172: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
173: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
174: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
175: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
176: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12

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

169: p_cm_dlvry_mthd_typ_id =>p_rec.cm_dlvry_mthd_typ_id
170: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
171: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
172: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
173: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
174: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
175: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
176: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
177: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13

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

170: ,p_cm_dlvry_mthd_typ_cd_o =>ben_cmt_shd.g_old_rec.cm_dlvry_mthd_typ_cd
171: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
172: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
173: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
174: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
175: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
176: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
177: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
178: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14

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

171: ,p_business_group_id_o =>ben_cmt_shd.g_old_rec.business_group_id
172: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
173: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
174: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
175: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
176: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
177: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
178: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
179: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15

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

172: ,p_cm_typ_id_o =>ben_cmt_shd.g_old_rec.cm_typ_id
173: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
174: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
175: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
176: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
177: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
178: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
179: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
180: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16

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

173: ,p_cmt_attribute1_o =>ben_cmt_shd.g_old_rec.cmt_attribute1
174: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
175: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
176: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
177: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
178: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
179: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
180: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
181: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17

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

174: ,p_cmt_attribute10_o =>ben_cmt_shd.g_old_rec.cmt_attribute10
175: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
176: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
177: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
178: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
179: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
180: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
181: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
182: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18

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

175: ,p_cmt_attribute11_o =>ben_cmt_shd.g_old_rec.cmt_attribute11
176: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
177: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
178: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
179: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
180: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
181: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
182: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
183: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19

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

176: ,p_cmt_attribute12_o =>ben_cmt_shd.g_old_rec.cmt_attribute12
177: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
178: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
179: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
180: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
181: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
182: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
183: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
184: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2

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

177: ,p_cmt_attribute13_o =>ben_cmt_shd.g_old_rec.cmt_attribute13
178: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
179: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
180: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
181: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
182: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
183: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
184: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
185: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20

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

178: ,p_cmt_attribute14_o =>ben_cmt_shd.g_old_rec.cmt_attribute14
179: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
180: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
181: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
182: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
183: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
184: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
185: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
186: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21

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

179: ,p_cmt_attribute15_o =>ben_cmt_shd.g_old_rec.cmt_attribute15
180: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
181: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
182: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
183: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
184: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
185: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
186: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
187: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22

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

180: ,p_cmt_attribute16_o =>ben_cmt_shd.g_old_rec.cmt_attribute16
181: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
182: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
183: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
184: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
185: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
186: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
187: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
188: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23

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

181: ,p_cmt_attribute17_o =>ben_cmt_shd.g_old_rec.cmt_attribute17
182: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
183: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
184: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
185: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
186: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
187: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
188: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
189: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24

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

182: ,p_cmt_attribute18_o =>ben_cmt_shd.g_old_rec.cmt_attribute18
183: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
184: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
185: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
186: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
187: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
188: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
189: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
190: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25

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

183: ,p_cmt_attribute19_o =>ben_cmt_shd.g_old_rec.cmt_attribute19
184: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
185: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
186: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
187: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
188: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
189: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
190: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
191: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26

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

184: ,p_cmt_attribute2_o =>ben_cmt_shd.g_old_rec.cmt_attribute2
185: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
186: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
187: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
188: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
189: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
190: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
191: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
192: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27

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

185: ,p_cmt_attribute20_o =>ben_cmt_shd.g_old_rec.cmt_attribute20
186: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
187: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
188: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
189: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
190: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
191: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
192: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
193: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28

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

186: ,p_cmt_attribute21_o =>ben_cmt_shd.g_old_rec.cmt_attribute21
187: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
188: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
189: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
190: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
191: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
192: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
193: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
194: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29

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

187: ,p_cmt_attribute22_o =>ben_cmt_shd.g_old_rec.cmt_attribute22
188: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
189: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
190: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
191: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
192: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
193: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
194: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
195: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3

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

188: ,p_cmt_attribute23_o =>ben_cmt_shd.g_old_rec.cmt_attribute23
189: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
190: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
191: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
192: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
193: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
194: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
195: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
196: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30

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

189: ,p_cmt_attribute24_o =>ben_cmt_shd.g_old_rec.cmt_attribute24
190: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
191: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
192: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
193: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
194: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
195: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
196: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
197: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag

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

190: ,p_cmt_attribute25_o =>ben_cmt_shd.g_old_rec.cmt_attribute25
191: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
192: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
193: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
194: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
195: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
196: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
197: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
198: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category

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

191: ,p_cmt_attribute26_o =>ben_cmt_shd.g_old_rec.cmt_attribute26
192: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
193: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
194: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
195: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
196: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
197: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
198: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
199: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4

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

192: ,p_cmt_attribute27_o =>ben_cmt_shd.g_old_rec.cmt_attribute27
193: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
194: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
195: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
196: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
197: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
198: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
199: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
200: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5

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

193: ,p_cmt_attribute28_o =>ben_cmt_shd.g_old_rec.cmt_attribute28
194: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
195: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
196: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
197: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
198: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
199: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
200: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
201: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6

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

194: ,p_cmt_attribute29_o =>ben_cmt_shd.g_old_rec.cmt_attribute29
195: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
196: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
197: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
198: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
199: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
200: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
201: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
202: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7

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

195: ,p_cmt_attribute3_o =>ben_cmt_shd.g_old_rec.cmt_attribute3
196: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
197: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
198: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
199: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
200: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
201: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
202: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
203: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8

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

196: ,p_cmt_attribute30_o =>ben_cmt_shd.g_old_rec.cmt_attribute30
197: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
198: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
199: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
200: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
201: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
202: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
203: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
204: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9

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

197: ,p_rqd_flag_o =>ben_cmt_shd.g_old_rec.rqd_flag
198: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
199: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
200: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
201: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
202: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
203: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
204: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
205: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag

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

198: ,p_cmt_attribute_category_o =>ben_cmt_shd.g_old_rec.cmt_attribute_category
199: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
200: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
201: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
202: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
203: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
204: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
205: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
206: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number

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

199: ,p_cmt_attribute4_o =>ben_cmt_shd.g_old_rec.cmt_attribute4
200: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
201: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
202: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
203: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
204: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
205: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
206: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number
207: );

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

200: ,p_cmt_attribute5_o =>ben_cmt_shd.g_old_rec.cmt_attribute5
201: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
202: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
203: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
204: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
205: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
206: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number
207: );
208: --

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

201: ,p_cmt_attribute6_o =>ben_cmt_shd.g_old_rec.cmt_attribute6
202: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
203: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
204: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
205: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
206: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number
207: );
208: --
209: exception

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

202: ,p_cmt_attribute7_o =>ben_cmt_shd.g_old_rec.cmt_attribute7
203: ,p_cmt_attribute8_o =>ben_cmt_shd.g_old_rec.cmt_attribute8
204: ,p_cmt_attribute9_o =>ben_cmt_shd.g_old_rec.cmt_attribute9
205: ,p_dflt_flag_o =>ben_cmt_shd.g_old_rec.dflt_flag
206: ,p_object_version_number_o =>ben_cmt_shd.g_old_rec.object_version_number
207: );
208: --
209: exception
210: --

Line 231: p_rec in ben_cmt_shd.g_rec_type

227: -- ----------------------------------------------------------------------------
228: Procedure del
229: (
230: p_effective_date in date,
231: p_rec in ben_cmt_shd.g_rec_type
232: ) is
233: --
234: l_proc varchar2(72) := g_package||'del';
235: --

Line 241: ben_cmt_shd.lck

237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: -- We must lock the row which we need to delete.
240: --
241: ben_cmt_shd.lck
242: (
243: p_rec.cm_dlvry_mthd_typ_id,
244: p_rec.object_version_number
245: );

Line 276: l_rec ben_cmt_shd.g_rec_type;

272: p_cm_dlvry_mthd_typ_id in number,
273: p_object_version_number in number
274: ) is
275: --
276: l_rec ben_cmt_shd.g_rec_type;
277: l_proc varchar2(72) := g_package||'del';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);