APPS.DDR_WEBSERVICES_PUB dependencies on DUAL

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

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

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

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

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

1538: x_msg_data OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1539: IS
1540: l_next_val NUMBER:=null;
1541: BEGIN
1542: SELECT DDR_WS_FILE_SEQ.NEXTVAL INTO l_next_val FROM dual;
1543: RETURN to_char(l_next_val);
1544: EXCEPTION
1545: WHEN NO_DATA_FOUND THEN
1546: x_return_status := ddr_webservices_constants.g_ret_sts_error;