APPS.ZPB_DHMINTERFACE_GRP dependencies on DUAL

Line 631: select to_char(FEM_OBJECT_ID_SEQ.nextVal) into l_femHier from dual;

627: if (upper(l_femHier) = 'NA') then
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:

Line 644: into l_femHierDef from dual;

640: --
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:

Line 1303: l_time_dim_grp_key from dual;

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:
1306: FEM_DIMENSION_GRPS_PKG.INSERT_ROW
1307: (l_value,

Line 2100: into l_level from dual;

2096: --
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||'''');