1518: l_plsql_blk :=
1519: 'BEGIN
1520: CSI_UTILITY_GRP.vld_item_ctrl_changes (
1521: p_api_version => 1.0
1522: ,p_commit => fnd_api.g_false
1523: ,p_init_msg_list => fnd_api.g_false
1524: ,p_validation_level => fnd_api.g_valid_level_full
1525: ,p_inventory_item_id => :1
1526: ,p_organization_id => :2
1519: 'BEGIN
1520: CSI_UTILITY_GRP.vld_item_ctrl_changes (
1521: p_api_version => 1.0
1522: ,p_commit => fnd_api.g_false
1523: ,p_init_msg_list => fnd_api.g_false
1524: ,p_validation_level => fnd_api.g_valid_level_full
1525: ,p_inventory_item_id => :1
1526: ,p_organization_id => :2
1527: ,p_item_attr_name => NULL
1520: CSI_UTILITY_GRP.vld_item_ctrl_changes (
1521: p_api_version => 1.0
1522: ,p_commit => fnd_api.g_false
1523: ,p_init_msg_list => fnd_api.g_false
1524: ,p_validation_level => fnd_api.g_valid_level_full
1525: ,p_inventory_item_id => :1
1526: ,p_organization_id => :2
1527: ,p_item_attr_name => NULL
1528: ,p_new_item_attr_value => NULL
1532: ,x_msg_data => :X_ib_msg);
1533: END;';
1534: EXECUTE IMMEDIATE l_plsql_blk
1535: USING p_inventory_item_id, p_organization_id,OUT X_ib_ret_status,OUT l_msg_count,OUT X_ib_msg;
1536: X_ib_ret_status:= FND_API.G_RET_STS_ERROR;
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: X_ib_ret_status:= FND_API.G_RET_STS_SUCCESS;
1540: X_ib_msg := NULL;
1535: USING p_inventory_item_id, p_organization_id,OUT X_ib_ret_status,OUT l_msg_count,OUT X_ib_msg;
1536: X_ib_ret_status:= FND_API.G_RET_STS_ERROR;
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: X_ib_ret_status:= FND_API.G_RET_STS_SUCCESS;
1540: X_ib_msg := NULL;
1541: END;
1542: ELSE
1543: X_ib_ret_status:= FND_API.G_RET_STS_SUCCESS;
1539: X_ib_ret_status:= FND_API.G_RET_STS_SUCCESS;
1540: X_ib_msg := NULL;
1541: END;
1542: ELSE
1543: X_ib_ret_status:= FND_API.G_RET_STS_SUCCESS;
1544: X_ib_msg := NULL;
1545: END IF;
1546: END CSI_Table_Queries;
1547: