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.PER_CTR_DEL dependencies on PER_CTR_SHD

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

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

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

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

Line 73: per_ctr_shd.constraint_error

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

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

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

Line 166: => per_ctr_shd.g_old_rec.business_group_id

162: begin
163: per_ctr_rkd.after_delete
164: (p_contact_relationship_id => p_rec.contact_relationship_id
165: ,p_business_group_id_o
166: => per_ctr_shd.g_old_rec.business_group_id
167: ,p_person_id_o
168: => per_ctr_shd.g_old_rec.person_id
169: ,p_contact_person_id_o
170: => per_ctr_shd.g_old_rec.contact_person_id

Line 168: => per_ctr_shd.g_old_rec.person_id

164: (p_contact_relationship_id => p_rec.contact_relationship_id
165: ,p_business_group_id_o
166: => per_ctr_shd.g_old_rec.business_group_id
167: ,p_person_id_o
168: => per_ctr_shd.g_old_rec.person_id
169: ,p_contact_person_id_o
170: => per_ctr_shd.g_old_rec.contact_person_id
171: ,p_contact_type_o
172: => per_ctr_shd.g_old_rec.contact_type

Line 170: => per_ctr_shd.g_old_rec.contact_person_id

166: => per_ctr_shd.g_old_rec.business_group_id
167: ,p_person_id_o
168: => per_ctr_shd.g_old_rec.person_id
169: ,p_contact_person_id_o
170: => per_ctr_shd.g_old_rec.contact_person_id
171: ,p_contact_type_o
172: => per_ctr_shd.g_old_rec.contact_type
173: ,p_comments_o
174: => per_ctr_shd.g_old_rec.comments

Line 172: => per_ctr_shd.g_old_rec.contact_type

168: => per_ctr_shd.g_old_rec.person_id
169: ,p_contact_person_id_o
170: => per_ctr_shd.g_old_rec.contact_person_id
171: ,p_contact_type_o
172: => per_ctr_shd.g_old_rec.contact_type
173: ,p_comments_o
174: => per_ctr_shd.g_old_rec.comments
175: ,p_primary_contact_flag_o
176: => per_ctr_shd.g_old_rec.primary_contact_flag

Line 174: => per_ctr_shd.g_old_rec.comments

170: => per_ctr_shd.g_old_rec.contact_person_id
171: ,p_contact_type_o
172: => per_ctr_shd.g_old_rec.contact_type
173: ,p_comments_o
174: => per_ctr_shd.g_old_rec.comments
175: ,p_primary_contact_flag_o
176: => per_ctr_shd.g_old_rec.primary_contact_flag
177: ,p_request_id_o
178: => per_ctr_shd.g_old_rec.request_id

Line 176: => per_ctr_shd.g_old_rec.primary_contact_flag

172: => per_ctr_shd.g_old_rec.contact_type
173: ,p_comments_o
174: => per_ctr_shd.g_old_rec.comments
175: ,p_primary_contact_flag_o
176: => per_ctr_shd.g_old_rec.primary_contact_flag
177: ,p_request_id_o
178: => per_ctr_shd.g_old_rec.request_id
179: ,p_program_application_id_o
180: => per_ctr_shd.g_old_rec.program_application_id

Line 178: => per_ctr_shd.g_old_rec.request_id

174: => per_ctr_shd.g_old_rec.comments
175: ,p_primary_contact_flag_o
176: => per_ctr_shd.g_old_rec.primary_contact_flag
177: ,p_request_id_o
178: => per_ctr_shd.g_old_rec.request_id
179: ,p_program_application_id_o
180: => per_ctr_shd.g_old_rec.program_application_id
181: ,p_program_id_o
182: => per_ctr_shd.g_old_rec.program_id

Line 180: => per_ctr_shd.g_old_rec.program_application_id

176: => per_ctr_shd.g_old_rec.primary_contact_flag
177: ,p_request_id_o
178: => per_ctr_shd.g_old_rec.request_id
179: ,p_program_application_id_o
180: => per_ctr_shd.g_old_rec.program_application_id
181: ,p_program_id_o
182: => per_ctr_shd.g_old_rec.program_id
183: ,p_program_update_date_o
184: => per_ctr_shd.g_old_rec.program_update_date

Line 182: => per_ctr_shd.g_old_rec.program_id

178: => per_ctr_shd.g_old_rec.request_id
179: ,p_program_application_id_o
180: => per_ctr_shd.g_old_rec.program_application_id
181: ,p_program_id_o
182: => per_ctr_shd.g_old_rec.program_id
183: ,p_program_update_date_o
184: => per_ctr_shd.g_old_rec.program_update_date
185: ,p_date_start_o
186: => per_ctr_shd.g_old_rec.date_start

Line 184: => per_ctr_shd.g_old_rec.program_update_date

180: => per_ctr_shd.g_old_rec.program_application_id
181: ,p_program_id_o
182: => per_ctr_shd.g_old_rec.program_id
183: ,p_program_update_date_o
184: => per_ctr_shd.g_old_rec.program_update_date
185: ,p_date_start_o
186: => per_ctr_shd.g_old_rec.date_start
187: ,p_start_life_id_o
188: => per_ctr_shd.g_old_rec.start_life_reason_id

Line 186: => per_ctr_shd.g_old_rec.date_start

182: => per_ctr_shd.g_old_rec.program_id
183: ,p_program_update_date_o
184: => per_ctr_shd.g_old_rec.program_update_date
185: ,p_date_start_o
186: => per_ctr_shd.g_old_rec.date_start
187: ,p_start_life_id_o
188: => per_ctr_shd.g_old_rec.start_life_reason_id
189: ,p_date_end_o
190: => per_ctr_shd.g_old_rec.date_end

Line 188: => per_ctr_shd.g_old_rec.start_life_reason_id

184: => per_ctr_shd.g_old_rec.program_update_date
185: ,p_date_start_o
186: => per_ctr_shd.g_old_rec.date_start
187: ,p_start_life_id_o
188: => per_ctr_shd.g_old_rec.start_life_reason_id
189: ,p_date_end_o
190: => per_ctr_shd.g_old_rec.date_end
191: ,p_end_life_id_o
192: => per_ctr_shd.g_old_rec.end_life_reason_id

Line 190: => per_ctr_shd.g_old_rec.date_end

186: => per_ctr_shd.g_old_rec.date_start
187: ,p_start_life_id_o
188: => per_ctr_shd.g_old_rec.start_life_reason_id
189: ,p_date_end_o
190: => per_ctr_shd.g_old_rec.date_end
191: ,p_end_life_id_o
192: => per_ctr_shd.g_old_rec.end_life_reason_id
193: ,p_rltd_per_dsgntr_flag_o
194: => per_ctr_shd.g_old_rec.rltd_per_rsds_w_dsgntr_flag

Line 192: => per_ctr_shd.g_old_rec.end_life_reason_id

188: => per_ctr_shd.g_old_rec.start_life_reason_id
189: ,p_date_end_o
190: => per_ctr_shd.g_old_rec.date_end
191: ,p_end_life_id_o
192: => per_ctr_shd.g_old_rec.end_life_reason_id
193: ,p_rltd_per_dsgntr_flag_o
194: => per_ctr_shd.g_old_rec.rltd_per_rsds_w_dsgntr_flag
195: ,p_personal_flag_o
196: => per_ctr_shd.g_old_rec.personal_flag

Line 194: => per_ctr_shd.g_old_rec.rltd_per_rsds_w_dsgntr_flag

190: => per_ctr_shd.g_old_rec.date_end
191: ,p_end_life_id_o
192: => per_ctr_shd.g_old_rec.end_life_reason_id
193: ,p_rltd_per_dsgntr_flag_o
194: => per_ctr_shd.g_old_rec.rltd_per_rsds_w_dsgntr_flag
195: ,p_personal_flag_o
196: => per_ctr_shd.g_old_rec.personal_flag
197: ,p_sequence_number_o
198: => per_ctr_shd.g_old_rec.sequence_number

Line 196: => per_ctr_shd.g_old_rec.personal_flag

192: => per_ctr_shd.g_old_rec.end_life_reason_id
193: ,p_rltd_per_dsgntr_flag_o
194: => per_ctr_shd.g_old_rec.rltd_per_rsds_w_dsgntr_flag
195: ,p_personal_flag_o
196: => per_ctr_shd.g_old_rec.personal_flag
197: ,p_sequence_number_o
198: => per_ctr_shd.g_old_rec.sequence_number
199: ,p_cont_attribute_category_o
200: => per_ctr_shd.g_old_rec.cont_attribute_category

Line 198: => per_ctr_shd.g_old_rec.sequence_number

194: => per_ctr_shd.g_old_rec.rltd_per_rsds_w_dsgntr_flag
195: ,p_personal_flag_o
196: => per_ctr_shd.g_old_rec.personal_flag
197: ,p_sequence_number_o
198: => per_ctr_shd.g_old_rec.sequence_number
199: ,p_cont_attribute_category_o
200: => per_ctr_shd.g_old_rec.cont_attribute_category
201: ,p_cont_attribute1_o
202: => per_ctr_shd.g_old_rec.cont_attribute1

Line 200: => per_ctr_shd.g_old_rec.cont_attribute_category

196: => per_ctr_shd.g_old_rec.personal_flag
197: ,p_sequence_number_o
198: => per_ctr_shd.g_old_rec.sequence_number
199: ,p_cont_attribute_category_o
200: => per_ctr_shd.g_old_rec.cont_attribute_category
201: ,p_cont_attribute1_o
202: => per_ctr_shd.g_old_rec.cont_attribute1
203: ,p_cont_attribute2_o
204: => per_ctr_shd.g_old_rec.cont_attribute2

Line 202: => per_ctr_shd.g_old_rec.cont_attribute1

198: => per_ctr_shd.g_old_rec.sequence_number
199: ,p_cont_attribute_category_o
200: => per_ctr_shd.g_old_rec.cont_attribute_category
201: ,p_cont_attribute1_o
202: => per_ctr_shd.g_old_rec.cont_attribute1
203: ,p_cont_attribute2_o
204: => per_ctr_shd.g_old_rec.cont_attribute2
205: ,p_cont_attribute3_o
206: => per_ctr_shd.g_old_rec.cont_attribute3

Line 204: => per_ctr_shd.g_old_rec.cont_attribute2

200: => per_ctr_shd.g_old_rec.cont_attribute_category
201: ,p_cont_attribute1_o
202: => per_ctr_shd.g_old_rec.cont_attribute1
203: ,p_cont_attribute2_o
204: => per_ctr_shd.g_old_rec.cont_attribute2
205: ,p_cont_attribute3_o
206: => per_ctr_shd.g_old_rec.cont_attribute3
207: ,p_cont_attribute4_o
208: => per_ctr_shd.g_old_rec.cont_attribute4

Line 206: => per_ctr_shd.g_old_rec.cont_attribute3

202: => per_ctr_shd.g_old_rec.cont_attribute1
203: ,p_cont_attribute2_o
204: => per_ctr_shd.g_old_rec.cont_attribute2
205: ,p_cont_attribute3_o
206: => per_ctr_shd.g_old_rec.cont_attribute3
207: ,p_cont_attribute4_o
208: => per_ctr_shd.g_old_rec.cont_attribute4
209: ,p_cont_attribute5_o
210: => per_ctr_shd.g_old_rec.cont_attribute5

Line 208: => per_ctr_shd.g_old_rec.cont_attribute4

204: => per_ctr_shd.g_old_rec.cont_attribute2
205: ,p_cont_attribute3_o
206: => per_ctr_shd.g_old_rec.cont_attribute3
207: ,p_cont_attribute4_o
208: => per_ctr_shd.g_old_rec.cont_attribute4
209: ,p_cont_attribute5_o
210: => per_ctr_shd.g_old_rec.cont_attribute5
211: ,p_cont_attribute6_o
212: => per_ctr_shd.g_old_rec.cont_attribute6

Line 210: => per_ctr_shd.g_old_rec.cont_attribute5

206: => per_ctr_shd.g_old_rec.cont_attribute3
207: ,p_cont_attribute4_o
208: => per_ctr_shd.g_old_rec.cont_attribute4
209: ,p_cont_attribute5_o
210: => per_ctr_shd.g_old_rec.cont_attribute5
211: ,p_cont_attribute6_o
212: => per_ctr_shd.g_old_rec.cont_attribute6
213: ,p_cont_attribute7_o
214: => per_ctr_shd.g_old_rec.cont_attribute7

Line 212: => per_ctr_shd.g_old_rec.cont_attribute6

208: => per_ctr_shd.g_old_rec.cont_attribute4
209: ,p_cont_attribute5_o
210: => per_ctr_shd.g_old_rec.cont_attribute5
211: ,p_cont_attribute6_o
212: => per_ctr_shd.g_old_rec.cont_attribute6
213: ,p_cont_attribute7_o
214: => per_ctr_shd.g_old_rec.cont_attribute7
215: ,p_cont_attribute8_o
216: => per_ctr_shd.g_old_rec.cont_attribute8

Line 214: => per_ctr_shd.g_old_rec.cont_attribute7

210: => per_ctr_shd.g_old_rec.cont_attribute5
211: ,p_cont_attribute6_o
212: => per_ctr_shd.g_old_rec.cont_attribute6
213: ,p_cont_attribute7_o
214: => per_ctr_shd.g_old_rec.cont_attribute7
215: ,p_cont_attribute8_o
216: => per_ctr_shd.g_old_rec.cont_attribute8
217: ,p_cont_attribute9_o
218: => per_ctr_shd.g_old_rec.cont_attribute9

Line 216: => per_ctr_shd.g_old_rec.cont_attribute8

212: => per_ctr_shd.g_old_rec.cont_attribute6
213: ,p_cont_attribute7_o
214: => per_ctr_shd.g_old_rec.cont_attribute7
215: ,p_cont_attribute8_o
216: => per_ctr_shd.g_old_rec.cont_attribute8
217: ,p_cont_attribute9_o
218: => per_ctr_shd.g_old_rec.cont_attribute9
219: ,p_cont_attribute10_o
220: => per_ctr_shd.g_old_rec.cont_attribute10

Line 218: => per_ctr_shd.g_old_rec.cont_attribute9

214: => per_ctr_shd.g_old_rec.cont_attribute7
215: ,p_cont_attribute8_o
216: => per_ctr_shd.g_old_rec.cont_attribute8
217: ,p_cont_attribute9_o
218: => per_ctr_shd.g_old_rec.cont_attribute9
219: ,p_cont_attribute10_o
220: => per_ctr_shd.g_old_rec.cont_attribute10
221: ,p_cont_attribute11_o
222: => per_ctr_shd.g_old_rec.cont_attribute11

Line 220: => per_ctr_shd.g_old_rec.cont_attribute10

216: => per_ctr_shd.g_old_rec.cont_attribute8
217: ,p_cont_attribute9_o
218: => per_ctr_shd.g_old_rec.cont_attribute9
219: ,p_cont_attribute10_o
220: => per_ctr_shd.g_old_rec.cont_attribute10
221: ,p_cont_attribute11_o
222: => per_ctr_shd.g_old_rec.cont_attribute11
223: ,p_cont_attribute12_o
224: => per_ctr_shd.g_old_rec.cont_attribute12

Line 222: => per_ctr_shd.g_old_rec.cont_attribute11

218: => per_ctr_shd.g_old_rec.cont_attribute9
219: ,p_cont_attribute10_o
220: => per_ctr_shd.g_old_rec.cont_attribute10
221: ,p_cont_attribute11_o
222: => per_ctr_shd.g_old_rec.cont_attribute11
223: ,p_cont_attribute12_o
224: => per_ctr_shd.g_old_rec.cont_attribute12
225: ,p_cont_attribute13_o
226: => per_ctr_shd.g_old_rec.cont_attribute13

Line 224: => per_ctr_shd.g_old_rec.cont_attribute12

220: => per_ctr_shd.g_old_rec.cont_attribute10
221: ,p_cont_attribute11_o
222: => per_ctr_shd.g_old_rec.cont_attribute11
223: ,p_cont_attribute12_o
224: => per_ctr_shd.g_old_rec.cont_attribute12
225: ,p_cont_attribute13_o
226: => per_ctr_shd.g_old_rec.cont_attribute13
227: ,p_cont_attribute14_o
228: => per_ctr_shd.g_old_rec.cont_attribute14

Line 226: => per_ctr_shd.g_old_rec.cont_attribute13

222: => per_ctr_shd.g_old_rec.cont_attribute11
223: ,p_cont_attribute12_o
224: => per_ctr_shd.g_old_rec.cont_attribute12
225: ,p_cont_attribute13_o
226: => per_ctr_shd.g_old_rec.cont_attribute13
227: ,p_cont_attribute14_o
228: => per_ctr_shd.g_old_rec.cont_attribute14
229: ,p_cont_attribute15_o
230: => per_ctr_shd.g_old_rec.cont_attribute15

Line 228: => per_ctr_shd.g_old_rec.cont_attribute14

224: => per_ctr_shd.g_old_rec.cont_attribute12
225: ,p_cont_attribute13_o
226: => per_ctr_shd.g_old_rec.cont_attribute13
227: ,p_cont_attribute14_o
228: => per_ctr_shd.g_old_rec.cont_attribute14
229: ,p_cont_attribute15_o
230: => per_ctr_shd.g_old_rec.cont_attribute15
231: ,p_cont_attribute16_o
232: => per_ctr_shd.g_old_rec.cont_attribute16

Line 230: => per_ctr_shd.g_old_rec.cont_attribute15

226: => per_ctr_shd.g_old_rec.cont_attribute13
227: ,p_cont_attribute14_o
228: => per_ctr_shd.g_old_rec.cont_attribute14
229: ,p_cont_attribute15_o
230: => per_ctr_shd.g_old_rec.cont_attribute15
231: ,p_cont_attribute16_o
232: => per_ctr_shd.g_old_rec.cont_attribute16
233: ,p_cont_attribute17_o
234: => per_ctr_shd.g_old_rec.cont_attribute17

Line 232: => per_ctr_shd.g_old_rec.cont_attribute16

228: => per_ctr_shd.g_old_rec.cont_attribute14
229: ,p_cont_attribute15_o
230: => per_ctr_shd.g_old_rec.cont_attribute15
231: ,p_cont_attribute16_o
232: => per_ctr_shd.g_old_rec.cont_attribute16
233: ,p_cont_attribute17_o
234: => per_ctr_shd.g_old_rec.cont_attribute17
235: ,p_cont_attribute18_o
236: => per_ctr_shd.g_old_rec.cont_attribute18

Line 234: => per_ctr_shd.g_old_rec.cont_attribute17

230: => per_ctr_shd.g_old_rec.cont_attribute15
231: ,p_cont_attribute16_o
232: => per_ctr_shd.g_old_rec.cont_attribute16
233: ,p_cont_attribute17_o
234: => per_ctr_shd.g_old_rec.cont_attribute17
235: ,p_cont_attribute18_o
236: => per_ctr_shd.g_old_rec.cont_attribute18
237: ,p_cont_attribute19_o
238: => per_ctr_shd.g_old_rec.cont_attribute19

Line 236: => per_ctr_shd.g_old_rec.cont_attribute18

232: => per_ctr_shd.g_old_rec.cont_attribute16
233: ,p_cont_attribute17_o
234: => per_ctr_shd.g_old_rec.cont_attribute17
235: ,p_cont_attribute18_o
236: => per_ctr_shd.g_old_rec.cont_attribute18
237: ,p_cont_attribute19_o
238: => per_ctr_shd.g_old_rec.cont_attribute19
239: ,p_cont_attribute20_o
240: => per_ctr_shd.g_old_rec.cont_attribute20

Line 238: => per_ctr_shd.g_old_rec.cont_attribute19

234: => per_ctr_shd.g_old_rec.cont_attribute17
235: ,p_cont_attribute18_o
236: => per_ctr_shd.g_old_rec.cont_attribute18
237: ,p_cont_attribute19_o
238: => per_ctr_shd.g_old_rec.cont_attribute19
239: ,p_cont_attribute20_o
240: => per_ctr_shd.g_old_rec.cont_attribute20
241: ,p_cont_information_category_o
242: => per_ctr_shd.g_old_rec.cont_information_category

Line 240: => per_ctr_shd.g_old_rec.cont_attribute20

236: => per_ctr_shd.g_old_rec.cont_attribute18
237: ,p_cont_attribute19_o
238: => per_ctr_shd.g_old_rec.cont_attribute19
239: ,p_cont_attribute20_o
240: => per_ctr_shd.g_old_rec.cont_attribute20
241: ,p_cont_information_category_o
242: => per_ctr_shd.g_old_rec.cont_information_category
243: ,p_cont_information1_o
244: => per_ctr_shd.g_old_rec.cont_information1

Line 242: => per_ctr_shd.g_old_rec.cont_information_category

238: => per_ctr_shd.g_old_rec.cont_attribute19
239: ,p_cont_attribute20_o
240: => per_ctr_shd.g_old_rec.cont_attribute20
241: ,p_cont_information_category_o
242: => per_ctr_shd.g_old_rec.cont_information_category
243: ,p_cont_information1_o
244: => per_ctr_shd.g_old_rec.cont_information1
245: ,p_cont_information2_o
246: => per_ctr_shd.g_old_rec.cont_information2

Line 244: => per_ctr_shd.g_old_rec.cont_information1

240: => per_ctr_shd.g_old_rec.cont_attribute20
241: ,p_cont_information_category_o
242: => per_ctr_shd.g_old_rec.cont_information_category
243: ,p_cont_information1_o
244: => per_ctr_shd.g_old_rec.cont_information1
245: ,p_cont_information2_o
246: => per_ctr_shd.g_old_rec.cont_information2
247: ,p_cont_information3_o
248: => per_ctr_shd.g_old_rec.cont_information3

Line 246: => per_ctr_shd.g_old_rec.cont_information2

242: => per_ctr_shd.g_old_rec.cont_information_category
243: ,p_cont_information1_o
244: => per_ctr_shd.g_old_rec.cont_information1
245: ,p_cont_information2_o
246: => per_ctr_shd.g_old_rec.cont_information2
247: ,p_cont_information3_o
248: => per_ctr_shd.g_old_rec.cont_information3
249: ,p_cont_information4_o
250: => per_ctr_shd.g_old_rec.cont_information4

Line 248: => per_ctr_shd.g_old_rec.cont_information3

244: => per_ctr_shd.g_old_rec.cont_information1
245: ,p_cont_information2_o
246: => per_ctr_shd.g_old_rec.cont_information2
247: ,p_cont_information3_o
248: => per_ctr_shd.g_old_rec.cont_information3
249: ,p_cont_information4_o
250: => per_ctr_shd.g_old_rec.cont_information4
251: ,p_cont_information5_o
252: => per_ctr_shd.g_old_rec.cont_information5

Line 250: => per_ctr_shd.g_old_rec.cont_information4

246: => per_ctr_shd.g_old_rec.cont_information2
247: ,p_cont_information3_o
248: => per_ctr_shd.g_old_rec.cont_information3
249: ,p_cont_information4_o
250: => per_ctr_shd.g_old_rec.cont_information4
251: ,p_cont_information5_o
252: => per_ctr_shd.g_old_rec.cont_information5
253: ,p_cont_information6_o
254: => per_ctr_shd.g_old_rec.cont_information6

Line 252: => per_ctr_shd.g_old_rec.cont_information5

248: => per_ctr_shd.g_old_rec.cont_information3
249: ,p_cont_information4_o
250: => per_ctr_shd.g_old_rec.cont_information4
251: ,p_cont_information5_o
252: => per_ctr_shd.g_old_rec.cont_information5
253: ,p_cont_information6_o
254: => per_ctr_shd.g_old_rec.cont_information6
255: ,p_cont_information7_o
256: => per_ctr_shd.g_old_rec.cont_information7

Line 254: => per_ctr_shd.g_old_rec.cont_information6

250: => per_ctr_shd.g_old_rec.cont_information4
251: ,p_cont_information5_o
252: => per_ctr_shd.g_old_rec.cont_information5
253: ,p_cont_information6_o
254: => per_ctr_shd.g_old_rec.cont_information6
255: ,p_cont_information7_o
256: => per_ctr_shd.g_old_rec.cont_information7
257: ,p_cont_information8_o
258: => per_ctr_shd.g_old_rec.cont_information8

Line 256: => per_ctr_shd.g_old_rec.cont_information7

252: => per_ctr_shd.g_old_rec.cont_information5
253: ,p_cont_information6_o
254: => per_ctr_shd.g_old_rec.cont_information6
255: ,p_cont_information7_o
256: => per_ctr_shd.g_old_rec.cont_information7
257: ,p_cont_information8_o
258: => per_ctr_shd.g_old_rec.cont_information8
259: ,p_cont_information9_o
260: => per_ctr_shd.g_old_rec.cont_information9

Line 258: => per_ctr_shd.g_old_rec.cont_information8

254: => per_ctr_shd.g_old_rec.cont_information6
255: ,p_cont_information7_o
256: => per_ctr_shd.g_old_rec.cont_information7
257: ,p_cont_information8_o
258: => per_ctr_shd.g_old_rec.cont_information8
259: ,p_cont_information9_o
260: => per_ctr_shd.g_old_rec.cont_information9
261: ,p_cont_information10_o
262: => per_ctr_shd.g_old_rec.cont_information10

Line 260: => per_ctr_shd.g_old_rec.cont_information9

256: => per_ctr_shd.g_old_rec.cont_information7
257: ,p_cont_information8_o
258: => per_ctr_shd.g_old_rec.cont_information8
259: ,p_cont_information9_o
260: => per_ctr_shd.g_old_rec.cont_information9
261: ,p_cont_information10_o
262: => per_ctr_shd.g_old_rec.cont_information10
263: ,p_cont_information11_o
264: => per_ctr_shd.g_old_rec.cont_information11

Line 262: => per_ctr_shd.g_old_rec.cont_information10

258: => per_ctr_shd.g_old_rec.cont_information8
259: ,p_cont_information9_o
260: => per_ctr_shd.g_old_rec.cont_information9
261: ,p_cont_information10_o
262: => per_ctr_shd.g_old_rec.cont_information10
263: ,p_cont_information11_o
264: => per_ctr_shd.g_old_rec.cont_information11
265: ,p_cont_information12_o
266: => per_ctr_shd.g_old_rec.cont_information12

Line 264: => per_ctr_shd.g_old_rec.cont_information11

260: => per_ctr_shd.g_old_rec.cont_information9
261: ,p_cont_information10_o
262: => per_ctr_shd.g_old_rec.cont_information10
263: ,p_cont_information11_o
264: => per_ctr_shd.g_old_rec.cont_information11
265: ,p_cont_information12_o
266: => per_ctr_shd.g_old_rec.cont_information12
267: ,p_cont_information13_o
268: => per_ctr_shd.g_old_rec.cont_information13

Line 266: => per_ctr_shd.g_old_rec.cont_information12

262: => per_ctr_shd.g_old_rec.cont_information10
263: ,p_cont_information11_o
264: => per_ctr_shd.g_old_rec.cont_information11
265: ,p_cont_information12_o
266: => per_ctr_shd.g_old_rec.cont_information12
267: ,p_cont_information13_o
268: => per_ctr_shd.g_old_rec.cont_information13
269: ,p_cont_information14_o
270: => per_ctr_shd.g_old_rec.cont_information14

Line 268: => per_ctr_shd.g_old_rec.cont_information13

264: => per_ctr_shd.g_old_rec.cont_information11
265: ,p_cont_information12_o
266: => per_ctr_shd.g_old_rec.cont_information12
267: ,p_cont_information13_o
268: => per_ctr_shd.g_old_rec.cont_information13
269: ,p_cont_information14_o
270: => per_ctr_shd.g_old_rec.cont_information14
271: ,p_cont_information15_o
272: => per_ctr_shd.g_old_rec.cont_information15

Line 270: => per_ctr_shd.g_old_rec.cont_information14

266: => per_ctr_shd.g_old_rec.cont_information12
267: ,p_cont_information13_o
268: => per_ctr_shd.g_old_rec.cont_information13
269: ,p_cont_information14_o
270: => per_ctr_shd.g_old_rec.cont_information14
271: ,p_cont_information15_o
272: => per_ctr_shd.g_old_rec.cont_information15
273: ,p_cont_information16_o
274: => per_ctr_shd.g_old_rec.cont_information16

Line 272: => per_ctr_shd.g_old_rec.cont_information15

268: => per_ctr_shd.g_old_rec.cont_information13
269: ,p_cont_information14_o
270: => per_ctr_shd.g_old_rec.cont_information14
271: ,p_cont_information15_o
272: => per_ctr_shd.g_old_rec.cont_information15
273: ,p_cont_information16_o
274: => per_ctr_shd.g_old_rec.cont_information16
275: ,p_cont_information17_o
276: => per_ctr_shd.g_old_rec.cont_information17

Line 274: => per_ctr_shd.g_old_rec.cont_information16

270: => per_ctr_shd.g_old_rec.cont_information14
271: ,p_cont_information15_o
272: => per_ctr_shd.g_old_rec.cont_information15
273: ,p_cont_information16_o
274: => per_ctr_shd.g_old_rec.cont_information16
275: ,p_cont_information17_o
276: => per_ctr_shd.g_old_rec.cont_information17
277: ,p_cont_information18_o
278: => per_ctr_shd.g_old_rec.cont_information18

Line 276: => per_ctr_shd.g_old_rec.cont_information17

272: => per_ctr_shd.g_old_rec.cont_information15
273: ,p_cont_information16_o
274: => per_ctr_shd.g_old_rec.cont_information16
275: ,p_cont_information17_o
276: => per_ctr_shd.g_old_rec.cont_information17
277: ,p_cont_information18_o
278: => per_ctr_shd.g_old_rec.cont_information18
279: ,p_cont_information19_o
280: => per_ctr_shd.g_old_rec.cont_information19

Line 278: => per_ctr_shd.g_old_rec.cont_information18

274: => per_ctr_shd.g_old_rec.cont_information16
275: ,p_cont_information17_o
276: => per_ctr_shd.g_old_rec.cont_information17
277: ,p_cont_information18_o
278: => per_ctr_shd.g_old_rec.cont_information18
279: ,p_cont_information19_o
280: => per_ctr_shd.g_old_rec.cont_information19
281: ,p_cont_information20_o
282: => per_ctr_shd.g_old_rec.cont_information20

Line 280: => per_ctr_shd.g_old_rec.cont_information19

276: => per_ctr_shd.g_old_rec.cont_information17
277: ,p_cont_information18_o
278: => per_ctr_shd.g_old_rec.cont_information18
279: ,p_cont_information19_o
280: => per_ctr_shd.g_old_rec.cont_information19
281: ,p_cont_information20_o
282: => per_ctr_shd.g_old_rec.cont_information20
283: ,p_third_party_pay_flag_o
284: => per_ctr_shd.g_old_rec.third_party_pay_flag

Line 282: => per_ctr_shd.g_old_rec.cont_information20

278: => per_ctr_shd.g_old_rec.cont_information18
279: ,p_cont_information19_o
280: => per_ctr_shd.g_old_rec.cont_information19
281: ,p_cont_information20_o
282: => per_ctr_shd.g_old_rec.cont_information20
283: ,p_third_party_pay_flag_o
284: => per_ctr_shd.g_old_rec.third_party_pay_flag
285: ,p_bondholder_flag_o
286: => per_ctr_shd.g_old_rec.bondholder_flag

Line 284: => per_ctr_shd.g_old_rec.third_party_pay_flag

280: => per_ctr_shd.g_old_rec.cont_information19
281: ,p_cont_information20_o
282: => per_ctr_shd.g_old_rec.cont_information20
283: ,p_third_party_pay_flag_o
284: => per_ctr_shd.g_old_rec.third_party_pay_flag
285: ,p_bondholder_flag_o
286: => per_ctr_shd.g_old_rec.bondholder_flag
287: ,p_dependent_flag_o
288: => per_ctr_shd.g_old_rec.dependent_flag

Line 286: => per_ctr_shd.g_old_rec.bondholder_flag

282: => per_ctr_shd.g_old_rec.cont_information20
283: ,p_third_party_pay_flag_o
284: => per_ctr_shd.g_old_rec.third_party_pay_flag
285: ,p_bondholder_flag_o
286: => per_ctr_shd.g_old_rec.bondholder_flag
287: ,p_dependent_flag_o
288: => per_ctr_shd.g_old_rec.dependent_flag
289: ,p_beneficiary_flag_o
290: => per_ctr_shd.g_old_rec.beneficiary_flag

Line 288: => per_ctr_shd.g_old_rec.dependent_flag

284: => per_ctr_shd.g_old_rec.third_party_pay_flag
285: ,p_bondholder_flag_o
286: => per_ctr_shd.g_old_rec.bondholder_flag
287: ,p_dependent_flag_o
288: => per_ctr_shd.g_old_rec.dependent_flag
289: ,p_beneficiary_flag_o
290: => per_ctr_shd.g_old_rec.beneficiary_flag
291: ,p_object_version_number_o
292: => per_ctr_shd.g_old_rec.object_version_number

Line 290: => per_ctr_shd.g_old_rec.beneficiary_flag

286: => per_ctr_shd.g_old_rec.bondholder_flag
287: ,p_dependent_flag_o
288: => per_ctr_shd.g_old_rec.dependent_flag
289: ,p_beneficiary_flag_o
290: => per_ctr_shd.g_old_rec.beneficiary_flag
291: ,p_object_version_number_o
292: => per_ctr_shd.g_old_rec.object_version_number
293: );
294: exception

Line 292: => per_ctr_shd.g_old_rec.object_version_number

288: => per_ctr_shd.g_old_rec.dependent_flag
289: ,p_beneficiary_flag_o
290: => per_ctr_shd.g_old_rec.beneficiary_flag
291: ,p_object_version_number_o
292: => per_ctr_shd.g_old_rec.object_version_number
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error

Line 311: p_rec in per_ctr_shd.g_rec_type,

307: -- |---------------------------------< del >----------------------------------|
308: -- ----------------------------------------------------------------------------
309: Procedure del
310: (
311: p_rec in per_ctr_shd.g_rec_type,
312: p_validate in boolean default false
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'del';

Line 331: per_ctr_shd.lck

327: End If;
328: --
329: -- We must lock the row which we need to delete.
330: --
331: per_ctr_shd.lck
332: (
333: p_rec.contact_relationship_id,
334: p_rec.object_version_number
335: );

Line 379: l_rec per_ctr_shd.g_rec_type;

375: p_object_version_number in number,
376: p_validate in boolean default false
377: ) is
378: --
379: l_rec per_ctr_shd.g_rec_type;
380: l_proc varchar2(72) := g_package||'del';
381: --
382: Begin
383: hr_utility.set_location('Entering:'||l_proc, 5);