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_ONLINE_GEN_PVT dependencies on DBMS_SQL

Line 569: sqlstring dbms_sql.varchar2s;

565: l_dummy VARCHAR2(500);
566: l_dev_phase VARCHAR2(80);
567: l_dev_status VARCHAR2(80) := 'INCOMPLETE';
568: l_status BOOLEAN;
569: sqlstring dbms_sql.varchar2s;
570: empty_sqlstring dbms_sql.varchar2s;
571: cursor1 INTEGER;
572: i INTEGER;
573: j INTEGER;

Line 570: empty_sqlstring dbms_sql.varchar2s;

566: l_dev_phase VARCHAR2(80);
567: l_dev_status VARCHAR2(80) := 'INCOMPLETE';
568: l_status BOOLEAN;
569: sqlstring dbms_sql.varchar2s;
570: empty_sqlstring dbms_sql.varchar2s;
571: cursor1 INTEGER;
572: i INTEGER;
573: j INTEGER;
574: new_line_flag BOOLEAN:=TRUE;

Line 629: cursor1:=DBMS_SQL.OPEN_CURSOR;

625:
626: i:=1;
627: j:= sqlstring.count;
628:
629: cursor1:=DBMS_SQL.OPEN_CURSOR;
630: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
631: retval:=DBMS_SQL.EXECUTE(cursor1);
632: DBMS_SQL.CLOSE_CURSOR(cursor1);
633:

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

626: i:=1;
627: j:= sqlstring.count;
628:
629: cursor1:=DBMS_SQL.OPEN_CURSOR;
630: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
631: retval:=DBMS_SQL.EXECUTE(cursor1);
632: DBMS_SQL.CLOSE_CURSOR(cursor1);
633:
634: sqlstring := empty_sqlstring;

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

627: j:= sqlstring.count;
628:
629: cursor1:=DBMS_SQL.OPEN_CURSOR;
630: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
631: retval:=DBMS_SQL.EXECUTE(cursor1);
632: DBMS_SQL.CLOSE_CURSOR(cursor1);
633:
634: sqlstring := empty_sqlstring;
635:

Line 632: DBMS_SQL.CLOSE_CURSOR(cursor1);

628:
629: cursor1:=DBMS_SQL.OPEN_CURSOR;
630: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
631: retval:=DBMS_SQL.EXECUTE(cursor1);
632: DBMS_SQL.CLOSE_CURSOR(cursor1);
633:
634: sqlstring := empty_sqlstring;
635:
636: SELECT co.object_id

Line 654: cursor1:=DBMS_SQL.OPEN_CURSOR;

650:
651: i:= 1;
652: j:= sqlstring.count;
653:
654: cursor1:=DBMS_SQL.OPEN_CURSOR;
655: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
656: retval:=DBMS_SQL.EXECUTE(cursor1);
657: DBMS_SQL.CLOSE_CURSOR(cursor1);
658:

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

651: i:= 1;
652: j:= sqlstring.count;
653:
654: cursor1:=DBMS_SQL.OPEN_CURSOR;
655: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
656: retval:=DBMS_SQL.EXECUTE(cursor1);
657: DBMS_SQL.CLOSE_CURSOR(cursor1);
658:
659: cn_message_pkg.debug('The rule dynamic package is created successfully. Continue to intall the package. ');

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

652: j:= sqlstring.count;
653:
654: cursor1:=DBMS_SQL.OPEN_CURSOR;
655: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
656: retval:=DBMS_SQL.EXECUTE(cursor1);
657: DBMS_SQL.CLOSE_CURSOR(cursor1);
658:
659: cn_message_pkg.debug('The rule dynamic package is created successfully. Continue to intall the package. ');
660: fnd_file.put_line(fnd_file.Log, 'The rule dynamic package is created successfully. Continue to intall the package.');

Line 657: DBMS_SQL.CLOSE_CURSOR(cursor1);

653:
654: cursor1:=DBMS_SQL.OPEN_CURSOR;
655: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
656: retval:=DBMS_SQL.EXECUTE(cursor1);
657: DBMS_SQL.CLOSE_CURSOR(cursor1);
658:
659: cn_message_pkg.debug('The rule dynamic package is created successfully. Continue to intall the package. ');
660: fnd_file.put_line(fnd_file.Log, 'The rule dynamic package is created successfully. Continue to intall the package.');
661: