DBA Data[Home] [Help]

APPS.HR_FIM_UPD dependencies on HR_API

Line 91: When hr_api.check_integrity_violated Then

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

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

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

Line 96: When hr_api.parent_integrity_violated Then

92: -- A check constraint has been violated
93: --
94: hr_fim_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: hr_fim_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.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: hr_fim_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: hr_fim_shd.constraint_error

Line 101: When hr_api.unique_integrity_violated Then

97: -- Parent integrity has been violated
98: --
99: hr_fim_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: hr_fim_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.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: hr_fim_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: --
108: Raise;
109: End update_dml;

Line 250: when hr_api.cannot_find_prog_unit then

246: );
247: --
248: exception
249: --
250: when hr_api.cannot_find_prog_unit then
251: --
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'HR_FORM_ITEMS_B'
254: ,p_hook_type => 'AU');

Line 252: hr_api.cannot_find_prog_unit_error

248: exception
249: --
250: when hr_api.cannot_find_prog_unit then
251: --
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'HR_FORM_ITEMS_B'
254: ,p_hook_type => 'AU');
255: --
256: end;

Line 315: If (p_rec.application_id = hr_api.g_number) then

311: -- p_rec plsql record structure
312: -- to see if a system default is being used. If a system default
313: -- is being used then we must set to the 'current' argument value.
314: --
315: If (p_rec.application_id = hr_api.g_number) then
316: p_rec.application_id :=
317: hr_fim_shd.g_old_rec.application_id;
318: End If;
319: If (p_rec.form_id = hr_api.g_number) then

Line 319: If (p_rec.form_id = hr_api.g_number) then

315: If (p_rec.application_id = hr_api.g_number) then
316: p_rec.application_id :=
317: hr_fim_shd.g_old_rec.application_id;
318: End If;
319: If (p_rec.form_id = hr_api.g_number) then
320: p_rec.form_id :=
321: hr_fim_shd.g_old_rec.form_id;
322: End If;
323: If (p_rec.form_canvas_id = hr_api.g_number) then

Line 323: If (p_rec.form_canvas_id = hr_api.g_number) then

319: If (p_rec.form_id = hr_api.g_number) then
320: p_rec.form_id :=
321: hr_fim_shd.g_old_rec.form_id;
322: End If;
323: If (p_rec.form_canvas_id = hr_api.g_number) then
324: p_rec.form_canvas_id :=
325: hr_fim_shd.g_old_rec.form_canvas_id;
326: End If;
327: If (p_rec.full_item_name = hr_api.g_varchar2) then

Line 327: If (p_rec.full_item_name = hr_api.g_varchar2) then

323: If (p_rec.form_canvas_id = hr_api.g_number) then
324: p_rec.form_canvas_id :=
325: hr_fim_shd.g_old_rec.form_canvas_id;
326: End If;
327: If (p_rec.full_item_name = hr_api.g_varchar2) then
328: p_rec.full_item_name :=
329: hr_fim_shd.g_old_rec.full_item_name;
330: End If;
331: If (p_rec.item_type = hr_api.g_varchar2) then

Line 331: If (p_rec.item_type = hr_api.g_varchar2) then

327: If (p_rec.full_item_name = hr_api.g_varchar2) then
328: p_rec.full_item_name :=
329: hr_fim_shd.g_old_rec.full_item_name;
330: End If;
331: If (p_rec.item_type = hr_api.g_varchar2) then
332: p_rec.item_type :=
333: hr_fim_shd.g_old_rec.item_type;
334: End If;
335: If (p_rec.form_tab_page_id = hr_api.g_number) then

Line 335: If (p_rec.form_tab_page_id = hr_api.g_number) then

331: If (p_rec.item_type = hr_api.g_varchar2) then
332: p_rec.item_type :=
333: hr_fim_shd.g_old_rec.item_type;
334: End If;
335: If (p_rec.form_tab_page_id = hr_api.g_number) then
336: p_rec.form_tab_page_id :=
337: hr_fim_shd.g_old_rec.form_tab_page_id;
338: End If;
339: If (p_rec.radio_button_name = hr_api.g_varchar2) then

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

335: If (p_rec.form_tab_page_id = hr_api.g_number) then
336: p_rec.form_tab_page_id :=
337: hr_fim_shd.g_old_rec.form_tab_page_id;
338: End If;
339: If (p_rec.radio_button_name = hr_api.g_varchar2) then
340: p_rec.radio_button_name :=
341: hr_fim_shd.g_old_rec.radio_button_name;
342: End If;
343: If (p_rec.required_override = hr_api.g_number) then

Line 343: If (p_rec.required_override = hr_api.g_number) then

339: If (p_rec.radio_button_name = hr_api.g_varchar2) then
340: p_rec.radio_button_name :=
341: hr_fim_shd.g_old_rec.radio_button_name;
342: End If;
343: If (p_rec.required_override = hr_api.g_number) then
344: p_rec.required_override :=
345: hr_fim_shd.g_old_rec.required_override;
346: End If;
347: If (p_rec.form_tab_page_id_override = hr_api.g_number) then

Line 347: If (p_rec.form_tab_page_id_override = hr_api.g_number) then

343: If (p_rec.required_override = hr_api.g_number) then
344: p_rec.required_override :=
345: hr_fim_shd.g_old_rec.required_override;
346: End If;
347: If (p_rec.form_tab_page_id_override = hr_api.g_number) then
348: p_rec.form_tab_page_id_override :=
349: hr_fim_shd.g_old_rec.form_tab_page_id_override;
350: End If;
351: If (p_rec.visible_override = hr_api.g_number) then

Line 351: If (p_rec.visible_override = hr_api.g_number) then

347: If (p_rec.form_tab_page_id_override = hr_api.g_number) then
348: p_rec.form_tab_page_id_override :=
349: hr_fim_shd.g_old_rec.form_tab_page_id_override;
350: End If;
351: If (p_rec.visible_override = hr_api.g_number) then
352: p_rec.visible_override :=
353: hr_fim_shd.g_old_rec.visible_override;
354: End If;
355: --

Line 413: ,p_application_id in number default hr_api.g_number

409: Procedure upd
410: (p_effective_date in date
411: ,p_form_item_id in number
412: ,p_object_version_number in out nocopy number
413: ,p_application_id in number default hr_api.g_number
414: ,p_form_id in number default hr_api.g_number
415: ,p_form_canvas_id in number default hr_api.g_number
416: ,p_full_item_name in varchar2 default hr_api.g_varchar2
417: ,p_item_type in varchar2 default hr_api.g_varchar2

Line 414: ,p_form_id in number default hr_api.g_number

410: (p_effective_date in date
411: ,p_form_item_id in number
412: ,p_object_version_number in out nocopy number
413: ,p_application_id in number default hr_api.g_number
414: ,p_form_id in number default hr_api.g_number
415: ,p_form_canvas_id in number default hr_api.g_number
416: ,p_full_item_name in varchar2 default hr_api.g_varchar2
417: ,p_item_type in varchar2 default hr_api.g_varchar2
418: ,p_form_tab_page_id in number default hr_api.g_number

Line 415: ,p_form_canvas_id in number default hr_api.g_number

411: ,p_form_item_id in number
412: ,p_object_version_number in out nocopy number
413: ,p_application_id in number default hr_api.g_number
414: ,p_form_id in number default hr_api.g_number
415: ,p_form_canvas_id in number default hr_api.g_number
416: ,p_full_item_name in varchar2 default hr_api.g_varchar2
417: ,p_item_type in varchar2 default hr_api.g_varchar2
418: ,p_form_tab_page_id in number default hr_api.g_number
419: ,p_radio_button_name in varchar2 default hr_api.g_varchar2

Line 416: ,p_full_item_name in varchar2 default hr_api.g_varchar2

412: ,p_object_version_number in out nocopy number
413: ,p_application_id in number default hr_api.g_number
414: ,p_form_id in number default hr_api.g_number
415: ,p_form_canvas_id in number default hr_api.g_number
416: ,p_full_item_name in varchar2 default hr_api.g_varchar2
417: ,p_item_type in varchar2 default hr_api.g_varchar2
418: ,p_form_tab_page_id in number default hr_api.g_number
419: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
420: ,p_required_override in number default hr_api.g_number

Line 417: ,p_item_type in varchar2 default hr_api.g_varchar2

413: ,p_application_id in number default hr_api.g_number
414: ,p_form_id in number default hr_api.g_number
415: ,p_form_canvas_id in number default hr_api.g_number
416: ,p_full_item_name in varchar2 default hr_api.g_varchar2
417: ,p_item_type in varchar2 default hr_api.g_varchar2
418: ,p_form_tab_page_id in number default hr_api.g_number
419: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
420: ,p_required_override in number default hr_api.g_number
421: ,p_form_tab_page_id_override in number default hr_api.g_number

Line 418: ,p_form_tab_page_id in number default hr_api.g_number

414: ,p_form_id in number default hr_api.g_number
415: ,p_form_canvas_id in number default hr_api.g_number
416: ,p_full_item_name in varchar2 default hr_api.g_varchar2
417: ,p_item_type in varchar2 default hr_api.g_varchar2
418: ,p_form_tab_page_id in number default hr_api.g_number
419: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
420: ,p_required_override in number default hr_api.g_number
421: ,p_form_tab_page_id_override in number default hr_api.g_number
422: ,p_visible_override in number default hr_api.g_number

Line 419: ,p_radio_button_name in varchar2 default hr_api.g_varchar2

415: ,p_form_canvas_id in number default hr_api.g_number
416: ,p_full_item_name in varchar2 default hr_api.g_varchar2
417: ,p_item_type in varchar2 default hr_api.g_varchar2
418: ,p_form_tab_page_id in number default hr_api.g_number
419: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
420: ,p_required_override in number default hr_api.g_number
421: ,p_form_tab_page_id_override in number default hr_api.g_number
422: ,p_visible_override in number default hr_api.g_number
423: ) is

Line 420: ,p_required_override in number default hr_api.g_number

416: ,p_full_item_name in varchar2 default hr_api.g_varchar2
417: ,p_item_type in varchar2 default hr_api.g_varchar2
418: ,p_form_tab_page_id in number default hr_api.g_number
419: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
420: ,p_required_override in number default hr_api.g_number
421: ,p_form_tab_page_id_override in number default hr_api.g_number
422: ,p_visible_override in number default hr_api.g_number
423: ) is
424: --

Line 421: ,p_form_tab_page_id_override in number default hr_api.g_number

417: ,p_item_type in varchar2 default hr_api.g_varchar2
418: ,p_form_tab_page_id in number default hr_api.g_number
419: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
420: ,p_required_override in number default hr_api.g_number
421: ,p_form_tab_page_id_override in number default hr_api.g_number
422: ,p_visible_override in number default hr_api.g_number
423: ) is
424: --
425: l_rec hr_fim_shd.g_rec_type;

Line 422: ,p_visible_override in number default hr_api.g_number

418: ,p_form_tab_page_id in number default hr_api.g_number
419: ,p_radio_button_name in varchar2 default hr_api.g_varchar2
420: ,p_required_override in number default hr_api.g_number
421: ,p_form_tab_page_id_override in number default hr_api.g_number
422: ,p_visible_override in number default hr_api.g_number
423: ) is
424: --
425: l_rec hr_fim_shd.g_rec_type;
426: l_proc varchar2(72) := g_package||'upd';