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.CN_MODULES_PKG dependencies on DUAL

Line 320: INTO rec_b.module_id FROM sys.dual;

316: ELSE
317:
318: SELECT Decode(X_MODULE_ID, FND_API.G_MISS_NUM, rec_b.module_id,
319: Ltrim(Rtrim(X_MODULE_ID)))
320: INTO rec_b.module_id FROM sys.dual;
321:
322: SELECT Decode(X_MODULE_TYPE, FND_API.G_MISS_CHAR, rec_b.MODULE_TYPE,
323: Ltrim(Rtrim(X_MODULE_TYPE)))
324: INTO rec_b.MODULE_TYPE FROM sys.dual;

Line 324: INTO rec_b.MODULE_TYPE FROM sys.dual;

320: INTO rec_b.module_id FROM sys.dual;
321:
322: SELECT Decode(X_MODULE_TYPE, FND_API.G_MISS_CHAR, rec_b.MODULE_TYPE,
323: Ltrim(Rtrim(X_MODULE_TYPE)))
324: INTO rec_b.MODULE_TYPE FROM sys.dual;
325:
326: SELECT Decode(X_REPOSITORY_ID, FND_API.G_MISS_NUM, rec_b.REPOSITORY_ID,
327: Ltrim(Rtrim(X_REPOSITORY_ID)))
328: INTO rec_b.REPOSITORY_ID FROM sys.dual;

Line 328: INTO rec_b.REPOSITORY_ID FROM sys.dual;

324: INTO rec_b.MODULE_TYPE FROM sys.dual;
325:
326: SELECT Decode(X_REPOSITORY_ID, FND_API.G_MISS_NUM, rec_b.REPOSITORY_ID,
327: Ltrim(Rtrim(X_REPOSITORY_ID)))
328: INTO rec_b.REPOSITORY_ID FROM sys.dual;
329:
330: SELECT Decode(X_DESCRIPTION, FND_API.G_MISS_CHAR, rec_b.DESCRIPTION,
331: Ltrim(Rtrim(X_DESCRIPTION)))
332: INTO rec_b.DESCRIPTION FROM sys.dual;

Line 332: INTO rec_b.DESCRIPTION FROM sys.dual;

328: INTO rec_b.REPOSITORY_ID FROM sys.dual;
329:
330: SELECT Decode(X_DESCRIPTION, FND_API.G_MISS_CHAR, rec_b.DESCRIPTION,
331: Ltrim(Rtrim(X_DESCRIPTION)))
332: INTO rec_b.DESCRIPTION FROM sys.dual;
333:
334: SELECT Decode(X_PARENT_MODULE_ID, FND_API.G_MISS_NUM, rec_b.PARENT_MODULE_ID,
335: Ltrim(Rtrim(X_PARENT_MODULE_ID)))
336: INTO rec_b.PARENT_MODULE_ID FROM sys.dual;

Line 336: INTO rec_b.PARENT_MODULE_ID FROM sys.dual;

332: INTO rec_b.DESCRIPTION FROM sys.dual;
333:
334: SELECT Decode(X_PARENT_MODULE_ID, FND_API.G_MISS_NUM, rec_b.PARENT_MODULE_ID,
335: Ltrim(Rtrim(X_PARENT_MODULE_ID)))
336: INTO rec_b.PARENT_MODULE_ID FROM sys.dual;
337:
338: SELECT Decode(X_SOURCE_REPOSITORY_ID, FND_API.G_MISS_NUM, rec_b.SOURCE_REPOSITORY_ID,Ltrim(Rtrim(X_SOURCE_REPOSITORY_ID)))
339: INTO rec_b.SOURCE_REPOSITORY_ID FROM sys.dual;
340:

Line 339: INTO rec_b.SOURCE_REPOSITORY_ID FROM sys.dual;

335: Ltrim(Rtrim(X_PARENT_MODULE_ID)))
336: INTO rec_b.PARENT_MODULE_ID FROM sys.dual;
337:
338: SELECT Decode(X_SOURCE_REPOSITORY_ID, FND_API.G_MISS_NUM, rec_b.SOURCE_REPOSITORY_ID,Ltrim(Rtrim(X_SOURCE_REPOSITORY_ID)))
339: INTO rec_b.SOURCE_REPOSITORY_ID FROM sys.dual;
340:
341: SELECT Decode(X_MODULE_STATUS, FND_API.G_MISS_CHAR, rec_b.MODULE_STATUS,
342: Ltrim(Rtrim(X_MODULE_STATUS)))
343: INTO rec_b.MODULE_STATUS FROM sys.dual;

