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_SF_UPD dependencies on PAY_SF_SHD

Line 51: Procedure update_dml(p_rec in out nocopy pay_sf_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_sf_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin

Line 78: pay_sf_shd.constraint_error

74: --
75: Exception
76: When hr_api.check_integrity_violated Then
77: -- A check constraint has been violated
78: pay_sf_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: pay_sf_shd.constraint_error

Line 82: pay_sf_shd.constraint_error

78: pay_sf_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: pay_sf_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: pay_sf_shd.constraint_error

Line 86: pay_sf_shd.constraint_error

82: pay_sf_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: pay_sf_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: Raise;
90: End update_dml;

Line 124: Procedure pre_update(p_rec in pay_sf_shd.g_rec_type) is

120: -- Internal Row Handler Use Only.
121: --
122: -- {End Of Comments}
123: -- ----------------------------------------------------------------------------
124: Procedure pre_update(p_rec in pay_sf_shd.g_rec_type) is
125: --
126: l_proc varchar2(72) := g_package||'pre_update';
127: --
128: Begin

Line 166: Procedure post_update(p_rec in pay_sf_shd.g_rec_type) is

162: -- Internal Row Handler Use Only.
163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure post_update(p_rec in pay_sf_shd.g_rec_type) is
167: --
168: l_proc varchar2(72) := g_package||'post_update';
169: --
170: Begin

Line 220: Procedure convert_defs(p_rec in out nocopy pay_sf_shd.g_rec_type) is

216: -- Internal Row Handler Use Only.
217: --
218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: Procedure convert_defs(p_rec in out nocopy pay_sf_shd.g_rec_type) is
221: --
222: l_proc varchar2(72) := g_package||'convert_defs';
223: --
224: Begin

Line 235: pay_sf_shd.g_old_rec.template_type;

231: -- is being used then we must set to the 'current' argument value.
232: --
233: If (p_rec.template_type = hr_api.g_varchar2) then
234: p_rec.template_type :=
235: pay_sf_shd.g_old_rec.template_type;
236: End If;
237: If (p_rec.legislation_code = hr_api.g_varchar2) then
238: p_rec.legislation_code :=
239: pay_sf_shd.g_old_rec.legislation_code;

Line 239: pay_sf_shd.g_old_rec.legislation_code;

235: pay_sf_shd.g_old_rec.template_type;
236: End If;
237: If (p_rec.legislation_code = hr_api.g_varchar2) then
238: p_rec.legislation_code :=
239: pay_sf_shd.g_old_rec.legislation_code;
240: End If;
241: If (p_rec.business_group_id = hr_api.g_number) then
242: p_rec.business_group_id :=
243: pay_sf_shd.g_old_rec.business_group_id;

Line 243: pay_sf_shd.g_old_rec.business_group_id;

239: pay_sf_shd.g_old_rec.legislation_code;
240: End If;
241: If (p_rec.business_group_id = hr_api.g_number) then
242: p_rec.business_group_id :=
243: pay_sf_shd.g_old_rec.business_group_id;
244: End If;
245: If (p_rec.formula_name = hr_api.g_varchar2) then
246: p_rec.formula_name :=
247: pay_sf_shd.g_old_rec.formula_name;

Line 247: pay_sf_shd.g_old_rec.formula_name;

243: pay_sf_shd.g_old_rec.business_group_id;
244: End If;
245: If (p_rec.formula_name = hr_api.g_varchar2) then
246: p_rec.formula_name :=
247: pay_sf_shd.g_old_rec.formula_name;
248: End If;
249: If (p_rec.description = hr_api.g_varchar2) then
250: p_rec.description :=
251: pay_sf_shd.g_old_rec.description;

Line 251: pay_sf_shd.g_old_rec.description;

247: pay_sf_shd.g_old_rec.formula_name;
248: End If;
249: If (p_rec.description = hr_api.g_varchar2) then
250: p_rec.description :=
251: pay_sf_shd.g_old_rec.description;
252: End If;
253: If (p_rec.formula_text = hr_api.g_varchar2) then
254: p_rec.formula_text :=
255: pay_sf_shd.g_old_rec.formula_text;

Line 255: pay_sf_shd.g_old_rec.formula_text;

251: pay_sf_shd.g_old_rec.description;
252: End If;
253: If (p_rec.formula_text = hr_api.g_varchar2) then
254: p_rec.formula_text :=
255: pay_sf_shd.g_old_rec.formula_text;
256: End If;
257: If (p_rec.formula_type_name = hr_api.g_varchar2) then
258: p_rec.formula_type_name :=
259: pay_sf_shd.g_old_rec.formula_type_name;

Line 259: pay_sf_shd.g_old_rec.formula_type_name;

255: pay_sf_shd.g_old_rec.formula_text;
256: End If;
257: If (p_rec.formula_type_name = hr_api.g_varchar2) then
258: p_rec.formula_type_name :=
259: pay_sf_shd.g_old_rec.formula_type_name;
260: End If;
261:
262:
263: --

Line 273: ,p_rec in out nocopy pay_sf_shd.g_rec_type

269: -- |---------------------------------< upd >----------------------------------|
270: -- ----------------------------------------------------------------------------
271: Procedure upd
272: (p_effective_date in date
273: ,p_rec in out nocopy pay_sf_shd.g_rec_type
274: ) is
275: --
276: l_proc varchar2(72) := g_package||'upd';
277: --

Line 283: pay_sf_shd.lck

279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- We must lock the row which we need to update.
282: --
283: pay_sf_shd.lck
284: (
285: p_rec.formula_id,
286: p_rec.object_version_number
287: );

Line 323: l_rec pay_sf_shd.g_rec_type;

319: p_formula_text in varchar2 default hr_api.g_varchar2,
320: p_object_version_number in out nocopy number
321: ) is
322: --
323: l_rec pay_sf_shd.g_rec_type;
324: l_proc varchar2(72) := g_package||'upd';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);

Line 333: pay_sf_shd.convert_args

329: -- Call conversion function to turn arguments into the
330: -- l_rec structure.
331: --
332: l_rec :=
333: pay_sf_shd.convert_args
334: (
335: p_formula_id,
336: hr_api.g_varchar2,
337: hr_api.g_varchar2,