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 3051: in_residual_value Number14p3TabTyp;

3047: in_yield_name Var150TabTyp;
3048: in_yield_value Number18p15TabTyp;
3049: in_implicit_interest_rate Number18p15TabTyp;
3050: in_asset_value Number14p3TabTyp;
3051: in_residual_value Number14p3TabTyp;
3052: in_unbilled_receivables Number14p3TabTyp;
3053: in_asset_quantity Number14p3TabTyp;
3054: in_quote_quantity Number14p3TabTyp;
3055: in_split_kle_id NumberTabTyp;

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

3222: in_yield_name(j) := l_tqlv_rec.yield_name;
3223: in_yield_value(j) := l_tqlv_rec.yield_value;
3224: in_implicit_interest_rate(j) := l_tqlv_rec.implicit_interest_rate;
3225: in_asset_value(j) := l_tqlv_rec.asset_value;
3226: in_residual_value(j) := l_tqlv_rec.residual_value;
3227: in_unbilled_receivables(j) := l_tqlv_rec.unbilled_receivables;
3228: in_asset_quantity(j) := l_tqlv_rec.asset_quantity;
3229: in_quote_quantity(j) := l_tqlv_rec.quote_quantity;
3230: in_split_kle_id(j) := l_tqlv_rec.split_kle_id;

Line 3323: residual_value,

3319: yield_name,
3320: yield_value,
3321: implicit_interest_rate,
3322: asset_value,
3323: residual_value,
3324: unbilled_receivables,
3325: asset_quantity,
3326: quote_quantity,
3327: split_kle_id,

Line 3384: in_residual_value(i),

3380: in_yield_name(i),
3381: in_yield_value(i),
3382: in_implicit_interest_rate(i),
3383: in_asset_value(i),
3384: in_residual_value(i),
3385: in_unbilled_receivables(i),
3386: in_asset_quantity(i),
3387: in_quote_quantity(i),
3388: in_split_kle_id(i),

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

4077: IF (x_tql_rec.asset_value = OKC_API.G_MISS_NUM)
4078: THEN
4079: x_tql_rec.asset_value := l_tql_rec.asset_value;
4080: END IF;
4081: IF (x_tql_rec.residual_value = OKC_API.G_MISS_NUM)
4082: THEN
4083: x_tql_rec.residual_value := l_tql_rec.residual_value;
4084: END IF;
4085: IF (x_tql_rec.unbilled_receivables = OKC_API.G_MISS_NUM)

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

4079: x_tql_rec.asset_value := l_tql_rec.asset_value;
4080: END IF;
4081: IF (x_tql_rec.residual_value = OKC_API.G_MISS_NUM)
4082: THEN
4083: x_tql_rec.residual_value := l_tql_rec.residual_value;
4084: END IF;
4085: IF (x_tql_rec.unbilled_receivables = OKC_API.G_MISS_NUM)
4086: THEN
4087: x_tql_rec.unbilled_receivables := l_tql_rec.unbilled_receivables;

Line 4231: RESIDUAL_VALUE = l_def_tql_rec.residual_value,

4227: YIELD_NAME = l_def_tql_rec.yield_name,
4228: YIELD_VALUE = l_def_tql_rec.yield_value,
4229: IMPLICIT_INTEREST_RATE = l_def_tql_rec.implicit_interest_rate,
4230: ASSET_VALUE = l_def_tql_rec.asset_value,
4231: RESIDUAL_VALUE = l_def_tql_rec.residual_value,
4232: UNBILLED_RECEIVABLES = l_def_tql_rec.unbilled_receivables,
4233: ASSET_QUANTITY = l_def_tql_rec.asset_quantity,
4234: QUOTE_QUANTITY = l_def_tql_rec.quote_quantity,
4235: SPLIT_KLE_ID = l_def_tql_rec.split_kle_id,

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

4723: IF (x_tqlv_rec.asset_value = OKC_API.G_MISS_NUM)
4724: THEN
4725: x_tqlv_rec.asset_value := l_tqlv_rec.asset_value;
4726: END IF;
4727: IF (x_tqlv_rec.residual_value = OKC_API.G_MISS_NUM)
4728: THEN
4729: x_tqlv_rec.residual_value := l_tqlv_rec.residual_value;
4730: END IF;
4731: IF (x_tqlv_rec.unbilled_receivables = OKC_API.G_MISS_NUM)

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

4725: x_tqlv_rec.asset_value := l_tqlv_rec.asset_value;
4726: END IF;
4727: IF (x_tqlv_rec.residual_value = OKC_API.G_MISS_NUM)
4728: THEN
4729: x_tqlv_rec.residual_value := l_tqlv_rec.residual_value;
4730: END IF;
4731: IF (x_tqlv_rec.unbilled_receivables = OKC_API.G_MISS_NUM)
4732: THEN
4733: x_tqlv_rec.unbilled_receivables := l_tqlv_rec.unbilled_receivables;