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_DIMENSION_UTIL_PKG dependencies on FEM_CAL_PERIODS_B

Line 1110: TYPE cal_period_tbl_type IS TABLE OF FEM_CAL_PERIODS_B.cal_period_id%TYPE;

1106: 'fem.plsql.fem_dimension_util_pkg.relative_cal_period_id';
1107: C_LIMIT CONSTANT NUMBER := 10000; -- fetch limit
1108: e_unexp EXCEPTION;
1109:
1110: TYPE cal_period_tbl_type IS TABLE OF FEM_CAL_PERIODS_B.cal_period_id%TYPE;
1111: v_cal_period_tbl cal_period_tbl_type;
1112: TYPE cal_period_cur_type IS REF CURSOR; -- define weak REF CURSOR type
1113: v_cal_period_cv cal_period_cur_type;
1114:

Line 1115: v_base_dimgrp_id FEM_CAL_PERIODS_B.calendar_id%TYPE;

1111: v_cal_period_tbl cal_period_tbl_type;
1112: TYPE cal_period_cur_type IS REF CURSOR; -- define weak REF CURSOR type
1113: v_cal_period_cv cal_period_cur_type;
1114:
1115: v_base_dimgrp_id FEM_CAL_PERIODS_B.calendar_id%TYPE;
1116: v_base_calendar_id FEM_CAL_PERIODS_B.dimension_group_id%TYPE;
1117: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
1118: v_dim_name FEM_DIMENSIONS_TL.dimension_name%TYPE;
1119: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;

Line 1116: v_base_calendar_id FEM_CAL_PERIODS_B.dimension_group_id%TYPE;

1112: TYPE cal_period_cur_type IS REF CURSOR; -- define weak REF CURSOR type
1113: v_cal_period_cv cal_period_cur_type;
1114:
1115: v_base_dimgrp_id FEM_CAL_PERIODS_B.calendar_id%TYPE;
1116: v_base_calendar_id FEM_CAL_PERIODS_B.dimension_group_id%TYPE;
1117: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
1118: v_dim_name FEM_DIMENSIONS_TL.dimension_name%TYPE;
1119: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
1120: v_dim_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;

Line 1175: FROM fem_cal_periods_b

1171: -- of the base period
1172: BEGIN
1173: SELECT calendar_id, dimension_group_id
1174: INTO v_base_calendar_id, v_base_dimgrp_id
1175: FROM fem_cal_periods_b
1176: WHERE cal_period_id = p_base_cal_period_id;
1177:
1178: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1179: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1433: v_sql := 'SELECT CP.cal_period_id FROM fem_cal_periods_b CP';

1429:
1430: -- Build the dynamic sql to return the relevant calendar periods
1431: -- needed for the relative offset calcs
1432:
1433: v_sql := 'SELECT CP.cal_period_id FROM fem_cal_periods_b CP';
1434:
1435: IF v_incl_adj_period = 'N' THEN
1436: v_sql := v_sql||',fem_cal_periods_attr CPA';
1437: END IF;

Line 1641: CALENDAR_ID (in fem_cal_periods_b) is the same as the Calendar

1637: procedure could return a cal_period_id where the Year of the End Date
1638: belongs in a different year than the fiscal year.
1639:
1640: The above version finds the CAL_PERIOD_ID where:
1641: CALENDAR_ID (in fem_cal_periods_b) is the same as the Calendar
1642: of the CAL_PERIOD_HIER_OBJ_DEF_ID attribute of the p_ledger_id
1643:
1644: DIMENSION_GROUP_ID (in fem_cal_periods_b) matches the
1645: DIMENSION_GROUP_ID from fem_dimension_grps_b where

Line 1644: DIMENSION_GROUP_ID (in fem_cal_periods_b) matches the

1640: The above version finds the CAL_PERIOD_ID where:
1641: CALENDAR_ID (in fem_cal_periods_b) is the same as the Calendar
1642: of the CAL_PERIOD_HIER_OBJ_DEF_ID attribute of the p_ledger_id
1643:
1644: DIMENSION_GROUP_ID (in fem_cal_periods_b) matches the
1645: DIMENSION_GROUP_ID from fem_dimension_grps_b where
1646: the DIMENSION_GROUP_DISPLAY_CODE = p_dim grp_dc
1647:
1648: Value for the GL_PERIOD_NUM attribute (in fem_cal_periods_attr)

Line 1750: FROM fem_cal_periods_b B,

1746:
1747:
1748: SELECT B.cal_period_id
1749: INTO v_cal_period_id
1750: FROM fem_cal_periods_b B,
1751: fem_cal_periods_attr N,
1752: fem_cal_periods_attr D,
1753: fem_dimension_grps_b G
1754: WHERE N.attribute_id = v_periodnum_attr_id

Line 1780: CALENDAR_ID (in fem_cal_periods_b) is the same as the Calendar

1776: This function is available for applications to call when they
1777: want to find the corresponding CAL_PERIOD_ID for a given end date.
1778:
1779: The above version finds the CAL_PERIOD_ID where:
1780: CALENDAR_ID (in fem_cal_periods_b) is the same as the Calendar
1781: of the CAL_PERIOD_HIER_OBJ_DEF_ID attribute of the p_ledger_id
1782:
1783: DIMENSION_GROUP_ID (in fem_cal_periods_b) matches the
1784: DIMENSION_GROUP_ID from fem_dimension_grps_b where

Line 1783: DIMENSION_GROUP_ID (in fem_cal_periods_b) matches the

1779: The above version finds the CAL_PERIOD_ID where:
1780: CALENDAR_ID (in fem_cal_periods_b) is the same as the Calendar
1781: of the CAL_PERIOD_HIER_OBJ_DEF_ID attribute of the p_ledger_id
1782:
1783: DIMENSION_GROUP_ID (in fem_cal_periods_b) matches the
1784: DIMENSION_GROUP_ID from fem_dimension_grps_b where
1785: the DIMENSION_GROUP_DISPLAY_CODE = p_dim grp_dc
1786:
1787: Value for the GL_PERIOD_NUM attribute (in fem_cal_periods_attr)

Line 1889: FROM fem_cal_periods_b B,

1885:
1886:
1887: SELECT B.cal_period_id
1888: INTO v_cal_period_id
1889: FROM fem_cal_periods_b B,
1890: fem_cal_periods_attr N,
1891: fem_cal_periods_attr D,
1892: fem_dimension_grps_b G
1893: WHERE N.attribute_id = v_periodnum_attr_id