APPS.OKL_OVERRIDE_TAX_BASIS_PVT dependencies on OKL_TAX_BASIS_OVERRIDE

Line 7: -- Description : procedure to create or update rec in OKL_TAX_BASIS_OVERRIDE

3:
4: -- Start of comments
5: --
6: -- Procedure Name : override_tax_basis
7: -- Description : procedure to create or update rec in OKL_TAX_BASIS_OVERRIDE
8: -- Business Rules :
9: -- Parameters :
10: -- Version : 1.0
11: -- History : SECHAWLA - Created

Line 27: -- Check if record already exists in okl_tax_basis_override

23: l_api_name VARCHAR2(30) := 'override_tax_basis';
24: l_api_version CONSTANT NUMBER := G_API_VERSION;
25: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
26:
27: -- Check if record already exists in okl_tax_basis_override
28: CURSOR l_taxbasis_csr(cp_try_id IN NUMBER, cp_org_id IN NUMBER) IS
29: SELECT 'x'
30: FROM okl_tax_basis_override
31: WHERE try_id = cp_try_id

Line 30: FROM okl_tax_basis_override

26:
27: -- Check if record already exists in okl_tax_basis_override
28: CURSOR l_taxbasis_csr(cp_try_id IN NUMBER, cp_org_id IN NUMBER) IS
29: SELECT 'x'
30: FROM okl_tax_basis_override
31: WHERE try_id = cp_try_id
32: AND org_id = cp_org_id;
33:
34: l_dummy VARCHAR2(1);

Line 66: OKL_TAX_BASIS_OVERRIDE_PUB.update_tax_basis_override

62:
63: OPEN l_taxbasis_csr(p_tbov_rec.try_id, p_tbov_rec.org_id);
64: FETCH l_taxbasis_csr INTO l_dummy;
65: IF l_taxbasis_csr%FOUND THEN
66: OKL_TAX_BASIS_OVERRIDE_PUB.update_tax_basis_override
67: (p_api_version => p_api_version,
68: p_init_msg_list => G_FALSE,
69: x_return_status => l_return_status,
70: x_msg_count => x_msg_count,

Line 83: OKL_TAX_BASIS_OVERRIDE_PUB.insert_tax_basis_override

79: RAISE G_EXCEPTION_ERROR;
80: END IF;
81: ELSE
82: -- Call TAPI insert
83: OKL_TAX_BASIS_OVERRIDE_PUB.insert_tax_basis_override
84: (p_api_version => p_api_version,
85: p_init_msg_list => G_FALSE,
86: x_return_status => l_return_status,
87: x_msg_count => x_msg_count,

Line 177: -- Description : procedure to create or update rec in OKL_TAX_BASIS_OVERRIDE

173:
174: -- Start of comments
175: --
176: -- Procedure Name : override_tax_basis
177: -- Description : procedure to create or update rec in OKL_TAX_BASIS_OVERRIDE
178: -- Business Rules :
179: -- Parameters :
180: -- Version : 1.0
181: -- History : SMODUGA - Created