APPS.XLA_XLAABACR_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        PRB.APPLICATION_ID,
        PRB.AMB_CONTEXT_CODE,
        PRB.PRODUCT_RULE_TYPE_CODE,
        PRB.PRODUCT_RULE_CODE
      FROM
        XLA_PRODUCT_RULES_B PRB
      WHERE PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
            ,'N'
            ,'Y'
            ,'') )
        AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
         ,PRB.PRODUCT_RULE_TYPE_CODE)
        AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
         ,'DEFAULT');

Line: 21

      SELECT
        PRB.APPLICATION_ID,
        PRB.AMB_CONTEXT_CODE,
        PRB.PRODUCT_RULE_TYPE_CODE,
        PRB.PRODUCT_RULE_CODE
      FROM
        XLA_PRODUCT_RULES_B PRB
      WHERE PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
            ,'N'
            ,'Y'
            ,'') )
        AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
         ,PRB.PRODUCT_RULE_TYPE_CODE)
        AND PRB.APPLICATION_ID = P_APPLICATION_ID
        AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
         ,'DEFAULT');

Line: 38

      SELECT
        PRB.APPLICATION_ID,
        PRB.AMB_CONTEXT_CODE,
        PRB.PRODUCT_RULE_TYPE_CODE,
        PRB.PRODUCT_RULE_CODE
      FROM
        XLA_PRODUCT_RULES_B PRB
      WHERE PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
            ,'N'
            ,'Y'
            ,'') )
        AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
         ,PRB.PRODUCT_RULE_TYPE_CODE)
        AND PRB.APPLICATION_ID = P_APPLICATION_ID
        AND PRB.PRODUCT_RULE_CODE = P_PRODUCT_RULE_CODE
        AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
         ,'DEFAULT');

Line: 56

      SELECT
        PRB.APPLICATION_ID,
        PRB.AMB_CONTEXT_CODE,
        PRB.PRODUCT_RULE_TYPE_CODE,
        PRB.PRODUCT_RULE_CODE
      FROM
        XLA_PRODUCT_RULES_B PRB,
        XLA_GL_LEDGERS_V LE,
        XLA_ACCTG_METHOD_RULES AMR,
        XLA_LEDGER_RELATIONSHIPS_V LR
      WHERE PRB.PRODUCT_RULE_TYPE_CODE = AMR.PRODUCT_RULE_TYPE_CODE
        AND PRB.PRODUCT_RULE_CODE = AMR.PRODUCT_RULE_CODE
        AND PRB.APPLICATION_ID = AMR.APPLICATION_ID
        AND AMR.ACCOUNTING_METHOD_TYPE_CODE = LE.SLA_ACCOUNTING_METHOD_TYPE
        AND AMR.ACCOUNTING_METHOD_CODE = LE.SLA_ACCOUNTING_METHOD_CODE
        AND LE.LEDGER_ID = LR.LEDGER_ID
        AND LR.PRIMARY_LEDGER_ID = P_LEDGER_ID
        AND PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
            ,'N'
            ,'Y'
            ,'') )
        AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
         ,PRB.PRODUCT_RULE_TYPE_CODE)
        AND PRB.APPLICATION_ID = NVL(P_APPLICATION_ID
         ,PRB.APPLICATION_ID)
        AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
         ,'DEFAULT');

Line: 84

      SELECT
        PRB.APPLICATION_ID,
        PRB.AMB_CONTEXT_CODE,
        PRB.PRODUCT_RULE_TYPE_CODE,
        PRB.PRODUCT_RULE_CODE
      FROM
        XLA_PRODUCT_RULES_B PRB,
        XLA_GL_LEDGERS_V LE,
        XLA_ACCTG_METHOD_RULES AMR
      WHERE PRB.PRODUCT_RULE_TYPE_CODE = AMR.PRODUCT_RULE_TYPE_CODE
        AND PRB.PRODUCT_RULE_CODE = AMR.PRODUCT_RULE_CODE
        AND PRB.APPLICATION_ID = AMR.APPLICATION_ID
        AND AMR.ACCOUNTING_METHOD_TYPE_CODE = LE.SLA_ACCOUNTING_METHOD_TYPE
        AND AMR.ACCOUNTING_METHOD_CODE = LE.SLA_ACCOUNTING_METHOD_CODE
        AND LE.LEDGER_ID = P_LEDGER_ID
        AND PRB.COMPILE_STATUS_CODE in ( 'E' , 'N' , DECODE(P_UNCOMPILE_ONLY_FLAG
            ,'N'
            ,'Y'
            ,'') )
        AND PRB.PRODUCT_RULE_TYPE_CODE = NVL(P_PRODUCT_RULE_TYPE_CODE
         ,PRB.PRODUCT_RULE_TYPE_CODE)
        AND PRB.APPLICATION_ID = NVL(P_APPLICATION_ID
         ,PRB.APPLICATION_ID)
        AND PRB.AMB_CONTEXT_CODE = NVL(FND_PROFILE.VALUE('XLA_AMB_CONTEXT')
         ,'DEFAULT');

