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.ICX_REQ_CATEGORIES dependencies on AK_QUERY_PKG

Line 118: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

114: close cat_set;
115:
116: where_clause := 'relationship_type = ''TOP'' AND CATEGORY_SET_ID =' || v_category_set_id;
117: -- Query childrens.
118: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
119: P_PARENT_REGION_CODE => 'ICX_RELATED_CATEGORIES_DISPLAY',
120: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
121: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
122: P_WHERE_CLAUSE => where_clause,

Line 128: if ak_query_pkg.g_results_table.count > 0 then

124: P_RETURN_CHILDREN => 'F');
125:
126: counter := 1;
127:
128: if ak_query_pkg.g_results_table.count > 0 then
129: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
130: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
131:
132: v_node_id := ak_query_pkg.g_results_table(i).value2; -- Category id

Line 129: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');

125:
126: counter := 1;
127:
128: if ak_query_pkg.g_results_table.count > 0 then
129: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
130: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
131:
132: v_node_id := ak_query_pkg.g_results_table(i).value2; -- Category id
133: v_name := ak_query_pkg.g_results_table(i).value4; -- Category name

Line 130: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop

126: counter := 1;
127:
128: if ak_query_pkg.g_results_table.count > 0 then
129: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
130: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
131:
132: v_node_id := ak_query_pkg.g_results_table(i).value2; -- Category id
133: v_name := ak_query_pkg.g_results_table(i).value4; -- Category name
134:

Line 132: v_node_id := ak_query_pkg.g_results_table(i).value2; -- Category id

128: if ak_query_pkg.g_results_table.count > 0 then
129: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
130: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
131:
132: v_node_id := ak_query_pkg.g_results_table(i).value2; -- Category id
133: v_name := ak_query_pkg.g_results_table(i).value4; -- Category name
134:
135: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');
136:

Line 133: v_name := ak_query_pkg.g_results_table(i).value4; -- Category name

129: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
130: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
131:
132: v_node_id := ak_query_pkg.g_results_table(i).value2; -- Category id
133: v_name := ak_query_pkg.g_results_table(i).value4; -- Category name
134:
135: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');
136:
137:

Line 159: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,

155: end loop; -- end i
156:
157: else -- No hierchy setup use regular categories
158:
159: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
160: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
161: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
162: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
163: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',

Line 168: if ak_query_pkg.g_results_table.count > 0 then

164:
165: P_RETURN_PARENTS => 'T',
166: P_RETURN_CHILDREN => 'F');
167:
168: if ak_query_pkg.g_results_table.count > 0 then
169: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
170: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
171:
172:

Line 169: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');

165: P_RETURN_PARENTS => 'T',
166: P_RETURN_CHILDREN => 'F');
167:
168: if ak_query_pkg.g_results_table.count > 0 then
169: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
170: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
171:
172:
173: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Category id

Line 170: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop

166: P_RETURN_CHILDREN => 'F');
167:
168: if ak_query_pkg.g_results_table.count > 0 then
169: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
170: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
171:
172:
173: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Category id
174: v_name := ak_query_pkg.g_results_table(i).value1; -- Category name

Line 173: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Category id

169: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
170: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
171:
172:
173: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Category id
174: v_name := ak_query_pkg.g_results_table(i).value1; -- Category name
175:
176: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');
177:

Line 174: v_name := ak_query_pkg.g_results_table(i).value1; -- Category name

170: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
171:
172:
173: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Category id
174: v_name := ak_query_pkg.g_results_table(i).value1; -- Category name
175:
176: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');
177:
178:

Line 334: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

330: end if;
331:
332: where_clause := where_clause || ' relationship_type = ''CHILD''';
333: -- Query childrens.
334: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
335: P_PARENT_REGION_CODE => 'ICX_RELATED_CATEGORIES_DISPLAY',
336: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
337: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
338: P_WHERE_CLAUSE => where_clause,

Line 342: if ak_query_pkg.g_results_table.count > 0 then

338: P_WHERE_CLAUSE => where_clause,
339: P_RETURN_PARENTS => 'T',
340: P_RETURN_CHILDREN => 'F');
341:
342: if ak_query_pkg.g_results_table.count > 0 then
343: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
344:
345: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related Category id
346: v_name := ak_query_pkg.g_results_table(i).value4; -- Related Category name

Line 343: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop

339: P_RETURN_PARENTS => 'T',
340: P_RETURN_CHILDREN => 'F');
341:
342: if ak_query_pkg.g_results_table.count > 0 then
343: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
344:
345: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related Category id
346: v_name := ak_query_pkg.g_results_table(i).value4; -- Related Category name
347:

Line 345: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related Category id

