LOOKUP_PACKAGE_CAPABILITY

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: LOOKUP_PACKAGE_CAPABILITY(name_in IN VARCHAR2,
     3:     version_in IN VARCHAR2 DEFAULT NULL)
     4: RETURN NUMBER
     5: DETERMINISTIC
     6: IS
     7: 	PRAGMA AUTONOMOUS_TRANSACTION;
     8: 	name_id		NUMBER;
     9: BEGIN
    10: 	IF version_in IS NULL THEN
    11: 		SELECT id
    12: 		  INTO name_id
    13: 		  FROM rhnPackageCapability
    14: 		 WHERE name = name_in
    15: 		   AND version IS NULL;
    16: 	ELSE
    17: 		SELECT id
    18: 		  INTO name_id
    19: 		  FROM rhnPackageCapability
    20: 		 WHERE name = name_in
    21: 		   AND version = version_in;
    22: 	END IF;
    23: 	RETURN name_id;
    24: EXCEPTION
    25:         WHEN NO_DATA_FOUND THEN
    26:             INSERT INTO rhnPackageCapability (id, name, version)
    27:                 VALUES (rhn_pkg_capability_id_seq.nextval, name_in, version_in)
    28:                 RETURNING id INTO name_id;
    29:             COMMIT;
    30: 	RETURN name_id;
    31: END;