APPS.PAY_SFR_INS dependencies on PAY_SFR_SHD

Line 50: Procedure insert_dml(p_rec in out nocopy pay_sfr_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_sfr_shd.g_rec_type) is
51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin

Line 91: pay_sfr_shd.constraint_error

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

Line 95: pay_sfr_shd.constraint_error

91: pay_sfr_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: pay_sfr_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: pay_sfr_shd.constraint_error

Line 99: pay_sfr_shd.constraint_error

95: pay_sfr_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: pay_sfr_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: Raise;
103: End insert_dml;

Line 142: Procedure pre_insert(p_rec in out nocopy pay_sfr_shd.g_rec_type) is

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

Line 193: Procedure post_insert(p_rec in pay_sfr_shd.g_rec_type) is

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

Line 209: p_rec in out nocopy pay_sfr_shd.g_rec_type

205: -- ----------------------------------------------------------------------------
206: Procedure ins
207: (
208: p_effective_date in date,
209: p_rec in out nocopy pay_sfr_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72) := g_package||'ins';
213: --

Line 252: l_rec pay_sfr_shd.g_rec_type;

248: p_element_name in varchar2 default null,
249: p_object_version_number out nocopy number
250: ) is
251: --
252: l_rec pay_sfr_shd.g_rec_type;
253: l_proc varchar2(72) := g_package||'ins';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);

Line 262: pay_sfr_shd.convert_args

258: -- Call conversion function to turn arguments into the
259: -- p_rec structure.
260: --
261: l_rec :=
262: pay_sfr_shd.convert_args
263: (
264: null,
265: p_shadow_element_type_id,
266: p_element_type_id,