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.CN_SCA_RULES_BATCH_GEN_PVT dependencies on DBMS_SQL

Line 763: sqlstring dbms_sql.varchar2s;

759: l_dummy VARCHAR2(500);
760: l_dev_phase VARCHAR2(80);
761: l_dev_status VARCHAR2(80) := 'INCOMPLETE';
762: l_status BOOLEAN;
763: sqlstring dbms_sql.varchar2s;
764: empty_sqlstring dbms_sql.varchar2s;
765: cursor1 INTEGER;
766: i INTEGER;
767: j INTEGER;

Line 764: empty_sqlstring dbms_sql.varchar2s;

760: l_dev_phase VARCHAR2(80);
761: l_dev_status VARCHAR2(80) := 'INCOMPLETE';
762: l_status BOOLEAN;
763: sqlstring dbms_sql.varchar2s;
764: empty_sqlstring dbms_sql.varchar2s;
765: cursor1 INTEGER;
766: i INTEGER;
767: j INTEGER;
768: new_line_flag BOOLEAN:=TRUE;

Line 827: cursor1:=DBMS_SQL.OPEN_CURSOR;

823:
824: i:=1;
825: j:= sqlstring.count;
826:
827: cursor1:=DBMS_SQL.OPEN_CURSOR;
828: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
829: retval:=DBMS_SQL.EXECUTE(cursor1);
830: DBMS_SQL.CLOSE_CURSOR(cursor1);
831:

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

824: i:=1;
825: j:= sqlstring.count;
826:
827: cursor1:=DBMS_SQL.OPEN_CURSOR;
828: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
829: retval:=DBMS_SQL.EXECUTE(cursor1);
830: DBMS_SQL.CLOSE_CURSOR(cursor1);
831:
832: sqlstring := empty_sqlstring;

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

825: j:= sqlstring.count;
826:
827: cursor1:=DBMS_SQL.OPEN_CURSOR;
828: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
829: retval:=DBMS_SQL.EXECUTE(cursor1);
830: DBMS_SQL.CLOSE_CURSOR(cursor1);
831:
832: sqlstring := empty_sqlstring;
833:

Line 830: DBMS_SQL.CLOSE_CURSOR(cursor1);

826:
827: cursor1:=DBMS_SQL.OPEN_CURSOR;
828: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
829: retval:=DBMS_SQL.EXECUTE(cursor1);
830: DBMS_SQL.CLOSE_CURSOR(cursor1);
831:
832: sqlstring := empty_sqlstring;
833:
834: SELECT co.object_id

Line 852: cursor1:=DBMS_SQL.OPEN_CURSOR;

848:
849: i:= 1;
850: j:= sqlstring.count;
851:
852: cursor1:=DBMS_SQL.OPEN_CURSOR;
853: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
854: retval:=DBMS_SQL.EXECUTE(cursor1);
855: DBMS_SQL.CLOSE_CURSOR(cursor1);
856:

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

849: i:= 1;
850: j:= sqlstring.count;
851:
852: cursor1:=DBMS_SQL.OPEN_CURSOR;
853: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
854: retval:=DBMS_SQL.EXECUTE(cursor1);
855: DBMS_SQL.CLOSE_CURSOR(cursor1);
856:
857: cn_message_pkg.debug('The rule dynamic package is created successfully. Continue to intall the package. ');

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

850: j:= sqlstring.count;
851:
852: cursor1:=DBMS_SQL.OPEN_CURSOR;
853: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
854: retval:=DBMS_SQL.EXECUTE(cursor1);
855: DBMS_SQL.CLOSE_CURSOR(cursor1);
856:
857: cn_message_pkg.debug('The rule dynamic package is created successfully. Continue to intall the package. ');
858: fnd_file.put_line(fnd_file.Log, 'The rule dynamic package is created successfully. Continue to intall the package.');

Line 855: DBMS_SQL.CLOSE_CURSOR(cursor1);

851:
852: cursor1:=DBMS_SQL.OPEN_CURSOR;
853: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
854: retval:=DBMS_SQL.EXECUTE(cursor1);
855: DBMS_SQL.CLOSE_CURSOR(cursor1);
856:
857: cn_message_pkg.debug('The rule dynamic package is created successfully. Continue to intall the package. ');
858: fnd_file.put_line(fnd_file.Log, 'The rule dynamic package is created successfully. Continue to intall the package.');
859: --dbms_output.put_line('The rule dynamic package is created successfully. ' );