APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_DATASETS_ATTR

Line 1940: FROM fem_datasets_attr

1936: END IF;
1937:
1938: SELECT dim_attribute_varchar_member
1939: INTO pv_ds_balance_type_cd
1940: FROM fem_datasets_attr
1941: WHERE attribute_id = pv_dim_attr_id
1942: AND version_id = pv_dim_attr_ver_id
1943: AND dataset_code = pv_dataset_code;
1944:

Line 2003: FROM fem_datasets_attr

1999: END IF;
2000:
2001: SELECT dim_attribute_numeric_member
2002: INTO pv_budget_id
2003: FROM fem_datasets_attr
2004: WHERE attribute_id = pv_dim_attr_id
2005: AND version_id = pv_dim_attr_ver_id
2006: AND dataset_code = pv_dataset_code;
2007:

Line 2111: FROM fem_datasets_attr

2107: END IF;
2108:
2109: SELECT dim_attribute_numeric_member
2110: INTO pv_enc_type_id
2111: FROM fem_datasets_attr
2112: WHERE attribute_id = pv_dim_attr_id
2113: AND version_id = pv_dim_attr_ver_id
2114: AND dataset_code = pv_dataset_code;
2115:

Line 2463: v_ds_budget_id fem_datasets_attr.dim_attribute_numeric_member%TYPE;

2459: -- Notes
2460: -- Called by Validate_Engine_Parameters
2461: -- =======================================================================
2462:
2463: v_ds_budget_id fem_datasets_attr.dim_attribute_numeric_member%TYPE;
2464: v_budget_ledger fem_budgets_attr.dim_attribute_numeric_member%TYPE;
2465:
2466: BEGIN
2467:

Line 2535: FROM fem_datasets_attr

2531: END IF;
2532:
2533: SELECT dim_attribute_numeric_member
2534: INTO v_ds_budget_id
2535: FROM fem_datasets_attr
2536: WHERE attribute_id = pv_dim_attr_id
2537: AND version_id = pv_dim_attr_ver_id
2538: AND dataset_code = pv_dataset_code;
2539:

Line 2888: FROM fem_datasets_attr

2884: END IF;
2885:
2886: SELECT dim_attribute_varchar_member
2887: INTO pv_ds_balance_type_cd
2888: FROM fem_datasets_attr
2889: WHERE attribute_id = pv_dim_attr_id
2890: AND version_id = pv_dim_attr_ver_id
2891: AND dataset_code = pv_dataset_code;
2892:

Line 2982: FROM fem_datasets_attr

2978: AND o.object_id = x.object_id
2979: AND o.object_type_code = 'XGL_INTEGRATION'
2980: AND 'ACTUAL' =
2981: (SELECT DIM_ATTRIBUTE_VARCHAR_MEMBER
2982: FROM fem_datasets_attr
2983: WHERE dataset_code = r.output_dataset_code
2984: AND (attribute_id, version_id) =
2985: (SELECT a.attribute_id, v.version_id
2986: FROM fem_dim_attributes_b a,

Line 3009: FROM fem_datasets_attr

3005: AND o.object_id = x.object_id
3006: AND o.object_type_code = 'XGL_INTEGRATION'
3007: AND pv_budget_id =
3008: (SELECT DIM_ATTRIBUTE_NUMERIC_MEMBER
3009: FROM fem_datasets_attr
3010: WHERE dataset_code = r.output_dataset_code
3011: AND (attribute_id, version_id) =
3012: (SELECT a.attribute_id, v.version_id
3013: FROM fem_dim_attributes_b a,

Line 3036: FROM fem_datasets_attr

3032: AND o.object_id = x.object_id
3033: AND o.object_type_code = 'XGL_INTEGRATION'
3034: AND pv_enc_type_id =
3035: (SELECT DIM_ATTRIBUTE_NUMERIC_MEMBER
3036: FROM fem_datasets_attr
3037: WHERE dataset_code = r.output_dataset_code
3038: AND (attribute_id, version_id) =
3039: (SELECT a.attribute_id, v.version_id
3040: FROM fem_dim_attributes_b a,

Line 3098: v_ds_enc_type_id fem_datasets_attr.dim_attribute_numeric_member%TYPE;

3094: -- Notes
3095: -- Called by Validate_Engine_Parameters
3096: -- =======================================================================
3097:
3098: v_ds_enc_type_id fem_datasets_attr.dim_attribute_numeric_member%TYPE;
3099:
3100: BEGIN
3101:
3102: FEM_ENGINES_PKG.Tech_Message

Line 3171: FROM fem_datasets_attr

3167: END IF;
3168:
3169: SELECT dim_attribute_numeric_member
3170: INTO v_ds_enc_type_id
3171: FROM fem_datasets_attr
3172: WHERE attribute_id = pv_dim_attr_id
3173: AND version_id = pv_dim_attr_ver_id
3174: AND dataset_code = pv_dataset_code;
3175:

Line 3617: v_ds_production_flag fem_datasets_attr.dim_attribute_varchar_member%TYPE;

3613: -- =======================================================================
3614:
3615: v_obj_approval_status_cd fem_object_definition_b.approval_status_code%TYPE;
3616: v_folder_id fem_object_catalog_b.folder_id%TYPE;
3617: v_ds_production_flag fem_datasets_attr.dim_attribute_varchar_member%TYPE;
3618: v_rowcount PLS_INTEGER;
3619:
3620: BEGIN
3621:

Line 3760: FROM fem_datasets_attr

3756: END IF;
3757:
3758: SELECT dim_attribute_varchar_member
3759: INTO v_ds_production_flag
3760: FROM fem_datasets_attr
3761: WHERE attribute_id = pv_dim_attr_id
3762: AND version_id = pv_dim_attr_ver_id
3763: AND dataset_code = pv_dataset_code;
3764: