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 OKL_TRX_CONTRACTS

Line 228: g_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';

224: AND txs.tax_call_type_code = 'UPFRONT_TAX'
225: AND NVL(txs.total_tax,0) <> 0;
226:
227: -- Global Variables
228: g_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
229:
230:
231:
232: -- Start of comments

Line 857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,

853: p_api_version IN NUMBER,
854: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
855: p_contract_id IN okc_k_headers_all_b.id%TYPE,
856: p_transaction_type IN okl_trx_types_tl.name%TYPE,
857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,

Line 858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,

854: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
855: p_contract_id IN okc_k_headers_all_b.id%TYPE,
856: p_transaction_type IN okl_trx_types_tl.name%TYPE,
857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,

Line 859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,

855: p_contract_id IN okc_k_headers_all_b.id%TYPE,
856: p_transaction_type IN okl_trx_types_tl.name%TYPE,
857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change

Line 861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,

857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,

Line 862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,

858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change

859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311
861: p_transaction_amount IN okl_trx_contracts_all.amount%TYPE DEFAULT NULL,
862: x_transaction_id OUT NOCOPY okl_trx_contracts_all.id%TYPE,
863: x_trxh_out_rec OUT NOCOPY Okl_Trx_Contracts_Pvt.tcnv_rec_type, -- R12 Change
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2) IS
867:

Line 869: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2) IS
867:
868: -- Define PL/SQL Records and Tables
869: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
870: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
871:
872: -- Define variables
873: l_sysdate DATE;

Line 870: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

866: x_msg_data OUT NOCOPY VARCHAR2) IS
867:
868: -- Define PL/SQL Records and Tables
869: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
870: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
871:
872: -- Define variables
873: l_sysdate DATE;
874: l_sysdate_trunc DATE;

Line 888: From okl_trx_contracts txh

884:
885: Cursor trx_csr( khrId NUMBER, tcntype VARCHAR2 ) is
886: Select txh.ID HeaderTransID,
887: txh.date_transaction_occurred date_transaction_occurred
888: From okl_trx_contracts txh
889: Where txh.khr_id = khrId
890: --rkuttiya added for 12.1.1 Multi GAAP
891: AND txh.representation_type = 'PRIMARY'
892: --

Line 922: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

918: l_transaction_type VARCHAR2(256) := p_transaction_type;
919: l_transaction_id NUMBER;
920:
921: --Bug# 3153003
922: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
923: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
924:
925: pop_trx_failed exception;
926:

Line 923: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

919: l_transaction_id NUMBER;
920:
921: --Bug# 3153003
922: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
923: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
924:
925: pop_trx_failed exception;
926:
927: --Added by dpsingh for LE uptake

Line 1173: ,'OKL: Populate Trx Procedure : before Okl_Trx_Contracts_Pub.create_trx_contracts ');

