APPS.HXC_ULC_UPD dependencies on HR_API

Line 110: When hr_api.check_integrity_violated Then

106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: end if;
108: --
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: hxc_ulc_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: hxc_ulc_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: hxc_ulc_shd.constraint_error

Line 115: When hr_api.parent_integrity_violated Then

111: -- A check constraint has been violated
112: --
113: hxc_ulc_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: hxc_ulc_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: hxc_ulc_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: hxc_ulc_shd.constraint_error

Line 120: When hr_api.unique_integrity_violated Then

116: -- Parent integrity has been violated
117: --
118: hxc_ulc_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: hxc_ulc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: hxc_ulc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
127: Raise;
128: End update_dml;

Line 306: when hr_api.cannot_find_prog_unit then

302: );
303: --
304: exception
305: --
306: when hr_api.cannot_find_prog_unit then
307: --
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'HXC_LAYOUT_COMPONENTS'
310: ,p_hook_type => 'AU');

Line 308: hr_api.cannot_find_prog_unit_error

304: exception
305: --
306: when hr_api.cannot_find_prog_unit then
307: --
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'HXC_LAYOUT_COMPONENTS'
310: ,p_hook_type => 'AU');
311: --
312: end;

Line 373: If (p_rec.layout_id = hr_api.g_number) then

369: -- p_rec plsql record structure
370: -- to see if a system default is being used. If a system default
371: -- is being used then we must set to the 'current' argument value.
372: --
373: If (p_rec.layout_id = hr_api.g_number) then
374: p_rec.layout_id :=
375: hxc_ulc_shd.g_old_rec.layout_id;
376: End If;
377: If (p_rec.layout_comp_definition_id = hr_api.g_number) then

Line 377: If (p_rec.layout_comp_definition_id = hr_api.g_number) then

373: If (p_rec.layout_id = hr_api.g_number) then
374: p_rec.layout_id :=
375: hxc_ulc_shd.g_old_rec.layout_id;
376: End If;
377: If (p_rec.layout_comp_definition_id = hr_api.g_number) then
378: p_rec.layout_comp_definition_id :=
379: hxc_ulc_shd.g_old_rec.layout_comp_definition_id;
380: End If;
381: If (p_rec.parent_component_id = hr_api.g_number) then

Line 381: If (p_rec.parent_component_id = hr_api.g_number) then

377: If (p_rec.layout_comp_definition_id = hr_api.g_number) then
378: p_rec.layout_comp_definition_id :=
379: hxc_ulc_shd.g_old_rec.layout_comp_definition_id;
380: End If;
381: If (p_rec.parent_component_id = hr_api.g_number) then
382: p_rec.parent_component_id :=
383: hxc_ulc_shd.g_old_rec.parent_component_id;
384: End If;
385: If (p_rec.component_name = hr_api.g_varchar2) then

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

381: If (p_rec.parent_component_id = hr_api.g_number) then
382: p_rec.parent_component_id :=
383: hxc_ulc_shd.g_old_rec.parent_component_id;
384: End If;
385: If (p_rec.component_name = hr_api.g_varchar2) then
386: p_rec.component_name :=
387: hxc_ulc_shd.g_old_rec.component_name;
388: End If;
389: If (p_rec.component_value = hr_api.g_varchar2) then

Line 389: If (p_rec.component_value = hr_api.g_varchar2) then

385: If (p_rec.component_name = hr_api.g_varchar2) then
386: p_rec.component_name :=
387: hxc_ulc_shd.g_old_rec.component_name;
388: End If;
389: If (p_rec.component_value = hr_api.g_varchar2) then
390: p_rec.component_value :=
391: hxc_ulc_shd.g_old_rec.component_value;
392: End If;
393: If (p_rec.sequence = hr_api.g_number) then

Line 393: If (p_rec.sequence = hr_api.g_number) then

389: If (p_rec.component_value = hr_api.g_varchar2) then
390: p_rec.component_value :=
391: hxc_ulc_shd.g_old_rec.component_value;
392: End If;
393: If (p_rec.sequence = hr_api.g_number) then
394: p_rec.sequence :=
395: hxc_ulc_shd.g_old_rec.sequence;
396: End If;
397: If (p_rec.name_value_string = hr_api.g_varchar2) then

Line 397: If (p_rec.name_value_string = hr_api.g_varchar2) then

393: If (p_rec.sequence = hr_api.g_number) then
394: p_rec.sequence :=
395: hxc_ulc_shd.g_old_rec.sequence;
396: End If;
397: If (p_rec.name_value_string = hr_api.g_varchar2) then
398: p_rec.name_value_string :=
399: hxc_ulc_shd.g_old_rec.name_value_string;
400: End If;
401: If (p_rec.region_code = hr_api.g_varchar2) then

