APPS.OKC_UDA_TEMPLATES_UTIL dependencies on EGO_MAPPINGS_B

Line 641: FROM EGO_MAPPINGS_B

637: BEGIN
638:
639: SELECT MAPPED_TO_GROUP_PK2, MAPPED_TO_GROUP_PK3, MAPPED_ATTRIBUTE
640: INTO l_pk2, l_pk3, l_map_attr
641: FROM EGO_MAPPINGS_B
642: WHERE FUNCTION_ID = l_function_id
643: AND MAPPED_OBJ_PK1_VAL = l_action_id
644: AND FUNC_PARAM_ID = l_param_id
645: AND MAPPED_OBJ_TYPE = p_map_obj_type

Line 654: INSERT INTO EGO_MAPPINGS_B

650:
651: EXCEPTION
652: WHEN NO_DATA_FOUND THEN
653:
654: INSERT INTO EGO_MAPPINGS_B
655: (
656: FUNCTION_ID,
657: MAPPED_OBJ_TYPE,
658: MAPPED_OBJ_PK1_VAL,

Line 901: FROM EGO_MAPPINGS_B

897:
898: CURSOR c_src_func_mappings(p_function_id NUMBER, p_action_id NUMBER) IS
899: SELECT FUNCTION_ID, MAPPED_OBJ_TYPE, MAPPED_OBJ_PK1_VAL, FUNC_PARAM_ID, MAPPED_TO_GROUP_TYPE, MAPPED_TO_GROUP_PK1, MAPPED_TO_GROUP_PK2,
900: MAPPED_TO_GROUP_PK3, MAPPED_ATTRIBUTE, MAPPED_UOM_PARAMETER, VALUE_UOM_SOURCE, FIXED_UOM
901: FROM EGO_MAPPINGS_B
902: WHERE function_id = p_function_id
903: AND MAPPED_OBJ_PK1_VAL = p_action_id;
904:
905: BEGIN