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

Line 4286: l_cur_get_inst_rel := dbms_sql.open_cursor;

4282: x_select_stmt => l_select_stmt ,
4283: p_active_instance_only => p_active_instance_only);
4284:
4285: -- Open the cursor
4286: l_cur_get_inst_rel := dbms_sql.open_cursor;
4287:
4288: --Parse the select statement
4289: dbms_sql.parse(l_cur_get_inst_rel, l_select_stmt , dbms_sql.native);
4290:

Line 4289: dbms_sql.parse(l_cur_get_inst_rel, l_select_stmt , dbms_sql.native);

4285: -- Open the cursor
4286: l_cur_get_inst_rel := dbms_sql.open_cursor;
4287:
4288: --Parse the select statement
4289: dbms_sql.parse(l_cur_get_inst_rel, l_select_stmt , dbms_sql.native);
4290:
4291: -- Bind the variables
4292: csi_item_instance_pvt.Bind_inst_variable(p_instance_query_rec,
4293: p_party_query_rec,

Line 4303: l_rows_processed := dbms_sql.execute(l_cur_get_inst_rel);

4299: csi_item_instance_pvt.Define_Inst_Columns(l_cur_get_inst_rel,
4300: p_instance_query_rec );
4301:
4302: -- execute the select statement
4303: l_rows_processed := dbms_sql.execute(l_cur_get_inst_rel);
4304: -- srramakr Bug # 2636868. Construct_inst_header_rec is called within the loop and
4305: -- x_instance_header_tbl is constructed. This is basically to l_instance_id_list
4306: -- with the bind variable p_instance_id.
4307: LOOP

Line 4308: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_inst_rel) = 0;

4304: -- srramakr Bug # 2636868. Construct_inst_header_rec is called within the loop and
4305: -- x_instance_header_tbl is constructed. This is basically to l_instance_id_list
4306: -- with the bind variable p_instance_id.
4307: LOOP
4308: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_inst_rel) = 0;
4309: csi_item_instance_pvt.Get_Inst_Column_Values(l_cur_get_inst_rel,
4310: l_instance_id );
4311: l_count := l_count + 1;
4312: csi_item_instance_pvt.Construct_inst_header_rec(l_instance_id,

Line 4322: DBMS_SQL.CLOSE_CURSOR(l_cur_get_inst_rel);

4318: END IF; *****/
4319: END LOOP;
4320:
4321: -- Close the cursor
4322: DBMS_SQL.CLOSE_CURSOR(l_cur_get_inst_rel);
4323:
4324: /***** COMMENTED FOR Bug # 2636868 IF l_instance_id_list IS NOT NULL THEN
4325: csi_item_instance_pvt.Construct_inst_header_rec(l_instance_id_list,
4326: x_instance_header_tbl);

Line 4551: l_cur_get_instance_rel := dbms_sql.open_cursor;

4547: ****/
4548: -- Start API body
4549:
4550: -- Open the cursor
4551: l_cur_get_instance_rel := dbms_sql.open_cursor;
4552:
4553: --Parse the select statement
4554: dbms_sql.parse(l_cur_get_instance_rel, l_select_stmt , dbms_sql.native);
4555:

Line 4554: dbms_sql.parse(l_cur_get_instance_rel, l_select_stmt , dbms_sql.native);

4550: -- Open the cursor
4551: l_cur_get_instance_rel := dbms_sql.open_cursor;
4552:
4553: --Parse the select statement
4554: dbms_sql.parse(l_cur_get_instance_rel, l_select_stmt , dbms_sql.native);
4555:
4556: -- Bind the variables
4557: csi_item_instance_pvt.Bind_instance_variable(p_instance_rec,
4558: l_cur_get_instance_rel);

Line 4564: l_rows_processed := dbms_sql.execute(l_cur_get_instance_rel);

4560: -- Define output variables
4561: csi_item_instance_pvt.Define_Instance_Columns(l_cur_get_instance_rel);
4562:
4563: -- execute the select statement
4564: l_rows_processed := dbms_sql.execute(l_cur_get_instance_rel);
4565:
4566: LOOP
4567: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_instance_rel) = 0;
4568: csi_item_instance_pvt.Get_Instance_Col_Values(l_cur_get_instance_rel,

Line 4567: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_instance_rel) = 0;

4563: -- execute the select statement
4564: l_rows_processed := dbms_sql.execute(l_cur_get_instance_rel);
4565:
4566: LOOP
4567: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_instance_rel) = 0;
4568: csi_item_instance_pvt.Get_Instance_Col_Values(l_cur_get_instance_rel,
4569: l_instance_rec
4570: );
4571: p_instance_rec := l_instance_rec;

Line 4575: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);

4571: p_instance_rec := l_instance_rec;
4572: END LOOP;
4573:
4574: -- Close the cursor
4575: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4576:
4577: --
4578: -- Get the last purge date from csi_item_instances table
4579: --

Line 4900: IF DBMS_SQL.IS_OPEN(l_cur_get_instance_rel) THEN

4896: p_data => x_msg_data
4897: );
4898: WHEN OTHERS THEN
4899:
4900: IF DBMS_SQL.IS_OPEN(l_cur_get_instance_rel) THEN
4901: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4902: END IF;
4903: -- ROLLBACK TO get_item_instance_details;
4904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4901: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);

4897: );
4898: WHEN OTHERS THEN
4899:
4900: IF DBMS_SQL.IS_OPEN(l_cur_get_instance_rel) THEN
4901: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4902: END IF;
4903: -- ROLLBACK TO get_item_instance_details;
4904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4905: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 5023: l_get_ver_cursor_id := dbms_sql.open_cursor;

5019: -- Build the select statement
5020: l_select_stmt := l_select_stmt || ' where '||l_where_clause;
5021:
5022: -- Open the cursor
5023: l_get_ver_cursor_id := dbms_sql.open_cursor;
5024:
5025: --Parse the select statement
5026: dbms_sql.parse(l_get_ver_cursor_id, l_select_stmt , dbms_sql.native);
5027:

Line 5026: dbms_sql.parse(l_get_ver_cursor_id, l_select_stmt , dbms_sql.native);

5022: -- Open the cursor
5023: l_get_ver_cursor_id := dbms_sql.open_cursor;
5024:
5025: --Parse the select statement
5026: dbms_sql.parse(l_get_ver_cursor_id, l_select_stmt , dbms_sql.native);
5027:
5028: -- Bind the variables
5029: csi_item_instance_pvt.Bind_Ver_variable(p_version_label_query_rec, l_get_ver_cursor_id);
5030:

Line 5035: l_rows_processed := dbms_sql.execute(l_get_ver_cursor_id);

5031: -- Define output variables
5032: csi_item_instance_pvt.Define_Ver_Columns(l_get_ver_cursor_id);
5033:
5034: -- execute the select statement
5035: l_rows_processed := dbms_sql.execute(l_get_ver_cursor_id);
5036:
5037: LOOP
5038: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_ver_cursor_id) = 0;
5039: csi_item_instance_pvt.Get_Ver_Column_Values(l_get_ver_cursor_id, l_version_label_rec);

Line 5038: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_ver_cursor_id) = 0;

5034: -- execute the select statement
5035: l_rows_processed := dbms_sql.execute(l_get_ver_cursor_id);
5036:
5037: LOOP
5038: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_ver_cursor_id) = 0;
5039: csi_item_instance_pvt.Get_Ver_Column_Values(l_get_ver_cursor_id, l_version_label_rec);
5040: l_count := l_count + 1;
5041: x_version_label_tbl(l_count) := l_version_label_rec;
5042: END LOOP;

Line 5045: DBMS_SQL.CLOSE_CURSOR(l_get_ver_cursor_id);

5041: x_version_label_tbl(l_count) := l_version_label_rec;
5042: END LOOP;
5043:
5044: -- Close the cursor
5045: DBMS_SQL.CLOSE_CURSOR(l_get_ver_cursor_id);
5046:
5047: IF p_time_stamp < sysdate THEN
5048: csi_item_instance_pvt.Construct_ver_from_hist(x_version_label_tbl, p_time_stamp);
5049: ELSE

Line 5896: l_cur_get_ext := dbms_sql.open_cursor;

5892:
5893: l_select_stmt := l_select_stmt || ' AND '||l_where_clause;
5894:
5895: -- Open the cursor
5896: l_cur_get_ext := dbms_sql.open_cursor;
5897:
5898:
5899: --Parse the select statement
5900: dbms_sql.parse(l_cur_get_ext, l_select_stmt , dbms_sql.native);

Line 5900: dbms_sql.parse(l_cur_get_ext, l_select_stmt , dbms_sql.native);

5896: l_cur_get_ext := dbms_sql.open_cursor;
5897:
5898:
5899: --Parse the select statement
5900: dbms_sql.parse(l_cur_get_ext, l_select_stmt , dbms_sql.native);
5901:
5902: -- Bind the variables
5903: csi_item_instance_pvt.Bind_ext_variable
5904: ( p_ext_attribs_query_rec,

Line 5911: l_rows_processed := dbms_sql.execute(l_cur_get_ext);

5907: -- Define output variables
5908: csi_item_instance_pvt.Define_ext_Columns(l_cur_get_ext);
5909:
5910: -- execute the select statement
5911: l_rows_processed := dbms_sql.execute(l_cur_get_ext);
5912:
5913:
5914: LOOP
5915: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_ext) = 0;

Line 5915: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_ext) = 0;

5911: l_rows_processed := dbms_sql.execute(l_cur_get_ext);
5912:
5913:
5914: LOOP
5915: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_ext) = 0;
5916: csi_item_instance_pvt.Get_ext_Column_Values(l_cur_get_ext, l_ext_rec);
5917: l_count := l_count + 1;
5918: x_ext_attrib_tbl(l_count) := l_ext_rec;
5919: END LOOP;

Line 5922: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);

5918: x_ext_attrib_tbl(l_count) := l_ext_rec;
5919: END LOOP;
5920:
5921: -- Close the cursor
5922: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);
5923:
5924: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
5925: IF p_time_stamp <= sysdate THEN
5926: csi_item_instance_pvt.Construct_ext_From_Hist(x_ext_attrib_tbl, p_time_stamp);

Line 6018: IF DBMS_SQL.IS_OPEN(l_cur_get_ext) THEN

6014: p_data => x_msg_data
6015: );
6016:
6017: WHEN OTHERS THEN
6018: IF DBMS_SQL.IS_OPEN(l_cur_get_ext) THEN
6019: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);
6020: END IF;
6021:
6022: -- ROLLBACK TO get_extended_attrib_values;

Line 6019: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);

6015: );
6016:
6017: WHEN OTHERS THEN
6018: IF DBMS_SQL.IS_OPEN(l_cur_get_ext) THEN
6019: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);
6020: END IF;
6021:
6022: -- ROLLBACK TO get_extended_attrib_values;
6023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;