DBA Data[Home] [Help]

APPS.MSD_AW_LOADER dependencies on DBMS_AW

Line 11: -- dbms_aw.execute('awwaittime = 1000000; &(if aw(attached ''ODPCODE'') then ''shw NA'' else ''aw attach ODPCODE rw wait'')');

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

Line 17: dbms_aw.AW_ATTACH('ODPCODE_PATCH_EDITION',true,true,'wait');

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;

Line 19: dbms_aw.AW_ATTACH('ODPCODE',true,true,'wait');

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

Line 26: dbms_aw.execute('&(if exists(''_noupdate'') then ''shw na'' else ''upd'')');

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;