APPS.DDR_WEBSERVICES_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 502

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

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 ;

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 ;

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 ;

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 ;

Line: 572

	--update job status to Running
    UPDATE DDR_WS_JOB set status= ddr_webservices_constants.g_ret_sts_running,start_date=sysdate where job_id=p_job_id ;

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 ;

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 ;

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 ;

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 ;

Line: 784

   l_query := 'SELECT ' || l_fact_cols;

Line: 831

   SELECT LENGTH(l_query) into l_query_len from dual;

Line: 1250

       SELECT hrchy_lvl_name INTO l_hrchy_lvl_name FROM DDR_WS_METADATA WHERE hrchy_lvl_cd=p_exp_time_level;

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,
                created_by, creation_date, last_updated_by,
                last_update_date, last_update_login)
         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,
                SYSDATE, 101);

Line: 1379

       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,
                created_by, creation_date, last_updated_by,
                last_update_date, last_update_login
               )
        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,
                SYSDATE, 101);

Line: 1534

      SELECT lkup_name INTO x_sys_var_val FROM ddr_r_lkup_mst WHERE lkup_cd=p_sys_var;

Line: 1553

    SELECT DDR_WS_FILE_SEQ.NEXTVAL INTO l_next_val FROM dual;

Line: 1769

       SELECT hrchy_lvl_name INTO l_hrchy_lvl_name FROM DDR_WS_METADATA WHERE
       hrchy_lvl_cd=p_time_dim_lvl_cd;

Line: 1773

       SELECT hrchy_lvl_name INTO l_hrchy_lvl_name FROM DDR_WS_METADATA WHERE
       hrchy_lvl_cd=p_exp_time_level;

Line: 1976

    SELECT lvl_rnk INTO l_hrchy_lvl FROM DDR_WS_METADATA WHERE HRCHY_LVL_CD=p_hrchy_lvl_cd AND hrchy_lvl_name=p_hrchy_lvl_name;

Line: 2001

x.org_bsns_unit_id, x.day_cd, x.glbl_item_id, x.rtl_sku_item_id) IN(SELECT
MAX(frcst_vrsn),  mfg_org_cd,  rtl_org_cd,  org_bsns_unit_id,  day_cd,
glbl_item_id,  rtl_sku_item_id FROM ddr_b_sls_frcst_item_day GROUP BY
mfg_org_cd,  rtl_org_cd,  org_bsns_unit_id,  day_cd,  glbl_item_id,
rtl_sku_item_id)';