DBA Data[Home] [Help]

APPS.MTH_CALENDAR_PKG dependencies on MTH_WEEK_ERR

Line 1360: from MTH_WEEK_ERR

1356: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;
1357:
1358: select count(*)
1359: into v_week_err
1360: from MTH_WEEK_ERR
1361: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;
1362:
1363: select count(*)
1364: into v_day_err

Line 1498: from MTH_WEEK_ERR

1494: USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1,
1495: USER_MEASURE2, USER_MEASURE3,USER_MEASURE4,
1496: USER_MEASURE5, SYSTEM_FK, END_DATE, START_DATE, ERR_CODE,
1497: P_SESSION_NO as RUN_ID
1498: from MTH_WEEK_ERR
1499: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO);*/
1500:
1501: -- Collect Period Data into array
1502: SELECT HIERARCHY_NAME, NAME, USER_ATTR1, USER_ATTR2,

Line 1750: INSERT INTO MTH_WEEK_ERR(

1746:
1747: mth_util_pkg.log_msg('c_mth_dayerr_REPORT_DATE.COUNT = ' || c_mth_dayerr_REPORT_DATE.COUNT , mth_util_pkg.G_DBG_ROW_CNT);
1748:
1749: FORALL i IN 1..c_mth_weekerr_NAME.COUNT
1750: INSERT INTO MTH_WEEK_ERR(
1751: HIERARCHY_NAME, NAME, USER_ATTR1, USER_ATTR2,
1752: USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1,
1753: USER_MEASURE2, USER_MEASURE3,USER_MEASURE4,
1754: USER_MEASURE5, SYSTEM_FK, END_DATE, START_DATE, ERR_CODE,ERR$$$_AUDIT_RUN_ID)