APPS.FND_FLEX_VAL_API dependencies on DBMS_SQL

Line 4995: l_cur_hdl := dbms_sql.open_cursor;

4991: l_stmt := l_stmt||', '||l_tmpaddlclmn;
4992:
4993: END IF;
4994:
4995: l_cur_hdl := dbms_sql.open_cursor;
4996:
4997: IF (l_stmt is not NULL) THEN
4998:
4999: -- Remove bind variables, if any, and replace with null

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

5002: -- Test Value Column, ID Column and Additional Columns
5003: l_stmt1 := 'select '||l_stmt||
5004: ' from '||p_application_table_name||
5005: ' where rownum=1';
5006: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);
5007:
5008: END IF;
5009:
5010: -- Test the ID Column

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

5015: l_stmt1 := 'select '||l_stmt||
5016: ' from '||p_application_table_name||
5017: ' where rownum=1 and '||
5018: l_id_column_name||' is NULL';
5019: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);
5020: END IF;
5021:
5022: -- Test the Value Column
5023: IF (p_value_column_name is not NULL) THEN

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

5027: l_stmt1 := 'select '||l_stmt||
5028: ' from '||p_application_table_name||
5029: ' where rownum=1 and '||
5030: l_value_column_name||' is NULL';
5031: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);
5032:
5033: END IF;
5034:
5035: -- Test the Additional Where clause

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

5055: else
5056: l_stmt1 := 'select '||l_stmt||' from '||p_application_table_name
5057: || ' where ' ||l_additional_where_clause;
5058: end if;
5059: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);
5060:
5061: END IF;
5062:
5063: dbms_sql.close_cursor(l_cur_hdl);

Line 5063: dbms_sql.close_cursor(l_cur_hdl);

5059: dbms_sql.parse(l_cur_hdl, l_stmt1, dbms_sql.native);
5060:
5061: END IF;
5062:
5063: dbms_sql.close_cursor(l_cur_hdl);
5064:
5065: x_result := 'Success';
5066:
5067: EXCEPTION

Line 5069: if dbms_sql.is_open(l_cur_hdl) then

5065: x_result := 'Success';
5066:
5067: EXCEPTION
5068: WHEN OTHERS THEN
5069: if dbms_sql.is_open(l_cur_hdl) then
5070: dbms_sql.close_cursor(l_cur_hdl);
5071: end if;
5072: x_result := 'Failure';
5073: l_message := substr(l_stmt1,1,32000);

Line 5070: dbms_sql.close_cursor(l_cur_hdl);

5066:
5067: EXCEPTION
5068: WHEN OTHERS THEN
5069: if dbms_sql.is_open(l_cur_hdl) then
5070: dbms_sql.close_cursor(l_cur_hdl);
5071: end if;
5072: x_result := 'Failure';
5073: l_message := substr(l_stmt1,1,32000);
5074: x_message := substr(SQLERRM || NEWLINE || l_message,1,32000);