1018: /* Does the service exist in GSM? */
1019: begin
1020: select concurrent_queue_id, application_id, enabled_flag
1021: into queue_id, queue_appl_id, fcq_enabled_flag
1022: from fnd_concurrent_queues
1023: where application_id = 0
1024: and concurrent_queue_name = short_name;
1025:
1026: /* Yes, the service exists. Otherwise, there would *
1064:
1065: /* Now update enabled flag to 'N' */
1066: select concurrent_queue_id, application_id, enabled_flag
1067: into queue_id, queue_appl_id, fcq_enabled_flag
1068: from fnd_concurrent_queues
1069: where application_id = 0
1070: and concurrent_queue_name = short_name;
1071:
1072: update fnd_concurrent_queues
1068: from fnd_concurrent_queues
1069: where application_id = 0
1070: and concurrent_queue_name = short_name;
1071:
1072: update fnd_concurrent_queues
1073: set enabled_flag = 'N'
1074: where concurrent_queue_id = queue_id
1075: and application_id = queue_appl_id;
1076:
1106:
1107: else /* Service is disabled in context file. */
1108:
1109: /* Update fcq if necessary */
1110: update fnd_concurrent_queues
1111: set enabled_flag = 'N'
1112: where application_id = 0
1113: and concurrent_queue_name = short_name;
1114: