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_TBD_API dependencies on HR_API

Line 38: -- The exception hr_api.check_integrity_violated,

34: -- {Start Of Comments}
35: --
36: -- Description:
37: -- This procedure is called when a constraint has been violated (i.e.
38: -- The exception hr_api.check_integrity_violated,
39: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
40: -- been raised).
41: -- The exceptions can only be raised as follows:
42: -- 1) A check constraint can only be violated during an INSERT or UPDATE

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

35: --
36: -- Description:
37: -- This procedure is called when a constraint has been violated (i.e.
38: -- The exception hr_api.check_integrity_violated,
39: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
40: -- been raised).
41: -- The exceptions can only be raised as follows:
42: -- 1) A check constraint can only be violated during an INSERT or UPDATE
43: -- dml operation.

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

46: -- 3) A child integrity constraint can only be violated during an
47: -- DELETE dml operation.
48: --
49: -- Pre Conditions:
50: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
51: -- or hr_api.child_integrity_violated has been raised with the subsequent
52: -- stripping of the constraint name from the generated error message text.
53: --
54: -- In Arguments:

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

47: -- DELETE dml operation.
48: --
49: -- Pre Conditions:
50: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
51: -- or hr_api.child_integrity_violated has been raised with the subsequent
52: -- stripping of the constraint name from the generated error message text.
53: --
54: -- In Arguments:
55: -- p_constraint_name is in upper format and is just the constraint name

Line 336: and nvl(p_end_date,hr_api.g_eot)

332: where a.booking_deal_id = p_booking_deal_id
333: and a.booking_id = b.booking_id
334: and b.event_id = c.event_id
335: and p_start_date <= nvl(c.course_start_date,p_start_date)
336: and nvl(p_end_date,hr_api.g_eot)
337: >= nvl(c.course_start_date,nvl(p_end_date,hr_api.g_eot))
338: and a.cancelled_flag = 'N';
339: --
340: begin

Line 337: >= nvl(c.course_start_date,nvl(p_end_date,hr_api.g_eot))

333: and a.booking_id = b.booking_id
334: and b.event_id = c.event_id
335: and p_start_date <= nvl(c.course_start_date,p_start_date)
336: and nvl(p_end_date,hr_api.g_eot)
337: >= nvl(c.course_start_date,nvl(p_end_date,hr_api.g_eot))
338: and a.cancelled_flag = 'N';
339: --
340: begin
341: --

Line 683: nvl (TPL.START_DATE, hr_api.g_sot),

679: W_TPL_END_DATE date;
680: --
681: cursor C1 is
682: select TPL.BUSINESS_GROUP_ID,
683: nvl (TPL.START_DATE, hr_api.g_sot),
684: nvl (TPL.END_DATE, hr_api.g_eot)
685: from OTA_PRICE_LISTS TPL
686: where TPL.PRICE_LIST_ID = P_PRICE_LIST_ID;
687: --

Line 684: nvl (TPL.END_DATE, hr_api.g_eot)

680: --
681: cursor C1 is
682: select TPL.BUSINESS_GROUP_ID,
683: nvl (TPL.START_DATE, hr_api.g_sot),
684: nvl (TPL.END_DATE, hr_api.g_eot)
685: from OTA_PRICE_LISTS TPL
686: where TPL.PRICE_LIST_ID = P_PRICE_LIST_ID;
687: --
688: begin

Line 751: nvl (EVT.COURSE_START_DATE,hr_api.g_sot),

747: --
748: cursor C1 is
749: select EVT.BUSINESS_GROUP_ID,
750: EVT.EVENT_TYPE,
751: nvl (EVT.COURSE_START_DATE,hr_api.g_sot),
752: nvl (EVT.COURSE_END_DATE ,hr_api.g_eot),
753: maximum_attendees,
754: price_basis
755: from OTA_EVENTS EVT

Line 752: nvl (EVT.COURSE_END_DATE ,hr_api.g_eot),

748: cursor C1 is
749: select EVT.BUSINESS_GROUP_ID,
750: EVT.EVENT_TYPE,
751: nvl (EVT.COURSE_START_DATE,hr_api.g_sot),
752: nvl (EVT.COURSE_END_DATE ,hr_api.g_eot),
753: maximum_attendees,
754: price_basis
755: from OTA_EVENTS EVT
756: where EVT.EVENT_ID = P_EVENT_ID;

Line 836: select nvl (TAV.START_DATE, hr_api.g_sot),

832: W_TAV_START_DATE date;
833: W_TAV_END_DATE date;
834: --
835: cursor C1 is
836: select nvl (TAV.START_DATE, hr_api.g_sot),
837: nvl (TAV.END_DATE, hr_api.g_eot)
838: from OTA_ACTIVITY_VERSIONS TAV
839: where TAV.ACTIVITY_VERSION_ID = P_ACTIVITY_VERSION_ID;
840: --

Line 837: nvl (TAV.END_DATE, hr_api.g_eot)

833: W_TAV_END_DATE date;
834: --
835: cursor C1 is
836: select nvl (TAV.START_DATE, hr_api.g_sot),
837: nvl (TAV.END_DATE, hr_api.g_eot)
838: from OTA_ACTIVITY_VERSIONS TAV
839: where TAV.ACTIVITY_VERSION_ID = P_ACTIVITY_VERSION_ID;
840: --
841: begin

Line 1204: When hr_api.check_integrity_violated Then

1200: g_api_dml := false; -- Unset the api dml status
1201: --
1202: hr_utility.set_location(' Leaving:'||l_proc, 10);
1203: Exception
1204: When hr_api.check_integrity_violated Then
1205: -- A check constraint has been violated
1206: g_api_dml := false; -- Unset the api dml status
1207: constraint_error
1208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

1204: When hr_api.check_integrity_violated Then
1205: -- A check constraint has been violated
1206: g_api_dml := false; -- Unset the api dml status
1207: constraint_error
1208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1209: When hr_api.parent_integrity_violated Then
1210: -- Parent integrity has been violated
1211: g_api_dml := false; -- Unset the api dml status
1212: constraint_error

Line 1209: When hr_api.parent_integrity_violated Then

1205: -- A check constraint has been violated
1206: g_api_dml := false; -- Unset the api dml status
1207: constraint_error
1208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1209: When hr_api.parent_integrity_violated Then
1210: -- Parent integrity has been violated
1211: g_api_dml := false; -- Unset the api dml status
1212: constraint_error
1213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

1209: When hr_api.parent_integrity_violated Then
1210: -- Parent integrity has been violated
1211: g_api_dml := false; -- Unset the api dml status
1212: constraint_error
1213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1214: When hr_api.unique_integrity_violated Then
1215: -- Unique integrity has been violated
1216: g_api_dml := false; -- Unset the api dml status
1217: constraint_error

Line 1214: When hr_api.unique_integrity_violated Then

1210: -- Parent integrity has been violated
1211: g_api_dml := false; -- Unset the api dml status
1212: constraint_error
1213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1214: When hr_api.unique_integrity_violated Then
1215: -- Unique integrity has been violated
1216: g_api_dml := false; -- Unset the api dml status
1217: constraint_error
1218: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

1214: When hr_api.unique_integrity_violated Then
1215: -- Unique integrity has been violated
1216: g_api_dml := false; -- Unset the api dml status
1217: constraint_error
1218: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1219: When Others Then
1220: g_api_dml := false; -- Unset the api dml status
1221: Raise;
1222: End insert_dml;

Line 1329: When hr_api.check_integrity_violated Then

1325: --
1326: hr_utility.set_location(' Leaving:'||l_proc, 10);
1327: --
1328: Exception
1329: When hr_api.check_integrity_violated Then
1330: -- A check constraint has been violated
1331: g_api_dml := false; -- Unset the api dml status
1332: constraint_error
1333: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

1329: When hr_api.check_integrity_violated Then
1330: -- A check constraint has been violated
1331: g_api_dml := false; -- Unset the api dml status
1332: constraint_error
1333: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1334: When hr_api.parent_integrity_violated Then
1335: -- Parent integrity has been violated
1336: g_api_dml := false; -- Unset the api dml status
1337: constraint_error

Line 1334: When hr_api.parent_integrity_violated Then

1330: -- A check constraint has been violated
1331: g_api_dml := false; -- Unset the api dml status
1332: constraint_error
1333: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1334: When hr_api.parent_integrity_violated Then
1335: -- Parent integrity has been violated
1336: g_api_dml := false; -- Unset the api dml status
1337: constraint_error
1338: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

1334: When hr_api.parent_integrity_violated Then
1335: -- Parent integrity has been violated
1336: g_api_dml := false; -- Unset the api dml status
1337: constraint_error
1338: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1339: When hr_api.unique_integrity_violated Then
1340: -- Unique integrity has been violated
1341: g_api_dml := false; -- Unset the api dml status
1342: constraint_error

Line 1339: When hr_api.unique_integrity_violated Then

1335: -- Parent integrity has been violated
1336: g_api_dml := false; -- Unset the api dml status
1337: constraint_error
1338: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1339: When hr_api.unique_integrity_violated Then
1340: -- Unique integrity has been violated
1341: g_api_dml := false; -- Unset the api dml status
1342: constraint_error
1343: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

1339: When hr_api.unique_integrity_violated Then
1340: -- Unique integrity has been violated
1341: g_api_dml := false; -- Unset the api dml status
1342: constraint_error
1343: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1344: When Others Then
1345: g_api_dml := false; -- Unset the api dml status
1346: Raise;
1347: End update_dml;

Line 1406: When hr_api.child_integrity_violated then

1402: --
1403: hr_utility.set_location(' Leaving:'||l_proc, 10);
1404: --
1405: Exception
1406: When hr_api.child_integrity_violated then
1407: -- Child integrity has been violated
1408: g_api_dml := false; -- Unset the api dml status
1409: constraint_error
1410: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

1406: When hr_api.child_integrity_violated then
1407: -- Child integrity has been violated
1408: g_api_dml := false; -- Unset the api dml status
1409: constraint_error
1410: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1411: When Others Then
1412: g_api_dml := false; -- Unset the api dml status
1413: Raise;
1414: End delete_dml;

Line 1727: -- hr_api.mandatory_arg_error

1723: hr_utility.set_location('Entering:'||l_proc, 5);
1724: --
1725: -- Add any mandatory argument checking here:
1726: -- Example:
1727: -- hr_api.mandatory_arg_error
1728: -- (p_api_name => l_proc,
1729: -- p_argument => 'object_version_number',
1730: -- p_argument_value => p_object_version_number);
1731: --

Line 1753: When HR_Api.Object_Locked then

1749: --
1750: -- We need to trap the ORA LOCK exception
1751: --
1752: Exception
1753: When HR_Api.Object_Locked then
1754: --
1755: -- The object is locked therefore we need to supply a meaningful
1756: -- error message.
1757: --

Line 1945: If (p_rec.customer_id = hr_api.g_number) then

1941: -- p_rec plsql record structure
1942: -- to see if a system default is being used. If a system default
1943: -- is being used then we must set to the 'current' argument value.
1944: --
1945: If (p_rec.customer_id = hr_api.g_number) then
1946: p_rec.customer_id := g_old_rec.customer_id;
1947: End If;
1948: If (p_rec.approved_by_person_id = hr_api.g_number) then
1949: p_rec.approved_by_person_id := g_old_rec.approved_by_person_id;

Line 1948: If (p_rec.approved_by_person_id = hr_api.g_number) then

1944: --
1945: If (p_rec.customer_id = hr_api.g_number) then
1946: p_rec.customer_id := g_old_rec.customer_id;
1947: End If;
1948: If (p_rec.approved_by_person_id = hr_api.g_number) then
1949: p_rec.approved_by_person_id := g_old_rec.approved_by_person_id;
1950: End If;
1951: If (p_rec.business_group_id = hr_api.g_number) then
1952: p_rec.business_group_id := g_old_rec.business_group_id;

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

