Line 413: SELECT ahl_util_uc_pkg.get_uc_header_id(l_customer_product_id) into l_uc_hdr_id from dual;
409: l_accomplished_date := SYSDATE;
410: END IF;
411:
412: /* retrieve active unit on which SR instance is installed */ 413: SELECT ahl_util_uc_pkg.get_uc_header_id(l_customer_product_id) into l_uc_hdr_id from dual; 414: IF (l_uc_hdr_id is not null)
415: THEN
416: -- if the instance's unit is in QUARANTINE/DEACTIVATE_QUARANTINE throw error
417: -- if the instance's unit is COMPLETE/INCOMPLETE, it is active hence use the unit
[Home] [Help]