eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_AW_LOADER_PVT dependencies on DBMS_AW

Line 16: return dbms_lob.substr(dbms_aw.interp (p_cmd));

12: -------------------------------------------------------------------------------
13: function CALL_AW(p_cmd in varchar2) return varchar2
14: is
15: begin
16: return dbms_lob.substr(dbms_aw.interp (p_cmd));
17: end CALL_AW;
18:
19: -------------------------------------------------------------------------------
20: -- CALL_BOOL

Line 32: return (dbms_aw.interp (p_cmd) = dbms_aw.interp ('shw yes'));

28: -------------------------------------------------------------------------------
29: function CALL_BOOL (p_cmd in varchar2)
30: return boolean is
31: begin
32: return (dbms_aw.interp (p_cmd) = dbms_aw.interp ('shw yes'));
33: end CALL_BOOL;
34:
35: -------------------------------------------------------------------------------
36: -- ATTACH_AW: Attaches the AW rw

Line 66: dbms_aw.execute ('awwaittime = 200');

62: -- under ALIAS of p_aw. If from ADPATCH, then this AW is not attached.
63: -- Note that, in development, we are in as ZPB, whereas in ADPATCH, we
64: -- enter as APPS.
65: --
66: dbms_aw.execute ('awwaittime = 200');
67: if (CALL_BOOL('shw aw (attached '''||p_aw||''')') and
68: (not CALL_BOOL('shw aw (rw '''||p_aw||''')'))) then
69: dbms_aw.execute ('aw detach '||p_aw);
70: end if;

Line 69: dbms_aw.execute ('aw detach '||p_aw);

65: --
66: dbms_aw.execute ('awwaittime = 200');
67: if (CALL_BOOL('shw aw (attached '''||p_aw||''')') and
68: (not CALL_BOOL('shw aw (rw '''||p_aw||''')'))) then
69: dbms_aw.execute ('aw detach '||p_aw);
70: end if;
71: if (not CALL_BOOL('shw aw (attached '''||p_aw||''')')) then
72: dbms_aw.execute ('aw attach '||l_aw||' rw wait');
73: end if;

Line 72: dbms_aw.execute ('aw attach '||l_aw||' rw wait');

68: (not CALL_BOOL('shw aw (rw '''||p_aw||''')'))) then
69: dbms_aw.execute ('aw detach '||p_aw);
70: end if;
71: if (not CALL_BOOL('shw aw (attached '''||p_aw||''')')) then
72: dbms_aw.execute ('aw attach '||l_aw||' rw wait');
73: end if;
74: dbms_aw.execute ('commas = no');
75: end ATTACH_AW;
76:

Line 74: dbms_aw.execute ('commas = no');

70: end if;
71: if (not CALL_BOOL('shw aw (attached '''||p_aw||''')')) then
72: dbms_aw.execute ('aw attach '||l_aw||' rw wait');
73: end if;
74: dbms_aw.execute ('commas = no');
75: end ATTACH_AW;
76:
77: -------------------------------------------------------------------------------
78: -- CREATE_OBJECT - Creates the object of specified name, type and attribute

Line 95: dbms_aw.execute ('cns '||p_object_name);

91: l_ret varchar2(16);
92: begin
93: if (CALL_BOOL('shw exists ('''||p_object_name||''')')) then
94: if (p_object_type = 'DIMENSION') then
95: dbms_aw.execute ('cns '||p_object_name);
96: dbms_aw.execute ('property delete all');
97: else
98: dbms_aw.execute ('dlt '||p_object_name);
99: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||

Line 96: dbms_aw.execute ('property delete all');

92: begin
93: if (CALL_BOOL('shw exists ('''||p_object_name||''')')) then
94: if (p_object_type = 'DIMENSION') then
95: dbms_aw.execute ('cns '||p_object_name);
96: dbms_aw.execute ('property delete all');
97: else
98: dbms_aw.execute ('dlt '||p_object_name);
99: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
100: p_object_attributes);

Line 98: dbms_aw.execute ('dlt '||p_object_name);

94: if (p_object_type = 'DIMENSION') then
95: dbms_aw.execute ('cns '||p_object_name);
96: dbms_aw.execute ('property delete all');
97: else
98: dbms_aw.execute ('dlt '||p_object_name);
99: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
100: p_object_attributes);
101: end if;
102: else

Line 99: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||

95: dbms_aw.execute ('cns '||p_object_name);
96: dbms_aw.execute ('property delete all');
97: else
98: dbms_aw.execute ('dlt '||p_object_name);
99: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
100: p_object_attributes);
101: end if;
102: else
103: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||

Line 103: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||

99: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
100: p_object_attributes);
101: end if;
102: else
103: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
104: p_object_attributes);
105: end if;
106: dbms_aw.execute ('ld '||p_object_ld);
107: m_curr_obj := p_object_name;

Line 106: dbms_aw.execute ('ld '||p_object_ld);

102: else
103: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
104: p_object_attributes);
105: end if;
106: dbms_aw.execute ('ld '||p_object_ld);
107: m_curr_obj := p_object_name;
108: end CREATE_OBJECT;
109:
110: -------------------------------------------------------------------------------

Line 120: dbms_aw.execute('delete ' || p_object_name);

116: procedure DELETE_OBJECT(p_object_name in varchar2)
117: is
118: begin
119: if (CALL_BOOL('shw exists ('''||p_object_name||''')')) then
120: dbms_aw.execute('delete ' || p_object_name);
121: end if;
122: end DELETE_OBJECT;
123:
124: -------------------------------------------------------------------------------

Line 136: dbms_aw.execute('mnt '||m_curr_obj||' add '||

132: l_diff number;
133: begin
134: l_size := to_number(CALL_AW('shw obj(dimmax '''||m_curr_obj||''')'));
135: if (l_size < p_dimension_size) then
136: dbms_aw.execute('mnt '||m_curr_obj||' add '||
137: (p_dimension_size - l_size));
138: elsif (l_size > p_dimension_size) then
139: dbms_aw.execute('mnt '||m_curr_obj||' delete last '||
140: (l_size - p_dimension_size));

Line 139: dbms_aw.execute('mnt '||m_curr_obj||' delete last '||

135: if (l_size < p_dimension_size) then
136: dbms_aw.execute('mnt '||m_curr_obj||' add '||
137: (p_dimension_size - l_size));
138: elsif (l_size > p_dimension_size) then
139: dbms_aw.execute('mnt '||m_curr_obj||' delete last '||
140: (l_size - p_dimension_size));
141: end if;
142: end LOAD_DIMENSION_INT;
143:

Line 171: dbms_aw.execute ('mnt '||m_curr_obj||' add '||l_value||'');

167: l_value := ''''||l_value||'''';
168: end if;
169:
170: if (not CALL_BOOL ('shw isvalue ('||m_curr_obj||' '||l_value||')')) then
171: dbms_aw.execute ('mnt '||m_curr_obj||' add '||l_value||'');
172: end if;
173: dbms_aw.execute('mnt '||m_curr_obj||' move '||l_value||' after '||i);
174: i := i + 1;
175: end loop;

Line 173: dbms_aw.execute('mnt '||m_curr_obj||' move '||l_value||' after '||i);

169:
170: if (not CALL_BOOL ('shw isvalue ('||m_curr_obj||' '||l_value||')')) then
171: dbms_aw.execute ('mnt '||m_curr_obj||' add '||l_value||'');
172: end if;
173: dbms_aw.execute('mnt '||m_curr_obj||' move '||l_value||' after '||i);
174: i := i + 1;
175: end loop;
176:
177: --

Line 182: dbms_aw.execute ('lmt '||m_curr_obj||' to last '||(l_size - i));

178: -- Remove extra entries:
179: --
180: l_size := to_number(CALL_AW ('shw obj(dimmax '''||m_curr_obj||''')'));
181: if (l_size > i) then
182: dbms_aw.execute ('lmt '||m_curr_obj||' to last '||(l_size - i));
183: dbms_aw.execute ('mnt '||m_curr_obj||' delete values('||m_curr_obj||')');
184: end if;
185:
186: end LOAD_DIMENSION_VALUES;

Line 183: dbms_aw.execute ('mnt '||m_curr_obj||' delete values('||m_curr_obj||')');

179: --
180: l_size := to_number(CALL_AW ('shw obj(dimmax '''||m_curr_obj||''')'));
181: if (l_size > i) then
182: dbms_aw.execute ('lmt '||m_curr_obj||' to last '||(l_size - i));
183: dbms_aw.execute ('mnt '||m_curr_obj||' delete values('||m_curr_obj||')');
184: end if;
185:
186: end LOAD_DIMENSION_VALUES;
187:

Line 197: dbms_aw.execute ('cns '||m_curr_obj);

193: -------------------------------------------------------------------------------
194: procedure LOAD_FORMULA(p_formula in varchar2)
195: is
196: begin
197: dbms_aw.execute ('cns '||m_curr_obj);
198: dbms_aw.execute('eq '||p_formula);
199: end LOAD_FORMULA;
200:
201: -------------------------------------------------------------------------------

Line 198: dbms_aw.execute('eq '||p_formula);

194: procedure LOAD_FORMULA(p_formula in varchar2)
195: is
196: begin
197: dbms_aw.execute ('cns '||m_curr_obj);
198: dbms_aw.execute('eq '||p_formula);
199: end LOAD_FORMULA;
200:
201: -------------------------------------------------------------------------------
202: -- LOAD_MODEL - Builds a model

Line 210: dbms_aw.execute ('cns '||m_curr_obj);

206: -------------------------------------------------------------------------------
207: procedure LOAD_MODEL(p_model in varchar2)
208: is
209: begin
210: dbms_aw.execute ('cns '||m_curr_obj);
211: dbms_aw.execute('model;'||p_model||';end');
212: end LOAD_MODEL;
213:
214: -------------------------------------------------------------------------------

Line 211: dbms_aw.execute('model;'||p_model||';end');

207: procedure LOAD_MODEL(p_model in varchar2)
208: is
209: begin
210: dbms_aw.execute ('cns '||m_curr_obj);
211: dbms_aw.execute('model;'||p_model||';end');
212: end LOAD_MODEL;
213:
214: -------------------------------------------------------------------------------
215: -- LOAD_PROGRAM - Builds a program

Line 225: dbms_aw.execute ('cns '||m_curr_obj);

221: is
222: templob CLOB;
223: begin
224: templob := 'program;';
225: dbms_aw.execute ('cns '||m_curr_obj);
226: dbms_lob.append(templob, p_program);
227: dbms_lob.append(templob, ';end');
228: templob := dbms_aw.interpclob(templob);
229: end LOAD_PROGRAM;

Line 228: templob := dbms_aw.interpclob(templob);

224: templob := 'program;';
225: dbms_aw.execute ('cns '||m_curr_obj);
226: dbms_lob.append(templob, p_program);
227: dbms_lob.append(templob, ';end');
228: templob := dbms_aw.interpclob(templob);
229: end LOAD_PROGRAM;
230:
231: -------------------------------------------------------------------------------
232: -- LOAD_PROPERTIES - Loads the properties of an object

Line 241: dbms_aw.execute ('cns '||m_curr_obj);

237: procedure LOAD_PROPERTIES(p_properties in PROP_VALUES)
238: is
239: l_key varchar2(32);
240: begin
241: dbms_aw.execute ('cns '||m_curr_obj);
242: l_key := p_properties.FIRST;
243: while (l_key is not null)
244: loop
245: dbms_aw.execute('prp '''||l_key||''' '||p_properties(l_key));

Line 245: dbms_aw.execute('prp '''||l_key||''' '||p_properties(l_key));

241: dbms_aw.execute ('cns '||m_curr_obj);
242: l_key := p_properties.FIRST;
243: while (l_key is not null)
244: loop
245: dbms_aw.execute('prp '''||l_key||''' '||p_properties(l_key));
246: l_key := p_properties.NEXT(l_key);
247: end loop;
248: end LOAD_PROPERTIES;
249:

Line 262: dbms_aw.execute('lmt '||m_curr_obj||' to null');

258: i number;
259: l_value varchar2(32);
260: l_size number;
261: begin
262: dbms_aw.execute('lmt '||m_curr_obj||' to null');
263: i := 0;
264: loop
265: if not p_dimension_values.exists(i) then
266: exit;

Line 269: dbms_aw.execute('lmt '||m_curr_obj||' add '||l_value);

265: if not p_dimension_values.exists(i) then
266: exit;
267: end if;
268: l_value := p_dimension_values(i);
269: dbms_aw.execute('lmt '||m_curr_obj||' add '||l_value);
270: i := i + 1;
271: end loop;
272:
273: end LOAD_VALUESET;

Line 282: dbms_aw.execute ('upd');

278: -------------------------------------------------------------------------------
279: procedure UPDATE_AW
280: is
281: begin
282: dbms_aw.execute ('upd');
283: end UPDATE_AW;
284:
285: end ZPB_AW_LOADER_PVT;