DBA Data[Home] [Help]

APPS.QPR_DML_PVT dependencies on DBMS_AW

Line 11: dbms_aw.execute('aw attach '||awname||' rw');

7:
8: begin
9: FND_FILE.PUT_LINE(FND_FILE.LOG,'Load DML Programs in AW '||awname);
10:
11: dbms_aw.execute('aw attach '||awname||' rw');
12:
13: FND_FILE.PUT_LINE(FND_FILE.LOG,'AW attached in RW Mode ');
14:
15: str1 := 'define regression program;program;';

Line 81: dbms_aw.execute(str1 || str2 || str3);

77: str3 := str3 || 'ALLSTAT;';
78: str3 := str3 || 'return(joinchars(slope,''_'',intercept));end;';
79:
80:
81: dbms_aw.execute(str1 || str2 || str3);
82:
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'Created Regression DML Program ..... ');
84:
85:

Line 104: dbms_aw.execute(str1);

100: str1 := str1 || 'else do;';
101: str1 := str1 || 'return 0;';
102: str1 := str1 || 'doend;end;';
103:
104: dbms_aw.execute(str1);
105:
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Created RetOffInv DML Program ..... ');
107:
108: dbms_aw.execute('update;commit;');

Line 108: dbms_aw.execute('update;commit;');

104: dbms_aw.execute(str1);
105:
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Created RetOffInv DML Program ..... ');
107:
108: dbms_aw.execute('update;commit;');
109: FND_FILE.PUT_LINE(FND_FILE.LOG,'UPDATE and COMMIT');
110:
111: dbms_aw.execute('aw detach '||awname);
112:

Line 111: dbms_aw.execute('aw detach '||awname);

107:
108: dbms_aw.execute('update;commit;');
109: FND_FILE.PUT_LINE(FND_FILE.LOG,'UPDATE and COMMIT');
110:
111: dbms_aw.execute('aw detach '||awname);
112:
113: FND_FILE.PUT_LINE(FND_FILE.LOG,'AW Detached');
114:
115: EXCEPTION