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 2008/04/03 09:55:49 vbhave noship $ */
3:
4: -- Start of comments
5: -- API name : get_dyn_query

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

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

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

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

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

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

Line 2001: END ddr_webservices_pub;

1997: '||sqlerrm;
1998: END get_other_join_conditions;
1999: --Bug 6880404 change end
2000:
2001: END ddr_webservices_pub;