341:
342: if ak_query_pkg.g_results_table.count > 0 then
343: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
344:
345: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related Category id
346: v_name := ak_query_pkg.g_results_table(i).value4; -- Related Category name
347:
348: v_p_where := icx_call.encrypt2(v_node_id || '*' || v_org || '*' || v_name || '**]');
349:

Line 346: v_name := ak_query_pkg.g_results_table(i).value4; -- Related Category name

342: if ak_query_pkg.g_results_table.count > 0 then
343: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
344:
345: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related Category id
346: v_name := ak_query_pkg.g_results_table(i).value4; -- Related Category name
347:
348: v_p_where := icx_call.encrypt2(v_node_id || '*' || v_org || '*' || v_name || '**]');
349:
350: select count(-1) into v_no_of_children

Line 921: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

917: else
918: end_row := p_end_row;
919: end if;
920:
921: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
922: P_PARENT_REGION_CODE => 'ICX_PO_SUPPL_CATALOG_ITEMS_R',
923: p_where_clause => where_clause,
924: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
925: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

Line 932: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;

928: P_RANGE_LOW => p_start_row,
929: P_RANGE_HIGH => end_row);
930:
931: --get number of rows to display
932: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;
933: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;
934: if end_row > total_rows then
935: end_row := total_rows;
936: end if;

Line 933: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;

929: P_RANGE_HIGH => end_row);
930:
931: --get number of rows to display
932: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;
933: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;
934: if end_row > total_rows then
935: end_row := total_rows;
936: end if;
937:

Line 938: if ak_query_pkg.g_results_table.COUNT = 0 then

