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_WS_JOB

Line 502: UPDATE DDR_WS_JOB set status= ddr_webservices_constants.g_ret_sts_running,start_date=sysdate where job_id=p_job_id ;

498: l_job_id NUMBER:=null;
499: BEGIN
500: l_job_id:=p_job_id;
501: --update job status to Running
502: UPDATE DDR_WS_JOB set status= ddr_webservices_constants.g_ret_sts_running,start_date=sysdate where job_id=p_job_id ;
503: --build dynamic query
504: get_dyn_query(p_api_version,
505: 'A',
506: p_mfg_org_cd,

Line 526: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;

522: l_msg_count,
523: l_msg_data,
524: l_query);
525: IF l_return_status<>ddr_webservices_constants.g_ret_sts_success THEN
526: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;
527: RETURN;
528: END IF;
529: --write data to xml file based on dynamic query generated
530: write_fact_to_xml_file(l_query,p_fact_code,l_job_id,l_return_status,l_msg_count,l_msg_data);

Line 532: UPDATE DDR_WS_JOB SET status=ddr_webservices_constants.g_ret_sts_success,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;

528: END IF;
529: --write data to xml file based on dynamic query generated
530: write_fact_to_xml_file(l_query,p_fact_code,l_job_id,l_return_status,l_msg_count,l_msg_data);
531: --update job status to complete/error
532: UPDATE DDR_WS_JOB SET status=ddr_webservices_constants.g_ret_sts_success,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: l_return_status:=ddr_webservices_constants.g_ret_sts_error;
536: l_msg_count:=1;

Line 538: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;

534: WHEN NO_DATA_FOUND THEN
535: l_return_status:=ddr_webservices_constants.g_ret_sts_error;
536: l_msg_count:=1;
537: l_msg_data:='No Data Found. Error code:'||sqlcode||' Error message:'||sqlerrm;
538: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;
539: WHEN OTHERS THEN
540: l_return_status:=ddr_webservices_constants.g_ret_sts_unexp_error;
541: l_msg_count:=1;
542: l_msg_data:='Unexpected Error. Error code:'||sqlcode||' Error message:'||sqlerrm;

Line 543: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;

539: WHEN OTHERS THEN
540: l_return_status:=ddr_webservices_constants.g_ret_sts_unexp_error;
541: l_msg_count:=1;
542: l_msg_data:='Unexpected Error. Error code:'||sqlcode||' Error message:'||sqlerrm;
543: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;
544: END ddr_fact_aggr_prc;
545:
546: PROCEDURE ddr_fact_details_prc(p_api_version IN NUMBER,
547: p_job_id IN NUMBER,

Line 573: UPDATE DDR_WS_JOB set status= ddr_webservices_constants.g_ret_sts_running,start_date=sysdate where job_id=p_job_id ;

569: l_job_id NUMBER:=null;
570: BEGIN
571: l_job_id:=p_job_id;
572: --update job status to Running
573: UPDATE DDR_WS_JOB set status= ddr_webservices_constants.g_ret_sts_running,start_date=sysdate where job_id=p_job_id ;
574: --build dynamic query
575: get_dyn_query(p_api_version,
576: 'D',
577: p_mfg_org_cd,

Line 598: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;

594: l_msg_data,
595: l_query);
596:
597: IF l_return_status<>ddr_webservices_constants.g_ret_sts_success THEN
598: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;
599: RETURN;
600: END IF;
601: --write data to xml file based on dynamic query generated
602: write_fact_to_xml_file(l_query,p_fact_code,l_job_id,l_return_status,l_msg_count,l_msg_data);

Line 604: UPDATE DDR_WS_JOB SET status=ddr_webservices_constants.g_ret_sts_success,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;

600: END IF;
601: --write data to xml file based on dynamic query generated
602: write_fact_to_xml_file(l_query,p_fact_code,l_job_id,l_return_status,l_msg_count,l_msg_data);
603: --update job status to complete/error
604: UPDATE DDR_WS_JOB SET status=ddr_webservices_constants.g_ret_sts_success,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;
605: EXCEPTION
606: WHEN NO_DATA_FOUND THEN
607: l_return_status:=ddr_webservices_constants.g_ret_sts_error;
608: l_msg_count:=1;

Line 610: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;

606: WHEN NO_DATA_FOUND THEN
607: l_return_status:=ddr_webservices_constants.g_ret_sts_error;
608: l_msg_count:=1;
609: l_msg_data:='No Data Found. Error code:'||sqlcode||' Error message:'||sqlerrm;
610: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;
611: WHEN OTHERS THEN
612: l_return_status:=ddr_webservices_constants.g_ret_sts_unexp_error;
613: l_msg_count:=1;
614: l_msg_data:='Unexpected Error. Error code:'||sqlcode||' Error message:'||sqlerrm;

Line 615: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;

611: WHEN OTHERS THEN
612: l_return_status:=ddr_webservices_constants.g_ret_sts_unexp_error;
613: l_msg_count:=1;
614: l_msg_data:='Unexpected Error. Error code:'||sqlcode||' Error message:'||sqlerrm;
615: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;
616: END ddr_fact_details_prc;
617:
618:
619: PROCEDURE get_dyn_query(p_api_version IN NUMBER,

Line 1349: INSERT INTO ddr_ws_job_file_dls(file_id, job_id, file_name, status, delete_flag,src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr,

1345: UTL_FILE.put_line(l_xml_file,'');
1346: UTL_FILE.FCLOSE(l_xml_file);
1347: --update the job file metadata table with the file name
1348: BEGIN
1349: INSERT INTO ddr_ws_job_file_dls(file_id, job_id, file_name, status, delete_flag,src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr,
1350: created_by, creation_date, last_updated_by,
1351: last_update_date, last_update_login)
1352: VALUES (l_file_id, p_job_id, l_file_name, ddr_webservices_constants.g_ret_sts_success, 'N','ABC', SYSDATE, 'ABC', 'ABC',101, SYSDATE, 101,
1353: SYSDATE, 101);

Line 1379: INSERT INTO ddr_ws_job_file_dls

1375: UTL_FILE.put_line(l_xml_file, '');
1376: UTL_FILE.FCLOSE(l_xml_file);
1377: BEGIN
1378: -- DBMS_OUTPUT.PUT_LINE('third, l_file_id='||l_file_id);
1379: INSERT INTO ddr_ws_job_file_dls
1380: (file_id, job_id, file_name, status, delete_flag,
1381: src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr,
1382: created_by, creation_date, last_updated_by,
1383: last_update_date, last_update_login