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.OTA_TAD_API dependencies on HR_API

Line 68: -- The exception hr_api.check_integrity_violated,

64: -- {Start Of Comments}
65: --
66: -- Description:
67: -- This procedure is called when a constraint has been violated (i.e.
68: -- The exception hr_api.check_integrity_violated,
69: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
70: -- been raised).
71: -- The exceptions can only be raised as follows:
72: -- 1) A check constraint can only be violated during an INSERT or UPDATE

Line 69: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has

65: --
66: -- Description:
67: -- This procedure is called when a constraint has been violated (i.e.
68: -- The exception hr_api.check_integrity_violated,
69: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
70: -- been raised).
71: -- The exceptions can only be raised as follows:
72: -- 1) A check constraint can only be violated during an INSERT or UPDATE
73: -- dml operation.

Line 80: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated

76: -- 3) A child integrity constraint can only be violated during an
77: -- DELETE dml operation.
78: --
79: -- Pre Conditions:
80: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
81: -- or hr_api.child_integrity_violated has been raised with the subsequent
82: -- stripping of the constraint name from the generated error message text.
83: --
84: -- In Arguments:

Line 81: -- or hr_api.child_integrity_violated has been raised with the subsequent

77: -- DELETE dml operation.
78: --
79: -- Pre Conditions:
80: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
81: -- or hr_api.child_integrity_violated has been raised with the subsequent
82: -- stripping of the constraint name from the generated error message text.
83: --
84: -- In Arguments:
85: -- p_constraint_name is in upper format and is just the constraint name

Line 392: If ( nvl( p_first_start_date ,hr_api.g_sot)

388: --
389: -- Check whether the first startdate is between the second startdate and
390: -- the second enddate => Overlapping dates
391: --
392: If ( nvl( p_first_start_date ,hr_api.g_sot)
393: Between nvl( p_second_start_date ,hr_api.g_sot)
394: And nvl( p_second_end_date ,hr_api.g_eot) ) OR
395: --
396: -- Check whether the first enddate is between the second startdate and

Line 393: Between nvl( p_second_start_date ,hr_api.g_sot)

389: -- Check whether the first startdate is between the second startdate and
390: -- the second enddate => Overlapping dates
391: --
392: If ( nvl( p_first_start_date ,hr_api.g_sot)
393: Between nvl( p_second_start_date ,hr_api.g_sot)
394: And nvl( p_second_end_date ,hr_api.g_eot) ) OR
395: --
396: -- Check whether the first enddate is between the second startdate and
397: -- the second enddate => Overlapping dates

Line 394: And nvl( p_second_end_date ,hr_api.g_eot) ) OR

390: -- the second enddate => Overlapping dates
391: --
392: If ( nvl( p_first_start_date ,hr_api.g_sot)
393: Between nvl( p_second_start_date ,hr_api.g_sot)
394: And nvl( p_second_end_date ,hr_api.g_eot) ) OR
395: --
396: -- Check whether the first enddate is between the second startdate and
397: -- the second enddate => Overlapping dates
398: --

Line 399: ( nvl( p_first_end_date ,hr_api.g_eot)

395: --
396: -- Check whether the first enddate is between the second startdate and
397: -- the second enddate => Overlapping dates
398: --
399: ( nvl( p_first_end_date ,hr_api.g_eot)
400: Between nvl( p_second_start_date ,hr_api.g_sot)
401: And nvl( p_second_end_date ,hr_api.g_eot) ) OR
402: --
403: -- Check whether the first datepair includes the second datepair

Line 400: Between nvl( p_second_start_date ,hr_api.g_sot)

396: -- Check whether the first enddate is between the second startdate and
397: -- the second enddate => Overlapping dates
398: --
399: ( nvl( p_first_end_date ,hr_api.g_eot)
400: Between nvl( p_second_start_date ,hr_api.g_sot)
401: And nvl( p_second_end_date ,hr_api.g_eot) ) OR
402: --
403: -- Check whether the first datepair includes the second datepair
404: -- => Overlapping dates

Line 401: And nvl( p_second_end_date ,hr_api.g_eot) ) OR

397: -- the second enddate => Overlapping dates
398: --
399: ( nvl( p_first_end_date ,hr_api.g_eot)
400: Between nvl( p_second_start_date ,hr_api.g_sot)
401: And nvl( p_second_end_date ,hr_api.g_eot) ) OR
402: --
403: -- Check whether the first datepair includes the second datepair
404: -- => Overlapping dates
405: --

Line 406: (( nvl( p_second_start_date ,hr_api.g_sot)

402: --
403: -- Check whether the first datepair includes the second datepair
404: -- => Overlapping dates
405: --
406: (( nvl( p_second_start_date ,hr_api.g_sot)
407: Between nvl( p_first_start_date ,hr_api.g_sot)
408: And nvl( p_first_end_date ,hr_api.g_eot) ) AND
409: ( nvl( p_second_end_date ,hr_api.g_eot)
410: Between nvl( p_first_start_date ,hr_api.g_sot)

Line 407: Between nvl( p_first_start_date ,hr_api.g_sot)

403: -- Check whether the first datepair includes the second datepair
404: -- => Overlapping dates
405: --
406: (( nvl( p_second_start_date ,hr_api.g_sot)
407: Between nvl( p_first_start_date ,hr_api.g_sot)
408: And nvl( p_first_end_date ,hr_api.g_eot) ) AND
409: ( nvl( p_second_end_date ,hr_api.g_eot)
410: Between nvl( p_first_start_date ,hr_api.g_sot)
411: And nvl( p_first_end_date ,hr_api.g_eot) ) ) OR

Line 408: And nvl( p_first_end_date ,hr_api.g_eot) ) AND

404: -- => Overlapping dates
405: --
406: (( nvl( p_second_start_date ,hr_api.g_sot)
407: Between nvl( p_first_start_date ,hr_api.g_sot)
408: And nvl( p_first_end_date ,hr_api.g_eot) ) AND
409: ( nvl( p_second_end_date ,hr_api.g_eot)
410: Between nvl( p_first_start_date ,hr_api.g_sot)
411: And nvl( p_first_end_date ,hr_api.g_eot) ) ) OR
412: --

Line 409: ( nvl( p_second_end_date ,hr_api.g_eot)

405: --
406: (( nvl( p_second_start_date ,hr_api.g_sot)
407: Between nvl( p_first_start_date ,hr_api.g_sot)
408: And nvl( p_first_end_date ,hr_api.g_eot) ) AND
409: ( nvl( p_second_end_date ,hr_api.g_eot)
410: Between nvl( p_first_start_date ,hr_api.g_sot)
411: And nvl( p_first_end_date ,hr_api.g_eot) ) ) OR
412: --
413: -- Check whether the second datepair includes the first datepair

Line 410: Between nvl( p_first_start_date ,hr_api.g_sot)

406: (( nvl( p_second_start_date ,hr_api.g_sot)
407: Between nvl( p_first_start_date ,hr_api.g_sot)
408: And nvl( p_first_end_date ,hr_api.g_eot) ) AND
409: ( nvl( p_second_end_date ,hr_api.g_eot)
410: Between nvl( p_first_start_date ,hr_api.g_sot)
411: And nvl( p_first_end_date ,hr_api.g_eot) ) ) OR
412: --
413: -- Check whether the second datepair includes the first datepair
414: -- => Overlapping dates

Line 411: And nvl( p_first_end_date ,hr_api.g_eot) ) ) OR

407: Between nvl( p_first_start_date ,hr_api.g_sot)
408: And nvl( p_first_end_date ,hr_api.g_eot) ) AND
409: ( nvl( p_second_end_date ,hr_api.g_eot)
410: Between nvl( p_first_start_date ,hr_api.g_sot)
411: And nvl( p_first_end_date ,hr_api.g_eot) ) ) OR
412: --
413: -- Check whether the second datepair includes the first datepair
414: -- => Overlapping dates
415: --

Line 416: (( nvl( p_first_start_date ,hr_api.g_sot)

412: --
413: -- Check whether the second datepair includes the first datepair
414: -- => Overlapping dates
415: --
416: (( nvl( p_first_start_date ,hr_api.g_sot)
417: Between nvl( p_second_start_date ,hr_api.g_sot)
418: And nvl( p_second_end_date ,hr_api.g_eot) ) AND
419: ( nvl( p_first_end_date ,hr_api.g_eot)
420: Between nvl( p_second_start_date ,hr_api.g_sot)

Line 417: Between nvl( p_second_start_date ,hr_api.g_sot)

413: -- Check whether the second datepair includes the first datepair
414: -- => Overlapping dates
415: --
416: (( nvl( p_first_start_date ,hr_api.g_sot)
417: Between nvl( p_second_start_date ,hr_api.g_sot)
418: And nvl( p_second_end_date ,hr_api.g_eot) ) AND
419: ( nvl( p_first_end_date ,hr_api.g_eot)
420: Between nvl( p_second_start_date ,hr_api.g_sot)
421: And nvl( p_second_end_date ,hr_api.g_eot) ) ) THEN

Line 418: And nvl( p_second_end_date ,hr_api.g_eot) ) AND

414: -- => Overlapping dates
415: --
416: (( nvl( p_first_start_date ,hr_api.g_sot)
417: Between nvl( p_second_start_date ,hr_api.g_sot)
418: And nvl( p_second_end_date ,hr_api.g_eot) ) AND
419: ( nvl( p_first_end_date ,hr_api.g_eot)
420: Between nvl( p_second_start_date ,hr_api.g_sot)
421: And nvl( p_second_end_date ,hr_api.g_eot) ) ) THEN
422: --

Line 419: ( nvl( p_first_end_date ,hr_api.g_eot)

415: --
416: (( nvl( p_first_start_date ,hr_api.g_sot)
417: Between nvl( p_second_start_date ,hr_api.g_sot)
418: And nvl( p_second_end_date ,hr_api.g_eot) ) AND
419: ( nvl( p_first_end_date ,hr_api.g_eot)
420: Between nvl( p_second_start_date ,hr_api.g_sot)
421: And nvl( p_second_end_date ,hr_api.g_eot) ) ) THEN
422: --
423: -- The pair of dates (first,second) are overlapped

Line 420: Between nvl( p_second_start_date ,hr_api.g_sot)

416: (( nvl( p_first_start_date ,hr_api.g_sot)
417: Between nvl( p_second_start_date ,hr_api.g_sot)
418: And nvl( p_second_end_date ,hr_api.g_eot) ) AND
419: ( nvl( p_first_end_date ,hr_api.g_eot)
420: Between nvl( p_second_start_date ,hr_api.g_sot)
421: And nvl( p_second_end_date ,hr_api.g_eot) ) ) THEN
422: --
423: -- The pair of dates (first,second) are overlapped
424: --

Line 421: And nvl( p_second_end_date ,hr_api.g_eot) ) ) THEN

417: Between nvl( p_second_start_date ,hr_api.g_sot)
418: And nvl( p_second_end_date ,hr_api.g_eot) ) AND
419: ( nvl( p_first_end_date ,hr_api.g_eot)
420: Between nvl( p_second_start_date ,hr_api.g_sot)
421: And nvl( p_second_end_date ,hr_api.g_eot) ) ) THEN
422: --
423: -- The pair of dates (first,second) are overlapped
424: --
425: Return( true);

Line 702: When hr_api.check_integrity_violated Then

698: g_api_dml := false; -- Unset the api dml status
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 10);
701: Exception
702: When hr_api.check_integrity_violated Then
703: -- A check constraint has been violated
704: g_api_dml := false; -- Unset the api dml status
705: constraint_error
706: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

702: When hr_api.check_integrity_violated Then
703: -- A check constraint has been violated
704: g_api_dml := false; -- Unset the api dml status
705: constraint_error
706: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
707: When hr_api.parent_integrity_violated then
708: -- Parent integrity has been violated
709: g_api_dml := false; -- Unset the api dml status
710: constraint_error

Line 707: When hr_api.parent_integrity_violated then

703: -- A check constraint has been violated
704: g_api_dml := false; -- Unset the api dml status
705: constraint_error
706: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
707: When hr_api.parent_integrity_violated then
708: -- Parent integrity has been violated
709: g_api_dml := false; -- Unset the api dml status
710: constraint_error
711: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

707: When hr_api.parent_integrity_violated then
708: -- Parent integrity has been violated
709: g_api_dml := false; -- Unset the api dml status
710: constraint_error
711: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
712: When Others Then
713: g_api_dml := false; -- Unset the api dml status
714: Raise;
715: End insert_dml;

Line 811: When hr_api.check_integrity_violated Then

807: --
808: hr_utility.set_location(' Leaving:'||l_proc, 10);
809: --
810: Exception
811: When hr_api.check_integrity_violated Then
812: -- A check constraint has been violated
813: g_api_dml := false; -- Unset the api dml status
814: constraint_error
815: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

811: When hr_api.check_integrity_violated Then
812: -- A check constraint has been violated
813: g_api_dml := false; -- Unset the api dml status
814: constraint_error
815: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
816: When hr_api.parent_integrity_violated then
817: -- Parent integrity has been violated
818: g_api_dml := false; -- Unset the api dml status
819: constraint_error

Line 816: When hr_api.parent_integrity_violated then

812: -- A check constraint has been violated
813: g_api_dml := false; -- Unset the api dml status
814: constraint_error
815: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
816: When hr_api.parent_integrity_violated then
817: -- Parent integrity has been violated
818: g_api_dml := false; -- Unset the api dml status
819: constraint_error
820: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

816: When hr_api.parent_integrity_violated then
817: -- Parent integrity has been violated
818: g_api_dml := false; -- Unset the api dml status
819: constraint_error
820: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
821: When Others Then
822: g_api_dml := false; -- Unset the api dml status
823: Raise;
824: End update_dml;

Line 895: When hr_api.child_integrity_violated then

891: --
892: hr_utility.set_location(' Leaving:'||l_proc, 10);
893: --
894: Exception
895: When hr_api.child_integrity_violated then
896: -- Child integrity has been violated
897: g_api_dml := false; -- Unset the api dml status
898: constraint_error
899: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

895: When hr_api.child_integrity_violated then
896: -- Child integrity has been violated
897: g_api_dml := false; -- Unset the api dml status
898: constraint_error
899: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
900: When Others Then
901: g_api_dml := false; -- Unset the api dml status
902: Raise;
903: End delete_dml;

Line 1182: -- another user. This will raise the HR_Api.Object_Locked exception.

1178: --
1179: -- Post Failure:
1180: -- The Lck process can fail for three reasons:
1181: -- 1) When attempting to lock the row the row could already be locked by
1182: -- another user. This will raise the HR_Api.Object_Locked exception.
1183: -- 2) The row which is required to be locked doesn't exist in the HR Schema.
1184: -- This error is trapped and reported using the message name
1185: -- 'HR_7155_OBJECT_INVALID'.
1186: -- 3) The row although existing in the HR Schema has a different object

Line 1193: -- call to hr_api.mandatory_arg_error procedure to ensure that these

1189: -- 'HR_7155_OBJECT_INVALID'.
1190: --
1191: -- Developer Implementation Notes:
1192: -- For each primary key and the object version number arguments add a
1193: -- call to hr_api.mandatory_arg_error procedure to ensure that these
1194: -- argument values are not null.
1195: --
1196: -- {End Of Comments}
1197: -- ----------------------------------------------------------------------------

Line 1248: -- hr_api.check_mandatory_arg_error

1244: hr_utility.set_location('Entering:'||l_proc, 5);
1245: --
1246: -- Add any mandatory argument checking here:
1247: -- Example:
1248: -- hr_api.check_mandatory_arg_error
1249: -- (p_api_name => l_proc,
1250: -- p_argument => 'object_version_number',
1251: -- p_argument_value => p_object_version_number);
1252: --

Line 1273: When HR_Api.Object_Locked then

1269: --
1270: -- We need to trap the ORA LOCK exception
1271: --
1272: Exception
1273: When HR_Api.Object_Locked then
1274: --
1275: -- The object is locked therefore we need to supply a meaningful
1276: -- error message.
1277: --

Line 1443: If (p_rec.business_group_id = hr_api.g_number) then

1439: -- p_rec plsql record structure
1440: -- to see if a system default is being used. If a system default
1441: -- is being used then we must set to the 'current' argument value.
1442: --
1443: If (p_rec.business_group_id = hr_api.g_number) then
1444: p_rec.business_group_id := g_old_rec.business_group_id;
1445: End If;
1446: If (p_rec.name = hr_api.g_varchar2) then
1447: p_rec.name := g_old_rec.name;

Line 1446: If (p_rec.name = hr_api.g_varchar2) then

1442: --
1443: If (p_rec.business_group_id = hr_api.g_number) then
1444: p_rec.business_group_id := g_old_rec.business_group_id;
1445: End If;
1446: If (p_rec.name = hr_api.g_varchar2) then
1447: p_rec.name := g_old_rec.name;
1448: End If;
1449: If (p_rec.comments = hr_api.g_varchar2) then
1450: p_rec.comments := g_old_rec.comments;

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

1445: End If;
1446: If (p_rec.name = hr_api.g_varchar2) then
1447: p_rec.name := g_old_rec.name;
1448: End If;
1449: If (p_rec.comments = hr_api.g_varchar2) then
1450: p_rec.comments := g_old_rec.comments;
1451: End If;
1452: If (p_rec.description = hr_api.g_varchar2) then
1453: p_rec.description := g_old_rec.description;

Line 1452: If (p_rec.description = hr_api.g_varchar2) then

1448: End If;
1449: If (p_rec.comments = hr_api.g_varchar2) then
1450: p_rec.comments := g_old_rec.comments;
1451: End If;
1452: If (p_rec.description = hr_api.g_varchar2) then
1453: p_rec.description := g_old_rec.description;
1454: End If;
1455: If (p_rec.multiple_con_versions_flag = hr_api.g_varchar2) then
1456: p_rec.multiple_con_versions_flag :=

Line 1455: If (p_rec.multiple_con_versions_flag = hr_api.g_varchar2) then

1451: End If;
1452: If (p_rec.description = hr_api.g_varchar2) then
1453: p_rec.description := g_old_rec.description;
1454: End If;
1455: If (p_rec.multiple_con_versions_flag = hr_api.g_varchar2) then
1456: p_rec.multiple_con_versions_flag :=
1457: g_old_rec.multiple_con_versions_flag;
1458: End If;
1459: If (p_rec.tad_information_category = hr_api.g_varchar2) then

Line 1459: If (p_rec.tad_information_category = hr_api.g_varchar2) then

1455: If (p_rec.multiple_con_versions_flag = hr_api.g_varchar2) then
1456: p_rec.multiple_con_versions_flag :=
1457: g_old_rec.multiple_con_versions_flag;
1458: End If;
1459: If (p_rec.tad_information_category = hr_api.g_varchar2) then
1460: p_rec.tad_information_category := g_old_rec.tad_information_category;
1461: End If;
1462: If (p_rec.tad_information1 = hr_api.g_varchar2) then
1463: p_rec.tad_information1 := g_old_rec.tad_information1;

Line 1462: If (p_rec.tad_information1 = hr_api.g_varchar2) then

1458: End If;
1459: If (p_rec.tad_information_category = hr_api.g_varchar2) then
1460: p_rec.tad_information_category := g_old_rec.tad_information_category;
1461: End If;
1462: If (p_rec.tad_information1 = hr_api.g_varchar2) then
1463: p_rec.tad_information1 := g_old_rec.tad_information1;
1464: End If;
1465: If (p_rec.tad_information2 = hr_api.g_varchar2) then
1466: p_rec.tad_information2 := g_old_rec.tad_information2;

Line 1465: If (p_rec.tad_information2 = hr_api.g_varchar2) then

1461: End If;
1462: If (p_rec.tad_information1 = hr_api.g_varchar2) then
1463: p_rec.tad_information1 := g_old_rec.tad_information1;
1464: End If;
1465: If (p_rec.tad_information2 = hr_api.g_varchar2) then
1466: p_rec.tad_information2 := g_old_rec.tad_information2;
1467: End If;
1468: If (p_rec.tad_information3 = hr_api.g_varchar2) then
1469: p_rec.tad_information3 := g_old_rec.tad_information3;

Line 1468: If (p_rec.tad_information3 = hr_api.g_varchar2) then

1464: End If;
1465: If (p_rec.tad_information2 = hr_api.g_varchar2) then
1466: p_rec.tad_information2 := g_old_rec.tad_information2;
1467: End If;
1468: If (p_rec.tad_information3 = hr_api.g_varchar2) then
1469: p_rec.tad_information3 := g_old_rec.tad_information3;
1470: End If;
1471: If (p_rec.tad_information4 = hr_api.g_varchar2) then
1472: p_rec.tad_information4 := g_old_rec.tad_information4;

Line 1471: If (p_rec.tad_information4 = hr_api.g_varchar2) then

1467: End If;
1468: If (p_rec.tad_information3 = hr_api.g_varchar2) then
1469: p_rec.tad_information3 := g_old_rec.tad_information3;
1470: End If;
1471: If (p_rec.tad_information4 = hr_api.g_varchar2) then
1472: p_rec.tad_information4 := g_old_rec.tad_information4;
1473: End If;
1474: If (p_rec.tad_information5 = hr_api.g_varchar2) then
1475: p_rec.tad_information5 := g_old_rec.tad_information5;

Line 1474: If (p_rec.tad_information5 = hr_api.g_varchar2) then

1470: End If;
1471: If (p_rec.tad_information4 = hr_api.g_varchar2) then
1472: p_rec.tad_information4 := g_old_rec.tad_information4;
1473: End If;
1474: If (p_rec.tad_information5 = hr_api.g_varchar2) then
1475: p_rec.tad_information5 := g_old_rec.tad_information5;
1476: End If;
1477: If (p_rec.tad_information6 = hr_api.g_varchar2) then
1478: p_rec.tad_information6 := g_old_rec.tad_information6;

Line 1477: If (p_rec.tad_information6 = hr_api.g_varchar2) then

1473: End If;
1474: If (p_rec.tad_information5 = hr_api.g_varchar2) then
1475: p_rec.tad_information5 := g_old_rec.tad_information5;
1476: End If;
1477: If (p_rec.tad_information6 = hr_api.g_varchar2) then
1478: p_rec.tad_information6 := g_old_rec.tad_information6;
1479: End If;
1480: If (p_rec.tad_information7 = hr_api.g_varchar2) then
1481: p_rec.tad_information7 := g_old_rec.tad_information7;

Line 1480: If (p_rec.tad_information7 = hr_api.g_varchar2) then

1476: End If;
1477: If (p_rec.tad_information6 = hr_api.g_varchar2) then
1478: p_rec.tad_information6 := g_old_rec.tad_information6;
1479: End If;
1480: If (p_rec.tad_information7 = hr_api.g_varchar2) then
1481: p_rec.tad_information7 := g_old_rec.tad_information7;
1482: End If;
1483: If (p_rec.tad_information8 = hr_api.g_varchar2) then
1484: p_rec.tad_information8 := g_old_rec.tad_information8;

Line 1483: If (p_rec.tad_information8 = hr_api.g_varchar2) then

1479: End If;
1480: If (p_rec.tad_information7 = hr_api.g_varchar2) then
1481: p_rec.tad_information7 := g_old_rec.tad_information7;
1482: End If;
1483: If (p_rec.tad_information8 = hr_api.g_varchar2) then
1484: p_rec.tad_information8 := g_old_rec.tad_information8;
1485: End If;
1486: If (p_rec.tad_information9 = hr_api.g_varchar2) then
1487: p_rec.tad_information9 := g_old_rec.tad_information9;

Line 1486: If (p_rec.tad_information9 = hr_api.g_varchar2) then

1482: End If;
1483: If (p_rec.tad_information8 = hr_api.g_varchar2) then
1484: p_rec.tad_information8 := g_old_rec.tad_information8;
1485: End If;
1486: If (p_rec.tad_information9 = hr_api.g_varchar2) then
1487: p_rec.tad_information9 := g_old_rec.tad_information9;
1488: End If;
1489: If (p_rec.tad_information10 = hr_api.g_varchar2) then
1490: p_rec.tad_information10 := g_old_rec.tad_information10;

Line 1489: If (p_rec.tad_information10 = hr_api.g_varchar2) then

1485: End If;
1486: If (p_rec.tad_information9 = hr_api.g_varchar2) then
1487: p_rec.tad_information9 := g_old_rec.tad_information9;
1488: End If;
1489: If (p_rec.tad_information10 = hr_api.g_varchar2) then
1490: p_rec.tad_information10 := g_old_rec.tad_information10;
1491: End If;
1492: If (p_rec.tad_information11 = hr_api.g_varchar2) then
1493: p_rec.tad_information11 := g_old_rec.tad_information11;

Line 1492: If (p_rec.tad_information11 = hr_api.g_varchar2) then

1488: End If;
1489: If (p_rec.tad_information10 = hr_api.g_varchar2) then
1490: p_rec.tad_information10 := g_old_rec.tad_information10;
1491: End If;
1492: If (p_rec.tad_information11 = hr_api.g_varchar2) then
1493: p_rec.tad_information11 := g_old_rec.tad_information11;
1494: End If;
1495: If (p_rec.tad_information12 = hr_api.g_varchar2) then
1496: p_rec.tad_information12 := g_old_rec.tad_information12;

Line 1495: If (p_rec.tad_information12 = hr_api.g_varchar2) then

1491: End If;
1492: If (p_rec.tad_information11 = hr_api.g_varchar2) then
1493: p_rec.tad_information11 := g_old_rec.tad_information11;
1494: End If;
1495: If (p_rec.tad_information12 = hr_api.g_varchar2) then
1496: p_rec.tad_information12 := g_old_rec.tad_information12;
1497: End If;
1498: If (p_rec.tad_information13 = hr_api.g_varchar2) then
1499: p_rec.tad_information13 := g_old_rec.tad_information13;

Line 1498: If (p_rec.tad_information13 = hr_api.g_varchar2) then

1494: End If;
1495: If (p_rec.tad_information12 = hr_api.g_varchar2) then
1496: p_rec.tad_information12 := g_old_rec.tad_information12;
1497: End If;
1498: If (p_rec.tad_information13 = hr_api.g_varchar2) then
1499: p_rec.tad_information13 := g_old_rec.tad_information13;
1500: End If;
1501: If (p_rec.tad_information14 = hr_api.g_varchar2) then
1502: p_rec.tad_information14 := g_old_rec.tad_information14;

Line 1501: If (p_rec.tad_information14 = hr_api.g_varchar2) then

1497: End If;
1498: If (p_rec.tad_information13 = hr_api.g_varchar2) then
1499: p_rec.tad_information13 := g_old_rec.tad_information13;
1500: End If;
1501: If (p_rec.tad_information14 = hr_api.g_varchar2) then
1502: p_rec.tad_information14 := g_old_rec.tad_information14;
1503: End If;
1504: If (p_rec.tad_information15 = hr_api.g_varchar2) then
1505: p_rec.tad_information15 := g_old_rec.tad_information15;

Line 1504: If (p_rec.tad_information15 = hr_api.g_varchar2) then

1500: End If;
1501: If (p_rec.tad_information14 = hr_api.g_varchar2) then
1502: p_rec.tad_information14 := g_old_rec.tad_information14;
1503: End If;
1504: If (p_rec.tad_information15 = hr_api.g_varchar2) then
1505: p_rec.tad_information15 := g_old_rec.tad_information15;
1506: End If;
1507: If (p_rec.tad_information16 = hr_api.g_varchar2) then
1508: p_rec.tad_information16 := g_old_rec.tad_information16;

Line 1507: If (p_rec.tad_information16 = hr_api.g_varchar2) then

1503: End If;
1504: If (p_rec.tad_information15 = hr_api.g_varchar2) then
1505: p_rec.tad_information15 := g_old_rec.tad_information15;
1506: End If;
1507: If (p_rec.tad_information16 = hr_api.g_varchar2) then
1508: p_rec.tad_information16 := g_old_rec.tad_information16;
1509: End If;
1510: If (p_rec.tad_information17 = hr_api.g_varchar2) then
1511: p_rec.tad_information17 := g_old_rec.tad_information17;

Line 1510: If (p_rec.tad_information17 = hr_api.g_varchar2) then

