APPS.AS_PIPELINE_MOVE_PUB dependencies on DUAL

Line 169: SELECT REPLACE(UPPER(TRIM(p_status)),',',''',''') INTO status_tokenized FROM DUAL;

165: ELSE
166: BEGIN
167: /* Status filter earlier code
168: status_str := '''(''';
169: SELECT REPLACE(UPPER(TRIM(p_status)),',',''',''') INTO status_tokenized FROM DUAL;
170: status_str := status_str || status_tokenized || ''')''';
171: status_str := '(''';
172: SELECT REPLACE(UPPER(TRIM(p_status)),',',''',''') INTO status_tokenized FROM DUAL;
173: status_str := status_str || status_tokenized || ''')';

Line 172: SELECT REPLACE(UPPER(TRIM(p_status)),',',''',''') INTO status_tokenized FROM DUAL;

168: status_str := '''(''';
169: SELECT REPLACE(UPPER(TRIM(p_status)),',',''',''') INTO status_tokenized FROM DUAL;
170: status_str := status_str || status_tokenized || ''')''';
171: status_str := '(''';
172: SELECT REPLACE(UPPER(TRIM(p_status)),',',''',''') INTO status_tokenized FROM DUAL;
173: status_str := status_str || status_tokenized || ''')';
174: --DBMS_OUTPUT.PUT_LINE(status_str);
175: */
176: SELECT '(TRIM(''' || REPLACE(REPLACE(UPPER(TRIM(p_status)),',','''),TRIM('''),' ','') || '''))' INTO status_str FROM DUAL;

Line 176: SELECT '(TRIM(''' || REPLACE(REPLACE(UPPER(TRIM(p_status)),',','''),TRIM('''),' ','') || '''))' INTO status_str FROM DUAL;

172: SELECT REPLACE(UPPER(TRIM(p_status)),',',''',''') INTO status_tokenized FROM DUAL;
173: status_str := status_str || status_tokenized || ''')';
174: --DBMS_OUTPUT.PUT_LINE(status_str);
175: */
176: SELECT '(TRIM(''' || REPLACE(REPLACE(UPPER(TRIM(p_status)),',','''),TRIM('''),' ','') || '''))' INTO status_str FROM DUAL;
177: EXCEPTION
178: WHEN OTHERS THEN
179: ERRBUF := 'Error at Pipeline Movement '||SQLERRM||' - (Error in determining input value of STATUS)';
180: END;