APPS.MTL_CCEOI_CONC_PVT SQL Statements

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

Line: 28

   select INSTR(value,',',1,2),INSTR(value,',',1,3)
   into v_st_position,v_end_position from  v$parameter
   where upper(name) = 'UTL_FILE_DIR';

Line: 34

   select substr(value,v_st_position+1,v_w_position)
   into v_log_name from v$parameter
   where upper(name) = 'UTL_FILE_DIR';

Line: 97

          SELECT *
          FROM mtl_cycle_count_headers
       WHERE
          (cycle_count_header_id = cchid);

Line: 103

          SELECT *
          FROM mtl_cycle_count_entries
       WHERE
          (cycle_count_header_id = hid
             OR cycle_count_entry_id = ccid)
          AND NVL(export_flag, 2) = 2
          AND entry_status_code IN(1, 3);

Line: 118

          SELECT msi.tracking_quantity_ind
               , msi.secondary_default_ind
               , msi.secondary_uom_code
               , msi.process_costing_enabled_flag
               , mtp.process_enabled_flag
            FROM mtl_system_items msi, mtl_parameters mtp
           WHERE mtp.organization_id = cp_organization_id
             AND msi.organization_id = mtp.organization_id
             AND msi.inventory_item_id = cp_inventory_item_id;

Line: 174

             SELECT
                MTL_CC_ENTRIES_INTERFACE_S2.nextval
             INTO
                L_cc_entry_iface_group_id
             FROM
                dual;

Line: 229

                 select SERIAL_NUMBER_CONTROL_CODE into x_serial_number_control
                   from mtl_system_items
                  where organization_id = c_rec.organization_id
                    and inventory_item_id = c_rec.inventory_item_id;

Line: 233

                 select SERIAL_COUNT_OPTION into x_serial_count_option
                   from mtl_cycle_count_headers
                  where cycle_count_header_id = c_rec.Cycle_Count_Header_id;

Line: 418

  P_DeleteProcRec IN NUMBER DEFAULT 2)
  IS
    l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line: 508

       IF P_DeleteProcRec NOT IN(1, 2) THEN
          RETCODE := 'ERROR';

Line: 510

          ERRBUF :=FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_DELETEREC');

Line: 541

             SELECT COUNT(*)
             INTO L_MaxNumRows
             FROM MTL_CC_ENTRIES_INTERFACE
             WHERE NVL(STATUS_FLAG, 4) = 4
             --   STATUS_FLAG = 4
             AND NVL(LOCK_FLAG, 2) =2
             AND NVL(DELETE_FLAG, 2) = 2
             AND NVL(PROCESS_FLAG, 1) = 1
             AND NVL(PROCESS_MODE, 3) = 3;

Line: 551

             SELECT COUNT(*)
             INTO L_MaxNumRows
             FROM MTL_CC_ENTRIES_INTERFACE
             WHERE CYCLE_COUNT_HEADER_ID = P_CYCLE_COUNT_HEADER_ID
             AND NVL(STATUS_FLAG, 4) = 4
             --AND STATUS_FLAG = 4
             AND NVL(LOCK_FLAG, 2) =2
             AND NVL(DELETE_FLAG, 2) = 2
             AND NVL(PROCESS_FLAG, 1) = 1
             AND NVL(PROCESS_MODE, 3) = 3;

Line: 588

             SELECT ROUND(L_MaxNumRows/L_CountWorker)
             INTO
                L_CountRows
             FROM
                DUAL;

Line: 606

                UPDATE mtl_cc_entries_interface
                SET
                   cc_entry_interface_group_id = NULL,
                   LAST_UPDATE_DATE = SYSDATE,
                   LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
                   LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
                   PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
                   PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
                   REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
                   PROGRAM_UPDATE_DATE = SYSDATE
                WHERE
                   CYCLE_COUNT_HEADER_ID = NVL(P_Cycle_Count_Header_Id,CYCLE_COUNT_HEADER_ID)
                   AND NVL(PROCESS_FLAG, 1) = 1
                   AND NVL(LOCK_FLAG, 2) = 2
                   AND NVL(PROCESS_MODE, 3) = 3
                   AND NVL(STATUS_FLAG,4) = 4
                   AND NVL(DELETE_FLAG, 2) = 2;

Line: 626

             SELECT MTL_CC_ENTRIES_INTERFACE_S1.NEXTVAL
             INTO
                L_NextGroupID
             FROM
                DUAL;

Line: 634

                UPDATE mtl_cc_entries_interface
                SET
                   cc_entry_interface_group_id = L_NextGroupID,
                   LAST_UPDATE_DATE = SYSDATE,
                   LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
                   LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
                   PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
                   PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
                   REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
                   PROGRAM_UPDATE_DATE = SYSDATE
                WHERE
                   NVL(PROCESS_FLAG, 1) = 1
                   AND NVL(LOCK_FLAG, 2) = 2
                   AND NVL(PROCESS_MODE, 3) = 3
                   AND NVL(STATUS_FLAG,4) = 4
                   AND NVL(DELETE_FLAG, 2) = 2
                   AND cc_entry_interface_group_id IS NULL
                   AND ROWNUM <= L_CountRows;

Line: 653

                UPDATE mtl_cc_entries_interface
                SET
                   cc_entry_interface_group_id = L_NextGroupID,
                   LAST_UPDATE_DATE = SYSDATE,
                   LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
                   LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
                   PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
                   PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
                   REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
                   PROGRAM_UPDATE_DATE = SYSDATE
                WHERE
                   CYCLE_COUNT_HEADER_ID = P_Cycle_Count_Header_Id
                   AND NVL(PROCESS_FLAG, 1) = 1
                   AND NVL(LOCK_FLAG, 2) = 2
                   AND NVL(PROCESS_MODE, 3) = 3
                   AND NVL(STATUS_FLAG,4) = 4
                   AND NVL(DELETE_FLAG, 2) = 2
                   AND cc_entry_interface_group_id IS NULL
                   AND ROWNUM <= L_CountRows;

Line: 684

                argument4 => to_char(P_DeleteProcRec));

Line: 754

          SELECT
          *
          FROM
          MTL_CC_ENTRIES_INTERFACE
       WHERE
          (ERROR_FLAG = 2
             AND STATUS_FLAG IN(0, 1))
          OR DELETE_FLAG = 1;

Line: 779

          select count(*)
          into L_recs
          FROM
          MTL_CC_ENTRIES_INTERFACE
       WHERE
          (ERROR_FLAG = 2 AND STATUS_FLAG IN (0, 1))
          OR DELETE_FLAG = 1;

Line: 816

             MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
                p_cc_entry_interface_id => c_rec.cc_entry_interface_id);

Line: 820

             MTL_CCEOI_PROCESS_PVT.Delete_CCIEntry(
                p_cc_entry_interface_id => c_rec.cc_entry_interface_id);

Line: 831

          'Deleted rows     ='|| TO_CHAR(L_counter));

Line: 854

  P_DeleteProcRec IN NUMBER DEFAULT 2)
  IS
     l_interface_id NUMBER;

Line: 905

          SELECT * FROM MTL_CC_ENTRIES_INTERFACE
       WHERE
          CC_ENTRY_INTERFACE_GROUP_ID = id
--          AND LOCK_FLAG = 1  -- record will be locked by public API
          AND NVL(PROCESS_FLAG, 1) = 1
          AND NVL(PROCESS_MODE, 3) IN(2, 3)
          AND NVL(STATUS_FLAG,4)=4
          AND NVL(DELETE_FLAG,2)=2;

Line: 951

       IF P_DeleteProcRec NOT IN(1, 2) THEN
          ERRBUF := FND_MESSAGE.GET_STRING('INV', 'INV_CCEOI_WRONG_DELETEREC');

Line: 961

       UPDATE mtl_cc_entries_interface
       SET
          LAST_UPDATE_DATE = SYSDATE,
          LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
          LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
          PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
          PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
          REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
          PROGRAM_UPDATE_DATE = sysdate
--          LOCK_FLAG = 1
       WHERE
          cc_entry_interface_group_id = P_CC_Interface_Group_ID
          AND NVL(lock_flag, 2) = 2
          AND NVL(PROCESS_FLAG, 1) = 1
          AND NVL(PROCESS_MODE, 3) IN(2, 3);

Line: 1009

		  L_iface_rec.last_update_date :=	c_rec.last_update_date      	 ;

Line: 1010

		  L_iface_rec.last_updated_by :=	c_rec.last_updated_by     	 ;

Line: 1013

		  L_iface_rec.last_update_login :=	c_rec.last_update_login     	 ;

Line: 1111

		  L_iface_rec.program_update_date :=	c_rec.program_update_date     	 ;

Line: 1116

		  L_iface_rec.delete_flag :=	c_rec.delete_flag     	 ;

Line: 1216

                UPDATE mtl_cc_entries_interface
                SET
                   LAST_UPDATE_DATE = SYSDATE,
                   LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
                   LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
                   PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
                   PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
                   REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
                   PROGRAM_UPDATE_DATE = SYSDATE
--                   LOCK_FLAG = 2
                WHERE
                   cc_entry_interface_group_id = P_CC_Interface_Group_Id;

Line: 1243

                UPDATE mtl_cc_entries_interface
                SET
                   LAST_UPDATE_DATE = SYSDATE,
                   LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
                   LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
                   PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
                   PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
                   REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
                   PROGRAM_UPDATE_DATE = SYSDATE
--                   LOCK_FLAG = 2
                WHERE
                   cc_entry_interface_group_id = P_CC_Interface_Group_ID;

Line: 1271

       UPDATE mtl_cc_entries_interface
       SET
          LAST_UPDATE_DATE = SYSDATE,
          LAST_UPDATED_BY = MTL_CCEOI_VAR_PVT.G_UserID,
          LAST_UPDATE_LOGIN = MTL_CCEOI_VAR_PVT.G_LoginID,
          PROGRAM_APPLICATION_ID = MTL_CCEOI_VAR_PVT.G_ProgramAppID,
          PROGRAM_ID = MTL_CCEOI_VAR_PVT.G_ProgramID,
          REQUEST_ID = MTL_CCEOI_VAR_PVT.G_RequestID,
          PROGRAM_UPDATE_DATE = SYSDATE
  --        LOCK_FLAG = 2
       WHERE
          cc_entry_interface_group_id = P_CC_Interface_Group_ID;

Line: 1288

         Update mtl_cycle_count_entries
         set export_flag = 2
         where cycle_count_entry_id
         in (select cycle_count_entry_id
            from mtl_cc_entries_interface where
            cc_entry_interface_group_id = P_CC_Interface_Group_ID
            and status_flag = 0 );

Line: 1300

FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Unexport Not updated ');

Line: 1302

       IF P_DeleteProcRec = 1 THEN
          -- DELETE completed interface records
          -- All records which are marked FOR deletion delete_flag =1
          -- OR status_flag IN (0,1) AND error_flag = 2 will be deleted
          Purge_CCEntriesIface(ERRBUF => ERRBUF, RETCODE => RETCODE);