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_UTIL_PKG dependencies on MTH_WORKDAY_SHIFTS_ERR

Line 4133: -- SELECT Count(*) INTO v_reprocess_flag FROM MTH_WORKDAY_SHIFTS_ERR WHERE REPROCESS_READY_YN='Y';

4129: -- Initialize default parameters
4130: v_log_date := sysdate;
4131: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
4132: -- mth_util_pkg.switch_column_default_value ( 'MTH_WORKDAY_SHIFTS_STG', v_processing_flag);
4133: -- SELECT Count(*) INTO v_reprocess_flag FROM MTH_WORKDAY_SHIFTS_ERR WHERE REPROCESS_READY_YN='Y';
4134:
4135: -- IF ( v_processing_flag=1 OR v_processing_flag=2 OR v_reprocess_flag>0 ) THEN
4136:
4137:

Line 4184: FROM MTH_WORKDAY_SHIFTS_ERR

4180: TO_DATE,
4181: SHIFT_NAME,
4182: SHIFT_TYPE,
4183: GRAVEYARD_SHIFT
4184: FROM MTH_WORKDAY_SHIFTS_ERR
4185: WHERE UPPER( REPROCESS_READY_YN ) = 'Y'
4186: )
4187: ;
4188: mth_util_pkg.log_msg('Number of rows inserted in MTH_WORKDAY_SHIFTS_STG from error table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line 4191: DELETE FROM MTH_WORKDAY_SHIFTS_ERR

4187: ;
4188: mth_util_pkg.log_msg('Number of rows inserted in MTH_WORKDAY_SHIFTS_STG from error table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4189:
4190: --delete data from the output error table
4191: DELETE FROM MTH_WORKDAY_SHIFTS_ERR
4192: WHERE UPPER(REPROCESS_READY_YN) IN ('D','Y'); --Bug 14753663
4193: mth_util_pkg.log_msg('Number of rows deleted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4194: mth_util_pkg.REFRESH_ONE_MV ('MTH_SHIFT_REFERENCE_MV',null,null,'C');
4195: mth_util_pkg.switch_column_default_value('MTH_WORKDAY_SHIFTS_STG',v_processing_flag);

Line 4193: mth_util_pkg.log_msg('Number of rows deleted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4189:
4190: --delete data from the output error table
4191: DELETE FROM MTH_WORKDAY_SHIFTS_ERR
4192: WHERE UPPER(REPROCESS_READY_YN) IN ('D','Y'); --Bug 14753663
4193: mth_util_pkg.log_msg('Number of rows deleted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4194: mth_util_pkg.REFRESH_ONE_MV ('MTH_SHIFT_REFERENCE_MV',null,null,'C');
4195: mth_util_pkg.switch_column_default_value('MTH_WORKDAY_SHIFTS_STG',v_processing_flag);
4196: IF ( v_processing_flag=1 OR v_processing_flag=2 ) THEN
4197:

Line 4351: --Insert records into mth_workday_shifts_err

4347: WHERE v_profile<>'External Source';
4348: mth_util_pkg.log_msg('Number of rows with PRF in MTH_WORKDAY_SHIFTS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4349:
4350:
4351: --Insert records into mth_workday_shifts_err
4352:
4353: INSERT INTO MTH_WORKDAY_SHIFTS_ERR(REPROCESS_READY_YN,
4354: SHIFT_DATE,
4355: SOURCE_ORG_CODE,

Line 4353: INSERT INTO MTH_WORKDAY_SHIFTS_ERR(REPROCESS_READY_YN,

4349:
4350:
4351: --Insert records into mth_workday_shifts_err
4352:
4353: INSERT INTO MTH_WORKDAY_SHIFTS_ERR(REPROCESS_READY_YN,
4354: SHIFT_DATE,
4355: SOURCE_ORG_CODE,
4356: USER_ATTR1,
4357: USER_ATTR2,

Line 4400: mth_util_pkg.log_msg('Number of rows inserted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

4396: GRAVEYARD_SHIFT
4397: FROM mth_workday_shifts_stg
4398: WHERE err_code IS NOT NULL
4399: );
4400: mth_util_pkg.log_msg('Number of rows inserted in MTH_WORKDAY_SHIFTS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
4401:
4402:
4403:
4404: DELETE FROM mth_equipment_shifts_D