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_SUBMIT dependencies on AK_QUERY_PKG

Line 54: v_regions_table ak_query_pkg.regions_table_type;

50: procedure display_read_only_my_order( cart_id number,p_emergency varchar2 ) is
51: ------------------------------------------------------------
52:
53: vvalue varchar2(240);
54: v_regions_table ak_query_pkg.regions_table_type;
55: v_items_table ak_query_pkg.items_table_type;
56: v_results_table ak_query_pkg.results_table_type;
57:
58: shopper_id number;

Line 55: v_items_table ak_query_pkg.items_table_type;

51: ------------------------------------------------------------
52:
53: vvalue varchar2(240);
54: v_regions_table ak_query_pkg.regions_table_type;
55: v_items_table ak_query_pkg.items_table_type;
56: v_results_table ak_query_pkg.results_table_type;
57:
58: shopper_id number;
59:

Line 56: v_results_table ak_query_pkg.results_table_type;

52:
53: vvalue varchar2(240);
54: v_regions_table ak_query_pkg.regions_table_type;
55: v_items_table ak_query_pkg.items_table_type;
56: v_results_table ak_query_pkg.results_table_type;
57:
58: shopper_id number;
59:
60: v_where_clause varchar2(240);

Line 92: where_clause_binds ak_query_pkg.bind_tab;

88: v_precision number;
89: v_money_fmt_mask varchar2(32);
90:
91: /* Change wrto Bug Fix to implement the Bind Vars **/
92: where_clause_binds ak_query_pkg.bind_tab;
93: where_clause_binds_empty ak_query_pkg.bind_tab;
94: v_index NUMBER;
95:
96:

Line 93: where_clause_binds_empty ak_query_pkg.bind_tab;

89: v_money_fmt_mask varchar2(32);
90:
91: /* Change wrto Bug Fix to implement the Bind Vars **/
92: where_clause_binds ak_query_pkg.bind_tab;
93: where_clause_binds_empty ak_query_pkg.bind_tab;
94: v_index NUMBER;
95:
96:
97: cursor getLoccd(locid number) is

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

171:
172: -- Cart Header Related Object Navigator
173: -- ^^^^^^^^^^
174: --
175: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
176: P_PARENT_REGION_CODE => v_header_region,
177: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
178: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
179: P_WHERE_CLAUSE => v_where_clause,

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

183:
184: -- Draw cart header.
185: htp.tableOpen( 'border=0' );
186:
187: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;
188:
189: /* get org ahead of time */
190: for k in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
191: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_DEST_ORG_ID' then

Line 190: for k in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop

186:
187: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;
188:
189: /* get org ahead of time */
190: for k in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
191: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_DEST_ORG_ID' then
192: v_org := y_table(ak_query_pkg.g_items_table(k).value_id);
193: exit;
194: end if;

Line 191: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_DEST_ORG_ID' then

187: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;
188:
189: /* get org ahead of time */
190: for k in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
191: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_DEST_ORG_ID' then
192: v_org := y_table(ak_query_pkg.g_items_table(k).value_id);
193: exit;
194: end if;
195: end loop;

Line 192: v_org := y_table(ak_query_pkg.g_items_table(k).value_id);

188:
189: /* get org ahead of time */
190: for k in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
191: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_DEST_ORG_ID' then
192: v_org := y_table(ak_query_pkg.g_items_table(k).value_id);
193: exit;
194: end if;
195: end loop;
196:

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

201: v_money_fmt_mask := FND_CURRENCY.GET_FORMAT_MASK(v_currency,30);
202: end if;
203:
204:
205: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
206:
207:
208: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
209: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' ) OR

Line 208: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and

204:
205: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
206:
207:
208: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
209: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' ) OR
210: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' OR
211: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' OR
212: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then

Line 209: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' ) OR

205: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
206:
207:
208: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
209: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' ) OR
210: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' OR
211: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' OR
212: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
213:

Line 210: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' OR

206:
207:
208: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
209: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' ) OR
210: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' OR
211: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' OR
212: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
213:
214: if ak_query_pkg.g_items_table(i).value_id is not null then -- It is an object attribute

Line 211: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' OR

207:
208: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
209: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' ) OR
210: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' OR
211: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' OR
212: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
213:
214: if ak_query_pkg.g_items_table(i).value_id is not null then -- It is an object attribute
215:

Line 212: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then

208: if ( ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' and
209: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' ) OR
210: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' OR
211: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' OR
212: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
213:
214: if ak_query_pkg.g_items_table(i).value_id is not null then -- It is an object attribute
215:
216: if(ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then

Line 214: if ak_query_pkg.g_items_table(i).value_id is not null then -- It is an object attribute

210: (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_ID' OR
211: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR_ID' OR
212: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
213:
214: if ak_query_pkg.g_items_table(i).value_id is not null then -- It is an object attribute
215:
216: if(ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
217: v_org := y_table(ak_query_pkg.g_items_table(i).value_id);
218: elsif(ak_query_pkg.g_items_table(i).attribute_code =

Line 216: if(ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then

212: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
213:
214: if ak_query_pkg.g_items_table(i).value_id is not null then -- It is an object attribute
215:
216: if(ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
217: v_org := y_table(ak_query_pkg.g_items_table(i).value_id);
218: elsif(ak_query_pkg.g_items_table(i).attribute_code =
219: 'ICX_DELIVER_TO_LOCATION_ID') then
220: -- get the location id to find the location code

Line 217: v_org := y_table(ak_query_pkg.g_items_table(i).value_id);

213:
214: if ak_query_pkg.g_items_table(i).value_id is not null then -- It is an object attribute
215:
216: if(ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
217: v_org := y_table(ak_query_pkg.g_items_table(i).value_id);
218: elsif(ak_query_pkg.g_items_table(i).attribute_code =
219: 'ICX_DELIVER_TO_LOCATION_ID') then
220: -- get the location id to find the location code
221: v_location_id := y_table(ak_query_pkg.g_items_table(i).value_id);

Line 218: elsif(ak_query_pkg.g_items_table(i).attribute_code =

214: if ak_query_pkg.g_items_table(i).value_id is not null then -- It is an object attribute
215:
216: if(ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DEST_ORG_ID') then
217: v_org := y_table(ak_query_pkg.g_items_table(i).value_id);
218: elsif(ak_query_pkg.g_items_table(i).attribute_code =
219: 'ICX_DELIVER_TO_LOCATION_ID') then
220: -- get the location id to find the location code
221: v_location_id := y_table(ak_query_pkg.g_items_table(i).value_id);
222: elsif (ak_query_pkg.g_items_table(i).attribute_code =

Line 221: v_location_id := y_table(ak_query_pkg.g_items_table(i).value_id);

217: v_org := y_table(ak_query_pkg.g_items_table(i).value_id);
218: elsif(ak_query_pkg.g_items_table(i).attribute_code =
219: 'ICX_DELIVER_TO_LOCATION_ID') then
220: -- get the location id to find the location code
221: v_location_id := y_table(ak_query_pkg.g_items_table(i).value_id);
222: elsif (ak_query_pkg.g_items_table(i).attribute_code =
223: 'ICX_DELIVER_TO_REQUESTOR_ID') then
224: v_requestor_id := y_table(ak_query_pkg.g_items_table(i).value_id);
225: else

Line 222: elsif (ak_query_pkg.g_items_table(i).attribute_code =

218: elsif(ak_query_pkg.g_items_table(i).attribute_code =
219: 'ICX_DELIVER_TO_LOCATION_ID') then
220: -- get the location id to find the location code
221: v_location_id := y_table(ak_query_pkg.g_items_table(i).value_id);
222: elsif (ak_query_pkg.g_items_table(i).attribute_code =
223: 'ICX_DELIVER_TO_REQUESTOR_ID') then
224: v_requestor_id := y_table(ak_query_pkg.g_items_table(i).value_id);
225: else
226: htp.tableRowOpen;

Line 224: v_requestor_id := y_table(ak_query_pkg.g_items_table(i).value_id);

220: -- get the location id to find the location code
221: v_location_id := y_table(ak_query_pkg.g_items_table(i).value_id);
222: elsif (ak_query_pkg.g_items_table(i).attribute_code =
223: 'ICX_DELIVER_TO_REQUESTOR_ID') then
224: v_requestor_id := y_table(ak_query_pkg.g_items_table(i).value_id);
225: else
226: htp.tableRowOpen;
227: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
228: htp.tableData(cvalue => ' ');

Line 227: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');

223: 'ICX_DELIVER_TO_REQUESTOR_ID') then
224: v_requestor_id := y_table(ak_query_pkg.g_items_table(i).value_id);
225: else
226: htp.tableRowOpen;
227: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
228: htp.tableData(cvalue => ' ');
229: htp.p('');
230: htp.p('');
231: if ak_query_pkg.g_items_table(i).italic = 'Y' then

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

227: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
228: htp.tableData(cvalue => ' ');
229: htp.p('');
230: htp.p('');
231: if ak_query_pkg.g_items_table(i).italic = 'Y' then
232: htp.p('');
233: end if;
234: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
235: if ak_query_pkg.g_items_table(i).italic = 'Y' then

Line 234: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));

230: htp.p('');
231: if ak_query_pkg.g_items_table(i).italic = 'Y' then
232: htp.p('');
233: end if;
234: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
235: if ak_query_pkg.g_items_table(i).italic = 'Y' then
236: htp.p('');
237: end if;
238: htp.p('');

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

231: if ak_query_pkg.g_items_table(i).italic = 'Y' then
232: htp.p('');
233: end if;
234: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
235: if ak_query_pkg.g_items_table(i).italic = 'Y' then
236: htp.p('');
237: end if;
238: htp.p('');
239:

Line 246: if(ak_query_pkg.g_items_table(i).attribute_code =

242:
243: else
244: -- this is a regular attribute
245:
246: if(ak_query_pkg.g_items_table(i).attribute_code =
247: 'ICX_DELIVER_TO_LOCATION') then
248: open getLoccd(v_location_id);
249: fetch getLoccd into v_location_code;
250: close getLoccd;

Line 252: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');

248: open getLoccd(v_location_id);
249: fetch getLoccd into v_location_code;
250: close getLoccd;
251: htp.tableRowOpen;
252: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
253: htp.tableData(cvalue => ' ');
254: htp.p('');
255: if ak_query_pkg.g_items_table(i).bold = 'Y' then
256: htp.p('');

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

251: htp.tableRowOpen;
252: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
253: htp.tableData(cvalue => ' ');
254: htp.p('');
255: if ak_query_pkg.g_items_table(i).bold = 'Y' then
256: htp.p('');
257: end if;
258: if ak_query_pkg.g_items_table(i).italic = 'Y' then
259: htp.p('');

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

254: htp.p('');
255: if ak_query_pkg.g_items_table(i).bold = 'Y' then
256: htp.p('');
257: end if;
258: if ak_query_pkg.g_items_table(i).italic = 'Y' then
259: htp.p('');
260: end if;
261: htp.p(v_location_code);
262: if ak_query_pkg.g_items_table(i).italic = 'Y' then

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

258: if ak_query_pkg.g_items_table(i).italic = 'Y' then
259: htp.p('');
260: end if;
261: htp.p(v_location_code);
262: if ak_query_pkg.g_items_table(i).italic = 'Y' then
263: htp.p('');
264: end if;
265: if ak_query_pkg.g_items_table(i).bold = 'Y' then
266: htp.p('');

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

261: htp.p(v_location_code);
262: if ak_query_pkg.g_items_table(i).italic = 'Y' then
263: htp.p('');
264: end if;
265: if ak_query_pkg.g_items_table(i).bold = 'Y' then
266: htp.p('');
267: end if;
268: htp.tableRowClose;
269: elsif(ak_query_pkg.g_items_table(i).attribute_code =

Line 269: elsif(ak_query_pkg.g_items_table(i).attribute_code =

265: if ak_query_pkg.g_items_table(i).bold = 'Y' then
266: htp.p('');
267: end if;
268: htp.tableRowClose;
269: elsif(ak_query_pkg.g_items_table(i).attribute_code =
270: 'ICX_DELIVER_TO_REQUESTOR') then
271: open requestor_name(v_requestor_id);
272: fetch requestor_name into v_requestor_name;
273: close requestor_name;

Line 275: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');

271: open requestor_name(v_requestor_id);
272: fetch requestor_name into v_requestor_name;
273: close requestor_name;
274: htp.tableRowOpen;
275: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
276: htp.tableData(cvalue => ' ');
277: htp.p('');
278: if ak_query_pkg.g_items_table(i).bold = 'Y' then
279: htp.p('');

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

274: htp.tableRowOpen;
275: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
276: htp.tableData(cvalue => ' ');
277: htp.p('');
278: if ak_query_pkg.g_items_table(i).bold = 'Y' then
279: htp.p('');
280: end if;
281: if ak_query_pkg.g_items_table(i).italic = 'Y' then
282: htp.p('');

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

277: htp.p('');
278: if ak_query_pkg.g_items_table(i).bold = 'Y' then
279: htp.p('');
280: end if;
281: if ak_query_pkg.g_items_table(i).italic = 'Y' then
282: htp.p('');
283: end if;
284: htp.p(v_requestor_name);
285: if ak_query_pkg.g_items_table(i).italic = 'Y' then

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

281: if ak_query_pkg.g_items_table(i).italic = 'Y' then
282: htp.p('');
283: end if;
284: htp.p(v_requestor_name);
285: if ak_query_pkg.g_items_table(i).italic = 'Y' then
286: htp.p('');
287: end if;
288: if ak_query_pkg.g_items_table(i).bold = 'Y' then
289: htp.p('');

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

284: htp.p(v_requestor_name);
285: if ak_query_pkg.g_items_table(i).italic = 'Y' then
286: htp.p('');
287: end if;
288: if ak_query_pkg.g_items_table(i).bold = 'Y' then
289: htp.p('');
290: end if;
291: htp.tableRowClose;
292: end if;

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

302:
303: -- Cart Lines Related Object Navigator
304: -- ^^^^^^^^^^
305: --
306: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
307: P_PARENT_REGION_CODE => v_lines_region,
308: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
309: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
310: P_WHERE_CLAUSE => v_where_clause,

Line 327: for i in 0 .. ak_query_pkg.g_items_table.LAST loop

323: -- PrintHead
324: htp.p('');
325:
326: col_no := 0;
327: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
328: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
329: and ak_query_pkg.g_items_table(i).secured_column = 'F'
330: then
331: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'

Line 328: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

324: htp.p('');
325:
326: col_no := 0;
327: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
328: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
329: and ak_query_pkg.g_items_table(i).secured_column = 'F'
330: then
331: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
332: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'

Line 329: and ak_query_pkg.g_items_table(i).secured_column = 'F'

325:
326: col_no := 0;
327: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
328: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
329: and ak_query_pkg.g_items_table(i).secured_column = 'F'
330: then
331: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
332: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
333: then

Line 331: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'

327: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
328: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
329: and ak_query_pkg.g_items_table(i).secured_column = 'F'
330: then
331: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
332: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
333: then
334: null;
335: else

Line 332: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'

328: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
329: and ak_query_pkg.g_items_table(i).secured_column = 'F'
330: then
331: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
332: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
333: then
334: null;
335: else
336: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' or

Line 336: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' or

332: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
333: then
334: null;
335: else
336: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' or
337: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
338: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ')', calign => 'CENTER');
339: else
340: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'CENTER');

Line 337: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then

333: then
334: null;
335: else
336: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' or
337: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
338: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ')', calign => 'CENTER');
339: else
340: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'CENTER');
341: end if;

Line 338: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ')', calign => 'CENTER');

334: null;
335: else
336: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' or
337: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
338: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ')', calign => 'CENTER');
339: else
340: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'CENTER');
341: end if;
342:

Line 340: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'CENTER');

336: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' or
337: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' then
338: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || v_currency || ')', calign => 'CENTER');
339: else
340: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'CENTER');
341: end if;
342:
343: col_no := col_no + 1;
344: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'

Line 344: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'

340: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'CENTER');
341: end if;
342:
343: col_no := col_no + 1;
344: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'
345: then
346: v_ext_price_is_on := TRUE;
347: column_number := col_no;
348: end if;

Line 357: if ak_query_pkg.g_regions_table(0).total_result_count > 0 then

353: -- end PrintHead;
354:
355: -- PrintItems
356: v_order_total := 0;
357: if ak_query_pkg.g_regions_table(0).total_result_count > 0 then
358: for j in 0 .. ak_query_pkg.g_results_table.last loop
359: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
360:
361: htp.tableRowOpen;

Line 358: for j in 0 .. ak_query_pkg.g_results_table.last loop

354:
355: -- PrintItems
356: v_order_total := 0;
357: if ak_query_pkg.g_regions_table(0).total_result_count > 0 then
358: for j in 0 .. ak_query_pkg.g_results_table.last loop
359: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
360:
361: htp.tableRowOpen;
362: for i in 0 .. ak_query_pkg.g_items_table.LAST loop

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

355: -- PrintItems
356: v_order_total := 0;
357: if ak_query_pkg.g_regions_table(0).total_result_count > 0 then
358: for j in 0 .. ak_query_pkg.g_results_table.last loop
359: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
360:
361: htp.tableRowOpen;
362: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
363: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 362: for i in 0 .. ak_query_pkg.g_items_table.LAST loop

358: for j in 0 .. ak_query_pkg.g_results_table.last loop
359: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
360:
361: htp.tableRowOpen;
362: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
363: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
364: and ak_query_pkg.g_items_table(i).secured_column = 'F'
365: then
366: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'

Line 363: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

359: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
360:
361: htp.tableRowOpen;
362: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
363: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
364: and ak_query_pkg.g_items_table(i).secured_column = 'F'
365: then
366: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
367: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'

Line 364: and ak_query_pkg.g_items_table(i).secured_column = 'F'

360:
361: htp.tableRowOpen;
362: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
363: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
364: and ak_query_pkg.g_items_table(i).secured_column = 'F'
365: then
366: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
367: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
368: then

Line 366: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'

362: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
363: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
364: and ak_query_pkg.g_items_table(i).secured_column = 'F'
365: then
366: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
367: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
368: then
369: null;
370: else

Line 367: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'

363: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
364: and ak_query_pkg.g_items_table(i).secured_column = 'F'
365: then
366: if ak_query_pkg.g_items_table(i).item_style = 'HIDDEN'
367: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
368: then
369: null;
370: else
371: if ak_query_pkg.g_items_table(i).value_id is null

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

367: or ak_query_pkg.g_items_table(i).item_style = 'IMAGE'
368: then
369: null;
370: else
371: if ak_query_pkg.g_items_table(i).value_id is null
372: then
373: l_value := '';
374: else
375: l_value := y_table(ak_query_pkg.g_items_table(i).value_id);

Line 375: l_value := y_table(ak_query_pkg.g_items_table(i).value_id);

371: if ak_query_pkg.g_items_table(i).value_id is null
372: then
373: l_value := '';
374: else
375: l_value := y_table(ak_query_pkg.g_items_table(i).value_id);
376:
377: /* compute price total */
378: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'
379: then

Line 378: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'

374: else
375: l_value := y_table(ak_query_pkg.g_items_table(i).value_id);
376:
377: /* compute price total */
378: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'
379: then
380: v_order_total := v_order_total + to_number(nvl(l_value,0));
381: l_value := to_char(to_number(l_value),v_money_fmt_mask);
382: end if;

Line 385: htp.tableData(cvalue => icx_on_utilities.formatText(l_value,ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),

381: l_value := to_char(to_number(l_value),v_money_fmt_mask);
382: end if;
383: end if;
384:
385: htp.tableData(cvalue => icx_on_utilities.formatText(l_value,ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),
386: calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');
387:
388: end if;
389: end if;

Line 386: calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');

382: end if;
383: end if;
384:
385: htp.tableData(cvalue => icx_on_utilities.formatText(l_value,ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),
386: calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');
387:
388: end if;
389: end if;
390: end loop;