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.IBE_REPORTING_PVT dependencies on IBE_ECR_MVLOG

Line 244: Update IBE_ECR_MVLOG

240: printDebugLog('updateLog(+)');
241: printDebugLog(fnd_global.tab||'IN Parameters: '||to_char(pMvlogid)||', '||pStatus||', '||to_char(pLogTime,'YYYY-MM-DD HH24:MI:SS')||', '||pCurrencyCode||', '||pErrorCode||', '||pErrorMessage);
242: END IF;
243:
244: Update IBE_ECR_MVLOG
245: Set Refresh_Status = pStatus,
246: Refresh_Duration = ((pLogTime- Creation_Date)*24*60*60),
247: Currency_Code = pCurrencyCode,
248: Error_Code = pErrorCode,

Line 272: Update IBE_ECR_MVLOG

268: printDebugLog('updateLog(+)');
269: printDebugLog(fnd_global.tab||'IN Parameters: '||pName||', '||pMode||', '||to_char(pFromStatus)||', '||to_char(pToStatus)||', '||pErrorCode||', '||pErrorMessage );
270: END IF;
271:
272: Update IBE_ECR_MVLOG
273: Set Refresh_Status = pToStatus,
274: Error_Code = nvl(pErrorCode,Error_Code),
275: Error_Message = nvl(pErrorMessage,Error_Message)
276: Where Refresh_Status = pFromStatus

Line 307: Insert into IBE_ECR_MVLOG

303:
304: END IF;
305:
306: -- Make New Entry.
307: Insert into IBE_ECR_MVLOG
308: (mvlog_id,object_version_number,Created_by,Creation_Date,
309: last_updated_by,last_update_date,last_update_login,
310: Program_application_id,Request_id,Program_id,Program_update_Date,Refresh_Mode,
311: mview_Name, Refresh_Status, Begin_Date, End_Date,Fact_Source,Error_Code, Error_Message,Refresh_Duration,

Line 313: Values (ibe_ecr_mvlog_s1.nextval,0,

309: last_updated_by,last_update_date,last_update_login,
310: Program_application_id,Request_id,Program_id,Program_update_Date,Refresh_Mode,
311: mview_Name, Refresh_Status, Begin_Date, End_Date,Fact_Source,Error_Code, Error_Message,Refresh_Duration,
312: CONVERSION_TYPE, DAY_BIN_OFFSET,FORCE_REFRESH_FLAG, QUARTER_BEGIN_FLAG, PERIOD_SET_NAME)
313: Values (ibe_ecr_mvlog_s1.nextval,0,
314: FND_GLOBAL.user_id,pLogTime,
315: FND_GLOBAL.user_id,sysdate,
316: FND_GLOBAL.Conc_Login_ID,
317: fnd_global.prog_appl_id, fnd_global.conc_request_id,

Line 330: printOutput(getMessage('IBE','IBE_ECR_MVLOG_ERROR',pMviewName));

326: printDebugLog('makeLogEntry(-)');
327: END IF;
328: EXCEPTION
329: When Others Then
330: printOutput(getMessage('IBE','IBE_ECR_MVLOG_ERROR',pMviewName));
331: Raise;
332: END makeLogEntry;
333:
334:

Line 744: From ibe_ecr_mvlog

740:
741: ElsIf pMode = 'INCREMENT' Then
742:
743: Select min(End_Date) Into pFromDate
744: From ibe_ecr_mvlog
745: Where refresh_mode = pMode
746: And mview_name = pfactName
747: And refresh_status = 1;
748:

Line 752: From ibe_ecr_mvlog

748:
749: If pFromDate is null Then
750:
751: Select min(Begin_Date) Into pFromDate
752: From ibe_ecr_mvlog
753: Where refresh_mode = pMode
754: And mview_name = pfactName
755: And refresh_status = -1;
756:

Line 761: From ibe_ecr_mvlog

757: If pFromDate is null Then
758:
759: Begin
760: Select End_Date Into pFromDate
761: From ibe_ecr_mvlog
762: Where refresh_mode = 'COMPLETE'
763: And mview_name = pfactName
764: And refresh_status = 1;
765: Exception

Line 892: From IBE_ECR_MVLOG

888:
889:
890: Select Begin_Date, End_Date
891: Into pStartDate, pEndDate
892: From IBE_ECR_MVLOG
893: Where Refresh_Status = pStatus
894: And Mview_Name = pFactname
895: And Refresh_Mode = pMode;
896: IF (l_debug = 'Y') THEN

Line 1212: From IBE_ECR_MVLOG

1208:
1209: Begin
1210:
1211: Select Mvlog_id, Begin_Date, End_Date Into l_mvlog_id,l_begindate,l_enddate
1212: From IBE_ECR_MVLOG
1213: Where Refresh_Status = l_mvlog_Status
1214: And Mview_Name = pObjName
1215: And Refresh_Mode = pMode;
1216:

Line 1221: Update IBE_ECR_MVLOG

1217: If (l_begindate = pBeginDate And l_enddate = pendDate) Then
1218:
1219: pForceRefreshStatus := 'N';
1220:
1221: Update IBE_ECR_MVLOG
1222: Set Program_ID = fnd_global.conc_program_id,
1223: Request_id = fnd_global.conc_request_id,
1224: Program_update_Date = SysDate,
1225: last_updated_by = FND_GLOBAL.USER_ID,

Line 1461: Update IBE_ECR_MVLOG Set Refresh_status = -1 Where Refresh_Status = 0;

1457: end if;
1458:
1459: setSessionParallel( g_parallelFlag);
1460:
1461: Update IBE_ECR_MVLOG Set Refresh_status = -1 Where Refresh_Status = 0;
1462:
1463:
1464: refreshFact(pMode,'IBE_ECR_ORDER_HEADERS_FACT',pBeginDate, pEndDate);
1465: refreshFact(pMode,'IBE_ECR_ORDERS_FACT',pBeginDate, pEndDate);

Line 1570: From IBE_ECR_MVLOG

1566: Select 'Y',Begin_Date,End_Date,Conversion_Type,Currency_code,Fact_Source,
1567: day_bin_offset,Force_Refresh_Flag,Quarter_Begin_Flag,Period_Set_Name
1568: INTO pStatus,pBeginDate,pEndDate,pConversionType,pCurrencyCode,pFactSource,
1569: pDayOffset, pForceRefresh, pQuarterBegin,pPeriodSetName
1570: From IBE_ECR_MVLOG
1571: WHERE MView_Name = pName
1572: ANd Refresh_Status = l_mvlogStatus
1573: And Refresh_Mode = pMode;
1574:

Line 1757: Delete from IBE_ECR_MVLOG where Refresh_Status = l_mvlogStatus ;

1753: printDebugLog('purgeMain(+)');
1754: END IF;
1755:
1756: l_mvlogStatus := 2;
1757: Delete from IBE_ECR_MVLOG where Refresh_Status = l_mvlogStatus ;
1758: Commit;
1759: printOutput(getMessage('IBE','IBE_ECR_MVLOG_PURGE'));
1760: IF (l_debug = 'Y') THEN
1761: printDebugLog('purgeMain(-)');

Line 1759: printOutput(getMessage('IBE','IBE_ECR_MVLOG_PURGE'));

1755:
1756: l_mvlogStatus := 2;
1757: Delete from IBE_ECR_MVLOG where Refresh_Status = l_mvlogStatus ;
1758: Commit;
1759: printOutput(getMessage('IBE','IBE_ECR_MVLOG_PURGE'));
1760: IF (l_debug = 'Y') THEN
1761: printDebugLog('purgeMain(-)');
1762: END IF;
1763: EXCEPTION