APPS.JA_CN_UPDATE_JL_SEQ_PKG SQL Statements

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

Line: 67

    INSERT INTO JA_CN_JOURNAL_NUMBERING
      (legal_entity_id,
       ledger_id,
       Period_Name,
       NEXT_NUMBER,
       CREATED_BY,
       CREATION_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATE_LOGIN)
    VALUES
      (p_legal_entity_ID,
       p_ledger_id,
       p_period_name,
       2,
       fnd_global.USER_ID,
       SYSDATE,
       fnd_global.USER_ID,
       SYSDATE,
       fnd_global.LOGIN_ID);

Line: 129

  PROCEDURE Update_JL_Seq(p_legal_entity_ID IN NUMBER,
                          p_ledger_id       in number,
                          p_period_name     IN VARCHAR2,
                          p_next_number     IN NUMBER) IS

    l_procedure_name VARCHAR2(30) := 'Update_JL_Seq';

Line: 145

    UPDATE JA_CN_JOURNAL_NUMBERING jcjn
       SET jcjn.next_number       = p_next_number,
           jcjn.last_updated_by   = fnd_global.USER_ID,
           jcjn.last_update_date  = SYSDATE,
           jcjn.last_update_login = fnd_global.LOGIN_ID
     WHERE jcjn.legal_entity_id = nvl(p_legal_entity_ID, -1)
       and jcjn.ledger_id = p_ledger_id
       AND jcjn.period_name = p_period_name;

Line: 171

  END Update_JL_Seq;

Line: 205

      SELECT next_number
        FROM JA_CN_JOURNAL_NUMBERING jcjn
       WHERE jcjn.legal_entity_id = NVL(p_legal_entity_ID, -1)
         and jcjn.ledger_id = P_ledger_id
         AND jcjn.period_name = p_period_name;

Line: 234

      Update_JL_Seq(p_legal_entity_ID,
                    p_ledger_id,
                    p_period_name,
                    l_next_number + 1);