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_PSV_UPD dependencies on PER_PSV_SHD

Line 55: (p_rec in out nocopy per_psv_shd.g_rec_type

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

Line 66: per_psv_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_psv_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_pos_structure_versions Row
69: --
70: update per_pos_structure_versions

Line 86: per_psv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 93: per_psv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 94: per_psv_shd.constraint_error

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

Line 98: per_psv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 99: per_psv_shd.constraint_error

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

Line 103: per_psv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 104: per_psv_shd.constraint_error

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

Line 107: per_psv_shd.g_api_dml := false; -- Unset the api dml status

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

Line 144: (p_rec in per_psv_shd.g_rec_type

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

Line 189: ,p_rec in per_psv_shd.g_rec_type

185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure post_update
188: (p_effective_date in date
189: ,p_rec in per_psv_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'post_update';
193: --

Line 225: => per_psv_shd.g_old_rec.business_group_id

221: => p_rec.program_update_date
222: ,p_object_version_number
223: => p_rec.object_version_number
224: ,p_business_group_id_o
225: => per_psv_shd.g_old_rec.business_group_id
226: ,p_position_structure_id_o
227: => per_psv_shd.g_old_rec.position_structure_id
228: ,p_date_from_o
229: => per_psv_shd.g_old_rec.date_from

Line 227: => per_psv_shd.g_old_rec.position_structure_id

223: => p_rec.object_version_number
224: ,p_business_group_id_o
225: => per_psv_shd.g_old_rec.business_group_id
226: ,p_position_structure_id_o
227: => per_psv_shd.g_old_rec.position_structure_id
228: ,p_date_from_o
229: => per_psv_shd.g_old_rec.date_from
230: ,p_version_number_o
231: => per_psv_shd.g_old_rec.version_number

Line 229: => per_psv_shd.g_old_rec.date_from

225: => per_psv_shd.g_old_rec.business_group_id
226: ,p_position_structure_id_o
227: => per_psv_shd.g_old_rec.position_structure_id
228: ,p_date_from_o
229: => per_psv_shd.g_old_rec.date_from
230: ,p_version_number_o
231: => per_psv_shd.g_old_rec.version_number
232: ,p_copy_structure_version_id_o
233: => per_psv_shd.g_old_rec.copy_structure_version_id

Line 231: => per_psv_shd.g_old_rec.version_number

227: => per_psv_shd.g_old_rec.position_structure_id
228: ,p_date_from_o
229: => per_psv_shd.g_old_rec.date_from
230: ,p_version_number_o
231: => per_psv_shd.g_old_rec.version_number
232: ,p_copy_structure_version_id_o
233: => per_psv_shd.g_old_rec.copy_structure_version_id
234: ,p_date_to_o
235: => per_psv_shd.g_old_rec.date_to

Line 233: => per_psv_shd.g_old_rec.copy_structure_version_id

229: => per_psv_shd.g_old_rec.date_from
230: ,p_version_number_o
231: => per_psv_shd.g_old_rec.version_number
232: ,p_copy_structure_version_id_o
233: => per_psv_shd.g_old_rec.copy_structure_version_id
234: ,p_date_to_o
235: => per_psv_shd.g_old_rec.date_to
236: ,p_request_id_o
237: => per_psv_shd.g_old_rec.request_id

Line 235: => per_psv_shd.g_old_rec.date_to

231: => per_psv_shd.g_old_rec.version_number
232: ,p_copy_structure_version_id_o
233: => per_psv_shd.g_old_rec.copy_structure_version_id
234: ,p_date_to_o
235: => per_psv_shd.g_old_rec.date_to
236: ,p_request_id_o
237: => per_psv_shd.g_old_rec.request_id
238: ,p_program_application_id_o
239: => per_psv_shd.g_old_rec.program_application_id

Line 237: => per_psv_shd.g_old_rec.request_id

233: => per_psv_shd.g_old_rec.copy_structure_version_id
234: ,p_date_to_o
235: => per_psv_shd.g_old_rec.date_to
236: ,p_request_id_o
237: => per_psv_shd.g_old_rec.request_id
238: ,p_program_application_id_o
239: => per_psv_shd.g_old_rec.program_application_id
240: ,p_program_id_o
241: => per_psv_shd.g_old_rec.program_id

Line 239: => per_psv_shd.g_old_rec.program_application_id

235: => per_psv_shd.g_old_rec.date_to
236: ,p_request_id_o
237: => per_psv_shd.g_old_rec.request_id
238: ,p_program_application_id_o
239: => per_psv_shd.g_old_rec.program_application_id
240: ,p_program_id_o
241: => per_psv_shd.g_old_rec.program_id
242: ,p_program_update_date_o
243: => per_psv_shd.g_old_rec.program_update_date

Line 241: => per_psv_shd.g_old_rec.program_id

237: => per_psv_shd.g_old_rec.request_id
238: ,p_program_application_id_o
239: => per_psv_shd.g_old_rec.program_application_id
240: ,p_program_id_o
241: => per_psv_shd.g_old_rec.program_id
242: ,p_program_update_date_o
243: => per_psv_shd.g_old_rec.program_update_date
244: ,p_object_version_number_o
245: => per_psv_shd.g_old_rec.object_version_number

Line 243: => per_psv_shd.g_old_rec.program_update_date

239: => per_psv_shd.g_old_rec.program_application_id
240: ,p_program_id_o
241: => per_psv_shd.g_old_rec.program_id
242: ,p_program_update_date_o
243: => per_psv_shd.g_old_rec.program_update_date
244: ,p_object_version_number_o
245: => per_psv_shd.g_old_rec.object_version_number
246: );
247: --

Line 245: => per_psv_shd.g_old_rec.object_version_number

241: => per_psv_shd.g_old_rec.program_id
242: ,p_program_update_date_o
243: => per_psv_shd.g_old_rec.program_update_date
244: ,p_object_version_number_o
245: => per_psv_shd.g_old_rec.object_version_number
246: );
247: --
248: exception
249: --

Line 305: (p_rec in out nocopy per_psv_shd.g_rec_type

301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure convert_defs
305: (p_rec in out nocopy per_psv_shd.g_rec_type
306: ) is
307: --
308: Begin
309: --

Line 317: per_psv_shd.g_old_rec.business_group_id;

313: -- is being used then we must set to the 'current' argument value.
314: --
315: If (p_rec.business_group_id = hr_api.g_number) then
316: p_rec.business_group_id :=
317: per_psv_shd.g_old_rec.business_group_id;
318: End If;
319: If (p_rec.position_structure_id = hr_api.g_number) then
320: p_rec.position_structure_id :=
321: per_psv_shd.g_old_rec.position_structure_id;

Line 321: per_psv_shd.g_old_rec.position_structure_id;

317: per_psv_shd.g_old_rec.business_group_id;
318: End If;
319: If (p_rec.position_structure_id = hr_api.g_number) then
320: p_rec.position_structure_id :=
321: per_psv_shd.g_old_rec.position_structure_id;
322: End If;
323: If (p_rec.date_from = hr_api.g_date) then
324: p_rec.date_from :=
325: per_psv_shd.g_old_rec.date_from;

Line 325: per_psv_shd.g_old_rec.date_from;

321: per_psv_shd.g_old_rec.position_structure_id;
322: End If;
323: If (p_rec.date_from = hr_api.g_date) then
324: p_rec.date_from :=
325: per_psv_shd.g_old_rec.date_from;
326: End If;
327: If (p_rec.version_number = hr_api.g_number) then
328: p_rec.version_number :=
329: per_psv_shd.g_old_rec.version_number;

Line 329: per_psv_shd.g_old_rec.version_number;

325: per_psv_shd.g_old_rec.date_from;
326: End If;
327: If (p_rec.version_number = hr_api.g_number) then
328: p_rec.version_number :=
329: per_psv_shd.g_old_rec.version_number;
330: End If;
331: If (p_rec.copy_structure_version_id = hr_api.g_number) then
332: p_rec.copy_structure_version_id :=
333: per_psv_shd.g_old_rec.copy_structure_version_id;

Line 333: per_psv_shd.g_old_rec.copy_structure_version_id;

329: per_psv_shd.g_old_rec.version_number;
330: End If;
331: If (p_rec.copy_structure_version_id = hr_api.g_number) then
332: p_rec.copy_structure_version_id :=
333: per_psv_shd.g_old_rec.copy_structure_version_id;
334: End If;
335: If (p_rec.date_to = hr_api.g_date) then
336: p_rec.date_to :=
337: per_psv_shd.g_old_rec.date_to;

Line 337: per_psv_shd.g_old_rec.date_to;

333: per_psv_shd.g_old_rec.copy_structure_version_id;
334: End If;
335: If (p_rec.date_to = hr_api.g_date) then
336: p_rec.date_to :=
337: per_psv_shd.g_old_rec.date_to;
338: End If;
339: If (p_rec.request_id = hr_api.g_number) then
340: p_rec.request_id :=
341: per_psv_shd.g_old_rec.request_id;

Line 341: per_psv_shd.g_old_rec.request_id;

337: per_psv_shd.g_old_rec.date_to;
338: End If;
339: If (p_rec.request_id = hr_api.g_number) then
340: p_rec.request_id :=
341: per_psv_shd.g_old_rec.request_id;
342: End If;
343: If (p_rec.program_application_id = hr_api.g_number) then
344: p_rec.program_application_id :=
345: per_psv_shd.g_old_rec.program_application_id;

Line 345: per_psv_shd.g_old_rec.program_application_id;

341: per_psv_shd.g_old_rec.request_id;
342: End If;
343: If (p_rec.program_application_id = hr_api.g_number) then
344: p_rec.program_application_id :=
345: per_psv_shd.g_old_rec.program_application_id;
346: End If;
347: If (p_rec.program_id = hr_api.g_number) then
348: p_rec.program_id :=
349: per_psv_shd.g_old_rec.program_id;

Line 349: per_psv_shd.g_old_rec.program_id;

345: per_psv_shd.g_old_rec.program_application_id;
346: End If;
347: If (p_rec.program_id = hr_api.g_number) then
348: p_rec.program_id :=
349: per_psv_shd.g_old_rec.program_id;
350: End If;
351: If (p_rec.program_update_date = hr_api.g_date) then
352: p_rec.program_update_date :=
353: per_psv_shd.g_old_rec.program_update_date;

Line 353: per_psv_shd.g_old_rec.program_update_date;

349: per_psv_shd.g_old_rec.program_id;
350: End If;
351: If (p_rec.program_update_date = hr_api.g_date) then
352: p_rec.program_update_date :=
353: per_psv_shd.g_old_rec.program_update_date;
354: End If;
355: --
356: End convert_defs;
357: --

Line 363: ,p_rec in out nocopy per_psv_shd.g_rec_type

359: -- |---------------------------------< upd >----------------------------------|
360: -- ----------------------------------------------------------------------------
361: Procedure upd
362: (p_effective_date in date
363: ,p_rec in out nocopy per_psv_shd.g_rec_type
364: ,p_gap_warning out nocopy boolean
365: ) is
366: --
367: l_proc varchar2(72) := g_package||'upd';

Line 374: per_psv_shd.lck

370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: -- We must lock the row which we need to update.
373: --
374: per_psv_shd.lck
375: (p_rec.pos_structure_version_id
376: ,p_rec.object_version_number
377: );
378: --

Line 427: l_rec per_psv_shd.g_rec_type;

423: ,p_object_version_number in out nocopy number
424: ,p_gap_warning out nocopy boolean
425: ) is
426: --
427: l_rec per_psv_shd.g_rec_type;
428: l_proc varchar2(72) := g_package||'upd';
429: --
430: Begin
431: hr_utility.set_location('Entering:'||l_proc, 5);

Line 437: per_psv_shd.convert_args

433: -- Call conversion function to turn arguments into the
434: -- l_rec structure.
435: --
436: l_rec :=
437: per_psv_shd.convert_args
438: (p_pos_structure_version_id
439: ,hr_api.g_number
440: ,p_position_structure_id
441: ,p_date_from