APPS.CN_PREPOSTBATCHES SQL Statements

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

Line: 7

G_LAST_UPDATE_DATE        DATE         := SYSDATE;

Line: 8

G_LAST_UPDATED_BY         NUMBER       := FND_GLOBAL.USER_ID;

Line: 11

G_LAST_UPDATE_LOGIN       NUMBER       := FND_GLOBAL.LOGIN_ID;

Line: 16

      SELECT cn_posting_batches_s.nextval
      FROM   dual;

Line: 24

PROCEDURE Insert_Record
(   x_rowid                          IN OUT NOCOPY VARCHAR2,
    x_posting_batch_id                      NUMBER,
    x_name                                  VARCHAR2,
    x_start_date                            DATE    ,
    x_end_date                              DATE    ,
    x_load_status                           VARCHAR2    := C_UNLOADED,
    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,
    x_last_update_date                      DATE    ,
    x_last_updated_by                       NUMBER  ,
    x_last_update_login                     NUMBER  ,
    x_creation_date                         DATE        := G_CREATION_DATE,
    x_created_by                            NUMBER      := G_CREATED_BY,
    p_org_id                                NUMBER
  )
IS
      l_api_name                  CONSTANT VARCHAR2(30)      := 'Insert_Record';

Line: 57

   INSERT INTO cn_posting_batches(
      posting_batch_id,
      name,
      start_date,
      end_date,
      load_status,
      attribute_category,
      attribute1      ,
      attribute2      ,
      attribute3      ,
      attribute4      ,
      attribute5      ,
      attribute6      ,
      attribute7      ,
      attribute8      ,
      attribute9      ,
      attribute10      ,
      attribute11      ,
      attribute12      ,
      attribute13      ,
      attribute14      ,
      attribute15      ,
      last_update_date,
      last_updated_by,
      last_update_login,
      creation_date,
      created_by,
      org_id
      )
   VALUES(
      x_posting_batch_id,
      x_name,
      x_start_date,
      x_end_date,
      x_load_status,
      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_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_creation_date,
      x_created_by,
      p_org_id
      );

Line: 115

END Insert_Record;

Line: 130

      IF x_operation = 'INSERT' THEN

         Insert_Record(
          x_rowid,
          x_posting_batch_rec.posting_batch_id,
          x_posting_batch_rec.name,
          x_posting_batch_rec.start_date,
          x_posting_batch_rec.end_date,
          C_UNLOADED,
          x_posting_batch_rec.attribute_category,
          x_posting_batch_rec.attribute1      ,
          x_posting_batch_rec.attribute2      ,
          x_posting_batch_rec.attribute3      ,
          x_posting_batch_rec.attribute4      ,
          x_posting_batch_rec.attribute5      ,
          x_posting_batch_rec.attribute6      ,
          x_posting_batch_rec.attribute7      ,
          x_posting_batch_rec.attribute8      ,
          x_posting_batch_rec.attribute9      ,
          x_posting_batch_rec.attribute10      ,
          x_posting_batch_rec.attribute11      ,
          x_posting_batch_rec.attribute12      ,
          x_posting_batch_rec.attribute13      ,
          x_posting_batch_rec.attribute14      ,
          x_posting_batch_rec.attribute15      ,
          x_posting_batch_rec.last_update_date,
          x_posting_batch_rec.last_updated_by,
          x_posting_batch_rec.last_update_login,
          x_posting_batch_rec.creation_date,
          x_posting_batch_rec.created_by,
          p_org_id
         );