APPS.CSP_STOCK_LISTS_PVT SQL Statements

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

Line: 18

                           ,p_LAST_UPDATED_BY    NUMBER
                           ,p_LAST_UPDATE_DATE    DATE
                           ,p_LAST_UPDATE_LOGIN    NUMBER
                           ,x_return_status out NOCOPY VARCHAR2) AS
  CURSOR get_items  IS
        SELECT *
        FROM   csp_stock_lists
        where  INVENTORY_ITEM_ID = p_inventory_item_id
        and    ORGANIZATION_ID = p_organization_id
        and    nvl(SUBINVENTORY_CODE,'X') = nvl(p_subinventory_code,'X');

Line: 34

         CSP_STOCK_LISTS_PKG.update_Row(p_ORGANIZATION_ID
                                         ,p_INVENTORY_ITEM_ID
                                         ,p_SUBINVENTORY_CODE
                                         ,p_MANUAL_AUTO
                                         ,p_REASON_CODE
                                         ,p_CREATED_BY
                                         ,p_CREATION_DATE
                                         ,p_LAST_UPDATED_BY
                                         ,p_LAST_UPDATE_DATE
                                         ,p_LAST_UPDATE_LOGIN);

Line: 45

           CSP_STOCK_LISTS_PKG.Insert_Row( p_ORGANIZATION_ID
                                           ,p_INVENTORY_ITEM_ID
                                           ,p_SUBINVENTORY_CODE
                                           ,p_MANUAL_AUTO
                                           ,p_REASON_CODE
                                           ,p_CREATED_BY
                                           ,p_CREATION_DATE
                                           ,p_LAST_UPDATED_BY
                                           ,p_LAST_UPDATE_DATE
                                           ,p_LAST_UPDATE_LOGIN);

Line: 66

          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_CREATION_DATE    DATE,
          p_CREATED_BY    NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_PRIMARY_SUBINVENTORY_FLAG    NUMBER,
          p_PICKING_ORDER    NUMBER,
          p_MIN_MINMAX_QUANTITY    NUMBER,
          p_MAX_MINMAX_QUANTITY    NUMBER,
          p_INVENTORY_PLANNING_CODE    NUMBER,
          p_FIXED_LOT_MULTIPLE    NUMBER,
          p_MINIMUM_ORDER_QUANTITY    NUMBER,
          p_MAXIMUM_ORDER_QUANTITY    NUMBER,
          p_SOURCE_TYPE    NUMBER,
          p_SOURCE_ORGANIZATION_ID    NUMBER,
          p_SOURCE_SUBINVENTORY    VARCHAR2,
          p_ATTRIBUTE_CATEGORY    VARCHAR2,
          p_ATTRIBUTE1    VARCHAR2,
          p_ATTRIBUTE2    VARCHAR2,
          p_ATTRIBUTE3    VARCHAR2,
          p_ATTRIBUTE4    VARCHAR2,
          p_ATTRIBUTE5    VARCHAR2,
          p_ATTRIBUTE6    VARCHAR2,
          p_ATTRIBUTE7    VARCHAR2,
          p_ATTRIBUTE8    VARCHAR2,
          p_ATTRIBUTE9    VARCHAR2,
          p_ATTRIBUTE10    VARCHAR2,
          p_ATTRIBUTE11    VARCHAR2,
          p_ATTRIBUTE12    VARCHAR2,
          p_ATTRIBUTE13    VARCHAR2,
          p_ATTRIBUTE14    VARCHAR2,
          p_ATTRIBUTE15    VARCHAR2,
          p_ENCUMBRANCE_ACCOUNT    NUMBER,
          p_PREPROCESSING_LEAD_TIME    NUMBER,
          p_PROCESSING_LEAD_TIME    NUMBER,
          p_POSTPROCESSING_LEAD_TIME    NUMBER
          ,x_return_status out NOCOPY VARCHAR2) AS

      CURSOR get_subinv_items  IS
        SELECT *
        FROM   MTL_ITEM_SUB_INVENTORIES
        where  INVENTORY_ITEM_ID = p_inventory_item_id
        and    ORGANIZATION_ID = p_organization_id
        and    SECONDARY_INVENTORY = p_secondary_inventory;

Line: 118

          CSP_ITEM_SUB_INVENTORIES_PKG.Update_Row(
              p_ROWID  ,
              l_item_id    ,
              p_ORGANIZATION_ID    ,
              p_SECONDARY_INVENTORY    ,
              p_LAST_UPDATE_DATE    ,
              p_LAST_UPDATED_BY    ,
              p_CREATION_DATE    ,
              p_CREATED_BY    ,
              p_LAST_UPDATE_LOGIN    ,
              p_PRIMARY_SUBINVENTORY_FLAG    ,
              p_PICKING_ORDER    ,
              p_MIN_MINMAX_QUANTITY    ,
              p_MAX_MINMAX_QUANTITY    ,
              p_INVENTORY_PLANNING_CODE    ,
              p_FIXED_LOT_MULTIPLE    ,
              p_MINIMUM_ORDER_QUANTITY    ,
              p_MAXIMUM_ORDER_QUANTITY    ,
              p_SOURCE_TYPE    ,
              p_SOURCE_ORGANIZATION_ID    ,
              p_SOURCE_SUBINVENTORY    ,
              p_ATTRIBUTE_CATEGORY    ,
              p_ATTRIBUTE1    ,
              p_ATTRIBUTE2    ,
              p_ATTRIBUTE3    ,
              p_ATTRIBUTE4    ,
              p_ATTRIBUTE5    ,
              p_ATTRIBUTE6    ,
              p_ATTRIBUTE7    ,
              p_ATTRIBUTE8    ,
              p_ATTRIBUTE9    ,
              p_ATTRIBUTE10    ,
              p_ATTRIBUTE11    ,
              p_ATTRIBUTE12    ,
              p_ATTRIBUTE13    ,
              p_ATTRIBUTE14    ,
              p_ATTRIBUTE15    ,
              p_ENCUMBRANCE_ACCOUNT    ,
              p_PREPROCESSING_LEAD_TIME    ,
              p_PROCESSING_LEAD_TIME    ,
              p_POSTPROCESSING_LEAD_TIME    );

Line: 160

                CSP_ITEM_SUB_INVENTORIES_PKG.Insert_Row(
                  l_item_id   ,
                  p_ORGANIZATION_ID    ,
                  p_SECONDARY_INVENTORY    ,
                  p_LAST_UPDATE_DATE    ,
                  p_LAST_UPDATED_BY    ,
                  p_CREATION_DATE    ,
                  p_CREATED_BY    ,
                  p_LAST_UPDATE_LOGIN    ,
                  p_PRIMARY_SUBINVENTORY_FLAG    ,
                  p_PICKING_ORDER    ,
                  p_MIN_MINMAX_QUANTITY    ,
                  p_MAX_MINMAX_QUANTITY    ,
                  p_INVENTORY_PLANNING_CODE    ,
                  p_FIXED_LOT_MULTIPLE    ,
                  p_MINIMUM_ORDER_QUANTITY    ,
                  p_MAXIMUM_ORDER_QUANTITY    ,
                  p_SOURCE_TYPE    ,
                  p_SOURCE_ORGANIZATION_ID    ,
                  p_SOURCE_SUBINVENTORY    ,
                  p_ATTRIBUTE_CATEGORY    ,
                  p_ATTRIBUTE1    ,
                  p_ATTRIBUTE2    ,
                  p_ATTRIBUTE3    ,
                  p_ATTRIBUTE4    ,
                  p_ATTRIBUTE5    ,
                  p_ATTRIBUTE6    ,
                  p_ATTRIBUTE7    ,
                  p_ATTRIBUTE8    ,
                  p_ATTRIBUTE9    ,
                  p_ATTRIBUTE10    ,
                  p_ATTRIBUTE11    ,
                  p_ATTRIBUTE12    ,
                  p_ATTRIBUTE13    ,
                  p_ATTRIBUTE14    ,
                  p_ATTRIBUTE15    ,
                  p_ENCUMBRANCE_ACCOUNT    ,
                  p_PREPROCESSING_LEAD_TIME    ,
                  p_PROCESSING_LEAD_TIME    ,
                  p_POSTPROCESSING_LEAD_TIME);

Line: 202

   PROCEDURE DELETE_STOCK_LIST(
                      P_INVENTORY_ITEM_ID  NUMBER
                     ,p_ORGANIZATION_ID    NUMBER
                     ,P_SUBINVENTORY_CODE    VARCHAR2
                     ,X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
   ln_count NUMBER :=0;

Line: 209

         SELECT count(*) into ln_count
         FROM CSP_STOCK_LISTS
         WHERE INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID
         AND ORGANIZATION_ID = P_ORGANIZATION_ID
         AND nvl(SUBINVENTORY_CODE,'X') = nvl(P_SUBINVENTORY_CODE,'X');

Line: 215

          CSP_STOCK_LISTS_PKG.DELETE_ROW(p_INVENTORY_ITEM_ID,p_ORGANIZATION_ID,P_SUBINVENTORY_CODE  );