DBA Data[Home] [Help]

APPS.PER_ENT_UPD dependencies on HR_API

Line 96: When hr_api.check_integrity_violated Then

92: --
93: hr_utility.set_location(' Leaving:'||l_proc, 10);
94: --
95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: --
99: per_ent_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: --
99: per_ent_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: --
104: per_ent_shd.constraint_error

Line 101: When hr_api.parent_integrity_violated Then

97: -- A check constraint has been violated
98: --
99: per_ent_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: --
104: per_ent_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: --
104: per_ent_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --
109: per_ent_shd.constraint_error

Line 106: When hr_api.unique_integrity_violated Then

102: -- Parent integrity has been violated
103: --
104: per_ent_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --
109: per_ent_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --
109: per_ent_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;
114: End update_dml;

Line 272: when hr_api.cannot_find_prog_unit then

268: );
269: --
270: exception
271: --
272: when hr_api.cannot_find_prog_unit then
273: --
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'PER_CALENDAR_ENTRIES'
276: ,p_hook_type => 'AU');

Line 274: hr_api.cannot_find_prog_unit_error

270: exception
271: --
272: when hr_api.cannot_find_prog_unit then
273: --
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'PER_CALENDAR_ENTRIES'
276: ,p_hook_type => 'AU');
277: --
278: end;

Line 337: If (p_rec.business_group_id = hr_api.g_number) then

333: -- p_rec plsql record structure
334: -- to see if a system default is being used. If a system default
335: -- is being used then we must set to the 'current' argument value.
336: --
337: If (p_rec.business_group_id = hr_api.g_number) then
338: p_rec.business_group_id :=
339: per_ent_shd.g_old_rec.business_group_id;
340: End If;
341: If (p_rec.name = hr_api.g_varchar2) then

Line 341: If (p_rec.name = hr_api.g_varchar2) then

337: If (p_rec.business_group_id = hr_api.g_number) then
338: p_rec.business_group_id :=
339: per_ent_shd.g_old_rec.business_group_id;
340: End If;
341: If (p_rec.name = hr_api.g_varchar2) then
342: p_rec.name :=
343: per_ent_shd.g_old_rec.name;
344: End If;
345: If (p_rec.type = hr_api.g_varchar2) then

Line 345: If (p_rec.type = hr_api.g_varchar2) then

341: If (p_rec.name = hr_api.g_varchar2) then
342: p_rec.name :=
343: per_ent_shd.g_old_rec.name;
344: End If;
345: If (p_rec.type = hr_api.g_varchar2) then
346: p_rec.type :=
347: per_ent_shd.g_old_rec.type;
348: End If;
349: If (p_rec.start_date = hr_api.g_date) then

Line 349: If (p_rec.start_date = hr_api.g_date) then

345: If (p_rec.type = hr_api.g_varchar2) then
346: p_rec.type :=
347: per_ent_shd.g_old_rec.type;
348: End If;
349: If (p_rec.start_date = hr_api.g_date) then
350: p_rec.start_date :=
351: per_ent_shd.g_old_rec.start_date;
352: End If;
353: If (p_rec.start_hour = hr_api.g_varchar2) then

Line 353: If (p_rec.start_hour = hr_api.g_varchar2) then

349: If (p_rec.start_date = hr_api.g_date) then
350: p_rec.start_date :=
351: per_ent_shd.g_old_rec.start_date;
352: End If;
353: If (p_rec.start_hour = hr_api.g_varchar2) then
354: p_rec.start_hour :=
355: per_ent_shd.g_old_rec.start_hour;
356: End If;
357: If (p_rec.start_min = hr_api.g_varchar2) then

Line 357: If (p_rec.start_min = hr_api.g_varchar2) then

353: If (p_rec.start_hour = hr_api.g_varchar2) then
354: p_rec.start_hour :=
355: per_ent_shd.g_old_rec.start_hour;
356: End If;
357: If (p_rec.start_min = hr_api.g_varchar2) then
358: p_rec.start_min :=
359: per_ent_shd.g_old_rec.start_min;
360: End If;
361: If (p_rec.end_date = hr_api.g_date) then

Line 361: If (p_rec.end_date = hr_api.g_date) then

357: If (p_rec.start_min = hr_api.g_varchar2) then
358: p_rec.start_min :=
359: per_ent_shd.g_old_rec.start_min;
360: End If;
361: If (p_rec.end_date = hr_api.g_date) then
362: p_rec.end_date :=
363: per_ent_shd.g_old_rec.end_date;
364: End If;
365: If (p_rec.end_hour = hr_api.g_varchar2) then

Line 365: If (p_rec.end_hour = hr_api.g_varchar2) then

361: If (p_rec.end_date = hr_api.g_date) then
362: p_rec.end_date :=
363: per_ent_shd.g_old_rec.end_date;
364: End If;
365: If (p_rec.end_hour = hr_api.g_varchar2) then
366: p_rec.end_hour :=
367: per_ent_shd.g_old_rec.end_hour;
368: End If;
369: If (p_rec.end_min = hr_api.g_varchar2) then

Line 369: If (p_rec.end_min = hr_api.g_varchar2) then

365: If (p_rec.end_hour = hr_api.g_varchar2) then
366: p_rec.end_hour :=
367: per_ent_shd.g_old_rec.end_hour;
368: End If;
369: If (p_rec.end_min = hr_api.g_varchar2) then
370: p_rec.end_min :=
371: per_ent_shd.g_old_rec.end_min;
372: End If;
373: If (p_rec.description = hr_api.g_varchar2) then

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

369: If (p_rec.end_min = hr_api.g_varchar2) then
370: p_rec.end_min :=
371: per_ent_shd.g_old_rec.end_min;
372: End If;
373: If (p_rec.description = hr_api.g_varchar2) then
374: p_rec.description :=
375: per_ent_shd.g_old_rec.description;
376: End If;
377: If (p_rec.hierarchy_id = hr_api.g_number) then

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

373: If (p_rec.description = hr_api.g_varchar2) then
374: p_rec.description :=
375: per_ent_shd.g_old_rec.description;
376: End If;
377: If (p_rec.hierarchy_id = hr_api.g_number) then
378: p_rec.hierarchy_id :=
379: per_ent_shd.g_old_rec.hierarchy_id;
380: End If;
381: If (p_rec.value_set_id = hr_api.g_number) then

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

377: If (p_rec.hierarchy_id = hr_api.g_number) then
378: p_rec.hierarchy_id :=
379: per_ent_shd.g_old_rec.hierarchy_id;
380: End If;
381: If (p_rec.value_set_id = hr_api.g_number) then
382: p_rec.value_set_id :=
383: per_ent_shd.g_old_rec.value_set_id;
384: End If;
385: If (p_rec.organization_structure_id = hr_api.g_number) then

Line 385: If (p_rec.organization_structure_id = hr_api.g_number) then

381: If (p_rec.value_set_id = hr_api.g_number) then
382: p_rec.value_set_id :=
383: per_ent_shd.g_old_rec.value_set_id;
384: End If;
385: If (p_rec.organization_structure_id = hr_api.g_number) then
386: p_rec.organization_structure_id :=
387: per_ent_shd.g_old_rec.organization_structure_id;
388: End If;
389: If (p_rec.org_structure_version_id = hr_api.g_number) then

Line 389: If (p_rec.org_structure_version_id = hr_api.g_number) then

385: If (p_rec.organization_structure_id = hr_api.g_number) then
386: p_rec.organization_structure_id :=
387: per_ent_shd.g_old_rec.organization_structure_id;
388: End If;
389: If (p_rec.org_structure_version_id = hr_api.g_number) then
390: p_rec.org_structure_version_id :=
391: per_ent_shd.g_old_rec.org_structure_version_id;
392: End If;
393: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 393: If (p_rec.legislation_code = hr_api.g_varchar2) then

389: If (p_rec.org_structure_version_id = hr_api.g_number) then
390: p_rec.org_structure_version_id :=
391: per_ent_shd.g_old_rec.org_structure_version_id;
392: End If;
393: If (p_rec.legislation_code = hr_api.g_varchar2) then
394: p_rec.legislation_code :=
395: per_ent_shd.g_old_rec.legislation_code;
396: End If;
397: If (p_rec.identifier_key = hr_api.g_varchar2) then

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

393: If (p_rec.legislation_code = hr_api.g_varchar2) then
394: p_rec.legislation_code :=
395: per_ent_shd.g_old_rec.legislation_code;
396: End If;
397: If (p_rec.identifier_key = hr_api.g_varchar2) then
398: p_rec.identifier_key :=
399: per_ent_shd.g_old_rec.identifier_key;
400: End If;
401: --

