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 5900: l_txn_exists_tbl dbms_sql.Number_Table;

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

Line 5901: l_intf_id_array dbms_sql.Number_Table;

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

Line 5902: l_inst_id_array dbms_sql.Number_Table;

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

Line 5903: l_status_array dbms_sql.Varchar2_Table;

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

Line 5904: l_error_array dbms_sql.Varchar2_Table;

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

Line 5936: l_ctr_id dbms_sql.Number_Table;

5932: ,valid_flag VARCHAR2(1)
5933: );
5934: TYPE CONTACT_PARTY_TBL IS TABLE OF CONTACT_PARTY_REC INDEX BY BINARY_INTEGER;
5935: --
5936: l_ctr_id dbms_sql.Number_Table;
5937: l_ctr_ins_id dbms_sql.Number_Table;
5938: l_ctr_item_id dbms_sql.Number_Table;
5939: l_ctr_org_id dbms_sql.Number_Table;
5940: l_counter NUMBER := 0;

Line 5937: l_ctr_ins_id dbms_sql.Number_Table;

5933: );
5934: TYPE CONTACT_PARTY_TBL IS TABLE OF CONTACT_PARTY_REC INDEX BY BINARY_INTEGER;
5935: --
5936: l_ctr_id dbms_sql.Number_Table;
5937: l_ctr_ins_id dbms_sql.Number_Table;
5938: l_ctr_item_id dbms_sql.Number_Table;
5939: l_ctr_org_id dbms_sql.Number_Table;
5940: l_counter NUMBER := 0;
5941: l_contact_party_tbl CONTACT_PARTY_TBL;

Line 5938: l_ctr_item_id dbms_sql.Number_Table;

5934: TYPE CONTACT_PARTY_TBL IS TABLE OF CONTACT_PARTY_REC INDEX BY BINARY_INTEGER;
5935: --
5936: l_ctr_id dbms_sql.Number_Table;
5937: l_ctr_ins_id dbms_sql.Number_Table;
5938: l_ctr_item_id dbms_sql.Number_Table;
5939: l_ctr_org_id dbms_sql.Number_Table;
5940: l_counter NUMBER := 0;
5941: l_contact_party_tbl CONTACT_PARTY_TBL;
5942: l_contact_party_count NUMBER := 0;

Line 5939: l_ctr_org_id dbms_sql.Number_Table;

5935: --
5936: l_ctr_id dbms_sql.Number_Table;
5937: l_ctr_ins_id dbms_sql.Number_Table;
5938: l_ctr_item_id dbms_sql.Number_Table;
5939: l_ctr_org_id dbms_sql.Number_Table;
5940: l_counter NUMBER := 0;
5941: l_contact_party_tbl CONTACT_PARTY_TBL;
5942: l_contact_party_count NUMBER := 0;
5943: l_ctr_tbl CTR_TBL;

Line 5959: l_upd_txn_tbl dbms_sql.Number_Table;

5955: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;
5956: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5957: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
5958: l_upd_txn_count NUMBER := 0;
5959: l_upd_txn_tbl dbms_sql.Number_Table;
5960: l_serial_control_code number;
5961: --
5962: PROCESS_NEXT EXCEPTION;
5963: SKIP_ERROR EXCEPTION;

Line 7582: l_num_of_rows := dbms_sql.open_cursor;

7578: SET instance_id = :ins_id
7579: ,error_text = :error_text
7580: ,process_status = :status
7581: WHERE inst_interface_id = :intf_id';
7582: l_num_of_rows := dbms_sql.open_cursor;
7583: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7584: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7585: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7586: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);

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

7579: ,error_text = :error_text
7580: ,process_status = :status
7581: WHERE inst_interface_id = :intf_id';
7582: l_num_of_rows := dbms_sql.open_cursor;
7583: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7584: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7585: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7586: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
7587: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);

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

7580: ,process_status = :status
7581: WHERE inst_interface_id = :intf_id';
7582: l_num_of_rows := dbms_sql.open_cursor;
7583: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7584: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7585: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7586: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
7587: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
7588: l_dummy := dbms_sql.execute(l_num_of_rows);

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

