APPS.QA_VALIDATION_API dependencies on DUAL

Line 1954: -- dual which is inefficient

1950: sql_string VARCHAR2(1500);
1951: ok_flag varchar2(240);
1952:
1953: -- Bug 3111310. Used to have a SQL that select from
1954: -- dual which is inefficient
1955: -- saugupta Aug 2003
1956:
1957: CURSOR c1 (p_id NUMBER, e_id NUMBER, v VARCHAR2) IS
1958: select '1'

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

2661: OPEN c2 (plan_char_action_id);
2662: FETCH c2 INTO assignment_type, assigned_datatype, assigned_precision;
2663: CLOSE c2;
2664:
2665: -- if it's a formula type assign, wrap the action text in a select from dual
2666: IF assignment_type = 'F' THEN
2667: final_stmt := 'SELECT ' || final_stmt || ' FROM DUAL';
2668: END IF;
2669:

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

2663: CLOSE c2;
2664:
2665: -- if it's a formula type assign, wrap the action text in a select from dual
2666: IF assignment_type = 'F' THEN
2667: final_stmt := 'SELECT ' || final_stmt || ' FROM DUAL';
2668: END IF;
2669:
2670: c1 := dbms_sql.open_cursor;
2671: dbms_sql.parse(c1, final_stmt, dbms_sql.native);

Line 4010: INTO token_count FROM DUAL;

4006: replaced_message VARCHAR2(2000);
4007: token_postn NUMBER;
4008: BEGIN
4009: SELECT LENGTH(p_error_message) - LENGTH(REPLACE(p_error_message,'&',''))
4010: INTO token_count FROM DUAL;
4011:
4012: IF token_count <> 0 THEN
4013: SELECT INSTR(p_error_message,':',1) INTO token_postn FROM DUAL;
4014:

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

4009: SELECT LENGTH(p_error_message) - LENGTH(REPLACE(p_error_message,'&',''))
4010: INTO token_count FROM DUAL;
4011:
4012: IF token_count <> 0 THEN
4013: SELECT INSTR(p_error_message,':',1) INTO token_postn FROM DUAL;
4014:
4015: SELECT SUBSTR(p_error_message,1,token_postn-1),
4016: SUBSTR(p_error_message,token_postn+1)
4017: INTO element_prompt, replaced_message

Line 4018: FROM DUAL;

4014:
4015: SELECT SUBSTR(p_error_message,1,token_postn-1),
4016: SUBSTR(p_error_message,token_postn+1)
4017: INTO element_prompt, replaced_message
4018: FROM DUAL;
4019:
4020: SELECT REPLACE(replaced_message,'&'||'CHAR_PROMPT', element_prompt)
4021: INTO replaced_message FROM DUAL;
4022: ELSE

Line 4021: INTO replaced_message FROM DUAL;

4017: INTO element_prompt, replaced_message
4018: FROM DUAL;
4019:
4020: SELECT REPLACE(replaced_message,'&'||'CHAR_PROMPT', element_prompt)
4021: INTO replaced_message FROM DUAL;
4022: ELSE
4023: RETURN p_error_message;
4024: END IF;
4025:

Line 4206: FROM DUAL;

4202: -- that converts the comma separated strings into arrays
4203: -- works only with number elements
4204: SELECT TRANSLATE(disable_enable_flag_list,'ED','12')
4205: INTO dep_elements_status
4206: FROM DUAL;
4207:
4208: QA_PARENT_CHILD_PKG.parse_list(dependent_elements , dependent_elements_arr);
4209: QA_PARENT_CHILD_PKG.parse_list(dep_elements_status, dep_elements_status_arr);
4210: