DBA Data[Home] [Help]

APPS.MTH_CALENDAR_PKG dependencies on MTH_TIME_HIERARCHY_ERR

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 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),