APPS.FEM_REFRESH_UTIL_PKG dependencies on FEM_DIM_ATTRIBUTES_PRIV

Line 193: delete from fem_dim_attributes_priv

189: and D1.dimension_varchar_label = 'CALENDAR'
190: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
191: ));
192:
193: delete from fem_dim_attributes_priv
194: where attribute_id in (select attribute_id
195: from fem_dim_attributes_b A1, fem_dimensions_b D1
196: where A1.dimension_id = D1.dimension_id
197: and D1.dimension_varchar_label = 'CALENDAR'

Line 248: delete from fem_dim_attributes_priv

244: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
245: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
246: ,'DIVISIBLE_FLAG'));
247:
248: delete from fem_dim_attributes_priv
249: where attribute_id in (select attribute_id
250: from fem_dim_attributes_b A1, fem_dimensions_b D1
251: where A1.dimension_id = D1.dimension_id
252: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'

Line 332: delete from fem_dim_attributes_priv

328: ,'ACTIVATION_FLAG'
329: ,'OFFSET_CCTR_ORG'
330: ));
331:
332: delete from fem_dim_attributes_priv
333: where attribute_id in (select attribute_id
334: from fem_dim_attributes_b A1, fem_dimensions_b D1
335: where A1.dimension_id = D1.dimension_id
336: and D1.dimension_varchar_label = 'LINE_ITEM'

Line 406: delete from fem_dim_attributes_priv

402: where A1.dimension_id = D1.dimension_id
403: and D1.dimension_varchar_label = 'PRODUCT'
404: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
405:
406: delete from fem_dim_attributes_priv
407: where attribute_id in (select attribute_id
408: from fem_dim_attributes_b A1, fem_dimensions_b D1
409: where A1.dimension_id = D1.dimension_id
410: and D1.dimension_varchar_label = 'PRODUCT'

Line 462: delete from fem_dim_attributes_priv

458: where A1.dimension_id = D1.dimension_id
459: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
460: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
461:
462: delete from fem_dim_attributes_priv
463: where attribute_id in (select attribute_id
464: from fem_dim_attributes_b A1, fem_dimensions_b D1
465: where A1.dimension_id = D1.dimension_id
466: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'

Line 516: delete from fem_dim_attributes_priv

512: where A1.dimension_id = D1.dimension_id
513: and D1.dimension_varchar_label = 'LEDGER'
514: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
515:
516: delete from fem_dim_attributes_priv
517: where attribute_id in (select attribute_id
518: from fem_dim_attributes_b A1, fem_dimensions_b D1
519: where A1.dimension_id = D1.dimension_id
520: and D1.dimension_varchar_label = 'LEDGER'

Line 632: delete from fem_dim_attributes_priv

628:
629: delete from fem_dim_attr_grps
630: where attribute_id=attr.attribute_id;
631:
632: delete from fem_dim_attributes_priv
633: where attribute_id = attr.attribute_id;
634:
635: end loop;
636:

Line 664: delete from fem_dim_attributes_priv

660:
661: delete from fem_dim_attr_grps
662: where attribute_id=attr.attribute_id;
663:
664: delete from fem_dim_attributes_priv
665: where attribute_id = attr.attribute_id;
666:
667: end loop;
668:

Line 696: delete from fem_dim_attributes_priv

692:
693: delete from fem_dim_attr_grps
694: where attribute_id=attr.attribute_id;
695:
696: delete from fem_dim_attributes_priv
697: where attribute_id = attr.attribute_id;
698:
699: end loop;
700:

Line 728: delete from fem_dim_attributes_priv

724:
725: delete from fem_dim_attr_grps
726: where attribute_id=attr.attribute_id;
727:
728: delete from fem_dim_attributes_priv
729: where attribute_id = attr.attribute_id;
730:
731: end loop;
732:

Line 760: delete from fem_dim_attributes_priv

756:
757: delete from fem_dim_attr_grps
758: where attribute_id=attr.attribute_id;
759:
760: delete from fem_dim_attributes_priv
761: where attribute_id = attr.attribute_id;
762:
763: end loop;
764: