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_SFR_UPD dependencies on HR_API

Line 81: When hr_api.check_integrity_violated Then

77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pay_sfr_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then

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

80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pay_sfr_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sfr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 85: When hr_api.parent_integrity_violated Then

81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pay_sfr_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sfr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated 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.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sfr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pay_sfr_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 89: When hr_api.unique_integrity_violated Then

85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pay_sfr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pay_sfr_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then

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

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pay_sfr_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: Raise;
95: End update_dml;
96: --

Line 238: If (p_rec.shadow_element_type_id = hr_api.g_number) then

234: -- p_rec plsql record structure
235: -- to see if a system default is being used. If a system default
236: -- is being used then we must set to the 'current' argument value.
237: --
238: If (p_rec.shadow_element_type_id = hr_api.g_number) then
239: p_rec.shadow_element_type_id :=
240: pay_sfr_shd.g_old_rec.shadow_element_type_id;
241: End If;
242: If (p_rec.element_type_id = hr_api.g_number) then

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

238: If (p_rec.shadow_element_type_id = hr_api.g_number) then
239: p_rec.shadow_element_type_id :=
240: pay_sfr_shd.g_old_rec.shadow_element_type_id;
241: End If;
242: If (p_rec.element_type_id = hr_api.g_number) then
243: p_rec.element_type_id :=
244: pay_sfr_shd.g_old_rec.element_type_id;
245: End If;
246: If (p_rec.result_name = hr_api.g_varchar2) then

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

242: If (p_rec.element_type_id = hr_api.g_number) then
243: p_rec.element_type_id :=
244: pay_sfr_shd.g_old_rec.element_type_id;
245: End If;
246: If (p_rec.result_name = hr_api.g_varchar2) then
247: p_rec.result_name :=
248: pay_sfr_shd.g_old_rec.result_name;
249: End If;
250: If (p_rec.result_rule_type = hr_api.g_varchar2) then

Line 250: If (p_rec.result_rule_type = hr_api.g_varchar2) then

246: If (p_rec.result_name = hr_api.g_varchar2) then
247: p_rec.result_name :=
248: pay_sfr_shd.g_old_rec.result_name;
249: End If;
250: If (p_rec.result_rule_type = hr_api.g_varchar2) then
251: p_rec.result_rule_type :=
252: pay_sfr_shd.g_old_rec.result_rule_type;
253: End If;
254: If (p_rec.severity_level = hr_api.g_varchar2) then

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

250: If (p_rec.result_rule_type = hr_api.g_varchar2) then
251: p_rec.result_rule_type :=
252: pay_sfr_shd.g_old_rec.result_rule_type;
253: End If;
254: If (p_rec.severity_level = hr_api.g_varchar2) then
255: p_rec.severity_level :=
256: pay_sfr_shd.g_old_rec.severity_level;
257: End If;
258: If (p_rec.input_value_id = hr_api.g_number) then

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

254: If (p_rec.severity_level = hr_api.g_varchar2) then
255: p_rec.severity_level :=
256: pay_sfr_shd.g_old_rec.severity_level;
257: End If;
258: If (p_rec.input_value_id = hr_api.g_number) then
259: p_rec.input_value_id :=
260: pay_sfr_shd.g_old_rec.input_value_id;
261: End If;
262: If (p_rec.exclusion_rule_id = hr_api.g_number) then

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

258: If (p_rec.input_value_id = hr_api.g_number) then
259: p_rec.input_value_id :=
260: pay_sfr_shd.g_old_rec.input_value_id;
261: End If;
262: If (p_rec.exclusion_rule_id = hr_api.g_number) then
263: p_rec.exclusion_rule_id :=
264: pay_sfr_shd.g_old_rec.exclusion_rule_id;
265: End If;
266: If (p_rec.element_name = hr_api.g_varchar2) then

Line 266: If (p_rec.element_name = hr_api.g_varchar2) then

262: If (p_rec.exclusion_rule_id = hr_api.g_number) then
263: p_rec.exclusion_rule_id :=
264: pay_sfr_shd.g_old_rec.exclusion_rule_id;
265: End If;
266: If (p_rec.element_name = hr_api.g_varchar2) then
267: p_rec.element_name :=
268: pay_sfr_shd.g_old_rec.element_name;
269: End If;
270: --

Line 326: p_element_type_id in number default hr_api.g_number,

322: Procedure upd
323: (
324: p_effective_date in date,
325: p_formula_result_rule_id in number,
326: p_element_type_id in number default hr_api.g_number,
327: p_result_name in varchar2 default hr_api.g_varchar2,
328: p_result_rule_type in varchar2 default hr_api.g_varchar2,
329: p_severity_level in varchar2 default hr_api.g_varchar2,
330: p_input_value_id in number default hr_api.g_number,

Line 327: p_result_name in varchar2 default hr_api.g_varchar2,

323: (
324: p_effective_date in date,
325: p_formula_result_rule_id in number,
326: p_element_type_id in number default hr_api.g_number,
327: p_result_name in varchar2 default hr_api.g_varchar2,
328: p_result_rule_type in varchar2 default hr_api.g_varchar2,
329: p_severity_level in varchar2 default hr_api.g_varchar2,
330: p_input_value_id in number default hr_api.g_number,
331: p_exclusion_rule_id in number default hr_api.g_number,

Line 328: p_result_rule_type in varchar2 default hr_api.g_varchar2,

324: p_effective_date in date,
325: p_formula_result_rule_id in number,
326: p_element_type_id in number default hr_api.g_number,
327: p_result_name in varchar2 default hr_api.g_varchar2,
328: p_result_rule_type in varchar2 default hr_api.g_varchar2,
329: p_severity_level in varchar2 default hr_api.g_varchar2,
330: p_input_value_id in number default hr_api.g_number,
331: p_exclusion_rule_id in number default hr_api.g_number,
332: p_element_name in varchar2 default hr_api.g_varchar2,

Line 329: p_severity_level in varchar2 default hr_api.g_varchar2,

325: p_formula_result_rule_id in number,
326: p_element_type_id in number default hr_api.g_number,
327: p_result_name in varchar2 default hr_api.g_varchar2,
328: p_result_rule_type in varchar2 default hr_api.g_varchar2,
329: p_severity_level in varchar2 default hr_api.g_varchar2,
330: p_input_value_id in number default hr_api.g_number,
331: p_exclusion_rule_id in number default hr_api.g_number,
332: p_element_name in varchar2 default hr_api.g_varchar2,
333: p_object_version_number in out nocopy number

Line 330: p_input_value_id in number default hr_api.g_number,

326: p_element_type_id in number default hr_api.g_number,
327: p_result_name in varchar2 default hr_api.g_varchar2,
328: p_result_rule_type in varchar2 default hr_api.g_varchar2,
329: p_severity_level in varchar2 default hr_api.g_varchar2,
330: p_input_value_id in number default hr_api.g_number,
331: p_exclusion_rule_id in number default hr_api.g_number,
332: p_element_name in varchar2 default hr_api.g_varchar2,
333: p_object_version_number in out nocopy number
334: ) is

Line 331: p_exclusion_rule_id in number default hr_api.g_number,

327: p_result_name in varchar2 default hr_api.g_varchar2,
328: p_result_rule_type in varchar2 default hr_api.g_varchar2,
329: p_severity_level in varchar2 default hr_api.g_varchar2,
330: p_input_value_id in number default hr_api.g_number,
331: p_exclusion_rule_id in number default hr_api.g_number,
332: p_element_name in varchar2 default hr_api.g_varchar2,
333: p_object_version_number in out nocopy number
334: ) is
335: --

Line 332: p_element_name in varchar2 default hr_api.g_varchar2,

328: p_result_rule_type in varchar2 default hr_api.g_varchar2,
329: p_severity_level in varchar2 default hr_api.g_varchar2,
330: p_input_value_id in number default hr_api.g_number,
331: p_exclusion_rule_id in number default hr_api.g_number,
332: p_element_name in varchar2 default hr_api.g_varchar2,
333: p_object_version_number in out nocopy number
334: ) is
335: --
336: l_rec pay_sfr_shd.g_rec_type;

Line 349: hr_api.g_number,

345: l_rec :=
346: pay_sfr_shd.convert_args
347: (
348: p_formula_result_rule_id,
349: hr_api.g_number,
350: p_element_type_id,
351: p_result_name,
352: p_result_rule_type,
353: p_severity_level,