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

Line 1213: cur:=dbms_sql.open_cursor;

1209: var_schema:=NULL;
1210: ELSE
1211: var_schema:=cz_schema||'.';
1212: END IF;
1213: cur:=dbms_sql.open_cursor;
1214: stmt:='SELECT setting_id,value from '||var_schema||'CZ_DB_SETTINGS WHERE section_name like '''||section_name||
1215: ''' and setting_id like '''||setting_id||''' ';
1216:
1217: dbms_sql.parse(cur,stmt,dbms_sql.native);

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

1213: cur:=dbms_sql.open_cursor;
1214: stmt:='SELECT setting_id,value from '||var_schema||'CZ_DB_SETTINGS WHERE section_name like '''||section_name||
1215: ''' and setting_id like '''||setting_id||''' ';
1216:
1217: dbms_sql.parse(cur,stmt,dbms_sql.native);
1218: dbms_sql.define_column(cur,1,var_setting_id,40);
1219: dbms_sql.define_column(cur,2,var_value,300);
1220: var_row:=dbms_sql.execute(cur);
1221: WHILE (dbms_sql.fetch_rows(cur)>0) LOOP

Line 1218: dbms_sql.define_column(cur,1,var_setting_id,40);

1214: stmt:='SELECT setting_id,value from '||var_schema||'CZ_DB_SETTINGS WHERE section_name like '''||section_name||
1215: ''' and setting_id like '''||setting_id||''' ';
1216:
1217: dbms_sql.parse(cur,stmt,dbms_sql.native);
1218: dbms_sql.define_column(cur,1,var_setting_id,40);
1219: dbms_sql.define_column(cur,2,var_value,300);
1220: var_row:=dbms_sql.execute(cur);
1221: WHILE (dbms_sql.fetch_rows(cur)>0) LOOP
1222: dbms_sql.column_value(cur,1,var_setting_id);

Line 1219: dbms_sql.define_column(cur,2,var_value,300);

1215: ''' and setting_id like '''||setting_id||''' ';
1216:
1217: dbms_sql.parse(cur,stmt,dbms_sql.native);
1218: dbms_sql.define_column(cur,1,var_setting_id,40);
1219: dbms_sql.define_column(cur,2,var_value,300);
1220: var_row:=dbms_sql.execute(cur);
1221: WHILE (dbms_sql.fetch_rows(cur)>0) LOOP
1222: dbms_sql.column_value(cur,1,var_setting_id);
1223: dbms_sql.column_value(cur,2,var_value);

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

1216:
1217: dbms_sql.parse(cur,stmt,dbms_sql.native);
1218: dbms_sql.define_column(cur,1,var_setting_id,40);
1219: dbms_sql.define_column(cur,2,var_value,300);
1220: var_row:=dbms_sql.execute(cur);
1221: WHILE (dbms_sql.fetch_rows(cur)>0) LOOP
1222: dbms_sql.column_value(cur,1,var_setting_id);
1223: dbms_sql.column_value(cur,2,var_value);
1224: LOG_REPORT(rpad(var_setting_id,40)||var_value);

Line 1221: WHILE (dbms_sql.fetch_rows(cur)>0) LOOP

1217: dbms_sql.parse(cur,stmt,dbms_sql.native);
1218: dbms_sql.define_column(cur,1,var_setting_id,40);
1219: dbms_sql.define_column(cur,2,var_value,300);
1220: var_row:=dbms_sql.execute(cur);
1221: WHILE (dbms_sql.fetch_rows(cur)>0) LOOP
1222: dbms_sql.column_value(cur,1,var_setting_id);
1223: dbms_sql.column_value(cur,2,var_value);
1224: LOG_REPORT(rpad(var_setting_id,40)||var_value);
1225: END LOOP;

Line 1222: dbms_sql.column_value(cur,1,var_setting_id);

1218: dbms_sql.define_column(cur,1,var_setting_id,40);
1219: dbms_sql.define_column(cur,2,var_value,300);
1220: var_row:=dbms_sql.execute(cur);
1221: WHILE (dbms_sql.fetch_rows(cur)>0) LOOP
1222: dbms_sql.column_value(cur,1,var_setting_id);
1223: dbms_sql.column_value(cur,2,var_value);
1224: LOG_REPORT(rpad(var_setting_id,40)||var_value);
1225: END LOOP;
1226: dbms_sql.close_cursor(cur);

Line 1223: dbms_sql.column_value(cur,2,var_value);

1219: dbms_sql.define_column(cur,2,var_value,300);
1220: var_row:=dbms_sql.execute(cur);
1221: WHILE (dbms_sql.fetch_rows(cur)>0) LOOP
1222: dbms_sql.column_value(cur,1,var_setting_id);
1223: dbms_sql.column_value(cur,2,var_value);
1224: LOG_REPORT(rpad(var_setting_id,40)||var_value);
1225: END LOOP;
1226: dbms_sql.close_cursor(cur);
1227: EXCEPTION

Line 1226: dbms_sql.close_cursor(cur);

1222: dbms_sql.column_value(cur,1,var_setting_id);
1223: dbms_sql.column_value(cur,2,var_value);
1224: LOG_REPORT(rpad(var_setting_id,40)||var_value);
1225: END LOOP;
1226: dbms_sql.close_cursor(cur);
1227: EXCEPTION
1228: WHEN OTHERS THEN
1229: LOG_REPORT(SQLERRM);
1230: END;

Line 1564: v_cur := dbms_sql.open_cursor;

1560: get_App_Info('INV', v_fndnam_link_name, v_inv_oracle_schema);
1561: v_string := 'select count(*) from all_tab_columns'||v_fndnam_link_name||
1562: ' where owner='''||v_inv_oracle_schema||''' AND table_name like ''MTL_SYSTEM_ITEMS%''
1563: and column_name = ''INDIVISIBLE_FLAG''';
1564: v_cur := dbms_sql.open_cursor;
1565: dbms_sql.parse(v_cur, v_string, dbms_sql.native);
1566: dbms_sql.define_column(v_cur,1,v_count);
1567: v_res := dbms_sql.execute(v_cur);
1568: if (dbms_sql.fetch_rows(v_cur) > 0) then

Line 1565: dbms_sql.parse(v_cur, v_string, dbms_sql.native);

1561: v_string := 'select count(*) from all_tab_columns'||v_fndnam_link_name||
1562: ' where owner='''||v_inv_oracle_schema||''' AND table_name like ''MTL_SYSTEM_ITEMS%''
1563: and column_name = ''INDIVISIBLE_FLAG''';
1564: v_cur := dbms_sql.open_cursor;
1565: dbms_sql.parse(v_cur, v_string, dbms_sql.native);
1566: dbms_sql.define_column(v_cur,1,v_count);
1567: v_res := dbms_sql.execute(v_cur);
1568: if (dbms_sql.fetch_rows(v_cur) > 0) then
1569: dbms_sql.column_value(v_cur,1,v_count);

Line 1566: dbms_sql.define_column(v_cur,1,v_count);

1562: ' where owner='''||v_inv_oracle_schema||''' AND table_name like ''MTL_SYSTEM_ITEMS%''
1563: and column_name = ''INDIVISIBLE_FLAG''';
1564: v_cur := dbms_sql.open_cursor;
1565: dbms_sql.parse(v_cur, v_string, dbms_sql.native);
1566: dbms_sql.define_column(v_cur,1,v_count);
1567: v_res := dbms_sql.execute(v_cur);
1568: if (dbms_sql.fetch_rows(v_cur) > 0) then
1569: dbms_sql.column_value(v_cur,1,v_count);
1570: end if;

Line 1567: v_res := dbms_sql.execute(v_cur);

1563: and column_name = ''INDIVISIBLE_FLAG''';
1564: v_cur := dbms_sql.open_cursor;
1565: dbms_sql.parse(v_cur, v_string, dbms_sql.native);
1566: dbms_sql.define_column(v_cur,1,v_count);
1567: v_res := dbms_sql.execute(v_cur);
1568: if (dbms_sql.fetch_rows(v_cur) > 0) then
1569: dbms_sql.column_value(v_cur,1,v_count);
1570: end if;
1571: dbms_sql.close_cursor(v_cur);

Line 1568: if (dbms_sql.fetch_rows(v_cur) > 0) then

1564: v_cur := dbms_sql.open_cursor;
1565: dbms_sql.parse(v_cur, v_string, dbms_sql.native);
1566: dbms_sql.define_column(v_cur,1,v_count);
1567: v_res := dbms_sql.execute(v_cur);
1568: if (dbms_sql.fetch_rows(v_cur) > 0) then
1569: dbms_sql.column_value(v_cur,1,v_count);
1570: end if;
1571: dbms_sql.close_cursor(v_cur);
1572:

Line 1569: dbms_sql.column_value(v_cur,1,v_count);

1565: dbms_sql.parse(v_cur, v_string, dbms_sql.native);
1566: dbms_sql.define_column(v_cur,1,v_count);
1567: v_res := dbms_sql.execute(v_cur);
1568: if (dbms_sql.fetch_rows(v_cur) > 0) then
1569: dbms_sql.column_value(v_cur,1,v_count);
1570: end if;
1571: dbms_sql.close_cursor(v_cur);
1572:
1573: IF (v_count = 0) THEN

Line 1571: dbms_sql.close_cursor(v_cur);

1567: v_res := dbms_sql.execute(v_cur);
1568: if (dbms_sql.fetch_rows(v_cur) > 0) then
1569: dbms_sql.column_value(v_cur,1,v_count);
1570: end if;
1571: dbms_sql.close_cursor(v_cur);
1572:
1573: IF (v_count = 0) THEN
1574: -- version 10
1575: v_versioned_string := ' ''Y'' INDIVISIBLE_FLAG';

Line 1587: if (dbms_sql.is_open(v_cur)) then

1583: END IF;
1584:
1585: EXCEPTION
1586: WHEN OTHERS THEN
1587: if (dbms_sql.is_open(v_cur)) then
1588: dbms_sql.close_cursor(v_cur);
1589: end if;
1590: END;
1591:

Line 1588: dbms_sql.close_cursor(v_cur);

1584:
1585: EXCEPTION
1586: WHEN OTHERS THEN
1587: if (dbms_sql.is_open(v_cur)) then
1588: dbms_sql.close_cursor(v_cur);
1589: end if;
1590: END;
1591:
1592: -- Check version of apps for existence of comms_nl_trackable_flag in mtl_system_items

Line 2716: v_cur := dbms_sql.open_cursor;

2712:
2713: BEGIN
2714: v_newString := 'SELECT version INTO :v_server_db_version FROM V$INSTANCE@' || v_fndnam_link_name ;
2715: -- || ' WHERE database_status in (''ACTIVE'', ''OPEN'') ';
2716: v_cur := dbms_sql.open_cursor;
2717: dbms_sql.parse(v_cur,v_newString,dbms_sql.native);
2718: dbms_sql.define_column(v_cur,1,v_server_db_version,40);
2719: v_res:=dbms_sql.execute(v_cur);
2720:

Line 2717: dbms_sql.parse(v_cur,v_newString,dbms_sql.native);

2713: BEGIN
2714: v_newString := 'SELECT version INTO :v_server_db_version FROM V$INSTANCE@' || v_fndnam_link_name ;
2715: -- || ' WHERE database_status in (''ACTIVE'', ''OPEN'') ';
2716: v_cur := dbms_sql.open_cursor;
2717: dbms_sql.parse(v_cur,v_newString,dbms_sql.native);
2718: dbms_sql.define_column(v_cur,1,v_server_db_version,40);
2719: v_res:=dbms_sql.execute(v_cur);
2720:
2721: if (dbms_sql.fetch_rows(v_cur) > 0) then

Line 2718: dbms_sql.define_column(v_cur,1,v_server_db_version,40);

2714: v_newString := 'SELECT version INTO :v_server_db_version FROM V$INSTANCE@' || v_fndnam_link_name ;
2715: -- || ' WHERE database_status in (''ACTIVE'', ''OPEN'') ';
2716: v_cur := dbms_sql.open_cursor;
2717: dbms_sql.parse(v_cur,v_newString,dbms_sql.native);
2718: dbms_sql.define_column(v_cur,1,v_server_db_version,40);
2719: v_res:=dbms_sql.execute(v_cur);
2720:
2721: if (dbms_sql.fetch_rows(v_cur) > 0) then
2722: dbms_sql.column_value(v_cur,1,v_server_db_version);

Line 2719: v_res:=dbms_sql.execute(v_cur);

2715: -- || ' WHERE database_status in (''ACTIVE'', ''OPEN'') ';
2716: v_cur := dbms_sql.open_cursor;
2717: dbms_sql.parse(v_cur,v_newString,dbms_sql.native);
2718: dbms_sql.define_column(v_cur,1,v_server_db_version,40);
2719: v_res:=dbms_sql.execute(v_cur);
2720:
2721: if (dbms_sql.fetch_rows(v_cur) > 0) then
2722: dbms_sql.column_value(v_cur,1,v_server_db_version);
2723: end if;

Line 2721: if (dbms_sql.fetch_rows(v_cur) > 0) then

2717: dbms_sql.parse(v_cur,v_newString,dbms_sql.native);
2718: dbms_sql.define_column(v_cur,1,v_server_db_version,40);
2719: v_res:=dbms_sql.execute(v_cur);
2720:
2721: if (dbms_sql.fetch_rows(v_cur) > 0) then
2722: dbms_sql.column_value(v_cur,1,v_server_db_version);
2723: end if;
2724: dbms_sql.close_cursor(v_cur);
2725: EXCEPTION

Line 2722: dbms_sql.column_value(v_cur,1,v_server_db_version);

2718: dbms_sql.define_column(v_cur,1,v_server_db_version,40);
2719: v_res:=dbms_sql.execute(v_cur);
2720:
2721: if (dbms_sql.fetch_rows(v_cur) > 0) then
2722: dbms_sql.column_value(v_cur,1,v_server_db_version);
2723: end if;
2724: dbms_sql.close_cursor(v_cur);
2725: EXCEPTION
2726: WHEN OTHERS THEN

Line 2724: dbms_sql.close_cursor(v_cur);

2720:
2721: if (dbms_sql.fetch_rows(v_cur) > 0) then
2722: dbms_sql.column_value(v_cur,1,v_server_db_version);
2723: end if;
2724: dbms_sql.close_cursor(v_cur);
2725: EXCEPTION
2726: WHEN OTHERS THEN
2727: errbuf := cz_utils.get_text('CZ_DB_VERSION_NOT_FOUND', 'SQLERRM', Sqlerrm);
2728: Retcode := 1;