159: begin
160:
161: v_on := 'N';
162: v_vendor_on_flag := 'N';
163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
160:
161: v_on := 'N';
162: v_vendor_on_flag := 'N';
163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
161: v_on := 'N';
162: v_vendor_on_flag := 'N';
163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
162: v_vendor_on_flag := 'N';
163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
172:
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
172:
173: v_vendor_on_flag := 'Y';
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
172:
173: v_vendor_on_flag := 'Y';
174: exit;
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
172:
173: v_vendor_on_flag := 'Y';
174: exit;
175: end if;