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 1880: NEW_RESIDUAL_VALUE,

1876: LAST_UPDATE_LOGIN,
1877: DEPRECIATE_YN,
1878: HOLD_PERIOD_DAYS,
1879: OLD_SALVAGE_VALUE,
1880: NEW_RESIDUAL_VALUE,
1881: OLD_RESIDUAL_VALUE,
1882: UNITS_RETIRED,
1883: COST_RETIRED,
1884: SALE_PROCEEDS,

Line 1881: OLD_RESIDUAL_VALUE,

1877: DEPRECIATE_YN,
1878: HOLD_PERIOD_DAYS,
1879: OLD_SALVAGE_VALUE,
1880: NEW_RESIDUAL_VALUE,
1881: OLD_RESIDUAL_VALUE,
1882: UNITS_RETIRED,
1883: COST_RETIRED,
1884: SALE_PROCEEDS,
1885: REMOVAL_COST,

Line 1900: RESIDUAL_SHR_PARTY_ID,

1896: currency_conversion_rate,
1897: currency_conversion_date,
1898: -- Multi-Currency Change
1899: -- VRS Project - START
1900: RESIDUAL_SHR_PARTY_ID,
1901: RESIDUAL_SHR_AMOUNT,
1902: RETIREMENT_ID
1903: -- VRS Project - END
1904: FROM Okl_Txl_Assets_B

Line 1901: RESIDUAL_SHR_AMOUNT,

1897: currency_conversion_date,
1898: -- Multi-Currency Change
1899: -- VRS Project - START
1900: RESIDUAL_SHR_PARTY_ID,
1901: RESIDUAL_SHR_AMOUNT,
1902: RETIREMENT_ID
1903: -- VRS Project - END
1904: FROM Okl_Txl_Assets_B
1905: WHERE okl_txl_assets_b.id = p_id;

Line 1976: l_tal_rec.NEW_RESIDUAL_VALUE,

1972: l_tal_rec.LAST_UPDATE_LOGIN,
1973: l_tal_rec.DEPRECIATE_YN,
1974: l_tal_rec.HOLD_PERIOD_DAYS,
1975: l_tal_rec.OLD_SALVAGE_VALUE,
1976: l_tal_rec.NEW_RESIDUAL_VALUE,
1977: l_tal_rec.OLD_RESIDUAL_VALUE,
1978: l_tal_rec.UNITS_RETIRED,
1979: l_tal_rec.COST_RETIRED,
1980: l_tal_rec.SALE_PROCEEDS,

Line 1977: l_tal_rec.OLD_RESIDUAL_VALUE,

1973: l_tal_rec.DEPRECIATE_YN,
1974: l_tal_rec.HOLD_PERIOD_DAYS,
1975: l_tal_rec.OLD_SALVAGE_VALUE,
1976: l_tal_rec.NEW_RESIDUAL_VALUE,
1977: l_tal_rec.OLD_RESIDUAL_VALUE,
1978: l_tal_rec.UNITS_RETIRED,
1979: l_tal_rec.COST_RETIRED,
1980: l_tal_rec.SALE_PROCEEDS,
1981: l_tal_rec.REMOVAL_COST,

Line 1996: l_tal_rec.RESIDUAL_SHR_PARTY_ID,

1992: l_tal_rec.currency_conversion_rate,
1993: l_tal_rec.currency_conversion_date,
1994: -- Multi-Currency Change
1995: -- VRS Project - START
1996: l_tal_rec.RESIDUAL_SHR_PARTY_ID,
1997: l_tal_rec.RESIDUAL_SHR_AMOUNT,
1998: l_tal_rec.RETIREMENT_ID;
1999: -- VRS Project - END
2000: x_no_data_found := okl_txl_asset_b_pk_csr%NOTFOUND;

Line 1997: l_tal_rec.RESIDUAL_SHR_AMOUNT,

1993: l_tal_rec.currency_conversion_date,
1994: -- Multi-Currency Change
1995: -- VRS Project - START
1996: l_tal_rec.RESIDUAL_SHR_PARTY_ID,
1997: l_tal_rec.RESIDUAL_SHR_AMOUNT,
1998: l_tal_rec.RETIREMENT_ID;
1999: -- VRS Project - END
2000: x_no_data_found := okl_txl_asset_b_pk_csr%NOTFOUND;
2001: CLOSE okl_txl_asset_b_pk_csr;

Line 2138: NEW_RESIDUAL_VALUE,

2134: LAST_UPDATE_LOGIN,
2135: DEPRECIATE_YN,
2136: HOLD_PERIOD_DAYS,
2137: OLD_SALVAGE_VALUE,
2138: NEW_RESIDUAL_VALUE,
2139: OLD_RESIDUAL_VALUE,
2140: UNITS_RETIRED,
2141: COST_RETIRED,
2142: SALE_PROCEEDS,

Line 2139: OLD_RESIDUAL_VALUE,

2135: DEPRECIATE_YN,
2136: HOLD_PERIOD_DAYS,
2137: OLD_SALVAGE_VALUE,
2138: NEW_RESIDUAL_VALUE,
2139: OLD_RESIDUAL_VALUE,
2140: UNITS_RETIRED,
2141: COST_RETIRED,
2142: SALE_PROCEEDS,
2143: REMOVAL_COST,

Line 2158: RESIDUAL_SHR_PARTY_ID,

2154: currency_conversion_rate,
2155: currency_conversion_date,
2156: -- Multi-Currency Change
2157: -- VRS Project - START
2158: RESIDUAL_SHR_PARTY_ID,
2159: RESIDUAL_SHR_AMOUNT,
2160: RETIREMENT_ID
2161: -- VRS Project - END
2162: FROM Okl_Txl_Assets_V

Line 2159: RESIDUAL_SHR_AMOUNT,

2155: currency_conversion_date,
2156: -- Multi-Currency Change
2157: -- VRS Project - START
2158: RESIDUAL_SHR_PARTY_ID,
2159: RESIDUAL_SHR_AMOUNT,
2160: RETIREMENT_ID
2161: -- VRS Project - END
2162: FROM Okl_Txl_Assets_V
2163: WHERE okl_txl_assets_v.id = p_id;

Line 2236: l_talv_rec.NEW_RESIDUAL_VALUE,

2232: l_talv_rec.LAST_UPDATE_LOGIN,
2233: l_talv_rec.DEPRECIATE_YN,
2234: l_talv_rec.HOLD_PERIOD_DAYS,
2235: l_talv_rec.OLD_SALVAGE_VALUE,
2236: l_talv_rec.NEW_RESIDUAL_VALUE,
2237: l_talv_rec.OLD_RESIDUAL_VALUE,
2238: l_talv_rec.UNITS_RETIRED,
2239: l_talv_rec.COST_RETIRED,
2240: l_talv_rec.SALE_PROCEEDS,

Line 2237: l_talv_rec.OLD_RESIDUAL_VALUE,

2233: l_talv_rec.DEPRECIATE_YN,
2234: l_talv_rec.HOLD_PERIOD_DAYS,
2235: l_talv_rec.OLD_SALVAGE_VALUE,
2236: l_talv_rec.NEW_RESIDUAL_VALUE,
2237: l_talv_rec.OLD_RESIDUAL_VALUE,
2238: l_talv_rec.UNITS_RETIRED,
2239: l_talv_rec.COST_RETIRED,
2240: l_talv_rec.SALE_PROCEEDS,
2241: l_talv_rec.REMOVAL_COST,

Line 2256: l_talv_rec.RESIDUAL_SHR_PARTY_ID,

2252: l_talv_rec.currency_conversion_rate,
2253: l_talv_rec.currency_conversion_date,
2254: -- Multi-Currency Change
2255: -- VRS Project - START
2256: l_talv_rec.RESIDUAL_SHR_PARTY_ID,
2257: l_talv_rec.RESIDUAL_SHR_AMOUNT,
2258: l_talv_rec.RETIREMENT_ID;
2259: -- VRS Project - END
2260:

Line 2257: l_talv_rec.RESIDUAL_SHR_AMOUNT,

2253: l_talv_rec.currency_conversion_date,
2254: -- Multi-Currency Change
2255: -- VRS Project - START
2256: l_talv_rec.RESIDUAL_SHR_PARTY_ID,
2257: l_talv_rec.RESIDUAL_SHR_AMOUNT,
2258: l_talv_rec.RETIREMENT_ID;
2259: -- VRS Project - END
2260:
2261: x_no_data_found := okl_talv_pk_csr%NOTFOUND;

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

2464: END IF;
2465: IF (l_talv_rec.old_salvage_value = OKC_API.G_MISS_NUM) THEN
2466: l_talv_rec.old_salvage_value := NULL;
2467: END IF;
2468: IF (l_talv_rec.new_residual_value = OKC_API.G_MISS_NUM) THEN
2469: l_talv_rec.new_residual_value := NULL;
2470: END IF;
2471: IF (l_talv_rec.old_residual_value = OKC_API.G_MISS_NUM) THEN
2472: l_talv_rec.old_residual_value := NULL;

Line 2469: l_talv_rec.new_residual_value := NULL;

2465: IF (l_talv_rec.old_salvage_value = OKC_API.G_MISS_NUM) THEN
2466: l_talv_rec.old_salvage_value := NULL;
2467: END IF;
2468: IF (l_talv_rec.new_residual_value = OKC_API.G_MISS_NUM) THEN
2469: l_talv_rec.new_residual_value := NULL;
2470: END IF;
2471: IF (l_talv_rec.old_residual_value = OKC_API.G_MISS_NUM) THEN
2472: l_talv_rec.old_residual_value := NULL;
2473: END IF;

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

2467: END IF;
2468: IF (l_talv_rec.new_residual_value = OKC_API.G_MISS_NUM) THEN
2469: l_talv_rec.new_residual_value := NULL;
2470: END IF;
2471: IF (l_talv_rec.old_residual_value = OKC_API.G_MISS_NUM) THEN
2472: l_talv_rec.old_residual_value := NULL;
2473: END IF;
2474: IF (l_talv_rec.units_retired = OKC_API.G_MISS_NUM) THEN
2475: l_talv_rec.units_retired := NULL;

Line 2472: l_talv_rec.old_residual_value := NULL;

2468: IF (l_talv_rec.new_residual_value = OKC_API.G_MISS_NUM) THEN
2469: l_talv_rec.new_residual_value := NULL;
2470: END IF;
2471: IF (l_talv_rec.old_residual_value = OKC_API.G_MISS_NUM) THEN
2472: l_talv_rec.old_residual_value := NULL;
2473: END IF;
2474: IF (l_talv_rec.units_retired = OKC_API.G_MISS_NUM) THEN
2475: l_talv_rec.units_retired := NULL;
2476: END IF;

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

