APPS.PN_LOC_ACC_MAP_HDR_PKG SQL Statements

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

Line: 11

PROCEDURE insert_row (
x_LOC_ACC_MAP_HDR_ID        IN OUT NOCOPY  NUMBER,
x_MAPPING_NAME              IN             VARCHAR2,
x_last_update_date          IN             DATE,
x_last_updated_by           IN             NUMBER,
x_creation_date             IN             DATE,
x_created_by                IN             NUMBER,
x_last_update_login         IN             NUMBER,
x_attribute_category        IN             VARCHAR2,
x_attribute1                IN             VARCHAR2,
x_attribute2                IN             VARCHAR2,
x_attribute3                IN             VARCHAR2,
x_attribute4                IN             VARCHAR2,
x_attribute5                IN             VARCHAR2,
x_attribute6                IN             VARCHAR2,
x_attribute7                IN             VARCHAR2,
x_attribute8                IN             VARCHAR2,
x_attribute9                IN             VARCHAR2,
x_attribute10               IN             VARCHAR2,
x_attribute11               IN             VARCHAR2,
x_attribute12               IN             VARCHAR2,
x_attribute13               IN             VARCHAR2,
x_attribute14               IN             VARCHAR2,
x_attribute15               IN             VARCHAR2,
x_ORG_ID                    IN             NUMBER  default NULL
) IS
      CURSOR C IS
      SELECT LOC_ACC_MAP_HDR_ID
      FROM PN_LOC_ACC_MAP_HDR_ALL                                       --sdm_MOAC
      WHERE LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID;

Line: 43

  INSERT INTO PN_LOC_ACC_MAP_HDR_ALL                                    --sdm_MOAC
  (LOC_ACC_MAP_HDR_ID,
       MAPPING_NAME,
       last_update_date,
       last_updated_by,
       creation_date,
       created_by,
       last_update_login,
       attribute_category,
       attribute1,
       attribute2,
       attribute3,
       attribute4,
       attribute5,
       attribute6,
       attribute7,
       attribute8,
       attribute9,
       attribute10,
       attribute11,
       attribute12,
       attribute13,
       attribute14,
       attribute15,
       ORG_ID)
  VALUES (NVL(x_LOC_ACC_MAP_HDR_ID,PN_LOC_ACC_MAP_HDR_S.NEXTVAL),
      x_MAPPING_NAME,
      x_last_update_date,
      x_last_updated_by,
      x_creation_date,
      x_created_by,
      x_last_update_login,
      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,
      x_org_id
      )
  RETURNING  LOC_ACC_MAP_HDR_ID INTO x_LOC_ACC_MAP_HDR_ID;

Line: 104

END insert_row;

Line: 114

PROCEDURE update_row (
x_LOC_ACC_MAP_HDR_ID        IN             NUMBER,
x_MAPPING_NAME              IN             VARCHAR2,
x_last_update_date          IN             DATE,
x_last_updated_by           IN             NUMBER,
x_last_update_login         IN             NUMBER,
x_attribute_category        IN             VARCHAR2,
x_attribute1                IN             VARCHAR2,
x_attribute2                IN             VARCHAR2,
x_attribute3                IN             VARCHAR2,
x_attribute4                IN             VARCHAR2,
x_attribute5                IN             VARCHAR2,
x_attribute6                IN             VARCHAR2,
x_attribute7                IN             VARCHAR2,
x_attribute8                IN             VARCHAR2,
x_attribute9                IN             VARCHAR2,
x_attribute10               IN             VARCHAR2,
x_attribute11               IN             VARCHAR2,
x_attribute12               IN             VARCHAR2,
x_attribute13               IN             VARCHAR2,
x_attribute14               IN             VARCHAR2,
x_attribute15               IN             VARCHAR2
) IS
BEGIN
  UPDATE PN_LOC_ACC_MAP_HDR_ALL                                 --sdm_MOAC
  SET   last_update_date = x_last_update_date,
    last_updated_by = x_last_updated_by,
    last_update_login = x_last_update_login,
    MAPPING_NAME = x_MAPPING_NAME,
    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 LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID;

Line: 162

END update_row;

Line: 193

         SELECT    *
         FROM PN_LOC_ACC_MAP_HDR_ALL                                    --sdm_MOAC
         WHERE LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID
         FOR UPDATE OF LOC_ACC_MAP_HDR_ID NOWAIT;

Line: 289

PROCEDURE delete_row (
  x_LOC_ACC_MAP_HDR_ID     IN    NUMBER
) IS
BEGIN
  DELETE FROM PN_LOC_ACC_MAP_HDR_ALL                                    --sdm_MOAC
            WHERE LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID;

Line: 299

END delete_row;