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

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

55: --R12 Bug# 14033244 End
56:
57:
58: -- Cursor to get Transaction type and status descriptions
59: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS
60: select description, lookup_code
61: from fnd_lookup_values
62: where language = 'US'
63: AND lookup_type = lkp_type

Line 1071: l_fnd_rec fnd_lookups_csr%ROWTYPE;

1067: l_api_version CONSTANT NUMBER := 1.0;
1068:
1069: -- Cursor Types
1070: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;
1071: l_fnd_rec fnd_lookups_csr%ROWTYPE;
1072: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;
1073: l_trx_rec trx_csr%ROWTYPE;
1074:
1075: p_chr_id VARCHAR2(2000) := TO_CHAR(p_contract_id);

Line 1072: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;

1068:
1069: -- Cursor Types
1070: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;
1071: l_fnd_rec fnd_lookups_csr%ROWTYPE;
1072: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;
1073: l_trx_rec trx_csr%ROWTYPE;
1074:
1075: p_chr_id VARCHAR2(2000) := TO_CHAR(p_contract_id);
1076: l_transaction_type VARCHAR2(256) := p_transaction_type;

Line 1233: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');

1229:
1230: okl_debug_pub.logmessage('OKL: POP TRX : Transaction_Type_csr.id: ' || l_Trx_Type_rec.id);
1231:
1232: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1233: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1234: END IF;
1235:
1236: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
1237: FETCH fnd_lookups_csr INTO l_fnd_rec;

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

1232: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1233: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1234: END IF;
1235:
1236: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
1237: FETCH fnd_lookups_csr INTO l_fnd_rec;
1238:
1239: IF fnd_lookups_csr%NOTFOUND THEN
1240: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);

Line 1237: FETCH fnd_lookups_csr INTO l_fnd_rec;

1233: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1234: END IF;
1235:
1236: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
1237: FETCH fnd_lookups_csr INTO l_fnd_rec;
1238:
1239: IF fnd_lookups_csr%NOTFOUND THEN
1240: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);
1241: CLOSE fnd_lookups_csr;

Line 1239: IF fnd_lookups_csr%NOTFOUND THEN

1235:
1236: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
1237: FETCH fnd_lookups_csr INTO l_fnd_rec;
1238:
1239: IF fnd_lookups_csr%NOTFOUND THEN
1240: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);
1241: CLOSE fnd_lookups_csr;
1242: RAISE pop_trx_failed;
1243: END IF;

Line 1241: CLOSE fnd_lookups_csr;

1237: FETCH fnd_lookups_csr INTO l_fnd_rec;
1238:
1239: IF fnd_lookups_csr%NOTFOUND THEN
1240: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);
1241: CLOSE fnd_lookups_csr;
1242: RAISE pop_trx_failed;
1243: END IF;
1244: CLOSE fnd_lookups_csr;
1245:

Line 1244: CLOSE fnd_lookups_csr;

1240: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);
1241: CLOSE fnd_lookups_csr;
1242: RAISE pop_trx_failed;
1243: END IF;
1244: CLOSE fnd_lookups_csr;
1245:
1246: okl_debug_pub.logmessage('OKL: POP TRX : transaction type: ' || l_transaction_type);
1247: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: Description ' || l_fnd_rec.description);
1248: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: lookup_code ' || l_fnd_rec.lookup_code);

Line 1247: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: Description ' || l_fnd_rec.description);

1243: END IF;
1244: CLOSE fnd_lookups_csr;
1245:
1246: okl_debug_pub.logmessage('OKL: POP TRX : transaction type: ' || l_transaction_type);
1247: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: Description ' || l_fnd_rec.description);
1248: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: lookup_code ' || l_fnd_rec.lookup_code);
1249:
1250:
1251: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN

Line 1248: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: lookup_code ' || l_fnd_rec.lookup_code);

1244: CLOSE fnd_lookups_csr;
1245:
1246: okl_debug_pub.logmessage('OKL: POP TRX : transaction type: ' || l_transaction_type);
1247: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: Description ' || l_fnd_rec.description);
1248: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: lookup_code ' || l_fnd_rec.lookup_code);
1249:
1250:
1251: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1252: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before trx_csr ');

Line 1304: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');

1300:
1301: If ( l_has_trans = OKL_API.G_FALSE ) Then
1302:
1303: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1304: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1305: END IF;
1306:
1307: -- The followinf if segment ensures that Upfront Tax transaction is created
1308: -- with 'Processed' status

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

1307: -- The followinf if segment ensures that Upfront Tax transaction is created
1308: -- with 'Processed' status
1309: IF (l_transaction_type = 'Upfront Tax')
1310: THEN
1311: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1312: ELSE
1313: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1314: END IF;
1315: FETCH fnd_lookups_csr INTO l_fnd_rec;

Line 1313: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');

1309: IF (l_transaction_type = 'Upfront Tax')
1310: THEN
1311: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1312: ELSE
1313: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1314: END IF;
1315: FETCH fnd_lookups_csr INTO l_fnd_rec;
1316: IF fnd_lookups_csr%NOTFOUND THEN
1317: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);

Line 1315: FETCH fnd_lookups_csr INTO l_fnd_rec;

1311: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1312: ELSE
1313: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1314: END IF;
1315: FETCH fnd_lookups_csr INTO l_fnd_rec;
1316: IF fnd_lookups_csr%NOTFOUND THEN
1317: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1318: CLOSE fnd_lookups_csr;
1319: RAISE pop_trx_failed;

Line 1316: IF fnd_lookups_csr%NOTFOUND THEN

1312: ELSE
1313: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1314: END IF;
1315: FETCH fnd_lookups_csr INTO l_fnd_rec;
1316: IF fnd_lookups_csr%NOTFOUND THEN
1317: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1318: CLOSE fnd_lookups_csr;
1319: RAISE pop_trx_failed;
1320: END IF;

Line 1318: CLOSE fnd_lookups_csr;

1314: END IF;
1315: FETCH fnd_lookups_csr INTO l_fnd_rec;
1316: IF fnd_lookups_csr%NOTFOUND THEN
1317: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1318: CLOSE fnd_lookups_csr;
1319: RAISE pop_trx_failed;
1320: END IF;
1321: CLOSE fnd_lookups_csr;
1322:

Line 1321: CLOSE fnd_lookups_csr;

1317: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1318: CLOSE fnd_lookups_csr;
1319: RAISE pop_trx_failed;
1320: END IF;
1321: CLOSE fnd_lookups_csr;
1322:
1323: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
1324: l_trxH_in_rec.description := l_fnd_rec.description;
1325:

Line 1394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');

1390: l_upd_trxH_rec.id := l_trx_rec.HeaderTransID;
1391: l_upd_trxH_rec.date_transaction_occurred := l_trx_rec.date_transaction_occurred;
1392: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1393: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : transaction ID '||l_trx_rec.HeaderTransID);
1394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1395: END IF;
1396:
1397: -- R12 Bug# 14033244 Start
1398: l_upd_trxH_rec.pdt_id := g_Product_rec.product_id;

Line 1408: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');

1404: l_upd_trxH_rec.currency_conversion_type := x_currency_conversion_type;
1405: l_upd_trxH_rec.currency_conversion_date := x_currency_conversion_date;
1406: -- R12 Bug# 14033244 End
1407:
1408: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1409: FETCH fnd_lookups_csr INTO l_fnd_rec;
1410: IF fnd_lookups_csr%NOTFOUND THEN
1411: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1412: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');

Line 1409: FETCH fnd_lookups_csr INTO l_fnd_rec;

1405: l_upd_trxH_rec.currency_conversion_date := x_currency_conversion_date;
1406: -- R12 Bug# 14033244 End
1407:
1408: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1409: FETCH fnd_lookups_csr INTO l_fnd_rec;
1410: IF fnd_lookups_csr%NOTFOUND THEN
1411: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1412: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');
1413: CLOSE fnd_lookups_csr;

