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

Line 1602: -- Procedure Name : validate_residual_amount

1598: END validate_principal_paydown_amt;
1599:
1600: -- Start of comments
1601: --
1602: -- Procedure Name : validate_residual_amount
1603: -- Description :
1604: -- Business Rules :
1605: -- Parameters :
1606: -- Version : 1.0

Line 1608: PROCEDURE validate_residual_amount(p_qtev_rec IN qtev_rec_type

1604: -- Business Rules :
1605: -- Parameters :
1606: -- Version : 1.0
1607: -- End of comments
1608: PROCEDURE validate_residual_amount(p_qtev_rec IN qtev_rec_type
1609: ,x_return_status OUT NOCOPY VARCHAR2) IS
1610:
1611: BEGIN
1612: -- initialize return status

Line 1631: END validate_residual_amount;

1627:
1628: -- notify caller of an UNEXPECTED error
1629: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1630:
1631: END validate_residual_amount;
1632:
1633: -- Start of comments
1634: --
1635: -- Procedure Name : validate_yield

Line 2632: validate_residual_amount( p_qtev_rec => p_qtev_rec

2628: x_return_status := l_return_status;
2629: END IF;
2630: END IF;
2631:
2632: validate_residual_amount( p_qtev_rec => p_qtev_rec
2633: ,x_return_status => l_return_status);
2634: -- store the highest degree of error
2635: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2636: IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2988: RESIDUAL_AMOUNT,

2984: DATE_RESTRUCTURE_END,
2985: REMAINING_PAYMENTS,
2986: RENT_AMOUNT,
2987: YIELD,
2988: RESIDUAL_AMOUNT,
2989: PRINCIPAL_PAYDOWN_AMOUNT,
2990: PAYMENT_FREQUENCY,
2991: EARLY_TERMINATION_YN,
2992: PARTIAL_YN,

Line 3035: RESIDUAL_VALUE,

3031: LAST_UPDATE_LOGIN,
3032: PURCHASE_AMOUNT,
3033: PURCHASE_FORMULA,
3034: ASSET_VALUE,
3035: RESIDUAL_VALUE,
3036: UNBILLED_RECEIVABLES,
3037: GAIN_LOSS,
3038: -- BAKUCHIB 2667636 Start
3039: CURRENCY_CODE,

Line 3080: l_qte_rec.RESIDUAL_AMOUNT,

3076: l_qte_rec.DATE_RESTRUCTURE_END,
3077: l_qte_rec.REMAINING_PAYMENTS,
3078: l_qte_rec.RENT_AMOUNT,
3079: l_qte_rec.YIELD,
3080: l_qte_rec.RESIDUAL_AMOUNT,
3081: l_qte_rec.PRINCIPAL_PAYDOWN_AMOUNT,
3082: l_qte_rec.PAYMENT_FREQUENCY,
3083: l_qte_rec.EARLY_TERMINATION_YN,
3084: l_qte_rec.PARTIAL_YN,

Line 3127: l_qte_rec.RESIDUAL_VALUE,

3123: l_qte_rec.LAST_UPDATE_LOGIN,
3124: l_qte_rec.PURCHASE_AMOUNT,
3125: l_qte_rec.PURCHASE_FORMULA,
3126: l_qte_rec.ASSET_VALUE,
3127: l_qte_rec.RESIDUAL_VALUE,
3128: l_qte_rec.UNBILLED_RECEIVABLES,
3129: l_qte_rec.GAIN_LOSS,
3130: -- BAKUCHIB 2667636 Start
3131: l_qte_rec.CURRENCY_CODE,

Line 3248: RESIDUAL_AMOUNT,

3244: DATE_ACCEPTED,
3245: SUMMARY_FORMAT_YN,
3246: CONSOLIDATED_YN,
3247: PRINCIPAL_PAYDOWN_AMOUNT,
3248: RESIDUAL_AMOUNT,
3249: YIELD,
3250: RENT_AMOUNT,
3251: DATE_RESTRUCTURE_END,
3252: DATE_RESTRUCTURE_START,

Line 3297: RESIDUAL_VALUE,

3293: LAST_UPDATE_LOGIN,
3294: PURCHASE_AMOUNT,
3295: PURCHASE_FORMULA,
3296: ASSET_VALUE,
3297: RESIDUAL_VALUE,
3298: UNBILLED_RECEIVABLES,
3299: GAIN_LOSS,
3300: -- BAKUCHIB 2667636 Start
3301: CURRENCY_CODE,

Line 3342: l_qtev_rec.RESIDUAL_AMOUNT,

3338: l_qtev_rec.DATE_ACCEPTED,
3339: l_qtev_rec.SUMMARY_FORMAT_YN,
3340: l_qtev_rec.CONSOLIDATED_YN,
3341: l_qtev_rec.PRINCIPAL_PAYDOWN_AMOUNT,
3342: l_qtev_rec.RESIDUAL_AMOUNT,
3343: l_qtev_rec.YIELD,
3344: l_qtev_rec.RENT_AMOUNT,
3345: l_qtev_rec.DATE_RESTRUCTURE_END,
3346: l_qtev_rec.DATE_RESTRUCTURE_START,

Line 3391: l_qtev_rec.RESIDUAL_VALUE,

3387: l_qtev_rec.LAST_UPDATE_LOGIN,
3388: l_qtev_rec.PURCHASE_AMOUNT,
3389: l_qtev_rec.PURCHASE_FORMULA,
3390: l_qtev_rec.ASSET_VALUE,
3391: l_qtev_rec.RESIDUAL_VALUE,
3392: l_qtev_rec.UNBILLED_RECEIVABLES,
3393: l_qtev_rec.GAIN_LOSS,
3394: -- BAKUCHIB 2667636 Start
3395: l_qtev_rec.CURRENCY_CODE,

Line 3502: IF (l_qtev_rec.residual_amount = OKC_API.G_MISS_NUM) THEN

3498: END IF;
3499: IF (l_qtev_rec.principal_paydown_amount = OKC_API.G_MISS_NUM) THEN
3500: l_qtev_rec.principal_paydown_amount := NULL;
3501: END IF;
3502: IF (l_qtev_rec.residual_amount = OKC_API.G_MISS_NUM) THEN
3503: l_qtev_rec.residual_amount := NULL;
3504: END IF;
3505: IF (l_qtev_rec.yield = OKC_API.G_MISS_NUM) THEN
3506: l_qtev_rec.yield := NULL;

Line 3503: l_qtev_rec.residual_amount := NULL;

3499: IF (l_qtev_rec.principal_paydown_amount = OKC_API.G_MISS_NUM) THEN
3500: l_qtev_rec.principal_paydown_amount := NULL;
3501: END IF;
3502: IF (l_qtev_rec.residual_amount = OKC_API.G_MISS_NUM) THEN
3503: l_qtev_rec.residual_amount := NULL;
3504: END IF;
3505: IF (l_qtev_rec.yield = OKC_API.G_MISS_NUM) THEN
3506: l_qtev_rec.yield := NULL;
3507: END IF;

Line 3651: IF (l_qtev_rec.residual_value = OKC_API.G_MISS_NUM) THEN

3647: END IF;
3648: IF (l_qtev_rec.asset_value = OKC_API.G_MISS_NUM) THEN
3649: l_qtev_rec.asset_value := NULL;
3650: END IF;
3651: IF (l_qtev_rec.residual_value = OKC_API.G_MISS_NUM) THEN
3652: l_qtev_rec.residual_value := NULL;
3653: END IF;
3654: IF (l_qtev_rec.unbilled_receivables = OKC_API.G_MISS_NUM) THEN
3655: l_qtev_rec.unbilled_receivables := NULL;

Line 3652: l_qtev_rec.residual_value := NULL;

3648: IF (l_qtev_rec.asset_value = OKC_API.G_MISS_NUM) THEN
3649: l_qtev_rec.asset_value := NULL;
3650: END IF;
3651: IF (l_qtev_rec.residual_value = OKC_API.G_MISS_NUM) THEN
3652: l_qtev_rec.residual_value := NULL;
3653: END IF;
3654: IF (l_qtev_rec.unbilled_receivables = OKC_API.G_MISS_NUM) THEN
3655: l_qtev_rec.unbilled_receivables := NULL;
3656: END IF;

Line 4349: p_to.residual_amount := p_from.residual_amount;

4345: p_to.date_restructure_end := p_from.date_restructure_end;
4346: p_to.remaining_payments := p_from.remaining_payments;
4347: p_to.rent_amount := p_from.rent_amount;
4348: p_to.yield := p_from.yield;
4349: p_to.residual_amount := p_from.residual_amount;
4350: p_to.principal_paydown_amount := p_from.principal_paydown_amount;
4351: p_to.payment_frequency := p_from.payment_frequency;
4352: p_to.early_termination_yn := p_from.early_termination_yn;
4353: p_to.partial_yn := p_from.partial_yn;

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

4392: p_to.last_update_login := p_from.last_update_login;
4393: p_to.purchase_amount := p_from.purchase_amount;
4394: p_to.purchase_formula := p_from.purchase_formula;
4395: p_to.asset_value := p_from.asset_value;
4396: p_to.residual_value := p_from.residual_value;
4397: p_to.unbilled_receivables := p_from.unbilled_receivables;
4398: p_to.gain_loss := p_from.gain_loss;
4399: -- BAKUCHIB 2667636 Start
4400: p_to.currency_code := p_from.currency_code;

Line 4453: p_to.residual_amount := p_from.residual_amount;

4449: p_to.date_restructure_end := p_from.date_restructure_end;
4450: p_to.remaining_payments := p_from.remaining_payments;
4451: p_to.rent_amount := p_from.rent_amount;
4452: p_to.yield := p_from.yield;
4453: p_to.residual_amount := p_from.residual_amount;
4454: p_to.principal_paydown_amount := p_from.principal_paydown_amount;
4455: p_to.payment_frequency := p_from.payment_frequency;
4456: p_to.early_termination_yn := p_from.early_termination_yn;
4457: p_to.partial_yn := p_from.partial_yn;

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

4496: p_to.last_update_login := p_from.last_update_login;
4497: p_to.purchase_amount := p_from.purchase_amount;
4498: p_to.purchase_formula := p_from.purchase_formula;
4499: p_to.asset_value := p_from.asset_value;
4500: p_to.residual_value := p_from.residual_value;
4501: p_to.unbilled_receivables := p_from.unbilled_receivables;
4502: p_to.gain_loss := p_from.gain_loss;
4503: --BAKUCHIB 2667636 Start
4504: p_to.currency_code := p_from.currency_code;

Line 4781: residual_amount,

4777: date_restructure_end,
4778: remaining_payments,
4779: rent_amount,
4780: yield,
4781: residual_amount,
4782: principal_paydown_amount,
4783: payment_frequency,
4784: early_termination_yn,
4785: partial_yn,

Line 4828: residual_value,

4824: last_update_login,
4825: purchase_amount,
4826: purchase_formula,
4827: asset_value,
4828: residual_value,
4829: unbilled_receivables,
4830: gain_loss,
4831: -- BAKUCHIB 2667636 Start
4832: currency_code,

Line 4866: l_qte_rec.residual_amount,

4862: l_qte_rec.date_restructure_end,
4863: l_qte_rec.remaining_payments,
4864: l_qte_rec.rent_amount,
4865: l_qte_rec.yield,
4866: l_qte_rec.residual_amount,
4867: l_qte_rec.principal_paydown_amount,
4868: l_qte_rec.payment_frequency,
4869: l_qte_rec.early_termination_yn,
4870: l_qte_rec.partial_yn,

Line 4919: l_qte_rec.residual_value,

4915: l_qte_rec.last_update_login,
4916: l_qte_rec.purchase_amount,
4917: l_qte_rec.purchase_formula,
4918: l_qte_rec.asset_value,
4919: l_qte_rec.residual_value,
4920: l_qte_rec.unbilled_receivables,
4921: l_qte_rec.gain_loss,
4922: -- BAKUCHIB 2667636 Start
4923: l_qte_rec.currency_code,

Line 5225: SELECT OKL_QTE_SEQ.NEXTVAL INTO l_def_qtev_rec.quote_number FROM DUAL;

5221: END IF;
5222: l_def_qtev_rec := fill_who_columns(l_def_qtev_rec);
5223:
5224: -- Added the sequence to pick the quote_number
5225: SELECT OKL_QTE_SEQ.NEXTVAL INTO l_def_qtev_rec.quote_number FROM DUAL;
5226:
5227: --- Validate all non-missing attributes (Item Level Validation)
5228: l_return_status := Validate_Attributes(l_def_qtev_rec);
5229: --- If any errors happen abort API

Line 5917: IF (x_qte_rec.residual_amount = OKC_API.G_MISS_NUM)

5913: IF (x_qte_rec.yield = OKC_API.G_MISS_NUM)
5914: THEN
5915: x_qte_rec.yield := l_qte_rec.yield;
5916: END IF;
5917: IF (x_qte_rec.residual_amount = OKC_API.G_MISS_NUM)
5918: THEN
5919: x_qte_rec.residual_amount := l_qte_rec.residual_amount;
5920: END IF;
5921: IF (x_qte_rec.principal_paydown_amount = OKC_API.G_MISS_NUM)

Line 5919: x_qte_rec.residual_amount := l_qte_rec.residual_amount;

5915: x_qte_rec.yield := l_qte_rec.yield;
5916: END IF;
5917: IF (x_qte_rec.residual_amount = OKC_API.G_MISS_NUM)
5918: THEN
5919: x_qte_rec.residual_amount := l_qte_rec.residual_amount;
5920: END IF;
5921: IF (x_qte_rec.principal_paydown_amount = OKC_API.G_MISS_NUM)
5922: THEN
5923: x_qte_rec.principal_paydown_amount := l_qte_rec.principal_paydown_amount;

Line 6105: IF (x_qte_rec.residual_value = OKC_API.G_MISS_NUM) OR (x_qte_rec.residual_value IS NULL)

6101: IF (x_qte_rec.asset_value = OKC_API.G_MISS_NUM) OR (x_qte_rec.asset_value IS NULL)
6102: THEN
6103: x_qte_rec.asset_value := l_qte_rec.asset_value;
6104: END IF;
6105: IF (x_qte_rec.residual_value = OKC_API.G_MISS_NUM) OR (x_qte_rec.residual_value IS NULL)
6106: THEN
6107: x_qte_rec.residual_value := l_qte_rec.residual_value;
6108: END IF;
6109: IF (x_qte_rec.unbilled_receivables = OKC_API.G_MISS_NUM) OR (x_qte_rec.unbilled_receivables IS NULL)

Line 6107: x_qte_rec.residual_value := l_qte_rec.residual_value;

6103: x_qte_rec.asset_value := l_qte_rec.asset_value;
6104: END IF;
6105: IF (x_qte_rec.residual_value = OKC_API.G_MISS_NUM) OR (x_qte_rec.residual_value IS NULL)
6106: THEN
6107: x_qte_rec.residual_value := l_qte_rec.residual_value;
6108: END IF;
6109: IF (x_qte_rec.unbilled_receivables = OKC_API.G_MISS_NUM) OR (x_qte_rec.unbilled_receivables IS NULL)
6110: THEN
6111: x_qte_rec.unbilled_receivables := l_qte_rec.unbilled_receivables;

Line 6218: RESIDUAL_AMOUNT = l_def_qte_rec.residual_amount,

6214: DATE_RESTRUCTURE_END = l_def_qte_rec.date_restructure_end,
6215: REMAINING_PAYMENTS = l_def_qte_rec.remaining_payments,
6216: RENT_AMOUNT = l_def_qte_rec.rent_amount,
6217: YIELD = l_def_qte_rec.yield,
6218: RESIDUAL_AMOUNT = l_def_qte_rec.residual_amount,
6219: PRINCIPAL_PAYDOWN_AMOUNT = l_def_qte_rec.principal_paydown_amount,
6220: PAYMENT_FREQUENCY = l_def_qte_rec.payment_frequency,
6221: EARLY_TERMINATION_YN = l_def_qte_rec.early_termination_yn,
6222: PARTIAL_YN = l_def_qte_rec.partial_yn,

Line 6275: RESIDUAL_VALUE = l_def_qte_rec.residual_value,

6271: LAST_UPDATE_LOGIN = l_def_qte_rec.last_update_login,
6272: PURCHASE_AMOUNT = l_def_qte_rec.purchase_amount,
6273: PURCHASE_FORMULA = l_def_qte_rec.purchase_formula,
6274: ASSET_VALUE = l_def_qte_rec.asset_value,
6275: RESIDUAL_VALUE = l_def_qte_rec.residual_value,
6276: UNBILLED_RECEIVABLES = l_def_qte_rec.unbilled_receivables,
6277: GAIN_LOSS = l_def_qte_rec.gain_loss,
6278: -- BAKCUHIUB 2667636 Start
6279: CURRENCY_CODE = l_def_qte_rec.currency_code,

Line 6655: IF (x_qtev_rec.residual_amount = OKC_API.G_MISS_NUM)

6651: IF (x_qtev_rec.principal_paydown_amount = OKC_API.G_MISS_NUM)
6652: THEN
6653: x_qtev_rec.principal_paydown_amount := l_qtev_rec.principal_paydown_amount;
6654: END IF;
6655: IF (x_qtev_rec.residual_amount = OKC_API.G_MISS_NUM)
6656: THEN
6657: x_qtev_rec.residual_amount := l_qtev_rec.residual_amount;
6658: END IF;
6659: IF (x_qtev_rec.yield = OKC_API.G_MISS_NUM)

Line 6657: x_qtev_rec.residual_amount := l_qtev_rec.residual_amount;

6653: x_qtev_rec.principal_paydown_amount := l_qtev_rec.principal_paydown_amount;
6654: END IF;
6655: IF (x_qtev_rec.residual_amount = OKC_API.G_MISS_NUM)
6656: THEN
6657: x_qtev_rec.residual_amount := l_qtev_rec.residual_amount;
6658: END IF;
6659: IF (x_qtev_rec.yield = OKC_API.G_MISS_NUM)
6660: THEN
6661: x_qtev_rec.yield := l_qtev_rec.yield;

Line 6851: IF (x_qtev_rec.residual_value = OKC_API.G_MISS_NUM) OR (x_qtev_rec.residual_value IS NULL)

6847: IF (x_qtev_rec.asset_value = OKC_API.G_MISS_NUM) OR (x_qtev_rec.asset_value IS NULL)
6848: THEN
6849: x_qtev_rec.asset_value := l_qtev_rec.asset_value ;
6850: END IF;
6851: IF (x_qtev_rec.residual_value = OKC_API.G_MISS_NUM) OR (x_qtev_rec.residual_value IS NULL)
6852: THEN
6853: x_qtev_rec.residual_value := l_qtev_rec.residual_value;
6854: END IF;
6855: IF (x_qtev_rec.unbilled_receivables = OKC_API.G_MISS_NUM) OR (x_qtev_rec.unbilled_receivables IS NULL)

Line 6853: x_qtev_rec.residual_value := l_qtev_rec.residual_value;

6849: x_qtev_rec.asset_value := l_qtev_rec.asset_value ;
6850: END IF;
6851: IF (x_qtev_rec.residual_value = OKC_API.G_MISS_NUM) OR (x_qtev_rec.residual_value IS NULL)
6852: THEN
6853: x_qtev_rec.residual_value := l_qtev_rec.residual_value;
6854: END IF;
6855: IF (x_qtev_rec.unbilled_receivables = OKC_API.G_MISS_NUM) OR (x_qtev_rec.unbilled_receivables IS NULL)
6856: THEN
6857: x_qtev_rec.unbilled_receivables := l_qtev_rec.unbilled_receivables;