DBA Data[Home] [Help]

APPS.PAY_TFU_INS dependencies on PAY_TFU_SHD

Line 76: (p_rec in out nocopy pay_tfu_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy pay_tfu_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 113: pay_tfu_shd.constraint_error

109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: pay_tfu_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --

Line 118: pay_tfu_shd.constraint_error

114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: pay_tfu_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --

Line 123: pay_tfu_shd.constraint_error

119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: pay_tfu_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
127: Raise;

Line 168: (p_rec in out nocopy pay_tfu_shd.g_rec_type

164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure pre_insert
168: (p_rec in out nocopy pay_tfu_shd.g_rec_type
169: ) is
170: --
171: Cursor C_Sel1 is select pay_template_ff_usages_s.nextval from sys.dual;
172: --

Line 256: ,p_rec in pay_tfu_shd.g_rec_type

252: -- {End Of Comments}
253: -- ----------------------------------------------------------------------------
254: Procedure post_insert
255: (p_effective_date in date
256: ,p_rec in pay_tfu_shd.g_rec_type
257: ) is
258: --
259: l_proc varchar2(72) := g_package||'post_insert';
260: --

Line 272: ,p_rec in out nocopy pay_tfu_shd.g_rec_type

268: -- |---------------------------------< ins >----------------------------------|
269: -- ----------------------------------------------------------------------------
270: Procedure ins
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||'ins';
276: --

Line 324: l_rec pay_tfu_shd.g_rec_type;

320: ,p_template_ff_usage_id out nocopy number
321: ,p_object_version_number out nocopy number
322: ) is
323: --
324: l_rec pay_tfu_shd.g_rec_type;
325: l_proc varchar2(72) := g_package||'ins';
326: --
327: Begin
328: hr_utility.set_location('Entering:'||l_proc, 5);

Line 334: pay_tfu_shd.convert_args

330: -- Call conversion function to turn arguments into the
331: -- p_rec structure.
332: --
333: l_rec :=
334: pay_tfu_shd.convert_args
335: (null
336: ,p_template_id
337: ,p_formula_id
338: ,p_object_id