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_SEC_AGREEMENT_PVT dependencies on FND_LOOKUPS

Line 208: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS

204: FROM okl_trx_types_tl
205: WHERE name = p_transaction_type
206: AND LANGUAGE = 'US';
207:
208: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS
209: SELECT description,
210: lookup_code
211: FROM fnd_lookup_values
212: WHERE LANGUAGE = 'US'

Line 244: l_fnd_rec fnd_lookups_csr%ROWTYPE;

240:
241: -- Cursor Types
242: l_Product_rec Product_csr%ROWTYPE;
243: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;
244: l_fnd_rec fnd_lookups_csr%ROWTYPE;
245: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;
246: l_trx_rec trx_csr%ROWTYPE;
247: l_special_acct_rec special_acct_rec_csr%ROWTYPE;
248:

Line 245: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;

241: -- Cursor Types
242: l_Product_rec Product_csr%ROWTYPE;
243: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;
244: l_fnd_rec fnd_lookups_csr%ROWTYPE;
245: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;
246: l_trx_rec trx_csr%ROWTYPE;
247: l_special_acct_rec special_acct_rec_csr%ROWTYPE;
248:
249: l_transaction_type VARCHAR2(256) := p_transaction_type;

Line 278: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

274: l_has_trans VARCHAR2(1);
275: l_trx_desc VARCHAR2(2000);
276:
277: --Bug# 4622198
278: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
279: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
280: --Bug# 4622198
281: --
282: --Added by kthiruva for Bug 6354647

Line 410: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);

406: RAISE Okl_Api.G_EXCEPTION_ERROR;
407: END IF;
408: CLOSE Transaction_Type_csr;
409:
410: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
411: FETCH fnd_lookups_csr INTO l_fnd_rec;
412: IF fnd_lookups_csr%NOTFOUND THEN
413: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
414: CLOSE fnd_lookups_csr;

Line 411: FETCH fnd_lookups_csr INTO l_fnd_rec;

407: END IF;
408: CLOSE Transaction_Type_csr;
409:
410: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
411: FETCH fnd_lookups_csr INTO l_fnd_rec;
412: IF fnd_lookups_csr%NOTFOUND THEN
413: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
414: CLOSE fnd_lookups_csr;
415: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 412: IF fnd_lookups_csr%NOTFOUND THEN

408: CLOSE Transaction_Type_csr;
409:
410: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
411: FETCH fnd_lookups_csr INTO l_fnd_rec;
412: IF fnd_lookups_csr%NOTFOUND THEN
413: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
414: CLOSE fnd_lookups_csr;
415: RAISE Okl_Api.G_EXCEPTION_ERROR;
416: END IF;

Line 414: CLOSE fnd_lookups_csr;

410: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
411: FETCH fnd_lookups_csr INTO l_fnd_rec;
412: IF fnd_lookups_csr%NOTFOUND THEN
413: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
414: CLOSE fnd_lookups_csr;
415: RAISE Okl_Api.G_EXCEPTION_ERROR;
416: END IF;
417: CLOSE fnd_lookups_csr;
418:

Line 417: CLOSE fnd_lookups_csr;

413: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
414: CLOSE fnd_lookups_csr;
415: RAISE Okl_Api.G_EXCEPTION_ERROR;
416: END IF;
417: CLOSE fnd_lookups_csr;
418:
419: OPEN trx_csr(p_contract_id,l_fnd_rec.lookup_code);
420: FETCH trx_csr INTO l_trx_rec;
421: IF trx_csr%NOTFOUND THEN -- While activation, create a new trans always.

Line 466: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);

462: l_trxH_in_rec.currency_conversion_rate := x_currency_conversion_rate;
463: l_trxH_in_rec.currency_conversion_type := x_currency_conversion_type;
464: l_trxH_in_rec.currency_conversion_date := x_currency_conversion_date;
465:
466: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
467: FETCH fnd_lookups_csr INTO l_fnd_rec1;
468: IF fnd_lookups_csr%NOTFOUND THEN
469: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
470: CLOSE fnd_lookups_csr;

Line 467: FETCH fnd_lookups_csr INTO l_fnd_rec1;

463: l_trxH_in_rec.currency_conversion_type := x_currency_conversion_type;
464: l_trxH_in_rec.currency_conversion_date := x_currency_conversion_date;
465:
466: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
467: FETCH fnd_lookups_csr INTO l_fnd_rec1;
468: IF fnd_lookups_csr%NOTFOUND THEN
469: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
470: CLOSE fnd_lookups_csr;
471: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 468: IF fnd_lookups_csr%NOTFOUND THEN

464: l_trxH_in_rec.currency_conversion_date := x_currency_conversion_date;
465:
466: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
467: FETCH fnd_lookups_csr INTO l_fnd_rec1;
468: IF fnd_lookups_csr%NOTFOUND THEN
469: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
470: CLOSE fnd_lookups_csr;
471: RAISE Okl_Api.G_EXCEPTION_ERROR;
472: END IF;

Line 470: CLOSE fnd_lookups_csr;

466: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
467: FETCH fnd_lookups_csr INTO l_fnd_rec1;
468: IF fnd_lookups_csr%NOTFOUND THEN
469: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
470: CLOSE fnd_lookups_csr;
471: RAISE Okl_Api.G_EXCEPTION_ERROR;
472: END IF;
473: CLOSE fnd_lookups_csr;
474:

Line 473: CLOSE fnd_lookups_csr;

469: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
470: CLOSE fnd_lookups_csr;
471: RAISE Okl_Api.G_EXCEPTION_ERROR;
472: END IF;
473: CLOSE fnd_lookups_csr;
474:
475:
476:
477:

Line 488: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');

484: -- IF ( l_has_trans = OKL_API.G_FALSE ) THEN
485: -- Commenting the above IF condition to create Accounting Header, Lines and Distributions
486: -- Always while activating an agreement
487:
488: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
489: FETCH fnd_lookups_csr INTO l_fnd_rec;
490: IF fnd_lookups_csr%NOTFOUND THEN
491: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
492: CLOSE fnd_lookups_csr;

Line 489: FETCH fnd_lookups_csr INTO l_fnd_rec;

485: -- Commenting the above IF condition to create Accounting Header, Lines and Distributions
486: -- Always while activating an agreement
487:
488: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
489: FETCH fnd_lookups_csr INTO l_fnd_rec;
490: IF fnd_lookups_csr%NOTFOUND THEN
491: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
492: CLOSE fnd_lookups_csr;
493: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 490: IF fnd_lookups_csr%NOTFOUND THEN

486: -- Always while activating an agreement
487:
488: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
489: FETCH fnd_lookups_csr INTO l_fnd_rec;
490: IF fnd_lookups_csr%NOTFOUND THEN
491: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
492: CLOSE fnd_lookups_csr;
493: RAISE Okl_Api.G_EXCEPTION_ERROR;
494: END IF;

Line 492: CLOSE fnd_lookups_csr;

488: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
489: FETCH fnd_lookups_csr INTO l_fnd_rec;
490: IF fnd_lookups_csr%NOTFOUND THEN
491: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
492: CLOSE fnd_lookups_csr;
493: RAISE Okl_Api.G_EXCEPTION_ERROR;
494: END IF;
495: CLOSE fnd_lookups_csr;
496:

Line 495: CLOSE fnd_lookups_csr;

491: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
492: CLOSE fnd_lookups_csr;
493: RAISE Okl_Api.G_EXCEPTION_ERROR;
494: END IF;
495: CLOSE fnd_lookups_csr;
496:
497: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
498:
499: l_trxH_in_rec.date_transaction_occurred := l_transaction_date;

Line 769: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');

765: END LOOP;
766:
767: l_trxH_in_rec.currency_code := l_currency_code;
768:
769: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
770: FETCH fnd_lookups_csr INTO l_fnd_rec;
771: IF fnd_lookups_csr%NOTFOUND THEN
772: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
773: CLOSE fnd_lookups_csr;

Line 770: FETCH fnd_lookups_csr INTO l_fnd_rec;

766:
767: l_trxH_in_rec.currency_code := l_currency_code;
768:
769: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
770: FETCH fnd_lookups_csr INTO l_fnd_rec;
771: IF fnd_lookups_csr%NOTFOUND THEN
772: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
773: CLOSE fnd_lookups_csr;
774: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 771: IF fnd_lookups_csr%NOTFOUND THEN

767: l_trxH_in_rec.currency_code := l_currency_code;
768:
769: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
770: FETCH fnd_lookups_csr INTO l_fnd_rec;
771: IF fnd_lookups_csr%NOTFOUND THEN
772: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
773: CLOSE fnd_lookups_csr;
774: RAISE Okl_Api.G_EXCEPTION_ERROR;
775: END IF;

Line 773: CLOSE fnd_lookups_csr;

769: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
770: FETCH fnd_lookups_csr INTO l_fnd_rec;
771: IF fnd_lookups_csr%NOTFOUND THEN
772: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
773: CLOSE fnd_lookups_csr;
774: RAISE Okl_Api.G_EXCEPTION_ERROR;
775: END IF;
776: CLOSE fnd_lookups_csr;
777: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;

Line 776: CLOSE fnd_lookups_csr;

772: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
773: CLOSE fnd_lookups_csr;
774: RAISE Okl_Api.G_EXCEPTION_ERROR;
775: END IF;
776: CLOSE fnd_lookups_csr;
777: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
778:
779: ELSE
780:

Line 781: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');

777: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
778:
779: ELSE
780:
781: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
782: FETCH fnd_lookups_csr INTO l_fnd_rec;
783: IF fnd_lookups_csr%NOTFOUND THEN
784: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
785: CLOSE fnd_lookups_csr;

Line 782: FETCH fnd_lookups_csr INTO l_fnd_rec;

778:
779: ELSE
780:
781: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
782: FETCH fnd_lookups_csr INTO l_fnd_rec;
783: IF fnd_lookups_csr%NOTFOUND THEN
784: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
785: CLOSE fnd_lookups_csr;
786: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 783: IF fnd_lookups_csr%NOTFOUND THEN

779: ELSE
780:
781: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
782: FETCH fnd_lookups_csr INTO l_fnd_rec;
783: IF fnd_lookups_csr%NOTFOUND THEN
784: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
785: CLOSE fnd_lookups_csr;
786: RAISE Okl_Api.G_EXCEPTION_ERROR;
787: END IF;

Line 785: CLOSE fnd_lookups_csr;

781: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
782: FETCH fnd_lookups_csr INTO l_fnd_rec;
783: IF fnd_lookups_csr%NOTFOUND THEN
784: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
785: CLOSE fnd_lookups_csr;
786: RAISE Okl_Api.G_EXCEPTION_ERROR;
787: END IF;
788: CLOSE fnd_lookups_csr;
789: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;

Line 788: CLOSE fnd_lookups_csr;

784: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
785: CLOSE fnd_lookups_csr;
786: RAISE Okl_Api.G_EXCEPTION_ERROR;
787: END IF;
788: CLOSE fnd_lookups_csr;
789: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
790: l_trxH_in_rec.amount := NULL;
791: FOR i in l_tclv_tbl.FIRST..l_tclv_tbl.LAST
792: LOOP

Line 1264: FROM fnd_lookups

1260: l_row_found BOOLEAN := FALSE;
1261:
1262: CURSOR c_sec_type IS
1263: SELECT 'x'
1264: FROM fnd_lookups
1265: WHERE lookup_type = 'OKL_SECURITIZATION_TYPE'
1266: AND lookup_code = p_secAgreement_rec.SECURITIZATION_TYPE
1267: ;
1268:

Line 1333: FROM fnd_lookups

1329: l_row_not_found BOOLEAN := FALSE;
1330:
1331: CURSOR c_rcs IS
1332: SELECT 'x'
1333: FROM fnd_lookups
1334: WHERE lookup_type = 'OKL_SEC_RECOURSE'
1335: ;
1336:
1337: BEGIN

Line 1387: FROM fnd_lookups

1383: l_row_not_found BOOLEAN := FALSE;
1384:
1385: CURSOR c_serv IS
1386: SELECT 'x'
1387: FROM fnd_lookups
1388: WHERE lookup_type = 'OKL_SEC_SERVICE_ORG'
1389: ;
1390:
1391: BEGIN

Line 4066: l_approval_process fnd_lookups.lookup_code%TYPE;

4062: l_pool_id OKL_POOLS.ID%TYPE;
4063: l_pool_trans_id OKL_POOL_TRANSACTIONS.ID%TYPE;
4064: lp_poxv_rec poxv_rec_type;
4065: lx_poxv_rec poxv_rec_type;
4066: l_approval_process fnd_lookups.lookup_code%TYPE;
4067: l_msg_data VARCHAR2(2000);
4068: l_msg_count NUMBER;
4069:
4070: BEGIN