DBA Data[Home] [Help]

APPS.PER_ENT_UPD dependencies on PER_ENT_SHD

Line 55: (p_rec in out nocopy per_ent_shd.g_rec_type

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

Line 99: per_ent_shd.constraint_error

95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: --
99: per_ent_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: --

Line 104: per_ent_shd.constraint_error

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: --
104: per_ent_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --

Line 109: per_ent_shd.constraint_error

105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --
109: per_ent_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;

Line 149: (p_rec in per_ent_shd.g_rec_type

145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_update
149: (p_rec in per_ent_shd.g_rec_type
150: ) is
151: --
152: l_proc varchar2(72) := g_package||'pre_update';
153: --

Line 194: ,p_rec in per_ent_shd.g_rec_type

190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure post_update
193: (p_effective_date in date
194: ,p_rec in per_ent_shd.g_rec_type
195: ) is
196: --
197: l_proc varchar2(72) := g_package||'post_update';
198: --

Line 239: => per_ent_shd.g_old_rec.business_group_id

235: => p_rec.org_structure_version_id
236: ,p_object_version_number
237: => p_rec.object_version_number
238: ,p_business_group_id_o
239: => per_ent_shd.g_old_rec.business_group_id
240: ,p_name_o
241: => per_ent_shd.g_old_rec.name
242: ,p_type_o
243: => per_ent_shd.g_old_rec.type

Line 241: => per_ent_shd.g_old_rec.name

237: => p_rec.object_version_number
238: ,p_business_group_id_o
239: => per_ent_shd.g_old_rec.business_group_id
240: ,p_name_o
241: => per_ent_shd.g_old_rec.name
242: ,p_type_o
243: => per_ent_shd.g_old_rec.type
244: ,p_start_date_o
245: => per_ent_shd.g_old_rec.start_date

Line 243: => per_ent_shd.g_old_rec.type

239: => per_ent_shd.g_old_rec.business_group_id
240: ,p_name_o
241: => per_ent_shd.g_old_rec.name
242: ,p_type_o
243: => per_ent_shd.g_old_rec.type
244: ,p_start_date_o
245: => per_ent_shd.g_old_rec.start_date
246: ,p_start_hour_o
247: => per_ent_shd.g_old_rec.start_hour

Line 245: => per_ent_shd.g_old_rec.start_date

241: => per_ent_shd.g_old_rec.name
242: ,p_type_o
243: => per_ent_shd.g_old_rec.type
244: ,p_start_date_o
245: => per_ent_shd.g_old_rec.start_date
246: ,p_start_hour_o
247: => per_ent_shd.g_old_rec.start_hour
248: ,p_start_min_o
249: => per_ent_shd.g_old_rec.start_min

Line 247: => per_ent_shd.g_old_rec.start_hour

243: => per_ent_shd.g_old_rec.type
244: ,p_start_date_o
245: => per_ent_shd.g_old_rec.start_date
246: ,p_start_hour_o
247: => per_ent_shd.g_old_rec.start_hour
248: ,p_start_min_o
249: => per_ent_shd.g_old_rec.start_min
250: ,p_end_date_o
251: => per_ent_shd.g_old_rec.end_date

Line 249: => per_ent_shd.g_old_rec.start_min

245: => per_ent_shd.g_old_rec.start_date
246: ,p_start_hour_o
247: => per_ent_shd.g_old_rec.start_hour
248: ,p_start_min_o
249: => per_ent_shd.g_old_rec.start_min
250: ,p_end_date_o
251: => per_ent_shd.g_old_rec.end_date
252: ,p_end_hour_o
253: => per_ent_shd.g_old_rec.end_hour

Line 251: => per_ent_shd.g_old_rec.end_date

247: => per_ent_shd.g_old_rec.start_hour
248: ,p_start_min_o
249: => per_ent_shd.g_old_rec.start_min
250: ,p_end_date_o
251: => per_ent_shd.g_old_rec.end_date
252: ,p_end_hour_o
253: => per_ent_shd.g_old_rec.end_hour
254: ,p_end_min_o
255: => per_ent_shd.g_old_rec.end_min

Line 253: => per_ent_shd.g_old_rec.end_hour

249: => per_ent_shd.g_old_rec.start_min
250: ,p_end_date_o
251: => per_ent_shd.g_old_rec.end_date
252: ,p_end_hour_o
253: => per_ent_shd.g_old_rec.end_hour
254: ,p_end_min_o
255: => per_ent_shd.g_old_rec.end_min
256: ,p_description_o
257: => per_ent_shd.g_old_rec.description

Line 255: => per_ent_shd.g_old_rec.end_min

251: => per_ent_shd.g_old_rec.end_date
252: ,p_end_hour_o
253: => per_ent_shd.g_old_rec.end_hour
254: ,p_end_min_o
255: => per_ent_shd.g_old_rec.end_min
256: ,p_description_o
257: => per_ent_shd.g_old_rec.description
258: ,p_hierarchy_id_o
259: => per_ent_shd.g_old_rec.hierarchy_id

Line 257: => per_ent_shd.g_old_rec.description

253: => per_ent_shd.g_old_rec.end_hour
254: ,p_end_min_o
255: => per_ent_shd.g_old_rec.end_min
256: ,p_description_o
257: => per_ent_shd.g_old_rec.description
258: ,p_hierarchy_id_o
259: => per_ent_shd.g_old_rec.hierarchy_id
260: ,p_value_set_id_o
261: => per_ent_shd.g_old_rec.value_set_id

Line 259: => per_ent_shd.g_old_rec.hierarchy_id

255: => per_ent_shd.g_old_rec.end_min
256: ,p_description_o
257: => per_ent_shd.g_old_rec.description
258: ,p_hierarchy_id_o
259: => per_ent_shd.g_old_rec.hierarchy_id
260: ,p_value_set_id_o
261: => per_ent_shd.g_old_rec.value_set_id
262: ,p_organization_structure_id_o
263: => per_ent_shd.g_old_rec.organization_structure_id

Line 261: => per_ent_shd.g_old_rec.value_set_id

257: => per_ent_shd.g_old_rec.description
258: ,p_hierarchy_id_o
259: => per_ent_shd.g_old_rec.hierarchy_id
260: ,p_value_set_id_o
261: => per_ent_shd.g_old_rec.value_set_id
262: ,p_organization_structure_id_o
263: => per_ent_shd.g_old_rec.organization_structure_id
264: ,p_org_structure_version_id_o
265: => per_ent_shd.g_old_rec.org_structure_version_id

Line 263: => per_ent_shd.g_old_rec.organization_structure_id

259: => per_ent_shd.g_old_rec.hierarchy_id
260: ,p_value_set_id_o
261: => per_ent_shd.g_old_rec.value_set_id
262: ,p_organization_structure_id_o
263: => per_ent_shd.g_old_rec.organization_structure_id
264: ,p_org_structure_version_id_o
265: => per_ent_shd.g_old_rec.org_structure_version_id
266: ,p_object_version_number_o
267: => per_ent_shd.g_old_rec.object_version_number

Line 265: => per_ent_shd.g_old_rec.org_structure_version_id

261: => per_ent_shd.g_old_rec.value_set_id
262: ,p_organization_structure_id_o
263: => per_ent_shd.g_old_rec.organization_structure_id
264: ,p_org_structure_version_id_o
265: => per_ent_shd.g_old_rec.org_structure_version_id
266: ,p_object_version_number_o
267: => per_ent_shd.g_old_rec.object_version_number
268: );
269: --

Line 267: => per_ent_shd.g_old_rec.object_version_number

263: => per_ent_shd.g_old_rec.organization_structure_id
264: ,p_org_structure_version_id_o
265: => per_ent_shd.g_old_rec.org_structure_version_id
266: ,p_object_version_number_o
267: => per_ent_shd.g_old_rec.object_version_number
268: );
269: --
270: exception
271: --

Line 327: (p_rec in out nocopy per_ent_shd.g_rec_type

323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure convert_defs
327: (p_rec in out nocopy per_ent_shd.g_rec_type
328: ) is
329: --
330: Begin
331: --

Line 339: per_ent_shd.g_old_rec.business_group_id;

335: -- is being used then we must set to the 'current' argument value.
336: --
337: If (p_rec.business_group_id = hr_api.g_number) then
338: p_rec.business_group_id :=
339: per_ent_shd.g_old_rec.business_group_id;
340: End If;
341: If (p_rec.name = hr_api.g_varchar2) then
342: p_rec.name :=
343: per_ent_shd.g_old_rec.name;

Line 343: per_ent_shd.g_old_rec.name;

339: per_ent_shd.g_old_rec.business_group_id;
340: End If;
341: If (p_rec.name = hr_api.g_varchar2) then
342: p_rec.name :=
343: per_ent_shd.g_old_rec.name;
344: End If;
345: If (p_rec.type = hr_api.g_varchar2) then
346: p_rec.type :=
347: per_ent_shd.g_old_rec.type;

Line 347: per_ent_shd.g_old_rec.type;

343: per_ent_shd.g_old_rec.name;
344: End If;
345: If (p_rec.type = hr_api.g_varchar2) then
346: p_rec.type :=
347: per_ent_shd.g_old_rec.type;
348: End If;
349: If (p_rec.start_date = hr_api.g_date) then
350: p_rec.start_date :=
351: per_ent_shd.g_old_rec.start_date;

Line 351: per_ent_shd.g_old_rec.start_date;

347: per_ent_shd.g_old_rec.type;
348: End If;
349: If (p_rec.start_date = hr_api.g_date) then
350: p_rec.start_date :=
351: per_ent_shd.g_old_rec.start_date;
352: End If;
353: If (p_rec.start_hour = hr_api.g_varchar2) then
354: p_rec.start_hour :=
355: per_ent_shd.g_old_rec.start_hour;

Line 355: per_ent_shd.g_old_rec.start_hour;

351: per_ent_shd.g_old_rec.start_date;
352: End If;
353: If (p_rec.start_hour = hr_api.g_varchar2) then
354: p_rec.start_hour :=
355: per_ent_shd.g_old_rec.start_hour;
356: End If;
357: If (p_rec.start_min = hr_api.g_varchar2) then
358: p_rec.start_min :=
359: per_ent_shd.g_old_rec.start_min;

Line 359: per_ent_shd.g_old_rec.start_min;

355: per_ent_shd.g_old_rec.start_hour;
356: End If;
357: If (p_rec.start_min = hr_api.g_varchar2) then
358: p_rec.start_min :=
359: per_ent_shd.g_old_rec.start_min;
360: End If;
361: If (p_rec.end_date = hr_api.g_date) then
362: p_rec.end_date :=
363: per_ent_shd.g_old_rec.end_date;

Line 363: per_ent_shd.g_old_rec.end_date;

359: per_ent_shd.g_old_rec.start_min;
360: End If;
361: If (p_rec.end_date = hr_api.g_date) then
362: p_rec.end_date :=
363: per_ent_shd.g_old_rec.end_date;
364: End If;
365: If (p_rec.end_hour = hr_api.g_varchar2) then
366: p_rec.end_hour :=
367: per_ent_shd.g_old_rec.end_hour;

Line 367: per_ent_shd.g_old_rec.end_hour;

363: per_ent_shd.g_old_rec.end_date;
364: End If;
365: If (p_rec.end_hour = hr_api.g_varchar2) then
366: p_rec.end_hour :=
367: per_ent_shd.g_old_rec.end_hour;
368: End If;
369: If (p_rec.end_min = hr_api.g_varchar2) then
370: p_rec.end_min :=
371: per_ent_shd.g_old_rec.end_min;

Line 371: per_ent_shd.g_old_rec.end_min;

367: per_ent_shd.g_old_rec.end_hour;
368: End If;
369: If (p_rec.end_min = hr_api.g_varchar2) then
370: p_rec.end_min :=
371: per_ent_shd.g_old_rec.end_min;
372: End If;
373: If (p_rec.description = hr_api.g_varchar2) then
374: p_rec.description :=
375: per_ent_shd.g_old_rec.description;

Line 375: per_ent_shd.g_old_rec.description;

371: per_ent_shd.g_old_rec.end_min;
372: End If;
373: If (p_rec.description = hr_api.g_varchar2) then
374: p_rec.description :=
375: per_ent_shd.g_old_rec.description;
376: End If;
377: If (p_rec.hierarchy_id = hr_api.g_number) then
378: p_rec.hierarchy_id :=
379: per_ent_shd.g_old_rec.hierarchy_id;

Line 379: per_ent_shd.g_old_rec.hierarchy_id;

375: per_ent_shd.g_old_rec.description;
376: End If;
377: If (p_rec.hierarchy_id = hr_api.g_number) then
378: p_rec.hierarchy_id :=
379: per_ent_shd.g_old_rec.hierarchy_id;
380: End If;
381: If (p_rec.value_set_id = hr_api.g_number) then
382: p_rec.value_set_id :=
383: per_ent_shd.g_old_rec.value_set_id;

Line 383: per_ent_shd.g_old_rec.value_set_id;

379: per_ent_shd.g_old_rec.hierarchy_id;
380: End If;
381: If (p_rec.value_set_id = hr_api.g_number) then
382: p_rec.value_set_id :=
383: per_ent_shd.g_old_rec.value_set_id;
384: End If;
385: If (p_rec.organization_structure_id = hr_api.g_number) then
386: p_rec.organization_structure_id :=
387: per_ent_shd.g_old_rec.organization_structure_id;

Line 387: per_ent_shd.g_old_rec.organization_structure_id;

383: per_ent_shd.g_old_rec.value_set_id;
384: End If;
385: If (p_rec.organization_structure_id = hr_api.g_number) then
386: p_rec.organization_structure_id :=
387: per_ent_shd.g_old_rec.organization_structure_id;
388: End If;
389: If (p_rec.org_structure_version_id = hr_api.g_number) then
390: p_rec.org_structure_version_id :=
391: per_ent_shd.g_old_rec.org_structure_version_id;

Line 391: per_ent_shd.g_old_rec.org_structure_version_id;

387: per_ent_shd.g_old_rec.organization_structure_id;
388: End If;
389: If (p_rec.org_structure_version_id = hr_api.g_number) then
390: p_rec.org_structure_version_id :=
391: per_ent_shd.g_old_rec.org_structure_version_id;
392: End If;
393: If (p_rec.legislation_code = hr_api.g_varchar2) then
394: p_rec.legislation_code :=
395: per_ent_shd.g_old_rec.legislation_code;

Line 395: per_ent_shd.g_old_rec.legislation_code;

391: per_ent_shd.g_old_rec.org_structure_version_id;
392: End If;
393: If (p_rec.legislation_code = hr_api.g_varchar2) then
394: p_rec.legislation_code :=
395: per_ent_shd.g_old_rec.legislation_code;
396: End If;
397: If (p_rec.identifier_key = hr_api.g_varchar2) then
398: p_rec.identifier_key :=
399: per_ent_shd.g_old_rec.identifier_key;

Line 399: per_ent_shd.g_old_rec.identifier_key;

395: per_ent_shd.g_old_rec.legislation_code;
396: End If;
397: If (p_rec.identifier_key = hr_api.g_varchar2) then
398: p_rec.identifier_key :=
399: per_ent_shd.g_old_rec.identifier_key;
400: End If;
401: --
402: End convert_defs;
403: --

Line 409: ,p_rec in out nocopy per_ent_shd.g_rec_type

405: -- |---------------------------------< upd >----------------------------------|
406: -- ----------------------------------------------------------------------------
407: Procedure upd
408: (p_effective_date in date
409: ,p_rec in out nocopy per_ent_shd.g_rec_type
410: ) is
411: --
412: l_proc varchar2(72) := g_package||'upd';
413: --

Line 419: per_ent_shd.lck

415: hr_utility.set_location('Entering:'||l_proc, 5);
416: --
417: -- We must lock the row which we need to update.
418: --
419: per_ent_shd.lck
420: (p_rec.calendar_entry_id
421: ,p_rec.object_version_number
422: );
423: --

Line 481: l_rec per_ent_shd.g_rec_type;

477: ,p_org_structure_version_id in number default hr_api.g_number
478: ,p_business_group_id in number default null
479: ) is
480: --
481: l_rec per_ent_shd.g_rec_type;
482: l_proc varchar2(72) := g_package||'upd';
483: --
484: Begin
485: hr_utility.set_location('Entering:'||l_proc, 5);

Line 491: per_ent_shd.convert_args

487: -- Call conversion function to turn arguments into the
488: -- l_rec structure.
489: --
490: l_rec :=
491: per_ent_shd.convert_args
492: (p_calendar_entry_id
493: ,p_business_group_id
494: ,p_name
495: ,p_type