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_AM_LEASE_TRMNT_PVT dependencies on OKL_TRX_CONTRACTS

Line 598: FROM OKL_TRX_CONTRACTS trx

594: -- Check if another transaction exists which is processed and for which tmt_evergreen_yn was Y
595: -- which means this contract was evergreen earlier
596: CURSOR chk_evergreen_ear_csr ( p_khr_id IN NUMBER, p_tcn_id IN NUMBER) IS
597: SELECT trx.tmt_evergreen_yn
598: FROM OKL_TRX_CONTRACTS trx
599: WHERE trx.khr_id = p_khr_id
600: AND trx.tmt_status_code = 'PROCESSED' --changed by akrangan sla tmt_status_code changes
601: AND trx.tcn_type IN ('TMT','ALT','EVG')-- akrangan bug 5354501 fix added 'EVG'
602: AND trx.tmt_evergreen_yn = 'Y'

Line 2399: FROM OKL_TRX_CONTRACTS TRN

2395:
2396: -- Get the nonprocessed termination transaction for the contract
2397: CURSOR get_trn_csr (p_khr_id IN NUMBER) IS
2398: SELECT TRN.tmt_recycle_yn
2399: FROM OKL_TRX_CONTRACTS TRN
2400: WHERE TRN.khr_id = p_khr_id
2401: AND TRN.tmt_status_code NOT IN ('PROCESSED', 'CANCELED') --akrangan changes for sla tmt_status_code cr
2402: AND TRN.tcn_type in ( 'TMT','EVG') --akrangan bug 5354501 fix added 'EVG'
2403: AND TRN.representation_type = 'PRIMARY'; --rkuttiya added for 12.1.1

Line 2718: FROM okl_trx_contracts trx

2714: -- Fetch tmt_status_code
2715:
2716: CURSOR c_tmt_status_code_csr (p_qte_id IN NUMBER) IS
2717: SELECT tmt_status_code
2718: FROM okl_trx_contracts trx
2719: WHERE trx.qte_id = p_qte_id
2720: --rkuttiya added for 12.1.1 Multi GAAP
2721: AND trx.representation_type = 'PRIMARY';
2722:

Line 3342: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');

3338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'p_trn_mode = '||p_trn_mode);
3339: END IF;
3340: IF p_trn_mode = 'INSERT' THEN
3341: IF (is_debug_statement_on) THEN
3342: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
3343: END IF;
3344: -- insert transaction rec
3345: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
3346: p_api_version => p_api_version,

Line 3345: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(

3341: IF (is_debug_statement_on) THEN
3342: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
3343: END IF;
3344: -- insert transaction rec
3345: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
3346: p_api_version => p_api_version,
3347: p_init_msg_list => OKL_API.G_FALSE,
3348: x_return_status => l_return_status,
3349: x_msg_count => x_msg_count,

Line 3354: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.insert_trx_contracts l_return_status = '||l_return_status);

3350: x_msg_data => x_msg_data,
3351: p_tcnv_rec => lp_tcnv_rec,
3352: x_tcnv_rec => lx_tcnv_rec);
3353: IF (is_debug_statement_on) THEN
3354: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.insert_trx_contracts l_return_status = '||l_return_status);
3355: END IF;
3356: ELSIF p_trn_mode = 'UPDATE' THEN
3357: IF (is_debug_statement_on) THEN
3358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

Line 3358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

3354: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.insert_trx_contracts l_return_status = '||l_return_status);
3355: END IF;
3356: ELSIF p_trn_mode = 'UPDATE' THEN
3357: IF (is_debug_statement_on) THEN
3358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
3359: END IF;
3360:
3361: -- update transaction rec
3362: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

Line 3362: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

3358: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
3359: END IF;
3360:
3361: -- update transaction rec
3362: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
3363: p_api_version => p_api_version,
3364: p_init_msg_list => OKL_API.G_FALSE,
3365: x_return_status => l_return_status,
3366: x_msg_count => x_msg_count,

Line 3371: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.update_trx_contracts l_return_status = '||l_return_status);

3367: x_msg_data => x_msg_data,
3368: p_tcnv_rec => lp_tcnv_rec,
3369: x_tcnv_rec => lx_tcnv_rec);
3370: IF (is_debug_statement_on) THEN
3371: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called OKL_TRX_CONTRACTS_PUB.update_trx_contracts l_return_status = '||l_return_status);
3372: END IF;
3373: END IF;
3374:
3375: -- rollback if error

Line 6358: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;

6354: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
6355: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
6356: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
6357: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
6358: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
6359: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6360: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6361: l_trans_meaning VARCHAR2(200);
6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

Line 6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6358: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
6359: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6360: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6361: l_trans_meaning VARCHAR2(200);
6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6363: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6364: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6365: i NUMBER;
6366: l_total_amount NUMBER := 0;

Line 6363: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6359: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6360: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6361: l_trans_meaning VARCHAR2(200);
6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6363: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6364: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6365: i NUMBER;
6366: l_total_amount NUMBER := 0;
6367: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;

Line 6364: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6360: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6361: l_trans_meaning VARCHAR2(200);
6362: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6363: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6364: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6365: i NUMBER;
6366: l_total_amount NUMBER := 0;
6367: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6368: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;

Line 6369: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;

6365: i NUMBER;
6366: l_total_amount NUMBER := 0;
6367: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6368: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
6369: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6370: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6371: l_product_type VARCHAR2(2000);
6372: l_line_number NUMBER := 1;
6373:

Line 6370: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;

6366: l_total_amount NUMBER := 0;
6367: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6368: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
6369: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6370: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6371: l_product_type VARCHAR2(2000);
6372: l_line_number NUMBER := 1;
6373:
6374: -- RMUNJULU 23-DEC-02 2726739 Added variables

Line 6394: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE; -- MGAAP 7263041

6390:
6391: -- SMODUGA added variable for userdefined streams 3925469
6392: lx_sty_id NUMBER;
6393: lx_sty_id_rep NUMBER; -- MGAAP 7263041
6394: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE; -- MGAAP 7263041
6395: lx_pretax_sty_id NUMBER;
6396: lx_rentaccrual_sty_id NUMBER;
6397:
6398: -- MDOKAL Bug 3061765

Line 6534: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;

6530: --akrangan Bug 5514059 end
6531: --akrangan sla single accounting call to ae uptake starts
6532: l_org_id NUMBER(15);
6533: --txl contracts specific tbl types
6534: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6535: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6536: --ae new table types declaration
6537: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
6538: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;

Line 6535: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;

6531: --akrangan sla single accounting call to ae uptake starts
6532: l_org_id NUMBER(15);
6533: --txl contracts specific tbl types
6534: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6535: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6536: --ae new table types declaration
6537: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
6538: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
6539: l_ctxt_tbl okl_account_dist_pvt.ctxt_tbl_type;

Line 6547: -- desc flex fields columns in okl_trx_contracts

6543: l_tcn_id NUMBER;
6544:
6545: --hdr dff fields cursor
6546: --this cursor is to populate the
6547: -- desc flex fields columns in okl_trx_contracts
6548: CURSOR trx_contracts_dff_csr(p_khr_id IN NUMBER) IS
6549: SELECT attribute_category,
6550: attribute1,
6551: attribute2,

Line 6614: l_currency_code okl_trx_contracts.currency_code%TYPE;

6610: SELECT NAME,
6611: tax_owner
6612: FROM okl_product_parameters_v
6613: WHERE id = p_pdt_id;
6614: l_currency_code okl_trx_contracts.currency_code%TYPE;
6615: --loop variables
6616: j NUMBER;
6617: k NUMBER;
6618: l NUMBER;

Line 6927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');

6923: EXIT WHEN(i = lix_template_tbl.LAST);
6924: i := lix_template_tbl.NEXT(i);
6925: END LOOP;
6926: IF (is_debug_statement_on) THEN
6927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');
6928: END IF;
6929: --create trx contract lines table
6930: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,
6931: p_init_msg_list => okl_api.g_false,

Line 6930: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,

