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 260: cur:=dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

Line 272: dbms_sql.close_cursor(cur);

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

Line 794: cur:=dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

795: dbms_sql.parse(cur,'select max(LAST_UPDATE_DATE) from '||Tables(i).name,dbms_sql.native);
796: dbms_sql.define_column(cur,1,var_date);
797: var_row:=dbms_sql.execute(cur);
798: if dbms_sql.fetch_rows(cur)>0 then
799: dbms_sql.column_value(cur,1,var_date);
800: end if;
801: dbms_sql.close_cursor(cur);
802: if var_date>max_date then
803: max_date:=var_date;

Line 801: dbms_sql.close_cursor(cur);

797: var_row:=dbms_sql.execute(cur);
798: if dbms_sql.fetch_rows(cur)>0 then
799: dbms_sql.column_value(cur,1,var_date);
800: end if;
801: dbms_sql.close_cursor(cur);
802: if var_date>max_date then
803: max_date:=var_date;
804: end if;
805: exception

Line 807: if dbms_sql.is_open(cur) then

803: max_date:=var_date;
804: end if;
805: exception
806: when OTHERS then
807: if dbms_sql.is_open(cur) then
808: dbms_sql.close_cursor(cur);
809: end if;
810: end;
811: end loop;

Line 808: dbms_sql.close_cursor(cur);

804: end if;
805: exception
806: when OTHERS then
807: if dbms_sql.is_open(cur) then
808: dbms_sql.close_cursor(cur);
809: end if;
810: end;
811: end loop;
812: AS_OF:=max_date;

Line 828: cur:=dbms_sql.open_cursor;

824: (stmt in varchar2) is
825: cur integer;
826: var_tempo integer;
827: begin
828: cur:=dbms_sql.open_cursor;
829: dbms_sql.parse(cur,stmt,dbms_sql.native);
830: var_tempo:=dbms_sql.execute(cur);
831: DSQL_ERROR:=0;
832: dbms_sql.close_cursor(cur);

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

825: cur integer;
826: var_tempo integer;
827: begin
828: cur:=dbms_sql.open_cursor;
829: dbms_sql.parse(cur,stmt,dbms_sql.native);
830: var_tempo:=dbms_sql.execute(cur);
831: DSQL_ERROR:=0;
832: dbms_sql.close_cursor(cur);
833: exception

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

826: var_tempo integer;
827: begin
828: cur:=dbms_sql.open_cursor;
829: dbms_sql.parse(cur,stmt,dbms_sql.native);
830: var_tempo:=dbms_sql.execute(cur);
831: DSQL_ERROR:=0;
832: dbms_sql.close_cursor(cur);
833: exception
834: when OTHERS then

Line 832: dbms_sql.close_cursor(cur);

828: cur:=dbms_sql.open_cursor;
829: dbms_sql.parse(cur,stmt,dbms_sql.native);
830: var_tempo:=dbms_sql.execute(cur);
831: DSQL_ERROR:=0;
832: dbms_sql.close_cursor(cur);
833: exception
834: when OTHERS then
835: LOG_REPORT('.dsql',SQLERRM);
836: DSQL_ERROR:=1;

Line 849: cur:=dbms_sql.open_cursor;

845: var_tempo integer;
846: var_stmt varchar2(10000);
847: begin
848: var_stmt:=stmt||' AND rownum<'||to_char(BATCH_SIZE);
849: cur:=dbms_sql.open_cursor;
850: dbms_sql.parse(cur,var_stmt,dbms_sql.native);
851:
852: loop
853: var_tempo:=dbms_sql.execute(cur);

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

846: var_stmt varchar2(10000);
847: begin
848: var_stmt:=stmt||' AND rownum<'||to_char(BATCH_SIZE);
849: cur:=dbms_sql.open_cursor;
850: dbms_sql.parse(cur,var_stmt,dbms_sql.native);
851:
852: loop
853: var_tempo:=dbms_sql.execute(cur);
854: if var_tempo>0 then

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

849: cur:=dbms_sql.open_cursor;
850: dbms_sql.parse(cur,var_stmt,dbms_sql.native);
851:
852: loop
853: var_tempo:=dbms_sql.execute(cur);
854: if var_tempo>0 then
855: commit;
856: else
857: exit;

Line 860: dbms_sql.close_cursor(cur);

856: else
857: exit;
858: end if;
859: end loop;
860: dbms_sql.close_cursor(cur);
861: exception
862: when OTHERS then
863: LOG_REPORT('CZ_BASE_MGR.exec','Error : '||SQLERRM||' : statement : "'||var_stmt||'"');
864: end;