PACKAGE BODY: APPS.ASO_QUEUE

Source

1 PACKAGE BODY ASO_QUEUE AS
2 /* $Header: asoqinsb.pls 115.4 2002/12/07 19:50:37 hagrawal ship $ */
3 
4 
5 -- ---------------------------------------------------------
6 -- Declare Local Variables
7 -- ---------------------------------------------------------
8 l_schema             varchar2(30);
9 l_status             varchar2(1);
10 l_industry           varchar2(1);
11 
12 -- ---------------------------------------------------------
13 -- Initialize Package Globals
14 -- ---------------------------------------------------------
15 
16 BEGIN
17   if (FND_INSTALLATION.get_app_info('ASO', l_status, l_industry, l_schema)) then
18       ASO_QUEUE.ASO_OF_Q :=  l_schema||'.'||'ASO_OF_Q';
19       ASO_QUEUE.ASO_OF_Q_E :=  l_schema||'.'||'ASO_OF_Q_E';
20       ASO_QUEUE.ASO_OF_EXCP_Q := l_schema||'.'||'ASO_OF_EXCP_Q';
21       ASO_QUEUE.ASO_OF_EXCP_Q_E := l_schema||'.'||'ASO_OF_EXCP_Q_E';
22   else
23       raise_application_error(-20000,
24                                'Failed to get information for product'||
25                                'ASO');
26   end if;
27 
28 END ASO_QUEUE;