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.OKL_TAL_PVT dependencies on DUAL

Line 61: FROM DUAL

57:
58: ln_dummy number := 0;
59: CURSOR c_tas_id_validate(p_id number) is
60: SELECT 1
61: FROM DUAL
62: WHERE EXISTS (SELECT id
63: FROM OKL_TRX_ASSETS
64: WHERE id = p_id);
65:

Line 140: FROM DUAL

136:
137: ln_dummy number := 0;
138: CURSOR c_ilo_id_validate(p_id number) is
139: SELECT 1
140: FROM DUAL
141: WHERE EXISTS (SELECT id1
142: FROM OKX_AST_LOCS_V
143: WHERE id1 = p_id
144: AND id2 = G_ID2);

Line 214: FROM DUAL

210:
211: ln_dummy number := 0;
212: CURSOR c_ilo_id_old_validate(p_id number) is
213: SELECT 1
214: FROM DUAL
215: WHERE EXISTS (SELECT id1
216: FROM OKX_AST_LOCS_V
217: WHERE id1 = p_id
218: AND id2 = G_ID2);

Line 288: FROM DUAL

284:
285: ln_dummy number := 0;
286: CURSOR c_iay_id_validate(p_id number) is
287: SELECT 1
288: FROM DUAL
289: WHERE EXISTS (SELECT id1
290: FROM OKX_ASST_CATGRS_V
291: WHERE id1 = p_id
292: AND id2 = G_ID2);

Line 362: FROM DUAL

358:
359: ln_dummy number := 0;
360: CURSOR c_iay_id_new_validate(p_id number) is
361: SELECT 1
362: FROM DUAL
363: WHERE EXISTS (SELECT id1
364: FROM OKX_ASST_CATGRS_V
365: WHERE id1 = p_id
366: AND id2 = G_ID2);

Line 437: FROM DUAL

433:
434: ln_dummy number := 0;
435: CURSOR c_kle_id_validate(p_id number) is
436: SELECT 1
437: FROM DUAL
438: WHERE EXISTS (SELECT id
439: FROM OKL_K_LINES_V
440: WHERE id = p_id);
441: BEGIN

Line 577: FROM DUAL

573: ln_dummy number := 0;
574: CURSOR c_org_id_validate(p_org_id OKL_TXL_ASSETS_B.ORG_ID%TYPE,
575: p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE) is
576: SELECT 1
577: FROM DUAL
578: WHERE EXISTS (SELECT chrv.authoring_org_id
579: FROM OKC_K_HEADERS_B chrv,
580: OKC_K_LINES_B cle,
581: OKL_K_LINES_V kle

Line 815: FROM DUAL

811:
812: ln_dummy number := 0;
813: CURSOR c_deprn_id_validate(p_id1 OKX_ASST_CATGRS_V.ID1%type) is
814: SELECT 1
815: FROM DUAL
816: WHERE EXISTS (SELECT '1'
817: FROM OKX_ASST_CATGRS_V
818: WHERE id1 = p_id1
819: and id2 = G_ID2);

Line 889: FROM DUAL

885:
886: ln_dummy number := 0;
887: CURSOR c_fa_location_id_validate(p_fa_location_id OKX_AST_LOCS_V.LOCATION_ID%TYPE) is
888: SELECT 1
889: FROM DUAL
890: WHERE EXISTS (SELECT '1'
891: FROM OKX_AST_LOCS_V
892: WHERE id1 = p_fa_location_id
893: AND id2 = G_ID2);

Line 966: FROM DUAL

962:
963: ln_dummy number := 0;
964: CURSOR c_dnz_khr_id_validate(p_dnz_khr_id OKL_TXL_ASSETS_V.DNZ_KHR_ID%TYPE) is
965: SELECT 1
966: FROM DUAL
967: WHERE EXISTS (SELECT '1'
968: FROM OKC_K_HEADERS_B chrv
969: WHERE chrv.id = p_dnz_khr_id);
970: BEGIN

Line 1040: FROM DUAL

1036:
1037: ln_dummy number := 0;
1038: CURSOR c_corp_book_validate(p_name OKX_ASST_BK_CONTROLS_V.NAME%TYPE) is
1039: SELECT 1
1040: FROM DUAL
1041: WHERE EXISTS (SELECT id1
1042: FROM OKX_ASST_BK_CONTROLS_V
1043: WHERE name = p_name
1044: AND book_class = 'CORPORATE');

Line 1114: FROM DUAL

1110:
1111: ln_dummy number := 0;
1112: CURSOR c_deprn_method_validate(p_deprn_method OKX_ASST_DEP_METHODS_V.METHOD_CODE%TYPE) is
1113: SELECT 1
1114: FROM DUAL
1115: WHERE EXISTS (SELECT method_code
1116: FROM OKX_ASST_DEP_METHODS_V
1117: WHERE method_code = p_deprn_method);
1118:

Line 1480: IF (p_talv_rec.new_residual_value IS NOT NULL

1476:
1477: x_talv_rec.old_salvage_value := l_conv_amount;
1478: END IF;
1479:
1480: IF (p_talv_rec.new_residual_value IS NOT NULL
1481: AND
1482: p_talv_rec.new_residual_value <> OKL_API.G_MISS_NUM) THEN
1483:
1484: l_conv_amount := NULL;

Line 1482: p_talv_rec.new_residual_value <> OKL_API.G_MISS_NUM) THEN

1478: END IF;
1479:
1480: IF (p_talv_rec.new_residual_value IS NOT NULL
1481: AND
1482: p_talv_rec.new_residual_value <> OKL_API.G_MISS_NUM) THEN
1483:
1484: l_conv_amount := NULL;
1485: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1486: p_amount => p_talv_rec.new_residual_value,

Line 1486: p_amount => p_talv_rec.new_residual_value,

1482: p_talv_rec.new_residual_value <> OKL_API.G_MISS_NUM) THEN
1483:
1484: l_conv_amount := NULL;
1485: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1486: p_amount => p_talv_rec.new_residual_value,
1487: p_currency_code => l_currency_code
1488: );
1489:
1490: x_talv_rec.new_residual_value := l_conv_amount;

