DBA Data[Home] [Help]

APPS.FEM_REFRESH_UTIL_PKG dependencies on FEM_DIM_ATTRIBUTES_TL

Line 185: delete from fem_dim_attributes_tl

181: and D1.dimension_varchar_label = 'CALENDAR'
182: and A1.attribute_varchar_label in ('DEFAULT_CAL_PERIOD'
183: ));
184:
185: delete from fem_dim_attributes_tl
186: where attribute_id in (select attribute_id
187: from fem_dim_attributes_b A1, fem_dimensions_b D1
188: where A1.dimension_id = D1.dimension_id
189: and D1.dimension_varchar_label = 'CALENDAR'

Line 240: delete from fem_dim_attributes_tl

236: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'
237: and A1.attribute_varchar_label in ('FE_DATA_GROUPING_CODE'
238: ,'DIVISIBLE_FLAG'));
239:
240: delete from fem_dim_attributes_tl
241: where attribute_id in (select attribute_id
242: from fem_dim_attributes_b A1, fem_dimensions_b D1
243: where A1.dimension_id = D1.dimension_id
244: and D1.dimension_varchar_label = 'FINANCIAL_ELEMENT'

Line 319: delete from fem_dim_attributes_tl

315: ,'ACTIVATION_FLAG'
316: ,'OFFSET_CCTR_ORG'
317: ));
318:
319: delete from fem_dim_attributes_tl
320: where attribute_id in (select attribute_id
321: from fem_dim_attributes_b A1, fem_dimensions_b D1
322: where A1.dimension_id = D1.dimension_id
323: and D1.dimension_varchar_label = 'LINE_ITEM'

Line 399: delete from fem_dim_attributes_tl

395: where A1.dimension_id = D1.dimension_id
396: and D1.dimension_varchar_label = 'PRODUCT'
397: and A1.attribute_varchar_label in ('HIDDEN_FLAG'));
398:
399: delete from fem_dim_attributes_tl
400: where attribute_id in (select attribute_id
401: from fem_dim_attributes_b A1, fem_dimensions_b D1
402: where A1.dimension_id = D1.dimension_id
403: and D1.dimension_varchar_label = 'PRODUCT'

Line 455: delete from fem_dim_attributes_tl

451: where A1.dimension_id = D1.dimension_id
452: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'
453: and A1.attribute_varchar_label in ('HIDDEN_FLAG','ACTIVATION_FLAG'));
454:
455: delete from fem_dim_attributes_tl
456: where attribute_id in (select attribute_id
457: from fem_dim_attributes_b A1, fem_dimensions_b D1
458: where A1.dimension_id = D1.dimension_id
459: and D1.dimension_varchar_label = 'NATURAL_ACCOUNT'

Line 509: delete from fem_dim_attributes_tl

505: where A1.dimension_id = D1.dimension_id
506: and D1.dimension_varchar_label = 'LEDGER'
507: and A1.attribute_varchar_label in ('EPB_DEFAULT_LEDGER_FLAG'));
508:
509: delete from fem_dim_attributes_tl
510: where attribute_id in (select attribute_id
511: from fem_dim_attributes_b A1, fem_dimensions_b D1
512: where A1.dimension_id = D1.dimension_id
513: and D1.dimension_varchar_label = 'LEDGER'

Line 623: delete from fem_dim_attributes_tl

619:
620: delete from fem_dim_attr_versions_b
621: where attribute_id = attr.attribute_id;
622:
623: delete from fem_dim_attributes_tl
624: where attribute_id = attr.attribute_id;
625:
626: delete from fem_dim_attributes_b
627: where attribute_id = attr.attribute_id;

Line 655: delete from fem_dim_attributes_tl

651:
652: delete from fem_dim_attr_versions_b
653: where attribute_id = attr.attribute_id;
654:
655: delete from fem_dim_attributes_tl
656: where attribute_id = attr.attribute_id;
657:
658: delete from fem_dim_attributes_b
659: where attribute_id = attr.attribute_id;

Line 687: delete from fem_dim_attributes_tl

683:
684: delete from fem_dim_attr_versions_b
685: where attribute_id = attr.attribute_id;
686:
687: delete from fem_dim_attributes_tl
688: where attribute_id = attr.attribute_id;
689:
690: delete from fem_dim_attributes_b
691: where attribute_id = attr.attribute_id;

Line 719: delete from fem_dim_attributes_tl

715:
716: delete from fem_dim_attr_versions_b
717: where attribute_id = attr.attribute_id;
718:
719: delete from fem_dim_attributes_tl
720: where attribute_id = attr.attribute_id;
721:
722: delete from fem_dim_attributes_b
723: where attribute_id = attr.attribute_id;

Line 751: delete from fem_dim_attributes_tl

747:
748: delete from fem_dim_attr_versions_b
749: where attribute_id = attr.attribute_id;
750:
751: delete from fem_dim_attributes_tl
752: where attribute_id = attr.attribute_id;
753:
754: delete from fem_dim_attributes_b
755: where attribute_id = attr.attribute_id;