eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_REQ_CATEGORIES dependencies on HTP

Line 18: htp.htmlOpen;

14: procedure createDummyPage(p_where number, nodeId varchar2, nodeIndex varchar2, v_string long,v_first_time_flag varchar2) is
15: ------------------------------------------------------------
16: begin
17: -- open html
18: htp.htmlOpen;
19: htp.headOpen;
20: htp.headClose;
21:
22: if (v_first_time_flag = 'Y') then

Line 19: htp.headOpen;

15: ------------------------------------------------------------
16: begin
17: -- open html
18: htp.htmlOpen;
19: htp.headOpen;
20: htp.headClose;
21:
22: if (v_first_time_flag = 'Y') then
23: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.openTemplate(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');

Line 20: htp.headClose;

16: begin
17: -- open html
18: htp.htmlOpen;
19: htp.headOpen;
20: htp.headClose;
21:
22: if (v_first_time_flag = 'Y') then
23: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.openTemplate(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
24: else

Line 23: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.openTemplate(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');

19: htp.headOpen;
20: htp.headClose;
21:
22: if (v_first_time_flag = 'Y') then
23: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.openTemplate(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
24: else
25: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
26: end if;
27:

Line 25: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');

21:
22: if (v_first_time_flag = 'Y') then
23: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.openTemplate(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
24: else
25: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
26: end if;
27:
28: htp.formOpen(curl =>'ICX_REQ_CATEGORIES.GetCategoryChildren',
29: cmethod => 'POST',

Line 28: htp.formOpen(curl =>'ICX_REQ_CATEGORIES.GetCategoryChildren',

24: else
25: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
26: end if;
27:
28: htp.formOpen(curl =>'ICX_REQ_CATEGORIES.GetCategoryChildren',
29: cmethod => 'POST',
30: cattributes => 'name=''GetChildren'''
31: );
32:

Line 33: htp.formHidden('nodeId', cvalue => v_string);

29: cmethod => 'POST',
30: cattributes => 'name=''GetChildren'''
31: );
32:
33: htp.formHidden('nodeId', cvalue => v_string);
34: htp.formHidden('p_where', cvalue => p_where);
35: htp.formHidden('nodeIndex', cvalue => nodeIndex);
36:
37: htp.formClose;

Line 34: htp.formHidden('p_where', cvalue => p_where);

30: cattributes => 'name=''GetChildren'''
31: );
32:
33: htp.formHidden('nodeId', cvalue => v_string);
34: htp.formHidden('p_where', cvalue => p_where);
35: htp.formHidden('nodeIndex', cvalue => nodeIndex);
36:
37: htp.formClose;
38: htp.bodyClose;

Line 35: htp.formHidden('nodeIndex', cvalue => nodeIndex);

31: );
32:
33: htp.formHidden('nodeId', cvalue => v_string);
34: htp.formHidden('p_where', cvalue => p_where);
35: htp.formHidden('nodeIndex', cvalue => nodeIndex);
36:
37: htp.formClose;
38: htp.bodyClose;
39: htp.htmlClose;

Line 37: htp.formClose;

33: htp.formHidden('nodeId', cvalue => v_string);
34: htp.formHidden('p_where', cvalue => p_where);
35: htp.formHidden('nodeIndex', cvalue => nodeIndex);
36:
37: htp.formClose;
38: htp.bodyClose;
39: htp.htmlClose;
40:
41: end createDummyPage;

Line 38: htp.bodyClose;

34: htp.formHidden('p_where', cvalue => p_where);
35: htp.formHidden('nodeIndex', cvalue => nodeIndex);
36:
37: htp.formClose;
38: htp.bodyClose;
39: htp.htmlClose;
40:
41: end createDummyPage;
42:

Line 39: htp.htmlClose;

35: htp.formHidden('nodeIndex', cvalue => nodeIndex);
36:
37: htp.formClose;
38: htp.bodyClose;
39: htp.htmlClose;
40:
41: end createDummyPage;
42:
43: --**********************************************************

Line 129: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');

125:
126: counter := 1;
127:
128: if ak_query_pkg.g_results_table.count > 0 then
129: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
130: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
131:
132: v_node_id := ak_query_pkg.g_results_table(i).value2; -- Category id
133: v_name := ak_query_pkg.g_results_table(i).value4; -- Category name

Line 149: htp.p('TOP_CATEGORIES[' || counter || ']= new node(' || v_node_id || ',"' ||

145: else
146: v_children_loaded := 'true';
147: end if;
148:
149: htp.p('TOP_CATEGORIES[' || counter || ']= new node(' || v_node_id || ',"' ||
150: v_name || '",' || v_children_loaded || ',"' ||
151: v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?p_where=' || p_where -- Node Link
152: || '","' || p_where || '");');
153: counter := counter + 1;

Line 169: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');

165: P_RETURN_PARENTS => 'T',
166: P_RETURN_CHILDREN => 'F');
167:
168: if ak_query_pkg.g_results_table.count > 0 then
169: htp.p('TOP_CATEGORIES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
170: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
171:
172:
173: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Category id

Line 180: htp.p('TOP_CATEGORIES[' || counter || ']= new node(' || v_node_id || ',"' ||

176: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');
177:
178:
179: v_children_loaded := 'true';
180: htp.p('TOP_CATEGORIES[' || counter || ']= new node(' || v_node_id || ',"' ||
181: v_name || '",' || v_children_loaded || ',"' ||
182: v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?p_where=' || p_where -- Node Link
183: || '","' || p_where || '");');
184: counter := counter + 1;

Line 188: htp.p('TOP_CATEGORIES = new MakeArray(0);');

184: counter := counter + 1;
185:
186: end loop;
187: else -- No Categories
188: htp.p('TOP_CATEGORIES = new MakeArray(0);');
189: end if;
190:
191: end if; -- No hierchy setup
192:

Line 218: htp.htmlOpen;

214:
215: --get dcd name
216: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
217:
218: htp.htmlOpen;
219: htp.headOpen;
220: htp.headClose;
221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');

Line 219: htp.headOpen;

215: --get dcd name
216: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
217:
218: htp.htmlOpen;
219: htp.headOpen;
220: htp.headClose;
221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');
223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );

Line 220: htp.headClose;

216: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
217:
218: htp.htmlOpen;
219: htp.headOpen;
220: htp.headClose;
221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');
223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );
224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL

Line 221: htp.framesetOpen('','250,*','BORDER=5');

217:
218: htp.htmlOpen;
219: htp.headOpen;
220: htp.headClose;
221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');
223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );
224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL
225: htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?p_where=' || p_where, -- URL

Line 222: htp.framesetOpen('*,0','','BORDER=0');

218: htp.htmlOpen;
219: htp.headOpen;
220: htp.headClose;
221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');
223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );
224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL
225: htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?p_where=' || p_where, -- URL
226: cname => 'dummy', --Window Name

Line 223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );

219: htp.headOpen;
220: htp.headClose;
221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');
223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );
224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL
225: htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?p_where=' || p_where, -- URL
226: cname => 'dummy', --Window Name
227: cmarginwidth => '0', -- Value in pixels

Line 224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL

220: htp.headClose;
221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');
223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );
224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL
225: htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?p_where=' || p_where, -- URL
226: cname => 'dummy', --Window Name
227: cmarginwidth => '0', -- Value in pixels
228: cmarginheight => '0', -- Value in pixels

Line 225: htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?p_where=' || p_where, -- URL

221: htp.framesetOpen('','250,*','BORDER=5');
222: htp.framesetOpen('*,0','','BORDER=0');
223: htp.frame('/OA_HTML/' || v_lang || '/ICXCATH.htm', 'left_frame', '0','0', cscrolling=>'auto', cnoresize => '' );
224: --htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?n_org=' || n_org, --URL
225: htp.frame(csrc => v_dcdName || '/ICX_REQ_CATEGORIES.GetCategoryChildren?p_where=' || p_where, -- URL
226: cname => 'dummy', --Window Name
227: cmarginwidth => '0', -- Value in pixels
228: cmarginheight => '0', -- Value in pixels
229: cscrolling => 'NO',

Line 234: htp.framesetClose;

230: -- cnoresize => '',
231: cattributes => 'FRAMEBORDER=NO');
232: -- cscrolling => 'NO',-- yes | no | auto
233: -- cnoresize => 'NORESIZE' );
234: htp.framesetClose;
235:
236: v_frame_location := v_dcdName || '/ICX_REQ_CATEGORIES.catalog_items?';
237:
238: if c_end_row is not null then

