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_SET_PKG SQL Statements

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

Line: 8


      SELECT gl_auto_alloc_sets_s.NEXTVAL
      FROM dual;

Line: 36


Procedure Insert_Allocation_Set(
 l_Row_Id            IN OUT NOCOPY VARCHAR2
, l_ALLOCATION_SET_ID           IN NUMBER
, l_ALLOCATION_SET_TYPE_CODE    IN VARCHAR2
, l_ALLOCATION_SET_NAME         IN VARCHAR2
, l_ALLOCATION_CODE             IN VARCHAR2
, l_CHART_OF_ACCOUNTS_ID        IN NUMBER
, l_PERIOD_SET_NAME             IN VARCHAR
, l_ACCOUNTED_PERIOD_TYPE       IN VARCHAR
, 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_ORG_ID                      IN NUMBER
, l_DESCRIPTION                 IN VARCHAR2
, l_OWNER                       IN VARCHAR2
, l_SECURITY_FLAG               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_SET IS
   SELECT rowid
   FROM GL_AUTO_ALLOC_SETS
   WHERE ALLOCATION_SET_ID = l_ALLOCATION_SET_ID;

Line: 77


 Insert Into GL_AUTO_ALLOC_SETS (
  ALLOCATION_SET_ID
, ALLOCATION_SET_TYPE_CODE
, ALLOCATION_SET_NAME
, ALLOCATION_CODE
, CHART_OF_ACCOUNTS_ID
, PERIOD_SET_NAME
, ACCOUNTED_PERIOD_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ORG_ID
, DESCRIPTION
, OWNER
, SECURITY_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
)
Values(
  l_ALLOCATION_SET_ID
, l_ALLOCATION_SET_TYPE_CODE
, l_ALLOCATION_SET_NAME
, l_ALLOCATION_CODE
, l_CHART_OF_ACCOUNTS_ID
, l_PERIOD_SET_NAME
, l_ACCOUNTED_PERIOD_TYPE
, l_LAST_UPDATE_DATE
, l_LAST_UPDATED_BY
, l_LAST_UPDATE_LOGIN
, l_CREATION_DATE
, l_CREATED_BY
, l_ORG_ID
, l_DESCRIPTION
, l_OWNER
, l_SECURITY_FLAG
, 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: 153


End Insert_Allocation_Set;

Line: 155


Procedure Update_Allocation_Set(
 l_Row_Id                      IN VARCHAR2
, l_ALLOCATION_SET_NAME         IN VARCHAR2
, l_LAST_UPDATE_DATE            IN DATE
, l_LAST_UPDATED_BY             IN NUMBER
, l_LAST_UPDATE_LOGIN           IN NUMBER
, l_DESCRIPTION                 IN VARCHAR2
, l_OWNER                       IN VARCHAR2
, l_SECURITY_FLAG               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_SETS
  SET
   ALLOCATION_SET_NAME      = l_ALLOCATION_SET_NAME
 , LAST_UPDATE_DATE         = l_LAST_UPDATE_DATE
 , LAST_UPDATED_BY          = l_LAST_UPDATED_BY
 , LAST_UPDATE_LOGIN        = l_LAST_UPDATE_LOGIN
 , DESCRIPTION              = l_DESCRIPTION
 , OWNER                    = l_OWNER
 , SECURITY_FLAG            = l_SECURITY_FLAG
 , 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: 209


End Update_Allocation_Set;

Line: 220


, l_LAST_UPDATED_BY             IN NUMBER
, l_LAST_UPDATE_LOGIN           IN NUMBER
, l_CREATED_BY                  IN NUMBER
, l_DESCRIPTION                 IN VARCHAR2
, l_OWNER                       IN VARCHAR2
, l_SECURITY_FLAG               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_SETS
        WHERE  rowid = l_ROW_ID
        FOR UPDATE NOWAIT;

Line: 255


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

Line: 330


Procedure Delete_Allocation_Set(
   l_allocation_set_id                  IN NUMBER
  ) Is
 Begin
    --delete batches
   DELETE From GL_AUTO_ALLOC_BATCHES
   Where Allocation_Set_Id = l_allocation_set_id;

Line: 338


   DELETE From GL_AUTO_ALLOC_SETS
   Where Allocation_Set_Id = l_allocation_set_id;

Line: 345


End Delete_Allocation_Set;

Line: 366


        SELECT batch_type_code
        FROM   gl_auto_alloc_batches
        WHERE  allocation_set_id = X_Allocation_Set_Id;

Line: 415


        SELECT batch_type_code
        FROM   gl_auto_alloc_batch_history
        WHERE  Request_Id = X_Request_Id;

Line: 456


      SELECT batch_id,batch_type_code
      FROM   gl_auto_alloc_batches
      WHERE  allocation_set_id = x_batch_id
      ORDER BY (decode(batch_type_code, 'A', 1, 'R', 2, 'E', 3, 'P',4));

Line: 462


      SELECT ledger_id
      FROM   gl_recurring_headers
      WHERE  recurring_batch_id = random_bid;

Line: 468


      SELECT lgr.ledger_id
      FROM   gl_alloc_formulas af,
             gl_alloc_formula_lines afl,
             gl_ledger_set_assignments lsa,
             gl_ledgers lgr
      WHERE  af.allocation_batch_id = random_bid
      AND    afl.allocation_formula_id = af.allocation_formula_id
      AND    afl.line_number IN (4, 5)
      AND    lsa.ledger_set_id (+) = nvl(afl.ledger_id, x_ledger_id)
      AND    sysdate BETWEEN
                     nvl(trunc(lsa.start_date), sysdate - 1)
                 AND nvl(trunc(lsa.end_date), sysdate + 1)
      AND    lgr.ledger_id = nvl(lsa.ledger_id,
                                 nvl(afl.ledger_id, x_ledger_id))
      AND    lgr.object_type_code = 'L';

Line: 485


      SELECT lgr.ledger_id
      FROM   gl_alloc_formulas af,
             gl_alloc_formula_lines afl,
             gl_ledger_set_assignments lsa,
             gl_ledgers lgr
      WHERE  af.allocation_batch_id = random_bid
      AND    afl.allocation_formula_id = af.allocation_formula_id
      AND    afl.line_number IN (4, 5)
      AND    lsa.ledger_set_id (+) = afl.ledger_id
      AND    sysdate BETWEEN
                     nvl(trunc(lsa.start_date), sysdate - 1)
                 AND nvl(trunc(lsa.end_date), sysdate + 1)
      AND    lgr.ledger_id = nvl(lsa.ledger_id, afl.ledger_id)
      AND    lgr.object_type_code = 'L';

Line: 559


        SELECT allocation_set_name
        FROM   gl_auto_alloc_sets
        WHERE  allocation_set_id = X_Alloc_Set_Id;

Line: 564


        SELECT name
        FROM   gl_alloc_batches
        WHERE  allocation_batch_id = X_Alloc_Set_Id;

Line: 569


        SELECT name
        FROM   gl_recurring_batches
        WHERE  recurring_batch_id = X_Alloc_Set_Id;