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 321: l_intf_id_array dbms_sql.Number_Table;

317: (p_instance_tbl IN csi_datastructures_pub.instance_tbl
318: ,p_grp_error_tbl IN csi_datastructures_pub.grp_error_tbl)
319: IS
320: --
321: l_intf_id_array dbms_sql.Number_Table;
322: l_error_array dbms_sql.Varchar2_Table;
323: l_status_array dbms_sql.Varchar2_Table;
324: l_num_of_rows NUMBER;
325: l_upd_stmt VARCHAR2(2000);

Line 322: l_error_array dbms_sql.Varchar2_Table;

318: ,p_grp_error_tbl IN csi_datastructures_pub.grp_error_tbl)
319: IS
320: --
321: l_intf_id_array dbms_sql.Number_Table;
322: l_error_array dbms_sql.Varchar2_Table;
323: l_status_array dbms_sql.Varchar2_Table;
324: l_num_of_rows NUMBER;
325: l_upd_stmt VARCHAR2(2000);
326: l_dummy NUMBER;

Line 323: l_status_array dbms_sql.Varchar2_Table;

319: IS
320: --
321: l_intf_id_array dbms_sql.Number_Table;
322: l_error_array dbms_sql.Varchar2_Table;
323: l_status_array dbms_sql.Varchar2_Table;
324: l_num_of_rows NUMBER;
325: l_upd_stmt VARCHAR2(2000);
326: l_dummy NUMBER;
327: BEGIN

Line 347: l_num_of_rows := dbms_sql.open_cursor;

343: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE
344: SET error_text = :error_text
345: ,process_status = :status
346: WHERE inst_interface_id = :intf_id';
347: l_num_of_rows := dbms_sql.open_cursor;
348: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
349: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
350: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
351: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

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

344: SET error_text = :error_text
345: ,process_status = :status
346: WHERE inst_interface_id = :intf_id';
347: l_num_of_rows := dbms_sql.open_cursor;
348: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
349: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
350: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
351: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
352: l_dummy := dbms_sql.execute(l_num_of_rows);

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

345: ,process_status = :status
346: WHERE inst_interface_id = :intf_id';
347: l_num_of_rows := dbms_sql.open_cursor;
348: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
349: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
350: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
351: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
352: l_dummy := dbms_sql.execute(l_num_of_rows);
353: dbms_sql.close_cursor(l_num_of_rows);

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

346: WHERE inst_interface_id = :intf_id';
347: l_num_of_rows := dbms_sql.open_cursor;
348: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
349: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
350: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
351: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
352: l_dummy := dbms_sql.execute(l_num_of_rows);
353: dbms_sql.close_cursor(l_num_of_rows);
354: EXCEPTION

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

347: l_num_of_rows := dbms_sql.open_cursor;
348: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
349: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
350: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
351: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
352: l_dummy := dbms_sql.execute(l_num_of_rows);
353: dbms_sql.close_cursor(l_num_of_rows);
354: EXCEPTION
355: WHEN OTHERS THEN

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

348: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
349: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
350: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
351: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
352: l_dummy := dbms_sql.execute(l_num_of_rows);
353: dbms_sql.close_cursor(l_num_of_rows);
354: EXCEPTION
355: WHEN OTHERS THEN
356: NULL;

Line 353: dbms_sql.close_cursor(l_num_of_rows);

349: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
350: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
351: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
352: l_dummy := dbms_sql.execute(l_num_of_rows);
353: dbms_sql.close_cursor(l_num_of_rows);
354: EXCEPTION
355: WHEN OTHERS THEN
356: NULL;
357: END;

Line 366: l_intf_id_array dbms_sql.Number_Table;

362: (p_instance_tbl IN csi_datastructures_pub.instance_tbl
363: ,p_grp_upd_error_tbl IN csi_datastructures_pub.grp_upd_error_tbl)
364: IS
365: --
366: l_intf_id_array dbms_sql.Number_Table;
367: l_error_array dbms_sql.Varchar2_Table;
368: l_status_array dbms_sql.Varchar2_Table;
369: l_num_of_rows NUMBER;
370: l_upd_stmt VARCHAR2(2000);

Line 367: l_error_array dbms_sql.Varchar2_Table;

363: ,p_grp_upd_error_tbl IN csi_datastructures_pub.grp_upd_error_tbl)
364: IS
365: --
366: l_intf_id_array dbms_sql.Number_Table;
367: l_error_array dbms_sql.Varchar2_Table;
368: l_status_array dbms_sql.Varchar2_Table;
369: l_num_of_rows NUMBER;
370: l_upd_stmt VARCHAR2(2000);
371: l_dummy NUMBER;

Line 368: l_status_array dbms_sql.Varchar2_Table;

364: IS
365: --
366: l_intf_id_array dbms_sql.Number_Table;
367: l_error_array dbms_sql.Varchar2_Table;
368: l_status_array dbms_sql.Varchar2_Table;
369: l_num_of_rows NUMBER;
370: l_upd_stmt VARCHAR2(2000);
371: l_dummy NUMBER;
372: BEGIN

Line 392: l_num_of_rows := dbms_sql.open_cursor;

388: l_upd_stmt := 'UPDATE CSI_INSTANCE_INTERFACE
389: SET error_text = :error_text
390: ,process_status = :status
391: WHERE inst_interface_id = :intf_id';
392: l_num_of_rows := dbms_sql.open_cursor;
393: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
394: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
395: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
396: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

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

389: SET error_text = :error_text
390: ,process_status = :status
391: WHERE inst_interface_id = :intf_id';
392: l_num_of_rows := dbms_sql.open_cursor;
393: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
394: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
395: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
396: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
397: l_dummy := dbms_sql.execute(l_num_of_rows);

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

390: ,process_status = :status
391: WHERE inst_interface_id = :intf_id';
392: l_num_of_rows := dbms_sql.open_cursor;
393: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
394: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
395: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
396: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
397: l_dummy := dbms_sql.execute(l_num_of_rows);
398: dbms_sql.close_cursor(l_num_of_rows);

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

391: WHERE inst_interface_id = :intf_id';
392: l_num_of_rows := dbms_sql.open_cursor;
393: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
394: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
395: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
396: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
397: l_dummy := dbms_sql.execute(l_num_of_rows);
398: dbms_sql.close_cursor(l_num_of_rows);
399: EXCEPTION

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

392: l_num_of_rows := dbms_sql.open_cursor;
393: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
394: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
395: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
396: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
397: l_dummy := dbms_sql.execute(l_num_of_rows);
398: dbms_sql.close_cursor(l_num_of_rows);
399: EXCEPTION
400: WHEN OTHERS THEN

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

393: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
394: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
395: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
396: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
397: l_dummy := dbms_sql.execute(l_num_of_rows);
398: dbms_sql.close_cursor(l_num_of_rows);
399: EXCEPTION
400: WHEN OTHERS THEN
401: NULL;

Line 398: dbms_sql.close_cursor(l_num_of_rows);

394: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
395: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
396: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
397: l_dummy := dbms_sql.execute(l_num_of_rows);
398: dbms_sql.close_cursor(l_num_of_rows);
399: EXCEPTION
400: WHEN OTHERS THEN
401: NULL;
402: END;