DBA Data[Home] [Help]

APPS.OKL_TRANS_CONTRACTS_PVT dependencies on OKL_TRX_CONTRACTS

Line 59: l_functional_currency okl_trx_contracts.currency_code%TYPE;

55:
56: l_api_version NUMBER := 1.0;
57: l_try_id NUMBER := 0;
58: l_tcnv_rec tcnv_rec_type := p_tcnv_rec;
59: l_functional_currency okl_trx_contracts.currency_code%TYPE;
60:
61: -- Added by Santonyr on 22-Nov-2002 Multi-Currency
62:
63: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;

Line 189: OKL_TRX_CONTRACTS_PUB.create_trx_contracts( p_api_version => l_api_version

185: (p_amount => p_tcnv_rec.amount,
186: p_currency_code => l_tcnv_rec.currency_code);
187:
188:
189: OKL_TRX_CONTRACTS_PUB.create_trx_contracts( p_api_version => l_api_version
190: ,p_init_msg_list => p_init_msg_list
191: ,x_return_status => x_return_status
192: ,x_msg_count => x_msg_count
193: ,x_msg_data => x_msg_data

Line 219: l_functional_currency okl_trx_contracts.currency_code%TYPE;

215: IS
216:
217: l_api_version NUMBER := 1.0;
218: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TRX_CONTRACTS';
219: l_functional_currency okl_trx_contracts.currency_code%TYPE;
220:
221: l_try_id NUMBER := 0;
222: l_tcnv_rec tcnv_rec_type := p_tcnv_rec;
223:

Line 378: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(p_api_version => l_api_version,

374: (p_amount => p_tcnv_rec.amount,
375: p_currency_code => l_tcnv_rec.currency_code);
376:
377:
378: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(p_api_version => l_api_version,
379: p_init_msg_list => p_init_msg_list,
380: x_return_status => l_return_status,
381: x_msg_count => x_msg_count,
382: x_msg_data => x_msg_data,

Line 511: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines(p_api_version => l_api_version,

507: END IF;
508:
509: l_tclv_rec.TCL_TYPE := 'MAE';
510:
511: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines(p_api_version => l_api_version,
512: p_init_msg_list => p_init_msg_list,
513: x_return_status => x_return_status,
514: x_msg_count => x_msg_count,
515: x_msg_data => x_msg_data,

Line 609: OKL_TRX_CONTRACTS_PUB.update_trx_contracts( p_api_version => l_api_version

605: p_msg_name => 'OKL_TRX_AMT_GT_LINE_AMT');
606: RAISE OKL_API.G_EXCEPTION_ERROR;
607: END IF;
608:
609: OKL_TRX_CONTRACTS_PUB.update_trx_contracts( p_api_version => l_api_version
610: ,p_init_msg_list => p_init_msg_list
611: ,x_return_status => x_return_status
612: ,x_msg_count => x_msg_count
613: ,x_msg_data => x_msg_data

Line 649: FROM OKL_TRX_CONTRACTS

645:
646:
647: CURSOR tcn_csr(v_tcn_id NUMBER) IS
648: SELECT tsu_code
649: FROM OKL_TRX_CONTRACTS
650: WHERE id = v_tcn_id;
651:
652:
653: tcl_rec tcl_csr%ROWTYPE;

Line 655: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;

651:
652:
653: tcl_rec tcl_csr%ROWTYPE;
654: l_source_id_tbl OKL_REVERSAL_PUB.SOURCE_ID_TBL_TYPE;
655: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
656: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
657: l_acct_date DATE := SYSDATE;
658:
659: l_total_dist NUMBER := 0;

Line 716: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,

712: RAISE OKL_API.G_EXCEPTION_ERROR;
713: END IF;
714:
715:
716: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
717: p_init_msg_list => p_init_msg_list,
718: x_return_status => l_return_status,
719: x_msg_count => x_msg_count,
720: x_msg_data => x_msg_data,

Line 875: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(p_api_version => l_api_version,

871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:
874:
875: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(p_api_version => l_api_version,
876: p_init_msg_list => p_init_msg_list,
877: x_return_status => x_return_status,
878: x_msg_count => x_msg_count,
879: x_msg_data => x_msg_data,

Line 902: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(p_api_version => l_api_version,

898: l_api_version NUMBER := 1.0;
899:
900: BEGIN
901:
902: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(p_api_version => l_api_version,
903: p_init_msg_list => p_init_msg_list,
904: x_return_status => x_return_status,
905: x_msg_count => x_msg_count,
906: x_msg_data => x_msg_data,

Line 925: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(p_api_version => l_api_version,

921:
922: l_api_version NUMBER := 1.0;
923:
924: BEGIN
925: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(p_api_version => l_api_version,
926: p_init_msg_list => p_init_msg_list,
927: x_return_status => x_return_status,
928: x_msg_count => x_msg_count,
929: x_msg_data => x_msg_data,

Line 949: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(p_api_version => l_api_version,

945:
946: BEGIN
947:
948:
949: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(p_api_version => l_api_version,
950: p_init_msg_list => p_init_msg_list,
951: x_return_status => x_return_status,
952: x_msg_count => x_msg_count,
953: x_msg_data => x_msg_data,

Line 971: OKL_TRX_CONTRACTS_PUB.delete_trx_cntrct_lines(p_api_version => l_api_version,

967: l_api_version NUMBER := 1.0;
968:
969: BEGIN
970:
971: OKL_TRX_CONTRACTS_PUB.delete_trx_cntrct_lines(p_api_version => l_api_version,
972: p_init_msg_list => p_init_msg_list,
973: x_return_status => x_return_status,
974: x_msg_count => x_msg_count,
975: x_msg_data => x_msg_data,

Line 994: OKL_TRX_CONTRACTS_PUB.delete_trx_cntrct_lines(p_api_version => l_api_version,

990: l_api_version NUMBER := 1.0;
991:
992: BEGIN
993:
994: OKL_TRX_CONTRACTS_PUB.delete_trx_cntrct_lines(p_api_version => l_api_version,
995: p_init_msg_list => p_init_msg_list,
996: x_return_status => x_return_status,
997: x_msg_count => x_msg_count,
998: x_msg_data => x_msg_data,