Line 343: INTO rec_b.MODULE_STATUS FROM sys.dual;

339: INTO rec_b.SOURCE_REPOSITORY_ID FROM sys.dual;
340:
341: SELECT Decode(X_MODULE_STATUS, FND_API.G_MISS_CHAR, rec_b.MODULE_STATUS,
342: Ltrim(Rtrim(X_MODULE_STATUS)))
343: INTO rec_b.MODULE_STATUS FROM sys.dual;
344:
345: SELECT Decode(X_EVENT_ID, FND_API.G_MISS_NUM, rec_b.EVENT_ID,
346: Ltrim(Rtrim(X_EVENT_ID)))
347: INTO rec_b.EVENT_ID FROM sys.dual;

Line 347: INTO rec_b.EVENT_ID FROM sys.dual;

343: INTO rec_b.MODULE_STATUS FROM sys.dual;
344:
345: SELECT Decode(X_EVENT_ID, FND_API.G_MISS_NUM, rec_b.EVENT_ID,
346: Ltrim(Rtrim(X_EVENT_ID)))
347: INTO rec_b.EVENT_ID FROM sys.dual;
348:
349: SELECT Decode(X_LAST_MODIFICATION, FND_API.G_MISS_DATE, rec_b.LAST_MODIFICATION,
350: Ltrim(Rtrim(X_LAST_MODIFICATION)))
351: INTO rec_b.LAST_MODIFICATION FROM sys.dual;

Line 351: INTO rec_b.LAST_MODIFICATION FROM sys.dual;

347: INTO rec_b.EVENT_ID FROM sys.dual;
348:
349: SELECT Decode(X_LAST_MODIFICATION, FND_API.G_MISS_DATE, rec_b.LAST_MODIFICATION,
350: Ltrim(Rtrim(X_LAST_MODIFICATION)))
351: INTO rec_b.LAST_MODIFICATION FROM sys.dual;
352:
353: SELECT Decode(X_LAST_SYNCHRONIZATION, FND_API.G_MISS_DATE, rec_b.LAST_SYNCHRONIZATION,
354: Ltrim(Rtrim(X_LAST_SYNCHRONIZATION)))
355: INTO rec_b.LAST_SYNCHRONIZATION FROM sys.dual;

Line 355: INTO rec_b.LAST_SYNCHRONIZATION FROM sys.dual;

351: INTO rec_b.LAST_MODIFICATION FROM sys.dual;
352:
353: SELECT Decode(X_LAST_SYNCHRONIZATION, FND_API.G_MISS_DATE, rec_b.LAST_SYNCHRONIZATION,
354: Ltrim(Rtrim(X_LAST_SYNCHRONIZATION)))
355: INTO rec_b.LAST_SYNCHRONIZATION FROM sys.dual;
356:
357: SELECT Decode(X_OUTPUT_FILENAME, FND_API.G_MISS_CHAR, rec_b.OUTPUT_FILENAME,
358: Ltrim(Rtrim(X_OUTPUT_FILENAME)))
359: INTO rec_b.OUTPUT_FILENAME FROM sys.dual;

Line 359: INTO rec_b.OUTPUT_FILENAME FROM sys.dual;

355: INTO rec_b.LAST_SYNCHRONIZATION FROM sys.dual;
356:
357: SELECT Decode(X_OUTPUT_FILENAME, FND_API.G_MISS_CHAR, rec_b.OUTPUT_FILENAME,
358: Ltrim(Rtrim(X_OUTPUT_FILENAME)))
359: INTO rec_b.OUTPUT_FILENAME FROM sys.dual;
360:
361: SELECT Decode(X_COLLECT_FLAG, FND_API.G_MISS_CHAR, rec_b.COLLECT_FLAG,
362: Ltrim(Rtrim(X_COLLECT_FLAG)))
363: INTO rec_b.COLLECT_FLAG FROM sys.dual;

Line 363: INTO rec_b.COLLECT_FLAG FROM sys.dual;