1947: End If;
1948: If (p_rec.approved_by_person_id = hr_api.g_number) then
1949: p_rec.approved_by_person_id := g_old_rec.approved_by_person_id;
1950: End If;
1951: If (p_rec.business_group_id = hr_api.g_number) then
1952: p_rec.business_group_id := g_old_rec.business_group_id;
1953: End If;
1954: If (p_rec.name = hr_api.g_varchar2) then
1955: p_rec.name := g_old_rec.name;

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

1950: End If;
1951: If (p_rec.business_group_id = hr_api.g_number) then
1952: p_rec.business_group_id := g_old_rec.business_group_id;
1953: End If;
1954: If (p_rec.name = hr_api.g_varchar2) then
1955: p_rec.name := g_old_rec.name;
1956: End If;
1957: If (p_rec.start_date = hr_api.g_date) then
1958: p_rec.start_date := g_old_rec.start_date;

Line 1957: If (p_rec.start_date = hr_api.g_date) then

1953: End If;
1954: If (p_rec.name = hr_api.g_varchar2) then
1955: p_rec.name := g_old_rec.name;
1956: End If;
1957: If (p_rec.start_date = hr_api.g_date) then
1958: p_rec.start_date := g_old_rec.start_date;
1959: End If;
1960: If (p_rec.category = hr_api.g_varchar2) then
1961: p_rec.category := g_old_rec.category;

Line 1960: If (p_rec.category = hr_api.g_varchar2) then

1956: End If;
1957: If (p_rec.start_date = hr_api.g_date) then
1958: p_rec.start_date := g_old_rec.start_date;
1959: End If;
1960: If (p_rec.category = hr_api.g_varchar2) then
1961: p_rec.category := g_old_rec.category;
1962: End If;
1963: If (p_rec.comments = hr_api.g_varchar2) then
1964: p_rec.comments := g_old_rec.comments;

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

1959: End If;
1960: If (p_rec.category = hr_api.g_varchar2) then
1961: p_rec.category := g_old_rec.category;
1962: End If;
1963: If (p_rec.comments = hr_api.g_varchar2) then
1964: p_rec.comments := g_old_rec.comments;
1965: End If;
1966: If (p_rec.description = hr_api.g_varchar2) then
1967: p_rec.description := g_old_rec.description;

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

1962: End If;
1963: If (p_rec.comments = hr_api.g_varchar2) then
1964: p_rec.comments := g_old_rec.comments;
1965: End If;
1966: If (p_rec.description = hr_api.g_varchar2) then
1967: p_rec.description := g_old_rec.description;
1968: End If;
1969: If (p_rec.discount_percentage = hr_api.g_number) then
1970: p_rec.discount_percentage := g_old_rec.discount_percentage;

Line 1969: If (p_rec.discount_percentage = hr_api.g_number) then

1965: End If;
1966: If (p_rec.description = hr_api.g_varchar2) then
1967: p_rec.description := g_old_rec.description;
1968: End If;
1969: If (p_rec.discount_percentage = hr_api.g_number) then
1970: p_rec.discount_percentage := g_old_rec.discount_percentage;
1971: End If;
1972: If (p_rec.end_date = hr_api.g_date) then
1973: p_rec.end_date := g_old_rec.end_date;

Line 1972: If (p_rec.end_date = hr_api.g_date) then

1968: End If;
1969: If (p_rec.discount_percentage = hr_api.g_number) then
1970: p_rec.discount_percentage := g_old_rec.discount_percentage;
1971: End If;
1972: If (p_rec.end_date = hr_api.g_date) then
1973: p_rec.end_date := g_old_rec.end_date;
1974: End If;
1975: If (p_rec.number_of_places = hr_api.g_number) then
1976: p_rec.number_of_places := g_old_rec.number_of_places;

Line 1975: If (p_rec.number_of_places = hr_api.g_number) then

1971: End If;
1972: If (p_rec.end_date = hr_api.g_date) then
1973: p_rec.end_date := g_old_rec.end_date;
1974: End If;
1975: If (p_rec.number_of_places = hr_api.g_number) then
1976: p_rec.number_of_places := g_old_rec.number_of_places;
1977: End If;
1978: if (P_REC.LIMIT_EACH_EVENT_FLAG = HR_API.G_VARCHAR2) then
1979: P_REC.LIMIT_EACH_EVENT_FLAG := G_OLD_REC.LIMIT_EACH_EVENT_FLAG;

Line 1978: if (P_REC.LIMIT_EACH_EVENT_FLAG = HR_API.G_VARCHAR2) then

1974: End If;
1975: If (p_rec.number_of_places = hr_api.g_number) then
1976: p_rec.number_of_places := g_old_rec.number_of_places;
1977: End If;
1978: if (P_REC.LIMIT_EACH_EVENT_FLAG = HR_API.G_VARCHAR2) then
1979: P_REC.LIMIT_EACH_EVENT_FLAG := G_OLD_REC.LIMIT_EACH_EVENT_FLAG;
1980: end if;
1981: If (p_rec.overdraft_limit = hr_api.g_number) then
1982: p_rec.overdraft_limit := g_old_rec.overdraft_limit;

Line 1981: If (p_rec.overdraft_limit = hr_api.g_number) then

1977: End If;
1978: if (P_REC.LIMIT_EACH_EVENT_FLAG = HR_API.G_VARCHAR2) then
1979: P_REC.LIMIT_EACH_EVENT_FLAG := G_OLD_REC.LIMIT_EACH_EVENT_FLAG;
1980: end if;
1981: If (p_rec.overdraft_limit = hr_api.g_number) then
1982: p_rec.overdraft_limit := g_old_rec.overdraft_limit;
1983: End If;
1984: If (p_rec.type = hr_api.g_varchar2) then
1985: p_rec.type := g_old_rec.type;

Line 1984: If (p_rec.type = hr_api.g_varchar2) then

1980: end if;
1981: If (p_rec.overdraft_limit = hr_api.g_number) then
1982: p_rec.overdraft_limit := g_old_rec.overdraft_limit;
1983: End If;
1984: If (p_rec.type = hr_api.g_varchar2) then
1985: p_rec.type := g_old_rec.type;
1986: End If;
1987: If (p_rec.price_list_id = hr_api.g_number) then
1988: p_rec.price_list_id := g_old_rec.price_list_id;

Line 1987: If (p_rec.price_list_id = hr_api.g_number) then

1983: End If;
1984: If (p_rec.type = hr_api.g_varchar2) then
1985: p_rec.type := g_old_rec.type;
1986: End If;
1987: If (p_rec.price_list_id = hr_api.g_number) then
1988: p_rec.price_list_id := g_old_rec.price_list_id;
1989: End If;
1990: If (p_rec.activity_version_id = hr_api.g_number) then
1991: p_rec.activity_version_id := g_old_rec.activity_version_id;

Line 1990: If (p_rec.activity_version_id = hr_api.g_number) then

1986: End If;
1987: If (p_rec.price_list_id = hr_api.g_number) then
1988: p_rec.price_list_id := g_old_rec.price_list_id;
1989: End If;
1990: If (p_rec.activity_version_id = hr_api.g_number) then
1991: p_rec.activity_version_id := g_old_rec.activity_version_id;
1992: End If;
1993: If (p_rec.event_id = hr_api.g_number) then
1994: p_rec.event_id := g_old_rec.event_id;

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

1989: End If;
1990: If (p_rec.activity_version_id = hr_api.g_number) then
1991: p_rec.activity_version_id := g_old_rec.activity_version_id;
1992: End If;
1993: If (p_rec.event_id = hr_api.g_number) then
1994: p_rec.event_id := g_old_rec.event_id;
1995: End If;
1996: If (p_rec.tbd_information_category = hr_api.g_varchar2) then
1997: p_rec.tbd_information_category := g_old_rec.tbd_information_category;

Line 1996: If (p_rec.tbd_information_category = hr_api.g_varchar2) then

1992: End If;
1993: If (p_rec.event_id = hr_api.g_number) then
1994: p_rec.event_id := g_old_rec.event_id;
1995: End If;
1996: If (p_rec.tbd_information_category = hr_api.g_varchar2) then
1997: p_rec.tbd_information_category := g_old_rec.tbd_information_category;
1998: End If;
1999: If (p_rec.tbd_information1 = hr_api.g_varchar2) then
2000: p_rec.tbd_information1 := g_old_rec.tbd_information1;

Line 1999: If (p_rec.tbd_information1 = hr_api.g_varchar2) then

1995: End If;
1996: If (p_rec.tbd_information_category = hr_api.g_varchar2) then
1997: p_rec.tbd_information_category := g_old_rec.tbd_information_category;
1998: End If;
1999: If (p_rec.tbd_information1 = hr_api.g_varchar2) then
2000: p_rec.tbd_information1 := g_old_rec.tbd_information1;
2001: End If;
2002: If (p_rec.tbd_information2 = hr_api.g_varchar2) then
2003: p_rec.tbd_information2 := g_old_rec.tbd_information2;

Line 2002: If (p_rec.tbd_information2 = hr_api.g_varchar2) then

1998: End If;
1999: If (p_rec.tbd_information1 = hr_api.g_varchar2) then
2000: p_rec.tbd_information1 := g_old_rec.tbd_information1;
2001: End If;
2002: If (p_rec.tbd_information2 = hr_api.g_varchar2) then
2003: p_rec.tbd_information2 := g_old_rec.tbd_information2;
2004: End If;
2005: If (p_rec.tbd_information3 = hr_api.g_varchar2) then
2006: p_rec.tbd_information3 := g_old_rec.tbd_information3;

Line 2005: If (p_rec.tbd_information3 = hr_api.g_varchar2) then

2001: End If;
2002: If (p_rec.tbd_information2 = hr_api.g_varchar2) then
2003: p_rec.tbd_information2 := g_old_rec.tbd_information2;
2004: End If;
2005: If (p_rec.tbd_information3 = hr_api.g_varchar2) then
2006: p_rec.tbd_information3 := g_old_rec.tbd_information3;
2007: End If;
2008: If (p_rec.tbd_information4 = hr_api.g_varchar2) then
2009: p_rec.tbd_information4 := g_old_rec.tbd_information4;

Line 2008: If (p_rec.tbd_information4 = hr_api.g_varchar2) then

2004: End If;
2005: If (p_rec.tbd_information3 = hr_api.g_varchar2) then
2006: p_rec.tbd_information3 := g_old_rec.tbd_information3;
2007: End If;
2008: If (p_rec.tbd_information4 = hr_api.g_varchar2) then
2009: p_rec.tbd_information4 := g_old_rec.tbd_information4;
2010: End If;
2011: If (p_rec.tbd_information5 = hr_api.g_varchar2) then
2012: p_rec.tbd_information5 := g_old_rec.tbd_information5;

Line 2011: If (p_rec.tbd_information5 = hr_api.g_varchar2) then

2007: End If;
2008: If (p_rec.tbd_information4 = hr_api.g_varchar2) then
2009: p_rec.tbd_information4 := g_old_rec.tbd_information4;
2010: End If;
2011: If (p_rec.tbd_information5 = hr_api.g_varchar2) then
2012: p_rec.tbd_information5 := g_old_rec.tbd_information5;
2013: End If;
2014: If (p_rec.tbd_information6 = hr_api.g_varchar2) then
2015: p_rec.tbd_information6 := g_old_rec.tbd_information6;

Line 2014: If (p_rec.tbd_information6 = hr_api.g_varchar2) then

