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 1306: l_file_id :=get_ddr_ws_file_seq_nextval(x_return_status,x_msg_count,x_msg_data);

1302: 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);
1303: -- DBMS_OUTPUT.PUT_LINE('l_max_row_count='||l_max_row_count);
1304: l_pagination_row_count:=to_number(l_pagination_row_count);
1305: --get file id
1306: l_file_id :=get_ddr_ws_file_seq_nextval(x_return_status,x_msg_count,x_msg_data);
1307: --construct file name
1308: l_file_name := p_fact_code || '_'|| l_file_id || '.xml';
1309: --open file in write mode
1310: l_xml_file := UTL_FILE.fopen(l_dir_name,l_file_name,ddr_webservices_constants.g_file_write_mode);

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

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

Line 1536: FUNCTION get_ddr_ws_file_seq_nextval(x_return_status OUT NOCOPY VARCHAR2,

1532: x_msg_count:=1;
1533: x_msg_data:='Unexpected Error. Error code:'||sqlcode||' Error message:'||sqlerrm;
1534: END get_sys_var_val;
1535:
1536: FUNCTION get_ddr_ws_file_seq_nextval(x_return_status OUT NOCOPY VARCHAR2,
1537: x_msg_count OUT NOCOPY NUMBER,
1538: x_msg_data OUT NOCOPY VARCHAR2) RETURN VARCHAR2
1539: IS
1540: l_next_val NUMBER:=null;

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;

Line 1553: END get_ddr_ws_file_seq_nextval;

1549: WHEN OTHERS THEN
1550: x_return_status:=ddr_webservices_constants.g_ret_sts_unexp_error;
1551: x_msg_count:=1;
1552: x_msg_data:='Unexpected Error. Error code:'||sqlcode||' Error message:'||sqlerrm;
1553: END get_ddr_ws_file_seq_nextval;
1554:
1555: PROCEDURE get_itm_hrchy_clauses(p_item_dim_lvl_cd IN VARCHAR2,
1556: p_item_lvl_val IN VARCHAR2,
1557: p_exp_item_level IN VARCHAR2,