APPS.GL_AUTO_ALLOC_WF_PKG SQL Statements

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

Line: 51

        l_LAST_UPDATE_LOGIN                Number;

Line: 53

        l_LAST_UPDATED_BY                  Number;

Line: 68

    Select
    ALLOCATION_SET_ID
   ,ALLOCATION_SET_NAME
   ,OWNER
   ,ACCESS_SET_ID
   ,LEDGER_ID
   ,LEDGER_CURRENCY
   ,PERIOD_NAME
   ,BUDGET_VERSION_ID
   ,BALANCING_SEGMENT_VALUE
   ,JOURNAL_EFFECTIVE_DATE
   ,CALCULATION_EFFECTIVE_DATE
   ,USAGE_CODE
   ,GL_PERIOD_NAME
   ,PA_PERIOD_NAME
   ,EXPENDITURE_ITEM_DATE
   ,CREATED_BY
   ,LAST_UPDATED_BY
   ,LAST_UPDATE_LOGIN
   ,ORG_ID
    From GL_AUTO_ALLOC_SET_HISTORY
    Where REQUEST_ID = p_request_Id;

Line: 93

   SELECT user_name
   FROM fnd_user
   WHERE user_id = l_user_id;

Line: 98

   SELECT chart_of_accounts_id
   FROM GL_ACCESS_SETS
   WHERE access_set_id = l_access_set_id;

Line: 121

   ,l_LAST_UPDATED_BY
   ,l_LAST_UPDATE_LOGIN
   ,l_org_id;

Line: 280

        UPDATE GL_AUTO_ALLOC_SET_HISTORY
        SET MONITOR_URL = l_monitor_url
        Where Request_Id = to_number(p_item_key);

Line: 440

                                   aname           => 'LAST_UPDATED_BY',
                                   avalue          => l_LAST_UPDATED_BY);

Line: 443

        	diagn_debug_msg('Create_And_Start_Wf: ' || 'Attribute CREATED_BY = ' ||to_char(l_LAST_UPDATED_BY));

Line: 449

                                   aname           => 'LAST_UPDATE_LOGIN',
                                   avalue          => l_LAST_UPDATE_LOGIN);

Line: 452

        	diagn_debug_msg('Create_And_Start_Wf: ' || 'Attribute LAST_UPDATE_LOGIN = ' ||to_char(l_LAST_UPDATE_LOGIN));

Line: 486

      Select
            STEP_NUMBER
         ,  BATCH_ID
         ,  BATCH_TYPE_CODE
         ,  ALLOCATION_METHOD_CODE
         ,  OWNER
   From   GL_AUTO_ALLOC_BATCH_HISTORY
   Where REQUEST_ID  = to_number(p_item_key)
   AND   Step_number > l_step_number
   Order by Step_number ASC;

Line: 508

  Select jb.status, jb.je_batch_id
  FROM GL_JE_BATCHES jb,
       GL_AUTO_ALLOC_BATCH_HISTORY bh
  WHERE bh.request_id = to_number(p_item_key)
  AND   bh.step_number = l_step
  AND   jb.je_batch_id = bh.generated_je_batch_id;

Line: 583

           Update GL_AUTO_ALLOC_BATCH_HISTORY
           Set COMPLETE_FLAG = 'Y'
           Where REQUEST_ID = to_number(p_item_key)
           And STEP_NUMBER  = l_step;

Line: 591

             diagn_debug_msg('Rows updated='||to_char(SQL%ROWCOUNT));

Line: 594

             	diagn_debug_msg('Next_Step_Type: ' || 'No update any row for complete flag = Y');

Line: 693

     Update_Status(to_number(p_item_key)
                    ,f_step_number
                    ,'UFE'
                    );

Line: 771

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 831

      Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'JRP'
                    );

Line: 841

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'GC'
                    );

Line: 857

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 877

 Select JB.APPROVAL_STATUS_CODE,JB.JE_BATCH_ID
 FROM GL_JE_BATCHES jb,
 GL_AUTO_ALLOC_BATCH_HISTORY bh
 WHERE bh.request_id = to_number(p_item_key)
 AND   bh.step_number = l_step_number
 AND   jb.je_batch_id = bh.generated_je_batch_id;

Line: 924

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'JAP'
                    );

Line: 932

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'GC'
                    );

Line: 951

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 976

 Select JB.APPROVAL_STATUS_CODE,JB.NAME,JB.JE_BATCH_ID
 FROM GL_JE_BATCHES jb,
 GL_AUTO_ALLOC_BATCH_HISTORY bh
 WHERE bh.request_id = to_number(p_item_key)
 AND   bh.step_number = l_step_number
 AND   jb.je_batch_id = bh.generated_je_batch_id;

Line: 1067

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 1089

 Select JB.APPROVAL_STATUS_CODE,JB.JE_BATCH_ID
 FROM GL_JE_BATCHES jb,
      GL_AUTO_ALLOC_BATCH_HISTORY bh
 WHERE bh.request_id = to_number(p_item_key)
 AND   bh.step_number = l_step_number
 AND   jb.je_batch_id = bh.generated_je_batch_id;

Line: 1154

      Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'JAP'
                       );

Line: 1162

      Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'GC'
                      );

Line: 1180

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 1207

 Select A.GENERATED_JE_BATCH_ID,
        JEB.Name
 From GL_JE_BATCHES JEB
     ,GL_AUTO_ALLOC_BATCH_HISTORY A
 Where JEB.JE_BATCH_ID = A.GENERATED_JE_BATCH_ID
 AND   A.REQUEST_ID      = to_number(p_item_key)
 AND   A.STEP_NUMBER     = l_step_number;

Line: 1309

      Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'GC'
                    );

Line: 1328

    Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 1335

Procedure Select_And_Validate_Batch(p_item_type      IN VARCHAR2,
                         p_item_key       IN VARCHAR2,
                         p_actid          IN NUMBER,
                         p_funcmode        IN VARCHAR2,
                         p_result OUT NOCOPY VARCHAR2) Is

 l_result                Varchar2(1);

Line: 1350

SELECT jb.je_batch_id
FROM GL_JE_BATCHES jb,
     GL_AUTO_ALLOC_BATCH_HISTORY bh
WHERE bh.request_id = to_number(p_item_key)
AND   bh.step_number = l_step_number
AND   jb.je_batch_id = bh.generated_je_batch_id
AND   jb.status NOT IN ('P','I','S');

Line: 1362

   	diagn_debug_msg('Started Select_And_Validate_Batch');

Line: 1388

           	diagn_debug_msg('Select_And_Validate_Batch: ' || 'Batch '||to_char(l_gen_batch_id)||' is already posted');

Line: 1392

           	diagn_debug_msg('Select_And_Validate_Batch: ' || 'Batch  '||to_char(l_gen_batch_id)||' is valid for posting');

Line: 1404

        Update_Status(to_number(p_item_key)
                      ,l_step_number
                      ,'GC'
                      );

Line: 1413

        	diagn_debug_msg('Select_And_Validate_Batch: ' || 'Sending Notification. '||l_error_msg);

Line: 1429

        	diagn_debug_msg('Select_And_Validate_Batch: ' || 'Message_name = '||l_message_Name);

Line: 1441

        Update_Status(to_number(p_item_key)
                      ,l_step_number
                      ,'BNP'
                      );

Line: 1454

    Wf_Core.Context('GL_AUTO_ALLOC_WF_PKG', 'Select_And_Validate_Batch', p_item_type, p_item_key);

Line: 1457

     	diagn_debug_msg('Select_And_Validate_Batch: ' || err_msg ||'*'||err_stack);

Line: 1460

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 1465

End Select_And_Validate_Batch;

Line: 1483

  Select jb.je_batch_id, jb.status
  From GL_JE_BATCHES jb,
       GL_AUTO_ALLOC_BATCH_HISTORY bh
  Where bh.request_id = to_number(p_item_key)
  And   bh.step_number = l_step_number
  And   jb.je_batch_id = bh.generated_je_batch_id;

Line: 1546

      Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'JBNP'
                     );

Line: 1552

      Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'PC'
                    );

Line: 1570

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 1577

Procedure Delete_Batch(p_item_type      IN VARCHAR2,
                         p_item_key       IN VARCHAR2,
                         p_actid          IN NUMBER,
                         p_funcmode        IN VARCHAR2,
                         p_result OUT NOCOPY VARCHAR2) Is

l_step_number            Number;

Line: 1591

Cursor Verify_Delete_C IS
Select
 H.Step_Number
,H.Batch_Id
,H.BATCH_TYPE_CODE
,H.GENERATED_JE_BATCH_ID
,H.COMPLETE_FLAG
,JEB.Name
,JEB.Status
From GL_JE_BATCHES JEB
    ,GL_AUTO_ALLOC_BATCH_HISTORY H
Where
JEB.JE_BATCH_ID  = H.GENERATED_JE_BATCH_ID
AND H.REQUEST_ID = to_number(p_item_key)
AND H.GENERATED_JE_BATCH_ID IS Not Null
AND JEB.Status  <> 'P'
Order By H.STEP_NUMBER Desc;

Line: 1610

Select step_number
From GL_AUTO_ALLOC_BATCH_HISTORY
Where
    REQUEST_ID= to_number(p_item_key)
AND GENERATED_JE_BATCH_ID IS NULL
AND STATUS_CODE <> 'NS';

Line: 1621

   	diagn_debug_msg('Rollback:Started Delete_Batch');

Line: 1624

    Open Verify_Delete_C;

Line: 1626

      Fetch Verify_Delete_C Into
          l_step_number
          ,l_batch_id
          ,l_batch_type_code
          ,l_gen_batch_Id
          ,l_complete_flag
          ,l_gen_batch_name
          ,l_status;

Line: 1635

      If Verify_Delete_C%NOTFOUND Then
         IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
         	diagn_debug_msg('Delete_Batch: ' || 'Rollback:No Batch to delete');

Line: 1643

             Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RNR'
                    );

Line: 1652

         	diagn_debug_msg('Delete_Batch: ' || 'Rollback:Deleting Batch= '||to_char(l_gen_batch_Id));

Line: 1655

             DELETE gl_je_lines
             WHERE  je_header_id IN (SELECT je_header_id
                            FROM   gl_je_headers
                            WHERE  je_batch_id = l_gen_batch_Id);

Line: 1661

                DELETE gl_je_headers
                WHERE  je_batch_id = l_gen_batch_Id;

Line: 1665

                DELETE gl_je_batches
                WHERE  je_batch_id = l_gen_batch_Id;

Line: 1669

          	diagn_debug_msg('Delete_Batch: ' || 'Rollback:Batch deleted');

Line: 1672

          Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RC'
                    );

Line: 1678

  Close Verify_Delete_C;

Line: 1681

      Update_Status(to_number(p_item_key)
                    ,-1
                    ,'RP'
                    );

Line: 1692

    Wf_Core.Context('GL_AUTO_ALLOC_WF_PKG', 'Delete_Batch', p_item_type, p_item_key);

Line: 1695

     	diagn_debug_msg('Delete_Batch: ' || err_msg ||'*'||err_stack);

Line: 1697

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RUFE'
                    );

Line: 1702

End Delete_Batch;

Line: 1716

Select
 Step_Number
,GENERATED_JE_BATCH_ID
From GL_AUTO_ALLOC_BATCH_HISTORY
WHERE REQUEST_ID = to_number(p_item_key)
And COMPLETE_FLAG = 'Y'
And Nvl(ALL_HEADERS_REVERSED,'N') <>  'Y'
And STEP_NUMBER  <=  l_step_number
Order by STEP_NUMBER desc;

Line: 1727

Select JE.JE_HEADER_ID
FROM GL_JE_HEADERS JE
WHERE JE.JE_BATCH_ID = l_gen_batch_id
AND NOT EXISTS ( SELECT RB.JE_HEADER_ID
                FROM GL_AUTO_ALLOC_REV_BATCHES RB
                WHERE RB.PARENT_REQUEST_ID = to_number(p_item_key)
                AND   RB.JE_HEADER_ID = JE.JE_HEADER_ID);

Line: 1769

          Update_Status(to_number(p_item_key)
                        ,l_step_number
                        ,'RRP');

Line: 1781

          UPDATE GL_AUTO_ALLOC_BATCH_HISTORY
          Set ALL_HEADERS_REVERSED = 'Y'
          WHERE REQUEST_ID = to_number(p_item_key)
          And GENERATED_JE_BATCH_ID = l_gen_batch_id;

Line: 1785

          diagn_debug_msg('Rows updated = '||to_char(SQL%ROWCOUNT));

Line: 1788

          Update_Status(to_number(p_item_key)
                        ,l_step_number
                        ,'RRC');

Line: 1851

            Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RRP');

Line: 1864

            UPDATE GL_AUTO_ALLOC_BATCH_HISTORY
            Set ALL_HEADERS_REVERSED = 'Y'
            WHERE REQUEST_ID = to_number(p_item_key)
            And GENERATED_JE_BATCH_ID = l_gen_batch_id;

Line: 1868

            diagn_debug_msg('Rollback:Rows updated = '||to_char(SQL%ROWCOUNT));

Line: 1871

            Update_Status(to_number(p_item_key)
                         ,l_step_number
                         ,'RRC');

Line: 1886

 Update_Status(to_number(p_item_key)
               ,-1
               ,'RRC');

Line: 1904

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RUFE'
                    );

Line: 1922

Select R.REVERSAL_JE_HEADER_ID
From GL_JE_BATCHES JEB
    ,GL_AUTO_ALLOC_REV_BATCHES R
Where JEB.JE_BATCH_ID = R.REVERSAL_JE_BATCH_ID
AND   JEB.STATUS Not In ('P','I')
AND    R.PARENT_REQUEST_ID = to_number(p_item_key);

Line: 1945

         Update_Status(to_number(p_item_key)
                    ,-1
                    ,'RPP');

Line: 1958

         Update_Status(to_number(p_item_key)
                    ,-1
                    ,'RC');

Line: 1995

 Select
 Accrual_rev_status
,Accrual_rev_je_header_id
From GL_JE_HEADERS
Where JE_HEADER_ID = l_je_header_id;

Line: 2038

         Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RJNR');

Line: 2061

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RUFE'
                    );

Line: 2069

Procedure Select_And_Validate_AllBatches(p_item_type      IN VARCHAR2,
                         p_item_key       IN VARCHAR2,
                         p_actid          IN NUMBER,
                         p_funcmode       IN VARCHAR2,
                         p_result         OUT NOCOPY VARCHAR2) Is

l_reversal_je_batch_id   NUMBER;

Line: 2083

Select
  GLAARV.REVERSAL_JE_BATCH_ID
 ,BH.step_Number
FROM GL_JE_BATCHES GLB
    ,GL_AUTO_ALLOC_BATCH_HISTORY BH
    ,GL_AUTO_ALLOC_REV_BATCHES GLAARV
Where GLB.JE_BATCH_ID = GLAARV.REVERSAL_JE_BATCH_ID
  AND GLAARV.JE_BATCH_ID = BH.GENERATED_JE_BATCH_ID
  AND GLB.STATUS NOT In ('P','I','S')
  AND BH.REQUEST_ID            = to_number(p_item_key)
  AND GLAARV.PARENT_REQUEST_ID = to_number(p_item_key);

Line: 2099

   	diagn_debug_msg('Rollback:Started Select_And_Validate_AllBatches');

Line: 2117

                  	diagn_debug_msg('Select_And_Validate_AllBatches: ' || 'Rollback: '||to_char(l_reversal_je_batch_id)||
                                   ' Batch is valid for posting');

Line: 2122

                  	diagn_debug_msg('Select_And_Validate_AllBatches: ' || 'Rollback:Batch '||to_char(l_reversal_je_batch_id)||
                            ' is already posted');

Line: 2129

                     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RBNP');

Line: 2138

      	diagn_debug_msg('Select_And_Validate_AllBatches: ' || '*************************************');

Line: 2139

      	diagn_debug_msg('Select_And_Validate_AllBatches: ' || 'Rollback:All reverse batches valid for posting');

Line: 2140

      	diagn_debug_msg('Select_And_Validate_AllBatches: ' || '*************************************');

Line: 2145

       Update_Status(to_number(p_item_key)
                    ,-1
                    ,'RPP');

Line: 2152

     	diagn_debug_msg('Select_And_Validate_AllBatches: ' || 'Rollback:Batches not valid for posting = '||l_batches_not_valid||
                     ' Sending Notification' );

Line: 2161

         	diagn_debug_msg('Select_And_Validate_AllBatches: ' || 'Message_name = '||l_message_Name);

Line: 2178

    Wf_Core.Context('GL_AUTO_ALLOC_WF_PKG', 'Select_And_Validate_AllBatches', p_item_type, p_item_key);

Line: 2181

     	diagn_debug_msg('Select_And_Validate_AllBatches: ' || err_msg ||'*'||err_stack);

Line: 2183

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RUFE'
                    );

Line: 2189

End Select_And_Validate_AllBatches ;

Line: 2205

  Select JEB.Status
  ,JEB.JE_Batch_Id
  ,BH.Step_Number
   From GL_JE_BATCHES JEB
     ,GL_AUTO_ALLOC_BATCH_HISTORY BH
     ,GL_AUTO_ALLOC_REV_BATCHES RB
  Where JEB.JE_BATCH_ID = RB.REVERSAL_JE_BATCH_ID
   And RB.JE_BATCH_ID   = BH.GENERATED_JE_BATCH_ID
   AND BH.REQUEST_ID        = to_number(p_item_key)
   And RB.PARENT_REQUEST_ID = to_number(p_item_key);

Line: 2237

          Update_status(
             to_number(p_item_key)
                    ,l_step_number
                    ,'RJBNP');

Line: 2269

      Update_Status(to_number(p_item_key)
                    ,-1
                    ,'RC');

Line: 2286

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RUFE'
                    );

Line: 2452

       Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'GP'
                    );

Line: 2470

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 2496

          SELECT jb.request_id,bh.generated_je_batch_id
          FROM GL_JE_BATCHES jb,
               GL_AUTO_ALLOC_BATCH_HISTORY bh
          WHERE bh.request_id = to_number(p_item_key)
          AND   bh.step_number = l_step_number
          AND   jb.je_batch_id = bh.generated_je_batch_id;

Line: 2552

         	diagn_debug_msg('SUBMIT_POSTING_PROGRAM: ' || 'Inserting req id = '||to_char(l_batch_request_id)||
                            ' into histroy detail');

Line: 2567

         INSERT_BATCH_HIST_DET(
                  p_REQUEST_ID        => l_batch_request_id
                 ,p_PARENT_REQUEST_ID => l_parent_req_id
                 ,p_STEP_NUMBER       => l_step_number
                 ,p_PROGRAM_NAME_CODE => 'GLPPOS'
                 ,p_RUN_MODE          => l_operating_mode);

Line: 2609

               Update GL_JE_BATCHES
               Set Posting_Run_Id = l_posting_run_id
                ,Status = 'S'
                Where JE_BATCH_ID in ( Select GLAARV.REVERSAL_JE_BATCH_ID
                                  From GL_JE_BATCHES GLB
                                      ,GL_AUTO_ALLOC_REV_BATCHES GLAARV
                                  Where GLB.JE_BATCH_ID = GLAARV.REVERSAL_JE_BATCH_ID
                                  AND GLB.STATUS NOT In ('P','I','S')
                                  AND GLAARV.PARENT_REQUEST_ID = to_number(p_item_key) );

Line: 2623

                 Update_Status(to_number(p_item_key)
                       ,-1
                        ,'RPP'
                       );

Line: 2628

                Update GL_JE_BATCHES
                Set Posting_Run_Id = l_posting_run_id,
                    Status = 'S'
                Where JE_BATCH_ID IN
                        ( SELECT bh.generated_je_batch_id
                          FROM GL_AUTO_ALLOC_BATCH_HISTORY bh,
                               GL_JE_BATCHES jb
                          WHERE bh.request_id = to_number(p_item_key)
                          AND   bh.step_number = l_step_number
                          AND   jb.je_batch_id = bh.generated_je_batch_id
                          AND   jb.status NOT IN ('P','I','S')

                         );

Line: 2643

               Update_Status(to_number(p_item_key)
                       ,l_step_number
                       ,'PP'
                       );

Line: 2661

        Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 2698

          SELECT 'untaxed journals'
          FROM DUAL
          WHERE EXISTS
              (SELECT 'UNTAXED'
               FROM   GL_JE_HEADERS JEH,
                      GL_LEDGERS LGR
               WHERE  JEH.je_batch_id = l_je_batch_id
               AND    JEH.tax_status_code = 'R'
               AND    JEH.currency_code <> 'STAT'
               AND    JEH.je_source = 'Manual'
               AND    LGR.ledger_id = JEH.ledger_id
               AND    LGR.ledger_category_code <> 'NONE'
               AND    LGR.enable_automatic_tax_flag = 'Y');

Line: 2713

Select
  NAME
 ,CONTROL_TOTAL
 ,RUNNING_TOTAL_DR
 ,RUNNING_TOTAL_CR
 ,DEFAULT_PERIOD_NAME
 ,ACTUAL_FLAG
 ,BUDGETARY_CONTROL_STATUS
 ,STATUS
 ,APPROVAL_STATUS_CODE
From GL_JE_BATCHES
Where JE_BATCH_ID = l_je_batch_id;

Line: 2728

SELECT
jh.LEDGER_ID,
jh.BUDGET_VERSION_ID,
lgr.LATEST_ENCUMBRANCE_YEAR
FROM GL_JE_HEADERS jh, GL_LEDGERS lgr
WHERE jh.JE_BATCH_ID = l_je_batch_id
AND   lgr.LEDGER_ID = jh.LEDGER_ID
AND   lgr.LEDGER_CATEGORY_CODE <> 'NONE';

Line: 2768

          Update GL_JE_BATCHES
          Set approval_status_code = 'Z'
          Where je_batch_id = l_je_batch_id;

Line: 2839

      GL_PERIOD_STATUSES_PKG.select_columns(
            101,
            l_ledger_id,
            l_period_name,
            l_period_status,
            l_start_date,
            l_end_date,
            l_period_num,
            l_period_year);

Line: 2865

            SELECT max(decode(bud.status, 'I', 1, 'F', 1, 0)),
                   max(l_period_year - bud.latest_opened_year)
            FROM   GL_BUDGET_VERSIONS BV,
                   GL_BUDGETS BUD
            WHERE  BV.budget_version_id = l_budget_version_id
            AND    BUD.budget_type = BV.budget_type
            AND    BUD.budget_name = BV.budget_name;

Line: 3019

       Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'GP'
                    );

Line: 3037

    Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 3109

        Update GL_JE_HEADERS
        Set accrual_rev_flag = 'Y'
          , accrual_rev_period_name = l_period_name
          , accrual_rev_effective_date = decode(actual_flag,'A',
                            default_effective_date,accrual_rev_effective_date)
         Where je_header_id = l_je_header_id;

Line: 3117

        Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RRP'
                    );

Line: 3135

    Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RUFE'
                    );

Line: 3220

    select userenv('LANG') into l_userenv_lang from dual;

Line: 3224

    select userenv('CLIENT_INFO') into l_client_info from dual;

Line: 3266

            Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,l_status_code
                    );

Line: 3294

          Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,l_status_code
                    );

Line: 3321

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );

Line: 3347

Select
 H.Step_Number
,H.Batch_Id
,H.BATCH_TYPE_CODE
,H.GENERATED_JE_BATCH_ID
,H.COMPLETE_FLAG
,JEB.Status
From GL_JE_BATCHES JEB
    ,GL_AUTO_ALLOC_BATCH_HISTORY H
Where
 JEB.JE_BATCH_ID = H.GENERATED_JE_BATCH_ID
AND H.REQUEST_ID = to_number(p_item_key)
Order By H.STEP_NUMBER Desc;

Line: 3362

Select
 H.Step_Number
,H.Batch_Id
,H.BATCH_TYPE_CODE
,H.GENERATED_JE_BATCH_ID
,JEB.Name
From GL_JE_BATCHES JEB
    ,GL_AUTO_ALLOC_BATCH_HISTORY H
Where JEB.JE_BATCH_ID = H.GENERATED_JE_BATCH_ID
AND H.REQUEST_ID = to_number(p_item_key)
AND H.COMPLETE_FLAG = 'Y'
Order By H.STEP_NUMBER Desc;

Line: 3417

                     Update GL_AUTO_ALLOC_BATCH_HISTORY
                     Set COMPLETE_FLAG = 'Y'
                     Where REQUEST_ID = to_number(p_item_key)
                     And   STEP_NUMBER = l_step_number;

Line: 3512

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RUFE'
                    );

Line: 3545

        Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'RST'
                    );

Line: 3550

        Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'ST'
                    );

Line: 3570

procedure Selector_Func (p_item_type      IN VARCHAR2,
                         p_item_key       IN VARCHAR2,
                         p_actid          IN NUMBER,
                         p_funcmode        IN VARCHAR2,
                         p_result         OUT NOCOPY VARCHAR2)  IS
Begin
If ( p_funcmode = 'RUN' ) THEN
    NULL;

Line: 3581

   	diagn_debug_msg('Entering Selector_Func');

Line: 3590

    Wf_Core.Context('GL_AUTO_ALLOC_WF_PKG', 'SELECTOR_FUNC', p_item_type, p_item_key);

Line: 3593

     	diagn_debug_msg('Selector_Func: ' || err_msg ||'*'||err_stack);

Line: 3596

End Selector_Func ;

Line: 3600

Procedure INSERT_BATCH_HIST_DET(
           p_request_id        IN NUMBER
          ,p_parent_request_id IN NUMBER
          ,p_step_number       IN NUMBER
          ,p_program_name_code IN VARCHAR2
          ,p_run_mode          IN VARCHAR2
          ,p_allocation_type   IN VARCHAR2 DEFAULT 'GL'
	  ,p_created_by        IN NUMBER DEFAULT   -1
          ,p_last_updated_by   IN NUMBER DEFAULT   -1
          ,p_last_update_login IN NUMBER DEFAULT   -1
          ) IS

 l_CREATED_BY        NUMBER;

Line: 3613

 l_LAST_UPDATED_BY   NUMBER;

Line: 3614

 l_LAST_UPDATE_LOGIN NUMBER;

Line: 3619

 Select step_number
 From GL_AUTO_ALLOC_BATCH_HISTORY
 WHERE request_Id = p_PARENT_REQUEST_ID
 AND Status_Code Not In ( 'NS','RNR','RC');

Line: 3627

                     ,l_LAST_UPDATED_BY
                     ,l_LAST_UPDATE_LOGIN
                     );

Line: 3632

     l_last_updated_by   := p_last_updated_by;

Line: 3633

     l_last_update_login := p_last_update_login ;

Line: 3637

     Insert Into GL_AUTO_ALLOC_BAT_HIST_DET
          (REQUEST_ID
           ,PARENT_REQUEST_ID
           ,STEP_NUMBER
           ,PROGRAM_NAME_CODE
           ,LAST_UPDATE_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_LOGIN
           ,CREATION_DATE
           ,CREATED_BY
           ,STATUS_CODE
           ,RUN_MODE
          )
          Values
          (p_REQUEST_ID
          ,p_PARENT_REQUEST_ID
          ,p_STEP_NUMBER
          ,p_PROGRAM_NAME_CODE
          ,sysdate
          ,l_LAST_UPDATED_BY
          ,l_LAST_UPDATE_LOGIN
          ,sysdate
          ,l_CREATED_BY
          ,NULL
          ,p_RUN_MODE);

Line: 3669

       Insert Into GL_AUTO_ALLOC_BAT_HIST_DET
             (REQUEST_ID
           ,PARENT_REQUEST_ID
           ,STEP_NUMBER
           ,PROGRAM_NAME_CODE
           ,LAST_UPDATE_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_LOGIN
           ,CREATION_DATE
           ,CREATED_BY
           ,STATUS_CODE
           ,RUN_MODE
          )
          Values
          (p_REQUEST_ID
          ,p_PARENT_REQUEST_ID
          ,f_step_number
          ,p_PROGRAM_NAME_CODE
          ,sysdate
          ,l_LAST_UPDATED_BY
          ,l_LAST_UPDATE_LOGIN
          ,sysdate
          ,l_CREATED_BY
          ,NULL
          ,p_RUN_MODE);

Line: 3696

End INSERT_BATCH_HIST_DET ;

Line: 3700

            ,l_LAST_UPDATED_BY     OUT NOCOPY NUMBER
            ,l_LAST_UPDATE_LOGIN   OUT NOCOPY NUMBER ) IS
 Begin
          l_CREATED_BY:=  WF_ENGINE.GetItemAttrNumber
                        (p_item_type,
                         p_item_key,
                         'CREATED_BY');

Line: 3708

         l_LAST_UPDATED_BY:=   WF_ENGINE.GetItemAttrNumber
                        (p_item_type,
                         p_item_key,
                         'LAST_UPDATED_BY');

Line: 3713

         l_LAST_UPDATE_LOGIN:= WF_ENGINE.GetItemAttrNumber
                        (p_item_type,
                         p_item_key,
                         'LAST_UPDATE_LOGIN');

Line: 3727

        SELECT batch_type_code
        FROM   gl_auto_alloc_batch_history
        WHERE  Request_Id = X_Request_Id;

Line: 3749

Procedure Update_Status(
       l_request_id     IN Number
      ,l_step_number    IN Number
      ,l_status_code    IN Varchar2 ) IS

f_step_number         NUMBER;

Line: 3758

Select
 STATUS_CODE
,STEP_NUMBER
FROM GL_AUTO_ALLOC_BATCH_HISTORY
WHERE REQUEST_ID = l_request_id
AND ( STEP_NUMBER = l_step_number OR
      -1 = l_step_number) ;

Line: 3769

   	diagn_debug_msg('Update_Status: ' || 'Status_code = '||l_status_code||
                  ' Step_number = '||to_char(l_step_number));

Line: 3780

           UPDATE GL_AUTO_ALLOC_BATCH_HISTORY
           SET STATUS_CODE = l_status_code
           WHERE REQUEST_ID = l_request_id
           AND STEP_NUMBER = f_step_number;

Line: 3793

         UPDATE GL_AUTO_ALLOC_BATCH_HISTORY
         SET STATUS_CODE = l_status_code
         WHERE REQUEST_ID = l_request_id
         AND STEP_NUMBER =  l_step_number;

Line: 3801

End Update_Status;

Line: 3907

Select USER_CONCURRENT_PROGRAM_NAME
From fnd_concurrent_programs_vl
Where APPLICATION_ID = 101
AND CONCURRENT_PROGRAM_NAME = Prog_Code;

Line: 3968

    select userenv('LANG') into l_userenv_lang from dual;

Line: 3972

    select userenv('CLIENT_INFO') into l_client_info from dual;

Line: 4010

        select nvl(userenv('LANG'),'US') into l_userenv_lang from dual;

Line: 4039

          Update_Status(to_number(p_item_key)
                    ,p_step_number
                    ,l_status_code
                    );

Line: 4055

      	diagn_debug_msg('Inserting req id = '||to_char(l_submit_request_id)||
                            ' into histroy detail');

Line: 4063

       INSERT_BATCH_HIST_DET(
                p_REQUEST_ID        => l_submit_request_id
               ,p_PARENT_REQUEST_ID => l_parent_req_id
               ,p_STEP_NUMBER       => p_step_number
               ,p_PROGRAM_NAME_CODE => Prog_Code
               ,p_RUN_MODE          => l_operating_mode);

Line: 4158

      Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'BNG'
                    );

Line: 4183

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'BNG'
                    );

Line: 4200

     Update_Status(to_number(p_item_key)
                    ,l_step_number
                    ,'UFE'
                    );