eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_NLA_DEL dependencies on GHR_NLA_SHD

Line 45: Procedure delete_dml(p_rec in ghr_nla_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_nla_shd.g_rec_type) is
46: --
47: l_proc varchar2(72);
48: --
49: Begin

Line 65: ghr_nla_shd.constraint_error

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

Line 103: Procedure pre_delete(p_rec in ghr_nla_shd.g_rec_type) is

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

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

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

Line 163: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id

159: --
160: ghr_nla_rkd.after_delete
161: (
162: p_noac_la_id =>p_rec.noac_la_id
163: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
164: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
165: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
166: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
167: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to

Line 164: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code

160: ghr_nla_rkd.after_delete
161: (
162: p_noac_la_id =>p_rec.noac_la_id
163: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
164: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
165: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
166: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
167: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
168: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number

Line 165: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag

161: (
162: p_noac_la_id =>p_rec.noac_la_id
163: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
164: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
165: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
166: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
167: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
168: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
169: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag

Line 166: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from

162: p_noac_la_id =>p_rec.noac_la_id
163: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
164: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
165: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
166: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
167: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
168: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
169: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
170: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag

Line 167: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to

163: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
164: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
165: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
166: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
167: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
168: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
169: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
170: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
171: );

Line 168: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number

164: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
165: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
166: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
167: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
168: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
169: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
170: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
171: );
172: --

Line 169: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag

165: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
166: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
167: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
168: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
169: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
170: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
171: );
172: --
173: exception

Line 170: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag

166: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
167: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
168: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
169: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
170: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
171: );
172: --
173: exception
174: --

Line 195: p_rec in ghr_nla_shd.g_rec_type

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

Line 206: ghr_nla_shd.lck

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

Line 241: l_rec ghr_nla_shd.g_rec_type;

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