APPS.PER_ADD_DEL dependencies on PER_ADD_SHD

Line 51: Procedure delete_dml(p_rec in out nocopy per_add_shd.g_rec_type) is

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

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

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

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

Line 73: per_add_shd.constraint_error

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

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

72: per_add_shd.g_api_dml := false; -- Unset the api dml status
73: per_add_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_add_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_add_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_add_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_add_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_add_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

Line 166: => per_add_shd.g_old_rec.business_group_id

162: begin
163: per_add_rkd.after_delete
164: (p_address_id => p_rec.address_id
165: ,p_business_group_id_o
166: => per_add_shd.g_old_rec.business_group_id
167: ,p_date_from_o
168: => per_add_shd.g_old_rec.date_from
169: ,p_address_line1_o
170: => per_add_shd.g_old_rec.address_line1

Line 168: => per_add_shd.g_old_rec.date_from

164: (p_address_id => p_rec.address_id
165: ,p_business_group_id_o
166: => per_add_shd.g_old_rec.business_group_id
167: ,p_date_from_o
168: => per_add_shd.g_old_rec.date_from
169: ,p_address_line1_o
170: => per_add_shd.g_old_rec.address_line1
171: ,p_address_line2_o
172: => per_add_shd.g_old_rec.address_line2

Line 170: => per_add_shd.g_old_rec.address_line1

166: => per_add_shd.g_old_rec.business_group_id
167: ,p_date_from_o
168: => per_add_shd.g_old_rec.date_from
169: ,p_address_line1_o
170: => per_add_shd.g_old_rec.address_line1
171: ,p_address_line2_o
172: => per_add_shd.g_old_rec.address_line2
173: ,p_address_line3_o
174: => per_add_shd.g_old_rec.address_line3

Line 172: => per_add_shd.g_old_rec.address_line2

168: => per_add_shd.g_old_rec.date_from
169: ,p_address_line1_o
170: => per_add_shd.g_old_rec.address_line1
171: ,p_address_line2_o
172: => per_add_shd.g_old_rec.address_line2
173: ,p_address_line3_o
174: => per_add_shd.g_old_rec.address_line3
175: ,p_address_type_o
176: => per_add_shd.g_old_rec.address_type

Line 174: => per_add_shd.g_old_rec.address_line3

170: => per_add_shd.g_old_rec.address_line1
171: ,p_address_line2_o
172: => per_add_shd.g_old_rec.address_line2
173: ,p_address_line3_o
174: => per_add_shd.g_old_rec.address_line3
175: ,p_address_type_o
176: => per_add_shd.g_old_rec.address_type
177: ,p_comments_o
178: => per_add_shd.g_old_rec.comments

Line 176: => per_add_shd.g_old_rec.address_type

172: => per_add_shd.g_old_rec.address_line2
173: ,p_address_line3_o
174: => per_add_shd.g_old_rec.address_line3
175: ,p_address_type_o
176: => per_add_shd.g_old_rec.address_type
177: ,p_comments_o
178: => per_add_shd.g_old_rec.comments
179: ,p_country_o
180: => per_add_shd.g_old_rec.country

Line 178: => per_add_shd.g_old_rec.comments

174: => per_add_shd.g_old_rec.address_line3
175: ,p_address_type_o
176: => per_add_shd.g_old_rec.address_type
177: ,p_comments_o
178: => per_add_shd.g_old_rec.comments
179: ,p_country_o
180: => per_add_shd.g_old_rec.country
181: ,p_date_to_o
182: => per_add_shd.g_old_rec.date_to

Line 180: => per_add_shd.g_old_rec.country

176: => per_add_shd.g_old_rec.address_type
177: ,p_comments_o
178: => per_add_shd.g_old_rec.comments
179: ,p_country_o
180: => per_add_shd.g_old_rec.country
181: ,p_date_to_o
182: => per_add_shd.g_old_rec.date_to
183: ,p_postal_code_o
184: => per_add_shd.g_old_rec.postal_code

Line 182: => per_add_shd.g_old_rec.date_to

178: => per_add_shd.g_old_rec.comments
179: ,p_country_o
180: => per_add_shd.g_old_rec.country
181: ,p_date_to_o
182: => per_add_shd.g_old_rec.date_to
183: ,p_postal_code_o
184: => per_add_shd.g_old_rec.postal_code
185: ,p_region_1_o
186: => per_add_shd.g_old_rec.region_1

Line 184: => per_add_shd.g_old_rec.postal_code

180: => per_add_shd.g_old_rec.country
181: ,p_date_to_o
182: => per_add_shd.g_old_rec.date_to
183: ,p_postal_code_o
184: => per_add_shd.g_old_rec.postal_code
185: ,p_region_1_o
186: => per_add_shd.g_old_rec.region_1
187: ,p_region_2_o
188: => per_add_shd.g_old_rec.region_2

Line 186: => per_add_shd.g_old_rec.region_1

182: => per_add_shd.g_old_rec.date_to
183: ,p_postal_code_o
184: => per_add_shd.g_old_rec.postal_code
185: ,p_region_1_o
186: => per_add_shd.g_old_rec.region_1
187: ,p_region_2_o
188: => per_add_shd.g_old_rec.region_2
189: ,p_region_3_o
190: => per_add_shd.g_old_rec.region_3

Line 188: => per_add_shd.g_old_rec.region_2

184: => per_add_shd.g_old_rec.postal_code
185: ,p_region_1_o
186: => per_add_shd.g_old_rec.region_1
187: ,p_region_2_o
188: => per_add_shd.g_old_rec.region_2
189: ,p_region_3_o
190: => per_add_shd.g_old_rec.region_3
191: ,p_telephone_number_1_o
192: => per_add_shd.g_old_rec.telephone_number_1

Line 190: => per_add_shd.g_old_rec.region_3

186: => per_add_shd.g_old_rec.region_1
187: ,p_region_2_o
188: => per_add_shd.g_old_rec.region_2
189: ,p_region_3_o
190: => per_add_shd.g_old_rec.region_3
191: ,p_telephone_number_1_o
192: => per_add_shd.g_old_rec.telephone_number_1
193: ,p_telephone_number_2_o
194: => per_add_shd.g_old_rec.telephone_number_2

Line 192: => per_add_shd.g_old_rec.telephone_number_1

188: => per_add_shd.g_old_rec.region_2
189: ,p_region_3_o
190: => per_add_shd.g_old_rec.region_3
191: ,p_telephone_number_1_o
192: => per_add_shd.g_old_rec.telephone_number_1
193: ,p_telephone_number_2_o
194: => per_add_shd.g_old_rec.telephone_number_2
195: ,p_telephone_number_3_o
196: => per_add_shd.g_old_rec.telephone_number_3

Line 194: => per_add_shd.g_old_rec.telephone_number_2

190: => per_add_shd.g_old_rec.region_3
191: ,p_telephone_number_1_o
192: => per_add_shd.g_old_rec.telephone_number_1
193: ,p_telephone_number_2_o
194: => per_add_shd.g_old_rec.telephone_number_2
195: ,p_telephone_number_3_o
196: => per_add_shd.g_old_rec.telephone_number_3
197: ,p_town_or_city_o
198: => per_add_shd.g_old_rec.town_or_city

Line 196: => per_add_shd.g_old_rec.telephone_number_3

192: => per_add_shd.g_old_rec.telephone_number_1
193: ,p_telephone_number_2_o
194: => per_add_shd.g_old_rec.telephone_number_2
195: ,p_telephone_number_3_o
196: => per_add_shd.g_old_rec.telephone_number_3
197: ,p_town_or_city_o
198: => per_add_shd.g_old_rec.town_or_city
199: ,p_request_id_o
200: => per_add_shd.g_old_rec.request_id

Line 198: => per_add_shd.g_old_rec.town_or_city

194: => per_add_shd.g_old_rec.telephone_number_2
195: ,p_telephone_number_3_o
196: => per_add_shd.g_old_rec.telephone_number_3
197: ,p_town_or_city_o
198: => per_add_shd.g_old_rec.town_or_city
199: ,p_request_id_o
200: => per_add_shd.g_old_rec.request_id
201: ,p_program_application_id_o
202: => per_add_shd.g_old_rec.program_application_id

Line 200: => per_add_shd.g_old_rec.request_id

196: => per_add_shd.g_old_rec.telephone_number_3
197: ,p_town_or_city_o
198: => per_add_shd.g_old_rec.town_or_city
199: ,p_request_id_o
200: => per_add_shd.g_old_rec.request_id
201: ,p_program_application_id_o
202: => per_add_shd.g_old_rec.program_application_id
203: ,p_program_id_o
204: => per_add_shd.g_old_rec.program_id

Line 202: => per_add_shd.g_old_rec.program_application_id

198: => per_add_shd.g_old_rec.town_or_city
199: ,p_request_id_o
200: => per_add_shd.g_old_rec.request_id
201: ,p_program_application_id_o
202: => per_add_shd.g_old_rec.program_application_id
203: ,p_program_id_o
204: => per_add_shd.g_old_rec.program_id
205: ,p_program_update_date_o
206: => per_add_shd.g_old_rec.program_update_date

Line 204: => per_add_shd.g_old_rec.program_id

200: => per_add_shd.g_old_rec.request_id
201: ,p_program_application_id_o
202: => per_add_shd.g_old_rec.program_application_id
203: ,p_program_id_o
204: => per_add_shd.g_old_rec.program_id
205: ,p_program_update_date_o
206: => per_add_shd.g_old_rec.program_update_date
207: ,p_addr_attribute_category_o
208: => per_add_shd.g_old_rec.addr_attribute_category

Line 206: => per_add_shd.g_old_rec.program_update_date

202: => per_add_shd.g_old_rec.program_application_id
203: ,p_program_id_o
204: => per_add_shd.g_old_rec.program_id
205: ,p_program_update_date_o
206: => per_add_shd.g_old_rec.program_update_date
207: ,p_addr_attribute_category_o
208: => per_add_shd.g_old_rec.addr_attribute_category
209: ,p_addr_attribute1_o
210: => per_add_shd.g_old_rec.addr_attribute1

Line 208: => per_add_shd.g_old_rec.addr_attribute_category

204: => per_add_shd.g_old_rec.program_id
205: ,p_program_update_date_o
206: => per_add_shd.g_old_rec.program_update_date
207: ,p_addr_attribute_category_o
208: => per_add_shd.g_old_rec.addr_attribute_category
209: ,p_addr_attribute1_o
210: => per_add_shd.g_old_rec.addr_attribute1
211: ,p_addr_attribute2_o
212: => per_add_shd.g_old_rec.addr_attribute2

Line 210: => per_add_shd.g_old_rec.addr_attribute1

206: => per_add_shd.g_old_rec.program_update_date
207: ,p_addr_attribute_category_o
208: => per_add_shd.g_old_rec.addr_attribute_category
209: ,p_addr_attribute1_o
210: => per_add_shd.g_old_rec.addr_attribute1
211: ,p_addr_attribute2_o
212: => per_add_shd.g_old_rec.addr_attribute2
213: ,p_addr_attribute3_o
214: => per_add_shd.g_old_rec.addr_attribute3

Line 212: => per_add_shd.g_old_rec.addr_attribute2

208: => per_add_shd.g_old_rec.addr_attribute_category
209: ,p_addr_attribute1_o
210: => per_add_shd.g_old_rec.addr_attribute1
211: ,p_addr_attribute2_o
212: => per_add_shd.g_old_rec.addr_attribute2
213: ,p_addr_attribute3_o
214: => per_add_shd.g_old_rec.addr_attribute3
215: ,p_addr_attribute4_o
216: => per_add_shd.g_old_rec.addr_attribute4

Line 214: => per_add_shd.g_old_rec.addr_attribute3

210: => per_add_shd.g_old_rec.addr_attribute1
211: ,p_addr_attribute2_o
212: => per_add_shd.g_old_rec.addr_attribute2
213: ,p_addr_attribute3_o
214: => per_add_shd.g_old_rec.addr_attribute3
215: ,p_addr_attribute4_o
216: => per_add_shd.g_old_rec.addr_attribute4
217: ,p_addr_attribute5_o
218: => per_add_shd.g_old_rec.addr_attribute5

Line 216: => per_add_shd.g_old_rec.addr_attribute4

212: => per_add_shd.g_old_rec.addr_attribute2
213: ,p_addr_attribute3_o
214: => per_add_shd.g_old_rec.addr_attribute3
215: ,p_addr_attribute4_o
216: => per_add_shd.g_old_rec.addr_attribute4
217: ,p_addr_attribute5_o
218: => per_add_shd.g_old_rec.addr_attribute5
219: ,p_addr_attribute6_o
220: => per_add_shd.g_old_rec.addr_attribute6

Line 218: => per_add_shd.g_old_rec.addr_attribute5

214: => per_add_shd.g_old_rec.addr_attribute3
215: ,p_addr_attribute4_o
216: => per_add_shd.g_old_rec.addr_attribute4
217: ,p_addr_attribute5_o
218: => per_add_shd.g_old_rec.addr_attribute5
219: ,p_addr_attribute6_o
220: => per_add_shd.g_old_rec.addr_attribute6
221: ,p_addr_attribute7_o
222: => per_add_shd.g_old_rec.addr_attribute7

Line 220: => per_add_shd.g_old_rec.addr_attribute6

216: => per_add_shd.g_old_rec.addr_attribute4
217: ,p_addr_attribute5_o
218: => per_add_shd.g_old_rec.addr_attribute5
219: ,p_addr_attribute6_o
220: => per_add_shd.g_old_rec.addr_attribute6
221: ,p_addr_attribute7_o
222: => per_add_shd.g_old_rec.addr_attribute7
223: ,p_addr_attribute8_o
224: => per_add_shd.g_old_rec.addr_attribute8

Line 222: => per_add_shd.g_old_rec.addr_attribute7

218: => per_add_shd.g_old_rec.addr_attribute5
219: ,p_addr_attribute6_o
220: => per_add_shd.g_old_rec.addr_attribute6
221: ,p_addr_attribute7_o
222: => per_add_shd.g_old_rec.addr_attribute7
223: ,p_addr_attribute8_o
224: => per_add_shd.g_old_rec.addr_attribute8
225: ,p_addr_attribute9_o
226: => per_add_shd.g_old_rec.addr_attribute9

Line 224: => per_add_shd.g_old_rec.addr_attribute8

220: => per_add_shd.g_old_rec.addr_attribute6
221: ,p_addr_attribute7_o
222: => per_add_shd.g_old_rec.addr_attribute7
223: ,p_addr_attribute8_o
224: => per_add_shd.g_old_rec.addr_attribute8
225: ,p_addr_attribute9_o
226: => per_add_shd.g_old_rec.addr_attribute9
227: ,p_addr_attribute10_o
228: => per_add_shd.g_old_rec.addr_attribute10

Line 226: => per_add_shd.g_old_rec.addr_attribute9

222: => per_add_shd.g_old_rec.addr_attribute7
223: ,p_addr_attribute8_o
224: => per_add_shd.g_old_rec.addr_attribute8
225: ,p_addr_attribute9_o
226: => per_add_shd.g_old_rec.addr_attribute9
227: ,p_addr_attribute10_o
228: => per_add_shd.g_old_rec.addr_attribute10
229: ,p_addr_attribute11_o
230: => per_add_shd.g_old_rec.addr_attribute11

Line 228: => per_add_shd.g_old_rec.addr_attribute10

224: => per_add_shd.g_old_rec.addr_attribute8
225: ,p_addr_attribute9_o
226: => per_add_shd.g_old_rec.addr_attribute9
227: ,p_addr_attribute10_o
228: => per_add_shd.g_old_rec.addr_attribute10
229: ,p_addr_attribute11_o
230: => per_add_shd.g_old_rec.addr_attribute11
231: ,p_addr_attribute12_o
232: => per_add_shd.g_old_rec.addr_attribute12

Line 230: => per_add_shd.g_old_rec.addr_attribute11

226: => per_add_shd.g_old_rec.addr_attribute9
227: ,p_addr_attribute10_o
228: => per_add_shd.g_old_rec.addr_attribute10
229: ,p_addr_attribute11_o
230: => per_add_shd.g_old_rec.addr_attribute11
231: ,p_addr_attribute12_o
232: => per_add_shd.g_old_rec.addr_attribute12
233: ,p_addr_attribute13_o
234: => per_add_shd.g_old_rec.addr_attribute13

Line 232: => per_add_shd.g_old_rec.addr_attribute12

228: => per_add_shd.g_old_rec.addr_attribute10
229: ,p_addr_attribute11_o
230: => per_add_shd.g_old_rec.addr_attribute11
231: ,p_addr_attribute12_o
232: => per_add_shd.g_old_rec.addr_attribute12
233: ,p_addr_attribute13_o
234: => per_add_shd.g_old_rec.addr_attribute13
235: ,p_addr_attribute14_o
236: => per_add_shd.g_old_rec.addr_attribute14

Line 234: => per_add_shd.g_old_rec.addr_attribute13

230: => per_add_shd.g_old_rec.addr_attribute11
231: ,p_addr_attribute12_o
232: => per_add_shd.g_old_rec.addr_attribute12
233: ,p_addr_attribute13_o
234: => per_add_shd.g_old_rec.addr_attribute13
235: ,p_addr_attribute14_o
236: => per_add_shd.g_old_rec.addr_attribute14
237: ,p_addr_attribute15_o
238: => per_add_shd.g_old_rec.addr_attribute15

Line 236: => per_add_shd.g_old_rec.addr_attribute14

232: => per_add_shd.g_old_rec.addr_attribute12
233: ,p_addr_attribute13_o
234: => per_add_shd.g_old_rec.addr_attribute13
235: ,p_addr_attribute14_o
236: => per_add_shd.g_old_rec.addr_attribute14
237: ,p_addr_attribute15_o
238: => per_add_shd.g_old_rec.addr_attribute15
239: ,p_addr_attribute16_o
240: => per_add_shd.g_old_rec.addr_attribute16

Line 238: => per_add_shd.g_old_rec.addr_attribute15

234: => per_add_shd.g_old_rec.addr_attribute13
235: ,p_addr_attribute14_o
236: => per_add_shd.g_old_rec.addr_attribute14
237: ,p_addr_attribute15_o
238: => per_add_shd.g_old_rec.addr_attribute15
239: ,p_addr_attribute16_o
240: => per_add_shd.g_old_rec.addr_attribute16
241: ,p_addr_attribute17_o
242: => per_add_shd.g_old_rec.addr_attribute17

Line 240: => per_add_shd.g_old_rec.addr_attribute16

236: => per_add_shd.g_old_rec.addr_attribute14
237: ,p_addr_attribute15_o
238: => per_add_shd.g_old_rec.addr_attribute15
239: ,p_addr_attribute16_o
240: => per_add_shd.g_old_rec.addr_attribute16
241: ,p_addr_attribute17_o
242: => per_add_shd.g_old_rec.addr_attribute17
243: ,p_addr_attribute18_o
244: => per_add_shd.g_old_rec.addr_attribute18

Line 242: => per_add_shd.g_old_rec.addr_attribute17

238: => per_add_shd.g_old_rec.addr_attribute15
239: ,p_addr_attribute16_o
240: => per_add_shd.g_old_rec.addr_attribute16
241: ,p_addr_attribute17_o
242: => per_add_shd.g_old_rec.addr_attribute17
243: ,p_addr_attribute18_o
244: => per_add_shd.g_old_rec.addr_attribute18
245: ,p_addr_attribute19_o
246: => per_add_shd.g_old_rec.addr_attribute19

Line 244: => per_add_shd.g_old_rec.addr_attribute18

240: => per_add_shd.g_old_rec.addr_attribute16
241: ,p_addr_attribute17_o
242: => per_add_shd.g_old_rec.addr_attribute17
243: ,p_addr_attribute18_o
244: => per_add_shd.g_old_rec.addr_attribute18
245: ,p_addr_attribute19_o
246: => per_add_shd.g_old_rec.addr_attribute19
247: ,p_addr_attribute20_o
248: => per_add_shd.g_old_rec.addr_attribute20

Line 246: => per_add_shd.g_old_rec.addr_attribute19

242: => per_add_shd.g_old_rec.addr_attribute17
243: ,p_addr_attribute18_o
244: => per_add_shd.g_old_rec.addr_attribute18
245: ,p_addr_attribute19_o
246: => per_add_shd.g_old_rec.addr_attribute19
247: ,p_addr_attribute20_o
248: => per_add_shd.g_old_rec.addr_attribute20
249: ,p_add_information13_o
250: => per_add_shd.g_old_rec.add_information13

Line 248: => per_add_shd.g_old_rec.addr_attribute20

244: => per_add_shd.g_old_rec.addr_attribute18
245: ,p_addr_attribute19_o
246: => per_add_shd.g_old_rec.addr_attribute19
247: ,p_addr_attribute20_o
248: => per_add_shd.g_old_rec.addr_attribute20
249: ,p_add_information13_o
250: => per_add_shd.g_old_rec.add_information13
251: ,p_add_information14_o
252: => per_add_shd.g_old_rec.add_information14

Line 250: => per_add_shd.g_old_rec.add_information13

246: => per_add_shd.g_old_rec.addr_attribute19
247: ,p_addr_attribute20_o
248: => per_add_shd.g_old_rec.addr_attribute20
249: ,p_add_information13_o
250: => per_add_shd.g_old_rec.add_information13
251: ,p_add_information14_o
252: => per_add_shd.g_old_rec.add_information14
253: ,p_add_information15_o
254: => per_add_shd.g_old_rec.add_information15

Line 252: => per_add_shd.g_old_rec.add_information14

248: => per_add_shd.g_old_rec.addr_attribute20
249: ,p_add_information13_o
250: => per_add_shd.g_old_rec.add_information13
251: ,p_add_information14_o
252: => per_add_shd.g_old_rec.add_information14
253: ,p_add_information15_o
254: => per_add_shd.g_old_rec.add_information15
255: ,p_add_information16_o
256: => per_add_shd.g_old_rec.add_information16

Line 254: => per_add_shd.g_old_rec.add_information15

250: => per_add_shd.g_old_rec.add_information13
251: ,p_add_information14_o
252: => per_add_shd.g_old_rec.add_information14
253: ,p_add_information15_o
254: => per_add_shd.g_old_rec.add_information15
255: ,p_add_information16_o
256: => per_add_shd.g_old_rec.add_information16
257: ,p_add_information17_o
258: => per_add_shd.g_old_rec.add_information17

Line 256: => per_add_shd.g_old_rec.add_information16

252: => per_add_shd.g_old_rec.add_information14
253: ,p_add_information15_o
254: => per_add_shd.g_old_rec.add_information15
255: ,p_add_information16_o
256: => per_add_shd.g_old_rec.add_information16
257: ,p_add_information17_o
258: => per_add_shd.g_old_rec.add_information17
259: ,p_add_information18_o
260: => per_add_shd.g_old_rec.add_information18

Line 258: => per_add_shd.g_old_rec.add_information17

254: => per_add_shd.g_old_rec.add_information15
255: ,p_add_information16_o
256: => per_add_shd.g_old_rec.add_information16
257: ,p_add_information17_o
258: => per_add_shd.g_old_rec.add_information17
259: ,p_add_information18_o
260: => per_add_shd.g_old_rec.add_information18
261: ,p_add_information19_o
262: => per_add_shd.g_old_rec.add_information19

Line 260: => per_add_shd.g_old_rec.add_information18

256: => per_add_shd.g_old_rec.add_information16
257: ,p_add_information17_o
258: => per_add_shd.g_old_rec.add_information17
259: ,p_add_information18_o
260: => per_add_shd.g_old_rec.add_information18
261: ,p_add_information19_o
262: => per_add_shd.g_old_rec.add_information19
263: ,p_add_information20_o
264: => per_add_shd.g_old_rec.add_information20

Line 262: => per_add_shd.g_old_rec.add_information19

258: => per_add_shd.g_old_rec.add_information17
259: ,p_add_information18_o
260: => per_add_shd.g_old_rec.add_information18
261: ,p_add_information19_o
262: => per_add_shd.g_old_rec.add_information19
263: ,p_add_information20_o
264: => per_add_shd.g_old_rec.add_information20
265: ,p_object_version_number_o
266: => per_add_shd.g_old_rec.object_version_number

Line 264: => per_add_shd.g_old_rec.add_information20

260: => per_add_shd.g_old_rec.add_information18
261: ,p_add_information19_o
262: => per_add_shd.g_old_rec.add_information19
263: ,p_add_information20_o
264: => per_add_shd.g_old_rec.add_information20
265: ,p_object_version_number_o
266: => per_add_shd.g_old_rec.object_version_number
267: );
268: exception

Line 266: => per_add_shd.g_old_rec.object_version_number

262: => per_add_shd.g_old_rec.add_information19
263: ,p_add_information20_o
264: => per_add_shd.g_old_rec.add_information20
265: ,p_object_version_number_o
266: => per_add_shd.g_old_rec.object_version_number
267: );
268: exception
269: when hr_api.cannot_find_prog_unit then
270: hr_api.cannot_find_prog_unit_error

Line 285: p_rec in out nocopy per_add_shd.g_rec_type,

281: -- |---------------------------------< del >----------------------------------|
282: -- ----------------------------------------------------------------------------
283: Procedure del
284: (
285: p_rec in out nocopy per_add_shd.g_rec_type,
286: p_validate in boolean default false
287: ) is
288: --
289: l_proc varchar2(72) := g_package||'del';

Line 305: per_add_shd.lck

301: End If;
302: --
303: -- We must lock the row which we need to delete.
304: --
305: per_add_shd.lck
306: (
307: p_rec.address_id,
308: p_rec.object_version_number
309: );

Line 358: l_rec per_add_shd.g_rec_type;

354: p_object_version_number in number,
355: p_validate in boolean default false
356: ) is
357: --
358: l_rec per_add_shd.g_rec_type;
359: l_proc varchar2(72) := g_package||'del';
360: --
361: Begin
362: hr_utility.set_location('Entering:'||l_proc, 5);