APPS.OKL_LLA_UTIL_PVT dependencies on OKC_K_LINES_B

Line 886: FROM okc_k_lines_b cle

882: CURSOR l_cle_csr(p_cle_id IN NUMBER)
883: IS
884: SELECT cle.sts_code,
885: cle.dnz_chr_id
886: FROM okc_k_lines_b cle
887: WHERE cle.id = p_cle_id;
888:
889: l_cle_rec l_cle_csr%ROWTYPE;
890: l_chk_rebook_chr VARCHAR2(1);

Line 959: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null

955: p_api_type => G_API_TYPE);
956: END check_line_update_allowed;
957: --Bug# 4959361
958: --added by asawanka
959: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null
960: -- p_khr_id is contract id
961: FUNCTION get_asset_location(
962: p_kle_id IN NUMBER,
963: p_khr_id IN NUMBER)

Line 1073: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null

1069: WHEN OTHERS THEN
1070: RETURN NULL;
1071: END get_asset_location;
1072: --added by asawanka
1073: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null
1074: -- p_khr_id is contract id
1075: FUNCTION get_ast_install_loc_id(
1076: p_kle_id IN NUMBER,
1077: p_khr_id IN NUMBER)

Line 1188: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null

1184: WHEN OTHERS THEN
1185: RETURN NULL;
1186: END get_ast_install_loc_id;
1187: --added by asawanka
1188: -- p_kle_id is top line id. select id from okc_k_lines_b where cle_id is null
1189: -- p_khr_id is contract id
1190: FUNCTION get_booked_asset_number(
1191: p_kle_id IN NUMBER,
1192: p_khr_id IN NUMBER)

Line 1203: , OKC_K_LINES_B CLE_FA

1199: CURSOR l_get_booked_astnum_csr IS
1200: SELECT FAV.ASSET_NUMBER ASSETNUMBER
1201: FROM OKC_K_LINES_V CLE_FIN
1202: , OKC_LINE_STYLES_B LSE_FIN
1203: , OKC_K_LINES_B CLE_FA
1204: , OKC_LINE_STYLES_B LSE_FA
1205: , OKC_K_ITEMS CIM_FA
1206: , FA_ADDITIONS_B FAV
1207: WHERE CLE_FIN.CLE_ID IS NULL