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.WSMPPCPD dependencies on V$PARAMETER

Line 3421: l_full_path v$parameter.value%TYPE;

3417:
3418: e_null_param_exception EXCEPTION;
3419:
3420: -- ST Bug fix 5081436
3421: l_full_path v$parameter.value%TYPE;
3422: l_new_full_path v$parameter.value%TYPE;
3423: l_file_dir v$parameter.value%TYPE;
3424: l_debug_flag VARCHAR2(1);
3425: l_mrp_debug VARCHAR2(1);

Line 3422: l_new_full_path v$parameter.value%TYPE;

3418: e_null_param_exception EXCEPTION;
3419:
3420: -- ST Bug fix 5081436
3421: l_full_path v$parameter.value%TYPE;
3422: l_new_full_path v$parameter.value%TYPE;
3423: l_file_dir v$parameter.value%TYPE;
3424: l_debug_flag VARCHAR2(1);
3425: l_mrp_debug VARCHAR2(1);
3426: fileHandler UTL_FILE.FILE_TYPE;

Line 3423: l_file_dir v$parameter.value%TYPE;

3419:
3420: -- ST Bug fix 5081436
3421: l_full_path v$parameter.value%TYPE;
3422: l_new_full_path v$parameter.value%TYPE;
3423: l_file_dir v$parameter.value%TYPE;
3424: l_debug_flag VARCHAR2(1);
3425: l_mrp_debug VARCHAR2(1);
3426: fileHandler UTL_FILE.FILE_TYPE;
3427: -- ST Bug fix 5081436

Line 3455: FROM v$parameter

3451: IF l_mrp_debug = 'Y' THEN
3452: -- Pass on a directory from utl_file_dir
3453: SELECT value
3454: INTO l_full_path
3455: FROM v$parameter
3456: WHERE name = 'utl_file_dir';
3457:
3458: -- l_full_path contains a list of comma-separated directories
3459: WHILE(TRUE)