APPS.PQH_TAT_UPD dependencies on HR_API

Line 77: When hr_api.check_integrity_violated Then

73: --
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: --
76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: pqh_tat_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then

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

76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: pqh_tat_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: pqh_tat_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 81: When hr_api.parent_integrity_violated Then

77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: pqh_tat_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: pqh_tat_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then

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

80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: pqh_tat_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: pqh_tat_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 85: When hr_api.unique_integrity_violated Then

81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: pqh_tat_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: pqh_tat_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When Others Then

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

84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: pqh_tat_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When Others Then
90: Raise;
91: End update_dml;
92: --

Line 200: when hr_api.cannot_find_prog_unit then

196: );
197: --
198: exception
199: --
200: when hr_api.cannot_find_prog_unit then
201: --
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'pqh_template_attributes'
204: ,p_hook_type => 'AU');

Line 202: hr_api.cannot_find_prog_unit_error

198: exception
199: --
200: when hr_api.cannot_find_prog_unit then
201: --
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'pqh_template_attributes'
204: ,p_hook_type => 'AU');
205: --
206: end;

Line 270: If (p_rec.required_flag = hr_api.g_varchar2) then

266: -- p_rec plsql record structure
267: -- to see if a system default is being used. If a system default
268: -- is being used then we must set to the 'current' argument value.
269: --
270: If (p_rec.required_flag = hr_api.g_varchar2) then
271: p_rec.required_flag :=
272: pqh_tat_shd.g_old_rec.required_flag;
273: End If;
274: If (p_rec.view_flag = hr_api.g_varchar2) then

Line 274: If (p_rec.view_flag = hr_api.g_varchar2) then

270: If (p_rec.required_flag = hr_api.g_varchar2) then
271: p_rec.required_flag :=
272: pqh_tat_shd.g_old_rec.required_flag;
273: End If;
274: If (p_rec.view_flag = hr_api.g_varchar2) then
275: p_rec.view_flag :=
276: pqh_tat_shd.g_old_rec.view_flag;
277: End If;
278: If (p_rec.edit_flag = hr_api.g_varchar2) then

Line 278: If (p_rec.edit_flag = hr_api.g_varchar2) then

274: If (p_rec.view_flag = hr_api.g_varchar2) then
275: p_rec.view_flag :=
276: pqh_tat_shd.g_old_rec.view_flag;
277: End If;
278: If (p_rec.edit_flag = hr_api.g_varchar2) then
279: p_rec.edit_flag :=
280: pqh_tat_shd.g_old_rec.edit_flag;
281: End If;
282: If (p_rec.attribute_id = hr_api.g_number) then

Line 282: If (p_rec.attribute_id = hr_api.g_number) then

278: If (p_rec.edit_flag = hr_api.g_varchar2) then
279: p_rec.edit_flag :=
280: pqh_tat_shd.g_old_rec.edit_flag;
281: End If;
282: If (p_rec.attribute_id = hr_api.g_number) then
283: p_rec.attribute_id :=
284: pqh_tat_shd.g_old_rec.attribute_id;
285: End If;
286: If (p_rec.template_id = hr_api.g_number) then

Line 286: If (p_rec.template_id = hr_api.g_number) then

282: If (p_rec.attribute_id = hr_api.g_number) then
283: p_rec.attribute_id :=
284: pqh_tat_shd.g_old_rec.attribute_id;
285: End If;
286: If (p_rec.template_id = hr_api.g_number) then
287: p_rec.template_id :=
288: pqh_tat_shd.g_old_rec.template_id;
289: End If;
290:

Line 348: p_required_flag in varchar2 default hr_api.g_varchar2,

344: -- ----------------------------------------------------------------------------
345: Procedure upd
346: (
347: p_effective_date in date,
348: p_required_flag in varchar2 default hr_api.g_varchar2,
349: p_view_flag in varchar2 default hr_api.g_varchar2,
350: p_edit_flag in varchar2 default hr_api.g_varchar2,
351: p_template_attribute_id in number,
352: p_attribute_id in number default hr_api.g_number,

Line 349: p_view_flag in varchar2 default hr_api.g_varchar2,

345: Procedure upd
346: (
347: p_effective_date in date,
348: p_required_flag in varchar2 default hr_api.g_varchar2,
349: p_view_flag in varchar2 default hr_api.g_varchar2,
350: p_edit_flag in varchar2 default hr_api.g_varchar2,
351: p_template_attribute_id in number,
352: p_attribute_id in number default hr_api.g_number,
353: p_template_id in number default hr_api.g_number,

Line 350: p_edit_flag in varchar2 default hr_api.g_varchar2,

346: (
347: p_effective_date in date,
348: p_required_flag in varchar2 default hr_api.g_varchar2,
349: p_view_flag in varchar2 default hr_api.g_varchar2,
350: p_edit_flag in varchar2 default hr_api.g_varchar2,
351: p_template_attribute_id in number,
352: p_attribute_id in number default hr_api.g_number,
353: p_template_id in number default hr_api.g_number,
354: p_object_version_number in out nocopy number

Line 352: p_attribute_id in number default hr_api.g_number,

348: p_required_flag in varchar2 default hr_api.g_varchar2,
349: p_view_flag in varchar2 default hr_api.g_varchar2,
350: p_edit_flag in varchar2 default hr_api.g_varchar2,
351: p_template_attribute_id in number,
352: p_attribute_id in number default hr_api.g_number,
353: p_template_id in number default hr_api.g_number,
354: p_object_version_number in out nocopy number
355: ) is
356: --

Line 353: p_template_id in number default hr_api.g_number,

349: p_view_flag in varchar2 default hr_api.g_varchar2,
350: p_edit_flag in varchar2 default hr_api.g_varchar2,
351: p_template_attribute_id in number,
352: p_attribute_id in number default hr_api.g_number,
353: p_template_id in number default hr_api.g_number,
354: p_object_version_number in out nocopy number
355: ) is
356: --
357: l_rec pqh_tat_shd.g_rec_type;