APPS.JA_CN_CFS_INT_PKG SQL Statements

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

Line: 89

  PROCEDURE insert_CFS_data(P_COA_ID               IN NUMBER,
                            P_LEDGER_ID            IN NUMBER,
                            P_LEGAL_ENTITY_ID      IN NUMBER
                            ) AS
   BEGIN

    INSERT INTO ja_cn_cfs_activities_all(CFS_ACTIVITY_ID,
                                          LEGAL_ENTITY_ID,
                                          LEDGER_ID,
                                          ORG_ID,
                                          TRX_ID,
                                          TRX_NUMBER,
                                          TRX_LINE_ID,
                                          SOURCE,
                                          TRANSACTION_TYPE,
                                          DOCUMENT_SEQUENCE_NUMBER,
                                          TRANSACTION_DATE,
                                          GL_DATE,
                                          PERIOD_NAME,
                                          FUNC_CURR_CODE,
                                          FUNC_AMOUNT,
                                          ORIGINAL_CURR_CODE,
                                          ORIGINAL_AMOUNT,
                                          CURRENCY_CONVERSION_RATE,
                                          CURRENCY_CONVERSION_TYPE,
                                          CURRENCY_CONVERSION_DATE,
                                          DESCRIPTION,
                                          DETAILED_CFS_ITEM,
                                          INTERCOMPANY_FLAG,
                                          REFERENCE_NUMBER,
                                          THIRD_PARTY_NAME,
                                          THIRD_PARTY_NUMBER,
                                          EVENT_CLASS_CODE,
                                          SOURCE_APPLICATION_ID,
                                          ANALYTICAL_CRITERION_CODE,
                                          SOURCE_VALUE,
                                          CASH_ITEM_DESC,
                                          UPGRADE_FLAG,
                                          LAST_UPDATE_DATE,
                                          LAST_UPDATED_BY,
                                          CREATION_DATE,
                                          CREATED_BY,
                                          LAST_UPDATE_LOGIN)
    SELECT ja_cn_cfs_activities_s.NEXTVAL,
           LEGAL_ENTITY_ID,
           LEDGER_ID,
           ORG_ID,
           TRX_ID,
           TRX_NUMBER,
           TRX_LINE_ID,
           SOURCE,
           TRANSACTION_TYPE,
           DOCUMENT_SEQUENCE_NUMBER,
           TRANSACTION_DATE,
           GL_DATE,
           PERIOD_NAME,
           FUNC_CURR_CODE,
           FUNC_AMOUNT,
           ORIGINAL_CURR_CODE,
           ORIGINAL_AMOUNT,
           CURRENCY_CONVERSION_RATE,
           CURRENCY_CONVERSION_TYPE,
           CURRENCY_CONVERSION_DATE,
           DESCRIPTION,
           DETAILED_CFS_ITEM,
           INTERCOMPANY_FLAG,
           REFERENCE_NUMBER,
           THIRD_PARTY_NAME,
           THIRD_PARTY_NUMBER,
           EVENT_CLASS_CODE,
           SOURCE_APPLICATION_ID,
           ANALYTICAL_CRITERION_CODE,
           SOURCE_VALUE,
           CASH_ITEM_DESC,
           'I',
           SYSDATE,
           fnd_global.user_id,
           SYSDATE,
           fnd_global.user_id,
           fnd_global.LOGIN_ID
     FROM ja_cn_cfs_activities_interface
     WHERE legal_entity_id = p_legal_entity_id
       AND ledger_id = p_ledger_id
       AND status = 'S';

Line: 209

    SELECT ROWID,
           period_name,
           func_curr_code,
           detailed_cfs_item,
           trx_number,
           transaction_date
      FROM ja_cn_cfs_activities_interface
     WHERE ledger_id = p_ledger_id
       AND legal_entity_id = p_legal_entity_id;

Line: 222

    DELETE FROM ja_cn_cfs_activities_interface
     WHERE ledger_id = p_ledger_id
       AND legal_entity_id = p_legal_entity_id
       AND (status = 'E' OR status = 'S');

Line: 247

     SELECT COUNT(*)
       INTO l_number
       FROM gl_ledgers
      WHERE ledger_id = P_LEDGER_ID
       AND  currency_code = l_func_curr_code;

Line: 264

      SELECT COUNT(*)
        INTO l_number
        FROM Gl_Periods gp, gl_ledgers gl
       WHERE gl.ledger_id = p_ledger_id
         AND gl.period_set_name = gp.period_set_name
         AND gp.period_name = l_period_name;

Line: 282

       SELECT COUNT(*)
         INTO l_number
         FROM Fnd_Flex_Values_Tl Ffvt,
              fnd_flex_values    Ffv,
              ja_cn_cash_valuesets_all Cra
        WHERE Cra.Chart_Of_Accounts_Id = P_COA_Id
          AND Ffv.Flex_Value_Set_Id = Cra.Flex_Value_Set_Id
          AND Ffv.Flex_Value_Id = Ffvt.Flex_Value_Id
          AND Ffv.Flex_Value = l_detailed_cfs_item
          AND ffvt.LANGUAGE = userenv('LANG');

Line: 304

           UPDATE ja_cn_cfs_activities_interface
              SET  status = 'S'
             WHERE ROWID = l_rowid;

Line: 310

           UPDATE ja_cn_cfs_activities_interface
              SET  status = 'E'
             WHERE ROWID = l_rowid;

Line: 319

   insert_CFS_data(P_COA_ID,
                   P_LEDGER_ID,
                   P_legal_entity_ID);