APPS.MTH_CALENDAR_PKG dependencies on MTH_TIME_HIERARCHY

Line 1370: from MTH_TIME_HIERARCHY_ERR

1366: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;
1367:
1368: select count(*)
1369: into v_time_hrcy_err
1370: from MTH_TIME_HIERARCHY_ERR
1371: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;
1372:
1373: /*SELECT
1374: HIERARCHY_NAME,CHILD_FK,PARENT_FK,LEVEL_NUMBER_OF_CHILD,

Line 1385: FROM MTH_TIME_HIERARCHY_ERR

1381: c_mth_hryerr_SYSTEM_FK,
1382: c_mth_hryerr_RUN_ID,
1383: c_mth_hryerr_ERR_CODE
1384:
1385: FROM MTH_TIME_HIERARCHY_ERR
1386: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;*/
1387: /*WHERE LEVEL_FK_KEY IN(
1388: SELECT LEVEL_FK_KEY
1389: FROM(

Line 1391: FROM MTH_TIME_HIERARCHY

1387: /*WHERE LEVEL_FK_KEY IN(
1388: SELECT LEVEL_FK_KEY
1389: FROM(
1390: SELECT LEVEL_FK_KEY,Count(PARENT_FK_KEY) AS MULTIPLE_PARENTS
1391: FROM MTH_TIME_HIERARCHY
1392: GROUP BY LEVEL_FK_KEY)
1393: WHERE MULTIPLE <> 1);*/
1394:
1395: --Collect Day Data into array

Line 1715: from MTH_TIME_HIERARCHY;

1711: from MTH_DAY_D;
1712:
1713: select count(*)
1714: into v_time_hrcy_err
1715: from MTH_TIME_HIERARCHY;
1716:
1717:
1718: mth_util_pkg.log_msg('After Rollback v_year_d = ' || v_year_err , mth_util_pkg.G_DBG_ROW_CNT);
1719: mth_util_pkg.log_msg('After Rollback v_quarter_d = ' || v_quarter_err , mth_util_pkg.G_DBG_ROW_CNT);

Line 1857: INSERT INTO MTH_TIME_HIERARCHY_ERR(

1853:
1854: mth_util_pkg.log_msg('c_mth_yearerr_NAME.COUNT = ' || c_mth_yearerr_NAME.COUNT , mth_util_pkg.G_DBG_ROW_CNT);
1855:
1856: /*FORALL i in 1..c_mth_hryerr_CHILD_FK.COUNT
1857: INSERT INTO MTH_TIME_HIERARCHY_ERR(
1858: HIERARCHY_NAME,CHILD_FK,PARENT_FK,LEVEL_NUMBER_OF_CHILD,
1859: SYSTEM_FK,ERR_CODE,ERR$$$_AUDIT_RUN_ID)
1860: VALUES
1861: (c_mth_hryerr_HIERARCHY_NAME(i),

Line 1878: DELETE FROM MTH_TIME_HIERARCHY_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_TIME_HIERARCHY_STG');

1874: DELETE FROM MTH_WEEK_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_WEEK_STG');
1875: DELETE FROM MTH_PERIOD_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_PERIOD_STG');
1876: DELETE FROM MTH_QUARTER_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_QUARTER_STG');
1877: DELETE FROM MTH_YEAR_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_YEAR_STG');
1878: DELETE FROM MTH_TIME_HIERARCHY_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_TIME_HIERARCHY_STG');
1879: mth_util_pkg.log_msg('Processing Flag = ' || mth_util_pkg.Get_Processing_Flag() , mth_util_pkg.G_DBG_ROW_CNT);
1880: mth_util_pkg.log_msg('After deleting Staging = ' || P_SESSION_NO , mth_util_pkg.G_DBG_ROW_CNT);
1881:
1882: COMMIT;

Line 1894: DELETE FROM MTH_TIME_HIERARCHY_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_TIME_HIERARCHY_STG');

1890: DELETE FROM MTH_WEEK_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_WEEK_STG');
1891: DELETE FROM MTH_PERIOD_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_PERIOD_STG');
1892: DELETE FROM MTH_QUARTER_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_QUARTER_STG');
1893: DELETE FROM MTH_YEAR_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_YEAR_STG');
1894: DELETE FROM MTH_TIME_HIERARCHY_STG where PROCESSING_FLAG = mth_util_pkg.Get_Processing_Flag('MTH_TIME_HIERARCHY_STG');
1895: --mth_util_pkg.log_msg('Processing Flag = ' || mth_util_pkg.Get_Processing_Flag() , mth_util_pkg.G_DBG_ROW_CNT);
1896: mth_util_pkg.log_msg('After deleting Staging = ' || P_SESSION_NO , mth_util_pkg.G_DBG_ROW_CNT);
1897:
1898: mth_util_pkg.log_msg('VALIDATE_CUSTOM_CAL_STG_DATA start', mth_util_pkg.G_DBG_PROC_FUN_END);