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

Line 406: Elsif nvl( v_sup_end_date, hr_api.g_eot)

402: call_error_message( p_error_appl => 'OTA'
403: , p_error_txt => 'OTA_13293_TAV_NO_SUP'
404: );
405: --
406: Elsif nvl( v_sup_end_date, hr_api.g_eot)
407: < nvl( p_end_date, hr_general.end_of_time) Then
408: --
409: Close sel_version;
410: --

Line 946: v_end_date := hr_api.g_eot;

942: End if;
943: --
944: If v_end_date is null Then
945: --
946: v_end_date := hr_api.g_eot;
947: --
948: End if;
949: --
950: If ota_general.check_par_child_dates_fun( p_start_date

Line 1001: nvl(ctu.end_date_active, hr_api.g_eot)

997:
998: CURSOR cur_cat_start_end_date is
999: select
1000: ctu.start_date_active,
1001: nvl(ctu.end_date_active, hr_api.g_eot)
1002: from
1003: ota_category_usages ctu,
1004: ota_act_cat_inclusions aci
1005: where

Line 1032: or l_cat_end_date < nvl(p_end_date, hr_api.g_eot)

1028:
1029: IF cur_cat_start_end_date%FOUND THEN
1030: CLOSE cur_cat_start_end_date;
1031: IF ( l_cat_start_date > p_start_date
1032: or l_cat_end_date < nvl(p_end_date, hr_api.g_eot)
1033: ) THEN
1034: --
1035: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');
1036: fnd_message.raise_error;

Line 1629: If NOT ota_general.check_person( p_person_id, nvl(p_date,hr_api.g_sot)) Then

1625: hr_utility.set_location('Entering:'|| v_proc, 5);
1626: --
1627: If p_person_id is not null Then
1628: --
1629: If NOT ota_general.check_person( p_person_id, nvl(p_date,hr_api.g_sot)) Then
1630: --
1631: -- ** TEMP ** Add error message with the following text.
1632: --
1633: call_error_message( p_error_appl => 'OTA'

Line 1677: and v_end_date >= nvl(tav.start_date,hr_api.g_sot);

1673: and p_activity_version_id is not null )
1674: or p_activity_version_id is null)
1675: and v_start_date <= nvl(tav.end_date,
1676: greatest(v_default_end_date,tav.start_date))
1677: and v_end_date >= nvl(tav.start_date,hr_api.g_sot);
1678: --
1679: Begin
1680: --
1681: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 1684: v_start_date := hr_api.g_sot;

1680: --
1681: hr_utility.set_location('Entering:'|| v_proc, 5);
1682: --
1683: if p_start_date is null then
1684: v_start_date := hr_api.g_sot;
1685: else
1686: v_start_date := p_start_date;
1687: end if;
1688: --

Line 1690: v_end_date := hr_api.g_eot;

1686: v_start_date := p_start_date;
1687: end if;
1688: --
1689: if p_end_date is null then
1690: v_end_date := hr_api.g_eot;
1691: else
1692: v_end_date := p_end_date;
1693: end if;
1694: --

Line 1703: v_default_end_date := hr_api.g_eot;

1699: -- When updating the default end date should be the end of time
1700: --
1701: if p_activity_version_id is null then
1702: if p_start_date is null then
1703: v_default_end_date := hr_api.g_eot;
1704: else
1705: v_default_end_date := p_start_date - 1;
1706: end if;
1707: else

Line 1708: v_default_end_date := hr_api.g_eot;

1704: else
1705: v_default_end_date := p_start_date - 1;
1706: end if;
1707: else
1708: v_default_end_date := hr_api.g_eot;
1709: end if;
1710: --
1711: hr_utility.trace(to_char(v_start_date));
1712: hr_utility.trace(to_char(v_end_date));

Line 1854: v_end_date := hr_api.g_date;

1850: --
1851: -- If the end date is not null then we do not want to update it
1852: --
1853: if v_end_date is not null then
1854: v_end_date := hr_api.g_date;
1855: else
1856: v_end_date := p_start_date - 1;
1857: end if;
1858: --

Line 1951: and nvl(tav.end_date, hr_api.g_eot) =

1947: , ota_activity_versions tav
1948: where tad.activity_id = p_activity_id
1949: and tad.multiple_con_versions_flag = 'N'
1950: and tav.activity_id = tad.activity_id
1951: and nvl(tav.end_date, hr_api.g_eot) =
1952: (select max( nvl(tav2.end_date, hr_api.g_eot))
1953: from ota_activity_versions tav2
1954: where tav2.activity_id = p_activity_id);
1955: --

Line 1952: (select max( nvl(tav2.end_date, hr_api.g_eot))

1948: where tad.activity_id = p_activity_id
1949: and tad.multiple_con_versions_flag = 'N'
1950: and tav.activity_id = tad.activity_id
1951: and nvl(tav.end_date, hr_api.g_eot) =
1952: (select max( nvl(tav2.end_date, hr_api.g_eot))
1953: from ota_activity_versions tav2
1954: where tav2.activity_id = p_activity_id);
1955: --
1956: cursor sel_superseded_act( pc_activity_version_id IN number) is

Line 2053: nvl(l_old_inventory_item_id,hr_api.g_number) <>

2049: FETCH csr_old_inventory into l_old_inventory_item_id,
2050: l_old_organization_id;
2051: CLOSE csr_old_inventory;
2052: if ((p_activity_version_id is not null) and
2053: nvl(l_old_inventory_item_id,hr_api.g_number) <>
2054: nvl(p_inventory_item_id,hr_api.g_number)) then
2055: --
2056: hr_utility.set_location('Entering:'||l_proc, 10);
2057:

Line 2054: nvl(p_inventory_item_id,hr_api.g_number)) then

2050: l_old_organization_id;
2051: CLOSE csr_old_inventory;
2052: if ((p_activity_version_id is not null) and
2053: nvl(l_old_inventory_item_id,hr_api.g_number) <>
2054: nvl(p_inventory_item_id,hr_api.g_number)) then
2055: --
2056: hr_utility.set_location('Entering:'||l_proc, 10);
2057:
2058: --

Line 2167: (nvl(l_old_inventory_item_id ,hr_api.g_number) <>

2163: CLOSE csr_old_inventory;
2164: END IF;
2165:
2166: if (((p_activity_version_id is not null) and
2167: (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2168: nvl(p_inventory_item_id,hr_api.g_number)or
2169: nvl(l_old_organization_id,hr_api.g_number) <>
2170: nvl(p_organization_id,hr_api.g_number)))
2171: or (p_activity_version_id is null)) then

Line 2168: nvl(p_inventory_item_id,hr_api.g_number)or

2164: END IF;
2165:
2166: if (((p_activity_version_id is not null) and
2167: (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2168: nvl(p_inventory_item_id,hr_api.g_number)or
2169: nvl(l_old_organization_id,hr_api.g_number) <>
2170: nvl(p_organization_id,hr_api.g_number)))
2171: or (p_activity_version_id is null)) then
2172: --

Line 2169: nvl(l_old_organization_id,hr_api.g_number) <>

2165:
2166: if (((p_activity_version_id is not null) and
2167: (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2168: nvl(p_inventory_item_id,hr_api.g_number)or
2169: nvl(l_old_organization_id,hr_api.g_number) <>
2170: nvl(p_organization_id,hr_api.g_number)))
2171: or (p_activity_version_id is null)) then
2172: --
2173: hr_utility.set_location('Entering:'||l_proc, 10);

Line 2170: nvl(p_organization_id,hr_api.g_number)))

2166: if (((p_activity_version_id is not null) and
2167: (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2168: nvl(p_inventory_item_id,hr_api.g_number)or
2169: nvl(l_old_organization_id,hr_api.g_number) <>
2170: nvl(p_organization_id,hr_api.g_number)))
2171: or (p_activity_version_id is null)) then
2172: --
2173: hr_utility.set_location('Entering:'||l_proc, 10);
2174:

