DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_TRX_TYPES_TL

Line 1014: p_transaction_type IN okl_trx_types_tl.name%TYPE,

1010: Procedure populate_transaction(
1011: p_api_version IN NUMBER,
1012: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1013: p_contract_id IN okc_k_headers_all_b.id%TYPE,
1014: p_transaction_type IN okl_trx_types_tl.name%TYPE,
1015: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
1016: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
1017: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
1018: --Bug# 6619311

Line 1039: FROM okl_trx_types_tl

1035:
1036: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE )
1037: IS
1038: SELECT id
1039: FROM okl_trx_types_tl
1040: WHERE name = p_transaction_type
1041: AND language = 'US';
1042:
1043: Cursor trx_csr( khrId NUMBER, tcntype VARCHAR2 ) is

Line 5369: FROM OKL_TRX_TYPES_TL

5365: WHERE ID = p_contract_id;
5366:
5367: CURSOR c_try_type(p_name IN VARCHAR2) IS
5368: SELECT ID
5369: FROM OKL_TRX_TYPES_TL
5370: WHERE name = p_name
5371: AND LANGUAGE = 'US';
5372:
5373: l_currency_code VARCHAR2(15);