APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 26: pv_obj_type_cd fem_object_catalog_b.object_type_code%TYPE;

22: pv_dim_attr_ver_id fem_dim_attr_versions_b.version_id%TYPE;
23: pv_attr_label fem_dim_attributes_b.attribute_varchar_label%TYPE;
24: pv_dim_name fem_dimensions_tl.dimension_name%TYPE;
25:
26: pv_obj_type_cd fem_object_catalog_b.object_type_code%TYPE;
27: pv_cal_per_calendar_id fem_cal_periods_b.calendar_id%TYPE;
28: pv_ledger_calendar_id fem_hierarchies.calendar_id%TYPE;
29: pv_precedent_dataset_code fem_datasets_b.dataset_code%TYPE;
30:

Line 2971: fem_object_catalog_b o

2967: SELECT MAX(r.output_dataset_code)
2968: INTO pv_precedent_dataset_code
2969: FROM fem_pl_requests r,
2970: fem_pl_object_executions x,
2971: fem_object_catalog_b o
2972: WHERE r.ledger_id = pv_ledger_id
2973: AND r.cal_period_id = pv_cal_period_id
2974: AND r.output_dataset_code <> pv_dataset_code
2975: AND r.exec_mode_code = 'S'

Line 2998: fem_object_catalog_b o

2994: SELECT MAX(r.output_dataset_code)
2995: INTO pv_precedent_dataset_code
2996: FROM fem_pl_requests r,
2997: fem_pl_object_executions x,
2998: fem_object_catalog_b o
2999: WHERE r.ledger_id = pv_ledger_id
3000: AND r.cal_period_id = pv_cal_period_id
3001: AND r.output_dataset_code <> pv_dataset_code
3002: AND r.exec_mode_code = 'S'

Line 3025: fem_object_catalog_b o

3021: SELECT MAX(r.output_dataset_code)
3022: INTO pv_precedent_dataset_code
3023: FROM fem_pl_requests r,
3024: fem_pl_object_executions x,
3025: fem_object_catalog_b o
3026: WHERE r.ledger_id = pv_ledger_id
3027: AND r.cal_period_id = pv_cal_period_id
3028: AND r.output_dataset_code <> pv_dataset_code
3029: AND r.exec_mode_code = 'S'

Line 3616: v_folder_id fem_object_catalog_b.folder_id%TYPE;

3612: -- Called by Validate_Engine_Parameters
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

Line 3683: FROM fem_object_catalog_b

3679: BEGIN
3680:
3681: SELECT object_type_code, folder_id
3682: INTO pv_obj_type_cd, v_folder_id
3683: FROM fem_object_catalog_b
3684: WHERE object_id = pv_rule_obj_id;
3685:
3686: FEM_ENGINES_PKG.Tech_Message
3687: (p_severity => pc_log_level_statement,