APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_TRX_TYPES_V

Line 1630: l_trx_type okl_trx_types_v.id%TYPE;

1626: FROM okl_trx_types_tl
1627: WHERE name = cp_name
1628: AND LANGUAGE = cp_language;
1629:
1630: l_trx_type okl_trx_types_v.id%TYPE;
1631:
1632: BEGIN
1633:
1634: l_trx_type := NULL;

Line 6647: l_trx_type_id Okl_Trx_Types_V.id%TYPE;

6643: l_okl_trx_created VARCHAR2(1) := OKL_API.G_FALSE;
6644: create_stream_invoice_failed EXCEPTION;
6645:
6646: -- 5033120
6647: l_trx_type_id Okl_Trx_Types_V.id%TYPE;
6648: l_trx_try_id Okl_Trx_Types_V.try_id%TYPE;
6649: l_trx_desc Okl_Trx_Types_V.description%TYPE;
6650:
6651: l_tcn_type FND_LOOKUPS.lookup_code%TYPE;

Line 6648: l_trx_try_id Okl_Trx_Types_V.try_id%TYPE;

6644: create_stream_invoice_failed EXCEPTION;
6645:
6646: -- 5033120
6647: l_trx_type_id Okl_Trx_Types_V.id%TYPE;
6648: l_trx_try_id Okl_Trx_Types_V.try_id%TYPE;
6649: l_trx_desc Okl_Trx_Types_V.description%TYPE;
6650:
6651: l_tcn_type FND_LOOKUPS.lookup_code%TYPE;
6652: l_tcn_meaning FND_LOOKUPS.meaning%TYPE;

Line 6649: l_trx_desc Okl_Trx_Types_V.description%TYPE;

6645:
6646: -- 5033120
6647: l_trx_type_id Okl_Trx_Types_V.id%TYPE;
6648: l_trx_try_id Okl_Trx_Types_V.try_id%TYPE;
6649: l_trx_desc Okl_Trx_Types_V.description%TYPE;
6650:
6651: l_tcn_type FND_LOOKUPS.lookup_code%TYPE;
6652: l_tcn_meaning FND_LOOKUPS.meaning%TYPE;
6653: l_tcn_desc FND_LOOKUPS.description%TYPE;

Line 6696: FROM okl_trx_types_v

6692:
6693:
6694: CURSOR trx_type_csr (p_trx_name VARCHAR2) IS
6695: SELECT id, try_id, description
6696: FROM okl_trx_types_v
6697: WHERE name = p_trx_name;
6698:
6699:
6700: CURSOR fnd_lookup_csr (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS