APPS.DDR_WEBSERVICES_PUB dependencies on DUAL

Line 831: SELECT LENGTH(l_query) into l_query_len from dual;

827: IF l_group_col IS NOT NULL THEN
828: l_query := l_query || ' GROUP BY '|| l_group_col;
829: END IF;
830: END IF;
831: SELECT LENGTH(l_query) into l_query_len from dual;
832: -- DBMS_OUTPUT.PUT_LINE('l_query_len='||l_query_len);
833: -- DBMS_OUTPUT.PUT_LINE('l_query='||l_query);
834: x_dyn_query:= l_query;
835: EXCEPTION

Line 1331: --write individual row in the xml file

1327: WHILE ( l_fetch_rows > 0 ) LOOP
1328: l_fetch_ctn:=l_fetch_ctn+l_fetch_rows;
1329: UTL_FILE.put_line(l_xml_file, '');
1330: l_fact:=null;
1331: --write individual row in the xml file
1332: FOR i in 1..l_cnt loop
1333: l_col_name:= l_dtbl(i).col_name;
1334: dbms_sql.column_value(l_cur,i,l_val);
1335: -- l_fact:=l_fact||'<'||l_col_name||'>'||l_val||''||chr(10);

Line 1553: SELECT DDR_WS_FILE_SEQ.NEXTVAL INTO l_next_val FROM dual;

1549: x_msg_data OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1550: IS
1551: l_next_val NUMBER:=null;
1552: BEGIN
1553: SELECT DDR_WS_FILE_SEQ.NEXTVAL INTO l_next_val FROM dual;
1554: RETURN to_char(l_next_val);
1555: EXCEPTION
1556: WHEN NO_DATA_FOUND THEN
1557: x_return_status := ddr_webservices_constants.g_ret_sts_error;