eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_BR_MAPPING_RULE_PVT dependencies on FEM_OBJECT_CATALOG_B

Line 406: l_cond_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

402: (p_obj_def_id NUMBER,
403: p_func_seq NUMBER
404: ) RETURN NUMBER
405: IS
406: l_cond_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
407: BEGIN
408: select sub_object_id
409: into l_cond_id
410: from fem_alloc_br_formula

Line 595: from fem_object_catalog_b obj

591: select sub_object_id
592: from fem_alloc_br_formula formula
593: where formula.object_definition_id = p_rule_def_id
594: and exists (select 1
595: from fem_object_catalog_b obj
596: where obj.object_id = formula.sub_object_id
597: and obj.object_type_code = 'CONDITION_MAPPING');
598:
599: l_local_cond_id NUMBER;

Line 864: from fem_object_catalog_b obj

860: ,object_version_number
861: from fem_alloc_br_formula formula
862: where formula.object_definition_id = p_obj_def_id
863: and exists (select 1
864: from fem_object_catalog_b obj
865: where obj.object_id = formula.sub_object_id
866: and obj.object_type_code = 'CONDITION_MAPPING');
867:
868: l_formula_rec c_allc_br_formula%ROWTYPE;

Line 871: l_source_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

867:
868: l_formula_rec c_allc_br_formula%ROWTYPE;
869:
870: l_source_cond_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
871: l_source_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
872:
873: l_target_cond_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
874: l_target_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
875: l_target_cond_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;

Line 874: l_target_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

870: l_source_cond_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
871: l_source_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
872:
873: l_target_cond_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;
874: l_target_cond_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
875: l_target_cond_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
876: l_target_cond_obj_def_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
877:
878: l_backup_obj_def_id FEM_OBJECT_DEFINITION_B.object_definition_id%TYPE;

Line 936: from fem_object_catalog_b o

932: from fem_alloc_br_formula f
933: where f.object_definition_id = p_source_obj_def_id
934: and (f.sub_object_id is NULL
935: or NOT EXISTS (select 1
936: from fem_object_catalog_b o
937: where o.object_id = f.sub_object_id
938: and o.object_type_code = 'CONDITION_MAPPING'));
939:
940: -- cursor to select all records from fem_alloc_br_formula and join

Line 941: -- with fem_object_catalog_b to only return records that have

937: where o.object_id = f.sub_object_id
938: and o.object_type_code = 'CONDITION_MAPPING'));
939:
940: -- cursor to select all records from fem_alloc_br_formula and join
941: -- with fem_object_catalog_b to only return records that have
942: -- object_type_code = 'CONDITION_MAPPING'.
943: FOR l_formula_rec IN c_allc_br_formula (p_source_obj_def_id)
944: LOOP
945: