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 41: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS

37: -- R12 - END
38:
39:
40: -- Cursor to get Transaction type and status descriptions
41: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS
42: select description, lookup_code
43: from fnd_lookup_values
44: where language = 'US'
45: AND lookup_type = lkp_type

Line 913: l_fnd_rec fnd_lookups_csr%ROWTYPE;

909: l_api_version CONSTANT NUMBER := 1.0;
910:
911: -- Cursor Types
912: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;
913: l_fnd_rec fnd_lookups_csr%ROWTYPE;
914: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;
915: l_trx_rec trx_csr%ROWTYPE;
916:
917: p_chr_id VARCHAR2(2000) := TO_CHAR(p_contract_id);

Line 914: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;

910:
911: -- Cursor Types
912: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;
913: l_fnd_rec fnd_lookups_csr%ROWTYPE;
914: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;
915: l_trx_rec trx_csr%ROWTYPE;
916:
917: p_chr_id VARCHAR2(2000) := TO_CHAR(p_contract_id);
918: l_transaction_type VARCHAR2(256) := p_transaction_type;

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

1054:
1055: okl_debug_pub.logmessage('OKL: POP TRX : Transaction_Type_csr.id: ' || l_Trx_Type_rec.id);
1056:
1057: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1058: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1059: END IF;
1060:
1061: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
1062: FETCH fnd_lookups_csr INTO l_fnd_rec;

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

1057: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1058: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1059: END IF;
1060:
1061: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
1062: FETCH fnd_lookups_csr INTO l_fnd_rec;
1063:
1064: IF fnd_lookups_csr%NOTFOUND THEN
1065: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);

Line 1062: FETCH fnd_lookups_csr INTO l_fnd_rec;

1058: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1059: END IF;
1060:
1061: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
1062: FETCH fnd_lookups_csr INTO l_fnd_rec;
1063:
1064: IF fnd_lookups_csr%NOTFOUND THEN
1065: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);
1066: CLOSE fnd_lookups_csr;

Line 1064: IF fnd_lookups_csr%NOTFOUND THEN

1060:
1061: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
1062: FETCH fnd_lookups_csr INTO l_fnd_rec;
1063:
1064: IF fnd_lookups_csr%NOTFOUND THEN
1065: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);
1066: CLOSE fnd_lookups_csr;
1067: RAISE pop_trx_failed;
1068: END IF;

Line 1066: CLOSE fnd_lookups_csr;

1062: FETCH fnd_lookups_csr INTO l_fnd_rec;
1063:
1064: IF fnd_lookups_csr%NOTFOUND THEN
1065: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);
1066: CLOSE fnd_lookups_csr;
1067: RAISE pop_trx_failed;
1068: END IF;
1069: CLOSE fnd_lookups_csr;
1070:

Line 1069: CLOSE fnd_lookups_csr;

1065: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,'TRANSACTION_TYPE', l_transaction_type);
1066: CLOSE fnd_lookups_csr;
1067: RAISE pop_trx_failed;
1068: END IF;
1069: CLOSE fnd_lookups_csr;
1070:
1071: okl_debug_pub.logmessage('OKL: POP TRX : transaction type: ' || l_transaction_type);
1072: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: Description ' || l_fnd_rec.description);
1073: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: lookup_code ' || l_fnd_rec.lookup_code);

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

1068: END IF;
1069: CLOSE fnd_lookups_csr;
1070:
1071: okl_debug_pub.logmessage('OKL: POP TRX : transaction type: ' || l_transaction_type);
1072: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: Description ' || l_fnd_rec.description);
1073: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: lookup_code ' || l_fnd_rec.lookup_code);
1074:
1075:
1076: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN

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

1069: CLOSE fnd_lookups_csr;
1070:
1071: okl_debug_pub.logmessage('OKL: POP TRX : transaction type: ' || l_transaction_type);
1072: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: Description ' || l_fnd_rec.description);
1073: okl_debug_pub.logmessage('OKL: POP TRX : fnd_lookups_csr: lookup_code ' || l_fnd_rec.lookup_code);
1074:
1075:
1076: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1077: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before trx_csr ');

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

