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_UPD dependencies on GHR_NLA_SHD

Line 48: Procedure update_dml(p_rec in out ghr_nla_shd.g_rec_type) is

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

Line 81: ghr_nla_shd.constraint_error

77: --
78: Exception
79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: ghr_nla_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: ghr_nla_shd.constraint_error

Line 85: ghr_nla_shd.constraint_error

81: ghr_nla_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: ghr_nla_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: ghr_nla_shd.constraint_error

Line 89: ghr_nla_shd.constraint_error

85: ghr_nla_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: ghr_nla_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
92: Raise;
93: End update_dml;

Line 127: Procedure pre_update(p_rec in ghr_nla_shd.g_rec_type) is

123: -- Internal Row Handler Use Only.
124: --
125: -- {End Of Comments}
126: -- ----------------------------------------------------------------------------
127: Procedure pre_update(p_rec in ghr_nla_shd.g_rec_type) is
128: --
129: l_proc varchar2(72) := g_package||'pre_update';
130: --
131: Begin

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

166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure post_update(
170: p_effective_date in date,p_rec in ghr_nla_shd.g_rec_type) is
171: --
172: l_proc varchar2(72) := g_package||'post_update';
173: --
174: Begin

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

190: ,p_object_version_number =>p_rec.object_version_number
191: ,p_valid_first_lac_flag =>p_rec.valid_first_lac_flag
192: ,p_valid_second_lac_flag =>p_rec.valid_second_lac_flag
193: ,p_effective_date =>p_effective_date
194: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
195: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
196: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
197: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
198: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to

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

191: ,p_valid_first_lac_flag =>p_rec.valid_first_lac_flag
192: ,p_valid_second_lac_flag =>p_rec.valid_second_lac_flag
193: ,p_effective_date =>p_effective_date
194: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
195: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
196: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
197: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
198: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
199: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number

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

192: ,p_valid_second_lac_flag =>p_rec.valid_second_lac_flag
193: ,p_effective_date =>p_effective_date
194: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
195: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
196: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
197: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
198: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
199: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
200: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag

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

193: ,p_effective_date =>p_effective_date
194: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
195: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
196: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
197: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
198: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
199: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
200: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
201: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag

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

194: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
195: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
196: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
197: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
198: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
199: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
200: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
201: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
202: );

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

195: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
196: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
197: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
198: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
199: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
200: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
201: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
202: );
203: --

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

196: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
197: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
198: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
199: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
200: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
201: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
202: );
203: --
204: exception

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

197: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
198: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
199: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
200: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
201: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
202: );
203: --
204: exception
205: --

Line 263: Procedure convert_defs(p_rec in out ghr_nla_shd.g_rec_type) is

259: -- Internal Row Handler Use Only.
260: --
261: -- {End Of Comments}
262: -- ----------------------------------------------------------------------------
263: Procedure convert_defs(p_rec in out ghr_nla_shd.g_rec_type) is
264: --
265: l_proc varchar2(72) := g_package||'convert_defs';
266: --
267: Begin

Line 278: ghr_nla_shd.g_old_rec.nature_of_action_id;

274: -- is being used then we must set to the 'current' argument value.
275: --
276: If (p_rec.nature_of_action_id = hr_api.g_number) then
277: p_rec.nature_of_action_id :=
278: ghr_nla_shd.g_old_rec.nature_of_action_id;
279: End If;
280: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then
281: p_rec.lac_lookup_code :=
282: ghr_nla_shd.g_old_rec.lac_lookup_code;

Line 282: ghr_nla_shd.g_old_rec.lac_lookup_code;

278: ghr_nla_shd.g_old_rec.nature_of_action_id;
279: End If;
280: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then
281: p_rec.lac_lookup_code :=
282: ghr_nla_shd.g_old_rec.lac_lookup_code;
283: End If;
284: If (p_rec.enabled_flag = hr_api.g_varchar2) then
285: p_rec.enabled_flag :=
286: ghr_nla_shd.g_old_rec.enabled_flag;

Line 286: ghr_nla_shd.g_old_rec.enabled_flag;

282: ghr_nla_shd.g_old_rec.lac_lookup_code;
283: End If;
284: If (p_rec.enabled_flag = hr_api.g_varchar2) then
285: p_rec.enabled_flag :=
286: ghr_nla_shd.g_old_rec.enabled_flag;
287: End If;
288: If (p_rec.date_from = hr_api.g_date) then
289: p_rec.date_from :=
290: ghr_nla_shd.g_old_rec.date_from;

Line 290: ghr_nla_shd.g_old_rec.date_from;

286: ghr_nla_shd.g_old_rec.enabled_flag;
287: End If;
288: If (p_rec.date_from = hr_api.g_date) then
289: p_rec.date_from :=
290: ghr_nla_shd.g_old_rec.date_from;
291: End If;
292: If (p_rec.date_to = hr_api.g_date) then
293: p_rec.date_to :=
294: ghr_nla_shd.g_old_rec.date_to;

Line 294: ghr_nla_shd.g_old_rec.date_to;

290: ghr_nla_shd.g_old_rec.date_from;
291: End If;
292: If (p_rec.date_to = hr_api.g_date) then
293: p_rec.date_to :=
294: ghr_nla_shd.g_old_rec.date_to;
295: End If;
296: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then
297: p_rec.valid_first_lac_flag :=
298: ghr_nla_shd.g_old_rec.valid_first_lac_flag;

Line 298: ghr_nla_shd.g_old_rec.valid_first_lac_flag;

294: ghr_nla_shd.g_old_rec.date_to;
295: End If;
296: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then
297: p_rec.valid_first_lac_flag :=
298: ghr_nla_shd.g_old_rec.valid_first_lac_flag;
299: End If;
300: If (p_rec.valid_second_lac_flag = hr_api.g_varchar2) then
301: p_rec.valid_second_lac_flag :=
302: ghr_nla_shd.g_old_rec.valid_second_lac_flag;

Line 302: ghr_nla_shd.g_old_rec.valid_second_lac_flag;

298: ghr_nla_shd.g_old_rec.valid_first_lac_flag;
299: End If;
300: If (p_rec.valid_second_lac_flag = hr_api.g_varchar2) then
301: p_rec.valid_second_lac_flag :=
302: ghr_nla_shd.g_old_rec.valid_second_lac_flag;
303: End If;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: --

Line 315: p_rec in out ghr_nla_shd.g_rec_type

311: -- ----------------------------------------------------------------------------
312: Procedure upd
313: (
314: p_effective_date in date,
315: p_rec in out ghr_nla_shd.g_rec_type
316: ) is
317: --
318: l_proc varchar2(72) := g_package||'upd';
319: --

Line 325: ghr_nla_shd.lck

321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: -- We must lock the row which we need to update.
324: --
325: ghr_nla_shd.lck
326: (
327: p_rec.noac_la_id,
328: p_rec.object_version_number
329: );

Line 372: l_rec ghr_nla_shd.g_rec_type;

368: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
369: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
370: ) is
371: --
372: l_rec ghr_nla_shd.g_rec_type;
373: l_proc varchar2(72) := g_package||'upd';
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);

Line 382: ghr_nla_shd.convert_args

378: -- Call conversion function to turn arguments into the
379: -- l_rec structure.
380: --
381: l_rec :=
382: ghr_nla_shd.convert_args
383: (
384: p_noac_la_id,
385: p_nature_of_action_id,
386: p_lac_lookup_code,