DBA Data[Home] [Help]

APPS.FEM_SOURCE_DATA_LOADER_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 106: l_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

102: l_cal_period_id NUMBER;
103: l_dataset_code NUMBER;
104: l_source_system_code NUMBER;
105:
106: l_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
107: l_table_name FEM_TABLE_CLASS_ASSIGNMT_V.table_name%TYPE;
108: l_ledger_dc FEM_LEDGERS_B.ledger_display_code%TYPE;
109: l_calp_dim_grp_dc FEM_DIMENSION_GRPS_B.dimension_group_display_code%TYPE;
110: l_cal_per_end_date FEM_CAL_PERIODS_ATTR.date_assign_value%TYPE;

Line 3325: FROM fem_object_definition_b od, fem_object_catalog_b o,

3321: -- --------------------------------------------------------------------
3322: BEGIN
3323: SELECT o.object_id, t.table_name
3324: INTO x_object_id, x_table_name
3325: FROM fem_object_definition_b od, fem_object_catalog_b o,
3326: fem_user_folders f, fem_data_loader_objects d,
3327: fem_table_class_assignmt_v t
3328: WHERE od.object_definition_id = p_obj_def_id
3329: AND od.object_id = o.object_id

Line 3367: FROM fem_object_catalog_b

3363:
3364: BEGIN
3365: SELECT object_type_code
3366: INTO l_object_type_code
3367: FROM fem_object_catalog_b
3368: WHERE object_id = x_object_id
3369: AND object_type_code = p_object_type;
3370:
3371: EXCEPTION