Line 1490: x_talv_rec.new_residual_value := l_conv_amount;

1486: p_amount => p_talv_rec.new_residual_value,
1487: p_currency_code => l_currency_code
1488: );
1489:
1490: x_talv_rec.new_residual_value := l_conv_amount;
1491: END IF;
1492:
1493: IF (p_talv_rec.old_residual_value IS NOT NULL
1494: AND

Line 1493: IF (p_talv_rec.old_residual_value IS NOT NULL

1489:
1490: x_talv_rec.new_residual_value := l_conv_amount;
1491: END IF;
1492:
1493: IF (p_talv_rec.old_residual_value IS NOT NULL
1494: AND
1495: p_talv_rec.old_residual_value <> OKL_API.G_MISS_NUM) THEN
1496:
1497: l_conv_amount := NULL;

Line 1495: p_talv_rec.old_residual_value <> OKL_API.G_MISS_NUM) THEN

1491: END IF;
1492:
1493: IF (p_talv_rec.old_residual_value IS NOT NULL
1494: AND
1495: p_talv_rec.old_residual_value <> OKL_API.G_MISS_NUM) THEN
1496:
1497: l_conv_amount := NULL;
1498: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1499: p_amount => p_talv_rec.old_residual_value,

Line 1499: p_amount => p_talv_rec.old_residual_value,

1495: p_talv_rec.old_residual_value <> OKL_API.G_MISS_NUM) THEN
1496:
1497: l_conv_amount := NULL;
1498: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
1499: p_amount => p_talv_rec.old_residual_value,
1500: p_currency_code => l_currency_code
1501: );
1502:
1503: x_talv_rec.old_residual_value := l_conv_amount;

Line 1503: x_talv_rec.old_residual_value := l_conv_amount;

1499: p_amount => p_talv_rec.old_residual_value,
1500: p_currency_code => l_currency_code
1501: );
1502:
1503: x_talv_rec.old_residual_value := l_conv_amount;
1504: END IF;
1505:
1506: IF (p_talv_rec.cost_retired IS NOT NULL
1507: AND

Line 1896: NEW_RESIDUAL_VALUE,

1892: LAST_UPDATE_LOGIN,
1893: DEPRECIATE_YN,
1894: HOLD_PERIOD_DAYS,
1895: OLD_SALVAGE_VALUE,
1896: NEW_RESIDUAL_VALUE,
1897: OLD_RESIDUAL_VALUE,
1898: UNITS_RETIRED,
1899: COST_RETIRED,
1900: SALE_PROCEEDS,

Line 1897: OLD_RESIDUAL_VALUE,

1893: DEPRECIATE_YN,
1894: HOLD_PERIOD_DAYS,
1895: OLD_SALVAGE_VALUE,
1896: NEW_RESIDUAL_VALUE,
1897: OLD_RESIDUAL_VALUE,
1898: UNITS_RETIRED,
1899: COST_RETIRED,
1900: SALE_PROCEEDS,
1901: REMOVAL_COST,

Line 1916: RESIDUAL_SHR_PARTY_ID,

1912: currency_conversion_rate,
1913: currency_conversion_date,
1914: -- Multi-Currency Change
1915: -- VRS Project - START
1916: RESIDUAL_SHR_PARTY_ID,
1917: RESIDUAL_SHR_AMOUNT,
1918: RETIREMENT_ID
1919: -- VRS Project - END
1920: FROM Okl_Txl_Assets_B

Line 1917: RESIDUAL_SHR_AMOUNT,

1913: currency_conversion_date,
1914: -- Multi-Currency Change
1915: -- VRS Project - START
1916: RESIDUAL_SHR_PARTY_ID,
1917: RESIDUAL_SHR_AMOUNT,
1918: RETIREMENT_ID
1919: -- VRS Project - END
1920: FROM Okl_Txl_Assets_B
1921: WHERE okl_txl_assets_b.id = p_id;

Line 1992: l_tal_rec.NEW_RESIDUAL_VALUE,

1988: l_tal_rec.LAST_UPDATE_LOGIN,
1989: l_tal_rec.DEPRECIATE_YN,
1990: l_tal_rec.HOLD_PERIOD_DAYS,
1991: l_tal_rec.OLD_SALVAGE_VALUE,
1992: l_tal_rec.NEW_RESIDUAL_VALUE,
1993: l_tal_rec.OLD_RESIDUAL_VALUE,
1994: l_tal_rec.UNITS_RETIRED,
1995: l_tal_rec.COST_RETIRED,
1996: l_tal_rec.SALE_PROCEEDS,

Line 1993: l_tal_rec.OLD_RESIDUAL_VALUE,

1989: l_tal_rec.DEPRECIATE_YN,
1990: l_tal_rec.HOLD_PERIOD_DAYS,
1991: l_tal_rec.OLD_SALVAGE_VALUE,
1992: l_tal_rec.NEW_RESIDUAL_VALUE,
1993: l_tal_rec.OLD_RESIDUAL_VALUE,
1994: l_tal_rec.UNITS_RETIRED,
1995: l_tal_rec.COST_RETIRED,
1996: l_tal_rec.SALE_PROCEEDS,
1997: l_tal_rec.REMOVAL_COST,

Line 2012: l_tal_rec.RESIDUAL_SHR_PARTY_ID,

2008: l_tal_rec.currency_conversion_rate,
2009: l_tal_rec.currency_conversion_date,
2010: -- Multi-Currency Change
2011: -- VRS Project - START
2012: l_tal_rec.RESIDUAL_SHR_PARTY_ID,
2013: l_tal_rec.RESIDUAL_SHR_AMOUNT,
2014: l_tal_rec.RETIREMENT_ID;
2015: -- VRS Project - END
2016: x_no_data_found := okl_txl_asset_b_pk_csr%NOTFOUND;

Line 2013: l_tal_rec.RESIDUAL_SHR_AMOUNT,

2009: l_tal_rec.currency_conversion_date,
2010: -- Multi-Currency Change
2011: -- VRS Project - START
2012: l_tal_rec.RESIDUAL_SHR_PARTY_ID,
2013: l_tal_rec.RESIDUAL_SHR_AMOUNT,
2014: l_tal_rec.RETIREMENT_ID;
2015: -- VRS Project - END
2016: x_no_data_found := okl_txl_asset_b_pk_csr%NOTFOUND;
2017: CLOSE okl_txl_asset_b_pk_csr;

Line 2154: NEW_RESIDUAL_VALUE,

2150: LAST_UPDATE_LOGIN,
2151: DEPRECIATE_YN,
2152: HOLD_PERIOD_DAYS,
2153: OLD_SALVAGE_VALUE,
2154: NEW_RESIDUAL_VALUE,
2155: OLD_RESIDUAL_VALUE,
2156: UNITS_RETIRED,
2157: COST_RETIRED,
2158: SALE_PROCEEDS,

Line 2155: OLD_RESIDUAL_VALUE,

2151: DEPRECIATE_YN,
2152: HOLD_PERIOD_DAYS,
2153: OLD_SALVAGE_VALUE,
2154: NEW_RESIDUAL_VALUE,
2155: OLD_RESIDUAL_VALUE,
2156: UNITS_RETIRED,
2157: COST_RETIRED,
2158: SALE_PROCEEDS,
2159: REMOVAL_COST,

Line 2174: RESIDUAL_SHR_PARTY_ID,

2170: currency_conversion_rate,
2171: currency_conversion_date,
2172: -- Multi-Currency Change
2173: -- VRS Project - START
2174: RESIDUAL_SHR_PARTY_ID,
2175: RESIDUAL_SHR_AMOUNT,
2176: RETIREMENT_ID
2177: -- VRS Project - END
2178: FROM Okl_Txl_Assets_V

Line 2175: RESIDUAL_SHR_AMOUNT,

2171: currency_conversion_date,
2172: -- Multi-Currency Change
2173: -- VRS Project - START
2174: RESIDUAL_SHR_PARTY_ID,
2175: RESIDUAL_SHR_AMOUNT,
2176: RETIREMENT_ID
2177: -- VRS Project - END
2178: FROM Okl_Txl_Assets_V
2179: WHERE okl_txl_assets_v.id = p_id;

Line 2252: l_talv_rec.NEW_RESIDUAL_VALUE,

2248: l_talv_rec.LAST_UPDATE_LOGIN,
2249: l_talv_rec.DEPRECIATE_YN,
2250: l_talv_rec.HOLD_PERIOD_DAYS,
2251: l_talv_rec.OLD_SALVAGE_VALUE,
2252: l_talv_rec.NEW_RESIDUAL_VALUE,
2253: l_talv_rec.OLD_RESIDUAL_VALUE,
2254: l_talv_rec.UNITS_RETIRED,
2255: l_talv_rec.COST_RETIRED,
2256: l_talv_rec.SALE_PROCEEDS,

Line 2253: l_talv_rec.OLD_RESIDUAL_VALUE,

2249: l_talv_rec.DEPRECIATE_YN,
2250: l_talv_rec.HOLD_PERIOD_DAYS,
2251: l_talv_rec.OLD_SALVAGE_VALUE,
2252: l_talv_rec.NEW_RESIDUAL_VALUE,
2253: l_talv_rec.OLD_RESIDUAL_VALUE,
2254: l_talv_rec.UNITS_RETIRED,
2255: l_talv_rec.COST_RETIRED,
2256: l_talv_rec.SALE_PROCEEDS,
2257: l_talv_rec.REMOVAL_COST,

Line 2272: l_talv_rec.RESIDUAL_SHR_PARTY_ID,

2268: l_talv_rec.currency_conversion_rate,
2269: l_talv_rec.currency_conversion_date,
2270: -- Multi-Currency Change
2271: -- VRS Project - START
2272: l_talv_rec.RESIDUAL_SHR_PARTY_ID,
2273: l_talv_rec.RESIDUAL_SHR_AMOUNT,
2274: l_talv_rec.RETIREMENT_ID;
2275: -- VRS Project - END
2276:

Line 2273: l_talv_rec.RESIDUAL_SHR_AMOUNT,

2269: l_talv_rec.currency_conversion_date,
2270: -- Multi-Currency Change
2271: -- VRS Project - START
2272: l_talv_rec.RESIDUAL_SHR_PARTY_ID,
2273: l_talv_rec.RESIDUAL_SHR_AMOUNT,
2274: l_talv_rec.RETIREMENT_ID;
2275: -- VRS Project - END
2276:
2277: x_no_data_found := okl_talv_pk_csr%NOTFOUND;

Line 2484: IF (l_talv_rec.new_residual_value = OKC_API.G_MISS_NUM) THEN

2480: END IF;
2481: IF (l_talv_rec.old_salvage_value = OKC_API.G_MISS_NUM) THEN
2482: l_talv_rec.old_salvage_value := NULL;
2483: END IF;
2484: IF (l_talv_rec.new_residual_value = OKC_API.G_MISS_NUM) THEN
2485: l_talv_rec.new_residual_value := NULL;
2486: END IF;
2487: IF (l_talv_rec.old_residual_value = OKC_API.G_MISS_NUM) THEN
2488: l_talv_rec.old_residual_value := NULL;

Line 2485: l_talv_rec.new_residual_value := NULL;

2481: IF (l_talv_rec.old_salvage_value = OKC_API.G_MISS_NUM) THEN
2482: l_talv_rec.old_salvage_value := NULL;
2483: END IF;
2484: IF (l_talv_rec.new_residual_value = OKC_API.G_MISS_NUM) THEN
2485: l_talv_rec.new_residual_value := NULL;
2486: END IF;
2487: IF (l_talv_rec.old_residual_value = OKC_API.G_MISS_NUM) THEN
2488: l_talv_rec.old_residual_value := NULL;
2489: END IF;

Line 2487: IF (l_talv_rec.old_residual_value = OKC_API.G_MISS_NUM) THEN

2483: END IF;
2484: IF (l_talv_rec.new_residual_value = OKC_API.G_MISS_NUM) THEN
2485: l_talv_rec.new_residual_value := NULL;
2486: END IF;
2487: IF (l_talv_rec.old_residual_value = OKC_API.G_MISS_NUM) THEN
2488: l_talv_rec.old_residual_value := NULL;
2489: END IF;
2490: IF (l_talv_rec.units_retired = OKC_API.G_MISS_NUM) THEN
2491: l_talv_rec.units_retired := NULL;

Line 2488: l_talv_rec.old_residual_value := NULL;

2484: IF (l_talv_rec.new_residual_value = OKC_API.G_MISS_NUM) THEN
2485: l_talv_rec.new_residual_value := NULL;
2486: END IF;
2487: IF (l_talv_rec.old_residual_value = OKC_API.G_MISS_NUM) THEN
2488: l_talv_rec.old_residual_value := NULL;
2489: END IF;
2490: IF (l_talv_rec.units_retired = OKC_API.G_MISS_NUM) THEN
2491: l_talv_rec.units_retired := NULL;
2492: END IF;

Line 2541: IF (l_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN

2537: -- Multi-Currency Change
2538:
2539: -- VRS Project - START
2540:
2541: IF (l_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
2542: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;
2543: END IF;
2544: IF (l_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
2545: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;

Line 2542: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;

2538:
2539: -- VRS Project - START
2540:
2541: IF (l_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
2542: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;
2543: END IF;
2544: IF (l_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
2545: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;
2546: END IF;

Line 2544: IF (l_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN

2540:
2541: IF (l_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
2542: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;
2543: END IF;
2544: IF (l_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
2545: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;
2546: END IF;
2547: IF (l_talv_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM) THEN
2548: l_talv_rec.RETIREMENT_ID := NULL;

Line 2545: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;

2541: IF (l_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
2542: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;
2543: END IF;
2544: IF (l_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
2545: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;
2546: END IF;
2547: IF (l_talv_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM) THEN
2548: l_talv_rec.RETIREMENT_ID := NULL;
2549: END IF;

Line 2879: p_to.new_residual_value := p_from.new_residual_value;

2875: p_to.last_update_login := p_from.last_update_login;
2876: p_to.depreciate_yn := p_from.depreciate_yn;
2877: p_to.hold_period_days := p_from.hold_period_days;
2878: p_to.old_salvage_value := p_from.old_salvage_value;
2879: p_to.new_residual_value := p_from.new_residual_value;
2880: p_to.old_residual_value := p_from.old_residual_value;
2881: p_to.units_retired := p_from.units_retired;
2882: p_to.cost_retired := p_from.cost_retired;
2883: p_to.sale_proceeds := p_from.sale_proceeds;

Line 2880: p_to.old_residual_value := p_from.old_residual_value;

2876: p_to.depreciate_yn := p_from.depreciate_yn;
2877: p_to.hold_period_days := p_from.hold_period_days;
2878: p_to.old_salvage_value := p_from.old_salvage_value;
2879: p_to.new_residual_value := p_from.new_residual_value;
2880: p_to.old_residual_value := p_from.old_residual_value;
2881: p_to.units_retired := p_from.units_retired;
2882: p_to.cost_retired := p_from.cost_retired;
2883: p_to.sale_proceeds := p_from.sale_proceeds;
2884: p_to.removal_cost := p_from.removal_cost;

Line 2899: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;

2895: p_to.currency_conversion_rate := p_from.currency_conversion_rate;
2896: p_to.currency_conversion_date := p_from.currency_conversion_date;
2897: -- Multi-Currency Change
2898: -- VRS Project - START
2899: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;
2900: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;
2901: p_to.RETIREMENT_ID := p_from.RETIREMENT_ID;
2902: -- VRS Project - END
2903:

Line 2900: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;

2896: p_to.currency_conversion_date := p_from.currency_conversion_date;
2897: -- Multi-Currency Change
2898: -- VRS Project - START
2899: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;
2900: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;
2901: p_to.RETIREMENT_ID := p_from.RETIREMENT_ID;
2902: -- VRS Project - END
2903:
2904: END migrate;

Line 2973: p_to.new_residual_value := p_from.new_residual_value;

2969: p_to.last_update_login := p_from.last_update_login;
2970: p_to.depreciate_yn := p_from.depreciate_yn;
2971: p_to.hold_period_days := p_from.hold_period_days;
2972: p_to.old_salvage_value := p_from.old_salvage_value;
2973: p_to.new_residual_value := p_from.new_residual_value;
2974: p_to.old_residual_value := p_from.old_residual_value;
2975: p_to.units_retired := p_from.units_retired;
2976: p_to.cost_retired := p_from.cost_retired;
2977: p_to.sale_proceeds := p_from.sale_proceeds;

Line 2974: p_to.old_residual_value := p_from.old_residual_value;

2970: p_to.depreciate_yn := p_from.depreciate_yn;
2971: p_to.hold_period_days := p_from.hold_period_days;
2972: p_to.old_salvage_value := p_from.old_salvage_value;
2973: p_to.new_residual_value := p_from.new_residual_value;
2974: p_to.old_residual_value := p_from.old_residual_value;
2975: p_to.units_retired := p_from.units_retired;
2976: p_to.cost_retired := p_from.cost_retired;
2977: p_to.sale_proceeds := p_from.sale_proceeds;
2978: p_to.removal_cost := p_from.removal_cost;

Line 2993: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;

2989: p_to.currency_conversion_rate := p_from.currency_conversion_rate;
2990: p_to.currency_conversion_date := p_from.currency_conversion_date;
2991: -- Multi-Currency Change
2992: -- VRS Project - START
2993: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;
2994: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;
2995: p_to.RETIREMENT_ID := p_from.RETIREMENT_ID;
2996: -- VRS Project - END
2997:

Line 2994: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;

2990: p_to.currency_conversion_date := p_from.currency_conversion_date;
2991: -- Multi-Currency Change
2992: -- VRS Project - START
2993: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;
2994: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;
2995: p_to.RETIREMENT_ID := p_from.RETIREMENT_ID;
2996: -- VRS Project - END
2997:
2998: END migrate;

Line 3288: new_residual_value,

3284: last_update_login,
3285: depreciate_yn,
3286: hold_period_days,
3287: old_salvage_value,
3288: new_residual_value,
3289: old_residual_value,
3290: units_retired,
3291: cost_retired,
3292: sale_proceeds,

Line 3289: old_residual_value,

3285: depreciate_yn,
3286: hold_period_days,
3287: old_salvage_value,
3288: new_residual_value,
3289: old_residual_value,
3290: units_retired,
3291: cost_retired,
3292: sale_proceeds,
3293: removal_cost,

Line 3308: RESIDUAL_SHR_PARTY_ID,

3304: currency_conversion_rate,
3305: currency_conversion_date,
3306: -- Multi-Currency Change
3307: -- VRS Project - END
3308: RESIDUAL_SHR_PARTY_ID,
3309: RESIDUAL_SHR_AMOUNT,
3310: RETIREMENT_ID
3311: -- VRS Project - END
3312: )

Line 3309: RESIDUAL_SHR_AMOUNT,

3305: currency_conversion_date,
3306: -- Multi-Currency Change
3307: -- VRS Project - END
3308: RESIDUAL_SHR_PARTY_ID,
3309: RESIDUAL_SHR_AMOUNT,
3310: RETIREMENT_ID
3311: -- VRS Project - END
3312: )
3313: VALUES (

Line 3377: l_tal_rec.new_residual_value,

3373: l_tal_rec.last_update_login,
3374: l_tal_rec.depreciate_yn,
3375: l_tal_rec.hold_period_days,
3376: l_tal_rec.old_salvage_value,
3377: l_tal_rec.new_residual_value,
3378: l_tal_rec.old_residual_value,
3379: l_tal_rec.units_retired,
3380: l_tal_rec.cost_retired,
3381: l_tal_rec.sale_proceeds,

Line 3378: l_tal_rec.old_residual_value,

3374: l_tal_rec.depreciate_yn,
3375: l_tal_rec.hold_period_days,
3376: l_tal_rec.old_salvage_value,
3377: l_tal_rec.new_residual_value,
3378: l_tal_rec.old_residual_value,
3379: l_tal_rec.units_retired,
3380: l_tal_rec.cost_retired,
3381: l_tal_rec.sale_proceeds,
3382: l_tal_rec.removal_cost,

Line 3397: l_tal_rec.RESIDUAL_SHR_PARTY_ID,

3393: l_tal_rec.currency_conversion_rate,
3394: l_tal_rec.currency_conversion_date,
3395: -- Multi-Currency Change
3396: -- VRS Project - END
3397: l_tal_rec.RESIDUAL_SHR_PARTY_ID,
3398: l_tal_rec.RESIDUAL_SHR_AMOUNT,
3399: l_tal_rec.RETIREMENT_ID
3400: -- VRS Project - END
3401: );

Line 3398: l_tal_rec.RESIDUAL_SHR_AMOUNT,

3394: l_tal_rec.currency_conversion_date,
3395: -- Multi-Currency Change
3396: -- VRS Project - END
3397: l_tal_rec.RESIDUAL_SHR_PARTY_ID,
3398: l_tal_rec.RESIDUAL_SHR_AMOUNT,
3399: l_tal_rec.RETIREMENT_ID
3400: -- VRS Project - END
3401: );
3402:

Line 4460: IF (x_tal_rec.new_residual_value = OKC_API.G_MISS_NUM)

4456: IF (x_tal_rec.old_salvage_value = OKC_API.G_MISS_NUM)
4457: THEN
4458: x_tal_rec.old_salvage_value := l_tal_rec.old_salvage_value;
4459: END IF;
4460: IF (x_tal_rec.new_residual_value = OKC_API.G_MISS_NUM)
4461: THEN
4462: x_tal_rec.new_residual_value := l_tal_rec.new_residual_value;
4463: END IF;
4464: IF (x_tal_rec.old_residual_value = OKC_API.G_MISS_NUM)

Line 4462: x_tal_rec.new_residual_value := l_tal_rec.new_residual_value;

4458: x_tal_rec.old_salvage_value := l_tal_rec.old_salvage_value;
4459: END IF;
4460: IF (x_tal_rec.new_residual_value = OKC_API.G_MISS_NUM)
4461: THEN
4462: x_tal_rec.new_residual_value := l_tal_rec.new_residual_value;
4463: END IF;
4464: IF (x_tal_rec.old_residual_value = OKC_API.G_MISS_NUM)
4465: THEN
4466: x_tal_rec.old_residual_value := l_tal_rec.old_residual_value;

Line 4464: IF (x_tal_rec.old_residual_value = OKC_API.G_MISS_NUM)

4460: IF (x_tal_rec.new_residual_value = OKC_API.G_MISS_NUM)
4461: THEN
4462: x_tal_rec.new_residual_value := l_tal_rec.new_residual_value;
4463: END IF;
4464: IF (x_tal_rec.old_residual_value = OKC_API.G_MISS_NUM)
4465: THEN
4466: x_tal_rec.old_residual_value := l_tal_rec.old_residual_value;
4467: END IF;
4468: IF (x_tal_rec.units_retired = OKC_API.G_MISS_NUM)

Line 4466: x_tal_rec.old_residual_value := l_tal_rec.old_residual_value;

4462: x_tal_rec.new_residual_value := l_tal_rec.new_residual_value;
4463: END IF;
4464: IF (x_tal_rec.old_residual_value = OKC_API.G_MISS_NUM)
4465: THEN
4466: x_tal_rec.old_residual_value := l_tal_rec.old_residual_value;
4467: END IF;
4468: IF (x_tal_rec.units_retired = OKC_API.G_MISS_NUM)
4469: THEN
4470: x_tal_rec.units_retired := l_tal_rec.units_retired;

Line 4533: IF (x_tal_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN

4529: -- Multi Currency Change
4530:
4531: -- VRS Project - START
4532:
4533: IF (x_tal_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
4534: x_tal_rec.RESIDUAL_SHR_PARTY_ID:= l_tal_rec.RESIDUAL_SHR_PARTY_ID;
4535: END IF;
4536:
4537: IF (x_tal_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN

Line 4534: x_tal_rec.RESIDUAL_SHR_PARTY_ID:= l_tal_rec.RESIDUAL_SHR_PARTY_ID;

4530:
4531: -- VRS Project - START
4532:
4533: IF (x_tal_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
4534: x_tal_rec.RESIDUAL_SHR_PARTY_ID:= l_tal_rec.RESIDUAL_SHR_PARTY_ID;
4535: END IF;
4536:
4537: IF (x_tal_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
4538: x_tal_rec.RESIDUAL_SHR_AMOUNT := l_tal_rec.RESIDUAL_SHR_AMOUNT;

Line 4537: IF (x_tal_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN

4533: IF (x_tal_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
4534: x_tal_rec.RESIDUAL_SHR_PARTY_ID:= l_tal_rec.RESIDUAL_SHR_PARTY_ID;
4535: END IF;
4536:
4537: IF (x_tal_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
4538: x_tal_rec.RESIDUAL_SHR_AMOUNT := l_tal_rec.RESIDUAL_SHR_AMOUNT;
4539: END IF;
4540: IF (x_tal_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM) THEN
4541: x_tal_rec.RETIREMENT_ID := l_tal_rec.RETIREMENT_ID;

Line 4538: x_tal_rec.RESIDUAL_SHR_AMOUNT := l_tal_rec.RESIDUAL_SHR_AMOUNT;

4534: x_tal_rec.RESIDUAL_SHR_PARTY_ID:= l_tal_rec.RESIDUAL_SHR_PARTY_ID;
4535: END IF;
4536:
4537: IF (x_tal_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
4538: x_tal_rec.RESIDUAL_SHR_AMOUNT := l_tal_rec.RESIDUAL_SHR_AMOUNT;
4539: END IF;
4540: IF (x_tal_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM) THEN
4541: x_tal_rec.RETIREMENT_ID := l_tal_rec.RETIREMENT_ID;
4542: END IF;

Line 4650: NEW_RESIDUAL_VALUE = l_def_tal_rec.new_residual_value,

4646: LAST_UPDATE_LOGIN = l_def_tal_rec.last_update_login,
4647: DEPRECIATE_YN = l_def_tal_rec.depreciate_yn,
4648: HOLD_PERIOD_DAYS = l_def_tal_rec.hold_period_days,
4649: OLD_SALVAGE_VALUE = l_def_tal_rec.old_salvage_value,
4650: NEW_RESIDUAL_VALUE = l_def_tal_rec.new_residual_value,
4651: OLD_RESIDUAL_VALUE = l_def_tal_rec.old_residual_value,
4652: UNITS_RETIRED = l_def_tal_rec.units_retired,
4653: COST_RETIRED = l_def_tal_rec.cost_retired,
4654: SALE_PROCEEDS = l_def_tal_rec.sale_proceeds,

Line 4651: OLD_RESIDUAL_VALUE = l_def_tal_rec.old_residual_value,

4647: DEPRECIATE_YN = l_def_tal_rec.depreciate_yn,
4648: HOLD_PERIOD_DAYS = l_def_tal_rec.hold_period_days,
4649: OLD_SALVAGE_VALUE = l_def_tal_rec.old_salvage_value,
4650: NEW_RESIDUAL_VALUE = l_def_tal_rec.new_residual_value,
4651: OLD_RESIDUAL_VALUE = l_def_tal_rec.old_residual_value,
4652: UNITS_RETIRED = l_def_tal_rec.units_retired,
4653: COST_RETIRED = l_def_tal_rec.cost_retired,
4654: SALE_PROCEEDS = l_def_tal_rec.sale_proceeds,
4655: REMOVAL_COST = l_def_tal_rec.removal_cost,

Line 4669: RESIDUAL_SHR_PARTY_ID =l_def_tal_rec.RESIDUAL_SHR_PARTY_ID,

4665: CURRENCY_CONVERSION_RATE = l_def_tal_rec.currency_conversion_rate,
4666: CURRENCY_CONVERSION_DATE = l_def_tal_rec.currency_conversion_date,
4667:
4668: -- VRS Project - START
4669: RESIDUAL_SHR_PARTY_ID =l_def_tal_rec.RESIDUAL_SHR_PARTY_ID,
4670: RESIDUAL_SHR_AMOUNT =l_def_tal_rec.RESIDUAL_SHR_AMOUNT,
4671: RETIREMENT_ID = l_def_tal_rec.RETIREMENT_ID
4672: -- VRS Project - END
4673:

Line 4670: RESIDUAL_SHR_AMOUNT =l_def_tal_rec.RESIDUAL_SHR_AMOUNT,

4666: CURRENCY_CONVERSION_DATE = l_def_tal_rec.currency_conversion_date,
4667:
4668: -- VRS Project - START
4669: RESIDUAL_SHR_PARTY_ID =l_def_tal_rec.RESIDUAL_SHR_PARTY_ID,
4670: RESIDUAL_SHR_AMOUNT =l_def_tal_rec.RESIDUAL_SHR_AMOUNT,
4671: RETIREMENT_ID = l_def_tal_rec.RETIREMENT_ID
4672: -- VRS Project - END
4673:
4674: WHERE ID = l_def_tal_rec.id;

Line 5182: IF (x_talv_rec.new_residual_value = OKC_API.G_MISS_NUM)

5178: IF (x_talv_rec.old_salvage_value = OKC_API.G_MISS_NUM)
5179: THEN
5180: x_talv_rec.old_salvage_value := l_talv_rec.old_salvage_value;
5181: END IF;
5182: IF (x_talv_rec.new_residual_value = OKC_API.G_MISS_NUM)
5183: THEN
5184: x_talv_rec.new_residual_value := l_talv_rec.new_residual_value;
5185: END IF;
5186: IF (x_talv_rec.old_residual_value = OKC_API.G_MISS_NUM)

Line 5184: x_talv_rec.new_residual_value := l_talv_rec.new_residual_value;

5180: x_talv_rec.old_salvage_value := l_talv_rec.old_salvage_value;
5181: END IF;
5182: IF (x_talv_rec.new_residual_value = OKC_API.G_MISS_NUM)
5183: THEN
5184: x_talv_rec.new_residual_value := l_talv_rec.new_residual_value;
5185: END IF;
5186: IF (x_talv_rec.old_residual_value = OKC_API.G_MISS_NUM)
5187: THEN
5188: x_talv_rec.old_residual_value := l_talv_rec.old_residual_value;

Line 5186: IF (x_talv_rec.old_residual_value = OKC_API.G_MISS_NUM)

5182: IF (x_talv_rec.new_residual_value = OKC_API.G_MISS_NUM)
5183: THEN
5184: x_talv_rec.new_residual_value := l_talv_rec.new_residual_value;
5185: END IF;
5186: IF (x_talv_rec.old_residual_value = OKC_API.G_MISS_NUM)
5187: THEN
5188: x_talv_rec.old_residual_value := l_talv_rec.old_residual_value;
5189: END IF;
5190: IF (x_talv_rec.units_retired = OKC_API.G_MISS_NUM)

Line 5188: x_talv_rec.old_residual_value := l_talv_rec.old_residual_value;

5184: x_talv_rec.new_residual_value := l_talv_rec.new_residual_value;
5185: END IF;
5186: IF (x_talv_rec.old_residual_value = OKC_API.G_MISS_NUM)
5187: THEN
5188: x_talv_rec.old_residual_value := l_talv_rec.old_residual_value;
5189: END IF;
5190: IF (x_talv_rec.units_retired = OKC_API.G_MISS_NUM)
5191: THEN
5192: x_talv_rec.units_retired := l_talv_rec.units_retired;

Line 5255: IF (x_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM)

5251: END IF;
5252: -- Multi Currency Change
5253:
5254: -- VRS Project - START
5255: IF (x_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM)
5256: THEN
5257: x_talv_rec.RESIDUAL_SHR_PARTY_ID := l_talv_rec.RESIDUAL_SHR_PARTY_ID;
5258: END IF;
5259: IF (x_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM)

Line 5257: x_talv_rec.RESIDUAL_SHR_PARTY_ID := l_talv_rec.RESIDUAL_SHR_PARTY_ID;

5253:
5254: -- VRS Project - START
5255: IF (x_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM)
5256: THEN
5257: x_talv_rec.RESIDUAL_SHR_PARTY_ID := l_talv_rec.RESIDUAL_SHR_PARTY_ID;
5258: END IF;
5259: IF (x_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM)
5260: THEN
5261: x_talv_rec.RESIDUAL_SHR_AMOUNT := l_talv_rec.RESIDUAL_SHR_AMOUNT;

Line 5259: IF (x_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM)

5255: IF (x_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM)
5256: THEN
5257: x_talv_rec.RESIDUAL_SHR_PARTY_ID := l_talv_rec.RESIDUAL_SHR_PARTY_ID;
5258: END IF;
5259: IF (x_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM)
5260: THEN
5261: x_talv_rec.RESIDUAL_SHR_AMOUNT := l_talv_rec.RESIDUAL_SHR_AMOUNT;
5262: END IF;
5263: IF (x_talv_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM)

Line 5261: x_talv_rec.RESIDUAL_SHR_AMOUNT := l_talv_rec.RESIDUAL_SHR_AMOUNT;

5257: x_talv_rec.RESIDUAL_SHR_PARTY_ID := l_talv_rec.RESIDUAL_SHR_PARTY_ID;
5258: END IF;
5259: IF (x_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM)
5260: THEN
5261: x_talv_rec.RESIDUAL_SHR_AMOUNT := l_talv_rec.RESIDUAL_SHR_AMOUNT;
5262: END IF;
5263: IF (x_talv_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM)
5264: THEN
5265: x_talv_rec.RETIREMENT_ID := l_talv_rec.RETIREMENT_ID;