DBA Data[Home] [Help]

APPS.PAY_PTA_INS dependencies on PAY_PTA_SHD

Line 54: (p_rec in out nocopy pay_pta_shd.g_rec_type

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

Line 103: pay_pta_shd.constraint_error

99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: --
103: pay_pta_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: --

Line 108: pay_pta_shd.constraint_error

104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: --
108: pay_pta_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: --

Line 113: pay_pta_shd.constraint_error

109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: --
113: pay_pta_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When Others Then
116: --
117: Raise;

Line 158: (p_rec in out nocopy pay_pta_shd.g_rec_type

154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure pre_insert
158: (p_rec in out nocopy pay_pta_shd.g_rec_type
159: ) is
160: --
161: l_proc varchar2(72) := g_package||'pre_insert';
162: --

Line 219: (p_rec in pay_pta_shd.g_rec_type

215: --
216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: Procedure post_insert
219: (p_rec in pay_pta_shd.g_rec_type
220: ) is
221: --
222: l_proc varchar2(72) := g_package||'post_insert';
223: --

Line 272: (p_rec in out nocopy pay_pta_shd.g_rec_type

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

Line 321: l_rec pay_pta_shd.g_rec_type;

317: ,p_dyn_trigger_package_name in varchar2 default null
318: ,p_dyn_trig_pkg_generated in varchar2 default null
319: ) is
320: --
321: l_rec pay_pta_shd.g_rec_type;
322: l_proc varchar2(72) := g_package||'ins';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);

Line 331: pay_pta_shd.convert_args

327: -- Call conversion function to turn arguments into the
328: -- p_rec structure.
329: --
330: l_rec :=
331: pay_pta_shd.convert_args
332: (null
333: ,p_table_name
334: ,p_application_id
335: ,p_surrogate_key_name