DBA Data[Home] [Help]

APPS.OKL_LA_JE_PVT dependencies on OKL_TRX_CONTRACTS

Line 102: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

98: x_trxH_rec OUT NOCOPY tcnv_rec_type) IS
99:
100:
101: -- Define PL/SQL Records and Tables
102: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
103: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
104: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
105: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
106:

Line 103: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

99:
100:
101: -- Define PL/SQL Records and Tables
102: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
103: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
104: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
105: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
106:
107: -- Define variables

Line 104: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

100:
101: -- Define PL/SQL Records and Tables
102: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
103: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
104: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
105: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
106:
107: -- Define variables
108: l_sysdate DATE;

Line 105: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

101: -- Define PL/SQL Records and Tables
102: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
103: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
104: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
105: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
106:
107: -- Define variables
108: l_sysdate DATE;
109: l_sysdate_trunc DATE;

Line 237: From okl_trx_contracts txh

233: Cursor trx_csr( khrId NUMBER, tcntype VARCHAR2 ) is
234: Select txh.ID HeaderTransID,
235: txh.date_transaction_occurred date_transaction_occurred,
236: txh.tsu_code
237: From okl_trx_contracts txh
238: Where txh.tcn_type = tcntype
239: and txh.khr_id = khrId
240: --rkuttiya added for 12.1.1 Multi GAAP
241: and txh.representation_type = 'PRIMARY';

Line 270: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

266: l_has_trans VARCHAR2(1);
267: l_memo_yn VARCHAR2(1);
268:
269: --Bug# 3153003
270: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
271: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
272: --Bug# 3153003
273:
274: --Bug# 4622198

Line 271: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

267: l_memo_yn VARCHAR2(1);
268:
269: --Bug# 3153003
270: l_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
271: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
272: --Bug# 3153003
273:
274: --Bug# 4622198
275: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

Line 289: l_trxl_del_tbl Okl_trx_contracts_pvt.tclv_tbl_type;

285: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
286: l_legal_entity_id NUMBER;
287:
288: --Bug# 5964482
289: l_trxl_del_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
290: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
291: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
292: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
293: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;

Line 290: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;

286: l_legal_entity_id NUMBER;
287:
288: --Bug# 5964482
289: l_trxl_del_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
290: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
291: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
292: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
293: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
294:

Line 291: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;

287:
288: --Bug# 5964482
289: l_trxl_del_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
290: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
291: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
292: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
293: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
294:
295: /* New Type Declarations*/

Line 292: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;

288: --Bug# 5964482
289: l_trxl_del_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
290: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
291: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
292: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
293: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
294:
295: /* New Type Declarations*/
296: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;

Line 293: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;

289: l_trxl_del_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
290: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
291: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
292: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
293: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
294:
295: /* New Type Declarations*/
296: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
297: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;

Line 590: Okl_Trx_Contracts_Pub.create_trx_contracts(

586: l_trxH_in_rec.attribute15 := l_product_rec.khr_attribute15;
587: --Bug# 5964482 : End
588:
589: -- Create Transaction Header, Lines
590: Okl_Trx_Contracts_Pub.create_trx_contracts(
591: p_api_version => l_api_version
592: ,p_init_msg_list => l_init_msg_list
593: ,x_return_status => x_return_status
594: ,x_msg_count => l_msg_count

Line 622: --Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(

618: -- Create Transaction Line
619: --l_trxL_in_rec.tcn_id := l_trxH_out_rec.id;
620:
621: -- Create Transaction Header, Lines
622: --Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(
623: --p_api_version => l_api_version
624: --,p_init_msg_list => l_init_msg_list
625: --,x_return_status => x_return_status
626: --,x_msg_count => l_msg_count

Line 653: Okl_Trx_Contracts_Pub.update_trx_contracts(

649: -----------------
650: --if transaction exists change the date transaction occured
651: l_upd_trxH_rec.id := l_trx_rec.HeaderTransID;
652: l_upd_trxH_rec.date_transaction_occurred := l_transaction_date;
653: Okl_Trx_Contracts_Pub.update_trx_contracts(
654: p_api_version => l_api_version
655: ,p_init_msg_list => l_init_msg_list
656: ,x_return_status => x_return_status
657: ,x_msg_count => l_msg_count

Line 700: okl_trx_contracts_pub.delete_trx_cntrct_lines(

696: Loop
697: l_trxl_del_tbl(i).id := l_trx_rec.linetransid;
698: End Loop;
699:
700: okl_trx_contracts_pub.delete_trx_cntrct_lines(
701: p_api_version => l_api_version,
702: p_init_msg_list => l_init_msg_list,
703: x_return_status => x_return_status,
704: x_msg_count => l_msg_count,

Line 803: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'|| x_return_status);

799:
800:
801: --Call to create transaction lines
802: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
803: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'|| x_return_status);
804: END IF;
805: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(
806: p_api_version => l_api_version
807: ,p_init_msg_list => l_init_msg_list

Line 805: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(

801: --Call to create transaction lines
802: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
803: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'|| x_return_status);
804: END IF;
805: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(
806: p_api_version => l_api_version
807: ,p_init_msg_list => l_init_msg_list
808: ,x_return_status => x_return_status
809: ,x_msg_count => l_msg_count

Line 814: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'|| x_return_status);

810: ,x_msg_data => l_msg_data
811: ,p_tclv_tbl => l_tclv_tbl
812: ,x_tclv_tbl => x_tclv_tbl);
813: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
814: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'|| x_return_status);
815: END IF;
816: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
818: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 990: Okl_Trx_Contracts_Pub.update_trx_contracts

986: End If; -- If l_tclv_tbl.COUNT
987:
988:
989: --Making the call to update the amounts on transaction header and line
990: Okl_Trx_Contracts_Pub.update_trx_contracts
991: (p_api_version => p_api_version
992: ,p_init_msg_list => p_init_msg_list
993: ,x_return_status => x_return_status
994: ,x_msg_count => x_msg_count

Line 1071: Okl_Trx_Contracts_Pub.update_trx_contracts(

1067: l_trxL_in_rec.amount := null;
1068:
1069: End If;
1070:
1071: Okl_Trx_Contracts_Pub.update_trx_contracts(
1072: p_api_version => l_api_version
1073: ,p_init_msg_list => l_init_msg_list
1074: ,x_return_status => x_return_status
1075: ,x_msg_count => l_msg_count

Line 1080: Okl_Trx_Contracts_Pub.update_trx_cntrct_lines(

1076: ,x_msg_data => l_msg_data
1077: ,p_tcnv_rec => l_trxH_in_rec
1078: ,x_tcnv_rec => l_trxH_out_rec);
1079:
1080: Okl_Trx_Contracts_Pub.update_trx_cntrct_lines(
1081: p_api_version => l_api_version
1082: ,p_init_msg_list => l_init_msg_list
1083: ,x_return_status => x_return_status
1084: ,x_msg_count => l_msg_count

Line 1202: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1198: x_return_status OUT NOCOPY VARCHAR2,
1199: x_msg_count OUT NOCOPY NUMBER,
1200: x_msg_data OUT NOCOPY VARCHAR2) IS
1201:
1202: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1203:
1204: Begin
1205:
1206: generate_journal_entries(