1506: End If;
1507: If (p_rec.tad_information16 = hr_api.g_varchar2) then
1508: p_rec.tad_information16 := g_old_rec.tad_information16;
1509: End If;
1510: If (p_rec.tad_information17 = hr_api.g_varchar2) then
1511: p_rec.tad_information17 := g_old_rec.tad_information17;
1512: End If;
1513: If (p_rec.tad_information18 = hr_api.g_varchar2) then
1514: p_rec.tad_information18 := g_old_rec.tad_information18;

Line 1513: If (p_rec.tad_information18 = hr_api.g_varchar2) then

1509: End If;
1510: If (p_rec.tad_information17 = hr_api.g_varchar2) then
1511: p_rec.tad_information17 := g_old_rec.tad_information17;
1512: End If;
1513: If (p_rec.tad_information18 = hr_api.g_varchar2) then
1514: p_rec.tad_information18 := g_old_rec.tad_information18;
1515: End If;
1516: If (p_rec.tad_information19 = hr_api.g_varchar2) then
1517: p_rec.tad_information19 := g_old_rec.tad_information19;

Line 1516: If (p_rec.tad_information19 = hr_api.g_varchar2) then

1512: End If;
1513: If (p_rec.tad_information18 = hr_api.g_varchar2) then
1514: p_rec.tad_information18 := g_old_rec.tad_information18;
1515: End If;
1516: If (p_rec.tad_information19 = hr_api.g_varchar2) then
1517: p_rec.tad_information19 := g_old_rec.tad_information19;
1518: End If;
1519: If (p_rec.tad_information20 = hr_api.g_varchar2) then
1520: p_rec.tad_information20 := g_old_rec.tad_information20;

Line 1519: If (p_rec.tad_information20 = hr_api.g_varchar2) then

1515: End If;
1516: If (p_rec.tad_information19 = hr_api.g_varchar2) then
1517: p_rec.tad_information19 := g_old_rec.tad_information19;
1518: End If;
1519: If (p_rec.tad_information20 = hr_api.g_varchar2) then
1520: p_rec.tad_information20 := g_old_rec.tad_information20;
1521: End If;
1522: If (p_rec.category_usage_id = hr_api.g_number) then
1523: p_rec.category_usage_id := g_old_rec.category_usage_id;

Line 1522: If (p_rec.category_usage_id = hr_api.g_number) then

1518: End If;
1519: If (p_rec.tad_information20 = hr_api.g_varchar2) then
1520: p_rec.tad_information20 := g_old_rec.tad_information20;
1521: End If;
1522: If (p_rec.category_usage_id = hr_api.g_number) then
1523: p_rec.category_usage_id := g_old_rec.category_usage_id;
1524: End If;
1525: --
1526: -- Return the plsql record structure.

Line 1571: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1567: hr_utility.set_location('Entering:'||l_proc, 5);
1568: --
1569: -- Call all supporting business operations
1570: --
1571: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1572: --
1573: check_unique_name( p_rec.name
1574: , p_rec.business_group_id
1575: , p_rec.activity_id );

