DBA Data[Home] [Help]

APPS.POS_ASL_CAPACITY_PKG dependencies on AK_QUERY_PKG

Line 61: if ak_query_pkg.g_items_table(l_index).required_flag = 'Y' then

57:
58:
59: FUNCTION item_reqd(l_index in number) RETURN VARCHAR2 IS
60: BEGIN
61: if ak_query_pkg.g_items_table(l_index).required_flag = 'Y' then
62: return '';
63: else
64: return '';
65: end if;

Line 72: ak_query_pkg.g_items_table(l_index).horizontal_alignment;

68: FUNCTION item_halign(l_index in number) RETURN VARCHAR2 IS
69: BEGIN
70:
71: RETURN ' align=' ||
72: ak_query_pkg.g_items_table(l_index).horizontal_alignment;
73:
74: END item_halign;
75:
76: FUNCTION item_valign(l_index in number) RETURN VARCHAR2 IS

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

76: FUNCTION item_valign(l_index in number) RETURN VARCHAR2 IS
77: BEGIN
78:
79: RETURN ' valign=' ||
80: ak_query_pkg.g_items_table(l_index).vertical_alignment;
81:
82: END item_valign;
83:
84: FUNCTION item_name(l_index in number) RETURN VARCHAR2 IS

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

83:
84: FUNCTION item_name(l_index in number) RETURN VARCHAR2 IS
85: BEGIN
86:
87: RETURN ak_query_pkg.g_items_table(l_index).attribute_label_long;
88:
89: END item_name;
90:
91: FUNCTION item_code(l_index in number) RETURN VARCHAR2 IS

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

90:
91: FUNCTION item_code(l_index in number) RETURN VARCHAR2 IS
92: BEGIN
93:
94: RETURN ak_query_pkg.g_items_table(l_index).attribute_code;
95:
96: END item_code;
97:
98: FUNCTION item_style(l_index in number) RETURN VARCHAR2 IS

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

97:
98: FUNCTION item_style(l_index in number) RETURN VARCHAR2 IS
99: BEGIN
100:
101: RETURN ak_query_pkg.g_items_table(l_index).item_style;
102:
103: END item_style;
104:
105: FUNCTION item_displayed(l_index in number) RETURN BOOLEAN IS

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

104:
105: FUNCTION item_displayed(l_index in number) RETURN BOOLEAN IS
106: BEGIN
107:
108: RETURN (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y');
109:
110: END item_displayed;
111:
112: FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS

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

111:
112: FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
113: BEGIN
114:
115: RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');
116:
117: END item_updateable;
118:
119: FUNCTION item_size (l_index in number) RETURN VARCHAR2 IS

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

118:
119: FUNCTION item_size (l_index in number) RETURN VARCHAR2 IS
120: BEGIN
121:
122: RETURN ' size=' || to_char(ak_query_pkg.g_items_table(l_index).display_value_length);
123:
124: END item_size;
125:
126: FUNCTION item_lov(l_index in number) RETURN VARCHAR2 IS

Line 129: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND

125:
126: FUNCTION item_lov(l_index in number) RETURN VARCHAR2 IS
127: BEGIN
128:
129: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
130: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL)
131: THEN
132: return '

Line 130: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL)

126: FUNCTION item_lov(l_index in number) RETURN VARCHAR2 IS
127: BEGIN
128:
129: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
130: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL)
131: THEN
132: return ' 134: '>

Line 145: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND

141:
142: FUNCTION item_lov_multi(l_index in number, l_row in number) RETURN VARCHAR2 IS
143: BEGIN
144:
145: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
146: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL)
147: THEN
148: return ' 149: item_code(l_index) || '''' || ',' || '''' || to_char(l_row-1) ||
150: '''' || ',' || '''' || l_script_name ||

Line 193: IF ak_query_pkg.g_results_table.count > 0 THEN

189: l_execute INTEGER;
190: l_result VARCHAR2(2000);
191: BEGIN
192:
193: IF ak_query_pkg.g_results_table.count > 0 THEN
194:
195: sql_statement := 'begin ' ||
196: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||
197: to_char(p_col) || '; ' ||

Line 196: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||

192:
193: IF ak_query_pkg.g_results_table.count > 0 THEN
194:
195: sql_statement := 'begin ' ||
196: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||
197: to_char(p_col) || '; ' ||
198: ' end;';
199:
200: l_cursor := dbms_sql.open_cursor;

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

279: if p_where_clause is not null then
280: l_where_clause := p_where_clause;
281: end if;
282:
283: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
284: p_parent_region_code => 'POS_SUPPLIER_ITEM_CAPACITY_R',
285: p_where_clause => l_where_clause,
286: p_responsibility_id => l_responsibility_id,
287: p_user_id => l_user_id,

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

287: p_user_id => l_user_id,
288: p_return_parents => 'T',
289: p_return_children => 'F');
290:
291: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
292:
293: htp.p('');
294: htp.p('');
325:
326: END IF;
327:
328: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
329:
330: END LOOP;
331:
332: htp.p('');

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

352: else
353: htp.p('

');
354: end if;
355:
356: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
357:
358: l_current_col := 0;
359:
360: WHILE (l_attribute_index IS NOT NULL) LOOP

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

418: END IF;
419: END IF;
420: END IF;
421:
422: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
423:
424: END LOOP;
425:
426: htp.p('

');

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

442: else
443: htp.p('

');
444: end if;
445:
446: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
447:
448: l_current_col := 0;
449:
450: WHILE (l_attribute_index IS NOT NULL) LOOP

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

470:
471: END IF;
472: END IF;
473:
474: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
475:
476: END LOOP;
477:
478: htp.p('

');

Line 498: IF ak_query_pkg.g_results_table.count > 0 THEN

494: /* ----- print contents -----------*/
495:
496: l_current_row := 0;
497:
498: IF ak_query_pkg.g_results_table.count > 0 THEN
499:
500: l_result_index := ak_query_pkg.g_results_table.FIRST;
501:
502: WHILE (l_result_index IS NOT NULL) LOOP

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

496: l_current_row := 0;
497:
498: IF ak_query_pkg.g_results_table.count > 0 THEN
499:
500: l_result_index := ak_query_pkg.g_results_table.FIRST;
501:
502: WHILE (l_result_index IS NOT NULL) LOOP
503:
504: l_current_row := l_current_row + 1;

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

508: else
509: htp.p('

');
510: end if;
511:
512: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
513:
514: l_current_col := 0;
515:
516: WHILE (l_attribute_index IS NOT NULL) LOOP

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

557: END IF;
558: END IF;
559: END IF;
560:
561: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
562:
563: END LOOP;
564:
565: htp.p('

');

Line 567: l_result_index := ak_query_pkg.g_results_table.NEXT(l_result_index);

563: END LOOP;
564:
565: htp.p('');
566:
567: l_result_index := ak_query_pkg.g_results_table.NEXT(l_result_index);
568:
569: END LOOP;
570:
571: END IF;

');
295:

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

324: htp.p('