APPS.OTA_PMM_UPD dependencies on HR_API

Line 108: When hr_api.check_integrity_violated Then

104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: --
107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
111: ota_pmm_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
111: ota_pmm_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
116: ota_pmm_shd.constraint_error

Line 113: When hr_api.parent_integrity_violated Then

109: -- A check constraint has been violated
110: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
111: ota_pmm_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
116: ota_pmm_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
116: ota_pmm_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
121: ota_pmm_shd.constraint_error

Line 118: When hr_api.unique_integrity_violated Then

114: -- Parent integrity has been violated
115: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
116: ota_pmm_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
121: ota_pmm_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
121: ota_pmm_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: ota_pmm_shd.g_api_dml := false; -- Unset the api dml status
125: Raise;
126: End update_dml;

Line 269: If (p_rec.event_id = hr_api.g_number) then

265: -- p_rec plsql record structure
266: -- to see if a system default is being used. If a system default
267: -- is being used then we must set to the 'current' argument value.
268: --
269: If (p_rec.event_id = hr_api.g_number) then
270: p_rec.event_id :=
271: ota_pmm_shd.g_old_rec.event_id;
272: End If;
273: If (p_rec.program_event_id = hr_api.g_number) then

Line 273: If (p_rec.program_event_id = hr_api.g_number) then

269: If (p_rec.event_id = hr_api.g_number) then
270: p_rec.event_id :=
271: ota_pmm_shd.g_old_rec.event_id;
272: End If;
273: If (p_rec.program_event_id = hr_api.g_number) then
274: p_rec.program_event_id :=
275: ota_pmm_shd.g_old_rec.program_event_id;
276: End If;
277: If (p_rec.comments = hr_api.g_varchar2) then

Line 277: If (p_rec.comments = hr_api.g_varchar2) then

273: If (p_rec.program_event_id = hr_api.g_number) then
274: p_rec.program_event_id :=
275: ota_pmm_shd.g_old_rec.program_event_id;
276: End If;
277: If (p_rec.comments = hr_api.g_varchar2) then
278: p_rec.comments :=
279: ota_pmm_shd.g_old_rec.comments;
280: End If;
281: If (p_rec.group_name = hr_api.g_varchar2) then

Line 281: If (p_rec.group_name = hr_api.g_varchar2) then

277: If (p_rec.comments = hr_api.g_varchar2) then
278: p_rec.comments :=
279: ota_pmm_shd.g_old_rec.comments;
280: End If;
281: If (p_rec.group_name = hr_api.g_varchar2) then
282: p_rec.group_name :=
283: ota_pmm_shd.g_old_rec.group_name;
284: End If;
285: If (p_rec.required_flag = hr_api.g_varchar2) then

Line 285: If (p_rec.required_flag = hr_api.g_varchar2) then

281: If (p_rec.group_name = hr_api.g_varchar2) then
282: p_rec.group_name :=
283: ota_pmm_shd.g_old_rec.group_name;
284: End If;
285: If (p_rec.required_flag = hr_api.g_varchar2) then
286: p_rec.required_flag :=
287: ota_pmm_shd.g_old_rec.required_flag;
288: End If;
289: If (p_rec.role = hr_api.g_varchar2) then

Line 289: If (p_rec.role = hr_api.g_varchar2) then

285: If (p_rec.required_flag = hr_api.g_varchar2) then
286: p_rec.required_flag :=
287: ota_pmm_shd.g_old_rec.required_flag;
288: End If;
289: If (p_rec.role = hr_api.g_varchar2) then
290: p_rec.role :=
291: ota_pmm_shd.g_old_rec.role;
292: End If;
293: If (p_rec.sequence = hr_api.g_number) then

Line 293: If (p_rec.sequence = hr_api.g_number) then

289: If (p_rec.role = hr_api.g_varchar2) then
290: p_rec.role :=
291: ota_pmm_shd.g_old_rec.role;
292: End If;
293: If (p_rec.sequence = hr_api.g_number) then
294: p_rec.sequence :=
295: ota_pmm_shd.g_old_rec.sequence;
296: End If;
297: If (p_rec.pmm_information_category = hr_api.g_varchar2) then

Line 297: If (p_rec.pmm_information_category = hr_api.g_varchar2) then

293: If (p_rec.sequence = hr_api.g_number) then
294: p_rec.sequence :=
295: ota_pmm_shd.g_old_rec.sequence;
296: End If;
297: If (p_rec.pmm_information_category = hr_api.g_varchar2) then
298: p_rec.pmm_information_category :=
299: ota_pmm_shd.g_old_rec.pmm_information_category;
300: End If;
301: If (p_rec.pmm_information1 = hr_api.g_varchar2) then

Line 301: If (p_rec.pmm_information1 = hr_api.g_varchar2) then

297: If (p_rec.pmm_information_category = hr_api.g_varchar2) then
298: p_rec.pmm_information_category :=
299: ota_pmm_shd.g_old_rec.pmm_information_category;
300: End If;
301: If (p_rec.pmm_information1 = hr_api.g_varchar2) then
302: p_rec.pmm_information1 :=
303: ota_pmm_shd.g_old_rec.pmm_information1;
304: End If;
305: If (p_rec.pmm_information2 = hr_api.g_varchar2) then

Line 305: If (p_rec.pmm_information2 = hr_api.g_varchar2) then

301: If (p_rec.pmm_information1 = hr_api.g_varchar2) then
302: p_rec.pmm_information1 :=
303: ota_pmm_shd.g_old_rec.pmm_information1;
304: End If;
305: If (p_rec.pmm_information2 = hr_api.g_varchar2) then
306: p_rec.pmm_information2 :=
307: ota_pmm_shd.g_old_rec.pmm_information2;
308: End If;
309: If (p_rec.pmm_information3 = hr_api.g_varchar2) then

Line 309: If (p_rec.pmm_information3 = hr_api.g_varchar2) then

305: If (p_rec.pmm_information2 = hr_api.g_varchar2) then
306: p_rec.pmm_information2 :=
307: ota_pmm_shd.g_old_rec.pmm_information2;
308: End If;
309: If (p_rec.pmm_information3 = hr_api.g_varchar2) then
310: p_rec.pmm_information3 :=
311: ota_pmm_shd.g_old_rec.pmm_information3;
312: End If;
313: If (p_rec.pmm_information4 = hr_api.g_varchar2) then

Line 313: If (p_rec.pmm_information4 = hr_api.g_varchar2) then

309: If (p_rec.pmm_information3 = hr_api.g_varchar2) then
310: p_rec.pmm_information3 :=
311: ota_pmm_shd.g_old_rec.pmm_information3;
312: End If;
313: If (p_rec.pmm_information4 = hr_api.g_varchar2) then
314: p_rec.pmm_information4 :=
315: ota_pmm_shd.g_old_rec.pmm_information4;
316: End If;
317: If (p_rec.pmm_information5 = hr_api.g_varchar2) then

Line 317: If (p_rec.pmm_information5 = hr_api.g_varchar2) then

313: If (p_rec.pmm_information4 = hr_api.g_varchar2) then
314: p_rec.pmm_information4 :=
315: ota_pmm_shd.g_old_rec.pmm_information4;
316: End If;
317: If (p_rec.pmm_information5 = hr_api.g_varchar2) then
318: p_rec.pmm_information5 :=
319: ota_pmm_shd.g_old_rec.pmm_information5;
320: End If;
321: If (p_rec.pmm_information6 = hr_api.g_varchar2) then

Line 321: If (p_rec.pmm_information6 = hr_api.g_varchar2) then

317: If (p_rec.pmm_information5 = hr_api.g_varchar2) then
318: p_rec.pmm_information5 :=
319: ota_pmm_shd.g_old_rec.pmm_information5;
320: End If;
321: If (p_rec.pmm_information6 = hr_api.g_varchar2) then
322: p_rec.pmm_information6 :=
323: ota_pmm_shd.g_old_rec.pmm_information6;
324: End If;
325: If (p_rec.pmm_information7 = hr_api.g_varchar2) then

Line 325: If (p_rec.pmm_information7 = hr_api.g_varchar2) then

321: If (p_rec.pmm_information6 = hr_api.g_varchar2) then
322: p_rec.pmm_information6 :=
323: ota_pmm_shd.g_old_rec.pmm_information6;
324: End If;
325: If (p_rec.pmm_information7 = hr_api.g_varchar2) then
326: p_rec.pmm_information7 :=
327: ota_pmm_shd.g_old_rec.pmm_information7;
328: End If;
329: If (p_rec.pmm_information8 = hr_api.g_varchar2) then

Line 329: If (p_rec.pmm_information8 = hr_api.g_varchar2) then

325: If (p_rec.pmm_information7 = hr_api.g_varchar2) then
326: p_rec.pmm_information7 :=
327: ota_pmm_shd.g_old_rec.pmm_information7;
328: End If;
329: If (p_rec.pmm_information8 = hr_api.g_varchar2) then
330: p_rec.pmm_information8 :=
331: ota_pmm_shd.g_old_rec.pmm_information8;
332: End If;
333: If (p_rec.pmm_information9 = hr_api.g_varchar2) then

Line 333: If (p_rec.pmm_information9 = hr_api.g_varchar2) then

329: If (p_rec.pmm_information8 = hr_api.g_varchar2) then
330: p_rec.pmm_information8 :=
331: ota_pmm_shd.g_old_rec.pmm_information8;
332: End If;
333: If (p_rec.pmm_information9 = hr_api.g_varchar2) then
334: p_rec.pmm_information9 :=
335: ota_pmm_shd.g_old_rec.pmm_information9;
336: End If;
337: If (p_rec.pmm_information10 = hr_api.g_varchar2) then

Line 337: If (p_rec.pmm_information10 = hr_api.g_varchar2) then

333: If (p_rec.pmm_information9 = hr_api.g_varchar2) then
334: p_rec.pmm_information9 :=
335: ota_pmm_shd.g_old_rec.pmm_information9;
336: End If;
337: If (p_rec.pmm_information10 = hr_api.g_varchar2) then
338: p_rec.pmm_information10 :=
339: ota_pmm_shd.g_old_rec.pmm_information10;
340: End If;
341: If (p_rec.pmm_information11 = hr_api.g_varchar2) then

Line 341: If (p_rec.pmm_information11 = hr_api.g_varchar2) then

337: If (p_rec.pmm_information10 = hr_api.g_varchar2) then
338: p_rec.pmm_information10 :=
339: ota_pmm_shd.g_old_rec.pmm_information10;
340: End If;
341: If (p_rec.pmm_information11 = hr_api.g_varchar2) then
342: p_rec.pmm_information11 :=
343: ota_pmm_shd.g_old_rec.pmm_information11;
344: End If;
345: If (p_rec.pmm_information12 = hr_api.g_varchar2) then

Line 345: If (p_rec.pmm_information12 = hr_api.g_varchar2) then

341: If (p_rec.pmm_information11 = hr_api.g_varchar2) then
342: p_rec.pmm_information11 :=
343: ota_pmm_shd.g_old_rec.pmm_information11;
344: End If;
345: If (p_rec.pmm_information12 = hr_api.g_varchar2) then
346: p_rec.pmm_information12 :=
347: ota_pmm_shd.g_old_rec.pmm_information12;
348: End If;
349: If (p_rec.pmm_information13 = hr_api.g_varchar2) then

Line 349: If (p_rec.pmm_information13 = hr_api.g_varchar2) then

345: If (p_rec.pmm_information12 = hr_api.g_varchar2) then
346: p_rec.pmm_information12 :=
347: ota_pmm_shd.g_old_rec.pmm_information12;
348: End If;
349: If (p_rec.pmm_information13 = hr_api.g_varchar2) then
350: p_rec.pmm_information13 :=
351: ota_pmm_shd.g_old_rec.pmm_information13;
352: End If;
353: If (p_rec.pmm_information14 = hr_api.g_varchar2) then

Line 353: If (p_rec.pmm_information14 = hr_api.g_varchar2) then

349: If (p_rec.pmm_information13 = hr_api.g_varchar2) then
350: p_rec.pmm_information13 :=
351: ota_pmm_shd.g_old_rec.pmm_information13;
352: End If;
353: If (p_rec.pmm_information14 = hr_api.g_varchar2) then
354: p_rec.pmm_information14 :=
355: ota_pmm_shd.g_old_rec.pmm_information14;
356: End If;
357: If (p_rec.pmm_information15 = hr_api.g_varchar2) then

Line 357: If (p_rec.pmm_information15 = hr_api.g_varchar2) then

