APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_K_LINES

Line 698: FUNCTION check_asset_sno(p_asset_line IN OKL_K_LINES.ID%TYPE,

694: -- History : BAKUCHIB 10-DEC-2002 Bug 2484327 Created
695: -- RMUNJULU 24-JAN-03 2759726 Changed cursor and removed
696: -- contract sts check
697: -- End of comments
698: FUNCTION check_asset_sno(p_asset_line IN OKL_K_LINES.ID%TYPE,
699: x_sno_yn OUT NOCOPY VARCHAR2,
700: x_clev_tbl OUT NOCOPY clev_tbl_type) RETURN VARCHAR2 AS
701:
702: G_CONTRACT_INACTIVE CONSTANT VARCHAR2(200) := 'OKL_AM_CONTRACT_INACTIVE';

Line 713: CURSOR l_asset_sno_csr (p_asset_line IN OKL_K_LINES.ID%TYPE) IS

709:
710: -- Cursor to Know asset has serial number
711: -- RMUNJULU 24-JAN-03 2759726 Taken out the line status check
712: -- and check line sts same as header sts
713: CURSOR l_asset_sno_csr (p_asset_line IN OKL_K_LINES.ID%TYPE) IS
714: SELECT csi.serial_number,
715: cle_ib.id
716: FROM csi_item_instances csi,
717: okc_k_items cim_ib,

Line 749: CURSOR l_ast_line_csr(p_asset_line OKL_K_LINES.ID%TYPE)

745: AND cle_fin.id = p_asset_line;
746:
747: -- To get the Line code of the asset line,
748: -- Status of the contract and the contract number
749: CURSOR l_ast_line_csr(p_asset_line OKL_K_LINES.ID%TYPE)
750: IS
751: SELECT lse.lty_code,
752: cle.sts_code,
753: chr.contract_number