DBA Data[Home] [Help]

APPS.PAY_TDF_UPD dependencies on HR_API

Line 95: When hr_api.check_integrity_violated Then

91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
98: pay_tdf_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
98: pay_tdf_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
103: pay_tdf_shd.constraint_error

Line 100: When hr_api.parent_integrity_violated Then

96: -- A check constraint has been violated
97: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
98: pay_tdf_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
103: pay_tdf_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
103: pay_tdf_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
108: pay_tdf_shd.constraint_error

Line 105: When hr_api.unique_integrity_violated Then

101: -- Parent integrity has been violated
102: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
103: pay_tdf_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
108: pay_tdf_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
108: pay_tdf_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End update_dml;

Line 270: when hr_api.cannot_find_prog_unit then

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

Line 272: hr_api.cannot_find_prog_unit_error

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

Line 335: If (p_rec.short_name = hr_api.g_varchar2) then

331: -- p_rec plsql record structure
332: -- to see if a system default is being used. If a system default
333: -- is being used then we must set to the 'current' argument value.
334: --
335: If (p_rec.short_name = hr_api.g_varchar2) then
336: p_rec.short_name :=
337: pay_tdf_shd.g_old_rec.short_name;
338: End If;
339: If (p_rec.definition_name = hr_api.g_varchar2) then

Line 339: If (p_rec.definition_name = hr_api.g_varchar2) then

335: If (p_rec.short_name = hr_api.g_varchar2) then
336: p_rec.short_name :=
337: pay_tdf_shd.g_old_rec.short_name;
338: End If;
339: If (p_rec.definition_name = hr_api.g_varchar2) then
340: p_rec.definition_name :=
341: pay_tdf_shd.g_old_rec.definition_name;
342: End If;
343: If (p_rec.period_type = hr_api.g_varchar2) then

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

339: If (p_rec.definition_name = hr_api.g_varchar2) then
340: p_rec.definition_name :=
341: pay_tdf_shd.g_old_rec.definition_name;
342: End If;
343: If (p_rec.period_type = hr_api.g_varchar2) then
344: p_rec.period_type :=
345: pay_tdf_shd.g_old_rec.period_type;
346: End If;
347: If (p_rec.period_unit = hr_api.g_varchar2) then

Line 347: If (p_rec.period_unit = hr_api.g_varchar2) then

343: If (p_rec.period_type = hr_api.g_varchar2) then
344: p_rec.period_type :=
345: pay_tdf_shd.g_old_rec.period_type;
346: End If;
347: If (p_rec.period_unit = hr_api.g_varchar2) then
348: p_rec.period_unit :=
349: pay_tdf_shd.g_old_rec.period_unit;
350: End If;
351: If (p_rec.day_adjustment = hr_api.g_varchar2) then

Line 351: If (p_rec.day_adjustment = hr_api.g_varchar2) then

347: If (p_rec.period_unit = hr_api.g_varchar2) then
348: p_rec.period_unit :=
349: pay_tdf_shd.g_old_rec.period_unit;
350: End If;
351: If (p_rec.day_adjustment = hr_api.g_varchar2) then
352: p_rec.day_adjustment :=
353: pay_tdf_shd.g_old_rec.day_adjustment;
354: End If;
355: If (p_rec.dynamic_code = hr_api.g_varchar2) then

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

351: If (p_rec.day_adjustment = hr_api.g_varchar2) then
352: p_rec.day_adjustment :=
353: pay_tdf_shd.g_old_rec.day_adjustment;
354: End If;
355: If (p_rec.dynamic_code = hr_api.g_varchar2) then
356: p_rec.dynamic_code :=
357: pay_tdf_shd.g_old_rec.dynamic_code;
358: End If;
359: If (p_rec.business_group_id = hr_api.g_number) then

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

355: If (p_rec.dynamic_code = hr_api.g_varchar2) then
356: p_rec.dynamic_code :=
357: pay_tdf_shd.g_old_rec.dynamic_code;
358: End If;
359: If (p_rec.business_group_id = hr_api.g_number) then
360: p_rec.business_group_id :=
361: pay_tdf_shd.g_old_rec.business_group_id;
362: End If;
363: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

359: If (p_rec.business_group_id = hr_api.g_number) then
360: p_rec.business_group_id :=
361: pay_tdf_shd.g_old_rec.business_group_id;
362: End If;
363: If (p_rec.legislation_code = hr_api.g_varchar2) then
364: p_rec.legislation_code :=
365: pay_tdf_shd.g_old_rec.legislation_code;
366: End If;
367: If (p_rec.definition_type = hr_api.g_varchar2) then

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

363: If (p_rec.legislation_code = hr_api.g_varchar2) then
364: p_rec.legislation_code :=
365: pay_tdf_shd.g_old_rec.legislation_code;
366: End If;
367: If (p_rec.definition_type = hr_api.g_varchar2) then
368: p_rec.definition_type :=
369: pay_tdf_shd.g_old_rec.definition_type;
370: End If;
371: If (p_rec.number_of_years = hr_api.g_number) then

Line 371: If (p_rec.number_of_years = hr_api.g_number) then

367: If (p_rec.definition_type = hr_api.g_varchar2) then
368: p_rec.definition_type :=
369: pay_tdf_shd.g_old_rec.definition_type;
370: End If;
371: If (p_rec.number_of_years = hr_api.g_number) then
372: p_rec.number_of_years :=
373: pay_tdf_shd.g_old_rec.number_of_years;
374: End If;
375: If (p_rec.start_date = hr_api.g_date) then

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

371: If (p_rec.number_of_years = hr_api.g_number) then
372: p_rec.number_of_years :=
373: pay_tdf_shd.g_old_rec.number_of_years;
374: End If;
375: If (p_rec.start_date = hr_api.g_date) then
376: p_rec.start_date :=
377: pay_tdf_shd.g_old_rec.start_date;
378: End If;
379: If (p_rec.period_time_definition_id = hr_api.g_number) then

Line 379: If (p_rec.period_time_definition_id = hr_api.g_number) then

375: If (p_rec.start_date = hr_api.g_date) then
376: p_rec.start_date :=
377: pay_tdf_shd.g_old_rec.start_date;
378: End If;
379: If (p_rec.period_time_definition_id = hr_api.g_number) then
380: p_rec.period_time_definition_id :=
381: pay_tdf_shd.g_old_rec.period_time_definition_id;
382: End If;
383: If (p_rec.creator_id = hr_api.g_number) then

Line 383: If (p_rec.creator_id = hr_api.g_number) then

379: If (p_rec.period_time_definition_id = hr_api.g_number) then
380: p_rec.period_time_definition_id :=
381: pay_tdf_shd.g_old_rec.period_time_definition_id;
382: End If;
383: If (p_rec.creator_id = hr_api.g_number) then
384: p_rec.creator_id :=
385: pay_tdf_shd.g_old_rec.creator_id;
386: End If;
387: If (p_rec.creator_type = hr_api.g_varchar2) then

Line 387: If (p_rec.creator_type = hr_api.g_varchar2) then

383: If (p_rec.creator_id = hr_api.g_number) then
384: p_rec.creator_id :=
385: pay_tdf_shd.g_old_rec.creator_id;
386: End If;
387: If (p_rec.creator_type = hr_api.g_varchar2) then
388: p_rec.creator_type :=
389: pay_tdf_shd.g_old_rec.creator_type;
390: End If;
391: --

Line 461: ,p_short_name in varchar2 default hr_api.g_varchar2

457: ,p_time_definition_id in number
458: ,p_object_version_number in out nocopy number
459: ,p_regenerate_periods out nocopy boolean
460: ,p_delete_periods out nocopy boolean
461: ,p_short_name in varchar2 default hr_api.g_varchar2
462: ,p_definition_name in varchar2 default hr_api.g_varchar2
463: ,p_period_type in varchar2 default hr_api.g_varchar2
464: ,p_period_unit in varchar2 default hr_api.g_varchar2
465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2

Line 462: ,p_definition_name in varchar2 default hr_api.g_varchar2

458: ,p_object_version_number in out nocopy number
459: ,p_regenerate_periods out nocopy boolean
460: ,p_delete_periods out nocopy boolean
461: ,p_short_name in varchar2 default hr_api.g_varchar2
462: ,p_definition_name in varchar2 default hr_api.g_varchar2
463: ,p_period_type in varchar2 default hr_api.g_varchar2
464: ,p_period_unit in varchar2 default hr_api.g_varchar2
465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2

Line 463: ,p_period_type in varchar2 default hr_api.g_varchar2

459: ,p_regenerate_periods out nocopy boolean
460: ,p_delete_periods out nocopy boolean
461: ,p_short_name in varchar2 default hr_api.g_varchar2
462: ,p_definition_name in varchar2 default hr_api.g_varchar2
463: ,p_period_type in varchar2 default hr_api.g_varchar2
464: ,p_period_unit in varchar2 default hr_api.g_varchar2
465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
467: ,p_business_group_id in number default hr_api.g_number

Line 464: ,p_period_unit in varchar2 default hr_api.g_varchar2

460: ,p_delete_periods out nocopy boolean
461: ,p_short_name in varchar2 default hr_api.g_varchar2
462: ,p_definition_name in varchar2 default hr_api.g_varchar2
463: ,p_period_type in varchar2 default hr_api.g_varchar2
464: ,p_period_unit in varchar2 default hr_api.g_varchar2
465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
467: ,p_business_group_id in number default hr_api.g_number
468: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2

461: ,p_short_name in varchar2 default hr_api.g_varchar2
462: ,p_definition_name in varchar2 default hr_api.g_varchar2
463: ,p_period_type in varchar2 default hr_api.g_varchar2
464: ,p_period_unit in varchar2 default hr_api.g_varchar2
465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
467: ,p_business_group_id in number default hr_api.g_number
468: ,p_legislation_code in varchar2 default hr_api.g_varchar2
469: ,p_definition_type in varchar2 default hr_api.g_varchar2

Line 466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2

462: ,p_definition_name in varchar2 default hr_api.g_varchar2
463: ,p_period_type in varchar2 default hr_api.g_varchar2
464: ,p_period_unit in varchar2 default hr_api.g_varchar2
465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
467: ,p_business_group_id in number default hr_api.g_number
468: ,p_legislation_code in varchar2 default hr_api.g_varchar2
469: ,p_definition_type in varchar2 default hr_api.g_varchar2
470: ,p_number_of_years in number default hr_api.g_number

Line 467: ,p_business_group_id in number default hr_api.g_number

463: ,p_period_type in varchar2 default hr_api.g_varchar2
464: ,p_period_unit in varchar2 default hr_api.g_varchar2
465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
467: ,p_business_group_id in number default hr_api.g_number
468: ,p_legislation_code in varchar2 default hr_api.g_varchar2
469: ,p_definition_type in varchar2 default hr_api.g_varchar2
470: ,p_number_of_years in number default hr_api.g_number
471: ,p_start_date in date default hr_api.g_date

Line 468: ,p_legislation_code in varchar2 default hr_api.g_varchar2

464: ,p_period_unit in varchar2 default hr_api.g_varchar2
465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
467: ,p_business_group_id in number default hr_api.g_number
468: ,p_legislation_code in varchar2 default hr_api.g_varchar2
469: ,p_definition_type in varchar2 default hr_api.g_varchar2
470: ,p_number_of_years in number default hr_api.g_number
471: ,p_start_date in date default hr_api.g_date
472: ,p_period_time_definition_id in number default hr_api.g_number

Line 469: ,p_definition_type in varchar2 default hr_api.g_varchar2

465: ,p_day_adjustment in varchar2 default hr_api.g_varchar2
466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
467: ,p_business_group_id in number default hr_api.g_number
468: ,p_legislation_code in varchar2 default hr_api.g_varchar2
469: ,p_definition_type in varchar2 default hr_api.g_varchar2
470: ,p_number_of_years in number default hr_api.g_number
471: ,p_start_date in date default hr_api.g_date
472: ,p_period_time_definition_id in number default hr_api.g_number
473: ,p_creator_id in number default hr_api.g_number

Line 470: ,p_number_of_years in number default hr_api.g_number

466: ,p_dynamic_code in varchar2 default hr_api.g_varchar2
467: ,p_business_group_id in number default hr_api.g_number
468: ,p_legislation_code in varchar2 default hr_api.g_varchar2
469: ,p_definition_type in varchar2 default hr_api.g_varchar2
470: ,p_number_of_years in number default hr_api.g_number
471: ,p_start_date in date default hr_api.g_date
472: ,p_period_time_definition_id in number default hr_api.g_number
473: ,p_creator_id in number default hr_api.g_number
474: ,p_creator_type in varchar2 default hr_api.g_varchar2

Line 471: ,p_start_date in date default hr_api.g_date

467: ,p_business_group_id in number default hr_api.g_number
468: ,p_legislation_code in varchar2 default hr_api.g_varchar2
469: ,p_definition_type in varchar2 default hr_api.g_varchar2
470: ,p_number_of_years in number default hr_api.g_number
471: ,p_start_date in date default hr_api.g_date
472: ,p_period_time_definition_id in number default hr_api.g_number
473: ,p_creator_id in number default hr_api.g_number
474: ,p_creator_type in varchar2 default hr_api.g_varchar2
475: ) is

Line 472: ,p_period_time_definition_id in number default hr_api.g_number

468: ,p_legislation_code in varchar2 default hr_api.g_varchar2
469: ,p_definition_type in varchar2 default hr_api.g_varchar2
470: ,p_number_of_years in number default hr_api.g_number
471: ,p_start_date in date default hr_api.g_date
472: ,p_period_time_definition_id in number default hr_api.g_number
473: ,p_creator_id in number default hr_api.g_number
474: ,p_creator_type in varchar2 default hr_api.g_varchar2
475: ) is
476: --

Line 473: ,p_creator_id in number default hr_api.g_number

469: ,p_definition_type in varchar2 default hr_api.g_varchar2
470: ,p_number_of_years in number default hr_api.g_number
471: ,p_start_date in date default hr_api.g_date
472: ,p_period_time_definition_id in number default hr_api.g_number
473: ,p_creator_id in number default hr_api.g_number
474: ,p_creator_type in varchar2 default hr_api.g_varchar2
475: ) is
476: --
477: l_rec pay_tdf_shd.g_rec_type;

Line 474: ,p_creator_type in varchar2 default hr_api.g_varchar2

470: ,p_number_of_years in number default hr_api.g_number
471: ,p_start_date in date default hr_api.g_date
472: ,p_period_time_definition_id in number default hr_api.g_number
473: ,p_creator_id in number default hr_api.g_number
474: ,p_creator_type in varchar2 default hr_api.g_varchar2
475: ) is
476: --
477: l_rec pay_tdf_shd.g_rec_type;
478: l_proc varchar2(72) := g_package||'upd';