DBA Data[Home] [Help]

APPS.HR_TIS_UPD dependencies on HR_API

Line 103: When hr_api.check_integrity_violated Then

99: --
100: hr_utility.set_location(' Leaving:'||l_proc, 10);
101: --
102: Exception
103: When hr_api.check_integrity_violated Then
104: -- A check constraint has been violated
105: --
106: hr_tis_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

103: When hr_api.check_integrity_violated Then
104: -- A check constraint has been violated
105: --
106: hr_tis_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: --
111: hr_tis_shd.constraint_error

Line 108: When hr_api.parent_integrity_violated Then

104: -- A check constraint has been violated
105: --
106: hr_tis_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: --
111: hr_tis_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: --
111: hr_tis_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: --
116: hr_tis_shd.constraint_error

Line 113: When hr_api.unique_integrity_violated Then

109: -- Parent integrity has been violated
110: --
111: hr_tis_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: --
116: hr_tis_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: --
116: hr_tis_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: --
120: Raise;
121: End update_dml;

Line 261: when hr_api.cannot_find_prog_unit then

257: );
258: --
259: exception
260: --
261: when hr_api.cannot_find_prog_unit then
262: --
263: hr_api.cannot_find_prog_unit_error
264: (p_module_name => 'HR_KI_TOPIC_INTEGRATIONS'
265: ,p_hook_type => 'AU');

Line 263: hr_api.cannot_find_prog_unit_error

259: exception
260: --
261: when hr_api.cannot_find_prog_unit then
262: --
263: hr_api.cannot_find_prog_unit_error
264: (p_module_name => 'HR_KI_TOPIC_INTEGRATIONS'
265: ,p_hook_type => 'AU');
266: --
267: end;

Line 326: If (p_rec.topic_id = hr_api.g_number) then

322: -- p_rec plsql record structure
323: -- to see if a system default is being used. If a system default
324: -- is being used then we must set to the 'current' argument value.
325: --
326: If (p_rec.topic_id = hr_api.g_number) then
327: p_rec.topic_id :=
328: hr_tis_shd.g_old_rec.topic_id;
329: End If;
330: If (p_rec.integration_id = hr_api.g_number) then

Line 330: If (p_rec.integration_id = hr_api.g_number) then

326: If (p_rec.topic_id = hr_api.g_number) then
327: p_rec.topic_id :=
328: hr_tis_shd.g_old_rec.topic_id;
329: End If;
330: If (p_rec.integration_id = hr_api.g_number) then
331: p_rec.integration_id :=
332: hr_tis_shd.g_old_rec.integration_id;
333: End If;
334: If (p_rec.param_name1 = hr_api.g_varchar2) then

Line 334: If (p_rec.param_name1 = hr_api.g_varchar2) then

330: If (p_rec.integration_id = hr_api.g_number) then
331: p_rec.integration_id :=
332: hr_tis_shd.g_old_rec.integration_id;
333: End If;
334: If (p_rec.param_name1 = hr_api.g_varchar2) then
335: p_rec.param_name1 := hr_tis_shd.g_old_rec.param_name1;
336: End If;
337: If (p_rec.param_value1 = hr_api.g_varchar2) then
338: p_rec.param_value1 := hr_tis_shd.g_old_rec.param_value1;

Line 337: If (p_rec.param_value1 = hr_api.g_varchar2) then

333: End If;
334: If (p_rec.param_name1 = hr_api.g_varchar2) then
335: p_rec.param_name1 := hr_tis_shd.g_old_rec.param_name1;
336: End If;
337: If (p_rec.param_value1 = hr_api.g_varchar2) then
338: p_rec.param_value1 := hr_tis_shd.g_old_rec.param_value1;
339: End If;
340: If (p_rec.param_name2 = hr_api.g_varchar2) then
341: p_rec.param_name2 := hr_tis_shd.g_old_rec.param_name2;

Line 340: If (p_rec.param_name2 = hr_api.g_varchar2) then

336: End If;
337: If (p_rec.param_value1 = hr_api.g_varchar2) then
338: p_rec.param_value1 := hr_tis_shd.g_old_rec.param_value1;
339: End If;
340: If (p_rec.param_name2 = hr_api.g_varchar2) then
341: p_rec.param_name2 := hr_tis_shd.g_old_rec.param_name2;
342: End If;
343: If (p_rec.param_value2 = hr_api.g_varchar2) then
344: p_rec.param_value2 := hr_tis_shd.g_old_rec.param_value2;

Line 343: If (p_rec.param_value2 = hr_api.g_varchar2) then

339: End If;
340: If (p_rec.param_name2 = hr_api.g_varchar2) then
341: p_rec.param_name2 := hr_tis_shd.g_old_rec.param_name2;
342: End If;
343: If (p_rec.param_value2 = hr_api.g_varchar2) then
344: p_rec.param_value2 := hr_tis_shd.g_old_rec.param_value2;
345: End If;
346: If (p_rec.param_name3 = hr_api.g_varchar2) then
347: p_rec.param_name3 := hr_tis_shd.g_old_rec.param_name3;

Line 346: If (p_rec.param_name3 = hr_api.g_varchar2) then

342: End If;
343: If (p_rec.param_value2 = hr_api.g_varchar2) then
344: p_rec.param_value2 := hr_tis_shd.g_old_rec.param_value2;
345: End If;
346: If (p_rec.param_name3 = hr_api.g_varchar2) then
347: p_rec.param_name3 := hr_tis_shd.g_old_rec.param_name3;
348: End If;
349: If (p_rec.param_value3 = hr_api.g_varchar2) then
350: p_rec.param_value3 := hr_tis_shd.g_old_rec.param_value3;

Line 349: If (p_rec.param_value3 = hr_api.g_varchar2) then

345: End If;
346: If (p_rec.param_name3 = hr_api.g_varchar2) then
347: p_rec.param_name3 := hr_tis_shd.g_old_rec.param_name3;
348: End If;
349: If (p_rec.param_value3 = hr_api.g_varchar2) then
350: p_rec.param_value3 := hr_tis_shd.g_old_rec.param_value3;
351: End If;
352: If (p_rec.param_name4 = hr_api.g_varchar2) then
353: p_rec.param_name4 := hr_tis_shd.g_old_rec.param_name4;

Line 352: If (p_rec.param_name4 = hr_api.g_varchar2) then

348: End If;
349: If (p_rec.param_value3 = hr_api.g_varchar2) then
350: p_rec.param_value3 := hr_tis_shd.g_old_rec.param_value3;
351: End If;
352: If (p_rec.param_name4 = hr_api.g_varchar2) then
353: p_rec.param_name4 := hr_tis_shd.g_old_rec.param_name4;
354: End If;
355: If (p_rec.param_value4 = hr_api.g_varchar2) then
356: p_rec.param_value4 := hr_tis_shd.g_old_rec.param_value4;

Line 355: If (p_rec.param_value4 = hr_api.g_varchar2) then

351: End If;
352: If (p_rec.param_name4 = hr_api.g_varchar2) then
353: p_rec.param_name4 := hr_tis_shd.g_old_rec.param_name4;
354: End If;
355: If (p_rec.param_value4 = hr_api.g_varchar2) then
356: p_rec.param_value4 := hr_tis_shd.g_old_rec.param_value4;
357: End If;
358: If (p_rec.param_name5 = hr_api.g_varchar2) then
359: p_rec.param_name5 := hr_tis_shd.g_old_rec.param_name5;

Line 358: If (p_rec.param_name5 = hr_api.g_varchar2) then

354: End If;
355: If (p_rec.param_value4 = hr_api.g_varchar2) then
356: p_rec.param_value4 := hr_tis_shd.g_old_rec.param_value4;
357: End If;
358: If (p_rec.param_name5 = hr_api.g_varchar2) then
359: p_rec.param_name5 := hr_tis_shd.g_old_rec.param_name5;
360: End If;
361: If (p_rec.param_value5 = hr_api.g_varchar2) then
362: p_rec.param_value5 := hr_tis_shd.g_old_rec.param_value5;

Line 361: If (p_rec.param_value5 = hr_api.g_varchar2) then

357: End If;
358: If (p_rec.param_name5 = hr_api.g_varchar2) then
359: p_rec.param_name5 := hr_tis_shd.g_old_rec.param_name5;
360: End If;
361: If (p_rec.param_value5 = hr_api.g_varchar2) then
362: p_rec.param_value5 := hr_tis_shd.g_old_rec.param_value5;
363: End If;
364: If (p_rec.param_name6 = hr_api.g_varchar2) then
365: p_rec.param_name6 := hr_tis_shd.g_old_rec.param_name6;

Line 364: If (p_rec.param_name6 = hr_api.g_varchar2) then

360: End If;
361: If (p_rec.param_value5 = hr_api.g_varchar2) then
362: p_rec.param_value5 := hr_tis_shd.g_old_rec.param_value5;
363: End If;
364: If (p_rec.param_name6 = hr_api.g_varchar2) then
365: p_rec.param_name6 := hr_tis_shd.g_old_rec.param_name6;
366: End If;
367: If (p_rec.param_value6 = hr_api.g_varchar2) then
368: p_rec.param_value6 := hr_tis_shd.g_old_rec.param_value6;

Line 367: If (p_rec.param_value6 = hr_api.g_varchar2) then

363: End If;
364: If (p_rec.param_name6 = hr_api.g_varchar2) then
365: p_rec.param_name6 := hr_tis_shd.g_old_rec.param_name6;
366: End If;
367: If (p_rec.param_value6 = hr_api.g_varchar2) then
368: p_rec.param_value6 := hr_tis_shd.g_old_rec.param_value6;
369: End If;
370: If (p_rec.param_name7 = hr_api.g_varchar2) then
371: p_rec.param_name7 := hr_tis_shd.g_old_rec.param_name7;

Line 370: If (p_rec.param_name7 = hr_api.g_varchar2) then

366: End If;
367: If (p_rec.param_value6 = hr_api.g_varchar2) then
368: p_rec.param_value6 := hr_tis_shd.g_old_rec.param_value6;
369: End If;
370: If (p_rec.param_name7 = hr_api.g_varchar2) then
371: p_rec.param_name7 := hr_tis_shd.g_old_rec.param_name7;
372: End If;
373: If (p_rec.param_value7 = hr_api.g_varchar2) then
374: p_rec.param_value7 := hr_tis_shd.g_old_rec.param_value7;

Line 373: If (p_rec.param_value7 = hr_api.g_varchar2) then

369: End If;
370: If (p_rec.param_name7 = hr_api.g_varchar2) then
371: p_rec.param_name7 := hr_tis_shd.g_old_rec.param_name7;
372: End If;
373: If (p_rec.param_value7 = hr_api.g_varchar2) then
374: p_rec.param_value7 := hr_tis_shd.g_old_rec.param_value7;
375: End If;
376: If (p_rec.param_name8 = hr_api.g_varchar2) then
377: p_rec.param_name8 := hr_tis_shd.g_old_rec.param_name8;

Line 376: If (p_rec.param_name8 = hr_api.g_varchar2) then

372: End If;
373: If (p_rec.param_value7 = hr_api.g_varchar2) then
374: p_rec.param_value7 := hr_tis_shd.g_old_rec.param_value7;
375: End If;
376: If (p_rec.param_name8 = hr_api.g_varchar2) then
377: p_rec.param_name8 := hr_tis_shd.g_old_rec.param_name8;
378: End If;
379: If (p_rec.param_value8 = hr_api.g_varchar2) then
380: p_rec.param_value8 := hr_tis_shd.g_old_rec.param_value8;

Line 379: If (p_rec.param_value8 = hr_api.g_varchar2) then

375: End If;
376: If (p_rec.param_name8 = hr_api.g_varchar2) then
377: p_rec.param_name8 := hr_tis_shd.g_old_rec.param_name8;
378: End If;
379: If (p_rec.param_value8 = hr_api.g_varchar2) then
380: p_rec.param_value8 := hr_tis_shd.g_old_rec.param_value8;
381: End If;
382: If (p_rec.param_name9 = hr_api.g_varchar2) then
383: p_rec.param_name9 := hr_tis_shd.g_old_rec.param_name9;

Line 382: If (p_rec.param_name9 = hr_api.g_varchar2) then

378: End If;
379: If (p_rec.param_value8 = hr_api.g_varchar2) then
380: p_rec.param_value8 := hr_tis_shd.g_old_rec.param_value8;
381: End If;
382: If (p_rec.param_name9 = hr_api.g_varchar2) then
383: p_rec.param_name9 := hr_tis_shd.g_old_rec.param_name9;
384: End If;
385: If (p_rec.param_value9 = hr_api.g_varchar2) then
386: p_rec.param_value9 := hr_tis_shd.g_old_rec.param_value9;

Line 385: If (p_rec.param_value9 = hr_api.g_varchar2) then

381: End If;
382: If (p_rec.param_name9 = hr_api.g_varchar2) then
383: p_rec.param_name9 := hr_tis_shd.g_old_rec.param_name9;
384: End If;
385: If (p_rec.param_value9 = hr_api.g_varchar2) then
386: p_rec.param_value9 := hr_tis_shd.g_old_rec.param_value9;
387: End If;
388: If (p_rec.param_name10 = hr_api.g_varchar2) then
389: p_rec.param_name10 := hr_tis_shd.g_old_rec.param_name10;

Line 388: If (p_rec.param_name10 = hr_api.g_varchar2) then

384: End If;
385: If (p_rec.param_value9 = hr_api.g_varchar2) then
386: p_rec.param_value9 := hr_tis_shd.g_old_rec.param_value9;
387: End If;
388: If (p_rec.param_name10 = hr_api.g_varchar2) then
389: p_rec.param_name10 := hr_tis_shd.g_old_rec.param_name10;
390: End If;
391: If (p_rec.param_value10 = hr_api.g_varchar2) then
392: p_rec.param_value10 := hr_tis_shd.g_old_rec.param_value10;

Line 391: If (p_rec.param_value10 = hr_api.g_varchar2) then

387: End If;
388: If (p_rec.param_name10 = hr_api.g_varchar2) then
389: p_rec.param_name10 := hr_tis_shd.g_old_rec.param_name10;
390: End If;
391: If (p_rec.param_value10 = hr_api.g_varchar2) then
392: p_rec.param_value10 := hr_tis_shd.g_old_rec.param_value10;
393: End If;
394: --
395: End convert_defs;

Line 453: ,p_topic_id in number default hr_api.g_number

449: -- |---------------------------------< upd >----------------------------------|
450: -- ----------------------------------------------------------------------------
451: Procedure upd
452: (p_topic_integrations_id in number
453: ,p_topic_id in number default hr_api.g_number
454: ,p_integration_id in number default hr_api.g_number
455: ,p_param_name1 in varchar2 default hr_api.g_varchar2
456: ,p_param_value1 in varchar2 default hr_api.g_varchar2
457: ,p_param_name2 in varchar2 default hr_api.g_varchar2

Line 454: ,p_integration_id in number default hr_api.g_number

450: -- ----------------------------------------------------------------------------
451: Procedure upd
452: (p_topic_integrations_id in number
453: ,p_topic_id in number default hr_api.g_number
454: ,p_integration_id in number default hr_api.g_number
455: ,p_param_name1 in varchar2 default hr_api.g_varchar2
456: ,p_param_value1 in varchar2 default hr_api.g_varchar2
457: ,p_param_name2 in varchar2 default hr_api.g_varchar2
458: ,p_param_value2 in varchar2 default hr_api.g_varchar2

Line 455: ,p_param_name1 in varchar2 default hr_api.g_varchar2

451: Procedure upd
452: (p_topic_integrations_id in number
453: ,p_topic_id in number default hr_api.g_number
454: ,p_integration_id in number default hr_api.g_number
455: ,p_param_name1 in varchar2 default hr_api.g_varchar2
456: ,p_param_value1 in varchar2 default hr_api.g_varchar2
457: ,p_param_name2 in varchar2 default hr_api.g_varchar2
458: ,p_param_value2 in varchar2 default hr_api.g_varchar2
459: ,p_param_name3 in varchar2 default hr_api.g_varchar2

Line 456: ,p_param_value1 in varchar2 default hr_api.g_varchar2

452: (p_topic_integrations_id in number
453: ,p_topic_id in number default hr_api.g_number
454: ,p_integration_id in number default hr_api.g_number
455: ,p_param_name1 in varchar2 default hr_api.g_varchar2
456: ,p_param_value1 in varchar2 default hr_api.g_varchar2
457: ,p_param_name2 in varchar2 default hr_api.g_varchar2
458: ,p_param_value2 in varchar2 default hr_api.g_varchar2
459: ,p_param_name3 in varchar2 default hr_api.g_varchar2
460: ,p_param_value3 in varchar2 default hr_api.g_varchar2

Line 457: ,p_param_name2 in varchar2 default hr_api.g_varchar2

453: ,p_topic_id in number default hr_api.g_number
454: ,p_integration_id in number default hr_api.g_number
455: ,p_param_name1 in varchar2 default hr_api.g_varchar2
456: ,p_param_value1 in varchar2 default hr_api.g_varchar2
457: ,p_param_name2 in varchar2 default hr_api.g_varchar2
458: ,p_param_value2 in varchar2 default hr_api.g_varchar2
459: ,p_param_name3 in varchar2 default hr_api.g_varchar2
460: ,p_param_value3 in varchar2 default hr_api.g_varchar2
461: ,p_param_name4 in varchar2 default hr_api.g_varchar2

Line 458: ,p_param_value2 in varchar2 default hr_api.g_varchar2

454: ,p_integration_id in number default hr_api.g_number
455: ,p_param_name1 in varchar2 default hr_api.g_varchar2
456: ,p_param_value1 in varchar2 default hr_api.g_varchar2
457: ,p_param_name2 in varchar2 default hr_api.g_varchar2
458: ,p_param_value2 in varchar2 default hr_api.g_varchar2
459: ,p_param_name3 in varchar2 default hr_api.g_varchar2
460: ,p_param_value3 in varchar2 default hr_api.g_varchar2
461: ,p_param_name4 in varchar2 default hr_api.g_varchar2
462: ,p_param_value4 in varchar2 default hr_api.g_varchar2

Line 459: ,p_param_name3 in varchar2 default hr_api.g_varchar2

455: ,p_param_name1 in varchar2 default hr_api.g_varchar2
456: ,p_param_value1 in varchar2 default hr_api.g_varchar2
457: ,p_param_name2 in varchar2 default hr_api.g_varchar2
458: ,p_param_value2 in varchar2 default hr_api.g_varchar2
459: ,p_param_name3 in varchar2 default hr_api.g_varchar2
460: ,p_param_value3 in varchar2 default hr_api.g_varchar2
461: ,p_param_name4 in varchar2 default hr_api.g_varchar2
462: ,p_param_value4 in varchar2 default hr_api.g_varchar2
463: ,p_param_name5 in varchar2 default hr_api.g_varchar2

Line 460: ,p_param_value3 in varchar2 default hr_api.g_varchar2

456: ,p_param_value1 in varchar2 default hr_api.g_varchar2
457: ,p_param_name2 in varchar2 default hr_api.g_varchar2
458: ,p_param_value2 in varchar2 default hr_api.g_varchar2
459: ,p_param_name3 in varchar2 default hr_api.g_varchar2
460: ,p_param_value3 in varchar2 default hr_api.g_varchar2
461: ,p_param_name4 in varchar2 default hr_api.g_varchar2
462: ,p_param_value4 in varchar2 default hr_api.g_varchar2
463: ,p_param_name5 in varchar2 default hr_api.g_varchar2
464: ,p_param_value5 in varchar2 default hr_api.g_varchar2

Line 461: ,p_param_name4 in varchar2 default hr_api.g_varchar2

457: ,p_param_name2 in varchar2 default hr_api.g_varchar2
458: ,p_param_value2 in varchar2 default hr_api.g_varchar2
459: ,p_param_name3 in varchar2 default hr_api.g_varchar2
460: ,p_param_value3 in varchar2 default hr_api.g_varchar2
461: ,p_param_name4 in varchar2 default hr_api.g_varchar2
462: ,p_param_value4 in varchar2 default hr_api.g_varchar2
463: ,p_param_name5 in varchar2 default hr_api.g_varchar2
464: ,p_param_value5 in varchar2 default hr_api.g_varchar2
465: ,p_param_name6 in varchar2 default hr_api.g_varchar2

Line 462: ,p_param_value4 in varchar2 default hr_api.g_varchar2

458: ,p_param_value2 in varchar2 default hr_api.g_varchar2
459: ,p_param_name3 in varchar2 default hr_api.g_varchar2
460: ,p_param_value3 in varchar2 default hr_api.g_varchar2
461: ,p_param_name4 in varchar2 default hr_api.g_varchar2
462: ,p_param_value4 in varchar2 default hr_api.g_varchar2
463: ,p_param_name5 in varchar2 default hr_api.g_varchar2
464: ,p_param_value5 in varchar2 default hr_api.g_varchar2
465: ,p_param_name6 in varchar2 default hr_api.g_varchar2
466: ,p_param_value6 in varchar2 default hr_api.g_varchar2

Line 463: ,p_param_name5 in varchar2 default hr_api.g_varchar2

459: ,p_param_name3 in varchar2 default hr_api.g_varchar2
460: ,p_param_value3 in varchar2 default hr_api.g_varchar2
461: ,p_param_name4 in varchar2 default hr_api.g_varchar2
462: ,p_param_value4 in varchar2 default hr_api.g_varchar2
463: ,p_param_name5 in varchar2 default hr_api.g_varchar2
464: ,p_param_value5 in varchar2 default hr_api.g_varchar2
465: ,p_param_name6 in varchar2 default hr_api.g_varchar2
466: ,p_param_value6 in varchar2 default hr_api.g_varchar2
467: ,p_param_name7 in varchar2 default hr_api.g_varchar2

Line 464: ,p_param_value5 in varchar2 default hr_api.g_varchar2

460: ,p_param_value3 in varchar2 default hr_api.g_varchar2
461: ,p_param_name4 in varchar2 default hr_api.g_varchar2
462: ,p_param_value4 in varchar2 default hr_api.g_varchar2
463: ,p_param_name5 in varchar2 default hr_api.g_varchar2
464: ,p_param_value5 in varchar2 default hr_api.g_varchar2
465: ,p_param_name6 in varchar2 default hr_api.g_varchar2
466: ,p_param_value6 in varchar2 default hr_api.g_varchar2
467: ,p_param_name7 in varchar2 default hr_api.g_varchar2
468: ,p_param_value7 in varchar2 default hr_api.g_varchar2

Line 465: ,p_param_name6 in varchar2 default hr_api.g_varchar2

461: ,p_param_name4 in varchar2 default hr_api.g_varchar2
462: ,p_param_value4 in varchar2 default hr_api.g_varchar2
463: ,p_param_name5 in varchar2 default hr_api.g_varchar2
464: ,p_param_value5 in varchar2 default hr_api.g_varchar2
465: ,p_param_name6 in varchar2 default hr_api.g_varchar2
466: ,p_param_value6 in varchar2 default hr_api.g_varchar2
467: ,p_param_name7 in varchar2 default hr_api.g_varchar2
468: ,p_param_value7 in varchar2 default hr_api.g_varchar2
469: ,p_param_name8 in varchar2 default hr_api.g_varchar2

Line 466: ,p_param_value6 in varchar2 default hr_api.g_varchar2

462: ,p_param_value4 in varchar2 default hr_api.g_varchar2
463: ,p_param_name5 in varchar2 default hr_api.g_varchar2
464: ,p_param_value5 in varchar2 default hr_api.g_varchar2
465: ,p_param_name6 in varchar2 default hr_api.g_varchar2
466: ,p_param_value6 in varchar2 default hr_api.g_varchar2
467: ,p_param_name7 in varchar2 default hr_api.g_varchar2
468: ,p_param_value7 in varchar2 default hr_api.g_varchar2
469: ,p_param_name8 in varchar2 default hr_api.g_varchar2
470: ,p_param_value8 in varchar2 default hr_api.g_varchar2

Line 467: ,p_param_name7 in varchar2 default hr_api.g_varchar2

463: ,p_param_name5 in varchar2 default hr_api.g_varchar2
464: ,p_param_value5 in varchar2 default hr_api.g_varchar2
465: ,p_param_name6 in varchar2 default hr_api.g_varchar2
466: ,p_param_value6 in varchar2 default hr_api.g_varchar2
467: ,p_param_name7 in varchar2 default hr_api.g_varchar2
468: ,p_param_value7 in varchar2 default hr_api.g_varchar2
469: ,p_param_name8 in varchar2 default hr_api.g_varchar2
470: ,p_param_value8 in varchar2 default hr_api.g_varchar2
471: ,p_param_name9 in varchar2 default hr_api.g_varchar2

Line 468: ,p_param_value7 in varchar2 default hr_api.g_varchar2

464: ,p_param_value5 in varchar2 default hr_api.g_varchar2
465: ,p_param_name6 in varchar2 default hr_api.g_varchar2
466: ,p_param_value6 in varchar2 default hr_api.g_varchar2
467: ,p_param_name7 in varchar2 default hr_api.g_varchar2
468: ,p_param_value7 in varchar2 default hr_api.g_varchar2
469: ,p_param_name8 in varchar2 default hr_api.g_varchar2
470: ,p_param_value8 in varchar2 default hr_api.g_varchar2
471: ,p_param_name9 in varchar2 default hr_api.g_varchar2
472: ,p_param_value9 in varchar2 default hr_api.g_varchar2

Line 469: ,p_param_name8 in varchar2 default hr_api.g_varchar2

465: ,p_param_name6 in varchar2 default hr_api.g_varchar2
466: ,p_param_value6 in varchar2 default hr_api.g_varchar2
467: ,p_param_name7 in varchar2 default hr_api.g_varchar2
468: ,p_param_value7 in varchar2 default hr_api.g_varchar2
469: ,p_param_name8 in varchar2 default hr_api.g_varchar2
470: ,p_param_value8 in varchar2 default hr_api.g_varchar2
471: ,p_param_name9 in varchar2 default hr_api.g_varchar2
472: ,p_param_value9 in varchar2 default hr_api.g_varchar2
473: ,p_param_name10 in varchar2 default hr_api.g_varchar2

Line 470: ,p_param_value8 in varchar2 default hr_api.g_varchar2

466: ,p_param_value6 in varchar2 default hr_api.g_varchar2
467: ,p_param_name7 in varchar2 default hr_api.g_varchar2
468: ,p_param_value7 in varchar2 default hr_api.g_varchar2
469: ,p_param_name8 in varchar2 default hr_api.g_varchar2
470: ,p_param_value8 in varchar2 default hr_api.g_varchar2
471: ,p_param_name9 in varchar2 default hr_api.g_varchar2
472: ,p_param_value9 in varchar2 default hr_api.g_varchar2
473: ,p_param_name10 in varchar2 default hr_api.g_varchar2
474: ,p_param_value10 in varchar2 default hr_api.g_varchar2

Line 471: ,p_param_name9 in varchar2 default hr_api.g_varchar2

467: ,p_param_name7 in varchar2 default hr_api.g_varchar2
468: ,p_param_value7 in varchar2 default hr_api.g_varchar2
469: ,p_param_name8 in varchar2 default hr_api.g_varchar2
470: ,p_param_value8 in varchar2 default hr_api.g_varchar2
471: ,p_param_name9 in varchar2 default hr_api.g_varchar2
472: ,p_param_value9 in varchar2 default hr_api.g_varchar2
473: ,p_param_name10 in varchar2 default hr_api.g_varchar2
474: ,p_param_value10 in varchar2 default hr_api.g_varchar2
475: ,p_object_version_number in out nocopy number

Line 472: ,p_param_value9 in varchar2 default hr_api.g_varchar2

468: ,p_param_value7 in varchar2 default hr_api.g_varchar2
469: ,p_param_name8 in varchar2 default hr_api.g_varchar2
470: ,p_param_value8 in varchar2 default hr_api.g_varchar2
471: ,p_param_name9 in varchar2 default hr_api.g_varchar2
472: ,p_param_value9 in varchar2 default hr_api.g_varchar2
473: ,p_param_name10 in varchar2 default hr_api.g_varchar2
474: ,p_param_value10 in varchar2 default hr_api.g_varchar2
475: ,p_object_version_number in out nocopy number
476: ) is

Line 473: ,p_param_name10 in varchar2 default hr_api.g_varchar2

469: ,p_param_name8 in varchar2 default hr_api.g_varchar2
470: ,p_param_value8 in varchar2 default hr_api.g_varchar2
471: ,p_param_name9 in varchar2 default hr_api.g_varchar2
472: ,p_param_value9 in varchar2 default hr_api.g_varchar2
473: ,p_param_name10 in varchar2 default hr_api.g_varchar2
474: ,p_param_value10 in varchar2 default hr_api.g_varchar2
475: ,p_object_version_number in out nocopy number
476: ) is
477: --

Line 474: ,p_param_value10 in varchar2 default hr_api.g_varchar2

470: ,p_param_value8 in varchar2 default hr_api.g_varchar2
471: ,p_param_name9 in varchar2 default hr_api.g_varchar2
472: ,p_param_value9 in varchar2 default hr_api.g_varchar2
473: ,p_param_name10 in varchar2 default hr_api.g_varchar2
474: ,p_param_value10 in varchar2 default hr_api.g_varchar2
475: ,p_object_version_number in out nocopy number
476: ) is
477: --
478: l_rec hr_tis_shd.g_rec_type;