DBA Data[Home] [Help]

APPS.BEN_CSO_DEL dependencies on BEN_CSO_SHD

Line 52: (p_rec in ben_cso_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ben_cso_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: ben_cso_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ben_cso_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in ben_cso_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in ben_cso_shd.g_rec_type) is

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

Line 168: => ben_cso_shd.g_old_rec.grant_id

164: ben_cso_rkd.after_delete
165: (p_cwb_stock_optn_dtls_id
166: => p_rec.cwb_stock_optn_dtls_id
167: ,p_grant_id_o
168: => ben_cso_shd.g_old_rec.grant_id
169: ,p_grant_number_o
170: => ben_cso_shd.g_old_rec.grant_number
171: ,p_grant_name_o
172: => ben_cso_shd.g_old_rec.grant_name

Line 170: => ben_cso_shd.g_old_rec.grant_number

166: => p_rec.cwb_stock_optn_dtls_id
167: ,p_grant_id_o
168: => ben_cso_shd.g_old_rec.grant_id
169: ,p_grant_number_o
170: => ben_cso_shd.g_old_rec.grant_number
171: ,p_grant_name_o
172: => ben_cso_shd.g_old_rec.grant_name
173: ,p_grant_type_o
174: => ben_cso_shd.g_old_rec.grant_type

Line 172: => ben_cso_shd.g_old_rec.grant_name

168: => ben_cso_shd.g_old_rec.grant_id
169: ,p_grant_number_o
170: => ben_cso_shd.g_old_rec.grant_number
171: ,p_grant_name_o
172: => ben_cso_shd.g_old_rec.grant_name
173: ,p_grant_type_o
174: => ben_cso_shd.g_old_rec.grant_type
175: ,p_grant_date_o
176: => ben_cso_shd.g_old_rec.grant_date

Line 174: => ben_cso_shd.g_old_rec.grant_type

170: => ben_cso_shd.g_old_rec.grant_number
171: ,p_grant_name_o
172: => ben_cso_shd.g_old_rec.grant_name
173: ,p_grant_type_o
174: => ben_cso_shd.g_old_rec.grant_type
175: ,p_grant_date_o
176: => ben_cso_shd.g_old_rec.grant_date
177: ,p_grant_shares_o
178: => ben_cso_shd.g_old_rec.grant_shares

Line 176: => ben_cso_shd.g_old_rec.grant_date

172: => ben_cso_shd.g_old_rec.grant_name
173: ,p_grant_type_o
174: => ben_cso_shd.g_old_rec.grant_type
175: ,p_grant_date_o
176: => ben_cso_shd.g_old_rec.grant_date
177: ,p_grant_shares_o
178: => ben_cso_shd.g_old_rec.grant_shares
179: ,p_grant_price_o
180: => ben_cso_shd.g_old_rec.grant_price

Line 178: => ben_cso_shd.g_old_rec.grant_shares

174: => ben_cso_shd.g_old_rec.grant_type
175: ,p_grant_date_o
176: => ben_cso_shd.g_old_rec.grant_date
177: ,p_grant_shares_o
178: => ben_cso_shd.g_old_rec.grant_shares
179: ,p_grant_price_o
180: => ben_cso_shd.g_old_rec.grant_price
181: ,p_value_at_grant_o
182: => ben_cso_shd.g_old_rec.value_at_grant

Line 180: => ben_cso_shd.g_old_rec.grant_price

176: => ben_cso_shd.g_old_rec.grant_date
177: ,p_grant_shares_o
178: => ben_cso_shd.g_old_rec.grant_shares
179: ,p_grant_price_o
180: => ben_cso_shd.g_old_rec.grant_price
181: ,p_value_at_grant_o
182: => ben_cso_shd.g_old_rec.value_at_grant
183: ,p_current_share_price_o
184: => ben_cso_shd.g_old_rec.current_share_price

Line 182: => ben_cso_shd.g_old_rec.value_at_grant

178: => ben_cso_shd.g_old_rec.grant_shares
179: ,p_grant_price_o
180: => ben_cso_shd.g_old_rec.grant_price
181: ,p_value_at_grant_o
182: => ben_cso_shd.g_old_rec.value_at_grant
183: ,p_current_share_price_o
184: => ben_cso_shd.g_old_rec.current_share_price
185: ,p_current_shares_outstanding_o
186: => ben_cso_shd.g_old_rec.current_shares_outstanding

Line 184: => ben_cso_shd.g_old_rec.current_share_price

180: => ben_cso_shd.g_old_rec.grant_price
181: ,p_value_at_grant_o
182: => ben_cso_shd.g_old_rec.value_at_grant
183: ,p_current_share_price_o
184: => ben_cso_shd.g_old_rec.current_share_price
185: ,p_current_shares_outstanding_o
186: => ben_cso_shd.g_old_rec.current_shares_outstanding
187: ,p_vested_shares_o
188: => ben_cso_shd.g_old_rec.vested_shares

Line 186: => ben_cso_shd.g_old_rec.current_shares_outstanding

182: => ben_cso_shd.g_old_rec.value_at_grant
183: ,p_current_share_price_o
184: => ben_cso_shd.g_old_rec.current_share_price
185: ,p_current_shares_outstanding_o
186: => ben_cso_shd.g_old_rec.current_shares_outstanding
187: ,p_vested_shares_o
188: => ben_cso_shd.g_old_rec.vested_shares
189: ,p_unvested_shares_o
190: => ben_cso_shd.g_old_rec.unvested_shares

Line 188: => ben_cso_shd.g_old_rec.vested_shares

184: => ben_cso_shd.g_old_rec.current_share_price
185: ,p_current_shares_outstanding_o
186: => ben_cso_shd.g_old_rec.current_shares_outstanding
187: ,p_vested_shares_o
188: => ben_cso_shd.g_old_rec.vested_shares
189: ,p_unvested_shares_o
190: => ben_cso_shd.g_old_rec.unvested_shares
191: ,p_exercisable_shares_o
192: => ben_cso_shd.g_old_rec.exercisable_shares

Line 190: => ben_cso_shd.g_old_rec.unvested_shares

186: => ben_cso_shd.g_old_rec.current_shares_outstanding
187: ,p_vested_shares_o
188: => ben_cso_shd.g_old_rec.vested_shares
189: ,p_unvested_shares_o
190: => ben_cso_shd.g_old_rec.unvested_shares
191: ,p_exercisable_shares_o
192: => ben_cso_shd.g_old_rec.exercisable_shares
193: ,p_exercised_shares_o
194: => ben_cso_shd.g_old_rec.exercised_shares

Line 192: => ben_cso_shd.g_old_rec.exercisable_shares

188: => ben_cso_shd.g_old_rec.vested_shares
189: ,p_unvested_shares_o
190: => ben_cso_shd.g_old_rec.unvested_shares
191: ,p_exercisable_shares_o
192: => ben_cso_shd.g_old_rec.exercisable_shares
193: ,p_exercised_shares_o
194: => ben_cso_shd.g_old_rec.exercised_shares
195: ,p_cancelled_shares_o
196: => ben_cso_shd.g_old_rec.cancelled_shares

Line 194: => ben_cso_shd.g_old_rec.exercised_shares

190: => ben_cso_shd.g_old_rec.unvested_shares
191: ,p_exercisable_shares_o
192: => ben_cso_shd.g_old_rec.exercisable_shares
193: ,p_exercised_shares_o
194: => ben_cso_shd.g_old_rec.exercised_shares
195: ,p_cancelled_shares_o
196: => ben_cso_shd.g_old_rec.cancelled_shares
197: ,p_trading_symbol_o
198: => ben_cso_shd.g_old_rec.trading_symbol

Line 196: => ben_cso_shd.g_old_rec.cancelled_shares

192: => ben_cso_shd.g_old_rec.exercisable_shares
193: ,p_exercised_shares_o
194: => ben_cso_shd.g_old_rec.exercised_shares
195: ,p_cancelled_shares_o
196: => ben_cso_shd.g_old_rec.cancelled_shares
197: ,p_trading_symbol_o
198: => ben_cso_shd.g_old_rec.trading_symbol
199: ,p_expiration_date_o
200: => ben_cso_shd.g_old_rec.expiration_date

Line 198: => ben_cso_shd.g_old_rec.trading_symbol

194: => ben_cso_shd.g_old_rec.exercised_shares
195: ,p_cancelled_shares_o
196: => ben_cso_shd.g_old_rec.cancelled_shares
197: ,p_trading_symbol_o
198: => ben_cso_shd.g_old_rec.trading_symbol
199: ,p_expiration_date_o
200: => ben_cso_shd.g_old_rec.expiration_date
201: ,p_reason_code_o
202: => ben_cso_shd.g_old_rec.reason_code

Line 200: => ben_cso_shd.g_old_rec.expiration_date

196: => ben_cso_shd.g_old_rec.cancelled_shares
197: ,p_trading_symbol_o
198: => ben_cso_shd.g_old_rec.trading_symbol
199: ,p_expiration_date_o
200: => ben_cso_shd.g_old_rec.expiration_date
201: ,p_reason_code_o
202: => ben_cso_shd.g_old_rec.reason_code
203: ,p_class_o
204: => ben_cso_shd.g_old_rec.class

Line 202: => ben_cso_shd.g_old_rec.reason_code

198: => ben_cso_shd.g_old_rec.trading_symbol
199: ,p_expiration_date_o
200: => ben_cso_shd.g_old_rec.expiration_date
201: ,p_reason_code_o
202: => ben_cso_shd.g_old_rec.reason_code
203: ,p_class_o
204: => ben_cso_shd.g_old_rec.class
205: ,p_misc_o
206: => ben_cso_shd.g_old_rec.misc

Line 204: => ben_cso_shd.g_old_rec.class

200: => ben_cso_shd.g_old_rec.expiration_date
201: ,p_reason_code_o
202: => ben_cso_shd.g_old_rec.reason_code
203: ,p_class_o
204: => ben_cso_shd.g_old_rec.class
205: ,p_misc_o
206: => ben_cso_shd.g_old_rec.misc
207: ,p_employee_number_o
208: => ben_cso_shd.g_old_rec.employee_number

Line 206: => ben_cso_shd.g_old_rec.misc

202: => ben_cso_shd.g_old_rec.reason_code
203: ,p_class_o
204: => ben_cso_shd.g_old_rec.class
205: ,p_misc_o
206: => ben_cso_shd.g_old_rec.misc
207: ,p_employee_number_o
208: => ben_cso_shd.g_old_rec.employee_number
209: ,p_person_id_o
210: => ben_cso_shd.g_old_rec.person_id

Line 208: => ben_cso_shd.g_old_rec.employee_number

204: => ben_cso_shd.g_old_rec.class
205: ,p_misc_o
206: => ben_cso_shd.g_old_rec.misc
207: ,p_employee_number_o
208: => ben_cso_shd.g_old_rec.employee_number
209: ,p_person_id_o
210: => ben_cso_shd.g_old_rec.person_id
211: ,p_business_group_id_o
212: => ben_cso_shd.g_old_rec.business_group_id

Line 210: => ben_cso_shd.g_old_rec.person_id

206: => ben_cso_shd.g_old_rec.misc
207: ,p_employee_number_o
208: => ben_cso_shd.g_old_rec.employee_number
209: ,p_person_id_o
210: => ben_cso_shd.g_old_rec.person_id
211: ,p_business_group_id_o
212: => ben_cso_shd.g_old_rec.business_group_id
213: ,p_prtt_rt_val_id_o
214: => ben_cso_shd.g_old_rec.prtt_rt_val_id

Line 212: => ben_cso_shd.g_old_rec.business_group_id

208: => ben_cso_shd.g_old_rec.employee_number
209: ,p_person_id_o
210: => ben_cso_shd.g_old_rec.person_id
211: ,p_business_group_id_o
212: => ben_cso_shd.g_old_rec.business_group_id
213: ,p_prtt_rt_val_id_o
214: => ben_cso_shd.g_old_rec.prtt_rt_val_id
215: ,p_object_version_number_o
216: => ben_cso_shd.g_old_rec.object_version_number

Line 214: => ben_cso_shd.g_old_rec.prtt_rt_val_id

210: => ben_cso_shd.g_old_rec.person_id
211: ,p_business_group_id_o
212: => ben_cso_shd.g_old_rec.business_group_id
213: ,p_prtt_rt_val_id_o
214: => ben_cso_shd.g_old_rec.prtt_rt_val_id
215: ,p_object_version_number_o
216: => ben_cso_shd.g_old_rec.object_version_number
217: ,p_cso_attribute_category_o
218: => ben_cso_shd.g_old_rec.cso_attribute_category

Line 216: => ben_cso_shd.g_old_rec.object_version_number

212: => ben_cso_shd.g_old_rec.business_group_id
213: ,p_prtt_rt_val_id_o
214: => ben_cso_shd.g_old_rec.prtt_rt_val_id
215: ,p_object_version_number_o
216: => ben_cso_shd.g_old_rec.object_version_number
217: ,p_cso_attribute_category_o
218: => ben_cso_shd.g_old_rec.cso_attribute_category
219: ,p_cso_attribute1_o
220: => ben_cso_shd.g_old_rec.cso_attribute1

Line 218: => ben_cso_shd.g_old_rec.cso_attribute_category

214: => ben_cso_shd.g_old_rec.prtt_rt_val_id
215: ,p_object_version_number_o
216: => ben_cso_shd.g_old_rec.object_version_number
217: ,p_cso_attribute_category_o
218: => ben_cso_shd.g_old_rec.cso_attribute_category
219: ,p_cso_attribute1_o
220: => ben_cso_shd.g_old_rec.cso_attribute1
221: ,p_cso_attribute2_o
222: => ben_cso_shd.g_old_rec.cso_attribute2

Line 220: => ben_cso_shd.g_old_rec.cso_attribute1

216: => ben_cso_shd.g_old_rec.object_version_number
217: ,p_cso_attribute_category_o
218: => ben_cso_shd.g_old_rec.cso_attribute_category
219: ,p_cso_attribute1_o
220: => ben_cso_shd.g_old_rec.cso_attribute1
221: ,p_cso_attribute2_o
222: => ben_cso_shd.g_old_rec.cso_attribute2
223: ,p_cso_attribute3_o
224: => ben_cso_shd.g_old_rec.cso_attribute3

Line 222: => ben_cso_shd.g_old_rec.cso_attribute2

218: => ben_cso_shd.g_old_rec.cso_attribute_category
219: ,p_cso_attribute1_o
220: => ben_cso_shd.g_old_rec.cso_attribute1
221: ,p_cso_attribute2_o
222: => ben_cso_shd.g_old_rec.cso_attribute2
223: ,p_cso_attribute3_o
224: => ben_cso_shd.g_old_rec.cso_attribute3
225: ,p_cso_attribute4_o
226: => ben_cso_shd.g_old_rec.cso_attribute4

Line 224: => ben_cso_shd.g_old_rec.cso_attribute3

220: => ben_cso_shd.g_old_rec.cso_attribute1
221: ,p_cso_attribute2_o
222: => ben_cso_shd.g_old_rec.cso_attribute2
223: ,p_cso_attribute3_o
224: => ben_cso_shd.g_old_rec.cso_attribute3
225: ,p_cso_attribute4_o
226: => ben_cso_shd.g_old_rec.cso_attribute4
227: ,p_cso_attribute5_o
228: => ben_cso_shd.g_old_rec.cso_attribute5

Line 226: => ben_cso_shd.g_old_rec.cso_attribute4

222: => ben_cso_shd.g_old_rec.cso_attribute2
223: ,p_cso_attribute3_o
224: => ben_cso_shd.g_old_rec.cso_attribute3
225: ,p_cso_attribute4_o
226: => ben_cso_shd.g_old_rec.cso_attribute4
227: ,p_cso_attribute5_o
228: => ben_cso_shd.g_old_rec.cso_attribute5
229: ,p_cso_attribute6_o
230: => ben_cso_shd.g_old_rec.cso_attribute6

Line 228: => ben_cso_shd.g_old_rec.cso_attribute5

224: => ben_cso_shd.g_old_rec.cso_attribute3
225: ,p_cso_attribute4_o
226: => ben_cso_shd.g_old_rec.cso_attribute4
227: ,p_cso_attribute5_o
228: => ben_cso_shd.g_old_rec.cso_attribute5
229: ,p_cso_attribute6_o
230: => ben_cso_shd.g_old_rec.cso_attribute6
231: ,p_cso_attribute7_o
232: => ben_cso_shd.g_old_rec.cso_attribute7

Line 230: => ben_cso_shd.g_old_rec.cso_attribute6

226: => ben_cso_shd.g_old_rec.cso_attribute4
227: ,p_cso_attribute5_o
228: => ben_cso_shd.g_old_rec.cso_attribute5
229: ,p_cso_attribute6_o
230: => ben_cso_shd.g_old_rec.cso_attribute6
231: ,p_cso_attribute7_o
232: => ben_cso_shd.g_old_rec.cso_attribute7
233: ,p_cso_attribute8_o
234: => ben_cso_shd.g_old_rec.cso_attribute8

Line 232: => ben_cso_shd.g_old_rec.cso_attribute7

228: => ben_cso_shd.g_old_rec.cso_attribute5
229: ,p_cso_attribute6_o
230: => ben_cso_shd.g_old_rec.cso_attribute6
231: ,p_cso_attribute7_o
232: => ben_cso_shd.g_old_rec.cso_attribute7
233: ,p_cso_attribute8_o
234: => ben_cso_shd.g_old_rec.cso_attribute8
235: ,p_cso_attribute9_o
236: => ben_cso_shd.g_old_rec.cso_attribute9

Line 234: => ben_cso_shd.g_old_rec.cso_attribute8

230: => ben_cso_shd.g_old_rec.cso_attribute6
231: ,p_cso_attribute7_o
232: => ben_cso_shd.g_old_rec.cso_attribute7
233: ,p_cso_attribute8_o
234: => ben_cso_shd.g_old_rec.cso_attribute8
235: ,p_cso_attribute9_o
236: => ben_cso_shd.g_old_rec.cso_attribute9
237: ,p_cso_attribute10_o
238: => ben_cso_shd.g_old_rec.cso_attribute10

Line 236: => ben_cso_shd.g_old_rec.cso_attribute9

232: => ben_cso_shd.g_old_rec.cso_attribute7
233: ,p_cso_attribute8_o
234: => ben_cso_shd.g_old_rec.cso_attribute8
235: ,p_cso_attribute9_o
236: => ben_cso_shd.g_old_rec.cso_attribute9
237: ,p_cso_attribute10_o
238: => ben_cso_shd.g_old_rec.cso_attribute10
239: ,p_cso_attribute11_o
240: => ben_cso_shd.g_old_rec.cso_attribute11

Line 238: => ben_cso_shd.g_old_rec.cso_attribute10

234: => ben_cso_shd.g_old_rec.cso_attribute8
235: ,p_cso_attribute9_o
236: => ben_cso_shd.g_old_rec.cso_attribute9
237: ,p_cso_attribute10_o
238: => ben_cso_shd.g_old_rec.cso_attribute10
239: ,p_cso_attribute11_o
240: => ben_cso_shd.g_old_rec.cso_attribute11
241: ,p_cso_attribute12_o
242: => ben_cso_shd.g_old_rec.cso_attribute12

Line 240: => ben_cso_shd.g_old_rec.cso_attribute11

236: => ben_cso_shd.g_old_rec.cso_attribute9
237: ,p_cso_attribute10_o
238: => ben_cso_shd.g_old_rec.cso_attribute10
239: ,p_cso_attribute11_o
240: => ben_cso_shd.g_old_rec.cso_attribute11
241: ,p_cso_attribute12_o
242: => ben_cso_shd.g_old_rec.cso_attribute12
243: ,p_cso_attribute13_o
244: => ben_cso_shd.g_old_rec.cso_attribute13

Line 242: => ben_cso_shd.g_old_rec.cso_attribute12

238: => ben_cso_shd.g_old_rec.cso_attribute10
239: ,p_cso_attribute11_o
240: => ben_cso_shd.g_old_rec.cso_attribute11
241: ,p_cso_attribute12_o
242: => ben_cso_shd.g_old_rec.cso_attribute12
243: ,p_cso_attribute13_o
244: => ben_cso_shd.g_old_rec.cso_attribute13
245: ,p_cso_attribute14_o
246: => ben_cso_shd.g_old_rec.cso_attribute14

Line 244: => ben_cso_shd.g_old_rec.cso_attribute13

240: => ben_cso_shd.g_old_rec.cso_attribute11
241: ,p_cso_attribute12_o
242: => ben_cso_shd.g_old_rec.cso_attribute12
243: ,p_cso_attribute13_o
244: => ben_cso_shd.g_old_rec.cso_attribute13
245: ,p_cso_attribute14_o
246: => ben_cso_shd.g_old_rec.cso_attribute14
247: ,p_cso_attribute15_o
248: => ben_cso_shd.g_old_rec.cso_attribute15

Line 246: => ben_cso_shd.g_old_rec.cso_attribute14

242: => ben_cso_shd.g_old_rec.cso_attribute12
243: ,p_cso_attribute13_o
244: => ben_cso_shd.g_old_rec.cso_attribute13
245: ,p_cso_attribute14_o
246: => ben_cso_shd.g_old_rec.cso_attribute14
247: ,p_cso_attribute15_o
248: => ben_cso_shd.g_old_rec.cso_attribute15
249: ,p_cso_attribute16_o
250: => ben_cso_shd.g_old_rec.cso_attribute16

Line 248: => ben_cso_shd.g_old_rec.cso_attribute15

244: => ben_cso_shd.g_old_rec.cso_attribute13
245: ,p_cso_attribute14_o
246: => ben_cso_shd.g_old_rec.cso_attribute14
247: ,p_cso_attribute15_o
248: => ben_cso_shd.g_old_rec.cso_attribute15
249: ,p_cso_attribute16_o
250: => ben_cso_shd.g_old_rec.cso_attribute16
251: ,p_cso_attribute17_o
252: => ben_cso_shd.g_old_rec.cso_attribute17

Line 250: => ben_cso_shd.g_old_rec.cso_attribute16

246: => ben_cso_shd.g_old_rec.cso_attribute14
247: ,p_cso_attribute15_o
248: => ben_cso_shd.g_old_rec.cso_attribute15
249: ,p_cso_attribute16_o
250: => ben_cso_shd.g_old_rec.cso_attribute16
251: ,p_cso_attribute17_o
252: => ben_cso_shd.g_old_rec.cso_attribute17
253: ,p_cso_attribute18_o
254: => ben_cso_shd.g_old_rec.cso_attribute18

Line 252: => ben_cso_shd.g_old_rec.cso_attribute17

248: => ben_cso_shd.g_old_rec.cso_attribute15
249: ,p_cso_attribute16_o
250: => ben_cso_shd.g_old_rec.cso_attribute16
251: ,p_cso_attribute17_o
252: => ben_cso_shd.g_old_rec.cso_attribute17
253: ,p_cso_attribute18_o
254: => ben_cso_shd.g_old_rec.cso_attribute18
255: ,p_cso_attribute19_o
256: => ben_cso_shd.g_old_rec.cso_attribute19

Line 254: => ben_cso_shd.g_old_rec.cso_attribute18

250: => ben_cso_shd.g_old_rec.cso_attribute16
251: ,p_cso_attribute17_o
252: => ben_cso_shd.g_old_rec.cso_attribute17
253: ,p_cso_attribute18_o
254: => ben_cso_shd.g_old_rec.cso_attribute18
255: ,p_cso_attribute19_o
256: => ben_cso_shd.g_old_rec.cso_attribute19
257: ,p_cso_attribute20_o
258: => ben_cso_shd.g_old_rec.cso_attribute20

Line 256: => ben_cso_shd.g_old_rec.cso_attribute19

252: => ben_cso_shd.g_old_rec.cso_attribute17
253: ,p_cso_attribute18_o
254: => ben_cso_shd.g_old_rec.cso_attribute18
255: ,p_cso_attribute19_o
256: => ben_cso_shd.g_old_rec.cso_attribute19
257: ,p_cso_attribute20_o
258: => ben_cso_shd.g_old_rec.cso_attribute20
259: ,p_cso_attribute21_o
260: => ben_cso_shd.g_old_rec.cso_attribute21

Line 258: => ben_cso_shd.g_old_rec.cso_attribute20

254: => ben_cso_shd.g_old_rec.cso_attribute18
255: ,p_cso_attribute19_o
256: => ben_cso_shd.g_old_rec.cso_attribute19
257: ,p_cso_attribute20_o
258: => ben_cso_shd.g_old_rec.cso_attribute20
259: ,p_cso_attribute21_o
260: => ben_cso_shd.g_old_rec.cso_attribute21
261: ,p_cso_attribute22_o
262: => ben_cso_shd.g_old_rec.cso_attribute22

Line 260: => ben_cso_shd.g_old_rec.cso_attribute21

256: => ben_cso_shd.g_old_rec.cso_attribute19
257: ,p_cso_attribute20_o
258: => ben_cso_shd.g_old_rec.cso_attribute20
259: ,p_cso_attribute21_o
260: => ben_cso_shd.g_old_rec.cso_attribute21
261: ,p_cso_attribute22_o
262: => ben_cso_shd.g_old_rec.cso_attribute22
263: ,p_cso_attribute23_o
264: => ben_cso_shd.g_old_rec.cso_attribute23

Line 262: => ben_cso_shd.g_old_rec.cso_attribute22

258: => ben_cso_shd.g_old_rec.cso_attribute20
259: ,p_cso_attribute21_o
260: => ben_cso_shd.g_old_rec.cso_attribute21
261: ,p_cso_attribute22_o
262: => ben_cso_shd.g_old_rec.cso_attribute22
263: ,p_cso_attribute23_o
264: => ben_cso_shd.g_old_rec.cso_attribute23
265: ,p_cso_attribute24_o
266: => ben_cso_shd.g_old_rec.cso_attribute24

Line 264: => ben_cso_shd.g_old_rec.cso_attribute23

260: => ben_cso_shd.g_old_rec.cso_attribute21
261: ,p_cso_attribute22_o
262: => ben_cso_shd.g_old_rec.cso_attribute22
263: ,p_cso_attribute23_o
264: => ben_cso_shd.g_old_rec.cso_attribute23
265: ,p_cso_attribute24_o
266: => ben_cso_shd.g_old_rec.cso_attribute24
267: ,p_cso_attribute25_o
268: => ben_cso_shd.g_old_rec.cso_attribute25

Line 266: => ben_cso_shd.g_old_rec.cso_attribute24

262: => ben_cso_shd.g_old_rec.cso_attribute22
263: ,p_cso_attribute23_o
264: => ben_cso_shd.g_old_rec.cso_attribute23
265: ,p_cso_attribute24_o
266: => ben_cso_shd.g_old_rec.cso_attribute24
267: ,p_cso_attribute25_o
268: => ben_cso_shd.g_old_rec.cso_attribute25
269: ,p_cso_attribute26_o
270: => ben_cso_shd.g_old_rec.cso_attribute26

Line 268: => ben_cso_shd.g_old_rec.cso_attribute25

264: => ben_cso_shd.g_old_rec.cso_attribute23
265: ,p_cso_attribute24_o
266: => ben_cso_shd.g_old_rec.cso_attribute24
267: ,p_cso_attribute25_o
268: => ben_cso_shd.g_old_rec.cso_attribute25
269: ,p_cso_attribute26_o
270: => ben_cso_shd.g_old_rec.cso_attribute26
271: ,p_cso_attribute27_o
272: => ben_cso_shd.g_old_rec.cso_attribute27

Line 270: => ben_cso_shd.g_old_rec.cso_attribute26

266: => ben_cso_shd.g_old_rec.cso_attribute24
267: ,p_cso_attribute25_o
268: => ben_cso_shd.g_old_rec.cso_attribute25
269: ,p_cso_attribute26_o
270: => ben_cso_shd.g_old_rec.cso_attribute26
271: ,p_cso_attribute27_o
272: => ben_cso_shd.g_old_rec.cso_attribute27
273: ,p_cso_attribute28_o
274: => ben_cso_shd.g_old_rec.cso_attribute28

Line 272: => ben_cso_shd.g_old_rec.cso_attribute27

268: => ben_cso_shd.g_old_rec.cso_attribute25
269: ,p_cso_attribute26_o
270: => ben_cso_shd.g_old_rec.cso_attribute26
271: ,p_cso_attribute27_o
272: => ben_cso_shd.g_old_rec.cso_attribute27
273: ,p_cso_attribute28_o
274: => ben_cso_shd.g_old_rec.cso_attribute28
275: ,p_cso_attribute29_o
276: => ben_cso_shd.g_old_rec.cso_attribute29

Line 274: => ben_cso_shd.g_old_rec.cso_attribute28

270: => ben_cso_shd.g_old_rec.cso_attribute26
271: ,p_cso_attribute27_o
272: => ben_cso_shd.g_old_rec.cso_attribute27
273: ,p_cso_attribute28_o
274: => ben_cso_shd.g_old_rec.cso_attribute28
275: ,p_cso_attribute29_o
276: => ben_cso_shd.g_old_rec.cso_attribute29
277: ,p_cso_attribute30_o
278: => ben_cso_shd.g_old_rec.cso_attribute30

Line 276: => ben_cso_shd.g_old_rec.cso_attribute29

272: => ben_cso_shd.g_old_rec.cso_attribute27
273: ,p_cso_attribute28_o
274: => ben_cso_shd.g_old_rec.cso_attribute28
275: ,p_cso_attribute29_o
276: => ben_cso_shd.g_old_rec.cso_attribute29
277: ,p_cso_attribute30_o
278: => ben_cso_shd.g_old_rec.cso_attribute30
279: );
280: --