Line: 144

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = 'R'
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 165

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 195

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = 'R'
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 216

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 246

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = 'R'
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 267

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 299

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = 'R'
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 320

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 350

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = 'R'
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 371

            UPDATE
              XLA_PRODUCT_RULES_B
            SET
              COMPILE_STATUS_CODE = L_COMPILE_STATUS_CODE
            WHERE APPLICATION_ID = L_APPLICATION_ID
              AND AMB_CONTEXT_CODE = L_AMB_CONTEXT_CODE
              AND PRODUCT_RULE_TYPE_CODE = L_PROD_RULE_TYPE_CODE
              AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;

Line: 393

      SELECT
        LEDGER_CATEGORY_CODE
      FROM
        XLA_GL_LEDGERS_V
      WHERE LEDGER_ID = P_LEDGER_ID;

Line: 406

      CP_JLD_SELECT := ' ';

Line: 414

      CP_JLD_SELECT := ' UNION
                       select app.application_name
                       ,lk11.meaning amb_context_dsp
                       ,err.amb_context_code
                       ,err.product_rule_code
                       ,null product_rule_name
                       ,err.product_rule_type_code
                       ,null product_rule_type_dsp
                       ,err.line_definition_owner_code
                       ,lk12.meaning line_definition_owner
                       ,err.line_definition_code
                       ,xld.name line_definition_name
                       ,err.category_sequence_num
                       ,err.message_category_code
                       ,lk2.meaning message_category_dsp
                       ,msg.message_number
                       ,err.message_type_flag
                       ,lk1.meaning message_type_dsp
                       ,ect.event_class_code
                       ,ect.name event_class_name
                       ,ett.event_type_code
                       ,ett.name event_type_name
                       ,err.description_code
                       ,dt.name description_name
                       ,err.description_type_code
                       ,lk5.meaning description_type_dsp
                       ,err.extract_object_name
                       ,err.extract_object_type_code
                       ,null extract_object_type_dsp
                       ,err.source_code
                       ,st.name source_name
                       ,err.source_type_code
                       ,lk9.meaning source_type_dsp
                       ,err.analytical_criterion_code
                       ,act.name analytical_criterion_name
                       ,err.analytical_criterion_type_code
                       ,lk6.meaning analytical_criterion_type_dsp
                       ,err.accounting_line_code
                       ,acb.name accounting_line_name
                       ,err.accounting_line_type_code
                       ,lk7.meaning accounting_line_type_dsp
                       ,err.mapping_set_code
                       ,mst.name mapping_set_name
                       ,err.segment_rule_code
                       ,srt.name segment_rule_name
                       ,err.segment_rule_type_code
                       ,lk8.meaning segment_rule_type_dsp
                       ,err.accounting_source_code
                       ,err.mapping_group_code
                       ,lk10.meaning mapping_group_dsp
                       ,ast1.name accounting_source_name
                       ,err.mpa_accounting_line_code
                       ,malt.name mpa_accounting_line_name
                       ,err.mpa_accounting_line_type_code
                       ,lk13.meaning mpa_accounting_line_type_dsp
                       ,msg.message_text ';

Line: 591

      CP_JLD_SELECT := ' ';

Line: 596

      CP_JLD_SELECT := ' ';

Line: 721

  FUNCTION CP_JLD_SELECT_P RETURN VARCHAR2 IS
  BEGIN
    RETURN CP_JLD_SELECT;

Line: 724

  END CP_JLD_SELECT_P;