DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_TRX_CONTRACTS

Line 1163: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := null; -- MGAAP

1159: l_inv_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
1160: l_trxv_rec trxv_rec_type;
1161: lx_trxv_rec trxv_rec_type;
1162: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;
1163: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := null; -- MGAAP
1164: l_trx_reason_asset_split VARCHAR2(20) := OKL_SECURITIZATION_PVT.G_TRX_REASON_ASSET_SPLIT;
1165:
1166: --Cursor to check whether split asset transaction is in progress for the contract
1167: CURSOR check_split_trx_csr IS

Line 1628: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1624:
1625: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1626:
1627: -- Define PL/SQL Records and Tables
1628: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1629: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
1630: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1631: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
1632:

Line 1629: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

1625: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1626:
1627: -- Define PL/SQL Records and Tables
1628: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1629: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
1630: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1631: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
1632:
1633: -- Define variables

Line 1630: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

1626:
1627: -- Define PL/SQL Records and Tables
1628: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1629: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
1630: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1631: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
1632:
1633: -- Define variables
1634: l_post_to_gl_yn VARCHAR2(1);

Line 1631: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;

1627: -- Define PL/SQL Records and Tables
1628: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1629: l_trxL_in_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
1630: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1631: l_trxL_out_rec Okl_Trx_Contracts_Pvt.tclv_rec_type;
1632:
1633: -- Define variables
1634: l_post_to_gl_yn VARCHAR2(1);
1635:

Line 1694: lp_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;

1690: l_try_id NUMBER;
1691: G_NO CONSTANT VARCHAR2(1) := 'N';
1692: l_valid_gl_date DATE;
1693: l_product_type VARCHAR2(2000);
1694: lp_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;
1695: lx_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;
1696: li_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;
1697: i NUMBER;
1698: l_total_amount NUMBER := 0;

Line 1695: lx_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;

1691: G_NO CONSTANT VARCHAR2(1) := 'N';
1692: l_valid_gl_date DATE;
1693: l_product_type VARCHAR2(2000);
1694: lp_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;
1695: lx_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;
1696: li_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;
1697: i NUMBER;
1698: l_total_amount NUMBER := 0;
1699: l_line_number NUMBER := 1;

Line 1696: li_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;

1692: l_valid_gl_date DATE;
1693: l_product_type VARCHAR2(2000);
1694: lp_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;
1695: lx_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;
1696: li_tclv_rec OKL_TRX_CONTRACTS_PUB.tclv_rec_type;
1697: i NUMBER;
1698: l_total_amount NUMBER := 0;
1699: l_line_number NUMBER := 1;
1700: l_hard_coded_amount NUMBER := 100;

Line 1702: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;

1698: l_total_amount NUMBER := 0;
1699: l_line_number NUMBER := 1;
1700: l_hard_coded_amount NUMBER := 100;
1701:
1702: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
1703: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
1704: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
1705: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
1706:

Line 1703: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;

1699: l_line_number NUMBER := 1;
1700: l_hard_coded_amount NUMBER := 100;
1701:
1702: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
1703: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
1704: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
1705: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
1706:
1707: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;

Line 1704: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;

1700: l_hard_coded_amount NUMBER := 100;
1701:
1702: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
1703: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
1704: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
1705: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
1706:
1707: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
1708: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;

Line 1705: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;

1701:
1702: l_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
1703: x_tclv_tbl Okl_trx_contracts_pvt.tclv_tbl_type;
1704: l_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
1705: x_tcnv_rec Okl_trx_contracts_pvt.tcnv_rec_type;
1706:
1707: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
1708: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
1709: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;

Line 1840: Okl_Trx_Contracts_Pub.create_trx_contracts(

1836: l_trxH_in_rec.org_id := l_Product_rec.authoring_org_id;
1837: --------------------------------------------------------------------------
1838: -- Create transaction Header and line
1839: --------------------------------------------------------------------------
1840: Okl_Trx_Contracts_Pub.create_trx_contracts(
1841: p_api_version => l_api_version
1842: ,p_init_msg_list => l_init_msg_list
1843: ,x_return_status => l_return_status
1844: ,x_msg_count => l_msg_count

Line 1969: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(

1965: END LOOP;
1966:
1967: --Call to create transaction lines
1968:
1969: Okl_Trx_Contracts_Pub.create_trx_cntrct_lines(
1970: p_api_version => l_api_version
1971: ,p_init_msg_list => l_init_msg_list
1972: ,x_return_status => x_return_status
1973: ,x_msg_count => l_msg_count

Line 2095: Okl_Trx_Contracts_Pub.update_trx_contracts

2091: END LOOP; -- For i in
2092: End If; -- If l_tclv_tbl.COUNT
2093:
2094: --Making the call to update the amounts on transaction header and line
2095: Okl_Trx_Contracts_Pub.update_trx_contracts
2096: (p_api_version => p_api_version
2097: ,p_init_msg_list => p_init_msg_list
2098: ,x_return_status => x_return_status
2099: ,x_msg_count => x_msg_count

Line 14838: okl_trx_contracts t,

14834: WHERE EXISTS
14835: (SELECT 1
14836: FROM okl_trx_quotes_b h,
14837: okl_txl_quote_lines_b l,
14838: okl_trx_contracts t,
14839: okl_k_headers k
14840: WHERE h.id = l.qte_id
14841: AND h.id = t.qte_id
14842: AND h.khr_id = k.id