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 FND_API

Line 318: SELECT Decode(X_MODULE_ID, FND_API.G_MISS_NUM, rec_b.module_id,

314: RAISE no_data_found;
315:
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,

Line 322: SELECT Decode(X_MODULE_TYPE, FND_API.G_MISS_CHAR, rec_b.MODULE_TYPE,

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;
325:
326: SELECT Decode(X_REPOSITORY_ID, FND_API.G_MISS_NUM, rec_b.REPOSITORY_ID,

Line 326: SELECT Decode(X_REPOSITORY_ID, FND_API.G_MISS_NUM, rec_b.REPOSITORY_ID,

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;
329:
330: SELECT Decode(X_DESCRIPTION, FND_API.G_MISS_CHAR, rec_b.DESCRIPTION,

Line 330: SELECT Decode(X_DESCRIPTION, FND_API.G_MISS_CHAR, rec_b.DESCRIPTION,

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;
333:
334: SELECT Decode(X_PARENT_MODULE_ID, FND_API.G_MISS_NUM, rec_b.PARENT_MODULE_ID,

Line 334: SELECT Decode(X_PARENT_MODULE_ID, FND_API.G_MISS_NUM, rec_b.PARENT_MODULE_ID,

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;
337:
338: SELECT Decode(X_SOURCE_REPOSITORY_ID, FND_API.G_MISS_NUM, rec_b.SOURCE_REPOSITORY_ID,Ltrim(Rtrim(X_SOURCE_REPOSITORY_ID)))

Line 338: SELECT Decode(X_SOURCE_REPOSITORY_ID, FND_API.G_MISS_NUM, rec_b.SOURCE_REPOSITORY_ID,Ltrim(Rtrim(X_SOURCE_REPOSITORY_ID)))

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:
341: SELECT Decode(X_MODULE_STATUS, FND_API.G_MISS_CHAR, rec_b.MODULE_STATUS,
342: Ltrim(Rtrim(X_MODULE_STATUS)))

Line 341: SELECT Decode(X_MODULE_STATUS, FND_API.G_MISS_CHAR, rec_b.MODULE_STATUS,

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;
344:
345: SELECT Decode(X_EVENT_ID, FND_API.G_MISS_NUM, rec_b.EVENT_ID,

Line 345: SELECT Decode(X_EVENT_ID, FND_API.G_MISS_NUM, rec_b.EVENT_ID,

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;
348:
349: SELECT Decode(X_LAST_MODIFICATION, FND_API.G_MISS_DATE, rec_b.LAST_MODIFICATION,

Line 349: SELECT Decode(X_LAST_MODIFICATION, FND_API.G_MISS_DATE, rec_b.LAST_MODIFICATION,

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;
352:
353: SELECT Decode(X_LAST_SYNCHRONIZATION, FND_API.G_MISS_DATE, rec_b.LAST_SYNCHRONIZATION,

Line 353: SELECT Decode(X_LAST_SYNCHRONIZATION, FND_API.G_MISS_DATE, rec_b.LAST_SYNCHRONIZATION,

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;
356:
357: SELECT Decode(X_OUTPUT_FILENAME, FND_API.G_MISS_CHAR, rec_b.OUTPUT_FILENAME,

Line 357: SELECT Decode(X_OUTPUT_FILENAME, FND_API.G_MISS_CHAR, rec_b.OUTPUT_FILENAME,

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;
360:
361: SELECT Decode(X_COLLECT_FLAG, FND_API.G_MISS_CHAR, rec_b.COLLECT_FLAG,

Line 361: SELECT Decode(X_COLLECT_FLAG, FND_API.G_MISS_CHAR, rec_b.COLLECT_FLAG,

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;
364:
365:

Line 366: SELECT Decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, rec_b.LAST_UPDATE_DATE,

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)))
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,

Line 370: SELECT Decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, rec_b.LAST_UPDATED_BY,

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;
373:
374: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_b.LAST_UPDATE_LOGIN,

Line 374: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_b.LAST_UPDATE_LOGIN,

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;
377:
378: UPDATE CN_MODULES_ALL_B SET

Line 415: SELECT Decode(X_NAME, FND_API.G_MISS_CHAR, rec_tl.NAME,

411: RAISE no_data_found;
412:
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,

Line 419: SELECT Decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, rec_tl.LAST_UPDATE_DATE,

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;
422:
423: SELECT Decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, rec_tl.LAST_UPDATED_BY,

Line 423: SELECT Decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, rec_tl.LAST_UPDATED_BY,

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;
426:
427: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_tl.LAST_UPDATE_LOGIN,

Line 427: SELECT Decode(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, rec_tl.LAST_UPDATE_LOGIN,

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;
430:
431: UPDATE CN_MODULES_ALL_TL SET