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

Line 1119: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

1115:
1116: l_custBillTo_rec custBillTo_csr%ROWTYPE;
1117:
1118: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
1119: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1120: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1121:
1122: account_data_exception EXCEPTION;
1123:

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

1297: WHERE khr.id = p_contract_id;
1298:
1299: l_contract_rec contract_csr%ROWTYPE;
1300:
1301: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS
1302: select description, lookup_code
1303: from fnd_lookup_values
1304: where language = 'US'
1305: AND lookup_type = lkp_type

Line 1365: l_lkp_tcn_type_rec fnd_lookups_csr%ROWTYPE;

1361: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
1362:
1363: j NUMBER := 0;
1364: l_trx_id NUMBER;
1365: l_lkp_tcn_type_rec fnd_lookups_csr%ROWTYPE;
1366: l_lkp_trx_status_rec fnd_lookups_csr%ROWTYPE;
1367: SUBTYPE ac_tax_line_rec IS tax_line_csr1%ROWTYPE;
1368: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec INDEX BY BINARY_INTEGER;
1369: l_accoutable_tax_lines ac_tax_line_tbl;

Line 1366: l_lkp_trx_status_rec fnd_lookups_csr%ROWTYPE;

1362:
1363: j NUMBER := 0;
1364: l_trx_id NUMBER;
1365: l_lkp_tcn_type_rec fnd_lookups_csr%ROWTYPE;
1366: l_lkp_trx_status_rec fnd_lookups_csr%ROWTYPE;
1367: SUBTYPE ac_tax_line_rec IS tax_line_csr1%ROWTYPE;
1368: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec INDEX BY BINARY_INTEGER;
1369: l_accoutable_tax_lines ac_tax_line_tbl;
1370: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

Line 1370: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

1366: l_lkp_trx_status_rec fnd_lookups_csr%ROWTYPE;
1367: SUBTYPE ac_tax_line_rec IS tax_line_csr1%ROWTYPE;
1368: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec INDEX BY BINARY_INTEGER;
1369: l_accoutable_tax_lines ac_tax_line_tbl;
1370: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1371: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1372: upfront_tax_acct_exception EXCEPTION;
1373:
1374: l_billed_sty_id NUMBER;

Line 1443: ,'OKL: create_upfront_tax_accounting Procedure: before fnd_lookups_csr ');

1439: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
1440: THEN
1441: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT
1442: , G_MODULE
1443: ,'OKL: create_upfront_tax_accounting Procedure: before fnd_lookups_csr ');
1444: END IF;
1445:
1446: l_lkp_tcn_type_rec := NULL;
1447: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');

Line 1447: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');

1443: ,'OKL: create_upfront_tax_accounting Procedure: before fnd_lookups_csr ');
1444: END IF;
1445:
1446: l_lkp_tcn_type_rec := NULL;
1447: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
1448: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1449: IF fnd_lookups_csr%NOTFOUND
1450: THEN
1451: Okl_Api.SET_MESSAGE( G_APP_NAME

Line 1448: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;

1444: END IF;
1445:
1446: l_lkp_tcn_type_rec := NULL;
1447: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
1448: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1449: IF fnd_lookups_csr%NOTFOUND
1450: THEN
1451: Okl_Api.SET_MESSAGE( G_APP_NAME
1452: ,OKL_API.G_INVALID_VALUE

Line 1449: IF fnd_lookups_csr%NOTFOUND

1445:
1446: l_lkp_tcn_type_rec := NULL;
1447: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
1448: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1449: IF fnd_lookups_csr%NOTFOUND
1450: THEN
1451: Okl_Api.SET_MESSAGE( G_APP_NAME
1452: ,OKL_API.G_INVALID_VALUE
1453: ,'TRANSACTION_TYPE'

Line 1455: CLOSE fnd_lookups_csr;

1451: Okl_Api.SET_MESSAGE( G_APP_NAME
1452: ,OKL_API.G_INVALID_VALUE
1453: ,'TRANSACTION_TYPE'
1454: ,'Upfront Tax');
1455: CLOSE fnd_lookups_csr;
1456: RAISE upfront_tax_acct_exception;
1457: END IF;
1458: CLOSE fnd_lookups_csr;
1459:

Line 1458: CLOSE fnd_lookups_csr;

1454: ,'Upfront Tax');
1455: CLOSE fnd_lookups_csr;
1456: RAISE upfront_tax_acct_exception;
1457: END IF;
1458: CLOSE fnd_lookups_csr;
1459:
1460: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
1461: THEN
1462: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT

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

1563: l_trxH_in_rec.tcn_type := l_lkp_tcn_type_rec.lookup_code;
1564: l_trxH_in_rec.amount := l_transaction_amount;
1565:
1566: l_lkp_trx_status_rec := NULL;
1567: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1568: FETCH fnd_lookups_csr INTO l_lkp_trx_status_rec;
1569: CLOSE fnd_lookups_csr;
1570:
1571: l_trxH_in_rec.tsu_code := l_lkp_trx_status_rec.lookup_code;

Line 1568: FETCH fnd_lookups_csr INTO l_lkp_trx_status_rec;

1564: l_trxH_in_rec.amount := l_transaction_amount;
1565:
1566: l_lkp_trx_status_rec := NULL;
1567: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1568: FETCH fnd_lookups_csr INTO l_lkp_trx_status_rec;
1569: CLOSE fnd_lookups_csr;
1570:
1571: l_trxH_in_rec.tsu_code := l_lkp_trx_status_rec.lookup_code;
1572: l_trxH_in_rec.description := l_lkp_trx_status_rec.description;

Line 1569: CLOSE fnd_lookups_csr;

1565:
1566: l_lkp_trx_status_rec := NULL;
1567: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1568: FETCH fnd_lookups_csr INTO l_lkp_trx_status_rec;
1569: CLOSE fnd_lookups_csr;
1570:
1571: l_trxH_in_rec.tsu_code := l_lkp_trx_status_rec.lookup_code;
1572: l_trxH_in_rec.description := l_lkp_trx_status_rec.description;
1573: