APPS.QPR_CREATE_AW dependencies on DBMS_AW

Line 56: dbms_aw.execute('aw attach '||'QPR'||p_price_plan_id||' rw;');

52:
53: qprterms_rec qprterms_cur%ROWTYPE;
54: tempString varchar2(4000);
55: BEGIN
56: dbms_aw.execute('aw attach '||'QPR'||p_price_plan_id||' rw;');
57: for qprmodels_rec in qprmodels_cur loop
58: dbms_aw.execute('define '||qprmodels_rec.model_name||' model ;');
59: dbms_aw.execute('consider '||qprmodels_rec.model_name||'; ');
60: tempString := 'DIMENSION '||qprmodels_rec.dim_code||'\n';

Line 58: dbms_aw.execute('define '||qprmodels_rec.model_name||' model ;');

54: tempString varchar2(4000);
55: BEGIN
56: dbms_aw.execute('aw attach '||'QPR'||p_price_plan_id||' rw;');
57: for qprmodels_rec in qprmodels_cur loop
58: dbms_aw.execute('define '||qprmodels_rec.model_name||' model ;');
59: dbms_aw.execute('consider '||qprmodels_rec.model_name||'; ');
60: tempString := 'DIMENSION '||qprmodels_rec.dim_code||'\n';
61: for qprmodeleqns_rec in qprmodeleqns_cur(qprmodels_rec.model_id) loop
62: for qprexpressions_rec in qprexpressions_cur(qprmodeleqns_rec.lhs_expression_id) loop

Line 59: dbms_aw.execute('consider '||qprmodels_rec.model_name||'; ');

55: BEGIN
56: dbms_aw.execute('aw attach '||'QPR'||p_price_plan_id||' rw;');
57: for qprmodels_rec in qprmodels_cur loop
58: dbms_aw.execute('define '||qprmodels_rec.model_name||' model ;');
59: dbms_aw.execute('consider '||qprmodels_rec.model_name||'; ');
60: tempString := 'DIMENSION '||qprmodels_rec.dim_code||'\n';
61: for qprmodeleqns_rec in qprmodeleqns_cur(qprmodels_rec.model_id) loop
62: for qprexpressions_rec in qprexpressions_cur(qprmodeleqns_rec.lhs_expression_id) loop
63: for qprterms_rec in qprterms_cur(qprexpressions_rec.term_id) loop

Line 85: dbms_aw.execute('MODEL JOINLINES( '||''''||tempString||''''||' '||''''||'END;'||''''||')');

81: end loop;-- terms;
82: end loop;-- expressions;
83: tempString := tempString || '\n';
84: end loop;-- modeleqns;
85: dbms_aw.execute('MODEL JOINLINES( '||''''||tempString||''''||' '||''''||'END;'||''''||')');
86: dbms_aw.EXECUTE('update;commit;');
87:
88: tempString := '';
89: end loop;-- qprmodel;

Line 86: dbms_aw.EXECUTE('update;commit;');

82: end loop;-- expressions;
83: tempString := tempString || '\n';
84: end loop;-- modeleqns;
85: dbms_aw.execute('MODEL JOINLINES( '||''''||tempString||''''||' '||''''||'END;'||''''||')');
86: dbms_aw.EXECUTE('update;commit;');
87:
88: tempString := '';
89: end loop;-- qprmodel;
90: dbms_aw.execute('aw detach '||'QPR'||p_price_plan_id||';');

Line 90: dbms_aw.execute('aw detach '||'QPR'||p_price_plan_id||';');

86: dbms_aw.EXECUTE('update;commit;');
87:
88: tempString := '';
89: end loop;-- qprmodel;
90: dbms_aw.execute('aw detach '||'QPR'||p_price_plan_id||';');
91: exception
92: when others then
93: dbms_aw.execute('aw detach '||'QPR'||p_price_plan_id||';');
94: END;

Line 93: dbms_aw.execute('aw detach '||'QPR'||p_price_plan_id||';');

89: end loop;-- qprmodel;
90: dbms_aw.execute('aw detach '||'QPR'||p_price_plan_id||';');
91: exception
92: when others then
93: dbms_aw.execute('aw detach '||'QPR'||p_price_plan_id||';');
94: END;
95:
96:
97: PROCEDURE SUBMIT_REQUEST_SET(P_PRICE_PLAN_ID IN NUMBER,

Line 171: l_aw_output := DBMS_AW_XML.EXECUTE(L_CLB);

167: IF(AW_EXISTS(L_AW_NAME1)) THEN
168:
169: L_STMTNUM := 30;
170:
171: l_aw_output := DBMS_AW_XML.EXECUTE(L_CLB);
172:
173: L_STMTNUM := 40;
174:
175: DBMS_AW.AW_UPDATE('APPS',L_AW_NAME1);

Line 175: DBMS_AW.AW_UPDATE('APPS',L_AW_NAME1);

171: l_aw_output := DBMS_AW_XML.EXECUTE(L_CLB);
172:
173: L_STMTNUM := 40;
174:
175: DBMS_AW.AW_UPDATE('APPS',L_AW_NAME1);
176:
177: L_STMTNUM := 50;
178:
179: L_STMTNUM := 60;

Line 234: DBMS_AW.AW_ATTACH('APPS',P_AW_NAME2,true);

230: PRAGMA EXCEPTION_INIT (L_AW_EXISTS1,-33262);
231:
232: BEGIN
233:
234: DBMS_AW.AW_ATTACH('APPS',P_AW_NAME2,true);
235: L_RES := FALSE;
236: RETURN L_RES;
237:
238: EXCEPTION