eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_AUTO_ALLOC_BATCH_PKG SQL Statements

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

Line: 6


Procedure Insert_Allocation_Batch(
  l_Row_Id                      IN OUT NOCOPY VARCHAR2
, l_ALLOCATION_SET_ID           IN NUMBER
, l_BATCH_ID                    IN NUMBER
, l_BATCH_TYPE_CODE             IN VARCHAR2
, l_LAST_UPDATE_DATE            IN DATE
, l_LAST_UPDATED_BY             IN NUMBER
, l_LAST_UPDATE_LOGIN           IN NUMBER
, l_CREATION_DATE               IN DATE
, l_CREATED_BY                  IN NUMBER
, l_STEP_NUMBER                 IN NUMBER
, l_OWNER                       IN VARCHAR2
, l_ALLOCATION_METHOD_CODE      IN VARCHAR2
, l_ATTRIBUTE1                  IN VARCHAR2
, l_ATTRIBUTE2                  IN VARCHAR2
, l_ATTRIBUTE3                  IN VARCHAR2
, l_ATTRIBUTE4                  IN VARCHAR2
, l_ATTRIBUTE5                  IN VARCHAR2
, l_ATTRIBUTE6                  IN VARCHAR2
, l_ATTRIBUTE7                  IN VARCHAR2
, l_ATTRIBUTE8                  IN VARCHAR2
, l_ATTRIBUTE9                  IN VARCHAR2
, l_ATTRIBUTE10                 IN VARCHAR2
, l_ATTRIBUTE11                 IN VARCHAR2
, l_ATTRIBUTE12                 IN VARCHAR2
, l_ATTRIBUTE13                 IN VARCHAR2
, l_ATTRIBUTE14                 IN VARCHAR2
, l_ATTRIBUTE15                 IN VARCHAR2
, l_CONTEXT                     IN VARCHAR2
)  IS

   CURSOR C IS
   SELECT rowid
   FROM  GL_AUTO_ALLOC_BATCHES
   WHERE ALLOCATION_SET_ID = l_ALLOCATION_SET_ID
   AND   BATCH_ID          = l_BATCH_ID
   And   BATCH_TYPE_CODE   = l_BATCH_TYPE_CODE;

Line: 45


  Insert Into GL_AUTO_ALLOC_BATCHES
  (
  ALLOCATION_SET_ID
, BATCH_ID
, BATCH_TYPE_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, STEP_NUMBER
, OWNER
, ALLOCATION_METHOD_CODE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
)
Values(
  l_ALLOCATION_SET_ID
, l_BATCH_ID
, l_BATCH_TYPE_CODE
, l_LAST_UPDATE_DATE
, l_LAST_UPDATED_BY
, l_LAST_UPDATE_LOGIN
, l_CREATION_DATE
, l_CREATED_BY
, l_STEP_NUMBER
, l_OWNER
, l_ALLOCATION_METHOD_CODE
, l_ATTRIBUTE1
, l_ATTRIBUTE2
, l_ATTRIBUTE3
, l_ATTRIBUTE4
, l_ATTRIBUTE5
, l_ATTRIBUTE6
, l_ATTRIBUTE7
, l_ATTRIBUTE8
, l_ATTRIBUTE9
, l_ATTRIBUTE10
, l_ATTRIBUTE11
, l_ATTRIBUTE12
, l_ATTRIBUTE13
, l_ATTRIBUTE14
, l_ATTRIBUTE15
, l_CONTEXT
 );

Line: 111


End Insert_Allocation_Batch;

Line: 113


Procedure Update_Allocation_Batch(
  l_Row_Id                      IN VARCHAR2
, l_BATCH_ID                    IN NUMBER
, l_BATCH_TYPE_CODE             IN VARCHAR2
, l_LAST_UPDATE_DATE            IN DATE
, l_LAST_UPDATED_BY             IN NUMBER
, l_LAST_UPDATE_LOGIN           IN NUMBER
, l_STEP_NUMBER                 IN NUMBER
, l_OWNER                       IN VARCHAR2
, l_ALLOCATION_METHOD_CODE      IN VARCHAR2
, l_ATTRIBUTE1                  IN VARCHAR2
, l_ATTRIBUTE2                  IN VARCHAR2
, l_ATTRIBUTE3                  IN VARCHAR2
, l_ATTRIBUTE4                  IN VARCHAR2
, l_ATTRIBUTE5                  IN VARCHAR2
, l_ATTRIBUTE6                  IN VARCHAR2
, l_ATTRIBUTE7                  IN VARCHAR2
, l_ATTRIBUTE8                  IN VARCHAR2
, l_ATTRIBUTE9                  IN VARCHAR2
, l_ATTRIBUTE10                 IN VARCHAR2
, l_ATTRIBUTE11                 IN VARCHAR2
, l_ATTRIBUTE12                 IN VARCHAR2
, l_ATTRIBUTE13                 IN VARCHAR2
, l_ATTRIBUTE14                 IN VARCHAR2
, l_ATTRIBUTE15                 IN VARCHAR2
, l_CONTEXT                     IN VARCHAR2
) IS
Begin
  Update GL_AUTO_ALLOC_BATCHES
  Set
   Batch_id = l_BATCH_ID
 , BATCH_TYPE_CODE = l_BATCH_TYPE_CODE
 , STEP_NUMBER     = l_STEP_NUMBER
 , OWNER           = l_OWNER
 , ALLOCATION_METHOD_CODE = l_ALLOCATION_METHOD_CODE
 , LAST_UPDATE_DATE  = l_LAST_UPDATE_DATE
 , LAST_UPDATED_BY  = l_LAST_UPDATED_BY
 , LAST_UPDATE_LOGIN = l_LAST_UPDATE_LOGIN
 , ATTRIBUTE1 = l_ATTRIBUTE1
 , ATTRIBUTE2 = l_ATTRIBUTE2
 , ATTRIBUTE3 = l_ATTRIBUTE3
 , ATTRIBUTE4 = l_ATTRIBUTE4
 , ATTRIBUTE5 = l_ATTRIBUTE5
 , ATTRIBUTE6 = l_ATTRIBUTE6
 , ATTRIBUTE7 = l_ATTRIBUTE7
 , ATTRIBUTE8 = l_ATTRIBUTE8
 , ATTRIBUTE9 = l_ATTRIBUTE9
 , ATTRIBUTE10 = l_ATTRIBUTE10
 , ATTRIBUTE11 = l_ATTRIBUTE11
 , ATTRIBUTE12 = l_ATTRIBUTE12
 , ATTRIBUTE13 = l_ATTRIBUTE13
 , ATTRIBUTE14 = l_ATTRIBUTE14
 , ATTRIBUTE15 = l_ATTRIBUTE15
 , CONTEXT     = l_CONTEXT
   Where rowid = l_row_id;

Line: 169


End Update_Allocation_batch;

Line: 172


Procedure Delete_Allocation_batch(
  l_Row_id                  IN VARCHAR2
 ) Is
Begin
  Delete From GL_AUTO_ALLOC_BATCHES
  Where RowId = l_Row_id;

Line: 181


End Delete_Allocation_batch;

Line: 190


, l_LAST_UPDATED_BY             IN NUMBER
, l_LAST_UPDATE_LOGIN           IN NUMBER
, l_STEP_NUMBER                 IN NUMBER
, l_OWNER                       IN VARCHAR2
, l_ALLOCATION_METHOD_CODE      IN VARCHAR2
, l_ATTRIBUTE1                  IN VARCHAR2
, l_ATTRIBUTE2                  IN VARCHAR2
, l_ATTRIBUTE3                  IN VARCHAR2
, l_ATTRIBUTE4                  IN VARCHAR2
, l_ATTRIBUTE5                  IN VARCHAR2
, l_ATTRIBUTE6                  IN VARCHAR2
, l_ATTRIBUTE7                  IN VARCHAR2
, l_ATTRIBUTE8                  IN VARCHAR2
, l_ATTRIBUTE9                  IN VARCHAR2
, l_ATTRIBUTE10                 IN VARCHAR2
, l_ATTRIBUTE11                 IN VARCHAR2
, l_ATTRIBUTE12                 IN VARCHAR2
, l_ATTRIBUTE13                 IN VARCHAR2
, l_ATTRIBUTE14                 IN VARCHAR2
, l_ATTRIBUTE15                 IN VARCHAR2
, l_CONTEXT                     IN VARCHAR2
 ) IS
 CURSOR C IS
        SELECT *
        FROM   GL_AUTO_ALLOC_BATCHES
        WHERE  rowid = l_ROW_ID
        FOR UPDATE NOWAIT;

Line: 225


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

Line: 306


      Select 'Duplicate'
      From   gl_auto_alloc_batches r
      Where  r.step_number = l_step_number
      And    r.allocation_set_id = l_allocation_set_id
      And    ( l_rowid is NULL
               OR
               r.rowid <> l_rowid );

Line: 347


      Select 'Duplicate'
      From   gl_auto_alloc_batches r
      Where  r.allocation_set_id = l_allocation_set_id
      And    r.Batch_Id          = l_Batch_Id
      And    r.Batch_Type_Code   = l_Batch_Type_Code
      And    ( l_rowid is NULL
               OR
               r.rowid <> l_rowid );

Line: 391


 Select Batch_Type_Code
 From   GL_AUTO_ALLOC_BATCH_HISTORY
 Where  REQUEST_ID = p_request_Id
 AND    STEP_NUMBER = p_step_number;

Line: 450


 Select Status_Code
 From GL_AUTO_ALLOC_BATCH_HISTORY
 Where REQUEST_ID = p_request_Id
 AND   STEP_NUMBER = p_step_number;

Line: 456


 Select
  Meaning
 ,Description
 From gl_lookups
 Where LOOKUP_TYPE = 'AUTOALLOCATION_STATUS'
 And LOOKUP_CODE = l_lookup_code;

Line: 464


  Select request_id
  From GL_AUTO_ALLOC_BAT_HIST_DET
  Where PARENT_REQUEST_ID = p_request_Id
  And STEP_NUMBER = p_step_number
  order by request_id desc;