Line 1626: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1622: hr_utility.set_location('Entering:'||l_proc, 5);
1623: --
1624: -- Call all supporting business operations
1625: --
1626: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1627: --
1628: If l_name_changed Then
1629: --
1630: check_unique_name( p_rec.name

Line 1730: -- by raising and handling the exception hr_api.validate_enabled. We use

1726: -- default is false. The validation is controlled by a savepoint and
1727: -- rollback mechanism. The savepoint is issued at the beginning of the
1728: -- business process and is rollbacked at the end of the business process
1729: -- when all the processing has been completed. The rollback is controlled
1730: -- by raising and handling the exception hr_api.validate_enabled. We use
1731: -- the exception because, by raising the exception with the business
1732: -- process, we can exit successfully without having any of the 'OUT'
1733: -- arguments being set.
1734: --

Line 1787: Raise HR_Api.Validate_Enabled;

1783: --
1784: -- If we are validating then raise the Validate_Enabled exception
1785: --
1786: If p_validate then
1787: Raise HR_Api.Validate_Enabled;
1788: End If;
1789: --
1790: hr_utility.set_location(' Leaving:'||l_proc, 10);
1791: Exception

Line 1792: When HR_Api.Validate_Enabled Then

1788: End If;
1789: --
1790: hr_utility.set_location(' Leaving:'||l_proc, 10);
1791: Exception
1792: When HR_Api.Validate_Enabled Then
1793: --
1794: -- As the Validate_Enabled exception has been raised
1795: -- we must rollback to the savepoint
1796: --

Line 1976: -- by raising and handling the exception hr_api.validate_enabled. We use

1972: -- default is false. The validation is controlled by a savepoint and
1973: -- rollback mechanism. The savepoint is issued at the beginning of the
1974: -- business process and is rollbacked at the end of the business process
1975: -- when all the processing has been completed. The rollback is controlled
1976: -- by raising and handling the exception hr_api.validate_enabled. We use
1977: -- the exception because, by raising the exception with the business
1978: -- process, we can exit successfully without having any of the 'OUT'
1979: -- arguments being set.
1980: --

Line 2045: Raise HR_Api.Validate_Enabled;

2041: --
2042: -- If we are validating then raise the Validate_Enabled exception
2043: --
2044: If p_validate then
2045: Raise HR_Api.Validate_Enabled;
2046: End If;
2047: --
2048: hr_utility.set_location(' Leaving:'||l_proc, 10);
2049: Exception

Line 2050: When HR_Api.Validate_Enabled Then

2046: End If;
2047: --
2048: hr_utility.set_location(' Leaving:'||l_proc, 10);
2049: Exception
2050: When HR_Api.Validate_Enabled Then
2051: --
2052: -- As the Validate_Enabled exception has been raised
2053: -- we must rollback to the savepoint
2054: --

Line 2100: p_business_group_id in number default hr_api.g_number,

2096: -- ----------------------------------------------------------------------------
2097: Procedure upd
2098: (
2099: p_activity_id in number,
2100: p_business_group_id in number default hr_api.g_number,
2101: p_name in varchar2 default hr_api.g_varchar2,
2102: p_comments in varchar2 default hr_api.g_varchar2,
2103: p_description in varchar2 default hr_api.g_varchar2,
2104: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,

Line 2101: p_name in varchar2 default hr_api.g_varchar2,

2097: Procedure upd
2098: (
2099: p_activity_id in number,
2100: p_business_group_id in number default hr_api.g_number,
2101: p_name in varchar2 default hr_api.g_varchar2,
2102: p_comments in varchar2 default hr_api.g_varchar2,
2103: p_description in varchar2 default hr_api.g_varchar2,
2104: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
2105: p_object_version_number in out nocopy number,

Line 2102: p_comments in varchar2 default hr_api.g_varchar2,

2098: (
2099: p_activity_id in number,
2100: p_business_group_id in number default hr_api.g_number,
2101: p_name in varchar2 default hr_api.g_varchar2,
2102: p_comments in varchar2 default hr_api.g_varchar2,
2103: p_description in varchar2 default hr_api.g_varchar2,
2104: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
2105: p_object_version_number in out nocopy number,
2106: p_tad_information_category in varchar2 default hr_api.g_varchar2,

Line 2103: p_description in varchar2 default hr_api.g_varchar2,

2099: p_activity_id in number,
2100: p_business_group_id in number default hr_api.g_number,
2101: p_name in varchar2 default hr_api.g_varchar2,
2102: p_comments in varchar2 default hr_api.g_varchar2,
2103: p_description in varchar2 default hr_api.g_varchar2,
2104: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
2105: p_object_version_number in out nocopy number,
2106: p_tad_information_category in varchar2 default hr_api.g_varchar2,
2107: p_tad_information1 in varchar2 default hr_api.g_varchar2,

Line 2104: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,

2100: p_business_group_id in number default hr_api.g_number,
2101: p_name in varchar2 default hr_api.g_varchar2,
2102: p_comments in varchar2 default hr_api.g_varchar2,
2103: p_description in varchar2 default hr_api.g_varchar2,
2104: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
2105: p_object_version_number in out nocopy number,
2106: p_tad_information_category in varchar2 default hr_api.g_varchar2,
2107: p_tad_information1 in varchar2 default hr_api.g_varchar2,
2108: p_tad_information2 in varchar2 default hr_api.g_varchar2,

Line 2106: p_tad_information_category in varchar2 default hr_api.g_varchar2,

2102: p_comments in varchar2 default hr_api.g_varchar2,
2103: p_description in varchar2 default hr_api.g_varchar2,
2104: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
2105: p_object_version_number in out nocopy number,
2106: p_tad_information_category in varchar2 default hr_api.g_varchar2,
2107: p_tad_information1 in varchar2 default hr_api.g_varchar2,
2108: p_tad_information2 in varchar2 default hr_api.g_varchar2,
2109: p_tad_information3 in varchar2 default hr_api.g_varchar2,
2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,

Line 2107: p_tad_information1 in varchar2 default hr_api.g_varchar2,

2103: p_description in varchar2 default hr_api.g_varchar2,
2104: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
2105: p_object_version_number in out nocopy number,
2106: p_tad_information_category in varchar2 default hr_api.g_varchar2,
2107: p_tad_information1 in varchar2 default hr_api.g_varchar2,
2108: p_tad_information2 in varchar2 default hr_api.g_varchar2,
2109: p_tad_information3 in varchar2 default hr_api.g_varchar2,
2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,
2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,

Line 2108: p_tad_information2 in varchar2 default hr_api.g_varchar2,

2104: p_multiple_con_versions_flag in varchar2 default hr_api.g_varchar2,
2105: p_object_version_number in out nocopy number,
2106: p_tad_information_category in varchar2 default hr_api.g_varchar2,
2107: p_tad_information1 in varchar2 default hr_api.g_varchar2,
2108: p_tad_information2 in varchar2 default hr_api.g_varchar2,
2109: p_tad_information3 in varchar2 default hr_api.g_varchar2,
2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,
2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,
2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,

Line 2109: p_tad_information3 in varchar2 default hr_api.g_varchar2,

2105: p_object_version_number in out nocopy number,
2106: p_tad_information_category in varchar2 default hr_api.g_varchar2,
2107: p_tad_information1 in varchar2 default hr_api.g_varchar2,
2108: p_tad_information2 in varchar2 default hr_api.g_varchar2,
2109: p_tad_information3 in varchar2 default hr_api.g_varchar2,
2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,
2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,
2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,
2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,

Line 2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,

2106: p_tad_information_category in varchar2 default hr_api.g_varchar2,
2107: p_tad_information1 in varchar2 default hr_api.g_varchar2,
2108: p_tad_information2 in varchar2 default hr_api.g_varchar2,
2109: p_tad_information3 in varchar2 default hr_api.g_varchar2,
2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,
2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,
2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,
2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,
2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,

Line 2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,

2107: p_tad_information1 in varchar2 default hr_api.g_varchar2,
2108: p_tad_information2 in varchar2 default hr_api.g_varchar2,
2109: p_tad_information3 in varchar2 default hr_api.g_varchar2,
2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,
2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,
2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,
2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,
2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,
2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,

Line 2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,

2108: p_tad_information2 in varchar2 default hr_api.g_varchar2,
2109: p_tad_information3 in varchar2 default hr_api.g_varchar2,
2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,
2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,
2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,
2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,
2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,
2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,
2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,

Line 2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,

2109: p_tad_information3 in varchar2 default hr_api.g_varchar2,
2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,
2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,
2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,
2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,
2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,
2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,
2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,
2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,

Line 2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,

2110: p_tad_information4 in varchar2 default hr_api.g_varchar2,
2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,
2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,
2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,
2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,
2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,
2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,
2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,
2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,

Line 2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,

2111: p_tad_information5 in varchar2 default hr_api.g_varchar2,
2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,
2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,
2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,
2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,
2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,
2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,
2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,
2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,

Line 2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,

2112: p_tad_information6 in varchar2 default hr_api.g_varchar2,
2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,
2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,
2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,
2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,
2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,
2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,
2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,
2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,

Line 2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,

2113: p_tad_information7 in varchar2 default hr_api.g_varchar2,
2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,
2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,
2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,
2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,
2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,
2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,
2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,
2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,

Line 2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,

2114: p_tad_information8 in varchar2 default hr_api.g_varchar2,
2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,
2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,
2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,
2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,
2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,
2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,
2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,
2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,

Line 2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,

2115: p_tad_information9 in varchar2 default hr_api.g_varchar2,
2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,
2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,
2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,
2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,
2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,
2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,
2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,
2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,

Line 2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,

2116: p_tad_information10 in varchar2 default hr_api.g_varchar2,
2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,
2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,
2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,
2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,
2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,
2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,
2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,
2124: p_tad_information18 in varchar2 default hr_api.g_varchar2,

Line 2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,

2117: p_tad_information11 in varchar2 default hr_api.g_varchar2,
2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,
2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,
2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,
2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,
2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,
2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,
2124: p_tad_information18 in varchar2 default hr_api.g_varchar2,
2125: p_tad_information19 in varchar2 default hr_api.g_varchar2,

Line 2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,

2118: p_tad_information12 in varchar2 default hr_api.g_varchar2,
2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,
2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,
2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,
2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,
2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,
2124: p_tad_information18 in varchar2 default hr_api.g_varchar2,
2125: p_tad_information19 in varchar2 default hr_api.g_varchar2,
2126: p_tad_information20 in varchar2 default hr_api.g_varchar2,

Line 2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,

2119: p_tad_information13 in varchar2 default hr_api.g_varchar2,
2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,
2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,
2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,
2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,
2124: p_tad_information18 in varchar2 default hr_api.g_varchar2,
2125: p_tad_information19 in varchar2 default hr_api.g_varchar2,
2126: p_tad_information20 in varchar2 default hr_api.g_varchar2,
2127: p_category_usage_id in number default hr_api.g_number,

Line 2124: p_tad_information18 in varchar2 default hr_api.g_varchar2,

2120: p_tad_information14 in varchar2 default hr_api.g_varchar2,
2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,
2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,
2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,
2124: p_tad_information18 in varchar2 default hr_api.g_varchar2,
2125: p_tad_information19 in varchar2 default hr_api.g_varchar2,
2126: p_tad_information20 in varchar2 default hr_api.g_varchar2,
2127: p_category_usage_id in number default hr_api.g_number,
2128: p_validate in boolean default false

Line 2125: p_tad_information19 in varchar2 default hr_api.g_varchar2,

2121: p_tad_information15 in varchar2 default hr_api.g_varchar2,
2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,
2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,
2124: p_tad_information18 in varchar2 default hr_api.g_varchar2,
2125: p_tad_information19 in varchar2 default hr_api.g_varchar2,
2126: p_tad_information20 in varchar2 default hr_api.g_varchar2,
2127: p_category_usage_id in number default hr_api.g_number,
2128: p_validate in boolean default false
2129: ) is

Line 2126: p_tad_information20 in varchar2 default hr_api.g_varchar2,

2122: p_tad_information16 in varchar2 default hr_api.g_varchar2,
2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,
2124: p_tad_information18 in varchar2 default hr_api.g_varchar2,
2125: p_tad_information19 in varchar2 default hr_api.g_varchar2,
2126: p_tad_information20 in varchar2 default hr_api.g_varchar2,
2127: p_category_usage_id in number default hr_api.g_number,
2128: p_validate in boolean default false
2129: ) is
2130: --

Line 2127: p_category_usage_id in number default hr_api.g_number,

2123: p_tad_information17 in varchar2 default hr_api.g_varchar2,
2124: p_tad_information18 in varchar2 default hr_api.g_varchar2,
2125: p_tad_information19 in varchar2 default hr_api.g_varchar2,
2126: p_tad_information20 in varchar2 default hr_api.g_varchar2,
2127: p_category_usage_id in number default hr_api.g_number,
2128: p_validate in boolean default false
2129: ) is
2130: --
2131: l_rec g_rec_type;

Line 2221: -- by raising and handling the exception hr_api.validate_enabled. We use

2217: -- default is false. The validation is controlled by a savepoint and
2218: -- rollback mechanism. The savepoint is issued at the beginning of the
2219: -- business process and is rollbacked at the end of the business process
2220: -- when all the processing has been completed. The rollback is controlled
2221: -- by raising and handling the exception hr_api.validate_enabled. We use
2222: -- the exception because, by raising the exception with the business
2223: -- process, we can exit successfully without having any of the 'OUT'
2224: -- arguments being set.
2225: --

Line 2286: Raise HR_Api.Validate_Enabled;

2282: --
2283: -- If we are validating then raise the Validate_Enabled exception
2284: --
2285: If p_validate then
2286: Raise HR_Api.Validate_Enabled;
2287: End If;
2288: --
2289: hr_utility.set_location(' Leaving:'||l_proc, 10);
2290: Exception

Line 2291: When HR_Api.Validate_Enabled Then

2287: End If;
2288: --
2289: hr_utility.set_location(' Leaving:'||l_proc, 10);
2290: Exception
2291: When HR_Api.Validate_Enabled Then
2292: --
2293: -- As the Validate_Enabled exception has been raised
2294: -- we must rollback to the savepoint
2295: --