APPS.DDR_WEBSERVICES_PUB dependencies on DDR_WS_FILE_SEQ

Line 232: -- API name : get_ddr_ws_file_seq_nextval

228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2);
230:
231: -- Start of comments
232: -- API name : get_ddr_ws_file_seq_nextval
233: -- Type: Private
234: -- Pre-reqs: None.
235: -- Function: to get the file id from sequence
236: -- Parameters:

Line 244: FUNCTION get_ddr_ws_file_seq_nextval(x_return_status OUT NOCOPY VARCHAR2,

240: -- file ID sequence number
241: -- Version: Current version1.0
242: -- Initial version 1.0
243: -- End of comments
244: FUNCTION get_ddr_ws_file_seq_nextval(x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
247:
248:

Line 1309: l_file_id :=get_ddr_ws_file_seq_nextval(x_return_status,x_msg_count,x_msg_data);

1305: ddr_webservices_pub.get_sys_var_val('MAX_OUT NOCOPY PUT_RECORDS',x_return_status, x_msg_count,x_msg_data,l_max_row_count);
1306: -- DBMS_OUTPUT.PUT_LINE('l_max_row_count='||l_max_row_count);
1307: l_pagination_row_count:=to_number(l_pagination_row_count);
1308: --get file id
1309: l_file_id :=get_ddr_ws_file_seq_nextval(x_return_status,x_msg_count,x_msg_data);
1310: --construct file name
1311: l_file_name := p_fact_code || '_'|| l_file_id || '.xml';
1312: --open file in write mode
1313: l_xml_file := UTL_FILE.fopen(l_dir_name,l_file_name,ddr_webservices_constants.g_file_write_mode);

Line 1360: l_file_id :=get_ddr_ws_file_seq_nextval(x_return_status,x_msg_count,x_msg_data);

1356: IF(l_fetch_rows > 0) THEN
1357: IF l_total_row_count >=l_max_row_count THEN
1358: RAISE l_max_rows;
1359: END IF;
1360: l_file_id :=get_ddr_ws_file_seq_nextval(x_return_status,x_msg_count,x_msg_data);
1361: l_file_name := p_fact_code || '_'|| l_file_id || '.xml';
1362: l_xml_file := UTL_FILE.fopen(l_dir_name,l_file_name,ddr_webservices_constants.g_file_write_mode);
1363: UTL_FILE.put_line(l_xml_file, '');
1364: UTL_FILE.put_line(l_xml_file, '');

Line 1547: FUNCTION get_ddr_ws_file_seq_nextval(x_return_status OUT NOCOPY VARCHAR2,

1543: x_msg_count:=1;
1544: x_msg_data:='Unexpected Error. Error code:'||sqlcode||' Error message:'||sqlerrm;
1545: END get_sys_var_val;
1546:
1547: FUNCTION get_ddr_ws_file_seq_nextval(x_return_status OUT NOCOPY VARCHAR2,
1548: x_msg_count OUT NOCOPY NUMBER,
1549: x_msg_data OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1550: IS
1551: l_next_val NUMBER:=null;

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;

Line 1564: END get_ddr_ws_file_seq_nextval;

1560: WHEN OTHERS THEN
1561: x_return_status:=ddr_webservices_constants.g_ret_sts_unexp_error;
1562: x_msg_count:=1;
1563: x_msg_data:='Unexpected Error. Error code:'||sqlcode||' Error message:'||sqlerrm;
1564: END get_ddr_ws_file_seq_nextval;
1565:
1566: PROCEDURE get_itm_hrchy_clauses(p_item_dim_lvl_cd IN VARCHAR2,
1567: p_item_lvl_val IN VARCHAR2,
1568: p_exp_item_level IN VARCHAR2,