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

Line 206: zpb_aw.execute

202: into l_user_name
203: from FND_USER
204: where USER_ID = l_shdw_id;
205:
206: zpb_aw.execute
207: ('PERSONAL!MD.GLBL.CAT (PERSONAL!MD.GLBL.OBJ ''DHM'') = DB.DATE');
208:
209: --
210: -- Get the table/column information from the xdim table

Line 249: l_aw := zpb_aw.get_personal_aw(l_shdw_id);

245: if (l_dim_table_name is null) then
246: return;
247: end if;
248:
249: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
250: l_shrdAw := zpb_aw.get_shared_aw;
251: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
252: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
253: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);

Line 250: l_shrdAw := zpb_aw.get_shared_aw;

246: return;
247: end if;
248:
249: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
250: l_shrdAw := zpb_aw.get_shared_aw;
251: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
252: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
253: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
254:

Line 251: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';

247: end if;
248:
249: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
250: l_shrdAw := zpb_aw.get_shared_aw;
251: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
252: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
253: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
254:
255: if (p_dimension_id >= 100 and p_attr_id is null) then

Line 257: if (zpb_aw.interpbool ('shw isValue('||l_awQual||l_global_ecm.DimDim||

253: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
254:
255: if (p_dimension_id >= 100 and p_attr_id is null) then
256: for each in l_epb_dim_attrs loop
257: if (zpb_aw.interpbool ('shw isValue('||l_awQual||l_global_ecm.DimDim||
258: ' ''AV.A'||each.attribute_id||'.D'||
259: each.dimension_id||''')')) then
260: l_epb_dim := 'AV.A'||each.attribute_id||'.D'||each.dimension_id;
261: exit;

Line 275: l_epb_dim := zpb_aw.interp('shw lmt ('||l_awQual||l_global_ecm.DimDim

271: elsif (p_attr_id is null) then
272: delete from FEM_DIM_ATTRIBUTES_PRIV where USER_ID = l_apps_id;
273:
274: if (l_dim_type = 'LINE') then
275: l_epb_dim := zpb_aw.interp('shw lmt ('||l_awQual||l_global_ecm.DimDim
276: ||' to '||l_awQual||l_global_ecm.DimTypeRel
277: ||' eq ''LINE'')');
278: else
279:

Line 285: l_epb_dim := zpb_aw.interp('shw lmt ('||l_awQual||l_global_ecm.DimDim

281: ZPB_BUSAREA_MAINT.GENERATE_AW_DIM_NAME(l_dim_type,
282: l_dim_mbr_table,
283: l_aw_dim_name);
284:
285: l_epb_dim := zpb_aw.interp('shw lmt ('||l_awQual||l_global_ecm.DimDim
286: ||' to '||l_awQual||l_global_ecm.ExpObjVar
287: ||' eq '''||l_aw_dim_name||''')');
288: end if;
289: l_epb_dim_id := l_epb_dim;

Line 292: l_epb_dim_id := zpb_aw.interp('shw lmt ('||l_awQual||

288: end if;
289: l_epb_dim_id := l_epb_dim;
290: else
291: l_epb_dim := p_attr_id;
292: l_epb_dim_id := zpb_aw.interp('shw lmt ('||l_awQual||
293: l_global_ecm.AttrDim||' to '||l_awQual||
294: l_global_attr_ecm.RangeDimRel||' eq '''||
295: p_attr_id||''')');
296: end if;

Line 312: zpb_aw.execute ('push oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||

308: elsif (l_dim_data.Type = 'LINE') then
309: l_dim_line_ecm := zpb_ecm.get_dimension_line_ecm(l_epb_dim, l_aw);
310: end if;
311:
312: zpb_aw.execute ('push oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||
313: l_awQual||l_global_ecm.LangDim||' commas');
314: zpb_aw.execute ('oknullstatus = yes; commas = no');
315:
316: if (l_dim_value_sets = 'Y') then

Line 314: zpb_aw.execute ('oknullstatus = yes; commas = no');

310: end if;
311:
312: zpb_aw.execute ('push oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||
313: l_awQual||l_global_ecm.LangDim||' commas');
314: zpb_aw.execute ('oknullstatus = yes; commas = no');
315:
316: if (l_dim_value_sets = 'Y') then
317: select A.VALUE_SET_ID
318: into l_value_set_id

Line 341: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LangDim||' to '''||

337: end if;
338: --
339: -- HACK: is this needed? Should this happen in startup?
340: --
341: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LangDim||' to '''||
342: FND_GLOBAL.CURRENT_LANGUAGE||'''');
343: --
344: -- Update the Dimension member security table:
345: --

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

378:
379: --
380: -- Update the Attribute table
381: --
382: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.AttrDim||' to '||
383: l_awQual||l_global_attr_ecm.DomainDimRel||' eq '''||
384: l_epb_dim||'''');
385: l_attributes := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
386: l_global_ecm.AttrDim||''' YES)');

Line 385: l_attributes := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||

381: --
382: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.AttrDim||' to '||
383: l_awQual||l_global_attr_ecm.DomainDimRel||' eq '''||
384: l_epb_dim||'''');
385: l_attributes := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
386: l_global_ecm.AttrDim||''' YES)');
387:
388: if (l_attributes <> 'NA') then
389: i := 1;

Line 438: l_attr_dimdim := zpb_aw.interp

434: l_apps_id,
435: sysdate,
436: fnd_global.login_id);
437:
438: l_attr_dimdim := zpb_aw.interp
439: ('shw '||l_awQual||l_global_attr_ecm.RangeDimRel||
440: ' ('||l_awQual||l_global_ecm.AttrDim||' '''||l_attr||''')');
441:
442: if (l_attr_dim_id is not null) then

Line 588: zpb_aw.execute ('sort '||l_awQual||l_dim_ecm.HierDim||' a '||

584: -- Update the hierarchy information:
585: --
586: -- Sort to ensure version hierarchies are after effective:
587: --
588: zpb_aw.execute ('sort '||l_awQual||l_dim_ecm.HierDim||' a '||
589: l_awQual||l_dim_ecm.HierDim);
590: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
591: l_dim_ecm.HierDim||''')');
592: i := 1;

Line 590: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||

586: -- Sort to ensure version hierarchies are after effective:
587: --
588: zpb_aw.execute ('sort '||l_awQual||l_dim_ecm.HierDim||' a '||
589: l_awQual||l_dim_ecm.HierDim);
590: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
591: l_dim_ecm.HierDim||''')');
592: i := 1;
593: loop
594: exit when l_hiers = 'NA';

Line 603: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '''||

599: l_hier := substr (l_hiers, i, j-i);
600: i := j+1;
601: end if;
602:
603: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '''||
604: l_hier||'''');
605:
606: if (zpb_aw.interpbool ('shw exists('''||l_awQual||
607: l_dim_ecm.HierVersLdscVar||''')')) then

Line 606: if (zpb_aw.interpbool ('shw exists('''||l_awQual||

602:
603: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '''||
604: l_hier||'''');
605:
606: if (zpb_aw.interpbool ('shw exists('''||l_awQual||
607: l_dim_ecm.HierVersLdscVar||''')')) then
608: l_value2 :=zpb_aw.interp('shw '||l_awQual||
609: l_dim_ecm.HierVersLdscVar);
610: else

Line 608: l_value2 :=zpb_aw.interp('shw '||l_awQual||

604: l_hier||'''');
605:
606: if (zpb_aw.interpbool ('shw exists('''||l_awQual||
607: l_dim_ecm.HierVersLdscVar||''')')) then
608: l_value2 :=zpb_aw.interp('shw '||l_awQual||
609: l_dim_ecm.HierVersLdscVar);
610: else
611: l_value2 := null;
612: end if;

Line 615: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierFEMIDVar);

611: l_value2 := null;
612: end if;
613: if (l_value2 is null or l_value2 = 'NA') then
614: l_femHier :=
615: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierFEMIDVar);
616: else
617: l_femHier :=
618: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||
619: l_awQual||l_dim_ecm.HierDim||' '''||

Line 618: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||

614: l_femHier :=
615: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierFEMIDVar);
616: else
617: l_femHier :=
618: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||
619: l_awQual||l_dim_ecm.HierDim||' '''||
620: substr(l_hier, 1, instr(l_hier, 'V')-1)||''')');
621: if (upper(l_femHier) <> 'NA') then
622: zpb_aw.execute (l_awQual||l_dim_ecm.HierFEMIDVar||' = '''||

Line 622: zpb_aw.execute (l_awQual||l_dim_ecm.HierFEMIDVar||' = '''||

618: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||
619: l_awQual||l_dim_ecm.HierDim||' '''||
620: substr(l_hier, 1, instr(l_hier, 'V')-1)||''')');
621: if (upper(l_femHier) <> 'NA') then
622: zpb_aw.execute (l_awQual||l_dim_ecm.HierFEMIDVar||' = '''||
623: l_femHier||'''');
624: end if;
625: end if;
626:

Line 632: zpb_aw.execute (l_awQual||l_dim_ecm.HierFEMIDVar||' = '''||

628: --
629: -- Have to get an ID from FEM for the hierarchy
630: --
631: select to_char(FEM_OBJECT_ID_SEQ.nextVal) into l_femHier from dual;
632: zpb_aw.execute (l_awQual||l_dim_ecm.HierFEMIDVar||' = '''||
633: l_femHier||'''');
634: end if;
635:
636: l_femHierDef :=

Line 637: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierFEMDefIDVar);

633: l_femHier||'''');
634: end if;
635:
636: l_femHierDef :=
637: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierFEMDefIDVar);
638:
639: if (upper(l_femHierDef) = 'NA') then
640: --
641: -- Have to get an ID from FEM for the hierarchy

Line 645: zpb_aw.execute (l_awQual||l_dim_ecm.HierFEMDefIDVar||' = '''||

641: -- Have to get an ID from FEM for the hierarchy
642: --
643: select to_char(FEM_OBJECT_DEFINITION_ID_SEQ.nextVal)
644: into l_femHierDef from dual;
645: zpb_aw.execute (l_awQual||l_dim_ecm.HierFEMDefIDVar||' = '''||
646: l_femHierDef||'''');
647: end if;
648:
649: if (zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel)

Line 649: if (zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel)

645: zpb_aw.execute (l_awQual||l_dim_ecm.HierFEMDefIDVar||' = '''||
646: l_femHierDef||'''');
647: end if;
648:
649: if (zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel)
650: = 'VALUE_BASED') then
651: l_hierType := 'NO_GROUPS';
652: else
653: l_hierType := 'SEQUENCE_ENFORCED_SKIP_LEVEL';

Line 666: l_value2 := zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierLdscVar);

662: --
663: FEM_FOLDERS_UTL_PKG.GET_PERSONAL_FOLDER(l_apps_id, l_folder);
664:
665: if (l_value2 is null or l_value2 = 'NA') then
666: l_value2 := zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierLdscVar);
667: FEM_OBJECT_CATALOG_PKG.INSERT_ROW
668: (l_value,
669: to_number(l_femHier),
670: 'HIERARCHY',

Line 688: if (zpb_aw.interpbool ('shw exists('''||l_awQual||

684:
685: --
686: -- Update the Definition table:
687: --
688: if (zpb_aw.interpbool ('shw exists('''||l_awQual||
689: l_dim_ecm.HierVersLdscVar||''')')) then
690: l_value2 := zpb_aw.interp('shw '||l_awQual||
691: l_dim_ecm.HierVersLdscVar);
692: else

Line 690: l_value2 := zpb_aw.interp('shw '||l_awQual||

686: -- Update the Definition table:
687: --
688: if (zpb_aw.interpbool ('shw exists('''||l_awQual||
689: l_dim_ecm.HierVersLdscVar||''')')) then
690: l_value2 := zpb_aw.interp('shw '||l_awQual||
691: l_dim_ecm.HierVersLdscVar);
692: else
693: l_value2 := null;
694: end if;

Line 708: if (to_number(zpb_aw.interp('shw statlen(lmt('||l_awQual||

704: where OBJECT_ID = to_number(l_hier)
705: and EFFECTIVE_START_DATE <= sysdate
706: and EFFECTIVE_END_DATE >= sysdate;
707:
708: if (to_number(zpb_aw.interp('shw statlen(lmt('||l_awQual||
709: l_dim_ecm.HierDim||' to findchars('||l_awQual||
710: l_dim_ecm.HierDim||' '''||l_hier||'V'') gt 0))'))>0) then
711: l_startDate := sysdate;
712: end if;

Line 800: if (zpb_aw.interpbool ('shw exists('''||l_awQual||

796:
797: --
798: -- FEM_HIER_VALUE_SETS
799: --
800: if (zpb_aw.interpbool ('shw exists('''||l_awQual||
801: l_dim_ecm.HierVersLdscVar||''')')) then
802: l_value2 := zpb_aw.interp('shw '||l_awQual||
803: l_dim_ecm.HierVersLdscVar);
804: else

Line 802: l_value2 := zpb_aw.interp('shw '||l_awQual||

798: -- FEM_HIER_VALUE_SETS
799: --
800: if (zpb_aw.interpbool ('shw exists('''||l_awQual||
801: l_dim_ecm.HierVersLdscVar||''')')) then
802: l_value2 := zpb_aw.interp('shw '||l_awQual||
803: l_dim_ecm.HierVersLdscVar);
804: else
805: l_value2 := null;
806: end if;

Line 859: zpb_aw.interpbool('shw exists('''||l_awQual||

855: l_multi_vs := 'Y';
856: end;
857:
858: if (l_dim_data.Type = 'TIME' and
859: zpb_aw.interpbool('shw exists('''||l_awQual||
860: l_dim_time_ecm.CalendarVar||''')')) then
861: zpb_aw.execute('push '||l_awQual||l_dim_data.ExpObj);
862: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
863: l_awQual||l_dim_ecm.HOrderVS);

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

857:
858: if (l_dim_data.Type = 'TIME' and
859: zpb_aw.interpbool('shw exists('''||l_awQual||
860: l_dim_time_ecm.CalendarVar||''')')) then
861: zpb_aw.execute('push '||l_awQual||l_dim_data.ExpObj);
862: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
863: l_awQual||l_dim_ecm.HOrderVS);
864: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||
865: l_awQual||l_dim_ecm.MemberTypeRel||'''SHARED''');

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

858: if (l_dim_data.Type = 'TIME' and
859: zpb_aw.interpbool('shw exists('''||l_awQual||
860: l_dim_time_ecm.CalendarVar||''')')) then
861: zpb_aw.execute('push '||l_awQual||l_dim_data.ExpObj);
862: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
863: l_awQual||l_dim_ecm.HOrderVS);
864: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||
865: l_awQual||l_dim_ecm.MemberTypeRel||'''SHARED''');
866: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||

Line 864: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||

860: l_dim_time_ecm.CalendarVar||''')')) then
861: zpb_aw.execute('push '||l_awQual||l_dim_data.ExpObj);
862: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
863: l_awQual||l_dim_ecm.HOrderVS);
864: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||
865: l_awQual||l_dim_ecm.MemberTypeRel||'''SHARED''');
866: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||
867: ' keep first 1');
868: l_calendar_id := zpb_aw.interp('shw '||l_awQual||

Line 866: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||

862: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
863: l_awQual||l_dim_ecm.HOrderVS);
864: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||
865: l_awQual||l_dim_ecm.MemberTypeRel||'''SHARED''');
866: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||
867: ' keep first 1');
868: l_calendar_id := zpb_aw.interp('shw '||l_awQual||
869: l_dim_time_ecm.CalendarVar);
870: end if;

Line 868: l_calendar_id := zpb_aw.interp('shw '||l_awQual||

864: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||
865: l_awQual||l_dim_ecm.MemberTypeRel||'''SHARED''');
866: zpb_aw.execute('lmt '||l_awQual||l_dim_data.ExpObj||
867: ' keep first 1');
868: l_calendar_id := zpb_aw.interp('shw '||l_awQual||
869: l_dim_time_ecm.CalendarVar);
870: end if;
871:
872: insert into FEM_HIERARCHIES

Line 919: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||

915: -- Insert into the FEM Personal Hierarchy table:
916: --
917: -- First determine if personal hierarchy needed:
918: --
919: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
920: l_awQual||l_dim_ecm.LevelPersVar||' eq YES');
921: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
922: l_awQual||l_dim_ecm.HorderVS);
923: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||

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

917: -- First determine if personal hierarchy needed:
918: --
919: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
920: l_awQual||l_dim_ecm.LevelPersVar||' eq YES');
921: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
922: l_awQual||l_dim_ecm.HorderVS);
923: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||
924: l_awQual||l_dim_ecm.LevelRel);
925: if (zpb_aw.interp('shw convert(statlen('||l_awQual||l_dim_data.ExpObj

Line 923: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||

919: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
920: l_awQual||l_dim_ecm.LevelPersVar||' eq YES');
921: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
922: l_awQual||l_dim_ecm.HorderVS);
923: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||
924: l_awQual||l_dim_ecm.LevelRel);
925: if (zpb_aw.interp('shw convert(statlen('||l_awQual||l_dim_data.ExpObj
926: ||') TEXT 0 no no)') <> '0') then
927: l_dim_view := zpb_metadata_names.get_dimension_view (l_aw,

Line 925: if (zpb_aw.interp('shw convert(statlen('||l_awQual||l_dim_data.ExpObj

921: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
922: l_awQual||l_dim_ecm.HorderVS);
923: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||
924: l_awQual||l_dim_ecm.LevelRel);
925: if (zpb_aw.interp('shw convert(statlen('||l_awQual||l_dim_data.ExpObj
926: ||') TEXT 0 no no)') <> '0') then
927: l_dim_view := zpb_metadata_names.get_dimension_view (l_aw,
928: 'PERSONAL',
929: l_epb_dim_id,

Line 1107: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to all');

1103: --
1104: l_dim_view := zpb_metadata_names.get_dimension_view (l_shrdAw,
1105: 'PERSONAL',
1106: l_epb_dim_id);
1107: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to all');
1108: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' remove '||
1109: l_awQual||l_dim_ecm.MemberTypeRel||' ''SHARED''');
1110:
1111: l_dims :=

Line 1108: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' remove '||

1104: l_dim_view := zpb_metadata_names.get_dimension_view (l_shrdAw,
1105: 'PERSONAL',
1106: l_epb_dim_id);
1107: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to all');
1108: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' remove '||
1109: l_awQual||l_dim_ecm.MemberTypeRel||' ''SHARED''');
1110:
1111: l_dims :=
1112: zpb_aw.interp ('shw joinchars(joincols(charlist ('||l_awQual||

Line 1112: zpb_aw.interp ('shw joinchars(joincols(charlist ('||l_awQual||

1108: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' remove '||
1109: l_awQual||l_dim_ecm.MemberTypeRel||' ''SHARED''');
1110:
1111: l_dims :=
1112: zpb_aw.interp ('shw joinchars(joincols(charlist ('||l_awQual||
1113: l_dim_data.ExpObj||') ''\'',\''''))');
1114:
1115: if (l_dims <> ''',''') then
1116: l_dims := ''''||substr(l_dims, 1, length(l_dims) - 2);

Line 1256: zpb_aw.execute ('call DHM.EXPORT.ATTRS ('||l_apps_id||' '||

1252:
1253: --
1254: -- Populate the attribute relations:
1255: --
1256: zpb_aw.execute ('call DHM.EXPORT.ATTRS ('||l_apps_id||' '||
1257: ''''||l_epb_dim||''' '''||l_dim_data.ExpObj||''' '''||
1258: l_dim_attr_table||''' '''||l_dim_column||''' '''||
1259: l_dim_value_sets||''')');
1260:

Line 1266: if (l_dim_ecm.HierDim <> 'NA' and zpb_aw.interp

1262: --
1263: -- Populate the dimension groups table
1264: --
1265:
1266: if (l_dim_ecm.HierDim <> 'NA' and zpb_aw.interp
1267: ('shw obj(dimmax '''||l_awQual||l_dim_ecm.HierDim||''')') <> '0') then
1268: zpb_aw.execute ('push '||l_awQual||l_dim_ecm.LevelDim);
1269: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||l_awQual||
1270: l_dim_ecm.LevelPersVar||' eq yes');

Line 1268: zpb_aw.execute ('push '||l_awQual||l_dim_ecm.LevelDim);

1264: --
1265:
1266: if (l_dim_ecm.HierDim <> 'NA' and zpb_aw.interp
1267: ('shw obj(dimmax '''||l_awQual||l_dim_ecm.HierDim||''')') <> '0') then
1268: zpb_aw.execute ('push '||l_awQual||l_dim_ecm.LevelDim);
1269: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||l_awQual||
1270: l_dim_ecm.LevelPersVar||' eq yes');
1271: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
1272: ' remove findchars ('||l_dim_ecm.LevelLdscVar||

Line 1269: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||l_awQual||

1265:
1266: if (l_dim_ecm.HierDim <> 'NA' and zpb_aw.interp
1267: ('shw obj(dimmax '''||l_awQual||l_dim_ecm.HierDim||''')') <> '0') then
1268: zpb_aw.execute ('push '||l_awQual||l_dim_ecm.LevelDim);
1269: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||l_awQual||
1270: l_dim_ecm.LevelPersVar||' eq yes');
1271: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
1272: ' remove findchars ('||l_dim_ecm.LevelLdscVar||
1273: ' ''LV_'') gt 0');

Line 1271: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||

1267: ('shw obj(dimmax '''||l_awQual||l_dim_ecm.HierDim||''')') <> '0') then
1268: zpb_aw.execute ('push '||l_awQual||l_dim_ecm.LevelDim);
1269: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||l_awQual||
1270: l_dim_ecm.LevelPersVar||' eq yes');
1271: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
1272: ' remove findchars ('||l_dim_ecm.LevelLdscVar||
1273: ' ''LV_'') gt 0');
1274:
1275: l_levels := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||

Line 1275: l_levels := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||

1271: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
1272: ' remove findchars ('||l_dim_ecm.LevelLdscVar||
1273: ' ''LV_'') gt 0');
1274:
1275: l_levels := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
1276: l_dim_ecm.LevelDim||''' yes)');
1277: if (l_levels <> 'NA') then
1278: i := 1;
1279: loop

Line 1288: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||

1284: l_level := substr (l_levels, i, j-i);
1285: i := j+1;
1286: end if;
1287:
1288: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||
1289: l_level||'''');
1290: --
1291: -- The following handles the case where a hierarchy is added
1292: -- after a personal level is created:

Line 1294: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '||

1290: --
1291: -- The following handles the case where a hierarchy is added
1292: -- after a personal level is created:
1293: --
1294: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '||
1295: l_awQual||l_dim_ecm.LevelDepthVar||' ne NA');
1296:
1297: l_value := null;
1298: l_level_type := null;

Line 1301: l_level_type := zpb_aw.interp('shw '||l_awQual||l_dim_time_ecm.TLvlTypeRel);

1297: l_value := null;
1298: l_level_type := null;
1299: l_time_dim_grp_key := null;
1300: if (l_dim_data.Type = 'TIME') then
1301: l_level_type := zpb_aw.interp('shw '||l_awQual||l_dim_time_ecm.TLvlTypeRel);
1302: select fem_time_dimension_group_key_s.nextval into
1303: l_time_dim_grp_key from dual;
1304: end if;
1305:

Line 1311: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelDepthVar),

1307: (l_value,
1308: l_level,
1309: l_time_dim_grp_key,
1310: p_dimension_id,
1311: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelDepthVar),
1312: l_level_type,
1313: 'N',
1314: 1,
1315: 'Y',

Line 1317: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelSdscVar),

1313: 'N',
1314: 1,
1315: 'Y',
1316: 'Y',
1317: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelSdscVar),
1318: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelMdscVar),
1319: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelLdscVar),
1320: sysdate,
1321: l_apps_id,

Line 1318: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelMdscVar),

1314: 1,
1315: 'Y',
1316: 'Y',
1317: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelSdscVar),
1318: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelMdscVar),
1319: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelLdscVar),
1320: sysdate,
1321: l_apps_id,
1322: sysdate,

Line 1319: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelLdscVar),

1315: 'Y',
1316: 'Y',
1317: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelSdscVar),
1318: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelMdscVar),
1319: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.LevelLdscVar),
1320: sysdate,
1321: l_apps_id,
1322: sysdate,
1323: l_apps_id,

Line 1330: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '||l_awQual||

1326: exit when j=0;
1327: end loop;
1328: end if;
1329:
1330: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '||l_awQual||
1331: l_dim_ecm.HierTypeRel||' eq ''LEVEL_BASED''');
1332: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' keep '||l_awQual||
1333: l_dim_ecm.HierVersLdscVar||' eq NA');
1334:

Line 1332: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' keep '||l_awQual||

1328: end if;
1329:
1330: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '||l_awQual||
1331: l_dim_ecm.HierTypeRel||' eq ''LEVEL_BASED''');
1332: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' keep '||l_awQual||
1333: l_dim_ecm.HierVersLdscVar||' eq NA');
1334:
1335: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
1336: l_dim_ecm.HierDim||''' yes)');

Line 1335: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||

1331: l_dim_ecm.HierTypeRel||' eq ''LEVEL_BASED''');
1332: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' keep '||l_awQual||
1333: l_dim_ecm.HierVersLdscVar||' eq NA');
1334:
1335: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
1336: l_dim_ecm.HierDim||''' yes)');
1337: if (l_hiers <> 'NA') then
1338: i := 1;
1339: loop

Line 1347: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '''||

1343: else
1344: l_hier := substr (l_hiers, i, j-i);
1345: i := j+1;
1346: end if;
1347: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '''||
1348: l_hier||'''');
1349: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
1350: l_awQual||l_dim_ecm.HierLevelVS);
1351: l_femHier :=

Line 1349: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||

1345: i := j+1;
1346: end if;
1347: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '''||
1348: l_hier||'''');
1349: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
1350: l_awQual||l_dim_ecm.HierLevelVS);
1351: l_femHier :=
1352: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||
1353: l_awQual||l_dim_ecm.HierDim||' '''||l_hier||''')');

Line 1352: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||

1348: l_hier||'''');
1349: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
1350: l_awQual||l_dim_ecm.HierLevelVS);
1351: l_femHier :=
1352: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||
1353: l_awQual||l_dim_ecm.HierDim||' '''||l_hier||''')');
1354: l_levels := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
1355: l_dim_ecm.LevelDim||''' yes)');
1356: if (l_levels <> 'NA') then

Line 1354: l_levels := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||

1350: l_awQual||l_dim_ecm.HierLevelVS);
1351: l_femHier :=
1352: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||
1353: l_awQual||l_dim_ecm.HierDim||' '''||l_hier||''')');
1354: l_levels := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
1355: l_dim_ecm.LevelDim||''' yes)');
1356: if (l_levels <> 'NA') then
1357: k := 1;
1358: loop

Line 1366: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||

1362: else
1363: l_level := substr (l_levels, k, m-k);
1364: k := m+1;
1365: end if;
1366: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
1367: ' to '''||l_level||'''');
1368: insert into FEM_HIER_DIMENSION_GRPS
1369: (DIMENSION_GROUP_ID,
1370: HIERARCHY_OBJ_ID,

Line 1380: zpb_aw.interp('shw '||l_awQual||

1376: LAST_UPDATE_LOGIN,
1377: OBJECT_VERSION_NUMBER)
1378: values (l_level,
1379: l_femHier,
1380: zpb_aw.interp('shw '||l_awQual||
1381: l_dim_ecm.LevelDepthVar) + 1,
1382: sysdate,
1383: l_apps_id,
1384: l_apps_id,

Line 1396: zpb_aw.execute ('pop '||l_awQual||l_dim_ecm.LevelDim);

1392: exit when j=0;
1393:
1394: end loop;
1395: end if;
1396: zpb_aw.execute ('pop '||l_awQual||l_dim_ecm.LevelDim);
1397: end if;
1398:
1399: zpb_aw.execute ('pop oknullstatus commas '||l_awQual||l_dim_data.ExpObj||
1400: ' '||l_awQual||l_global_ecm.LangDim);

Line 1399: zpb_aw.execute ('pop oknullstatus commas '||l_awQual||l_dim_data.ExpObj||

1395: end if;
1396: zpb_aw.execute ('pop '||l_awQual||l_dim_ecm.LevelDim);
1397: end if;
1398:
1399: zpb_aw.execute ('pop oknullstatus commas '||l_awQual||l_dim_data.ExpObj||
1400: ' '||l_awQual||l_global_ecm.LangDim);
1401:
1402: if (FND_API.TO_BOOLEAN (p_commit)) then
1403: zpb_aw.execute ('upd');

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

1399: zpb_aw.execute ('pop oknullstatus commas '||l_awQual||l_dim_data.ExpObj||
1400: ' '||l_awQual||l_global_ecm.LangDim);
1401:
1402: if (FND_API.TO_BOOLEAN (p_commit)) then
1403: zpb_aw.execute ('upd');
1404: commit work;
1405: end if;
1406:
1407: FND_MSG_PUB.COUNT_AND_GET

Line 1555: zpb_aw.interp ('shw '||l_dim_ecm.HierFEMIDVar)

1551: cursor l_hier_grps is
1552: select DIMENSION_GROUP_ID
1553: from FEM_HIER_DIMENSION_GRPS
1554: where HIERARCHY_OBJ_ID =
1555: zpb_aw.interp ('shw '||l_dim_ecm.HierFEMIDVar)
1556: order by RELATIVE_DIMENSION_GROUP_SEQ;
1557: begin
1558: SAVEPOINT Import_Dimension_Grp;
1559:

Line 1578: zpb_aw.execute ('commas = no');

1574: l_shdw_id := nvl(sys_context('ZPB_CONTEXT', 'shadow_id'),
1575: fnd_global.user_id);
1576: l_apps_id := nvl(sys_context('ZPB_CONTEXT', 'user_id'), fnd_global.user_id);
1577:
1578: zpb_aw.execute ('commas = no');
1579:
1580: l_upd_date := 'to_date ('''||
1581: zpb_aw.interp('shw PERSONAL!MD.GLBL.CAT (MD.GLBL.OBJ ''DHM'')')||
1582: ''', ''YYYY/MM/DD HH24:MI:SS'')';

Line 1581: zpb_aw.interp('shw PERSONAL!MD.GLBL.CAT (MD.GLBL.OBJ ''DHM'')')||

1577:
1578: zpb_aw.execute ('commas = no');
1579:
1580: l_upd_date := 'to_date ('''||
1581: zpb_aw.interp('shw PERSONAL!MD.GLBL.CAT (MD.GLBL.OBJ ''DHM'')')||
1582: ''', ''YYYY/MM/DD HH24:MI:SS'')';
1583:
1584: zpb_aw.execute('PERSONAL!MD.GLBL.CAT (MD.GLBL.OBJ ''DHM'') = DB.DATE');
1585:

Line 1584: zpb_aw.execute('PERSONAL!MD.GLBL.CAT (MD.GLBL.OBJ ''DHM'') = DB.DATE');

1580: l_upd_date := 'to_date ('''||
1581: zpb_aw.interp('shw PERSONAL!MD.GLBL.CAT (MD.GLBL.OBJ ''DHM'')')||
1582: ''', ''YYYY/MM/DD HH24:MI:SS'')';
1583:
1584: zpb_aw.execute('PERSONAL!MD.GLBL.CAT (MD.GLBL.OBJ ''DHM'') = DB.DATE');
1585:
1586: --
1587: -- Get the table/column information from the xdim table
1588: --

Line 1618: l_aw := zpb_aw.get_personal_aw(l_shdw_id);

1614: FEM_XDIM_DIMENSIONS
1615: where
1616: DIMENSION_ID = p_dimension_id;
1617:
1618: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
1619: l_shrdAw := zpb_aw.get_shared_aw;
1620: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
1621: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
1622: l_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);

Line 1619: l_shrdAw := zpb_aw.get_shared_aw;

1615: where
1616: DIMENSION_ID = p_dimension_id;
1617:
1618: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
1619: l_shrdAw := zpb_aw.get_shared_aw;
1620: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
1621: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
1622: l_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
1623:

Line 1620: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';

1616: DIMENSION_ID = p_dimension_id;
1617:
1618: l_aw := zpb_aw.get_personal_aw(l_shdw_id);
1619: l_shrdAw := zpb_aw.get_shared_aw;
1620: l_awQual := zpb_aw.get_schema||'.'||l_aw||'!';
1621: l_global_ecm := zpb_ecm.get_global_ecm(l_aw);
1622: l_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
1623:
1624: if (p_attr_id is null) then

Line 1626: l_epb_dim := zpb_aw.interp('shw lmt ('||l_awQual||l_global_ecm.DimDim

1622: l_attr_ecm := zpb_ecm.get_global_attr_ecm(l_aw);
1623:
1624: if (p_attr_id is null) then
1625: if (l_dim_type = 'LINE') then
1626: l_epb_dim := zpb_aw.interp('shw lmt ('||l_awQual||l_global_ecm.DimDim
1627: ||' to '||l_awQual||l_global_ecm.DimTypeRel
1628: ||' eq ''LINE'')');
1629: else
1630:

Line 1636: l_epb_dim := zpb_aw.interp('shw lmt ('||l_awQual||l_global_ecm.DimDim

1632: ZPB_BUSAREA_MAINT.GENERATE_AW_DIM_NAME(l_dim_type,
1633: l_dim_mbr_table,
1634: l_aw_dim_name);
1635:
1636: l_epb_dim := zpb_aw.interp('shw lmt ('||l_awQual||l_global_ecm.DimDim
1637: ||' to '||l_awQual||l_global_ecm.ExpObjVar
1638: ||' eq '''||l_aw_dim_name||''')');
1639: end if;
1640: else

Line 1658: zpb_aw.execute ('push oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||

1654: elsif (l_dim_data.Type = 'LINE') then
1655: l_dim_line_ecm := zpb_ecm.get_dimension_line_ecm(l_epb_dim, l_aw);
1656: end if;
1657:
1658: zpb_aw.execute ('push oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||
1659: l_awQual||l_global_ecm.LangDim||' '||l_awQual||
1660: l_dim_ecm.LevelDim);
1661: zpb_aw.execute ('oknullstatus = yes; commas = no');
1662:

Line 1661: zpb_aw.execute ('oknullstatus = yes; commas = no');

1657:
1658: zpb_aw.execute ('push oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||
1659: l_awQual||l_global_ecm.LangDim||' '||l_awQual||
1660: l_dim_ecm.LevelDim);
1661: zpb_aw.execute ('oknullstatus = yes; commas = no');
1662:
1663: --
1664: -- Parse the MEMBER_B table for removed dimensions:
1665: --

Line 1666: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to all');

1662:
1663: --
1664: -- Parse the MEMBER_B table for removed dimensions:
1665: --
1666: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to all');
1667:
1668: l_command := 'select '||l_dim_view_col||' from '||l_dim_view||
1669: ' minus select to_char(';
1670: if (l_dim_value_sets = 'Y') then

Line 1695: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||l_dim_mbr_id_list);

1691: -- bug 5493497/6119917 cannot delete in a loop
1692: -- delete the member(s) if any need to be deleted
1693: if (length(l_dim_mbr_id_list) > 0)
1694: then
1695: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||l_dim_mbr_id_list);
1696:
1697: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||l_awQual||l_dim_ecm.MemberTypeRel||' NE ''SHARED'' ');
1698:
1699: l_dim_mbr_id_list := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||l_dim_data.ExpObj||''' YES)');

Line 1697: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||l_awQual||l_dim_ecm.MemberTypeRel||' NE ''SHARED'' ');

1693: if (length(l_dim_mbr_id_list) > 0)
1694: then
1695: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||l_dim_mbr_id_list);
1696:
1697: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||l_awQual||l_dim_ecm.MemberTypeRel||' NE ''SHARED'' ');
1698:
1699: l_dim_mbr_id_list := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||l_dim_data.ExpObj||''' YES)');
1700:
1701: -- if there are any values to delete make a list of them

Line 1699: l_dim_mbr_id_list := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||l_dim_data.ExpObj||''' YES)');

1695: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||l_dim_mbr_id_list);
1696:
1697: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' keep '||l_awQual||l_dim_ecm.MemberTypeRel||' NE ''SHARED'' ');
1698:
1699: l_dim_mbr_id_list := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||l_dim_data.ExpObj||''' YES)');
1700:
1701: -- if there are any values to delete make a list of them
1702: l_dim_mbr_dlt_list := '';
1703: if (l_dim_mbr_id_list <> 'NA') then

Line 1717: zpb_aw.execute ('call sc.pers.obj.mnt('''||l_awQual||l_dim_data.ExpObj||

1713: l_dim_mbr_dlt_list := l_dim_mbr_dlt_list||'\'''|| l_dim_mbr_id||'\'' ';
1714: exit when j=0;
1715: end loop;
1716:
1717: zpb_aw.execute ('call sc.pers.obj.mnt('''||l_awQual||l_dim_data.ExpObj||
1718: ''' ''mnt '||l_awQual||l_dim_data.ExpObj||' delete '||
1719: l_dim_mbr_dlt_list||''')');
1720: end if;
1721: end if;

Line 1726: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||

1722:
1723: --
1724: -- Look for removed DIMENSION_GROUPS
1725: --
1726: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
1727: l_awQual||l_dim_ecm.LevelPersVar||' eq yes');
1728: if (l_dim_ecm.LevelDim <> 'NA' and
1729: zpb_aw.interp ('shw statlen('||l_awQual||l_dim_ecm.LevelDim||')') <> '0')
1730: then

Line 1729: zpb_aw.interp ('shw statlen('||l_awQual||l_dim_ecm.LevelDim||')') <> '0')

1725: --
1726: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
1727: l_awQual||l_dim_ecm.LevelPersVar||' eq yes');
1728: if (l_dim_ecm.LevelDim <> 'NA' and
1729: zpb_aw.interp ('shw statlen('||l_awQual||l_dim_ecm.LevelDim||')') <> '0')
1730: then
1731: open l_existing_levels;
1732: loop
1733: fetch l_existing_levels into l_level;

Line 1736: if (zpb_aw.interpbool('shw isvalue('||l_awQual||l_dim_ecm.LevelDim||

1732: loop
1733: fetch l_existing_levels into l_level;
1734: exit when l_existing_levels%NOTFOUND;
1735:
1736: if (zpb_aw.interpbool('shw isvalue('||l_awQual||l_dim_ecm.LevelDim||
1737: ' '''||l_level||''')')) then
1738: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
1739: ' remove '''||l_level||'''');
1740: end if;

Line 1738: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||

1734: exit when l_existing_levels%NOTFOUND;
1735:
1736: if (zpb_aw.interpbool('shw isvalue('||l_awQual||l_dim_ecm.LevelDim||
1737: ' '''||l_level||''')')) then
1738: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
1739: ' remove '''||l_level||'''');
1740: end if;
1741: end loop;
1742:

Line 1743: if (zpb_aw.interp('shw statlen ('||l_awQual||

1739: ' remove '''||l_level||'''');
1740: end if;
1741: end loop;
1742:
1743: if (zpb_aw.interp('shw statlen ('||l_awQual||
1744: l_dim_ecm.LevelDim||')') <> 0) then
1745: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||
1746: ' delete values('||l_awQual||l_dim_ecm.LevelDim||')');
1747: end if;

Line 1745: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||

1741: end loop;
1742:
1743: if (zpb_aw.interp('shw statlen ('||l_awQual||
1744: l_dim_ecm.LevelDim||')') <> 0) then
1745: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||
1746: ' delete values('||l_awQual||l_dim_ecm.LevelDim||')');
1747: end if;
1748: end if;
1749:

Line 1774: if (not zpb_aw.interpbool ('shw isvalue('||l_awQual||l_dim_ecm.LevelDim||

1770: fetch l_imp_dim_curs into l_level, l_level_seq,
1771: l_level_name, l_level_desc, l_level_code;
1772: exit when l_imp_dim_curs%NOTFOUND;
1773:
1774: if (not zpb_aw.interpbool ('shw isvalue('||l_awQual||l_dim_ecm.LevelDim||
1775: ' '''||l_level||''')')) then
1776: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||' add '''||
1777: l_level||'''');
1778: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||

Line 1776: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||' add '''||

1772: exit when l_imp_dim_curs%NOTFOUND;
1773:
1774: if (not zpb_aw.interpbool ('shw isvalue('||l_awQual||l_dim_ecm.LevelDim||
1775: ' '''||l_level||''')')) then
1776: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||' add '''||
1777: l_level||'''');
1778: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||
1779: l_level||'''');
1780: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');

Line 1778: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||

1774: if (not zpb_aw.interpbool ('shw isvalue('||l_awQual||l_dim_ecm.LevelDim||
1775: ' '''||l_level||''')')) then
1776: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||' add '''||
1777: l_level||'''');
1778: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||
1779: l_level||'''');
1780: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');
1781: else
1782: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||

Line 1780: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');

1776: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||' add '''||
1777: l_level||'''');
1778: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||
1779: l_level||'''');
1780: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');
1781: else
1782: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||
1783: l_level||'''');
1784: end if;

Line 1782: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||

1778: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||
1779: l_level||'''');
1780: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');
1781: else
1782: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '''||
1783: l_level||'''');
1784: end if;
1785:
1786: CONVERT_NAME (l_level_name);

Line 1789: zpb_aw.execute

1785:
1786: CONVERT_NAME (l_level_name);
1787: CONVERT_NAME (l_level_desc);
1788: CONVERT_NAME (l_level_code);
1789: zpb_aw.execute
1790: (l_awQual||l_dim_ecm.LevelMdscVar||' = '''||l_level_name||'''');
1791: zpb_aw.execute
1792: (l_awQual||l_dim_ecm.LevelLdscVar||' = '''||l_level_desc||'''');
1793: zpb_aw.execute

Line 1791: zpb_aw.execute

1787: CONVERT_NAME (l_level_desc);
1788: CONVERT_NAME (l_level_code);
1789: zpb_aw.execute
1790: (l_awQual||l_dim_ecm.LevelMdscVar||' = '''||l_level_name||'''');
1791: zpb_aw.execute
1792: (l_awQual||l_dim_ecm.LevelLdscVar||' = '''||l_level_desc||'''');
1793: zpb_aw.execute
1794: (l_awQual||l_dim_ecm.LevelSdscVar||' = '''||l_level_code||'''');
1795: zpb_aw.execute (l_awQual||l_dim_ecm.LevelDepthVar||' = '||l_level_seq);

Line 1793: zpb_aw.execute

1789: zpb_aw.execute
1790: (l_awQual||l_dim_ecm.LevelMdscVar||' = '''||l_level_name||'''');
1791: zpb_aw.execute
1792: (l_awQual||l_dim_ecm.LevelLdscVar||' = '''||l_level_desc||'''');
1793: zpb_aw.execute
1794: (l_awQual||l_dim_ecm.LevelSdscVar||' = '''||l_level_code||'''');
1795: zpb_aw.execute (l_awQual||l_dim_ecm.LevelDepthVar||' = '||l_level_seq);
1796: if (l_dim_data.Type = 'TIME') then
1797: select B.NUMBER_ASSIGN_VALUE TIME_LVL_PERIODS

Line 1795: zpb_aw.execute (l_awQual||l_dim_ecm.LevelDepthVar||' = '||l_level_seq);

1791: zpb_aw.execute
1792: (l_awQual||l_dim_ecm.LevelLdscVar||' = '''||l_level_desc||'''');
1793: zpb_aw.execute
1794: (l_awQual||l_dim_ecm.LevelSdscVar||' = '''||l_level_code||'''');
1795: zpb_aw.execute (l_awQual||l_dim_ecm.LevelDepthVar||' = '||l_level_seq);
1796: if (l_dim_data.Type = 'TIME') then
1797: select B.NUMBER_ASSIGN_VALUE TIME_LVL_PERIODS
1798: into l_num_periods_in_year
1799: from FEM_DIMENSION_GRPS_B A,

Line 1810: l_level_type := zpb_aw.interp ('shw SQ.CONV.TIMELVLS('''||l_num_periods_in_year||''')');

1806: AND C.ATTRIBUTE_VARCHAR_LABEL(+) = 'PERIODS_IN_YEAR'
1807: AND B.VERSION_ID = D.VERSION_ID(+)
1808: AND B.ATTRIBUTE_ID = D.ATTRIBUTE_ID(+)
1809: AND D.DEFAULT_VERSION_FLAG(+) = 'Y';
1810: l_level_type := zpb_aw.interp ('shw SQ.CONV.TIMELVLS('''||l_num_periods_in_year||''')');
1811: zpb_aw.execute (l_awQual||l_dim_time_ecm.TlvlTypeRel||' = '''||l_level_type||'''');
1812: end if;
1813: end loop;
1814: close l_imp_dim_curs;

Line 1811: zpb_aw.execute (l_awQual||l_dim_time_ecm.TlvlTypeRel||' = '''||l_level_type||'''');

1807: AND B.VERSION_ID = D.VERSION_ID(+)
1808: AND B.ATTRIBUTE_ID = D.ATTRIBUTE_ID(+)
1809: AND D.DEFAULT_VERSION_FLAG(+) = 'Y';
1810: l_level_type := zpb_aw.interp ('shw SQ.CONV.TIMELVLS('''||l_num_periods_in_year||''')');
1811: zpb_aw.execute (l_awQual||l_dim_time_ecm.TlvlTypeRel||' = '''||l_level_type||'''');
1812: end if;
1813: end loop;
1814: close l_imp_dim_curs;
1815:

Line 1857: if(not zpb_aw.interpbool('shw isvalue('||l_awQual||l_dim_data.ExpObj||

1853: exit when l_imp_dim_curs%NOTFOUND;
1854:
1855: if (l_last_dim_id is null or l_last_dim_id <> l_dim_mbr_id) then
1856:
1857: if(not zpb_aw.interpbool('shw isvalue('||l_awQual||l_dim_data.ExpObj||
1858: ' '''||l_dim_mbr_id||''')')) then
1859: zpb_aw.execute ('call sc.pers.obj.mnt('''||l_awQual||
1860: l_dim_data.ExpObj||''' ''mnt '||l_awQual||
1861: l_dim_data.ExpObj||' add \'''||

Line 1859: zpb_aw.execute ('call sc.pers.obj.mnt('''||l_awQual||

1855: if (l_last_dim_id is null or l_last_dim_id <> l_dim_mbr_id) then
1856:
1857: if(not zpb_aw.interpbool('shw isvalue('||l_awQual||l_dim_data.ExpObj||
1858: ' '''||l_dim_mbr_id||''')')) then
1859: zpb_aw.execute ('call sc.pers.obj.mnt('''||l_awQual||
1860: l_dim_data.ExpObj||''' ''mnt '||l_awQual||
1861: l_dim_data.ExpObj||' add \'''||
1862: l_dim_mbr_id||'\'''')');
1863: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||

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

1859: zpb_aw.execute ('call sc.pers.obj.mnt('''||l_awQual||
1860: l_dim_data.ExpObj||''' ''mnt '||l_awQual||
1861: l_dim_data.ExpObj||' add \'''||
1862: l_dim_mbr_id||'\'''')');
1863: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
1864: l_dim_mbr_id||'''');
1865: zpb_aw.execute (l_awQual||l_dim_ecm.MemberTypeRel||
1866: ' = ''PERSONAL''');
1867: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = NO');

Line 1865: zpb_aw.execute (l_awQual||l_dim_ecm.MemberTypeRel||

1861: l_dim_data.ExpObj||' add \'''||
1862: l_dim_mbr_id||'\'''')');
1863: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
1864: l_dim_mbr_id||'''');
1865: zpb_aw.execute (l_awQual||l_dim_ecm.MemberTypeRel||
1866: ' = ''PERSONAL''');
1867: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = NO');
1868: -- Add read-only to shared AW to synch shared up (4733894):
1869: zpb_aw.execute ('mnt SHARED!'||l_dim_data.ExpObj||' add '''||

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

1863: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
1864: l_dim_mbr_id||'''');
1865: zpb_aw.execute (l_awQual||l_dim_ecm.MemberTypeRel||
1866: ' = ''PERSONAL''');
1867: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = NO');
1868: -- Add read-only to shared AW to synch shared up (4733894):
1869: zpb_aw.execute ('mnt SHARED!'||l_dim_data.ExpObj||' add '''||
1870: l_dim_mbr_id||'''');
1871: if (l_dim_data.Type = 'LINE') then

Line 1869: zpb_aw.execute ('mnt SHARED!'||l_dim_data.ExpObj||' add '''||

1865: zpb_aw.execute (l_awQual||l_dim_ecm.MemberTypeRel||
1866: ' = ''PERSONAL''');
1867: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = NO');
1868: -- Add read-only to shared AW to synch shared up (4733894):
1869: zpb_aw.execute ('mnt SHARED!'||l_dim_data.ExpObj||' add '''||
1870: l_dim_mbr_id||'''');
1871: if (l_dim_data.Type = 'LINE') then
1872: ZPB_AW.EXECUTE ('call PA.ADDPERSLINE('''||l_dim_mbr_id||''')');
1873: end if;

Line 1872: ZPB_AW.EXECUTE ('call PA.ADDPERSLINE('''||l_dim_mbr_id||''')');

1868: -- Add read-only to shared AW to synch shared up (4733894):
1869: zpb_aw.execute ('mnt SHARED!'||l_dim_data.ExpObj||' add '''||
1870: l_dim_mbr_id||'''');
1871: if (l_dim_data.Type = 'LINE') then
1872: ZPB_AW.EXECUTE ('call PA.ADDPERSLINE('''||l_dim_mbr_id||''')');
1873: end if;
1874: else
1875: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
1876: l_dim_mbr_id||'''');

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

1871: if (l_dim_data.Type = 'LINE') then
1872: ZPB_AW.EXECUTE ('call PA.ADDPERSLINE('''||l_dim_mbr_id||''')');
1873: end if;
1874: else
1875: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
1876: l_dim_mbr_id||'''');
1877: end if;
1878: if (l_level is not null) then
1879: zpb_aw.execute (l_awQual||l_dim_ecm.DfltLevelRel||' = '''||

Line 1879: zpb_aw.execute (l_awQual||l_dim_ecm.DfltLevelRel||' = '''||

1875: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
1876: l_dim_mbr_id||'''');
1877: end if;
1878: if (l_level is not null) then
1879: zpb_aw.execute (l_awQual||l_dim_ecm.DfltLevelRel||' = '''||
1880: l_level||'''');
1881: end if;
1882:
1883: l_last_dim_id := l_dim_mbr_id;

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

1881: end if;
1882:
1883: l_last_dim_id := l_dim_mbr_id;
1884: else
1885: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
1886: l_dim_mbr_id||'''');
1887: end if;
1888: CONVERT_NAME (l_dim_code);
1889: CONVERT_NAME (l_dim_name);

Line 1896: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LangDim||' to '''||

1892: l_dim_desc := ''''||l_dim_desc||'''';
1893: else
1894: l_dim_desc := 'NA';
1895: end if;
1896: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LangDim||' to '''||
1897: l_lang||'''');
1898: zpb_aw.execute (l_awQual||l_dim_ecm.SdscVar||' = '''||l_dim_code||'''');
1899: zpb_aw.execute (l_awQual||l_dim_ecm.MdscVar||' = '''||l_dim_name||'''');
1900: zpb_aw.execute (l_awQual||l_dim_ecm.LdscVar||' = '||l_dim_desc);

Line 1898: zpb_aw.execute (l_awQual||l_dim_ecm.SdscVar||' = '''||l_dim_code||'''');

1894: l_dim_desc := 'NA';
1895: end if;
1896: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LangDim||' to '''||
1897: l_lang||'''');
1898: zpb_aw.execute (l_awQual||l_dim_ecm.SdscVar||' = '''||l_dim_code||'''');
1899: zpb_aw.execute (l_awQual||l_dim_ecm.MdscVar||' = '''||l_dim_name||'''');
1900: zpb_aw.execute (l_awQual||l_dim_ecm.LdscVar||' = '||l_dim_desc);
1901: if (l_dim_data.Type = 'TIME' and
1902: zpb_aw.interpbool('shw exists('''||l_awQual||

Line 1899: zpb_aw.execute (l_awQual||l_dim_ecm.MdscVar||' = '''||l_dim_name||'''');

1895: end if;
1896: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LangDim||' to '''||
1897: l_lang||'''');
1898: zpb_aw.execute (l_awQual||l_dim_ecm.SdscVar||' = '''||l_dim_code||'''');
1899: zpb_aw.execute (l_awQual||l_dim_ecm.MdscVar||' = '''||l_dim_name||'''');
1900: zpb_aw.execute (l_awQual||l_dim_ecm.LdscVar||' = '||l_dim_desc);
1901: if (l_dim_data.Type = 'TIME' and
1902: zpb_aw.interpbool('shw exists('''||l_awQual||
1903: l_dim_time_ecm.CalendarVar||''')')) then

Line 1900: zpb_aw.execute (l_awQual||l_dim_ecm.LdscVar||' = '||l_dim_desc);

1896: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LangDim||' to '''||
1897: l_lang||'''');
1898: zpb_aw.execute (l_awQual||l_dim_ecm.SdscVar||' = '''||l_dim_code||'''');
1899: zpb_aw.execute (l_awQual||l_dim_ecm.MdscVar||' = '''||l_dim_name||'''');
1900: zpb_aw.execute (l_awQual||l_dim_ecm.LdscVar||' = '||l_dim_desc);
1901: if (l_dim_data.Type = 'TIME' and
1902: zpb_aw.interpbool('shw exists('''||l_awQual||
1903: l_dim_time_ecm.CalendarVar||''')')) then
1904: zpb_aw.execute (l_awQual||l_dim_time_ecm.CalendarVar||' = '||

Line 1902: zpb_aw.interpbool('shw exists('''||l_awQual||

1898: zpb_aw.execute (l_awQual||l_dim_ecm.SdscVar||' = '''||l_dim_code||'''');
1899: zpb_aw.execute (l_awQual||l_dim_ecm.MdscVar||' = '''||l_dim_name||'''');
1900: zpb_aw.execute (l_awQual||l_dim_ecm.LdscVar||' = '||l_dim_desc);
1901: if (l_dim_data.Type = 'TIME' and
1902: zpb_aw.interpbool('shw exists('''||l_awQual||
1903: l_dim_time_ecm.CalendarVar||''')')) then
1904: zpb_aw.execute (l_awQual||l_dim_time_ecm.CalendarVar||' = '||
1905: l_dim_calendar);
1906: end if;

Line 1904: zpb_aw.execute (l_awQual||l_dim_time_ecm.CalendarVar||' = '||

1900: zpb_aw.execute (l_awQual||l_dim_ecm.LdscVar||' = '||l_dim_desc);
1901: if (l_dim_data.Type = 'TIME' and
1902: zpb_aw.interpbool('shw exists('''||l_awQual||
1903: l_dim_time_ecm.CalendarVar||''')')) then
1904: zpb_aw.execute (l_awQual||l_dim_time_ecm.CalendarVar||' = '||
1905: l_dim_calendar);
1906: end if;
1907: end loop;
1908: close l_imp_dim_curs;

Line 1915: if (zpb_aw.interp ('shw obj(dimmax '''||l_awQual||l_dim_ecm.HierDim||

1911: -- Read in hierarchy information:
1912: --
1913: -- Update the levels in this hierarchy, if level-based
1914: --
1915: if (zpb_aw.interp ('shw obj(dimmax '''||l_awQual||l_dim_ecm.HierDim||
1916: ''')') <> '0') then
1917: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
1918: l_dim_ecm.HierDim||''')');
1919: hi := 1;

Line 1917: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||

1913: -- Update the levels in this hierarchy, if level-based
1914: --
1915: if (zpb_aw.interp ('shw obj(dimmax '''||l_awQual||l_dim_ecm.HierDim||
1916: ''')') <> '0') then
1917: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_awQual||
1918: l_dim_ecm.HierDim||''')');
1919: hi := 1;
1920: loop
1921: hj := instr (l_hiers, ' ', hi);

Line 1931: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||

1927: end if;
1928:
1929: if (instr(l_value, 'V') > 1) then
1930: l_femHier :=
1931: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||
1932: l_awQual||l_dim_ecm.HierDim||' '''||
1933: substr(l_value, 1, instr(l_value, 'V')-1)||''')');
1934: else
1935: l_femHier := l_value;

Line 1937: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '''||

1933: substr(l_value, 1, instr(l_value, 'V')-1)||''')');
1934: else
1935: l_femHier := l_value;
1936: end if;
1937: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '''||
1938: l_femHier||'''');
1939:
1940: l_hier_type :=
1941: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel);

Line 1941: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel);

1937: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '''||
1938: l_femHier||'''');
1939:
1940: l_hier_type :=
1941: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel);
1942: if (l_hier_type = 'LEVEL_BASED') then
1943: l_levels := '';
1944: for each in l_hier_grps loop
1945: l_levels := l_levels||' '''||each.DIMENSION_GROUP_ID||'''';

Line 1947: l_value2 := zpb_aw.interp ('shw values('||l_awQual||

1943: l_levels := '';
1944: for each in l_hier_grps loop
1945: l_levels := l_levels||' '''||each.DIMENSION_GROUP_ID||'''';
1946: end loop;
1947: l_value2 := zpb_aw.interp ('shw values('||l_awQual||
1948: l_dim_ecm.HierLevelVS||')');
1949: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.HierLevelVS||' to '||
1950: l_levels);
1951: if (zpb_aw.interp ('shw values('||l_awQual||

Line 1949: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.HierLevelVS||' to '||

1945: l_levels := l_levels||' '''||each.DIMENSION_GROUP_ID||'''';
1946: end loop;
1947: l_value2 := zpb_aw.interp ('shw values('||l_awQual||
1948: l_dim_ecm.HierLevelVS||')');
1949: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.HierLevelVS||' to '||
1950: l_levels);
1951: if (zpb_aw.interp ('shw values('||l_awQual||
1952: l_dim_ecm.HierLevelVS||')') <> l_value2) then
1953: l_view_changed := true;

Line 1951: if (zpb_aw.interp ('shw values('||l_awQual||

1947: l_value2 := zpb_aw.interp ('shw values('||l_awQual||
1948: l_dim_ecm.HierLevelVS||')');
1949: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.HierLevelVS||' to '||
1950: l_levels);
1951: if (zpb_aw.interp ('shw values('||l_awQual||
1952: l_dim_ecm.HierLevelVS||')') <> l_value2) then
1953: l_view_changed := true;
1954: l_gid_changed := true;
1955: end if;

Line 1956: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.LevelDim||

1952: l_dim_ecm.HierLevelVS||')') <> l_value2) then
1953: l_view_changed := true;
1954: l_gid_changed := true;
1955: end if;
1956: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.LevelDim||
1957: ' to '||l_awQual||l_dim_ecm.HierLevelVS);
1958: end if;
1959:
1960: --

Line 1973: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||

1969: l_command := 'select distinct to_char(A.CHILD_ID)';
1970: end if;
1971: if (instr(l_value, 'V') > 1) then
1972: l_femHier :=
1973: zpb_aw.interp('shw '||l_awQual||l_dim_ecm.HierFEMIDVar||' ('||
1974: l_awQual||l_dim_ecm.HierDim||' '''||
1975: substr(l_value, 1, instr(l_value, 'V')-1)||''')'); else
1976: l_femHier := l_value;
1977: end if;

Line 1991: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||

1987: ' and A.CREATED_BY = '||l_apps_id||
1988: ' and A.HIERARCHY_OBJ_DEF_ID = D.OBJECT_DEFINITION_ID'||
1989: ' and D.OBJECT_ID = '||l_femHier;
1990:
1991: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||
1992: ' to '||l_awQual||l_dim_ecm.HorderVS);
1993: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||
1994: ' keep '||l_awQual||l_dim_ecm.MemberTypeRel||
1995: ' ne ''SHARED''');

Line 1993: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||

1989: ' and D.OBJECT_ID = '||l_femHier;
1990:
1991: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||
1992: ' to '||l_awQual||l_dim_ecm.HorderVS);
1993: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||
1994: ' keep '||l_awQual||l_dim_ecm.MemberTypeRel||
1995: ' ne ''SHARED''');
1996: open l_imp_dim_curs for l_command;
1997: loop

Line 2001: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||

1997: loop
1998: fetch l_imp_dim_curs into l_child;
1999: exit when l_imp_dim_curs%NOTFOUND;
2000:
2001: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||
2002: ' remove '''||l_child||'''');
2003: end loop;
2004: if (zpb_aw.interp('shw statlen('||l_awQual||l_dim_data.ExpObj||
2005: ')') <> '0') then

Line 2004: if (zpb_aw.interp('shw statlen('||l_awQual||l_dim_data.ExpObj||

2000:
2001: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||
2002: ' remove '''||l_child||'''');
2003: end loop;
2004: if (zpb_aw.interp('shw statlen('||l_awQual||l_dim_data.ExpObj||
2005: ')') <> '0') then
2006: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = no');
2007: zpb_aw.execute (l_awQual||l_dim_ecm.ParentRel||' = na');
2008: l_gid_changed := true;

Line 2006: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = no');

2002: ' remove '''||l_child||'''');
2003: end loop;
2004: if (zpb_aw.interp('shw statlen('||l_awQual||l_dim_data.ExpObj||
2005: ')') <> '0') then
2006: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = no');
2007: zpb_aw.execute (l_awQual||l_dim_ecm.ParentRel||' = na');
2008: l_gid_changed := true;
2009: --
2010: -- Could have removed all members at a level:

Line 2007: zpb_aw.execute (l_awQual||l_dim_ecm.ParentRel||' = na');

2003: end loop;
2004: if (zpb_aw.interp('shw statlen('||l_awQual||l_dim_data.ExpObj||
2005: ')') <> '0') then
2006: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = no');
2007: zpb_aw.execute (l_awQual||l_dim_ecm.ParentRel||' = na');
2008: l_gid_changed := true;
2009: --
2010: -- Could have removed all members at a level:
2011: --

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

2056: fetch l_imp_dim_curs into l_parent, l_child, l_parent_depth,
2057: l_child_depth, l_order, l_hier;
2058: exit when l_imp_dim_curs%NOTFOUND;
2059:
2060: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2061: l_child||'''');
2062: if (l_last_hier is null or l_hier <> l_last_hier) then
2063: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '||
2064: l_awQual||l_dim_ecm.HierFEMIDVar||' eq '||l_hier);

Line 2063: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '||

2059:
2060: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2061: l_child||'''');
2062: if (l_last_hier is null or l_hier <> l_last_hier) then
2063: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '||
2064: l_awQual||l_dim_ecm.HierFEMIDVar||' eq '||l_hier);
2065:
2066: l_hier_type :=
2067: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel);

Line 2067: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel);

2063: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.HierDim||' to '||
2064: l_awQual||l_dim_ecm.HierFEMIDVar||' eq '||l_hier);
2065:
2066: l_hier_type :=
2067: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel);
2068: l_last_hier := l_hier;
2069: end if;
2070:
2071: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = YES');

Line 2071: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = YES');

2067: zpb_aw.interp ('shw '||l_awQual||l_dim_ecm.HierTypeRel);
2068: l_last_hier := l_hier;
2069: end if;
2070:
2071: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = YES');
2072: zpb_aw.execute (l_awQual||l_dim_ecm.SibOrderVar||' = '||l_order||
2073: '-.5');
2074: if (l_parent_depth <> l_child_depth) then
2075: zpb_aw.execute (l_awQual||l_dim_ecm.ParentRel||' = '''||l_parent||

Line 2072: zpb_aw.execute (l_awQual||l_dim_ecm.SibOrderVar||' = '||l_order||

2068: l_last_hier := l_hier;
2069: end if;
2070:
2071: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = YES');
2072: zpb_aw.execute (l_awQual||l_dim_ecm.SibOrderVar||' = '||l_order||
2073: '-.5');
2074: if (l_parent_depth <> l_child_depth) then
2075: zpb_aw.execute (l_awQual||l_dim_ecm.ParentRel||' = '''||l_parent||
2076: '''');

Line 2075: zpb_aw.execute (l_awQual||l_dim_ecm.ParentRel||' = '''||l_parent||

2071: zpb_aw.execute (l_awQual||l_dim_ecm.InHierVar||' = YES');
2072: zpb_aw.execute (l_awQual||l_dim_ecm.SibOrderVar||' = '||l_order||
2073: '-.5');
2074: if (l_parent_depth <> l_child_depth) then
2075: zpb_aw.execute (l_awQual||l_dim_ecm.ParentRel||' = '''||l_parent||
2076: '''');
2077: end if;
2078:
2079: if (l_hier_type = 'LEVEL_BASED') then

Line 2080: zpb_aw.execute (l_awQual||l_dim_ecm.LevelRel||' = '||

2076: '''');
2077: end if;
2078:
2079: if (l_hier_type = 'LEVEL_BASED') then
2080: zpb_aw.execute (l_awQual||l_dim_ecm.LevelRel||' = '||
2081: l_dim_ecm.DfltLevelRel);
2082:
2083: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
2084: l_awQual||l_dim_ecm.LevelRel||' '||

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

2079: if (l_hier_type = 'LEVEL_BASED') then
2080: zpb_aw.execute (l_awQual||l_dim_ecm.LevelRel||' = '||
2081: l_dim_ecm.DfltLevelRel);
2082:
2083: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
2084: l_awQual||l_dim_ecm.LevelRel||' '||
2085: l_awQual||l_dim_ecm.LevelRel);
2086: if (zpb_aw.interp ('shw convert(statlen('||l_awQual||
2087: l_dim_data.ExpObj||') TEXT 0 no no)') = '1') then

Line 2086: if (zpb_aw.interp ('shw convert(statlen('||l_awQual||

2082:
2083: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '||
2084: l_awQual||l_dim_ecm.LevelRel||' '||
2085: l_awQual||l_dim_ecm.LevelRel);
2086: if (zpb_aw.interp ('shw convert(statlen('||l_awQual||
2087: l_dim_data.ExpObj||') TEXT 0 no no)') = '1') then
2088: l_view_changed := true;
2089: end if;
2090: else

Line 2091: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||

2087: l_dim_data.ExpObj||') TEXT 0 no no)') = '1') then
2088: l_view_changed := true;
2089: end if;
2090: else
2091: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
2092: l_awQual||l_dim_ecm.HierLevelVS);
2093: l_value := zpb_aw.interp ('shw statlen('||l_awQual||
2094: l_dim_ecm.LevelDim||')');
2095: if (l_child_depth > to_number(l_value)) then

Line 2093: l_value := zpb_aw.interp ('shw statlen('||l_awQual||

2089: end if;
2090: else
2091: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.LevelDim||' to '||
2092: l_awQual||l_dim_ecm.HierLevelVS);
2093: l_value := zpb_aw.interp ('shw statlen('||l_awQual||
2094: l_dim_ecm.LevelDim||')');
2095: if (l_child_depth > to_number(l_value)) then
2096: --
2097: -- Create a fake level for value-based hierarchy:

Line 2101: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||

2097: -- Create a fake level for value-based hierarchy:
2098: --
2099: select '999'||to_char(FEM_DIMENSION_GRPS_B_S.NEXTVAL)
2100: into l_level from dual;
2101: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||
2102: ' add '''||l_level||'''');
2103: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.HierLevelVS||
2104: ' add '''||l_level||'''');
2105:

Line 2103: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.HierLevelVS||

2099: select '999'||to_char(FEM_DIMENSION_GRPS_B_S.NEXTVAL)
2100: into l_level from dual;
2101: zpb_aw.execute ('mnt '||l_awQual||l_dim_ecm.LevelDim||
2102: ' add '''||l_level||'''');
2103: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.HierLevelVS||
2104: ' add '''||l_level||'''');
2105:
2106: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
2107: ' to '''||l_level||'''');

Line 2106: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||

2102: ' add '''||l_level||'''');
2103: zpb_aw.execute('lmt '||l_awQual||l_dim_ecm.HierLevelVS||
2104: ' add '''||l_level||'''');
2105:
2106: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
2107: ' to '''||l_level||'''');
2108: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');
2109: zpb_aw.execute (l_awQual||l_dim_ecm.LevelLdscVar||' = ''H'||
2110: l_hier||'LV_'||l_level||'''');

Line 2108: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');

2104: ' add '''||l_level||'''');
2105:
2106: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
2107: ' to '''||l_level||'''');
2108: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');
2109: zpb_aw.execute (l_awQual||l_dim_ecm.LevelLdscVar||' = ''H'||
2110: l_hier||'LV_'||l_level||'''');
2111: zpb_aw.execute (l_awQual||l_dim_ecm.LevelDepthVar||' = '||
2112: l_child_depth);

Line 2109: zpb_aw.execute (l_awQual||l_dim_ecm.LevelLdscVar||' = ''H'||

2105:
2106: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||
2107: ' to '''||l_level||'''');
2108: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');
2109: zpb_aw.execute (l_awQual||l_dim_ecm.LevelLdscVar||' = ''H'||
2110: l_hier||'LV_'||l_level||'''');
2111: zpb_aw.execute (l_awQual||l_dim_ecm.LevelDepthVar||' = '||
2112: l_child_depth);
2113: l_view_changed := true;

Line 2111: zpb_aw.execute (l_awQual||l_dim_ecm.LevelDepthVar||' = '||

2107: ' to '''||l_level||'''');
2108: zpb_aw.execute (l_awQual||l_dim_ecm.LevelPersVar||' = YES');
2109: zpb_aw.execute (l_awQual||l_dim_ecm.LevelLdscVar||' = ''H'||
2110: l_hier||'LV_'||l_level||'''');
2111: zpb_aw.execute (l_awQual||l_dim_ecm.LevelDepthVar||' = '||
2112: l_child_depth);
2113: l_view_changed := true;
2114: end if;
2115:

Line 2116: zpb_aw.execute(l_awQual||l_dim_ecm.LevelRel||' = lmt('||

2112: l_child_depth);
2113: l_view_changed := true;
2114: end if;
2115:
2116: zpb_aw.execute(l_awQual||l_dim_ecm.LevelRel||' = lmt('||
2117: l_awQual||l_dim_ecm.LevelDim||' to '||
2118: l_dim_ecm.LevelDepthVar||' eq '||
2119: l_child_depth||')');
2120: end if;

Line 2126: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to all');

2122: --
2123: -- Update FamilyRel:
2124: --
2125: if (l_parent_depth <> l_child_depth) then
2126: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to all');
2127: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2128: l_child||'''');
2129: zpb_aw.execute (l_awQual||l_dim_ecm.AncestorRel||' = '||
2130: l_awQual||l_dim_ecm.AncestorRel||' ('||l_awQual||

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

2123: -- Update FamilyRel:
2124: --
2125: if (l_parent_depth <> l_child_depth) then
2126: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to all');
2127: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2128: l_child||'''');
2129: zpb_aw.execute (l_awQual||l_dim_ecm.AncestorRel||' = '||
2130: l_awQual||l_dim_ecm.AncestorRel||' ('||l_awQual||
2131: l_dim_data.ExpObj||' '''||l_parent||''')');

Line 2129: zpb_aw.execute (l_awQual||l_dim_ecm.AncestorRel||' = '||

2125: if (l_parent_depth <> l_child_depth) then
2126: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LevelDim||' to all');
2127: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2128: l_child||'''');
2129: zpb_aw.execute (l_awQual||l_dim_ecm.AncestorRel||' = '||
2130: l_awQual||l_dim_ecm.AncestorRel||' ('||l_awQual||
2131: l_dim_data.ExpObj||' '''||l_parent||''')');
2132: zpb_aw.execute (l_awQual||l_dim_ecm.AncestorRel||' ('||l_awQual||
2133: l_dim_ecm.LevelDim||' '||l_awQual||

Line 2132: zpb_aw.execute (l_awQual||l_dim_ecm.AncestorRel||' ('||l_awQual||

2128: l_child||'''');
2129: zpb_aw.execute (l_awQual||l_dim_ecm.AncestorRel||' = '||
2130: l_awQual||l_dim_ecm.AncestorRel||' ('||l_awQual||
2131: l_dim_data.ExpObj||' '''||l_parent||''')');
2132: zpb_aw.execute (l_awQual||l_dim_ecm.AncestorRel||' ('||l_awQual||
2133: l_dim_ecm.LevelDim||' '||l_awQual||
2134: l_dim_ecm.LevelRel||') = '''||l_child||'''');
2135: end if;
2136: l_gid_changed := true;

Line 2183: if (zpb_aw.interpbool('shw isvalue('||l_awQual||l_global_ecm.AttrDim||

2179: open l_imp_dim_curs for l_command;
2180: loop
2181: fetch l_imp_dim_curs into l_dim_mbr_id, l_attr_id, l_attr_label;
2182: exit when l_imp_dim_curs%NOTFOUND;
2183: if (zpb_aw.interpbool('shw isvalue('||l_awQual||l_global_ecm.AttrDim||
2184: ' '''||l_epb_dim||'A'||l_attr_id||''') and isvalue('||
2185: l_awQual||l_dim_data.ExpObj||' '''||l_dim_mbr_id||
2186: ''')')) then
2187: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.AttrDim||' to '''||

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

2183: if (zpb_aw.interpbool('shw isvalue('||l_awQual||l_global_ecm.AttrDim||
2184: ' '''||l_epb_dim||'A'||l_attr_id||''') and isvalue('||
2185: l_awQual||l_dim_data.ExpObj||' '''||l_dim_mbr_id||
2186: ''')')) then
2187: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.AttrDim||' to '''||
2188: l_epb_dim||'A'||l_attr_id||'''');
2189: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2190: l_dim_mbr_id||'''');
2191: zpb_aw.execute('&joinchars('''||l_awQual||''' '||l_awQual||

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

2185: l_awQual||l_dim_data.ExpObj||' '''||l_dim_mbr_id||
2186: ''')')) then
2187: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.AttrDim||' to '''||
2188: l_epb_dim||'A'||l_attr_id||'''');
2189: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2190: l_dim_mbr_id||'''');
2191: zpb_aw.execute('&joinchars('''||l_awQual||''' '||l_awQual||
2192: l_attr_ecm.ExpObjVar||') = NA');
2193: if (l_attr_label = 'CAL_PERIOD_END_DATE') then

Line 2191: zpb_aw.execute('&joinchars('''||l_awQual||''' '||l_awQual||

2187: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.AttrDim||' to '''||
2188: l_epb_dim||'A'||l_attr_id||'''');
2189: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2190: l_dim_mbr_id||'''');
2191: zpb_aw.execute('&joinchars('''||l_awQual||''' '||l_awQual||
2192: l_attr_ecm.ExpObjVar||') = NA');
2193: if (l_attr_label = 'CAL_PERIOD_END_DATE') then
2194: zpb_aw.execute (l_awQual||l_dim_time_ecm.EndDateVar||' = NA');
2195: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');

Line 2194: zpb_aw.execute (l_awQual||l_dim_time_ecm.EndDateVar||' = NA');

2190: l_dim_mbr_id||'''');
2191: zpb_aw.execute('&joinchars('''||l_awQual||''' '||l_awQual||
2192: l_attr_ecm.ExpObjVar||') = NA');
2193: if (l_attr_label = 'CAL_PERIOD_END_DATE') then
2194: zpb_aw.execute (l_awQual||l_dim_time_ecm.EndDateVar||' = NA');
2195: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');
2196: elsif (l_attr_label = 'CAL_PERIOD_START_DATE') then
2197: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');
2198: elsif (l_attr_label = 'TIME_AGG_METHOD') then

Line 2195: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');

2191: zpb_aw.execute('&joinchars('''||l_awQual||''' '||l_awQual||
2192: l_attr_ecm.ExpObjVar||') = NA');
2193: if (l_attr_label = 'CAL_PERIOD_END_DATE') then
2194: zpb_aw.execute (l_awQual||l_dim_time_ecm.EndDateVar||' = NA');
2195: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');
2196: elsif (l_attr_label = 'CAL_PERIOD_START_DATE') then
2197: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');
2198: elsif (l_attr_label = 'TIME_AGG_METHOD') then
2199: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to '||

Line 2197: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');

2193: if (l_attr_label = 'CAL_PERIOD_END_DATE') then
2194: zpb_aw.execute (l_awQual||l_dim_time_ecm.EndDateVar||' = NA');
2195: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');
2196: elsif (l_attr_label = 'CAL_PERIOD_START_DATE') then
2197: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');
2198: elsif (l_attr_label = 'TIME_AGG_METHOD') then
2199: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to '||
2200: l_awQual||l_global_ecm.DimTypeRel||' eq ''TIME''');
2201: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLdRel||' = NA');

Line 2199: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to '||

2195: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');
2196: elsif (l_attr_label = 'CAL_PERIOD_START_DATE') then
2197: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');
2198: elsif (l_attr_label = 'TIME_AGG_METHOD') then
2199: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to '||
2200: l_awQual||l_global_ecm.DimTypeRel||' eq ''TIME''');
2201: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLdRel||' = NA');
2202: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to all');
2203: elsif (l_attr_label = 'DEFAULT_AGG_METHOD') then

Line 2201: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLdRel||' = NA');

2197: zpb_aw.execute (l_awQual||l_dim_time_ecm.TimeSpanVar||' = NA');
2198: elsif (l_attr_label = 'TIME_AGG_METHOD') then
2199: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to '||
2200: l_awQual||l_global_ecm.DimTypeRel||' eq ''TIME''');
2201: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLdRel||' = NA');
2202: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to all');
2203: elsif (l_attr_label = 'DEFAULT_AGG_METHOD') then
2204: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLineRel||' = NA');
2205: elsif (l_attr_label = 'DEFAULT_NUMBER_FORMAT') then

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

2198: elsif (l_attr_label = 'TIME_AGG_METHOD') then
2199: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to '||
2200: l_awQual||l_global_ecm.DimTypeRel||' eq ''TIME''');
2201: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLdRel||' = NA');
2202: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to all');
2203: elsif (l_attr_label = 'DEFAULT_AGG_METHOD') then
2204: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLineRel||' = NA');
2205: elsif (l_attr_label = 'DEFAULT_NUMBER_FORMAT') then
2206: zpb_aw.execute (l_awQual||l_dim_ecm.FmtStringVar||' = NA');

Line 2204: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLineRel||' = NA');

2200: l_awQual||l_global_ecm.DimTypeRel||' eq ''TIME''');
2201: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLdRel||' = NA');
2202: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to all');
2203: elsif (l_attr_label = 'DEFAULT_AGG_METHOD') then
2204: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLineRel||' = NA');
2205: elsif (l_attr_label = 'DEFAULT_NUMBER_FORMAT') then
2206: zpb_aw.execute (l_awQual||l_dim_ecm.FmtStringVar||' = NA');
2207: elsif (l_attr_label = 'BETTER_FLAG') then
2208: zpb_aw.execute(l_awQual||l_dim_line_ecm.BetterWorseVar||' = NA');

Line 2206: zpb_aw.execute (l_awQual||l_dim_ecm.FmtStringVar||' = NA');

2202: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to all');
2203: elsif (l_attr_label = 'DEFAULT_AGG_METHOD') then
2204: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLineRel||' = NA');
2205: elsif (l_attr_label = 'DEFAULT_NUMBER_FORMAT') then
2206: zpb_aw.execute (l_awQual||l_dim_ecm.FmtStringVar||' = NA');
2207: elsif (l_attr_label = 'BETTER_FLAG') then
2208: zpb_aw.execute(l_awQual||l_dim_line_ecm.BetterWorseVar||' = NA');
2209: end if;
2210: end if;

Line 2208: zpb_aw.execute(l_awQual||l_dim_line_ecm.BetterWorseVar||' = NA');

2204: zpb_aw.execute (l_awQual||l_dim_line_ecm.AggLineRel||' = NA');
2205: elsif (l_attr_label = 'DEFAULT_NUMBER_FORMAT') then
2206: zpb_aw.execute (l_awQual||l_dim_ecm.FmtStringVar||' = NA');
2207: elsif (l_attr_label = 'BETTER_FLAG') then
2208: zpb_aw.execute(l_awQual||l_dim_line_ecm.BetterWorseVar||' = NA');
2209: end if;
2210: end if;
2211: end loop;
2212: close l_imp_dim_curs;

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

2244: l_attr_num_mbr, l_attr_vs_id, l_attr_var_mbr, l_attr_num_val,
2245: l_attr_var_val, l_attr_dat_val;
2246: exit when l_imp_dim_curs%NOTFOUND;
2247:
2248: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2249: l_dim_mbr_id||'''');
2250:
2251: if (l_attr_label = 'CAL_PERIOD_END_DATE') then
2252: zpb_aw.execute

Line 2252: zpb_aw.execute

2248: zpb_aw.execute ('lmt '||l_awQual||l_dim_data.ExpObj||' to '''||
2249: l_dim_mbr_id||'''');
2250:
2251: if (l_attr_label = 'CAL_PERIOD_END_DATE') then
2252: zpb_aw.execute
2253: (l_awQual||l_dim_time_ecm.EndDateVar||' = to_date('''||
2254: to_char(l_attr_dat_val, 'YYYY/MM/DD')||''', ''YYYY/MM/DD'')');
2255: elsif (l_attr_label = 'CAL_PERIOD_START_DATE') then
2256: --

Line 2260: zpb_aw.execute

2256: --
2257: -- Start date sets the time span variable, since end date has
2258: -- already be evaluated (end date has a lower attribute id)
2259: --
2260: zpb_aw.execute
2261: (l_awQual||l_dim_time_ecm.TimeSpanVar||' = ('||l_awQual||
2262: l_dim_time_ecm.EndDateVar||' - to_date('''||
2263: to_char(l_attr_dat_val, 'YYYY/MM/DD')||
2264: ''',''YYYY/MM/DD'')) * 86400000');

Line 2266: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to '||

2262: l_dim_time_ecm.EndDateVar||' - to_date('''||
2263: to_char(l_attr_dat_val, 'YYYY/MM/DD')||
2264: ''',''YYYY/MM/DD'')) * 86400000');
2265: elsif (l_attr_label = 'TIME_AGG_METHOD') then
2266: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to '||
2267: l_awQual||l_global_ecm.DimTypeRel||' eq ''TIME''');
2268: zpb_aw.execute
2269: (l_awQual||l_dim_line_ecm.AggLdRel||' = DB.CONV.AGGMETH(''_V'||
2270: l_attr_var_mbr||''')');

Line 2268: zpb_aw.execute

2264: ''',''YYYY/MM/DD'')) * 86400000');
2265: elsif (l_attr_label = 'TIME_AGG_METHOD') then
2266: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to '||
2267: l_awQual||l_global_ecm.DimTypeRel||' eq ''TIME''');
2268: zpb_aw.execute
2269: (l_awQual||l_dim_line_ecm.AggLdRel||' = DB.CONV.AGGMETH(''_V'||
2270: l_attr_var_mbr||''')');
2271: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to all');
2272: elsif (l_attr_label = 'DEFAULT_AGG_METHOD') then

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

2267: l_awQual||l_global_ecm.DimTypeRel||' eq ''TIME''');
2268: zpb_aw.execute
2269: (l_awQual||l_dim_line_ecm.AggLdRel||' = DB.CONV.AGGMETH(''_V'||
2270: l_attr_var_mbr||''')');
2271: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to all');
2272: elsif (l_attr_label = 'DEFAULT_AGG_METHOD') then
2273: zpb_aw.execute
2274: (l_awQual||l_dim_line_ecm.AggLineRel||
2275: ' = DB.CONV.AGGMETH(''_V'||l_attr_var_mbr||''')');

Line 2273: zpb_aw.execute

2269: (l_awQual||l_dim_line_ecm.AggLdRel||' = DB.CONV.AGGMETH(''_V'||
2270: l_attr_var_mbr||''')');
2271: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.DimDim||' to all');
2272: elsif (l_attr_label = 'DEFAULT_AGG_METHOD') then
2273: zpb_aw.execute
2274: (l_awQual||l_dim_line_ecm.AggLineRel||
2275: ' = DB.CONV.AGGMETH(''_V'||l_attr_var_mbr||''')');
2276: elsif (l_attr_label = 'DEFAULT_NUMBER_FORMAT') then
2277: zpb_aw.execute

Line 2277: zpb_aw.execute

2273: zpb_aw.execute
2274: (l_awQual||l_dim_line_ecm.AggLineRel||
2275: ' = DB.CONV.AGGMETH(''_V'||l_attr_var_mbr||''')');
2276: elsif (l_attr_label = 'DEFAULT_NUMBER_FORMAT') then
2277: zpb_aw.execute
2278: (l_awQual||l_dim_ecm.FmtStringVar||' = '''||
2279: l_attr_var_val||'''');
2280: elsif (l_attr_label = 'BETTER_FLAG') then
2281: zpb_aw.execute

Line 2281: zpb_aw.execute

2277: zpb_aw.execute
2278: (l_awQual||l_dim_ecm.FmtStringVar||' = '''||
2279: l_attr_var_val||'''');
2280: elsif (l_attr_label = 'BETTER_FLAG') then
2281: zpb_aw.execute
2282: (l_awQual||l_dim_line_ecm.BetterWorseVar||' = if '''||
2283: l_attr_var_mbr||''' eq ''Y'' then 1 else if '''||
2284: l_attr_var_mbr||''' eq ''N'' then -1 else NA');
2285: else

Line 2299: zpb_aw.execute

2295: where A.ATTRIBUTE_ID = B.ATTRIBUTE_ID
2296: and B.ATTRIBUTE_VARCHAR_LABEL = 'BASIC_ACCOUNT_TYPE_CODE'
2297: and A.EXT_ACCOUNT_TYPE_CODE = l_attr_var_mbr
2298: and A.AW_SNAPSHOT_FLAG = 'N';
2299: zpb_aw.execute
2300: (l_awQual||l_dim_line_ecm.LineTypeRel||' = if '''||
2301: l_attr_var_mbr||''' eq ''EQUITY'' then ''OWNERS.EQUITY'' '||
2302: 'else '''||l_attr_var_mbr||'''');
2303: end if;

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

2300: (l_awQual||l_dim_line_ecm.LineTypeRel||' = if '''||
2301: l_attr_var_mbr||''' eq ''EQUITY'' then ''OWNERS.EQUITY'' '||
2302: 'else '''||l_attr_var_mbr||'''');
2303: end if;
2304: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.AttrDim||' to '''||
2305: l_epb_dim||'A'||l_attr_id||'''');
2306: l_dim_attr_ecm := ZPB_ECM.GET_ATTR_ECM(l_epb_dim||'A'||l_attr_id,
2307: l_attr_ecm, l_aw);
2308:

Line 2309: l_attr_abbrev := zpb_aw.interp

2305: l_epb_dim||'A'||l_attr_id||'''');
2306: l_dim_attr_ecm := ZPB_ECM.GET_ATTR_ECM(l_epb_dim||'A'||l_attr_id,
2307: l_attr_ecm, l_aw);
2308:
2309: l_attr_abbrev := zpb_aw.interp
2310: ('shw '||l_awQual||l_attr_ecm.NameFragVar);
2311:
2312: if (l_attr_abbrev <> 'NA') then
2313: l_attr_val := l_attr_abbrev||'.A'||l_attr_id||'_V'||

Line 2322: l_value := l_awQual||zpb_aw.interp('shw '||l_awQual||

2318: --
2319: -- Add the new attribute to the personal as a personal member
2320: -- This should only happen in data/varchar/num attribute types
2321: --
2322: l_value := l_awQual||zpb_aw.interp('shw '||l_awQual||
2323: l_attr_ecm.RangeDimRel);
2324: if (not zpb_aw.interpbool('shw isvalue('||l_value||' '''||
2325: l_attr_val||''')')) then
2326: zpb_aw.execute ('mnt '||l_value||

Line 2324: if (not zpb_aw.interpbool('shw isvalue('||l_value||' '''||

2320: -- This should only happen in data/varchar/num attribute types
2321: --
2322: l_value := l_awQual||zpb_aw.interp('shw '||l_awQual||
2323: l_attr_ecm.RangeDimRel);
2324: if (not zpb_aw.interpbool('shw isvalue('||l_value||' '''||
2325: l_attr_val||''')')) then
2326: zpb_aw.execute ('mnt '||l_value||
2327: ' merge '''||l_attr_val||'''');
2328: zpb_aw.execute ('lmt '||l_value||' to '''||l_attr_val||'''');

Line 2326: zpb_aw.execute ('mnt '||l_value||

2322: l_value := l_awQual||zpb_aw.interp('shw '||l_awQual||
2323: l_attr_ecm.RangeDimRel);
2324: if (not zpb_aw.interpbool('shw isvalue('||l_value||' '''||
2325: l_attr_val||''')')) then
2326: zpb_aw.execute ('mnt '||l_value||
2327: ' merge '''||l_attr_val||'''');
2328: zpb_aw.execute ('lmt '||l_value||' to '''||l_attr_val||'''');
2329: if (l_attr_num_val is not null or l_attr_var_val is not null
2330: or l_attr_dat_val is not null) then

Line 2328: zpb_aw.execute ('lmt '||l_value||' to '''||l_attr_val||'''');

2324: if (not zpb_aw.interpbool('shw isvalue('||l_value||' '''||
2325: l_attr_val||''')')) then
2326: zpb_aw.execute ('mnt '||l_value||
2327: ' merge '''||l_attr_val||'''');
2328: zpb_aw.execute ('lmt '||l_value||' to '''||l_attr_val||'''');
2329: if (l_attr_num_val is not null or l_attr_var_val is not null
2330: or l_attr_dat_val is not null) then
2331: zpb_aw.execute(l_awQual||l_dim_attr_ecm.ldscvar||' = '''||
2332: nvl(to_char(l_attr_num_val),

Line 2331: zpb_aw.execute(l_awQual||l_dim_attr_ecm.ldscvar||' = '''||

2327: ' merge '''||l_attr_val||'''');
2328: zpb_aw.execute ('lmt '||l_value||' to '''||l_attr_val||'''');
2329: if (l_attr_num_val is not null or l_attr_var_val is not null
2330: or l_attr_dat_val is not null) then
2331: zpb_aw.execute(l_awQual||l_dim_attr_ecm.ldscvar||' = '''||
2332: nvl(to_char(l_attr_num_val),
2333: nvl(l_attr_var_val,
2334: to_char(l_attr_dat_val)))||'''');
2335: end if;

Line 2336: zpb_aw.execute ('&joinchars('''||l_awQual||''' obj (property'

2332: nvl(to_char(l_attr_num_val),
2333: nvl(l_attr_var_val,
2334: to_char(l_attr_dat_val)))||'''');
2335: end if;
2336: zpb_aw.execute ('&joinchars('''||l_awQual||''' obj (property'
2337: ||' ''MEMBERTYPEREL'' '''||l_value||
2338: ''')) = ''PERSONAL''');
2339: end if;
2340: zpb_aw.execute('&joinchars('''||l_awQual||''' '||l_awQual||

Line 2340: zpb_aw.execute('&joinchars('''||l_awQual||''' '||l_awQual||

2336: zpb_aw.execute ('&joinchars('''||l_awQual||''' obj (property'
2337: ||' ''MEMBERTYPEREL'' '''||l_value||
2338: ''')) = ''PERSONAL''');
2339: end if;
2340: zpb_aw.execute('&joinchars('''||l_awQual||''' '||l_awQual||
2341: l_attr_ecm.ExpObjVar||') = '''||l_attr_val||'''');
2342: end if;
2343: end if;
2344: end loop;

Line 2351: zpb_aw.execute('call PA.SET.ORDER('''||zpb_aw.get_schema||'.'||

2347:
2348: --
2349: -- Fix the order structures:
2350: --
2351: zpb_aw.execute('call PA.SET.ORDER('''||zpb_aw.get_schema||'.'||
2352: l_aw||''' '''||l_dim_data.ExpObj||''')');
2353:
2354: --
2355: -- If GID changed, update GID and Hierheight structures

Line 2358: zpb_aw.execute('call DB.SET.GID('''||zpb_aw.get_schema||'.'||l_aw||

2354: --
2355: -- If GID changed, update GID and Hierheight structures
2356: --
2357: if (l_gid_changed) then
2358: zpb_aw.execute('call DB.SET.GID('''||zpb_aw.get_schema||'.'||l_aw||
2359: ''' '''||l_dim_data.ExpObj||''')');
2360: end if;
2361:
2362: --

Line 2367: zpb_aw.execute ('call DB.BUILD.LMAP('''||zpb_aw.get_schema||'.'||l_aw||

2363: -- If levels changed, then we need to update the dim hierarchy table
2364: --
2365: if (l_view_changed) then
2366: ZPB_OLAP_VIEWS_PKG.CREATE_DIMENSION_VIEWS(l_aw, 'PERSONAL', l_epb_dim);
2367: zpb_aw.execute ('call DB.BUILD.LMAP('''||zpb_aw.get_schema||'.'||l_aw||
2368: ''' '''||l_epb_dim||''')');
2369:
2370: -- create MD for personal hierarchy table
2371: zpb_metadata_pkg.build_dims(l_aw,

Line 2372: zpb_aw.get_schema||'.'||l_shrdAw,

2368: ''' '''||l_epb_dim||''')');
2369:
2370: -- create MD for personal hierarchy table
2371: zpb_metadata_pkg.build_dims(l_aw,
2372: zpb_aw.get_schema||'.'||l_shrdAw,
2373: 'PERSONAL',
2374: l_epb_dim);
2375:
2376: -- add scoping to newly created hierarchy and levels

Line 2378: zpb_aw.get_schema||'.'||l_shrdAw,

2374: l_epb_dim);
2375:
2376: -- add scoping to newly created hierarchy and levels
2377: zpb_metadata_pkg.build_personal_dims(l_aw,
2378: zpb_aw.get_schema||'.'||l_shrdAw,
2379: 'PERSONAL',
2380: l_epb_dim);
2381: end if;
2382:

Line 2383: zpb_aw.execute ('pop oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||

2379: 'PERSONAL',
2380: l_epb_dim);
2381: end if;
2382:
2383: zpb_aw.execute ('pop oknullstatus '||l_awQual||l_dim_data.ExpObj||' '||
2384: l_awQual||l_global_ecm.LangDim||' '||l_awQual||
2385: l_dim_ecm.LevelDim);
2386:
2387: if (FND_API.TO_BOOLEAN (p_commit)) then

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

2384: l_awQual||l_global_ecm.LangDim||' '||l_awQual||
2385: l_dim_ecm.LevelDim);
2386:
2387: if (FND_API.TO_BOOLEAN (p_commit)) then
2388: zpb_aw.execute ('upd');
2389: commit work;
2390: end if;
2391:
2392: FND_MSG_PUB.COUNT_AND_GET