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.MSD_AW_LOADER_PVT dependencies on DBMS_AW

Line 18: l_return := dbms_aw.interp (p_cmd);

14: is
15: l_return varchar2(4000);
16: l_pos number := 1;
17: begin
18: l_return := dbms_aw.interp (p_cmd);
19:
20: if (l_return is null or length (l_return) = 0) then
21: return l_return;
22: end if;

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

49: -- enter as APPS.
50: --
51: if (upper (CALL_AW('shw aw (attached '''||p_aw||''')')) = 'YES' and
52: upper(CALL_AW('shw aw (rw '''||p_aw||''')')) = 'NO') then
53: dbms_aw.execute ('aw detach '||p_aw);
54: end if;
55: if (upper (CALL_AW('shw aw (attached '''||p_aw||''')')) <> 'YES') then
56: dbms_aw.execute ('aw attach '||l_aw||' rw wait');
57: end if;

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

52: upper(CALL_AW('shw aw (rw '''||p_aw||''')')) = 'NO') then
53: dbms_aw.execute ('aw detach '||p_aw);
54: end if;
55: if (upper (CALL_AW('shw aw (attached '''||p_aw||''')')) <> 'YES') then
56: dbms_aw.execute ('aw attach '||l_aw||' rw wait');
57: end if;
58: end ATTACH_AW;
59:
60: -------------------------------------------------------------------------------

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

74: l_ret varchar2(16);
75: begin
76: if (upper (CALL_AW('shw exists ('''||p_object_name||''')')) = 'YES') then
77: if (p_object_type = 'DIMENSION') then
78: dbms_aw.execute ('cns '||p_object_name);
79: dbms_aw.execute ('property delete all');
80: else
81: dbms_aw.execute ('dlt '||p_object_name);
82: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||

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

75: begin
76: if (upper (CALL_AW('shw exists ('''||p_object_name||''')')) = 'YES') then
77: if (p_object_type = 'DIMENSION') then
78: dbms_aw.execute ('cns '||p_object_name);
79: dbms_aw.execute ('property delete all');
80: else
81: dbms_aw.execute ('dlt '||p_object_name);
82: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
83: p_object_attributes);

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

77: if (p_object_type = 'DIMENSION') then
78: dbms_aw.execute ('cns '||p_object_name);
79: dbms_aw.execute ('property delete all');
80: else
81: dbms_aw.execute ('dlt '||p_object_name);
82: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
83: p_object_attributes);
84: end if;
85: else

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

78: dbms_aw.execute ('cns '||p_object_name);
79: dbms_aw.execute ('property delete all');
80: else
81: dbms_aw.execute ('dlt '||p_object_name);
82: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
83: p_object_attributes);
84: end if;
85: else
86: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||

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

82: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
83: p_object_attributes);
84: end if;
85: else
86: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
87: p_object_attributes);
88: end if;
89: dbms_aw.execute ('ld '||p_object_ld);
90: m_curr_obj := p_object_name;

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

85: else
86: dbms_aw.execute ('dfn '||p_object_name||' '||p_object_type||' '||
87: p_object_attributes);
88: end if;
89: dbms_aw.execute ('ld '||p_object_ld);
90: m_curr_obj := p_object_name;
91: end CREATE_OBJECT;
92:
93: -------------------------------------------------------------------------------

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

101: l_diff number;
102: begin
103: l_size := to_number(CALL_AW('shw obj(dimmax '''||m_curr_obj||''')'));
104: if (l_size < p_dimension_size) then
105: dbms_aw.execute('mnt '||m_curr_obj||' add '||
106: (p_dimension_size - l_size));
107: elsif (l_size > p_dimension_size) then
108: dbms_aw.execute('mnt '||m_curr_obj||' delete last '||
109: (l_size - p_dimension_size));

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

104: if (l_size < p_dimension_size) then
105: dbms_aw.execute('mnt '||m_curr_obj||' add '||
106: (p_dimension_size - l_size));
107: elsif (l_size > p_dimension_size) then
108: dbms_aw.execute('mnt '||m_curr_obj||' delete last '||
109: (l_size - p_dimension_size));
110: end if;
111: end LOAD_DIMENSION_INT;
112:

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

136: end if;
137:
138: if (upper (CALL_AW ('shw isvalue ('||m_curr_obj||' '||l_value||')'))
139: = 'NO') then
140: dbms_aw.execute ('mnt '||m_curr_obj||' add '||l_value||'');
141: end if;
142: dbms_aw.execute('mnt '||m_curr_obj||' move '||l_value||' after '||i);
143: i := i + 1;
144: end loop;

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

138: if (upper (CALL_AW ('shw isvalue ('||m_curr_obj||' '||l_value||')'))
139: = 'NO') then
140: dbms_aw.execute ('mnt '||m_curr_obj||' add '||l_value||'');
141: end if;
142: dbms_aw.execute('mnt '||m_curr_obj||' move '||l_value||' after '||i);
143: i := i + 1;
144: end loop;
145:
146: --

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

147: -- Remove extra entries:
148: --
149: l_size := to_number(CALL_AW ('shw obj(dimmax '''||m_curr_obj||''')'));
150: if (l_size > i) then
151: dbms_aw.execute ('lmt '||m_curr_obj||' to last '||(l_size - i));
152: dbms_aw.execute ('mnt '||m_curr_obj||' delete values('||m_curr_obj||')');
153: end if;
154:
155: end LOAD_DIMENSION_VALUES;

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

148: --
149: l_size := to_number(CALL_AW ('shw obj(dimmax '''||m_curr_obj||''')'));
150: if (l_size > i) then
151: dbms_aw.execute ('lmt '||m_curr_obj||' to last '||(l_size - i));
152: dbms_aw.execute ('mnt '||m_curr_obj||' delete values('||m_curr_obj||')');
153: end if;
154:
155: end LOAD_DIMENSION_VALUES;
156:

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

162: -------------------------------------------------------------------------------
163: procedure LOAD_FORMULA(p_formula in varchar2)
164: is
165: begin
166: dbms_aw.execute ('cns '||m_curr_obj);
167: dbms_aw.execute('eq '||p_formula);
168: end LOAD_FORMULA;
169:
170: -------------------------------------------------------------------------------

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

163: procedure LOAD_FORMULA(p_formula in varchar2)
164: is
165: begin
166: dbms_aw.execute ('cns '||m_curr_obj);
167: dbms_aw.execute('eq '||p_formula);
168: end LOAD_FORMULA;
169:
170: -------------------------------------------------------------------------------
171: -- LOAD_MODEL - Builds a model

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

175: -------------------------------------------------------------------------------
176: procedure LOAD_MODEL(p_model in varchar2)
177: is
178: begin
179: dbms_aw.execute ('cns '||m_curr_obj);
180: dbms_aw.execute('model;'||p_model||';end');
181: end LOAD_MODEL;
182:
183: -------------------------------------------------------------------------------

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

176: procedure LOAD_MODEL(p_model in varchar2)
177: is
178: begin
179: dbms_aw.execute ('cns '||m_curr_obj);
180: dbms_aw.execute('model;'||p_model||';end');
181: end LOAD_MODEL;
182:
183: -------------------------------------------------------------------------------
184: -- LOAD_PROGRAM - Builds a program

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

189: procedure LOAD_PROGRAM(p_program in CLOB)
190: is
191: templob CLOB := 'program;';
192: begin
193: dbms_aw.execute ('cns '||m_curr_obj);
194: dbms_lob.append(templob, p_program);
195: dbms_lob.append(templob, ';end');
196: templob := dbms_aw.interpclob(templob);
197: end LOAD_PROGRAM;

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

192: begin
193: dbms_aw.execute ('cns '||m_curr_obj);
194: dbms_lob.append(templob, p_program);
195: dbms_lob.append(templob, ';end');
196: templob := dbms_aw.interpclob(templob);
197: end LOAD_PROGRAM;
198:
199: -------------------------------------------------------------------------------
200: -- LOAD_PROPERTIES - Loads the properties of an object

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

205: procedure LOAD_PROPERTIES(p_properties in PROP_VALUES)
206: is
207: l_key varchar2(32);
208: begin
209: dbms_aw.execute ('cns '||m_curr_obj);
210: l_key := p_properties.FIRST;
211: while (l_key is not null)
212: loop
213: dbms_aw.execute('prp '''||l_key||''' '||p_properties(l_key));

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

209: dbms_aw.execute ('cns '||m_curr_obj);
210: l_key := p_properties.FIRST;
211: while (l_key is not null)
212: loop
213: dbms_aw.execute('prp '''||l_key||''' '||p_properties(l_key));
214: l_key := p_properties.NEXT(l_key);
215: end loop;
216: end LOAD_PROPERTIES;
217:

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

226: i number := 0;
227: l_value varchar2(32);
228: l_size number;
229: begin
230: dbms_aw.execute('lmt '||m_curr_obj||' to null');
231: loop
232: if not p_dimension_values.exists(i) then
233: exit;
234: end if;

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

232: if not p_dimension_values.exists(i) then
233: exit;
234: end if;
235: l_value := p_dimension_values(i);
236: dbms_aw.execute('lmt '||m_curr_obj||' add '||l_value);
237: i := i + 1;
238: end loop;
239:
240: end LOAD_VALUESET;

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

245: -------------------------------------------------------------------------------
246: procedure UPDATE_AW
247: is
248: begin
249: dbms_aw.execute ('upd');
250: end UPDATE_AW;
251:
252: end msd_AW_LOADER_PVT;