DBA Data[Home] [Help]

APPS.HR_INT_UPD dependencies on HR_INT_SHD

Line 55: (p_rec in out nocopy hr_int_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy hr_int_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 121: hr_int_shd.constraint_error

117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: hr_int_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --

Line 126: hr_int_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --
126: hr_int_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --

Line 131: hr_int_shd.constraint_error

127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --
131: hr_int_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: --
135: Raise;

Line 171: (p_rec in hr_int_shd.g_rec_type

167: --
168: -- {End Of Comments}
169: -- ----------------------------------------------------------------------------
170: Procedure pre_update
171: (p_rec in hr_int_shd.g_rec_type
172: ) is
173: --
174: l_proc varchar2(72) := g_package||'pre_update';
175: --

Line 215: (p_rec in hr_int_shd.g_rec_type

211: --
212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure post_update
215: (p_rec in hr_int_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --

Line 303: => hr_int_shd.g_old_rec.integration_key

299: => p_rec.field_value9
300: ,p_object_version_number
301: => p_rec.object_version_number
302: ,p_integration_key_o
303: => hr_int_shd.g_old_rec.integration_key
304: ,p_party_type_o
305: => hr_int_shd.g_old_rec.party_type
306: ,p_party_name_o
307: => hr_int_shd.g_old_rec.party_name

Line 305: => hr_int_shd.g_old_rec.party_type

301: => p_rec.object_version_number
302: ,p_integration_key_o
303: => hr_int_shd.g_old_rec.integration_key
304: ,p_party_type_o
305: => hr_int_shd.g_old_rec.party_type
306: ,p_party_name_o
307: => hr_int_shd.g_old_rec.party_name
308: ,p_party_site_name_o
309: => hr_int_shd.g_old_rec.party_site_name

Line 307: => hr_int_shd.g_old_rec.party_name

303: => hr_int_shd.g_old_rec.integration_key
304: ,p_party_type_o
305: => hr_int_shd.g_old_rec.party_type
306: ,p_party_name_o
307: => hr_int_shd.g_old_rec.party_name
308: ,p_party_site_name_o
309: => hr_int_shd.g_old_rec.party_site_name
310: ,p_transaction_type_o
311: => hr_int_shd.g_old_rec.transaction_type

Line 309: => hr_int_shd.g_old_rec.party_site_name

305: => hr_int_shd.g_old_rec.party_type
306: ,p_party_name_o
307: => hr_int_shd.g_old_rec.party_name
308: ,p_party_site_name_o
309: => hr_int_shd.g_old_rec.party_site_name
310: ,p_transaction_type_o
311: => hr_int_shd.g_old_rec.transaction_type
312: ,p_transaction_subtype_o
313: => hr_int_shd.g_old_rec.transaction_subtype

Line 311: => hr_int_shd.g_old_rec.transaction_type

307: => hr_int_shd.g_old_rec.party_name
308: ,p_party_site_name_o
309: => hr_int_shd.g_old_rec.party_site_name
310: ,p_transaction_type_o
311: => hr_int_shd.g_old_rec.transaction_type
312: ,p_transaction_subtype_o
313: => hr_int_shd.g_old_rec.transaction_subtype
314: ,p_standard_code_o
315: => hr_int_shd.g_old_rec.standard_code

Line 313: => hr_int_shd.g_old_rec.transaction_subtype

309: => hr_int_shd.g_old_rec.party_site_name
310: ,p_transaction_type_o
311: => hr_int_shd.g_old_rec.transaction_type
312: ,p_transaction_subtype_o
313: => hr_int_shd.g_old_rec.transaction_subtype
314: ,p_standard_code_o
315: => hr_int_shd.g_old_rec.standard_code
316: ,p_ext_trans_type_o
317: => hr_int_shd.g_old_rec.ext_trans_type

Line 315: => hr_int_shd.g_old_rec.standard_code

311: => hr_int_shd.g_old_rec.transaction_type
312: ,p_transaction_subtype_o
313: => hr_int_shd.g_old_rec.transaction_subtype
314: ,p_standard_code_o
315: => hr_int_shd.g_old_rec.standard_code
316: ,p_ext_trans_type_o
317: => hr_int_shd.g_old_rec.ext_trans_type
318: ,p_ext_trans_subtype_o
319: => hr_int_shd.g_old_rec.ext_trans_subtype

Line 317: => hr_int_shd.g_old_rec.ext_trans_type

313: => hr_int_shd.g_old_rec.transaction_subtype
314: ,p_standard_code_o
315: => hr_int_shd.g_old_rec.standard_code
316: ,p_ext_trans_type_o
317: => hr_int_shd.g_old_rec.ext_trans_type
318: ,p_ext_trans_subtype_o
319: => hr_int_shd.g_old_rec.ext_trans_subtype
320: ,p_trans_direction_o
321: => hr_int_shd.g_old_rec.trans_direction

Line 319: => hr_int_shd.g_old_rec.ext_trans_subtype

315: => hr_int_shd.g_old_rec.standard_code
316: ,p_ext_trans_type_o
317: => hr_int_shd.g_old_rec.ext_trans_type
318: ,p_ext_trans_subtype_o
319: => hr_int_shd.g_old_rec.ext_trans_subtype
320: ,p_trans_direction_o
321: => hr_int_shd.g_old_rec.trans_direction
322: ,p_url_o
323: => hr_int_shd.g_old_rec.url

Line 321: => hr_int_shd.g_old_rec.trans_direction

317: => hr_int_shd.g_old_rec.ext_trans_type
318: ,p_ext_trans_subtype_o
319: => hr_int_shd.g_old_rec.ext_trans_subtype
320: ,p_trans_direction_o
321: => hr_int_shd.g_old_rec.trans_direction
322: ,p_url_o
323: => hr_int_shd.g_old_rec.url
324: ,p_synched_o
325: => hr_int_shd.g_old_rec.synched

Line 323: => hr_int_shd.g_old_rec.url

319: => hr_int_shd.g_old_rec.ext_trans_subtype
320: ,p_trans_direction_o
321: => hr_int_shd.g_old_rec.trans_direction
322: ,p_url_o
323: => hr_int_shd.g_old_rec.url
324: ,p_synched_o
325: => hr_int_shd.g_old_rec.synched
326: ,p_ext_application_id_o
327: => hr_int_shd.g_old_rec.ext_application_id

Line 325: => hr_int_shd.g_old_rec.synched

321: => hr_int_shd.g_old_rec.trans_direction
322: ,p_url_o
323: => hr_int_shd.g_old_rec.url
324: ,p_synched_o
325: => hr_int_shd.g_old_rec.synched
326: ,p_ext_application_id_o
327: => hr_int_shd.g_old_rec.ext_application_id
328: ,p_application_name_o
329: => hr_int_shd.g_old_rec.application_name

Line 327: => hr_int_shd.g_old_rec.ext_application_id

323: => hr_int_shd.g_old_rec.url
324: ,p_synched_o
325: => hr_int_shd.g_old_rec.synched
326: ,p_ext_application_id_o
327: => hr_int_shd.g_old_rec.ext_application_id
328: ,p_application_name_o
329: => hr_int_shd.g_old_rec.application_name
330: ,p_application_type_o
331: => hr_int_shd.g_old_rec.application_type

Line 329: => hr_int_shd.g_old_rec.application_name

325: => hr_int_shd.g_old_rec.synched
326: ,p_ext_application_id_o
327: => hr_int_shd.g_old_rec.ext_application_id
328: ,p_application_name_o
329: => hr_int_shd.g_old_rec.application_name
330: ,p_application_type_o
331: => hr_int_shd.g_old_rec.application_type
332: ,p_application_url_o
333: => hr_int_shd.g_old_rec.application_url

Line 331: => hr_int_shd.g_old_rec.application_type

327: => hr_int_shd.g_old_rec.ext_application_id
328: ,p_application_name_o
329: => hr_int_shd.g_old_rec.application_name
330: ,p_application_type_o
331: => hr_int_shd.g_old_rec.application_type
332: ,p_application_url_o
333: => hr_int_shd.g_old_rec.application_url
334: ,p_logout_url_o
335: => hr_int_shd.g_old_rec.logout_url

Line 333: => hr_int_shd.g_old_rec.application_url

329: => hr_int_shd.g_old_rec.application_name
330: ,p_application_type_o
331: => hr_int_shd.g_old_rec.application_type
332: ,p_application_url_o
333: => hr_int_shd.g_old_rec.application_url
334: ,p_logout_url_o
335: => hr_int_shd.g_old_rec.logout_url
336: ,p_user_field_o
337: => hr_int_shd.g_old_rec.user_field

Line 335: => hr_int_shd.g_old_rec.logout_url

331: => hr_int_shd.g_old_rec.application_type
332: ,p_application_url_o
333: => hr_int_shd.g_old_rec.application_url
334: ,p_logout_url_o
335: => hr_int_shd.g_old_rec.logout_url
336: ,p_user_field_o
337: => hr_int_shd.g_old_rec.user_field
338: ,p_password_field_o
339: => hr_int_shd.g_old_rec.password_field

Line 337: => hr_int_shd.g_old_rec.user_field

333: => hr_int_shd.g_old_rec.application_url
334: ,p_logout_url_o
335: => hr_int_shd.g_old_rec.logout_url
336: ,p_user_field_o
337: => hr_int_shd.g_old_rec.user_field
338: ,p_password_field_o
339: => hr_int_shd.g_old_rec.password_field
340: ,p_authentication_needed_o
341: => hr_int_shd.g_old_rec.authentication_needed

Line 339: => hr_int_shd.g_old_rec.password_field

335: => hr_int_shd.g_old_rec.logout_url
336: ,p_user_field_o
337: => hr_int_shd.g_old_rec.user_field
338: ,p_password_field_o
339: => hr_int_shd.g_old_rec.password_field
340: ,p_authentication_needed_o
341: => hr_int_shd.g_old_rec.authentication_needed
342: ,p_field_name1_o
343: => hr_int_shd.g_old_rec.field_name1

Line 341: => hr_int_shd.g_old_rec.authentication_needed

337: => hr_int_shd.g_old_rec.user_field
338: ,p_password_field_o
339: => hr_int_shd.g_old_rec.password_field
340: ,p_authentication_needed_o
341: => hr_int_shd.g_old_rec.authentication_needed
342: ,p_field_name1_o
343: => hr_int_shd.g_old_rec.field_name1
344: ,p_field_value1_o
345: => hr_int_shd.g_old_rec.field_value1

Line 343: => hr_int_shd.g_old_rec.field_name1

339: => hr_int_shd.g_old_rec.password_field
340: ,p_authentication_needed_o
341: => hr_int_shd.g_old_rec.authentication_needed
342: ,p_field_name1_o
343: => hr_int_shd.g_old_rec.field_name1
344: ,p_field_value1_o
345: => hr_int_shd.g_old_rec.field_value1
346: ,p_field_name2_o
347: => hr_int_shd.g_old_rec.field_name2

Line 345: => hr_int_shd.g_old_rec.field_value1

341: => hr_int_shd.g_old_rec.authentication_needed
342: ,p_field_name1_o
343: => hr_int_shd.g_old_rec.field_name1
344: ,p_field_value1_o
345: => hr_int_shd.g_old_rec.field_value1
346: ,p_field_name2_o
347: => hr_int_shd.g_old_rec.field_name2
348: ,p_field_value2_o
349: => hr_int_shd.g_old_rec.field_value2

Line 347: => hr_int_shd.g_old_rec.field_name2

343: => hr_int_shd.g_old_rec.field_name1
344: ,p_field_value1_o
345: => hr_int_shd.g_old_rec.field_value1
346: ,p_field_name2_o
347: => hr_int_shd.g_old_rec.field_name2
348: ,p_field_value2_o
349: => hr_int_shd.g_old_rec.field_value2
350: ,p_field_name3_o
351: => hr_int_shd.g_old_rec.field_name3

Line 349: => hr_int_shd.g_old_rec.field_value2

345: => hr_int_shd.g_old_rec.field_value1
346: ,p_field_name2_o
347: => hr_int_shd.g_old_rec.field_name2
348: ,p_field_value2_o
349: => hr_int_shd.g_old_rec.field_value2
350: ,p_field_name3_o
351: => hr_int_shd.g_old_rec.field_name3
352: ,p_field_value3_o
353: => hr_int_shd.g_old_rec.field_value3

Line 351: => hr_int_shd.g_old_rec.field_name3

347: => hr_int_shd.g_old_rec.field_name2
348: ,p_field_value2_o
349: => hr_int_shd.g_old_rec.field_value2
350: ,p_field_name3_o
351: => hr_int_shd.g_old_rec.field_name3
352: ,p_field_value3_o
353: => hr_int_shd.g_old_rec.field_value3
354: ,p_field_name4_o
355: => hr_int_shd.g_old_rec.field_name4

Line 353: => hr_int_shd.g_old_rec.field_value3

349: => hr_int_shd.g_old_rec.field_value2
350: ,p_field_name3_o
351: => hr_int_shd.g_old_rec.field_name3
352: ,p_field_value3_o
353: => hr_int_shd.g_old_rec.field_value3
354: ,p_field_name4_o
355: => hr_int_shd.g_old_rec.field_name4
356: ,p_field_value4_o
357: => hr_int_shd.g_old_rec.field_value4

Line 355: => hr_int_shd.g_old_rec.field_name4

351: => hr_int_shd.g_old_rec.field_name3
352: ,p_field_value3_o
353: => hr_int_shd.g_old_rec.field_value3
354: ,p_field_name4_o
355: => hr_int_shd.g_old_rec.field_name4
356: ,p_field_value4_o
357: => hr_int_shd.g_old_rec.field_value4
358: ,p_field_name5_o
359: => hr_int_shd.g_old_rec.field_name5

Line 357: => hr_int_shd.g_old_rec.field_value4

353: => hr_int_shd.g_old_rec.field_value3
354: ,p_field_name4_o
355: => hr_int_shd.g_old_rec.field_name4
356: ,p_field_value4_o
357: => hr_int_shd.g_old_rec.field_value4
358: ,p_field_name5_o
359: => hr_int_shd.g_old_rec.field_name5
360: ,p_field_value5_o
361: => hr_int_shd.g_old_rec.field_value5

Line 359: => hr_int_shd.g_old_rec.field_name5

355: => hr_int_shd.g_old_rec.field_name4
356: ,p_field_value4_o
357: => hr_int_shd.g_old_rec.field_value4
358: ,p_field_name5_o
359: => hr_int_shd.g_old_rec.field_name5
360: ,p_field_value5_o
361: => hr_int_shd.g_old_rec.field_value5
362: ,p_field_name6_o
363: => hr_int_shd.g_old_rec.field_name6

Line 361: => hr_int_shd.g_old_rec.field_value5

357: => hr_int_shd.g_old_rec.field_value4
358: ,p_field_name5_o
359: => hr_int_shd.g_old_rec.field_name5
360: ,p_field_value5_o
361: => hr_int_shd.g_old_rec.field_value5
362: ,p_field_name6_o
363: => hr_int_shd.g_old_rec.field_name6
364: ,p_field_value6_o
365: => hr_int_shd.g_old_rec.field_value6

Line 363: => hr_int_shd.g_old_rec.field_name6

359: => hr_int_shd.g_old_rec.field_name5
360: ,p_field_value5_o
361: => hr_int_shd.g_old_rec.field_value5
362: ,p_field_name6_o
363: => hr_int_shd.g_old_rec.field_name6
364: ,p_field_value6_o
365: => hr_int_shd.g_old_rec.field_value6
366: ,p_field_name7_o
367: => hr_int_shd.g_old_rec.field_name7

Line 365: => hr_int_shd.g_old_rec.field_value6

361: => hr_int_shd.g_old_rec.field_value5
362: ,p_field_name6_o
363: => hr_int_shd.g_old_rec.field_name6
364: ,p_field_value6_o
365: => hr_int_shd.g_old_rec.field_value6
366: ,p_field_name7_o
367: => hr_int_shd.g_old_rec.field_name7
368: ,p_field_value7_o
369: => hr_int_shd.g_old_rec.field_value7

Line 367: => hr_int_shd.g_old_rec.field_name7

363: => hr_int_shd.g_old_rec.field_name6
364: ,p_field_value6_o
365: => hr_int_shd.g_old_rec.field_value6
366: ,p_field_name7_o
367: => hr_int_shd.g_old_rec.field_name7
368: ,p_field_value7_o
369: => hr_int_shd.g_old_rec.field_value7
370: ,p_field_name8_o
371: => hr_int_shd.g_old_rec.field_name8

Line 369: => hr_int_shd.g_old_rec.field_value7

365: => hr_int_shd.g_old_rec.field_value6
366: ,p_field_name7_o
367: => hr_int_shd.g_old_rec.field_name7
368: ,p_field_value7_o
369: => hr_int_shd.g_old_rec.field_value7
370: ,p_field_name8_o
371: => hr_int_shd.g_old_rec.field_name8
372: ,p_field_value8_o
373: => hr_int_shd.g_old_rec.field_value8

Line 371: => hr_int_shd.g_old_rec.field_name8

367: => hr_int_shd.g_old_rec.field_name7
368: ,p_field_value7_o
369: => hr_int_shd.g_old_rec.field_value7
370: ,p_field_name8_o
371: => hr_int_shd.g_old_rec.field_name8
372: ,p_field_value8_o
373: => hr_int_shd.g_old_rec.field_value8
374: ,p_field_name9_o
375: => hr_int_shd.g_old_rec.field_name9

Line 373: => hr_int_shd.g_old_rec.field_value8

369: => hr_int_shd.g_old_rec.field_value7
370: ,p_field_name8_o
371: => hr_int_shd.g_old_rec.field_name8
372: ,p_field_value8_o
373: => hr_int_shd.g_old_rec.field_value8
374: ,p_field_name9_o
375: => hr_int_shd.g_old_rec.field_name9
376: ,p_field_value9_o
377: => hr_int_shd.g_old_rec.field_value9

Line 375: => hr_int_shd.g_old_rec.field_name9

371: => hr_int_shd.g_old_rec.field_name8
372: ,p_field_value8_o
373: => hr_int_shd.g_old_rec.field_value8
374: ,p_field_name9_o
375: => hr_int_shd.g_old_rec.field_name9
376: ,p_field_value9_o
377: => hr_int_shd.g_old_rec.field_value9
378: ,p_object_version_number_o
379: => hr_int_shd.g_old_rec.object_version_number

Line 377: => hr_int_shd.g_old_rec.field_value9

373: => hr_int_shd.g_old_rec.field_value8
374: ,p_field_name9_o
375: => hr_int_shd.g_old_rec.field_name9
376: ,p_field_value9_o
377: => hr_int_shd.g_old_rec.field_value9
378: ,p_object_version_number_o
379: => hr_int_shd.g_old_rec.object_version_number
380: );
381: --

Line 379: => hr_int_shd.g_old_rec.object_version_number

375: => hr_int_shd.g_old_rec.field_name9
376: ,p_field_value9_o
377: => hr_int_shd.g_old_rec.field_value9
378: ,p_object_version_number_o
379: => hr_int_shd.g_old_rec.object_version_number
380: );
381: --
382: exception
383: --

Line 439: (p_rec in out nocopy hr_int_shd.g_rec_type

435: --
436: -- {End Of Comments}
437: -- ----------------------------------------------------------------------------
438: Procedure convert_defs
439: (p_rec in out nocopy hr_int_shd.g_rec_type
440: ) is
441: --
442: Begin
443: --

Line 451: hr_int_shd.g_old_rec.integration_key;

447: -- is being used then we must set to the 'current' argument value.
448: --
449: If (p_rec.integration_key = hr_api.g_varchar2) then
450: p_rec.integration_key :=
451: hr_int_shd.g_old_rec.integration_key;
452: End If;
453: If (p_rec.party_type = hr_api.g_varchar2) then
454: p_rec.party_type :=
455: hr_int_shd.g_old_rec.party_type;

Line 455: hr_int_shd.g_old_rec.party_type;

451: hr_int_shd.g_old_rec.integration_key;
452: End If;
453: If (p_rec.party_type = hr_api.g_varchar2) then
454: p_rec.party_type :=
455: hr_int_shd.g_old_rec.party_type;
456: End If;
457: If (p_rec.party_name = hr_api.g_varchar2) then
458: p_rec.party_name :=
459: hr_int_shd.g_old_rec.party_name;

Line 459: hr_int_shd.g_old_rec.party_name;

455: hr_int_shd.g_old_rec.party_type;
456: End If;
457: If (p_rec.party_name = hr_api.g_varchar2) then
458: p_rec.party_name :=
459: hr_int_shd.g_old_rec.party_name;
460: End If;
461: If (p_rec.party_site_name = hr_api.g_varchar2) then
462: p_rec.party_site_name :=
463: hr_int_shd.g_old_rec.party_site_name;

Line 463: hr_int_shd.g_old_rec.party_site_name;

459: hr_int_shd.g_old_rec.party_name;
460: End If;
461: If (p_rec.party_site_name = hr_api.g_varchar2) then
462: p_rec.party_site_name :=
463: hr_int_shd.g_old_rec.party_site_name;
464: End If;
465: If (p_rec.transaction_type = hr_api.g_varchar2) then
466: p_rec.transaction_type :=
467: hr_int_shd.g_old_rec.transaction_type;

Line 467: hr_int_shd.g_old_rec.transaction_type;

463: hr_int_shd.g_old_rec.party_site_name;
464: End If;
465: If (p_rec.transaction_type = hr_api.g_varchar2) then
466: p_rec.transaction_type :=
467: hr_int_shd.g_old_rec.transaction_type;
468: End If;
469: If (p_rec.transaction_subtype = hr_api.g_varchar2) then
470: p_rec.transaction_subtype :=
471: hr_int_shd.g_old_rec.transaction_subtype;

Line 471: hr_int_shd.g_old_rec.transaction_subtype;

467: hr_int_shd.g_old_rec.transaction_type;
468: End If;
469: If (p_rec.transaction_subtype = hr_api.g_varchar2) then
470: p_rec.transaction_subtype :=
471: hr_int_shd.g_old_rec.transaction_subtype;
472: End If;
473: If (p_rec.standard_code = hr_api.g_varchar2) then
474: p_rec.standard_code :=
475: hr_int_shd.g_old_rec.standard_code;

Line 475: hr_int_shd.g_old_rec.standard_code;

471: hr_int_shd.g_old_rec.transaction_subtype;
472: End If;
473: If (p_rec.standard_code = hr_api.g_varchar2) then
474: p_rec.standard_code :=
475: hr_int_shd.g_old_rec.standard_code;
476: End If;
477: If (p_rec.ext_trans_type = hr_api.g_varchar2) then
478: p_rec.ext_trans_type :=
479: hr_int_shd.g_old_rec.ext_trans_type;

Line 479: hr_int_shd.g_old_rec.ext_trans_type;

475: hr_int_shd.g_old_rec.standard_code;
476: End If;
477: If (p_rec.ext_trans_type = hr_api.g_varchar2) then
478: p_rec.ext_trans_type :=
479: hr_int_shd.g_old_rec.ext_trans_type;
480: End If;
481: If (p_rec.ext_trans_subtype = hr_api.g_varchar2) then
482: p_rec.ext_trans_subtype :=
483: hr_int_shd.g_old_rec.ext_trans_subtype;

Line 483: hr_int_shd.g_old_rec.ext_trans_subtype;

479: hr_int_shd.g_old_rec.ext_trans_type;
480: End If;
481: If (p_rec.ext_trans_subtype = hr_api.g_varchar2) then
482: p_rec.ext_trans_subtype :=
483: hr_int_shd.g_old_rec.ext_trans_subtype;
484: End If;
485: If (p_rec.trans_direction = hr_api.g_varchar2) then
486: p_rec.trans_direction :=
487: hr_int_shd.g_old_rec.trans_direction;

Line 487: hr_int_shd.g_old_rec.trans_direction;

483: hr_int_shd.g_old_rec.ext_trans_subtype;
484: End If;
485: If (p_rec.trans_direction = hr_api.g_varchar2) then
486: p_rec.trans_direction :=
487: hr_int_shd.g_old_rec.trans_direction;
488: End If;
489: If (p_rec.url = hr_api.g_varchar2) then
490: p_rec.url :=
491: hr_int_shd.g_old_rec.url;

Line 491: hr_int_shd.g_old_rec.url;

487: hr_int_shd.g_old_rec.trans_direction;
488: End If;
489: If (p_rec.url = hr_api.g_varchar2) then
490: p_rec.url :=
491: hr_int_shd.g_old_rec.url;
492: End If;
493: If (p_rec.synched = hr_api.g_varchar2) then
494: p_rec.synched :=
495: hr_int_shd.g_old_rec.synched;

Line 495: hr_int_shd.g_old_rec.synched;

491: hr_int_shd.g_old_rec.url;
492: End If;
493: If (p_rec.synched = hr_api.g_varchar2) then
494: p_rec.synched :=
495: hr_int_shd.g_old_rec.synched;
496: End If;
497: If (p_rec.ext_application_id = hr_api.g_number) then
498: p_rec.ext_application_id :=
499: hr_int_shd.g_old_rec.ext_application_id;

Line 499: hr_int_shd.g_old_rec.ext_application_id;

495: hr_int_shd.g_old_rec.synched;
496: End If;
497: If (p_rec.ext_application_id = hr_api.g_number) then
498: p_rec.ext_application_id :=
499: hr_int_shd.g_old_rec.ext_application_id;
500: End If;
501: If (p_rec.application_name = hr_api.g_varchar2) then
502: p_rec.application_name :=
503: hr_int_shd.g_old_rec.application_name;

Line 503: hr_int_shd.g_old_rec.application_name;

499: hr_int_shd.g_old_rec.ext_application_id;
500: End If;
501: If (p_rec.application_name = hr_api.g_varchar2) then
502: p_rec.application_name :=
503: hr_int_shd.g_old_rec.application_name;
504: End If;
505: If (p_rec.application_type = hr_api.g_varchar2) then
506: p_rec.application_type :=
507: hr_int_shd.g_old_rec.application_type;

Line 507: hr_int_shd.g_old_rec.application_type;

503: hr_int_shd.g_old_rec.application_name;
504: End If;
505: If (p_rec.application_type = hr_api.g_varchar2) then
506: p_rec.application_type :=
507: hr_int_shd.g_old_rec.application_type;
508: End If;
509: If (p_rec.application_url = hr_api.g_varchar2) then
510: p_rec.application_url :=
511: hr_int_shd.g_old_rec.application_url;

Line 511: hr_int_shd.g_old_rec.application_url;

507: hr_int_shd.g_old_rec.application_type;
508: End If;
509: If (p_rec.application_url = hr_api.g_varchar2) then
510: p_rec.application_url :=
511: hr_int_shd.g_old_rec.application_url;
512: End If;
513: If (p_rec.logout_url = hr_api.g_varchar2) then
514: p_rec.logout_url :=
515: hr_int_shd.g_old_rec.logout_url;

Line 515: hr_int_shd.g_old_rec.logout_url;

511: hr_int_shd.g_old_rec.application_url;
512: End If;
513: If (p_rec.logout_url = hr_api.g_varchar2) then
514: p_rec.logout_url :=
515: hr_int_shd.g_old_rec.logout_url;
516: End If;
517: If (p_rec.user_field = hr_api.g_varchar2) then
518: p_rec.user_field :=
519: hr_int_shd.g_old_rec.user_field;

Line 519: hr_int_shd.g_old_rec.user_field;

515: hr_int_shd.g_old_rec.logout_url;
516: End If;
517: If (p_rec.user_field = hr_api.g_varchar2) then
518: p_rec.user_field :=
519: hr_int_shd.g_old_rec.user_field;
520: End If;
521: If (p_rec.password_field = hr_api.g_varchar2) then
522: p_rec.password_field :=
523: hr_int_shd.g_old_rec.password_field;

Line 523: hr_int_shd.g_old_rec.password_field;

519: hr_int_shd.g_old_rec.user_field;
520: End If;
521: If (p_rec.password_field = hr_api.g_varchar2) then
522: p_rec.password_field :=
523: hr_int_shd.g_old_rec.password_field;
524: End If;
525: If (p_rec.authentication_needed = hr_api.g_varchar2) then
526: p_rec.authentication_needed :=
527: hr_int_shd.g_old_rec.authentication_needed;

Line 527: hr_int_shd.g_old_rec.authentication_needed;

523: hr_int_shd.g_old_rec.password_field;
524: End If;
525: If (p_rec.authentication_needed = hr_api.g_varchar2) then
526: p_rec.authentication_needed :=
527: hr_int_shd.g_old_rec.authentication_needed;
528: End If;
529: If (p_rec.field_name1 = hr_api.g_varchar2) then
530: p_rec.field_name1 :=
531: hr_int_shd.g_old_rec.field_name1;

Line 531: hr_int_shd.g_old_rec.field_name1;

527: hr_int_shd.g_old_rec.authentication_needed;
528: End If;
529: If (p_rec.field_name1 = hr_api.g_varchar2) then
530: p_rec.field_name1 :=
531: hr_int_shd.g_old_rec.field_name1;
532: End If;
533: If (p_rec.field_value1 = hr_api.g_varchar2) then
534: p_rec.field_value1 :=
535: hr_int_shd.g_old_rec.field_value1;

Line 535: hr_int_shd.g_old_rec.field_value1;

531: hr_int_shd.g_old_rec.field_name1;
532: End If;
533: If (p_rec.field_value1 = hr_api.g_varchar2) then
534: p_rec.field_value1 :=
535: hr_int_shd.g_old_rec.field_value1;
536: End If;
537: If (p_rec.field_name2 = hr_api.g_varchar2) then
538: p_rec.field_name2 :=
539: hr_int_shd.g_old_rec.field_name2;

Line 539: hr_int_shd.g_old_rec.field_name2;

535: hr_int_shd.g_old_rec.field_value1;
536: End If;
537: If (p_rec.field_name2 = hr_api.g_varchar2) then
538: p_rec.field_name2 :=
539: hr_int_shd.g_old_rec.field_name2;
540: End If;
541: If (p_rec.field_value2 = hr_api.g_varchar2) then
542: p_rec.field_value2 :=
543: hr_int_shd.g_old_rec.field_value2;

Line 543: hr_int_shd.g_old_rec.field_value2;

539: hr_int_shd.g_old_rec.field_name2;
540: End If;
541: If (p_rec.field_value2 = hr_api.g_varchar2) then
542: p_rec.field_value2 :=
543: hr_int_shd.g_old_rec.field_value2;
544: End If;
545: If (p_rec.field_name3 = hr_api.g_varchar2) then
546: p_rec.field_name3 :=
547: hr_int_shd.g_old_rec.field_name3;

Line 547: hr_int_shd.g_old_rec.field_name3;

543: hr_int_shd.g_old_rec.field_value2;
544: End If;
545: If (p_rec.field_name3 = hr_api.g_varchar2) then
546: p_rec.field_name3 :=
547: hr_int_shd.g_old_rec.field_name3;
548: End If;
549: If (p_rec.field_value3 = hr_api.g_varchar2) then
550: p_rec.field_value3 :=
551: hr_int_shd.g_old_rec.field_value3;

Line 551: hr_int_shd.g_old_rec.field_value3;

547: hr_int_shd.g_old_rec.field_name3;
548: End If;
549: If (p_rec.field_value3 = hr_api.g_varchar2) then
550: p_rec.field_value3 :=
551: hr_int_shd.g_old_rec.field_value3;
552: End If;
553: If (p_rec.field_name4 = hr_api.g_varchar2) then
554: p_rec.field_name4 :=
555: hr_int_shd.g_old_rec.field_name4;

Line 555: hr_int_shd.g_old_rec.field_name4;

551: hr_int_shd.g_old_rec.field_value3;
552: End If;
553: If (p_rec.field_name4 = hr_api.g_varchar2) then
554: p_rec.field_name4 :=
555: hr_int_shd.g_old_rec.field_name4;
556: End If;
557: If (p_rec.field_value4 = hr_api.g_varchar2) then
558: p_rec.field_value4 :=
559: hr_int_shd.g_old_rec.field_value4;

Line 559: hr_int_shd.g_old_rec.field_value4;

555: hr_int_shd.g_old_rec.field_name4;
556: End If;
557: If (p_rec.field_value4 = hr_api.g_varchar2) then
558: p_rec.field_value4 :=
559: hr_int_shd.g_old_rec.field_value4;
560: End If;
561: If (p_rec.field_name5 = hr_api.g_varchar2) then
562: p_rec.field_name5 :=
563: hr_int_shd.g_old_rec.field_name5;

Line 563: hr_int_shd.g_old_rec.field_name5;

559: hr_int_shd.g_old_rec.field_value4;
560: End If;
561: If (p_rec.field_name5 = hr_api.g_varchar2) then
562: p_rec.field_name5 :=
563: hr_int_shd.g_old_rec.field_name5;
564: End If;
565: If (p_rec.field_value5 = hr_api.g_varchar2) then
566: p_rec.field_value5 :=
567: hr_int_shd.g_old_rec.field_value5;

Line 567: hr_int_shd.g_old_rec.field_value5;

563: hr_int_shd.g_old_rec.field_name5;
564: End If;
565: If (p_rec.field_value5 = hr_api.g_varchar2) then
566: p_rec.field_value5 :=
567: hr_int_shd.g_old_rec.field_value5;
568: End If;
569: If (p_rec.field_name6 = hr_api.g_varchar2) then
570: p_rec.field_name6 :=
571: hr_int_shd.g_old_rec.field_name6;

Line 571: hr_int_shd.g_old_rec.field_name6;

567: hr_int_shd.g_old_rec.field_value5;
568: End If;
569: If (p_rec.field_name6 = hr_api.g_varchar2) then
570: p_rec.field_name6 :=
571: hr_int_shd.g_old_rec.field_name6;
572: End If;
573: If (p_rec.field_value6 = hr_api.g_varchar2) then
574: p_rec.field_value6 :=
575: hr_int_shd.g_old_rec.field_value6;

Line 575: hr_int_shd.g_old_rec.field_value6;

571: hr_int_shd.g_old_rec.field_name6;
572: End If;
573: If (p_rec.field_value6 = hr_api.g_varchar2) then
574: p_rec.field_value6 :=
575: hr_int_shd.g_old_rec.field_value6;
576: End If;
577: If (p_rec.field_name7 = hr_api.g_varchar2) then
578: p_rec.field_name7 :=
579: hr_int_shd.g_old_rec.field_name7;

Line 579: hr_int_shd.g_old_rec.field_name7;

575: hr_int_shd.g_old_rec.field_value6;
576: End If;
577: If (p_rec.field_name7 = hr_api.g_varchar2) then
578: p_rec.field_name7 :=
579: hr_int_shd.g_old_rec.field_name7;
580: End If;
581: If (p_rec.field_value7 = hr_api.g_varchar2) then
582: p_rec.field_value7 :=
583: hr_int_shd.g_old_rec.field_value7;

Line 583: hr_int_shd.g_old_rec.field_value7;

579: hr_int_shd.g_old_rec.field_name7;
580: End If;
581: If (p_rec.field_value7 = hr_api.g_varchar2) then
582: p_rec.field_value7 :=
583: hr_int_shd.g_old_rec.field_value7;
584: End If;
585: If (p_rec.field_name8 = hr_api.g_varchar2) then
586: p_rec.field_name8 :=
587: hr_int_shd.g_old_rec.field_name8;

Line 587: hr_int_shd.g_old_rec.field_name8;

583: hr_int_shd.g_old_rec.field_value7;
584: End If;
585: If (p_rec.field_name8 = hr_api.g_varchar2) then
586: p_rec.field_name8 :=
587: hr_int_shd.g_old_rec.field_name8;
588: End If;
589: If (p_rec.field_value8 = hr_api.g_varchar2) then
590: p_rec.field_value8 :=
591: hr_int_shd.g_old_rec.field_value8;

Line 591: hr_int_shd.g_old_rec.field_value8;

587: hr_int_shd.g_old_rec.field_name8;
588: End If;
589: If (p_rec.field_value8 = hr_api.g_varchar2) then
590: p_rec.field_value8 :=
591: hr_int_shd.g_old_rec.field_value8;
592: End If;
593: If (p_rec.field_name9 = hr_api.g_varchar2) then
594: p_rec.field_name9 :=
595: hr_int_shd.g_old_rec.field_name9;

Line 595: hr_int_shd.g_old_rec.field_name9;

591: hr_int_shd.g_old_rec.field_value8;
592: End If;
593: If (p_rec.field_name9 = hr_api.g_varchar2) then
594: p_rec.field_name9 :=
595: hr_int_shd.g_old_rec.field_name9;
596: End If;
597: If (p_rec.field_value9 = hr_api.g_varchar2) then
598: p_rec.field_value9 :=
599: hr_int_shd.g_old_rec.field_value9;

Line 599: hr_int_shd.g_old_rec.field_value9;

595: hr_int_shd.g_old_rec.field_name9;
596: End If;
597: If (p_rec.field_value9 = hr_api.g_varchar2) then
598: p_rec.field_value9 :=
599: hr_int_shd.g_old_rec.field_value9;
600: End If;
601: --
602: End convert_defs;
603: --

Line 608: (p_rec in out nocopy hr_int_shd.g_rec_type

604: -- ----------------------------------------------------------------------------
605: -- |---------------------------------< upd >----------------------------------|
606: -- ----------------------------------------------------------------------------
607: Procedure upd
608: (p_rec in out nocopy hr_int_shd.g_rec_type
609: ) is
610: --
611: l_proc varchar2(72) := g_package||'upd';
612: --

Line 618: hr_int_shd.lck

614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: -- We must lock the row which we need to update.
617: --
618: hr_int_shd.lck
619: (p_rec.integration_id
620: ,p_rec.object_version_number
621: );
622: --

Line 700: l_rec hr_int_shd.g_rec_type;

696: ,p_field_name9 in varchar2 default hr_api.g_varchar2
697: ,p_field_value9 in varchar2 default hr_api.g_varchar2
698: ) is
699: --
700: l_rec hr_int_shd.g_rec_type;
701: l_proc varchar2(72) := g_package||'upd';
702: --
703: Begin
704: hr_utility.set_location('Entering:'||l_proc, 5);

Line 710: hr_int_shd.convert_args

706: -- Call conversion function to turn arguments into the
707: -- l_rec structure.
708: --
709: l_rec :=
710: hr_int_shd.convert_args
711: (p_integration_id
712: ,hr_api.g_varchar2
713: ,p_party_type
714: ,p_party_name