DBA Data[Home] [Help]

APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 3392: FROM fem_object_definition_b

3388: p_value2 => pv_ledger_per_hier_obj_def_id);
3389:
3390: SELECT object_id
3391: INTO pv_ledger_per_hier_obj_id
3392: FROM fem_object_definition_b
3393: WHERE object_definition_id = pv_ledger_per_hier_obj_def_id;
3394:
3395: FEM_ENGINES_PKG.Tech_Message
3396: (p_severity => pc_log_level_statement,

Line 3615: v_obj_approval_status_cd fem_object_definition_b.approval_status_code%TYPE;

3611: -- Notes
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:

Line 3637: FROM fem_object_definition_b

3633: BEGIN
3634:
3635: SELECT object_id, approval_status_code
3636: INTO pv_rule_obj_id, v_obj_approval_status_cd
3637: FROM fem_object_definition_b
3638: WHERE object_definition_id = pv_rule_obj_def_id
3639: AND old_approved_copy_flag = 'N';
3640:
3641: FEM_ENGINES_PKG.Tech_Message

Line 4819: , FEM_OBJECT_DEFINITION_B objDef

4815: , pv_rule_eff_start_date
4816: , pv_rule_eff_end_date
4817: FROM FEM_INTG_BAL_RULES balRule
4818: , FEM_INTG_BAL_RULE_DEFS balRDef
4819: , FEM_OBJECT_DEFINITION_B objDef
4820: , FEM_OBJECT_DEFINITION_TL objDefT
4821: , FND_ID_FLEX_STRUCTURES_TL flex
4822: , GL_LEDGERS lgr
4823: WHERE balRule.BAL_RULE_OBJ_ID = objDef.OBJECT_ID

Line 5136: , fem_object_definition_b od

5132: SELECT DISTINCT 'X'
5133: INTO v_dummy_flag
5134: FROM fem_intg_dim_rules r
5135: , fem_intg_dim_rule_defs rd
5136: , fem_object_definition_b od
5137: WHERE r.dim_rule_obj_id = od.object_id
5138: AND rd.dim_rule_obj_def_id = od.object_definition_id
5139: AND rd.dim_mapping_option_code <> 'SINGLEVAL'
5140: AND r.dimension_id <> 0