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

Line 28: v_cursor_handle INTEGER := dbms_sql.open_cursor;

24: )
25: IS
26: --
27: v_upd_stmt VARCHAR2(2000);
28: v_cursor_handle INTEGER := dbms_sql.open_cursor;
29: v_num_of_rows NUMBER;
30: BEGIN
31: v_upd_stmt := 'UPDATE '||p_intf_table||' SET ERROR_TEXT = :l_error_text'
32: ||' ,PROCESS_STATUS = :l_status'

Line 35: dbms_sql.parse(v_cursor_handle,v_upd_stmt,dbms_sql.NATIVE);

31: v_upd_stmt := 'UPDATE '||p_intf_table||' SET ERROR_TEXT = :l_error_text'
32: ||' ,PROCESS_STATUS = :l_status'
33: ||' ,INSTANCE_ID = :l_instance_id'
34: ||' WHERE '||p_intf_col_name||' = :l_intf_id';
35: dbms_sql.parse(v_cursor_handle,v_upd_stmt,dbms_sql.NATIVE);
36: dbms_sql.bind_variable(v_cursor_handle,':l_error_text',p_error_text);
37: dbms_sql.bind_variable(v_cursor_handle,':l_status',p_status);
38: dbms_sql.bind_variable(v_cursor_handle,':l_instance_id',p_instance_id);
39: dbms_sql.bind_variable(v_cursor_handle,':l_intf_id',p_intf_id);

Line 36: dbms_sql.bind_variable(v_cursor_handle,':l_error_text',p_error_text);

32: ||' ,PROCESS_STATUS = :l_status'
33: ||' ,INSTANCE_ID = :l_instance_id'
34: ||' WHERE '||p_intf_col_name||' = :l_intf_id';
35: dbms_sql.parse(v_cursor_handle,v_upd_stmt,dbms_sql.NATIVE);
36: dbms_sql.bind_variable(v_cursor_handle,':l_error_text',p_error_text);
37: dbms_sql.bind_variable(v_cursor_handle,':l_status',p_status);
38: dbms_sql.bind_variable(v_cursor_handle,':l_instance_id',p_instance_id);
39: dbms_sql.bind_variable(v_cursor_handle,':l_intf_id',p_intf_id);
40: v_num_of_rows := dbms_sql.execute(v_cursor_handle);

Line 37: dbms_sql.bind_variable(v_cursor_handle,':l_status',p_status);

33: ||' ,INSTANCE_ID = :l_instance_id'
34: ||' WHERE '||p_intf_col_name||' = :l_intf_id';
35: dbms_sql.parse(v_cursor_handle,v_upd_stmt,dbms_sql.NATIVE);
36: dbms_sql.bind_variable(v_cursor_handle,':l_error_text',p_error_text);
37: dbms_sql.bind_variable(v_cursor_handle,':l_status',p_status);
38: dbms_sql.bind_variable(v_cursor_handle,':l_instance_id',p_instance_id);
39: dbms_sql.bind_variable(v_cursor_handle,':l_intf_id',p_intf_id);
40: v_num_of_rows := dbms_sql.execute(v_cursor_handle);
41: dbms_sql.close_cursor(v_cursor_handle);

Line 38: dbms_sql.bind_variable(v_cursor_handle,':l_instance_id',p_instance_id);

34: ||' WHERE '||p_intf_col_name||' = :l_intf_id';
35: dbms_sql.parse(v_cursor_handle,v_upd_stmt,dbms_sql.NATIVE);
36: dbms_sql.bind_variable(v_cursor_handle,':l_error_text',p_error_text);
37: dbms_sql.bind_variable(v_cursor_handle,':l_status',p_status);
38: dbms_sql.bind_variable(v_cursor_handle,':l_instance_id',p_instance_id);
39: dbms_sql.bind_variable(v_cursor_handle,':l_intf_id',p_intf_id);
40: v_num_of_rows := dbms_sql.execute(v_cursor_handle);
41: dbms_sql.close_cursor(v_cursor_handle);
42: EXCEPTION

Line 39: dbms_sql.bind_variable(v_cursor_handle,':l_intf_id',p_intf_id);

35: dbms_sql.parse(v_cursor_handle,v_upd_stmt,dbms_sql.NATIVE);
36: dbms_sql.bind_variable(v_cursor_handle,':l_error_text',p_error_text);
37: dbms_sql.bind_variable(v_cursor_handle,':l_status',p_status);
38: dbms_sql.bind_variable(v_cursor_handle,':l_instance_id',p_instance_id);
39: dbms_sql.bind_variable(v_cursor_handle,':l_intf_id',p_intf_id);
40: v_num_of_rows := dbms_sql.execute(v_cursor_handle);
41: dbms_sql.close_cursor(v_cursor_handle);
42: EXCEPTION
43: WHEN OTHERS THEN

Line 40: v_num_of_rows := dbms_sql.execute(v_cursor_handle);

36: dbms_sql.bind_variable(v_cursor_handle,':l_error_text',p_error_text);
37: dbms_sql.bind_variable(v_cursor_handle,':l_status',p_status);
38: dbms_sql.bind_variable(v_cursor_handle,':l_instance_id',p_instance_id);
39: dbms_sql.bind_variable(v_cursor_handle,':l_intf_id',p_intf_id);
40: v_num_of_rows := dbms_sql.execute(v_cursor_handle);
41: dbms_sql.close_cursor(v_cursor_handle);
42: EXCEPTION
43: WHEN OTHERS THEN
44: NULL;

Line 41: dbms_sql.close_cursor(v_cursor_handle);

37: dbms_sql.bind_variable(v_cursor_handle,':l_status',p_status);
38: dbms_sql.bind_variable(v_cursor_handle,':l_instance_id',p_instance_id);
39: dbms_sql.bind_variable(v_cursor_handle,':l_intf_id',p_intf_id);
40: v_num_of_rows := dbms_sql.execute(v_cursor_handle);
41: dbms_sql.close_cursor(v_cursor_handle);
42: EXCEPTION
43: WHEN OTHERS THEN
44: NULL;
45: END Update_Interface_Table;

Line 5903: l_txn_exists_tbl dbms_sql.Number_Table;

5899: l_bulk_ext_count NUMBER := 0;
5900: l_bulk_asset_count NUMBER := 0;
5901: l_owner_count NUMBER := 0;
5902: --
5903: l_txn_exists_tbl dbms_sql.Number_Table;
5904: l_intf_id_array dbms_sql.Number_Table;
5905: l_inst_id_array dbms_sql.Number_Table;
5906: l_status_array dbms_sql.Varchar2_Table;
5907: l_error_array dbms_sql.Varchar2_Table;

Line 5904: l_intf_id_array dbms_sql.Number_Table;

5900: l_bulk_asset_count NUMBER := 0;
5901: l_owner_count NUMBER := 0;
5902: --
5903: l_txn_exists_tbl dbms_sql.Number_Table;
5904: l_intf_id_array dbms_sql.Number_Table;
5905: l_inst_id_array dbms_sql.Number_Table;
5906: l_status_array dbms_sql.Varchar2_Table;
5907: l_error_array dbms_sql.Varchar2_Table;
5908: l_num_of_rows NUMBER;

Line 5905: l_inst_id_array dbms_sql.Number_Table;

5901: l_owner_count NUMBER := 0;
5902: --
5903: l_txn_exists_tbl dbms_sql.Number_Table;
5904: l_intf_id_array dbms_sql.Number_Table;
5905: l_inst_id_array dbms_sql.Number_Table;
5906: l_status_array dbms_sql.Varchar2_Table;
5907: l_error_array dbms_sql.Varchar2_Table;
5908: l_num_of_rows NUMBER;
5909: l_upd_stmt VARCHAR2(2000);

Line 5906: l_status_array dbms_sql.Varchar2_Table;

