APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKC_K_LINES_B

Line 2012: l_kle_id okc_k_lines_b.id%TYPE;

2008: lp_clev_rec clev_rec_type;
2009: lx_clev_rec clev_rec_type;
2010: lp_klev_rec klev_rec_type;
2011: lx_klev_rec klev_rec_type;
2012: l_kle_id okc_k_lines_b.id%TYPE;
2013:
2014: CURSOR c_pool_upd IS
2015: SELECT id
2016: FROM okl_pools

Line 2027: FROM apps.okc_k_lines_b cle

2023: -- Replacing this by writing two cursors with top line first
2024: -- and sub lines next
2025: CURSOR c_agr_lns(p_khr_id okc_k_headers_b.id%TYPE) IS
2026: SELECT cle.id
2027: FROM apps.okc_k_lines_b cle
2028: WHERE cle.dnz_chr_id = p_khr_id
2029: ;
2030: */
2031: CURSOR l_okl_top_lines_csr(p_khr_id IN NUMBER)

Line 2034: FROM okc_k_lines_b clet

2030: */
2031: CURSOR l_okl_top_lines_csr(p_khr_id IN NUMBER)
2032: IS
2033: SELECT clet.id
2034: FROM okc_k_lines_b clet
2035: WHERE clet.dnz_chr_id = p_khr_id
2036: AND clet.cle_id IS NULL;
2037:
2038: CURSOR l_okl_sub_lines_csr(p_khr_id IN NUMBER,p_kle_id IN NUMBER)

Line 2041: FROM okc_k_lines_b cles

2037:
2038: CURSOR l_okl_sub_lines_csr(p_khr_id IN NUMBER,p_kle_id IN NUMBER)
2039: IS
2040: SELECT cles.id
2041: FROM okc_k_lines_b cles
2042: WHERE cles.dnz_chr_id = p_khr_id
2043: AND cles.cle_id = p_kle_id;
2044: -- end, mvasudev changes, 11/04/2003
2045:

Line 2479: l_kle_id OKC_K_LINES_B.ID%TYPE;

2475: IS
2476: l_api_name CONSTANT VARCHAR2(30) := 'activate_sec_agreement_pvt';
2477: l_api_version CONSTANT NUMBER := 1.0;
2478: i NUMBER;
2479: l_kle_id OKC_K_LINES_B.ID%TYPE;
2480: l_pol_id OKL_POOLS.ID%TYPE;
2481: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
2482: l_org_id OKL_POOLS.ORG_ID%TYPE;
2483: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;

Line 3107: l_kle_id OKC_K_LINES_B.ID%TYPE;

3103: IS
3104: l_api_name CONSTANT VARCHAR2(30) := 'update_sec_agreement_sts';
3105: l_api_version CONSTANT NUMBER := 1.0;
3106: i NUMBER;
3107: l_kle_id OKC_K_LINES_B.ID%TYPE;
3108: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3109:
3110: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3111:

Line 3130: FROM apps.okc_k_lines_b cle

3126: -- mvasudev, Fixed bug#3987171
3127: /*
3128: CURSOR c_agr_lns IS
3129: SELECT cle.id
3130: FROM apps.okc_k_lines_b cle
3131: WHERE cle.dnz_chr_id = p_sec_agreement_id
3132: ;
3133: */
3134: CURSOR c_agr_lns IS

Line 3136: FROM okc_k_lines_b cle

3132: ;
3133: */
3134: CURSOR c_agr_lns IS
3135: SELECT cle.id
3136: FROM okc_k_lines_b cle
3137: WHERE cle.dnz_chr_id = p_sec_agreement_id
3138: ;
3139:
3140: BEGIN

Line 3417: l_kle_id OKC_K_LINES_B.ID%TYPE;

3413:
3414: l_api_name CONSTANT VARCHAR2(30) := 'activate_add_request';
3415: l_api_version CONSTANT NUMBER := 1.0;
3416: i NUMBER;
3417: l_kle_id OKC_K_LINES_B.ID%TYPE;
3418: l_pol_id OKL_POOLS.ID%TYPE;
3419: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
3420: l_org_id OKL_POOLS.ORG_ID%TYPE;
3421: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;

Line 3496: FROM OKC_K_LINES_B TOP_LINE,

3492: IS
3493: SELECT TOP_KLE.ID,
3494: TOP_KLE.AMOUNT original_Stake,
3495: TOP_KLE.AMOUNT_STAKE additional_Stake
3496: FROM OKC_K_LINES_B TOP_LINE,
3497: OKL_K_LINES TOP_KLE,
3498: OKC_K_PARTY_ROLES_B PARTY_ROLE
3499: WHERE TOP_LINE.dnz_chr_id = p_khr_id
3500: AND TOP_KLE.ID = TOP_LINE.ID

Line 4272: FROM OKC_K_LINES_B TOP_LINE,

4268: IS
4269: SELECT TOP_KLE.ID,
4270: TOP_KLE.AMOUNT original_Stake,
4271: TOP_KLE.AMOUNT_STAKE additional_Stake
4272: FROM OKC_K_LINES_B TOP_LINE,
4273: OKL_K_LINES TOP_KLE,
4274: OKC_K_PARTY_ROLES_B PARTY_ROLE
4275: WHERE TOP_LINE.dnz_chr_id = p_khr_id
4276: AND TOP_KLE.ID = TOP_LINE.ID