10:
11: begin
12:
13: fnd_message.set_name('ICX','ICX_OPEN_QUERY');
14: l_message := icx_util.replace_quotes(fnd_message.get);
15:
16: if p_lines_now = 1
17: then
18: htp.p('function submitFunction() {
102:
103: begin
104:
105: htp.p('
112: htp.p('
125: then
126: htp.p('
132: P_HyperTextCall => p_url,
133: P_LanguageCode => p_language_code,
134: P_JavaScriptFlag => FALSE);
135: else
136: icx_util.DynamicButton(P_ButtonText => p_one,
137: P_ImageFileName => 'FNDBONEC',
138: P_OnMouseOverText => p_one,
139: P_HyperTextCall => p_url,
140: P_LanguageCode => p_language_code,
171: l_message varchar2(240);
172: l_page_title varchar2(30);
173:
174: c_title varchar2(50);
175: c_prompts icx_util.g_prompts_table;
176: l_lookup_codes icx_util.g_lookup_code_table;
177: l_lookup_meanings icx_util.g_lookup_meaning_table;
178:
179: c_count number;
172: l_page_title varchar2(30);
173:
174: c_title varchar2(50);
175: c_prompts icx_util.g_prompts_table;
176: l_lookup_codes icx_util.g_lookup_code_table;
177: l_lookup_meanings icx_util.g_lookup_meaning_table;
178:
179: c_count number;
180: l_data_type varchar2(1);
173:
174: c_title varchar2(50);
175: c_prompts icx_util.g_prompts_table;
176: l_lookup_codes icx_util.g_lookup_code_table;
177: l_lookup_meanings icx_util.g_lookup_meaning_table;
178:
179: c_count number;
180: l_data_type varchar2(1);
181: c_attributes icx_on_utilities.v2000_table;
218: v_category_set_id number;
219: v_validate_flag varchar2(1);
220: l_category_id number;
221: l_category_name number;
222: l_values icx_util.char240_table;
223: l_parameters icx_on_utilities.v240_table;
224: l_starts_with number;
225:
226: begin
225:
226: begin
227:
228: /* XXXXXXXXXXXXXXXXGet condition title, prompts and conditions */
229: icx_util.getPrompts(178,'ICX_WEB_ON_QUERY',c_title,c_prompts);
230:
231: if p_values is not null then
232: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_values), l_parameters);
233: for i in l_parameters.COUNT..20 loop
241:
242: c_url := p_lines_url||icx_call.encrypt2(p_region_appl_id||'*'||p_region_code||'*'||p_goto_url||'*'||p_goto_target||'*'||p_lines_next||'*'||
243: p_lines_url||'*'||p_lines_target||'*'||p_lines_now||'*'||p_hidden_name||'*'||p_hidden_value||'*'||p_help_url||'*'||p_new_url||'*'||p_LOV_mode||'*'||p_default_title||'**] NAME="'||p_lines_target||'"');
244:
245: icx_util.getLookups('ICX_CONDITIONS',l_lookup_codes,l_lookup_meanings);
246:
247: /* Create queryable attribute select list */
248:
249: for i in 1..p_lines_now loop
335:
336: if p_new_url is not null
337: then
338: htp.p('
385: else
386: l_categories := l_categories||'
524: -- htp.p('Debug 0');
525: htp.p('
589: l_paramX := l_search(10); -- p_hidden_value
590: end if;
591: htp.htmlOpen;
592: htp.headOpen;
593: icx_util.copyright;
594: js.scriptOpen;
595: find_form_head_region(v_lines_now);
596: js.scriptClose;
597: htp.headClose;
974: l_err_num := SQLCODE;
975: l_error_message := SQLERRM;
976:
977: select substr(l_error_message,12,512) into l_err_mesg from dual;
978: icx_util.add_error(l_err_mesg);
979: icx_util.error_page_print;
980:
981:
982: end;
975: l_error_message := SQLERRM;
976:
977: select substr(l_error_message,12,512) into l_err_mesg from dual;
978: icx_util.add_error(l_err_mesg);
979: icx_util.error_page_print;
980:
981:
982: end;
983:
1007: p_hidden in varchar2 default null) is
1008: -----------------------------------------------------------
1009: c_language varchar2(30);
1010: c_title varchar2(80) := '';
1011: c_prompts icx_util.g_prompts_table;
1012: where_clause varchar2(2000);
1013: total_rows number;
1014: end_row number;
1015: temp_table icx_admin_sig.pp_table;
1034: counter number := 0;
1035: v_quantity_length number :=10;
1036: v_temp varchar2(240);
1037: v_qty_flag boolean := false;
1038: y_table icx_util.char240_table;
1039: parameters_pass varchar2(20);
1040: a_1_code varchar2(80);
1041: a_2_code varchar2(80);
1042: a_3_code varchar2(80);
1093: icx_req_navigation.shopper_info(employee_id, shopper_name, v_location_id, v_location_code, v_org_id, v_org_code);
1094:
1095: ICX_REQ_NAVIGATION.get_currency(v_org_id, c_currency, c_money_precision, c_money_fmt_mask);
1096:
1097: icx_util.getPrompts(601,'ICX_PO_SUPPL_SEARCH_ITEMS_R',c_title,c_prompts);
1098: icx_util.error_page_setup;
1099: if p_where is not null then
1100: Y:=icx_call.decrypt2(p_where);
1101: icx_on_utilities.unpack_parameters(Y,params);
1094:
1095: ICX_REQ_NAVIGATION.get_currency(v_org_id, c_currency, c_money_precision, c_money_fmt_mask);
1096:
1097: icx_util.getPrompts(601,'ICX_PO_SUPPL_SEARCH_ITEMS_R',c_title,c_prompts);
1098: icx_util.error_page_setup;
1099: if p_where is not null then
1100: Y:=icx_call.decrypt2(p_where);
1101: icx_on_utilities.unpack_parameters(Y,params);
1102: a_1_code := params(1);
1153:
1154:
1155: htp.htmlOpen;
1156: htp.headOpen;
1157: icx_util.copyright;
1158: js.scriptOpen;
1159: find_form_head_region(v_lines_now);
1160:
1161: icx_on_utilities.unpack_whereSegment(where_clause,l_where_clause,where_clause_binds);
1350:
1398:
1399: -- for j in p_start_row-1 .. end_row-1 loop
1490: --close the table row
1351: l_pos := l_pos + 24;
1352:
1353: htp.tableOpen('BORDER');
1354: htp.p('');
1355:
1356: --Print the column headings
1357: for i in ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST loop
1358:
Line 1402: temp_table(0) := '
';
1399: -- for j in p_start_row-1 .. end_row-1 loop
1400: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop
1401:
1402: temp_table(0) := '';
1403: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
1404:
1405: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1406:
Line 1403: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
1400: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop
1401:
1402: temp_table(0) := '';
1403: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
1404:
1405: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1406:
1407: --print quantity input text box and up button if v_qty_flag is set
Line 1494: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1491: temp_table(0) := temp_table(0) || htf.tableRowClose;
1492: if v_qty_flag then
1493: --print the down button
1494: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1495:
1496: display_text := display_text
1497: || '