Line 243: htp.frame( v_frame_location, 'right_frame', '0','0', cscrolling=>'auto');

239: v_frame_location := v_frame_location || 'p_start_row=' || start_row ||'&p_end_row=' || c_end_row || '&p_where=' || p_where;
240: else
241: v_frame_location := v_frame_location || 'p_where=' || p_where;
242: end if;
243: htp.frame( v_frame_location, 'right_frame', '0','0', cscrolling=>'auto');
244:
245: htp.framesetClose;
246: htp.htmlClose;
247:

Line 245: htp.framesetClose;

241: v_frame_location := v_frame_location || 'p_where=' || p_where;
242: end if;
243: htp.frame( v_frame_location, 'right_frame', '0','0', cscrolling=>'auto');
244:
245: htp.framesetClose;
246: htp.htmlClose;
247:
248: -- dbms_session.set_sql_trace(FALSE);
249: end categories;

Line 246: htp.htmlClose;

242: end if;
243: htp.frame( v_frame_location, 'right_frame', '0','0', cscrolling=>'auto');
244:
245: htp.framesetClose;
246: htp.htmlClose;
247:
248: -- dbms_session.set_sql_trace(FALSE);
249: end categories;
250:

Line 486: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.winOpen(''nav'', ''catalog'')"');

482: l_messg := l_messg || '';
483: l_message := l_message || l_messg;
484: end if;
485:
486: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.winOpen(''nav'', ''catalog'')"');
487: htp.p('

'|| l_message ||'

');
488: htp.bodyClose;
489: end;
490:

Line 487: htp.p('

'|| l_message ||'

');

483: l_message := l_message || l_messg;
484: end if;
485:
486: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.winOpen(''nav'', ''catalog'')"');
487: htp.p('

'|| l_message ||'

');
488: htp.bodyClose;
489: end;
490:
491:

Line 488: htp.bodyClose;

484: end if;
485:
486: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.winOpen(''nav'', ''catalog'')"');
487: htp.p('

'|| l_message ||'

');
488: htp.bodyClose;
489: end;
490:
491:
492:

Line 740: htp.p('function openButWin(start_row, end_row, total_row, where) {

736:
737: -- We need to split into 2 frames
738:
739: js.scriptOpen;
740: htp.p('function openButWin(start_row, end_row, total_row, where) {
741:
742: var result = "' || v_dcdName ||
743: '/ICX_REQ_CATEGORIES.catalog_items_buttons?p_start_row=" +
744: start_row + "&p_end_row=" + end_row + "&p_total_rows=" +

Line 752: htp.p('');

748: ');
749:
750: js.scriptClose;
751:
752: htp.p('');
753: htp.p('');

Line 753: htp.p('');
753: htp.p('');
757:

Line 758: htp.p('');
757:
758: htp.p('');
760: htp.p('');
761:
762: end;

Line 760: htp.p('');

756: p_where || '" NAME="data" FRAMEBORDER=NO MARGINWIDTH=0 MARGINHEIGHT=0 NORESIZE>');
757:
758: htp.p('');
760: htp.p('');
761:
762: end;
763:
764: ------------------------------------------------------------

Line 779: htp.p('');

775:
776: SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
777:
778: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
779: htp.p('');
780:
781: htp.p('');
782: htp.p('
');
783: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,

Line 781: htp.p('');
777:
778: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
779: htp.p('');
780:
781: htp.p('

');
782: htp.p('
');
783: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,
784: p_packproc => 'ICX_REQ_CATEGORIES.catalog_items',
785: p_start_row => p_start_row,

Line 782: htp.p('
');

778: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
779: htp.p('');
780:
781: htp.p('');
782: htp.p('');

787: p_encrypted_where => p_where,
788: p_query_set => c_query_size,
789: p_target => 'parent',
790: p_row_count => p_total_rows);
791: htp.p('');
792: htp.p('
');
792: htp.p('

');
783: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,
784: p_packproc => 'ICX_REQ_CATEGORIES.catalog_items',
785: p_start_row => p_start_row,
786: p_stop_row => p_end_row,

Line 791: htp.p('
');
793: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
794: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
795: P_ImageFileName => 'FNDBNEW.gif',

Line 792: htp.p('
');

788: p_query_set => c_query_size,
789: p_target => 'parent',
790: p_row_count => p_total_rows);
791: htp.p('
');
793: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
794: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
795: P_ImageFileName => 'FNDBNEW.gif',
796: P_OnMouseOverText => FND_MESSAGE.GET,

Line 802: htp.p('
');

798: bmit()',
799: P_LanguageCode => v_lang,
800: P_JavaScriptFlag => FALSE);
801:
802: htp.p('
');
803: htp.p('');
804: end;
805:
806:

Line 803: htp.p('');

799: P_LanguageCode => v_lang,
800: P_JavaScriptFlag => FALSE);
801:
802: htp.p('
');
803: htp.p('');
804: end;
805:
806:
807:

Line 889: htp.htmlOpen;

885:
886:
887: --If no catalog is selected then display a blank right frmae
888: if (v_cat_id = '-1') then
889: htp.htmlOpen;
890: htp.headOpen;
891: icx_util.copyright;
892: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
893: htp.bodyClose;

Line 890: htp.headOpen;

886:
887: --If no catalog is selected then display a blank right frmae
888: if (v_cat_id = '-1') then
889: htp.htmlOpen;
890: htp.headOpen;
891: icx_util.copyright;
892: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
893: htp.bodyClose;
894: htp.headClose;

Line 892: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');

888: if (v_cat_id = '-1') then
889: htp.htmlOpen;
890: htp.headOpen;
891: icx_util.copyright;
892: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
893: htp.bodyClose;
894: htp.headClose;
895: htp.htmlClose;
896: return;

Line 893: htp.bodyClose;

889: htp.htmlOpen;
890: htp.headOpen;
891: icx_util.copyright;
892: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
893: htp.bodyClose;
894: htp.headClose;
895: htp.htmlClose;
896: return;
897: end if;

Line 894: htp.headClose;

890: htp.headOpen;
891: icx_util.copyright;
892: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
893: htp.bodyClose;
894: htp.headClose;
895: htp.htmlClose;
896: return;
897: end if;
898:

Line 895: htp.htmlClose;

891: icx_util.copyright;
892: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
893: htp.bodyClose;
894: htp.headClose;
895: htp.htmlClose;
896: return;
897: end if;
898:
899:

Line 939: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');

935: end_row := total_rows;
936: end if;
937:
938: if ak_query_pkg.g_results_table.COUNT = 0 then
939: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
940: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
941: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
942: htp.p('
'||fnd_message.get||'
');
943: htp.bodyClose;

Line 942: htp.p('
'||fnd_message.get||'
');

938: if ak_query_pkg.g_results_table.COUNT = 0 then
939: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
940: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
941: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
942: htp.p('
'||fnd_message.get||'
');
943: htp.bodyClose;
944: return;
945: end if;
946:

Line 943: htp.bodyClose;

939: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
940: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
941: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
942: htp.p('
'||fnd_message.get||'
');
943: htp.bodyClose;
944: return;
945: end if;
946:
947:

Line 951: htp.htmlOpen;

947:
948: --Navigation buttons
949:
950: --print javascript functions
951: htp.htmlOpen;
952: htp.headOpen;
953: icx_util.copyright;
954: js.scriptOpen;
955:

Line 952: htp.headOpen;

948: --Navigation buttons
949:
950: --print javascript functions
951: htp.htmlOpen;
952: htp.headOpen;
953: icx_util.copyright;
954: js.scriptOpen;
955:
956: htp.p('function submit() {

Line 956: htp.p('function submit() {

952: htp.headOpen;
953: icx_util.copyright;
954: js.scriptOpen;
955:
956: htp.p('function submit() {
957: document.catalog_items.cartId.value = parent.parent.parent.cartId;
958: document.catalog_items.p_emergency.value = parent.parent.parent.emergency;
959: document.catalog_items.submit();
960: }');

Line 962: htp.p ('function get_parent_values(cartId,emergency) {

958: document.catalog_items.p_emergency.value = parent.parent.parent.emergency;
959: document.catalog_items.submit();
960: }');
961:
962: htp.p ('function get_parent_values(cartId,emergency) {
963: cartId.value=parent.parent.parent.cartId;
964: emergency.value=parent.parent.parent.emergency;
965: }');
966:

Line 972: htp.title(c_title);

968:
969: counter := 0;
970:
971: js.scriptClose;
972: htp.title(c_title);
973: htp.headClose;
974:
975: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog''); parent.parent.parent.lastCatalog.start_row='|| p_start_row ||
976: ';parent.parent.parent.lastCatalog.end_row='|| end_row ||

Line 973: htp.headClose;

969: counter := 0;
970:
971: js.scriptClose;
972: htp.title(c_title);
973: htp.headClose;
974:
975: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog''); parent.parent.parent.lastCatalog.start_row='|| p_start_row ||
976: ';parent.parent.parent.lastCatalog.end_row='|| end_row ||
977: ';parent.openButWin('|| p_start_row || ',' ||

Line 975: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog''); parent.parent.parent.lastCatalog.start_row='|| p_start_row ||

971: js.scriptClose;
972: htp.title(c_title);
973: htp.headClose;
974:
975: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog''); parent.parent.parent.lastCatalog.start_row='|| p_start_row ||
976: ';parent.parent.parent.lastCatalog.end_row='|| end_row ||
977: ';parent.openButWin('|| p_start_row || ',' ||
978: end_row || ',' || total_rows || ',' || p_where || ');"');
979: htp.br;

Line 979: htp.br;

975: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog''); parent.parent.parent.lastCatalog.start_row='|| p_start_row ||
976: ';parent.parent.parent.lastCatalog.end_row='|| end_row ||
977: ';parent.openButWin('|| p_start_row || ',' ||
978: end_row || ',' || total_rows || ',' || p_where || ');"');
979: htp.br;
980:
981: htp.p('
');
982:
983: htp.formHidden('cartId','');

Line 981: htp.p('');

977: ';parent.openButWin('|| p_start_row || ',' ||
978: end_row || ',' || total_rows || ',' || p_where || ');"');
979: htp.br;
980:
981: htp.p('');
982:
983: htp.formHidden('cartId','');
984: htp.formHidden('p_emergency','');
985: js.scriptOpen;

Line 983: htp.formHidden('cartId','');

979: htp.br;
980:
981: htp.p('');
982:
983: htp.formHidden('cartId','');
984: htp.formHidden('p_emergency','');
985: js.scriptOpen;
986: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
987: js.scriptClose;

Line 984: htp.formHidden('p_emergency','');

980:
981: htp.p('');
982:
983: htp.formHidden('cartId','');
984: htp.formHidden('p_emergency','');
985: js.scriptOpen;
986: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
987: js.scriptClose;
988:

Line 986: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');

982:
983: htp.formHidden('cartId','');
984: htp.formHidden('p_emergency','');
985: js.scriptOpen;
986: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
987: js.scriptClose;
988:
989: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
990: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');

Line 989: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');

985: js.scriptOpen;
986: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
987: js.scriptClose;
988:
989: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
990: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
991: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
992: htp.formHidden('p_cat_name',v_cat_name,'cols="60" rows = "10"');
993: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');

Line 990: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');

986: htp.p('get_parent_values(document.catalog_items.cartId,document.catalog_items.p_emergency)');
987: js.scriptClose;
988:
989: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
990: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
991: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
992: htp.formHidden('p_cat_name',v_cat_name,'cols="60" rows = "10"');
993: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
994: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');

Line 991: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');

987: js.scriptClose;
988:
989: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
990: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
991: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
992: htp.formHidden('p_cat_name',v_cat_name,'cols="60" rows = "10"');
993: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
994: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
995: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');

Line 992: htp.formHidden('p_cat_name',v_cat_name,'cols="60" rows = "10"');

988:
989: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
990: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
991: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
992: htp.formHidden('p_cat_name',v_cat_name,'cols="60" rows = "10"');
993: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
994: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
995: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
996:

Line 993: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');

989: htp.formHidden('p_start_row',p_start_row,'cols="60" rows = "10"');
990: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
991: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
992: htp.formHidden('p_cat_name',v_cat_name,'cols="60" rows = "10"');
993: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
994: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
995: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
996:
997: l_pos := l_pos + 9;

Line 994: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');

990: htp.formHidden('p_end_row',p_end_row,'cols="60" rows ="10"');
991: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
992: htp.formHidden('p_cat_name',v_cat_name,'cols="60" rows = "10"');
993: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
994: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
995: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
996:
997: l_pos := l_pos + 9;
998:

Line 995: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');

991: htp.formHidden('p_where',p_where,'cols="60" rows = "10"');
992: htp.formHidden('p_cat_name',v_cat_name,'cols="60" rows = "10"');
993: htp.formHidden('end_row',end_row,'cols="60" rows ="10"');
994: htp.formHidden('p_query_set',c_query_size,'cols="60" rows = "10"');
995: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
996:
997: l_pos := l_pos + 9;
998:
999: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_DATA_MULTIROW') );

Line 999: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_DATA_MULTIROW') );

995: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
996:
997: l_pos := l_pos + 9;
998:
999: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_DATA_MULTIROW') );
1000: htp.p('');
1001: --print the table column headings
1002: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1003:

Line 1000: htp.p('');

996:
997: l_pos := l_pos + 9;
998:
999: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_DATA_MULTIROW') );
1000: htp.p('');
1001: --print the table column headings
1002: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1003:
1004: if (ak_query_pkg.g_items_table(i).value_id is not null

Line 1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');

1008: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1009:
1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1011: --print quantity heading WITH COLSPAN=2
1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1013: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');
1015: else
1016: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');

Line 1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');

1010: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' then
1011: --print quantity heading WITH COLSPAN=2
1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1013: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');
1015: else
1016: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');
1017: end if;
1018: end if;

Line 1016: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');

1012: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
1013: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' then
1014: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','width=80');
1015: else
1016: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER');
1017: end if;
1018: end if;
1019:
1020: -- find line id, urls value id

Line 1040: htp.tableRowClose;

1036: end if;
1037: end if;
1038:
1039: end loop;
1040: htp.tableRowClose;
1041:
1042: --get one row of the result and find the catalog name
1043: -- icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;
1044:

Line 1047: htp.br; htp.br;

1043: -- icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;
1044:
1045: v_qty_flag := true;
1046:
1047: htp.br; htp.br;
1048:
1049: counter := 0;
1050: -- for j in p_start_row-1 .. end_row-1 loop
1051: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop

Line 1168: htp.p(temp_table(0));

1164: display_text := display_text || '';
1165: display_text := display_text || htf.tableRowClose;
1166: temp_table(0) := temp_table(0) || display_text;
1167: end if;
1168: htp.p(temp_table(0));
1169: counter := counter + 1;
1170: end loop; -- for j in 1 .. ak_query_pkg.g_results_table.COUNT loop
1171: htp.tableClose;
1172:

Line 1171: htp.tableClose;

1167: end if;
1168: htp.p(temp_table(0));
1169: counter := counter + 1;
1170: end loop; -- for j in 1 .. ak_query_pkg.g_results_table.COUNT loop
1171: htp.tableClose;
1172:
1173: htp.p('
');
1174:
1175: htp.bodyClose;

Line 1173: htp.p('');

1169: counter := counter + 1;
1170: end loop; -- for j in 1 .. ak_query_pkg.g_results_table.COUNT loop
1171: htp.tableClose;
1172:
1173: htp.p('');
1174:
1175: htp.bodyClose;
1176: htp.htmlClose;
1177:

Line 1175: htp.bodyClose;

1171: htp.tableClose;
1172:
1173: htp.p('');
1174:
1175: htp.bodyClose;
1176: htp.htmlClose;
1177:
1178: end if;
1179: -- dbms_session.set_sql_trace(FALSE);

Line 1176: htp.htmlClose;

1172:
1173: htp.p('');
1174:
1175: htp.bodyClose;
1176: htp.htmlClose;
1177:
1178: end if;
1179: -- dbms_session.set_sql_trace(FALSE);
1180: