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 1151: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

1147:
1148: l_custBillTo_rec custBillTo_csr%ROWTYPE;
1149:
1150: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
1151: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1152: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1153:
1154: account_data_exception EXCEPTION;
1155:

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

1329: WHERE khr.id = p_contract_id;
1330:
1331: l_contract_rec contract_csr%ROWTYPE;
1332:
1333: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS
1334: select description, lookup_code
1335: from fnd_lookup_values
1336: where language = 'US'
1337: AND lookup_type = lkp_type

Line 1397: l_lkp_tcn_type_rec fnd_lookups_csr%ROWTYPE;

1393: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
1394:
1395: j NUMBER := 0;
1396: l_trx_id NUMBER;
1397: l_lkp_tcn_type_rec fnd_lookups_csr%ROWTYPE;
1398: l_lkp_trx_status_rec fnd_lookups_csr%ROWTYPE;
1399: SUBTYPE ac_tax_line_rec IS tax_line_csr1%ROWTYPE;
1400: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec INDEX BY BINARY_INTEGER;
1401: l_accoutable_tax_lines ac_tax_line_tbl;

Line 1398: l_lkp_trx_status_rec fnd_lookups_csr%ROWTYPE;

1394:
1395: j NUMBER := 0;
1396: l_trx_id NUMBER;
1397: l_lkp_tcn_type_rec fnd_lookups_csr%ROWTYPE;
1398: l_lkp_trx_status_rec fnd_lookups_csr%ROWTYPE;
1399: SUBTYPE ac_tax_line_rec IS tax_line_csr1%ROWTYPE;
1400: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec INDEX BY BINARY_INTEGER;
1401: l_accoutable_tax_lines ac_tax_line_tbl;
1402: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

Line 1402: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

1398: l_lkp_trx_status_rec fnd_lookups_csr%ROWTYPE;
1399: SUBTYPE ac_tax_line_rec IS tax_line_csr1%ROWTYPE;
1400: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec INDEX BY BINARY_INTEGER;
1401: l_accoutable_tax_lines ac_tax_line_tbl;
1402: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1403: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1404: upfront_tax_acct_exception EXCEPTION;
1405:
1406: l_billed_sty_id NUMBER;

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

1471: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
1472: THEN
1473: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT
1474: , G_MODULE
1475: ,'OKL: create_upfront_tax_accounting Procedure: before fnd_lookups_csr ');
1476: END IF;
1477:
1478: l_lkp_tcn_type_rec := NULL;
1479: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');

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

1475: ,'OKL: create_upfront_tax_accounting Procedure: before fnd_lookups_csr ');
1476: END IF;
1477:
1478: l_lkp_tcn_type_rec := NULL;
1479: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
1480: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1481: IF fnd_lookups_csr%NOTFOUND
1482: THEN
1483: Okl_Api.SET_MESSAGE( G_APP_NAME

Line 1480: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;

1476: END IF;
1477:
1478: l_lkp_tcn_type_rec := NULL;
1479: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
1480: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1481: IF fnd_lookups_csr%NOTFOUND
1482: THEN
1483: Okl_Api.SET_MESSAGE( G_APP_NAME
1484: ,OKL_API.G_INVALID_VALUE

Line 1481: IF fnd_lookups_csr%NOTFOUND

1477:
1478: l_lkp_tcn_type_rec := NULL;
1479: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
1480: FETCH fnd_lookups_csr INTO l_lkp_tcn_type_rec;
1481: IF fnd_lookups_csr%NOTFOUND
1482: THEN
1483: Okl_Api.SET_MESSAGE( G_APP_NAME
1484: ,OKL_API.G_INVALID_VALUE
1485: ,'TRANSACTION_TYPE'

Line 1487: CLOSE fnd_lookups_csr;

1483: Okl_Api.SET_MESSAGE( G_APP_NAME
1484: ,OKL_API.G_INVALID_VALUE
1485: ,'TRANSACTION_TYPE'
1486: ,'Upfront Tax');
1487: CLOSE fnd_lookups_csr;
1488: RAISE upfront_tax_acct_exception;
1489: END IF;
1490: CLOSE fnd_lookups_csr;
1491:

Line 1490: CLOSE fnd_lookups_csr;

1486: ,'Upfront Tax');
1487: CLOSE fnd_lookups_csr;
1488: RAISE upfront_tax_acct_exception;
1489: END IF;
1490: CLOSE fnd_lookups_csr;
1491:
1492: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
1493: THEN
1494: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT

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

1595: l_trxH_in_rec.tcn_type := l_lkp_tcn_type_rec.lookup_code;
1596: l_trxH_in_rec.amount := l_transaction_amount;
1597:
1598: l_lkp_trx_status_rec := NULL;
1599: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1600: FETCH fnd_lookups_csr INTO l_lkp_trx_status_rec;
1601: CLOSE fnd_lookups_csr;
1602:
1603: l_trxH_in_rec.tsu_code := l_lkp_trx_status_rec.lookup_code;

Line 1600: FETCH fnd_lookups_csr INTO l_lkp_trx_status_rec;

1596: l_trxH_in_rec.amount := l_transaction_amount;
1597:
1598: l_lkp_trx_status_rec := NULL;
1599: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1600: FETCH fnd_lookups_csr INTO l_lkp_trx_status_rec;
1601: CLOSE fnd_lookups_csr;
1602:
1603: l_trxH_in_rec.tsu_code := l_lkp_trx_status_rec.lookup_code;
1604: l_trxH_in_rec.description := l_lkp_trx_status_rec.description;

Line 1601: CLOSE fnd_lookups_csr;

1597:
1598: l_lkp_trx_status_rec := NULL;
1599: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1600: FETCH fnd_lookups_csr INTO l_lkp_trx_status_rec;
1601: CLOSE fnd_lookups_csr;
1602:
1603: l_trxH_in_rec.tsu_code := l_lkp_trx_status_rec.lookup_code;
1604: l_trxH_in_rec.description := l_lkp_trx_status_rec.description;
1605: