6: -----------------------------------------------------------
7: v_help_url VARCHAR2(2000) := NULL;
8: v_language_code VARCHAR2(30) :=NULL;
9: v_title varchar2(45) ;
10: v_prompts icx_util.g_prompts_table;
11: v_line_table icx_util.char240_table;
12: v_tag_val varchar2(40);
13: v_new_proc varchar2(100);
14: v_new_prompt varchar2(100);
7: v_help_url VARCHAR2(2000) := NULL;
8: v_language_code VARCHAR2(30) :=NULL;
9: v_title varchar2(45) ;
10: v_prompts icx_util.g_prompts_table;
11: v_line_table icx_util.char240_table;
12: v_tag_val varchar2(40);
13: v_new_proc varchar2(100);
14: v_new_prompt varchar2(100);
15: v_order_by varchar2(100);
34:
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('
57:
58:
59: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
60:
61: icx_util.transfer_row_to_column(ak_query_pkg.g_results_table(i),v_line_table);
62:
63: for k in ak_query_pkg.g_items_table.first..ak_query_pkg.g_items_table.last loop
64:
65: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
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,
85: P_LanguageCode => v_language_code,
114: v_application_name varchar2(50) :=null;
115: v_help_url VARCHAR2(2000) := NULL;
116: v_language_code VARCHAR2(30) :=NULL;
117: v_title varchar2(45) ;
118: v_prompts icx_util.g_prompts_table;
119: v_where_clause varchar2(1000);
120: v_tag_name varchar2(200) default NULL;
121: v_application_id number default NULL;
122: v_tag_description varchar2(4000) default NULL;
161: icx_admin_sig.toolbar(language_code => v_language_code);
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('
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',
264: P_HyperTextCall => 'javascript:submit_request()',
265: P_LanguageCode => v_language_code,
265: P_LanguageCode => v_language_code,
266: P_JavaScriptFlag => FALSE);
267:
268: /**********Paints the Revert Button*******/
269: icx_util.DynamicButton(P_ButtonText => 'REVERT',
270: P_ImageFileName => 'FNDBCLR',
271: P_OnMouseOverText =>'REVERT',
272: P_HyperTextCall => 'javascript:revert()',
273: P_LanguageCode => v_language_code,
275:
276: /**********Paints the Copy Button for existing tags*******/
277: IF p_copy IS NULL and p_tag IS NOT NULL THEN
278: p_copy_temp := 'Y';
279: icx_util.DynamicButton(P_ButtonText => 'COPY',
280: P_ImageFileName => 'FNDBNEW',
281: P_OnMouseOverText =>'COPY TAG',
282: P_HyperTextCall => 'icx_tag.tag_det?p_tag='||v_tag_name||'&p_copy='||p_copy_temp,
283: P_LanguageCode => v_language_code,
341: htp.p('
');
342:
343: /**********Paints the Copy Button *******/
344: p_copy_temp := 'Y';
345: icx_util.DynamicButton(P_ButtonText => 'COPY',
346: P_ImageFileName => 'FNDBCLR',
347: P_OnMouseOverText =>'COPY TAG',
348: P_HyperTextCall => 'icx_tag.tag_det?p_tag='||v_tag_name||'&p_copy='||p_copy_temp,
349: P_LanguageCode => v_language_code,