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

Line 1881: FROM DUAL

1877: --Can't use the status of the run so see if any bundles exist in a non-finished status or have
1878: --workers
1879: SELECT 1
1880: INTO l_temp
1881: FROM DUAL
1882: WHERE EXISTS (SELECT 1
1883: FROM fnd_oam_dscram_bundles
1884: WHERE run_id = p_run_id
1885: AND (workers_assigned > 0 OR bundle_status NOT IN (FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,

Line 2462: p_src_text => 'SELECT SYSDATE FROM DUAL',

2458: IF NOT MAKE_ARG(p_arg_name => FND_OAM_DSCRAM_UTILS_PKG.G_ARG_INTERNAL_PREFIX||l_testnum||'_RUN_DYNARG2',
2459: p_parent_id => p_run_id,
2460: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE,
2461: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL,
2462: p_src_text => 'SELECT SYSDATE FROM DUAL',
2463: x_arg_id => l_retval) THEN
2464: RAISE INIT_FAILED;
2465: END IF;
2466:

Line 2472: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',

2468: IF NOT MAKE_ARG(p_arg_name => FND_OAM_DSCRAM_UTILS_PKG.G_ARG_INTERNAL_PREFIX||l_testnum||'_RUN_DYNARG3',
2469: p_parent_id => p_run_id,
2470: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
2471: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL,
2472: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',
2473: x_arg_id => l_retval) THEN
2474: RAISE INIT_FAILED;
2475: END IF;
2476:

Line 2484: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',

2480: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
2481: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
2482: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
2483: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL,
2484: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',
2485: x_arg_id => l_retval) THEN
2486: RAISE INIT_FAILED;
2487: END IF;
2488:

Line 2496: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',

2492: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
2493: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
2494: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_WORKER,
2495: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL,
2496: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',
2497: x_arg_id => l_retval) THEN
2498: RAISE INIT_FAILED;
2499: END IF;
2500:

Line 2508: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',

2504: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
2505: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
2506: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ALWAYS,
2507: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL,
2508: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',
2509: x_arg_id => l_retval) THEN
2510: RAISE INIT_FAILED;
2511: END IF;
2512:

Line 2520: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',

2516: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
2517: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
2518: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE,
2519: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL_RESTRICTABLE,
2520: p_src_text => 'SELECT to_char(SYSTIMESTAMP, ''HH24:MI:SS.FF'') FROM DUAL',
2521: x_arg_id => l_retval) THEN
2522: RAISE INIT_FAILED;
2523: END IF;
2524:

Line 2525: --create a dynamic run arg, sourcing the rowid from dual, no write

2521: x_arg_id => l_retval) THEN
2522: RAISE INIT_FAILED;
2523: END IF;
2524:
2525: --create a dynamic run arg, sourcing the rowid from dual, no write
2526: IF NOT MAKE_ARG(p_arg_name => FND_OAM_DSCRAM_UTILS_PKG.G_ARG_INTERNAL_PREFIX||l_testnum||'_RUN_DYNARG8',
2527: p_parent_id => p_run_id,
2528: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
2529: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ,

Line 2531: p_src_text => 'SELECT ROWID FROM DUAL',

2527: p_parent_id => p_run_id,
2528: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_ROWID,
2529: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ,
2530: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL_RESTRICTABLE,
2531: p_src_text => 'SELECT ROWID FROM DUAL',
2532: x_arg_id => l_retval) THEN
2533: RAISE INIT_FAILED;
2534: END IF;
2535:

Line 3491: p_src_text => 'SELECT FND_DATE.CANONICAL_TO_DATE('''||l_c4_val||''') FROM dual',

3487: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_DATE,
3488: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
3489: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_ONCE,
3490: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL,
3491: p_src_text => 'SELECT FND_DATE.CANONICAL_TO_DATE('''||l_c4_val||''') FROM dual',
3492: p_src_where_clause => NULL,
3493: x_arg_id => l_c4_run_in_id) THEN
3494: RAISE INIT_FAILED;
3495: END IF;

Line 3564: p_src_text => 'SELECT '''||l_c3_val||''' FROM DUAL',

3560: p_datatype => FND_OAM_DSCRAM_UTILS_PKG.G_DATATYPE_VARCHAR2,
3561: p_permissions => FND_OAM_DSCRAM_UTILS_PKG.G_PERMISSION_READ_WRITE,
3562: p_write_policy => FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_WORKER,
3563: p_src_type => FND_OAM_DSCRAM_UTILS_PKG.G_SOURCE_SQL,
3564: p_src_text => 'SELECT '''||l_c3_val||''' FROM DUAL',
3565: x_arg_id => l_c3_arg_in_id) THEN
3566: RAISE INIT_FAILED;
3567: END IF;
3568: --make an output arg for the C3 arg