20: IF icx_sec.validateSession THEN
21: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
22: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
23:
24: htp.htmlOpen;
25: htp.title('HTML Template Tags');
26: htp.headOpen;
27: js.scriptOpen;
28:
21: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
22: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
23:
24: htp.htmlOpen;
25: htp.title('HTML Template Tags');
26: htp.headOpen;
27: js.scriptOpen;
28:
29: /****** Assigns the help page and paints the toolbar *******/
22: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
23:
24: htp.htmlOpen;
25: htp.title('HTML Template Tags');
26: htp.headOpen;
27: js.scriptOpen;
28:
29: /****** Assigns the help page and paints the toolbar *******/
30:
35:
36: /***** Gets the title of the page *******/
37:
38: icx_util.getprompts(601,'ICX_TEMPL_TAG_HDR_R',v_title,v_prompts);
39: htp.p(''||v_title||'
');
40: htp.p('
36: /***** Gets the title of the page *******/
37:
38: icx_util.getprompts(601,'ICX_TEMPL_TAG_HDR_R',v_title,v_prompts);
39: htp.p(''||v_title||'
');
40: htp.p('
39: htp.p(''||v_title||'
');
40: htp.p('
65: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
66: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' and
67: ak_query_pkg.g_items_table(k).value_id is not NULL then
68: v_tag_val := (v_line_table(ak_query_pkg.g_items_table(k).value_id));
69: htp.p(''||v_tag_val||'');
70: htp.p('
');
71:
72: end if;
73: end loop;
66: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' and
67: ak_query_pkg.g_items_table(k).value_id is not NULL then
68: v_tag_val := (v_line_table(ak_query_pkg.g_items_table(k).value_id));
69: htp.p(''||v_tag_val||'');
70: htp.p('
');
71:
72: end if;
73: end loop;
74: end loop ;
76: /***********Paint New Button*********/
77: v_new_proc := 'icx_tag.tag_det';
78: v_new_prompt := 'ADD NEW TAG';
79:
80: htp.p('
');
81: icx_util.DynamicButton(P_ButtonText => v_new_prompt,
82: P_ImageFileName => 'FNDBNEW',
83: P_OnMouseOverText => v_new_prompt,
84: P_HyperTextCall => v_new_proc,
86: P_JavaScriptFlag => FALSE);
87:
88: else
89:
90: htp.bodyOpen('','BGCOLOR="#CCFFCC"');
91: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
92: htp.p('
88: else
89:
90: htp.bodyOpen('','BGCOLOR="#CCFFCC"');
91: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
92: htp.p(''||fnd_message.get||'
');
93: htp.bodyClose;
94:
95: end if;
96:
89:
90: htp.bodyOpen('','BGCOLOR="#CCFFCC"');
91: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
92: htp.p('
129: IF icx_sec.validateSession THEN
130: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
131: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
132:
133: htp.htmlOpen;
134: htp.title('HTML Template Tags');
135: htp.headOpen;
136: js.scriptOpen;
137:
130: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
131: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
132:
133: htp.htmlOpen;
134: htp.title('HTML Template Tags');
135: htp.headOpen;
136: js.scriptOpen;
137:
138:
131: v_help_url := '/OA_DOC/' || v_language_code ||'/awc' || '/icxstim.htm';
132:
133: htp.htmlOpen;
134: htp.title('HTML Template Tags');
135: htp.headOpen;
136: js.scriptOpen;
137:
138:
139: htp.p('function submit_request() {
135: htp.headOpen;
136: js.scriptOpen;
137:
138:
139: htp.p('function submit_request() {
140: var name_msg = "Please enter values for all the fields"
141: if (document.enter_tag.p_tag_name.value == "")
142: { alert(name_msg);}
143: else if (document.enter_tag.p_tag_description.value =="")
149: }
150: ');
151:
152:
153: htp.p('function revert() {
154: document.enter_tag.reset() }');
155:
156:
157: /****** Assigns the help page and paints the toolbar *******/
162:
163: /***** Gets the title of the page *******/
164:
165: icx_util.getprompts(601,'ICX_TEMPL_TAG_DTLS_R',v_title,v_prompts);
166: htp.p(''||v_title||'
');
167: htp.p('
163: /***** Gets the title of the page *******/
164:
165: icx_util.getprompts(601,'ICX_TEMPL_TAG_DTLS_R',v_title,v_prompts);
166: htp.p(''||v_title||'
');
167: htp.p('
166: htp.p(''||v_title||'
');
167: htp.p('
170: htp.headClose;
171: js.scriptClose;
172:
173:
174: htp.formOpen('icx_tag.update_tag_det','POST','','','NAME="enter_tag"');
175:
176: /************Prints the page for a new or unprotected tag*******************/
177:
178: IF p_tag IS NOT NULL THEN
196:
197:
198: IF v_protected = 'N' OR p_tag is null OR p_copy = 'Y' THEN
199:
200: htp.tableOpen;
201: htp.tableRowOpen;
202: htp.p('
197:
198: IF v_protected = 'N' OR p_tag is null OR p_copy = 'Y' THEN
199:
200: htp.tableOpen;
201: htp.tableRowOpen;
202: htp.p('
198: IF v_protected = 'N' OR p_tag is null OR p_copy = 'Y' THEN
199:
200: htp.tableOpen;
201: htp.tableRowOpen;
202: htp.p('
202: htp.p('
204: /**********Leave the name field blank if it is being copied **************/
205: IF p_copy ='Y' then
206: htp.tableData(cvalue => htf.formText(cname => 'p_tag_name', csize => '40'));
207: ELSE
208: htp.tableData(cvalue => htf.formText(cname => 'p_tag_name', csize => '40', cvalue => v_tag_name));
209: END IF;
210: htp.tableRowClose;
211:
212: htp.tableRowOpen;
206: htp.tableData(cvalue => htf.formText(cname => 'p_tag_name', csize => '40'));
207: ELSE
208: htp.tableData(cvalue => htf.formText(cname => 'p_tag_name', csize => '40', cvalue => v_tag_name));
209: END IF;
210: htp.tableRowClose;
211:
212: htp.tableRowOpen;
213: htp.p('
208: htp.tableData(cvalue => htf.formText(cname => 'p_tag_name', csize => '40', cvalue => v_tag_name));
209: END IF;
210: htp.tableRowClose;
211:
212: htp.tableRowOpen;
213: htp.p('
209: END IF;
210: htp.tableRowClose;
211:
212: htp.tableRowOpen;
213: htp.p('
210: htp.tableRowClose;
211:
212: htp.tableRowOpen;
213: htp.p('
211:
212: htp.tableRowOpen;
213: htp.p('
218: fetch c_application into l_application_id, l_application_name;
219: IF c_application%notfound then exit;
220: END IF;
221: IF v_application_id = l_application_id THEN
222: htp.p('223: ELSIF
224: l_application_id = 178 THEN
225: htp.p('
221: IF v_application_id = l_application_id THEN
222: htp.p('
228: END IF;
229: end loop;
223: ELSIF
224: l_application_id = 178 THEN
225: htp.p('
226: ELSE
227: htp.p('
229: end loop;
230: htp.p('
231: htp.p('
226: ELSE
227: htp.p('
228: END IF;
229: end loop;
230: htp.p('
231: htp.p('
227: htp.p('
228: END IF;
229: end loop;
230: htp.p('
231: htp.p('
232: htp.tableRowClose;
233:
234: htp.tableRowOpen;
235: htp.p(''||v_prompts(3)||' ');
228: END IF;
229: end loop;
230: htp.p('
231: htp.p('
232: htp.tableRowClose;
233:
234: htp.tableRowOpen;
235: htp.p('
230: htp.p(' 231: htp.p('
231: htp.p('
232: htp.tableRowClose;
233:
234: htp.tableRowOpen;
235: htp.p('
232: htp.tableRowClose;
233:
234: htp.tableRowOpen;
235: htp.p('
233:
234: htp.tableRowOpen;
235: htp.p('
234: htp.tableRowOpen;
235: htp.p('
235: htp.p('
238: htp.p('');
239: htp.tableRowClose;
240:
241:
242: htp.tableRowOpen;
243: htp.p('
239: htp.tableRowClose;
240:
241:
242: htp.tableRowOpen;
243: htp.p('
240:
241:
242: htp.tableRowOpen;
243: htp.p('
242: htp.tableRowOpen;
243: htp.p('
243: htp.p('
244: htp.p('
245: v_replacement_text_temp := (''||v_replacement_text||'');
246: htp.p('');
247: htp.p('
252: htp.p('
253: htp.p('
254: htp.p('
255: htp.p('
256: htp.p('
257: htp.p('');
258: htp.tableClose;
259: htp.p('
');
260: /**********Paints the Save Button************/
261: icx_util.DynamicButton(P_ButtonText => 'SAVE',
254: htp.p('
255: htp.p('
256: htp.p('');
257: htp.p('');
258: htp.tableClose;
259: htp.p('
');
260: /**********Paints the Save Button************/
261: icx_util.DynamicButton(P_ButtonText => 'SAVE',
262: P_ImageFileName => 'FNDBSAVE',
255: htp.p('
256: htp.p('');
257: htp.p('');
258: htp.tableClose;
259: htp.p('
');
260: /**********Paints the Save Button************/
261: icx_util.DynamicButton(P_ButtonText => 'SAVE',
262: P_ImageFileName => 'FNDBSAVE',
263: P_OnMouseOverText => 'SAVE',
286:
287:
288: ELSE
289: /********Prints the data as text for tags which are protected*********/
290: htp.tableOpen;
291:
292: htp.tableRowOpen;
293: htp.p('
288: ELSE
289: /********Prints the data as text for tags which are protected*********/
290: htp.tableOpen;
291:
292: htp.tableRowOpen;
293: htp.p('
289: /********Prints the data as text for tags which are protected*********/
290: htp.tableOpen;
291:
292: htp.tableRowOpen;
293: htp.p('
290: htp.tableOpen;
291:
292: htp.tableRowOpen;
293: htp.p('
291:
292: htp.tableRowOpen;
293: htp.p('
292: htp.tableRowOpen;
293: htp.p('
293: htp.p('
295: htp.p (v_tag_name);
296: htp.p('');
297: htp.tableRowClose;
298:
299: htp.tableRowOpen;
300: htp.p('
296: htp.p('');
297: htp.tableRowClose;
298:
299: htp.tableRowOpen;
300: htp.p('
307: IF l_application_id = v_application_id THEN
308: v_application_name := l_application_name;
309: END IF;
310: end loop;
311: htp.p('
308: v_application_name := l_application_name;
309: END IF;
310: end loop;
311: htp.p('
309: END IF;
310: end loop;
311: htp.p('
310: end loop;
311: htp.p('
313: htp.p('');
314: htp.tableRowClose;
315:
316:
317: htp.tableRowOpen;
318: htp.p('
314: htp.tableRowClose;
315:
316:
317: htp.tableRowOpen;
318: htp.p('
315:
316:
317: htp.tableRowOpen;
318: htp.p('
316:
317: htp.tableRowOpen;
318: htp.p('
317: htp.tableRowOpen;
318: htp.p('
318: htp.p('
321: htp.p('');
322: htp.tableRowClose;
323:
324:
325: htp.tableRowOpen;
326: htp.p('
322: htp.tableRowClose;
323:
324:
325: htp.tableRowOpen;
326: htp.p('
323:
324:
325: htp.tableRowOpen;
326: htp.p('
324:
325: htp.tableRowOpen;
326: htp.p('
325: htp.tableRowOpen;
326: htp.p('
326: htp.p('
327: htp.p('
328: htp.p('
330: htp.P('');
331: htp.p('
331: htp.p('');
332: htp.tableRowClose;
333:
334: htp.tableRowOpen;
335: htp.p('
332: htp.tableRowClose;
333:
334: htp.tableRowOpen;
335: htp.p('
333:
334: htp.tableRowOpen;
335: htp.p('
334: htp.tableRowOpen;
335: htp.p('
335: htp.p('
336: htp.p('
337: htp.p ('YES');
338: htp.p('');
339: htp.tableRowClose;
340: htp.tableClose;
341: htp.p('
');
342:
343: /**********Paints the Copy Button *******/
344: p_copy_temp := 'Y';
345: icx_util.DynamicButton(P_ButtonText => 'COPY',
349: P_LanguageCode => v_language_code,
350: P_JavaScriptFlag => FALSE);
351:
352: END IF;
353: htp.formClose;
354:
355: htp.htmlClose;
356:
357:
351:
352: END IF;
353: htp.formClose;
354:
355: htp.htmlClose;
356:
357:
358: END IF;
359:
405: END IF;
406: icx_tag.tag_maint;
407: exception
408: when others then
409: htp.p(sqlerrm);
410:
411:
412: END update_tag_det;
413: