APPS.FEM_INTG_CAL_RULE_ENG_PKG dependencies on FEM_DIMENSION_UTIL_PKG

Line 1372: -- Generates CAL_PERIOD_IDs using FEM_DIMENSION_UTIL_PKG.Generate_Member_ID

1368: -- ======================================================================
1369: -- Procedure
1370: -- Generate_Member_IDs
1371: -- Purpose
1372: -- Generates CAL_PERIOD_IDs using FEM_DIMENSION_UTIL_PKG.Generate_Member_ID
1373: -- and stores them in Global Temporary table
1374: -- History
1375: -- 02-02-05 Shintaro Okuda Created
1376: -- 08-02-05 Harikiran Bug 4523730 - Made code changes to the query

Line 1413: FEM_DIMENSION_UTIL_PKG.Generate_Member_ID(

1409: QUARTER_NUM,
1410: PERIOD_YEAR
1411: )
1412: SELECT -- Period members
1413: FEM_DIMENSION_UTIL_PKG.Generate_Member_ID(
1414: P.END_DATE,
1415: P.PERIOD_NUM,
1416: pv_calendar_id,
1417: G.DIMENSION_GROUP_ID

Line 1438: FEM_DIMENSION_UTIL_PKG.Generate_Member_ID(

1434: P.PERIOD_YEAR = pv_period_year AND
1435: G.DIMENSION_GROUP_ID = pv_dimension_grp_id_period
1436: UNION ALL
1437: SELECT -- Quater members
1438: FEM_DIMENSION_UTIL_PKG.Generate_Member_ID(
1439: Q.END_DATE,
1440: Q.QUARTER_NUM,
1441: pv_calendar_id,
1442: pv_dimension_grp_id_quarter

Line 1475: FEM_DIMENSION_UTIL_PKG.Generate_Member_ID(

1471: WHERE
1472: PT.PERIOD_TYPE = pv_period_type
1473: UNION ALL
1474: SELECT -- Year members
1475: FEM_DIMENSION_UTIL_PKG.Generate_Member_ID(
1476: Y.END_DATE,
1477: 1, -- Bug 4523730 hkaniven --
1478: pv_calendar_id,
1479: pv_dimension_grp_id_year