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_TEMPLATES dependencies on AK_QUERY_PKG

Line 90: where_clause_binds ak_query_pkg.bind_tab;

86: -- (MC) remove local variables v_regions_table, v_items_table, and v_results_table
87:
88: y_table icx_util.char240_table;
89: /* Change wrto Bug Fix to implement the Bind Vars **/
90: where_clause_binds ak_query_pkg.bind_tab;
91: where_clause_binds_empty ak_query_pkg.bind_tab;
92: where_clause varchar2(2000);
93:
94: v_index number;

Line 91: where_clause_binds_empty ak_query_pkg.bind_tab;

87:
88: y_table icx_util.char240_table;
89: /* Change wrto Bug Fix to implement the Bind Vars **/
90: where_clause_binds ak_query_pkg.bind_tab;
91: where_clause_binds_empty ak_query_pkg.bind_tab;
92: where_clause varchar2(2000);
93:
94: v_index number;
95: v_node_id varchar2(240);

Line 148: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

144: end if;
145:
146: htp.comment(where_clause);
147:
148: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
149: P_PARENT_REGION_CODE => 'ICX_RELATED_TEMPLATES_DISPLAY',
150: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
151: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
152: P_WHERE_CLAUSE => where_clause,

Line 165: if ak_query_pkg.g_results_table.count > 0 then

161: v_index := 1;
162:
163:
164:
165: if ak_query_pkg.g_results_table.count > 0 then
166: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
167: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
168:
169: /* desmond */

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

162:
163:
164:
165: if ak_query_pkg.g_results_table.count > 0 then
166: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
167: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
168:
169: /* desmond */
170: -- v_node_id := ak_query_pkg.g_results_table(i).value2; -- Template id

Line 167: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop

163:
164:
165: if ak_query_pkg.g_results_table.count > 0 then
166: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
167: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
168:
169: /* desmond */
170: -- v_node_id := ak_query_pkg.g_results_table(i).value2; -- Template id
171: -- v_name := ak_query_pkg.g_results_table(i).value4; -- Template name

Line 170: -- v_node_id := ak_query_pkg.g_results_table(i).value2; -- Template id

166: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
167: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
168:
169: /* desmond */
170: -- v_node_id := ak_query_pkg.g_results_table(i).value2; -- Template id
171: -- v_name := ak_query_pkg.g_results_table(i).value4; -- Template name
172:
173: v_node_id := ak_query_pkg.g_results_table(i).value1;
174: v_name := ak_query_pkg.g_results_table(i).value1;

Line 171: -- v_name := ak_query_pkg.g_results_table(i).value4; -- Template name

167: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
168:
169: /* desmond */
170: -- v_node_id := ak_query_pkg.g_results_table(i).value2; -- Template id
171: -- v_name := ak_query_pkg.g_results_table(i).value4; -- Template name
172:
173: v_node_id := ak_query_pkg.g_results_table(i).value1;
174: v_name := ak_query_pkg.g_results_table(i).value1;
175:

Line 173: v_node_id := ak_query_pkg.g_results_table(i).value1;

169: /* desmond */
170: -- v_node_id := ak_query_pkg.g_results_table(i).value2; -- Template id
171: -- v_name := ak_query_pkg.g_results_table(i).value4; -- Template name
172:
173: v_node_id := ak_query_pkg.g_results_table(i).value1;
174: v_name := ak_query_pkg.g_results_table(i).value1;
175:
176: if v_default_template is not NULL then
177: if v_node_id = v_default_template then

Line 174: v_name := ak_query_pkg.g_results_table(i).value1;

170: -- v_node_id := ak_query_pkg.g_results_table(i).value2; -- Template id
171: -- v_name := ak_query_pkg.g_results_table(i).value4; -- Template name
172:
173: v_node_id := ak_query_pkg.g_results_table(i).value1;
174: v_name := ak_query_pkg.g_results_table(i).value1;
175:
176: if v_default_template is not NULL then
177: if v_node_id = v_default_template then
178: v_def_is_top := 'Y';

Line 228: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

224: end if;
225:
226: htp.comment(where_clause);
227:
228: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
229: P_PARENT_REGION_CODE => 'ICX_REQ_TEMPLATES',
230: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
231: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
232: P_WHERE_CLAUSE => where_clause,

Line 237: if ak_query_pkg.g_results_table.count > 0 then

233: P_RETURN_PARENTS => 'T',
234: P_RETURN_CHILDREN => 'F',
235: P_WHERE_BINDS => where_clause_binds);
236:
237: if ak_query_pkg.g_results_table.count > 0 then
238: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
239: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
240:
241:

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

234: P_RETURN_CHILDREN => 'F',
235: P_WHERE_BINDS => where_clause_binds);
236:
237: if ak_query_pkg.g_results_table.count > 0 then
238: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
239: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
240:
241:
242: v_node_id := ak_query_pkg.g_results_table(i).value1; -- template id

Line 239: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop

235: P_WHERE_BINDS => where_clause_binds);
236:
237: if ak_query_pkg.g_results_table.count > 0 then
238: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
239: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
240:
241:
242: v_node_id := ak_query_pkg.g_results_table(i).value1; -- template id
243: v_name := ak_query_pkg.g_results_table(i).value1; -- template id

Line 242: v_node_id := ak_query_pkg.g_results_table(i).value1; -- template id

238: htp.p('TOP_TEMPLATES = new MakeArray(' || ak_query_pkg.g_results_table.count || ');');
239: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
240:
241:
242: v_node_id := ak_query_pkg.g_results_table(i).value1; -- template id
243: v_name := ak_query_pkg.g_results_table(i).value1; -- template id
244:
245: if v_default_template is not NULL then
246: if v_node_id = v_default_template then

Line 243: v_name := ak_query_pkg.g_results_table(i).value1; -- template id

239: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
240:
241:
242: v_node_id := ak_query_pkg.g_results_table(i).value1; -- template id
243: v_name := ak_query_pkg.g_results_table(i).value1; -- template id
244:
245: if v_default_template is not NULL then
246: if v_node_id = v_default_template then
247: v_def_is_top := 'Y';

Line 368: where_clause_binds ak_query_pkg.bind_tab;

364:
365: -- (MC) remove local variables v_regions_table, v_items_table, and v_results_table
366:
367: y_table icx_util.char240_table;
368: where_clause_binds ak_query_pkg.bind_tab;
369: where_clause_binds_empty ak_query_pkg.bind_tab;
370: where_clause varchar2(2000);
371:
372: v_index number;

Line 369: where_clause_binds_empty ak_query_pkg.bind_tab;

365: -- (MC) remove local variables v_regions_table, v_items_table, and v_results_table
366:
367: y_table icx_util.char240_table;
368: where_clause_binds ak_query_pkg.bind_tab;
369: where_clause_binds_empty ak_query_pkg.bind_tab;
370: where_clause varchar2(2000);
371:
372: v_index number;
373:

Line 530: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

526: where_clause_binds(v_index).name := 'rel_type_bin';
527: where_clause_binds(v_index).value := 'CHILD';
528: v_index := v_index + 1;
529: -- Query childrens.
530: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
531: P_PARENT_REGION_CODE => 'ICX_RELATED_TEMPLATES_DISPLAY',
532: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
533: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
534: P_WHERE_CLAUSE => where_clause,

Line 539: if ak_query_pkg.g_results_table.count > 0 then

535: P_RETURN_PARENTS => 'T',
536: P_RETURN_CHILDREN => 'F',
537: p_WHERE_BINDS => where_clause_binds);
538:
539: if ak_query_pkg.g_results_table.count > 0 then
540: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
541:
542: -- v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related template id
543: -- v_namet := ak_query_pkg.g_results_table(i).value4; -- Related template name

Line 540: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop

536: P_RETURN_CHILDREN => 'F',
537: p_WHERE_BINDS => where_clause_binds);
538:
539: if ak_query_pkg.g_results_table.count > 0 then
540: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
541:
542: -- v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related template id
543: -- v_namet := ak_query_pkg.g_results_table(i).value4; -- Related template name
544: v_node_id := ak_query_pkg.g_results_table(i).value2;

Line 542: -- v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related template id

538:
539: if ak_query_pkg.g_results_table.count > 0 then
540: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
541:
542: -- v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related template id
543: -- v_namet := ak_query_pkg.g_results_table(i).value4; -- Related template name
544: v_node_id := ak_query_pkg.g_results_table(i).value2;
545: v_name := ak_query_pkg.g_results_table(i).value2;
546:

Line 543: -- v_namet := ak_query_pkg.g_results_table(i).value4; -- Related template name

539: if ak_query_pkg.g_results_table.count > 0 then
540: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
541:
542: -- v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related template id
543: -- v_namet := ak_query_pkg.g_results_table(i).value4; -- Related template name
544: v_node_id := ak_query_pkg.g_results_table(i).value2;
545: v_name := ak_query_pkg.g_results_table(i).value2;
546:
547:

Line 544: v_node_id := ak_query_pkg.g_results_table(i).value2;

540: for i in ak_query_pkg.g_results_table.first .. ak_query_pkg.g_results_table.last loop
541:
542: -- v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related template id
543: -- v_namet := ak_query_pkg.g_results_table(i).value4; -- Related template name
544: v_node_id := ak_query_pkg.g_results_table(i).value2;
545: v_name := ak_query_pkg.g_results_table(i).value2;
546:
547:
548: v_p_where := icx_call.encrypt2(v_node_id || '*' || v_org || '**]');

Line 545: v_name := ak_query_pkg.g_results_table(i).value2;

541:
542: -- v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related template id
543: -- v_namet := ak_query_pkg.g_results_table(i).value4; -- Related template name
544: v_node_id := ak_query_pkg.g_results_table(i).value2;
545: v_name := ak_query_pkg.g_results_table(i).value2;
546:
547:
548: v_p_where := icx_call.encrypt2(v_node_id || '*' || v_org || '**]');
549:

Line 706: where_clause_binds ak_query_pkg.bind_tab;

702: sess_web_user number(15);
703: c_title varchar2(80) := '';
704: c_prompts icx_util.g_prompts_table;
705: v_lang varchar2(30);
706: where_clause_binds ak_query_pkg.bind_tab;
707: where_clause varchar2(2000);
708: v_index NUMBER;
709:
710:

Line 819: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

815: ELSE
816: end_row := p_end_row;
817: END IF;
818:
819: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
820: P_PARENT_REGION_CODE => 'ICX_PO_TEMPLATE_ITEMS_R',
821: P_WHERE_CLAUSE => where_clause,
822: p_WHERE_BINDS => where_clause_binds,
823: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

Line 830: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;

826: P_RETURN_CHILDREN => 'F',
827: P_RANGE_LOW => p_start_row,
828: P_RANGE_HIGH => end_row);
829: -- Get number of rows to display
830: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;
831:
832: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;
833:
834: IF end_row > total_rows THEN

Line 832: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;

828: P_RANGE_HIGH => end_row);
829: -- Get number of rows to display
830: g_reg_ind := ak_query_pkg.g_regions_table.FIRST;
831:
832: total_rows := ak_query_pkg.g_regions_table(g_reg_ind).total_result_count;
833:
834: IF end_row > total_rows THEN
835: end_row := total_rows;
836: END IF;

Line 839: IF ak_query_pkg.g_results_table.COUNT = 0 then

835: end_row := total_rows;
836: END IF;
837:
838:
839: IF ak_query_pkg.g_results_table.COUNT = 0 then
840: htp.bodyOpen('','BGCOLOR="#FFCCCC" onLoad="top.winOpen(''nav'', ''template'')"');
841: fnd_message.set_name('EC','ICX_NO_RECORDS_FOUND');
842: fnd_message.set_token('NAME_OF_REGION_TOKEN',c_title);
843: htp.p('

' || fnd_message.get || '

');

Line 908: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP

904: DATA_MULTIROW') );
905:
906: htp.p('');
907:
908: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
909: IF (ak_query_pkg.g_items_table(i).value_id IS NOT NULL
910: AND ak_query_pkg.g_items_table(i).item_style <> 'hidden'
911: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: AND ak_query_pkg.g_items_table(i).secured_column <> 'T') or

Line 909: IF (ak_query_pkg.g_items_table(i).value_id IS NOT NULL

905:
906: htp.p('');
907:
908: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
909: IF (ak_query_pkg.g_items_table(i).value_id IS NOT NULL
910: AND ak_query_pkg.g_items_table(i).item_style <> 'hidden'
911: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: AND ak_query_pkg.g_items_table(i).secured_column <> 'T') or
913: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN

Line 910: AND ak_query_pkg.g_items_table(i).item_style <> 'hidden'

906: htp.p('');
907:
908: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
909: IF (ak_query_pkg.g_items_table(i).value_id IS NOT NULL
910: AND ak_query_pkg.g_items_table(i).item_style <> 'hidden'
911: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: AND ak_query_pkg.g_items_table(i).secured_column <> 'T') or
913: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
914:

Line 911: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

907:
908: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
909: IF (ak_query_pkg.g_items_table(i).value_id IS NOT NULL
910: AND ak_query_pkg.g_items_table(i).item_style <> 'hidden'
911: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: AND ak_query_pkg.g_items_table(i).secured_column <> 'T') or
913: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
914:
915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN

Line 912: AND ak_query_pkg.g_items_table(i).secured_column <> 'T') or

908: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
909: IF (ak_query_pkg.g_items_table(i).value_id IS NOT NULL
910: AND ak_query_pkg.g_items_table(i).item_style <> 'hidden'
911: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: AND ak_query_pkg.g_items_table(i).secured_column <> 'T') or
913: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
914:
915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
916: --print quantity heading WITH COLSPAN=2

Line 913: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN

909: IF (ak_query_pkg.g_items_table(i).value_id IS NOT NULL
910: AND ak_query_pkg.g_items_table(i).item_style <> 'hidden'
911: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: AND ak_query_pkg.g_items_table(i).secured_column <> 'T') or
913: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
914:
915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
916: --print quantity heading WITH COLSPAN=2
917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');

Line 915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN

911: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
912: AND ak_query_pkg.g_items_table(i).secured_column <> 'T') or
913: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
914:
915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
916: --print quantity heading WITH COLSPAN=2
917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
918: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
919: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','','width=80');

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

913: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
914:
915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
916: --print quantity heading WITH COLSPAN=2
917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
918: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
919: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','','width=80');
920: ELSE
921: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long, 'CENTER');

Line 918: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN

914:
915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
916: --print quantity heading WITH COLSPAN=2
917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
918: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
919: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','','width=80');
920: ELSE
921: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long, 'CENTER');
922: END IF;

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

915: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
916: --print quantity heading WITH COLSPAN=2
917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
918: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
919: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','','width=80');
920: ELSE
921: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long, 'CENTER');
922: END IF;
923: END IF;

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

917: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'CENTER','','','','2');
918: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
919: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long || ' (' || c_currency || ')', 'CENTER','','','','','width=80');
920: ELSE
921: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long, 'CENTER');
922: END IF;
923: END IF;
924:
925: -- Find line id, urls value id

Line 926: if ak_query_pkg.g_items_table(i).value_id is not null then

922: END IF;
923: END IF;
924:
925: -- Find line id, urls value id
926: if ak_query_pkg.g_items_table(i).value_id is not null then
927:
928: --need line_id to call javascript function down() and up()
929: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
930: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;

Line 929: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then

925: -- Find line id, urls value id
926: if ak_query_pkg.g_items_table(i).value_id is not null then
927:
928: --need line_id to call javascript function down() and up()
929: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
930: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
931: end if;
932: -- find item_url and supplier_item_url
933: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then

Line 930: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;

926: if ak_query_pkg.g_items_table(i).value_id is not null then
927:
928: --need line_id to call javascript function down() and up()
929: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
930: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
931: end if;
932: -- find item_url and supplier_item_url
933: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
934: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

Line 933: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then

929: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_LINE_ID') then
930: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
931: end if;
932: -- find item_url and supplier_item_url
933: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
934: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
935: end if;
936: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
937: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;

Line 934: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

930: v_line_id_ind := ak_query_pkg.g_items_table(i).value_id;
931: end if;
932: -- find item_url and supplier_item_url
933: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
934: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
935: end if;
936: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
937: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
938: end if;

Line 936: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then

932: -- find item_url and supplier_item_url
933: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
934: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
935: end if;
936: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
937: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
938: end if;
939: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
940: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

Line 937: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;

933: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_URL') then
934: v_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
935: end if;
936: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
937: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
938: end if;
939: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
940: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
941: end if;

Line 939: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then

935: end if;
936: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
937: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
938: end if;
939: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
940: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
941: end if;
942: end if;
943:

Line 940: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;

936: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_URL') then
937: v_supplier_url_ind := ak_query_pkg.g_items_table(i).value_id;
938: end if;
939: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUPPLIER_ITEM_URL') then
940: v_supplier_item_url_ind := ak_query_pkg.g_items_table(i).value_id;
941: end if;
942: end if;
943:
944: END LOOP;

Line 953: FOR j IN ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST LOOP

949: counter := 0;
950: -- Print the table data
951:
952: -- FOR j IN p_start_row - 1 .. end_row - 1 LOOP
953: FOR j IN ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST LOOP
954:
955: temp_table := '';
956:
957: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;

Line 957: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;

953: FOR j IN ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST LOOP
954:
955: temp_table := '';
956:
957: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;
958:
959: FOR i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
960:
961: -- Print quantity input text box and up button

Line 959: FOR i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP

955: temp_table := '';
956:
957: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;
958:
959: FOR i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
960:
961: -- Print quantity input text box and up button
962: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
963: v_line_id := y_table(v_line_id_ind);

Line 962: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN

958:
959: FOR i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
960:
961: -- Print quantity input text box and up button
962: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_QTY' THEN
963: v_line_id := y_table(v_line_id_ind);
964: display_text := '

965: || ' SIZE=' || to_char(V_QUANTITY_LENGTH) || ' onChange=''if(!parent.parent.parent.checkNumber(this)){this.focus();this.value="";}''>';
966:

Line 983: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SEQUENCE' THEN

979: END IF;
980:
981: /* Sequence number is one of the required attribute to
982: to identify a row in the cart line */
983: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SEQUENCE' THEN
984: display_text := '';
985: l_pos := l_pos + 1;
986: temp_table := temp_table || display_text;
987: END IF;

Line 984: display_text := '';

980:
981: /* Sequence number is one of the required attribute to
982: to identify a row in the cart line */
983: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SEQUENCE' THEN
984: display_text := '';
985: l_pos := l_pos + 1;
986: temp_table := temp_table || display_text;
987: END IF;
988:

Line 989: IF ak_query_pkg.g_items_table(i).value_id IS NOT NULL -- not including ICX_QTY

985: l_pos := l_pos + 1;
986: temp_table := temp_table || display_text;
987: END IF;
988:
989: IF ak_query_pkg.g_items_table(i).value_id IS NOT NULL -- not including ICX_QTY
990: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
991: AND ak_query_pkg.g_items_table(i).secured_column <> 'T'
992: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
993:

Line 990: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

986: temp_table := temp_table || display_text;
987: END IF;
988:
989: IF ak_query_pkg.g_items_table(i).value_id IS NOT NULL -- not including ICX_QTY
990: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
991: AND ak_query_pkg.g_items_table(i).secured_column <> 'T'
992: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
993:
994: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/

Line 991: AND ak_query_pkg.g_items_table(i).secured_column <> 'T'

987: END IF;
988:
989: IF ak_query_pkg.g_items_table(i).value_id IS NOT NULL -- not including ICX_QTY
990: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
991: AND ak_query_pkg.g_items_table(i).secured_column <> 'T'
992: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
993:
994: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
995:

Line 992: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN

988:
989: IF ak_query_pkg.g_items_table(i).value_id IS NOT NULL -- not including ICX_QTY
990: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
991: AND ak_query_pkg.g_items_table(i).secured_column <> 'T'
992: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
993:
994: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
995:
996: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN

Line 996: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN

992: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
993:
994: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
995:
996: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
997: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
998: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
999: /* End Change Bug #640289 By Suri ***/
1000: ELSE

Line 997: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);

993:
994: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
995:
996: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
997: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
998: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
999: /* End Change Bug #640289 By Suri ***/
1000: ELSE
1001: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);

Line 998: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));

994: /* Ref Bug #640289 : Changed By Suri. The Standard Requisitions/Emergency Requisitions Unit Price field should allow more than two decimal places. ***/
995:
996: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_UNIT_PRICE' THEN
997: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
998: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
999: /* End Change Bug #640289 By Suri ***/
1000: ELSE
1001: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1002: END IF;

Line 1001: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);

997: -- display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)), c_money_fmt_mask);
998: display_text := to_char(to_number(y_table(ak_query_pkg.g_items_table(i).value_id)));
999: /* End Change Bug #640289 By Suri ***/
1000: ELSE
1001: display_text := y_table(ak_query_pkg.g_items_table(i).value_id);
1002: END IF;
1003:
1004: IF display_text is null THEN
1005: display_text := htf.br;

Line 1019: IF (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_DESCRIPTION') THEN

1015: END IF;
1016:
1017:
1018: -- Display item_description as a link and a tabledata
1019: IF (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_ITEM_DESCRIPTION') THEN
1020: v_item_url := y_table(v_item_url_ind);
1021: display_text := ICX_REQ_NAVIGATION.addURL(v_item_url, display_text);
1022: END IF;
1023:

Line 1025: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' THEN

1021: display_text := ICX_REQ_NAVIGATION.addURL(v_item_url, display_text);
1022: END IF;
1023:
1024: -- Display source_name as a link
1025: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' THEN
1026: v_supplier_url := y_table(v_supplier_url_ind);
1027: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_url, display_text);
1028: END IF;
1029:

Line 1031: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_ITEM_NUM' THEN

1027: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_url, display_text);
1028: END IF;
1029:
1030: -- Display supplier item number as a link
1031: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_ITEM_NUM' THEN
1032: v_supplier_item_url := y_table(v_supplier_item_url_ind);
1033: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_item_url, display_text);
1034: END IF;
1035:

Line 1037: IF ak_query_pkg.g_items_table(i).bold = 'Y' THEN

1033: display_text := ICX_REQ_NAVIGATION.addURL(v_supplier_item_url, display_text);
1034: END IF;
1035:
1036: -- Bold
1037: IF ak_query_pkg.g_items_table(i).bold = 'Y' THEN
1038: display_text := htf.bold(display_text);
1039: END IF;
1040:
1041: -- Italics

Line 1042: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN

1038: display_text := htf.bold(display_text);
1039: END IF;
1040:
1041: -- Italics
1042: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1043: display_text := htf.italic(display_text);
1044: END IF;
1045:
1046: temp_table := temp_table ||

Line 1048: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,

1044: END IF;
1045:
1046: temp_table := temp_table ||
1047: htf.tableData( cvalue => display_text,
1048: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
1049: crowspan => '2',
1050: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1051: );
1052:

Line 1050: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment

1046: temp_table := temp_table ||
1047: htf.tableData( cvalue => display_text,
1048: calign => ak_query_pkg.g_items_table(i).horizontal_alignment,
1049: crowspan => '2',
1050: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1051: );
1052:
1053: END IF; /* if value_id is not null */
1054: END LOOP; -- for i in 1 .. ak_query_pkg.g_items_table.first loop

Line 1054: END LOOP; -- for i in 1 .. ak_query_pkg.g_items_table.first loop

1050: cattributes => ' VALIGN=' || ak_query_pkg.g_items_table(i).vertical_alignment
1051: );
1052:
1053: END IF; /* if value_id is not null */
1054: END LOOP; -- for i in 1 .. ak_query_pkg.g_items_table.first loop
1055:
1056: temp_table := temp_table || htf.tableRowClose;
1057:
1058: --print the down button