eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SIR_UPD dependencies on HR_API

Line 87: When hr_api.check_integrity_violated Then

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

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

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

Line 92: When hr_api.parent_integrity_violated Then

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

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

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

Line 97: When hr_api.unique_integrity_violated Then

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

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

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

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

248: -- p_rec plsql record structure
249: -- to see if a system default is being used. If a system default
250: -- is being used then we must set to the 'current' argument value.
251: --
252: If (p_rec.element_type_id = hr_api.g_number) then
253: p_rec.element_type_id :=
254: pay_sir_shd.g_old_rec.element_type_id;
255: End If;
256: If (p_rec.result_name = hr_api.g_varchar2) then

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

252: If (p_rec.element_type_id = hr_api.g_number) then
253: p_rec.element_type_id :=
254: pay_sir_shd.g_old_rec.element_type_id;
255: End If;
256: If (p_rec.result_name = hr_api.g_varchar2) then
257: p_rec.result_name :=
258: pay_sir_shd.g_old_rec.result_name;
259: End If;
260: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then

Line 260: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then

256: If (p_rec.result_name = hr_api.g_varchar2) then
257: p_rec.result_name :=
258: pay_sir_shd.g_old_rec.result_name;
259: End If;
260: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then
261: p_rec.iterative_rule_type :=
262: pay_sir_shd.g_old_rec.iterative_rule_type;
263: End If;
264: If (p_rec.input_value_id = hr_api.g_number) then

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

260: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then
261: p_rec.iterative_rule_type :=
262: pay_sir_shd.g_old_rec.iterative_rule_type;
263: End If;
264: If (p_rec.input_value_id = hr_api.g_number) then
265: p_rec.input_value_id :=
266: pay_sir_shd.g_old_rec.input_value_id;
267: End If;
268: If (p_rec.severity_level = hr_api.g_varchar2) then

Line 268: If (p_rec.severity_level = hr_api.g_varchar2) then

264: If (p_rec.input_value_id = hr_api.g_number) then
265: p_rec.input_value_id :=
266: pay_sir_shd.g_old_rec.input_value_id;
267: End If;
268: If (p_rec.severity_level = hr_api.g_varchar2) then
269: p_rec.severity_level :=
270: pay_sir_shd.g_old_rec.severity_level;
271: End If;
272: If (p_rec.exclusion_rule_id = hr_api.g_number) then

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

268: If (p_rec.severity_level = hr_api.g_varchar2) then
269: p_rec.severity_level :=
270: pay_sir_shd.g_old_rec.severity_level;
271: End If;
272: If (p_rec.exclusion_rule_id = hr_api.g_number) then
273: p_rec.exclusion_rule_id :=
274: pay_sir_shd.g_old_rec.exclusion_rule_id;
275: End If;
276: --

Line 331: ,p_element_type_id in number default hr_api.g_number

327: Procedure upd
328: (p_effective_date in date
329: ,p_iterative_rule_id in number
330: ,p_object_version_number in out nocopy number
331: ,p_element_type_id in number default hr_api.g_number
332: ,p_result_name in varchar2 default hr_api.g_varchar2
333: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
334: ,p_input_value_id in number default hr_api.g_number
335: ,p_severity_level in varchar2 default hr_api.g_varchar2

Line 332: ,p_result_name in varchar2 default hr_api.g_varchar2

328: (p_effective_date in date
329: ,p_iterative_rule_id in number
330: ,p_object_version_number in out nocopy number
331: ,p_element_type_id in number default hr_api.g_number
332: ,p_result_name in varchar2 default hr_api.g_varchar2
333: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
334: ,p_input_value_id in number default hr_api.g_number
335: ,p_severity_level in varchar2 default hr_api.g_varchar2
336: ,p_exclusion_rule_id in number default hr_api.g_number

Line 333: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2

329: ,p_iterative_rule_id in number
330: ,p_object_version_number in out nocopy number
331: ,p_element_type_id in number default hr_api.g_number
332: ,p_result_name in varchar2 default hr_api.g_varchar2
333: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
334: ,p_input_value_id in number default hr_api.g_number
335: ,p_severity_level in varchar2 default hr_api.g_varchar2
336: ,p_exclusion_rule_id in number default hr_api.g_number
337: ) is

Line 334: ,p_input_value_id in number default hr_api.g_number

330: ,p_object_version_number in out nocopy number
331: ,p_element_type_id in number default hr_api.g_number
332: ,p_result_name in varchar2 default hr_api.g_varchar2
333: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
334: ,p_input_value_id in number default hr_api.g_number
335: ,p_severity_level in varchar2 default hr_api.g_varchar2
336: ,p_exclusion_rule_id in number default hr_api.g_number
337: ) is
338: --

Line 335: ,p_severity_level in varchar2 default hr_api.g_varchar2

331: ,p_element_type_id in number default hr_api.g_number
332: ,p_result_name in varchar2 default hr_api.g_varchar2
333: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
334: ,p_input_value_id in number default hr_api.g_number
335: ,p_severity_level in varchar2 default hr_api.g_varchar2
336: ,p_exclusion_rule_id in number default hr_api.g_number
337: ) is
338: --
339: l_rec pay_sir_shd.g_rec_type;

Line 336: ,p_exclusion_rule_id in number default hr_api.g_number

332: ,p_result_name in varchar2 default hr_api.g_varchar2
333: ,p_iterative_rule_type in varchar2 default hr_api.g_varchar2
334: ,p_input_value_id in number default hr_api.g_number
335: ,p_severity_level in varchar2 default hr_api.g_varchar2
336: ,p_exclusion_rule_id in number default hr_api.g_number
337: ) is
338: --
339: l_rec pay_sir_shd.g_rec_type;
340: l_proc varchar2(72) := g_package||'upd';