DBA Data[Home] [Help]

APPS.PAY_SGB_INS dependencies on PAY_SGB_SHD

Line 54: (p_rec in out nocopy pay_sgb_shd.g_rec_type

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

Line 93: pay_sgb_shd.constraint_error

89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: pay_sgb_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --

Line 98: pay_sgb_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: pay_sgb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --

Line 103: pay_sgb_shd.constraint_error

99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: pay_sgb_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;

Line 148: (p_rec in out nocopy pay_sgb_shd.g_rec_type

144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_insert
148: (p_rec in out nocopy pay_sgb_shd.g_rec_type
149: ) is
150: --
151: l_proc varchar2(72) := g_package||'pre_insert';
152: --

Line 200: Procedure post_insert(p_rec in pay_sgb_shd.g_rec_type) is

196: -- Internal Row Handler Use Only.
197: --
198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure post_insert(p_rec in pay_sgb_shd.g_rec_type) is
201: --
202: l_proc varchar2(72) := g_package||'post_insert';
203: --
204: Begin

Line 215: ,p_rec in out nocopy pay_sgb_shd.g_rec_type

211: -- |---------------------------------< ins >----------------------------------|
212: -- ----------------------------------------------------------------------------
213: Procedure ins
214: (p_effective_date in date
215: ,p_rec in out nocopy pay_sgb_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'ins';
219: --

Line 260: l_rec pay_sgb_shd.g_rec_type;

256: ,p_grossup_balances_id out nocopy number
257: ,p_object_version_number out nocopy number
258: ) is
259: --
260: l_rec pay_sgb_shd.g_rec_type;
261: l_proc varchar2(72) := g_package||'ins';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);

Line 270: pay_sgb_shd.convert_args

266: -- Call conversion function to turn arguments into the
267: -- p_rec structure.
268: --
269: l_rec :=
270: pay_sgb_shd.convert_args
271: (null
272: ,p_source_id
273: ,p_source_type
274: ,p_balance_type_name