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_ON_UTILITIES2 dependencies on DBMS_SQL

Line 1067: l_call := dbms_sql.open_cursor;

1063: p_result_values := p_result_values||l_value||'*';
1064: end if;
1065: end loop;
1066: p_result_values := p_result_values||']';
1067: l_call := dbms_sql.open_cursor;
1068: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1069: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1070: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1071: l_dummy := dbms_sql.execute(l_call);

Line 1068: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);

1064: end if;
1065: end loop;
1066: p_result_values := p_result_values||']';
1067: l_call := dbms_sql.open_cursor;
1068: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1069: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1070: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1071: l_dummy := dbms_sql.execute(l_call);
1072: dbms_sql.close_cursor(l_call);

Line 1069: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);

1065: end loop;
1066: p_result_values := p_result_values||']';
1067: l_call := dbms_sql.open_cursor;
1068: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1069: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1070: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1071: l_dummy := dbms_sql.execute(l_call);
1072: dbms_sql.close_cursor(l_call);
1073: htp.p('');

Line 1070: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);

1066: p_result_values := p_result_values||']';
1067: l_call := dbms_sql.open_cursor;
1068: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1069: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1070: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1071: l_dummy := dbms_sql.execute(l_call);
1072: dbms_sql.close_cursor(l_call);
1073: htp.p('');
1074: elsif l_item_styles(i) = 'URL'

Line 1071: l_dummy := dbms_sql.execute(l_call);

1067: l_call := dbms_sql.open_cursor;
1068: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1069: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1070: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1071: l_dummy := dbms_sql.execute(l_call);
1072: dbms_sql.close_cursor(l_call);
1073: htp.p('');
1074: elsif l_item_styles(i) = 'URL'
1075: then

Line 1072: dbms_sql.close_cursor(l_call);

1068: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1069: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1070: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1071: l_dummy := dbms_sql.execute(l_call);
1072: dbms_sql.close_cursor(l_call);
1073: htp.p('');
1074: elsif l_item_styles(i) = 'URL'
1075: then
1076: if l_values(l_value_id(l_url_display_sequence(i))) is null

Line 1312: l_call := dbms_sql.open_cursor;

1308: p_result_values := p_result_values||l_value||'*';
1309: end if;
1310: end loop;
1311: p_result_values := p_result_values||']';
1312: l_call := dbms_sql.open_cursor;
1313: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1314: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1315: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1316: l_dummy := dbms_sql.execute(l_call);

Line 1313: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);

1309: end if;
1310: end loop;
1311: p_result_values := p_result_values||']';
1312: l_call := dbms_sql.open_cursor;
1313: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1314: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1315: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1316: l_dummy := dbms_sql.execute(l_call);
1317: dbms_sql.close_cursor(l_call);

Line 1314: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);

1310: end loop;
1311: p_result_values := p_result_values||']';
1312: l_call := dbms_sql.open_cursor;
1313: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1314: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1315: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1316: l_dummy := dbms_sql.execute(l_call);
1317: dbms_sql.close_cursor(l_call);
1318: htp.p('');

Line 1315: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);

1311: p_result_values := p_result_values||']';
1312: l_call := dbms_sql.open_cursor;
1313: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1314: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1315: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1316: l_dummy := dbms_sql.execute(l_call);
1317: dbms_sql.close_cursor(l_call);
1318: htp.p('');
1319: elsif l_item_styles(i) = 'URL'

Line 1316: l_dummy := dbms_sql.execute(l_call);

1312: l_call := dbms_sql.open_cursor;
1313: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1314: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1315: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1316: l_dummy := dbms_sql.execute(l_call);
1317: dbms_sql.close_cursor(l_call);
1318: htp.p('');
1319: elsif l_item_styles(i) = 'URL'
1320: then

Line 1317: dbms_sql.close_cursor(l_call);

1313: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
1314: dbms_sql.bind_variable(l_call,'l_attribute_codes',l_attribute_codes);
1315: dbms_sql.bind_variable(l_call,'p_result_values',p_result_values);
1316: l_dummy := dbms_sql.execute(l_call);
1317: dbms_sql.close_cursor(l_call);
1318: htp.p('');
1319: elsif l_item_styles(i) = 'URL'
1320: then
1321: if l_values(l_value_id(l_url_display_sequence(i))) is null