DBA Data[Home] [Help]

APPS.GHR_NRE_DEL dependencies on GHR_NRE_SHD

Line 45: Procedure delete_dml(p_rec in ghr_nre_shd.g_rec_type) is

41: -- Internal Row Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in ghr_nre_shd.g_rec_type) is
46: --
47: l_proc varchar2(72);
48: --
49: Begin

Line 66: ghr_nre_shd.constraint_error

62: --
63: Exception
64: When hr_api.child_integrity_violated then
65: -- Child integrity has been violated
66: ghr_nre_shd.constraint_error
67: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
68: When Others Then
69: Raise;
70: End delete_dml;

Line 104: Procedure pre_delete(p_rec in ghr_nre_shd.g_rec_type) is

100: -- Internal Row Handler Use Only.
101: --
102: -- {End Of Comments}
103: -- ----------------------------------------------------------------------------
104: Procedure pre_delete(p_rec in ghr_nre_shd.g_rec_type) is
105: --
106: l_proc varchar2(72) := g_package||'pre_delete';
107: --
108: Begin

Line 149: p_effective_date in date,p_rec in ghr_nre_shd.g_rec_type) is

145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure post_delete(
149: p_effective_date in date,p_rec in ghr_nre_shd.g_rec_type) is
150: --
151: l_proc varchar2(72);
152: --
153: Begin

Line 165: ,p_nature_of_action_id_o =>ghr_nre_shd.g_old_rec.nature_of_action_id

161: --
162: ghr_nre_rkd.after_delete
163: (
164: p_noac_remark_id =>p_rec.noac_remark_id
165: ,p_nature_of_action_id_o =>ghr_nre_shd.g_old_rec.nature_of_action_id
166: ,p_remark_id_o =>ghr_nre_shd.g_old_rec.remark_id
167: ,p_required_flag_o =>ghr_nre_shd.g_old_rec.required_flag
168: ,p_enabled_flag_o =>ghr_nre_shd.g_old_rec.enabled_flag
169: ,p_date_from_o =>ghr_nre_shd.g_old_rec.date_from

Line 166: ,p_remark_id_o =>ghr_nre_shd.g_old_rec.remark_id

162: ghr_nre_rkd.after_delete
163: (
164: p_noac_remark_id =>p_rec.noac_remark_id
165: ,p_nature_of_action_id_o =>ghr_nre_shd.g_old_rec.nature_of_action_id
166: ,p_remark_id_o =>ghr_nre_shd.g_old_rec.remark_id
167: ,p_required_flag_o =>ghr_nre_shd.g_old_rec.required_flag
168: ,p_enabled_flag_o =>ghr_nre_shd.g_old_rec.enabled_flag
169: ,p_date_from_o =>ghr_nre_shd.g_old_rec.date_from
170: ,p_date_to_o =>ghr_nre_shd.g_old_rec.date_to

Line 167: ,p_required_flag_o =>ghr_nre_shd.g_old_rec.required_flag

163: (
164: p_noac_remark_id =>p_rec.noac_remark_id
165: ,p_nature_of_action_id_o =>ghr_nre_shd.g_old_rec.nature_of_action_id
166: ,p_remark_id_o =>ghr_nre_shd.g_old_rec.remark_id
167: ,p_required_flag_o =>ghr_nre_shd.g_old_rec.required_flag
168: ,p_enabled_flag_o =>ghr_nre_shd.g_old_rec.enabled_flag
169: ,p_date_from_o =>ghr_nre_shd.g_old_rec.date_from
170: ,p_date_to_o =>ghr_nre_shd.g_old_rec.date_to
171: ,p_object_version_number_o =>ghr_nre_shd.g_old_rec.object_version_number

Line 168: ,p_enabled_flag_o =>ghr_nre_shd.g_old_rec.enabled_flag

164: p_noac_remark_id =>p_rec.noac_remark_id
165: ,p_nature_of_action_id_o =>ghr_nre_shd.g_old_rec.nature_of_action_id
166: ,p_remark_id_o =>ghr_nre_shd.g_old_rec.remark_id
167: ,p_required_flag_o =>ghr_nre_shd.g_old_rec.required_flag
168: ,p_enabled_flag_o =>ghr_nre_shd.g_old_rec.enabled_flag
169: ,p_date_from_o =>ghr_nre_shd.g_old_rec.date_from
170: ,p_date_to_o =>ghr_nre_shd.g_old_rec.date_to
171: ,p_object_version_number_o =>ghr_nre_shd.g_old_rec.object_version_number
172: );

Line 169: ,p_date_from_o =>ghr_nre_shd.g_old_rec.date_from

165: ,p_nature_of_action_id_o =>ghr_nre_shd.g_old_rec.nature_of_action_id
166: ,p_remark_id_o =>ghr_nre_shd.g_old_rec.remark_id
167: ,p_required_flag_o =>ghr_nre_shd.g_old_rec.required_flag
168: ,p_enabled_flag_o =>ghr_nre_shd.g_old_rec.enabled_flag
169: ,p_date_from_o =>ghr_nre_shd.g_old_rec.date_from
170: ,p_date_to_o =>ghr_nre_shd.g_old_rec.date_to
171: ,p_object_version_number_o =>ghr_nre_shd.g_old_rec.object_version_number
172: );
173: --

Line 170: ,p_date_to_o =>ghr_nre_shd.g_old_rec.date_to

166: ,p_remark_id_o =>ghr_nre_shd.g_old_rec.remark_id
167: ,p_required_flag_o =>ghr_nre_shd.g_old_rec.required_flag
168: ,p_enabled_flag_o =>ghr_nre_shd.g_old_rec.enabled_flag
169: ,p_date_from_o =>ghr_nre_shd.g_old_rec.date_from
170: ,p_date_to_o =>ghr_nre_shd.g_old_rec.date_to
171: ,p_object_version_number_o =>ghr_nre_shd.g_old_rec.object_version_number
172: );
173: --
174: exception

Line 171: ,p_object_version_number_o =>ghr_nre_shd.g_old_rec.object_version_number

167: ,p_required_flag_o =>ghr_nre_shd.g_old_rec.required_flag
168: ,p_enabled_flag_o =>ghr_nre_shd.g_old_rec.enabled_flag
169: ,p_date_from_o =>ghr_nre_shd.g_old_rec.date_from
170: ,p_date_to_o =>ghr_nre_shd.g_old_rec.date_to
171: ,p_object_version_number_o =>ghr_nre_shd.g_old_rec.object_version_number
172: );
173: --
174: exception
175: --

Line 196: p_rec in ghr_nre_shd.g_rec_type

192: -- ----------------------------------------------------------------------------
193: Procedure del
194: (
195: p_effective_date in date,
196: p_rec in ghr_nre_shd.g_rec_type
197: ) is
198: --
199: l_proc varchar2(72);
200: --

Line 207: ghr_nre_shd.lck

203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: -- We must lock the row which we need to delete.
206: --
207: ghr_nre_shd.lck
208: (
209: p_rec.noac_remark_id,
210: p_rec.object_version_number
211: );

Line 242: l_rec ghr_nre_shd.g_rec_type;

238: p_noac_remark_id in number,
239: p_object_version_number in number
240: ) is
241: --
242: l_rec ghr_nre_shd.g_rec_type;
243: l_proc varchar2(72);
244: --
245: Begin
246: l_proc := g_package||'del';