DBA Data[Home] [Help]

APPS.QPR_DELETE_AW dependencies on DBMS_AW

Line 87: dbms_aw.aw_detach('APPS',l_aw_name1);

83: if (aw_exists(l_aw_name1)) then
84: fnd_file.put_line(fnd_file.log,'the analytic workspace '||l_aw_name1||
85: 'exists in schema apps '||to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
86:
87: dbms_aw.aw_detach('APPS',l_aw_name1);
88:
89: l_stmtnum := 60;
90:
91: dbms_aw.aw_delete('APPS',l_aw_name1);

Line 91: dbms_aw.aw_delete('APPS',l_aw_name1);

87: dbms_aw.aw_detach('APPS',l_aw_name1);
88:
89: l_stmtnum := 60;
90:
91: dbms_aw.aw_delete('APPS',l_aw_name1);
92:
93: fnd_file.put_line(fnd_file.log,'deleted analytic workspace '||l_aw_name1||
94: ' '||to_char(sysdate, 'hh24:mi:ss')||' '||l_stmtnum);
95:

Line 254: DBMS_AW.AW_ATTACH('APPS',P_AW_NAME1,true);

250: PRAGMA EXCEPTION_INIT (L_AW_DOESNOT_EXISTS2,-33262);
251:
252: BEGIN
253:
254: DBMS_AW.AW_ATTACH('APPS',P_AW_NAME1,true);
255: L_RES := TRUE;
256: RETURN L_RES;
257:
258: EXCEPTION