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

Line 1820: l_rel_id_array dbms_sql.Number_Table;

1816: )
1817: IS
1818: l_exists VARCHAR2(1);
1819: l_quantity NUMBER;
1820: l_rel_id_array dbms_sql.Number_Table;
1821: l_status_array dbms_sql.Varchar2_Table;
1822: l_error_array dbms_sql.Varchar2_Table;
1823: l_iface_error_text VARCHAR2(2000);
1824: rel_row NUMBER;

Line 1821: l_status_array dbms_sql.Varchar2_Table;

1817: IS
1818: l_exists VARCHAR2(1);
1819: l_quantity NUMBER;
1820: l_rel_id_array dbms_sql.Number_Table;
1821: l_status_array dbms_sql.Varchar2_Table;
1822: l_error_array dbms_sql.Varchar2_Table;
1823: l_iface_error_text VARCHAR2(2000);
1824: rel_row NUMBER;
1825: l_upd_stmt VARCHAR2(2000);

Line 1822: l_error_array dbms_sql.Varchar2_Table;

1818: l_exists VARCHAR2(1);
1819: l_quantity NUMBER;
1820: l_rel_id_array dbms_sql.Number_Table;
1821: l_status_array dbms_sql.Varchar2_Table;
1822: l_error_array dbms_sql.Varchar2_Table;
1823: l_iface_error_text VARCHAR2(2000);
1824: rel_row NUMBER;
1825: l_upd_stmt VARCHAR2(2000);
1826: l_num_of_rows NUMBER;

Line 2365: l_num_of_rows := dbms_sql.open_cursor;

2361: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2362: SET error_text = :error_text
2363: ,process_status = :status
2364: WHERE rel_interface_id = :intf_id';
2365: l_num_of_rows := dbms_sql.open_cursor;
2366: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2367: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2368: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2369: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

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

2362: SET error_text = :error_text
2363: ,process_status = :status
2364: WHERE rel_interface_id = :intf_id';
2365: l_num_of_rows := dbms_sql.open_cursor;
2366: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2367: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2368: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2369: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2370: l_dummy := dbms_sql.execute(l_num_of_rows);

Line 2367: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);

2363: ,process_status = :status
2364: WHERE rel_interface_id = :intf_id';
2365: l_num_of_rows := dbms_sql.open_cursor;
2366: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2367: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2368: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2369: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2370: l_dummy := dbms_sql.execute(l_num_of_rows);
2371: dbms_sql.close_cursor(l_num_of_rows);

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

2364: WHERE rel_interface_id = :intf_id';
2365: l_num_of_rows := dbms_sql.open_cursor;
2366: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2367: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2368: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2369: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2370: l_dummy := dbms_sql.execute(l_num_of_rows);
2371: dbms_sql.close_cursor(l_num_of_rows);
2372: EXCEPTION

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

2365: l_num_of_rows := dbms_sql.open_cursor;
2366: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2367: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2368: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2369: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2370: l_dummy := dbms_sql.execute(l_num_of_rows);
2371: dbms_sql.close_cursor(l_num_of_rows);
2372: EXCEPTION
2373: WHEN OTHERS THEN

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

2366: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2367: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2368: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2369: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2370: l_dummy := dbms_sql.execute(l_num_of_rows);
2371: dbms_sql.close_cursor(l_num_of_rows);
2372: EXCEPTION
2373: WHEN OTHERS THEN
2374: NULL;

Line 2371: dbms_sql.close_cursor(l_num_of_rows);

2367: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2368: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2369: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2370: l_dummy := dbms_sql.execute(l_num_of_rows);
2371: dbms_sql.close_cursor(l_num_of_rows);
2372: EXCEPTION
2373: WHEN OTHERS THEN
2374: NULL;
2375: END;

Line 2536: l_num_of_rows := dbms_sql.open_cursor;

2532: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2533: SET error_text = :error_text
2534: ,process_status = :status
2535: WHERE rel_interface_id = :intf_id';
2536: l_num_of_rows := dbms_sql.open_cursor;
2537: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2538: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2539: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2540: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

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

2533: SET error_text = :error_text
2534: ,process_status = :status
2535: WHERE rel_interface_id = :intf_id';
2536: l_num_of_rows := dbms_sql.open_cursor;
2537: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2538: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2539: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2540: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2541: l_dummy := dbms_sql.execute(l_num_of_rows);

Line 2538: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);

2534: ,process_status = :status
2535: WHERE rel_interface_id = :intf_id';
2536: l_num_of_rows := dbms_sql.open_cursor;
2537: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2538: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2539: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2540: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2541: l_dummy := dbms_sql.execute(l_num_of_rows);
2542: dbms_sql.close_cursor(l_num_of_rows);

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

2535: WHERE rel_interface_id = :intf_id';
2536: l_num_of_rows := dbms_sql.open_cursor;
2537: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2538: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2539: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2540: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2541: l_dummy := dbms_sql.execute(l_num_of_rows);
2542: dbms_sql.close_cursor(l_num_of_rows);
2543: EXCEPTION

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

2536: l_num_of_rows := dbms_sql.open_cursor;
2537: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2538: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2539: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2540: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2541: l_dummy := dbms_sql.execute(l_num_of_rows);
2542: dbms_sql.close_cursor(l_num_of_rows);
2543: EXCEPTION
2544: WHEN OTHERS THEN

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

2537: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2538: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2539: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2540: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2541: l_dummy := dbms_sql.execute(l_num_of_rows);
2542: dbms_sql.close_cursor(l_num_of_rows);
2543: EXCEPTION
2544: WHEN OTHERS THEN
2545: NULL;

Line 2542: dbms_sql.close_cursor(l_num_of_rows);

2538: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2539: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2540: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2541: l_dummy := dbms_sql.execute(l_num_of_rows);
2542: dbms_sql.close_cursor(l_num_of_rows);
2543: EXCEPTION
2544: WHEN OTHERS THEN
2545: NULL;
2546: END;

Line 2687: l_num_of_rows := dbms_sql.open_cursor;

2683: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2684: SET error_text = :error_text
2685: ,process_status = :status
2686: WHERE rel_interface_id = :intf_id';
2687: l_num_of_rows := dbms_sql.open_cursor;
2688: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2689: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2690: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2691: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

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

2684: SET error_text = :error_text
2685: ,process_status = :status
2686: WHERE rel_interface_id = :intf_id';
2687: l_num_of_rows := dbms_sql.open_cursor;
2688: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2689: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2690: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2691: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2692: l_dummy := dbms_sql.execute(l_num_of_rows);

Line 2689: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);

2685: ,process_status = :status
2686: WHERE rel_interface_id = :intf_id';
2687: l_num_of_rows := dbms_sql.open_cursor;
2688: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2689: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2690: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2691: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2692: l_dummy := dbms_sql.execute(l_num_of_rows);
2693: dbms_sql.close_cursor(l_num_of_rows);

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

2686: WHERE rel_interface_id = :intf_id';
2687: l_num_of_rows := dbms_sql.open_cursor;
2688: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2689: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2690: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2691: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2692: l_dummy := dbms_sql.execute(l_num_of_rows);
2693: dbms_sql.close_cursor(l_num_of_rows);
2694: EXCEPTION

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

2687: l_num_of_rows := dbms_sql.open_cursor;
2688: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2689: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2690: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2691: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2692: l_dummy := dbms_sql.execute(l_num_of_rows);
2693: dbms_sql.close_cursor(l_num_of_rows);
2694: EXCEPTION
2695: WHEN OTHERS THEN

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

2688: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2689: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2690: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2691: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2692: l_dummy := dbms_sql.execute(l_num_of_rows);
2693: dbms_sql.close_cursor(l_num_of_rows);
2694: EXCEPTION
2695: WHEN OTHERS THEN
2696: NULL;

Line 2693: dbms_sql.close_cursor(l_num_of_rows);

2689: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2690: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2691: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
2692: l_dummy := dbms_sql.execute(l_num_of_rows);
2693: dbms_sql.close_cursor(l_num_of_rows);
2694: EXCEPTION
2695: WHEN OTHERS THEN
2696: NULL;
2697: END;

Line 2921: l_num_of_rows := dbms_sql.open_cursor;

2917: BEGIN
2918: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2919: SET process_status = :status
2920: WHERE rel_interface_id = :intf_id';
2921: l_num_of_rows := dbms_sql.open_cursor;
2922: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2923: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2924: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2925: l_dummy := dbms_sql.execute(l_num_of_rows);

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

2918: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2919: SET process_status = :status
2920: WHERE rel_interface_id = :intf_id';
2921: l_num_of_rows := dbms_sql.open_cursor;
2922: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2923: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2924: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2925: l_dummy := dbms_sql.execute(l_num_of_rows);
2926: dbms_sql.close_cursor(l_num_of_rows);

Line 2923: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);

2919: SET process_status = :status
2920: WHERE rel_interface_id = :intf_id';
2921: l_num_of_rows := dbms_sql.open_cursor;
2922: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2923: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2924: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2925: l_dummy := dbms_sql.execute(l_num_of_rows);
2926: dbms_sql.close_cursor(l_num_of_rows);
2927: EXCEPTION

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

2920: WHERE rel_interface_id = :intf_id';
2921: l_num_of_rows := dbms_sql.open_cursor;
2922: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2923: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2924: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2925: l_dummy := dbms_sql.execute(l_num_of_rows);
2926: dbms_sql.close_cursor(l_num_of_rows);
2927: EXCEPTION
2928: WHEN OTHERS THEN

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

2921: l_num_of_rows := dbms_sql.open_cursor;
2922: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2923: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2924: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2925: l_dummy := dbms_sql.execute(l_num_of_rows);
2926: dbms_sql.close_cursor(l_num_of_rows);
2927: EXCEPTION
2928: WHEN OTHERS THEN
2929: NULL;

Line 2926: dbms_sql.close_cursor(l_num_of_rows);

2922: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
2923: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
2924: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
2925: l_dummy := dbms_sql.execute(l_num_of_rows);
2926: dbms_sql.close_cursor(l_num_of_rows);
2927: EXCEPTION
2928: WHEN OTHERS THEN
2929: NULL;
2930: END;

Line 3119: l_rel_id_array dbms_sql.Number_Table;

3115: FROM csi_ii_relation_interface
3116: WHERE process_status='R';
3117: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
3118: l_error BOOLEAN :=FALSE;
3119: l_rel_id_array dbms_sql.Number_Table;
3120: l_status_array dbms_sql.Varchar2_Table;
3121: l_error_array dbms_sql.Varchar2_Table;
3122: l_num_of_rows NUMBER;
3123: l_dummy NUMBER;

Line 3120: l_status_array dbms_sql.Varchar2_Table;

3116: WHERE process_status='R';
3117: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
3118: l_error BOOLEAN :=FALSE;
3119: l_rel_id_array dbms_sql.Number_Table;
3120: l_status_array dbms_sql.Varchar2_Table;
3121: l_error_array dbms_sql.Varchar2_Table;
3122: l_num_of_rows NUMBER;
3123: l_dummy NUMBER;
3124: rel_row NUMBER;

Line 3121: l_error_array dbms_sql.Varchar2_Table;

3117: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
3118: l_error BOOLEAN :=FALSE;
3119: l_rel_id_array dbms_sql.Number_Table;
3120: l_status_array dbms_sql.Varchar2_Table;
3121: l_error_array dbms_sql.Varchar2_Table;
3122: l_num_of_rows NUMBER;
3123: l_dummy NUMBER;
3124: rel_row NUMBER;
3125: l_upd_stmt VARCHAR2(2000);

Line 3165: l_num_of_rows := dbms_sql.open_cursor;

3161: SET process_status = :status
3162: ,error_text = :error_text
3163: ,parallel_worker_id =0
3164: WHERE rel_interface_id = :intf_id';
3165: l_num_of_rows := dbms_sql.open_cursor;
3166: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
3167: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
3168: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
3169: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

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

3162: ,error_text = :error_text
3163: ,parallel_worker_id =0
3164: WHERE rel_interface_id = :intf_id';
3165: l_num_of_rows := dbms_sql.open_cursor;
3166: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
3167: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
3168: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
3169: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
3170: l_dummy := dbms_sql.execute(l_num_of_rows);

Line 3167: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);

3163: ,parallel_worker_id =0
3164: WHERE rel_interface_id = :intf_id';
3165: l_num_of_rows := dbms_sql.open_cursor;
3166: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
3167: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
3168: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
3169: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
3170: l_dummy := dbms_sql.execute(l_num_of_rows);
3171: dbms_sql.close_cursor(l_num_of_rows);

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

3164: WHERE rel_interface_id = :intf_id';
3165: l_num_of_rows := dbms_sql.open_cursor;
3166: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
3167: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
3168: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
3169: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
3170: l_dummy := dbms_sql.execute(l_num_of_rows);
3171: dbms_sql.close_cursor(l_num_of_rows);
3172: EXCEPTION

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

3165: l_num_of_rows := dbms_sql.open_cursor;
3166: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
3167: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
3168: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
3169: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
3170: l_dummy := dbms_sql.execute(l_num_of_rows);
3171: dbms_sql.close_cursor(l_num_of_rows);
3172: EXCEPTION
3173: WHEN OTHERS THEN

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

3166: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
3167: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
3168: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
3169: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
3170: l_dummy := dbms_sql.execute(l_num_of_rows);
3171: dbms_sql.close_cursor(l_num_of_rows);
3172: EXCEPTION
3173: WHEN OTHERS THEN
3174: NULL;

Line 3171: dbms_sql.close_cursor(l_num_of_rows);

3167: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_rel_id_array);
3168: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
3169: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
3170: l_dummy := dbms_sql.execute(l_num_of_rows);
3171: dbms_sql.close_cursor(l_num_of_rows);
3172: EXCEPTION
3173: WHEN OTHERS THEN
3174: NULL;
3175: END;