APPS.OAM_GCS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

    SELECT count(*)
	INTO qcount
	FROM fnd_concurrent_queues
	WHERE UPPER(node_name) =UPPER(node)
	 AND TO_NUMBER(manager_type) = (select service_id
		FROM fnd_cp_services where service_handle='OAMGCS');

Line: 55

	        SELECT count(*)
		INTO ncount
		FROM fnd_concurrent_queues
		WHERE concurrent_queue_name = mgr_name;

Line: 61

			SELECT fnd_concurrent_queues_s.nextval
			INTO dummy
			FROM dual;

Line: 75

		DELETE FROM fnd_concurrent_queues_tl
		WHERE concurrent_queue_name = mgr_name;

Line: 101

			error_message:='Concurrent Manager not found to update OAM GCS';

Line: 115

PROCEDURE UPDATE_GCS

		Procedure to update a service instance

PARAMETERS

node		node name to use as service instance

Oracle_home	Value of ORACLE_HOME for the node specified

Interval

*/

PROCEDURE update_gcs(node IN varchar2,Oracle_home IN varchar2 DEFAULT null, rti_dir IN varchar2 DEFAULT null,interval IN number DEFAULT 300000)
IS
	mgr_name VARCHAR2(36);

Line: 159

	SELECT concurrent_queue_id INTO queue_id
		FROM  fnd_concurrent_queues
			WHERE application_id=0 AND concurrent_queue_name LIKE mgr_name;

Line: 163

	/* Update the workshift for this queue_id with new svc_params */

	UPDATE fnd_concurrent_queue_size
		SET   service_parameters = svcparams
			WHERE concurrent_queue_id = queue_id AND queue_application_id = 0;

Line: 172

			error_message:='Concurrent Manager not found to update OAM GCS';

Line: 178

			FND_MESSAGE.SET_NAME('FND','FND_OAMGCS_UPDATE_ERR');

Line: 180

			FND_LOG.MESSAGE (FND_LOG.LEVEL_ERROR,'FND.PLSQL.AFAMGCSB.OAM_GCS.UPDATE_OAMGCS',TRUE);

Line: 182

END update_gcs;

Line: 187

PROCEDURE DELETE_GCS

		Procedure to delete a service instance

PARAMETERS

node		node name to use as service instance


*/

PROCEDURE delete_gcs(node IN varchar2)
IS
	mgr_name VARCHAR2(36);

Line: 210

	DELETE FROM  fnd_concurrent_queues
			WHERE application_id=0 AND concurrent_queue_name LIKE mgr_name and UPPER(node_name)=upper(node);

Line: 213

END delete_gcs;

Line: 243

		   SELECT count(concurrent_queue_id) into instance_count
		   FROM
		   fnd_concurrent_queues where concurrent_queue_name like mgr_name AND
		   upper(node_name) = upper(node);

Line: 279

            SELECT application_id,concurrent_queue_id INTO appl_id,conc_queue_id                 FROM fnd_concurrent_queues
                  where  concurrent_queue_name like mgr_name
                        AND     upper(node_name) = upper(node);