APPS.POS_ASBN dependencies on AK_QUERY_PKG

Line 179: ak_query_pkg.g_items_table(l_index).vertical_alignment;

175: FUNCTION item_valign(l_index in number) RETURN VARCHAR2 IS
176: BEGIN
177:
178: RETURN ' valign=' ||
179: ak_query_pkg.g_items_table(l_index).vertical_alignment;
180:
181: END item_valign;
182:
183: FUNCTION item_name(l_index in number) RETURN VARCHAR2 IS

Line 186: RETURN ak_query_pkg.g_items_table(l_index).attribute_label_long;

182:
183: FUNCTION item_name(l_index in number) RETURN VARCHAR2 IS
184: BEGIN
185:
186: RETURN ak_query_pkg.g_items_table(l_index).attribute_label_long;
187:
188: END item_name;
189:
190: FUNCTION item_code(l_index in number) RETURN VARCHAR2 IS

Line 193: RETURN ak_query_pkg.g_items_table(l_index).attribute_code;

189:
190: FUNCTION item_code(l_index in number) RETURN VARCHAR2 IS
191: BEGIN
192:
193: RETURN ak_query_pkg.g_items_table(l_index).attribute_code;
194:
195: END item_code;
196:
197: FUNCTION item_style(l_index in number) RETURN VARCHAR2 IS

Line 200: RETURN ak_query_pkg.g_items_table(l_index).item_style;

196:
197: FUNCTION item_style(l_index in number) RETURN VARCHAR2 IS
198: BEGIN
199:
200: RETURN ak_query_pkg.g_items_table(l_index).item_style;
201:
202: END item_style;
203:
204: FUNCTION item_displayed(l_index in number) RETURN BOOLEAN IS

Line 207: RETURN (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y');

203:
204: FUNCTION item_displayed(l_index in number) RETURN BOOLEAN IS
205: BEGIN
206:
207: RETURN (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y');
208:
209: END item_displayed;
210:
211: FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS

Line 214: RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');

210:
211: FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
212: BEGIN
213:
214: RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');
215:
216: END item_updateable;
217:
218: FUNCTION item_maxlength (l_index in number) RETURN VARCHAR2 IS

Line 222: to_char(ak_query_pkg.g_items_table(l_index).attribute_value_length);

218: FUNCTION item_maxlength (l_index in number) RETURN VARCHAR2 IS
219: BEGIN
220:
221: RETURN ' maxlength=' ||
222: to_char(ak_query_pkg.g_items_table(l_index).attribute_value_length);
223:
224: END item_maxlength;
225:
226:

Line 230: RETURN ' size=' || to_char(ak_query_pkg.g_items_table(l_index).display_value_length);

226:
227: FUNCTION item_size (l_index in number) RETURN VARCHAR2 IS
228: BEGIN
229:
230: RETURN ' size=' || to_char(ak_query_pkg.g_items_table(l_index).display_value_length);
231:
232: END item_size;
233:
234: FUNCTION set_session_info RETURN BOOLEAN is

Line 262: if ak_query_pkg.g_results_table.count = 0 then

258: l_execute INTEGER;
259: l_result VARCHAR2(2000);
260: BEGIN
261:
262: if ak_query_pkg.g_results_table.count = 0 then
263: return '';
264: end if;
265: if p_col = 1 then
266: return ak_query_pkg.g_results_table(p_index).value1;

Line 266: return ak_query_pkg.g_results_table(p_index).value1;

262: if ak_query_pkg.g_results_table.count = 0 then
263: return '';
264: end if;
265: if p_col = 1 then
266: return ak_query_pkg.g_results_table(p_index).value1;
267: elsif p_col = 2 then
268: return ak_query_pkg.g_results_table(p_index).value2;
269: elsif p_col = 3 then
270: return ak_query_pkg.g_results_table(p_index).value3;

Line 268: return ak_query_pkg.g_results_table(p_index).value2;

264: end if;
265: if p_col = 1 then
266: return ak_query_pkg.g_results_table(p_index).value1;
267: elsif p_col = 2 then
268: return ak_query_pkg.g_results_table(p_index).value2;
269: elsif p_col = 3 then
270: return ak_query_pkg.g_results_table(p_index).value3;
271: elsif p_col = 4 then
272: return ak_query_pkg.g_results_table(p_index).value4;

Line 270: return ak_query_pkg.g_results_table(p_index).value3;

266: return ak_query_pkg.g_results_table(p_index).value1;
267: elsif p_col = 2 then
268: return ak_query_pkg.g_results_table(p_index).value2;
269: elsif p_col = 3 then
270: return ak_query_pkg.g_results_table(p_index).value3;
271: elsif p_col = 4 then
272: return ak_query_pkg.g_results_table(p_index).value4;
273: elsif p_col = 5 then
274: return ak_query_pkg.g_results_table(p_index).value5;

Line 272: return ak_query_pkg.g_results_table(p_index).value4;

268: return ak_query_pkg.g_results_table(p_index).value2;
269: elsif p_col = 3 then
270: return ak_query_pkg.g_results_table(p_index).value3;
271: elsif p_col = 4 then
272: return ak_query_pkg.g_results_table(p_index).value4;
273: elsif p_col = 5 then
274: return ak_query_pkg.g_results_table(p_index).value5;
275: elsif p_col = 6 then
276: return ak_query_pkg.g_results_table(p_index).value6;

Line 274: return ak_query_pkg.g_results_table(p_index).value5;

270: return ak_query_pkg.g_results_table(p_index).value3;
271: elsif p_col = 4 then
272: return ak_query_pkg.g_results_table(p_index).value4;
273: elsif p_col = 5 then
274: return ak_query_pkg.g_results_table(p_index).value5;
275: elsif p_col = 6 then
276: return ak_query_pkg.g_results_table(p_index).value6;
277: elsif p_col = 7 then
278: return ak_query_pkg.g_results_table(p_index).value7;

Line 276: return ak_query_pkg.g_results_table(p_index).value6;

272: return ak_query_pkg.g_results_table(p_index).value4;
273: elsif p_col = 5 then
274: return ak_query_pkg.g_results_table(p_index).value5;
275: elsif p_col = 6 then
276: return ak_query_pkg.g_results_table(p_index).value6;
277: elsif p_col = 7 then
278: return ak_query_pkg.g_results_table(p_index).value7;
279: elsif p_col = 8 then
280: return ak_query_pkg.g_results_table(p_index).value8;

Line 278: return ak_query_pkg.g_results_table(p_index).value7;

274: return ak_query_pkg.g_results_table(p_index).value5;
275: elsif p_col = 6 then
276: return ak_query_pkg.g_results_table(p_index).value6;
277: elsif p_col = 7 then
278: return ak_query_pkg.g_results_table(p_index).value7;
279: elsif p_col = 8 then
280: return ak_query_pkg.g_results_table(p_index).value8;
281: elsif p_col = 9 then
282: return ak_query_pkg.g_results_table(p_index).value9;

Line 280: return ak_query_pkg.g_results_table(p_index).value8;

276: return ak_query_pkg.g_results_table(p_index).value6;
277: elsif p_col = 7 then
278: return ak_query_pkg.g_results_table(p_index).value7;
279: elsif p_col = 8 then
280: return ak_query_pkg.g_results_table(p_index).value8;
281: elsif p_col = 9 then
282: return ak_query_pkg.g_results_table(p_index).value9;
283: elsif p_col = 10 then
284: return ak_query_pkg.g_results_table(p_index).value10;

Line 282: return ak_query_pkg.g_results_table(p_index).value9;

278: return ak_query_pkg.g_results_table(p_index).value7;
279: elsif p_col = 8 then
280: return ak_query_pkg.g_results_table(p_index).value8;
281: elsif p_col = 9 then
282: return ak_query_pkg.g_results_table(p_index).value9;
283: elsif p_col = 10 then
284: return ak_query_pkg.g_results_table(p_index).value10;
285: elsif p_col = 11 then
286: return ak_query_pkg.g_results_table(p_index).value11;

Line 284: return ak_query_pkg.g_results_table(p_index).value10;

280: return ak_query_pkg.g_results_table(p_index).value8;
281: elsif p_col = 9 then
282: return ak_query_pkg.g_results_table(p_index).value9;
283: elsif p_col = 10 then
284: return ak_query_pkg.g_results_table(p_index).value10;
285: elsif p_col = 11 then
286: return ak_query_pkg.g_results_table(p_index).value11;
287: elsif p_col = 12 then
288: return ak_query_pkg.g_results_table(p_index).value12;

Line 286: return ak_query_pkg.g_results_table(p_index).value11;

282: return ak_query_pkg.g_results_table(p_index).value9;
283: elsif p_col = 10 then
284: return ak_query_pkg.g_results_table(p_index).value10;
285: elsif p_col = 11 then
286: return ak_query_pkg.g_results_table(p_index).value11;
287: elsif p_col = 12 then
288: return ak_query_pkg.g_results_table(p_index).value12;
289: elsif p_col = 13 then
290: return ak_query_pkg.g_results_table(p_index).value13;

Line 288: return ak_query_pkg.g_results_table(p_index).value12;

284: return ak_query_pkg.g_results_table(p_index).value10;
285: elsif p_col = 11 then
286: return ak_query_pkg.g_results_table(p_index).value11;
287: elsif p_col = 12 then
288: return ak_query_pkg.g_results_table(p_index).value12;
289: elsif p_col = 13 then
290: return ak_query_pkg.g_results_table(p_index).value13;
291: elsif p_col = 14 then
292: return ak_query_pkg.g_results_table(p_index).value14;

Line 290: return ak_query_pkg.g_results_table(p_index).value13;

286: return ak_query_pkg.g_results_table(p_index).value11;
287: elsif p_col = 12 then
288: return ak_query_pkg.g_results_table(p_index).value12;
289: elsif p_col = 13 then
290: return ak_query_pkg.g_results_table(p_index).value13;
291: elsif p_col = 14 then
292: return ak_query_pkg.g_results_table(p_index).value14;
293: elsif p_col = 15 then
294: return ak_query_pkg.g_results_table(p_index).value15;

Line 292: return ak_query_pkg.g_results_table(p_index).value14;

288: return ak_query_pkg.g_results_table(p_index).value12;
289: elsif p_col = 13 then
290: return ak_query_pkg.g_results_table(p_index).value13;
291: elsif p_col = 14 then
292: return ak_query_pkg.g_results_table(p_index).value14;
293: elsif p_col = 15 then
294: return ak_query_pkg.g_results_table(p_index).value15;
295: elsif p_col = 16 then
296: return ak_query_pkg.g_results_table(p_index).value16;

Line 294: return ak_query_pkg.g_results_table(p_index).value15;

290: return ak_query_pkg.g_results_table(p_index).value13;
291: elsif p_col = 14 then
292: return ak_query_pkg.g_results_table(p_index).value14;
293: elsif p_col = 15 then
294: return ak_query_pkg.g_results_table(p_index).value15;
295: elsif p_col = 16 then
296: return ak_query_pkg.g_results_table(p_index).value16;
297: elsif p_col = 17 then
298: return ak_query_pkg.g_results_table(p_index).value17;

Line 296: return ak_query_pkg.g_results_table(p_index).value16;

292: return ak_query_pkg.g_results_table(p_index).value14;
293: elsif p_col = 15 then
294: return ak_query_pkg.g_results_table(p_index).value15;
295: elsif p_col = 16 then
296: return ak_query_pkg.g_results_table(p_index).value16;
297: elsif p_col = 17 then
298: return ak_query_pkg.g_results_table(p_index).value17;
299: elsif p_col = 18 then
300: return ak_query_pkg.g_results_table(p_index).value18;

Line 298: return ak_query_pkg.g_results_table(p_index).value17;

294: return ak_query_pkg.g_results_table(p_index).value15;
295: elsif p_col = 16 then
296: return ak_query_pkg.g_results_table(p_index).value16;
297: elsif p_col = 17 then
298: return ak_query_pkg.g_results_table(p_index).value17;
299: elsif p_col = 18 then
300: return ak_query_pkg.g_results_table(p_index).value18;
301: elsif p_col = 19 then
302: return ak_query_pkg.g_results_table(p_index).value19;

Line 300: return ak_query_pkg.g_results_table(p_index).value18;

296: return ak_query_pkg.g_results_table(p_index).value16;
297: elsif p_col = 17 then
298: return ak_query_pkg.g_results_table(p_index).value17;
299: elsif p_col = 18 then
300: return ak_query_pkg.g_results_table(p_index).value18;
301: elsif p_col = 19 then
302: return ak_query_pkg.g_results_table(p_index).value19;
303: elsif p_col = 20 then
304: return ak_query_pkg.g_results_table(p_index).value20;

Line 302: return ak_query_pkg.g_results_table(p_index).value19;

298: return ak_query_pkg.g_results_table(p_index).value17;
299: elsif p_col = 18 then
300: return ak_query_pkg.g_results_table(p_index).value18;
301: elsif p_col = 19 then
302: return ak_query_pkg.g_results_table(p_index).value19;
303: elsif p_col = 20 then
304: return ak_query_pkg.g_results_table(p_index).value20;
305: elsif p_col = 21 then
306: return ak_query_pkg.g_results_table(p_index).value21;

Line 304: return ak_query_pkg.g_results_table(p_index).value20;

300: return ak_query_pkg.g_results_table(p_index).value18;
301: elsif p_col = 19 then
302: return ak_query_pkg.g_results_table(p_index).value19;
303: elsif p_col = 20 then
304: return ak_query_pkg.g_results_table(p_index).value20;
305: elsif p_col = 21 then
306: return ak_query_pkg.g_results_table(p_index).value21;
307: elsif p_col = 22 then
308: return ak_query_pkg.g_results_table(p_index).value22;

Line 306: return ak_query_pkg.g_results_table(p_index).value21;

302: return ak_query_pkg.g_results_table(p_index).value19;
303: elsif p_col = 20 then
304: return ak_query_pkg.g_results_table(p_index).value20;
305: elsif p_col = 21 then
306: return ak_query_pkg.g_results_table(p_index).value21;
307: elsif p_col = 22 then
308: return ak_query_pkg.g_results_table(p_index).value22;
309: elsif p_col = 23 then
310: return ak_query_pkg.g_results_table(p_index).value23;

Line 308: return ak_query_pkg.g_results_table(p_index).value22;

304: return ak_query_pkg.g_results_table(p_index).value20;
305: elsif p_col = 21 then
306: return ak_query_pkg.g_results_table(p_index).value21;
307: elsif p_col = 22 then
308: return ak_query_pkg.g_results_table(p_index).value22;
309: elsif p_col = 23 then
310: return ak_query_pkg.g_results_table(p_index).value23;
311: elsif p_col = 24 then
312: return ak_query_pkg.g_results_table(p_index).value24;

Line 310: return ak_query_pkg.g_results_table(p_index).value23;

306: return ak_query_pkg.g_results_table(p_index).value21;
307: elsif p_col = 22 then
308: return ak_query_pkg.g_results_table(p_index).value22;
309: elsif p_col = 23 then
310: return ak_query_pkg.g_results_table(p_index).value23;
311: elsif p_col = 24 then
312: return ak_query_pkg.g_results_table(p_index).value24;
313: elsif p_col = 25 then
314: return ak_query_pkg.g_results_table(p_index).value25;

Line 312: return ak_query_pkg.g_results_table(p_index).value24;

308: return ak_query_pkg.g_results_table(p_index).value22;
309: elsif p_col = 23 then
310: return ak_query_pkg.g_results_table(p_index).value23;
311: elsif p_col = 24 then
312: return ak_query_pkg.g_results_table(p_index).value24;
313: elsif p_col = 25 then
314: return ak_query_pkg.g_results_table(p_index).value25;
315: elsif p_col = 26 then
316: return ak_query_pkg.g_results_table(p_index).value26;

Line 314: return ak_query_pkg.g_results_table(p_index).value25;

310: return ak_query_pkg.g_results_table(p_index).value23;
311: elsif p_col = 24 then
312: return ak_query_pkg.g_results_table(p_index).value24;
313: elsif p_col = 25 then
314: return ak_query_pkg.g_results_table(p_index).value25;
315: elsif p_col = 26 then
316: return ak_query_pkg.g_results_table(p_index).value26;
317: elsif p_col = 27 then
318: return ak_query_pkg.g_results_table(p_index).value27;

Line 316: return ak_query_pkg.g_results_table(p_index).value26;

312: return ak_query_pkg.g_results_table(p_index).value24;
313: elsif p_col = 25 then
314: return ak_query_pkg.g_results_table(p_index).value25;
315: elsif p_col = 26 then
316: return ak_query_pkg.g_results_table(p_index).value26;
317: elsif p_col = 27 then
318: return ak_query_pkg.g_results_table(p_index).value27;
319: elsif p_col = 28 then
320: return ak_query_pkg.g_results_table(p_index).value28;

Line 318: return ak_query_pkg.g_results_table(p_index).value27;

314: return ak_query_pkg.g_results_table(p_index).value25;
315: elsif p_col = 26 then
316: return ak_query_pkg.g_results_table(p_index).value26;
317: elsif p_col = 27 then
318: return ak_query_pkg.g_results_table(p_index).value27;
319: elsif p_col = 28 then
320: return ak_query_pkg.g_results_table(p_index).value28;
321: elsif p_col = 29 then
322: return ak_query_pkg.g_results_table(p_index).value29;

Line 320: return ak_query_pkg.g_results_table(p_index).value28;

316: return ak_query_pkg.g_results_table(p_index).value26;
317: elsif p_col = 27 then
318: return ak_query_pkg.g_results_table(p_index).value27;
319: elsif p_col = 28 then
320: return ak_query_pkg.g_results_table(p_index).value28;
321: elsif p_col = 29 then
322: return ak_query_pkg.g_results_table(p_index).value29;
323: elsif p_col = 30 then
324: return ak_query_pkg.g_results_table(p_index).value30;

Line 322: return ak_query_pkg.g_results_table(p_index).value29;

318: return ak_query_pkg.g_results_table(p_index).value27;
319: elsif p_col = 28 then
320: return ak_query_pkg.g_results_table(p_index).value28;
321: elsif p_col = 29 then
322: return ak_query_pkg.g_results_table(p_index).value29;
323: elsif p_col = 30 then
324: return ak_query_pkg.g_results_table(p_index).value30;
325: end if;
326:

Line 324: return ak_query_pkg.g_results_table(p_index).value30;

320: return ak_query_pkg.g_results_table(p_index).value28;
321: elsif p_col = 29 then
322: return ak_query_pkg.g_results_table(p_index).value29;
323: elsif p_col = 30 then
324: return ak_query_pkg.g_results_table(p_index).value30;
325: end if;
326:
327: END get_result_value;
328:

Line 485: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,

481: '');
482: htp.p('');
483: htp.p('');
484:
485: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
486: p_parent_region_code => 'POS_ASBN_HEADERS_R',
487: p_where_clause => l_where_clause,
488: p_responsibility_id => g_responsibility_id,
489: p_user_id => g_user_id,

Line 493: l_attribute_index := ak_query_pkg.g_items_table.FIRST;

489: p_user_id => g_user_id,
490: p_return_parents => 'T',
491: p_return_children => 'F');
492:
493: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
494: l_result_index := ak_query_pkg.g_results_table.FIRST;
495:
496: htp.p('');
497:

Line 494: l_result_index := ak_query_pkg.g_results_table.FIRST;

490: p_return_parents => 'T',
491: p_return_children => 'F');
492:
493: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
494: l_result_index := ak_query_pkg.g_results_table.FIRST;
495:
496: htp.p('

');
497:
498: htp.p('');

Line 580: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);

576: END IF;
577:
578: END IF;
579:
580: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
581:
582: -- if ((l_current_col mod 2) = 0) THEN
583: htp.p('

');
584: htp.p('');