2010: End If;
2011: If (p_rec.tbd_information5 = hr_api.g_varchar2) then
2012: p_rec.tbd_information5 := g_old_rec.tbd_information5;
2013: End If;
2014: If (p_rec.tbd_information6 = hr_api.g_varchar2) then
2015: p_rec.tbd_information6 := g_old_rec.tbd_information6;
2016: End If;
2017: If (p_rec.tbd_information7 = hr_api.g_varchar2) then
2018: p_rec.tbd_information7 := g_old_rec.tbd_information7;

Line 2017: If (p_rec.tbd_information7 = hr_api.g_varchar2) then

2013: End If;
2014: If (p_rec.tbd_information6 = hr_api.g_varchar2) then
2015: p_rec.tbd_information6 := g_old_rec.tbd_information6;
2016: End If;
2017: If (p_rec.tbd_information7 = hr_api.g_varchar2) then
2018: p_rec.tbd_information7 := g_old_rec.tbd_information7;
2019: End If;
2020: If (p_rec.tbd_information8 = hr_api.g_varchar2) then
2021: p_rec.tbd_information8 := g_old_rec.tbd_information8;

Line 2020: If (p_rec.tbd_information8 = hr_api.g_varchar2) then

2016: End If;
2017: If (p_rec.tbd_information7 = hr_api.g_varchar2) then
2018: p_rec.tbd_information7 := g_old_rec.tbd_information7;
2019: End If;
2020: If (p_rec.tbd_information8 = hr_api.g_varchar2) then
2021: p_rec.tbd_information8 := g_old_rec.tbd_information8;
2022: End If;
2023: If (p_rec.tbd_information9 = hr_api.g_varchar2) then
2024: p_rec.tbd_information9 := g_old_rec.tbd_information9;

Line 2023: If (p_rec.tbd_information9 = hr_api.g_varchar2) then

2019: End If;
2020: If (p_rec.tbd_information8 = hr_api.g_varchar2) then
2021: p_rec.tbd_information8 := g_old_rec.tbd_information8;
2022: End If;
2023: If (p_rec.tbd_information9 = hr_api.g_varchar2) then
2024: p_rec.tbd_information9 := g_old_rec.tbd_information9;
2025: End If;
2026: If (p_rec.tbd_information10 = hr_api.g_varchar2) then
2027: p_rec.tbd_information10 := g_old_rec.tbd_information10;

Line 2026: If (p_rec.tbd_information10 = hr_api.g_varchar2) then

2022: End If;
2023: If (p_rec.tbd_information9 = hr_api.g_varchar2) then
2024: p_rec.tbd_information9 := g_old_rec.tbd_information9;
2025: End If;
2026: If (p_rec.tbd_information10 = hr_api.g_varchar2) then
2027: p_rec.tbd_information10 := g_old_rec.tbd_information10;
2028: End If;
2029: If (p_rec.tbd_information11 = hr_api.g_varchar2) then
2030: p_rec.tbd_information11 := g_old_rec.tbd_information11;

Line 2029: If (p_rec.tbd_information11 = hr_api.g_varchar2) then

2025: End If;
2026: If (p_rec.tbd_information10 = hr_api.g_varchar2) then
2027: p_rec.tbd_information10 := g_old_rec.tbd_information10;
2028: End If;
2029: If (p_rec.tbd_information11 = hr_api.g_varchar2) then
2030: p_rec.tbd_information11 := g_old_rec.tbd_information11;
2031: End If;
2032: If (p_rec.tbd_information12 = hr_api.g_varchar2) then
2033: p_rec.tbd_information12 := g_old_rec.tbd_information12;

Line 2032: If (p_rec.tbd_information12 = hr_api.g_varchar2) then

2028: End If;
2029: If (p_rec.tbd_information11 = hr_api.g_varchar2) then
2030: p_rec.tbd_information11 := g_old_rec.tbd_information11;
2031: End If;
2032: If (p_rec.tbd_information12 = hr_api.g_varchar2) then
2033: p_rec.tbd_information12 := g_old_rec.tbd_information12;
2034: End If;
2035: If (p_rec.tbd_information13 = hr_api.g_varchar2) then
2036: p_rec.tbd_information13 := g_old_rec.tbd_information13;

Line 2035: If (p_rec.tbd_information13 = hr_api.g_varchar2) then

2031: End If;
2032: If (p_rec.tbd_information12 = hr_api.g_varchar2) then
2033: p_rec.tbd_information12 := g_old_rec.tbd_information12;
2034: End If;
2035: If (p_rec.tbd_information13 = hr_api.g_varchar2) then
2036: p_rec.tbd_information13 := g_old_rec.tbd_information13;
2037: End If;
2038: If (p_rec.tbd_information14 = hr_api.g_varchar2) then
2039: p_rec.tbd_information14 := g_old_rec.tbd_information14;

Line 2038: If (p_rec.tbd_information14 = hr_api.g_varchar2) then

2034: End If;
2035: If (p_rec.tbd_information13 = hr_api.g_varchar2) then
2036: p_rec.tbd_information13 := g_old_rec.tbd_information13;
2037: End If;
2038: If (p_rec.tbd_information14 = hr_api.g_varchar2) then
2039: p_rec.tbd_information14 := g_old_rec.tbd_information14;
2040: End If;
2041: If (p_rec.tbd_information15 = hr_api.g_varchar2) then
2042: p_rec.tbd_information15 := g_old_rec.tbd_information15;

Line 2041: If (p_rec.tbd_information15 = hr_api.g_varchar2) then

2037: End If;
2038: If (p_rec.tbd_information14 = hr_api.g_varchar2) then
2039: p_rec.tbd_information14 := g_old_rec.tbd_information14;
2040: End If;
2041: If (p_rec.tbd_information15 = hr_api.g_varchar2) then
2042: p_rec.tbd_information15 := g_old_rec.tbd_information15;
2043: End If;
2044: If (p_rec.tbd_information16 = hr_api.g_varchar2) then
2045: p_rec.tbd_information16 := g_old_rec.tbd_information16;

Line 2044: If (p_rec.tbd_information16 = hr_api.g_varchar2) then