7581: WHERE inst_interface_id = :intf_id';
7582: l_num_of_rows := dbms_sql.open_cursor;
7583: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7584: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7585: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7586: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
7587: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
7588: l_dummy := dbms_sql.execute(l_num_of_rows);
7589: dbms_sql.close_cursor(l_num_of_rows);

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

7582: l_num_of_rows := dbms_sql.open_cursor;
7583: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7584: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7585: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7586: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
7587: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
7588: l_dummy := dbms_sql.execute(l_num_of_rows);
7589: dbms_sql.close_cursor(l_num_of_rows);
7590:

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

7583: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7584: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7585: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7586: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
7587: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
7588: l_dummy := dbms_sql.execute(l_num_of_rows);
7589: dbms_sql.close_cursor(l_num_of_rows);
7590:
7591: l_upd_stmt := 'UPDATE CSI_I_ASSET_INTERFACE a

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

7584: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7585: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7586: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
7587: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
7588: l_dummy := dbms_sql.execute(l_num_of_rows);
7589: dbms_sql.close_cursor(l_num_of_rows);
7590:
7591: l_upd_stmt := 'UPDATE CSI_I_ASSET_INTERFACE a
7592: SET instance_id = :ins_id

Line 7589: dbms_sql.close_cursor(l_num_of_rows);

7585: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7586: dbms_sql.bind_array(l_num_of_rows,':status',l_status_array);
7587: dbms_sql.bind_array(l_num_of_rows,':error_text',l_error_array);
7588: l_dummy := dbms_sql.execute(l_num_of_rows);
7589: dbms_sql.close_cursor(l_num_of_rows);
7590:
7591: l_upd_stmt := 'UPDATE CSI_I_ASSET_INTERFACE a
7592: SET instance_id = :ins_id
7593: , instance_asset_id =

Line 7603: l_num_of_rows := dbms_sql.open_cursor;

7599: AND b.fa_location_id = a.fa_location_id
7600: AND rownum = 1
7601: )
7602: WHERE inst_interface_id = :intf_id';
7603: l_num_of_rows := dbms_sql.open_cursor;
7604: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7605: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7606: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
7607: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);

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

7600: AND rownum = 1
7601: )
7602: WHERE inst_interface_id = :intf_id';
7603: l_num_of_rows := dbms_sql.open_cursor;
7604: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7605: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7606: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
7607: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7608: l_dummy := dbms_sql.execute(l_num_of_rows);

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

7601: )
7602: WHERE inst_interface_id = :intf_id';
7603: l_num_of_rows := dbms_sql.open_cursor;
7604: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7605: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7606: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
7607: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7608: l_dummy := dbms_sql.execute(l_num_of_rows);
7609: dbms_sql.close_cursor(l_num_of_rows);

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

7602: WHERE inst_interface_id = :intf_id';
7603: l_num_of_rows := dbms_sql.open_cursor;
7604: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7605: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7606: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
7607: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7608: l_dummy := dbms_sql.execute(l_num_of_rows);
7609: dbms_sql.close_cursor(l_num_of_rows);
7610:

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

7603: l_num_of_rows := dbms_sql.open_cursor;
7604: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7605: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7606: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
7607: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7608: l_dummy := dbms_sql.execute(l_num_of_rows);
7609: dbms_sql.close_cursor(l_num_of_rows);
7610:
7611: EXCEPTION

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

7604: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);
7605: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7606: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
7607: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7608: l_dummy := dbms_sql.execute(l_num_of_rows);
7609: dbms_sql.close_cursor(l_num_of_rows);
7610:
7611: EXCEPTION
7612: WHEN OTHERS THEN

Line 7609: dbms_sql.close_cursor(l_num_of_rows);

7605: dbms_sql.bind_array(l_num_of_rows,':ins_id',l_inst_id_array);
7606: dbms_sql.bind_array(l_num_of_rows,':a_ins_id',l_inst_id_array);
7607: dbms_sql.bind_array(l_num_of_rows,':intf_id',l_intf_id_array);
7608: l_dummy := dbms_sql.execute(l_num_of_rows);
7609: dbms_sql.close_cursor(l_num_of_rows);
7610:
7611: EXCEPTION
7612: WHEN OTHERS THEN
7613: NULL;