83: else
84: v_jaws_spt_val := 'Yes';
85: end if;
86:
87: htp.htmlOpen;
88: -- show copyright in source
89: icx_util.copyright;
90: htp.headOpen;
91:
86:
87: htp.htmlOpen;
88: -- show copyright in source
89: icx_util.copyright;
90: htp.headOpen;
91:
92: icx_util.getPrompts(v_appl_id, v_page_code, v_title, v_prompt_tab);
93: v_prompt := v_prompt_tab(1);
94: v_start := v_prompt_tab(2);
92: icx_util.getPrompts(v_appl_id, v_page_code, v_title, v_prompt_tab);
93: v_prompt := v_prompt_tab(1);
94: v_start := v_prompt_tab(2);
95: v_no_plans := v_prompt_tab(3);
96: htp.title(v_title);
97:
98: htp.p('');
132: htp.headClose;
133:
134: htp.bodyOpen( cattributes => 'BGCOLOR=white');
127: alert("Select a demand plan.")
128: }
129: }');
130: htp.p('// done hiding -->');
131: htp.p('');
132: htp.headClose;
133:
134: htp.bodyOpen( cattributes => 'BGCOLOR=white');
135: -- display logo and toolbar
128: }
129: }');
130: htp.p('// done hiding -->');
131: htp.p('');
132: htp.headClose;
133:
134: htp.bodyOpen( cattributes => 'BGCOLOR=white');
135: -- display logo and toolbar
136: icx_admin_sig.toolbar(v_language);
130: htp.p('// done hiding -->');
131: htp.p('');
132: htp.headClose;
133:
134: htp.bodyOpen( cattributes => 'BGCOLOR=white');
135: -- display logo and toolbar
136: icx_admin_sig.toolbar(v_language);
137: htp.header(3, v_prompt);
138: htp.para;
133:
134: htp.bodyOpen( cattributes => 'BGCOLOR=white');
135: -- display logo and toolbar
136: icx_admin_sig.toolbar(v_language);
137: htp.header(3, v_prompt);
138: htp.para;
139:
140: htp.formOpen(curl => '');
141: b_plans_found := false;
134: htp.bodyOpen( cattributes => 'BGCOLOR=white');
135: -- display logo and toolbar
136: icx_admin_sig.toolbar(v_language);
137: htp.header(3, v_prompt);
138: htp.para;
139:
140: htp.formOpen(curl => '');
141: b_plans_found := false;
142: for v_plan in c_demand_plans loop
136: icx_admin_sig.toolbar(v_language);
137: htp.header(3, v_prompt);
138: htp.para;
139:
140: htp.formOpen(curl => '');
141: b_plans_found := false;
142: for v_plan in c_demand_plans loop
143:
144: select REPLACE(v_plan.SHARED_DB_LOCATION, v_sep, v_pth_sep)
158:
159: htp.p(' ' ||
161: v_plan.DEMAND_PLAN_NAME);
162: htp.nl;
163:
164: b_plans_found := true;
165: end loop;
166:
164: b_plans_found := true;
165: end loop;
166:
167: if (b_plans_found) then
168: htp.para;
169: htp.p('');
170: else
171: htp.para;
172: htp.print(v_no_plans);
165: end loop;
166:
167: if (b_plans_found) then
168: htp.para;
169: htp.p('');
170: else
171: htp.para;
172: htp.print(v_no_plans);
173: htp.para;
167: if (b_plans_found) then
168: htp.para;
169: htp.p('');
170: else
171: htp.para;
172: htp.print(v_no_plans);
173: htp.para;
174: end if;
175:
168: htp.para;
169: htp.p('');
170: else
171: htp.para;
172: htp.print(v_no_plans);
173: htp.para;
174: end if;
175:
176: htp.formClose;
169: htp.p('');
170: else
171: htp.para;
172: htp.print(v_no_plans);
173: htp.para;
174: end if;
175:
176: htp.formClose;
177: htp.bodyClose;
172: htp.print(v_no_plans);
173: htp.para;
174: end if;
175:
176: htp.formClose;
177: htp.bodyClose;
178: htp.htmlClose;
179: end if;
180:
173: htp.para;
174: end if;
175:
176: htp.formClose;
177: htp.bodyClose;
178: htp.htmlClose;
179: end if;
180:
181: end display_plans;
174: end if;
175:
176: htp.formClose;
177: htp.bodyClose;
178: htp.htmlClose;
179: end if;
180:
181: end display_plans;
182: