DBA Data[Home] [Help]

APPS.MTH_CALENDAR_PKG dependencies on MTH_DAY_ERR

Line 1365: from MTH_DAY_ERR

1361: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;
1362:
1363: select count(*)
1364: into v_day_err
1365: from MTH_DAY_ERR
1366: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;
1367:
1368: select count(*)
1369: into v_time_hrcy_err

Line 1441: FROM MTH_DAY_ERR

1437: SELECT REPORT_DATE, USER_ATTR1, USER_ATTR2,
1438: USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1,
1439: USER_MEASURE2, USER_MEASURE3,USER_MEASURE4,
1440: USER_MEASURE5, SYSTEM_FK, ERR_CODE, P_SESSION_NO as RUN_ID
1441: FROM MTH_DAY_ERR
1442: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;*/
1443:
1444: -- Collect Week Data into array
1445: SELECT HIERARCHY_NAME, NAME, USER_ATTR1, USER_ATTR2,

Line 1726: INSERT INTO MTH_DAY_ERR(

1722: mth_util_pkg.log_msg('After Rollback v_day_d = ' || v_day_err , mth_util_pkg.G_DBG_ROW_CNT);
1723: mth_util_pkg.log_msg('After Rollback v_time_hrcy_d = ' || v_time_hrcy_err , mth_util_pkg.G_DBG_ROW_CNT);
1724:
1725: FORALL i IN 1..c_mth_dayerr_REPORT_DATE.COUNT
1726: INSERT INTO MTH_DAY_ERR(
1727: REPORT_DATE, USER_ATTR1, USER_ATTR2,
1728: USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1,
1729: USER_MEASURE2, USER_MEASURE3,USER_MEASURE4,
1730: USER_MEASURE5, SYSTEM_FK, ERR_CODE,ERR$$$_AUDIT_RUN_ID)