DBA Data[Home] [Help]

APPS.JTF_TERR_CHANGES_REPORT_PVT dependencies on HTP

Line 104: htp.p(l_from_date);

100: into l_to_date
101: from dual;
102:
103: /*
104: htp.p(l_from_date);
105: htp.br;
106: htp.p(l_to_date);
107: htp.br;
108: */

Line 105: htp.br;

101: from dual;
102:
103: /*
104: htp.p(l_from_date);
105: htp.br;
106: htp.p(l_to_date);
107: htp.br;
108: */
109:

Line 106: htp.p(l_to_date);

102:
103: /*
104: htp.p(l_from_date);
105: htp.br;
106: htp.p(l_to_date);
107: htp.br;
108: */
109:
110: if (icx_sec.validateSession(c_function_code => 'JTF_TERR_CHGS_RPT', c_validate_only => 'Y')) then

Line 107: htp.br;

103: /*
104: htp.p(l_from_date);
105: htp.br;
106: htp.p(l_to_date);
107: htp.br;
108: */
109:
110: if (icx_sec.validateSession(c_function_code => 'JTF_TERR_CHGS_RPT', c_validate_only => 'Y')) then
111: if l_response = 'Excel' then

Line 116: htp.htmlopen;

112: xls(l_from_date,l_to_date);
113: else
114: --dbms_session.set_sql_trace(TRUE);
115: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 117: htp.headOpen;

113: else
114: --dbms_session.set_sql_trace(TRUE);
115: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');

Line 118: htp.title('Territory Changes Report');

114: --dbms_session.set_sql_trace(TRUE);
115: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);

Line 119: htp.headClose;

115: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);

Line 120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);

Line 121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');

117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;

Line 122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);

118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */

Line 123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);

119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('

');

Line 124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);

120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('

');
128: htp.tableOpen('border="0" ');

Line 125: htp.formClose;

121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('

');
128: htp.tableOpen('border="0" ');
129: htp.tableRowOpen( calign => 'TOP' );

Line 127: htp.p('
');

123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('

');
128: htp.tableOpen('border="0" ');
129: htp.tableRowOpen( calign => 'TOP' );
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');

Line 128: htp.tableOpen('border="0" ');

124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('

');
128: htp.tableOpen('border="0" ');
129: htp.tableRowOpen( calign => 'TOP' );
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');

Line 129: htp.tableRowOpen( calign => 'TOP' );

125: htp.formClose;
126: */
127: htp.p('

');
128: htp.tableOpen('border="0" ');
129: htp.tableRowOpen( calign => 'TOP' );
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;

Line 130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));

126: */
127: htp.p('

');
128: htp.tableOpen('border="0" ');
129: htp.tableRowOpen( calign => 'TOP' );
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;

Line 131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');

127: htp.p('

');
128: htp.tableOpen('border="0" ');
129: htp.tableRowOpen( calign => 'TOP' );
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;
135: htp.br;

Line 132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');

128: htp.tableOpen('border="0" ');
129: htp.tableRowOpen( calign => 'TOP' );
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;
135: htp.br;
136:

Line 133: htp.tableRowClose;

129: htp.tableRowOpen( calign => 'TOP' );
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;
135: htp.br;
136:
137:

Line 134: htp.tableClose;

130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;
135: htp.br;
136:
137:
138: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');

Line 135: htp.br;

131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;
135: htp.br;
136:
137:
138: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');
139: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));

Line 138: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');

134: htp.tableClose;
135: htp.br;
136:
137:
138: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');
139: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
140: -- display territories
141: l_rec_count := 0;
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop

Line 143: htp.tableRowOpen;

139: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
140: -- display territories
141: l_rec_count := 0;
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
143: htp.tableRowOpen;
144: htp.p('');
145: htp.p('');
146: htp.p(rec_terr.name);
147: htp.p('');

Line 144: htp.p('');

140: -- display territories
141: l_rec_count := 0;
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
143: htp.tableRowOpen;
144: htp.p('');
145: htp.p('');
146: htp.p(rec_terr.name);
147: htp.p('');
148: htp.p('');

Line 145: htp.p('');

141: l_rec_count := 0;
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
143: htp.tableRowOpen;
144: htp.p('');
145: htp.p('');
146: htp.p(rec_terr.name);
147: htp.p('');
148: htp.p('');
149: htp.p('Rank: ' ||rec_terr.rank);

Line 146: htp.p(rec_terr.name);

142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
143: htp.tableRowOpen;
144: htp.p('');
145: htp.p('');
146: htp.p(rec_terr.name);
147: htp.p('');
148: htp.p('');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('');

Line 147: htp.p('');

143: htp.tableRowOpen;
144: htp.p('');
145: htp.p('');
146: htp.p(rec_terr.name);
147: htp.p('');
148: htp.p('');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('');
151: htp.p('');

Line 148: htp.p('');

144: htp.p('');
145: htp.p('');
146: htp.p(rec_terr.name);
147: htp.p('');
148: htp.p('');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('');
151: htp.p('');
152: htp.p('Type: ' ||rec_terr.terr_type_name);

Line 149: htp.p('Rank: ' ||rec_terr.rank);

145: htp.p('');
146: htp.p(rec_terr.name);
147: htp.p('');
148: htp.p('');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('');
151: htp.p('');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('');

Line 150: htp.p('');

146: htp.p(rec_terr.name);
147: htp.p('');
148: htp.p('');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('');
151: htp.p('');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('');
154: htp.p('');

Line 151: htp.p('');

147: htp.p('');
148: htp.p('');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('');
151: htp.p('');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('');
154: htp.p('');
155: htp.p('Created: ' ||rec_terr.creation_date);

Line 152: htp.p('Type: ' ||rec_terr.terr_type_name);

148: htp.p('');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('');
151: htp.p('');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('');
154: htp.p('');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);

Line 153: htp.p('');

149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('');
151: htp.p('');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('');
154: htp.p('');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('');

Line 154: htp.p('');

150: htp.p('');
151: htp.p('');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('');
154: htp.p('');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('');
158: htp.tableRowClose;

Line 155: htp.p('Created: ' ||rec_terr.creation_date);

151: htp.p('');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('');
154: htp.p('');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('');
158: htp.tableRowClose;
159: l_rec_count := l_rec_count + 1;

Line 156: htp.p('Updated: ' ||rec_terr.last_update_date);

152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('');
154: htp.p('');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('');
158: htp.tableRowClose;
159: l_rec_count := l_rec_count + 1;
160:

Line 157: htp.p('');

153: htp.p('');
154: htp.p('');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('');
158: htp.tableRowClose;
159: l_rec_count := l_rec_count + 1;
160:
161: -- display sales reps

Line 158: htp.tableRowClose;

154: htp.p('');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('');
158: htp.tableRowClose;
159: l_rec_count := l_rec_count + 1;
160:
161: -- display sales reps
162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop

Line 163: htp.tableRowOpen;

159: l_rec_count := l_rec_count + 1;
160:
161: -- display sales reps
162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
163: htp.tableRowOpen;
164: htp.p('');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('');
167: --htp.p('');

Line 164: htp.p('');

160:
161: -- display sales reps
162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
163: htp.tableRowOpen;
164: htp.p('');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('');
167: --htp.p('');
168: --htp.p(rec_get_salesrep.resource_id);

Line 165: htp.p(rec_get_salesrep.resource_name);

161: -- display sales reps
162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
163: htp.tableRowOpen;
164: htp.p('');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('');
167: --htp.p('');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('');

Line 166: htp.p('');

162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
163: htp.tableRowOpen;
164: htp.p('');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('');
167: --htp.p('');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('');
170: --htp.tableRowClose;

Line 167: --htp.p('');

163: htp.tableRowOpen;
164: htp.p('');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('');
167: --htp.p('');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('');
170: --htp.tableRowClose;
171: END LOOP;

Line 168: --htp.p(rec_get_salesrep.resource_id);

164: htp.p('');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('');
167: --htp.p('');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('');
170: --htp.tableRowClose;
171: END LOOP;
172: -- display qualifiers

Line 169: --htp.p('');

165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('');
167: --htp.p('');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('');
170: --htp.tableRowClose;
171: END LOOP;
172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop

Line 170: --htp.tableRowClose;

166: htp.p('');
167: --htp.p('');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('');
170: --htp.tableRowClose;
171: END LOOP;
172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;

Line 174: htp.tableRowOpen;

170: --htp.tableRowClose;
171: END LOOP;
172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;
175: htp.p('');
176: htp.p('');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('');

Line 175: htp.p('');

171: END LOOP;
172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;
175: htp.p('');
176: htp.p('');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('');
179: --htp.p('');

Line 176: htp.p('');

172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;
175: htp.p('');
176: htp.p('');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('');
179: --htp.p('');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);

Line 177: htp.p(rec_get_terr_qual.qualifier_name);

173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;
175: htp.p('');
176: htp.p('');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('');
179: --htp.p('');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('');

Line 178: htp.p('');

174: htp.tableRowOpen;
175: htp.p('');
176: htp.p('');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('');
179: --htp.p('');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('');
182: htp.tableRowClose;

Line 179: --htp.p('');

175: htp.p('');
176: htp.p('');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('');
179: --htp.p('');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('');
182: htp.tableRowClose;
183: -- display qualifier values

Line 180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);

176: htp.p('');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('');
179: --htp.p('');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('');
182: htp.tableRowClose;
183: -- display qualifier values
184: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop

Line 181: --htp.p('');

177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('');
179: --htp.p('');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('');
182: htp.tableRowClose;
183: -- display qualifier values
184: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop
185: -- output qualifier values according to display_type and convert_to_id_flag

Line 182: htp.tableRowClose;

178: htp.p('');
179: --htp.p('');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('');
182: htp.tableRowClose;
183: -- display qualifier values
184: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop
185: -- output qualifier values according to display_type and convert_to_id_flag
186: l_display_type := rec_get_terr_values.display_type;

Line 191: htp.tableRowOpen;

187: l_convert_to_id_flag := rec_get_terr_values.convert_to_id_flag;
188:
189: If (l_display_type = 'CHAR') then
190: If (l_convert_to_id_flag = 'Y') then
191: htp.tableRowOpen;
192: htp.p('');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('');
195: htp.p('');

Line 192: htp.p('');

188:
189: If (l_display_type = 'CHAR') then
190: If (l_convert_to_id_flag = 'Y') then
191: htp.tableRowOpen;
192: htp.p('');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('');
195: htp.p('');
196: htp.p(rec_get_terr_values.low_value_char_desc);

Line 193: htp.p(rec_get_terr_values.comparison_operator);

189: If (l_display_type = 'CHAR') then
190: If (l_convert_to_id_flag = 'Y') then
191: htp.tableRowOpen;
192: htp.p('');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('');
195: htp.p('');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('');

Line 194: htp.p('');

190: If (l_convert_to_id_flag = 'Y') then
191: htp.tableRowOpen;
192: htp.p('');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('');
195: htp.p('');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('');
198: htp.p('');

Line 195: htp.p('');

191: htp.tableRowOpen;
192: htp.p('');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('');
195: htp.p('');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('');
198: htp.p('');
199: htp.p(rec_get_terr_values.low_value_char_id);

Line 196: htp.p(rec_get_terr_values.low_value_char_desc);

192: htp.p('');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('');
195: htp.p('');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('');
198: htp.p('');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('');

Line 197: htp.p('');

193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('');
195: htp.p('');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('');
198: htp.p('');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('');
201: htp.p('');

Line 198: htp.p('');

194: htp.p('');
195: htp.p('');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('');
198: htp.p('');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('');
201: htp.p('');
202: htp.p('');

Line 199: htp.p(rec_get_terr_values.low_value_char_id);

195: htp.p('');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('');
198: htp.p('');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('');
201: htp.p('');
202: htp.p('');
203: htp.p('');

Line 200: htp.p('');

196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('');
198: htp.p('');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('');
201: htp.p('');
202: htp.p('');
203: htp.p('');
204: htp.tableRowClose;

Line 201: htp.p('');

197: htp.p('');
198: htp.p('');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('');
201: htp.p('');
202: htp.p('');
203: htp.p('');
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')

Line 202: htp.p('');

198: htp.p('');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('');
201: htp.p('');
202: htp.p('');
203: htp.p('');
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;

Line 203: htp.p('');

199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('');
201: htp.p('');
202: htp.p('');
203: htp.p('');
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p('');

Line 204: htp.tableRowClose;

200: htp.p('');
201: htp.p('');
202: htp.p('');
203: htp.p('');
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p('');
208: htp.p(rec_get_terr_values.comparison_operator);

Line 206: htp.tableRowOpen;

202: htp.p('');
203: htp.p('');
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p('');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('');
210: htp.p('');

Line 207: htp.p('');

203: htp.p('');
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p('');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('');
210: htp.p('');
211: htp.p(rec_get_terr_values.low_value_char_desc);

Line 208: htp.p(rec_get_terr_values.comparison_operator);

204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p('');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('');
210: htp.p('');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('');

Line 209: htp.p('');

205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p('');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('');
210: htp.p('');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('');
213: htp.p('');

Line 210: htp.p('');

206: htp.tableRowOpen;
207: htp.p('');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('');
210: htp.p('');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('');
213: htp.p('');
214: htp.p(rec_get_terr_values.high_value_char_desc);

Line 211: htp.p(rec_get_terr_values.low_value_char_desc);

207: htp.p('');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('');
210: htp.p('');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('');
213: htp.p('');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('');

Line 212: htp.p('');

208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('');
210: htp.p('');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('');
213: htp.p('');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('');
216: htp.p('');

Line 213: htp.p('');

209: htp.p('');
210: htp.p('');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('');
213: htp.p('');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('');
216: htp.p('');
217: htp.p('');

Line 214: htp.p(rec_get_terr_values.high_value_char_desc);

210: htp.p('');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('');
213: htp.p('');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('');
216: htp.p('');
217: htp.p('');
218: htp.p('');

Line 215: htp.p('');

211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('');
213: htp.p('');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('');
216: htp.p('');
217: htp.p('');
218: htp.p('');
219: htp.tableRowClose;

Line 216: htp.p('');

212: htp.p('');
213: htp.p('');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('');
216: htp.p('');
217: htp.p('');
218: htp.p('');
219: htp.tableRowClose;
220: End if;

Line 217: htp.p('');

213: htp.p('');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('');
216: htp.p('');
217: htp.p('');
218: htp.p('');
219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then

Line 218: htp.p('');

214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('');
216: htp.p('');
217: htp.p('');
218: htp.p('');
219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;

Line 219: htp.tableRowClose;

215: htp.p('');
216: htp.p('');
217: htp.p('');
218: htp.p('');
219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p('');

Line 222: htp.tableRowOpen;

218: htp.p('');
219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p('');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('');
226: htp.p('');

Line 223: htp.p('');

219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p('');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('');
226: htp.p('');
227: htp.p(rec_get_terr_values.interest_type);

Line 224: htp.p(rec_get_terr_values.comparison_operator);

220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p('');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('');
226: htp.p('');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('');

Line 225: htp.p('');

221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p('');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('');
226: htp.p('');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('');
229: htp.p('');

Line 226: htp.p('');

222: htp.tableRowOpen;
223: htp.p('');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('');
226: htp.p('');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('');
229: htp.p('');
230: htp.p(rec_get_terr_values.primary_interest_code);

Line 227: htp.p(rec_get_terr_values.interest_type);

223: htp.p('');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('');
226: htp.p('');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('');
229: htp.p('');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('');

Line 228: htp.p('');

224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('');
226: htp.p('');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('');
229: htp.p('');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('');
232: htp.p('');

Line 229: htp.p('');

225: htp.p('');
226: htp.p('');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('');
229: htp.p('');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('');
232: htp.p('');
233: htp.p(rec_get_terr_values.secondary_interest_code);

Line 230: htp.p(rec_get_terr_values.primary_interest_code);

226: htp.p('');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('');
229: htp.p('');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('');
232: htp.p('');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('');

Line 231: htp.p('');

227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('');
229: htp.p('');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('');
232: htp.p('');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('');
235: htp.tableRowClose;

Line 232: htp.p('');

228: htp.p('');
229: htp.p('');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('');
232: htp.p('');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('');
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then

Line 233: htp.p(rec_get_terr_values.secondary_interest_code);

229: htp.p('');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('');
232: htp.p('');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('');
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;

Line 234: htp.p('');

230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('');
232: htp.p('');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('');
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p('');

Line 235: htp.tableRowClose;

231: htp.p('');
232: htp.p('');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('');
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p('');
239: htp.p(rec_get_terr_values.comparison_operator);

Line 237: htp.tableRowOpen;

233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('');
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p('');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('');
241: htp.p('');

Line 238: htp.p('');

234: htp.p('');
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p('');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('');
241: htp.p('');
242: htp.p(rec_get_terr_values.low_value_number);

Line 239: htp.p(rec_get_terr_values.comparison_operator);

235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p('');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('');
241: htp.p('');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('');

Line 240: htp.p('');

236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p('');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('');
241: htp.p('');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('');
244: htp.p('');

Line 241: htp.p('');

237: htp.tableRowOpen;
238: htp.p('');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('');
241: htp.p('');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('');
244: htp.p('');
245: htp.p(rec_get_terr_values.high_value_number);

Line 242: htp.p(rec_get_terr_values.low_value_number);

238: htp.p('');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('');
241: htp.p('');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('');
244: htp.p('');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('');

Line 243: htp.p('');

239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('');
241: htp.p('');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('');
244: htp.p('');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('');
247: htp.p('');

Line 244: htp.p('');

240: htp.p('');
241: htp.p('');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('');
244: htp.p('');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('');
247: htp.p('');
248: htp.p('');

Line 245: htp.p(rec_get_terr_values.high_value_number);

241: htp.p('');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('');
244: htp.p('');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('');
247: htp.p('');
248: htp.p('');
249: htp.p('');

Line 246: htp.p('');

242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('');
244: htp.p('');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('');
247: htp.p('');
248: htp.p('');
249: htp.p('');
250: htp.tableRowClose;

Line 247: htp.p('');

243: htp.p('');
244: htp.p('');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('');
247: htp.p('');
248: htp.p('');
249: htp.p('');
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then

Line 248: htp.p('');

244: htp.p('');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('');
247: htp.p('');
248: htp.p('');
249: htp.p('');
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;

Line 249: htp.p('');

245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('');
247: htp.p('');
248: htp.p('');
249: htp.p('');
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p('');

Line 250: htp.tableRowClose;

246: htp.p('');
247: htp.p('');
248: htp.p('');
249: htp.p('');
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p('');
254: htp.p(rec_get_terr_values.comparison_operator);

Line 252: htp.tableRowOpen;

248: htp.p('');
249: htp.p('');
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p('');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('');
256: htp.p('');

Line 253: htp.p('');

249: htp.p('');
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p('');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('');
256: htp.p('');
257: htp.p(rec_get_terr_values.low_value_number);

Line 254: htp.p(rec_get_terr_values.comparison_operator);

250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p('');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('');
256: htp.p('');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('');

Line 255: htp.p('');

251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p('');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('');
256: htp.p('');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('');
259: htp.p('');

Line 256: htp.p('');

252: htp.tableRowOpen;
253: htp.p('');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('');
256: htp.p('');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('');
259: htp.p('');
260: htp.p(rec_get_terr_values.high_value_number);

Line 257: htp.p(rec_get_terr_values.low_value_number);

253: htp.p('');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('');
256: htp.p('');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('');
259: htp.p('');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('');

Line 258: htp.p('');

254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('');
256: htp.p('');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('');
259: htp.p('');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('');
262: htp.p('');

Line 259: htp.p('');

255: htp.p('');
256: htp.p('');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('');
259: htp.p('');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('');
262: htp.p('');
263: htp.p(rec_get_terr_values.currency_code);

Line 260: htp.p(rec_get_terr_values.high_value_number);

256: htp.p('');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('');
259: htp.p('');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('');
262: htp.p('');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('');

Line 261: htp.p('');

257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('');
259: htp.p('');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('');
262: htp.p('');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('');
265: htp.tableRowClose;

Line 262: htp.p('');

258: htp.p('');
259: htp.p('');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('');
262: htp.p('');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('');
265: htp.tableRowClose;
266: else

Line 263: htp.p(rec_get_terr_values.currency_code);

259: htp.p('');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('');
262: htp.p('');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('');
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;

Line 264: htp.p('');

260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('');
262: htp.p('');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('');
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
268: htp.p('');

Line 265: htp.tableRowClose;

261: htp.p('');
262: htp.p('');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('');
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
268: htp.p('');
269: htp.p('NO DATA DISPLAYED');

Line 267: htp.tableRowOpen;

263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('');
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
268: htp.p('');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('');
271: htp.tableRowClose;

Line 268: htp.p('');

264: htp.p('');
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
268: htp.p('');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('');
271: htp.tableRowClose;
272: end if;

Line 269: htp.p('NO DATA DISPLAYED');

265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
268: htp.p('');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('');
271: htp.tableRowClose;
272: end if;
273: END LOOP;

Line 270: htp.p('');

266: else
267: htp.tableRowOpen;
268: htp.p('');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('');
271: htp.tableRowClose;
272: end if;
273: END LOOP;
274: END LOOP;

Line 271: htp.tableRowClose;

267: htp.tableRowOpen;
268: htp.p('');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('');
271: htp.tableRowClose;
272: end if;
273: END LOOP;
274: END LOOP;
275: END LOOP;

Line 277: htp.p('No territories meet search criteria.');

273: END LOOP;
274: END LOOP;
275: END LOOP;
276: If l_rec_count = 0 then
277: htp.p('No territories meet search criteria.');
278: End if;
279:
280: htp.tableClose;
281:

Line 280: htp.tableClose;

276: If l_rec_count = 0 then
277: htp.p('No territories meet search criteria.');
278: End if;
279:
280: htp.tableClose;
281:
282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;

Line 283: htp.tableOpen (cattributes => 'border="1" width="100%"');

279:
280: htp.tableClose;
281:
282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name');
287: htp.p('SalesRep');

Line 284: htp.tableRowOpen;

280: htp.tableClose;
281:
282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name');
287: htp.p('SalesRep');
288: --htp.p('Group Name');

Line 285: htp.p('');

281:
282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name');
287: htp.p('SalesRep');
288: --htp.p('Group Name');
289: htp.p('Territory Type');

Line 286: htp.p('Territory Name');

282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name');
287: htp.p('SalesRep');
288: --htp.p('Group Name');
289: htp.p('Territory Type');
290: htp.p('Qualifier Name');

Line 287: htp.p('SalesRep');

283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name');
287: htp.p('SalesRep');
288: --htp.p('Group Name');
289: htp.p('Territory Type');
290: htp.p('Qualifier Name');
291: htp.p('Value1');

Line 288: --htp.p('Group Name');

284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name');
287: htp.p('SalesRep');
288: --htp.p('Group Name');
289: htp.p('Territory Type');
290: htp.p('Qualifier Name');
291: htp.p('Value1');
292: htp.p('Value2');

Line 289: htp.p('Territory Type');

285: htp.p('');
286: htp.p('Territory Name');
287: htp.p('SalesRep');
288: --htp.p('Group Name');
289: htp.p('Territory Type');
290: htp.p('Qualifier Name');
291: htp.p('Value1');
292: htp.p('Value2');
293: htp.p('Created/Updates');

Line 290: htp.p('Qualifier Name');

286: htp.p('Territory Name');
287: htp.p('SalesRep');
288: --htp.p('Group Name');
289: htp.p('Territory Type');
290: htp.p('Qualifier Name');
291: htp.p('Value1');
292: htp.p('Value2');
293: htp.p('Created/Updates');
294: htp.tableRowClose;

Line 291: htp.p('Value1');

287: htp.p('SalesRep');
288: --htp.p('Group Name');
289: htp.p('Territory Type');
290: htp.p('Qualifier Name');
291: htp.p('Value1');
292: htp.p('Value2');
293: htp.p('Created/Updates');
294: htp.tableRowClose;
295: -- display territories

Line 292: htp.p('Value2');

288: --htp.p('Group Name');
289: htp.p('Territory Type');
290: htp.p('Qualifier Name');
291: htp.p('Value1');
292: htp.p('Value2');
293: htp.p('Created/Updates');
294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop

Line 293: htp.p('Created/Updates');

289: htp.p('Territory Type');
290: htp.p('Qualifier Name');
291: htp.p('Value1');
292: htp.p('Value2');
293: htp.p('Created/Updates');
294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;

Line 294: htp.tableRowClose;

290: htp.p('Qualifier Name');
291: htp.p('Value1');
292: htp.p('Value2');
293: htp.p('Created/Updates');
294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p('');

Line 297: htp.tableRowOpen;

293: htp.p('Created/Updates');
294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p('');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('');
301: htp.br;

Line 298: htp.p('');

294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p('');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('');
301: htp.br;
302: htp.tableRowClose;

Line 299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);

295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p('');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('');
301: htp.br;
302: htp.tableRowClose;
303: end loop;

Line 300: htp.p('');

296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p('');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('');
301: htp.br;
302: htp.tableRowClose;
303: end loop;
304:

Line 301: htp.br;

297: htp.tableRowOpen;
298: htp.p('');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('');
301: htp.br;
302: htp.tableRowClose;
303: end loop;
304:
305: -- DBMS_SQL.CLOSE_CURSOR(cid);

Line 302: htp.tableRowClose;

298: htp.p('');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('');
301: htp.br;
302: htp.tableRowClose;
303: end loop;
304:
305: -- DBMS_SQL.CLOSE_CURSOR(cid);
306: htp.tableClose;

Line 306: htp.tableClose;

302: htp.tableRowClose;
303: end loop;
304:
305: -- DBMS_SQL.CLOSE_CURSOR(cid);
306: htp.tableClose;
307: */
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;

Line 308: htp.Br;

304:
305: -- DBMS_SQL.CLOSE_CURSOR(cid);
306: htp.tableClose;
307: */
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;
311: htp.htmlClose;
312: end if;

Line 309: -- htp.p(p_count - 1||' records found');

305: -- DBMS_SQL.CLOSE_CURSOR(cid);
306: htp.tableClose;
307: */
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;
311: htp.htmlClose;
312: end if;
313: else

Line 310: htp.bodyClose;

306: htp.tableClose;
307: */
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;
311: htp.htmlClose;
312: end if;
313: else
314: htp.p('Invalid session');

Line 311: htp.htmlClose;

307: */
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;
311: htp.htmlClose;
312: end if;
313: else
314: htp.p('Invalid session');
315: end if;

Line 314: htp.p('Invalid session');

310: htp.bodyClose;
311: htp.htmlClose;
312: end if;
313: else
314: htp.p('Invalid session');
315: end if;
316: -- dbms_session.set_sql_trace(FALSE);
317:
318: EXCEPTION

Line 320: htp.print('Territory Changes Report: No Data Found!!!');

316: -- dbms_session.set_sql_trace(FALSE);
317:
318: EXCEPTION
319: when no_data_found then
320: htp.print('Territory Changes Report: No Data Found!!!');
321: when others then
322: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));
323: END;
324:

Line 322: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));

318: EXCEPTION
319: when no_data_found then
320: htp.print('Territory Changes Report: No Data Found!!!');
321: when others then
322: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));
323: END;
324:
325: ----------------------------------------------------------------------------------------------------------------------
326: PROCEDURE XLS (

Line 398: --htp.p(v_tabrow);

394: SELECT FND_GLOBAL.TAB
395: INTO v_tab
396: from dual;
397:
398: --htp.p(v_tabrow);
399: v_tabrow := null;
400: -- display territories
401: l_rec_count := 0;
402:

Line 407: htp.p(v_tabrow);

403: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
404: /*
405: if cur_territory%rowcount > 1 then
406: v_tabrow := v_tabrow||' '||v_tab;
407: htp.p(v_tabrow);
408: htp.p(v_tabrow);
409: v_tabrow := null;
410: end if;
411: */

Line 408: htp.p(v_tabrow);

404: /*
405: if cur_territory%rowcount > 1 then
406: v_tabrow := v_tabrow||' '||v_tab;
407: htp.p(v_tabrow);
408: htp.p(v_tabrow);
409: v_tabrow := null;
410: end if;
411: */
412: v_tabrow := null;

Line 413: htp.p(v_tabrow); -- add a blank before each territory

409: v_tabrow := null;
410: end if;
411: */
412: v_tabrow := null;
413: htp.p(v_tabrow); -- add a blank before each territory
414: v_tabrow := null;
415: v_tabrow := v_tabrow||rec_terr.name||v_tab;
416: v_tabrow := v_tabrow||'Rank: '||rec_terr.rank||v_tab;
417: v_tabrow := v_tabrow||'Type: '||rec_terr.terr_type_name||v_tab;

Line 419: htp.p(v_tabrow); -- print out prepared line

415: v_tabrow := v_tabrow||rec_terr.name||v_tab;
416: v_tabrow := v_tabrow||'Rank: '||rec_terr.rank||v_tab;
417: v_tabrow := v_tabrow||'Type: '||rec_terr.terr_type_name||v_tab;
418: v_tabrow := v_tabrow||'Created: '||rec_terr.creation_date||' Updated: '||rec_terr.last_update_date||v_tab;
419: htp.p(v_tabrow); -- print out prepared line
420: v_tabrow := null;
421: v_tabrow := v_tabrow||h1_divider||v_tab;
422: v_tabrow := v_tabrow||h1_divider||v_tab;
423: v_tabrow := v_tabrow||h1_divider||v_tab;

Line 425: htp.p(v_tabrow); -- divider since we dont' know how to format rows in XLS

421: v_tabrow := v_tabrow||h1_divider||v_tab;
422: v_tabrow := v_tabrow||h1_divider||v_tab;
423: v_tabrow := v_tabrow||h1_divider||v_tab;
424: v_tabrow := v_tabrow||h1_divider||v_tab;
425: htp.p(v_tabrow); -- divider since we dont' know how to format rows in XLS
426: -- display sales reps
427: l_counter2 := 0;
428: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
429: l_counter2 := l_counter2 + 1;

Line 434: htp.p(v_tabrow);

430: v_tabrow := null;
431: v_tabrow := v_tabrow||rec_get_salesrep.resource_name||v_tab;
432: --v_tabrow := v_tabrow||rec_get_salesrep.resource_name||'l_counter2: '||l_counter2||v_tab;
433: --v_tabrow := v_tabrow||rec_get_salesrep.resource_id||v_tab;
434: htp.p(v_tabrow);
435: END LOOP;
436: v_tabrow := null;
437: v_tabrow := v_tabrow||h2_divider||v_tab;
438: htp.p(v_tabrow);

Line 438: htp.p(v_tabrow);

434: htp.p(v_tabrow);
435: END LOOP;
436: v_tabrow := null;
437: v_tabrow := v_tabrow||h2_divider||v_tab;
438: htp.p(v_tabrow);
439: -- display qualifiers
440: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
441: v_tabrow := null;
442: htp.p(v_tabrow); -- put in a CR before each qualifier

Line 442: htp.p(v_tabrow); -- put in a CR before each qualifier

438: htp.p(v_tabrow);
439: -- display qualifiers
440: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
441: v_tabrow := null;
442: htp.p(v_tabrow); -- put in a CR before each qualifier
443: v_tabrow := null;
444: v_tabrow := v_tabrow||rec_get_terr_qual.qualifier_name||v_tab;
445: --v_tabrow := v_tabrow||rec_get_terr_qual.terr_qual_id||v_tab;
446: htp.p(v_tabrow);

Line 446: htp.p(v_tabrow);

442: htp.p(v_tabrow); -- put in a CR before each qualifier
443: v_tabrow := null;
444: v_tabrow := v_tabrow||rec_get_terr_qual.qualifier_name||v_tab;
445: --v_tabrow := v_tabrow||rec_get_terr_qual.terr_qual_id||v_tab;
446: htp.p(v_tabrow);
447: v_tabrow := null;
448: v_tabrow := v_tabrow||h3_divider||v_tab;
449: htp.p(v_tabrow);
450:

Line 449: htp.p(v_tabrow);

445: --v_tabrow := v_tabrow||rec_get_terr_qual.terr_qual_id||v_tab;
446: htp.p(v_tabrow);
447: v_tabrow := null;
448: v_tabrow := v_tabrow||h3_divider||v_tab;
449: htp.p(v_tabrow);
450:
451: -- display qualifier values
452: l_counter := 0;
453: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop

Line 465: htp.p(v_tabrow);

461: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
462: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_desc||v_tab;
463: --v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_id|| 'CHAR_Y l_counter:'||l_counter|| v_tab;
464: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_id||v_tab;
465: htp.p(v_tabrow);
466: else -- (l_convert_to_id_flag = 'N')
467: v_tabrow := null;
468: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
469: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_desc||v_tab;

Line 472: htp.p(v_tabrow);

468: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
469: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_desc||v_tab;
470: --v_tabrow := v_tabrow||rec_get_terr_values.high_value_char_desc|| 'CHAR_N l_counter:'||l_counter|| v_tab;
471: v_tabrow := v_tabrow||rec_get_terr_values.high_value_char_desc||v_tab;
472: htp.p(v_tabrow);
473: End if;
474: elsif (l_display_type = 'INTEREST_TYPE') then
475: v_tabrow := null;
476: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;

Line 481: htp.p(v_tabrow);

477: v_tabrow := v_tabrow||rec_get_terr_values.interest_type||v_tab;
478: v_tabrow := v_tabrow||rec_get_terr_values.primary_interest_code||v_tab;
479: --v_tabrow := v_tabrow||rec_get_terr_values.secondary_interest_code|| 'INT_T l_counter:'||l_counter|| v_tab;
480: v_tabrow := v_tabrow||rec_get_terr_values.secondary_interest_code||v_tab;
481: htp.p(v_tabrow);
482: elsif (l_display_type = 'NUMBER') then
483: v_tabrow := null;
484: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
485: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;

Line 488: htp.p(v_tabrow);

484: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
485: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;
486: --v_tabrow := v_tabrow||rec_get_terr_values.high_value_number|| 'NUM l_counter:'||l_counter|| v_tab;
487: v_tabrow := v_tabrow||rec_get_terr_values.high_value_number||v_tab;
488: htp.p(v_tabrow);
489: elsif (l_display_type = 'CURRENCY') then
490: v_tabrow := null;
491: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
492: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;

Line 496: htp.p(v_tabrow);

492: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;
493: v_tabrow := v_tabrow||rec_get_terr_values.high_value_number||v_tab;
494: --v_tabrow := v_tabrow||rec_get_terr_values.currency_code|| 'CUR l_counter:'||l_counter|| v_tab;
495: v_tabrow := v_tabrow||rec_get_terr_values.currency_code||v_tab;
496: htp.p(v_tabrow);
497: else
498: v_tabrow := null;
499: v_tabrow := v_tabrow||'NO DATA DISPLAYED'||v_tab;
500: htp.p(v_tabrow);

Line 500: htp.p(v_tabrow);

496: htp.p(v_tabrow);
497: else
498: v_tabrow := null;
499: v_tabrow := v_tabrow||'NO DATA DISPLAYED'||v_tab;
500: htp.p(v_tabrow);
501: end if;
502: END LOOP;
503: END LOOP;
504: END LOOP;

Line 508: htp.p(v_tabrow);

504: END LOOP;
505: If l_rec_count = 0 then
506: v_tabrow := null;
507: v_tabrow := v_tabrow||'No territories meet search criteria.'||v_tab;
508: htp.p(v_tabrow);
509: End if;
510:
511:
512: exception

Line 514: htp.print('Territory Changes excel: No Data Found!!!');

510:
511:
512: exception
513: when no_data_found then
514: htp.print('Territory Changes excel: No Data Found!!!');
515: when others then
516: htp.print('Territory Changes excel: '||substr(SQLERRM, 1,200));
517: END XLS;
518:

Line 516: htp.print('Territory Changes excel: '||substr(SQLERRM, 1,200));

512: exception
513: when no_data_found then
514: htp.print('Territory Changes excel: No Data Found!!!');
515: when others then
516: htp.print('Territory Changes excel: '||substr(SQLERRM, 1,200));
517: END XLS;
518:
519:
520: END;