6926: IF (is_debug_statement_on) THEN
6927: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');
6928: END IF;
6929: --create trx contract lines table
6930: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,
6931: p_init_msg_list => okl_api.g_false,
6932: x_return_status => l_return_status,
6933: x_msg_count => x_msg_count,
6934: x_msg_data => x_msg_data,

Line 6938: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_trx_contracts_pub.create_trx_cntrct_lines l_return_status = '||l_return_status);

6934: x_msg_data => x_msg_data,
6935: p_tclv_tbl => l_tclv_tbl,
6936: x_tclv_tbl => lx_tclv_tbl);
6937: IF (is_debug_statement_on) THEN
6938: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_trx_contracts_pub.create_trx_cntrct_lines l_return_status = '||l_return_status);
6939: END IF;
6940:
6941: -- If error inserting line then set message
6942: IF l_return_status <> okl_api.g_ret_sts_success

Line 7153: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');

7149: END LOOP;
7150: END IF;
7151: --call the api to update trx contracts hdr and lines
7152: IF (is_debug_statement_on) THEN
7153: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');
7154: END IF;
7155: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,
7156: p_init_msg_list => okl_api.g_false,
7157: x_return_status => l_return_status,

Line 7155: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,

7151: --call the api to update trx contracts hdr and lines
7152: IF (is_debug_statement_on) THEN
7153: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');
7154: END IF;
7155: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,
7156: p_init_msg_list => okl_api.g_false,
7157: x_return_status => l_return_status,
7158: x_msg_count => x_msg_count,
7159: x_msg_data => x_msg_data,

Line 7166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_trx_contracts_pub.update_trx_contracts l_return_status = '||l_return_status);

7162: x_tcnv_rec => lix_tcnv_rec,
7163: x_tclv_tbl => lx_tclv_tbl);
7164: --handle exception
7165: IF (is_debug_statement_on) THEN
7166: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'called okl_trx_contracts_pub.update_trx_contracts l_return_status = '||l_return_status);
7167: END IF;
7168: IF l_return_status <> okl_api.g_ret_sts_success
7169: THEN
7170: -- Error occurred when creating accounting entries for transaction TRX_TYPE.

Line 10963: p_trx_source_table => 'OKL_TRX_CONTRACTS',

10959: END IF;
10960:
10961: -- Save messages from stack into transaction message table
10962: OKL_AM_UTIL_PVT.process_messages(
10963: p_trx_source_table => 'OKL_TRX_CONTRACTS',
10964: p_trx_id => lp_tcnv_rec.id,
10965: x_return_status => l_return_status);
10966:
10967: -- RMUNJULU 3018641 Added code to get and set TMG_RUN

Line 11036: p_trx_source_table => 'OKL_TRX_CONTRACTS',

11032: END IF;
11033:
11034: -- Save messages from stack into transaction message table
11035: OKL_AM_UTIL_PVT.process_messages(
11036: p_trx_source_table => 'OKL_TRX_CONTRACTS',
11037: p_trx_id => lp_tcnv_rec.id,
11038: x_return_status => l_return_status);
11039:
11040: -- RMUNJULU 3018641 Added code to get and set TMG_RUN

Line 11106: p_trx_source_table => 'OKL_TRX_CONTRACTS',

11102: END IF;
11103:
11104: -- Save messages from stack into transaction message table
11105: OKL_AM_UTIL_PVT.process_messages(
11106: p_trx_source_table => 'OKL_TRX_CONTRACTS',
11107: p_trx_id => lp_tcnv_rec.id,
11108: x_return_status => l_return_status);
11109:
11110: -- RMUNJULU 3018641 Added code to get and set TMG_RUN

Line 11393: p_trx_source_table => 'OKL_TRX_CONTRACTS',

11389: END IF;
11390:
11391: -- Save messages from stack into transaction message table
11392: OKL_AM_UTIL_PVT.process_messages(
11393: p_trx_source_table => 'OKL_TRX_CONTRACTS',
11394: p_trx_id => lp_tcnv_rec.id,
11395: x_return_status => l_return_status);
11396:
11397: -- RMUNJULU 3018641 Added code to get and set TMG_RUN