APPS.WMS_UT_PKG dependencies on UTL_FILE

Line 2998: inputfile UTL_FILE.FILE_TYPE;

2994: p_overwrite IN VARCHAR2)
2995: IS
2996: l_file_text chartabtype150;
2997: l_text_line VARCHAR2(150);
2998: inputfile UTL_FILE.FILE_TYPE;
2999: BEGIN
3000:
3001: --inputfile := utl_file.fopen(p_path, p_file, 'r');
3002: inputfile := utl_file.fopen(p_path, p_file, 'r');

Line 3001: --inputfile := utl_file.fopen(p_path, p_file, 'r');

2997: l_text_line VARCHAR2(150);
2998: inputfile UTL_FILE.FILE_TYPE;
2999: BEGIN
3000:
3001: --inputfile := utl_file.fopen(p_path, p_file, 'r');
3002: inputfile := utl_file.fopen(p_path, p_file, 'r');
3003:
3004: LOOP
3005: BEGIN

Line 3002: inputfile := utl_file.fopen(p_path, p_file, 'r');

2998: inputfile UTL_FILE.FILE_TYPE;
2999: BEGIN
3000:
3001: --inputfile := utl_file.fopen(p_path, p_file, 'r');
3002: inputfile := utl_file.fopen(p_path, p_file, 'r');
3003:
3004: LOOP
3005: BEGIN
3006: UTL_FILE.GET_LINE(inputfile, l_text_line);

Line 3006: UTL_FILE.GET_LINE(inputfile, l_text_line);

3002: inputfile := utl_file.fopen(p_path, p_file, 'r');
3003:
3004: LOOP
3005: BEGIN
3006: UTL_FILE.GET_LINE(inputfile, l_text_line);
3007: l_file_text(l_file_text.count + 1) := l_text_line;
3008: EXCEPTION
3009: WHEN NO_DATA_FOUND THEN
3010: EXIT;

Line 3016: utl_file.fclose(inputfile);

3012: END LOOP;
3013:
3014: import_test_cases(l_file_text, p_overwrite);
3015:
3016: utl_file.fclose(inputfile);
3017:
3018: END;
3019:
3020: /*

Line 3038: outputfile UTL_FILE.FILE_TYPE;

3034: t_rec l_tests;
3035:
3036: l_file_text chartabtype150;
3037: l_text_line VARCHAR2(150);
3038: outputfile UTL_FILE.FILE_TYPE;
3039: l_last_testset_id NUMBER := -1;
3040: l_last_test_id NUMBER := -1;
3041:
3042: --p_cur_tests wms_ut_pkg.cur_tests;

Line 3056: --outputfile := utl_file.fopen(p_path || '/' || p_file, 'w');

3052: BEGIN
3053:
3054:
3055: IF p_overwrite THEN
3056: --outputfile := utl_file.fopen(p_path || '/' || p_file, 'w');
3057: print_debug('Opening File to write cases');
3058: ELSE
3059: --outputfile := utl_file.fopen(p_path || '/' || p_file, 'a');
3060: print_debug('Opening File to append cases');

Line 3059: --outputfile := utl_file.fopen(p_path || '/' || p_file, 'a');

3055: IF p_overwrite THEN
3056: --outputfile := utl_file.fopen(p_path || '/' || p_file, 'w');
3057: print_debug('Opening File to write cases');
3058: ELSE
3059: --outputfile := utl_file.fopen(p_path || '/' || p_file, 'a');
3060: print_debug('Opening File to append cases');
3061: END IF;
3062:
3063: FOR t_rec in c_tests LOOP

Line 3068: UTL_FILE.PUT_LINE(outputfile, 'SET : ' || t_rec.testset);

3064: --WHILE TRUE LOOP
3065: -- FETCH p_cur_tests into t_rec;
3066: -- EXIT WHEN t_rec.testset_id is NULL;
3067: IF l_last_testset_id <> t_rec.testset_id THEN
3068: UTL_FILE.PUT_LINE(outputfile, 'SET : ' || t_rec.testset);
3069: l_last_testset_id := t_rec.testset_id;
3070: END IF;
3071: IF l_last_test_id <> t_rec.test_id THEN
3072: UTL_FILE.PUT_LINE(outputfile, 'TEST : ' || t_rec.testname);

Line 3072: UTL_FILE.PUT_LINE(outputfile, 'TEST : ' || t_rec.testname);

3068: UTL_FILE.PUT_LINE(outputfile, 'SET : ' || t_rec.testset);
3069: l_last_testset_id := t_rec.testset_id;
3070: END IF;
3071: IF l_last_test_id <> t_rec.test_id THEN
3072: UTL_FILE.PUT_LINE(outputfile, 'TEST : ' || t_rec.testname);
3073: l_last_test_id := t_rec.test_id;
3074: END IF;
3075: UTL_FILE.PUT_LINE(outputfile, t_rec.test_text);
3076: END LOOP;

Line 3075: UTL_FILE.PUT_LINE(outputfile, t_rec.test_text);

3071: IF l_last_test_id <> t_rec.test_id THEN
3072: UTL_FILE.PUT_LINE(outputfile, 'TEST : ' || t_rec.testname);
3073: l_last_test_id := t_rec.test_id;
3074: END IF;
3075: UTL_FILE.PUT_LINE(outputfile, t_rec.test_text);
3076: END LOOP;
3077: --close p_cur_tests;
3078: utl_file.fclose(outputfile);
3079:

Line 3078: utl_file.fclose(outputfile);

3074: END IF;
3075: UTL_FILE.PUT_LINE(outputfile, t_rec.test_text);
3076: END LOOP;
3077: --close p_cur_tests;
3078: utl_file.fclose(outputfile);
3079:
3080: END;
3081: ---
3082: Procedure copy_test (p_from_test_id IN NUMBER,