Line 465: ,p_name in varchar2 default hr_api.g_varchar2

461: Procedure upd
462: (p_effective_date in date
463: ,p_calendar_entry_id in number
464: ,p_object_version_number in out nocopy number
465: ,p_name in varchar2 default hr_api.g_varchar2
466: ,p_type in varchar2 default hr_api.g_varchar2
467: ,p_start_date in date default hr_api.g_date
468: ,p_start_hour in varchar2 default hr_api.g_varchar2
469: ,p_start_min in varchar2 default hr_api.g_varchar2

Line 466: ,p_type in varchar2 default hr_api.g_varchar2

462: (p_effective_date in date
463: ,p_calendar_entry_id in number
464: ,p_object_version_number in out nocopy number
465: ,p_name in varchar2 default hr_api.g_varchar2
466: ,p_type in varchar2 default hr_api.g_varchar2
467: ,p_start_date in date default hr_api.g_date
468: ,p_start_hour in varchar2 default hr_api.g_varchar2
469: ,p_start_min in varchar2 default hr_api.g_varchar2
470: ,p_end_date in date default hr_api.g_date

Line 467: ,p_start_date in date default hr_api.g_date

463: ,p_calendar_entry_id in number
464: ,p_object_version_number in out nocopy number
465: ,p_name in varchar2 default hr_api.g_varchar2
466: ,p_type in varchar2 default hr_api.g_varchar2
467: ,p_start_date in date default hr_api.g_date
468: ,p_start_hour in varchar2 default hr_api.g_varchar2
469: ,p_start_min in varchar2 default hr_api.g_varchar2
470: ,p_end_date in date default hr_api.g_date
471: ,p_end_hour in varchar2 default hr_api.g_varchar2

Line 468: ,p_start_hour in varchar2 default hr_api.g_varchar2

464: ,p_object_version_number in out nocopy number
465: ,p_name in varchar2 default hr_api.g_varchar2
466: ,p_type in varchar2 default hr_api.g_varchar2
467: ,p_start_date in date default hr_api.g_date
468: ,p_start_hour in varchar2 default hr_api.g_varchar2
469: ,p_start_min in varchar2 default hr_api.g_varchar2
470: ,p_end_date in date default hr_api.g_date
471: ,p_end_hour in varchar2 default hr_api.g_varchar2
472: ,p_end_min in varchar2 default hr_api.g_varchar2

Line 469: ,p_start_min in varchar2 default hr_api.g_varchar2

465: ,p_name in varchar2 default hr_api.g_varchar2
466: ,p_type in varchar2 default hr_api.g_varchar2
467: ,p_start_date in date default hr_api.g_date
468: ,p_start_hour in varchar2 default hr_api.g_varchar2
469: ,p_start_min in varchar2 default hr_api.g_varchar2
470: ,p_end_date in date default hr_api.g_date
471: ,p_end_hour in varchar2 default hr_api.g_varchar2
472: ,p_end_min in varchar2 default hr_api.g_varchar2
473: ,p_description in varchar2 default hr_api.g_varchar2

Line 470: ,p_end_date in date default hr_api.g_date

466: ,p_type in varchar2 default hr_api.g_varchar2
467: ,p_start_date in date default hr_api.g_date
468: ,p_start_hour in varchar2 default hr_api.g_varchar2
469: ,p_start_min in varchar2 default hr_api.g_varchar2
470: ,p_end_date in date default hr_api.g_date
471: ,p_end_hour in varchar2 default hr_api.g_varchar2
472: ,p_end_min in varchar2 default hr_api.g_varchar2
473: ,p_description in varchar2 default hr_api.g_varchar2
474: ,p_hierarchy_id in number default hr_api.g_number

Line 471: ,p_end_hour in varchar2 default hr_api.g_varchar2

467: ,p_start_date in date default hr_api.g_date
468: ,p_start_hour in varchar2 default hr_api.g_varchar2
469: ,p_start_min in varchar2 default hr_api.g_varchar2
470: ,p_end_date in date default hr_api.g_date
471: ,p_end_hour in varchar2 default hr_api.g_varchar2
472: ,p_end_min in varchar2 default hr_api.g_varchar2
473: ,p_description in varchar2 default hr_api.g_varchar2
474: ,p_hierarchy_id in number default hr_api.g_number
475: ,p_value_set_id in number default hr_api.g_number

Line 472: ,p_end_min in varchar2 default hr_api.g_varchar2

468: ,p_start_hour in varchar2 default hr_api.g_varchar2
469: ,p_start_min in varchar2 default hr_api.g_varchar2
470: ,p_end_date in date default hr_api.g_date
471: ,p_end_hour in varchar2 default hr_api.g_varchar2
472: ,p_end_min in varchar2 default hr_api.g_varchar2
473: ,p_description in varchar2 default hr_api.g_varchar2
474: ,p_hierarchy_id in number default hr_api.g_number
475: ,p_value_set_id in number default hr_api.g_number
476: ,p_organization_structure_id in number default hr_api.g_number

Line 473: ,p_description in varchar2 default hr_api.g_varchar2

469: ,p_start_min in varchar2 default hr_api.g_varchar2
470: ,p_end_date in date default hr_api.g_date
471: ,p_end_hour in varchar2 default hr_api.g_varchar2
472: ,p_end_min in varchar2 default hr_api.g_varchar2
473: ,p_description in varchar2 default hr_api.g_varchar2
474: ,p_hierarchy_id in number default hr_api.g_number
475: ,p_value_set_id in number default hr_api.g_number
476: ,p_organization_structure_id in number default hr_api.g_number
477: ,p_org_structure_version_id in number default hr_api.g_number

Line 474: ,p_hierarchy_id in number default hr_api.g_number

470: ,p_end_date in date default hr_api.g_date
471: ,p_end_hour in varchar2 default hr_api.g_varchar2
472: ,p_end_min in varchar2 default hr_api.g_varchar2
473: ,p_description in varchar2 default hr_api.g_varchar2
474: ,p_hierarchy_id in number default hr_api.g_number
475: ,p_value_set_id in number default hr_api.g_number
476: ,p_organization_structure_id in number default hr_api.g_number
477: ,p_org_structure_version_id in number default hr_api.g_number
478: ,p_business_group_id in number default null

Line 475: ,p_value_set_id in number default hr_api.g_number

471: ,p_end_hour in varchar2 default hr_api.g_varchar2
472: ,p_end_min in varchar2 default hr_api.g_varchar2
473: ,p_description in varchar2 default hr_api.g_varchar2
474: ,p_hierarchy_id in number default hr_api.g_number
475: ,p_value_set_id in number default hr_api.g_number
476: ,p_organization_structure_id in number default hr_api.g_number
477: ,p_org_structure_version_id in number default hr_api.g_number
478: ,p_business_group_id in number default null
479: ) is

Line 476: ,p_organization_structure_id in number default hr_api.g_number

472: ,p_end_min in varchar2 default hr_api.g_varchar2
473: ,p_description in varchar2 default hr_api.g_varchar2
474: ,p_hierarchy_id in number default hr_api.g_number
475: ,p_value_set_id in number default hr_api.g_number
476: ,p_organization_structure_id in number default hr_api.g_number
477: ,p_org_structure_version_id in number default hr_api.g_number
478: ,p_business_group_id in number default null
479: ) is
480: --

Line 477: ,p_org_structure_version_id in number default hr_api.g_number

473: ,p_description in varchar2 default hr_api.g_varchar2
474: ,p_hierarchy_id in number default hr_api.g_number
475: ,p_value_set_id in number default hr_api.g_number
476: ,p_organization_structure_id in number default hr_api.g_number
477: ,p_org_structure_version_id in number default hr_api.g_number
478: ,p_business_group_id in number default null
479: ) is
480: --
481: l_rec per_ent_shd.g_rec_type;

Line 507: ,hr_api.g_varchar2

503: ,p_hierarchy_id
504: ,p_value_set_id
505: ,p_organization_structure_id
506: ,p_org_structure_version_id
507: ,hr_api.g_varchar2
508: ,hr_api.g_varchar2
509: ,p_object_version_number
510: );
511: --

Line 508: ,hr_api.g_varchar2

504: ,p_value_set_id
505: ,p_organization_structure_id
506: ,p_org_structure_version_id
507: ,hr_api.g_varchar2
508: ,hr_api.g_varchar2
509: ,p_object_version_number
510: );
511: --
512: -- Having converted the arguments into the