1418: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;
1419:
1420: CURSOR get_inv_and_organization_id IS
1421: SELECT object1_id1, object1_id2
1422: FROM okc_k_items
1423: WHERE cle_id = p_line_id;
1424:
1425: CURSOR get_lrt_bto IS
1426: SELECT NVL(LINE_RENEWAL_TYPE_CODE,'FUL') LINE_RENEWAL_TYPE_CODE, BILL_TO_SITE_USE_ID, START_DATE, END_DATE