DBA Data[Home] [Help]

APPS.GL_JE_BATCHES_POST_PKG SQL Statements

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

Line: 16

      SELECT gl_je_posting_s.NEXTVAL
      FROM dual;
Line: 44

      SELECT
	      'BF'
      FROM
	      dual
      WHERE   EXISTS
	      (  SELECT  'Frozen budget'
	         FROM    GL_BUDGET_VERSIONS BV,
		         GL_JE_HEADERS JH
	         WHERE   BV.status in ('I', 'F')
	         AND     BV.budget_version_id = JH.budget_version_id
	         AND     JH.je_batch_id = X_je_batch_id );
Line: 57

      SELECT
	      'BU'
      FROM
	      dual
      WHERE   EXISTS
	      (  SELECT  'Unopened budget year'
	         FROM    GL_BUDGETS GB,
			 GL_BUDGET_VERSIONS BV,
		         GL_JE_HEADERS JH
	         WHERE   GB.budget_name = BV.budget_name
		 AND	 GB.budget_type = BV.budget_type
		 AND     (   GB.latest_opened_year IS NULL
			  OR GB.latest_opened_year < X_period_year )
	         AND     BV.budget_version_id = JH.budget_version_id
	         AND     JH.je_batch_id = X_je_batch_id );
Line: 97

    SELECT 'Out of Balance'
    FROM   SYS.DUAL
    WHERE  EXISTS
	    ( SELECT 'x'
	      FROM   GL_JE_HEADERS
	      WHERE  je_batch_id = X_je_batch_id
              AND    nvl(display_alc_journal_flag, 'Y') = 'Y'
	      AND    currency_code <> 'STAT'
	      AND    nvl(running_total_dr, 0) <> nvl(running_total_cr, 0));
Line: 123

    SELECT 'Untaxed'
    FROM   SYS.DUAL
    WHERE  EXISTS
	    ( SELECT 'x'
	      FROM   GL_JE_HEADERS
	      WHERE  je_batch_id = X_je_batch_id
              AND    nvl(display_alc_journal_flag, 'Y') = 'Y'
	      AND    currency_code <> 'STAT'
	      AND    tax_status_code = 'R');
Line: 164

      SELECT *
      FROM   gl_je_batches
      WHERE  rowid = X_Rowid
      FOR UPDATE of Je_Batch_Id NOWAIT;
Line: 212

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Je_Batch_Id                         NUMBER,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER,
                     X_Chart_Of_Accounts_Id                NUMBER,
                     X_Name                                VARCHAR2,
                     X_Status                              VARCHAR2,
                     X_Status_Verified                     VARCHAR2,
                     X_Actual_Flag                         VARCHAR2,
                     X_Budgetary_Control_Status            VARCHAR2,
                     X_Last_Update_Login                   NUMBER,
                     X_Default_Period_Name                 VARCHAR2,
                     X_Control_Total                       NUMBER,
                     X_Running_Total_Dr                    NUMBER,
                     X_Running_Total_Cr                    NUMBER,
                     X_Posting_Run_Id                      NUMBER,
                     X_Request_Id             		   NUMBER
) IS
BEGIN
  UPDATE gl_je_batches
  SET
    je_batch_id                               =    X_Je_Batch_Id,
    last_update_date                          =    X_Last_Update_Date,
    last_updated_by                           =    X_Last_Updated_By,
    chart_of_accounts_id                      =    X_Chart_Of_Accounts_Id,
    name                                      =    X_Name,
    status                                    =    X_Status,
    status_verified                           =    X_Status_Verified,
    actual_flag                               =    X_Actual_Flag,
    budgetary_control_status                  =    X_Budgetary_Control_Status,
    last_update_login                         =    X_Last_Update_Login,
    default_period_name                       =    X_Default_Period_Name,
    control_total                             =    X_Control_Total,
    running_total_dr                          =    X_Running_Total_Dr,
    running_total_cr                          =    X_Running_Total_Cr,
    posting_run_id                            =    X_Posting_Run_Id,
    request_id                   	      =    X_Request_Id
  WHERE rowid = X_rowid;
Line: 257

  UPDATE GL_CONSOLIDATION_HISTORY
  SET   status = 'PS',
        request_id = X_Request_Id
  WHERE je_batch_id = X_Je_Batch_Id;
Line: 264

  UPDATE GL_ELIMINATION_HISTORY
  SET   status_code = 'PS',
        request_id = X_Request_Id
  WHERE je_batch_id = X_Je_Batch_Id;
Line: 269

END Update_Row;