APPS.PAY_SF_INS dependencies on PAY_SF_SHD

Line 50: Procedure insert_dml(p_rec in out nocopy pay_sf_shd.g_rec_type) is

46: -- Internal Row Handler Use Only.
47: --
48: -- {End Of Comments}
49: -- ----------------------------------------------------------------------------
50: Procedure insert_dml(p_rec in out nocopy pay_sf_shd.g_rec_type) is
51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin

Line 89: pay_sf_shd.constraint_error

85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pay_sf_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pay_sf_shd.constraint_error

Line 93: pay_sf_shd.constraint_error

89: pay_sf_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pay_sf_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: pay_sf_shd.constraint_error

Line 97: pay_sf_shd.constraint_error

93: pay_sf_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: pay_sf_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: Raise;
101: End insert_dml;

Line 140: Procedure pre_insert(p_rec in out nocopy pay_sf_shd.g_rec_type) is

136: -- Internal Row Handler Use Only.
137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_insert(p_rec in out nocopy pay_sf_shd.g_rec_type) is
141: --
142: l_proc varchar2(72) := g_package||'pre_insert';
143: --
144: Cursor C_Sel1 is select pay_shadow_formulas_s.nextval from sys.dual;

Line 191: Procedure post_insert(p_rec in pay_sf_shd.g_rec_type) is

187: -- Internal Row Handler Use Only.
188: --
189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure post_insert(p_rec in pay_sf_shd.g_rec_type) is
192: --
193: l_proc varchar2(72) := g_package||'post_insert';
194: --
195: Begin

Line 206: ,p_rec in out nocopy pay_sf_shd.g_rec_type

202: -- |---------------------------------< ins >----------------------------------|
203: -- ----------------------------------------------------------------------------
204: Procedure ins
205: (p_effective_date in date
206: ,p_rec in out nocopy pay_sf_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'ins';
210: --

Line 248: l_rec pay_sf_shd.g_rec_type;

244: p_formula_type_name in varchar2 default null,
245: p_object_version_number out nocopy number
246: ) is
247: --
248: l_rec pay_sf_shd.g_rec_type;
249: l_proc varchar2(72) := g_package||'ins';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);

Line 258: pay_sf_shd.convert_args

254: -- Call conversion function to turn arguments into the
255: -- p_rec structure.
256: --
257: l_rec :=
258: pay_sf_shd.convert_args
259: (
260: null,
261: p_template_type,
262: p_legislation_code,