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

Line 259: cur:=dbms_sql.open_cursor;

255: begin
256: TableName:=Table_Name.name;
257: PKeyName:=Table_Name.pk_name;
258: if PKeyName is not null then
259: cur:=dbms_sql.open_cursor;
260: if TableName = 'CZ_RP_ENTRIES' then
261: sqlText := 'select max(' ||PKeyName|| ') from ' || TableName || ' where object_type = ''FLD''';
262: else
263: sqlText := 'select max(' ||PKeyName|| ') from ' || TableName ;

Line 265: dbms_sql.parse(cur,sqlText,dbms_sql.native);

261: sqlText := 'select max(' ||PKeyName|| ') from ' || TableName || ' where object_type = ''FLD''';
262: else
263: sqlText := 'select max(' ||PKeyName|| ') from ' || TableName ;
264: end if;
265: dbms_sql.parse(cur,sqlText,dbms_sql.native);
266: dbms_sql.define_column(cur,1,var_key);
267: var_row:=dbms_sql.execute(cur);
268: if dbms_sql.fetch_rows(cur)>0 then
269: dbms_sql.column_value(cur,1,var_key);

Line 266: dbms_sql.define_column(cur,1,var_key);

262: else
263: sqlText := 'select max(' ||PKeyName|| ') from ' || TableName ;
264: end if;
265: dbms_sql.parse(cur,sqlText,dbms_sql.native);
266: dbms_sql.define_column(cur,1,var_key);
267: var_row:=dbms_sql.execute(cur);
268: if dbms_sql.fetch_rows(cur)>0 then
269: dbms_sql.column_value(cur,1,var_key);
270: end if;

Line 267: var_row:=dbms_sql.execute(cur);

263: sqlText := 'select max(' ||PKeyName|| ') from ' || TableName ;
264: end if;
265: dbms_sql.parse(cur,sqlText,dbms_sql.native);
266: dbms_sql.define_column(cur,1,var_key);
267: var_row:=dbms_sql.execute(cur);
268: if dbms_sql.fetch_rows(cur)>0 then
269: dbms_sql.column_value(cur,1,var_key);
270: end if;
271: dbms_sql.close_cursor(cur);

Line 268: if dbms_sql.fetch_rows(cur)>0 then

264: end if;
265: dbms_sql.parse(cur,sqlText,dbms_sql.native);
266: dbms_sql.define_column(cur,1,var_key);
267: var_row:=dbms_sql.execute(cur);
268: if dbms_sql.fetch_rows(cur)>0 then
269: dbms_sql.column_value(cur,1,var_key);
270: end if;
271: dbms_sql.close_cursor(cur);
272: end if;

Line 269: dbms_sql.column_value(cur,1,var_key);

265: dbms_sql.parse(cur,sqlText,dbms_sql.native);
266: dbms_sql.define_column(cur,1,var_key);
267: var_row:=dbms_sql.execute(cur);
268: if dbms_sql.fetch_rows(cur)>0 then
269: dbms_sql.column_value(cur,1,var_key);
270: end if;
271: dbms_sql.close_cursor(cur);
272: end if;
273: exception

Line 271: dbms_sql.close_cursor(cur);

267: var_row:=dbms_sql.execute(cur);
268: if dbms_sql.fetch_rows(cur)>0 then
269: dbms_sql.column_value(cur,1,var_key);
270: end if;
271: dbms_sql.close_cursor(cur);
272: end if;
273: exception
274: when OTHERS then
275: LOG_REPORT('.Redo_StartValue',SQLERRM);

Line 789: cur:=dbms_sql.open_cursor;

785: get_TABLE_NAMES(Subschema_Name,Tables);
786: Proc_Name:='CZ_'||Subschema_Name||'_MGR.MODIFIED';
787: for i in Tables.First..Tables.Last loop
788: begin
789: cur:=dbms_sql.open_cursor;
790: dbms_sql.parse(cur,'select max(LAST_UPDATE_DATE) from '||Tables(i).name,dbms_sql.native);
791: dbms_sql.define_column(cur,1,var_date);
792: var_row:=dbms_sql.execute(cur);
793: if dbms_sql.fetch_rows(cur)>0 then

Line 790: dbms_sql.parse(cur,'select max(LAST_UPDATE_DATE) from '||Tables(i).name,dbms_sql.native);

786: Proc_Name:='CZ_'||Subschema_Name||'_MGR.MODIFIED';
787: for i in Tables.First..Tables.Last loop
788: begin
789: cur:=dbms_sql.open_cursor;
790: dbms_sql.parse(cur,'select max(LAST_UPDATE_DATE) from '||Tables(i).name,dbms_sql.native);
791: dbms_sql.define_column(cur,1,var_date);
792: var_row:=dbms_sql.execute(cur);
793: if dbms_sql.fetch_rows(cur)>0 then
794: dbms_sql.column_value(cur,1,var_date);

Line 791: dbms_sql.define_column(cur,1,var_date);

787: for i in Tables.First..Tables.Last loop
788: begin
789: cur:=dbms_sql.open_cursor;
790: dbms_sql.parse(cur,'select max(LAST_UPDATE_DATE) from '||Tables(i).name,dbms_sql.native);
791: dbms_sql.define_column(cur,1,var_date);
792: var_row:=dbms_sql.execute(cur);
793: if dbms_sql.fetch_rows(cur)>0 then
794: dbms_sql.column_value(cur,1,var_date);
795: end if;

Line 792: var_row:=dbms_sql.execute(cur);

788: begin
789: cur:=dbms_sql.open_cursor;
790: dbms_sql.parse(cur,'select max(LAST_UPDATE_DATE) from '||Tables(i).name,dbms_sql.native);
791: dbms_sql.define_column(cur,1,var_date);
792: var_row:=dbms_sql.execute(cur);
793: if dbms_sql.fetch_rows(cur)>0 then
794: dbms_sql.column_value(cur,1,var_date);
795: end if;
796: dbms_sql.close_cursor(cur);

Line 793: if dbms_sql.fetch_rows(cur)>0 then

789: cur:=dbms_sql.open_cursor;
790: dbms_sql.parse(cur,'select max(LAST_UPDATE_DATE) from '||Tables(i).name,dbms_sql.native);
791: dbms_sql.define_column(cur,1,var_date);
792: var_row:=dbms_sql.execute(cur);
793: if dbms_sql.fetch_rows(cur)>0 then
794: dbms_sql.column_value(cur,1,var_date);
795: end if;
796: dbms_sql.close_cursor(cur);
797: if var_date>max_date then

Line 794: dbms_sql.column_value(cur,1,var_date);

790: dbms_sql.parse(cur,'select max(LAST_UPDATE_DATE) from '||Tables(i).name,dbms_sql.native);
791: dbms_sql.define_column(cur,1,var_date);
792: var_row:=dbms_sql.execute(cur);
793: if dbms_sql.fetch_rows(cur)>0 then
794: dbms_sql.column_value(cur,1,var_date);
795: end if;
796: dbms_sql.close_cursor(cur);
797: if var_date>max_date then
798: max_date:=var_date;

Line 796: dbms_sql.close_cursor(cur);

792: var_row:=dbms_sql.execute(cur);
793: if dbms_sql.fetch_rows(cur)>0 then
794: dbms_sql.column_value(cur,1,var_date);
795: end if;
796: dbms_sql.close_cursor(cur);
797: if var_date>max_date then
798: max_date:=var_date;
799: end if;
800: exception

Line 802: if dbms_sql.is_open(cur) then

798: max_date:=var_date;
799: end if;
800: exception
801: when OTHERS then
802: if dbms_sql.is_open(cur) then
803: dbms_sql.close_cursor(cur);
804: end if;
805: end;
806: end loop;

Line 803: dbms_sql.close_cursor(cur);

799: end if;
800: exception
801: when OTHERS then
802: if dbms_sql.is_open(cur) then
803: dbms_sql.close_cursor(cur);
804: end if;
805: end;
806: end loop;
807: AS_OF:=max_date;

Line 823: cur:=dbms_sql.open_cursor;

819: (stmt in varchar2) is
820: cur integer;
821: var_tempo integer;
822: begin
823: cur:=dbms_sql.open_cursor;
824: dbms_sql.parse(cur,stmt,dbms_sql.native);
825: var_tempo:=dbms_sql.execute(cur);
826: DSQL_ERROR:=0;
827: dbms_sql.close_cursor(cur);

Line 824: dbms_sql.parse(cur,stmt,dbms_sql.native);

820: cur integer;
821: var_tempo integer;
822: begin
823: cur:=dbms_sql.open_cursor;
824: dbms_sql.parse(cur,stmt,dbms_sql.native);
825: var_tempo:=dbms_sql.execute(cur);
826: DSQL_ERROR:=0;
827: dbms_sql.close_cursor(cur);
828: exception

Line 825: var_tempo:=dbms_sql.execute(cur);

821: var_tempo integer;
822: begin
823: cur:=dbms_sql.open_cursor;
824: dbms_sql.parse(cur,stmt,dbms_sql.native);
825: var_tempo:=dbms_sql.execute(cur);
826: DSQL_ERROR:=0;
827: dbms_sql.close_cursor(cur);
828: exception
829: when OTHERS then

Line 827: dbms_sql.close_cursor(cur);

823: cur:=dbms_sql.open_cursor;
824: dbms_sql.parse(cur,stmt,dbms_sql.native);
825: var_tempo:=dbms_sql.execute(cur);
826: DSQL_ERROR:=0;
827: dbms_sql.close_cursor(cur);
828: exception
829: when OTHERS then
830: LOG_REPORT('.dsql',SQLERRM);
831: DSQL_ERROR:=1;

Line 844: cur:=dbms_sql.open_cursor;

840: var_tempo integer;
841: var_stmt varchar2(10000);
842: begin
843: var_stmt:=stmt||' AND rownum<'||to_char(BATCH_SIZE);
844: cur:=dbms_sql.open_cursor;
845: dbms_sql.parse(cur,var_stmt,dbms_sql.native);
846:
847: loop
848: var_tempo:=dbms_sql.execute(cur);

Line 845: dbms_sql.parse(cur,var_stmt,dbms_sql.native);

841: var_stmt varchar2(10000);
842: begin
843: var_stmt:=stmt||' AND rownum<'||to_char(BATCH_SIZE);
844: cur:=dbms_sql.open_cursor;
845: dbms_sql.parse(cur,var_stmt,dbms_sql.native);
846:
847: loop
848: var_tempo:=dbms_sql.execute(cur);
849: if var_tempo>0 then

Line 848: var_tempo:=dbms_sql.execute(cur);

844: cur:=dbms_sql.open_cursor;
845: dbms_sql.parse(cur,var_stmt,dbms_sql.native);
846:
847: loop
848: var_tempo:=dbms_sql.execute(cur);
849: if var_tempo>0 then
850: commit;
851: else
852: exit;

Line 855: dbms_sql.close_cursor(cur);

851: else
852: exit;
853: end if;
854: end loop;
855: dbms_sql.close_cursor(cur);
856: exception
857: when OTHERS then
858: LOG_REPORT('CZ_BASE_MGR.exec','Error : '||SQLERRM||' : statement : "'||var_stmt||'"');
859: end;