Line 2202: and (nvl(l_old_inventory_item_id ,hr_api.g_number) <>

2198: end if;
2199:
2200: if ( p_activity_version_id is not null
2201: and p_inventory_item_id is not null
2202: and (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2203: nvl(p_inventory_item_id,hr_api.g_number))) then
2204:
2205: open cur_offerings;
2206: fetch cur_offerings

Line 2203: nvl(p_inventory_item_id,hr_api.g_number))) then

2199:
2200: if ( p_activity_version_id is not null
2201: and p_inventory_item_id is not null
2202: and (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2203: nvl(p_inventory_item_id,hr_api.g_number))) then
2204:
2205: open cur_offerings;
2206: fetch cur_offerings
2207: into l_num;

Line 2274: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>

2270:
2271: hr_utility.set_location('Entering:'||l_proc, 5);
2272:
2273: if (((p_activity_version_id is not null) and
2274: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>
2275: nvl(p_rco_id,hr_api.g_number))
2276: or (p_activity_version_id is null)) then
2277: --
2278: hr_utility.set_location('Entering:'||l_proc, 10);

Line 2275: nvl(p_rco_id,hr_api.g_number))

2271: hr_utility.set_location('Entering:'||l_proc, 5);
2272:
2273: if (((p_activity_version_id is not null) and
2274: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>
2275: nvl(p_rco_id,hr_api.g_number))
2276: or (p_activity_version_id is null)) then
2277: --
2278: hr_utility.set_location('Entering:'||l_proc, 10);
2279: if (p_rco_id is not null) then

Line 2348: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>

2344: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2346: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2347:
2348: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2349: NVL( p_start_date, hr_api.g_date )) THEN
2350: l_upd_start_date := TRUE;
2351: l_start_date := p_start_date;
2352: ELSE

Line 2349: NVL( p_start_date, hr_api.g_date )) THEN

2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2346: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2347:
2348: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2349: NVL( p_start_date, hr_api.g_date )) THEN
2350: l_upd_start_date := TRUE;
2351: l_start_date := p_start_date;
2352: ELSE
2353: l_upd_start_date := FALSE;

Line 2357: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>

2353: l_upd_start_date := FALSE;
2354: l_start_date := ota_tav_shd.g_old_rec.start_date;
2355: END IF;
2356:
2357: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2358: NVL( p_end_date, hr_api.g_date )) THEN
2359: l_upd_end_date := TRUE;
2360: l_end_date := p_end_date;
2361: ELSE

Line 2358: NVL( p_end_date, hr_api.g_date )) THEN

2354: l_start_date := ota_tav_shd.g_old_rec.start_date;
2355: END IF;
2356:
2357: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2358: NVL( p_end_date, hr_api.g_date )) THEN
2359: l_upd_end_date := TRUE;
2360: l_end_date := p_end_date;
2361: ELSE
2362: l_upd_end_date := FALSE;

Line 2537: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>

2533: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2535: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2536:
2537: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2538: NVL( p_start_date, hr_api.g_date )) THEN
2539: l_upd_start_date := TRUE;
2540: l_start_date := p_start_date;
2541: ELSE

Line 2538: NVL( p_start_date, hr_api.g_date )) THEN

2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2535: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2536:
2537: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2538: NVL( p_start_date, hr_api.g_date )) THEN
2539: l_upd_start_date := TRUE;
2540: l_start_date := p_start_date;
2541: ELSE
2542: l_upd_start_date := FALSE;

Line 2546: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>

2542: l_upd_start_date := FALSE;
2543: l_start_date := ota_tav_shd.g_old_rec.start_date;
2544: END IF;
2545:
2546: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2547: NVL( p_end_date, hr_api.g_date )) THEN
2548: l_upd_end_date := TRUE;
2549: l_end_date := p_end_date;
2550: ELSE

Line 2547: NVL( p_end_date, hr_api.g_date )) THEN

2543: l_start_date := ota_tav_shd.g_old_rec.start_date;
2544: END IF;
2545:
2546: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2547: NVL( p_end_date, hr_api.g_date )) THEN
2548: l_upd_end_date := TRUE;
2549: l_end_date := p_end_date;
2550: ELSE
2551: l_upd_end_date := FALSE;