1125:
1126: If ( l_has_trans = OKL_API.G_FALSE ) Then
1127:
1128: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1129: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1130: END IF;
1131:
1132: -- The followinf if segment ensures that Upfront Tax transaction is created
1133: -- with 'Processed' status

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

1132: -- The followinf if segment ensures that Upfront Tax transaction is created
1133: -- with 'Processed' status
1134: IF (l_transaction_type = 'Upfront Tax')
1135: THEN
1136: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1137: ELSE
1138: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1139: END IF;
1140: FETCH fnd_lookups_csr INTO l_fnd_rec;

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

1134: IF (l_transaction_type = 'Upfront Tax')
1135: THEN
1136: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1137: ELSE
1138: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1139: END IF;
1140: FETCH fnd_lookups_csr INTO l_fnd_rec;
1141: IF fnd_lookups_csr%NOTFOUND THEN
1142: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);

Line 1140: FETCH fnd_lookups_csr INTO l_fnd_rec;

1136: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1137: ELSE
1138: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1139: END IF;
1140: FETCH fnd_lookups_csr INTO l_fnd_rec;
1141: IF fnd_lookups_csr%NOTFOUND THEN
1142: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1143: CLOSE fnd_lookups_csr;
1144: RAISE pop_trx_failed;

Line 1141: IF fnd_lookups_csr%NOTFOUND THEN

1137: ELSE
1138: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1139: END IF;
1140: FETCH fnd_lookups_csr INTO l_fnd_rec;
1141: IF fnd_lookups_csr%NOTFOUND THEN
1142: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1143: CLOSE fnd_lookups_csr;
1144: RAISE pop_trx_failed;
1145: END IF;

Line 1143: CLOSE fnd_lookups_csr;

1139: END IF;
1140: FETCH fnd_lookups_csr INTO l_fnd_rec;
1141: IF fnd_lookups_csr%NOTFOUND THEN
1142: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1143: CLOSE fnd_lookups_csr;
1144: RAISE pop_trx_failed;
1145: END IF;
1146: CLOSE fnd_lookups_csr;
1147:

Line 1146: CLOSE fnd_lookups_csr;

1142: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1143: CLOSE fnd_lookups_csr;
1144: RAISE pop_trx_failed;
1145: END IF;
1146: CLOSE fnd_lookups_csr;
1147:
1148: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
1149: l_trxH_in_rec.description := l_fnd_rec.description;
1150:

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

1215: l_upd_trxH_rec.id := l_trx_rec.HeaderTransID;
1216: l_upd_trxH_rec.date_transaction_occurred := l_trx_rec.date_transaction_occurred;
1217: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1218: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : transaction ID '||l_trx_rec.HeaderTransID);
1219: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1220: END IF;
1221:
1222: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1223: FETCH fnd_lookups_csr INTO l_fnd_rec;

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

1218: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : transaction ID '||l_trx_rec.HeaderTransID);
1219: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1220: END IF;
1221:
1222: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1223: FETCH fnd_lookups_csr INTO l_fnd_rec;
1224: IF fnd_lookups_csr%NOTFOUND THEN
1225: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1226: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');

Line 1223: FETCH fnd_lookups_csr INTO l_fnd_rec;

1219: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before fnd_lookups_csr ');
1220: END IF;
1221:
1222: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1223: FETCH fnd_lookups_csr INTO l_fnd_rec;
1224: IF fnd_lookups_csr%NOTFOUND THEN
1225: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1226: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');
1227: CLOSE fnd_lookups_csr;

Line 1224: IF fnd_lookups_csr%NOTFOUND THEN

1220: END IF;
1221:
1222: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Entered');
1223: FETCH fnd_lookups_csr INTO l_fnd_rec;
1224: IF fnd_lookups_csr%NOTFOUND THEN
1225: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1226: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');
1227: CLOSE fnd_lookups_csr;
1228: RAISE pop_trx_failed;

Line 1227: CLOSE fnd_lookups_csr;

1223: FETCH fnd_lookups_csr INTO l_fnd_rec;
1224: IF fnd_lookups_csr%NOTFOUND THEN
1225: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1226: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');
1227: CLOSE fnd_lookups_csr;
1228: RAISE pop_trx_failed;
1229: END IF;
1230: CLOSE fnd_lookups_csr;
1231:

Line 1230: CLOSE fnd_lookups_csr;

1226: --Okl_Api.SET_MESSAGE(G_APP_NAME, 'Cannot Find Transaction Status');
1227: CLOSE fnd_lookups_csr;
1228: RAISE pop_trx_failed;
1229: END IF;
1230: CLOSE fnd_lookups_csr;
1231:
1232: l_upd_trxH_rec.tsu_code := l_fnd_rec.lookup_code;
1233:
1234: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN

Line 3030: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

3026: l_custBillTo_rec custBillTo_csr%ROWTYPE;
3027:
3028: -- Cursors plucked from OKL_LA_JE_PVT for a/c - END
3029: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
3030: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3031: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3032:
3033: account_data_exception EXCEPTION;
3034:

Line 3553: l_fnd_rec fnd_lookups_csr%ROWTYPE;

3549:
3550: counter NUMBER := 0;
3551: j NUMBER := 0;
3552: l_trx_id NUMBER;
3553: l_fnd_rec fnd_lookups_csr%ROWTYPE;
3554: l_trxh_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
3555: l_financed_sty_id NUMBER;
3556: l_capitalized_sty_id NUMBER;
3557: l_upfront_trx_exists NUMBER := 0;

Line 3563: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

3559: subtype ac_tax_line_rec is tax_line_csr2%ROWTYPE;
3560: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec
3561: INDEX BY BINARY_INTEGER;
3562: l_accoutable_tax_lines ac_tax_line_tbl;
3563: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3564: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3565: upfront_tax_acct_exception EXCEPTION;
3566:
3567: --Bug# 6619311

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

3621: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
3622: THEN
3623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT
3624: , G_MODULE
3625: ,'OKL: create_upfront_tax_accounting Procedure : before fnd_lookups_csr ');
3626: END IF;
3627:
3628: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
3629: FETCH fnd_lookups_csr INTO l_fnd_rec;

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

3624: , G_MODULE
3625: ,'OKL: create_upfront_tax_accounting Procedure : before fnd_lookups_csr ');
3626: END IF;
3627:
3628: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
3629: FETCH fnd_lookups_csr INTO l_fnd_rec;
3630:
3631: IF fnd_lookups_csr%NOTFOUND
3632: THEN

Line 3629: FETCH fnd_lookups_csr INTO l_fnd_rec;

3625: ,'OKL: create_upfront_tax_accounting Procedure : before fnd_lookups_csr ');
3626: END IF;
3627:
3628: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
3629: FETCH fnd_lookups_csr INTO l_fnd_rec;
3630:
3631: IF fnd_lookups_csr%NOTFOUND
3632: THEN
3633: Okl_Api.SET_MESSAGE( G_APP_NAME

Line 3631: IF fnd_lookups_csr%NOTFOUND

3627:
3628: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Upfront Tax');
3629: FETCH fnd_lookups_csr INTO l_fnd_rec;
3630:
3631: IF fnd_lookups_csr%NOTFOUND
3632: THEN
3633: Okl_Api.SET_MESSAGE( G_APP_NAME
3634: ,G_INVALID_VALUE
3635: ,'TRANSACTION_TYPE'

Line 3637: CLOSE fnd_lookups_csr;

3633: Okl_Api.SET_MESSAGE( G_APP_NAME
3634: ,G_INVALID_VALUE
3635: ,'TRANSACTION_TYPE'
3636: ,'Upfront Tax');
3637: CLOSE fnd_lookups_csr;
3638: RAISE upfront_tax_acct_exception;
3639: END IF;
3640:
3641: CLOSE fnd_lookups_csr;

Line 3641: CLOSE fnd_lookups_csr;

3637: CLOSE fnd_lookups_csr;
3638: RAISE upfront_tax_acct_exception;
3639: END IF;
3640:
3641: CLOSE fnd_lookups_csr;
3642:
3643: -- Get Stream ID's for 'Financed' and 'Capitalized' Fee stream purposes,
3644: -- this ID will be populated in OKL_TXL_CNTRCT_LNS depending on
3645: -- each inserted record's tax treatment

Line 5149: l_fnd_rec fnd_lookups_csr%ROWTYPE;

5145: --, nvl(tax_schedule_yn,'N') -- added for Bug 4748910 -- Not required in R12
5146: FROM okl_system_params;
5147:
5148: -- Cursor Types
5149: l_fnd_rec fnd_lookups_csr%ROWTYPE;
5150:
5151: l_transaction_type VARCHAR2(256) := p_transaction_type;
5152: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
5153: l_tax_upfront_yn okl_system_params.tax_upfront_yn%TYPE;

Line 5647: From fnd_lookups

5643:
5644: cursor fnd_csr( fndType VARCHAR2, fndCode VARCHAR2 ) IS
5645: Select meaning,
5646: description
5647: From fnd_lookups
5648: Where lookup_type = fndType
5649: and lookup_code = fndCode;
5650:
5651: CURSOR l_hdr_csr IS

Line 5710: l_fnd_meaning fnd_lookups.MEANING%TYPE;

5706: l_tax_header VARCHAR2(100);
5707: l_fnd_rec fnd_csr%ROWTYPE;
5708: l_line_fnd_rec fnd_csr%ROWTYPE;
5709: l_hdr_fnd_rec fnd_csr%ROWTYPE;
5710: l_fnd_meaning fnd_lookups.MEANING%TYPE;
5711: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
5712: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
5713: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
5714: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;

Line 5711: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;

5707: l_fnd_rec fnd_csr%ROWTYPE;
5708: l_line_fnd_rec fnd_csr%ROWTYPE;
5709: l_hdr_fnd_rec fnd_csr%ROWTYPE;
5710: l_fnd_meaning fnd_lookups.MEANING%TYPE;
5711: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
5712: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
5713: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
5714: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
5715: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;

Line 5712: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;

5708: l_line_fnd_rec fnd_csr%ROWTYPE;
5709: l_hdr_fnd_rec fnd_csr%ROWTYPE;
5710: l_fnd_meaning fnd_lookups.MEANING%TYPE;
5711: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
5712: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
5713: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
5714: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
5715: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
5716: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;

Line 5713: l_fee_type_meaning fnd_lookups.MEANING%TYPE;

5709: l_hdr_fnd_rec fnd_csr%ROWTYPE;
5710: l_fnd_meaning fnd_lookups.MEANING%TYPE;
5711: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
5712: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
5713: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
5714: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
5715: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
5716: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;
5717: l_count NUMBER;

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

5710: l_fnd_meaning fnd_lookups.MEANING%TYPE;
5711: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
5712: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
5713: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
5714: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
5715: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
5716: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;
5717: l_count NUMBER;
5718: l_amt_link_asset NUMBER;

Line 5715: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;

5711: l_line_fnd_meaning fnd_lookups.MEANING%TYPE;
5712: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
5713: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
5714: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
5715: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
5716: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;
5717: l_count NUMBER;
5718: l_amt_link_asset NUMBER;
5719: l_no_link_assets NUMBER;

Line 5716: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;

5712: l_hdr_fnd_meaning fnd_lookups.MEANING%TYPE;
5713: l_fee_type_meaning fnd_lookups.MEANING%TYPE;
5714: --l_tax_treatment_fee fnd_lookups.MEANING%TYPE;
5715: l_tax_fee_meaning fnd_lookups.MEANING%TYPE;
5716: l_st_fee_code fnd_lookups.LOOKUP_CODE%TYPE;
5717: l_count NUMBER;
5718: l_amt_link_asset NUMBER;
5719: l_no_link_assets NUMBER;
5720: l_bill_strm_type NUMBER;