APPS.JG_ZZ_VAT_REP_FINAL_REPORTING SQL Statements

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

Line: 59

      select
        application_id               ,
        entity_code                  ,
        event_class_code             ,
        trx_id                       ,
        trx_line_id                  ,
        internal_organization_id     ,
        tax_line_id
      from
        jg_zz_vat_trx_details
      where
        reporting_status_id  in
          (
            select reporting_status_id
            from   jg_zz_vat_rep_status
            Where  vat_reporting_entity_id  = cpn_vat_reporting_entity_id
            and    tax_calendar_period =  cpv_tax_calendar_period
            and   ( (cpv_source  = 'ALL') OR (cpv_source <> 'ALL' and source = cpv_source) )
        );

Line: 82

      select enable_allocations_flag
      from   jg_zz_vat_rep_entities
      where  vat_reporting_entity_id = pn_vat_reporting_entity_id;

Line: 87

      Select jg_zz_vat_rep_status_s3.nextval
      From dual;

Line: 94

    SELECT 'Y'
    FROM JG_ZZ_VAT_REP_STATUS RPS
    WHERE RPS.VAT_REPORTING_ENTITY_ID= pn_vat_reporting_entity_id
    AND   RPS.TAX_CALENDAR_PERIOD = pn_period
    AND   RPS.period_start_date >
         NVL((SELECT glp.end_date
                FROM  jg_zz_vat_rep_entities legal
                     ,jg_zz_vat_rep_entities acct
                     ,gl_periods             glp
                WHERE acct.entity_type_code='ACCOUNTING'
                AND acct.vat_reporting_entity_id = pn_vat_reporting_entity_id
                AND acct.mapping_vat_rep_entity_id= legal.vat_reporting_entity_id
                AND glp.period_set_name   = legal.tax_calendar_name
                AND glp.period_name  =  acct.last_reported_period),RPS.period_start_date-1)
    AND rownum=1;

Line: 116

    SELECT entity_level_code
    INTO l_entity_level_code
    FROM jg_zz_vat_rep_entities
    WHERE vat_reporting_entity_id =pn_vat_reporting_entity_id;

Line: 166

    /* Check if Allocation is disabled, if disabled this needs to be updated at final reporting */
    open  c_jg_zz_vat_rep_entities(pn_vat_reporting_entity_id );

Line: 188

    /* Call the eBtax API to update transactions in eBtax as finally reported */
    zx_extract_pkg.zx_upd_legal_reporting_status
    (
      p_api_version                  => jg_zz_vat_rep_final_reporting.gn_api_version             ,
      p_init_msg_list                => fnd_api.g_false                                          ,
      p_commit                       => fnd_api.g_false                                          ,
      p_validation_level             => null                                                     ,
      p_application_id_tbl           => ltn_application_id                                       ,
      p_entity_code_tbl              => ltv_entity_code                                          ,
      p_event_class_code_tbl         => ltv_event_class_code                                     ,
      p_trx_id_tbl                   => ltn_trx_id                                               ,
      p_trx_line_id_tbl              => ltn_trx_line_id                                          ,
      p_internal_organization_id_tbl => ltn_internal_organization_id                             ,
      p_tax_line_id_tbl              => ltn_tax_line_id                                          ,
      p_legal_reporting_status_val   => jg_zz_vat_rep_final_reporting.gv_legal_reporting_status  ,
      x_return_status                => lv_return_status                                         ,
      x_msg_count                    => ln_msg_count                                             ,
      x_msg_data                     => lv_msg_data
    );

Line: 218

    update jg_zz_vat_trx_details
    set    final_reporting_id =  ln_final_reporting_id,
            last_updated_by    =  fnd_global.user_id,
            last_update_date   =  trunc(sysdate),
            last_update_login  =  fnd_global.login_id
            where  reporting_status_id  in
            (
            select reporting_status_id
            from   jg_zz_vat_rep_status
            Where  vat_reporting_entity_id  = pn_vat_reporting_entity_id
            and    tax_calendar_period =  pv_tax_calendar_period
            and   ( (pv_source  = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) )
            );

Line: 232

    jg_zz_vat_rep_utility.post_process_update
    (
      pn_vat_reporting_entity_id         =>     pn_vat_reporting_entity_id       ,
      pv_tax_calendar_period             =>     pv_tax_calendar_period           ,
      pv_source                          =>     pv_source                        ,
      pv_process_name                    =>     'FINAL REPORTING'                ,
      pn_process_id                      =>     ln_final_reporting_id            ,
      pv_process_flag                    =>     fnd_api.g_ret_sts_success        ,
      pv_enable_allocations_flag         =>     lv_enable_allocations_flag       ,
      xv_return_status                   =>     lv_return_status                 ,
      xv_return_message                  =>     lv_return_message
    );