APPS.PNT_LOCATION_FEATURES_PKG SQL Statements

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

Line: 12

PROCEDURE insert_row (
                 x_rowid                   IN OUT NOCOPY VARCHAR2
                ,x_org_id                  IN            NUMBER
                ,x_LOCATION_FEATURE_ID     IN OUT NOCOPY NUMBER
                ,x_LAST_UPDATE_DATE                      DATE
                ,x_LAST_UPDATED_BY                       NUMBER
                ,x_CREATION_DATE                         DATE
                ,x_CREATED_BY                            NUMBER
                ,x_LAST_UPDATE_LOGIN                     NUMBER
                ,x_LOCATION_ID                           NUMBER
                ,x_LOCATION_FEATURE_LOOKUP_CODE          VARCHAR2
                ,x_DESCRIPTION                           VARCHAR2
                ,x_QUANTITY                              NUMBER
                ,x_FEATURE_SIZE                          NUMBER
                ,x_UOM_CODE                              VARCHAR2
                ,x_CONDITION_LOOKUP_CODE                 VARCHAR2
                ,x_ATTRIBUTE_CATEGORY                    VARCHAR2
                ,x_ATTRIBUTE1                            VARCHAR2
                ,x_ATTRIBUTE2                            VARCHAR2
                ,x_ATTRIBUTE3                            VARCHAR2
                ,x_ATTRIBUTE4                            VARCHAR2
                ,x_ATTRIBUTE5                            VARCHAR2
                ,x_ATTRIBUTE6                            VARCHAR2
                ,x_ATTRIBUTE7                            VARCHAR2
                ,x_ATTRIBUTE8                            VARCHAR2
                ,x_ATTRIBUTE9                            VARCHAR2
                ,x_ATTRIBUTE10                           VARCHAR2
                ,x_ATTRIBUTE11                           VARCHAR2
                ,x_ATTRIBUTE12                           VARCHAR2
                ,x_ATTRIBUTE13                           VARCHAR2
                ,x_ATTRIBUTE14                           VARCHAR2
                ,x_ATTRIBUTE15                           VARCHAR2
)
IS
  CURSOR C IS
    SELECT rowid
    FROM   PN_LOCATION_FEATURES_ALL
    WHERE  LOCATION_FEATURE_ID = x_location_feature_id;

Line: 52

     SELECT org_id FROM pn_locations_all WHERE location_id = x_LOCATION_ID AND ROWNUM = 1;

Line: 58

   PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.insert_row (+)');

Line: 63

   SELECT pn_location_features_s.nextval
   INTO   x_location_feature_id
   FROM   dual;

Line: 75

   INSERT INTO PN_LOCATION_FEATURES_ALL
   (
       LOCATION_FEATURE_ID
      ,org_id
      ,LAST_UPDATE_DATE
      ,LAST_UPDATED_BY
      ,CREATION_DATE
      ,CREATED_BY
      ,LAST_UPDATE_LOGIN
      ,LOCATION_ID
      ,LOCATION_FEATURE_LOOKUP_CODE
      ,DESCRIPTION
      ,QUANTITY
      ,FEATURE_SIZE
      ,UOM_CODE
      ,CONDITION_LOOKUP_CODE
      ,ATTRIBUTE_CATEGORY
      ,ATTRIBUTE1
      ,ATTRIBUTE2
      ,ATTRIBUTE3
      ,ATTRIBUTE4
      ,ATTRIBUTE5
      ,ATTRIBUTE6
      ,ATTRIBUTE7
      ,ATTRIBUTE8
      ,ATTRIBUTE9
      ,ATTRIBUTE10
      ,ATTRIBUTE11
      ,ATTRIBUTE12
      ,ATTRIBUTE13
      ,ATTRIBUTE14
      ,ATTRIBUTE15
   )
   VALUES
   (
       x_LOCATION_FEATURE_ID
      ,l_org_id
      ,x_LAST_UPDATE_DATE
      ,x_LAST_UPDATED_BY
      ,x_CREATION_DATE
      ,x_CREATED_BY
      ,x_LAST_UPDATE_LOGIN
      ,x_LOCATION_ID
      ,x_LOCATION_FEATURE_LOOKUP_CODE
      ,x_DESCRIPTION
      ,x_QUANTITY
      ,x_FEATURE_SIZE
      ,x_UOM_CODE
      ,x_CONDITION_LOOKUP_CODE
      ,x_ATTRIBUTE_CATEGORY
      ,x_ATTRIBUTE1
      ,x_ATTRIBUTE2
      ,x_ATTRIBUTE3
      ,x_ATTRIBUTE4
      ,x_ATTRIBUTE5
      ,x_ATTRIBUTE6
      ,x_ATTRIBUTE7
      ,x_ATTRIBUTE8
      ,x_ATTRIBUTE9
      ,x_ATTRIBUTE10
      ,x_ATTRIBUTE11
      ,x_ATTRIBUTE12
      ,x_ATTRIBUTE13
      ,x_ATTRIBUTE14
      ,x_ATTRIBUTE15
   );

Line: 149

   PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.insert_row (-)');

Line: 151

END insert_row;

Line: 161

PROCEDURE UPDATE_ROW (
                        x_rowid                          VARCHAR2
                       ,x_LOCATION_FEATURE_ID            NUMBER
                       ,x_LAST_UPDATE_DATE               DATE
                       ,x_LAST_UPDATED_BY                NUMBER
                       ,x_CREATION_DATE                  DATE
                       ,x_CREATED_BY                     NUMBER
                       ,x_LAST_UPDATE_LOGIN              NUMBER
                       ,x_LOCATION_ID                    NUMBER
                       ,x_LOCATION_FEATURE_LOOKUP_CODE   VARCHAR2
                       ,x_DESCRIPTION                    VARCHAR2
                       ,x_QUANTITY                       NUMBER
                       ,x_FEATURE_SIZE                   NUMBER
                       ,x_UOM_CODE                       VARCHAR2
                       ,x_CONDITION_LOOKUP_CODE          VARCHAR2
                       ,x_ATTRIBUTE_CATEGORY             VARCHAR2
                       ,x_ATTRIBUTE1                     VARCHAR2
                       ,x_ATTRIBUTE2                     VARCHAR2
                       ,x_ATTRIBUTE3                     VARCHAR2
                       ,x_ATTRIBUTE4                     VARCHAR2
                       ,x_ATTRIBUTE5                     VARCHAR2
                       ,x_ATTRIBUTE6                     VARCHAR2
                       ,x_ATTRIBUTE7                     VARCHAR2
                       ,x_ATTRIBUTE8                     VARCHAR2
                       ,x_ATTRIBUTE9                     VARCHAR2
                       ,x_ATTRIBUTE10                    VARCHAR2
                       ,x_ATTRIBUTE11                    VARCHAR2
                       ,x_ATTRIBUTE12                    VARCHAR2
                       ,x_ATTRIBUTE13                    VARCHAR2
                       ,x_ATTRIBUTE14                    VARCHAR2
                       ,x_ATTRIBUTE15                    VARCHAR2
                     ) IS
BEGIN

  PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.update_row (+)');

Line: 196

  UPDATE PN_LOCATION_FEATURES_ALL
  SET
         LOCATION_FEATURE_ID      =     x_LOCATION_FEATURE_ID
        ,LAST_UPDATE_DATE         =     x_LAST_UPDATE_DATE
        ,LAST_UPDATED_BY          =     x_LAST_UPDATED_BY
        ,CREATION_DATE            =     x_CREATION_DATE
        ,CREATED_BY               =     x_CREATED_BY
        ,LAST_UPDATE_LOGIN        =     x_LAST_UPDATE_LOGIN
        ,LOCATION_ID              =     x_LOCATION_ID
        ,LOCATION_FEATURE_LOOKUP_CODE=  x_LOCATION_FEATURE_LOOKUP_CODE
        ,DESCRIPTION              =     x_DESCRIPTION
        ,QUANTITY                 =     x_QUANTITY
        ,FEATURE_SIZE             =     x_FEATURE_SIZE
        ,UOM_CODE                 =     x_UOM_CODE
        ,CONDITION_LOOKUP_CODE    =     x_CONDITION_LOOKUP_CODE
        ,ATTRIBUTE_CATEGORY       =     x_ATTRIBUTE_CATEGORY
        ,ATTRIBUTE1               =     x_ATTRIBUTE1
        ,ATTRIBUTE2               =     x_ATTRIBUTE2
        ,ATTRIBUTE3               =     x_ATTRIBUTE3
        ,ATTRIBUTE4               =     x_ATTRIBUTE4
        ,ATTRIBUTE5               =     x_ATTRIBUTE5
        ,ATTRIBUTE6               =     x_ATTRIBUTE6
        ,ATTRIBUTE7               =     x_ATTRIBUTE7
        ,ATTRIBUTE8               =     x_ATTRIBUTE8
        ,ATTRIBUTE9               =     x_ATTRIBUTE9
        ,ATTRIBUTE10              =     x_ATTRIBUTE10
        ,ATTRIBUTE11              =     x_ATTRIBUTE11
        ,ATTRIBUTE12              =     x_ATTRIBUTE12
        ,ATTRIBUTE13              =     x_ATTRIBUTE13
        ,ATTRIBUTE14              =     x_ATTRIBUTE14
        ,ATTRIBUTE15              =     x_ATTRIBUTE15
  WHERE LOCATION_FEATURE_ID       =     x_LOCATION_FEATURE_ID;

Line: 233

  PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.update_row (-)');

Line: 234

END UPDATE_ROW;

Line: 272

     SELECT *
     FROM   PN_LOCATION_FEATURES_ALL
     WHERE  LOCATION_FEATURE_ID = x_LOCATION_FEATURE_ID
     FOR    UPDATE OF LOCATION_FEATURE_ID NOWAIT;

Line: 286

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 422

PROCEDURE delete_row   (
                                        x_location_feature_id                     NUMBER
                                        ) IS
BEGIN

   PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.delete_row (+)');

Line: 428

   DELETE FROM PN_LOCATION_FEATURES_ALL
   WHERE   location_feature_id = x_location_feature_id;

Line: 435

   PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.delete_row (-)');

Line: 436

END delete_row;