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_PERSONAL_AW dependencies on ZPB_AW

Line 6: g_olapSchema varchar2(3) := zpb_aw.get_schema;

2: /* $Header: zpbpersonalaw.plb 120.29 2007/12/04 15:40:39 mbhat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ZPB_PERSONAL_AW';
5: G_LOCK_OUT CONSTANT Number := 2;
6: g_olapSchema varchar2(3) := zpb_aw.get_schema;
7:
8: g_annotAW varchar2(30);
9: g_codeAW varchar2(30);
10: g_sharedAW varchar2(30);

Line 21: g_annotAW := ZPB_AW.GET_ANNOTATION_AW;

17: procedure GET_AWS (p_user in varchar2)
18: is
19: begin
20:
21: g_annotAW := ZPB_AW.GET_ANNOTATION_AW;
22: g_codeAW := ZPB_AW.GET_CODE_AW (p_user);
23: g_sharedAW := ZPB_AW.GET_SHARED_AW;
24: g_personalAW := ZPB_AW.GET_PERSONAL_AW (p_user);
25: end GET_AWS;

Line 22: g_codeAW := ZPB_AW.GET_CODE_AW (p_user);

18: is
19: begin
20:
21: g_annotAW := ZPB_AW.GET_ANNOTATION_AW;
22: g_codeAW := ZPB_AW.GET_CODE_AW (p_user);
23: g_sharedAW := ZPB_AW.GET_SHARED_AW;
24: g_personalAW := ZPB_AW.GET_PERSONAL_AW (p_user);
25: end GET_AWS;
26:

Line 23: g_sharedAW := ZPB_AW.GET_SHARED_AW;

19: begin
20:
21: g_annotAW := ZPB_AW.GET_ANNOTATION_AW;
22: g_codeAW := ZPB_AW.GET_CODE_AW (p_user);
23: g_sharedAW := ZPB_AW.GET_SHARED_AW;
24: g_personalAW := ZPB_AW.GET_PERSONAL_AW (p_user);
25: end GET_AWS;
26:
27: -------------------------------------------------------------------------------

Line 24: g_personalAW := ZPB_AW.GET_PERSONAL_AW (p_user);

20:
21: g_annotAW := ZPB_AW.GET_ANNOTATION_AW;
22: g_codeAW := ZPB_AW.GET_CODE_AW (p_user);
23: g_sharedAW := ZPB_AW.GET_SHARED_AW;
24: g_personalAW := ZPB_AW.GET_PERSONAL_AW (p_user);
25: end GET_AWS;
26:
27: -------------------------------------------------------------------------------
28: -- ANNOTATIONS_CREATE - Driver program to create the user's personal

Line 48: zpb_aw.execute ('call pa.attach.shared ('''||p_user||''')');

44: zpb_log.write('zpb_personal_aw.annotation_create.begin',
45: 'Creating personal metadata for '||p_user);
46:
47: l_persAw := g_olapSchema||'.'||g_personalAW;
48: zpb_aw.execute ('call pa.attach.shared ('''||p_user||''')');
49: l_global_ecm := zpb_ecm.get_global_ecm(g_sharedAW);
50:
51: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
52:

Line 51: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');

47: l_persAw := g_olapSchema||'.'||g_personalAW;
48: zpb_aw.execute ('call pa.attach.shared ('''||p_user||''')');
49: l_global_ecm := zpb_ecm.get_global_ecm(g_sharedAW);
50:
51: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
52:
53: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
54: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_sharedAW);
55: zpb_aw.execute('lmt '||l_global_ecm.AnnEntryDim||' remove all');

Line 54: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_sharedAW);

50:
51: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
52:
53: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
54: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_sharedAW);
55: zpb_aw.execute('lmt '||l_global_ecm.AnnEntryDim||' remove all');
56:
57: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
58: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');

Line 55: zpb_aw.execute('lmt '||l_global_ecm.AnnEntryDim||' remove all');

51: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
52:
53: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
54: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_sharedAW);
55: zpb_aw.execute('lmt '||l_global_ecm.AnnEntryDim||' remove all');
56:
57: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
58: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');
59: import (p_user, g_annotAW, 'N');

Line 57: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');

53: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
54: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_sharedAW);
55: zpb_aw.execute('lmt '||l_global_ecm.AnnEntryDim||' remove all');
56:
57: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
58: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');
59: import (p_user, g_annotAW, 'N');
60:
61: --

Line 58: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');

54: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_sharedAW);
55: zpb_aw.execute('lmt '||l_global_ecm.AnnEntryDim||' remove all');
56:
57: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
58: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');
59: import (p_user, g_annotAW, 'N');
60:
61: --
62: -- Define the formulas. Must be redefined instead of imported:

Line 64: zpb_aw.execute ('call an.form.pers.crt('''||l_persAw||''' '''||

60:
61: --
62: -- Define the formulas. Must be redefined instead of imported:
63: --
64: zpb_aw.execute ('call an.form.pers.crt('''||l_persAw||''' '''||
65: g_olapSchema||'.'||g_sharedAW||''' '''||
66: g_olapSchema||'.'||g_annotAW||''')');
67:
68: zpb_log.write('zpb_personal_aw.annotation_create.end',

Line 144: zpb_aw.initialize (p_api_version => 1.0,

140: where RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP';
141:
142: FND_GLOBAL.APPS_INITIALIZE (p_user, l_resp, 210);
143:
144: zpb_aw.initialize (p_api_version => 1.0,
145: x_return_status => l_retStat,
146: x_msg_count => l_msgCnt,
147: x_msg_data => l_msgData,
148: p_business_area_id => p_business_area_id,

Line 156: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_personalAW||' ro');

152:
153: get_aws(p_user);
154:
155: begin
156: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_personalAW||' ro');
157:
158: -- Added for Bug: 5842827
159: l_exists := true;
160: exception

Line 177: zpb_aw.execute ('aw create '||g_olapSchema||'.'||g_personalAW);

173:
174: -- Metadata for SHARED_VIEWS is shared between all users and thus
175: -- does not to be manipulated on a per user basis
176:
177: zpb_aw.execute ('aw create '||g_olapSchema||'.'||g_personalAW);
178: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
179:
180: -- Set up the personal DM objects
181: zpb_aw.execute('DM.PRS.DATAAW='''||g_olapSchema||'.'||g_personalAW||'''');

Line 178: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);

174: -- Metadata for SHARED_VIEWS is shared between all users and thus
175: -- does not to be manipulated on a per user basis
176:
177: zpb_aw.execute ('aw create '||g_olapSchema||'.'||g_personalAW);
178: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
179:
180: -- Set up the personal DM objects
181: zpb_aw.execute('DM.PRS.DATAAW='''||g_olapSchema||'.'||g_personalAW||'''');
182: zpb_aw.execute('DM.PRS.ANNOTAW='''||g_olapSchema||'.'||g_personalAW||'''');

Line 181: zpb_aw.execute('DM.PRS.DATAAW='''||g_olapSchema||'.'||g_personalAW||'''');

177: zpb_aw.execute ('aw create '||g_olapSchema||'.'||g_personalAW);
178: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
179:
180: -- Set up the personal DM objects
181: zpb_aw.execute('DM.PRS.DATAAW='''||g_olapSchema||'.'||g_personalAW||'''');
182: zpb_aw.execute('DM.PRS.ANNOTAW='''||g_olapSchema||'.'||g_personalAW||'''');
183: zpb_aw.execute('DM.PRS.ECMLOCATOR = '''||g_olapSchema||'.'||g_personalAW||
184: '!ECMLOCATOR''');
185: zpb_aw.execute ('DM.PRS.DIMDIM = '''||g_olapSchema||'.'||g_personalAW||

Line 182: zpb_aw.execute('DM.PRS.ANNOTAW='''||g_olapSchema||'.'||g_personalAW||'''');

178: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
179:
180: -- Set up the personal DM objects
181: zpb_aw.execute('DM.PRS.DATAAW='''||g_olapSchema||'.'||g_personalAW||'''');
182: zpb_aw.execute('DM.PRS.ANNOTAW='''||g_olapSchema||'.'||g_personalAW||'''');
183: zpb_aw.execute('DM.PRS.ECMLOCATOR = '''||g_olapSchema||'.'||g_personalAW||
184: '!ECMLOCATOR''');
185: zpb_aw.execute ('DM.PRS.DIMDIM = '''||g_olapSchema||'.'||g_personalAW||
186: '!DMENTRY''');

Line 183: zpb_aw.execute('DM.PRS.ECMLOCATOR = '''||g_olapSchema||'.'||g_personalAW||

179:
180: -- Set up the personal DM objects
181: zpb_aw.execute('DM.PRS.DATAAW='''||g_olapSchema||'.'||g_personalAW||'''');
182: zpb_aw.execute('DM.PRS.ANNOTAW='''||g_olapSchema||'.'||g_personalAW||'''');
183: zpb_aw.execute('DM.PRS.ECMLOCATOR = '''||g_olapSchema||'.'||g_personalAW||
184: '!ECMLOCATOR''');
185: zpb_aw.execute ('DM.PRS.DIMDIM = '''||g_olapSchema||'.'||g_personalAW||
186: '!DMENTRY''');
187: zpb_aw.execute ('DM.PRS.MEASDIM = '''||g_olapSchema||'.'||g_personalAW||

Line 185: zpb_aw.execute ('DM.PRS.DIMDIM = '''||g_olapSchema||'.'||g_personalAW||

181: zpb_aw.execute('DM.PRS.DATAAW='''||g_olapSchema||'.'||g_personalAW||'''');
182: zpb_aw.execute('DM.PRS.ANNOTAW='''||g_olapSchema||'.'||g_personalAW||'''');
183: zpb_aw.execute('DM.PRS.ECMLOCATOR = '''||g_olapSchema||'.'||g_personalAW||
184: '!ECMLOCATOR''');
185: zpb_aw.execute ('DM.PRS.DIMDIM = '''||g_olapSchema||'.'||g_personalAW||
186: '!DMENTRY''');
187: zpb_aw.execute ('DM.PRS.MEASDIM = '''||g_olapSchema||'.'||g_personalAW||
188: '!MEASURE''');
189:

Line 187: zpb_aw.execute ('DM.PRS.MEASDIM = '''||g_olapSchema||'.'||g_personalAW||

183: zpb_aw.execute('DM.PRS.ECMLOCATOR = '''||g_olapSchema||'.'||g_personalAW||
184: '!ECMLOCATOR''');
185: zpb_aw.execute ('DM.PRS.DIMDIM = '''||g_olapSchema||'.'||g_personalAW||
186: '!DMENTRY''');
187: zpb_aw.execute ('DM.PRS.MEASDIM = '''||g_olapSchema||'.'||g_personalAW||
188: '!MEASURE''');
189:
190: l_ecm := zpb_ecm.get_global_ecm (g_sharedAW);
191: l_aw := g_olapSchema||'.'||g_sharedAW;

Line 195: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);

191: l_aw := g_olapSchema||'.'||g_sharedAW;
192:
193: METADATA_CREATE (p_user);
194:
195: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
196: ANNOTATION_CREATE (p_user);
197:
198: -- Set up the Perosnal DM objects
199: l_ecm := zpb_ecm.get_global_ecm (g_personalAW);

Line 205: zpb_aw.execute ('call PA.CONVERT.FORMULAS('''||g_olapSchema||'.'||

201:
202: --
203: -- Convert SHARED formulas to point to Personal Aw
204: --
205: zpb_aw.execute ('call PA.CONVERT.FORMULAS('''||g_olapSchema||'.'||
206: g_personalAW||''' '''||g_olapSchema||'.'||
207: g_sharedAW||''')');
208:
209: --

Line 212: zpb_aw.execute ('call PA.META.CREATE('''||g_olapSchema||'.'||

208:
209: --
210: -- Generate personal AW structures, and update the metadata catalogs
211: --
212: zpb_aw.execute ('call PA.META.CREATE('''||g_olapSchema||'.'||
213: g_personalAW||''')');
214:
215: zpb_aw.execute ('call pa.attach.shared('''||p_user||''' false)');
216:

Line 215: zpb_aw.execute ('call pa.attach.shared('''||p_user||''' false)');

211: --
212: zpb_aw.execute ('call PA.META.CREATE('''||g_olapSchema||'.'||
213: g_personalAW||''')');
214:
215: zpb_aw.execute ('call pa.attach.shared('''||p_user||''' false)');
216:
217: --dbms_output.put_line ('done meta create: '||to_char(sysdate, 'HH:MI:SS'));
218: VIEWS_UPDATE (g_personalAW, p_user);
219:

Line 224: zpb_aw.execute ('upd '||g_olapSchema||'.'||g_personalAW);

220: --dbms_output.put_line ('done views create: '||to_char(sysdate, 'HH:MI:SS'))
221:
222: l_ignore := MEASURES_SHARED_UPDATE (p_user, l_vIgnore);
223: --dbms_output.put_line ('done meas create: '||to_char(sysdate, 'HH:MI:SS'));
224: zpb_aw.execute ('upd '||g_olapSchema||'.'||g_personalAW);
225: commit;
226:
227: -- Metadata for SHARED_VIEWS is shared between all users and thus does not to be
228: -- manipulated on a per user basis

Line 267: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);

263: commit;
264: end if;
265:
266: begin
267: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
268: exception
269: when others then
270: null;
271: end;

Line 320: zpb_aw.initialize (p_api_version => 1.0,

316:
317: FND_GLOBAL.APPS_INITIALIZE (p_user, l_resp, 210);
318: */
319:
320: zpb_aw.initialize (p_api_version => 1.0,
321: x_return_status => l_retStat,
322: x_msg_count => l_msgCnt,
323: x_msg_data => l_msgData,
324: p_business_area_id => p_business_area_id,

Line 349: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_codeAW||' ro');

345:
346: -- delete from zpb_metadata_map where aw_name = g_personalAW;
347: zpb_metadata_pkg.delete_user(g_personalAW);
348:
349: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_codeAW||' ro');
350:
351: begin
352: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_personalAW||' ro');
353: exception

Line 352: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_personalAW||' ro');

348:
349: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_codeAW||' ro');
350:
351: begin
352: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_personalAW||' ro');
353: exception
354: when others then
355: --
356: -- AW doesnt exist, so just return

Line 363: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);

359: end;
360:
361: zpb_olap_views_pkg.remove_user_views (p_user, p_business_area_id);
362:
363: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
364: zpb_aw.execute ('aw delete '||g_olapSchema||'.'||g_personalAW);
365:
366: EXCEPTION
367: WHEN aw_attached_rw_exception THEN

Line 364: zpb_aw.execute ('aw delete '||g_olapSchema||'.'||g_personalAW);

360:
361: zpb_olap_views_pkg.remove_user_views (p_user, p_business_area_id);
362:
363: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
364: zpb_aw.execute ('aw delete '||g_olapSchema||'.'||g_personalAW);
365:
366: EXCEPTION
367: WHEN aw_attached_rw_exception THEN
368:

Line 418: ZPB_AW.EXECUTE ('PA.VIEW.DELETED = no');

414:
415: begin
416: ZPB_LOG.WRITE ('zpb_metadata_map.aw_update.begin', 'Begin Metadata Update');
417:
418: ZPB_AW.EXECUTE ('PA.VIEW.DELETED = no');
419: --
420: -- For security, check to see if security needs updating:
421: --
422: for each in state_cur loop

Line 432: ZPB_AW.EXECUTE ('PA.VIEW.DELETED = yes');

428:
429: l_dims := METADATA_UPDATE(p_user, x_return_status);
430:
431: if (l_upd = true) then
432: ZPB_AW.EXECUTE ('PA.VIEW.DELETED = yes');
433: SECURITY_UPDATE(p_user, x_return_status);
434: --
435: -- Force refresh on all dim's views. If we need a metadata update
436: -- as well, then force a full refresh for logic's simplicity

Line 439: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');

435: -- Force refresh on all dim's views. If we need a metadata update
436: -- as well, then force a full refresh for logic's simplicity
437: --
438: if (l_dims is null) then
439: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
440: VIEWS_UPDATE(g_personalAW, p_user, l_dims, 'Y');
441:
442: ZPB_METADATA_PKG.BUILD_PERSONAL_DIMS (g_personalAW, g_sharedAW,
443: 'PERSONAL', l_dims);

Line 446: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');

442: ZPB_METADATA_PKG.BUILD_PERSONAL_DIMS (g_personalAW, g_sharedAW,
443: 'PERSONAL', l_dims);
444: l_dims := null;
445: else
446: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
447: end if;
448:
449: --
450: -- Update DC objects to regenerate the solve program (5093114)

Line 495: zpb_aw.execute('aw detach '||g_olapSchema||'.'||g_personalAW);

491: 'ZPB_STARTUP_DIM_MAP_ERR_MSG');
492: --
493: -- Reattach personal to remove changes to dimensions:
494: --
495: zpb_aw.execute('aw detach '||g_olapSchema||'.'||g_personalAW);
496: zpb_aw.execute('call PA.ATTACH.PERSONAL('''||p_user||''' '''||
497: g_attach_mode||''')');
498: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
499: FND_API.G_RET_STS_UNEXP_ERROR);

Line 496: zpb_aw.execute('call PA.ATTACH.PERSONAL('''||p_user||''' '''||

492: --
493: -- Reattach personal to remove changes to dimensions:
494: --
495: zpb_aw.execute('aw detach '||g_olapSchema||'.'||g_personalAW);
496: zpb_aw.execute('call PA.ATTACH.PERSONAL('''||p_user||''' '''||
497: g_attach_mode||''')');
498: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
499: FND_API.G_RET_STS_UNEXP_ERROR);
500:

Line 529: l_aw := zpb_aw.get_schema||'.'||g_personalAw;

525: 'Creating data views for '||p_user||
526: ', instance: '||p_instance);
527:
528: get_aws(p_user);
529: l_aw := zpb_aw.get_schema||'.'||g_personalAw;
530:
531: ZPB_AW.EXECUTE ('CALL CM.BUILD.INSTVIEW ('''||l_aw||''' '''||
532: p_instance||''' '''||p_type||''' '''||p_template||''' '''||
533: p_approver||''')');

Line 531: ZPB_AW.EXECUTE ('CALL CM.BUILD.INSTVIEW ('''||l_aw||''' '''||

527:
528: get_aws(p_user);
529: l_aw := zpb_aw.get_schema||'.'||g_personalAw;
530:
531: ZPB_AW.EXECUTE ('CALL CM.BUILD.INSTVIEW ('''||l_aw||''' '''||
532: p_instance||''' '''||p_type||''' '''||p_template||''' '''||
533: p_approver||''')');
534:
535: zpb_log.write('zpb_personal_aw.data_views_create.end',

Line 563: if (zpb_aw.interpbool('shw aw(attached '''||g_olapSchema||'.'||

559: l_ecm zpb_ecm.global_ecm;
560: begin
561: get_aws(p_user);
562:
563: if (zpb_aw.interpbool('shw aw(attached '''||g_olapSchema||'.'||
564: g_personalAW||''')')) then
565: if (lower(g_attach_mode) = 'rw') then
566: zpb_aw.execute ('upd '||g_olapSchema||'.'||g_personalAW);
567: end if;

Line 566: zpb_aw.execute ('upd '||g_olapSchema||'.'||g_personalAW);

562:
563: if (zpb_aw.interpbool('shw aw(attached '''||g_olapSchema||'.'||
564: g_personalAW||''')')) then
565: if (lower(g_attach_mode) = 'rw') then
566: zpb_aw.execute ('upd '||g_olapSchema||'.'||g_personalAW);
567: end if;
568:
569: commit;
570: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);

Line 570: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);

566: zpb_aw.execute ('upd '||g_olapSchema||'.'||g_personalAW);
567: end if;
568:
569: commit;
570: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
571: end if;
572:
573: l_aw := nvl(p_fromAW, g_sharedAW);
574: l_LOB := dbms_aw.eif_blob_out(g_olapSchema, l_aw);

Line 576: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||l_aw);

572:
573: l_aw := nvl(p_fromAW, g_sharedAW);
574: l_LOB := dbms_aw.eif_blob_out(g_olapSchema, l_aw);
575:
576: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||l_aw);
577: zpb_aw.execute ('call pa.attach.personal('''||p_user||''' '''||
578: g_attach_mode||''')');
579:
580: if (p_noScope = 'Y') then

Line 577: zpb_aw.execute ('call pa.attach.personal('''||p_user||''' '''||

573: l_aw := nvl(p_fromAW, g_sharedAW);
574: l_LOB := dbms_aw.eif_blob_out(g_olapSchema, l_aw);
575:
576: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||l_aw);
577: zpb_aw.execute ('call pa.attach.personal('''||p_user||''' '''||
578: g_attach_mode||''')');
579:
580: if (p_noScope = 'Y') then
581: l_ecm := zpb_ecm.get_global_ecm(g_personalAW);

Line 582: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');

578: g_attach_mode||''')');
579:
580: if (p_noScope = 'Y') then
581: l_ecm := zpb_ecm.get_global_ecm(g_personalAW);
582: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
583: i := 1;
584: loop
585: j := instr (l_dims, ' ', i);
586: if (j = 0) then

Line 593: l_obj := zpb_aw.interp('shw PERSONAL!'||l_ecm.ExpObjVar||' (PERSONAL!'

589: l_dim := substr (l_dims, i, j-i);
590: i := j+1;
591: end if;
592:
593: l_obj := zpb_aw.interp('shw PERSONAL!'||l_ecm.ExpObjVar||' (PERSONAL!'
594: ||l_ecm.DimDim||' '''||l_dim||''')');
595: l_val := ZPB_AW.EVAL_TEXT('obj(pmtread ''PERSONAL!'||
596: l_obj||''')');
597:

Line 595: l_val := ZPB_AW.EVAL_TEXT('obj(pmtread ''PERSONAL!'||

591: end if;
592:
593: l_obj := zpb_aw.interp('shw PERSONAL!'||l_ecm.ExpObjVar||' (PERSONAL!'
594: ||l_ecm.DimDim||' '''||l_dim||''')');
595: l_val := ZPB_AW.EVAL_TEXT('obj(pmtread ''PERSONAL!'||
596: l_obj||''')');
597:
598: if (length(l_val) > 1) then
599: zpb_aw.execute ('cns PERSONAL!'||l_obj);

Line 599: zpb_aw.execute ('cns PERSONAL!'||l_obj);

595: l_val := ZPB_AW.EVAL_TEXT('obj(pmtread ''PERSONAL!'||
596: l_obj||''')');
597:
598: if (length(l_val) > 1) then
599: zpb_aw.execute ('cns PERSONAL!'||l_obj);
600: zpb_aw.execute ('prp ''__READSCOPE'' obj(pmtread ''PERSONAL!'||
601: l_obj||''')');
602: zpb_aw.execute ('permit read when true');
603: end if;

Line 600: zpb_aw.execute ('prp ''__READSCOPE'' obj(pmtread ''PERSONAL!'||

596: l_obj||''')');
597:
598: if (length(l_val) > 1) then
599: zpb_aw.execute ('cns PERSONAL!'||l_obj);
600: zpb_aw.execute ('prp ''__READSCOPE'' obj(pmtread ''PERSONAL!'||
601: l_obj||''')');
602: zpb_aw.execute ('permit read when true');
603: end if;
604:

Line 602: zpb_aw.execute ('permit read when true');

598: if (length(l_val) > 1) then
599: zpb_aw.execute ('cns PERSONAL!'||l_obj);
600: zpb_aw.execute ('prp ''__READSCOPE'' obj(pmtread ''PERSONAL!'||
601: l_obj||''')');
602: zpb_aw.execute ('permit read when true');
603: end if;
604:
605: exit when j=0;
606: end loop;

Line 615: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');

611: l_LOB,
612: DBMS_AW.EIFIMP_DATA);
613:
614: if (p_noScope = 'Y') then
615: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
616: i := 1;
617: loop
618: j := instr (l_dims, ' ', i);
619: if (j = 0) then

Line 626: l_obj := zpb_aw.interp('shw PERSONAL!'||l_ecm.ExpObjVar||' (PERSONAL!'

622: l_dim := substr (l_dims, i, j-i);
623: i := j+1;
624: end if;
625:
626: l_obj := zpb_aw.interp('shw PERSONAL!'||l_ecm.ExpObjVar||' (PERSONAL!'
627: ||l_ecm.DimDim||' '''||l_dim||''')');
628: if (zpb_aw.interpbool('shw obj(hasproperty ''__READSCOPE'' '||
629: '''PERSONAL!'||l_obj||''')')) then
630: l_val := zpb_aw.interp ('shw obj(property ''__READSCOPE'' '||

Line 628: if (zpb_aw.interpbool('shw obj(hasproperty ''__READSCOPE'' '||

624: end if;
625:
626: l_obj := zpb_aw.interp('shw PERSONAL!'||l_ecm.ExpObjVar||' (PERSONAL!'
627: ||l_ecm.DimDim||' '''||l_dim||''')');
628: if (zpb_aw.interpbool('shw obj(hasproperty ''__READSCOPE'' '||
629: '''PERSONAL!'||l_obj||''')')) then
630: l_val := zpb_aw.interp ('shw obj(property ''__READSCOPE'' '||
631: '''PERSONAL!'||l_obj||''')');
632: if (length(l_val) > 1) then

Line 630: l_val := zpb_aw.interp ('shw obj(property ''__READSCOPE'' '||

626: l_obj := zpb_aw.interp('shw PERSONAL!'||l_ecm.ExpObjVar||' (PERSONAL!'
627: ||l_ecm.DimDim||' '''||l_dim||''')');
628: if (zpb_aw.interpbool('shw obj(hasproperty ''__READSCOPE'' '||
629: '''PERSONAL!'||l_obj||''')')) then
630: l_val := zpb_aw.interp ('shw obj(property ''__READSCOPE'' '||
631: '''PERSONAL!'||l_obj||''')');
632: if (length(l_val) > 1) then
633: zpb_aw.execute ('cns PERSONAL!'||l_obj);
634: zpb_aw.execute ('permit read when '||l_val);

Line 633: zpb_aw.execute ('cns PERSONAL!'||l_obj);

629: '''PERSONAL!'||l_obj||''')')) then
630: l_val := zpb_aw.interp ('shw obj(property ''__READSCOPE'' '||
631: '''PERSONAL!'||l_obj||''')');
632: if (length(l_val) > 1) then
633: zpb_aw.execute ('cns PERSONAL!'||l_obj);
634: zpb_aw.execute ('permit read when '||l_val);
635: zpb_aw.execute ('prp delete ''__READSCOPE''');
636: end if;
637: end if;

Line 634: zpb_aw.execute ('permit read when '||l_val);

630: l_val := zpb_aw.interp ('shw obj(property ''__READSCOPE'' '||
631: '''PERSONAL!'||l_obj||''')');
632: if (length(l_val) > 1) then
633: zpb_aw.execute ('cns PERSONAL!'||l_obj);
634: zpb_aw.execute ('permit read when '||l_val);
635: zpb_aw.execute ('prp delete ''__READSCOPE''');
636: end if;
637: end if;
638: exit when j=0;

Line 635: zpb_aw.execute ('prp delete ''__READSCOPE''');

631: '''PERSONAL!'||l_obj||''')');
632: if (length(l_val) > 1) then
633: zpb_aw.execute ('cns PERSONAL!'||l_obj);
634: zpb_aw.execute ('permit read when '||l_val);
635: zpb_aw.execute ('prp delete ''__READSCOPE''');
636: end if;
637: end if;
638: exit when j=0;
639: end loop;

Line 642: zpb_aw.execute ('upd '||g_olapSchema||'.'||g_personalAW);

638: exit when j=0;
639: end loop;
640: end if;
641: if (lower(g_attach_mode) = 'rw') then
642: zpb_aw.execute ('upd '||g_olapSchema||'.'||g_personalAW);
643: end if;
644: commit;
645:
646: end IMPORT;

Line 693: zpb_aw.execute ('call CM.DELPERSINST ('''||p_instance||''' '''||l_mode||

689: l_template := ''''||p_template||'''';
690: l_user := ''''||p_approvee||'''';
691: end if;
692:
693: zpb_aw.execute ('call CM.DELPERSINST ('''||p_instance||''' '''||l_mode||
694: ''' '||l_template||' '||l_user||')');
695:
696: end MEASURES_DELETE;
697:

Line 717: l_value := zpb_aw.interp ('call PA.MERGE.INST ('''||p_user||''' '''||

713: begin
714: zpb_log.write('zpb_personal_aw.measures_shared_update.begin',
715: 'Creating structures for shared measures');
716:
717: l_value := zpb_aw.interp ('call PA.MERGE.INST ('''||p_user||''' '''||
718: FND_GLOBAL.RESP_ID||''' '''||
719: g_personalAW||''' '''||g_sharedAW||''')');
720: if (l_value <> 'S') then
721: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,

Line 764: zpb_aw.execute ('call pa.attach.shared ('''||p_user||''')');

760: zpb_log.write('zpb_personal_aw.metadata_create.begin',
761: 'Creating personal metadata for '||p_user);
762:
763: get_aws(p_user);
764: zpb_aw.execute ('call pa.attach.shared ('''||p_user||''')');
765:
766: l_global_ecm := zpb_ecm.get_global_ecm(g_sharedAW);
767:
768: --

Line 772: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');

768: --
769: -- GLOBAL METADATA:
770: --
771:
772: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
773: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
774: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_annotAW);
775:
776: zpb_aw.execute ('oknullstatus=yes');

Line 774: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_annotAW);

770: --
771:
772: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
773: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
774: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_annotAW);
775:
776: zpb_aw.execute ('oknullstatus=yes');
777: zpb_aw.execute ('lmt '||l_global_ecm.ShapeEntryDim||' remove all');
778: zpb_aw.execute ('lmt '||l_global_ecm.MeasViewDim||' remove all');

Line 776: zpb_aw.execute ('oknullstatus=yes');

772: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
773: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
774: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_annotAW);
775:
776: zpb_aw.execute ('oknullstatus=yes');
777: zpb_aw.execute ('lmt '||l_global_ecm.ShapeEntryDim||' remove all');
778: zpb_aw.execute ('lmt '||l_global_ecm.MeasViewDim||' remove all');
779: zpb_aw.execute ('lmt '||l_annot_ecm.CellsObjDim||' remove all');
780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');

Line 777: zpb_aw.execute ('lmt '||l_global_ecm.ShapeEntryDim||' remove all');

773: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
774: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_annotAW);
775:
776: zpb_aw.execute ('oknullstatus=yes');
777: zpb_aw.execute ('lmt '||l_global_ecm.ShapeEntryDim||' remove all');
778: zpb_aw.execute ('lmt '||l_global_ecm.MeasViewDim||' remove all');
779: zpb_aw.execute ('lmt '||l_annot_ecm.CellsObjDim||' remove all');
780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');
781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');

Line 778: zpb_aw.execute ('lmt '||l_global_ecm.MeasViewDim||' remove all');

774: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_annotAW);
775:
776: zpb_aw.execute ('oknullstatus=yes');
777: zpb_aw.execute ('lmt '||l_global_ecm.ShapeEntryDim||' remove all');
778: zpb_aw.execute ('lmt '||l_global_ecm.MeasViewDim||' remove all');
779: zpb_aw.execute ('lmt '||l_annot_ecm.CellsObjDim||' remove all');
780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');
781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');
782: zpb_aw.execute ('limit '||l_global_ecm.SecEntityDim||' to user.entity');

Line 779: zpb_aw.execute ('lmt '||l_annot_ecm.CellsObjDim||' remove all');

775:
776: zpb_aw.execute ('oknullstatus=yes');
777: zpb_aw.execute ('lmt '||l_global_ecm.ShapeEntryDim||' remove all');
778: zpb_aw.execute ('lmt '||l_global_ecm.MeasViewDim||' remove all');
779: zpb_aw.execute ('lmt '||l_annot_ecm.CellsObjDim||' remove all');
780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');
781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');
782: zpb_aw.execute ('limit '||l_global_ecm.SecEntityDim||' to user.entity');
783: zpb_aw.execute ('lmt MEASURE remove all');

Line 780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');

776: zpb_aw.execute ('oknullstatus=yes');
777: zpb_aw.execute ('lmt '||l_global_ecm.ShapeEntryDim||' remove all');
778: zpb_aw.execute ('lmt '||l_global_ecm.MeasViewDim||' remove all');
779: zpb_aw.execute ('lmt '||l_annot_ecm.CellsObjDim||' remove all');
780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');
781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');
782: zpb_aw.execute ('limit '||l_global_ecm.SecEntityDim||' to user.entity');
783: zpb_aw.execute ('lmt MEASURE remove all');
784: zpb_aw.execute ('lmt INSTANCE remove all');

Line 781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');

777: zpb_aw.execute ('lmt '||l_global_ecm.ShapeEntryDim||' remove all');
778: zpb_aw.execute ('lmt '||l_global_ecm.MeasViewDim||' remove all');
779: zpb_aw.execute ('lmt '||l_annot_ecm.CellsObjDim||' remove all');
780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');
781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');
782: zpb_aw.execute ('limit '||l_global_ecm.SecEntityDim||' to user.entity');
783: zpb_aw.execute ('lmt MEASURE remove all');
784: zpb_aw.execute ('lmt INSTANCE remove all');
785: zpb_aw.execute ('lmt LANG to all');

Line 782: zpb_aw.execute ('limit '||l_global_ecm.SecEntityDim||' to user.entity');

778: zpb_aw.execute ('lmt '||l_global_ecm.MeasViewDim||' remove all');
779: zpb_aw.execute ('lmt '||l_annot_ecm.CellsObjDim||' remove all');
780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');
781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');
782: zpb_aw.execute ('limit '||l_global_ecm.SecEntityDim||' to user.entity');
783: zpb_aw.execute ('lmt MEASURE remove all');
784: zpb_aw.execute ('lmt INSTANCE remove all');
785: zpb_aw.execute ('lmt LANG to all');
786:

Line 783: zpb_aw.execute ('lmt MEASURE remove all');

779: zpb_aw.execute ('lmt '||l_annot_ecm.CellsObjDim||' remove all');
780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');
781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');
782: zpb_aw.execute ('limit '||l_global_ecm.SecEntityDim||' to user.entity');
783: zpb_aw.execute ('lmt MEASURE remove all');
784: zpb_aw.execute ('lmt INSTANCE remove all');
785: zpb_aw.execute ('lmt LANG to all');
786:
787: --

Line 784: zpb_aw.execute ('lmt INSTANCE remove all');

780: zpb_aw.execute ('lmt '||l_annot_ecm.LookupObjDim||' remove all');
781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');
782: zpb_aw.execute ('limit '||l_global_ecm.SecEntityDim||' to user.entity');
783: zpb_aw.execute ('lmt MEASURE remove all');
784: zpb_aw.execute ('lmt INSTANCE remove all');
785: zpb_aw.execute ('lmt LANG to all');
786:
787: --
788: -- Dimension metadata:

Line 785: zpb_aw.execute ('lmt LANG to all');

781: zpb_aw.execute ('limit '||l_global_ecm.SecUserDim||' to '''||p_user||'''');
782: zpb_aw.execute ('limit '||l_global_ecm.SecEntityDim||' to user.entity');
783: zpb_aw.execute ('lmt MEASURE remove all');
784: zpb_aw.execute ('lmt INSTANCE remove all');
785: zpb_aw.execute ('lmt LANG to all');
786:
787: --
788: -- Dimension metadata:
789: --

Line 790: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');

786:
787: --
788: -- Dimension metadata:
789: --
790: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
791: i := 1;
792: loop
793: j := instr (l_dims, ' ', i);
794: if (j = 0) then

Line 806: if (zpb_aw.interp('shw statlen('||l_dim_ecm.HierDim||')') <> '0') then

802:
803: --
804: -- Limit the levels/hierarchies down to what the user has access to
805: --
806: if (zpb_aw.interp('shw statlen('||l_dim_ecm.HierDim||')') <> '0') then
807: if (zpb_aw.interpbool ('shw any ('||l_dim_ecm.LevelDimScpFrm||
808: ' eq ''N'') or any ('||
809: l_dim_ecm.HierDimScpFrm||' eq ''N'')')) then
810: zpb_aw.execute('mnt '||l_dim_ecm.LevelDim||' delete '||

Line 807: if (zpb_aw.interpbool ('shw any ('||l_dim_ecm.LevelDimScpFrm||

803: --
804: -- Limit the levels/hierarchies down to what the user has access to
805: --
806: if (zpb_aw.interp('shw statlen('||l_dim_ecm.HierDim||')') <> '0') then
807: if (zpb_aw.interpbool ('shw any ('||l_dim_ecm.LevelDimScpFrm||
808: ' eq ''N'') or any ('||
809: l_dim_ecm.HierDimScpFrm||' eq ''N'')')) then
810: zpb_aw.execute('mnt '||l_dim_ecm.LevelDim||' delete '||
811: l_dim_ecm.LevelDimScpFrm||' eq ''N''');

Line 810: zpb_aw.execute('mnt '||l_dim_ecm.LevelDim||' delete '||

806: if (zpb_aw.interp('shw statlen('||l_dim_ecm.HierDim||')') <> '0') then
807: if (zpb_aw.interpbool ('shw any ('||l_dim_ecm.LevelDimScpFrm||
808: ' eq ''N'') or any ('||
809: l_dim_ecm.HierDimScpFrm||' eq ''N'')')) then
810: zpb_aw.execute('mnt '||l_dim_ecm.LevelDim||' delete '||
811: l_dim_ecm.LevelDimScpFrm||' eq ''N''');
812: zpb_aw.execute('mnt '||l_dim_ecm.HierDim||' delete '||
813: l_dim_ecm.HierDimScpFrm||' eq ''N''');
814:

Line 812: zpb_aw.execute('mnt '||l_dim_ecm.HierDim||' delete '||

808: ' eq ''N'') or any ('||
809: l_dim_ecm.HierDimScpFrm||' eq ''N'')')) then
810: zpb_aw.execute('mnt '||l_dim_ecm.LevelDim||' delete '||
811: l_dim_ecm.LevelDimScpFrm||' eq ''N''');
812: zpb_aw.execute('mnt '||l_dim_ecm.HierDim||' delete '||
813: l_dim_ecm.HierDimScpFrm||' eq ''N''');
814:
815: --
816: -- Fix the parentrel/inhier

Line 818: zpb_aw.execute ('push '||l_dim_data.ExpObj);

814:
815: --
816: -- Fix the parentrel/inhier
817: --
818: zpb_aw.execute ('push '||l_dim_data.ExpObj);
819: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||
820: l_dim_ecm.LevelRel||' eq NA');
821: zpb_aw.execute (l_dim_ecm.InHierVar||' = NO');
822: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');

Line 819: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||

815: --
816: -- Fix the parentrel/inhier
817: --
818: zpb_aw.execute ('push '||l_dim_data.ExpObj);
819: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||
820: l_dim_ecm.LevelRel||' eq NA');
821: zpb_aw.execute (l_dim_ecm.InHierVar||' = NO');
822: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');
823:

Line 821: zpb_aw.execute (l_dim_ecm.InHierVar||' = NO');

817: --
818: zpb_aw.execute ('push '||l_dim_data.ExpObj);
819: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||
820: l_dim_ecm.LevelRel||' eq NA');
821: zpb_aw.execute (l_dim_ecm.InHierVar||' = NO');
822: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');
823:
824: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||
825: l_dim_ecm.InHierVar||' ('||l_dim_data.ExpObj||' '||

Line 822: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');

818: zpb_aw.execute ('push '||l_dim_data.ExpObj);
819: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||
820: l_dim_ecm.LevelRel||' eq NA');
821: zpb_aw.execute (l_dim_ecm.InHierVar||' = NO');
822: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');
823:
824: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||
825: l_dim_ecm.InHierVar||' ('||l_dim_data.ExpObj||' '||
826: l_dim_ecm.ParentRel||') eq NO');

Line 824: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||

820: l_dim_ecm.LevelRel||' eq NA');
821: zpb_aw.execute (l_dim_ecm.InHierVar||' = NO');
822: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');
823:
824: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||
825: l_dim_ecm.InHierVar||' ('||l_dim_data.ExpObj||' '||
826: l_dim_ecm.ParentRel||') eq NO');
827: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');
828:

Line 827: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');

823:
824: zpb_aw.execute ('lmt '||l_dim_data.ExpObj||' to '||
825: l_dim_ecm.InHierVar||' ('||l_dim_data.ExpObj||' '||
826: l_dim_ecm.ParentRel||') eq NO');
827: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');
828:
829: zpb_aw.execute ('pop '||l_dim_data.ExpObj);
830:
831: zpb_aw.execute ('call DB.SET.GID('''||g_olapSchema||'.'||

Line 829: zpb_aw.execute ('pop '||l_dim_data.ExpObj);

825: l_dim_ecm.InHierVar||' ('||l_dim_data.ExpObj||' '||
826: l_dim_ecm.ParentRel||') eq NO');
827: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');
828:
829: zpb_aw.execute ('pop '||l_dim_data.ExpObj);
830:
831: zpb_aw.execute ('call DB.SET.GID('''||g_olapSchema||'.'||
832: g_sharedAW||''' '''||l_dim_data.ExpObj||''')');
833:

Line 831: zpb_aw.execute ('call DB.SET.GID('''||g_olapSchema||'.'||

827: zpb_aw.execute (l_dim_ecm.ParentRel||' = NA');
828:
829: zpb_aw.execute ('pop '||l_dim_data.ExpObj);
830:
831: zpb_aw.execute ('call DB.SET.GID('''||g_olapSchema||'.'||
832: g_sharedAW||''' '''||l_dim_data.ExpObj||''')');
833:
834: zpb_aw.execute ('call PA.SET.ORDER (''SHARED'' '''||
835: l_dim_data.ExpObj||''')');

Line 834: zpb_aw.execute ('call PA.SET.ORDER (''SHARED'' '''||

830:
831: zpb_aw.execute ('call DB.SET.GID('''||g_olapSchema||'.'||
832: g_sharedAW||''' '''||l_dim_data.ExpObj||''')');
833:
834: zpb_aw.execute ('call PA.SET.ORDER (''SHARED'' '''||
835: l_dim_data.ExpObj||''')');
836: end if;
837: end if;
838: exit when j=0;

Line 843: zpb_aw.execute('lmt '||l_global_ecm.AttrDim||' to '||

839: end loop;
840:
841: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(g_sharedAW);
842:
843: zpb_aw.execute('lmt '||l_global_ecm.AttrDim||' to '||
844: l_global_ecm.AttrDimScpFrm||' eq ''N''');
845: zpb_aw.execute('lmt '||l_global_ecm.DimDim||' to all');
846: zpb_aw.execute('mnt '||l_global_ecm.DimDim||' delete '||
847: l_global_attr_ecm.RangeDimRel);

Line 845: zpb_aw.execute('lmt '||l_global_ecm.DimDim||' to all');

841: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(g_sharedAW);
842:
843: zpb_aw.execute('lmt '||l_global_ecm.AttrDim||' to '||
844: l_global_ecm.AttrDimScpFrm||' eq ''N''');
845: zpb_aw.execute('lmt '||l_global_ecm.DimDim||' to all');
846: zpb_aw.execute('mnt '||l_global_ecm.DimDim||' delete '||
847: l_global_attr_ecm.RangeDimRel);
848: zpb_aw.execute('mnt '||l_global_ecm.AttrDim||' delete '||
849: l_global_ecm.AttrDimScpFrm||' eq ''N''');

Line 846: zpb_aw.execute('mnt '||l_global_ecm.DimDim||' delete '||

842:
843: zpb_aw.execute('lmt '||l_global_ecm.AttrDim||' to '||
844: l_global_ecm.AttrDimScpFrm||' eq ''N''');
845: zpb_aw.execute('lmt '||l_global_ecm.DimDim||' to all');
846: zpb_aw.execute('mnt '||l_global_ecm.DimDim||' delete '||
847: l_global_attr_ecm.RangeDimRel);
848: zpb_aw.execute('mnt '||l_global_ecm.AttrDim||' delete '||
849: l_global_ecm.AttrDimScpFrm||' eq ''N''');
850:

Line 848: zpb_aw.execute('mnt '||l_global_ecm.AttrDim||' delete '||

844: l_global_ecm.AttrDimScpFrm||' eq ''N''');
845: zpb_aw.execute('lmt '||l_global_ecm.DimDim||' to all');
846: zpb_aw.execute('mnt '||l_global_ecm.DimDim||' delete '||
847: l_global_attr_ecm.RangeDimRel);
848: zpb_aw.execute('mnt '||l_global_ecm.AttrDim||' delete '||
849: l_global_ecm.AttrDimScpFrm||' eq ''N''');
850:
851: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_sharedAW||' first');
852: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');

Line 851: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_sharedAW||' first');

847: l_global_attr_ecm.RangeDimRel);
848: zpb_aw.execute('mnt '||l_global_ecm.AttrDim||' delete '||
849: l_global_ecm.AttrDimScpFrm||' eq ''N''');
850:
851: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_sharedAW||' first');
852: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');
853: import (p_user, null, 'N');
854:
855: zpb_aw.execute ('call PA.ATTACH.SHARED('''||p_user||''' false)');

Line 852: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');

848: zpb_aw.execute('mnt '||l_global_ecm.AttrDim||' delete '||
849: l_global_ecm.AttrDimScpFrm||' eq ''N''');
850:
851: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_sharedAW||' first');
852: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');
853: import (p_user, null, 'N');
854:
855: zpb_aw.execute ('call PA.ATTACH.SHARED('''||p_user||''' false)');
856:

Line 855: zpb_aw.execute ('call PA.ATTACH.SHARED('''||p_user||''' false)');

851: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_sharedAW||' first');
852: zpb_aw.execute ('lmt name to obj(property ''PERSONALOBJ'') eq yes');
853: import (p_user, null, 'N');
854:
855: zpb_aw.execute ('call PA.ATTACH.SHARED('''||p_user||''' false)');
856:
857: zpb_log.write('zpb_personal_aw.metadata_create.end',
858: 'Created personal metadata for '||p_user);
859:

Line 883: l_ret := zpb_aw.interp('shw PA.META.UPDATE('''||p_user||''' '''||

879: begin
880: --
881: -- First determine if we are going to update the metadata scoping
882: --
883: l_ret := zpb_aw.interp('shw PA.META.UPDATE('''||p_user||''' '''||
884: g_olapSchema||'.'||g_sharedAW||''' '''||
885: g_olapSchema||'.'||g_personalAW||''')');
886: if (l_ret = 'NA' or l_ret = '') then
887: l_ret := null;

Line 900: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);

896: (G_PKG_NAME,
897: l_proc,
898: 'ZPB_STARTUP_META_UPD_ERR_MSG');
899:
900: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
901: zpb_aw.execute ('call PA.ATTACH.PERSONAL('''||p_user||''' '''||
902: g_attach_mode||''')');
903: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
904: FND_API.G_RET_STS_UNEXP_ERROR);

Line 901: zpb_aw.execute ('call PA.ATTACH.PERSONAL('''||p_user||''' '''||

897: l_proc,
898: 'ZPB_STARTUP_META_UPD_ERR_MSG');
899:
900: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
901: zpb_aw.execute ('call PA.ATTACH.PERSONAL('''||p_user||''' '''||
902: g_attach_mode||''')');
903: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
904: FND_API.G_RET_STS_UNEXP_ERROR);
905: return null;

Line 925: zpb_aw.execute('call SC.SET.PERS.SCP('''||p_user||''' '''||

921: i number;
922: j number;
923: l_dim_data zpb_ecm.dimension_data;
924: begin
925: zpb_aw.execute('call SC.SET.PERS.SCP('''||p_user||''' '''||
926: g_olapSchema||'.'||g_sharedAW||''' '''||g_olapSchema||'.'||
927: g_personalAW||''')');
928: exception
929: when others then

Line 1055: ZPB_AW.INITIALIZE_USER (p_api_version => 1.0,

1051: end if;
1052:
1053: if (l_resp <> l_mgrResp) then
1054:
1055: ZPB_AW.INITIALIZE_USER (p_api_version => 1.0,
1056: x_return_status => x_return_status,
1057: x_msg_count => x_msg_count,
1058: x_msg_data => x_msg_data,
1059: p_user => p_user,

Line 1090: zpb_aw.execute ('upd');

1086:
1087: MEASURES_APPROVER_UPDATE(p_user, x_return_status);
1088:
1089: if (p_read_only = FND_API.G_FALSE) then
1090: zpb_aw.execute ('upd');
1091: commit;
1092: end if;
1093: --dbms_output.put_line ('Update end: '||to_char(sysdate, 'HH:MI:SS'));
1094:

Line 1099: zpb_aw.execute ('call PA.ATTACH.SHARED('''||p_user||''' yes)');

1095: --
1096: -- Detach and Re-attach the Shared AW, augmenting the dimensions with
1097: -- the personal AW's personal AW dimension members
1098: --
1099: zpb_aw.execute ('call PA.ATTACH.SHARED('''||p_user||''' yes)');
1100: else
1101: ZPB_AW.INITIALIZE (p_api_version => 1.0,
1102: x_return_status => x_return_status,
1103: x_msg_count => x_msg_count,

Line 1101: ZPB_AW.INITIALIZE (p_api_version => 1.0,

1097: -- the personal AW's personal AW dimension members
1098: --
1099: zpb_aw.execute ('call PA.ATTACH.SHARED('''||p_user||''' yes)');
1100: else
1101: ZPB_AW.INITIALIZE (p_api_version => 1.0,
1102: x_return_status => x_return_status,
1103: x_msg_count => x_msg_count,
1104: x_msg_data => x_msg_data,
1105: p_business_area_id => sys_context('ZPB_CONTEXT',

Line 1140: zpb_aw.execute ('dotf tracefile');

1136: 'name context forever, level 4''';
1137: execute immediate l_comm;
1138: end if;
1139: if (l_trace = '3' or l_trace = '4') then
1140: zpb_aw.execute ('dotf tracefile');
1141: end if;
1142: end if;
1143: end if;
1144:

Line 1205: zpb_aw.execute ('call DB.BUILD.LMAP ('''||g_olapSchema||'.'||

1201: zpb_log.write('zpb_personal_aw.views_update.begin',
1202: 'Updating metadata views for dims: '||p_dims);
1203:
1204: if (p_dims is not null) then
1205: zpb_aw.execute ('call DB.BUILD.LMAP ('''||g_olapSchema||'.'||
1206: g_personalAW||''' '''||p_dims||''')');
1207: else
1208: zpb_aw.execute ('call DB.BUILD.LMAP ('''||g_olapSchema||'.'||
1209: g_personalAW||''')');

Line 1208: zpb_aw.execute ('call DB.BUILD.LMAP ('''||g_olapSchema||'.'||

1204: if (p_dims is not null) then
1205: zpb_aw.execute ('call DB.BUILD.LMAP ('''||g_olapSchema||'.'||
1206: g_personalAW||''' '''||p_dims||''')');
1207: else
1208: zpb_aw.execute ('call DB.BUILD.LMAP ('''||g_olapSchema||'.'||
1209: g_personalAW||''')');
1210: end if;
1211:
1212: --

Line 1221: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');

1217: if (p_doPers = 'Y') then
1218: if (p_dims is not null) then
1219: l_dims := p_dims;
1220: else
1221: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
1222: end if;
1223:
1224: l_aw := ZPB_AW.GET_SCHEMA||'.'||p_aw||'!';
1225: i := 1;

Line 1224: l_aw := ZPB_AW.GET_SCHEMA||'.'||p_aw||'!';

1220: else
1221: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
1222: end if;
1223:
1224: l_aw := ZPB_AW.GET_SCHEMA||'.'||p_aw||'!';
1225: i := 1;
1226: loop
1227: j := instr (l_dims, ' ', i);
1228: if (j = 0) then

Line 1239: if (to_number(ZPB_AW.INTERP('shw statlen(lmt('||l_aw||

1235:
1236: --
1237: -- If a personal level exists on the dimension...
1238: --
1239: if (to_number(ZPB_AW.INTERP('shw statlen(lmt('||l_aw||
1240: l_dim_ecm.LevelDim||' to '||l_aw||
1241: l_dim_ecm.LevelPersVar||'))')) > 0) then
1242: hi := 1;
1243: l_dim_data := zpb_ecm.get_dimension_data(l_ecmDim, p_aw);

Line 1244: l_hiers := ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||

1240: l_dim_ecm.LevelDim||' to '||l_aw||
1241: l_dim_ecm.LevelPersVar||'))')) > 0) then
1242: hi := 1;
1243: l_dim_data := zpb_ecm.get_dimension_data(l_ecmDim, p_aw);
1244: l_hiers := ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||
1245: l_dim_ecm.HierDim||''')');
1246: loop
1247: hj := instr (l_hiers, ' ', hi);
1248: if (hj = 0) then

Line 1255: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||

1251: l_hier := substr (l_hiers, hi, hj-hi);
1252: hi := hj+1;
1253: end if;
1254:
1255: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
1256: l_hier||'''');
1257: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
1258: ' to '||l_aw||l_dim_ecm.HierLevelVS);
1259: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||

Line 1257: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||

1253: end if;
1254:
1255: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
1256: l_hier||'''');
1257: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
1258: ' to '||l_aw||l_dim_ecm.HierLevelVS);
1259: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
1260: ' keep '||l_aw||l_dim_ecm.LevelPersVar);
1261: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||

Line 1259: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||

1255: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
1256: l_hier||'''');
1257: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
1258: ' to '||l_aw||l_dim_ecm.HierLevelVS);
1259: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
1260: ' keep '||l_aw||l_dim_ecm.LevelPersVar);
1261: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||
1262: l_dim_ecm.HOrderVS);
1263: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' keep '||

Line 1261: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||

1257: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
1258: ' to '||l_aw||l_dim_ecm.HierLevelVS);
1259: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
1260: ' keep '||l_aw||l_dim_ecm.LevelPersVar);
1261: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||
1262: l_dim_ecm.HOrderVS);
1263: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
1264: l_aw||l_dim_ecm.LevelRel);
1265: if (to_number(ZPB_AW.INTERP('shw statlen('||l_aw||

Line 1263: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' keep '||

1259: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
1260: ' keep '||l_aw||l_dim_ecm.LevelPersVar);
1261: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||
1262: l_dim_ecm.HOrderVS);
1263: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
1264: l_aw||l_dim_ecm.LevelRel);
1265: if (to_number(ZPB_AW.INTERP('shw statlen('||l_aw||
1266: l_dim_data.ExpObj||')')) > 0) then
1267: ZPB_OLAP_VIEWS_PKG.CREATE_DIMENSION_VIEWS(p_aw,

Line 1265: if (to_number(ZPB_AW.INTERP('shw statlen('||l_aw||

1261: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||
1262: l_dim_ecm.HOrderVS);
1263: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
1264: l_aw||l_dim_ecm.LevelRel);
1265: if (to_number(ZPB_AW.INTERP('shw statlen('||l_aw||
1266: l_dim_data.ExpObj||')')) > 0) then
1267: ZPB_OLAP_VIEWS_PKG.CREATE_DIMENSION_VIEWS(p_aw,
1268: 'PERSONAL',
1269: l_ecmDim);

Line 1321: where awname = upper(zpb_aw.get_personal_aw(p_user, p_business_area));

1317: --
1318: select awseq#
1319: into l_val
1320: from sys.aw$
1321: where awname = upper(zpb_aw.get_personal_aw(p_user, p_business_area));
1322:
1323: select sid
1324: into l_val
1325: from v$lock

Line 1464: zpb_aw.execute('CALL PA.ATTACH.APPROVEE('''||zpb_aw.get_schema||'.'||

1460: begin
1461: --
1462: -- Attach the approvee's personal AW:
1463: --
1464: zpb_aw.execute('CALL PA.ATTACH.APPROVEE('''||zpb_aw.get_schema||'.'||
1465: zpb_aw.get_personal_aw(personal.OBJECT_USER_ID)||''')');
1466: exception
1467: when others then
1468: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);

Line 1465: zpb_aw.get_personal_aw(personal.OBJECT_USER_ID)||''')');

1461: --
1462: -- Attach the approvee's personal AW:
1463: --
1464: zpb_aw.execute('CALL PA.ATTACH.APPROVEE('''||zpb_aw.get_schema||'.'||
1465: zpb_aw.get_personal_aw(personal.OBJECT_USER_ID)||''')');
1466: exception
1467: when others then
1468: ZPB_LOG.LOG_PLSQL_EXCEPTION (G_PKG_NAME, l_proc);
1469: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION