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

Line 551: OKL_TRX_CONTRACTS TRN

547: -- Check if close balances already done thru termination
548: CURSOR get_termination_trn_csr (p_khr_id IN NUMBER) IS
549: SELECT TRN.id
550: FROM OKL_TRX_AR_ADJSTS_V BAL,
551: OKL_TRX_CONTRACTS TRN
552: WHERE TRN.khr_id = p_khr_id
553: AND TRN.tcn_type = 'TMT'
554: AND BAL.tcn_id = TRN.id;
555:

Line 559: FROM OKL_TRX_CONTRACTS TRN

555:
556: -- Check if close balances already done thru termination
557: CURSOR get_writeoff_trn_csr (p_khr_id IN NUMBER) IS
558: SELECT TRN.id
559: FROM OKL_TRX_CONTRACTS TRN
560: WHERE TRN.khr_id = p_khr_id
561: AND TRN.tcn_type = 'BWO';
562:
563: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 912: lp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

908:
909: lp_ajlv_rec OKL_TXL_ADJSTS_LNS_PUB.ajlv_rec_type;
910: lx_ajlv_rec OKL_TXL_ADJSTS_LNS_PUB.ajlv_rec_type;
911: l_ajlv_rec OKL_TXL_ADJSTS_LNS_PUB.ajlv_rec_type;
912: lp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
913: lx_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
914: l_tol_profile_name VARCHAR2(300);
915:
916: -- rmunjulu 4622198

Line 913: lx_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

909: lp_ajlv_rec OKL_TXL_ADJSTS_LNS_PUB.ajlv_rec_type;
910: lx_ajlv_rec OKL_TXL_ADJSTS_LNS_PUB.ajlv_rec_type;
911: l_ajlv_rec OKL_TXL_ADJSTS_LNS_PUB.ajlv_rec_type;
912: lp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
913: lx_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
914: l_tol_profile_name VARCHAR2(300);
915:
916: -- rmunjulu 4622198
917: l_fact_synd_code FND_LOOKUPS.lookup_code%TYPE;

Line 921: lpp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type; -- rmunjulu 4917286

917: l_fact_synd_code FND_LOOKUPS.lookup_code%TYPE;
918: l_inv_acct_code OKC_RULES_B.rule_information1%TYPE;
919:
920: l_total_amount NUMBER; -- rmunjulu 4917286
921: lpp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type; -- rmunjulu 4917286
922: lxx_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type; -- rmunjulu 4917286
923:
924: BEGIN
925: ---

Line 922: lxx_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type; -- rmunjulu 4917286

918: l_inv_acct_code OKC_RULES_B.rule_information1%TYPE;
919:
920: l_total_amount NUMBER; -- rmunjulu 4917286
921: lpp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type; -- rmunjulu 4917286
922: lxx_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type; -- rmunjulu 4917286
923:
924: BEGIN
925: ---
926: --get the tolerance limit from profile

Line 1139: -- * CREATE WRITEOFF TRANSACTION IN OKL_TRX_CONTRACTS START *

1135: -- *** CONVERT CURRENCIES **************************** END ****
1136:
1137: l_total_amount := 0; --rmunjulu 4917286
1138:
1139: -- *** CREATE WRITEOFF TRANSACTION IN OKL_TRX_CONTRACTS ** START *
1140:
1141: -- initialize the transaction rec
1142: lp_tcnv_rec.khr_id := p_khr_rec.id;
1143: lp_tcnv_rec.tcn_type := 'BWO';

Line 1149: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(

1145: lp_tcnv_rec.currency_code := l_currency_code;
1146: lp_tcnv_rec.tsu_code := 'ENTERED';
1147: lp_tcnv_rec.date_transaction_occurred := p_sys_date;
1148:
1149: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(
1150: p_api_version=> p_api_version,
1151: p_init_msg_list=> OKL_API.G_FALSE,
1152: x_return_status => l_return_status,
1153: x_msg_count => x_msg_count,

Line 1169: 'OKL_TRX_CONTRACTS_PUB.create_trx_contracts = '||l_return_status );

1165:
1166: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1168: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1169: 'OKL_TRX_CONTRACTS_PUB.create_trx_contracts = '||l_return_status );
1170: END IF;
1171:
1172: -- Raise exception to rollback this whole block
1173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1179: -- * CREATE WRITEOFF TRANSACTION IN OKL_TRX_CONTRACTS END **

1175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1176: RAISE OKL_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:
1179: -- *** CREATE WRITEOFF TRANSACTION IN OKL_TRX_CONTRACTS ** END **
1180:
1181: -- *** CREATE ADJUSTMENT HEADER TRN IN OKL_TRX_ADJSTS ** START ***
1182: -- set the adjusts rec
1183: lp_adjv_rec.trx_status_code := 'WORKING'; -- tsu_code

Line 1390: -- * UPDATE WRITEOFF TRANSACTION IN OKL_TRX_CONTRACTS START *

1386: END IF;
1387: END IF;
1388:
1389: -- rmunjulu 4917286 update writeoff transaction with total amount
1390: -- *** UPDATE WRITEOFF TRANSACTION IN OKL_TRX_CONTRACTS ** START *
1391: lpp_tcnv_rec.id := lx_tcnv_rec.id;
1392: lpp_tcnv_rec.amount := l_total_amount;
1393:
1394: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

Line 1394: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

1390: -- *** UPDATE WRITEOFF TRANSACTION IN OKL_TRX_CONTRACTS ** START *
1391: lpp_tcnv_rec.id := lx_tcnv_rec.id;
1392: lpp_tcnv_rec.amount := l_total_amount;
1393:
1394: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
1395: p_api_version=> p_api_version,
1396: p_init_msg_list=> OKL_API.G_FALSE,
1397: x_return_status => l_return_status,
1398: x_msg_count => x_msg_count,

Line 1922: OKL_TRX_CONTRACTS TRN

1918: AND trunc(CHR.date_terminated) <= TRUNC(p_date) -- Ended
1919: AND CHR.id NOT IN (-- balance writeoffs already done when contract was fully terminated
1920: SELECT TRN.khr_id
1921: FROM OKL_TRX_AR_ADJSTS_V BAL,
1922: OKL_TRX_CONTRACTS TRN
1923: WHERE BAL.tcn_id = TRN.id
1924: AND TRN.tcn_type = 'TMT' -- full termination
1925: AND TRN.khr_id = CHR.id
1926: -- No need to check for actual step as tcn_id is recorded in AR_ADJSTS table

Line 1930: FROM OKL_TRX_CONTRACTS TRN

1926: -- No need to check for actual step as tcn_id is recorded in AR_ADJSTS table
1927: )
1928: AND CHR.id NOT IN (-- new balance writeoffs done as part of this concurrent program
1929: SELECT TRN.khr_id
1930: FROM OKL_TRX_CONTRACTS TRN
1931: WHERE TRN.tcn_type = 'BWO' -- new transaction type SEED ***
1932: AND TRN.khr_id = CHR.id
1933: )
1934: AND 0 < ( -- Check that invoices with balances greater than 0 exists and dated before today