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.PER_NAA_UPD dependencies on PER_NAA_SHD

Line 55: (p_rec in out nocopy per_naa_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_naa_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 66: per_naa_shd.g_api_dml := true; -- Set the api dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_naa_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_nl_absence_actions Row
69: --
70: update per_nl_absence_actions

Line 85: per_naa_shd.g_api_dml := false; -- Unset the api dml status

81: ,object_version_number = p_rec.object_version_number
82: ,enabled = p_rec.enabled
83: where absence_action_id = p_rec.absence_action_id;
84: --
85: per_naa_shd.g_api_dml := false; -- Unset the api dml status
86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: --
89: Exception

Line 92: per_naa_shd.g_api_dml := false; -- Unset the api dml status

88: --
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: per_naa_shd.g_api_dml := false; -- Unset the api dml status
93: per_naa_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated

Line 93: per_naa_shd.constraint_error

89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: per_naa_shd.g_api_dml := false; -- Unset the api dml status
93: per_naa_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: per_naa_shd.g_api_dml := false; -- Unset the api dml status

Line 97: per_naa_shd.g_api_dml := false; -- Unset the api dml status

93: per_naa_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: per_naa_shd.g_api_dml := false; -- Unset the api dml status
98: per_naa_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated

Line 98: per_naa_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: per_naa_shd.g_api_dml := false; -- Unset the api dml status
98: per_naa_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: per_naa_shd.g_api_dml := false; -- Unset the api dml status

Line 102: per_naa_shd.g_api_dml := false; -- Unset the api dml status

98: per_naa_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: per_naa_shd.g_api_dml := false; -- Unset the api dml status
103: per_naa_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: per_naa_shd.g_api_dml := false; -- Unset the api dml status

Line 103: per_naa_shd.constraint_error

99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: per_naa_shd.g_api_dml := false; -- Unset the api dml status
103: per_naa_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: per_naa_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;

Line 106: per_naa_shd.g_api_dml := false; -- Unset the api dml status

102: per_naa_shd.g_api_dml := false; -- Unset the api dml status
103: per_naa_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: per_naa_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;
108: End update_dml;
109: --
110: -- ----------------------------------------------------------------------------

Line 143: (p_rec in per_naa_shd.g_rec_type

139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure pre_update
143: (p_rec in per_naa_shd.g_rec_type
144: ) is
145: --
146: l_proc varchar2(72) := g_package||'pre_update';
147: --

Line 187: (p_rec in per_naa_shd.g_rec_type

183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure post_update
187: (p_rec in per_naa_shd.g_rec_type
188: ) is
189: --
190: l_proc varchar2(72) := g_package||'post_update';
191: --

Line 220: => per_naa_shd.g_old_rec.absence_attendance_id

216: => p_rec.last_updated_by
217: ,p_object_version_number
218: => p_rec.object_version_number
219: ,p_absence_attendance_id_o
220: => per_naa_shd.g_old_rec.absence_attendance_id
221: ,p_expected_date_o
222: => per_naa_shd.g_old_rec.expected_date
223: ,p_description_o
224: => per_naa_shd.g_old_rec.description

Line 222: => per_naa_shd.g_old_rec.expected_date

218: => p_rec.object_version_number
219: ,p_absence_attendance_id_o
220: => per_naa_shd.g_old_rec.absence_attendance_id
221: ,p_expected_date_o
222: => per_naa_shd.g_old_rec.expected_date
223: ,p_description_o
224: => per_naa_shd.g_old_rec.description
225: ,p_actual_start_date_o
226: => per_naa_shd.g_old_rec.actual_start_date

Line 224: => per_naa_shd.g_old_rec.description

220: => per_naa_shd.g_old_rec.absence_attendance_id
221: ,p_expected_date_o
222: => per_naa_shd.g_old_rec.expected_date
223: ,p_description_o
224: => per_naa_shd.g_old_rec.description
225: ,p_actual_start_date_o
226: => per_naa_shd.g_old_rec.actual_start_date
227: ,p_actual_end_date_o
228: => per_naa_shd.g_old_rec.actual_end_date

Line 226: => per_naa_shd.g_old_rec.actual_start_date

222: => per_naa_shd.g_old_rec.expected_date
223: ,p_description_o
224: => per_naa_shd.g_old_rec.description
225: ,p_actual_start_date_o
226: => per_naa_shd.g_old_rec.actual_start_date
227: ,p_actual_end_date_o
228: => per_naa_shd.g_old_rec.actual_end_date
229: ,p_holder_o
230: => per_naa_shd.g_old_rec.holder

Line 228: => per_naa_shd.g_old_rec.actual_end_date

224: => per_naa_shd.g_old_rec.description
225: ,p_actual_start_date_o
226: => per_naa_shd.g_old_rec.actual_start_date
227: ,p_actual_end_date_o
228: => per_naa_shd.g_old_rec.actual_end_date
229: ,p_holder_o
230: => per_naa_shd.g_old_rec.holder
231: ,p_comments_o
232: => per_naa_shd.g_old_rec.comments

Line 230: => per_naa_shd.g_old_rec.holder

226: => per_naa_shd.g_old_rec.actual_start_date
227: ,p_actual_end_date_o
228: => per_naa_shd.g_old_rec.actual_end_date
229: ,p_holder_o
230: => per_naa_shd.g_old_rec.holder
231: ,p_comments_o
232: => per_naa_shd.g_old_rec.comments
233: ,p_document_file_name_o
234: => per_naa_shd.g_old_rec.document_file_name

Line 232: => per_naa_shd.g_old_rec.comments

228: => per_naa_shd.g_old_rec.actual_end_date
229: ,p_holder_o
230: => per_naa_shd.g_old_rec.holder
231: ,p_comments_o
232: => per_naa_shd.g_old_rec.comments
233: ,p_document_file_name_o
234: => per_naa_shd.g_old_rec.document_file_name
235: ,p_last_updated_by_o
236: => per_naa_shd.g_old_rec.last_updated_by

Line 234: => per_naa_shd.g_old_rec.document_file_name

230: => per_naa_shd.g_old_rec.holder
231: ,p_comments_o
232: => per_naa_shd.g_old_rec.comments
233: ,p_document_file_name_o
234: => per_naa_shd.g_old_rec.document_file_name
235: ,p_last_updated_by_o
236: => per_naa_shd.g_old_rec.last_updated_by
237: ,p_object_version_number_o
238: => per_naa_shd.g_old_rec.object_version_number

Line 236: => per_naa_shd.g_old_rec.last_updated_by

232: => per_naa_shd.g_old_rec.comments
233: ,p_document_file_name_o
234: => per_naa_shd.g_old_rec.document_file_name
235: ,p_last_updated_by_o
236: => per_naa_shd.g_old_rec.last_updated_by
237: ,p_object_version_number_o
238: => per_naa_shd.g_old_rec.object_version_number
239: ,p_enabled_o
240: => per_naa_shd.g_old_rec.enabled

Line 238: => per_naa_shd.g_old_rec.object_version_number

234: => per_naa_shd.g_old_rec.document_file_name
235: ,p_last_updated_by_o
236: => per_naa_shd.g_old_rec.last_updated_by
237: ,p_object_version_number_o
238: => per_naa_shd.g_old_rec.object_version_number
239: ,p_enabled_o
240: => per_naa_shd.g_old_rec.enabled
241: );
242: --

Line 240: => per_naa_shd.g_old_rec.enabled

236: => per_naa_shd.g_old_rec.last_updated_by
237: ,p_object_version_number_o
238: => per_naa_shd.g_old_rec.object_version_number
239: ,p_enabled_o
240: => per_naa_shd.g_old_rec.enabled
241: );
242: --
243: exception
244: --

Line 300: (p_rec in out nocopy per_naa_shd.g_rec_type

296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure convert_defs
300: (p_rec in out nocopy per_naa_shd.g_rec_type
301: ) is
302: --
303: Begin
304: --

Line 312: per_naa_shd.g_old_rec.absence_attendance_id;

308: -- is being used then we must set to the 'current' argument value.
309: --
310: If (p_rec.absence_attendance_id = hr_api.g_number) then
311: p_rec.absence_attendance_id :=
312: per_naa_shd.g_old_rec.absence_attendance_id;
313: End If;
314: If (p_rec.expected_date = hr_api.g_date) then
315: p_rec.expected_date :=
316: per_naa_shd.g_old_rec.expected_date;

Line 316: per_naa_shd.g_old_rec.expected_date;

312: per_naa_shd.g_old_rec.absence_attendance_id;
313: End If;
314: If (p_rec.expected_date = hr_api.g_date) then
315: p_rec.expected_date :=
316: per_naa_shd.g_old_rec.expected_date;
317: End If;
318: If (p_rec.description = hr_api.g_varchar2) then
319: p_rec.description :=
320: per_naa_shd.g_old_rec.description;

Line 320: per_naa_shd.g_old_rec.description;

316: per_naa_shd.g_old_rec.expected_date;
317: End If;
318: If (p_rec.description = hr_api.g_varchar2) then
319: p_rec.description :=
320: per_naa_shd.g_old_rec.description;
321: End If;
322: If (p_rec.actual_start_date = hr_api.g_date) then
323: p_rec.actual_start_date :=
324: per_naa_shd.g_old_rec.actual_start_date;

Line 324: per_naa_shd.g_old_rec.actual_start_date;

320: per_naa_shd.g_old_rec.description;
321: End If;
322: If (p_rec.actual_start_date = hr_api.g_date) then
323: p_rec.actual_start_date :=
324: per_naa_shd.g_old_rec.actual_start_date;
325: End If;
326: If (p_rec.actual_end_date = hr_api.g_date) then
327: p_rec.actual_end_date :=
328: per_naa_shd.g_old_rec.actual_end_date;

Line 328: per_naa_shd.g_old_rec.actual_end_date;

324: per_naa_shd.g_old_rec.actual_start_date;
325: End If;
326: If (p_rec.actual_end_date = hr_api.g_date) then
327: p_rec.actual_end_date :=
328: per_naa_shd.g_old_rec.actual_end_date;
329: End If;
330: If (p_rec.holder = hr_api.g_varchar2) then
331: p_rec.holder :=
332: per_naa_shd.g_old_rec.holder;

Line 332: per_naa_shd.g_old_rec.holder;

328: per_naa_shd.g_old_rec.actual_end_date;
329: End If;
330: If (p_rec.holder = hr_api.g_varchar2) then
331: p_rec.holder :=
332: per_naa_shd.g_old_rec.holder;
333: End If;
334: If (p_rec.comments = hr_api.g_varchar2) then
335: p_rec.comments :=
336: per_naa_shd.g_old_rec.comments;

Line 336: per_naa_shd.g_old_rec.comments;

332: per_naa_shd.g_old_rec.holder;
333: End If;
334: If (p_rec.comments = hr_api.g_varchar2) then
335: p_rec.comments :=
336: per_naa_shd.g_old_rec.comments;
337: End If;
338: If (p_rec.document_file_name = hr_api.g_varchar2) then
339: p_rec.document_file_name :=
340: per_naa_shd.g_old_rec.document_file_name;

Line 340: per_naa_shd.g_old_rec.document_file_name;

336: per_naa_shd.g_old_rec.comments;
337: End If;
338: If (p_rec.document_file_name = hr_api.g_varchar2) then
339: p_rec.document_file_name :=
340: per_naa_shd.g_old_rec.document_file_name;
341: End If;
342: If (p_rec.last_updated_by = hr_api.g_number) then
343: p_rec.last_updated_by :=
344: per_naa_shd.g_old_rec.last_updated_by;

Line 344: per_naa_shd.g_old_rec.last_updated_by;

340: per_naa_shd.g_old_rec.document_file_name;
341: End If;
342: If (p_rec.last_updated_by = hr_api.g_number) then
343: p_rec.last_updated_by :=
344: per_naa_shd.g_old_rec.last_updated_by;
345: End If;
346: If (p_rec.enabled = hr_api.g_varchar2) then
347: p_rec.enabled :=
348: per_naa_shd.g_old_rec.enabled;

Line 348: per_naa_shd.g_old_rec.enabled;

344: per_naa_shd.g_old_rec.last_updated_by;
345: End If;
346: If (p_rec.enabled = hr_api.g_varchar2) then
347: p_rec.enabled :=
348: per_naa_shd.g_old_rec.enabled;
349: End If;
350:
351: --
352: End convert_defs;

Line 358: (p_rec in out nocopy per_naa_shd.g_rec_type

354: -- ----------------------------------------------------------------------------
355: -- |---------------------------------< upd >----------------------------------|
356: -- ----------------------------------------------------------------------------
357: Procedure upd
358: (p_rec in out nocopy per_naa_shd.g_rec_type
359: ) is
360: --
361: l_proc varchar2(72) := g_package||'upd';
362: --

Line 368: per_naa_shd.lck

364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: -- We must lock the row which we need to update.
367: --
368: per_naa_shd.lck
369: (p_rec.absence_action_id
370: ,p_rec.object_version_number
371: );
372: --

Line 423: l_rec per_naa_shd.g_rec_type;

419: ,p_last_updated_by in number
420: ,p_enabled in varchar2
421: ) is
422: --
423: l_rec per_naa_shd.g_rec_type;
424: l_proc varchar2(72) := g_package||'upd';
425: --
426: Begin
427: hr_utility.set_location('Entering:'||l_proc, 5);

Line 433: per_naa_shd.convert_args

429: -- Call conversion function to turn arguments into the
430: -- l_rec structure.
431: --
432: l_rec :=
433: per_naa_shd.convert_args
434: (p_absence_action_id
435: ,p_absence_attendance_id
436: ,p_expected_date
437: ,p_description