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

Line 327: l_intf_id_array dbms_sql.Number_Table;

323: (p_instance_tbl IN csi_datastructures_pub.instance_tbl
324: ,p_grp_error_tbl IN csi_datastructures_pub.grp_error_tbl)
325: IS
326: --
327: l_intf_id_array dbms_sql.Number_Table;
328: l_error_array dbms_sql.Varchar2_Table;
329: l_status_array dbms_sql.Varchar2_Table;
330: l_num_of_rows NUMBER;
331: l_upd_stmt VARCHAR2(2000);

Line 328: l_error_array dbms_sql.Varchar2_Table;

324: ,p_grp_error_tbl IN csi_datastructures_pub.grp_error_tbl)
325: IS
326: --
327: l_intf_id_array dbms_sql.Number_Table;
328: l_error_array dbms_sql.Varchar2_Table;
329: l_status_array dbms_sql.Varchar2_Table;
330: l_num_of_rows NUMBER;
331: l_upd_stmt VARCHAR2(2000);
332: l_dummy NUMBER;

Line 329: l_status_array dbms_sql.Varchar2_Table;

325: IS
326: --
327: l_intf_id_array dbms_sql.Number_Table;
328: l_error_array dbms_sql.Varchar2_Table;
329: l_status_array dbms_sql.Varchar2_Table;
330: l_num_of_rows NUMBER;
331: l_upd_stmt VARCHAR2(2000);
332: l_dummy NUMBER;
333: BEGIN

Line 353: l_num_of_rows := dbms_sql.open_cursor;

349: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE
350: SET error_text = :error_text
351: ,process_status = :status
352: WHERE inst_interface_id = :intf_id';
353: l_num_of_rows := dbms_sql.open_cursor;
354: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
355: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
356: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
357: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

Line 354: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);

350: SET error_text = :error_text
351: ,process_status = :status
352: WHERE inst_interface_id = :intf_id';
353: l_num_of_rows := dbms_sql.open_cursor;
354: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
355: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
356: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
357: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
358: l_dummy := dbms_sql.execute(l_num_of_rows);

Line 355: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);

351: ,process_status = :status
352: WHERE inst_interface_id = :intf_id';
353: l_num_of_rows := dbms_sql.open_cursor;
354: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
355: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
356: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
357: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
358: l_dummy := dbms_sql.execute(l_num_of_rows);
359: dbms_sql.close_cursor(l_num_of_rows);

Line 356: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);

352: WHERE inst_interface_id = :intf_id';
353: l_num_of_rows := dbms_sql.open_cursor;
354: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
355: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
356: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
357: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
358: l_dummy := dbms_sql.execute(l_num_of_rows);
359: dbms_sql.close_cursor(l_num_of_rows);
360: EXCEPTION

Line 357: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

353: l_num_of_rows := dbms_sql.open_cursor;
354: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
355: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
356: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
357: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
358: l_dummy := dbms_sql.execute(l_num_of_rows);
359: dbms_sql.close_cursor(l_num_of_rows);
360: EXCEPTION
361: WHEN OTHERS THEN

Line 358: l_dummy := dbms_sql.execute(l_num_of_rows);

354: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
355: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
356: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
357: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
358: l_dummy := dbms_sql.execute(l_num_of_rows);
359: dbms_sql.close_cursor(l_num_of_rows);
360: EXCEPTION
361: WHEN OTHERS THEN
362: NULL;

Line 359: dbms_sql.close_cursor(l_num_of_rows);

355: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
356: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
357: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
358: l_dummy := dbms_sql.execute(l_num_of_rows);
359: dbms_sql.close_cursor(l_num_of_rows);
360: EXCEPTION
361: WHEN OTHERS THEN
362: NULL;
363: END;

Line 372: l_intf_id_array dbms_sql.Number_Table;

368: (p_instance_tbl IN csi_datastructures_pub.instance_tbl
369: ,p_grp_upd_error_tbl IN csi_datastructures_pub.grp_upd_error_tbl)
370: IS
371: --
372: l_intf_id_array dbms_sql.Number_Table;
373: l_error_array dbms_sql.Varchar2_Table;
374: l_status_array dbms_sql.Varchar2_Table;
375: l_num_of_rows NUMBER;
376: l_upd_stmt VARCHAR2(2000);

Line 373: l_error_array dbms_sql.Varchar2_Table;

369: ,p_grp_upd_error_tbl IN csi_datastructures_pub.grp_upd_error_tbl)
370: IS
371: --
372: l_intf_id_array dbms_sql.Number_Table;
373: l_error_array dbms_sql.Varchar2_Table;
374: l_status_array dbms_sql.Varchar2_Table;
375: l_num_of_rows NUMBER;
376: l_upd_stmt VARCHAR2(2000);
377: l_dummy NUMBER;

Line 374: l_status_array dbms_sql.Varchar2_Table;

370: IS
371: --
372: l_intf_id_array dbms_sql.Number_Table;
373: l_error_array dbms_sql.Varchar2_Table;
374: l_status_array dbms_sql.Varchar2_Table;
375: l_num_of_rows NUMBER;
376: l_upd_stmt VARCHAR2(2000);
377: l_dummy NUMBER;
378: BEGIN

Line 398: l_num_of_rows := dbms_sql.open_cursor;

394: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE
395: SET error_text = :error_text
396: ,process_status = :status
397: WHERE inst_interface_id = :intf_id';
398: l_num_of_rows := dbms_sql.open_cursor;
399: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
400: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
401: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
402: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

Line 399: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);

395: SET error_text = :error_text
396: ,process_status = :status
397: WHERE inst_interface_id = :intf_id';
398: l_num_of_rows := dbms_sql.open_cursor;
399: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
400: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
401: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
402: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
403: l_dummy := dbms_sql.execute(l_num_of_rows);

Line 400: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);

396: ,process_status = :status
397: WHERE inst_interface_id = :intf_id';
398: l_num_of_rows := dbms_sql.open_cursor;
399: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
400: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
401: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
402: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
403: l_dummy := dbms_sql.execute(l_num_of_rows);
404: dbms_sql.close_cursor(l_num_of_rows);

Line 401: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);

397: WHERE inst_interface_id = :intf_id';
398: l_num_of_rows := dbms_sql.open_cursor;
399: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
400: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
401: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
402: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
403: l_dummy := dbms_sql.execute(l_num_of_rows);
404: dbms_sql.close_cursor(l_num_of_rows);
405: EXCEPTION

Line 402: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

398: l_num_of_rows := dbms_sql.open_cursor;
399: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
400: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
401: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
402: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
403: l_dummy := dbms_sql.execute(l_num_of_rows);
404: dbms_sql.close_cursor(l_num_of_rows);
405: EXCEPTION
406: WHEN OTHERS THEN

Line 403: l_dummy := dbms_sql.execute(l_num_of_rows);

399: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
400: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
401: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
402: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
403: l_dummy := dbms_sql.execute(l_num_of_rows);
404: dbms_sql.close_cursor(l_num_of_rows);
405: EXCEPTION
406: WHEN OTHERS THEN
407: NULL;

Line 404: dbms_sql.close_cursor(l_num_of_rows);

400: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
401: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
402: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
403: l_dummy := dbms_sql.execute(l_num_of_rows);
404: dbms_sql.close_cursor(l_num_of_rows);
405: EXCEPTION
406: WHEN OTHERS THEN
407: NULL;
408: END;