Line 278: => ben_cso_shd.g_old_rec.cso_attribute30

274: => ben_cso_shd.g_old_rec.cso_attribute28
275: ,p_cso_attribute29_o
276: => ben_cso_shd.g_old_rec.cso_attribute29
277: ,p_cso_attribute30_o
278: => ben_cso_shd.g_old_rec.cso_attribute30
279: );
280: --
281: exception
282: --

Line 298: (p_rec in ben_cso_shd.g_rec_type

294: -- ----------------------------------------------------------------------------
295: -- |---------------------------------< del >----------------------------------|
296: -- ----------------------------------------------------------------------------
297: Procedure del
298: (p_rec in ben_cso_shd.g_rec_type
299: ) is
300: --
301: l_proc varchar2(72) := g_package||'del';
302: --

Line 308: ben_cso_shd.lck

304: hr_utility.set_location('Entering:'||l_proc, 5);
305: --
306: -- We must lock the row which we need to delete.
307: --
308: ben_cso_shd.lck
309: (p_rec.cwb_stock_optn_dtls_id
310: ,p_rec.object_version_number
311: );
312: --

Line 345: l_rec ben_cso_shd.g_rec_type;

341: (p_cwb_stock_optn_dtls_id in number
342: ,p_object_version_number in number
343: ) is
344: --
345: l_rec ben_cso_shd.g_rec_type;
346: l_proc varchar2(72) := g_package||'del';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);