DBA Data[Home] [Help]

APPS.PAY_TFU_UPD dependencies on PAY_TFU_SHD

Line 55: (p_rec in out nocopy pay_tfu_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_tfu_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 88: pay_tfu_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: pay_tfu_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: --

Line 93: pay_tfu_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_tfu_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: --

Line 98: pay_tfu_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_tfu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;

Line 138: (p_rec in pay_tfu_shd.g_rec_type

134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure pre_update
138: (p_rec in pay_tfu_shd.g_rec_type
139: ) is
140: --
141: l_proc varchar2(72) := g_package||'pre_update';
142: --

Line 183: ,p_rec in pay_tfu_shd.g_rec_type

179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure post_update
182: (p_effective_date in date
183: ,p_rec in pay_tfu_shd.g_rec_type
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --

Line 238: (p_rec in out nocopy pay_tfu_shd.g_rec_type

234: --
235: -- {End Of Comments}
236: -- ----------------------------------------------------------------------------
237: Procedure convert_defs
238: (p_rec in out nocopy pay_tfu_shd.g_rec_type
239: ) is
240: --
241: Begin
242: --

Line 250: pay_tfu_shd.g_old_rec.template_id;

246: -- is being used then we must set to the 'current' argument value.
247: --
248: If (p_rec.template_id = hr_api.g_number) then
249: p_rec.template_id :=
250: pay_tfu_shd.g_old_rec.template_id;
251: End If;
252: If (p_rec.formula_id = hr_api.g_number) then
253: p_rec.formula_id :=
254: pay_tfu_shd.g_old_rec.formula_id;

Line 254: pay_tfu_shd.g_old_rec.formula_id;

250: pay_tfu_shd.g_old_rec.template_id;
251: End If;
252: If (p_rec.formula_id = hr_api.g_number) then
253: p_rec.formula_id :=
254: pay_tfu_shd.g_old_rec.formula_id;
255: End If;
256: If (p_rec.object_id = hr_api.g_number) then
257: p_rec.object_id :=
258: pay_tfu_shd.g_old_rec.object_id;

Line 258: pay_tfu_shd.g_old_rec.object_id;

254: pay_tfu_shd.g_old_rec.formula_id;
255: End If;
256: If (p_rec.object_id = hr_api.g_number) then
257: p_rec.object_id :=
258: pay_tfu_shd.g_old_rec.object_id;
259: End If;
260: If (p_rec.exclusion_rule_id = hr_api.g_number) then
261: p_rec.exclusion_rule_id :=
262: pay_tfu_shd.g_old_rec.exclusion_rule_id;

Line 262: pay_tfu_shd.g_old_rec.exclusion_rule_id;

258: pay_tfu_shd.g_old_rec.object_id;
259: End If;
260: If (p_rec.exclusion_rule_id = hr_api.g_number) then
261: p_rec.exclusion_rule_id :=
262: pay_tfu_shd.g_old_rec.exclusion_rule_id;
263: End If;
264: --
265: End convert_defs;
266: --

Line 272: ,p_rec in out nocopy pay_tfu_shd.g_rec_type

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

Line 282: pay_tfu_shd.lck

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

Line 333: l_rec pay_tfu_shd.g_rec_type;

329: ,p_object_id in number default hr_api.g_number
330: ,p_exclusion_rule_id in number default hr_api.g_number
331: ) is
332: --
333: l_rec pay_tfu_shd.g_rec_type;
334: l_proc varchar2(72) := g_package||'upd';
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);

Line 343: pay_tfu_shd.convert_args

339: -- Call conversion function to turn arguments into the
340: -- l_rec structure.
341: --
342: l_rec :=
343: pay_tfu_shd.convert_args
344: (p_template_ff_usage_id
345: ,hr_api.g_number
346: ,p_formula_id
347: ,p_object_id