PACKAGE BODY: APPS.IEO_QUEUE

Source

1 PACKAGE BODY IEO_QUEUE AS
2 /* $Header: ieogqnb.pls 115.3 2002/12/27 01:09:08 edwang noship $ */
3 
4      l_schema varchar2(30);
5      l_status varchar2(1);
6      l_industry varchar2(1);
7 
8 BEGIN
9 	IF (fnd_installation.get_app_info('IEO',l_status, l_industry, l_schema))
10 	THEN
11 		IEO_QUEUE.queue_name_1 := l_schema||'.'||'IEO_ICSM_QUEUE_1';
12 		IEO_QUEUE.queue_name_2 := l_schema||'.'||'IEO_ICSM_QUEUE_2';
13 	ELSE
14 		raise_application_error(-20000,'Failed to get information for product '|| 'IEO');
15 	END IF;
16     --dbms_output.put_line('QueueName'|| IEO_QUEUE.queue_name_1);
17     --dbms_output.put_line('QueueName'|| IEO_QUEUE.queue_name_2);
18 END;