eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTH_CALENDAR_PKG dependencies on MTH_YEAR_ERR

Line 1212: TYPE err_name IS TABLE OF MTH_YEAR_ERR.HIERARCHY_NAME%TYPE

1208: PROCEDURE VALIDATE_CUSTOM_CAL_STG_DATA(P_SESSION_NO IN VARCHAR) IS
1209:
1210: V_VALIDATION_STATUS NUMBER;
1211: l_execution_id NUMBER;
1212: TYPE err_name IS TABLE OF MTH_YEAR_ERR.HIERARCHY_NAME%TYPE
1213: INDEX BY PLS_INTEGER;
1214: TYPE err_userattr IS TABLE OF MTH_YEAR_ERR.USER_ATTR1%TYPE
1215: INDEX BY PLS_INTEGER;
1216: TYPE err_usermeasure IS TABLE OF MTH_YEAR_ERR.USER_MEASURE1%TYPE

Line 1214: TYPE err_userattr IS TABLE OF MTH_YEAR_ERR.USER_ATTR1%TYPE

1210: V_VALIDATION_STATUS NUMBER;
1211: l_execution_id NUMBER;
1212: TYPE err_name IS TABLE OF MTH_YEAR_ERR.HIERARCHY_NAME%TYPE
1213: INDEX BY PLS_INTEGER;
1214: TYPE err_userattr IS TABLE OF MTH_YEAR_ERR.USER_ATTR1%TYPE
1215: INDEX BY PLS_INTEGER;
1216: TYPE err_usermeasure IS TABLE OF MTH_YEAR_ERR.USER_MEASURE1%TYPE
1217: INDEX BY PLS_INTEGER;
1218: TYPE err_date IS TABLE OF MTH_YEAR_ERR.START_DATE%TYPE

Line 1216: TYPE err_usermeasure IS TABLE OF MTH_YEAR_ERR.USER_MEASURE1%TYPE

1212: TYPE err_name IS TABLE OF MTH_YEAR_ERR.HIERARCHY_NAME%TYPE
1213: INDEX BY PLS_INTEGER;
1214: TYPE err_userattr IS TABLE OF MTH_YEAR_ERR.USER_ATTR1%TYPE
1215: INDEX BY PLS_INTEGER;
1216: TYPE err_usermeasure IS TABLE OF MTH_YEAR_ERR.USER_MEASURE1%TYPE
1217: INDEX BY PLS_INTEGER;
1218: TYPE err_date IS TABLE OF MTH_YEAR_ERR.START_DATE%TYPE
1219: INDEX BY PLS_INTEGER;
1220: TYPE err_code IS TABLE OF MTH_YEAR_ERR.ERR_CODE%TYPE

Line 1218: TYPE err_date IS TABLE OF MTH_YEAR_ERR.START_DATE%TYPE

1214: TYPE err_userattr IS TABLE OF MTH_YEAR_ERR.USER_ATTR1%TYPE
1215: INDEX BY PLS_INTEGER;
1216: TYPE err_usermeasure IS TABLE OF MTH_YEAR_ERR.USER_MEASURE1%TYPE
1217: INDEX BY PLS_INTEGER;
1218: TYPE err_date IS TABLE OF MTH_YEAR_ERR.START_DATE%TYPE
1219: INDEX BY PLS_INTEGER;
1220: TYPE err_code IS TABLE OF MTH_YEAR_ERR.ERR_CODE%TYPE
1221: INDEX BY PLS_INTEGER;
1222: TYPE err_sysfk IS TABLE OF MTH_YEAR_ERR.SYSTEM_FK%TYPE

Line 1220: TYPE err_code IS TABLE OF MTH_YEAR_ERR.ERR_CODE%TYPE

1216: TYPE err_usermeasure IS TABLE OF MTH_YEAR_ERR.USER_MEASURE1%TYPE
1217: INDEX BY PLS_INTEGER;
1218: TYPE err_date IS TABLE OF MTH_YEAR_ERR.START_DATE%TYPE
1219: INDEX BY PLS_INTEGER;
1220: TYPE err_code IS TABLE OF MTH_YEAR_ERR.ERR_CODE%TYPE
1221: INDEX BY PLS_INTEGER;
1222: TYPE err_sysfk IS TABLE OF MTH_YEAR_ERR.SYSTEM_FK%TYPE
1223: INDEX BY PLS_INTEGER;
1224: TYPE err_runid IS TABLE OF MTH_YEAR_ERR.ERR$$$_AUDIT_RUN_ID%TYPE

Line 1222: TYPE err_sysfk IS TABLE OF MTH_YEAR_ERR.SYSTEM_FK%TYPE

1218: TYPE err_date IS TABLE OF MTH_YEAR_ERR.START_DATE%TYPE
1219: INDEX BY PLS_INTEGER;
1220: TYPE err_code IS TABLE OF MTH_YEAR_ERR.ERR_CODE%TYPE
1221: INDEX BY PLS_INTEGER;
1222: TYPE err_sysfk IS TABLE OF MTH_YEAR_ERR.SYSTEM_FK%TYPE
1223: INDEX BY PLS_INTEGER;
1224: TYPE err_runid IS TABLE OF MTH_YEAR_ERR.ERR$$$_AUDIT_RUN_ID%TYPE
1225: INDEX BY PLS_INTEGER;
1226:

Line 1224: TYPE err_runid IS TABLE OF MTH_YEAR_ERR.ERR$$$_AUDIT_RUN_ID%TYPE

1220: TYPE err_code IS TABLE OF MTH_YEAR_ERR.ERR_CODE%TYPE
1221: INDEX BY PLS_INTEGER;
1222: TYPE err_sysfk IS TABLE OF MTH_YEAR_ERR.SYSTEM_FK%TYPE
1223: INDEX BY PLS_INTEGER;
1224: TYPE err_runid IS TABLE OF MTH_YEAR_ERR.ERR$$$_AUDIT_RUN_ID%TYPE
1225: INDEX BY PLS_INTEGER;
1226:
1227: /*c_mth_hryerr_HIERARCHY_NAME err_name;
1228: c_mth_hryerr_CHILD_FK err_name;

Line 1345: from MTH_YEAR_ERR

1341: V_VALIDATION_STATUS := 0;
1342:
1343: select count(*)
1344: into v_year_err
1345: from MTH_YEAR_ERR
1346: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO;
1347:
1348: select count(*)
1349: into v_quarter_err

Line 1669: from MTH_YEAR_ERR

1665: USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1,
1666: USER_MEASURE2, USER_MEASURE3,USER_MEASURE4,
1667: USER_MEASURE5, SYSTEM_FK, END_DATE, START_DATE, ERR_CODE,
1668: P_SESSION_NO as RUN_ID
1669: from MTH_YEAR_ERR
1670: WHERE ERR$$$_AUDIT_RUN_ID = P_SESSION_NO);*/
1671:
1672: IF c_mth_dayerr_REPORT_DATE.COUNT > 0 OR c_mth_weekerr_NAME.COUNT > 0 OR c_mth_pererr_NAME.COUNT > 0 OR c_mth_qerr_NAME.COUNT > 0 OR c_mth_yearerr_NAME.COUNT >0 THEN
1673: V_VALIDATION_STATUS := -1;

Line 1830: INSERT INTO MTH_YEAR_ERR(

1826: c_mth_qerr_RUN_ID(i));
1827:
1828: mth_util_pkg.log_msg('c_mth_qerr_NAME.COUNT = ' || c_mth_qerr_NAME.COUNT , mth_util_pkg.G_DBG_ROW_CNT);
1829: FORALL i IN 1..c_mth_yearerr_NAME.COUNT
1830: INSERT INTO MTH_YEAR_ERR(
1831: HIERARCHY_NAME, NAME, USER_ATTR1, USER_ATTR2,
1832: USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1,
1833: USER_MEASURE2, USER_MEASURE3,USER_MEASURE4,
1834: USER_MEASURE5, SYSTEM_FK, END_DATE, START_DATE, ERR_CODE,ERR$$$_AUDIT_RUN_ID)