QUEUE_SERVER

Arguments:

Source

Legend: comment string keyword reserved word operator

     1: PROCEDURE
     2: queue_server(server_id_in IN NUMBER, immediate_in IN NUMBER := 1)
     3: IS
     4:     org_id_tmp NUMBER;
     5: BEGIN
     6:     IF immediate_in > 0
     7:     THEN
     8:         DELETE FROM rhnServerNeededPackageCache WHERE server_id = server_id_in;
     9:         INSERT INTO rhnServerNeededPackageCache
    10:        	    (SELECT org_id, server_id, errata_id, package_id
    11: 	       FROM rhnServerNeededPackageView
    12:               WHERE server_id = server_id_in);
    13: 	DELETE FROM rhnServerNeededErrataCache snec WHERE server_id = server_id_in;
    14: 	insert into rhnServerNeededErrataCache
    15: 	    (select distinct org_id, server_id, errata_id
    16: 	       from rhnServerNeededPackageCache
    17: 	      where server_id = server_id_in
    18: 	        and errata_id is not null);
    19:     ELSE
    20:           SELECT org_id INTO org_id_tmp FROM rhnServer WHERE id = server_id_in;
    21: 	  INSERT
    22:             INTO rhnTaskQueue
    23:                  (org_id, task_name, task_data)
    24:           VALUES (org_id_tmp,
    25:                   'update_server_errata_cache',
    26:                   server_id_in);
    27:     END IF;
    28: END queue_server;