DBA Data[Home] [Help]

APPS.PER_BPA_DEL dependencies on PER_BPA_SHD

Line 52: (p_rec in per_bpa_shd.g_rec_type

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

Line 75: per_bpa_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: per_bpa_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 per_bpa_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in per_bpa_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 per_bpa_shd.g_rec_type) is

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

Line 168: => per_bpa_shd.g_old_rec.payroll_run_id,

164: per_bpa_rkd.after_delete
165: (p_processed_assignment_id
166: => p_rec.processed_assignment_id,
167: p_payroll_run_id_o
168: => per_bpa_shd.g_old_rec.payroll_run_id,
169: p_assignment_id_o
170: => per_bpa_shd.g_old_rec.assignment_id,
171: p_object_version_number_o
172: => per_bpa_shd.g_old_rec.object_version_number,

Line 170: => per_bpa_shd.g_old_rec.assignment_id,

166: => p_rec.processed_assignment_id,
167: p_payroll_run_id_o
168: => per_bpa_shd.g_old_rec.payroll_run_id,
169: p_assignment_id_o
170: => per_bpa_shd.g_old_rec.assignment_id,
171: p_object_version_number_o
172: => per_bpa_shd.g_old_rec.object_version_number,
173: p_bpa_attribute_category_o
174: => per_bpa_shd.g_old_rec.bpa_attribute_category,

Line 172: => per_bpa_shd.g_old_rec.object_version_number,

168: => per_bpa_shd.g_old_rec.payroll_run_id,
169: p_assignment_id_o
170: => per_bpa_shd.g_old_rec.assignment_id,
171: p_object_version_number_o
172: => per_bpa_shd.g_old_rec.object_version_number,
173: p_bpa_attribute_category_o
174: => per_bpa_shd.g_old_rec.bpa_attribute_category,
175: p_bpa_attribute1_o
176: => per_bpa_shd.g_old_rec.bpa_attribute1,

Line 174: => per_bpa_shd.g_old_rec.bpa_attribute_category,

170: => per_bpa_shd.g_old_rec.assignment_id,
171: p_object_version_number_o
172: => per_bpa_shd.g_old_rec.object_version_number,
173: p_bpa_attribute_category_o
174: => per_bpa_shd.g_old_rec.bpa_attribute_category,
175: p_bpa_attribute1_o
176: => per_bpa_shd.g_old_rec.bpa_attribute1,
177: p_bpa_attribute2_o
178: => per_bpa_shd.g_old_rec.bpa_attribute2,

Line 176: => per_bpa_shd.g_old_rec.bpa_attribute1,

172: => per_bpa_shd.g_old_rec.object_version_number,
173: p_bpa_attribute_category_o
174: => per_bpa_shd.g_old_rec.bpa_attribute_category,
175: p_bpa_attribute1_o
176: => per_bpa_shd.g_old_rec.bpa_attribute1,
177: p_bpa_attribute2_o
178: => per_bpa_shd.g_old_rec.bpa_attribute2,
179: p_bpa_attribute3_o
180: => per_bpa_shd.g_old_rec.bpa_attribute3,

Line 178: => per_bpa_shd.g_old_rec.bpa_attribute2,

174: => per_bpa_shd.g_old_rec.bpa_attribute_category,
175: p_bpa_attribute1_o
176: => per_bpa_shd.g_old_rec.bpa_attribute1,
177: p_bpa_attribute2_o
178: => per_bpa_shd.g_old_rec.bpa_attribute2,
179: p_bpa_attribute3_o
180: => per_bpa_shd.g_old_rec.bpa_attribute3,
181: p_bpa_attribute4_o
182: => per_bpa_shd.g_old_rec.bpa_attribute4,

Line 180: => per_bpa_shd.g_old_rec.bpa_attribute3,

176: => per_bpa_shd.g_old_rec.bpa_attribute1,
177: p_bpa_attribute2_o
178: => per_bpa_shd.g_old_rec.bpa_attribute2,
179: p_bpa_attribute3_o
180: => per_bpa_shd.g_old_rec.bpa_attribute3,
181: p_bpa_attribute4_o
182: => per_bpa_shd.g_old_rec.bpa_attribute4,
183: p_bpa_attribute5_o
184: => per_bpa_shd.g_old_rec.bpa_attribute5,

Line 182: => per_bpa_shd.g_old_rec.bpa_attribute4,

178: => per_bpa_shd.g_old_rec.bpa_attribute2,
179: p_bpa_attribute3_o
180: => per_bpa_shd.g_old_rec.bpa_attribute3,
181: p_bpa_attribute4_o
182: => per_bpa_shd.g_old_rec.bpa_attribute4,
183: p_bpa_attribute5_o
184: => per_bpa_shd.g_old_rec.bpa_attribute5,
185: p_bpa_attribute6_o
186: => per_bpa_shd.g_old_rec.bpa_attribute6,

Line 184: => per_bpa_shd.g_old_rec.bpa_attribute5,

180: => per_bpa_shd.g_old_rec.bpa_attribute3,
181: p_bpa_attribute4_o
182: => per_bpa_shd.g_old_rec.bpa_attribute4,
183: p_bpa_attribute5_o
184: => per_bpa_shd.g_old_rec.bpa_attribute5,
185: p_bpa_attribute6_o
186: => per_bpa_shd.g_old_rec.bpa_attribute6,
187: p_bpa_attribute7_o
188: => per_bpa_shd.g_old_rec.bpa_attribute7,

Line 186: => per_bpa_shd.g_old_rec.bpa_attribute6,

182: => per_bpa_shd.g_old_rec.bpa_attribute4,
183: p_bpa_attribute5_o
184: => per_bpa_shd.g_old_rec.bpa_attribute5,
185: p_bpa_attribute6_o
186: => per_bpa_shd.g_old_rec.bpa_attribute6,
187: p_bpa_attribute7_o
188: => per_bpa_shd.g_old_rec.bpa_attribute7,
189: p_bpa_attribute8_o
190: => per_bpa_shd.g_old_rec.bpa_attribute8,

Line 188: => per_bpa_shd.g_old_rec.bpa_attribute7,

184: => per_bpa_shd.g_old_rec.bpa_attribute5,
185: p_bpa_attribute6_o
186: => per_bpa_shd.g_old_rec.bpa_attribute6,
187: p_bpa_attribute7_o
188: => per_bpa_shd.g_old_rec.bpa_attribute7,
189: p_bpa_attribute8_o
190: => per_bpa_shd.g_old_rec.bpa_attribute8,
191: p_bpa_attribute9_o
192: => per_bpa_shd.g_old_rec.bpa_attribute9,

Line 190: => per_bpa_shd.g_old_rec.bpa_attribute8,

186: => per_bpa_shd.g_old_rec.bpa_attribute6,
187: p_bpa_attribute7_o
188: => per_bpa_shd.g_old_rec.bpa_attribute7,
189: p_bpa_attribute8_o
190: => per_bpa_shd.g_old_rec.bpa_attribute8,
191: p_bpa_attribute9_o
192: => per_bpa_shd.g_old_rec.bpa_attribute9,
193: p_bpa_attribute10_o
194: => per_bpa_shd.g_old_rec.bpa_attribute10,

Line 192: => per_bpa_shd.g_old_rec.bpa_attribute9,

188: => per_bpa_shd.g_old_rec.bpa_attribute7,
189: p_bpa_attribute8_o
190: => per_bpa_shd.g_old_rec.bpa_attribute8,
191: p_bpa_attribute9_o
192: => per_bpa_shd.g_old_rec.bpa_attribute9,
193: p_bpa_attribute10_o
194: => per_bpa_shd.g_old_rec.bpa_attribute10,
195: p_bpa_attribute11_o
196: => per_bpa_shd.g_old_rec.bpa_attribute11,

Line 194: => per_bpa_shd.g_old_rec.bpa_attribute10,

190: => per_bpa_shd.g_old_rec.bpa_attribute8,
191: p_bpa_attribute9_o
192: => per_bpa_shd.g_old_rec.bpa_attribute9,
193: p_bpa_attribute10_o
194: => per_bpa_shd.g_old_rec.bpa_attribute10,
195: p_bpa_attribute11_o
196: => per_bpa_shd.g_old_rec.bpa_attribute11,
197: p_bpa_attribute12_o
198: => per_bpa_shd.g_old_rec.bpa_attribute12,

Line 196: => per_bpa_shd.g_old_rec.bpa_attribute11,

192: => per_bpa_shd.g_old_rec.bpa_attribute9,
193: p_bpa_attribute10_o
194: => per_bpa_shd.g_old_rec.bpa_attribute10,
195: p_bpa_attribute11_o
196: => per_bpa_shd.g_old_rec.bpa_attribute11,
197: p_bpa_attribute12_o
198: => per_bpa_shd.g_old_rec.bpa_attribute12,
199: p_bpa_attribute13_o
200: => per_bpa_shd.g_old_rec.bpa_attribute13,

Line 198: => per_bpa_shd.g_old_rec.bpa_attribute12,

194: => per_bpa_shd.g_old_rec.bpa_attribute10,
195: p_bpa_attribute11_o
196: => per_bpa_shd.g_old_rec.bpa_attribute11,
197: p_bpa_attribute12_o
198: => per_bpa_shd.g_old_rec.bpa_attribute12,
199: p_bpa_attribute13_o
200: => per_bpa_shd.g_old_rec.bpa_attribute13,
201: p_bpa_attribute14_o
202: => per_bpa_shd.g_old_rec.bpa_attribute14,

Line 200: => per_bpa_shd.g_old_rec.bpa_attribute13,

196: => per_bpa_shd.g_old_rec.bpa_attribute11,
197: p_bpa_attribute12_o
198: => per_bpa_shd.g_old_rec.bpa_attribute12,
199: p_bpa_attribute13_o
200: => per_bpa_shd.g_old_rec.bpa_attribute13,
201: p_bpa_attribute14_o
202: => per_bpa_shd.g_old_rec.bpa_attribute14,
203: p_bpa_attribute15_o
204: => per_bpa_shd.g_old_rec.bpa_attribute15,

Line 202: => per_bpa_shd.g_old_rec.bpa_attribute14,

198: => per_bpa_shd.g_old_rec.bpa_attribute12,
199: p_bpa_attribute13_o
200: => per_bpa_shd.g_old_rec.bpa_attribute13,
201: p_bpa_attribute14_o
202: => per_bpa_shd.g_old_rec.bpa_attribute14,
203: p_bpa_attribute15_o
204: => per_bpa_shd.g_old_rec.bpa_attribute15,
205: p_bpa_attribute16_o
206: => per_bpa_shd.g_old_rec.bpa_attribute16,

Line 204: => per_bpa_shd.g_old_rec.bpa_attribute15,

200: => per_bpa_shd.g_old_rec.bpa_attribute13,
201: p_bpa_attribute14_o
202: => per_bpa_shd.g_old_rec.bpa_attribute14,
203: p_bpa_attribute15_o
204: => per_bpa_shd.g_old_rec.bpa_attribute15,
205: p_bpa_attribute16_o
206: => per_bpa_shd.g_old_rec.bpa_attribute16,
207: p_bpa_attribute17_o
208: => per_bpa_shd.g_old_rec.bpa_attribute17,

Line 206: => per_bpa_shd.g_old_rec.bpa_attribute16,

202: => per_bpa_shd.g_old_rec.bpa_attribute14,
203: p_bpa_attribute15_o
204: => per_bpa_shd.g_old_rec.bpa_attribute15,
205: p_bpa_attribute16_o
206: => per_bpa_shd.g_old_rec.bpa_attribute16,
207: p_bpa_attribute17_o
208: => per_bpa_shd.g_old_rec.bpa_attribute17,
209: p_bpa_attribute18_o
210: => per_bpa_shd.g_old_rec.bpa_attribute18,

Line 208: => per_bpa_shd.g_old_rec.bpa_attribute17,

204: => per_bpa_shd.g_old_rec.bpa_attribute15,
205: p_bpa_attribute16_o
206: => per_bpa_shd.g_old_rec.bpa_attribute16,
207: p_bpa_attribute17_o
208: => per_bpa_shd.g_old_rec.bpa_attribute17,
209: p_bpa_attribute18_o
210: => per_bpa_shd.g_old_rec.bpa_attribute18,
211: p_bpa_attribute19_o
212: => per_bpa_shd.g_old_rec.bpa_attribute19,

Line 210: => per_bpa_shd.g_old_rec.bpa_attribute18,

206: => per_bpa_shd.g_old_rec.bpa_attribute16,
207: p_bpa_attribute17_o
208: => per_bpa_shd.g_old_rec.bpa_attribute17,
209: p_bpa_attribute18_o
210: => per_bpa_shd.g_old_rec.bpa_attribute18,
211: p_bpa_attribute19_o
212: => per_bpa_shd.g_old_rec.bpa_attribute19,
213: p_bpa_attribute20_o
214: => per_bpa_shd.g_old_rec.bpa_attribute20,

Line 212: => per_bpa_shd.g_old_rec.bpa_attribute19,

208: => per_bpa_shd.g_old_rec.bpa_attribute17,
209: p_bpa_attribute18_o
210: => per_bpa_shd.g_old_rec.bpa_attribute18,
211: p_bpa_attribute19_o
212: => per_bpa_shd.g_old_rec.bpa_attribute19,
213: p_bpa_attribute20_o
214: => per_bpa_shd.g_old_rec.bpa_attribute20,
215: p_bpa_attribute21_o
216: => per_bpa_shd.g_old_rec.bpa_attribute21,

Line 214: => per_bpa_shd.g_old_rec.bpa_attribute20,

210: => per_bpa_shd.g_old_rec.bpa_attribute18,
211: p_bpa_attribute19_o
212: => per_bpa_shd.g_old_rec.bpa_attribute19,
213: p_bpa_attribute20_o
214: => per_bpa_shd.g_old_rec.bpa_attribute20,
215: p_bpa_attribute21_o
216: => per_bpa_shd.g_old_rec.bpa_attribute21,
217: p_bpa_attribute22_o
218: => per_bpa_shd.g_old_rec.bpa_attribute22,

Line 216: => per_bpa_shd.g_old_rec.bpa_attribute21,

212: => per_bpa_shd.g_old_rec.bpa_attribute19,
213: p_bpa_attribute20_o
214: => per_bpa_shd.g_old_rec.bpa_attribute20,
215: p_bpa_attribute21_o
216: => per_bpa_shd.g_old_rec.bpa_attribute21,
217: p_bpa_attribute22_o
218: => per_bpa_shd.g_old_rec.bpa_attribute22,
219: p_bpa_attribute23_o
220: => per_bpa_shd.g_old_rec.bpa_attribute23,

Line 218: => per_bpa_shd.g_old_rec.bpa_attribute22,

214: => per_bpa_shd.g_old_rec.bpa_attribute20,
215: p_bpa_attribute21_o
216: => per_bpa_shd.g_old_rec.bpa_attribute21,
217: p_bpa_attribute22_o
218: => per_bpa_shd.g_old_rec.bpa_attribute22,
219: p_bpa_attribute23_o
220: => per_bpa_shd.g_old_rec.bpa_attribute23,
221: p_bpa_attribute24_o
222: => per_bpa_shd.g_old_rec.bpa_attribute24,

Line 220: => per_bpa_shd.g_old_rec.bpa_attribute23,

216: => per_bpa_shd.g_old_rec.bpa_attribute21,
217: p_bpa_attribute22_o
218: => per_bpa_shd.g_old_rec.bpa_attribute22,
219: p_bpa_attribute23_o
220: => per_bpa_shd.g_old_rec.bpa_attribute23,
221: p_bpa_attribute24_o
222: => per_bpa_shd.g_old_rec.bpa_attribute24,
223: p_bpa_attribute25_o
224: => per_bpa_shd.g_old_rec.bpa_attribute25,

Line 222: => per_bpa_shd.g_old_rec.bpa_attribute24,

218: => per_bpa_shd.g_old_rec.bpa_attribute22,
219: p_bpa_attribute23_o
220: => per_bpa_shd.g_old_rec.bpa_attribute23,
221: p_bpa_attribute24_o
222: => per_bpa_shd.g_old_rec.bpa_attribute24,
223: p_bpa_attribute25_o
224: => per_bpa_shd.g_old_rec.bpa_attribute25,
225: p_bpa_attribute26_o
226: => per_bpa_shd.g_old_rec.bpa_attribute26,

Line 224: => per_bpa_shd.g_old_rec.bpa_attribute25,

220: => per_bpa_shd.g_old_rec.bpa_attribute23,
221: p_bpa_attribute24_o
222: => per_bpa_shd.g_old_rec.bpa_attribute24,
223: p_bpa_attribute25_o
224: => per_bpa_shd.g_old_rec.bpa_attribute25,
225: p_bpa_attribute26_o
226: => per_bpa_shd.g_old_rec.bpa_attribute26,
227: p_bpa_attribute27_o
228: => per_bpa_shd.g_old_rec.bpa_attribute27,

Line 226: => per_bpa_shd.g_old_rec.bpa_attribute26,

222: => per_bpa_shd.g_old_rec.bpa_attribute24,
223: p_bpa_attribute25_o
224: => per_bpa_shd.g_old_rec.bpa_attribute25,
225: p_bpa_attribute26_o
226: => per_bpa_shd.g_old_rec.bpa_attribute26,
227: p_bpa_attribute27_o
228: => per_bpa_shd.g_old_rec.bpa_attribute27,
229: p_bpa_attribute28_o
230: => per_bpa_shd.g_old_rec.bpa_attribute28,

Line 228: => per_bpa_shd.g_old_rec.bpa_attribute27,

224: => per_bpa_shd.g_old_rec.bpa_attribute25,
225: p_bpa_attribute26_o
226: => per_bpa_shd.g_old_rec.bpa_attribute26,
227: p_bpa_attribute27_o
228: => per_bpa_shd.g_old_rec.bpa_attribute27,
229: p_bpa_attribute28_o
230: => per_bpa_shd.g_old_rec.bpa_attribute28,
231: p_bpa_attribute29_o
232: => per_bpa_shd.g_old_rec.bpa_attribute29,

Line 230: => per_bpa_shd.g_old_rec.bpa_attribute28,

226: => per_bpa_shd.g_old_rec.bpa_attribute26,
227: p_bpa_attribute27_o
228: => per_bpa_shd.g_old_rec.bpa_attribute27,
229: p_bpa_attribute28_o
230: => per_bpa_shd.g_old_rec.bpa_attribute28,
231: p_bpa_attribute29_o
232: => per_bpa_shd.g_old_rec.bpa_attribute29,
233: p_bpa_attribute30_o
234: => per_bpa_shd.g_old_rec.bpa_attribute30

Line 232: => per_bpa_shd.g_old_rec.bpa_attribute29,

228: => per_bpa_shd.g_old_rec.bpa_attribute27,
229: p_bpa_attribute28_o
230: => per_bpa_shd.g_old_rec.bpa_attribute28,
231: p_bpa_attribute29_o
232: => per_bpa_shd.g_old_rec.bpa_attribute29,
233: p_bpa_attribute30_o
234: => per_bpa_shd.g_old_rec.bpa_attribute30
235: );
236: --

Line 234: => per_bpa_shd.g_old_rec.bpa_attribute30

230: => per_bpa_shd.g_old_rec.bpa_attribute28,
231: p_bpa_attribute29_o
232: => per_bpa_shd.g_old_rec.bpa_attribute29,
233: p_bpa_attribute30_o
234: => per_bpa_shd.g_old_rec.bpa_attribute30
235: );
236: --
237: exception
238: --

Line 254: (p_rec in per_bpa_shd.g_rec_type

250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< del >----------------------------------|
252: -- ----------------------------------------------------------------------------
253: Procedure del
254: (p_rec in per_bpa_shd.g_rec_type
255: ) is
256: --
257: l_proc varchar2(72) := g_package||'del';
258: --

Line 264: per_bpa_shd.lck

260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: -- We must lock the row which we need to delete.
263: --
264: per_bpa_shd.lck
265: (p_rec.processed_assignment_id
266: ,p_rec.object_version_number
267: );
268: --

Line 294: l_rec per_bpa_shd.g_rec_type;

290: (p_processed_assignment_id in number
291: ,p_object_version_number in number
292: ) is
293: --
294: l_rec per_bpa_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'del';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);