APPS.QA_VALIDATION_API dependencies on DUAL

Line 1997: -- dual which is inefficient

1993: sql_string VARCHAR2(1500);
1994: ok_flag varchar2(240);
1995:
1996: -- Bug 3111310. Used to have a SQL that select from
1997: -- dual which is inefficient
1998: -- saugupta Aug 2003
1999:
2000: CURSOR c1 (p_id NUMBER, e_id NUMBER, v VARCHAR2) IS
2001: select '1'

Line 2732: -- if it's a formula type assign, wrap the action text in a select from dual

2728: OPEN c2 (plan_char_action_id);
2729: FETCH c2 INTO assignment_type, assigned_datatype, assigned_precision;
2730: CLOSE c2;
2731:
2732: -- if it's a formula type assign, wrap the action text in a select from dual
2733: IF assignment_type = 'F' THEN
2734: final_stmt := 'SELECT ' || final_stmt || ' FROM DUAL';
2735: END IF;
2736:

Line 2734: final_stmt := 'SELECT ' || final_stmt || ' FROM DUAL';

2730: CLOSE c2;
2731:
2732: -- if it's a formula type assign, wrap the action text in a select from dual
2733: IF assignment_type = 'F' THEN
2734: final_stmt := 'SELECT ' || final_stmt || ' FROM DUAL';
2735: END IF;
2736:
2737: c1 := dbms_sql.open_cursor;
2738: dbms_sql.parse(c1, final_stmt, dbms_sql.native);

Line 4138: INTO token_count FROM DUAL;

4134: replaced_message VARCHAR2(2000);
4135: token_postn NUMBER;
4136: BEGIN
4137: SELECT LENGTH(p_error_message) - LENGTH(REPLACE(p_error_message,'&',''))
4138: INTO token_count FROM DUAL;
4139:
4140: IF token_count <> 0 THEN
4141: SELECT INSTR(p_error_message,':',1) INTO token_postn FROM DUAL;
4142:

Line 4141: SELECT INSTR(p_error_message,':',1) INTO token_postn FROM DUAL;

4137: SELECT LENGTH(p_error_message) - LENGTH(REPLACE(p_error_message,'&',''))
4138: INTO token_count FROM DUAL;
4139:
4140: IF token_count <> 0 THEN
4141: SELECT INSTR(p_error_message,':',1) INTO token_postn FROM DUAL;
4142:
4143: SELECT SUBSTR(p_error_message,1,token_postn-1),
4144: SUBSTR(p_error_message,token_postn+1)
4145: INTO element_prompt, replaced_message

Line 4146: FROM DUAL;

4142:
4143: SELECT SUBSTR(p_error_message,1,token_postn-1),
4144: SUBSTR(p_error_message,token_postn+1)
4145: INTO element_prompt, replaced_message
4146: FROM DUAL;
4147:
4148: SELECT REPLACE(replaced_message,'&'||'CHAR_PROMPT', element_prompt)
4149: INTO replaced_message FROM DUAL;
4150: ELSE

Line 4149: INTO replaced_message FROM DUAL;

4145: INTO element_prompt, replaced_message
4146: FROM DUAL;
4147:
4148: SELECT REPLACE(replaced_message,'&'||'CHAR_PROMPT', element_prompt)
4149: INTO replaced_message FROM DUAL;
4150: ELSE
4151: RETURN p_error_message;
4152: END IF;
4153:

Line 4352: FROM DUAL;

4348: -- that converts the comma separated strings into arrays
4349: -- works only with number elements
4350: SELECT TRANSLATE(disable_enable_flag_list,'ED','12')
4351: INTO dep_elements_status
4352: FROM DUAL;
4353:
4354: QA_PARENT_CHILD_PKG.parse_list(dependent_elements , dependent_elements_arr);
4355: QA_PARENT_CHILD_PKG.parse_list(dep_elements_status, dep_elements_status_arr);
4356: