DBA Data[Home] [Help]

APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_DATASETS_ATTR

Line 2036: ' FROM fem_datasets_attr A,fem_dim_attr_versions_b V'||

2032: AND attribute_varchar_label = 'DATASET_BALANCE_TYPE_CODE';
2033:
2034: v_sql_cmd :=
2035: 'SELECT '||v_bal_type_col||
2036: ' FROM fem_datasets_attr A,fem_dim_attr_versions_b V'||
2037: ' WHERE dataset_code = :b_dataset_cd'||
2038: ' AND A.attribute_id = '||
2039: ' (SELECT attribute_id'||
2040: ' FROM fem_dim_attributes_b'||

Line 4208: INSERT INTO fem_datasets_attr(

4204: END;
4205: v_attr_num := '';
4206: END IF;
4207:
4208: INSERT INTO fem_datasets_attr(
4209: attribute_id,
4210: version_id,
4211: dataset_code,
4212: dim_attribute_numeric_member,

Line 4246: INSERT INTO fem_datasets_attr(

4242: THEN
4243: ----------------------------------------
4244: -- Attribute is an assigned number value
4245: ----------------------------------------
4246: INSERT INTO fem_datasets_attr(
4247: attribute_id,
4248: version_id,
4249: dataset_code,
4250: dim_attribute_numeric_member,

Line 4284: INSERT INTO fem_datasets_attr(

4280: THEN
4281: -----------------------------------------
4282: -- Attribute is an assigned varchar value
4283: -----------------------------------------
4284: INSERT INTO fem_datasets_attr(
4285: attribute_id,
4286: version_id,
4287: dataset_code,
4288: dim_attribute_numeric_member,

Line 4322: INSERT INTO fem_datasets_attr(

4318: THEN
4319: --------------------------------------
4320: -- Attribute is an assigned date value
4321: --------------------------------------
4322: INSERT INTO fem_datasets_attr(
4323: attribute_id,
4324: version_id,
4325: dataset_code,
4326: dim_attribute_numeric_member,

Line 4679: INSERT INTO fem_datasets_attr(

4675: END;
4676: v_attr_num := '';
4677: END IF;
4678:
4679: INSERT INTO fem_datasets_attr(
4680: attribute_id,
4681: version_id,
4682: dataset_code,
4683: dim_attribute_numeric_member,

Line 4717: INSERT INTO fem_datasets_attr(

4713: THEN
4714: ----------------------------------------
4715: -- Attribute is an assigned number value
4716: ----------------------------------------
4717: INSERT INTO fem_datasets_attr(
4718: attribute_id,
4719: version_id,
4720: dataset_code,
4721: dim_attribute_numeric_member,

Line 4755: INSERT INTO fem_datasets_attr(

4751: THEN
4752: -----------------------------------------
4753: -- Attribute is an assigned varchar value
4754: -----------------------------------------
4755: INSERT INTO fem_datasets_attr(
4756: attribute_id,
4757: version_id,
4758: dataset_code,
4759: dim_attribute_numeric_member,

Line 4793: INSERT INTO fem_datasets_attr(

4789: THEN
4790: -----------------------------------------
4791: -- Attribute is an assigned date value
4792: -----------------------------------------
4793: INSERT INTO fem_datasets_attr(
4794: attribute_id,
4795: version_id,
4796: dataset_code,
4797: dim_attribute_numeric_member,