PACKAGE BODY: APPS.MSD_AW_LOADER

Source

1 PACKAGE BODY MSD_AW_LOADER AS
2 /* $Header: msdawldb.pls 120.2.12020000.8 2012/10/19 09:58:33 rissingh ship $ */
3 
4 /* Public Procedures */
5 
6 procedure attach_code_aw is
7 EDITION_TYPE varchar2(15) :=NULL;
8 
9 begin
10   -- attach ODPCODE rw, create it if it does not exist
11   -- dbms_aw.execute('awwaittime = 1000000; &(if aw(attached ''ODPCODE'') then ''shw NA'' else ''aw attach ODPCODE rw wait'')');
12 
13   -- modified for Online patching support
14 
15   select upper(ad_zd.get_edition_type) into EDITION_TYPE from dual;  -- This will give error when executed in Non editioned environment
16   if EDITION_TYPE = 'PATCH' then
17   dbms_aw.AW_ATTACH('ODPCODE_PATCH_EDITION',true,true,'wait');
18   else
19   dbms_aw.AW_ATTACH('ODPCODE',true,true,'wait');
20   end if;
21 end attach_code_aw;
22 
23 procedure update_code_aw is
24 begin
25   -- Issue an update if _noupdate flag is not set
26   dbms_aw.execute('&(if exists(''_noupdate'') then ''shw na'' else ''upd'')');
27 end update_code_aw;
28 
29 
30 END MSD_AW_LOADER;