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_FACT_WEBSERVICES_PUB dependencies on DDR_WEBSERVICES_PUB

Line 866: l_proc_str := 'BEGIN ddr_webservices_pub.ddr_fact_aggr_prc(';

862: VALUES (l_job_id, ddr_webservices_constants.g_ret_sts_initialize,'-1', sysdate, '-1', '-1', -1,sysdate, -1, sysdate,-1);
863:
864:
865: --triggere the DBMS_SCHEDULER to run the job which writes data to xml file
866: l_proc_str := 'BEGIN ddr_webservices_pub.ddr_fact_aggr_prc(';
867: l_proc_str := l_proc_str || p_api_version || ', ';
868: l_proc_str := l_proc_str || '''' || l_job_id || ''', ';
869: l_proc_str := l_proc_str || '''' || p_mfg_org_cd || ''', ';
870: l_proc_str := l_proc_str || '''' || p_org_cd || ''', ';

Line 943: l_proc_str := 'BEGIN ddr_webservices_pub.ddr_fact_details_prc (';

939: INSERT INTO ddr_ws_job(job_id, status, SRC_SYS_IDNT,SRC_SYS_DT, CRTD_BY_DSR, LAST_UPDT_BY_DSR, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
940: VALUES (l_job_id, ddr_webservices_constants.g_ret_sts_initialize,'-1', sysdate, '-1', '-1', -1,sysdate, -1, sysdate,-1);
941:
942: --triggere the DBMS_SCHEDULER to run the job which writes data to xml file
943: l_proc_str := 'BEGIN ddr_webservices_pub.ddr_fact_details_prc (';
944: l_proc_str := l_proc_str || p_api_version|| ', ';
945: l_proc_str := l_proc_str || '''' || l_job_id || ''', ';
946: l_proc_str := l_proc_str || '''' || p_mfg_org_cd || ''', ';
947: l_proc_str := l_proc_str || '''' || p_org_cd || ''', ';

Line 1053: ddr_webservices_pub.get_sys_var_val('DDR_WS_FILE_PATH',x_return_status, x_msg_count,x_msg_data,l_xml_file_path);

1049: x_file_path:='Running';
1050: ELSIF l_job_status = ddr_webservices_constants.g_ret_sts_success THEN
1051: --get the path to the directory where xml files are stored
1052: --Bug 6880404 change start
1053: ddr_webservices_pub.get_sys_var_val('DDR_WS_FILE_PATH',x_return_status, x_msg_count,x_msg_data,l_xml_file_path);
1054: --Bug 6880404 change start
1055: --get logical directory name from system variable table
1056: --ddr_webservices_pub.get_sys_var_val('OUTPUT_DIR_PATH',x_return_status, x_msg_count,x_msg_data,l_dir_name);
1057: --l_dir_path := l_db_ip_address || '\'||l_dir_name||'\';

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

1052: --Bug 6880404 change start
1053: ddr_webservices_pub.get_sys_var_val('DDR_WS_FILE_PATH',x_return_status, x_msg_count,x_msg_data,l_xml_file_path);
1054: --Bug 6880404 change start
1055: --get logical directory name from system variable table
1056: --ddr_webservices_pub.get_sys_var_val('OUTPUT_DIR_PATH',x_return_status, x_msg_count,x_msg_data,l_dir_name);
1057: --l_dir_path := l_db_ip_address || '\'||l_dir_name||'\';
1058: l_dir_path := l_xml_file_path;
1059: OPEN file_name_cur (x_job_id);
1060: