DBA Data[Home] [Help]

APPS.PER_BBT_UPD dependencies on HR_API

Line 89: When hr_api.check_integrity_violated Then

85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: --
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: --
92: per_bbt_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: --
92: per_bbt_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: --
97: per_bbt_shd.constraint_error

Line 94: When hr_api.parent_integrity_violated Then

90: -- A check constraint has been violated
91: --
92: per_bbt_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: --
97: per_bbt_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: --
97: per_bbt_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --
102: per_bbt_shd.constraint_error

Line 99: When hr_api.unique_integrity_violated Then

95: -- Parent integrity has been violated
96: --
97: per_bbt_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --
102: per_bbt_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --
102: per_bbt_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When Others Then
105: --
106: Raise;
107: End update_dml;

Line 233: when hr_api.cannot_find_prog_unit then

229: );
230: --
231: exception
232: --
233: when hr_api.cannot_find_prog_unit then
234: --
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'PER_BF_BALANCE_TYPES'
237: ,p_hook_type => 'AU');

Line 235: hr_api.cannot_find_prog_unit_error

231: exception
232: --
233: when hr_api.cannot_find_prog_unit then
234: --
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'PER_BF_BALANCE_TYPES'
237: ,p_hook_type => 'AU');
238: --
239: end;

Line 302: If (p_rec.input_value_id = hr_api.g_number) then

298: -- p_rec plsql record structure
299: -- to see if a system default is being used. If a system default
300: -- is being used then we must set to the 'current' argument value.
301: --
302: If (p_rec.input_value_id = hr_api.g_number) then
303: p_rec.input_value_id :=
304: per_bbt_shd.g_old_rec.input_value_id;
305: End If;
306: If (p_rec.business_group_id = hr_api.g_number) then

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

302: If (p_rec.input_value_id = hr_api.g_number) then
303: p_rec.input_value_id :=
304: per_bbt_shd.g_old_rec.input_value_id;
305: End If;
306: If (p_rec.business_group_id = hr_api.g_number) then
307: p_rec.business_group_id :=
308: per_bbt_shd.g_old_rec.business_group_id;
309: End If;
310: If (p_rec.displayed_name = hr_api.g_varchar2) then

Line 310: If (p_rec.displayed_name = hr_api.g_varchar2) then

306: If (p_rec.business_group_id = hr_api.g_number) then
307: p_rec.business_group_id :=
308: per_bbt_shd.g_old_rec.business_group_id;
309: End If;
310: If (p_rec.displayed_name = hr_api.g_varchar2) then
311: p_rec.displayed_name :=
312: per_bbt_shd.g_old_rec.displayed_name;
313: End If;
314: If (p_rec.internal_name = hr_api.g_varchar2) then

Line 314: If (p_rec.internal_name = hr_api.g_varchar2) then

310: If (p_rec.displayed_name = hr_api.g_varchar2) then
311: p_rec.displayed_name :=
312: per_bbt_shd.g_old_rec.displayed_name;
313: End If;
314: If (p_rec.internal_name = hr_api.g_varchar2) then
315: p_rec.internal_name :=
316: per_bbt_shd.g_old_rec.internal_name;
317: End If;
318: If (p_rec.uom = hr_api.g_varchar2) then

Line 318: If (p_rec.uom = hr_api.g_varchar2) then

314: If (p_rec.internal_name = hr_api.g_varchar2) then
315: p_rec.internal_name :=
316: per_bbt_shd.g_old_rec.internal_name;
317: End If;
318: If (p_rec.uom = hr_api.g_varchar2) then
319: p_rec.uom :=
320: per_bbt_shd.g_old_rec.uom;
321: End If;
322: If (p_rec.currency = hr_api.g_varchar2) then

Line 322: If (p_rec.currency = hr_api.g_varchar2) then

318: If (p_rec.uom = hr_api.g_varchar2) then
319: p_rec.uom :=
320: per_bbt_shd.g_old_rec.uom;
321: End If;
322: If (p_rec.currency = hr_api.g_varchar2) then
323: p_rec.currency :=
324: per_bbt_shd.g_old_rec.currency;
325: End If;
326: If (p_rec.category = hr_api.g_varchar2) then

Line 326: If (p_rec.category = hr_api.g_varchar2) then

322: If (p_rec.currency = hr_api.g_varchar2) then
323: p_rec.currency :=
324: per_bbt_shd.g_old_rec.currency;
325: End If;
326: If (p_rec.category = hr_api.g_varchar2) then
327: p_rec.category :=
328: per_bbt_shd.g_old_rec.category;
329: End If;
330: If (p_rec.date_from = hr_api.g_date) then

Line 330: If (p_rec.date_from = hr_api.g_date) then

326: If (p_rec.category = hr_api.g_varchar2) then
327: p_rec.category :=
328: per_bbt_shd.g_old_rec.category;
329: End If;
330: If (p_rec.date_from = hr_api.g_date) then
331: p_rec.date_from :=
332: per_bbt_shd.g_old_rec.date_from;
333: End If;
334: If (p_rec.date_to = hr_api.g_date) then

Line 334: If (p_rec.date_to = hr_api.g_date) then

330: If (p_rec.date_from = hr_api.g_date) then
331: p_rec.date_from :=
332: per_bbt_shd.g_old_rec.date_from;
333: End If;
334: If (p_rec.date_to = hr_api.g_date) then
335: p_rec.date_to :=
336: per_bbt_shd.g_old_rec.date_to;
337: End If;
338: --

Line 397: ,p_input_value_id in number default hr_api.g_number

393: -- ----------------------------------------------------------------------------
394: Procedure upd
395: (p_effective_date in date
396: ,p_balance_type_id in number
397: ,p_input_value_id in number default hr_api.g_number
398: ,p_displayed_name in varchar2 default hr_api.g_varchar2
399: ,p_internal_name in varchar2 default hr_api.g_varchar2
400: ,p_uom in varchar2 default hr_api.g_varchar2
401: ,p_currency in varchar2 default hr_api.g_varchar2

Line 398: ,p_displayed_name in varchar2 default hr_api.g_varchar2

394: Procedure upd
395: (p_effective_date in date
396: ,p_balance_type_id in number
397: ,p_input_value_id in number default hr_api.g_number
398: ,p_displayed_name in varchar2 default hr_api.g_varchar2
399: ,p_internal_name in varchar2 default hr_api.g_varchar2
400: ,p_uom in varchar2 default hr_api.g_varchar2
401: ,p_currency in varchar2 default hr_api.g_varchar2
402: ,p_category in varchar2 default hr_api.g_varchar2

Line 399: ,p_internal_name in varchar2 default hr_api.g_varchar2

395: (p_effective_date in date
396: ,p_balance_type_id in number
397: ,p_input_value_id in number default hr_api.g_number
398: ,p_displayed_name in varchar2 default hr_api.g_varchar2
399: ,p_internal_name in varchar2 default hr_api.g_varchar2
400: ,p_uom in varchar2 default hr_api.g_varchar2
401: ,p_currency in varchar2 default hr_api.g_varchar2
402: ,p_category in varchar2 default hr_api.g_varchar2
403: ,p_date_from in date default hr_api.g_date

Line 400: ,p_uom in varchar2 default hr_api.g_varchar2

396: ,p_balance_type_id in number
397: ,p_input_value_id in number default hr_api.g_number
398: ,p_displayed_name in varchar2 default hr_api.g_varchar2
399: ,p_internal_name in varchar2 default hr_api.g_varchar2
400: ,p_uom in varchar2 default hr_api.g_varchar2
401: ,p_currency in varchar2 default hr_api.g_varchar2
402: ,p_category in varchar2 default hr_api.g_varchar2
403: ,p_date_from in date default hr_api.g_date
404: ,p_date_to in date default hr_api.g_date

Line 401: ,p_currency in varchar2 default hr_api.g_varchar2

397: ,p_input_value_id in number default hr_api.g_number
398: ,p_displayed_name in varchar2 default hr_api.g_varchar2
399: ,p_internal_name in varchar2 default hr_api.g_varchar2
400: ,p_uom in varchar2 default hr_api.g_varchar2
401: ,p_currency in varchar2 default hr_api.g_varchar2
402: ,p_category in varchar2 default hr_api.g_varchar2
403: ,p_date_from in date default hr_api.g_date
404: ,p_date_to in date default hr_api.g_date
405: ,p_object_version_number in out nocopy number

Line 402: ,p_category in varchar2 default hr_api.g_varchar2

398: ,p_displayed_name in varchar2 default hr_api.g_varchar2
399: ,p_internal_name in varchar2 default hr_api.g_varchar2
400: ,p_uom in varchar2 default hr_api.g_varchar2
401: ,p_currency in varchar2 default hr_api.g_varchar2
402: ,p_category in varchar2 default hr_api.g_varchar2
403: ,p_date_from in date default hr_api.g_date
404: ,p_date_to in date default hr_api.g_date
405: ,p_object_version_number in out nocopy number
406: ) is

Line 403: ,p_date_from in date default hr_api.g_date

399: ,p_internal_name in varchar2 default hr_api.g_varchar2
400: ,p_uom in varchar2 default hr_api.g_varchar2
401: ,p_currency in varchar2 default hr_api.g_varchar2
402: ,p_category in varchar2 default hr_api.g_varchar2
403: ,p_date_from in date default hr_api.g_date
404: ,p_date_to in date default hr_api.g_date
405: ,p_object_version_number in out nocopy number
406: ) is
407: --

Line 404: ,p_date_to in date default hr_api.g_date

400: ,p_uom in varchar2 default hr_api.g_varchar2
401: ,p_currency in varchar2 default hr_api.g_varchar2
402: ,p_category in varchar2 default hr_api.g_varchar2
403: ,p_date_from in date default hr_api.g_date
404: ,p_date_to in date default hr_api.g_date
405: ,p_object_version_number in out nocopy number
406: ) is
407: --
408: l_rec per_bbt_shd.g_rec_type;

Line 421: ,hr_api.g_number

417: l_rec :=
418: per_bbt_shd.convert_args
419: (p_balance_type_id
420: ,p_input_value_id
421: ,hr_api.g_number
422: ,p_displayed_name
423: ,p_internal_name
424: ,p_uom
425: ,p_currency