DBA Data[Home] [Help]

APPS.GHR_NLA_INS dependencies on GHR_NLA_SHD

Line 47: Procedure insert_dml(p_rec in out ghr_nla_shd.g_rec_type) is

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

Line 86: ghr_nla_shd.constraint_error

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

Line 90: ghr_nla_shd.constraint_error

86: ghr_nla_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: ghr_nla_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: ghr_nla_shd.constraint_error

Line 94: ghr_nla_shd.constraint_error

90: ghr_nla_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: ghr_nla_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When Others Then
97: Raise;
98: End insert_dml;

Line 137: Procedure pre_insert(p_rec in out ghr_nla_shd.g_rec_type) is

133: -- Internal Row Handler Use Only.
134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure pre_insert(p_rec in out ghr_nla_shd.g_rec_type) is
138: --
139: l_proc varchar2(72) := g_package||'pre_insert';
140: --
141: Cursor C_Sel1 is select ghr_noac_las_s.nextval from sys.dual;

Line 189: p_effective_date in date,p_rec in ghr_nla_shd.g_rec_type) is

185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure post_insert(
189: p_effective_date in date,p_rec in ghr_nla_shd.g_rec_type) is
190: --
191: l_proc varchar2(72) := g_package||'post_insert';
192: --
193: Begin

Line 237: p_rec in out ghr_nla_shd.g_rec_type

233: -- ----------------------------------------------------------------------------
234: Procedure ins
235: (
236: p_effective_date in date,
237: p_rec in out ghr_nla_shd.g_rec_type
238: ) is
239: --
240: l_proc varchar2(72) := g_package||'ins';
241: --

Line 281: l_rec ghr_nla_shd.g_rec_type;

277: p_valid_first_lac_flag in varchar2,
278: p_valid_second_lac_flag in varchar2
279: ) is
280: --
281: l_rec ghr_nla_shd.g_rec_type;
282: l_proc varchar2(72) := g_package||'ins';
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);

Line 291: ghr_nla_shd.convert_args

287: -- Call conversion function to turn arguments into the
288: -- p_rec structure.
289: --
290: l_rec :=
291: ghr_nla_shd.convert_args
292: (
293: null,
294: p_nature_of_action_id,
295: p_lac_lookup_code,