934: if end_row > total_rows then
935: end_row := total_rows;
936: end if;
937:
938: if ak_query_pkg.g_results_table.COUNT = 0 then
939: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
940: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
941: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
942: htp.p('

'||fnd_message.get||'

');

Line 1002: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop

998:
999: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_DATA_MULTIROW') );
1000: htp.p('');
1001: --print the table column headings
1002: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1003:
1004: if (ak_query_pkg.g_items_table(i).value_id is not null
1005: and ak_query_pkg.g_items_table(i).item_style <> 'hidden'
1006: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 1004: if (ak_query_pkg.g_items_table(i).value_id is not null

1000: htp.p('');
1001: --print the table column headings
1002: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1003:
1004: if (ak_query_pkg.g_items_table(i).value_id is not null
1005: and ak_query_pkg.g_items_table(i).item_style <> 'hidden'
1006: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1007: and ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1008: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then

Line 1005: and ak_query_pkg.g_items_table(i).item_style <> 'hidden'

1001: --print the table column headings
1002: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1003:
1004: if (ak_query_pkg.g_items_table(i).value_id is not null
1005: and ak_query_pkg.g_items_table(i).item_style <> 'hidden'
1006: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1007: and ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1008: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1009:

Line 1006: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

1002: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1003:
1004: if (ak_query_pkg.g_items_table(i).value_id is not null
1005: and ak_query_pkg.g_items_table(i).item_style <> 'hidden'
1006: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1007: and ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1008: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1009:
1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then

Line 1007: and ak_query_pkg.g_items_table(i).secured_column <> 'T') or

1003:
1004: if (ak_query_pkg.g_items_table(i).value_id is not null
1005: and ak_query_pkg.g_items_table(i).item_style <> 'hidden'
1006: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1007: and ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1008: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1009:
1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1011: --print quantity heading WITH COLSPAN=2

Line 1008: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then

1004: if (ak_query_pkg.g_items_table(i).value_id is not null
1005: and ak_query_pkg.g_items_table(i).item_style <> 'hidden'
1006: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1007: and ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1008: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1009:
1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1011: --print quantity heading WITH COLSPAN=2
1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');

Line 1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then

1006: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1007: and ak_query_pkg.g_items_table(i).secured_column <> 'T') or
1008: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1009:
1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1011: --print quantity heading WITH COLSPAN=2
1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1013: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');

Line 1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');

1008: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1009:
1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1011: --print quantity heading WITH COLSPAN=2
1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1013: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');
1015: else
1016: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');

Line 1013: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then

1009:
1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1011: --print quantity heading WITH COLSPAN=2
1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1013: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');
1015: else
1016: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');
1017: end if;

Line 1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');

1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1011: --print quantity heading WITH COLSPAN=2
1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1013: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');
1015: else
1016: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');
1017: end if;
1018: end if;

Line 1016: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');

1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1013: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');
1015: else
1016: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');
1017: end if;
1018: end if;
1019:
1020: -- find line id, urls value id

Line 1021: if ak_query_pkg.g_items_table(i).value_id is not null then

1017: end if;
1018: end if;
1019:
1020: -- find line id, urls value id
1021: if ak_query_pkg.g_items_table(i).value_id is not null then
1022:
1023: --need line_id to call javascript function down() and up()
1024: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
1025: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;

Line 1024: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then

1020: -- find line id, urls value id
1021: if ak_query_pkg.g_items_table(i).value_id is not null then
1022:
1023: --need line_id to call javascript function down() and up()
1024: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
1025: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
1026: end if;
1027: -- find item_url and supplier_item_url
1028: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then

Line 1025: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;

1021: if ak_query_pkg.g_items_table(i).value_id is not null then
1022:
1023: --need line_id to call javascript function down() and up()
1024: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
1025: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
1026: end if;
1027: -- find item_url and supplier_item_url
1028: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1029: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

Line 1028: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then

1024: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
1025: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
1026: end if;
1027: -- find item_url and supplier_item_url
1028: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1029: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1030: end if;
1031: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1032: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;

Line 1029: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

1025: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
1026: end if;
1027: -- find item_url and supplier_item_url
1028: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1029: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1030: end if;
1031: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1032: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1033: end if;

Line 1031: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then

1027: -- find item_url and supplier_item_url
1028: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1029: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1030: end if;
1031: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1032: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1033: end if;
1034: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
1035: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

Line 1032: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;

1028: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
1029: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1030: end if;
1031: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1032: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1033: end if;
1034: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
1035: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1036: end if;

Line 1034: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then

1030: end if;
1031: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1032: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1033: end if;
1034: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
1035: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1036: end if;
1037: end if;
1038:

Line 1035: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

1031: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
1032: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
1033: end if;
1034: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
1035: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
1036: end if;
1037: end if;
1038:
1039: end loop;

Line 1043: -- icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;

1039: end loop;
1040: htp.tableRowClose;
1041:
1042: --get one row of the result and find the catalog name
1043: -- icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;
1044:
1045: v_qty_flag := true;
1046:
1047: htp.br; htp.br;

Line 1051: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop

1047: htp.br; htp.br;
1048:
1049: counter := 0;
1050: -- for j in p_start_row-1 .. end_row-1 loop
1051: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop
1052: temp_table(0) := '';
1053:
1054: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;
1055:

Line 1054: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;

1050: -- for j in p_start_row-1 .. end_row-1 loop
1051: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop
1052: temp_table(0) := '';
1053:
1054: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;
1055:
1056: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1057:
1058: --print quantity input text box and up button if v_qty_flag is set

Line 1056: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop

1052: temp_table(0) := '';
1053:
1054: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;
1055:
1056: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1057:
1058: --print quantity input text box and up button if v_qty_flag is set
1059: if v_qty_flag and ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1060: v_line_id := y_table(v_line_id_ind);

Line 1059: if v_qty_flag and ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then

1055:
1056: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1057:
1058: --print quantity input text box and up button if v_qty_flag is set
1059: if v_qty_flag and ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1060: v_line_id := y_table(v_line_id_ind);
1061:
1062: display_text := '

1063: --dchu onFocus="top.update_quantity(document.forms[' || counter || '].Quantity, ''' || v_line_id || ''')"

Line 1083: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID' then

1079: --add the tabledata in temp_table() WITH ROWSPAN=2
1080: temp_table(0) := temp_table(0) || display_text;
1081: end if;
1082:
1083: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID' then
1084: display_text := '';
1085:
1086: l_pos := l_pos + 1;
1087: temp_table(0) := temp_table(0) || display_text;

Line 1084: display_text := '';

1080: temp_table(0) := temp_table(0) || display_text;
1081: end if;
1082:
1083: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID' then
1084: display_text := '';
1085:
1086: l_pos := l_pos + 1;
1087: temp_table(0) := temp_table(0) || display_text;
1088: end if;

Line 1091: if ak_query_pkg.g_items_table(i).value_id is not null --not including ICX_QTY

1087: temp_table(0) := temp_table(0) || display_text;
1088: end if;
1089:
1090: -- special treatment for certain columns
1091: if ak_query_pkg.g_items_table(i).value_id is not null --not including ICX_QTY
1092: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1093: and ak_query_pkg.g_items_table(i).secured_column <> 'T'
1094: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then --only for display of item tabledata
1095:

Line 1092: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

1088: end if;
1089:
1090: -- special treatment for certain columns
1091: if ak_query_pkg.g_items_table(i).value_id is not null --not including ICX_QTY
1092: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1093: and ak_query_pkg.g_items_table(i).secured_column <> 'T'
1094: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then --only for display of item tabledata
1095:
1096: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/

Line 1093: and ak_query_pkg.g_items_table(i).secured_column <> 'T'

1089:
1090: -- special treatment for certain columns
1091: if ak_query_pkg.g_items_table(i).value_id is not null --not including ICX_QTY
1092: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1093: and ak_query_pkg.g_items_table(i).secured_column <> 'T'
1094: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then --only for display of item tabledata
1095:
1096: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1097:

Line 1094: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then --only for display of item tabledata

1090: -- special treatment for certain columns
1091: if ak_query_pkg.g_items_table(i).value_id is not null --not including ICX_QTY
1092: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1093: and ak_query_pkg.g_items_table(i).secured_column <> 'T'
1094: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then --only for display of item tabledata
1095:
1096: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1097:
1098: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN

Line 1098: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN

1094: and ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then --only for display of item tabledata
1095:
1096: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1097:
1098: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
1099: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
1100: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
1101: /* End Change Bug #640289 By Suri ***/
1102: else

Line 1099: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);

1095:
1096: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1097:
1098: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
1099: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
1100: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
1101: /* End Change Bug #640289 By Suri ***/
1102: else
1103: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);

Line 1100: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));

1096: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
1097:
1098: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
1099: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
1100: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
1101: /* End Change Bug #640289 By Suri ***/
1102: else
1103: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1104: end if;

Line 1103: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);

1099: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
1100: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
1101: /* End Change Bug #640289 By Suri ***/
1102: else
1103: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1104: end if;
1105:
1106: --Display item_description as a link and a tabledata
1107: if display_text is not NULL then

Line 1108: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_DESCRIPTION') then

1104: end if;
1105:
1106: --Display item_description as a link and a tabledata
1107: if display_text is not NULL then
1108: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_DESCRIPTION') then
1109: v_item_url := y_table(v_item_url_ind);
1110: display_text := ICX_REQ_NAVIGATION.addURL(v_item_url, display_text);
1111: end if;
1112: --Display source_name as a link

Line 1113: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then

1109: v_item_url := y_table(v_item_url_ind);
1110: display_text := ICX_REQ_NAVIGATION.addURL(v_item_url, display_text);
1111: end if;
1112: --Display source_name as a link
1113: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then
1114: v_supplier_url := y_table(v_supplier_url_ind);
1115: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_url, display_text);
1116: end if;
1117: --Display supplier item number as a link

Line 1118: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_ITEM_NUM' then

1114: v_supplier_url := y_table(v_supplier_url_ind);
1115: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_url, display_text);
1116: end if;
1117: --Display supplier item number as a link
1118: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_ITEM_NUM' then
1119: v_supplier_item_url := y_table(v_supplier_item_url_ind);
1120: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_item_url, display_text);
1121: end if;
1122: end if;

Line 1139: if ak_query_pkg.g_items_table(i).bold = 'Y' then

1135: end if;
1136:
1137:
1138:
1139: if ak_query_pkg.g_items_table(i).bold = 'Y' then
1140: display_text := htf.bold(display_text);
1141: end if;
1142: --Italics
1143: if ak_query_pkg.g_items_table(i).italic = 'Y' then

Line 1143: if ak_query_pkg.g_items_table(i).italic = 'Y' then

1139: if ak_query_pkg.g_items_table(i).bold = 'Y' then
1140: display_text := htf.bold(display_text);
1141: end if;
1142: --Italics
1143: if ak_query_pkg.g_items_table(i).italic = 'Y' then
1144: display_text := htf.italic(display_text);
1145: end if;
1146:
1147: temp_table(0) := temp_table(0) ||

Line 1149: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,

1145: end if;
1146:
1147: temp_table(0) := temp_table(0) ||
1148: htf.tableData( cvalue => display_text,
1149: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
1150: crowspan => '2',
1151: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1152: );
1153: end if;

Line 1151: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment

1147: temp_table(0) := temp_table(0) ||
1148: htf.tableData( cvalue => display_text,
1149: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
1150: crowspan => '2',
1151: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1152: );
1153: end if;
1154: end loop; -- for i in 1 .. ak_query_pkg.g_items_table.first loop
1155:

Line 1154: end loop; -- for i in 1 .. ak_query_pkg.g_items_table.first loop

1150: crowspan => '2',
1151: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1152: );
1153: end if;
1154: end loop; -- for i in 1 .. ak_query_pkg.g_items_table.first loop
1155:
1156: --close the table row
1157: temp_table(0) := temp_table(0) || htf.tableRowClose;
1158: if v_qty_flag then

Line 1170: end loop; -- for j in 1 .. ak_query_pkg.g_results_table.COUNT loop

1166: temp_table(0) := temp_table(0) || display_text;
1167: end if;
1168: htp.p(temp_table(0));
1169: counter := counter + 1;
1170: end loop; -- for j in 1 .. ak_query_pkg.g_results_table.COUNT loop
1171: htp.tableClose;
1172:
1173: htp.p('');
1174: