APPS.ICX_ON_UTILITIES2 dependencies on HTP

Line 38: htp.p('');
50: else
51: htp.p('');

45: }
46: }');
47:
48: htp.p('// -->');
49: htp.p('');
50: else
51: htp.p('');
50: else
51: htp.p('');
50: else
51: htp.p('');
50: else
51: htp.p('');

52: htp.p('');
57: htp.p('');
58: end if;
59: end if;
60:

Line 57: htp.p('');

53: htp.p('function set_icon(X) {
54: '||l_target||'.location="'||icx_cabo.g_base_href||'" + X;
55: }');
56: htp.p('// -->');
57: htp.p('');
58: end if;
59: end if;
60:
61: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%"');

Line 61: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%"');

57: htp.p('');
58: end if;
59: end if;
60:
61: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%"');
62: htp.tableRowOpen;
63:
64: if p_start_row <= 1
65: then

Line 62: htp.tableRowOpen;

58: end if;
59: end if;
60:
61: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%"');
62: htp.tableRowOpen;
63:
64: if p_start_row <= 1
65: then
66: if p_stop_row < p_row_count

Line 68: htp.p('');

64: if p_start_row <= 1
65: then
66: if p_stop_row < p_row_count
67: then
68: htp.p('');
69: htp.img(curl => '/OA_MEDIA/FNDIFRSD.gif', cattributes => 'width=22 height=22');
70: htp.p('');
71: htp.p('');
72: htp.p('');

Line 69: htp.img(curl => '/OA_MEDIA/FNDIFRSD.gif', cattributes => 'width=22 height=22');

65: then
66: if p_stop_row < p_row_count
67: then
68: htp.p('');
69: htp.img(curl => '/OA_MEDIA/FNDIFRSD.gif', cattributes => 'width=22 height=22');
70: htp.p('');
71: htp.p('');
72: htp.p('');
73: htp.p('');

Line 70: htp.p('');

66: if p_stop_row < p_row_count
67: then
68: htp.p('');
69: htp.img(curl => '/OA_MEDIA/FNDIFRSD.gif', cattributes => 'width=22 height=22');
70: htp.p('');
71: htp.p('');
72: htp.p('');
73: htp.p('');
74: htp.img(curl => '/OA_MEDIA/FNDIPRED.gif', cattributes => 'width=22 height=22');

Line 71: htp.p('');

67: then
68: htp.p('');
69: htp.img(curl => '/OA_MEDIA/FNDIFRSD.gif', cattributes => 'width=22 height=22');
70: htp.p('');
71: htp.p('');
72: htp.p('');
73: htp.p('');
74: htp.img(curl => '/OA_MEDIA/FNDIPRED.gif', cattributes => 'width=22 height=22');
75: htp.p('');

Line 72: htp.p('');

68: htp.p('');
69: htp.img(curl => '/OA_MEDIA/FNDIFRSD.gif', cattributes => 'width=22 height=22');
70: htp.p('');
71: htp.p('');
72: htp.p('');
73: htp.p('');
74: htp.img(curl => '/OA_MEDIA/FNDIPRED.gif', cattributes => 'width=22 height=22');
75: htp.p('');
76: htp.p('');

Line 73: htp.p('');

69: htp.img(curl => '/OA_MEDIA/FNDIFRSD.gif', cattributes => 'width=22 height=22');
70: htp.p('');
71: htp.p('');
72: htp.p('');
73: htp.p('');
74: htp.img(curl => '/OA_MEDIA/FNDIPRED.gif', cattributes => 'width=22 height=22');
75: htp.p('');
76: htp.p('');
77: htp.p('');

Line 74: htp.img(curl => '/OA_MEDIA/FNDIPRED.gif', cattributes => 'width=22 height=22');

70: htp.p('');
71: htp.p('');
72: htp.p('');
73: htp.p('');
74: htp.img(curl => '/OA_MEDIA/FNDIPRED.gif', cattributes => 'width=22 height=22');
75: htp.p('');
76: htp.p('');
77: htp.p('');
78: end if;

Line 75: htp.p('');

71: htp.p('');
72: htp.p('');
73: htp.p('');
74: htp.img(curl => '/OA_MEDIA/FNDIPRED.gif', cattributes => 'width=22 height=22');
75: htp.p('');
76: htp.p('');
77: htp.p('');
78: end if;
79: else

Line 76: htp.p('');

72: htp.p('');
73: htp.p('');
74: htp.img(curl => '/OA_MEDIA/FNDIPRED.gif', cattributes => 'width=22 height=22');
75: htp.p('');
76: htp.p('');
77: htp.p('');
78: end if;
79: else
80: fnd_message.set_name('ICX','ICX_TABLE_SET');

Line 77: htp.p('');

73: htp.p('');
74: htp.img(curl => '/OA_MEDIA/FNDIPRED.gif', cattributes => 'width=22 height=22');
75: htp.p('');
76: htp.p('');
77: htp.p('');
78: end if;
79: else
80: fnd_message.set_name('ICX','ICX_TABLE_SET');
81: fnd_message.set_token('FROM_ROW_TOKEN','1');

Line 85: htp.p('');

81: fnd_message.set_token('FROM_ROW_TOKEN','1');
82: fnd_message.set_token('TO_ROW_TOKEN',p_query_set);
83: l_message := fnd_message.get;
84:
85: htp.p('');
86: if p_jsproc is null then
87: l_parameter := '?p_start_row='||1||'&'||'p_end_row='||p_query_set||'&'||'p_where='||p_encrypted_where;
88: if p_hidden is not null
89: then

Line 92: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')',

88: if p_hidden is not null
89: then
90: l_parameter := l_parameter||'&'||'p_hidden='||p_hidden;
91: end if;
92: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')',
93: htf.img(curl => '/OA_MEDIA/FNDIFRST.gif', calt => icx_util.replace_alt_quotes(l_prompts(1)),
94: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
95: else
96: htp.anchor('javascript:'||p_jsproc||'(''1'','''||p_query_set||''')',

Line 96: htp.anchor('javascript:'||p_jsproc||'(''1'','''||p_query_set||''')',

92: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')',
93: htf.img(curl => '/OA_MEDIA/FNDIFRST.gif', calt => icx_util.replace_alt_quotes(l_prompts(1)),
94: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
95: else
96: htp.anchor('javascript:'||p_jsproc||'(''1'','''||p_query_set||''')',
97: htf.img(curl => '/OA_MEDIA/FNDIFRST.gif', calt =>icx_util.replace_alt_quotes(l_prompts(1)),
98: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
99: end if;
100: htp.p('');

Line 100: htp.p('');

96: htp.anchor('javascript:'||p_jsproc||'(''1'','''||p_query_set||''')',
97: htf.img(curl => '/OA_MEDIA/FNDIFRST.gif', calt =>icx_util.replace_alt_quotes(l_prompts(1)),
98: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
99: end if;
100: htp.p('');
101: htp.p('');
102: htp.p('');
103:
104: fnd_message.set_name('ICX','ICX_TABLE_SET');

Line 101: htp.p('');

97: htf.img(curl => '/OA_MEDIA/FNDIFRST.gif', calt =>icx_util.replace_alt_quotes(l_prompts(1)),
98: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
99: end if;
100: htp.p('');
101: htp.p('');
102: htp.p('');
103:
104: fnd_message.set_name('ICX','ICX_TABLE_SET');
105: if p_start_row-p_query_set < 1

Line 102: htp.p('');

98: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
99: end if;
100: htp.p('');
101: htp.p('');
102: htp.p('');
103:
104: fnd_message.set_name('ICX','ICX_TABLE_SET');
105: if p_start_row-p_query_set < 1
106: then

Line 116: htp.p('');

112: fnd_message.set_token('TO_ROW_TOKEN',p_start_row-1);
113: l_message := fnd_message.get;
114:
115:
116: htp.p('');
117: if p_jsproc is null then
118: l_parameter := '?p_start_row='||to_char(l_start_row)||'&'||'p_end_row='||to_char(p_start_row-1)||'&'||'p_where='||p_encrypted_where;
119: if p_hidden is not null
120: then

Line 123: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')',

119: if p_hidden is not null
120: then
121: l_parameter := l_parameter||'&'||'p_hidden='||p_hidden;
122: end if;
123: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')',
124: htf.img(curl => '/OA_MEDIA/FNDIPREV.gif', calt => icx_util.replace_alt_quotes(l_prompts(2)),
125: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
126: else
127: htp.anchor('javascript:'||p_jsproc||'('''||to_char(l_start_row)||''','''||to_char(p_start_row-1)||''')',

Line 127: htp.anchor('javascript:'||p_jsproc||'('''||to_char(l_start_row)||''','''||to_char(p_start_row-1)||''')',

123: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')',
124: htf.img(curl => '/OA_MEDIA/FNDIPREV.gif', calt => icx_util.replace_alt_quotes(l_prompts(2)),
125: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
126: else
127: htp.anchor('javascript:'||p_jsproc||'('''||to_char(l_start_row)||''','''||to_char(p_start_row-1)||''')',
128: htf.img(curl => '/OA_MEDIA/FNDIPREV.gif', calt => icx_util.replace_alt_quotes(l_prompts(2)),
129: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
130: end if;
131: htp.p('');

Line 131: htp.p('');

127: htp.anchor('javascript:'||p_jsproc||'('''||to_char(l_start_row)||''','''||to_char(p_start_row-1)||''')',
128: htf.img(curl => '/OA_MEDIA/FNDIPREV.gif', calt => icx_util.replace_alt_quotes(l_prompts(2)),
129: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
130: end if;
131: htp.p('');
132: htp.p('');
133: htp.p('');
134:
135: end if;

Line 132: htp.p('');

128: htf.img(curl => '/OA_MEDIA/FNDIPREV.gif', calt => icx_util.replace_alt_quotes(l_prompts(2)),
129: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
130: end if;
131: htp.p('');
132: htp.p('');
133: htp.p('');
134:
135: end if;
136: fnd_message.set_name('ICX','ICX_RECORDS_RANGE');

Line 133: htp.p('');

129: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
130: end if;
131: htp.p('');
132: htp.p('');
133: htp.p('');
134:
135: end if;
136: fnd_message.set_name('ICX','ICX_RECORDS_RANGE');
137: fnd_message.set_token('FROM_ROW_TOKEN',p_start_row);

Line 142: htp.p(''||l_message||'');

138: fnd_message.set_token('TO_ROW_TOKEN',p_stop_row);
139: fnd_message.set_token('TOTAL_ROW_TOKEN',p_row_count);
140: l_message := fnd_message.get;
141:
142: htp.p(''||l_message||'');
143:
144: if p_stop_row >= p_row_count
145: then
146: if p_start_row > 1

Line 148: htp.p('');

144: if p_stop_row >= p_row_count
145: then
146: if p_start_row > 1
147: then
148: htp.p('');
149: htp.p('');
150: htp.p('');
151: htp.img(curl => '/OA_MEDIA/FNDINEXD.gif', cattributes => 'width=22 height=22');
152: htp.p('');

Line 149: htp.p('');

145: then
146: if p_start_row > 1
147: then
148: htp.p('');
149: htp.p('');
150: htp.p('');
151: htp.img(curl => '/OA_MEDIA/FNDINEXD.gif', cattributes => 'width=22 height=22');
152: htp.p('');
153: htp.p('');

Line 150: htp.p('');

146: if p_start_row > 1
147: then
148: htp.p('');
149: htp.p('');
150: htp.p('');
151: htp.img(curl => '/OA_MEDIA/FNDINEXD.gif', cattributes => 'width=22 height=22');
152: htp.p('');
153: htp.p('');
154: htp.p('');

Line 151: htp.img(curl => '/OA_MEDIA/FNDINEXD.gif', cattributes => 'width=22 height=22');

147: then
148: htp.p('');
149: htp.p('');
150: htp.p('');
151: htp.img(curl => '/OA_MEDIA/FNDINEXD.gif', cattributes => 'width=22 height=22');
152: htp.p('');
153: htp.p('');
154: htp.p('');
155: htp.p('');

Line 152: htp.p('');

148: htp.p('');
149: htp.p('');
150: htp.p('');
151: htp.img(curl => '/OA_MEDIA/FNDINEXD.gif', cattributes => 'width=22 height=22');
152: htp.p('');
153: htp.p('');
154: htp.p('');
155: htp.p('');
156: htp.img(curl => '/OA_MEDIA/FNDILASD.gif', cattributes => 'width=22 height=22');

Line 153: htp.p('');

149: htp.p('');
150: htp.p('');
151: htp.img(curl => '/OA_MEDIA/FNDINEXD.gif', cattributes => 'width=22 height=22');
152: htp.p('');
153: htp.p('');
154: htp.p('');
155: htp.p('');
156: htp.img(curl => '/OA_MEDIA/FNDILASD.gif', cattributes => 'width=22 height=22');
157: htp.p('');

Line 154: htp.p('');

150: htp.p('');
151: htp.img(curl => '/OA_MEDIA/FNDINEXD.gif', cattributes => 'width=22 height=22');
152: htp.p('');
153: htp.p('');
154: htp.p('');
155: htp.p('');
156: htp.img(curl => '/OA_MEDIA/FNDILASD.gif', cattributes => 'width=22 height=22');
157: htp.p('');
158: end if;

Line 155: htp.p('');

151: htp.img(curl => '/OA_MEDIA/FNDINEXD.gif', cattributes => 'width=22 height=22');
152: htp.p('');
153: htp.p('');
154: htp.p('');
155: htp.p('');
156: htp.img(curl => '/OA_MEDIA/FNDILASD.gif', cattributes => 'width=22 height=22');
157: htp.p('');
158: end if;
159: else

Line 156: htp.img(curl => '/OA_MEDIA/FNDILASD.gif', cattributes => 'width=22 height=22');

152: htp.p('');
153: htp.p('');
154: htp.p('');
155: htp.p('');
156: htp.img(curl => '/OA_MEDIA/FNDILASD.gif', cattributes => 'width=22 height=22');
157: htp.p('');
158: end if;
159: else
160: fnd_message.set_name('ICX','ICX_TABLE_SET');

Line 157: htp.p('');

153: htp.p('');
154: htp.p('');
155: htp.p('');
156: htp.img(curl => '/OA_MEDIA/FNDILASD.gif', cattributes => 'width=22 height=22');
157: htp.p('');
158: end if;
159: else
160: fnd_message.set_name('ICX','ICX_TABLE_SET');
161: fnd_message.set_token('FROM_ROW_TOKEN',p_stop_row+1);

Line 171: htp.p('');

167: end if;
168: fnd_message.set_token('TO_ROW_TOKEN',l_stop_row);
169: l_message := fnd_message.get;
170:
171: htp.p('');
172: if p_jsproc is null then
173: l_parameter := '?p_start_row='||to_char(p_stop_row+1)||'&'||'p_end_row='||to_char(l_stop_row)||'&'||'p_where='||p_encrypted_where;
174: if p_hidden is not null
175: then

Line 178: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')', htf.img(curl => '/OA_MEDIA/FNDINEXT.gif', calt => icx_util.replace_alt_quotes(l_prompts(3)),

174: if p_hidden is not null
175: then
176: l_parameter := l_parameter||'&'||'p_hidden='||p_hidden;
177: end if;
178: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')', htf.img(curl => '/OA_MEDIA/FNDINEXT.gif', calt => icx_util.replace_alt_quotes(l_prompts(3)),
179: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
180: else
181: htp.anchor('javascript:'||p_jsproc||'('''||to_char(p_stop_row+1)||''','''||to_char(l_stop_row)||''')',
182: htf.img(curl => '/OA_MEDIA/FNDINEXT.gif', calt => icx_util.replace_alt_quotes(l_prompts(3)),

Line 181: htp.anchor('javascript:'||p_jsproc||'('''||to_char(p_stop_row+1)||''','''||to_char(l_stop_row)||''')',

177: end if;
178: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')', htf.img(curl => '/OA_MEDIA/FNDINEXT.gif', calt => icx_util.replace_alt_quotes(l_prompts(3)),
179: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
180: else
181: htp.anchor('javascript:'||p_jsproc||'('''||to_char(p_stop_row+1)||''','''||to_char(l_stop_row)||''')',
182: htf.img(curl => '/OA_MEDIA/FNDINEXT.gif', calt => icx_util.replace_alt_quotes(l_prompts(3)),
183: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
184: end if;
185: htp.p('');

Line 185: htp.p('');

181: htp.anchor('javascript:'||p_jsproc||'('''||to_char(p_stop_row+1)||''','''||to_char(l_stop_row)||''')',
182: htf.img(curl => '/OA_MEDIA/FNDINEXT.gif', calt => icx_util.replace_alt_quotes(l_prompts(3)),
183: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
184: end if;
185: htp.p('');
186: htp.p('');
187: htp.p('');
188:
189: fnd_message.set_name('ICX','ICX_TABLE_SET');

Line 186: htp.p('');

182: htf.img(curl => '/OA_MEDIA/FNDINEXT.gif', calt => icx_util.replace_alt_quotes(l_prompts(3)),
183: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
184: end if;
185: htp.p('');
186: htp.p('');
187: htp.p('');
188:
189: fnd_message.set_name('ICX','ICX_TABLE_SET');
190: fnd_message.set_token('FROM_ROW_TOKEN',p_row_count-p_query_set+1);

Line 187: htp.p('');

183: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
184: end if;
185: htp.p('');
186: htp.p('');
187: htp.p('');
188:
189: fnd_message.set_name('ICX','ICX_TABLE_SET');
190: fnd_message.set_token('FROM_ROW_TOKEN',p_row_count-p_query_set+1);
191: fnd_message.set_token('TO_ROW_TOKEN',p_row_count);

Line 194: htp.p('');

190: fnd_message.set_token('FROM_ROW_TOKEN',p_row_count-p_query_set+1);
191: fnd_message.set_token('TO_ROW_TOKEN',p_row_count);
192: l_message := fnd_message.get;
193:
194: htp.p('');
195: if p_jsproc is null then
196: l_parameter := '?p_start_row='||to_char(p_row_count-p_query_set+1)||'&'||'p_end_row='||to_char(p_row_count)||'&'||'p_where='||p_encrypted_where;
197: if p_hidden is not null
198: then

Line 201: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')',

197: if p_hidden is not null
198: then
199: l_parameter := l_parameter||'&'||'p_hidden='||p_hidden;
200: end if;
201: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')',
202: htf.img(curl => '/OA_MEDIA/FNDILAST.gif', calt => icx_util.replace_alt_quotes(l_prompts(4)),
203: cattributes => 'width=22 height=22 BORDER=0'),'','onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
204: else
205: htp.anchor('javascript:'||p_jsproc||'('''||to_char(p_row_count-p_query_set+1)||''','''||to_char(p_row_count)||''')',

Line 205: htp.anchor('javascript:'||p_jsproc||'('''||to_char(p_row_count-p_query_set+1)||''','''||to_char(p_row_count)||''')',

201: htp.anchor('javascript:set_icon('''||p_packproc||l_parameter||''')',
202: htf.img(curl => '/OA_MEDIA/FNDILAST.gif', calt => icx_util.replace_alt_quotes(l_prompts(4)),
203: cattributes => 'width=22 height=22 BORDER=0'),'','onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
204: else
205: htp.anchor('javascript:'||p_jsproc||'('''||to_char(p_row_count-p_query_set+1)||''','''||to_char(p_row_count)||''')',
206: htf.img(curl => '/OA_MEDIA/FNDILAST.gif', calt => icx_util.replace_alt_quotes(l_prompts(4)),
207: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
208: end if;
209: htp.p('');

Line 209: htp.p('');

205: htp.anchor('javascript:'||p_jsproc||'('''||to_char(p_row_count-p_query_set+1)||''','''||to_char(p_row_count)||''')',
206: htf.img(curl => '/OA_MEDIA/FNDILAST.gif', calt => icx_util.replace_alt_quotes(l_prompts(4)),
207: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
208: end if;
209: htp.p('');
210: end if;
211: htp.p('');
212:
213: if (p_start_row = 1 and p_stop_row = p_row_count)

Line 211: htp.p('');

207: cattributes => 'width=22 height=22 BORDER=0'),'',' onMouseOver="window.status='''||icx_util.replace_OnMouseOver_quotes(l_message)||''';return true"');
208: end if;
209: htp.p('');
210: end if;
211: htp.p('');
212:
213: if (p_start_row = 1 and p_stop_row = p_row_count)
214: then
215: l_title := '';

Line 221: htp.p('');

217: fnd_message.set_name('ICX','ICX_RECORDS_ALL');
218: fnd_message.set_token('TOTAL_ROW_TOKEN',p_row_count);
219: l_message := fnd_message.get;
220:
221: htp.p('');
222: if p_jsproc is null then
223: l_parameter := '?p_start_row='||1||'&'||'p_end_row='||to_char(p_row_count)||'&'||'p_where='||p_encrypted_where;
224: if p_hidden is not null
225: then

Line 242: htp.p('');

238: P_HyperTextCall => 'javascript:'||p_jsproc||'(''1'','''||to_char(p_row_count)||''')',
239: P_LanguageCode => p_language_code,
240: P_JavaScriptFlag => FALSE);
241: end if;
242: htp.p('');
243: end if;
244:
245: htp.tableRowClose;
246: htp.tableClose;

Line 245: htp.tableRowClose;

241: end if;
242: htp.p('');
243: end if;
244:
245: htp.tableRowClose;
246: htp.tableClose;
247:
248: end;
249:

Line 246: htp.tableClose;

242: htp.p('');
243: end if;
244:
245: htp.tableRowClose;
246: htp.tableClose;
247:
248: end;
249:
250: procedure printText( p_item_rec in ak_query_pkg.item_rec,

Line 290: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_item_rec.display_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);

286: if p_data_type = 'NUMBER'
287: then
288: l_input_check := l_input_check||'check_number(this);';
289: end if;
290: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_item_rec.display_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);
291: elsif p_rowid is not null and p_value is not null
292: then
293: l_Y := 'X*****1****'||p_rowid||'*'||p_goto;
294: htp.tableData(cvalue => ''

Line 294: htp.tableData(cvalue => ''

290: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_item_rec.display_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);
291: elsif p_rowid is not null and p_value is not null
292: then
293: l_Y := 'X*****1****'||p_rowid||'*'||p_goto;
294: htp.tableData(cvalue => ''
295: ||l_display_value, calign => p_item_rec.horizontal_alignment, cattributes => 'VALIGN="'||p_item_rec.vertical_alignment||'"'||l_data_background_color, crowspan => p_rowspan);
296: else
297: htp.tableData(cvalue => l_display_value, calign => p_item_rec.horizontal_alignment, cattributes => 'VALIGN="'||p_item_rec.vertical_alignment||'"'||l_data_background_color, crowspan => p_rowspan);
298: end if;

293: l_Y := 'X*****1****'||p_rowid||'*'||p_goto;
294: htp.tableData(cvalue => ''
295: ||l_display_value, calign => p_item_rec.horizontal_alignment, cattributes => 'VALIGN="'||p_item_rec.vertical_alignment||'"'||l_data_background_color, crowspan => p_rowspan);
296: else
297: htp.tableData(cvalue => l_display_value, calign => p_item_rec.horizontal_alignment, cattributes => 'VALIGN="'||p_item_rec.vertical_alignment||'"'||l_data_background_color, crowspan => p_rowspan);
298: end if;
299:
300: end;
301:

328: then
329: if p_data_type = 'NUMBER'
330: then
331: l_input_check := l_input_check||'check_number(this);';
332: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);
333: htp.tableData(cvalue => '');
334: else
335: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);
336: end if;

Line 333: htp.tableData(cvalue => '');

329: if p_data_type = 'NUMBER'
330: then
331: l_input_check := l_input_check||'check_number(this);';
332: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);
333: htp.tableData(cvalue => '');
334: else
335: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);
336: end if;
337: else

331: l_input_check := l_input_check||'check_number(this);';
332: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);
333: htp.tableData(cvalue => '');
334: else
335: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);
336: end if;
337: else
338: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);
339: end if;

Line 354: htp.tableData(cvalue => '');

350: if p_update_flag = 'X'
351: then
352: if p_data_type = 'NUMBER'
353: then
354: htp.tableData(cvalue => '');
355: end if;
356: end if;
357:
358: end;

Line 382: htp.tableData(cvalue => '', calign => p_item_rec.horizontal_alignment, cattributes => 'VALIGN="'||p_item_rec.vertical_alignment||'"',
379: crowspan => p_rowspan, ccolspan => '3');
380: else
381: l_Y := 'X*****1****'||p_rowid||'*'||p_goto;
382: htp.tableData(cvalue => '', calign => p_item_rec.horizontal_alignment, cattributes => 'VALIGN="'||p_item_rec.vertical_alignment||'"', crowspan => p_rowspan);
384: end if;
385:
386: end;

Line 404: htp.tableData(cvalue => htf.formCheckbox('c','F')||p_label, crowspan => p_rowspan);

400: if p_update_flag = 'X'
401: then
402: if p_value_id is null
403: then
404: htp.tableData(cvalue => htf.formCheckbox('c','F')||p_label, crowspan => p_rowspan);
405: else
406: if p_value = 'T' or p_value = 'Y'
407: then
408: htp.tableData(cvalue => htf.formCheckbox('c',p_value,'CHECKED')||p_label, crowspan => p_rowspan);

Line 408: htp.tableData(cvalue => htf.formCheckbox('c',p_value,'CHECKED')||p_label, crowspan => p_rowspan);

404: htp.tableData(cvalue => htf.formCheckbox('c','F')||p_label, crowspan => p_rowspan);
405: else
406: if p_value = 'T' or p_value = 'Y'
407: then
408: htp.tableData(cvalue => htf.formCheckbox('c',p_value,'CHECKED')||p_label, crowspan => p_rowspan);
409: else
410: htp.tableData(cvalue => htf.formCheckbox('c',p_value)||p_label, crowspan => p_rowspan);
411: end if;
412: end if;

Line 410: htp.tableData(cvalue => htf.formCheckbox('c',p_value)||p_label, crowspan => p_rowspan);

406: if p_value = 'T' or p_value = 'Y'
407: then
408: htp.tableData(cvalue => htf.formCheckbox('c',p_value,'CHECKED')||p_label, crowspan => p_rowspan);
409: else
410: htp.tableData(cvalue => htf.formCheckbox('c',p_value)||p_label, crowspan => p_rowspan);
411: end if;
412: end if;
413: else
414: if p_value_id is null

Line 416: htp.tableData(cvalue => '', crowspan => p_rowspan);

412: end if;
413: else
414: if p_value_id is null
415: then
416: htp.tableData(cvalue => '', crowspan => p_rowspan);
417: else
418: if p_value = 'T' or p_value = 'Y'
419: then
420: htp.tableData(cvalue => '', calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);

Line 420: htp.tableData(cvalue => '', calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);

416: htp.tableData(cvalue => '', crowspan => p_rowspan);
417: else
418: if p_value = 'T' or p_value = 'Y'
419: then
420: htp.tableData(cvalue => '', calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);
421: else
422: htp.tableData(cvalue => '', crowspan => p_rowspan);
423: end if;
424: end if;

Line 422: htp.tableData(cvalue => '', crowspan => p_rowspan);

418: if p_value = 'T' or p_value = 'Y'
419: then
420: htp.tableData(cvalue => '', calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);
421: else
422: htp.tableData(cvalue => '', crowspan => p_rowspan);
423: end if;
424: end if;
425: end if;
426:

Line 445: htp.tableData(cvalue => '

441: begin
442:
443: if p_item_rec.region_validation_api_pkg is not null
444: then
445: htp.tableData(cvalue => '
446: ||');
447:
448: elsif p_rowid is not null
449: then

Line 450: htp.tableData(cvalue => '

446: ||');
447:
448: elsif p_rowid is not null
449: then
450: htp.tableData(cvalue => '
451: ||');
452:
453: else
454: htp.tableData('');

Line 454: htp.tableData('');

450: htp.tableData(cvalue => '
451: ||');
452:
453: else
454: htp.tableData('');
455:
456: end if;
457:
458: end;

Line 500: htp.tableData(cvalue => l_poplist, crowspan => p_rowspan);

496: l_poplist := l_poplist||(''||ak_query_pkg.g_results_table(r).value1);
497: end loop;
498: l_poplist := l_poplist||htf.formSelectClose;
499:
500: htp.tableData(cvalue => l_poplist, crowspan => p_rowspan);
501:
502: else
503:
504: l_poplist := htf.formSelectOpen('s');

Line 517: htp.tableData(cvalue => l_poplist, crowspan => p_rowspan);

513: l_poplist := l_poplist||htf.formSelectClose;
514:
515: end if;
516:
517: htp.tableData(cvalue => l_poplist, crowspan => p_rowspan);
518:
519: else
520:
521: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);

Line 521: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);

517: htp.tableData(cvalue => l_poplist, crowspan => p_rowspan);
518:
519: else
520:
521: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);
522:
523: end if;
524: else
525:

Line 526: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);

522:
523: end if;
524: else
525:
526: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);
527:
528: end if;
529:
530: end;

Line 761: -- htp.p('DEBUG '||i||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_attribute_code||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;

757: then
758: l_item_styles(i) := 'DEFAULT_PKG';
759: end if;
760:
761: -- htp.p('DEBUG '||i||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_attribute_code||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;
762:
763: end loop; -- region_items
764:
765: l_attribute_codes := l_attribute_codes||']';

Line 770: htp.p('');
840:
841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');
842: htp.formHidden('X',l_X);

Line 839: htp.p('');

835: document.inputForm'||p_region_rec_id||'.reset();
836: }');
837:
838: htp.p('// -->');
839: htp.p('');
840:
841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');
842: htp.formHidden('X',l_X);
843: htp.formHidden('Y',l_Y);

Line 841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');

837:
838: htp.p('// -->');
839: htp.p('');
840:
841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');
842: htp.formHidden('X',l_X);
843: htp.formHidden('Y',l_Y);
844: htp.formHidden('Z');
845: htp.formClose;

Line 842: htp.formHidden('X',l_X);

838: htp.p('// -->');
839: htp.p('');
840:
841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');
842: htp.formHidden('X',l_X);
843: htp.formHidden('Y',l_Y);
844: htp.formHidden('Z');
845: htp.formClose;
846: end if;

Line 843: htp.formHidden('Y',l_Y);

839: htp.p('');
840:
841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');
842: htp.formHidden('X',l_X);
843: htp.formHidden('Y',l_Y);
844: htp.formHidden('Z');
845: htp.formClose;
846: end if;
847:

Line 844: htp.formHidden('Z');

840:
841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');
842: htp.formHidden('X',l_X);
843: htp.formHidden('Y',l_Y);
844: htp.formHidden('Z');
845: htp.formClose;
846: end if;
847:
848: htp.formOpen(curl => 'javascript:submitFunction()', cattributes => 'NAME="inputForm'||p_region_rec_id||'"');

Line 845: htp.formClose;

841: htp.formOpen(curl => icx_cabo.g_plsql_agent||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_pkg||'.'||ak_query_pkg.g_regions_table(p_region_rec_id).region_validation_api_proc, cattributes => 'NAME="submitForm"');
842: htp.formHidden('X',l_X);
843: htp.formHidden('Y',l_Y);
844: htp.formHidden('Z');
845: htp.formClose;
846: end if;
847:
848: htp.formOpen(curl => 'javascript:submitFunction()', cattributes => 'NAME="inputForm'||p_region_rec_id||'"');
849:

Line 848: htp.formOpen(curl => 'javascript:submitFunction()', cattributes => 'NAME="inputForm'||p_region_rec_id||'"');

844: htp.formHidden('Z');
845: htp.formClose;
846: end if;
847:
848: htp.formOpen(curl => 'javascript:submitFunction()', cattributes => 'NAME="inputForm'||p_region_rec_id||'"');
849:
850: if l_region_style = 'TABLE'
851: then
852:

Line 908: htp.tableOpen(cborder => 'BORDER=2', cattributes => 'CELLPADDING=2');

904: icx_on_utilities2.displaySetIcons(l_language_code,icx_cabo.g_plsql_agent||'OracleON.IC',l_start_row,l_stop_row,icx_on_utilities.g_on_parameters(9),l_query_set,l_total_result_count,TRUE,'',icx_call.encrypt2(l_Y),l_update);
905:
906: end if;
907:
908: htp.tableOpen(cborder => 'BORDER=2', cattributes => 'CELLPADDING=2');
909: htp.p('');
910: for i in l_region_items_start..l_region_items_end loop
911: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: and ak_query_pkg.g_items_table(i).secured_column = 'F'

Line 909: htp.p('');

905:
906: end if;
907:
908: htp.tableOpen(cborder => 'BORDER=2', cattributes => 'CELLPADDING=2');
909: htp.p('');
910: for i in l_region_items_start..l_region_items_end loop
911: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: and ak_query_pkg.g_items_table(i).secured_column = 'F'
913: then

Line 916: htp.tableData(cvalue => '
');

912: and ak_query_pkg.g_items_table(i).secured_column = 'F'
913: then
914: if l_item_styles(i) = 'BUTTON'
915: then
916: htp.tableData(cvalue => '
');
917: elsif l_item_styles(i) = 'HIDDEN'
918: then
919: l_title := '';
920: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'

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

918: then
919: l_title := '';
920: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'
921: then
922: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);
923: else
924: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
925: end if;
926: end if;

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

920: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'
921: then
922: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);
923: else
924: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
925: end if;
926: end if;
927: end loop; -- region_items
928: htp.tableRowClose;

Line 928: htp.tableRowClose;

924: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
925: end if;
926: end if;
927: end loop; -- region_items
928: htp.tableRowClose;
929: htp.tableRowOpen;
930: htp.tableRowClose;
931: htp.tableRowOpen;
932: htp.tableRowClose;

Line 929: htp.tableRowOpen;

925: end if;
926: end if;
927: end loop; -- region_items
928: htp.tableRowClose;
929: htp.tableRowOpen;
930: htp.tableRowClose;
931: htp.tableRowOpen;
932: htp.tableRowClose;
933:

Line 930: htp.tableRowClose;

926: end if;
927: end loop; -- region_items
928: htp.tableRowClose;
929: htp.tableRowOpen;
930: htp.tableRowClose;
931: htp.tableRowOpen;
932: htp.tableRowClose;
933:
934: l_row_count := 0;

Line 931: htp.tableRowOpen;

927: end loop; -- region_items
928: htp.tableRowClose;
929: htp.tableRowOpen;
930: htp.tableRowClose;
931: htp.tableRowOpen;
932: htp.tableRowClose;
933:
934: l_row_count := 0;
935:

Line 932: htp.tableRowClose;

928: htp.tableRowClose;
929: htp.tableRowOpen;
930: htp.tableRowClose;
931: htp.tableRowOpen;
932: htp.tableRowClose;
933:
934: l_row_count := 0;
935:
936: for r in l_region_results_start..l_region_results_end loop

Line 955: htp.p('');

951: ||'*'||ak_query_pkg.g_results_table(r).key8
952: ||'*'||ak_query_pkg.g_results_table(r).key9
953: ||'*'||ak_query_pkg.g_results_table(r).key10||'**]';
954:
955: htp.p('');
956:
957: for i in l_region_items_start..l_region_items_end loop
958:
959: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 962: -- htp.p('DEBUG '||i||' '||l_value_id(i)||' '||l_secured_column(i)||' '||l_node_display_flag(i)||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;

958:
959: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
960: and ak_query_pkg.g_items_table(i).secured_column = 'F'
961: then
962: -- htp.p('DEBUG '||i||' '||l_value_id(i)||' '||l_secured_column(i)||' '||l_node_display_flag(i)||' '||ak_query_pkg.g_items_table(i).attribute_label_long||' '||l_item_styles(i)||' '||l_url_display_sequence(i));htp.nl;
963:
964: if ak_query_pkg.g_items_table(i).value_id is null
965: then
966: l_value := ak_query_pkg.g_items_table(i).attribute_label_long;

Line 1012: htp.formHidden('h',l_value);

1008: l_region_style);
1009:
1010: elsif l_item_styles(i) = 'HIDDEN'
1011: then
1012: htp.formHidden('h',l_value);
1013: elsif l_item_styles(i) = 'CHECKBOX'
1014: then
1015:
1016: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,

Line 1052: htp.p('');

1048: l_rowspan);
1049:
1050: elsif l_item_styles(i) = 'DEFAULT_PKG'
1051: then
1052: htp.p('');
1053: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1054: p_result_values := '';
1055:
1056: for i in l_region_items_start..l_region_items_end loop

Line 1073: htp.p('');

1069: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1070: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1071: l_dummy := dbms_sql.execute(l_call);
1072: dbms_sql.close_cursor(l_call);
1073: htp.p('');
1074: elsif l_item_styles(i) = 'URL'
1075: then
1076: if l_values(l_value_id(l_url_display_sequence(i))) is null
1077: then

Line 1088: htp.tableData(cvalue => ''

1084: l_region_style,
1085: '',
1086: l_rowspan);
1087: else
1088: htp.tableData(cvalue => ''
1089: ||icx_on_utilities.formatText(l_values(l_value_id(i)),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic)
1090: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1091: end if;
1092: else

Line 1105: htp.tableRowClose;

1101: l_rowspan);
1102: end if;
1103: end if;
1104: end loop; -- region_items
1105: htp.tableRowClose;
1106:
1107: if l_rowspan = 2
1108: then
1109: htp.p('');

Line 1109: htp.p('');

1105: htp.tableRowClose;
1106:
1107: if l_rowspan = 2
1108: then
1109: htp.p('');
1110: for i in l_region_items_start..l_region_items_end loop
1111: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1112: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1113: then

Line 1123: htp.tableRowClose;

1119: l_language_code);
1120: end if;
1121: end if;
1122: end loop; -- region_items
1123: htp.tableRowClose;
1124: end if; -- l_rowspan = 2
1125:
1126: end loop; -- ak_query_pkg.g_results_table
1127:

Line 1129: htp.tableRowOpen;

1125:
1126: end loop; -- ak_query_pkg.g_results_table
1127:
1128: if l_total_result_count > 5 and l_query_set2 > 5 then
1129: htp.tableRowOpen;
1130: htp.tableRowClose;
1131: htp.tableRowOpen;
1132: htp.tableRowClose;
1133: htp.p('');

Line 1130: htp.tableRowClose;

1126: end loop; -- ak_query_pkg.g_results_table
1127:
1128: if l_total_result_count > 5 and l_query_set2 > 5 then
1129: htp.tableRowOpen;
1130: htp.tableRowClose;
1131: htp.tableRowOpen;
1132: htp.tableRowClose;
1133: htp.p('');
1134: for i in l_region_items_start..l_region_items_end loop

Line 1131: htp.tableRowOpen;

1127:
1128: if l_total_result_count > 5 and l_query_set2 > 5 then
1129: htp.tableRowOpen;
1130: htp.tableRowClose;
1131: htp.tableRowOpen;
1132: htp.tableRowClose;
1133: htp.p('');
1134: for i in l_region_items_start..l_region_items_end loop
1135: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 1132: htp.tableRowClose;

1128: if l_total_result_count > 5 and l_query_set2 > 5 then
1129: htp.tableRowOpen;
1130: htp.tableRowClose;
1131: htp.tableRowOpen;
1132: htp.tableRowClose;
1133: htp.p('');
1134: for i in l_region_items_start..l_region_items_end loop
1135: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1136: and ak_query_pkg.g_items_table(i).secured_column = 'F'

Line 1133: htp.p('');

1129: htp.tableRowOpen;
1130: htp.tableRowClose;
1131: htp.tableRowOpen;
1132: htp.tableRowClose;
1133: htp.p('');
1134: for i in l_region_items_start..l_region_items_end loop
1135: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1136: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1137: then

Line 1140: htp.tableData(cvalue => '
');

1136: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1137: then
1138: if l_item_styles(i) = 'BUTTON'
1139: then
1140: htp.tableData(cvalue => '
');
1141: elsif l_item_styles(i) = 'HIDDEN'
1142: then
1143: l_title := '';
1144: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'

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

1142: then
1143: l_title := '';
1144: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'
1145: then
1146: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);
1147: else
1148: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
1149: end if;
1150: end if;

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

1144: elsif l_item_styles(i) = 'SPINBOX' and l_data_types(i) = 'NUMBER'
1145: then
1146: htp.tableData(cvalue => ''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER', ccolspan => 2);
1147: else
1148: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
1149: end if;
1150: end if;
1151: end loop; -- region_items
1152: htp.tableRowClose;

Line 1152: htp.tableRowClose;

1148: htp.tableData(''||ak_query_pkg.g_items_table(i).attribute_label_long||'', calign => 'CENTER');
1149: end if;
1150: end if;
1151: end loop; -- region_items
1152: htp.tableRowClose;
1153: end if;
1154:
1155: htp.tableClose;
1156: htp.formClose;

Line 1155: htp.tableClose;

1151: end loop; -- region_items
1152: htp.tableRowClose;
1153: end if;
1154:
1155: htp.tableClose;
1156: htp.formClose;
1157:
1158: if l_total_result_count > 5
1159: then

Line 1156: htp.formClose;

1152: htp.tableRowClose;
1153: end if;
1154:
1155: htp.tableClose;
1156: htp.formClose;
1157:
1158: if l_total_result_count > 5
1159: then
1160:

Line 1175: htp.tableOpen('BORDER=0');

1171: l_counter := 1;
1172: l_start_row := 1;
1173: l_stop_row := 2;
1174:
1175: htp.tableOpen('BORDER=0');
1176:
1177: for r in l_region_results_start..l_region_results_end loop
1178:
1179: l_row_count := l_row_count + 1;

Line 1196: htp.tableRowOpen;

1192: if l_counter = 1
1193: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1194: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1195: then
1196: htp.tableRowOpen;
1197: end if;
1198:
1199: if l_value_id(i) is null
1200: then

Line 1215: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN='||ak_query_pkg.g_items_table(i).vertical_alignment);

1211: else
1212: if l_item_styles(i) = 'TEXT'
1213: then
1214:
1215: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN='||ak_query_pkg.g_items_table(i).vertical_alignment);
1216: htp.tableData(' ');
1217:
1218: printText( ak_query_pkg.g_items_table(i),
1219: l_data_types(i),

Line 1216: htp.tableData(' ');

1212: if l_item_styles(i) = 'TEXT'
1213: then
1214:
1215: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN='||ak_query_pkg.g_items_table(i).vertical_alignment);
1216: htp.tableData(' ');
1217:
1218: printText( ak_query_pkg.g_items_table(i),
1219: l_data_types(i),
1220: l_value,

Line 1231: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1227:
1228: elsif l_item_styles(i) = 'SPINBOX'
1229: then
1230:
1231: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1232: htp.tableData(' ');
1233:
1234: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,
1235: ak_query_pkg.g_items_table(i).required_flag,

Line 1232: htp.tableData(' ');

1228: elsif l_item_styles(i) = 'SPINBOX'
1229: then
1230:
1231: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1232: htp.tableData(' ');
1233:
1234: printSpinboxup( ak_query_pkg.g_items_table(i).update_flag,
1235: ak_query_pkg.g_items_table(i).required_flag,
1236: ak_query_pkg.g_items_table(i).attribute_label_long,

Line 1260: htp.formHidden('h',l_value);

1256: l_region_style);
1257:
1258: elsif l_item_styles(i) = 'HIDDEN'
1259: then
1260: htp.formHidden('h',l_value);
1261:
1262: elsif l_item_styles(i) = 'CHECKBOX'
1263: then
1264:

Line 1265: htp.tableData(' ');

1261:
1262: elsif l_item_styles(i) = 'CHECKBOX'
1263: then
1264:
1265: htp.tableData(' ');
1266: htp.tableData(' ');
1267:
1268: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1269: ak_query_pkg.g_items_table(i).value_id,

Line 1266: htp.tableData(' ');

1262: elsif l_item_styles(i) = 'CHECKBOX'
1263: then
1264:
1265: htp.tableData(' ');
1266: htp.tableData(' ');
1267:
1268: printCheckbox( ak_query_pkg.g_items_table(i).update_flag,
1269: ak_query_pkg.g_items_table(i).value_id,
1270: l_value,

Line 1280: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1276:
1277: elsif l_item_styles(i) = 'POPLIST'
1278: then
1279:
1280: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1281: htp.tableData(' ');
1282:
1283: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1284: ak_query_pkg.g_items_table(i).lov_region_code,

Line 1281: htp.tableData(' ');

1277: elsif l_item_styles(i) = 'POPLIST'
1278: then
1279:
1280: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1281: htp.tableData(' ');
1282:
1283: printPoplist( ak_query_pkg.g_items_table(i).lov_region_application_id,
1284: ak_query_pkg.g_items_table(i).lov_region_code,
1285: ak_query_pkg.g_items_table(i).update_flag,

Line 1295: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1291: ak_query_pkg.g_items_table(i).vertical_alignment,
1292: l_rowspan);
1293: elsif l_item_styles(i) = 'DEFAULT_PKG'
1294: then
1295: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1296: htp.tableData(' ');
1297: htp.p('');
1298: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1299: p_result_values := '';

Line 1296: htp.tableData(' ');

1292: l_rowspan);
1293: elsif l_item_styles(i) = 'DEFAULT_PKG'
1294: then
1295: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1296: htp.tableData(' ');
1297: htp.p('');
1298: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1299: p_result_values := '';
1300:

Line 1297: htp.p('');

1293: elsif l_item_styles(i) = 'DEFAULT_PKG'
1294: then
1295: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1296: htp.tableData(' ');
1297: htp.p('');
1298: l_procedure_call := ak_query_pkg.g_items_table(i).region_defaulting_api_pkg||'.'||ak_query_pkg.g_items_table(i).region_defaulting_api_proc||'(:l_attribute_codes,:p_result_values)';
1299: p_result_values := '';
1300:
1301: for i in l_region_items_start..l_region_items_end loop

Line 1318: htp.p('');

1314: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1315: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1316: l_dummy := dbms_sql.execute(l_call);
1317: dbms_sql.close_cursor(l_call);
1318: htp.p('');
1319: elsif l_item_styles(i) = 'URL'
1320: then
1321: if l_values(l_value_id(l_url_display_sequence(i))) is null
1322: then

Line 1323: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1319: elsif l_item_styles(i) = 'URL'
1320: then
1321: if l_values(l_value_id(l_url_display_sequence(i))) is null
1322: then
1323: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1324: htp.tableData(' ');
1325: printText( ak_query_pkg.g_items_table(i),
1326: l_data_types(i),
1327: l_value,

Line 1324: htp.tableData(' ');

1320: then
1321: if l_values(l_value_id(l_url_display_sequence(i))) is null
1322: then
1323: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1324: htp.tableData(' ');
1325: printText( ak_query_pkg.g_items_table(i),
1326: l_data_types(i),
1327: l_value,
1328: l_rowids(i),

Line 1335: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1331: l_region_style,
1332: l_data_singlerow_color,
1333: l_rowspan);
1334: else
1335: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1336: htp.tableData(' ');
1337: htp.tableData(cvalue => ''
1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)
1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);

Line 1336: htp.tableData(' ');

1332: l_data_singlerow_color,
1333: l_rowspan);
1334: else
1335: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1336: htp.tableData(' ');
1337: htp.tableData(cvalue => ''
1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)
1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1340: end if;

Line 1337: htp.tableData(cvalue => ''

1333: l_rowspan);
1334: else
1335: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1336: htp.tableData(' ');
1337: htp.tableData(cvalue => ''
1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)
1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1340: end if;
1341: else

Line 1342: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)
1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1340: end if;
1341: else
1342: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1343: htp.tableData(' ');
1344: printText( ak_query_pkg.g_items_table(i),
1345: l_data_types(i),
1346: l_value,

Line 1343: htp.tableData(' ');

1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1340: end if;
1341: else
1342: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1343: htp.tableData(' ');
1344: printText( ak_query_pkg.g_items_table(i),
1345: l_data_types(i),
1346: l_value,
1347: l_rowids(i),

Line 1363: htp.tableRowClose;

1359: then
1360: l_counter := l_counter;
1361: elsif l_counter = l_num_columns
1362: then
1363: htp.tableRowClose;
1364: if l_rowspan = 2
1365: then
1366: htp.tableRowOpen;
1367: for i in l_region_items_start..l_region_items_end loop

Line 1366: htp.tableRowOpen;

1362: then
1363: htp.tableRowClose;
1364: if l_rowspan = 2
1365: then
1366: htp.tableRowOpen;
1367: for i in l_region_items_start..l_region_items_end loop
1368: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1369: and ak_query_pkg.g_items_table(i).secured_column = 'F'
1370: then

Line 1380: htp.tableRowClose;

1376: l_language_code);
1377: end if;
1378: end if;
1379: end loop; -- region_items
1380: htp.tableRowClose;
1381: end if;
1382: l_counter := 1;
1383: l_display_count := l_display_count + 1;
1384: l_table_rows(l_display_count) := l_table_row;

Line 1387: htp.tableData(' ');

1383: l_display_count := l_display_count + 1;
1384: l_table_rows(l_display_count) := l_table_row;
1385: l_table_row := '';
1386: else
1387: htp.tableData(' ');
1388: htp.tableData(' ');
1389: htp.tableData(' ');
1390: htp.tableData(' ');
1391: l_counter := l_counter + 1;

Line 1388: htp.tableData(' ');

1384: l_table_rows(l_display_count) := l_table_row;
1385: l_table_row := '';
1386: else
1387: htp.tableData(' ');
1388: htp.tableData(' ');
1389: htp.tableData(' ');
1390: htp.tableData(' ');
1391: l_counter := l_counter + 1;
1392: end if;

Line 1389: htp.tableData(' ');

1385: l_table_row := '';
1386: else
1387: htp.tableData(' ');
1388: htp.tableData(' ');
1389: htp.tableData(' ');
1390: htp.tableData(' ');
1391: l_counter := l_counter + 1;
1392: end if;
1393:

Line 1390: htp.tableData(' ');

1386: else
1387: htp.tableData(' ');
1388: htp.tableData(' ');
1389: htp.tableData(' ');
1390: htp.tableData(' ');
1391: l_counter := l_counter + 1;
1392: end if;
1393:
1394: end loop; -- region_items

Line 1400: htp.tableClose;

1396: end if; -- rows
1397:
1398: end loop; -- results
1399:
1400: htp.tableClose;
1401: htp.formClose;
1402:
1403: end if; -- l_region_style
1404:

Line 1401: htp.formClose;

1397:
1398: end loop; -- results
1399:
1400: htp.tableClose;
1401: htp.formClose;
1402:
1403: end if; -- l_region_style
1404:
1405: if l_update

Line 1408: htp.tableOpen(cborder => 'BORDER=0');

1404:
1405: if l_update
1406: then
1407: icx_util.getPrompts(601,'ICX_WEB_ON',l_title,l_prompts);
1408: htp.tableOpen(cborder => 'BORDER=0');
1409: htp.tableRowOpen;
1410: htp.p('');
1411: icx_util.DynamicButton(P_ButtonText => l_prompts(6),
1412: P_ImageFileName => 'FNDBSBMT',

Line 1409: htp.tableRowOpen;

1405: if l_update
1406: then
1407: icx_util.getPrompts(601,'ICX_WEB_ON',l_title,l_prompts);
1408: htp.tableOpen(cborder => 'BORDER=0');
1409: htp.tableRowOpen;
1410: htp.p('');
1411: icx_util.DynamicButton(P_ButtonText => l_prompts(6),
1412: P_ImageFileName => 'FNDBSBMT',
1413: P_OnMouseOverText => l_prompts(6),

Line 1410: htp.p('');

1406: then
1407: icx_util.getPrompts(601,'ICX_WEB_ON',l_title,l_prompts);
1408: htp.tableOpen(cborder => 'BORDER=0');
1409: htp.tableRowOpen;
1410: htp.p('');
1411: icx_util.DynamicButton(P_ButtonText => l_prompts(6),
1412: P_ImageFileName => 'FNDBSBMT',
1413: P_OnMouseOverText => l_prompts(6),
1414: P_HyperTextCall => 'javascript:submitFunction()',

Line 1417: htp.p('');

1413: P_OnMouseOverText => l_prompts(6),
1414: P_HyperTextCall => 'javascript:submitFunction()',
1415: P_LanguageCode => l_language_code,
1416: P_JavaScriptFlag => FALSE);
1417: htp.p('');
1418: if (instr(c_browser,'MSIE 3')=0) then
1419: htp.p('');
1420: icx_util.DynamicButton(P_ButtonText => l_prompts(7),
1421: P_ImageFileName => 'FNDBCLR',

Line 1419: htp.p('');

1415: P_LanguageCode => l_language_code,
1416: P_JavaScriptFlag => FALSE);
1417: htp.p('');
1418: if (instr(c_browser,'MSIE 3')=0) then
1419: htp.p('');
1420: icx_util.DynamicButton(P_ButtonText => l_prompts(7),
1421: P_ImageFileName => 'FNDBCLR',
1422: P_OnMouseOverText => l_prompts(7),
1423: P_HyperTextCall => 'javascript:resetFunction()',

Line 1426: htp.p('');

1422: P_OnMouseOverText => l_prompts(7),
1423: P_HyperTextCall => 'javascript:resetFunction()',
1424: P_LanguageCode => l_language_code,
1425: P_JavaScriptFlag => FALSE);
1426: htp.p('');
1427: end if; -- browser = 'MSIE 3'
1428: htp.tableRowClose;
1429: htp.tableClose;
1430: end if; -- update

Line 1428: htp.tableRowClose;

1424: P_LanguageCode => l_language_code,
1425: P_JavaScriptFlag => FALSE);
1426: htp.p('');
1427: end if; -- browser = 'MSIE 3'
1428: htp.tableRowClose;
1429: htp.tableClose;
1430: end if; -- update
1431:
1432: end if; -- no region items

Line 1429: htp.tableClose;

1425: P_JavaScriptFlag => FALSE);
1426: htp.p('');
1427: end if; -- browser = 'MSIE 3'
1428: htp.tableRowClose;
1429: htp.tableClose;
1430: end if; -- update
1431:
1432: end if; -- no region items
1433:

Line 1440: htp.p('===============================================================');htp.nl;

1436: procedure printPLSQLtables is
1437:
1438: begin
1439:
1440: htp.p('===============================================================');htp.nl;
1441: htp.p('REGIONS');htp.nl;
1442: htp.p('===============================================================');htp.nl;
1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP

Line 1441: htp.p('REGIONS');htp.nl;

1437:
1438: begin
1439:
1440: htp.p('===============================================================');htp.nl;
1441: htp.p('REGIONS');htp.nl;
1442: htp.p('===============================================================');htp.nl;
1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;

Line 1442: htp.p('===============================================================');htp.nl;

1438: begin
1439:
1440: htp.p('===============================================================');htp.nl;
1441: htp.p('REGIONS');htp.nl;
1442: htp.p('===============================================================');htp.nl;
1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;

Line 1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;

1439:
1440: htp.p('===============================================================');htp.nl;
1441: htp.p('REGIONS');htp.nl;
1442: htp.p('===============================================================');htp.nl;
1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;

Line 1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;

1441: htp.p('REGIONS');htp.nl;
1442: htp.p('===============================================================');htp.nl;
1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;

Line 1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;

1442: htp.p('===============================================================');htp.nl;
1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;

Line 1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;

1443: htp.p('Total Regions = '||to_char(ak_query_pkg.g_regions_table.COUNT));htp.nl;
1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;

Line 1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;

1444: FOR i IN ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST LOOP
1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;

Line 1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;

1445: htp.p('Regions Table Row ='||to_char(i));htp.nl;
1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;

Line 1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;

1446: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).region_rec_id));htp.nl;
1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;

Line 1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;

1447: htp.p('- parent_region_rec_id = '||to_char(ak_query_pkg.g_regions_table(i).parent_region_rec_id));htp.nl;
1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;

Line 1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;

1448: htp.p('- total_result_count = '||to_char(ak_query_pkg.g_regions_table(i).total_result_count));htp.nl;
1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;

Line 1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;

1449: htp.p('- flow_application_id = '||to_char(ak_query_pkg.g_regions_table(i).flow_application_id));htp.nl;
1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;

Line 1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;

1450: htp.p('- flow_code = '||ak_query_pkg.g_regions_table(i).flow_code);htp.nl;
1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;

Line 1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;

1451: htp.p('- page_application_id = '||to_char(ak_query_pkg.g_regions_table(i).page_application_id));htp.nl;
1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;

Line 1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;

1452: htp.p('- page_code = '||ak_query_pkg.g_regions_table(i).page_code);htp.nl;
1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;

Line 1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;

1453: htp.p('- region_application_id = '||to_char(ak_query_pkg.g_regions_table(i).region_application_id));htp.nl;
1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;

Line 1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;

1454: htp.p('- region_code = '||ak_query_pkg.g_regions_table(i).region_code);htp.nl;
1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;

Line 1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;

1455: htp.p('- primary_key_name = '||ak_query_pkg.g_regions_table(i).primary_key_name);htp.nl;
1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;

Line 1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;

1456: htp.p('- name = '||ak_query_pkg.g_regions_table(i).name);htp.nl;
1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;

Line 1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;

1457: htp.p('- region_style = '||ak_query_pkg.g_regions_table(i).region_style);htp.nl;
1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;

Line 1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;

1458: htp.p('- number_of_format_columns = '||to_char(ak_query_pkg.g_regions_table(i).number_of_format_columns));htp.nl;
1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;

Line 1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;

1459: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).region_defaulting_api_pkg);htp.nl;
1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;

Line 1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;

1460: htp.p('- region_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).region_defaulting_api_proc);htp.nl;
1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;
1468:

Line 1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;

1461: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).region_validation_api_pkg);htp.nl;
1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;
1468:
1469: htp.p('===============================================================');htp.nl;

Line 1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;

1462: htp.p('- region_validation_api_proc= '||ak_query_pkg.g_regions_table(i).region_validation_api_proc);htp.nl;
1463: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_regions_table(i).object_defaulting_api_pkg);htp.nl;
1464: htp.p('- object_defaulting_api_proc= '||ak_query_pkg.g_regions_table(i).object_defaulting_api_proc);htp.nl;
1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;
1468:
1469: htp.p('===============================================================');htp.nl;
1470: htp.p('ITEMS');htp.nl;

Line 1469: htp.p('===============================================================');htp.nl;

1465: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_regions_table(i).object_validation_api_pkg);htp.nl;
1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;
1468:
1469: htp.p('===============================================================');htp.nl;
1470: htp.p('ITEMS');htp.nl;
1471: htp.p('===============================================================');htp.nl;
1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP

Line 1470: htp.p('ITEMS');htp.nl;

1466: htp.p('- object_validation_api_proc= '||ak_query_pkg.g_regions_table(i).object_validation_api_proc);htp.nl;
1467: END LOOP;
1468:
1469: htp.p('===============================================================');htp.nl;
1470: htp.p('ITEMS');htp.nl;
1471: htp.p('===============================================================');htp.nl;
1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;

Line 1471: htp.p('===============================================================');htp.nl;

1467: END LOOP;
1468:
1469: htp.p('===============================================================');htp.nl;
1470: htp.p('ITEMS');htp.nl;
1471: htp.p('===============================================================');htp.nl;
1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;

Line 1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;

1468:
1469: htp.p('===============================================================');htp.nl;
1470: htp.p('ITEMS');htp.nl;
1471: htp.p('===============================================================');htp.nl;
1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;

Line 1474: htp.p('Item Table Row ='||to_char(i));htp.nl;

1470: htp.p('ITEMS');htp.nl;
1471: htp.p('===============================================================');htp.nl;
1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;

Line 1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;

1471: htp.p('===============================================================');htp.nl;
1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;

Line 1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;

1472: htp.p('Total Items = '||to_char(ak_query_pkg.g_items_table.COUNT));htp.nl;
1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;

Line 1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;

1473: FOR i IN 0..(ak_query_pkg.g_items_table.COUNT - 1) LOOP
1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;

Line 1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;

1474: htp.p('Item Table Row ='||to_char(i));htp.nl;
1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;

Line 1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;

1475: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_items_table(i).region_rec_id));htp.nl;
1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;

Line 1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;

1476: htp.p('- value_id = '||to_char(ak_query_pkg.g_items_table(i).value_id));htp.nl;
1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;

Line 1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;

1477: htp.p('- attribute_application_id = '||to_char(ak_query_pkg.g_items_table(i).attribute_application_id));htp.nl;
1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;

Line 1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;

1478: htp.p('- attribute_code = '||ak_query_pkg.g_items_table(i).attribute_code);htp.nl;
1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;

Line 1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;

1479: htp.p('- attribute_label_long = '||ak_query_pkg.g_items_table(i).attribute_label_long);htp.nl;
1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;

Line 1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;

1480: htp.p('- attribute_label_length = '||to_char(ak_query_pkg.g_items_table(i).attribute_label_length));htp.nl;
1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;

Line 1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;

1481: htp.p('- display_value_length = '||to_char(ak_query_pkg.g_items_table(i).display_value_length));htp.nl;
1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;

Line 1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;

1482: htp.p('- display_sequence = '||to_char(ak_query_pkg.g_items_table(i).display_sequence));htp.nl;
1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;

Line 1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;

1483: htp.p('- item_style = '||ak_query_pkg.g_items_table(i).item_style);htp.nl;
1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;

Line 1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;

1484: htp.p('- bold = '||ak_query_pkg.g_items_table(i).bold);htp.nl;
1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;

Line 1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;

1485: htp.p('- italic = '||ak_query_pkg.g_items_table(i).italic);htp.nl;
1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;

Line 1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;

1486: htp.p('- vertical_alignment = '||ak_query_pkg.g_items_table(i).vertical_alignment);htp.nl;
1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;

Line 1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;

1487: htp.p('- horizontal_alignment = '||ak_query_pkg.g_items_table(i).horizontal_alignment);htp.nl;
1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;

Line 1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;

1488: htp.p('- object_attribute_flag = '||ak_query_pkg.g_items_table(i).object_attribute_flag);htp.nl;
1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;

Line 1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;

1489: htp.p('- secured_column = '||ak_query_pkg.g_items_table(i).secured_column);htp.nl;
1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;

Line 1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;

1490: htp.p('- node_query_flag = '||ak_query_pkg.g_items_table(i).node_query_flag);htp.nl;
1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;

Line 1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;

1491: htp.p('- node_display_flag = '||ak_query_pkg.g_items_table(i).node_display_flag);htp.nl;
1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;

Line 1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;

1492: htp.p('- update_flag = '||ak_query_pkg.g_items_table(i).update_flag);htp.nl;
1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;

Line 1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;

1493: htp.p('- required_flag = '||ak_query_pkg.g_items_table(i).required_flag);htp.nl;
1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;

Line 1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;

1494: htp.p('- icx_custom_call = '||ak_query_pkg.g_items_table(i).icx_custom_call);htp.nl;
1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;

Line 1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;

1495: htp.p('- region_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).region_defaulting_api_pkg);htp.nl;
1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;

Line 1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;

1496: htp.p('- region_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).region_defaulting_api_proc);htp.nl;
1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;
1504:

Line 1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;

1497: htp.p('- region_validation_api_pkg = '||ak_query_pkg.g_items_table(i).region_validation_api_pkg);htp.nl;
1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;
1504:
1505: htp.p('===============================================================');htp.nl;

Line 1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;

1498: htp.p('- region_validation_api_proc = '||ak_query_pkg.g_items_table(i).region_validation_api_proc);htp.nl;
1499: htp.p('- object_defaulting_api_pkg = '||ak_query_pkg.g_items_table(i).object_defaulting_api_pkg);htp.nl;
1500: htp.p('- object_defaulting_api_proc = '||ak_query_pkg.g_items_table(i).object_defaulting_api_proc);htp.nl;
1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;
1504:
1505: htp.p('===============================================================');htp.nl;
1506: htp.p('RESULTS');htp.nl;

Line 1505: htp.p('===============================================================');htp.nl;

1501: htp.p('- object_validation_api_pkg = '||ak_query_pkg.g_items_table(i).object_validation_api_pkg);htp.nl;
1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;
1504:
1505: htp.p('===============================================================');htp.nl;
1506: htp.p('RESULTS');htp.nl;
1507: htp.p('===============================================================');htp.nl;
1508: htp.p('Total Results = '||to_char(ak_query_pkg.g_results_table.COUNT));htp.nl;
1509:

Line 1506: htp.p('RESULTS');htp.nl;

1502: htp.p('- object_validation_api_proc = '||ak_query_pkg.g_items_table(i).object_validation_api_proc);htp.nl;
1503: END LOOP;
1504:
1505: htp.p('===============================================================');htp.nl;
1506: htp.p('RESULTS');htp.nl;
1507: htp.p('===============================================================');htp.nl;
1508: htp.p('Total Results = '||to_char(ak_query_pkg.g_results_table.COUNT));htp.nl;
1509:
1510: if ak_query_pkg.g_results_table.COUNT <> 0

Line 1507: htp.p('===============================================================');htp.nl;

1503: END LOOP;
1504:
1505: htp.p('===============================================================');htp.nl;
1506: htp.p('RESULTS');htp.nl;
1507: htp.p('===============================================================');htp.nl;
1508: htp.p('Total Results = '||to_char(ak_query_pkg.g_results_table.COUNT));htp.nl;
1509:
1510: if ak_query_pkg.g_results_table.COUNT <> 0
1511: then

Line 1508: htp.p('Total Results = '||to_char(ak_query_pkg.g_results_table.COUNT));htp.nl;

1504:
1505: htp.p('===============================================================');htp.nl;
1506: htp.p('RESULTS');htp.nl;
1507: htp.p('===============================================================');htp.nl;
1508: htp.p('Total Results = '||to_char(ak_query_pkg.g_results_table.COUNT));htp.nl;
1509:
1510: if ak_query_pkg.g_results_table.COUNT <> 0
1511: then
1512:

Line 1514: htp.p('Results Table Row ='||to_char(i));htp.nl;

1510: if ak_query_pkg.g_results_table.COUNT <> 0
1511: then
1512:
1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;

Line 1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;

1511: then
1512:
1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;

Line 1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;

1512:
1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;

Line 1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;

1513: FOR i IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;

Line 1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;

1514: htp.p('Results Table Row ='||to_char(i));htp.nl;
1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;

Line 1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;

1515: htp.p('- region_rec_id = '||to_char(ak_query_pkg.g_results_table(i).region_rec_id));htp.nl;
1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;

Line 1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;

1516: htp.p('- key1 = '||ak_query_pkg.g_results_table(i).key1);htp.nl;
1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;

Line 1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;

1517: htp.p('- key2 = '||ak_query_pkg.g_results_table(i).key2);htp.nl;
1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;

Line 1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;

1518: htp.p('- key3 = '||ak_query_pkg.g_results_table(i).key3);htp.nl;
1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;

Line 1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;

1519: htp.p('- key4 = '||ak_query_pkg.g_results_table(i).key4);htp.nl;
1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;

Line 1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;

1520: htp.p('- key5 = '||ak_query_pkg.g_results_table(i).key5);htp.nl;
1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;

Line 1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;

1521: htp.p('- value1 = '||ak_query_pkg.g_results_table(i).value1);htp.nl;
1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;

Line 1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;

1522: htp.p('- value2 = '||ak_query_pkg.g_results_table(i).value2);htp.nl;
1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;

Line 1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;

1523: htp.p('- value3 = '||ak_query_pkg.g_results_table(i).value3);htp.nl;
1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;
1531: END LOOP;

Line 1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;

1524: htp.p('- value4 = '||ak_query_pkg.g_results_table(i).value4);htp.nl;
1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;
1531: END LOOP;
1532:

Line 1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;

1525: htp.p('- value5 = '||ak_query_pkg.g_results_table(i).value5);htp.nl;
1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;
1531: END LOOP;
1532:
1533: end if;

Line 1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;

1526: htp.p('- value6 = '||ak_query_pkg.g_results_table(i).value6);htp.nl;
1527: htp.p('- value7 = '||ak_query_pkg.g_results_table(i).value7);htp.nl;
1528: htp.p('- value8 = '||ak_query_pkg.g_results_table(i).value8);htp.nl;
1529: htp.p('- value9 = '||ak_query_pkg.g_results_table(i).value9);htp.nl;
1530: htp.p('- value10 = '||ak_query_pkg.g_results_table(i).value10);htp.nl;
1531: END LOOP;
1532:
1533: end if;
1534: