APPS.ZPB_DHMINTERFACE_GRP dependencies on FEM_DIM_ATTRIBUTES_PRIV

Line 272: delete from FEM_DIM_ATTRIBUTES_PRIV where USER_ID = l_apps_id;

268: -- DO SOMETHING!
269: --
270: end if;
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

Line 420: insert into FEM_DIM_ATTRIBUTES_PRIV

416: into l_attr_dim_id
417: from fem_dim_attributes_b
418: where attribute_id = l_fem_attr;
419:
420: insert into FEM_DIM_ATTRIBUTES_PRIV
421: (USER_ID,
422: ATTRIBUTE_ID,
423: DIMENSION_ID,
424: CREATION_DATE,

Line 492: from FEM_DIM_ATTRIBUTES_PRIV

488: end if;
489:
490: select count(*)
491: into i
492: from FEM_DIM_ATTRIBUTES_PRIV
493: where USER_ID = l_apps_id
494: and ATTRIBUTE_ID = each.ATTRIBUTE_ID;
495:
496: if (i = 0) then

Line 497: insert into FEM_DIM_ATTRIBUTES_PRIV

493: where USER_ID = l_apps_id
494: and ATTRIBUTE_ID = each.ATTRIBUTE_ID;
495:
496: if (i = 0) then
497: insert into FEM_DIM_ATTRIBUTES_PRIV
498: (USER_ID,
499: ATTRIBUTE_ID,
500: DIMENSION_ID,
501: CREATION_DATE,

Line 522: from FEM_DIM_ATTRIBUTES_PRIV

518: for each in l_epb_time_attrs loop
519:
520: select count(*)
521: into i
522: from FEM_DIM_ATTRIBUTES_PRIV
523: where USER_ID = l_apps_id
524: and ATTRIBUTE_ID = each.ATTRIBUTE_ID;
525:
526: if (i = 0) then

Line 527: insert into FEM_DIM_ATTRIBUTES_PRIV

523: where USER_ID = l_apps_id
524: and ATTRIBUTE_ID = each.ATTRIBUTE_ID;
525:
526: if (i = 0) then
527: insert into FEM_DIM_ATTRIBUTES_PRIV
528: (USER_ID,
529: ATTRIBUTE_ID,
530: DIMENSION_ID,
531: CREATION_DATE,