APPS.FND_FLEX_VAL_API dependencies on DBMS_SQL

Line 5123: l_cur_hdl := dbms_sql.open_cursor;

5119: l_stmt := l_stmt||', '||l_tmpaddlclmn;
5120:
5121: END IF;
5122:
5123: l_cur_hdl := dbms_sql.open_cursor;
5124:
5125: IF (l_stmt is not NULL) THEN
5126:
5127: -- Remove bind variables, if any, and replace with null

Line 5134: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);

5130: -- Test Value Column, ID Column and Additional Columns
5131: l_stmt1 := 'select '||l_stmt||
5132: ' from '||p_application_table_name||
5133: ' where rownum=1';
5134: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);
5135:
5136: END IF;
5137:
5138: -- Test the ID Column

Line 5147: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);

5143: l_stmt1 := 'select '||l_stmt||
5144: ' from '||p_application_table_name||
5145: ' where rownum=1 and '||
5146: l_id_column_name||' is NULL';
5147: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);
5148: END IF;
5149:
5150: -- Test the Value Column
5151: IF (p_value_column_name is not NULL) THEN

Line 5159: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);

5155: l_stmt1 := 'select '||l_stmt||
5156: ' from '||p_application_table_name||
5157: ' where rownum=1 and '||
5158: l_value_column_name||' is NULL';
5159: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);
5160:
5161: END IF;
5162:
5163: -- Test the Additional Where clause

Line 5187: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);

5183: else
5184: l_stmt1 := 'select '||l_stmt||' from '||p_application_table_name
5185: || ' where ' ||l_additional_where_clause;
5186: end if;
5187: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);
5188:
5189: l_ret := instr(l_ltrim_where_clause, 'group by', 1, 1);
5190: END IF;
5191:

Line 5192: dbms_sql.close_cursor(l_cur_hdl);

5188:
5189: l_ret := instr(l_ltrim_where_clause, 'group by', 1, 1);
5190: END IF;
5191:
5192: dbms_sql.close_cursor(l_cur_hdl);
5193:
5194: IF(l_ret > 0) THEN
5195: x_result := 'Failure';
5196: l_message := substr(l_stmt1,1,32000);

Line 5205: if dbms_sql.is_open(l_cur_hdl) then

5201: END IF;
5202:
5203: EXCEPTION
5204: WHEN OTHERS THEN
5205: if dbms_sql.is_open(l_cur_hdl) then
5206: dbms_sql.close_cursor(l_cur_hdl);
5207: end if;
5208: x_result := 'Failure';
5209: l_message := substr(l_stmt1,1,32000);

Line 5206: dbms_sql.close_cursor(l_cur_hdl);

5202:
5203: EXCEPTION
5204: WHEN OTHERS THEN
5205: if dbms_sql.is_open(l_cur_hdl) then
5206: dbms_sql.close_cursor(l_cur_hdl);
5207: end if;
5208: x_result := 'Failure';
5209: l_message := substr(l_stmt1,1,32000);
5210: x_message := substr(SQLERRM || NEWLINE || l_message,1,32000);