[Home] [Help]
803: ) IS
804:
805: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
806: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
807: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
808: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
809: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
810: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;
811: l_asset_status OKL_K_LINES_FULL_V.sts_code%TYPE;
817: l_session_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
818: l_count_asset NUMBER := 0;
819: message VARCHAR2(200);
820: l_msg_tbl msg_tbl_type;
821: /*this cursor retrives the contract_id and status from OKC_K_HEADERS_B with contract number
822: as input parameter*/
823: CURSOR get_chr_dtls_csr(p_chr_no IN VARCHAR2) IS
824: SELECT id,sts_code,authoring_org_id
825: FROM okc_k_headers_b
821: /*this cursor retrives the contract_id and status from OKC_K_HEADERS_B with contract number
822: as input parameter*/
823: CURSOR get_chr_dtls_csr(p_chr_no IN VARCHAR2) IS
824: SELECT id,sts_code,authoring_org_id
825: FROM okc_k_headers_b
826: WHERE contract_number=p_chr_no;
827: /* this cursor retrives the asset_id,asset_number,asset_status and description from okc_k_lines_v
828: and okc_line_styles_v with contract_id,asset_id,asset_number as input parameters.*/
829: CURSOR get_aset_dtls_csr(p_chr_id IN NUMBER,