353: If (p_rec.pmm_information14 = hr_api.g_varchar2) then
354: p_rec.pmm_information14 :=
355: ota_pmm_shd.g_old_rec.pmm_information14;
356: End If;
357: If (p_rec.pmm_information15 = hr_api.g_varchar2) then
358: p_rec.pmm_information15 :=
359: ota_pmm_shd.g_old_rec.pmm_information15;
360: End If;
361: If (p_rec.pmm_information16 = hr_api.g_varchar2) then

Line 361: If (p_rec.pmm_information16 = hr_api.g_varchar2) then

357: If (p_rec.pmm_information15 = hr_api.g_varchar2) then
358: p_rec.pmm_information15 :=
359: ota_pmm_shd.g_old_rec.pmm_information15;
360: End If;
361: If (p_rec.pmm_information16 = hr_api.g_varchar2) then
362: p_rec.pmm_information16 :=
363: ota_pmm_shd.g_old_rec.pmm_information16;
364: End If;
365: If (p_rec.pmm_information17 = hr_api.g_varchar2) then

Line 365: If (p_rec.pmm_information17 = hr_api.g_varchar2) then

361: If (p_rec.pmm_information16 = hr_api.g_varchar2) then
362: p_rec.pmm_information16 :=
363: ota_pmm_shd.g_old_rec.pmm_information16;
364: End If;
365: If (p_rec.pmm_information17 = hr_api.g_varchar2) then
366: p_rec.pmm_information17 :=
367: ota_pmm_shd.g_old_rec.pmm_information17;
368: End If;
369: If (p_rec.pmm_information18 = hr_api.g_varchar2) then

Line 369: If (p_rec.pmm_information18 = hr_api.g_varchar2) then

365: If (p_rec.pmm_information17 = hr_api.g_varchar2) then
366: p_rec.pmm_information17 :=
367: ota_pmm_shd.g_old_rec.pmm_information17;
368: End If;
369: If (p_rec.pmm_information18 = hr_api.g_varchar2) then
370: p_rec.pmm_information18 :=
371: ota_pmm_shd.g_old_rec.pmm_information18;
372: End If;
373: If (p_rec.pmm_information19 = hr_api.g_varchar2) then

Line 373: If (p_rec.pmm_information19 = hr_api.g_varchar2) then

369: If (p_rec.pmm_information18 = hr_api.g_varchar2) then
370: p_rec.pmm_information18 :=
371: ota_pmm_shd.g_old_rec.pmm_information18;
372: End If;
373: If (p_rec.pmm_information19 = hr_api.g_varchar2) then
374: p_rec.pmm_information19 :=
375: ota_pmm_shd.g_old_rec.pmm_information19;
376: End If;
377: If (p_rec.pmm_information20 = hr_api.g_varchar2) then

Line 377: If (p_rec.pmm_information20 = hr_api.g_varchar2) then

373: If (p_rec.pmm_information19 = hr_api.g_varchar2) then
374: p_rec.pmm_information19 :=
375: ota_pmm_shd.g_old_rec.pmm_information19;
376: End If;
377: If (p_rec.pmm_information20 = hr_api.g_varchar2) then
378: p_rec.pmm_information20 :=
379: ota_pmm_shd.g_old_rec.pmm_information20;
380: End If;
381: --

Line 443: Raise HR_Api.Validate_Enabled;

439: --
440: -- If we are validating then raise the Validate_Enabled exception
441: --
442: If p_validate then
443: Raise HR_Api.Validate_Enabled;
444: End If;
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447: Exception

Line 448: When HR_Api.Validate_Enabled Then

444: End If;
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447: Exception
448: When HR_Api.Validate_Enabled Then
449: --
450: -- As the Validate_Enabled exception has been raised
451: -- we must rollback to the savepoint
452: --

Line 462: p_event_id in number default hr_api.g_number,