1169: END IF;
1170: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT
1172: , G_MODULE
1173: ,'OKL: Populate Trx Procedure : before Okl_Trx_Contracts_Pub.create_trx_contracts ');
1174: END IF;
1175:
1176: -- Create Transaction Header, Lines
1177: Okl_Trx_Contracts_Pub.create_trx_contracts(

Line 1177: Okl_Trx_Contracts_Pub.create_trx_contracts(

1173: ,'OKL: Populate Trx Procedure : before Okl_Trx_Contracts_Pub.create_trx_contracts ');
1174: END IF;
1175:
1176: -- Create Transaction Header, Lines
1177: Okl_Trx_Contracts_Pub.create_trx_contracts(
1178: p_api_version => p_api_version
1179: ,p_init_msg_list => p_init_msg_list
1180: ,x_return_status => x_return_status
1181: ,x_msg_count => x_msg_count

Line 1235: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before Okl_Trx_Contracts_Pub.update_trx_contracts ');

1231:
1232: l_upd_trxH_rec.tsu_code := l_fnd_rec.lookup_code;
1233:
1234: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1235: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before Okl_Trx_Contracts_Pub.update_trx_contracts ');
1236: END IF;
1237:
1238: Okl_Trx_Contracts_Pub.update_trx_contracts(
1239: p_api_version => p_api_version

Line 1238: Okl_Trx_Contracts_Pub.update_trx_contracts(

1234: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1235: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL: Populate Trx Procedure : before Okl_Trx_Contracts_Pub.update_trx_contracts ');
1236: END IF;
1237:
1238: Okl_Trx_Contracts_Pub.update_trx_contracts(
1239: p_api_version => p_api_version
1240: ,p_init_msg_list => p_init_msg_list
1241: ,x_return_status => x_return_status
1242: ,x_msg_count => x_msg_count

Line 2973: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type

2969:
2970: PROCEDURE populate_account_data(
2971: p_api_version IN NUMBER
2972: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2973: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
2974: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
2975: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
2976: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
2977: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type

Line 2974: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type

2970: PROCEDURE populate_account_data(
2971: p_api_version IN NUMBER
2972: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2973: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
2974: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
2975: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
2976: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
2977: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type
2978: ,x_return_status OUT NOCOPY VARCHAR2

Line 3176: -- 1. TRX header in OKL_TRX_CONTRACTS for type 'Upfront Tax'

3172: -- Description : This procedure creates a/c journal entries for upfront tax lines.
3173: -- This procedure logic will be executed in its entirety, only if SLA accounting
3174: -- option AMB is enabled.
3175: -- When enabled, it creates:
3176: -- 1. TRX header in OKL_TRX_CONTRACTS for type 'Upfront Tax'
3177: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,
3178: -- store values for cle-id, tax_line_id, tax_amount, etc.
3179: -- 3. Identify tax treatment for each asset line, to derive stream type
3180: -- 4. Call a/c API for upfront tax records in OKL_TXL_CNTRCT_LNS

Line 3190: ,p_transaction_id IN okl_trx_contracts_all.khr_id%TYPE

3186: PROCEDURE create_upfront_tax_accounting(
3187: p_api_version IN NUMBER
3188: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3189: ,p_contract_id IN okc_k_headers_all_b.id%TYPE
3190: ,p_transaction_id IN okl_trx_contracts_all.khr_id%TYPE
3191: ,p_transaction_type IN VARCHAR2
3192: ,x_return_status OUT NOCOPY VARCHAR2
3193: ,x_msg_count OUT NOCOPY NUMBER
3194: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 3352: FROM okl_trx_contracts_all a

3348: IS
3349: SELECT 1
3350: FROM dual
3351: WHERE EXISTS (SELECT a.id
3352: FROM okl_trx_contracts_all a
3353: ,okl_trx_types_v b
3354: WHERE a.khr_id = p_contract_id
3355: AND a.try_id = b.id
3356: --rkuttiya added for 12.1.1 Multi GAAP

Line 3536: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

3532: AND tax_line_status_code = 'INACTIVE'
3533: AND adjusted_doc_trx_id IS NOT NULL
3534: AND adjusted_doc_trx_line_id IS NOT NULL);
3535:
3536: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3537: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3538:
3539:
3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;

Line 3537: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

3533: AND adjusted_doc_trx_id IS NOT NULL
3534: AND adjusted_doc_trx_line_id IS NOT NULL);
3535:
3536: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3537: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3538:
3539:
3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3541: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;

Line 3554: l_trxh_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

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;
3558: l_rule_info_csr rule_info_csr%ROWTYPE;

Line 3813: -- Create Upfront Tax Header TRX record in OKL_TRX_CONTRACTS table

3809: , G_MODULE
3810: ,'OKL: create_upfront_tax_accounting Procedure: Calling populate_transaction procedure ');
3811: END IF;
3812:
3813: -- Create Upfront Tax Header TRX record in OKL_TRX_CONTRACTS table
3814: populate_transaction(
3815: p_api_version => p_api_version,
3816: p_init_msg_list => p_init_msg_list,
3817: p_contract_id => p_contract_id,

Line 3877: , 'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Trx_Contracts_Pub.create_trx_cntrct_lines ');

3873: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
3874: THEN
3875: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
3876: ,G_MODULE
3877: , 'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Trx_Contracts_Pub.create_trx_cntrct_lines ');
3878: END IF;
3879:
3880: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(
3881: p_api_version => p_api_version,

Line 3880: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(

3876: ,G_MODULE
3877: , 'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Trx_Contracts_Pub.create_trx_cntrct_lines ');
3878: END IF;
3879:
3880: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(
3881: p_api_version => p_api_version,
3882: p_init_msg_list => p_init_msg_list,
3883: x_return_status => x_return_status,
3884: x_msg_count => x_msg_count,

Line 4053: -- Create Upfront Tax Header TRX record in OKL_TRX_CONTRACTS table

4049: , G_MODULE
4050: ,'OKL: create_upfront_tax_accounting Procedure: Calling populate_transaction procedure ');
4051: END IF;
4052:
4053: -- Create Upfront Tax Header TRX record in OKL_TRX_CONTRACTS table
4054: populate_transaction(
4055: p_api_version => p_api_version,
4056: p_init_msg_list => p_init_msg_list,
4057: p_contract_id => p_contract_id,

Line 4115: , 'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Trx_Contracts_Pub.create_trx_cntrct_lines ');

4111: IF (G_IS_DEBUG_STATEMENT_ON = TRUE)
4112: THEN
4113: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT
4114: ,G_MODULE
4115: , 'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Trx_Contracts_Pub.create_trx_cntrct_lines ');
4116: END IF;
4117:
4118: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(
4119: p_api_version => p_api_version,

Line 4118: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(

4114: ,G_MODULE
4115: , 'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Trx_Contracts_Pub.create_trx_cntrct_lines ');
4116: END IF;
4117:
4118: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(
4119: p_api_version => p_api_version,
4120: p_init_msg_list => p_init_msg_list,
4121: x_return_status => x_return_status,
4122: x_msg_count => x_msg_count,

Line 4600: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';

4596: l_booking_capitalized_tax NUMBER;
4597: L_prebook_capitalized_tax NUMBER;
4598: l_booking_billable_tax NUMBER;
4599: l_contract_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
4600: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
4601: l_billed_assets NUMBER :=0;
4602: l_asset_count NUMBER :=0;
4603: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4604: l_fee_type OKC_RULES_B.rule_information1%TYPE;

Line 5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5117: x_msg_count OUT NOCOPY NUMBER,
5118: x_msg_data OUT NOCOPY VARCHAR2) IS
5119:
5120: -- Define PL/SQL Records and Tables
5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5125:

Line 5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

5118: x_msg_data OUT NOCOPY VARCHAR2) IS
5119:
5120: -- Define PL/SQL Records and Tables
5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5125:
5126: -- Define variables

Line 5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5119:
5120: -- Define PL/SQL Records and Tables
5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5125:
5126: -- Define variables
5127: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

5120: -- Define PL/SQL Records and Tables
5121: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5122: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5123: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5124: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
5125:
5126: -- Define variables
5127: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
5128: l_transaction_id NUMBER;

Line 5152: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';

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;
5154: -- l_tax_schedule_yn VARCHAR2(1) := NULL; -- this variable is not required in R12
5155:
5156: -- Bug 4748910 - START