APPS.HR_INT_DEL dependencies on HR_INT_SHD

Line 52: (p_rec in hr_int_shd.g_rec_type

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

Line 75: hr_int_shd.constraint_error

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

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

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

Line 168: => hr_int_shd.g_old_rec.integration_key

164: hr_int_rkd.after_delete
165: (p_integration_id
166: => p_rec.integration_id
167: ,p_integration_key_o
168: => hr_int_shd.g_old_rec.integration_key
169: ,p_party_type_o
170: => hr_int_shd.g_old_rec.party_type
171: ,p_party_name_o
172: => hr_int_shd.g_old_rec.party_name

Line 170: => hr_int_shd.g_old_rec.party_type

166: => p_rec.integration_id
167: ,p_integration_key_o
168: => hr_int_shd.g_old_rec.integration_key
169: ,p_party_type_o
170: => hr_int_shd.g_old_rec.party_type
171: ,p_party_name_o
172: => hr_int_shd.g_old_rec.party_name
173: ,p_party_site_name_o
174: => hr_int_shd.g_old_rec.party_site_name

Line 172: => hr_int_shd.g_old_rec.party_name

168: => hr_int_shd.g_old_rec.integration_key
169: ,p_party_type_o
170: => hr_int_shd.g_old_rec.party_type
171: ,p_party_name_o
172: => hr_int_shd.g_old_rec.party_name
173: ,p_party_site_name_o
174: => hr_int_shd.g_old_rec.party_site_name
175: ,p_transaction_type_o
176: => hr_int_shd.g_old_rec.transaction_type

Line 174: => hr_int_shd.g_old_rec.party_site_name

170: => hr_int_shd.g_old_rec.party_type
171: ,p_party_name_o
172: => hr_int_shd.g_old_rec.party_name
173: ,p_party_site_name_o
174: => hr_int_shd.g_old_rec.party_site_name
175: ,p_transaction_type_o
176: => hr_int_shd.g_old_rec.transaction_type
177: ,p_transaction_subtype_o
178: => hr_int_shd.g_old_rec.transaction_subtype

Line 176: => hr_int_shd.g_old_rec.transaction_type

172: => hr_int_shd.g_old_rec.party_name
173: ,p_party_site_name_o
174: => hr_int_shd.g_old_rec.party_site_name
175: ,p_transaction_type_o
176: => hr_int_shd.g_old_rec.transaction_type
177: ,p_transaction_subtype_o
178: => hr_int_shd.g_old_rec.transaction_subtype
179: ,p_standard_code_o
180: => hr_int_shd.g_old_rec.standard_code

Line 178: => hr_int_shd.g_old_rec.transaction_subtype

174: => hr_int_shd.g_old_rec.party_site_name
175: ,p_transaction_type_o
176: => hr_int_shd.g_old_rec.transaction_type
177: ,p_transaction_subtype_o
178: => hr_int_shd.g_old_rec.transaction_subtype
179: ,p_standard_code_o
180: => hr_int_shd.g_old_rec.standard_code
181: ,p_ext_trans_type_o
182: => hr_int_shd.g_old_rec.ext_trans_type

Line 180: => hr_int_shd.g_old_rec.standard_code

176: => hr_int_shd.g_old_rec.transaction_type
177: ,p_transaction_subtype_o
178: => hr_int_shd.g_old_rec.transaction_subtype
179: ,p_standard_code_o
180: => hr_int_shd.g_old_rec.standard_code
181: ,p_ext_trans_type_o
182: => hr_int_shd.g_old_rec.ext_trans_type
183: ,p_ext_trans_subtype_o
184: => hr_int_shd.g_old_rec.ext_trans_subtype

Line 182: => hr_int_shd.g_old_rec.ext_trans_type

178: => hr_int_shd.g_old_rec.transaction_subtype
179: ,p_standard_code_o
180: => hr_int_shd.g_old_rec.standard_code
181: ,p_ext_trans_type_o
182: => hr_int_shd.g_old_rec.ext_trans_type
183: ,p_ext_trans_subtype_o
184: => hr_int_shd.g_old_rec.ext_trans_subtype
185: ,p_trans_direction_o
186: => hr_int_shd.g_old_rec.trans_direction

Line 184: => hr_int_shd.g_old_rec.ext_trans_subtype

180: => hr_int_shd.g_old_rec.standard_code
181: ,p_ext_trans_type_o
182: => hr_int_shd.g_old_rec.ext_trans_type
183: ,p_ext_trans_subtype_o
184: => hr_int_shd.g_old_rec.ext_trans_subtype
185: ,p_trans_direction_o
186: => hr_int_shd.g_old_rec.trans_direction
187: ,p_url_o
188: => hr_int_shd.g_old_rec.url

Line 186: => hr_int_shd.g_old_rec.trans_direction

182: => hr_int_shd.g_old_rec.ext_trans_type
183: ,p_ext_trans_subtype_o
184: => hr_int_shd.g_old_rec.ext_trans_subtype
185: ,p_trans_direction_o
186: => hr_int_shd.g_old_rec.trans_direction
187: ,p_url_o
188: => hr_int_shd.g_old_rec.url
189: ,p_synched_o
190: => hr_int_shd.g_old_rec.synched

Line 188: => hr_int_shd.g_old_rec.url

184: => hr_int_shd.g_old_rec.ext_trans_subtype
185: ,p_trans_direction_o
186: => hr_int_shd.g_old_rec.trans_direction
187: ,p_url_o
188: => hr_int_shd.g_old_rec.url
189: ,p_synched_o
190: => hr_int_shd.g_old_rec.synched
191: ,p_ext_application_id_o
192: => hr_int_shd.g_old_rec.ext_application_id

Line 190: => hr_int_shd.g_old_rec.synched

186: => hr_int_shd.g_old_rec.trans_direction
187: ,p_url_o
188: => hr_int_shd.g_old_rec.url
189: ,p_synched_o
190: => hr_int_shd.g_old_rec.synched
191: ,p_ext_application_id_o
192: => hr_int_shd.g_old_rec.ext_application_id
193: ,p_application_name_o
194: => hr_int_shd.g_old_rec.application_name

Line 192: => hr_int_shd.g_old_rec.ext_application_id

188: => hr_int_shd.g_old_rec.url
189: ,p_synched_o
190: => hr_int_shd.g_old_rec.synched
191: ,p_ext_application_id_o
192: => hr_int_shd.g_old_rec.ext_application_id
193: ,p_application_name_o
194: => hr_int_shd.g_old_rec.application_name
195: ,p_application_type_o
196: => hr_int_shd.g_old_rec.application_type

Line 194: => hr_int_shd.g_old_rec.application_name

190: => hr_int_shd.g_old_rec.synched
191: ,p_ext_application_id_o
192: => hr_int_shd.g_old_rec.ext_application_id
193: ,p_application_name_o
194: => hr_int_shd.g_old_rec.application_name
195: ,p_application_type_o
196: => hr_int_shd.g_old_rec.application_type
197: ,p_application_url_o
198: => hr_int_shd.g_old_rec.application_url

Line 196: => hr_int_shd.g_old_rec.application_type

192: => hr_int_shd.g_old_rec.ext_application_id
193: ,p_application_name_o
194: => hr_int_shd.g_old_rec.application_name
195: ,p_application_type_o
196: => hr_int_shd.g_old_rec.application_type
197: ,p_application_url_o
198: => hr_int_shd.g_old_rec.application_url
199: ,p_logout_url_o
200: => hr_int_shd.g_old_rec.logout_url

Line 198: => hr_int_shd.g_old_rec.application_url

194: => hr_int_shd.g_old_rec.application_name
195: ,p_application_type_o
196: => hr_int_shd.g_old_rec.application_type
197: ,p_application_url_o
198: => hr_int_shd.g_old_rec.application_url
199: ,p_logout_url_o
200: => hr_int_shd.g_old_rec.logout_url
201: ,p_user_field_o
202: => hr_int_shd.g_old_rec.user_field

Line 200: => hr_int_shd.g_old_rec.logout_url

196: => hr_int_shd.g_old_rec.application_type
197: ,p_application_url_o
198: => hr_int_shd.g_old_rec.application_url
199: ,p_logout_url_o
200: => hr_int_shd.g_old_rec.logout_url
201: ,p_user_field_o
202: => hr_int_shd.g_old_rec.user_field
203: ,p_password_field_o
204: => hr_int_shd.g_old_rec.password_field

Line 202: => hr_int_shd.g_old_rec.user_field

198: => hr_int_shd.g_old_rec.application_url
199: ,p_logout_url_o
200: => hr_int_shd.g_old_rec.logout_url
201: ,p_user_field_o
202: => hr_int_shd.g_old_rec.user_field
203: ,p_password_field_o
204: => hr_int_shd.g_old_rec.password_field
205: ,p_authentication_needed_o
206: => hr_int_shd.g_old_rec.authentication_needed

Line 204: => hr_int_shd.g_old_rec.password_field

200: => hr_int_shd.g_old_rec.logout_url
201: ,p_user_field_o
202: => hr_int_shd.g_old_rec.user_field
203: ,p_password_field_o
204: => hr_int_shd.g_old_rec.password_field
205: ,p_authentication_needed_o
206: => hr_int_shd.g_old_rec.authentication_needed
207: ,p_field_name1_o
208: => hr_int_shd.g_old_rec.field_name1

Line 206: => hr_int_shd.g_old_rec.authentication_needed

202: => hr_int_shd.g_old_rec.user_field
203: ,p_password_field_o
204: => hr_int_shd.g_old_rec.password_field
205: ,p_authentication_needed_o
206: => hr_int_shd.g_old_rec.authentication_needed
207: ,p_field_name1_o
208: => hr_int_shd.g_old_rec.field_name1
209: ,p_field_value1_o
210: => hr_int_shd.g_old_rec.field_value1

Line 208: => hr_int_shd.g_old_rec.field_name1

204: => hr_int_shd.g_old_rec.password_field
205: ,p_authentication_needed_o
206: => hr_int_shd.g_old_rec.authentication_needed
207: ,p_field_name1_o
208: => hr_int_shd.g_old_rec.field_name1
209: ,p_field_value1_o
210: => hr_int_shd.g_old_rec.field_value1
211: ,p_field_name2_o
212: => hr_int_shd.g_old_rec.field_name2

Line 210: => hr_int_shd.g_old_rec.field_value1

206: => hr_int_shd.g_old_rec.authentication_needed
207: ,p_field_name1_o
208: => hr_int_shd.g_old_rec.field_name1
209: ,p_field_value1_o
210: => hr_int_shd.g_old_rec.field_value1
211: ,p_field_name2_o
212: => hr_int_shd.g_old_rec.field_name2
213: ,p_field_value2_o
214: => hr_int_shd.g_old_rec.field_value2

Line 212: => hr_int_shd.g_old_rec.field_name2

208: => hr_int_shd.g_old_rec.field_name1
209: ,p_field_value1_o
210: => hr_int_shd.g_old_rec.field_value1
211: ,p_field_name2_o
212: => hr_int_shd.g_old_rec.field_name2
213: ,p_field_value2_o
214: => hr_int_shd.g_old_rec.field_value2
215: ,p_field_name3_o
216: => hr_int_shd.g_old_rec.field_name3

Line 214: => hr_int_shd.g_old_rec.field_value2

210: => hr_int_shd.g_old_rec.field_value1
211: ,p_field_name2_o
212: => hr_int_shd.g_old_rec.field_name2
213: ,p_field_value2_o
214: => hr_int_shd.g_old_rec.field_value2
215: ,p_field_name3_o
216: => hr_int_shd.g_old_rec.field_name3
217: ,p_field_value3_o
218: => hr_int_shd.g_old_rec.field_value3

Line 216: => hr_int_shd.g_old_rec.field_name3

212: => hr_int_shd.g_old_rec.field_name2
213: ,p_field_value2_o
214: => hr_int_shd.g_old_rec.field_value2
215: ,p_field_name3_o
216: => hr_int_shd.g_old_rec.field_name3
217: ,p_field_value3_o
218: => hr_int_shd.g_old_rec.field_value3
219: ,p_field_name4_o
220: => hr_int_shd.g_old_rec.field_name4

Line 218: => hr_int_shd.g_old_rec.field_value3

214: => hr_int_shd.g_old_rec.field_value2
215: ,p_field_name3_o
216: => hr_int_shd.g_old_rec.field_name3
217: ,p_field_value3_o
218: => hr_int_shd.g_old_rec.field_value3
219: ,p_field_name4_o
220: => hr_int_shd.g_old_rec.field_name4
221: ,p_field_value4_o
222: => hr_int_shd.g_old_rec.field_value4

Line 220: => hr_int_shd.g_old_rec.field_name4

216: => hr_int_shd.g_old_rec.field_name3
217: ,p_field_value3_o
218: => hr_int_shd.g_old_rec.field_value3
219: ,p_field_name4_o
220: => hr_int_shd.g_old_rec.field_name4
221: ,p_field_value4_o
222: => hr_int_shd.g_old_rec.field_value4
223: ,p_field_name5_o
224: => hr_int_shd.g_old_rec.field_name5

Line 222: => hr_int_shd.g_old_rec.field_value4

218: => hr_int_shd.g_old_rec.field_value3
219: ,p_field_name4_o
220: => hr_int_shd.g_old_rec.field_name4
221: ,p_field_value4_o
222: => hr_int_shd.g_old_rec.field_value4
223: ,p_field_name5_o
224: => hr_int_shd.g_old_rec.field_name5
225: ,p_field_value5_o
226: => hr_int_shd.g_old_rec.field_value5

Line 224: => hr_int_shd.g_old_rec.field_name5

220: => hr_int_shd.g_old_rec.field_name4
221: ,p_field_value4_o
222: => hr_int_shd.g_old_rec.field_value4
223: ,p_field_name5_o
224: => hr_int_shd.g_old_rec.field_name5
225: ,p_field_value5_o
226: => hr_int_shd.g_old_rec.field_value5
227: ,p_field_name6_o
228: => hr_int_shd.g_old_rec.field_name6

Line 226: => hr_int_shd.g_old_rec.field_value5

222: => hr_int_shd.g_old_rec.field_value4
223: ,p_field_name5_o
224: => hr_int_shd.g_old_rec.field_name5
225: ,p_field_value5_o
226: => hr_int_shd.g_old_rec.field_value5
227: ,p_field_name6_o
228: => hr_int_shd.g_old_rec.field_name6
229: ,p_field_value6_o
230: => hr_int_shd.g_old_rec.field_value6

Line 228: => hr_int_shd.g_old_rec.field_name6

224: => hr_int_shd.g_old_rec.field_name5
225: ,p_field_value5_o
226: => hr_int_shd.g_old_rec.field_value5
227: ,p_field_name6_o
228: => hr_int_shd.g_old_rec.field_name6
229: ,p_field_value6_o
230: => hr_int_shd.g_old_rec.field_value6
231: ,p_field_name7_o
232: => hr_int_shd.g_old_rec.field_name7

Line 230: => hr_int_shd.g_old_rec.field_value6

226: => hr_int_shd.g_old_rec.field_value5
227: ,p_field_name6_o
228: => hr_int_shd.g_old_rec.field_name6
229: ,p_field_value6_o
230: => hr_int_shd.g_old_rec.field_value6
231: ,p_field_name7_o
232: => hr_int_shd.g_old_rec.field_name7
233: ,p_field_value7_o
234: => hr_int_shd.g_old_rec.field_value7

Line 232: => hr_int_shd.g_old_rec.field_name7

228: => hr_int_shd.g_old_rec.field_name6
229: ,p_field_value6_o
230: => hr_int_shd.g_old_rec.field_value6
231: ,p_field_name7_o
232: => hr_int_shd.g_old_rec.field_name7
233: ,p_field_value7_o
234: => hr_int_shd.g_old_rec.field_value7
235: ,p_field_name8_o
236: => hr_int_shd.g_old_rec.field_name8

Line 234: => hr_int_shd.g_old_rec.field_value7

230: => hr_int_shd.g_old_rec.field_value6
231: ,p_field_name7_o
232: => hr_int_shd.g_old_rec.field_name7
233: ,p_field_value7_o
234: => hr_int_shd.g_old_rec.field_value7
235: ,p_field_name8_o
236: => hr_int_shd.g_old_rec.field_name8
237: ,p_field_value8_o
238: => hr_int_shd.g_old_rec.field_value8

Line 236: => hr_int_shd.g_old_rec.field_name8

232: => hr_int_shd.g_old_rec.field_name7
233: ,p_field_value7_o
234: => hr_int_shd.g_old_rec.field_value7
235: ,p_field_name8_o
236: => hr_int_shd.g_old_rec.field_name8
237: ,p_field_value8_o
238: => hr_int_shd.g_old_rec.field_value8
239: ,p_field_name9_o
240: => hr_int_shd.g_old_rec.field_name9

Line 238: => hr_int_shd.g_old_rec.field_value8

234: => hr_int_shd.g_old_rec.field_value7
235: ,p_field_name8_o
236: => hr_int_shd.g_old_rec.field_name8
237: ,p_field_value8_o
238: => hr_int_shd.g_old_rec.field_value8
239: ,p_field_name9_o
240: => hr_int_shd.g_old_rec.field_name9
241: ,p_field_value9_o
242: => hr_int_shd.g_old_rec.field_value9

Line 240: => hr_int_shd.g_old_rec.field_name9

236: => hr_int_shd.g_old_rec.field_name8
237: ,p_field_value8_o
238: => hr_int_shd.g_old_rec.field_value8
239: ,p_field_name9_o
240: => hr_int_shd.g_old_rec.field_name9
241: ,p_field_value9_o
242: => hr_int_shd.g_old_rec.field_value9
243: ,p_object_version_number_o
244: => hr_int_shd.g_old_rec.object_version_number

Line 242: => hr_int_shd.g_old_rec.field_value9

238: => hr_int_shd.g_old_rec.field_value8
239: ,p_field_name9_o
240: => hr_int_shd.g_old_rec.field_name9
241: ,p_field_value9_o
242: => hr_int_shd.g_old_rec.field_value9
243: ,p_object_version_number_o
244: => hr_int_shd.g_old_rec.object_version_number
245: );
246: --

Line 244: => hr_int_shd.g_old_rec.object_version_number

240: => hr_int_shd.g_old_rec.field_name9
241: ,p_field_value9_o
242: => hr_int_shd.g_old_rec.field_value9
243: ,p_object_version_number_o
244: => hr_int_shd.g_old_rec.object_version_number
245: );
246: --
247: exception
248: --

Line 264: (p_rec in hr_int_shd.g_rec_type

260: -- ----------------------------------------------------------------------------
261: -- |---------------------------------< del >----------------------------------|
262: -- ----------------------------------------------------------------------------
263: Procedure del
264: (p_rec in hr_int_shd.g_rec_type
265: ) is
266: --
267: l_proc varchar2(72) := g_package||'del';
268: --

Line 274: hr_int_shd.lck

270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: -- We must lock the row which we need to delete.
273: --
274: hr_int_shd.lck
275: (p_rec.integration_id
276: ,p_rec.object_version_number
277: );
278: --

Line 311: l_rec hr_int_shd.g_rec_type;

307: (p_integration_id in number
308: ,p_object_version_number in number
309: ) is
310: --
311: l_rec hr_int_shd.g_rec_type;
312: l_proc varchar2(72) := g_package||'del';
313: --
314: Begin
315: hr_utility.set_location('Entering:'||l_proc, 5);