2521: -- Multi-Currency Change
2522:
2523: -- VRS Project - START
2524:
2525: IF (l_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
2526: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;
2527: END IF;
2528: IF (l_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
2529: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;

Line 2526: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;

2522:
2523: -- VRS Project - START
2524:
2525: IF (l_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
2526: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;
2527: END IF;
2528: IF (l_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
2529: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;
2530: END IF;

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

2524:
2525: IF (l_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
2526: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;
2527: END IF;
2528: IF (l_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
2529: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;
2530: END IF;
2531: IF (l_talv_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM) THEN
2532: l_talv_rec.RETIREMENT_ID := NULL;

Line 2529: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;

2525: IF (l_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
2526: l_talv_rec.RESIDUAL_SHR_PARTY_ID:= NULL;
2527: END IF;
2528: IF (l_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
2529: l_talv_rec.RESIDUAL_SHR_AMOUNT:= NULL;
2530: END IF;
2531: IF (l_talv_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM) THEN
2532: l_talv_rec.RETIREMENT_ID := NULL;
2533: END IF;

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

2859: p_to.last_update_login := p_from.last_update_login;
2860: p_to.depreciate_yn := p_from.depreciate_yn;
2861: p_to.hold_period_days := p_from.hold_period_days;
2862: p_to.old_salvage_value := p_from.old_salvage_value;
2863: p_to.new_residual_value := p_from.new_residual_value;
2864: p_to.old_residual_value := p_from.old_residual_value;
2865: p_to.units_retired := p_from.units_retired;
2866: p_to.cost_retired := p_from.cost_retired;
2867: p_to.sale_proceeds := p_from.sale_proceeds;

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

2860: p_to.depreciate_yn := p_from.depreciate_yn;
2861: p_to.hold_period_days := p_from.hold_period_days;
2862: p_to.old_salvage_value := p_from.old_salvage_value;
2863: p_to.new_residual_value := p_from.new_residual_value;
2864: p_to.old_residual_value := p_from.old_residual_value;
2865: p_to.units_retired := p_from.units_retired;
2866: p_to.cost_retired := p_from.cost_retired;
2867: p_to.sale_proceeds := p_from.sale_proceeds;
2868: p_to.removal_cost := p_from.removal_cost;

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

2879: p_to.currency_conversion_rate := p_from.currency_conversion_rate;
2880: p_to.currency_conversion_date := p_from.currency_conversion_date;
2881: -- Multi-Currency Change
2882: -- VRS Project - START
2883: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;
2884: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;
2885: p_to.RETIREMENT_ID := p_from.RETIREMENT_ID;
2886: -- VRS Project - END
2887:

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

2880: p_to.currency_conversion_date := p_from.currency_conversion_date;
2881: -- Multi-Currency Change
2882: -- VRS Project - START
2883: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;
2884: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;
2885: p_to.RETIREMENT_ID := p_from.RETIREMENT_ID;
2886: -- VRS Project - END
2887:
2888: END migrate;

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

2953: p_to.last_update_login := p_from.last_update_login;
2954: p_to.depreciate_yn := p_from.depreciate_yn;
2955: p_to.hold_period_days := p_from.hold_period_days;
2956: p_to.old_salvage_value := p_from.old_salvage_value;
2957: p_to.new_residual_value := p_from.new_residual_value;
2958: p_to.old_residual_value := p_from.old_residual_value;
2959: p_to.units_retired := p_from.units_retired;
2960: p_to.cost_retired := p_from.cost_retired;
2961: p_to.sale_proceeds := p_from.sale_proceeds;

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

2954: p_to.depreciate_yn := p_from.depreciate_yn;
2955: p_to.hold_period_days := p_from.hold_period_days;
2956: p_to.old_salvage_value := p_from.old_salvage_value;
2957: p_to.new_residual_value := p_from.new_residual_value;
2958: p_to.old_residual_value := p_from.old_residual_value;
2959: p_to.units_retired := p_from.units_retired;
2960: p_to.cost_retired := p_from.cost_retired;
2961: p_to.sale_proceeds := p_from.sale_proceeds;
2962: p_to.removal_cost := p_from.removal_cost;

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

2973: p_to.currency_conversion_rate := p_from.currency_conversion_rate;
2974: p_to.currency_conversion_date := p_from.currency_conversion_date;
2975: -- Multi-Currency Change
2976: -- VRS Project - START
2977: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;
2978: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;
2979: p_to.RETIREMENT_ID := p_from.RETIREMENT_ID;
2980: -- VRS Project - END
2981:

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

2974: p_to.currency_conversion_date := p_from.currency_conversion_date;
2975: -- Multi-Currency Change
2976: -- VRS Project - START
2977: p_to.RESIDUAL_SHR_PARTY_ID := p_from.RESIDUAL_SHR_PARTY_ID;
2978: p_to.RESIDUAL_SHR_AMOUNT := p_from.RESIDUAL_SHR_AMOUNT;
2979: p_to.RETIREMENT_ID := p_from.RETIREMENT_ID;
2980: -- VRS Project - END
2981:
2982: END migrate;

Line 3272: new_residual_value,

3268: last_update_login,
3269: depreciate_yn,
3270: hold_period_days,
3271: old_salvage_value,
3272: new_residual_value,
3273: old_residual_value,
3274: units_retired,
3275: cost_retired,
3276: sale_proceeds,

Line 3273: old_residual_value,

3269: depreciate_yn,
3270: hold_period_days,
3271: old_salvage_value,
3272: new_residual_value,
3273: old_residual_value,
3274: units_retired,
3275: cost_retired,
3276: sale_proceeds,
3277: removal_cost,

Line 3292: RESIDUAL_SHR_PARTY_ID,

3288: currency_conversion_rate,
3289: currency_conversion_date,
3290: -- Multi-Currency Change
3291: -- VRS Project - END
3292: RESIDUAL_SHR_PARTY_ID,
3293: RESIDUAL_SHR_AMOUNT,
3294: RETIREMENT_ID
3295: -- VRS Project - END
3296: )

Line 3293: RESIDUAL_SHR_AMOUNT,

3289: currency_conversion_date,
3290: -- Multi-Currency Change
3291: -- VRS Project - END
3292: RESIDUAL_SHR_PARTY_ID,
3293: RESIDUAL_SHR_AMOUNT,
3294: RETIREMENT_ID
3295: -- VRS Project - END
3296: )
3297: VALUES (

Line 3361: l_tal_rec.new_residual_value,

3357: l_tal_rec.last_update_login,
3358: l_tal_rec.depreciate_yn,
3359: l_tal_rec.hold_period_days,
3360: l_tal_rec.old_salvage_value,
3361: l_tal_rec.new_residual_value,
3362: l_tal_rec.old_residual_value,
3363: l_tal_rec.units_retired,
3364: l_tal_rec.cost_retired,
3365: l_tal_rec.sale_proceeds,

Line 3362: l_tal_rec.old_residual_value,

3358: l_tal_rec.depreciate_yn,
3359: l_tal_rec.hold_period_days,
3360: l_tal_rec.old_salvage_value,
3361: l_tal_rec.new_residual_value,
3362: l_tal_rec.old_residual_value,
3363: l_tal_rec.units_retired,
3364: l_tal_rec.cost_retired,
3365: l_tal_rec.sale_proceeds,
3366: l_tal_rec.removal_cost,

Line 3381: l_tal_rec.RESIDUAL_SHR_PARTY_ID,

3377: l_tal_rec.currency_conversion_rate,
3378: l_tal_rec.currency_conversion_date,
3379: -- Multi-Currency Change
3380: -- VRS Project - END
3381: l_tal_rec.RESIDUAL_SHR_PARTY_ID,
3382: l_tal_rec.RESIDUAL_SHR_AMOUNT,
3383: l_tal_rec.RETIREMENT_ID
3384: -- VRS Project - END
3385: );

Line 3382: l_tal_rec.RESIDUAL_SHR_AMOUNT,

3378: l_tal_rec.currency_conversion_date,
3379: -- Multi-Currency Change
3380: -- VRS Project - END
3381: l_tal_rec.RESIDUAL_SHR_PARTY_ID,
3382: l_tal_rec.RESIDUAL_SHR_AMOUNT,
3383: l_tal_rec.RETIREMENT_ID
3384: -- VRS Project - END
3385: );
3386:

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

4440: IF (x_tal_rec.old_salvage_value = OKC_API.G_MISS_NUM)
4441: THEN
4442: x_tal_rec.old_salvage_value := l_tal_rec.old_salvage_value;
4443: END IF;
4444: IF (x_tal_rec.new_residual_value = OKC_API.G_MISS_NUM)
4445: THEN
4446: x_tal_rec.new_residual_value := l_tal_rec.new_residual_value;
4447: END IF;
4448: IF (x_tal_rec.old_residual_value = OKC_API.G_MISS_NUM)

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

4442: x_tal_rec.old_salvage_value := l_tal_rec.old_salvage_value;
4443: END IF;
4444: IF (x_tal_rec.new_residual_value = OKC_API.G_MISS_NUM)
4445: THEN
4446: x_tal_rec.new_residual_value := l_tal_rec.new_residual_value;
4447: END IF;
4448: IF (x_tal_rec.old_residual_value = OKC_API.G_MISS_NUM)
4449: THEN
4450: x_tal_rec.old_residual_value := l_tal_rec.old_residual_value;

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

4444: IF (x_tal_rec.new_residual_value = OKC_API.G_MISS_NUM)
4445: THEN
4446: x_tal_rec.new_residual_value := l_tal_rec.new_residual_value;
4447: END IF;
4448: IF (x_tal_rec.old_residual_value = OKC_API.G_MISS_NUM)
4449: THEN
4450: x_tal_rec.old_residual_value := l_tal_rec.old_residual_value;
4451: END IF;
4452: IF (x_tal_rec.units_retired = OKC_API.G_MISS_NUM)

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

4446: x_tal_rec.new_residual_value := l_tal_rec.new_residual_value;
4447: END IF;
4448: IF (x_tal_rec.old_residual_value = OKC_API.G_MISS_NUM)
4449: THEN
4450: x_tal_rec.old_residual_value := l_tal_rec.old_residual_value;
4451: END IF;
4452: IF (x_tal_rec.units_retired = OKC_API.G_MISS_NUM)
4453: THEN
4454: x_tal_rec.units_retired := l_tal_rec.units_retired;

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

4513: -- Multi Currency Change
4514:
4515: -- VRS Project - START
4516:
4517: IF (x_tal_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
4518: x_tal_rec.RESIDUAL_SHR_PARTY_ID:= l_tal_rec.RESIDUAL_SHR_PARTY_ID;
4519: END IF;
4520:
4521: IF (x_tal_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN

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

4514:
4515: -- VRS Project - START
4516:
4517: IF (x_tal_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
4518: x_tal_rec.RESIDUAL_SHR_PARTY_ID:= l_tal_rec.RESIDUAL_SHR_PARTY_ID;
4519: END IF;
4520:
4521: IF (x_tal_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
4522: x_tal_rec.RESIDUAL_SHR_AMOUNT := l_tal_rec.RESIDUAL_SHR_AMOUNT;

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

4517: IF (x_tal_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM) THEN
4518: x_tal_rec.RESIDUAL_SHR_PARTY_ID:= l_tal_rec.RESIDUAL_SHR_PARTY_ID;
4519: END IF;
4520:
4521: IF (x_tal_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
4522: x_tal_rec.RESIDUAL_SHR_AMOUNT := l_tal_rec.RESIDUAL_SHR_AMOUNT;
4523: END IF;
4524: IF (x_tal_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM) THEN
4525: x_tal_rec.RETIREMENT_ID := l_tal_rec.RETIREMENT_ID;

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

4518: x_tal_rec.RESIDUAL_SHR_PARTY_ID:= l_tal_rec.RESIDUAL_SHR_PARTY_ID;
4519: END IF;
4520:
4521: IF (x_tal_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM) THEN
4522: x_tal_rec.RESIDUAL_SHR_AMOUNT := l_tal_rec.RESIDUAL_SHR_AMOUNT;
4523: END IF;
4524: IF (x_tal_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM) THEN
4525: x_tal_rec.RETIREMENT_ID := l_tal_rec.RETIREMENT_ID;
4526: END IF;

Line 4634: NEW_RESIDUAL_VALUE = l_def_tal_rec.new_residual_value,

4630: LAST_UPDATE_LOGIN = l_def_tal_rec.last_update_login,
4631: DEPRECIATE_YN = l_def_tal_rec.depreciate_yn,
4632: HOLD_PERIOD_DAYS = l_def_tal_rec.hold_period_days,
4633: OLD_SALVAGE_VALUE = l_def_tal_rec.old_salvage_value,
4634: NEW_RESIDUAL_VALUE = l_def_tal_rec.new_residual_value,
4635: OLD_RESIDUAL_VALUE = l_def_tal_rec.old_residual_value,
4636: UNITS_RETIRED = l_def_tal_rec.units_retired,
4637: COST_RETIRED = l_def_tal_rec.cost_retired,
4638: SALE_PROCEEDS = l_def_tal_rec.sale_proceeds,

Line 4635: OLD_RESIDUAL_VALUE = l_def_tal_rec.old_residual_value,

4631: DEPRECIATE_YN = l_def_tal_rec.depreciate_yn,
4632: HOLD_PERIOD_DAYS = l_def_tal_rec.hold_period_days,
4633: OLD_SALVAGE_VALUE = l_def_tal_rec.old_salvage_value,
4634: NEW_RESIDUAL_VALUE = l_def_tal_rec.new_residual_value,
4635: OLD_RESIDUAL_VALUE = l_def_tal_rec.old_residual_value,
4636: UNITS_RETIRED = l_def_tal_rec.units_retired,
4637: COST_RETIRED = l_def_tal_rec.cost_retired,
4638: SALE_PROCEEDS = l_def_tal_rec.sale_proceeds,
4639: REMOVAL_COST = l_def_tal_rec.removal_cost,

Line 4653: RESIDUAL_SHR_PARTY_ID =l_def_tal_rec.RESIDUAL_SHR_PARTY_ID,

4649: CURRENCY_CONVERSION_RATE = l_def_tal_rec.currency_conversion_rate,
4650: CURRENCY_CONVERSION_DATE = l_def_tal_rec.currency_conversion_date,
4651:
4652: -- VRS Project - START
4653: RESIDUAL_SHR_PARTY_ID =l_def_tal_rec.RESIDUAL_SHR_PARTY_ID,
4654: RESIDUAL_SHR_AMOUNT =l_def_tal_rec.RESIDUAL_SHR_AMOUNT,
4655: RETIREMENT_ID = l_def_tal_rec.RETIREMENT_ID
4656: -- VRS Project - END
4657:

Line 4654: RESIDUAL_SHR_AMOUNT =l_def_tal_rec.RESIDUAL_SHR_AMOUNT,

4650: CURRENCY_CONVERSION_DATE = l_def_tal_rec.currency_conversion_date,
4651:
4652: -- VRS Project - START
4653: RESIDUAL_SHR_PARTY_ID =l_def_tal_rec.RESIDUAL_SHR_PARTY_ID,
4654: RESIDUAL_SHR_AMOUNT =l_def_tal_rec.RESIDUAL_SHR_AMOUNT,
4655: RETIREMENT_ID = l_def_tal_rec.RETIREMENT_ID
4656: -- VRS Project - END
4657:
4658: WHERE ID = l_def_tal_rec.id;

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

5162: IF (x_talv_rec.old_salvage_value = OKC_API.G_MISS_NUM)
5163: THEN
5164: x_talv_rec.old_salvage_value := l_talv_rec.old_salvage_value;
5165: END IF;
5166: IF (x_talv_rec.new_residual_value = OKC_API.G_MISS_NUM)
5167: THEN
5168: x_talv_rec.new_residual_value := l_talv_rec.new_residual_value;
5169: END IF;
5170: IF (x_talv_rec.old_residual_value = OKC_API.G_MISS_NUM)

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

5164: x_talv_rec.old_salvage_value := l_talv_rec.old_salvage_value;
5165: END IF;
5166: IF (x_talv_rec.new_residual_value = OKC_API.G_MISS_NUM)
5167: THEN
5168: x_talv_rec.new_residual_value := l_talv_rec.new_residual_value;
5169: END IF;
5170: IF (x_talv_rec.old_residual_value = OKC_API.G_MISS_NUM)
5171: THEN
5172: x_talv_rec.old_residual_value := l_talv_rec.old_residual_value;

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

5166: IF (x_talv_rec.new_residual_value = OKC_API.G_MISS_NUM)
5167: THEN
5168: x_talv_rec.new_residual_value := l_talv_rec.new_residual_value;
5169: END IF;
5170: IF (x_talv_rec.old_residual_value = OKC_API.G_MISS_NUM)
5171: THEN
5172: x_talv_rec.old_residual_value := l_talv_rec.old_residual_value;
5173: END IF;
5174: IF (x_talv_rec.units_retired = OKC_API.G_MISS_NUM)

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

5168: x_talv_rec.new_residual_value := l_talv_rec.new_residual_value;
5169: END IF;
5170: IF (x_talv_rec.old_residual_value = OKC_API.G_MISS_NUM)
5171: THEN
5172: x_talv_rec.old_residual_value := l_talv_rec.old_residual_value;
5173: END IF;
5174: IF (x_talv_rec.units_retired = OKC_API.G_MISS_NUM)
5175: THEN
5176: x_talv_rec.units_retired := l_talv_rec.units_retired;

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

5235: END IF;
5236: -- Multi Currency Change
5237:
5238: -- VRS Project - START
5239: IF (x_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM)
5240: THEN
5241: x_talv_rec.RESIDUAL_SHR_PARTY_ID := l_talv_rec.RESIDUAL_SHR_PARTY_ID;
5242: END IF;
5243: IF (x_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM)

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

5237:
5238: -- VRS Project - START
5239: IF (x_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM)
5240: THEN
5241: x_talv_rec.RESIDUAL_SHR_PARTY_ID := l_talv_rec.RESIDUAL_SHR_PARTY_ID;
5242: END IF;
5243: IF (x_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM)
5244: THEN
5245: x_talv_rec.RESIDUAL_SHR_AMOUNT := l_talv_rec.RESIDUAL_SHR_AMOUNT;

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

5239: IF (x_talv_rec.RESIDUAL_SHR_PARTY_ID = OKC_API.G_MISS_NUM)
5240: THEN
5241: x_talv_rec.RESIDUAL_SHR_PARTY_ID := l_talv_rec.RESIDUAL_SHR_PARTY_ID;
5242: END IF;
5243: IF (x_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM)
5244: THEN
5245: x_talv_rec.RESIDUAL_SHR_AMOUNT := l_talv_rec.RESIDUAL_SHR_AMOUNT;
5246: END IF;
5247: IF (x_talv_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM)

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

5241: x_talv_rec.RESIDUAL_SHR_PARTY_ID := l_talv_rec.RESIDUAL_SHR_PARTY_ID;
5242: END IF;
5243: IF (x_talv_rec.RESIDUAL_SHR_AMOUNT = OKC_API.G_MISS_NUM)
5244: THEN
5245: x_talv_rec.RESIDUAL_SHR_AMOUNT := l_talv_rec.RESIDUAL_SHR_AMOUNT;
5246: END IF;
5247: IF (x_talv_rec.RETIREMENT_ID = OKC_API.G_MISS_NUM)
5248: THEN
5249: x_talv_rec.RETIREMENT_ID := l_talv_rec.RETIREMENT_ID;