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));
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
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));
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
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));
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
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: --
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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: --
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;