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 PAY_SFR_SHD

Line 51: Procedure update_dml(p_rec in out nocopy pay_sfr_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure update_dml(p_rec in out nocopy pay_sfr_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin

Line 83: pay_sfr_shd.constraint_error

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
86: -- Parent integrity has been violated
87: pay_sfr_shd.constraint_error

Line 87: pay_sfr_shd.constraint_error

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
90: -- Unique integrity has been violated
91: pay_sfr_shd.constraint_error

Line 91: pay_sfr_shd.constraint_error

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
94: Raise;
95: End update_dml;

Line 129: Procedure pre_update(p_rec in pay_sfr_shd.g_rec_type) is

125: -- Internal Row Handler Use Only.
126: --
127: -- {End Of Comments}
128: -- ----------------------------------------------------------------------------
129: Procedure pre_update(p_rec in pay_sfr_shd.g_rec_type) is
130: --
131: l_proc varchar2(72) := g_package||'pre_update';
132: --
133: Begin

Line 171: Procedure post_update(p_rec in pay_sfr_shd.g_rec_type) is

167: -- Internal Row Handler Use Only.
168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure post_update(p_rec in pay_sfr_shd.g_rec_type) is
172: --
173: l_proc varchar2(72) := g_package||'post_update';
174: --
175: Begin

Line 225: Procedure convert_defs(p_rec in out nocopy pay_sfr_shd.g_rec_type) is

221: -- Internal Row Handler Use Only.
222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure convert_defs(p_rec in out nocopy pay_sfr_shd.g_rec_type) is
226: --
227: l_proc varchar2(72) := g_package||'convert_defs';
228: --
229: Begin

Line 240: pay_sfr_shd.g_old_rec.shadow_element_type_id;

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
243: p_rec.element_type_id :=
244: pay_sfr_shd.g_old_rec.element_type_id;

Line 244: pay_sfr_shd.g_old_rec.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
247: p_rec.result_name :=
248: pay_sfr_shd.g_old_rec.result_name;

Line 248: pay_sfr_shd.g_old_rec.result_name;

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
251: p_rec.result_rule_type :=
252: pay_sfr_shd.g_old_rec.result_rule_type;

Line 252: pay_sfr_shd.g_old_rec.result_rule_type;

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
255: p_rec.severity_level :=
256: pay_sfr_shd.g_old_rec.severity_level;

Line 256: pay_sfr_shd.g_old_rec.severity_level;

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
259: p_rec.input_value_id :=
260: pay_sfr_shd.g_old_rec.input_value_id;

Line 260: pay_sfr_shd.g_old_rec.input_value_id;

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
263: p_rec.exclusion_rule_id :=
264: pay_sfr_shd.g_old_rec.exclusion_rule_id;

Line 264: pay_sfr_shd.g_old_rec.exclusion_rule_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
267: p_rec.element_name :=
268: pay_sfr_shd.g_old_rec.element_name;

Line 268: pay_sfr_shd.g_old_rec.element_name;

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: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: --

Line 281: p_rec in out nocopy pay_sfr_shd.g_rec_type

277: -- ----------------------------------------------------------------------------
278: Procedure upd
279: (
280: p_effective_date in date,
281: p_rec in out nocopy pay_sfr_shd.g_rec_type
282: ) is
283: --
284: l_proc varchar2(72) := g_package||'upd';
285: --

Line 291: pay_sfr_shd.lck

287: hr_utility.set_location('Entering:'||l_proc, 5);
288: --
289: -- We must lock the row which we need to update.
290: --
291: pay_sfr_shd.lck
292: (
293: p_rec.formula_result_rule_id,
294: p_rec.object_version_number
295: );

Line 336: l_rec pay_sfr_shd.g_rec_type;

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;
337: l_proc varchar2(72) := g_package||'upd';
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 5);

Line 346: pay_sfr_shd.convert_args

342: -- Call conversion function to turn arguments into the
343: -- l_rec structure.
344: --
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,