2040: End If;
2041: If (p_rec.tbd_information15 = hr_api.g_varchar2) then
2042: p_rec.tbd_information15 := g_old_rec.tbd_information15;
2043: End If;
2044: If (p_rec.tbd_information16 = hr_api.g_varchar2) then
2045: p_rec.tbd_information16 := g_old_rec.tbd_information16;
2046: End If;
2047: If (p_rec.tbd_information17 = hr_api.g_varchar2) then
2048: p_rec.tbd_information17 := g_old_rec.tbd_information17;

Line 2047: If (p_rec.tbd_information17 = hr_api.g_varchar2) then

2043: End If;
2044: If (p_rec.tbd_information16 = hr_api.g_varchar2) then
2045: p_rec.tbd_information16 := g_old_rec.tbd_information16;
2046: End If;
2047: If (p_rec.tbd_information17 = hr_api.g_varchar2) then
2048: p_rec.tbd_information17 := g_old_rec.tbd_information17;
2049: End If;
2050: If (p_rec.tbd_information18 = hr_api.g_varchar2) then
2051: p_rec.tbd_information18 := g_old_rec.tbd_information18;

Line 2050: If (p_rec.tbd_information18 = hr_api.g_varchar2) then

2046: End If;
2047: If (p_rec.tbd_information17 = hr_api.g_varchar2) then
2048: p_rec.tbd_information17 := g_old_rec.tbd_information17;
2049: End If;
2050: If (p_rec.tbd_information18 = hr_api.g_varchar2) then
2051: p_rec.tbd_information18 := g_old_rec.tbd_information18;
2052: End If;
2053: If (p_rec.tbd_information19 = hr_api.g_varchar2) then
2054: p_rec.tbd_information19 := g_old_rec.tbd_information19;

Line 2053: If (p_rec.tbd_information19 = hr_api.g_varchar2) then

2049: End If;
2050: If (p_rec.tbd_information18 = hr_api.g_varchar2) then
2051: p_rec.tbd_information18 := g_old_rec.tbd_information18;
2052: End If;
2053: If (p_rec.tbd_information19 = hr_api.g_varchar2) then
2054: p_rec.tbd_information19 := g_old_rec.tbd_information19;
2055: End If;
2056: If (p_rec.tbd_information20 = hr_api.g_varchar2) then
2057: p_rec.tbd_information20 := g_old_rec.tbd_information20;

Line 2056: If (p_rec.tbd_information20 = hr_api.g_varchar2) then

2052: End If;
2053: If (p_rec.tbd_information19 = hr_api.g_varchar2) then
2054: p_rec.tbd_information19 := g_old_rec.tbd_information19;
2055: End If;
2056: If (p_rec.tbd_information20 = hr_api.g_varchar2) then
2057: p_rec.tbd_information20 := g_old_rec.tbd_information20;
2058: End If;
2059: --
2060: -- Return the plsql record structure.

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

2104: --
2105: VALIDITY_CHECK (
2106: P_REC => P_REC);
2107: --
2108: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2109: --
2110: hr_utility.set_location(' Leaving:'||l_proc, 10);
2111: End insert_validate;
2112: --

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

2147: hr_utility.set_location('Entering:'||l_proc, 5);
2148: --
2149: -- Call all supporting business operations
2150: --
2151: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2152: --
2153: if ( (TFL_LINES (P_REC.BOOKING_DEAL_ID))
2154: and ( (P_REC.PRICE_LIST_ID <> G_OLD_REC.PRICE_LIST_ID )
2155: or (P_REC.EVENT_ID <> G_OLD_REC.EVENT_ID )

Line 2266: Raise HR_Api.Validate_Enabled;

2262: --
2263: -- If we are validating then raise the Validate_Enabled exception
2264: --
2265: If p_validate then
2266: Raise HR_Api.Validate_Enabled;
2267: End If;
2268: --
2269: hr_utility.set_location(' Leaving:'||l_proc, 10);
2270: Exception

Line 2271: When HR_Api.Validate_Enabled Then

2267: End If;
2268: --
2269: hr_utility.set_location(' Leaving:'||l_proc, 10);
2270: Exception
2271: When HR_Api.Validate_Enabled Then
2272: --
2273: -- As the Validate_Enabled exception has been raised
2274: -- we must rollback to the savepoint
2275: --

Line 2449: Raise HR_Api.Validate_Enabled;

2445: --
2446: -- If we are validating then raise the Validate_Enabled exception
2447: --
2448: If p_validate then
2449: Raise HR_Api.Validate_Enabled;
2450: End If;
2451: --
2452: hr_utility.set_location(' Leaving:'||l_proc, 10);
2453: Exception

Line 2454: When HR_Api.Validate_Enabled Then

2450: End If;
2451: --
2452: hr_utility.set_location(' Leaving:'||l_proc, 10);
2453: Exception
2454: When HR_Api.Validate_Enabled Then
2455: --
2456: -- As the Validate_Enabled exception has been raised
2457: -- we must rollback to the savepoint
2458: --

Line 2468: p_customer_id in number default hr_api.g_number,

2464: -- ----------------------------------------------------------------------------
2465: Procedure upd
2466: (
2467: p_booking_deal_id in number,
2468: p_customer_id in number default hr_api.g_number,
2469: p_approved_by_person_id in number default hr_api.g_number,
2470: p_business_group_id in number default hr_api.g_number,
2471: p_name in varchar2 default hr_api.g_varchar2,
2472: p_object_version_number in out nocopy number,

Line 2469: p_approved_by_person_id in number default hr_api.g_number,

2465: Procedure upd
2466: (
2467: p_booking_deal_id in number,
2468: p_customer_id in number default hr_api.g_number,
2469: p_approved_by_person_id in number default hr_api.g_number,
2470: p_business_group_id in number default hr_api.g_number,
2471: p_name in varchar2 default hr_api.g_varchar2,
2472: p_object_version_number in out nocopy number,
2473: p_start_date in date default hr_api.g_date,

Line 2470: p_business_group_id in number default hr_api.g_number,

2466: (
2467: p_booking_deal_id in number,
2468: p_customer_id in number default hr_api.g_number,
2469: p_approved_by_person_id in number default hr_api.g_number,
2470: p_business_group_id in number default hr_api.g_number,
2471: p_name in varchar2 default hr_api.g_varchar2,
2472: p_object_version_number in out nocopy number,
2473: p_start_date in date default hr_api.g_date,
2474: p_category in varchar2 default hr_api.g_varchar2,

Line 2471: p_name in varchar2 default hr_api.g_varchar2,

2467: p_booking_deal_id in number,
2468: p_customer_id in number default hr_api.g_number,
2469: p_approved_by_person_id in number default hr_api.g_number,
2470: p_business_group_id in number default hr_api.g_number,
2471: p_name in varchar2 default hr_api.g_varchar2,
2472: p_object_version_number in out nocopy number,
2473: p_start_date in date default hr_api.g_date,
2474: p_category in varchar2 default hr_api.g_varchar2,
2475: p_comments in varchar2 default hr_api.g_varchar2,

Line 2473: p_start_date in date default hr_api.g_date,

2469: p_approved_by_person_id in number default hr_api.g_number,
2470: p_business_group_id in number default hr_api.g_number,
2471: p_name in varchar2 default hr_api.g_varchar2,
2472: p_object_version_number in out nocopy number,
2473: p_start_date in date default hr_api.g_date,
2474: p_category in varchar2 default hr_api.g_varchar2,
2475: p_comments in varchar2 default hr_api.g_varchar2,
2476: p_description in varchar2 default hr_api.g_varchar2,
2477: p_discount_percentage in number default hr_api.g_number,

Line 2474: p_category in varchar2 default hr_api.g_varchar2,

2470: p_business_group_id in number default hr_api.g_number,
2471: p_name in varchar2 default hr_api.g_varchar2,
2472: p_object_version_number in out nocopy number,
2473: p_start_date in date default hr_api.g_date,
2474: p_category in varchar2 default hr_api.g_varchar2,
2475: p_comments in varchar2 default hr_api.g_varchar2,
2476: p_description in varchar2 default hr_api.g_varchar2,
2477: p_discount_percentage in number default hr_api.g_number,
2478: p_end_date in date default hr_api.g_date,

Line 2475: p_comments in varchar2 default hr_api.g_varchar2,

2471: p_name in varchar2 default hr_api.g_varchar2,
2472: p_object_version_number in out nocopy number,
2473: p_start_date in date default hr_api.g_date,
2474: p_category in varchar2 default hr_api.g_varchar2,
2475: p_comments in varchar2 default hr_api.g_varchar2,
2476: p_description in varchar2 default hr_api.g_varchar2,
2477: p_discount_percentage in number default hr_api.g_number,
2478: p_end_date in date default hr_api.g_date,
2479: p_number_of_places in number default hr_api.g_number,

Line 2476: p_description in varchar2 default hr_api.g_varchar2,

2472: p_object_version_number in out nocopy number,
2473: p_start_date in date default hr_api.g_date,
2474: p_category in varchar2 default hr_api.g_varchar2,
2475: p_comments in varchar2 default hr_api.g_varchar2,
2476: p_description in varchar2 default hr_api.g_varchar2,
2477: p_discount_percentage in number default hr_api.g_number,
2478: p_end_date in date default hr_api.g_date,
2479: p_number_of_places in number default hr_api.g_number,
2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,

Line 2477: p_discount_percentage in number default hr_api.g_number,

2473: p_start_date in date default hr_api.g_date,
2474: p_category in varchar2 default hr_api.g_varchar2,
2475: p_comments in varchar2 default hr_api.g_varchar2,
2476: p_description in varchar2 default hr_api.g_varchar2,
2477: p_discount_percentage in number default hr_api.g_number,
2478: p_end_date in date default hr_api.g_date,
2479: p_number_of_places in number default hr_api.g_number,
2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,
2481: p_overdraft_limit in number default hr_api.g_number,

Line 2478: p_end_date in date default hr_api.g_date,

2474: p_category in varchar2 default hr_api.g_varchar2,
2475: p_comments in varchar2 default hr_api.g_varchar2,
2476: p_description in varchar2 default hr_api.g_varchar2,
2477: p_discount_percentage in number default hr_api.g_number,
2478: p_end_date in date default hr_api.g_date,
2479: p_number_of_places in number default hr_api.g_number,
2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,
2481: p_overdraft_limit in number default hr_api.g_number,
2482: p_type in varchar2 default hr_api.g_varchar2,

Line 2479: p_number_of_places in number default hr_api.g_number,

2475: p_comments in varchar2 default hr_api.g_varchar2,
2476: p_description in varchar2 default hr_api.g_varchar2,
2477: p_discount_percentage in number default hr_api.g_number,
2478: p_end_date in date default hr_api.g_date,
2479: p_number_of_places in number default hr_api.g_number,
2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,
2481: p_overdraft_limit in number default hr_api.g_number,
2482: p_type in varchar2 default hr_api.g_varchar2,
2483: p_price_list_id in number default hr_api.g_number,

Line 2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,

2476: p_description in varchar2 default hr_api.g_varchar2,
2477: p_discount_percentage in number default hr_api.g_number,
2478: p_end_date in date default hr_api.g_date,
2479: p_number_of_places in number default hr_api.g_number,
2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,
2481: p_overdraft_limit in number default hr_api.g_number,
2482: p_type in varchar2 default hr_api.g_varchar2,
2483: p_price_list_id in number default hr_api.g_number,
2484: p_activity_version_id in number default hr_api.g_number,

Line 2481: p_overdraft_limit in number default hr_api.g_number,

2477: p_discount_percentage in number default hr_api.g_number,
2478: p_end_date in date default hr_api.g_date,
2479: p_number_of_places in number default hr_api.g_number,
2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,
2481: p_overdraft_limit in number default hr_api.g_number,
2482: p_type in varchar2 default hr_api.g_varchar2,
2483: p_price_list_id in number default hr_api.g_number,
2484: p_activity_version_id in number default hr_api.g_number,
2485: p_event_id in number default hr_api.g_number,

Line 2482: p_type in varchar2 default hr_api.g_varchar2,

2478: p_end_date in date default hr_api.g_date,
2479: p_number_of_places in number default hr_api.g_number,
2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,
2481: p_overdraft_limit in number default hr_api.g_number,
2482: p_type in varchar2 default hr_api.g_varchar2,
2483: p_price_list_id in number default hr_api.g_number,
2484: p_activity_version_id in number default hr_api.g_number,
2485: p_event_id in number default hr_api.g_number,
2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,

Line 2483: p_price_list_id in number default hr_api.g_number,

2479: p_number_of_places in number default hr_api.g_number,
2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,
2481: p_overdraft_limit in number default hr_api.g_number,
2482: p_type in varchar2 default hr_api.g_varchar2,
2483: p_price_list_id in number default hr_api.g_number,
2484: p_activity_version_id in number default hr_api.g_number,
2485: p_event_id in number default hr_api.g_number,
2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,

Line 2484: p_activity_version_id in number default hr_api.g_number,

2480: P_LIMIT_EACH_EVENT_FLAG in varchar2 default HR_API.G_VARCHAR2,
2481: p_overdraft_limit in number default hr_api.g_number,
2482: p_type in varchar2 default hr_api.g_varchar2,
2483: p_price_list_id in number default hr_api.g_number,
2484: p_activity_version_id in number default hr_api.g_number,
2485: p_event_id in number default hr_api.g_number,
2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,

Line 2485: p_event_id in number default hr_api.g_number,

2481: p_overdraft_limit in number default hr_api.g_number,
2482: p_type in varchar2 default hr_api.g_varchar2,
2483: p_price_list_id in number default hr_api.g_number,
2484: p_activity_version_id in number default hr_api.g_number,
2485: p_event_id in number default hr_api.g_number,
2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,

Line 2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,

2482: p_type in varchar2 default hr_api.g_varchar2,
2483: p_price_list_id in number default hr_api.g_number,
2484: p_activity_version_id in number default hr_api.g_number,
2485: p_event_id in number default hr_api.g_number,
2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,

Line 2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,

2483: p_price_list_id in number default hr_api.g_number,
2484: p_activity_version_id in number default hr_api.g_number,
2485: p_event_id in number default hr_api.g_number,
2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,

Line 2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,

2484: p_activity_version_id in number default hr_api.g_number,
2485: p_event_id in number default hr_api.g_number,
2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,

Line 2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,

2485: p_event_id in number default hr_api.g_number,
2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,

Line 2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,

2486: p_tbd_information_category in varchar2 default hr_api.g_varchar2,
2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,

Line 2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,

2487: p_tbd_information1 in varchar2 default hr_api.g_varchar2,
2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,

Line 2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,

2488: p_tbd_information2 in varchar2 default hr_api.g_varchar2,
2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,

Line 2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,

2489: p_tbd_information3 in varchar2 default hr_api.g_varchar2,
2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,

Line 2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,

2490: p_tbd_information4 in varchar2 default hr_api.g_varchar2,
2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,

Line 2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,

2491: p_tbd_information5 in varchar2 default hr_api.g_varchar2,
2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,

Line 2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,

2492: p_tbd_information6 in varchar2 default hr_api.g_varchar2,
2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,

Line 2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,

2493: p_tbd_information7 in varchar2 default hr_api.g_varchar2,
2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,

Line 2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,

2494: p_tbd_information8 in varchar2 default hr_api.g_varchar2,
2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,

Line 2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,

2495: p_tbd_information9 in varchar2 default hr_api.g_varchar2,
2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
2503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,

Line 2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,

2496: p_tbd_information10 in varchar2 default hr_api.g_varchar2,
2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
2503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
2504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,

Line 2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,

2497: p_tbd_information11 in varchar2 default hr_api.g_varchar2,
2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
2503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
2504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
2505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,

Line 2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,

2498: p_tbd_information12 in varchar2 default hr_api.g_varchar2,
2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
2503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
2504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
2505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
2506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,

Line 2503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,

2499: p_tbd_information13 in varchar2 default hr_api.g_varchar2,
2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
2503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
2504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
2505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
2506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,
2507: p_validate in boolean default false

Line 2504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,

2500: p_tbd_information14 in varchar2 default hr_api.g_varchar2,
2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
2503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
2504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
2505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
2506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,
2507: p_validate in boolean default false
2508: ) is

Line 2505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,

2501: p_tbd_information15 in varchar2 default hr_api.g_varchar2,
2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
2503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
2504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
2505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
2506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,
2507: p_validate in boolean default false
2508: ) is
2509: --

Line 2506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,

2502: p_tbd_information16 in varchar2 default hr_api.g_varchar2,
2503: p_tbd_information17 in varchar2 default hr_api.g_varchar2,
2504: p_tbd_information18 in varchar2 default hr_api.g_varchar2,
2505: p_tbd_information19 in varchar2 default hr_api.g_varchar2,
2506: p_tbd_information20 in varchar2 default hr_api.g_varchar2,
2507: p_validate in boolean default false
2508: ) is
2509: --
2510: l_rec g_rec_type;

Line 2624: Raise HR_Api.Validate_Enabled;

2620: --
2621: -- If we are validating then raise the Validate_Enabled exception
2622: --
2623: If p_validate then
2624: Raise HR_Api.Validate_Enabled;
2625: End If;
2626: --
2627: hr_utility.set_location(' Leaving:'||l_proc, 10);
2628: Exception

Line 2629: When HR_Api.Validate_Enabled Then

2625: End If;
2626: --
2627: hr_utility.set_location(' Leaving:'||l_proc, 10);
2628: Exception
2629: When HR_Api.Validate_Enabled Then
2630: --
2631: -- As the Validate_Enabled exception has been raised
2632: -- we must rollback to the savepoint
2633: --