Line 1410: IF fnd_lookups_csr%NOTFOUND THEN

1406: -- R12 Bug# 14033244 End
1407:
1408: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1409: FETCH fnd_lookups_csr INTO l_fnd_rec;
1410: IF fnd_lookups_csr%NOTFOUND THEN
1411: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1412: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');
1413: CLOSE fnd_lookups_csr;
1414: RAISE pop_trx_failed;

Line 1413: CLOSE fnd_lookups_csr;

1409: FETCH fnd_lookups_csr INTO l_fnd_rec;
1410: IF fnd_lookups_csr%NOTFOUND THEN
1411: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1412: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');
1413: CLOSE fnd_lookups_csr;
1414: RAISE pop_trx_failed;
1415: END IF;
1416: CLOSE fnd_lookups_csr;
1417:

Line 1416: CLOSE fnd_lookups_csr;

1412: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');
1413: CLOSE fnd_lookups_csr;
1414: RAISE pop_trx_failed;
1415: END IF;
1416: CLOSE fnd_lookups_csr;
1417:
1418: l_upd_trxH_rec.tsu_code := l_fnd_rec.lookup_code;
1419:
1420: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN

Line 3234: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

3230: l_custBillTo_rec custBillTo_csr%ROWTYPE;
3231:
3232: -- Cursors plucked from OKL_LA_JE_PVT for a/c - END
3233: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
3234: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3235: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3236:
3237: account_data_exception EXCEPTION;
3238:

Line 3757: l_fnd_rec fnd_lookups_csr%ROWTYPE;

3753:
3754: counter NUMBER := 0;
3755: j NUMBER := 0;
3756: l_trx_id NUMBER;
3757: l_fnd_rec fnd_lookups_csr%ROWTYPE;
3758: l_trxh_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
3759: l_financed_sty_id NUMBER;
3760: l_capitalized_sty_id NUMBER;
3761: l_upfront_trx_exists NUMBER := 0;

Line 3767: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

3763: subtype ac_tax_line_rec is tax_line_csr2%ROWTYPE;
3764: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec
3765: INDEX BY BINARY_INTEGER;
3766: l_accoutable_tax_lines ac_tax_line_tbl;
3767: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3768: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3769: upfront_tax_acct_exception EXCEPTION;
3770:
3771: --Bug# 6619311

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

3825: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
3826: THEN
3827: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT
3828: , G_MODULE
3829: ,'OKL: create_upfront_tax_accounting Procedure : before fnd_lookups_csr ');
3830: END IF;
3831:
3832: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
3833: FETCH fnd_lookups_csr INTO l_fnd_rec;

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

3828: , G_MODULE
3829: ,'OKL: create_upfront_tax_accounting Procedure : before fnd_lookups_csr ');
3830: END IF;
3831:
3832: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
3833: FETCH fnd_lookups_csr INTO l_fnd_rec;
3834:
3835: IF fnd_lookups_csr%NOTFOUND
3836: THEN

Line 3833: FETCH fnd_lookups_csr INTO l_fnd_rec;

3829: ,'OKL: create_upfront_tax_accounting Procedure : before fnd_lookups_csr ');
3830: END IF;
3831:
3832: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
3833: FETCH fnd_lookups_csr INTO l_fnd_rec;
3834:
3835: IF fnd_lookups_csr%NOTFOUND
3836: THEN
3837: Okl_Api.SET_MESSAGE( G_APP_NAME

Line 3835: IF fnd_lookups_csr%NOTFOUND

3831:
3832: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
3833: FETCH fnd_lookups_csr INTO l_fnd_rec;
3834:
3835: IF fnd_lookups_csr%NOTFOUND
3836: THEN
3837: Okl_Api.SET_MESSAGE( G_APP_NAME
3838: ,G_INVALID_VALUE
3839: ,'TRANSACTION_TYPE'

Line 3841: CLOSE fnd_lookups_csr;

3837: Okl_Api.SET_MESSAGE( G_APP_NAME
3838: ,G_INVALID_VALUE
3839: ,'TRANSACTION_TYPE'
3840: ,'Upfront Tax');
3841: CLOSE fnd_lookups_csr;
3842: RAISE upfront_tax_acct_exception;
3843: END IF;
3844:
3845: CLOSE fnd_lookups_csr;

Line 3845: CLOSE fnd_lookups_csr;

3841: CLOSE fnd_lookups_csr;
3842: RAISE upfront_tax_acct_exception;
3843: END IF;
3844:
3845: CLOSE fnd_lookups_csr;
3846:
3847: -- Get Stream ID's for 'Financed' and 'Capitalized' Fee stream purposes,
3848: -- this ID will be populated in OKL_TXL_CNTRCT_LNS depending on
3849: -- each inserted record's tax treatment

Line 5353: l_fnd_rec fnd_lookups_csr%ROWTYPE;

5349: --, nvl(tax_schedule_yn,'N') -- added for Bug 4748910 -- Not required in R12
5350: FROM okl_system_params;
5351:
5352: -- Cursor Types
5353: l_fnd_rec fnd_lookups_csr%ROWTYPE;
5354:
5355: l_transaction_type VARCHAR2(256) := p_transaction_type;
5356: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
5357: l_tax_upfront_yn okl_system_params.tax_upfront_yn%TYPE;

Line 6043: From fnd_lookups

6039:
6040: cursor fnd_csr( fndType VARCHAR2, fndCode VARCHAR2 ) IS
6041: Select meaning,
6042: description
6043: From fnd_lookups
6044: Where lookup_type = fndType
6045: and lookup_code = fndCode;
6046:
6047: CURSOR l_hdr_csr IS

Line 6106: l_fnd_meaning fnd_lookups.MEANING%TYPE;

6102: l_tax_header VARCHAR2(100);
6103: l_fnd_rec fnd_csr%ROWTYPE;
6104: l_line_fnd_rec fnd_csr%ROWTYPE;
6105: l_hdr_fnd_rec fnd_csr%ROWTYPE;
6106: l_fnd_meaning fnd_lookups.MEANING%TYPE;
6107: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
6108: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
6109: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
6110: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;

Line 6107: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;

6103: l_fnd_rec fnd_csr%ROWTYPE;
6104: l_line_fnd_rec fnd_csr%ROWTYPE;
6105: l_hdr_fnd_rec fnd_csr%ROWTYPE;
6106: l_fnd_meaning fnd_lookups.MEANING%TYPE;
6107: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
6108: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
6109: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
6110: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
6111: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;

Line 6108: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;

6104: l_line_fnd_rec fnd_csr%ROWTYPE;
6105: l_hdr_fnd_rec fnd_csr%ROWTYPE;
6106: l_fnd_meaning fnd_lookups.MEANING%TYPE;
6107: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
6108: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
6109: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
6110: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
6111: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
6112: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;

Line 6109: l_fee_type_meaning fnd_lookups.MEANING%TYPE;

6105: l_hdr_fnd_rec fnd_csr%ROWTYPE;
6106: l_fnd_meaning fnd_lookups.MEANING%TYPE;
6107: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
6108: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
6109: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
6110: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
6111: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
6112: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;
6113: l_count NUMBER;

Line 6110: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;

6106: l_fnd_meaning fnd_lookups.MEANING%TYPE;
6107: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
6108: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
6109: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
6110: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
6111: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
6112: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;
6113: l_count NUMBER;
6114: l_amt_link_asset NUMBER;

Line 6111: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;

6107: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
6108: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
6109: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
6110: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
6111: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
6112: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;
6113: l_count NUMBER;
6114: l_amt_link_asset NUMBER;
6115: l_no_link_assets NUMBER;

Line 6112: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;

6108: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
6109: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
6110: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
6111: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
6112: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;
6113: l_count NUMBER;
6114: l_amt_link_asset NUMBER;
6115: l_no_link_assets NUMBER;
6116: l_bill_strm_type NUMBER;