APPS.PQH_TTM_UPD dependencies on HR_API

Line 76: When hr_api.check_integrity_violated Then

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

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

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

Line 80: When hr_api.parent_integrity_violated Then

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

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

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

Line 84: When hr_api.unique_integrity_violated Then

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

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

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

Line 197: when hr_api.cannot_find_prog_unit then

193: );
194: --
195: exception
196: --
197: when hr_api.cannot_find_prog_unit then
198: --
199: hr_api.cannot_find_prog_unit_error
200: (p_module_name => 'pqh_transaction_templates'
201: ,p_hook_type => 'AU');

Line 199: hr_api.cannot_find_prog_unit_error

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

Line 267: If (p_rec.enable_flag = hr_api.g_varchar2) then

263: -- p_rec plsql record structure
264: -- to see if a system default is being used. If a system default
265: -- is being used then we must set to the 'current' argument value.
266: --
267: If (p_rec.enable_flag = hr_api.g_varchar2) then
268: p_rec.enable_flag :=
269: pqh_ttm_shd.g_old_rec.enable_flag;
270: End If;
271: If (p_rec.template_id = hr_api.g_number) then

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

267: If (p_rec.enable_flag = hr_api.g_varchar2) then
268: p_rec.enable_flag :=
269: pqh_ttm_shd.g_old_rec.enable_flag;
270: End If;
271: If (p_rec.template_id = hr_api.g_number) then
272: p_rec.template_id :=
273: pqh_ttm_shd.g_old_rec.template_id;
274: End If;
275: If (p_rec.transaction_id = hr_api.g_number) then

Line 275: If (p_rec.transaction_id = hr_api.g_number) then

271: If (p_rec.template_id = hr_api.g_number) then
272: p_rec.template_id :=
273: pqh_ttm_shd.g_old_rec.template_id;
274: End If;
275: If (p_rec.transaction_id = hr_api.g_number) then
276: p_rec.transaction_id :=
277: pqh_ttm_shd.g_old_rec.transaction_id;
278: End If;
279: If (p_rec.transaction_category_id = hr_api.g_number) then

Line 279: If (p_rec.transaction_category_id = hr_api.g_number) then

275: If (p_rec.transaction_id = hr_api.g_number) then
276: p_rec.transaction_id :=
277: pqh_ttm_shd.g_old_rec.transaction_id;
278: End If;
279: If (p_rec.transaction_category_id = hr_api.g_number) then
280: p_rec.transaction_category_id :=
281: pqh_ttm_shd.g_old_rec.transaction_category_id;
282: End If;
283:

Line 342: p_enable_flag in varchar2 default hr_api.g_varchar2,

338: Procedure upd
339: (
340: p_effective_date in date,
341: p_transaction_template_id in number,
342: p_enable_flag in varchar2 default hr_api.g_varchar2,
343: p_template_id in number default hr_api.g_number,
344: p_transaction_id in number default hr_api.g_number,
345: p_transaction_category_id in number default hr_api.g_number,
346: p_object_version_number in out nocopy number

Line 343: p_template_id in number default hr_api.g_number,

339: (
340: p_effective_date in date,
341: p_transaction_template_id in number,
342: p_enable_flag in varchar2 default hr_api.g_varchar2,
343: p_template_id in number default hr_api.g_number,
344: p_transaction_id in number default hr_api.g_number,
345: p_transaction_category_id in number default hr_api.g_number,
346: p_object_version_number in out nocopy number
347: ) is

Line 344: p_transaction_id in number default hr_api.g_number,

340: p_effective_date in date,
341: p_transaction_template_id in number,
342: p_enable_flag in varchar2 default hr_api.g_varchar2,
343: p_template_id in number default hr_api.g_number,
344: p_transaction_id in number default hr_api.g_number,
345: p_transaction_category_id in number default hr_api.g_number,
346: p_object_version_number in out nocopy number
347: ) is
348: --

Line 345: p_transaction_category_id in number default hr_api.g_number,

341: p_transaction_template_id in number,
342: p_enable_flag in varchar2 default hr_api.g_varchar2,
343: p_template_id in number default hr_api.g_number,
344: p_transaction_id in number default hr_api.g_number,
345: p_transaction_category_id in number default hr_api.g_number,
346: p_object_version_number in out nocopy number
347: ) is
348: --
349: l_rec pqh_ttm_shd.g_rec_type;