APPS.PER_APL_DEL dependencies on PER_APL_SHD

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

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

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

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

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

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

Line 73: per_apl_shd.constraint_error

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

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

72: per_apl_shd.g_api_dml := false; -- Unset the api dml status
73: per_apl_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_apl_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 per_apl_shd.g_rec_type) is

108: -- Internal Table Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in per_apl_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 per_apl_shd.g_rec_type) is

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

Line 166: => per_apl_shd.g_old_rec.business_group_id

162: begin
163: per_apl_rkd.after_delete
164: (p_application_id => p_rec.application_id
165: ,p_business_group_id_o
166: => per_apl_shd.g_old_rec.business_group_id
167: ,p_person_id_o
168: => per_apl_shd.g_old_rec.person_id
169: ,p_date_received_o
170: => per_apl_shd.g_old_rec.date_received

Line 168: => per_apl_shd.g_old_rec.person_id

164: (p_application_id => p_rec.application_id
165: ,p_business_group_id_o
166: => per_apl_shd.g_old_rec.business_group_id
167: ,p_person_id_o
168: => per_apl_shd.g_old_rec.person_id
169: ,p_date_received_o
170: => per_apl_shd.g_old_rec.date_received
171: ,p_comments_o
172: => per_apl_shd.g_old_rec.comments

Line 170: => per_apl_shd.g_old_rec.date_received

166: => per_apl_shd.g_old_rec.business_group_id
167: ,p_person_id_o
168: => per_apl_shd.g_old_rec.person_id
169: ,p_date_received_o
170: => per_apl_shd.g_old_rec.date_received
171: ,p_comments_o
172: => per_apl_shd.g_old_rec.comments
173: ,p_current_employer_o
174: => per_apl_shd.g_old_rec.current_employer

Line 172: => per_apl_shd.g_old_rec.comments

168: => per_apl_shd.g_old_rec.person_id
169: ,p_date_received_o
170: => per_apl_shd.g_old_rec.date_received
171: ,p_comments_o
172: => per_apl_shd.g_old_rec.comments
173: ,p_current_employer_o
174: => per_apl_shd.g_old_rec.current_employer
175: ,p_date_end_o
176: => per_apl_shd.g_old_rec.date_end

Line 174: => per_apl_shd.g_old_rec.current_employer

170: => per_apl_shd.g_old_rec.date_received
171: ,p_comments_o
172: => per_apl_shd.g_old_rec.comments
173: ,p_current_employer_o
174: => per_apl_shd.g_old_rec.current_employer
175: ,p_date_end_o
176: => per_apl_shd.g_old_rec.date_end
177: ,p_projected_hire_date_o
178: => per_apl_shd.g_old_rec.projected_hire_date

Line 176: => per_apl_shd.g_old_rec.date_end

172: => per_apl_shd.g_old_rec.comments
173: ,p_current_employer_o
174: => per_apl_shd.g_old_rec.current_employer
175: ,p_date_end_o
176: => per_apl_shd.g_old_rec.date_end
177: ,p_projected_hire_date_o
178: => per_apl_shd.g_old_rec.projected_hire_date
179: ,p_successful_flag_o
180: => per_apl_shd.g_old_rec.successful_flag

Line 178: => per_apl_shd.g_old_rec.projected_hire_date

174: => per_apl_shd.g_old_rec.current_employer
175: ,p_date_end_o
176: => per_apl_shd.g_old_rec.date_end
177: ,p_projected_hire_date_o
178: => per_apl_shd.g_old_rec.projected_hire_date
179: ,p_successful_flag_o
180: => per_apl_shd.g_old_rec.successful_flag
181: ,p_termination_reason_o
182: => per_apl_shd.g_old_rec.termination_reason

Line 180: => per_apl_shd.g_old_rec.successful_flag

176: => per_apl_shd.g_old_rec.date_end
177: ,p_projected_hire_date_o
178: => per_apl_shd.g_old_rec.projected_hire_date
179: ,p_successful_flag_o
180: => per_apl_shd.g_old_rec.successful_flag
181: ,p_termination_reason_o
182: => per_apl_shd.g_old_rec.termination_reason
183: ,p_request_id_o
184: => per_apl_shd.g_old_rec.request_id

Line 182: => per_apl_shd.g_old_rec.termination_reason

178: => per_apl_shd.g_old_rec.projected_hire_date
179: ,p_successful_flag_o
180: => per_apl_shd.g_old_rec.successful_flag
181: ,p_termination_reason_o
182: => per_apl_shd.g_old_rec.termination_reason
183: ,p_request_id_o
184: => per_apl_shd.g_old_rec.request_id
185: ,p_program_application_id_o
186: => per_apl_shd.g_old_rec.program_application_id

Line 184: => per_apl_shd.g_old_rec.request_id

180: => per_apl_shd.g_old_rec.successful_flag
181: ,p_termination_reason_o
182: => per_apl_shd.g_old_rec.termination_reason
183: ,p_request_id_o
184: => per_apl_shd.g_old_rec.request_id
185: ,p_program_application_id_o
186: => per_apl_shd.g_old_rec.program_application_id
187: ,p_program_id_o
188: => per_apl_shd.g_old_rec.program_id

Line 186: => per_apl_shd.g_old_rec.program_application_id

182: => per_apl_shd.g_old_rec.termination_reason
183: ,p_request_id_o
184: => per_apl_shd.g_old_rec.request_id
185: ,p_program_application_id_o
186: => per_apl_shd.g_old_rec.program_application_id
187: ,p_program_id_o
188: => per_apl_shd.g_old_rec.program_id
189: ,p_program_update_date_o
190: => per_apl_shd.g_old_rec.program_update_date

Line 188: => per_apl_shd.g_old_rec.program_id

184: => per_apl_shd.g_old_rec.request_id
185: ,p_program_application_id_o
186: => per_apl_shd.g_old_rec.program_application_id
187: ,p_program_id_o
188: => per_apl_shd.g_old_rec.program_id
189: ,p_program_update_date_o
190: => per_apl_shd.g_old_rec.program_update_date
191: ,p_appl_attribute_category_o
192: => per_apl_shd.g_old_rec.appl_attribute_category

Line 190: => per_apl_shd.g_old_rec.program_update_date

186: => per_apl_shd.g_old_rec.program_application_id
187: ,p_program_id_o
188: => per_apl_shd.g_old_rec.program_id
189: ,p_program_update_date_o
190: => per_apl_shd.g_old_rec.program_update_date
191: ,p_appl_attribute_category_o
192: => per_apl_shd.g_old_rec.appl_attribute_category
193: ,p_appl_attribute1_o
194: => per_apl_shd.g_old_rec.appl_attribute1

Line 192: => per_apl_shd.g_old_rec.appl_attribute_category

188: => per_apl_shd.g_old_rec.program_id
189: ,p_program_update_date_o
190: => per_apl_shd.g_old_rec.program_update_date
191: ,p_appl_attribute_category_o
192: => per_apl_shd.g_old_rec.appl_attribute_category
193: ,p_appl_attribute1_o
194: => per_apl_shd.g_old_rec.appl_attribute1
195: ,p_appl_attribute2_o
196: => per_apl_shd.g_old_rec.appl_attribute2

Line 194: => per_apl_shd.g_old_rec.appl_attribute1

190: => per_apl_shd.g_old_rec.program_update_date
191: ,p_appl_attribute_category_o
192: => per_apl_shd.g_old_rec.appl_attribute_category
193: ,p_appl_attribute1_o
194: => per_apl_shd.g_old_rec.appl_attribute1
195: ,p_appl_attribute2_o
196: => per_apl_shd.g_old_rec.appl_attribute2
197: ,p_appl_attribute3_o
198: => per_apl_shd.g_old_rec.appl_attribute3

Line 196: => per_apl_shd.g_old_rec.appl_attribute2

192: => per_apl_shd.g_old_rec.appl_attribute_category
193: ,p_appl_attribute1_o
194: => per_apl_shd.g_old_rec.appl_attribute1
195: ,p_appl_attribute2_o
196: => per_apl_shd.g_old_rec.appl_attribute2
197: ,p_appl_attribute3_o
198: => per_apl_shd.g_old_rec.appl_attribute3
199: ,p_appl_attribute4_o
200: => per_apl_shd.g_old_rec.appl_attribute4

Line 198: => per_apl_shd.g_old_rec.appl_attribute3

194: => per_apl_shd.g_old_rec.appl_attribute1
195: ,p_appl_attribute2_o
196: => per_apl_shd.g_old_rec.appl_attribute2
197: ,p_appl_attribute3_o
198: => per_apl_shd.g_old_rec.appl_attribute3
199: ,p_appl_attribute4_o
200: => per_apl_shd.g_old_rec.appl_attribute4
201: ,p_appl_attribute5_o
202: => per_apl_shd.g_old_rec.appl_attribute5

Line 200: => per_apl_shd.g_old_rec.appl_attribute4

196: => per_apl_shd.g_old_rec.appl_attribute2
197: ,p_appl_attribute3_o
198: => per_apl_shd.g_old_rec.appl_attribute3
199: ,p_appl_attribute4_o
200: => per_apl_shd.g_old_rec.appl_attribute4
201: ,p_appl_attribute5_o
202: => per_apl_shd.g_old_rec.appl_attribute5
203: ,p_appl_attribute6_o
204: => per_apl_shd.g_old_rec.appl_attribute6

Line 202: => per_apl_shd.g_old_rec.appl_attribute5

198: => per_apl_shd.g_old_rec.appl_attribute3
199: ,p_appl_attribute4_o
200: => per_apl_shd.g_old_rec.appl_attribute4
201: ,p_appl_attribute5_o
202: => per_apl_shd.g_old_rec.appl_attribute5
203: ,p_appl_attribute6_o
204: => per_apl_shd.g_old_rec.appl_attribute6
205: ,p_appl_attribute7_o
206: => per_apl_shd.g_old_rec.appl_attribute7

Line 204: => per_apl_shd.g_old_rec.appl_attribute6

200: => per_apl_shd.g_old_rec.appl_attribute4
201: ,p_appl_attribute5_o
202: => per_apl_shd.g_old_rec.appl_attribute5
203: ,p_appl_attribute6_o
204: => per_apl_shd.g_old_rec.appl_attribute6
205: ,p_appl_attribute7_o
206: => per_apl_shd.g_old_rec.appl_attribute7
207: ,p_appl_attribute8_o
208: => per_apl_shd.g_old_rec.appl_attribute8

Line 206: => per_apl_shd.g_old_rec.appl_attribute7

202: => per_apl_shd.g_old_rec.appl_attribute5
203: ,p_appl_attribute6_o
204: => per_apl_shd.g_old_rec.appl_attribute6
205: ,p_appl_attribute7_o
206: => per_apl_shd.g_old_rec.appl_attribute7
207: ,p_appl_attribute8_o
208: => per_apl_shd.g_old_rec.appl_attribute8
209: ,p_appl_attribute9_o
210: => per_apl_shd.g_old_rec.appl_attribute9

Line 208: => per_apl_shd.g_old_rec.appl_attribute8

204: => per_apl_shd.g_old_rec.appl_attribute6
205: ,p_appl_attribute7_o
206: => per_apl_shd.g_old_rec.appl_attribute7
207: ,p_appl_attribute8_o
208: => per_apl_shd.g_old_rec.appl_attribute8
209: ,p_appl_attribute9_o
210: => per_apl_shd.g_old_rec.appl_attribute9
211: ,p_appl_attribute10_o
212: => per_apl_shd.g_old_rec.appl_attribute10

Line 210: => per_apl_shd.g_old_rec.appl_attribute9

206: => per_apl_shd.g_old_rec.appl_attribute7
207: ,p_appl_attribute8_o
208: => per_apl_shd.g_old_rec.appl_attribute8
209: ,p_appl_attribute9_o
210: => per_apl_shd.g_old_rec.appl_attribute9
211: ,p_appl_attribute10_o
212: => per_apl_shd.g_old_rec.appl_attribute10
213: ,p_appl_attribute11_o
214: => per_apl_shd.g_old_rec.appl_attribute11

Line 212: => per_apl_shd.g_old_rec.appl_attribute10

208: => per_apl_shd.g_old_rec.appl_attribute8
209: ,p_appl_attribute9_o
210: => per_apl_shd.g_old_rec.appl_attribute9
211: ,p_appl_attribute10_o
212: => per_apl_shd.g_old_rec.appl_attribute10
213: ,p_appl_attribute11_o
214: => per_apl_shd.g_old_rec.appl_attribute11
215: ,p_appl_attribute12_o
216: => per_apl_shd.g_old_rec.appl_attribute12

Line 214: => per_apl_shd.g_old_rec.appl_attribute11

210: => per_apl_shd.g_old_rec.appl_attribute9
211: ,p_appl_attribute10_o
212: => per_apl_shd.g_old_rec.appl_attribute10
213: ,p_appl_attribute11_o
214: => per_apl_shd.g_old_rec.appl_attribute11
215: ,p_appl_attribute12_o
216: => per_apl_shd.g_old_rec.appl_attribute12
217: ,p_appl_attribute13_o
218: => per_apl_shd.g_old_rec.appl_attribute13

Line 216: => per_apl_shd.g_old_rec.appl_attribute12

212: => per_apl_shd.g_old_rec.appl_attribute10
213: ,p_appl_attribute11_o
214: => per_apl_shd.g_old_rec.appl_attribute11
215: ,p_appl_attribute12_o
216: => per_apl_shd.g_old_rec.appl_attribute12
217: ,p_appl_attribute13_o
218: => per_apl_shd.g_old_rec.appl_attribute13
219: ,p_appl_attribute14_o
220: => per_apl_shd.g_old_rec.appl_attribute14

Line 218: => per_apl_shd.g_old_rec.appl_attribute13

214: => per_apl_shd.g_old_rec.appl_attribute11
215: ,p_appl_attribute12_o
216: => per_apl_shd.g_old_rec.appl_attribute12
217: ,p_appl_attribute13_o
218: => per_apl_shd.g_old_rec.appl_attribute13
219: ,p_appl_attribute14_o
220: => per_apl_shd.g_old_rec.appl_attribute14
221: ,p_appl_attribute15_o
222: => per_apl_shd.g_old_rec.appl_attribute15

Line 220: => per_apl_shd.g_old_rec.appl_attribute14

216: => per_apl_shd.g_old_rec.appl_attribute12
217: ,p_appl_attribute13_o
218: => per_apl_shd.g_old_rec.appl_attribute13
219: ,p_appl_attribute14_o
220: => per_apl_shd.g_old_rec.appl_attribute14
221: ,p_appl_attribute15_o
222: => per_apl_shd.g_old_rec.appl_attribute15
223: ,p_appl_attribute16_o
224: => per_apl_shd.g_old_rec.appl_attribute16

Line 222: => per_apl_shd.g_old_rec.appl_attribute15

218: => per_apl_shd.g_old_rec.appl_attribute13
219: ,p_appl_attribute14_o
220: => per_apl_shd.g_old_rec.appl_attribute14
221: ,p_appl_attribute15_o
222: => per_apl_shd.g_old_rec.appl_attribute15
223: ,p_appl_attribute16_o
224: => per_apl_shd.g_old_rec.appl_attribute16
225: ,p_appl_attribute17_o
226: => per_apl_shd.g_old_rec.appl_attribute17

Line 224: => per_apl_shd.g_old_rec.appl_attribute16

220: => per_apl_shd.g_old_rec.appl_attribute14
221: ,p_appl_attribute15_o
222: => per_apl_shd.g_old_rec.appl_attribute15
223: ,p_appl_attribute16_o
224: => per_apl_shd.g_old_rec.appl_attribute16
225: ,p_appl_attribute17_o
226: => per_apl_shd.g_old_rec.appl_attribute17
227: ,p_appl_attribute18_o
228: => per_apl_shd.g_old_rec.appl_attribute18

Line 226: => per_apl_shd.g_old_rec.appl_attribute17

222: => per_apl_shd.g_old_rec.appl_attribute15
223: ,p_appl_attribute16_o
224: => per_apl_shd.g_old_rec.appl_attribute16
225: ,p_appl_attribute17_o
226: => per_apl_shd.g_old_rec.appl_attribute17
227: ,p_appl_attribute18_o
228: => per_apl_shd.g_old_rec.appl_attribute18
229: ,p_appl_attribute19_o
230: => per_apl_shd.g_old_rec.appl_attribute19

Line 228: => per_apl_shd.g_old_rec.appl_attribute18

224: => per_apl_shd.g_old_rec.appl_attribute16
225: ,p_appl_attribute17_o
226: => per_apl_shd.g_old_rec.appl_attribute17
227: ,p_appl_attribute18_o
228: => per_apl_shd.g_old_rec.appl_attribute18
229: ,p_appl_attribute19_o
230: => per_apl_shd.g_old_rec.appl_attribute19
231: ,p_appl_attribute20_o
232: => per_apl_shd.g_old_rec.appl_attribute20

Line 230: => per_apl_shd.g_old_rec.appl_attribute19

226: => per_apl_shd.g_old_rec.appl_attribute17
227: ,p_appl_attribute18_o
228: => per_apl_shd.g_old_rec.appl_attribute18
229: ,p_appl_attribute19_o
230: => per_apl_shd.g_old_rec.appl_attribute19
231: ,p_appl_attribute20_o
232: => per_apl_shd.g_old_rec.appl_attribute20
233: ,p_object_version_number_o
234: => per_apl_shd.g_old_rec.object_version_number

Line 232: => per_apl_shd.g_old_rec.appl_attribute20

228: => per_apl_shd.g_old_rec.appl_attribute18
229: ,p_appl_attribute19_o
230: => per_apl_shd.g_old_rec.appl_attribute19
231: ,p_appl_attribute20_o
232: => per_apl_shd.g_old_rec.appl_attribute20
233: ,p_object_version_number_o
234: => per_apl_shd.g_old_rec.object_version_number
235: );
236: exception

Line 234: => per_apl_shd.g_old_rec.object_version_number

230: => per_apl_shd.g_old_rec.appl_attribute19
231: ,p_appl_attribute20_o
232: => per_apl_shd.g_old_rec.appl_attribute20
233: ,p_object_version_number_o
234: => per_apl_shd.g_old_rec.object_version_number
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error

Line 253: p_rec in per_apl_shd.g_rec_type,

249: -- |---------------------------------< del >----------------------------------|
250: -- ----------------------------------------------------------------------------
251: Procedure del
252: (
253: p_rec in per_apl_shd.g_rec_type,
254: p_validate in boolean default false
255: ) is
256: --
257: l_proc varchar2(72) := g_package||'del';

Line 273: per_apl_shd.lck

269: End If;
270: --
271: -- We must lock the row which we need to delete.
272: --
273: per_apl_shd.lck
274: (
275: p_rec.application_id,
276: p_rec.object_version_number
277: );

Line 329: l_rec per_apl_shd.g_rec_type;

325: p_object_version_number in number,
326: p_validate in boolean default false
327: ) is
328: --
329: l_rec per_apl_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'del';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);