DBA Data[Home] [Help]

APPS.POS_ASL_TOLERANCE_PKG dependencies on AK_QUERY_PKG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

274: if p_where_clause is not null then
275: l_where_clause := p_where_clause;
276: end if;
277:
278: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
279: p_parent_region_code => 'POS_ASL_TOLERANCE_R',
280: p_where_clause => l_where_clause,
281: p_responsibility_id => l_responsibility_id,
282: p_user_id => l_user_id,

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

282: p_user_id => l_user_id,
283: p_return_parents => 'T',
284: p_return_children => 'F');
285:
286: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
287:
288: htp.p('');
289: htp.p('');
318:
319: END IF;
320:
321: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
322:
323: END LOOP;
324:
325: htp.p('');

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

343: else
344: htp.p('

');
345: end if;
346:
347: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
348:
349: l_current_col := 0;
350:
351: 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 447: l_attribute_index := ak_query_pkg.g_items_table.FIRST;

443: else
444: htp.p('

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

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

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

');

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

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

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

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

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

507: else
508: htp.p('

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

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

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

');

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

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

');
290:

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

317: htp.p('