359: INTO rec_b.OUTPUT_FILENAME FROM sys.dual;
360:
361: SELECT Decode(X_COLLECT_FLAG, FND_API.G_MISS_CHAR, rec_b.COLLECT_FLAG,
362: Ltrim(Rtrim(X_COLLECT_FLAG)))
363: INTO rec_b.COLLECT_FLAG FROM sys.dual;
364:
365:
366: SELECT Decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, rec_b.LAST_UPDATE_DATE,
367: Ltrim(Rtrim(X_LAST_UPDATE_DATE)))

Line 368: INTO rec_b.LAST_UPDATE_DATE FROM sys.dual;

364:
365:
366: SELECT Decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, rec_b.LAST_UPDATE_DATE,
367: Ltrim(Rtrim(X_LAST_UPDATE_DATE)))
368: INTO rec_b.LAST_UPDATE_DATE FROM sys.dual;
369:
370: SELECT Decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, rec_b.LAST_UPDATED_BY,
371: Ltrim(Rtrim(X_LAST_UPDATED_BY)))
372: INTO rec_b.last_updated_by FROM sys.dual;

Line 372: INTO rec_b.last_updated_by FROM sys.dual;

368: INTO rec_b.LAST_UPDATE_DATE FROM sys.dual;
369:
370: SELECT Decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, rec_b.LAST_UPDATED_BY,
371: Ltrim(Rtrim(X_LAST_UPDATED_BY)))
372: INTO rec_b.last_updated_by FROM sys.dual;
373:
374: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_b.LAST_UPDATE_LOGIN,
375: Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
376: INTO rec_b.last_update_login FROM sys.dual;

Line 376: INTO rec_b.last_update_login FROM sys.dual;

372: INTO rec_b.last_updated_by FROM sys.dual;
373:
374: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_b.LAST_UPDATE_LOGIN,
375: Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
376: INTO rec_b.last_update_login FROM sys.dual;
377:
378: UPDATE CN_MODULES_ALL_B SET
379: MODULE_TYPE = rec_b.MODULE_TYPE,
380: REPOSITORY_ID = rec_b.REPOSITORY_ID,

Line 417: INTO rec_tl.NAME FROM sys.dual;

413: ELSE
414:
415: SELECT Decode(X_NAME, FND_API.G_MISS_CHAR, rec_tl.NAME,
416: Ltrim(Rtrim(X_NAME)))
417: INTO rec_tl.NAME FROM sys.dual;
418:
419: SELECT Decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, rec_tl.LAST_UPDATE_DATE,
420: Ltrim(Rtrim(X_LAST_UPDATE_DATE)))
421: INTO rec_tl.LAST_UPDATE_DATE FROM sys.dual;

Line 421: INTO rec_tl.LAST_UPDATE_DATE FROM sys.dual;

417: INTO rec_tl.NAME FROM sys.dual;
418:
419: SELECT Decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, rec_tl.LAST_UPDATE_DATE,
420: Ltrim(Rtrim(X_LAST_UPDATE_DATE)))
421: INTO rec_tl.LAST_UPDATE_DATE FROM sys.dual;
422:
423: SELECT Decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, rec_tl.LAST_UPDATED_BY,
424: Ltrim(Rtrim(X_LAST_UPDATED_BY)))
425: INTO rec_tl.last_updated_by FROM sys.dual;

Line 425: INTO rec_tl.last_updated_by FROM sys.dual;

421: INTO rec_tl.LAST_UPDATE_DATE FROM sys.dual;
422:
423: SELECT Decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, rec_tl.LAST_UPDATED_BY,
424: Ltrim(Rtrim(X_LAST_UPDATED_BY)))
425: INTO rec_tl.last_updated_by FROM sys.dual;
426:
427: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_tl.LAST_UPDATE_LOGIN,
428: Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
429: INTO rec_tl.last_update_login FROM sys.dual;

Line 429: INTO rec_tl.last_update_login FROM sys.dual;

425: INTO rec_tl.last_updated_by FROM sys.dual;
426:
427: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_tl.LAST_UPDATE_LOGIN,
428: Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
429: INTO rec_tl.last_update_login FROM sys.dual;
430:
431: UPDATE CN_MODULES_ALL_TL SET
432: NAME = rec_tl.NAME,
433: LAST_UPDATE_DATE = rec_tl.LAST_UPDATE_DATE,