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_CRD_DEL dependencies on BEN_CRD_SHD

Line 51: Procedure delete_dml(p_rec in ben_crd_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_crd_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ben_crd_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_crd_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_crt_ordr_cvrd_per row.
61: --
62: delete from ben_crt_ordr_cvrd_per

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

61: --
62: delete from ben_crt_ordr_cvrd_per
63: where crt_ordr_cvrd_per_id = p_rec.crt_ordr_cvrd_per_id;
64: --
65: ben_crd_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_crd_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_crd_shd.g_api_dml := false; -- Unset the api dml status
73: ben_crd_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_crd_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_crd_shd.constraint_error

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

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

72: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
73: ben_crd_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_crd_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_crd_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_crd_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in ben_crd_shd.g_rec_type) is

150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in ben_crd_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

Line 169: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id

165: --
166: ben_crd_rkd.after_delete
167: (
168: p_crt_ordr_cvrd_per_id =>p_rec.crt_ordr_cvrd_per_id
169: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
170: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
171: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
172: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1

Line 170: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id

166: ben_crd_rkd.after_delete
167: (
168: p_crt_ordr_cvrd_per_id =>p_rec.crt_ordr_cvrd_per_id
169: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
170: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
171: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
172: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2

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

167: (
168: p_crt_ordr_cvrd_per_id =>p_rec.crt_ordr_cvrd_per_id
169: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
170: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
171: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
172: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3

Line 172: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category

168: p_crt_ordr_cvrd_per_id =>p_rec.crt_ordr_cvrd_per_id
169: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
170: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
171: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
172: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4

Line 173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1

169: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
170: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
171: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
172: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5

Line 174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2

170: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
171: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
172: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6

Line 175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3

171: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
172: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7

Line 176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4

172: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8

Line 177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5

173: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9

Line 178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6

174: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10

Line 179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7

175: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11

Line 180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8

176: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12

Line 181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9

177: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13

Line 182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10

178: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14

Line 183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11

179: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15

Line 184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12

180: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16

Line 185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13

181: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17

Line 186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14

182: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18

Line 187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15

183: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19

Line 188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16

184: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20

Line 189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17

185: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21

Line 190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18

186: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22

Line 191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19

187: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23

Line 192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20

188: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24

Line 193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21

189: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25

Line 194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22

190: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26

Line 195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23

191: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27

Line 196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24

192: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
200: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28

Line 197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25

193: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
200: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
201: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29

Line 198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26

194: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
200: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
201: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
202: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30

Line 199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27

195: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
200: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
201: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
202: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
203: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number

Line 200: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28

196: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
200: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
201: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
202: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
203: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number
204: );

Line 201: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29

197: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
200: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
201: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
202: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
203: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number
204: );
205: --

Line 202: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30

198: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
200: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
201: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
202: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
203: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number
204: );
205: --
206: exception

Line 203: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number

199: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
200: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
201: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
202: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
203: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number
204: );
205: --
206: exception
207: --

Line 227: p_rec in ben_crd_shd.g_rec_type

223: -- |---------------------------------< del >----------------------------------|
224: -- ----------------------------------------------------------------------------
225: Procedure del
226: (
227: p_rec in ben_crd_shd.g_rec_type
228: ) is
229: --
230: l_proc varchar2(72) := g_package||'del';
231: --

Line 237: ben_crd_shd.lck

233: hr_utility.set_location('Entering:'||l_proc, 5);
234: --
235: -- We must lock the row which we need to delete.
236: --
237: ben_crd_shd.lck
238: (
239: p_rec.crt_ordr_cvrd_per_id,
240: p_rec.object_version_number
241: );

Line 269: l_rec ben_crd_shd.g_rec_type;

265: p_crt_ordr_cvrd_per_id in number,
266: p_object_version_number in number
267: ) is
268: --
269: l_rec ben_crd_shd.g_rec_type;
270: l_proc varchar2(72) := g_package||'del';
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);