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 597: UPDATE DDR_WS_JOB SET status=l_return_status,err_message=l_msg_data,end_date=sysdate WHERE job_id=p_job_id ;

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

Line 603: 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 ;

599: END IF;
600: --write data to xml file based on dynamic query generated
601: write_fact_to_xml_file(l_query,p_fact_code,l_job_id,l_return_status,l_msg_count,l_msg_data);
602: --update job status to complete/error
603: 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 ;
604: EXCEPTION
605: WHEN NO_DATA_FOUND THEN
606: l_return_status:=ddr_webservices_constants.g_ret_sts_error;
607: l_msg_count:=1;

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

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

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

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

Line 1346: 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,

1342: UTL_FILE.put_line(l_xml_file,'');
1343: UTL_FILE.FCLOSE(l_xml_file);
1344: --update the job file metadata table with the file name
1345: BEGIN
1346: 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,
1347: created_by, creation_date, last_updated_by,
1348: last_update_date, last_update_login)
1349: 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,
1350: SYSDATE, 101);

Line 1376: INSERT INTO ddr_ws_job_file_dls

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