APPS.GMD_CREATE_FORMULA dependencies on UTL_FILE

Line 17: form_handle UTL_FILE.FILE_TYPE;

13:
14: PROCEDURE CREATE_FORMULA IS
15: formula_insert_table GMD_FORMULA_PUB.formula_insert_hdr_tbl_type;
16: form_count BINARY_INTEGER := 0;
17: form_handle UTL_FILE.FILE_TYPE;
18: line_out varchar2(2000);
19: rec_type varchar2(2000);
20: start_position NUMBER := 0;
21: end_position NUMBER := 1;

Line 40: form_handle := UTL_FILE.FOPEN('/sqlcom/log/opm115g','MPGFM.csv','R');

36: PLEASE NOTE: my file exists in /sqlcom/log/opm115m
37: This needs to be changed !!!!!!
38: */
39:
40: form_handle := UTL_FILE.FOPEN('/sqlcom/log/opm115g','MPGFM.csv','R');
41:
42: LOOP
43: UTL_FILE.GET_LINE(form_handle,line_out);
44:

Line 43: UTL_FILE.GET_LINE(form_handle,line_out);

39:
40: form_handle := UTL_FILE.FOPEN('/sqlcom/log/opm115g','MPGFM.csv','R');
41:
42: LOOP
43: UTL_FILE.GET_LINE(form_handle,line_out);
44:
45: form_count := form_count + 1;
46: start_position := 0;
47: end_position := 1;

Line 688: UTL_FILE.FCLOSE(form_handle);

684:
685:
686: EXCEPTION
687: WHEN no_data_found THEN
688: UTL_FILE.FCLOSE(form_handle);
689: time_load := DBMS_UTILITY.GET_TIME;
690:
691: GMD_FORMULA_PUB.Insert_Formula
692: ( 1.0 ,

Line 715: UTL_FILE.FCLOSE(form_handle);

711:
712:
713: WHEN OTHERS
714: THEN
715: UTL_FILE.FCLOSE(form_handle);
716:
717: END Create_Formula;
718: End GMD_CREATE_FORMULA;