APPS.OTA_TFH_API_BUS SQL Statements

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

Line: 13

Procedure insert_validate
                 (
                  p_rec              in out  nocopy ota_tfh_api_shd.g_rec_type
                 ,p_transaction_type in      varchar2
                 ) is
--
  l_proc	varchar2(72) := g_package||'insert_validate';

Line: 141

End insert_validate;

Line: 172

Procedure update_validate(p_rec              in out nocopy  ota_tfh_api_shd.g_rec_type
                         ,p_transaction_type in      varchar2) is
--
  l_proc	varchar2(72) := g_package||'update_validate';

Line: 227

     ota_tfh_api_business_rules.check_update_header
                                   ( ota_tfh_api_shd.g_old_rec
                                   , p_rec
                                   , p_transaction_type);

Line: 311

    ota_tfh_api_business_rules.check_update_customer_id
                                        ( p_rec.customer_id
                                        , p_rec.address_id
                                        , p_rec.contact_id
                                        , p_rec.vendor_id );

Line: 416

End update_validate;

Line: 421

Procedure delete_validate(p_rec in ota_tfh_api_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 433

End delete_validate;

Line: 447

    select pbg.security_group_id,
           pbg.legislation_code
      from   per_business_groups_perf pbg,
                 ota_finance_headers tfh,
                 hr_all_organization_units org
          where  pbg.business_group_id    = org.business_group_id
            and  org.organization_id = tfh.organization_id
            and  tfh.finance_header_id = p_finance_header_id;

Line: 547

          select legislation_code
          from   per_business_groups_perf pbg,
                 ota_finance_headers tfh,
                 hr_all_organization_units org
          where  pbg.business_group_id    = org.business_group_id
            and  org.organization_id = tfh.organization_id
            and  tfh.finance_header_id = p_finance_header_id;