DBA Data[Home] [Help]

APPS.FEM_INTG_CAL_RULE_ENG_PKG dependencies on FEM_CAL_PERIODS_TL

Line 1582: -- the fem_cal_periods_tl table

1578: -- 08-29-05 Harikiran Bug 4350620
1579: -- - Get the calendar period hierarchy name
1580: -- and prefix it while inserting the
1581: -- calendar period name and description into
1582: -- the fem_cal_periods_tl table
1583: -- Arguments
1584: -- None
1585: -- ======================================================================
1586: PROCEDURE Populate_Time_Dimension

Line 1671: -- while inserting into the fem_cal_periods_tl table

1667:
1668: --
1669: -- Bug 4350620 hkaniven --
1670: -- Prefix the calendar period hierarchy name to the period_name and description
1671: -- while inserting into the fem_cal_periods_tl table
1672: --
1673:
1674:
1675: MERGE INTO FEM_CAL_PERIODS_TL TL

Line 1675: MERGE INTO FEM_CAL_PERIODS_TL TL

1671: -- while inserting into the fem_cal_periods_tl table
1672: --
1673:
1674:
1675: MERGE INTO FEM_CAL_PERIODS_TL TL
1676: USING (
1677: SELECT
1678: GT.CAL_PERIOD_ID CAL_PERIOD_ID,
1679: DECODE(GT.DIMENSION_GROUP_ID,

Line 2432: -- fem_cal_periods_tl

2428: --
2429: -- Bug 4350620 hkaniven --
2430: -- Get the calendar period hierarchy name which will then be added as a
2431: -- prefix to the period_name while inserting into the table
2432: -- fem_cal_periods_tl
2433: --
2434:
2435: SELECT TRIM(display_name)
2436: INTO pv_cal_per_hier_name