Line 431: SELECT ahl_util_uc_pkg.get_uc_header_id(l_customer_product_id) into l_uc_hdr_id from dual;
427: l_accomplished_date := SYSDATE;
428: END IF;
429:
430: /* retrieve active unit on which SR instance is installed */ 431: SELECT ahl_util_uc_pkg.get_uc_header_id(l_customer_product_id) into l_uc_hdr_id from dual; 432: IF (l_uc_hdr_id is not null)
433: THEN
434: -- if the instance's unit is in QUARANTINE/DEACTIVATE_QUARANTINE throw error
435: -- if the instance's unit is COMPLETE/INCOMPLETE, it is active hence use the unit
[Home] [Help]