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

Line 1365: p_styv_rec.stream_type_purpose = 'INVESTOR_RESIDUAL_PAY' OR

1361: END IF;
1362:
1363: --Bug # 6740000 ssdeshpa Changed Start
1364: IF (((p_styv_rec.stream_type_purpose = 'INVESTOR_CNTRCT_OBLIGATION_PAY' OR
1365: p_styv_rec.stream_type_purpose = 'INVESTOR_RESIDUAL_PAY' OR
1366: p_styv_rec.stream_type_purpose = 'INVESTOR_LATE_FEE_PAYABLE' OR
1367: p_styv_rec.stream_type_purpose = 'INVESTOR_RENT_BUYBACK' OR
1368: p_styv_rec.stream_type_purpose = 'INVESTOR_RESIDUAL_BUYBACK' OR
1369: p_styv_rec.stream_type_purpose = 'INVESTOR_DISB_ADJUSTMENT' OR

Line 1368: p_styv_rec.stream_type_purpose = 'INVESTOR_RESIDUAL_BUYBACK' OR

1364: IF (((p_styv_rec.stream_type_purpose = 'INVESTOR_CNTRCT_OBLIGATION_PAY' OR
1365: p_styv_rec.stream_type_purpose = 'INVESTOR_RESIDUAL_PAY' OR
1366: p_styv_rec.stream_type_purpose = 'INVESTOR_LATE_FEE_PAYABLE' OR
1367: p_styv_rec.stream_type_purpose = 'INVESTOR_RENT_BUYBACK' OR
1368: p_styv_rec.stream_type_purpose = 'INVESTOR_RESIDUAL_BUYBACK' OR
1369: p_styv_rec.stream_type_purpose = 'INVESTOR_DISB_ADJUSTMENT' OR
1370: p_styv_rec.stream_type_purpose = 'INVESTOR_EVERGREEN_RENT_PAY' OR
1371: p_styv_rec.stream_type_purpose = 'INVESTOR_LATE_INTEREST_PAY' OR
1372: p_styv_rec.stream_type_purpose = 'INVESTOR_PRINCIPAL_BUYBACK' OR

Line 1389: IF (p_styv_rec.stream_type_purpose = 'RESIDUAL_VALUE' AND

1385: -- raise the exception as there's no matching foreign key value
1386: RAISE G_EXCEPTION_HALT_VALIDATION;
1387: END IF;
1388:
1389: IF (p_styv_rec.stream_type_purpose = 'RESIDUAL_VALUE' AND
1390: (p_styv_rec.stream_type_subclass IS NULL OR
1391: p_styv_rec.stream_type_subclass <> 'RESIDUAL')) THEN
1392: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Stream_Type_SubClass');
1393: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1391: p_styv_rec.stream_type_subclass <> 'RESIDUAL')) THEN

1387: END IF;
1388:
1389: IF (p_styv_rec.stream_type_purpose = 'RESIDUAL_VALUE' AND
1390: (p_styv_rec.stream_type_subclass IS NULL OR
1391: p_styv_rec.stream_type_subclass <> 'RESIDUAL')) THEN
1392: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Stream_Type_SubClass');
1393: x_return_status := Okc_Api.G_RET_STS_ERROR;
1394: -- raise the exception as there's no matching foreign key value
1395: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1401: p_styv_rec.stream_type_purpose <> 'RESIDUAL_VALUE' AND

1397: --Bug # 6740000 ssdeshpa Changed Start
1398:
1399: IF (p_styv_rec.stream_type_purpose <> 'ADVANCE_RENT' AND
1400: p_styv_rec.stream_type_purpose <> 'RENT' AND
1401: p_styv_rec.stream_type_purpose <> 'RESIDUAL_VALUE' AND
1402: p_styv_rec.stream_type_purpose <> 'INVESTOR_CNTRCT_OBLIGATION_PAY' AND
1403: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_PAY' AND
1404: p_styv_rec.stream_type_purpose <> 'INVESTOR_LATE_FEE_PAYABLE' AND
1405: p_styv_rec.stream_type_purpose <> 'INVESTOR_RENT_BUYBACK' AND

Line 1403: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_PAY' AND

1399: IF (p_styv_rec.stream_type_purpose <> 'ADVANCE_RENT' AND
1400: p_styv_rec.stream_type_purpose <> 'RENT' AND
1401: p_styv_rec.stream_type_purpose <> 'RESIDUAL_VALUE' AND
1402: p_styv_rec.stream_type_purpose <> 'INVESTOR_CNTRCT_OBLIGATION_PAY' AND
1403: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_PAY' AND
1404: p_styv_rec.stream_type_purpose <> 'INVESTOR_LATE_FEE_PAYABLE' AND
1405: p_styv_rec.stream_type_purpose <> 'INVESTOR_RENT_BUYBACK' AND
1406: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_BUYBACK' AND
1407: p_styv_rec.stream_type_purpose <> 'INVESTOR_DISB_ADJUSTMENT' AND

Line 1406: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_BUYBACK' AND

1402: p_styv_rec.stream_type_purpose <> 'INVESTOR_CNTRCT_OBLIGATION_PAY' AND
1403: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_PAY' AND
1404: p_styv_rec.stream_type_purpose <> 'INVESTOR_LATE_FEE_PAYABLE' AND
1405: p_styv_rec.stream_type_purpose <> 'INVESTOR_RENT_BUYBACK' AND
1406: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_BUYBACK' AND
1407: p_styv_rec.stream_type_purpose <> 'INVESTOR_DISB_ADJUSTMENT' AND
1408: p_styv_rec.stream_type_purpose <> 'INVESTOR_EVERGREEN_RENT_PAY' AND
1409: p_styv_rec.stream_type_purpose <> 'INVESTOR_LATE_INTEREST_PAY' AND
1410: p_styv_rec.stream_type_purpose <> 'RENEWAL_RENT' AND

Line 1434: p_styv_rec.stream_type_purpose <> 'RESIDUAL_VALUE' AND

1430: -- raise the exception as there's no matching foreign key value
1431: RAISE G_EXCEPTION_HALT_VALIDATION;
1432: ELSIF (p_styv_rec.stream_type_purpose <> 'ADVANCE_RENT' AND
1433: p_styv_rec.stream_type_purpose <> 'RENT' AND
1434: p_styv_rec.stream_type_purpose <> 'RESIDUAL_VALUE' AND
1435: p_styv_rec.stream_type_purpose <> 'INVESTOR_CNTRCT_OBLIGATION_PAY' AND
1436: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_PAY' AND
1437: p_styv_rec.stream_type_purpose <> 'INVESTOR_LATE_FEE_PAYABLE' AND
1438: p_styv_rec.stream_type_purpose <> 'INVESTOR_RENT_BUYBACK' AND

Line 1436: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_PAY' AND

1432: ELSIF (p_styv_rec.stream_type_purpose <> 'ADVANCE_RENT' AND
1433: p_styv_rec.stream_type_purpose <> 'RENT' AND
1434: p_styv_rec.stream_type_purpose <> 'RESIDUAL_VALUE' AND
1435: p_styv_rec.stream_type_purpose <> 'INVESTOR_CNTRCT_OBLIGATION_PAY' AND
1436: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_PAY' AND
1437: p_styv_rec.stream_type_purpose <> 'INVESTOR_LATE_FEE_PAYABLE' AND
1438: p_styv_rec.stream_type_purpose <> 'INVESTOR_RENT_BUYBACK' AND
1439: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_BUYBACK' AND
1440: p_styv_rec.stream_type_purpose <> 'INVESTOR_DISB_ADJUSTMENT' AND

Line 1439: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_BUYBACK' AND

1435: p_styv_rec.stream_type_purpose <> 'INVESTOR_CNTRCT_OBLIGATION_PAY' AND
1436: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_PAY' AND
1437: p_styv_rec.stream_type_purpose <> 'INVESTOR_LATE_FEE_PAYABLE' AND
1438: p_styv_rec.stream_type_purpose <> 'INVESTOR_RENT_BUYBACK' AND
1439: p_styv_rec.stream_type_purpose <> 'INVESTOR_RESIDUAL_BUYBACK' AND
1440: p_styv_rec.stream_type_purpose <> 'INVESTOR_DISB_ADJUSTMENT' AND
1441: p_styv_rec.stream_type_purpose <> 'INVESTOR_EVERGREEN_RENT_PAY' AND
1442: p_styv_rec.stream_type_purpose <> 'INVESTOR_LATE_INTEREST_PAY' AND
1443: p_styv_rec.stream_type_purpose <> 'RENEWAL_RENT' AND

Line 4915: from dual

4911: p_styv_rec.CONTINGENCY,
4912: -- Added by SNANDIKO for Bug 6744584 Start
4913: p_styv_rec.CONTINGENCY_ID
4914: -- Added by SNANDIKO for Bug 6744584 End
4915: from dual
4916: where not exists (select 1
4917: from okl_strm_type_b
4918: where ID = TO_NUMBER(p_styv_rec.ID));
4919: