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 NOCOPY 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 NOCOPY ghr_nla_shd.g_rec_type) is
49: --
50: l_proc varchar2(72);
51: --
52: l_rec ghr_nla_shd.g_rec_type;

Line 52: l_rec ghr_nla_shd.g_rec_type;

48: Procedure update_dml(p_rec in out NOCOPY ghr_nla_shd.g_rec_type) is
49: --
50: l_proc varchar2(72);
51: --
52: l_rec ghr_nla_shd.g_rec_type;
53: Begin
54: l_proc := g_package||'update_dml';
55: l_rec := p_rec;
56: hr_utility.set_location('Entering:'||l_proc, 5);

Line 85: ghr_nla_shd.constraint_error

81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: p_rec := l_rec;
85: ghr_nla_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: p_rec := l_rec;

Line 90: ghr_nla_shd.constraint_error

86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: p_rec := l_rec;
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: p_rec := l_rec;

Line 95: 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: p_rec := l_rec;
95: ghr_nla_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: p_rec := l_rec;
99: Raise;

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

130: -- Internal Row Handler Use Only.
131: --
132: -- {End Of Comments}
133: -- ----------------------------------------------------------------------------
134: Procedure pre_update(p_rec in ghr_nla_shd.g_rec_type) is
135: --
136: l_proc varchar2(72) ;
137: --
138: Begin

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

174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure post_update(
178: p_effective_date in date,p_rec in ghr_nla_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) ;
181: --
182: Begin

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

199: ,p_object_version_number =>p_rec.object_version_number
200: ,p_valid_first_lac_flag =>p_rec.valid_first_lac_flag
201: ,p_valid_second_lac_flag =>p_rec.valid_second_lac_flag
202: ,p_effective_date =>p_effective_date
203: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
204: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
205: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
206: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
207: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to

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

200: ,p_valid_first_lac_flag =>p_rec.valid_first_lac_flag
201: ,p_valid_second_lac_flag =>p_rec.valid_second_lac_flag
202: ,p_effective_date =>p_effective_date
203: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
204: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
205: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
206: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
207: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
208: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number

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

201: ,p_valid_second_lac_flag =>p_rec.valid_second_lac_flag
202: ,p_effective_date =>p_effective_date
203: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
204: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
205: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
206: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
207: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
208: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
209: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag

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

202: ,p_effective_date =>p_effective_date
203: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
204: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
205: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
206: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
207: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
208: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
209: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
210: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag

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

203: ,p_nature_of_action_id_o =>ghr_nla_shd.g_old_rec.nature_of_action_id
204: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
205: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
206: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
207: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
208: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
209: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
210: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
211: );

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

204: ,p_lac_lookup_code_o =>ghr_nla_shd.g_old_rec.lac_lookup_code
205: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
206: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
207: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
208: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
209: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
210: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
211: );
212: --

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

205: ,p_enabled_flag_o =>ghr_nla_shd.g_old_rec.enabled_flag
206: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
207: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
208: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
209: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
210: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
211: );
212: --
213: exception

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

206: ,p_date_from_o =>ghr_nla_shd.g_old_rec.date_from
207: ,p_date_to_o =>ghr_nla_shd.g_old_rec.date_to
208: ,p_object_version_number_o =>ghr_nla_shd.g_old_rec.object_version_number
209: ,p_valid_first_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_first_lac_flag
210: ,p_valid_second_lac_flag_o =>ghr_nla_shd.g_old_rec.valid_second_lac_flag
211: );
212: --
213: exception
214: --

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

268: -- Internal Row Handler Use Only.
269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure convert_defs(p_rec in out NOCOPY ghr_nla_shd.g_rec_type) is
273: --
274: l_proc varchar2(72);
275: --
276: l_rec ghr_nla_shd.g_rec_type;

Line 276: l_rec ghr_nla_shd.g_rec_type;

272: Procedure convert_defs(p_rec in out NOCOPY ghr_nla_shd.g_rec_type) is
273: --
274: l_proc varchar2(72);
275: --
276: l_rec ghr_nla_shd.g_rec_type;
277: Begin
278: --
279: l_proc := g_package||'convert_defs';
280: l_rec := p_rec;

Line 290: ghr_nla_shd.g_old_rec.nature_of_action_id;

286: -- is being used then we must set to the 'current' argument value.
287: --
288: If (p_rec.nature_of_action_id = hr_api.g_number) then
289: p_rec.nature_of_action_id :=
290: ghr_nla_shd.g_old_rec.nature_of_action_id;
291: End If;
292: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then
293: p_rec.lac_lookup_code :=
294: ghr_nla_shd.g_old_rec.lac_lookup_code;

Line 294: ghr_nla_shd.g_old_rec.lac_lookup_code;

290: ghr_nla_shd.g_old_rec.nature_of_action_id;
291: End If;
292: If (p_rec.lac_lookup_code = hr_api.g_varchar2) then
293: p_rec.lac_lookup_code :=
294: ghr_nla_shd.g_old_rec.lac_lookup_code;
295: End If;
296: If (p_rec.enabled_flag = hr_api.g_varchar2) then
297: p_rec.enabled_flag :=
298: ghr_nla_shd.g_old_rec.enabled_flag;

Line 298: ghr_nla_shd.g_old_rec.enabled_flag;

294: ghr_nla_shd.g_old_rec.lac_lookup_code;
295: End If;
296: If (p_rec.enabled_flag = hr_api.g_varchar2) then
297: p_rec.enabled_flag :=
298: ghr_nla_shd.g_old_rec.enabled_flag;
299: End If;
300: If (p_rec.date_from = hr_api.g_date) then
301: p_rec.date_from :=
302: ghr_nla_shd.g_old_rec.date_from;

Line 302: ghr_nla_shd.g_old_rec.date_from;

298: ghr_nla_shd.g_old_rec.enabled_flag;
299: End If;
300: If (p_rec.date_from = hr_api.g_date) then
301: p_rec.date_from :=
302: ghr_nla_shd.g_old_rec.date_from;
303: End If;
304: If (p_rec.date_to = hr_api.g_date) then
305: p_rec.date_to :=
306: ghr_nla_shd.g_old_rec.date_to;

Line 306: ghr_nla_shd.g_old_rec.date_to;

302: ghr_nla_shd.g_old_rec.date_from;
303: End If;
304: If (p_rec.date_to = hr_api.g_date) then
305: p_rec.date_to :=
306: ghr_nla_shd.g_old_rec.date_to;
307: End If;
308: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then
309: p_rec.valid_first_lac_flag :=
310: ghr_nla_shd.g_old_rec.valid_first_lac_flag;

Line 310: ghr_nla_shd.g_old_rec.valid_first_lac_flag;

306: ghr_nla_shd.g_old_rec.date_to;
307: End If;
308: If (p_rec.valid_first_lac_flag = hr_api.g_varchar2) then
309: p_rec.valid_first_lac_flag :=
310: ghr_nla_shd.g_old_rec.valid_first_lac_flag;
311: End If;
312: If (p_rec.valid_second_lac_flag = hr_api.g_varchar2) then
313: p_rec.valid_second_lac_flag :=
314: ghr_nla_shd.g_old_rec.valid_second_lac_flag;

Line 314: ghr_nla_shd.g_old_rec.valid_second_lac_flag;

310: ghr_nla_shd.g_old_rec.valid_first_lac_flag;
311: End If;
312: If (p_rec.valid_second_lac_flag = hr_api.g_varchar2) then
313: p_rec.valid_second_lac_flag :=
314: ghr_nla_shd.g_old_rec.valid_second_lac_flag;
315: End If;
316: --
317: hr_utility.set_location(' Leaving:'||l_proc, 10);
318: --

Line 331: p_rec in out NOCOPY ghr_nla_shd.g_rec_type

327: -- ----------------------------------------------------------------------------
328: Procedure upd
329: (
330: p_effective_date in date,
331: p_rec in out NOCOPY ghr_nla_shd.g_rec_type
332: ) is
333: --
334: l_proc varchar2(72);
335: l_rec ghr_nla_shd.g_rec_type;

Line 335: l_rec ghr_nla_shd.g_rec_type;

331: p_rec in out NOCOPY ghr_nla_shd.g_rec_type
332: ) is
333: --
334: l_proc varchar2(72);
335: l_rec ghr_nla_shd.g_rec_type;
336: --
337: Begin
338: l_proc := g_package||'upd';
339: hr_utility.set_location('Entering:'||l_proc, 5);

Line 344: ghr_nla_shd.lck

340: l_rec := p_rec;
341: --
342: -- We must lock the row which we need to update.
343: --
344: ghr_nla_shd.lck
345: (
346: p_rec.noac_la_id,
347: p_rec.object_version_number
348: );

Line 395: l_rec ghr_nla_shd.g_rec_type;

391: p_valid_first_lac_flag in varchar2 default hr_api.g_varchar2,
392: p_valid_second_lac_flag in varchar2 default hr_api.g_varchar2
393: ) is
394: --
395: l_rec ghr_nla_shd.g_rec_type;
396: l_proc varchar2(72);
397: l_object_version_number number;
398: --
399: Begin

Line 408: ghr_nla_shd.convert_args

404: -- Call conversion function to turn arguments into the
405: -- l_rec structure.
406: --
407: l_rec :=
408: ghr_nla_shd.convert_args
409: (
410: p_noac_la_id,
411: p_nature_of_action_id,
412: p_lac_lookup_code,