eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DDR_WEBSERVICES_PUB dependencies on DDR_WEBSERVICES_PUB

Line 1: PACKAGE BODY ddr_webservices_pub AS

1: PACKAGE BODY ddr_webservices_pub AS
2: /* $Header: ddrpcwsb.pls 120.8.12010000.3 2010/03/03 04:18:48 vbhave ship $ */
3:
4: -- Start of comments
5: -- API name : get_dyn_query

Line 1301: ddr_webservices_pub.get_sys_var_val('OUTPUT_DIR_PATH',x_return_status, x_msg_count,x_msg_data,l_dir_name);

1297: l_file_id VARCHAR2(100):= NULL;
1298: l_max_rows EXCEPTION;
1299: BEGIN
1300: --get logical directory name from system variable table
1301: ddr_webservices_pub.get_sys_var_val('OUTPUT_DIR_PATH',x_return_status, x_msg_count,x_msg_data,l_dir_name);
1302: --get pagination row count from system variable table
1303: ddr_webservices_pub.get_sys_var_val('MAX_REC_PER_FILE',x_return_status, x_msg_count,x_msg_data,l_pagination_row_count);
1304: --get threashold value for the maximum records for which files can be created
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);

Line 1303: ddr_webservices_pub.get_sys_var_val('MAX_REC_PER_FILE',x_return_status, x_msg_count,x_msg_data,l_pagination_row_count);

1299: BEGIN
1300: --get logical directory name from system variable table
1301: ddr_webservices_pub.get_sys_var_val('OUTPUT_DIR_PATH',x_return_status, x_msg_count,x_msg_data,l_dir_name);
1302: --get pagination row count from system variable table
1303: ddr_webservices_pub.get_sys_var_val('MAX_REC_PER_FILE',x_return_status, x_msg_count,x_msg_data,l_pagination_row_count);
1304: --get threashold value for the maximum records for which files can be created
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);

Line 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);

1301: ddr_webservices_pub.get_sys_var_val('OUTPUT_DIR_PATH',x_return_status, x_msg_count,x_msg_data,l_dir_name);
1302: --get pagination row count from system variable table
1303: ddr_webservices_pub.get_sys_var_val('MAX_REC_PER_FILE',x_return_status, x_msg_count,x_msg_data,l_pagination_row_count);
1304: --get threashold value for the maximum records for which files can be created
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);

Line 2023: END ddr_webservices_pub;

2019: '||sqlerrm;
2020: END get_other_join_conditions;
2021: --Bug 6880404 change end
2022:
2023: END ddr_webservices_pub;