DBA Data[Home] [Help]

APPS.PAY_SEU_UPD dependencies on HR_API

Line 85: When hr_api.check_integrity_violated Then

81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: pay_seu_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: pay_seu_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: pay_seu_shd.constraint_error

Line 90: When hr_api.parent_integrity_violated Then

86: -- A check constraint has been violated
87: --
88: pay_seu_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: pay_seu_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 95: When hr_api.unique_integrity_violated Then

91: -- Parent integrity has been violated
92: --
93: pay_seu_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pay_seu_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.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pay_seu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;
103: End update_dml;

Line 248: If (p_rec.element_type_id = hr_api.g_number) then

244: -- p_rec plsql record structure
245: -- to see if a system default is being used. If a system default
246: -- is being used then we must set to the 'current' argument value.
247: --
248: If (p_rec.element_type_id = hr_api.g_number) then
249: p_rec.element_type_id :=
250: pay_seu_shd.g_old_rec.element_type_id;
251: End If;
252: If (p_rec.inclusion_flag = hr_api.g_varchar2) then

Line 252: If (p_rec.inclusion_flag = hr_api.g_varchar2) then

248: If (p_rec.element_type_id = hr_api.g_number) then
249: p_rec.element_type_id :=
250: pay_seu_shd.g_old_rec.element_type_id;
251: End If;
252: If (p_rec.inclusion_flag = hr_api.g_varchar2) then
253: p_rec.inclusion_flag :=
254: pay_seu_shd.g_old_rec.inclusion_flag;
255: End If;
256: If (p_rec.run_type_name = hr_api.g_varchar2) then

Line 256: If (p_rec.run_type_name = hr_api.g_varchar2) then

252: If (p_rec.inclusion_flag = hr_api.g_varchar2) then
253: p_rec.inclusion_flag :=
254: pay_seu_shd.g_old_rec.inclusion_flag;
255: End If;
256: If (p_rec.run_type_name = hr_api.g_varchar2) then
257: p_rec.run_type_name :=
258: pay_seu_shd.g_old_rec.run_type_name;
259: End If;
260: If (p_rec.exclusion_rule_id = hr_api.g_number) then

Line 260: If (p_rec.exclusion_rule_id = hr_api.g_number) then

256: If (p_rec.run_type_name = hr_api.g_varchar2) then
257: p_rec.run_type_name :=
258: pay_seu_shd.g_old_rec.run_type_name;
259: End If;
260: If (p_rec.exclusion_rule_id = hr_api.g_number) then
261: p_rec.exclusion_rule_id :=
262: pay_seu_shd.g_old_rec.exclusion_rule_id;
263: End If;
264: --

Line 322: ,p_element_type_id in number default hr_api.g_number

318: Procedure upd
319: (p_effective_date in date
320: ,p_element_type_usage_id in number
321: ,p_object_version_number in out nocopy number
322: ,p_element_type_id in number default hr_api.g_number
323: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
324: ,p_run_type_name in varchar2 default hr_api.g_varchar2
325: ,p_exclusion_rule_id in number default hr_api.g_number
326: ) is

Line 323: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2

319: (p_effective_date in date
320: ,p_element_type_usage_id in number
321: ,p_object_version_number in out nocopy number
322: ,p_element_type_id in number default hr_api.g_number
323: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
324: ,p_run_type_name in varchar2 default hr_api.g_varchar2
325: ,p_exclusion_rule_id in number default hr_api.g_number
326: ) is
327: --

Line 324: ,p_run_type_name in varchar2 default hr_api.g_varchar2

320: ,p_element_type_usage_id in number
321: ,p_object_version_number in out nocopy number
322: ,p_element_type_id in number default hr_api.g_number
323: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
324: ,p_run_type_name in varchar2 default hr_api.g_varchar2
325: ,p_exclusion_rule_id in number default hr_api.g_number
326: ) is
327: --
328: l_rec pay_seu_shd.g_rec_type;

Line 325: ,p_exclusion_rule_id in number default hr_api.g_number

321: ,p_object_version_number in out nocopy number
322: ,p_element_type_id in number default hr_api.g_number
323: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
324: ,p_run_type_name in varchar2 default hr_api.g_varchar2
325: ,p_exclusion_rule_id in number default hr_api.g_number
326: ) is
327: --
328: l_rec pay_seu_shd.g_rec_type;
329: l_proc varchar2(72) := g_package||'upd';