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

Line 2258: l_prof_val_pres VARCHAR2(1); -- to check profile value is present in utl_file_dir of v$parameter

2254: l_handler_region UTL_FILE.FILE_TYPE ; -- Added local variable as part of bug#2833850
2255: l_handler_check BOOLEAN;
2256: l_path_var VARCHAR2(80);
2257: l_req_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID(); -- returns the concurrent request id;
2258: l_prof_val_pres VARCHAR2(1); -- to check profile value is present in utl_file_dir of v$parameter
2259:
2260: -- Cursor to get room information to be exported to flat file
2261: CURSOR c_room IS
2262: SELECT room_id,building_id,room_cd,description,primary_use_cd,capacity,closed_ind

Line 2341: (output dir for export data file) matches with the value in v$parameter

2337:
2338: Date Created By : 08-MAY-2002
2339:
2340: Purpose : Private procedure to check the value of profile 'IGS_PS_EXP_DIR_PATH'
2341: (output dir for export data file) matches with the value in v$parameter
2342: for the name utl_file_dir. Called within prgp_write_ref_file procedure only.
2343:
2344: Know limitations, enhancements or remarks
2345:

Line 2356: l_dbvalue V$PARAMETER.VALUE%TYPE;

2352:
2353: l_start_str_index NUMBER := 1;
2354: l_end_comma_index NUMBER := 1;
2355: l_start_comma_index NUMBER := 1;
2356: l_dbvalue V$PARAMETER.VALUE%TYPE;
2357: l_temp V$PARAMETER.VALUE%TYPE;
2358: l_fndvalue VARCHAR2(80);
2359:
2360: CURSOR c_value IS

Line 2357: l_temp V$PARAMETER.VALUE%TYPE;

2353: l_start_str_index NUMBER := 1;
2354: l_end_comma_index NUMBER := 1;
2355: l_start_comma_index NUMBER := 1;
2356: l_dbvalue V$PARAMETER.VALUE%TYPE;
2357: l_temp V$PARAMETER.VALUE%TYPE;
2358: l_fndvalue VARCHAR2(80);
2359:
2360: CURSOR c_value IS
2361: SELECT VALUE

Line 2362: FROM V$PARAMETER

2358: l_fndvalue VARCHAR2(80);
2359:
2360: CURSOR c_value IS
2361: SELECT VALUE
2362: FROM V$PARAMETER
2363: WHERE NAME='utl_file_dir';
2364:
2365: BEGIN
2366: p_isthere := 'N';

Line 2403: l_prof_val_pres := 'N'; -- to check profile value is present in utl_file_dir of v$parameter

2399:
2400: BEGIN
2401: --adding the following code to overcome file.sql.35 warning.
2402: l_path_var := FND_PROFILE.VALUE('UTL_FILE_OUT');
2403: l_prof_val_pres := 'N'; -- to check profile value is present in utl_file_dir of v$parameter
2404:
2405: -- set the multi org id
2406: igs_ge_gen_003.set_org_id (p_org_id);
2407:

Line 2419: -- to check the value present in profile matches with that value of utl_file_dir in v$parameter

2415: RAISE invalid;
2416: END IF;
2417:
2418: -- calling private procedure
2419: -- to check the value present in profile matches with that value of utl_file_dir in v$parameter
2420: prof_value_pres_pvt(l_prof_val_pres);
2421: IF l_prof_val_pres = 'N' THEN
2422: l_message :='IGS_PS_OUT_DIR_NOT_FOUND';
2423: RAISE dirnotfound;