APPS.OTA_TFL_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_tfl_api_shd.g_rec_type
                         , p_transaction_type  in varchar2) is

--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 112

End insert_validate;

Line: 117

Procedure update_validate( p_rec               in out nocopy ota_tfl_api_shd.g_rec_type
                         , p_money_amount      in out nocopy number
                         , p_unitary_amount    in out nocopy number
                         , p_date_raised       in out nocopy date
                         , p_sequence_number   in out nocopy number
                         , p_transaction_type  in varchar2) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 230

  ota_tfl_api_business_rules.check_update_cancelled_flag
                                     ( p_rec.cancelled_flag );

Line: 234

  ota_tfl_api_business_rules.check_update_attributes(p_rec.transfer_status);

Line: 249

          fnd_message.set_name('OTA','OTA_13354_TFL_NO_TYPE_UPDATE');

Line: 348

End update_validate;

Line: 353

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

Line: 364

        fnd_message.set_name('OTA','OTA_13610_TFL_DELETE_CHK');

Line: 369

End delete_validate;

Line: 383

    select pbg.security_group_id,
           pbg.legislation_code
      from   per_business_groups_perf pbg,
                 ota_finance_headers tfh,
                 ota_finance_lines tfl,
		 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 = tfl.finance_header_id
	    and  tfl.finance_line_id = p_finance_line_id;

Line: 485

          select legislation_code
          from   per_business_groups_perf pbg,
                 ota_finance_headers tfh,
		 ota_finance_lines tfl,
                 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 = tfl.finance_header_id
	    and  tfl.finance_line_id = p_finance_line_id;