DBA Data[Home] [Help]

APPS.OKL_TRANSACTION_PVT dependencies on OKL_TRX_CONTRACTS

Line 18: -- subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

14: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - Start
15: G_REBOOK_TRX CONSTANT VARCHAR(30) := 'REBOOK';
16: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - End
17:
18: -- subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
19:
20: /*
21: -- mvasudev, 08/17/2004
22: -- Added Constants to enable Business Event

Line 313: FROM okl_trx_contracts trx,

309: -- Bug# 9851889
310: -- Modified cursor to pick up Rebook and Re-lease Contract transactions
311: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS
312: SELECT trx.id, trx.representation_type --sechawla 01-oct-09 8967918 : added representation type
313: FROM okl_trx_contracts trx,
314: okl_trx_types_tl try
315: WHERE trx.khr_id_new = p_chr_id_new
316: AND try.id = trx.try_id
317: AND try.language = 'US'

Line 368: Okl_Trx_Contracts_Pub.update_trx_contracts(

364: l_tcnv_rec.id := trx_rec.id;
365: l_tcnv_rec.tsu_code := p_status; --CANCELED
366: --END LOOP; --sechawla 01-oct-09 8967918 : moved update within the loop
367:
368: Okl_Trx_Contracts_Pub.update_trx_contracts(
369: p_api_version => p_api_version,
370: p_init_msg_list => p_init_msg_list,
371: x_return_status => x_return_status,
372: x_msg_count => x_msg_count,

Line 851: okl_trx_contracts_pub.create_trx_contracts(

847: RAISE OKC_API.G_EXCEPTION_ERROR;
848: END IF;
849:
850: -- Create Transaction Header only
851: okl_trx_contracts_pub.create_trx_contracts(
852: p_api_version => 1.0,
853: p_init_msg_list => p_init_msg_list,
854: x_return_status => x_return_status,
855: x_msg_count => x_msg_count,

Line 976: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';

972:
973: --akrangan added for ebtax rebook changes starts
974: l_source_trx_id NUMBER;
975: l_source_trx_name VARCHAR2(150);
976: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
977: l_prbk_tcnv_rec tcnv_rec_type;
978: x_prbk_tcnv_rec tcnv_rec_type;
979: --akrangan added for ebtax rebook changes ends
980:

Line 1061: Okl_Trx_Contracts_Pub.update_trx_contracts(

1057: IF l_source_trx_name = 'Pre-Rebook' THEN
1058: l_prbk_tcnv_rec.id := l_source_trx_id;
1059: l_prbk_tcnv_rec.tsu_code := p_tsu_code;
1060:
1061: Okl_Trx_Contracts_Pub.update_trx_contracts(
1062: p_api_version => p_api_version,
1063: p_init_msg_list => p_init_msg_list,
1064: x_return_status => x_return_status,
1065: x_msg_count => x_msg_count,

Line 1318: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE calling okl_trx_contracts_pub.create_trx_contracts');

1314: l_tcnv_rec.currency_code := con_header_rec.currency_code;
1315: END LOOP;
1316:
1317: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1318: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE calling okl_trx_contracts_pub.create_trx_contracts');
1319: END IF;
1320: -- Create Transaction Header only
1321: okl_trx_contracts_pub.create_trx_contracts(
1322: p_api_version => 1.0,

Line 1321: okl_trx_contracts_pub.create_trx_contracts(

1317: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1318: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE calling okl_trx_contracts_pub.create_trx_contracts');
1319: END IF;
1320: -- Create Transaction Header only
1321: okl_trx_contracts_pub.create_trx_contracts(
1322: p_api_version => 1.0,
1323: p_init_msg_list => p_init_msg_list,
1324: x_return_status => x_return_status,
1325: x_msg_count => x_msg_count,

Line 1332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');

1328: x_tcnv_rec => l_out_tcnv_rec
1329: );
1330:
1331: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');
1333: END IF;
1334:
1335: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1336: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1524: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE calling okl_trx_contracts_pub.create_trx_contracts');

1520: l_tcnv_rec.currency_code := con_header_rec.currency_code;
1521: END LOOP;
1522:
1523: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1524: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE calling okl_trx_contracts_pub.create_trx_contracts');
1525: END IF;
1526: -- Create Transaction Header only
1527: okl_trx_contracts_pub.create_trx_contracts(
1528: p_api_version => 1.0,

Line 1527: okl_trx_contracts_pub.create_trx_contracts(

1523: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1524: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE calling okl_trx_contracts_pub.create_trx_contracts');
1525: END IF;
1526: -- Create Transaction Header only
1527: okl_trx_contracts_pub.create_trx_contracts(
1528: p_api_version => 1.0,
1529: p_init_msg_list => p_init_msg_list,
1530: x_return_status => x_return_status,
1531: x_msg_count => x_msg_count,

Line 1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');

1534: x_tcnv_rec => l_out_tcnv_rec
1535: );
1536:
1537: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');
1539: END IF;
1540:
1541: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1542: RAISE OKC_API.G_EXCEPTION_ERROR;