APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_K_LINES

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

705: -- History : BAKUCHIB 10-DEC-2002 Bug 2484327 Created
706: -- RMUNJULU 24-JAN-03 2759726 Changed cursor and removed
707: -- contract sts check
708: -- End of comments
709: FUNCTION check_asset_sno(p_asset_line IN OKL_K_LINES.ID%TYPE,
710: x_sno_yn OUT NOCOPY VARCHAR2,
711: x_clev_tbl OUT NOCOPY clev_tbl_type) RETURN VARCHAR2 AS
712:
713: G_CONTRACT_INACTIVE CONSTANT VARCHAR2(200) := 'OKL_AM_CONTRACT_INACTIVE';

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

720:
721: -- Cursor to Know asset has serial number
722: -- RMUNJULU 24-JAN-03 2759726 Taken out the line status check
723: -- and check line sts same as header sts
724: CURSOR l_asset_sno_csr (p_asset_line IN OKL_K_LINES.ID%TYPE) IS
725: SELECT csi.serial_number,
726: cle_ib.id
727: FROM csi_item_instances csi,
728: okc_k_items cim_ib,

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

756: AND cle_fin.id = p_asset_line;
757:
758: -- To get the Line code of the asset line,
759: -- Status of the contract and the contract number
760: CURSOR l_ast_line_csr(p_asset_line OKL_K_LINES.ID%TYPE)
761: IS
762: SELECT lse.lty_code,
763: cle.sts_code,
764: chr.contract_number