DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_TRX_TYPES_V

Line 5260: FROM okl_trx_types_v try

5256:
5257: -- Added by rravikir (eBTax enhancement) Bug 5866207
5258: CURSOR get_try_id_csr (p_trx_name IN VARCHAR2) IS
5259: SELECT try.id
5260: FROM okl_trx_types_v try
5261: WHERE try.name = p_trx_name;
5262:
5263: l_try_id NUMBER;
5264: -- End (eBTax enhancement) Bug 5866207

Line 5737: FROM okl_trx_types_v try

5733:
5734: -- rmunjulu Sales_Tax_Enhancement
5735: CURSOR get_try_id_csr (p_trx_name IN VARCHAR2) IS
5736: SELECT try.id
5737: FROM okl_trx_types_v try
5738: WHERE try.name = p_trx_name;
5739:
5740: -- rmunjulu Sales_Tax_Enhancement
5741: l_qte_id NUMBER;

Line 5744: l_trx_name okl_trx_types_v.name%TYPE;

5740: -- rmunjulu Sales_Tax_Enhancement
5741: l_qte_id NUMBER;
5742: l_amount NUMBER;
5743: l_try_id NUMBER;
5744: l_trx_name okl_trx_types_v.name%TYPE;
5745: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_quote_line';
5746: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
5747: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
5748: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);