DBA Data[Home] [Help]

APPS.MTH_CALENDAR_PKG dependencies on MTH_PERIOD_ERR

Line 1355: from MTH_PERIOD_ERR

1351: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;
1352:
1353: select count(*)
1354: into v_period_err
1355: from MTH_PERIOD_ERR
1356: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;
1357:
1358: select count(*)
1359: into v_week_err

Line 1555: from MTH_PERIOD_ERR

1551: USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1,
1552: USER_MEASURE2, USER_MEASURE3,USER_MEASURE4,
1553: USER_MEASURE5, SYSTEM_FK, END_DATE, START_DATE, ERR_CODE,
1554: P_SESSION_NO as RUN_ID
1555: from MTH_PERIOD_ERR
1556: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO);*/
1557:
1558: -- Collect Quarter Data into array
1559: SELECT HIERARCHY_NAME, NAME, USER_ATTR1, USER_ATTR2,

Line 1777: INSERT INTO MTH_PERIOD_ERR(

1773:
1774: mth_util_pkg.log_msg('c_mth_weekerr_NAME.COUNT = ' || c_mth_weekerr_NAME.COUNT , mth_util_pkg.G_DBG_ROW_CNT);
1775:
1776: FORALL i IN 1..c_mth_pererr_NAME.COUNT
1777: INSERT INTO MTH_PERIOD_ERR(
1778: HIERARCHY_NAME, NAME, USER_ATTR1, USER_ATTR2,
1779: USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1,
1780: USER_MEASURE2, USER_MEASURE3,USER_MEASURE4,
1781: USER_MEASURE5, SYSTEM_FK, END_DATE, START_DATE, ERR_CODE,ERR$$$_AUDIT_RUN_ID)