458: -- ----------------------------------------------------------------------------
459: Procedure upd
460: (
461: p_program_membership_id in number,
462: p_event_id in number default hr_api.g_number,
463: p_program_event_id in number default hr_api.g_number,
464: p_object_version_number in out number,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_group_name in varchar2 default hr_api.g_varchar2,

Line 463: p_program_event_id in number default hr_api.g_number,

459: Procedure upd
460: (
461: p_program_membership_id in number,
462: p_event_id in number default hr_api.g_number,
463: p_program_event_id in number default hr_api.g_number,
464: p_object_version_number in out number,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_group_name in varchar2 default hr_api.g_varchar2,
467: p_required_flag in varchar2 default hr_api.g_varchar2,

Line 465: p_comments in varchar2 default hr_api.g_varchar2,

461: p_program_membership_id in number,
462: p_event_id in number default hr_api.g_number,
463: p_program_event_id in number default hr_api.g_number,
464: p_object_version_number in out number,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_group_name in varchar2 default hr_api.g_varchar2,
467: p_required_flag in varchar2 default hr_api.g_varchar2,
468: p_role in varchar2 default hr_api.g_varchar2,
469: p_sequence in number default hr_api.g_number,

Line 466: p_group_name in varchar2 default hr_api.g_varchar2,

462: p_event_id in number default hr_api.g_number,
463: p_program_event_id in number default hr_api.g_number,
464: p_object_version_number in out number,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_group_name in varchar2 default hr_api.g_varchar2,
467: p_required_flag in varchar2 default hr_api.g_varchar2,
468: p_role in varchar2 default hr_api.g_varchar2,
469: p_sequence in number default hr_api.g_number,
470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,

Line 467: p_required_flag in varchar2 default hr_api.g_varchar2,

463: p_program_event_id in number default hr_api.g_number,
464: p_object_version_number in out number,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_group_name in varchar2 default hr_api.g_varchar2,
467: p_required_flag in varchar2 default hr_api.g_varchar2,
468: p_role in varchar2 default hr_api.g_varchar2,
469: p_sequence in number default hr_api.g_number,
470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,
471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,

Line 468: p_role in varchar2 default hr_api.g_varchar2,

464: p_object_version_number in out number,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_group_name in varchar2 default hr_api.g_varchar2,
467: p_required_flag in varchar2 default hr_api.g_varchar2,
468: p_role in varchar2 default hr_api.g_varchar2,
469: p_sequence in number default hr_api.g_number,
470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,
471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,
472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,

Line 469: p_sequence in number default hr_api.g_number,

465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_group_name in varchar2 default hr_api.g_varchar2,
467: p_required_flag in varchar2 default hr_api.g_varchar2,
468: p_role in varchar2 default hr_api.g_varchar2,
469: p_sequence in number default hr_api.g_number,
470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,
471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,
472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,
473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,

Line 470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,

466: p_group_name in varchar2 default hr_api.g_varchar2,
467: p_required_flag in varchar2 default hr_api.g_varchar2,
468: p_role in varchar2 default hr_api.g_varchar2,
469: p_sequence in number default hr_api.g_number,
470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,
471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,
472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,
473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,
474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,

Line 471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,

467: p_required_flag in varchar2 default hr_api.g_varchar2,
468: p_role in varchar2 default hr_api.g_varchar2,
469: p_sequence in number default hr_api.g_number,
470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,
471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,
472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,
473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,
474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,
475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,

Line 472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,

468: p_role in varchar2 default hr_api.g_varchar2,
469: p_sequence in number default hr_api.g_number,
470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,
471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,
472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,
473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,
474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,
475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,
476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,

Line 473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,

469: p_sequence in number default hr_api.g_number,
470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,
471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,
472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,
473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,
474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,
475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,
476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,
477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,

Line 474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,

470: p_pmm_information_category in varchar2 default hr_api.g_varchar2,
471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,
472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,
473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,
474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,
475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,
476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,
477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,
478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,

Line 475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,

471: p_pmm_information1 in varchar2 default hr_api.g_varchar2,
472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,
473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,
474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,
475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,
476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,
477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,
478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,
479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,

Line 476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,

472: p_pmm_information2 in varchar2 default hr_api.g_varchar2,
473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,
474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,
475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,
476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,
477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,
478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,
479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,
480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,

Line 477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,

473: p_pmm_information3 in varchar2 default hr_api.g_varchar2,
474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,
475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,
476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,
477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,
478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,
479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,
480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,
481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,

Line 478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,

474: p_pmm_information4 in varchar2 default hr_api.g_varchar2,
475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,
476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,
477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,
478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,
479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,
480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,
481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,
482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,

Line 479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,

475: p_pmm_information5 in varchar2 default hr_api.g_varchar2,
476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,
477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,
478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,
479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,
480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,
481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,
482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,
483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,

Line 480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,

476: p_pmm_information6 in varchar2 default hr_api.g_varchar2,
477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,
478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,
479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,
480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,
481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,
482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,
483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,
484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,

Line 481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,

477: p_pmm_information7 in varchar2 default hr_api.g_varchar2,
478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,
479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,
480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,
481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,
482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,
483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,
484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,
485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,

Line 482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,

478: p_pmm_information8 in varchar2 default hr_api.g_varchar2,
479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,
480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,
481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,
482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,
483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,
484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,
485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,
486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,

Line 483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,

479: p_pmm_information9 in varchar2 default hr_api.g_varchar2,
480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,
481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,
482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,
483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,
484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,
485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,
486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,
487: p_pmm_information17 in varchar2 default hr_api.g_varchar2,

Line 484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,

480: p_pmm_information10 in varchar2 default hr_api.g_varchar2,
481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,
482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,
483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,
484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,
485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,
486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,
487: p_pmm_information17 in varchar2 default hr_api.g_varchar2,
488: p_pmm_information18 in varchar2 default hr_api.g_varchar2,

Line 485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,

481: p_pmm_information11 in varchar2 default hr_api.g_varchar2,
482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,
483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,
484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,
485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,
486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,
487: p_pmm_information17 in varchar2 default hr_api.g_varchar2,
488: p_pmm_information18 in varchar2 default hr_api.g_varchar2,
489: p_pmm_information19 in varchar2 default hr_api.g_varchar2,

Line 486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,

482: p_pmm_information12 in varchar2 default hr_api.g_varchar2,
483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,
484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,
485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,
486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,
487: p_pmm_information17 in varchar2 default hr_api.g_varchar2,
488: p_pmm_information18 in varchar2 default hr_api.g_varchar2,
489: p_pmm_information19 in varchar2 default hr_api.g_varchar2,
490: p_pmm_information20 in varchar2 default hr_api.g_varchar2,

Line 487: p_pmm_information17 in varchar2 default hr_api.g_varchar2,

483: p_pmm_information13 in varchar2 default hr_api.g_varchar2,
484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,
485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,
486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,
487: p_pmm_information17 in varchar2 default hr_api.g_varchar2,
488: p_pmm_information18 in varchar2 default hr_api.g_varchar2,
489: p_pmm_information19 in varchar2 default hr_api.g_varchar2,
490: p_pmm_information20 in varchar2 default hr_api.g_varchar2,
491: p_validate in boolean default false

Line 488: p_pmm_information18 in varchar2 default hr_api.g_varchar2,

484: p_pmm_information14 in varchar2 default hr_api.g_varchar2,
485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,
486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,
487: p_pmm_information17 in varchar2 default hr_api.g_varchar2,
488: p_pmm_information18 in varchar2 default hr_api.g_varchar2,
489: p_pmm_information19 in varchar2 default hr_api.g_varchar2,
490: p_pmm_information20 in varchar2 default hr_api.g_varchar2,
491: p_validate in boolean default false
492: ) is

Line 489: p_pmm_information19 in varchar2 default hr_api.g_varchar2,

485: p_pmm_information15 in varchar2 default hr_api.g_varchar2,
486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,
487: p_pmm_information17 in varchar2 default hr_api.g_varchar2,
488: p_pmm_information18 in varchar2 default hr_api.g_varchar2,
489: p_pmm_information19 in varchar2 default hr_api.g_varchar2,
490: p_pmm_information20 in varchar2 default hr_api.g_varchar2,
491: p_validate in boolean default false
492: ) is
493: --

Line 490: p_pmm_information20 in varchar2 default hr_api.g_varchar2,

486: p_pmm_information16 in varchar2 default hr_api.g_varchar2,
487: p_pmm_information17 in varchar2 default hr_api.g_varchar2,
488: p_pmm_information18 in varchar2 default hr_api.g_varchar2,
489: p_pmm_information19 in varchar2 default hr_api.g_varchar2,
490: p_pmm_information20 in varchar2 default hr_api.g_varchar2,
491: p_validate in boolean default false
492: ) is
493: --
494: l_rec ota_pmm_shd.g_rec_type;