APPS.OTA_VSP_API SQL Statements

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

Line: 33

    select 'YES'
      from OTA_ACTIVITY_VERSIONS                TAV
      where TAV.ACTIVITY_VERSION_ID      = P_ACTIVITY_VERSION_ID;

Line: 77

    select 'YES'
      from PO_VENDORS				VEN
      where VEN.VENDOR_ID		      =	P_VENDOR_ID;

Line: 122

    select 'NO'
      from OTA_VENDOR_SUPPLIES			VSP
      where VSP.ACTIVITY_VERSION_ID	      = P_ACTIVITY_VERSION_ID
        and VSP.VENDOR_ID		      = P_VENDOR_ID;

Line: 169

    select 'NO'
      from OTA_VENDOR_SUPPLIES			VSP
      where VSP.ACTIVITY_VERSION_ID	      =	P_ACTIVITY_VERSION_ID
        and VSP.PRIMARY_SUPPLIER_FLAG	      = P_PRIMARY_SUPPLIER_FLAG
        and VSP.VENDOR_ID		     <> P_VENDOR_ID;

Line: 255

    select vsp.vendor_id
         , vsp.primary_supplier_flag
         , vsp.comments
      from ota_vendor_supplies         vsp
     where vsp.activity_version_id     =  p_activity_version_from;

Line: 447

Procedure insert_dml(p_rec in out nocopy g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'insert_dml';

Line: 459

  insert into ota_vendor_supplies
  (	vendor_supply_id,
	vendor_id,
	activity_version_id,
	primary_supplier_flag,
	comments
  )
  Values
  (	p_rec.vendor_supply_id,
	p_rec.vendor_id,
	p_rec.activity_version_id,
	p_rec.primary_supplier_flag,
	p_rec.comments
  );

Line: 491

End insert_dml;

Line: 534

Procedure update_dml(p_rec in out nocopy g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'update_dml';

Line: 546

  update ota_vendor_supplies
  set
  vendor_supply_id                  = p_rec.vendor_supply_id,
  vendor_id                         = p_rec.vendor_id,
  activity_version_id               = p_rec.activity_version_id,
  primary_supplier_flag             = p_rec.primary_supplier_flag,
  comments                          = p_rec.comments
  where vendor_supply_id = p_rec.vendor_supply_id;

Line: 573

End update_dml;

Line: 614

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

Line: 625

  delete from ota_vendor_supplies
  where vendor_supply_id = p_rec.vendor_supply_id;

Line: 652

End delete_dml;

Line: 688

Procedure pre_insert(p_rec  in out nocopy g_rec_type) is
--
  l_proc	varchar2(72) := g_package||'pre_insert';

Line: 692

  Cursor C_Sel1 is select ota_vendor_supplies_s.nextval from sys.dual;

Line: 705

End pre_insert;

Line: 736

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

Line: 744

End pre_update;

Line: 775

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

Line: 783

End pre_delete;

Line: 814

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

Line: 822

End post_insert;

Line: 853

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

Line: 861

End post_update;

Line: 892

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

Line: 900

End post_delete;

Line: 955

    select 	vendor_supply_id,
	vendor_id,
	activity_version_id,
	primary_supplier_flag,
	comments
    from	ota_vendor_supplies
    where	vendor_supply_id = p_vendor_supply_id
    for	update nowait;

Line: 1167

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

Line: 1200

End insert_validate;

Line: 1231

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

Line: 1254

End update_validate;

Line: 1285

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

Line: 1295

End delete_validate;

Line: 1376

  insert_validate(p_rec);

Line: 1380

  pre_insert(p_rec);

Line: 1384

  insert_dml(p_rec);

Line: 1388

  post_insert(p_rec);

Line: 1585

  update_validate(convert_defs(p_rec));

Line: 1589

  pre_update(p_rec);

Line: 1593

  update_dml(p_rec);

Line: 1597

  post_update(p_rec);

Line: 1777

  delete_validate(p_rec);

Line: 1781

  pre_delete(p_rec);

Line: 1785

  delete_dml(p_rec);

Line: 1789

  post_delete(p_rec);