APPS.ZPB_AW_WRITE_BACK SQL Statements

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

Line: 18

   select USER_ID into l_user_id from FND_USER where USER_NAME = p_user_name;

Line: 83

   select count(*) into rcd_ct
      from ZPB_WRITEBACK_TASKS
      where (status = COMPLETED  or status = FAILED)
      and completion_date <= (SYSDATE - num_of_days);

Line: 93

      delete from ZPB_WRITEBACK_TASKS
         where (status = COMPLETED or status = FAILED)
         and completion_date <= (SYSDATE - num_of_days);

Line: 135

   SELECT distinct(responsibility_name) into resp_name
      FROM FND_RESPONSIBILITY_VL
      WHERE responsibility_id = P_RESP_ID;

Line: 139

   SELECT distinct(user_name) into zpb_user
      from FND_USER
      where user_id = P_USER_ID;

Line: 143

   select req_name
      into req_nm
      from ZPB_REQUESTS
      where req_task_type = P_TASK_TYPE;

Line: 148

   select zpb_writeback_seq.nextval into tsk_seq from dual;

Line: 150

   INSERT INTO zpb_writeback_tasks (task_type, business_area_id, user_id,
                                    session_id, task_seq, status, resp_id,
                                    submit_date,
                                    CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
                                    LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
      VALUES (P_TASK_TYPE, p_business_area_id, zpb_user,
              P_SESSION_ID, tsk_seq,
              PENDING, resp_name, P_START_TIME,
              fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
              SYSDATE, fnd_global.LOGIN_ID);

Line: 170

      INSERT INTO zpb_writeback_transaction
         (task_seq, exec_order, qdr,
          CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
          LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
         VALUES (tsk_seq,  ctr, spl_stmt,
                 fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
                 SYSDATE, fnd_global.LOGIN_ID);

Line: 185

      INSERT INTO zpb_writeback_transaction
         (task_seq, exec_order, qdr,
          CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
          LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
         VALUES (tsk_seq, ctr, cmd_str,
                 fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
                 SYSDATE, fnd_global.LOGIN_ID);

Line: 244

         select a.task_seq taskseq, a.user_id asuser,
           a.resp_id asresp, b.qdr type, b.exec_order exorder
            from zpb_writeback_tasks a, zpb_writeback_transaction b
            where b.task_seq = a.task_seq
              and a.task_seq = P_TASK_SEQ
            order by b.exec_order ASC;

Line: 269

      update zpb_writeback_tasks set
            status = FAILED, completion_date = SYSDATE,
                LAST_UPDATED_BY =  fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
                LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
         where task_seq = each.taskseq;

Line: 277

         delete * from zpb_ac_param_values;

Line: 278

         delete * from zpb_analysis_cycles;

Line: 279

         delete * from zpb_analysis_cycle_instances;

Line: 280

         delete * from zpb_analysis_cycle_tasks;

Line: 282

         delete * from zpb_cycle_model_dimensions;

Line: 283

         delete * from zpb_cycle_relationships;

Line: 284

         delete * from zpb_dc_distribution_lists;

Line: 285

         delete * from zpb_dc_distribution_list_items;

Line: 286

         delete * from zpb_dc_instruction_text;

Line: 287

         delete * from zpb_dc_instruction_text_items;

Line: 288

         delete * from zpb_home_page_data;

Line: 289

         delete * from zpb_label_lookups;

Line: 290

         delete * from zpb_solve_allocation_basis;

Line: 291

         delete * from zpb_solve_allocation_rules;

Line: 292

         delete * from zpb_solve_definitions;

Line: 293

         delete * from zpb_solve_input_levels;

Line: 294

         delete * from zpb_solve_output_hierarchies;

Line: 295

         delete * from zpb_solve_output_levels;

Line: 296

         delete * from zpb_status_sql;

Line: 297

         delete * from zpb_status_sql_lines;

Line: 298

         delete * from zpb_task_parameters;

Line: 299

         delete * from zpb_writeback_tasks;

Line: 300

         delete * from zpb_writeback_transaction;

Line: 308

      delete * from zpb_univ_attributes;

Line: 309

      delete * from zpb_univ_dimensions;

Line: 310

      delete * from zpb_univ_dimension_abbrevs;

Line: 311

      delete * from zpb_univ_dimension_groups;

Line: 312

      delete * from zpb_univ_hierarchies;

Line: 325

      update zpb_writeback_tasks set
            status = COMPLETED, completion_date = SYSDATE,
                LAST_UPDATED_BY =  fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
                LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
         where task_seq = last_task;

Line: 373

         select task_seq taskseq, business_Area_id,
            user_id asuser, resp_id asresp
            from zpb_writeback_tasks
            where task_seq = P_TASK_SEQ;

Line: 379

                   select qdr token, exec_order exorder
                   from zpb_writeback_transaction
                   where task_seq = P_TASK_SEQ
         order by exec_order ASC;

Line: 391

      update zpb_writeback_tasks set
        status = FAILED, completion_date = SYSDATE,
         LAST_UPDATED_BY =  fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
         LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
         where task_seq = v_task.taskseq;

Line: 420

      update zpb_writeback_tasks set
         status = COMPLETED, completion_date = SYSDATE,
         LAST_UPDATED_BY =  fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
         LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
         where task_seq = v_task.taskseq;

Line: 428

   ZPB_AW.EXECUTE ('update');

Line: 487

         select a.task_seq taskseq, a.business_Area_id,
            a.user_id asuser,
            a.resp_id asresp, b.qdr token, b.exec_order exorder
           from zpb_writeback_tasks a, zpb_writeback_transaction b
           where b.task_seq = a.task_seq
            and a.task_seq = P_TASK_SEQ
           order by b.exec_order ASC;

Line: 498

      SELECT a.task_seq taskseq,
             a.business_Area_id,
             a.user_id asuser,
             a.resp_id asresp,
	     b.qdr token,
	     b.exec_order exorder
      FROM   zpb_writeback_tasks a,
             zpb_writeback_transaction b
      WHERE  b.task_seq = a.task_seq
      AND    a.session_id = p_conc_request_id
      AND    a.task_type = 'DO'
      ORDER BY b.exec_order ASC;

Line: 533

        update zpb_writeback_tasks set
           status = FAILED, completion_date = SYSDATE,
           LAST_UPDATED_BY =  fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
           LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
           where task_seq = task;

Line: 558

                 UPDATE zpb_security_rule_definition_t
	         SET status = l_status,
	             error = error || '; ' || l_err_msg

Line: 567

                 UPDATE zpb_security_rule_definition_t
	         SET status = l_status,
	             error = error || '; ' || l_err_msg

Line: 576

                 UPDATE zpb_security_rule_definition_t
	         SET status = l_status,
	             error = error || '; ' || l_err_msg

Line: 585

	       UPDATE zpb_account_states
	       SET has_read_access = 0
	       WHERE user_id = v_task.asuser
	       AND business_area_id = v_task.business_Area_id;

Line: 617

        update zpb_account_states
           set has_read_access = x_has_read_acc
           where user_id = l_user_id
           and business_area_id = v_task.business_area_id;

Line: 640

        update zpb_writeback_tasks set
           status = FAILED, completion_date = SYSDATE,
           LAST_UPDATED_BY =  fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
           LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
           where task_seq = task;

Line: 678

        update zpb_account_states
           set has_read_access = x_has_read_acc
           where user_id = l_user_id
           and business_area_id = v_task.business_area_id;

Line: 687

   ZPB_AW.EXECUTE ('update');

Line: 699

     UPDATE zpb_writeback_tasks
     SET status = COMPLETED,
         completion_date = SYSDATE,
	 last_updated_by =  fnd_global.user_id,
	 last_update_date = SYSDATE,
	 last_update_login = fnd_global.login_id
     WHERE session_id = p_conc_request_id;

Line: 712

     UPDATE zpb_writeback_tasks
     SET status = COMPLETED,
         completion_date = SYSDATE,
         last_updated_by =  fnd_global.user_id,
	 last_update_date = SYSDATE,
         last_update_login = fnd_global.login_id
     WHERE task_seq = task;

Line: 763

          select distinct substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'ReadAccess')+10) QUERY_PATH
          from ZPB_STATUS_SQL SSQL
          where QUERY_PATH like 'oracle/apps/zpb/BusArea' ||
                p_business_area || '/ZPBSystem/Private/Manager/%ReadAccess%' and
                substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'ReadAccess')+10)
                   not in(
                     select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'ReadAccess')+10)
                     from ZPB_VALIDATION_TEMP_DATA VTDATA
                     where VTDATA.business_area_id = p_business_area);

Line: 774

         select distinct substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'WriteAccess')+11) QUERY_PATH
          from ZPB_STATUS_SQL SSQL
          where QUERY_PATH like 'oracle/apps/zpb/BusArea' ||
                p_business_area || '/ZPBSystem/Private/Manager/%WriteAccess%' and
                substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'WriteAccess')+11)
                   not in(
                     select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'WriteAccess')+11)
                     from ZPB_VALIDATION_TEMP_DATA VTDATA
                     where VTDATA.business_area_id = p_business_area);

Line: 785

         select distinct substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'Ownership')+9) QUERY_PATH
          from ZPB_STATUS_SQL SSQL
          where QUERY_PATH like 'oracle/apps/zpb/BusArea' ||
                p_business_area || '/ZPBSystem/Private/Manager/%Ownership%' and
                substr(SSQL.QUERY_PATH, 1, instr(SSQL.QUERY_PATH, 'Ownership')+9)
                   not in(
                     select substr(replace(VTDATA.VALUE, fnd_global.newline(), '/'), 1, instr(SSQL.QUERY_PATH, 'Ownership')+9)
                     from ZPB_VALIDATION_TEMP_DATA VTDATA
                     where VTDATA.business_area_id = p_business_area);

Line: 796

   select USER_NAME
      into l_user_name
      from FND_USER
      where USER_ID = FND_GLOBAL.USER_ID;

Line: 828

   DELETE FROM zpb_validation_temp_data WHERE business_area_id = p_business_area;

Line: 832

   ZPB_AW.EXECUTE ('update');

Line: 869

         select a.task_type tasktype, a.business_area_id,
            a.task_seq taskseq, a.user_id asuser,
           a.resp_id asresp, b.qdr qdr, b.exec_order exorder
            from zpb_writeback_tasks a, zpb_writeback_transaction b
            where b.task_seq = a.task_seq
              and a.task_seq = P_TASK_SEQ
            order by b.exec_order ASC;

Line: 898

      update zpb_writeback_tasks set
         status = FAILED, completion_date = SYSDATE,
         LAST_UPDATED_BY =  fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
         LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
         where task_seq = each.taskseq;

Line: 907

        ZPB_AW.EXECUTE('update');

Line: 934

      ZPB_AW.EXECUTE ('update');

Line: 941

   update zpb_writeback_tasks set
      status = COMPLETED, completion_date = SYSDATE,
      LAST_UPDATED_BY =  fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
      LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
      where task_seq = last_task;

Line: 972

  SELECT COUNT(*)
  FROM fnd_concurrent_requests
  WHERE concurrent_program_id = (SELECT concurrent_program_id
                                 FROM   fnd_concurrent_programs
                                 WHERE  concurrent_program_name = 'ZPB_CREATE_PERSONAL_AW')
  AND phase_code in ('I','P','R');

Line: 996

  SELECT DISTINCT b.qdr,
         a.business_area_id
  FROM   zpb_writeback_tasks a,
         zpb_writeback_transaction b
  WHERE  b.task_seq = a.task_seq
  AND    a.task_seq = p_task_seq
  AND    a.task_type = 'UM';

Line: 1075

  UPDATE zpb_account_states
  SET has_read_access = 0
  WHERE business_area_id = p_business_area_id
  AND user_id = p_user_id;

Line: 1103

  UPDATE zpb_account_states
  SET has_read_access = x_has_read_acc
  WHERE user_id = p_user_id
  AND business_area_id = p_business_area_id;