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;
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
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
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
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
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
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
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
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
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 '
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: '>
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 ||
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) || '; ' ||
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;
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,
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('
'); 290: Line 321: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index); | ');