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: IS
     6: 	PRAGMA AUTONOMOUS_TRANSACTION;
     7: 	name_id		NUMBER;
     8: BEGIN
     9: 	IF version_in IS NULL THEN
    10: 		SELECT id
    11: 		  INTO name_id
    12: 		  FROM rhnPackageCapability
    13: 		 WHERE name = name_in
    14: 		   AND version IS NULL;
    15: 	ELSE
    16: 		SELECT id
    17: 		  INTO name_id
    18: 		  FROM rhnPackageCapability
    19: 		 WHERE name = name_in
    20: 		   AND version = version_in;
    21: 	END IF;
    22: 	RETURN name_id;
    23: EXCEPTION
    24:         WHEN NO_DATA_FOUND THEN
    25:             INSERT INTO rhnPackageCapability (id, name, version)
    26:                 VALUES (rhn_pkg_capability_id_seq.nextval, name_in, version_in)
    27:                 RETURNING id INTO name_id;
    28:             COMMIT;
    29: 	RETURN name_id;
    30: END;