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 482: FROM OKL_TRX_CONTRACTS trx

478: -- Check if another transaction exists which is processed and for which tmt_evergreen_yn was Y
479: -- which means this contract was evergreen earlier
480: CURSOR chk_evergreen_ear_csr ( p_khr_id IN NUMBER, p_tcn_id IN NUMBER) IS
481: SELECT trx.tmt_evergreen_yn
482: FROM OKL_TRX_CONTRACTS trx
483: WHERE trx.khr_id = p_khr_id
484: AND trx.tmt_status_code = 'PROCESSED' --changed by akrangan sla tmt_status_code changes
485: AND trx.tcn_type IN ('TMT','ALT','EVG')-- akrangan bug 5354501 fix added 'EVG'
486: AND trx.tmt_evergreen_yn = 'Y'

Line 2283: FROM OKL_TRX_CONTRACTS TRN

2279:
2280: -- Get the nonprocessed termination transaction for the contract
2281: CURSOR get_trn_csr (p_khr_id IN NUMBER) IS
2282: SELECT TRN.tmt_recycle_yn
2283: FROM OKL_TRX_CONTRACTS TRN
2284: WHERE TRN.khr_id = p_khr_id
2285: AND TRN.tmt_status_code NOT IN ('PROCESSED', 'CANCELED') --akrangan changes for sla tmt_status_code cr
2286: AND TRN.tcn_type in ( 'TMT','EVG') --akrangan bug 5354501 fix added 'EVG'
2287: AND TRN.representation_type = 'PRIMARY'; --rkuttiya added for 12.1.1

Line 2602: FROM okl_trx_contracts trx

2598: -- Fetch tmt_status_code
2599:
2600: CURSOR c_tmt_status_code_csr (p_qte_id IN NUMBER) IS
2601: SELECT tmt_status_code
2602: FROM okl_trx_contracts trx
2603: WHERE trx.qte_id = p_qte_id
2604: --rkuttiya added for 12.1.1 Multi GAAP
2605: AND trx.representation_type = 'PRIMARY';
2606:

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

3222: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'p_trn_mode = '||p_trn_mode);
3223: END IF;
3224: IF p_trn_mode = 'INSERT' THEN
3225: IF (is_debug_statement_on) THEN
3226: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
3227: END IF;
3228: -- insert transaction rec
3229: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
3230: p_api_version => p_api_version,

Line 3229: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(

3225: IF (is_debug_statement_on) THEN
3226: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
3227: END IF;
3228: -- insert transaction rec
3229: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
3230: p_api_version => p_api_version,
3231: p_init_msg_list => OKL_API.G_FALSE,
3232: x_return_status => l_return_status,
3233: x_msg_count => x_msg_count,

Line 3238: 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);

3234: x_msg_data => x_msg_data,
3235: p_tcnv_rec => lp_tcnv_rec,
3236: x_tcnv_rec => lx_tcnv_rec);
3237: IF (is_debug_statement_on) THEN
3238: 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);
3239: END IF;
3240: ELSIF p_trn_mode = 'UPDATE' THEN
3241: IF (is_debug_statement_on) THEN
3242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

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

3238: 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);
3239: END IF;
3240: ELSIF p_trn_mode = 'UPDATE' THEN
3241: IF (is_debug_statement_on) THEN
3242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
3243: END IF;
3244:
3245: -- update transaction rec
3246: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

Line 3246: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

3242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
3243: END IF;
3244:
3245: -- update transaction rec
3246: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
3247: p_api_version => p_api_version,
3248: p_init_msg_list => OKL_API.G_FALSE,
3249: x_return_status => l_return_status,
3250: x_msg_count => x_msg_count,

Line 3255: 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);

3251: x_msg_data => x_msg_data,
3252: p_tcnv_rec => lp_tcnv_rec,
3253: x_tcnv_rec => lx_tcnv_rec);
3254: IF (is_debug_statement_on) THEN
3255: 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);
3256: END IF;
3257: END IF;
3258:
3259: -- rollback if error

Line 6192: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;

6188: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
6189: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
6190: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
6191: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
6192: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
6193: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6194: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6195: l_trans_meaning VARCHAR2(200);
6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

Line 6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6192: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
6193: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6194: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6195: l_trans_meaning VARCHAR2(200);
6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6197: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6198: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6199: i NUMBER;
6200: l_total_amount NUMBER := 0;

Line 6197: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6193: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
6194: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6195: l_trans_meaning VARCHAR2(200);
6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6197: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6198: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6199: i NUMBER;
6200: l_total_amount NUMBER := 0;
6201: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;

Line 6198: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;

6194: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
6195: l_trans_meaning VARCHAR2(200);
6196: lp_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6197: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6198: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
6199: i NUMBER;
6200: l_total_amount NUMBER := 0;
6201: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6202: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;

Line 6203: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;

6199: i NUMBER;
6200: l_total_amount NUMBER := 0;
6201: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6202: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
6203: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6204: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6205: l_product_type VARCHAR2(2000);
6206: l_line_number NUMBER := 1;
6207:

Line 6204: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;

6200: l_total_amount NUMBER := 0;
6201: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
6202: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
6203: lip_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6204: lix_tcnv_rec okl_trx_contracts_pub.tcnv_rec_type;
6205: l_product_type VARCHAR2(2000);
6206: l_line_number NUMBER := 1;
6207:
6208: -- RMUNJULU 23-DEC-02 2726739 Added variables

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

6224:
6225: -- SMODUGA added variable for userdefined streams 3925469
6226: lx_sty_id NUMBER;
6227: lx_sty_id_rep NUMBER; -- MGAAP 7263041
6228: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE; -- MGAAP 7263041
6229: lx_pretax_sty_id NUMBER;
6230: lx_rentaccrual_sty_id NUMBER;
6231:
6232: -- MDOKAL Bug 3061765

Line 6368: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;

6364: --akrangan Bug 5514059 end
6365: --akrangan sla single accounting call to ae uptake starts
6366: l_org_id NUMBER(15);
6367: --txl contracts specific tbl types
6368: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6369: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6370: --ae new table types declaration
6371: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
6372: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;

Line 6369: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;

6365: --akrangan sla single accounting call to ae uptake starts
6366: l_org_id NUMBER(15);
6367: --txl contracts specific tbl types
6368: l_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6369: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
6370: --ae new table types declaration
6371: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
6372: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
6373: l_ctxt_tbl okl_account_dist_pvt.ctxt_tbl_type;

Line 6381: -- desc flex fields columns in okl_trx_contracts

6377: l_tcn_id NUMBER;
6378:
6379: --hdr dff fields cursor
6380: --this cursor is to populate the
6381: -- desc flex fields columns in okl_trx_contracts
6382: CURSOR trx_contracts_dff_csr(p_khr_id IN NUMBER) IS
6383: SELECT attribute_category,
6384: attribute1,
6385: attribute2,

Line 6448: l_currency_code okl_trx_contracts.currency_code%TYPE;

6444: SELECT NAME,
6445: tax_owner
6446: FROM okl_product_parameters_v
6447: WHERE id = p_pdt_id;
6448: l_currency_code okl_trx_contracts.currency_code%TYPE;
6449: --loop variables
6450: j NUMBER;
6451: k NUMBER;
6452: l NUMBER;

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

6751: EXIT WHEN(i = lix_template_tbl.LAST);
6752: i := lix_template_tbl.NEXT(i);
6753: END LOOP;
6754: IF (is_debug_statement_on) THEN
6755: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');
6756: END IF;
6757: --create trx contract lines table
6758: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,
6759: p_init_msg_list => okl_api.g_false,

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

6754: IF (is_debug_statement_on) THEN
6755: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.create_trx_cntrct_lines');
6756: END IF;
6757: --create trx contract lines table
6758: okl_trx_contracts_pub.create_trx_cntrct_lines(p_api_version => p_api_version,
6759: p_init_msg_list => okl_api.g_false,
6760: x_return_status => l_return_status,
6761: x_msg_count => x_msg_count,
6762: x_msg_data => x_msg_data,

Line 6766: 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);

6762: x_msg_data => x_msg_data,
6763: p_tclv_tbl => l_tclv_tbl,
6764: x_tclv_tbl => lx_tclv_tbl);
6765: IF (is_debug_statement_on) THEN
6766: 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);
6767: END IF;
6768:
6769: -- If error inserting line then set message
6770: IF l_return_status <> okl_api.g_ret_sts_success

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

6977: END LOOP;
6978: END IF;
6979: --call the api to update trx contracts hdr and lines
6980: IF (is_debug_statement_on) THEN
6981: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');
6982: END IF;
6983: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,
6984: p_init_msg_list => okl_api.g_false,
6985: x_return_status => l_return_status,

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

6979: --call the api to update trx contracts hdr and lines
6980: IF (is_debug_statement_on) THEN
6981: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'calling okl_trx_contracts_pub.update_trx_contracts');
6982: END IF;
6983: okl_trx_contracts_pub.update_trx_contracts(p_api_version => p_api_version,
6984: p_init_msg_list => okl_api.g_false,
6985: x_return_status => l_return_status,
6986: x_msg_count => x_msg_count,
6987: x_msg_data => x_msg_data,

Line 6994: 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);

6990: x_tcnv_rec => lix_tcnv_rec,
6991: x_tclv_tbl => lx_tclv_tbl);
6992: --handle exception
6993: IF (is_debug_statement_on) THEN
6994: 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);
6995: END IF;
6996: IF l_return_status <> okl_api.g_ret_sts_success
6997: THEN
6998: -- Error occurred when creating accounting entries for transaction TRX_TYPE.

Line 10764: p_trx_source_table => 'OKL_TRX_CONTRACTS',

10760: END IF;
10761:
10762: -- Save messages from stack into transaction message table
10763: OKL_AM_UTIL_PVT.process_messages(
10764: p_trx_source_table => 'OKL_TRX_CONTRACTS',
10765: p_trx_id => lp_tcnv_rec.id,
10766: x_return_status => l_return_status);
10767:
10768: -- RMUNJULU 3018641 Added code to get and set TMG_RUN

Line 10837: p_trx_source_table => 'OKL_TRX_CONTRACTS',

10833: END IF;
10834:
10835: -- Save messages from stack into transaction message table
10836: OKL_AM_UTIL_PVT.process_messages(
10837: p_trx_source_table => 'OKL_TRX_CONTRACTS',
10838: p_trx_id => lp_tcnv_rec.id,
10839: x_return_status => l_return_status);
10840:
10841: -- RMUNJULU 3018641 Added code to get and set TMG_RUN

Line 10907: p_trx_source_table => 'OKL_TRX_CONTRACTS',

10903: END IF;
10904:
10905: -- Save messages from stack into transaction message table
10906: OKL_AM_UTIL_PVT.process_messages(
10907: p_trx_source_table => 'OKL_TRX_CONTRACTS',
10908: p_trx_id => lp_tcnv_rec.id,
10909: x_return_status => l_return_status);
10910:
10911: -- RMUNJULU 3018641 Added code to get and set TMG_RUN

Line 11194: p_trx_source_table => 'OKL_TRX_CONTRACTS',

11190: END IF;
11191:
11192: -- Save messages from stack into transaction message table
11193: OKL_AM_UTIL_PVT.process_messages(
11194: p_trx_source_table => 'OKL_TRX_CONTRACTS',
11195: p_trx_id => lp_tcnv_rec.id,
11196: x_return_status => l_return_status);
11197:
11198: -- RMUNJULU 3018641 Added code to get and set TMG_RUN