5902: --
5903: l_txn_exists_tbl dbms_sql.Number_Table;
5904: l_intf_id_array dbms_sql.Number_Table;
5905: l_inst_id_array dbms_sql.Number_Table;
5906: l_status_array dbms_sql.Varchar2_Table;
5907: l_error_array dbms_sql.Varchar2_Table;
5908: l_num_of_rows NUMBER;
5909: l_upd_stmt VARCHAR2(2000);
5910: l_dummy NUMBER;

Line 5907: l_error_array dbms_sql.Varchar2_Table;

5903: l_txn_exists_tbl dbms_sql.Number_Table;
5904: l_intf_id_array dbms_sql.Number_Table;
5905: l_inst_id_array dbms_sql.Number_Table;
5906: l_status_array dbms_sql.Varchar2_Table;
5907: l_error_array dbms_sql.Varchar2_Table;
5908: l_num_of_rows NUMBER;
5909: l_upd_stmt VARCHAR2(2000);
5910: l_dummy NUMBER;
5911: l_instance_status VARCHAR2(50) := FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

Line 5970: l_ctr_id dbms_sql.Number_Table;

5966:
5967: -- bug 11693286 end
5968:
5969: --
5970: l_ctr_id dbms_sql.Number_Table;
5971: l_ctr_ins_id dbms_sql.Number_Table;
5972: l_ctr_item_id dbms_sql.Number_Table;
5973: l_ctr_org_id dbms_sql.Number_Table;
5974: l_counter NUMBER := 0;

Line 5971: l_ctr_ins_id dbms_sql.Number_Table;

5967: -- bug 11693286 end
5968:
5969: --
5970: l_ctr_id dbms_sql.Number_Table;
5971: l_ctr_ins_id dbms_sql.Number_Table;
5972: l_ctr_item_id dbms_sql.Number_Table;
5973: l_ctr_org_id dbms_sql.Number_Table;
5974: l_counter NUMBER := 0;
5975: l_contact_party_tbl CONTACT_PARTY_TBL;

Line 5972: l_ctr_item_id dbms_sql.Number_Table;

5968:
5969: --
5970: l_ctr_id dbms_sql.Number_Table;
5971: l_ctr_ins_id dbms_sql.Number_Table;
5972: l_ctr_item_id dbms_sql.Number_Table;
5973: l_ctr_org_id dbms_sql.Number_Table;
5974: l_counter NUMBER := 0;
5975: l_contact_party_tbl CONTACT_PARTY_TBL;
5976: l_contact_party_count NUMBER := 0;

Line 5973: l_ctr_org_id dbms_sql.Number_Table;

5969: --
5970: l_ctr_id dbms_sql.Number_Table;
5971: l_ctr_ins_id dbms_sql.Number_Table;
5972: l_ctr_item_id dbms_sql.Number_Table;
5973: l_ctr_org_id dbms_sql.Number_Table;
5974: l_counter NUMBER := 0;
5975: l_contact_party_tbl CONTACT_PARTY_TBL;
5976: l_contact_party_count NUMBER := 0;
5977: l_ctr_tbl CTR_TBL;

Line 5993: l_upd_txn_tbl dbms_sql.Number_Table;

5989: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;
5990: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5991: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
5992: l_upd_txn_count NUMBER := 0;
5993: l_upd_txn_tbl dbms_sql.Number_Table;
5994: l_serial_control_code number;
5995: --
5996: PROCESS_NEXT EXCEPTION;
5997: SKIP_ERROR EXCEPTION;

Line 8119: l_num_of_rows := dbms_sql.open_cursor;

8115: SET instance_id = :ins_id
8116: ,error_text = :error_text
8117: ,process_status = :status
8118: WHERE inst_interface_id = :intf_id';
8119: l_num_of_rows := dbms_sql.open_cursor;
8120: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8121: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8122: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8123: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);

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

8116: ,error_text = :error_text
8117: ,process_status = :status
8118: WHERE inst_interface_id = :intf_id';
8119: l_num_of_rows := dbms_sql.open_cursor;
8120: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8121: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8122: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8123: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
8124: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

Line 8121: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);

8117: ,process_status = :status
8118: WHERE inst_interface_id = :intf_id';
8119: l_num_of_rows := dbms_sql.open_cursor;
8120: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8121: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8122: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8123: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
8124: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
8125: l_dummy := dbms_sql.execute(l_num_of_rows);

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

8118: WHERE inst_interface_id = :intf_id';
8119: l_num_of_rows := dbms_sql.open_cursor;
8120: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8121: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8122: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8123: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
8124: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
8125: l_dummy := dbms_sql.execute(l_num_of_rows);
8126: dbms_sql.close_cursor(l_num_of_rows);

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

8119: l_num_of_rows := dbms_sql.open_cursor;
8120: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8121: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8122: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8123: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
8124: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
8125: l_dummy := dbms_sql.execute(l_num_of_rows);
8126: dbms_sql.close_cursor(l_num_of_rows);
8127:

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

8120: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8121: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8122: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8123: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
8124: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
8125: l_dummy := dbms_sql.execute(l_num_of_rows);
8126: dbms_sql.close_cursor(l_num_of_rows);
8127:
8128: l_upd_stmt := 'UPDATE CSI_I_ASSET_INTERFACE a

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

8121: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8122: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8123: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
8124: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
8125: l_dummy := dbms_sql.execute(l_num_of_rows);
8126: dbms_sql.close_cursor(l_num_of_rows);
8127:
8128: l_upd_stmt := 'UPDATE CSI_I_ASSET_INTERFACE a
8129: SET instance_id = :ins_id

Line 8126: dbms_sql.close_cursor(l_num_of_rows);

8122: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8123: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
8124: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
8125: l_dummy := dbms_sql.execute(l_num_of_rows);
8126: dbms_sql.close_cursor(l_num_of_rows);
8127:
8128: l_upd_stmt := 'UPDATE CSI_I_ASSET_INTERFACE a
8129: SET instance_id = :ins_id
8130: , instance_asset_id =

Line 8140: l_num_of_rows := dbms_sql.open_cursor;

8136: AND b.fa_location_id = a.fa_location_id
8137: AND rownum = 1
8138: )
8139: WHERE inst_interface_id = :intf_id';
8140: l_num_of_rows := dbms_sql.open_cursor;
8141: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8142: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8143: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
8144: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);

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

8137: AND rownum = 1
8138: )
8139: WHERE inst_interface_id = :intf_id';
8140: l_num_of_rows := dbms_sql.open_cursor;
8141: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8142: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8143: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
8144: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8145: l_dummy := dbms_sql.execute(l_num_of_rows);

Line 8142: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);

8138: )
8139: WHERE inst_interface_id = :intf_id';
8140: l_num_of_rows := dbms_sql.open_cursor;
8141: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8142: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8143: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
8144: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8145: l_dummy := dbms_sql.execute(l_num_of_rows);
8146: dbms_sql.close_cursor(l_num_of_rows);

Line 8143: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);

8139: WHERE inst_interface_id = :intf_id';
8140: l_num_of_rows := dbms_sql.open_cursor;
8141: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8142: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8143: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
8144: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8145: l_dummy := dbms_sql.execute(l_num_of_rows);
8146: dbms_sql.close_cursor(l_num_of_rows);
8147:

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

8140: l_num_of_rows := dbms_sql.open_cursor;
8141: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8142: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8143: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
8144: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8145: l_dummy := dbms_sql.execute(l_num_of_rows);
8146: dbms_sql.close_cursor(l_num_of_rows);
8147:
8148: EXCEPTION

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

8141: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
8142: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8143: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
8144: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8145: l_dummy := dbms_sql.execute(l_num_of_rows);
8146: dbms_sql.close_cursor(l_num_of_rows);
8147:
8148: EXCEPTION
8149: WHEN OTHERS THEN

Line 8146: dbms_sql.close_cursor(l_num_of_rows);

8142: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
8143: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
8144: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
8145: l_dummy := dbms_sql.execute(l_num_of_rows);
8146: dbms_sql.close_cursor(l_num_of_rows);
8147:
8148: EXCEPTION
8149: WHEN OTHERS THEN
8150: NULL;