APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKC_K_LINES_B

Line 2020: l_kle_id okc_k_lines_b.id%TYPE;

2016: lp_clev_rec clev_rec_type;
2017: lx_clev_rec clev_rec_type;
2018: lp_klev_rec klev_rec_type;
2019: lx_klev_rec klev_rec_type;
2020: l_kle_id okc_k_lines_b.id%TYPE;
2021:
2022: CURSOR c_pool_upd IS
2023: SELECT id
2024: FROM okl_pools

Line 2035: FROM apps.okc_k_lines_b cle

2031: -- Replacing this by writing two cursors with top line first
2032: -- and sub lines next
2033: CURSOR c_agr_lns(p_khr_id okc_k_headers_b.id%TYPE) IS
2034: SELECT cle.id
2035: FROM apps.okc_k_lines_b cle
2036: WHERE cle.dnz_chr_id = p_khr_id
2037: ;
2038: */
2039: CURSOR l_okl_top_lines_csr(p_khr_id IN NUMBER)

Line 2042: FROM okc_k_lines_b clet

2038: */
2039: CURSOR l_okl_top_lines_csr(p_khr_id IN NUMBER)
2040: IS
2041: SELECT clet.id
2042: FROM okc_k_lines_b clet
2043: WHERE clet.dnz_chr_id = p_khr_id
2044: AND clet.cle_id IS NULL;
2045:
2046: CURSOR l_okl_sub_lines_csr(p_khr_id IN NUMBER,p_kle_id IN NUMBER)

Line 2049: FROM okc_k_lines_b cles

2045:
2046: CURSOR l_okl_sub_lines_csr(p_khr_id IN NUMBER,p_kle_id IN NUMBER)
2047: IS
2048: SELECT cles.id
2049: FROM okc_k_lines_b cles
2050: WHERE cles.dnz_chr_id = p_khr_id
2051: AND cles.cle_id = p_kle_id;
2052: -- end, mvasudev changes, 11/04/2003
2053:

Line 2496: l_kle_id OKC_K_LINES_B.ID%TYPE;

2492: IS
2493: l_api_name CONSTANT VARCHAR2(30) := 'activate_sec_agreement_pvt';
2494: l_api_version CONSTANT NUMBER := 1.0;
2495: i NUMBER;
2496: l_kle_id OKC_K_LINES_B.ID%TYPE;
2497: l_pol_id OKL_POOLS.ID%TYPE;
2498: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2499: l_org_id OKL_POOLS.ORG_ID%TYPE;
2500: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;

Line 3124: l_kle_id OKC_K_LINES_B.ID%TYPE;

3120: IS
3121: l_api_name CONSTANT VARCHAR2(30) := 'update_sec_agreement_sts';
3122: l_api_version CONSTANT NUMBER := 1.0;
3123: i NUMBER;
3124: l_kle_id OKC_K_LINES_B.ID%TYPE;
3125: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3126:
3127: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3128:

Line 3147: FROM apps.okc_k_lines_b cle

3143: -- mvasudev, Fixed bug#3987171
3144: /*
3145: CURSOR c_agr_lns IS
3146: SELECT cle.id
3147: FROM apps.okc_k_lines_b cle
3148: WHERE cle.dnz_chr_id = p_sec_agreement_id
3149: ;
3150: */
3151: CURSOR c_agr_lns IS

Line 3153: FROM okc_k_lines_b cle

3149: ;
3150: */
3151: CURSOR c_agr_lns IS
3152: SELECT cle.id
3153: FROM okc_k_lines_b cle
3154: WHERE cle.dnz_chr_id = p_sec_agreement_id
3155: ;
3156:
3157: BEGIN

Line 3434: l_kle_id OKC_K_LINES_B.ID%TYPE;

3430:
3431: l_api_name CONSTANT VARCHAR2(30) := 'activate_add_request';
3432: l_api_version CONSTANT NUMBER := 1.0;
3433: i NUMBER;
3434: l_kle_id OKC_K_LINES_B.ID%TYPE;
3435: l_pol_id OKL_POOLS.ID%TYPE;
3436: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3437: l_org_id OKL_POOLS.ORG_ID%TYPE;
3438: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;

Line 3513: FROM OKC_K_LINES_B TOP_LINE,

3509: IS
3510: SELECT TOP_KLE.ID,
3511: TOP_KLE.AMOUNT original_Stake,
3512: TOP_KLE.AMOUNT_STAKE additional_Stake
3513: FROM OKC_K_LINES_B TOP_LINE,
3514: OKL_K_LINES TOP_KLE,
3515: OKC_K_PARTY_ROLES_B PARTY_ROLE
3516: WHERE TOP_LINE.dnz_chr_id = p_khr_id
3517: AND TOP_KLE.ID = TOP_LINE.ID

Line 4300: FROM OKC_K_LINES_B TOP_LINE,

4296: IS
4297: SELECT TOP_KLE.ID,
4298: TOP_KLE.AMOUNT original_Stake,
4299: TOP_KLE.AMOUNT_STAKE additional_Stake
4300: FROM OKC_K_LINES_B TOP_LINE,
4301: OKL_K_LINES TOP_KLE,
4302: OKC_K_PARTY_ROLES_B PARTY_ROLE
4303: WHERE TOP_LINE.dnz_chr_id = p_khr_id
4304: AND TOP_KLE.ID = TOP_LINE.ID