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));
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
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));
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
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));
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;
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');
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;
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
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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;