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_TQL_PVT dependencies on DUAL

Line 274: FROM DUAL

270: p_tqlv_rec IN tqlv_rec_type) IS
271: ln_dummy number := 0;
272: CURSOR c_split_kle_id(p_id number) is
273: SELECT 1
274: FROM DUAL
275: WHERE EXISTS (SELECT id
276: FROM OKL_K_LINES_V
277: WHERE id = p_id);
278:

Line 1195: RESIDUAL_VALUE,

1191: YIELD_NAME,
1192: YIELD_VALUE,
1193: IMPLICIT_INTEREST_RATE,
1194: ASSET_VALUE,
1195: RESIDUAL_VALUE,
1196: UNBILLED_RECEIVABLES,
1197: ASSET_QUANTITY,
1198: QUOTE_QUANTITY,
1199: SPLIT_KLE_ID,

Line 1265: l_tql_rec.RESIDUAL_VALUE,

1261: l_tql_rec.YIELD_NAME,
1262: l_tql_rec.YIELD_VALUE,
1263: l_tql_rec.IMPLICIT_INTEREST_RATE,
1264: l_tql_rec.ASSET_VALUE,
1265: l_tql_rec.RESIDUAL_VALUE,
1266: l_tql_rec.UNBILLED_RECEIVABLES,
1267: l_tql_rec.ASSET_QUANTITY,
1268: l_tql_rec.QUOTE_QUANTITY,
1269: l_tql_rec.SPLIT_KLE_ID,

Line 1414: RESIDUAL_VALUE,

1410: YIELD_NAME,
1411: YIELD_VALUE,
1412: IMPLICIT_INTEREST_RATE,
1413: ASSET_VALUE,
1414: RESIDUAL_VALUE,
1415: UNBILLED_RECEIVABLES,
1416: ASSET_QUANTITY,
1417: QUOTE_QUANTITY,
1418: SPLIT_KLE_ID,

Line 1486: l_tqlv_rec.RESIDUAL_VALUE,

1482: l_tqlv_rec.YIELD_NAME,
1483: l_tqlv_rec.YIELD_VALUE,
1484: l_tqlv_rec.IMPLICIT_INTEREST_RATE,
1485: l_tqlv_rec.ASSET_VALUE,
1486: l_tqlv_rec.RESIDUAL_VALUE,
1487: l_tqlv_rec.UNBILLED_RECEIVABLES,
1488: l_tqlv_rec.ASSET_QUANTITY,
1489: l_tqlv_rec.QUOTE_QUANTITY,
1490: l_tqlv_rec.SPLIT_KLE_ID,

Line 1678: IF (l_tqlv_rec.residual_value = OKC_API.G_MISS_NUM) THEN

1674: END IF;
1675: IF (l_tqlv_rec.asset_value = OKC_API.G_MISS_NUM) THEN
1676: l_tqlv_rec.asset_value := NULL;
1677: END IF;
1678: IF (l_tqlv_rec.residual_value = OKC_API.G_MISS_NUM) THEN
1679: l_tqlv_rec.residual_value := NULL;
1680: END IF;
1681: IF (l_tqlv_rec.unbilled_receivables = OKC_API.G_MISS_NUM) THEN
1682: l_tqlv_rec.unbilled_receivables := NULL;

Line 1679: l_tqlv_rec.residual_value := NULL;

1675: IF (l_tqlv_rec.asset_value = OKC_API.G_MISS_NUM) THEN
1676: l_tqlv_rec.asset_value := NULL;
1677: END IF;
1678: IF (l_tqlv_rec.residual_value = OKC_API.G_MISS_NUM) THEN
1679: l_tqlv_rec.residual_value := NULL;
1680: END IF;
1681: IF (l_tqlv_rec.unbilled_receivables = OKC_API.G_MISS_NUM) THEN
1682: l_tqlv_rec.unbilled_receivables := NULL;
1683: END IF;

Line 2028: p_to.residual_value := p_from.residual_value;

2024: p_to.yield_name := p_from.yield_name;
2025: p_to.yield_value := p_from.yield_value;
2026: p_to.implicit_interest_rate := p_from.implicit_interest_rate;
2027: p_to.asset_value := p_from.asset_value;
2028: p_to.residual_value := p_from.residual_value;
2029: p_to.unbilled_receivables := p_from.unbilled_receivables;
2030: p_to.asset_quantity := p_from.asset_quantity;
2031: p_to.quote_quantity := p_from.quote_quantity;
2032: p_to.split_kle_id := p_from.split_kle_id;

Line 2112: p_to.residual_value := p_from.residual_value;

2108: p_to.yield_name := p_from.yield_name;
2109: p_to.yield_value := p_from.yield_value;
2110: p_to.implicit_interest_rate := p_from.implicit_interest_rate;
2111: p_to.asset_value := p_from.asset_value;
2112: p_to.residual_value := p_from.residual_value;
2113: p_to.unbilled_receivables := p_from.unbilled_receivables;
2114: p_to.asset_quantity := p_from.asset_quantity;
2115: p_to.quote_quantity := p_from.quote_quantity;
2116: p_to.split_kle_id := p_from.split_kle_id;

Line 2434: residual_value,

2430: yield_name,
2431: yield_value,
2432: implicit_interest_rate,
2433: asset_value,
2434: residual_value,
2435: unbilled_receivables,
2436: asset_quantity,
2437: quote_quantity,
2438: split_kle_id,

Line 2496: l_tql_rec.residual_value,

2492: l_tql_rec.yield_name,
2493: l_tql_rec.yield_value,
2494: l_tql_rec.implicit_interest_rate,
2495: l_tql_rec.asset_value,
2496: l_tql_rec.residual_value,
2497: l_tql_rec.unbilled_receivables,
2498: l_tql_rec.asset_quantity,
2499: l_tql_rec.quote_quantity,
2500: l_tql_rec.split_kle_id,

Line 3045: in_residual_value Number14p3TabTyp;

3041: in_yield_name Var150TabTyp;
3042: in_yield_value Number18p15TabTyp;
3043: in_implicit_interest_rate Number18p15TabTyp;
3044: in_asset_value Number14p3TabTyp;
3045: in_residual_value Number14p3TabTyp;
3046: in_unbilled_receivables Number14p3TabTyp;
3047: in_asset_quantity Number14p3TabTyp;
3048: in_quote_quantity Number14p3TabTyp;
3049: in_split_kle_id NumberTabTyp;

Line 3220: in_residual_value(j) := l_tqlv_rec.residual_value;

3216: in_yield_name(j) := l_tqlv_rec.yield_name;
3217: in_yield_value(j) := l_tqlv_rec.yield_value;
3218: in_implicit_interest_rate(j) := l_tqlv_rec.implicit_interest_rate;
3219: in_asset_value(j) := l_tqlv_rec.asset_value;
3220: in_residual_value(j) := l_tqlv_rec.residual_value;
3221: in_unbilled_receivables(j) := l_tqlv_rec.unbilled_receivables;
3222: in_asset_quantity(j) := l_tqlv_rec.asset_quantity;
3223: in_quote_quantity(j) := l_tqlv_rec.quote_quantity;
3224: in_split_kle_id(j) := l_tqlv_rec.split_kle_id;

Line 3317: residual_value,

3313: yield_name,
3314: yield_value,
3315: implicit_interest_rate,
3316: asset_value,
3317: residual_value,
3318: unbilled_receivables,
3319: asset_quantity,
3320: quote_quantity,
3321: split_kle_id,

Line 3378: in_residual_value(i),

3374: in_yield_name(i),
3375: in_yield_value(i),
3376: in_implicit_interest_rate(i),
3377: in_asset_value(i),
3378: in_residual_value(i),
3379: in_unbilled_receivables(i),
3380: in_asset_quantity(i),
3381: in_quote_quantity(i),
3382: in_split_kle_id(i),

Line 4071: IF (x_tql_rec.residual_value = OKC_API.G_MISS_NUM)

4067: IF (x_tql_rec.asset_value = OKC_API.G_MISS_NUM)
4068: THEN
4069: x_tql_rec.asset_value := l_tql_rec.asset_value;
4070: END IF;
4071: IF (x_tql_rec.residual_value = OKC_API.G_MISS_NUM)
4072: THEN
4073: x_tql_rec.residual_value := l_tql_rec.residual_value;
4074: END IF;
4075: IF (x_tql_rec.unbilled_receivables = OKC_API.G_MISS_NUM)

Line 4073: x_tql_rec.residual_value := l_tql_rec.residual_value;

4069: x_tql_rec.asset_value := l_tql_rec.asset_value;
4070: END IF;
4071: IF (x_tql_rec.residual_value = OKC_API.G_MISS_NUM)
4072: THEN
4073: x_tql_rec.residual_value := l_tql_rec.residual_value;
4074: END IF;
4075: IF (x_tql_rec.unbilled_receivables = OKC_API.G_MISS_NUM)
4076: THEN
4077: x_tql_rec.unbilled_receivables := l_tql_rec.unbilled_receivables;

Line 4221: RESIDUAL_VALUE = l_def_tql_rec.residual_value,

4217: YIELD_NAME = l_def_tql_rec.yield_name,
4218: YIELD_VALUE = l_def_tql_rec.yield_value,
4219: IMPLICIT_INTEREST_RATE = l_def_tql_rec.implicit_interest_rate,
4220: ASSET_VALUE = l_def_tql_rec.asset_value,
4221: RESIDUAL_VALUE = l_def_tql_rec.residual_value,
4222: UNBILLED_RECEIVABLES = l_def_tql_rec.unbilled_receivables,
4223: ASSET_QUANTITY = l_def_tql_rec.asset_quantity,
4224: QUOTE_QUANTITY = l_def_tql_rec.quote_quantity,
4225: SPLIT_KLE_ID = l_def_tql_rec.split_kle_id,

Line 4717: IF (x_tqlv_rec.residual_value = OKC_API.G_MISS_NUM)

4713: IF (x_tqlv_rec.asset_value = OKC_API.G_MISS_NUM)
4714: THEN
4715: x_tqlv_rec.asset_value := l_tqlv_rec.asset_value;
4716: END IF;
4717: IF (x_tqlv_rec.residual_value = OKC_API.G_MISS_NUM)
4718: THEN
4719: x_tqlv_rec.residual_value := l_tqlv_rec.residual_value;
4720: END IF;
4721: IF (x_tqlv_rec.unbilled_receivables = OKC_API.G_MISS_NUM)

Line 4719: x_tqlv_rec.residual_value := l_tqlv_rec.residual_value;

4715: x_tqlv_rec.asset_value := l_tqlv_rec.asset_value;
4716: END IF;
4717: IF (x_tqlv_rec.residual_value = OKC_API.G_MISS_NUM)
4718: THEN
4719: x_tqlv_rec.residual_value := l_tqlv_rec.residual_value;
4720: END IF;
4721: IF (x_tqlv_rec.unbilled_receivables = OKC_API.G_MISS_NUM)
4722: THEN
4723: x_tqlv_rec.unbilled_receivables := l_tqlv_rec.unbilled_receivables;