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 942: v_end_date := hr_api.g_eot;

938: End if;
939: --
940: If v_end_date is null Then
941: --
942: v_end_date := hr_api.g_eot;
943: --
944: End if;
945: --
946: If ota_general.check_par_child_dates_fun( p_start_date

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

991:
992: CURSOR cur_cat_start_end_date is
993: select
994: ctu.start_date_active,
995: nvl(ctu.end_date_active, hr_api.g_eot)
996: from
997: ota_category_usages ctu,
998: ota_act_cat_inclusions aci
999: where

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

1022:
1023: IF cur_cat_start_end_date%FOUND THEN
1024: CLOSE cur_cat_start_end_date;
1025: IF ( l_cat_start_date > p_start_date
1026: or l_cat_end_date < nvl(p_end_date, hr_api.g_eot)
1027: ) THEN
1028: --
1029: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');
1030: fnd_message.raise_error;

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

1619: hr_utility.set_location('Entering:'|| v_proc, 5);
1620: --
1621: If p_person_id is not null Then
1622: --
1623: If NOT ota_general.check_person( p_person_id, nvl(p_date,hr_api.g_sot)) Then
1624: --
1625: -- ** TEMP ** Add error message with the following text.
1626: --
1627: call_error_message( p_error_appl => 'OTA'

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

1667: and p_activity_version_id is not null )
1668: or p_activity_version_id is null)
1669: and v_start_date <= nvl(tav.end_date,
1670: greatest(v_default_end_date,tav.start_date))
1671: and v_end_date >= nvl(tav.start_date,hr_api.g_sot);
1672: --
1673: Begin
1674: --
1675: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 1678: v_start_date := hr_api.g_sot;

1674: --
1675: hr_utility.set_location('Entering:'|| v_proc, 5);
1676: --
1677: if p_start_date is null then
1678: v_start_date := hr_api.g_sot;
1679: else
1680: v_start_date := p_start_date;
1681: end if;
1682: --

Line 1684: v_end_date := hr_api.g_eot;

1680: v_start_date := p_start_date;
1681: end if;
1682: --
1683: if p_end_date is null then
1684: v_end_date := hr_api.g_eot;
1685: else
1686: v_end_date := p_end_date;
1687: end if;
1688: --

Line 1697: v_default_end_date := hr_api.g_eot;

1693: -- When updating the default end date should be the end of time
1694: --
1695: if p_activity_version_id is null then
1696: if p_start_date is null then
1697: v_default_end_date := hr_api.g_eot;
1698: else
1699: v_default_end_date := p_start_date - 1;
1700: end if;
1701: else

Line 1702: v_default_end_date := hr_api.g_eot;

1698: else
1699: v_default_end_date := p_start_date - 1;
1700: end if;
1701: else
1702: v_default_end_date := hr_api.g_eot;
1703: end if;
1704: --
1705: hr_utility.trace(to_char(v_start_date));
1706: hr_utility.trace(to_char(v_end_date));

Line 1848: v_end_date := hr_api.g_date;

1844: --
1845: -- If the end date is not null then we do not want to update it
1846: --
1847: if v_end_date is not null then
1848: v_end_date := hr_api.g_date;
1849: else
1850: v_end_date := p_start_date - 1;
1851: end if;
1852: --

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

1941: , ota_activity_versions tav
1942: where tad.activity_id = p_activity_id
1943: and tad.multiple_con_versions_flag = 'N'
1944: and tav.activity_id = tad.activity_id
1945: and nvl(tav.end_date, hr_api.g_eot) =
1946: (select max( nvl(tav2.end_date, hr_api.g_eot))
1947: from ota_activity_versions tav2
1948: where tav2.activity_id = p_activity_id);
1949: --

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

1942: where tad.activity_id = p_activity_id
1943: and tad.multiple_con_versions_flag = 'N'
1944: and tav.activity_id = tad.activity_id
1945: and nvl(tav.end_date, hr_api.g_eot) =
1946: (select max( nvl(tav2.end_date, hr_api.g_eot))
1947: from ota_activity_versions tav2
1948: where tav2.activity_id = p_activity_id);
1949: --
1950: cursor sel_superseded_act( pc_activity_version_id IN number) is

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

2043: FETCH csr_old_inventory into l_old_inventory_item_id,
2044: l_old_organization_id;
2045: CLOSE csr_old_inventory;
2046: if ((p_activity_version_id is not null) and
2047: nvl(l_old_inventory_item_id,hr_api.g_number) <>
2048: nvl(p_inventory_item_id,hr_api.g_number)) then
2049: --
2050: hr_utility.set_location('Entering:'||l_proc, 10);
2051:

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

2044: l_old_organization_id;
2045: CLOSE csr_old_inventory;
2046: if ((p_activity_version_id is not null) and
2047: nvl(l_old_inventory_item_id,hr_api.g_number) <>
2048: nvl(p_inventory_item_id,hr_api.g_number)) then
2049: --
2050: hr_utility.set_location('Entering:'||l_proc, 10);
2051:
2052: --

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

2157: CLOSE csr_old_inventory;
2158: END IF;
2159:
2160: if (((p_activity_version_id is not null) and
2161: (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2162: nvl(p_inventory_item_id,hr_api.g_number)or
2163: nvl(l_old_organization_id,hr_api.g_number) <>
2164: nvl(p_organization_id,hr_api.g_number)))
2165: or (p_activity_version_id is null)) then

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

2158: END IF;
2159:
2160: if (((p_activity_version_id is not null) and
2161: (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2162: nvl(p_inventory_item_id,hr_api.g_number)or
2163: nvl(l_old_organization_id,hr_api.g_number) <>
2164: nvl(p_organization_id,hr_api.g_number)))
2165: or (p_activity_version_id is null)) then
2166: --

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

2159:
2160: if (((p_activity_version_id is not null) and
2161: (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2162: nvl(p_inventory_item_id,hr_api.g_number)or
2163: nvl(l_old_organization_id,hr_api.g_number) <>
2164: nvl(p_organization_id,hr_api.g_number)))
2165: or (p_activity_version_id is null)) then
2166: --
2167: hr_utility.set_location('Entering:'||l_proc, 10);

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

2160: if (((p_activity_version_id is not null) and
2161: (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2162: nvl(p_inventory_item_id,hr_api.g_number)or
2163: nvl(l_old_organization_id,hr_api.g_number) <>
2164: nvl(p_organization_id,hr_api.g_number)))
2165: or (p_activity_version_id is null)) then
2166: --
2167: hr_utility.set_location('Entering:'||l_proc, 10);
2168:

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

2192: end if;
2193:
2194: if ( p_activity_version_id is not null
2195: and p_inventory_item_id is not null
2196: and (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2197: nvl(p_inventory_item_id,hr_api.g_number))) then
2198:
2199: open cur_offerings;
2200: fetch cur_offerings

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

2193:
2194: if ( p_activity_version_id is not null
2195: and p_inventory_item_id is not null
2196: and (nvl(l_old_inventory_item_id ,hr_api.g_number) <>
2197: nvl(p_inventory_item_id,hr_api.g_number))) then
2198:
2199: open cur_offerings;
2200: fetch cur_offerings
2201: into l_num;

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

2264:
2265: hr_utility.set_location('Entering:'||l_proc, 5);
2266:
2267: if (((p_activity_version_id is not null) and
2268: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>
2269: nvl(p_rco_id,hr_api.g_number))
2270: or (p_activity_version_id is null)) then
2271: --
2272: hr_utility.set_location('Entering:'||l_proc, 10);

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

2265: hr_utility.set_location('Entering:'||l_proc, 5);
2266:
2267: if (((p_activity_version_id is not null) and
2268: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>
2269: nvl(p_rco_id,hr_api.g_number))
2270: or (p_activity_version_id is null)) then
2271: --
2272: hr_utility.set_location('Entering:'||l_proc, 10);
2273: if (p_rco_id is not null) then

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

2338: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2339: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2340: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2341:
2342: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2343: NVL( p_start_date, hr_api.g_date )) THEN
2344: l_upd_start_date := TRUE;
2345: l_start_date := p_start_date;
2346: ELSE

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

2339: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2340: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2341:
2342: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2343: NVL( p_start_date, hr_api.g_date )) THEN
2344: l_upd_start_date := TRUE;
2345: l_start_date := p_start_date;
2346: ELSE
2347: l_upd_start_date := FALSE;

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

2347: l_upd_start_date := FALSE;
2348: l_start_date := ota_tav_shd.g_old_rec.start_date;
2349: END IF;
2350:
2351: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2352: NVL( p_end_date, hr_api.g_date )) THEN
2353: l_upd_end_date := TRUE;
2354: l_end_date := p_end_date;
2355: ELSE

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

2348: l_start_date := ota_tav_shd.g_old_rec.start_date;
2349: END IF;
2350:
2351: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2352: NVL( p_end_date, hr_api.g_date )) THEN
2353: l_upd_end_date := TRUE;
2354: l_end_date := p_end_date;
2355: ELSE
2356: l_upd_end_date := FALSE;

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

2527: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2528: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2529: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2530:
2531: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2532: NVL( p_start_date, hr_api.g_date )) THEN
2533: l_upd_start_date := TRUE;
2534: l_start_date := p_start_date;
2535: ELSE

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

2528: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2529: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN
2530:
2531: IF (NVL(ota_tav_shd.g_old_rec.start_date, hr_api.g_date) <>
2532: NVL( p_start_date, hr_api.g_date )) THEN
2533: l_upd_start_date := TRUE;
2534: l_start_date := p_start_date;
2535: ELSE
2536: l_upd_start_date := FALSE;

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

2536: l_upd_start_date := FALSE;
2537: l_start_date := ota_tav_shd.g_old_rec.start_date;
2538: END IF;
2539:
2540: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2541: NVL( p_end_date, hr_api.g_date )) THEN
2542: l_upd_end_date := TRUE;
2543: l_end_date := p_end_date;
2544: ELSE

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

2537: l_start_date := ota_tav_shd.g_old_rec.start_date;
2538: END IF;
2539:
2540: IF (NVL(ota_tav_shd.g_old_rec.end_date, hr_api.g_date) <>
2541: NVL( p_end_date, hr_api.g_date )) THEN
2542: l_upd_end_date := TRUE;
2543: l_end_date := p_end_date;
2544: ELSE
2545: l_upd_end_date := FALSE;