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_CONDITIONS_API dependencies on FEM_XDIM_DIMENSIONS

Line 295: FROM FEM_XDIM_DIMENSIONS

291:
292: IF (p_isDimension) THEN
293: SELECT DECODE (MEMBER_DATA_TYPE_CODE, 'NUMBER', 'NUMBER', 'DATE', 'DATE', 'STRING')
294: INTO l_dataType
295: FROM FEM_XDIM_DIMENSIONS
296: WHERE DIMENSION_ID = p_dimensionId;
297:
298: /*TO DO: handle exceptions*/
299:

Line 560: l_displayCodeCol FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;

556:
557: --3/23/2006
558: l_isDimension BOOLEAN;
559: l_sqlStmt VARCHAR2(500);
560: l_displayCodeCol FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
561: l_memberTableName FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
562: l_displayCodeVal FEM_LEDGERS_B.LEDGER_DISPLAY_CODE%TYPE;
563: l_displayCodeSQL VARCHAR2(500);
564:

Line 561: l_memberTableName FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;

557: --3/23/2006
558: l_isDimension BOOLEAN;
559: l_sqlStmt VARCHAR2(500);
560: l_displayCodeCol FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
561: l_memberTableName FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
562: l_displayCodeVal FEM_LEDGERS_B.LEDGER_DISPLAY_CODE%TYPE;
563: l_displayCodeSQL VARCHAR2(500);
564:
565: BEGIN

Line 577: --if column is a dimension column then query fem_xdim_dimensions to get display code column name and member table name

573: FOR i IN z_dataStepValues.FIRST..z_dataStepValues.LAST LOOP
574:
575: --3/23/06 NEW LOGIC HERE
576: IF (z_dataStepValues(i).OPERATOR_CODE IN ('GREATER','GREATER_EQUAL','LESSER','LESSER_EQUAL')) THEN
577: --if column is a dimension column then query fem_xdim_dimensions to get display code column name and member table name
578: IF (p_isDimension) THEN
579:
580: SELECT MEMBER_DISPLAY_CODE_COL, MEMBER_B_TABLE_NAME
581: INTO l_displayCodeCol, l_memberTableName

Line 582: FROM FEM_XDIM_DIMENSIONS

578: IF (p_isDimension) THEN
579:
580: SELECT MEMBER_DISPLAY_CODE_COL, MEMBER_B_TABLE_NAME
581: INTO l_displayCodeCol, l_memberTableName
582: FROM FEM_XDIM_DIMENSIONS
583: WHERE MEMBER_COL = p_columnName;
584:
585: --only proceed with obtaining display codes if the display code column is different from member column;
586: --ie. display code col exists on member table

Line 857: l_displayCodeCol FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;

853:
854: --3/23/2006
855: l_isDimension BOOLEAN;
856: l_sqlStmt VARCHAR2(500);
857: l_displayCodeCol FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
858: l_memberTableName FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
859: l_minRangeDisplayCode FEM_LEDGERS_B.LEDGER_DISPLAY_CODE%TYPE;
860: l_maxRangeDisplayCode FEM_LEDGERS_B.LEDGER_DISPLAY_CODE%TYPE;
861: l_displayCodeSQL VARCHAR2(500);

Line 858: l_memberTableName FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;

854: --3/23/2006
855: l_isDimension BOOLEAN;
856: l_sqlStmt VARCHAR2(500);
857: l_displayCodeCol FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
858: l_memberTableName FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%TYPE;
859: l_minRangeDisplayCode FEM_LEDGERS_B.LEDGER_DISPLAY_CODE%TYPE;
860: l_maxRangeDisplayCode FEM_LEDGERS_B.LEDGER_DISPLAY_CODE%TYPE;
861: l_displayCodeSQL VARCHAR2(500);
862:

Line 874: --if column is a dimension column then query fem_xdim_dimensions to get display code column name and member table name

870:
871: FOR i IN z_dataStepValues.FIRST..z_dataStepValues.LAST LOOP
872:
873: --3/23/06 NEW LOGIC HERE
874: --if column is a dimension column then query fem_xdim_dimensions to get display code column name and member table name
875: IF (p_isDimension) THEN
876:
877: SELECT MEMBER_DISPLAY_CODE_COL, MEMBER_B_TABLE_NAME
878: INTO l_displayCodeCol, l_memberTableName

Line 879: FROM FEM_XDIM_DIMENSIONS

875: IF (p_isDimension) THEN
876:
877: SELECT MEMBER_DISPLAY_CODE_COL, MEMBER_B_TABLE_NAME
878: INTO l_displayCodeCol, l_memberTableName
879: FROM FEM_XDIM_DIMENSIONS
880: WHERE MEMBER_COL = p_columnName;
881:
882: --only proceed with obtaining display codes if the display code column is different from member column;
883: --ie. display code col exists on member table

Line 1547: FROM FEM_XDIM_DIMENSIONS A,

1543: l_attrId,
1544: l_attrDataType,
1545: l_attrDimId,
1546: l_defaultVersionId
1547: FROM FEM_XDIM_DIMENSIONS A,
1548: FEM_DIM_ATTRIBUTES_VL B,
1549: FEM_DIM_ATTR_VERSIONS_VL C
1550: WHERE A.DIMENSION_ID = p_dimensionId
1551: AND A.DIMENSION_ID = B.DIMENSION_ID

Line 1666: from fem_xdim_dimensions

1662: l_value_set_id := null;
1663:
1664: select value_set_required_flag
1665: into l_value_set_required_flag
1666: from fem_xdim_dimensions
1667: where dimension_id = p_dimension_id;
1668:
1669: if (l_value_set_required_flag = 'Y') then
1670:

Line 1707: from fem_xdim_dimensions

1703: l_value_set_id := null;
1704:
1705: select value_set_required_flag
1706: into l_value_set_required_flag
1707: from fem_xdim_dimensions
1708: where dimension_id = p_dimension_id;
1709:
1710: if (l_value_set_required_flag = 'Y') then
1711:

Line 2018: from fem_xdim_dimensions

2014: -- Get hierarchy table name for the specified dimension
2015: begin
2016: select hierarchy_table_name
2017: INTO l_hierarchy_table_name
2018: from fem_xdim_dimensions
2019: where dimension_id = p_dimensionId;
2020: exception
2021: when no_data_found then
2022: -- LOG INVALID VALUES

Line 3621: from fem_xdim_dimensions_vl a

3617: ,dimension_varchar_label
3618: into l_hierarchy_table_name
3619: ,l_value_set_required_flag
3620: ,l_dimension_varchar_label
3621: from fem_xdim_dimensions_vl a
3622: where a.dimension_id = p_dimension_id;
3623: exception
3624: when others then
3625: -- Invalid Dimension Id

Line 3848: from fem_xdim_dimensions_vl xdim

3844: ,decode(xdim.value_set_required_flag
3845: ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)
3846: ,null))
3847: into l_member_display_code
3848: from fem_xdim_dimensions_vl xdim
3849: where xdim.dimension_id = p_dimension_id;
3850:
3851: return l_member_display_code;
3852:

Line 3891: from fem_xdim_dimensions_vl xdim

3887: ,decode(xdim.value_set_required_flag
3888: ,'Y',FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(xdim.dimension_id)
3889: ,null))
3890: into l_member_name
3891: from fem_xdim_dimensions_vl xdim
3892: where xdim.dimension_id = p_dimension_id;
3893:
3894: return l_member_name;
3895: