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 4244: l_cur_get_inst_rel := dbms_sql.open_cursor;

4240: x_select_stmt => l_select_stmt ,
4241: p_active_instance_only => p_active_instance_only);
4242:
4243: -- Open the cursor
4244: l_cur_get_inst_rel := dbms_sql.open_cursor;
4245:
4246: --Parse the select statement
4247: dbms_sql.parse(l_cur_get_inst_rel, l_select_stmt , dbms_sql.native);
4248:

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

4243: -- Open the cursor
4244: l_cur_get_inst_rel := dbms_sql.open_cursor;
4245:
4246: --Parse the select statement
4247: dbms_sql.parse(l_cur_get_inst_rel, l_select_stmt , dbms_sql.native);
4248:
4249: -- Bind the variables
4250: csi_item_instance_pvt.Bind_inst_variable(p_instance_query_rec,
4251: p_party_query_rec,

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

4257: csi_item_instance_pvt.Define_Inst_Columns(l_cur_get_inst_rel,
4258: p_instance_query_rec );
4259:
4260: -- execute the select statement
4261: l_rows_processed := dbms_sql.execute(l_cur_get_inst_rel);
4262: -- srramakr Bug # 2636868. Construct_inst_header_rec is called within the loop and
4263: -- x_instance_header_tbl is constructed. This is basically to l_instance_id_list
4264: -- with the bind variable p_instance_id.
4265: LOOP

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

4262: -- srramakr Bug # 2636868. Construct_inst_header_rec is called within the loop and
4263: -- x_instance_header_tbl is constructed. This is basically to l_instance_id_list
4264: -- with the bind variable p_instance_id.
4265: LOOP
4266: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_inst_rel) = 0;
4267: csi_item_instance_pvt.Get_Inst_Column_Values(l_cur_get_inst_rel,
4268: l_instance_id );
4269: l_count := l_count + 1;
4270: csi_item_instance_pvt.Construct_inst_header_rec(l_instance_id,

Line 4280: DBMS_SQL.CLOSE_CURSOR(l_cur_get_inst_rel);

4276: END IF; *****/
4277: END LOOP;
4278:
4279: -- Close the cursor
4280: DBMS_SQL.CLOSE_CURSOR(l_cur_get_inst_rel);
4281:
4282: /***** COMMENTED FOR Bug # 2636868 IF l_instance_id_list IS NOT NULL THEN
4283: csi_item_instance_pvt.Construct_inst_header_rec(l_instance_id_list,
4284: x_instance_header_tbl);

Line 4505: l_cur_get_instance_rel := dbms_sql.open_cursor;

4501: ****/
4502: -- Start API body
4503:
4504: -- Open the cursor
4505: l_cur_get_instance_rel := dbms_sql.open_cursor;
4506:
4507: --Parse the select statement
4508: dbms_sql.parse(l_cur_get_instance_rel, l_select_stmt , dbms_sql.native);
4509:

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

4504: -- Open the cursor
4505: l_cur_get_instance_rel := dbms_sql.open_cursor;
4506:
4507: --Parse the select statement
4508: dbms_sql.parse(l_cur_get_instance_rel, l_select_stmt , dbms_sql.native);
4509:
4510: -- Bind the variables
4511: csi_item_instance_pvt.Bind_instance_variable(p_instance_rec,
4512: l_cur_get_instance_rel);

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

4514: -- Define output variables
4515: csi_item_instance_pvt.Define_Instance_Columns(l_cur_get_instance_rel);
4516:
4517: -- execute the select statement
4518: l_rows_processed := dbms_sql.execute(l_cur_get_instance_rel);
4519:
4520: LOOP
4521: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_instance_rel) = 0;
4522: csi_item_instance_pvt.Get_Instance_Col_Values(l_cur_get_instance_rel,

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

4517: -- execute the select statement
4518: l_rows_processed := dbms_sql.execute(l_cur_get_instance_rel);
4519:
4520: LOOP
4521: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_instance_rel) = 0;
4522: csi_item_instance_pvt.Get_Instance_Col_Values(l_cur_get_instance_rel,
4523: l_instance_rec
4524: );
4525: p_instance_rec := l_instance_rec;

Line 4529: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);

4525: p_instance_rec := l_instance_rec;
4526: END LOOP;
4527:
4528: -- Close the cursor
4529: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4530:
4531: --
4532: -- Get the last purge date from csi_item_instances table
4533: --

Line 4851: IF DBMS_SQL.IS_OPEN(l_cur_get_instance_rel) THEN

4847: p_data => x_msg_data
4848: );
4849: WHEN OTHERS THEN
4850:
4851: IF DBMS_SQL.IS_OPEN(l_cur_get_instance_rel) THEN
4852: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4853: END IF;
4854: -- ROLLBACK TO get_item_instance_details;
4855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4852: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);

4848: );
4849: WHEN OTHERS THEN
4850:
4851: IF DBMS_SQL.IS_OPEN(l_cur_get_instance_rel) THEN
4852: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4853: END IF;
4854: -- ROLLBACK TO get_item_instance_details;
4855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4856: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 4971: l_get_ver_cursor_id := dbms_sql.open_cursor;

4967: -- Build the select statement
4968: l_select_stmt := l_select_stmt || ' where '||l_where_clause;
4969:
4970: -- Open the cursor
4971: l_get_ver_cursor_id := dbms_sql.open_cursor;
4972:
4973: --Parse the select statement
4974: dbms_sql.parse(l_get_ver_cursor_id, l_select_stmt , dbms_sql.native);
4975:

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

4970: -- Open the cursor
4971: l_get_ver_cursor_id := dbms_sql.open_cursor;
4972:
4973: --Parse the select statement
4974: dbms_sql.parse(l_get_ver_cursor_id, l_select_stmt , dbms_sql.native);
4975:
4976: -- Bind the variables
4977: csi_item_instance_pvt.Bind_Ver_variable(p_version_label_query_rec, l_get_ver_cursor_id);
4978:

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

4979: -- Define output variables
4980: csi_item_instance_pvt.Define_Ver_Columns(l_get_ver_cursor_id);
4981:
4982: -- execute the select statement
4983: l_rows_processed := dbms_sql.execute(l_get_ver_cursor_id);
4984:
4985: LOOP
4986: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_ver_cursor_id) = 0;
4987: csi_item_instance_pvt.Get_Ver_Column_Values(l_get_ver_cursor_id, l_version_label_rec);

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

4982: -- execute the select statement
4983: l_rows_processed := dbms_sql.execute(l_get_ver_cursor_id);
4984:
4985: LOOP
4986: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_ver_cursor_id) = 0;
4987: csi_item_instance_pvt.Get_Ver_Column_Values(l_get_ver_cursor_id, l_version_label_rec);
4988: l_count := l_count + 1;
4989: x_version_label_tbl(l_count) := l_version_label_rec;
4990: END LOOP;

Line 4993: DBMS_SQL.CLOSE_CURSOR(l_get_ver_cursor_id);

4989: x_version_label_tbl(l_count) := l_version_label_rec;
4990: END LOOP;
4991:
4992: -- Close the cursor
4993: DBMS_SQL.CLOSE_CURSOR(l_get_ver_cursor_id);
4994:
4995: IF p_time_stamp < sysdate THEN
4996: csi_item_instance_pvt.Construct_ver_from_hist(x_version_label_tbl, p_time_stamp);
4997: ELSE

Line 5828: l_cur_get_ext := dbms_sql.open_cursor;

5824:
5825: l_select_stmt := l_select_stmt || ' AND '||l_where_clause;
5826:
5827: -- Open the cursor
5828: l_cur_get_ext := dbms_sql.open_cursor;
5829:
5830:
5831: --Parse the select statement
5832: dbms_sql.parse(l_cur_get_ext, l_select_stmt , dbms_sql.native);

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

5828: l_cur_get_ext := dbms_sql.open_cursor;
5829:
5830:
5831: --Parse the select statement
5832: dbms_sql.parse(l_cur_get_ext, l_select_stmt , dbms_sql.native);
5833:
5834: -- Bind the variables
5835: csi_item_instance_pvt.Bind_ext_variable
5836: ( p_ext_attribs_query_rec,

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

5839: -- Define output variables
5840: csi_item_instance_pvt.Define_ext_Columns(l_cur_get_ext);
5841:
5842: -- execute the select statement
5843: l_rows_processed := dbms_sql.execute(l_cur_get_ext);
5844:
5845:
5846: LOOP
5847: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_ext) = 0;

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

5843: l_rows_processed := dbms_sql.execute(l_cur_get_ext);
5844:
5845:
5846: LOOP
5847: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_cur_get_ext) = 0;
5848: csi_item_instance_pvt.Get_ext_Column_Values(l_cur_get_ext, l_ext_rec);
5849: l_count := l_count + 1;
5850: x_ext_attrib_tbl(l_count) := l_ext_rec;
5851: END LOOP;

Line 5854: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);

5850: x_ext_attrib_tbl(l_count) := l_ext_rec;
5851: END LOOP;
5852:
5853: -- Close the cursor
5854: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);
5855:
5856: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
5857: IF p_time_stamp <= sysdate THEN
5858: csi_item_instance_pvt.Construct_ext_From_Hist(x_ext_attrib_tbl, p_time_stamp);

Line 5947: IF DBMS_SQL.IS_OPEN(l_cur_get_ext) THEN

5943: p_data => x_msg_data
5944: );
5945:
5946: WHEN OTHERS THEN
5947: IF DBMS_SQL.IS_OPEN(l_cur_get_ext) THEN
5948: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);
5949: END IF;
5950:
5951: -- ROLLBACK TO get_extended_attrib_values;

Line 5948: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);

5944: );
5945:
5946: WHEN OTHERS THEN
5947: IF DBMS_SQL.IS_OPEN(l_cur_get_ext) THEN
5948: DBMS_SQL.CLOSE_CURSOR(l_cur_get_ext);
5949: END IF;
5950:
5951: -- ROLLBACK TO get_extended_attrib_values;
5952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;