DBA Data[Home] [Help]

APPS.ICX_REQ_SEARCH dependencies on ICX_UTIL

Line 14: l_message := icx_util.replace_quotes(fnd_message.get);

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() {

Line 106: icx_util.DynamicButton(P_ButtonText => p_submit,

102:
103: begin
104:
105: htp.p('');
106: icx_util.DynamicButton(P_ButtonText => p_submit,
107: P_ImageFileName => 'FNDBSBMT',
108: P_OnMouseOverText => p_submit,
109: P_HyperTextCall => 'javascript:submitFunction()',
110: P_LanguageCode => p_language_code,

Line 116: icx_util.DynamicButton(P_ButtonText => p_clear,

112: htp.p('');
113: if (instr(l_browser,'MSIE')=0)
114: then
115: htp.p('');
116: icx_util.DynamicButton(P_ButtonText => p_clear,
117: P_ImageFileName => 'FNDBCLR',
118: P_OnMouseOverText => p_clear,
119: P_HyperTextCall => 'javascript:resetFunction()',
120: P_LanguageCode => p_language_code,

Line 129: icx_util.DynamicButton(P_ButtonText => p_more,

125: then
126: htp.p('');
127: if p_lines_next > p_lines_now
128: then
129: icx_util.DynamicButton(P_ButtonText => p_more,
130: P_ImageFileName => 'FNDBMORC',
131: P_OnMouseOverText => p_more,
132: P_HyperTextCall => p_url,
133: P_LanguageCode => p_language_code,

Line 136: icx_util.DynamicButton(P_ButtonText => p_one,

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,

Line 175: c_prompts icx_util.g_prompts_table;

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;

Line 176: l_lookup_codes icx_util.g_lookup_code_table;

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);

Line 177: l_lookup_meanings icx_util.g_lookup_meaning_table;

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;

Line 222: l_values icx_util.char240_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

Line 229: icx_util.getPrompts(178,'ICX_WEB_ON_QUERY',c_title,c_prompts);

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

Line 245: icx_util.getLookups('ICX_CONDITIONS',l_lookup_codes,l_lookup_meanings);

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

Line 339: icx_util.DynamicButton(P_ButtonText => c_prompts(5),

335:
336: if p_new_url is not null
337: then
338: htp.p('');
339: icx_util.DynamicButton(P_ButtonText => c_prompts(5),
340: P_ImageFileName => 'FNDBNEW',
341: P_OnMouseOverText => c_prompts(5),
342: P_HyperTextCall => p_new_url,
343: P_LanguageCode => l_language_code,

Line 389: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i),l_values);

385: else
386: l_categories := l_categories||'

Line 528: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,

524: -- htp.p('Debug 0');
525: htp.p('');
526: htp.p('');
527: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
528: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
529: P_ImageFileName => 'FNDBNEW.gif',
530: P_OnMouseOverText => FND_MESSAGE.GET,
531: P_HyperTextCall => 'javascript:parent.frames[0].submit()',
532: P_LanguageCode => v_lang,

Line 593: icx_util.copyright;

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;

Line 978: icx_util.add_error(l_err_mesg);

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;

Line 979: icx_util.error_page_print;

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:

Line 1011: c_prompts icx_util.g_prompts_table;

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;

Line 1038: y_table icx_util.char240_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);

Line 1097: icx_util.getPrompts(601,'ICX_PO_SUPPL_SEARCH_ITEMS_R',c_title,c_prompts);

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);

Line 1098: icx_util.error_page_setup;

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);

Line 1157: icx_util.copyright;

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);

Line 1354: htp.p('');

1350:
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) := '';

1398:
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);

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:
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')||'"');

1490: --close the table row
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: || '