Line 401: If (p_rec.region_code = hr_api.g_varchar2) then

397: If (p_rec.name_value_string = hr_api.g_varchar2) then
398: p_rec.name_value_string :=
399: hxc_ulc_shd.g_old_rec.name_value_string;
400: End If;
401: If (p_rec.region_code = hr_api.g_varchar2) then
402: p_rec.region_code :=
403: hxc_ulc_shd.g_old_rec.region_code;
404: End If;
405: If (p_rec.region_code_app_id = hr_api.g_number) then

Line 405: If (p_rec.region_code_app_id = hr_api.g_number) then

401: If (p_rec.region_code = hr_api.g_varchar2) then
402: p_rec.region_code :=
403: hxc_ulc_shd.g_old_rec.region_code;
404: End If;
405: If (p_rec.region_code_app_id = hr_api.g_number) then
406: p_rec.region_code_app_id :=
407: hxc_ulc_shd.g_old_rec.region_code_app_id;
408: End If;
409: If (p_rec.attribute_code = hr_api.g_varchar2) then

Line 409: If (p_rec.attribute_code = hr_api.g_varchar2) then

405: If (p_rec.region_code_app_id = hr_api.g_number) then
406: p_rec.region_code_app_id :=
407: hxc_ulc_shd.g_old_rec.region_code_app_id;
408: End If;
409: If (p_rec.attribute_code = hr_api.g_varchar2) then
410: p_rec.attribute_code :=
411: hxc_ulc_shd.g_old_rec.attribute_code;
412: End If;
413: If (p_rec.attribute_code_app_id = hr_api.g_number) then

Line 413: If (p_rec.attribute_code_app_id = hr_api.g_number) then

409: If (p_rec.attribute_code = hr_api.g_varchar2) then
410: p_rec.attribute_code :=
411: hxc_ulc_shd.g_old_rec.attribute_code;
412: End If;
413: If (p_rec.attribute_code_app_id = hr_api.g_number) then
414: p_rec.attribute_code_app_id :=
415: hxc_ulc_shd.g_old_rec.attribute_code_app_id;
416: End If;
417: If (p_rec.component_alias = hr_api.g_varchar2) then

Line 417: If (p_rec.component_alias = hr_api.g_varchar2) then

413: If (p_rec.attribute_code_app_id = hr_api.g_number) then
414: p_rec.attribute_code_app_id :=
415: hxc_ulc_shd.g_old_rec.attribute_code_app_id;
416: End If;
417: If (p_rec.component_alias = hr_api.g_varchar2) then
418: p_rec.component_alias :=
419: hxc_ulc_shd.g_old_rec.component_alias;
420: End If;
421: If (p_rec.parent_bean = hr_api.g_varchar2) then

Line 421: If (p_rec.parent_bean = hr_api.g_varchar2) then

417: If (p_rec.component_alias = hr_api.g_varchar2) then
418: p_rec.component_alias :=
419: hxc_ulc_shd.g_old_rec.component_alias;
420: End If;
421: If (p_rec.parent_bean = hr_api.g_varchar2) then
422: p_rec.parent_bean :=
423: hxc_ulc_shd.g_old_rec.parent_bean;
424: End If;
425: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 425: If (p_rec.attribute1 = hr_api.g_varchar2) then

421: If (p_rec.parent_bean = hr_api.g_varchar2) then
422: p_rec.parent_bean :=
423: hxc_ulc_shd.g_old_rec.parent_bean;
424: End If;
425: If (p_rec.attribute1 = hr_api.g_varchar2) then
426: p_rec.attribute1 :=
427: hxc_ulc_shd.g_old_rec.attribute1;
428: End If;
429: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 429: If (p_rec.attribute2 = hr_api.g_varchar2) then

425: If (p_rec.attribute1 = hr_api.g_varchar2) then
426: p_rec.attribute1 :=
427: hxc_ulc_shd.g_old_rec.attribute1;
428: End If;
429: If (p_rec.attribute2 = hr_api.g_varchar2) then
430: p_rec.attribute2 :=
431: hxc_ulc_shd.g_old_rec.attribute2;
432: End If;
433: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 433: If (p_rec.attribute3 = hr_api.g_varchar2) then

429: If (p_rec.attribute2 = hr_api.g_varchar2) then
430: p_rec.attribute2 :=
431: hxc_ulc_shd.g_old_rec.attribute2;
432: End If;
433: If (p_rec.attribute3 = hr_api.g_varchar2) then
434: p_rec.attribute3 :=
435: hxc_ulc_shd.g_old_rec.attribute3;
436: End If;
437: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 437: If (p_rec.attribute4 = hr_api.g_varchar2) then

433: If (p_rec.attribute3 = hr_api.g_varchar2) then
434: p_rec.attribute3 :=
435: hxc_ulc_shd.g_old_rec.attribute3;
436: End If;
437: If (p_rec.attribute4 = hr_api.g_varchar2) then
438: p_rec.attribute4 :=
439: hxc_ulc_shd.g_old_rec.attribute4;
440: End If;
441: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 441: If (p_rec.attribute5 = hr_api.g_varchar2) then

437: If (p_rec.attribute4 = hr_api.g_varchar2) then
438: p_rec.attribute4 :=
439: hxc_ulc_shd.g_old_rec.attribute4;
440: End If;
441: If (p_rec.attribute5 = hr_api.g_varchar2) then
442: p_rec.attribute5 :=
443: hxc_ulc_shd.g_old_rec.attribute5;
444: End If;
445: --

Line 503: ,p_layout_id in number default hr_api.g_number

499: -- ----------------------------------------------------------------------------
500: Procedure upd
501: (p_layout_component_id in number
502: ,p_object_version_number in out nocopy number
503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2

Line 504: ,p_parent_component_id in number default hr_api.g_number

500: Procedure upd
501: (p_layout_component_id in number
502: ,p_object_version_number in out nocopy number
503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2

Line 505: ,p_sequence in number default hr_api.g_number

501: (p_layout_component_id in number
502: ,p_object_version_number in out nocopy number
503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2

Line 506: ,p_component_name in varchar2 default hr_api.g_varchar2

502: ,p_object_version_number in out nocopy number
503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number

Line 507: ,p_component_value in varchar2 default hr_api.g_varchar2

503: ,p_layout_id in number default hr_api.g_number
504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2

Line 508: ,p_name_value_string in varchar2 default hr_api.g_varchar2

504: ,p_parent_component_id in number default hr_api.g_number
505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number

Line 509: ,p_region_code in varchar2 default hr_api.g_varchar2

505: ,p_sequence in number default hr_api.g_number
506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number

Line 510: ,p_region_code_app_id in number default hr_api.g_number

506: ,p_component_name in varchar2 default hr_api.g_varchar2
507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2

Line 511: ,p_attribute_code in varchar2 default hr_api.g_varchar2

507: ,p_component_value in varchar2 default hr_api.g_varchar2
508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2

Line 512: ,p_attribute_code_app_id in number default hr_api.g_number

508: ,p_name_value_string in varchar2 default hr_api.g_varchar2
509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 513: ,p_layout_comp_definition_id in number default hr_api.g_number

509: ,p_region_code in varchar2 default hr_api.g_varchar2
510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 514: ,p_component_alias in varchar2 default hr_api.g_varchar2

510: ,p_region_code_app_id in number default hr_api.g_number
511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 515: ,p_parent_bean in varchar2 default hr_api.g_varchar2

511: ,p_attribute_code in varchar2 default hr_api.g_varchar2
512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 516: ,p_attribute1 in varchar2 default hr_api.g_varchar2

512: ,p_attribute_code_app_id in number default hr_api.g_number
513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 517: ,p_attribute2 in varchar2 default hr_api.g_varchar2

513: ,p_layout_comp_definition_id in number default hr_api.g_number
514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
521: ) is

Line 518: ,p_attribute3 in varchar2 default hr_api.g_varchar2

514: ,p_component_alias in varchar2 default hr_api.g_varchar2
515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
521: ) is
522: --

Line 519: ,p_attribute4 in varchar2 default hr_api.g_varchar2

515: ,p_parent_bean in varchar2 default hr_api.g_varchar2
516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
521: ) is
522: --
523: l_rec hxc_ulc_shd.g_rec_type;

Line 520: ,p_attribute5 in varchar2 default hr_api.g_varchar2

516: ,p_attribute1 in varchar2 default hr_api.g_varchar2
517: ,p_attribute2 in varchar2 default hr_api.g_varchar2
518: ,p_attribute3 in varchar2 default hr_api.g_varchar2
519: ,p_attribute4 in varchar2 default hr_api.g_varchar2
520: ,p_attribute5 in varchar2 default hr_api.g_varchar2
521: ) is
522: --
523: l_rec hxc_ulc_shd.g_rec_type;
524: l_proc varchar2(72) ;