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

Line 12: G_STY_INV_RESIDUAL_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RESIDUAL_BUYBACK';

8: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
9: G_FINAL_DATE CONSTANT DATE := Okl_Pool_Pvt.G_FINAL_DATE;
10:
11: G_STY_INV_RENT_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RENT_BUYBACK';
12: G_STY_INV_RESIDUAL_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RESIDUAL_BUYBACK';
13: G_STY_SUBCLASS_RENT CONSTANT VARCHAR2(4) := 'RENT';
14: G_STY_SUBCLASS_RESIDUAL CONSTANT VARCHAR2(10) := 'RESIDUAL';
15: G_STM_SGN_CODE_MANUAL CONSTANT VARCHAR2(4) := 'MANL';
16: G_STM_SAY_CODE_CURR CONSTANT VARCHAR2(4) := 'CURR';

Line 14: G_STY_SUBCLASS_RESIDUAL CONSTANT VARCHAR2(10) := 'RESIDUAL';

10:
11: G_STY_INV_RENT_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RENT_BUYBACK';
12: G_STY_INV_RESIDUAL_BUYBACK CONSTANT VARCHAR2(30) := 'INVESTOR_RESIDUAL_BUYBACK';
13: G_STY_SUBCLASS_RENT CONSTANT VARCHAR2(4) := 'RENT';
14: G_STY_SUBCLASS_RESIDUAL CONSTANT VARCHAR2(10) := 'RESIDUAL';
15: G_STM_SGN_CODE_MANUAL CONSTANT VARCHAR2(4) := 'MANL';
16: G_STM_SAY_CODE_CURR CONSTANT VARCHAR2(4) := 'CURR';
17: G_STM_ACTIVE_Y CONSTANT VARCHAR2(1) := 'Y';
18: G_STM_SOURCE_TABLE CONSTANT VARCHAR2(15) := 'OKL_K_HEADERS';

Line 2355: IF (l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_RESIDUAL OR l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_LOAN_PAYMENT)

2351: lp_pocv_rec.transaction_number_out := lx_poxv_rec.transaction_number;
2352: lp_pocv_rec.status_code := G_POC_STS_INACTIVE;
2353:
2354: l_rv_date_updated := FALSE;
2355: IF (l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_RESIDUAL OR l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_LOAN_PAYMENT)
2356: THEN
2357: IF ( lp_poxv_rec.transaction_reason = G_TRX_REASON_ASSET_DISPOSAL
2358: OR lp_poxv_rec.transaction_reason = G_TRX_REASON_PURCHASE
2359: OR lp_poxv_rec.transaction_reason = G_TRX_REASON_REPURCHASE

Line 2408: ankushar --Bug 6594724: Unable to terminate Investor Agreement with Residual Streams

2404: AND l_okl_poc_rec.streams_from_date <= SYSDATE )
2405: THEN
2406: l_create := TRUE;
2407: /*
2408: ankushar --Bug 6594724: Unable to terminate Investor Agreement with Residual Streams
2409: Start changes
2410: */
2411: IF (l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_RESIDUAL) THEN
2412: FOR l_okl_khr_rec IN l_okl_khr_csr

Line 2411: IF (l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_RESIDUAL) THEN

2407: /*
2408: ankushar --Bug 6594724: Unable to terminate Investor Agreement with Residual Streams
2409: Start changes
2410: */
2411: IF (l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_RESIDUAL) THEN
2412: FOR l_okl_khr_rec IN l_okl_khr_csr
2413: LOOP
2414: IF (l_okl_khr_rec.sts_code IN ('TERMINATED','EXPIRED')) THEN
2415: l_create := FALSE;

Line 2435: -- residual poc-s , while created, always have null end date

2431: lp_pocv_rec_cre.sty_id := l_okl_poc_rec.sty_id;
2432: lp_pocv_rec_cre.sty_code := l_okl_poc_rec.sty_code;
2433: lp_pocv_rec_cre.streams_from_date := l_okl_poc_rec.streams_from_date;
2434:
2435: -- residual poc-s , while created, always have null end date
2436: IF l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_RESIDUAL
2437: THEN
2438: lp_pocv_rec_cre.streams_to_date := NULL;
2439: ELSIF p_streams_to_date IS NOT NULL THEN

Line 2436: IF l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_RESIDUAL

2432: lp_pocv_rec_cre.sty_code := l_okl_poc_rec.sty_code;
2433: lp_pocv_rec_cre.streams_from_date := l_okl_poc_rec.streams_from_date;
2434:
2435: -- residual poc-s , while created, always have null end date
2436: IF l_okl_poc_rec.stream_type_subclass = G_STY_SUBCLASS_RESIDUAL
2437: THEN
2438: lp_pocv_rec_cre.streams_to_date := NULL;
2439: ELSIF p_streams_to_date IS NOT NULL THEN
2440: lp_pocv_rec_cre.streams_to_date := p_streams_to_date;

Line 2765: -- These are residual value streams

2761: p_transaction_reason = G_TRX_REASON_SCRAP OR
2762: p_transaction_reason = G_TRX_REASON_REMARKET
2763: )
2764: THEN
2765: -- These are residual value streams
2766: --
2767: IF (p_transaction_reason = G_TRX_REASON_ASSET_DISPOSAL
2768: AND p_kle_id IS NULL) THEN
2769: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 3155: FROM dual;

3151: -- To get the Transaction Number for Streams
3152: CURSOR l_okl_seq_csr
3153: IS
3154: SELECT okl_sif_seq.NEXTVAL transaction_number
3155: FROM dual;
3156:
3157: lp_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3158: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
3159: lp_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 3186: ELSIF p_stream_type_subclass = G_STY_SUBCLASS_RESIDUAL THEN

3182: END IF;
3183:
3184: IF p_stream_type_subclass = G_STY_SUBCLASS_RENT THEN
3185: l_sty_purpose := G_STY_INV_RENT_BUYBACK;
3186: ELSIF p_stream_type_subclass = G_STY_SUBCLASS_RESIDUAL THEN
3187: l_sty_purpose := G_STY_INV_RESIDUAL_BUYBACK ;
3188: /* ankushar Bug#6740000 20-Jan-2008
3189: Added else clause for LOAN_PAYMENT subclass
3190: */

Line 3187: l_sty_purpose := G_STY_INV_RESIDUAL_BUYBACK ;

3183:
3184: IF p_stream_type_subclass = G_STY_SUBCLASS_RENT THEN
3185: l_sty_purpose := G_STY_INV_RENT_BUYBACK;
3186: ELSIF p_stream_type_subclass = G_STY_SUBCLASS_RESIDUAL THEN
3187: l_sty_purpose := G_STY_INV_RESIDUAL_BUYBACK ;
3188: /* ankushar Bug#6740000 20-Jan-2008
3189: Added else clause for LOAN_PAYMENT subclass
3190: */
3191: ELSIF p_stream_type_subclass = G_STY_SUBCLASS_LOAN_PAYMENT THEN