APPS.CN_FORMULA_GEN_PKG dependencies on DBMS_SQL

Line 5018: sqlstring dbms_sql.varchar2s;

5014: l_dev_phase VARCHAR2(80);
5015: l_dev_status VARCHAR2(80) := 'INCOMPLETE';
5016: l_status BOOLEAN;
5017:
5018: sqlstring dbms_sql.varchar2s;
5019: empty_sqlstring dbms_sql.varchar2s;
5020: cursor1 INTEGER;
5021: i INTEGER;
5022:

Line 5019: empty_sqlstring dbms_sql.varchar2s;

5015: l_dev_status VARCHAR2(80) := 'INCOMPLETE';
5016: l_status BOOLEAN;
5017:
5018: sqlstring dbms_sql.varchar2s;
5019: empty_sqlstring dbms_sql.varchar2s;
5020: cursor1 INTEGER;
5021: i INTEGER;
5022:
5023: j INTEGER;

Line 5090: cursor1:=DBMS_SQL.OPEN_CURSOR;

5086:
5087: i:=1;
5088: j:= sqlstring.count;
5089:
5090: cursor1:=DBMS_SQL.OPEN_CURSOR;
5091: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
5092: retval:=DBMS_SQL.EXECUTE(cursor1);
5093: DBMS_SQL.CLOSE_CURSOR(cursor1);
5094:

Line 5091: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);

5087: i:=1;
5088: j:= sqlstring.count;
5089:
5090: cursor1:=DBMS_SQL.OPEN_CURSOR;
5091: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
5092: retval:=DBMS_SQL.EXECUTE(cursor1);
5093: DBMS_SQL.CLOSE_CURSOR(cursor1);
5094:
5095: sqlstring := empty_sqlstring;

Line 5092: retval:=DBMS_SQL.EXECUTE(cursor1);

5088: j:= sqlstring.count;
5089:
5090: cursor1:=DBMS_SQL.OPEN_CURSOR;
5091: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
5092: retval:=DBMS_SQL.EXECUTE(cursor1);
5093: DBMS_SQL.CLOSE_CURSOR(cursor1);
5094:
5095: sqlstring := empty_sqlstring;
5096:

Line 5093: DBMS_SQL.CLOSE_CURSOR(cursor1);

5089:
5090: cursor1:=DBMS_SQL.OPEN_CURSOR;
5091: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
5092: retval:=DBMS_SQL.EXECUTE(cursor1);
5093: DBMS_SQL.CLOSE_CURSOR(cursor1);
5094:
5095: sqlstring := empty_sqlstring;
5096:
5097: SELECT co.object_id

Line 5113: cursor1:=DBMS_SQL.OPEN_CURSOR;

5109:
5110: i:= 1;
5111: j:= sqlstring.count;
5112:
5113: cursor1:=DBMS_SQL.OPEN_CURSOR;
5114: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
5115: retval:=DBMS_SQL.EXECUTE(cursor1);
5116: DBMS_SQL.CLOSE_CURSOR(cursor1);
5117:

Line 5114: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);

5110: i:= 1;
5111: j:= sqlstring.count;
5112:
5113: cursor1:=DBMS_SQL.OPEN_CURSOR;
5114: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
5115: retval:=DBMS_SQL.EXECUTE(cursor1);
5116: DBMS_SQL.CLOSE_CURSOR(cursor1);
5117:
5118: -- check whether package is installed successfully

Line 5115: retval:=DBMS_SQL.EXECUTE(cursor1);

5111: j:= sqlstring.count;
5112:
5113: cursor1:=DBMS_SQL.OPEN_CURSOR;
5114: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
5115: retval:=DBMS_SQL.EXECUTE(cursor1);
5116: DBMS_SQL.CLOSE_CURSOR(cursor1);
5117:
5118: -- check whether package is installed successfully
5119: SELECT COUNT(*)

Line 5116: DBMS_SQL.CLOSE_CURSOR(cursor1);

5112:
5113: cursor1:=DBMS_SQL.OPEN_CURSOR;
5114: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
5115: retval:=DBMS_SQL.EXECUTE(cursor1);
5116: DBMS_SQL.CLOSE_CURSOR(cursor1);
5117:
5118: -- check whether package is installed successfully
5119: SELECT COUNT(*)
5120: INTO l_error_count