APPS.OTA_VSP_API dependencies on OTA_VENDOR_SUPPLIES

Line 123: from OTA_VENDOR_SUPPLIES VSP

119: W_OK varchar2 (3);
120: --
121: cursor C1 is
122: select 'NO'
123: from OTA_VENDOR_SUPPLIES VSP
124: where VSP.ACTIVITY_VERSION_ID = P_ACTIVITY_VERSION_ID
125: and VSP.VENDOR_ID = P_VENDOR_ID;
126: --
127: begin

Line 170: from OTA_VENDOR_SUPPLIES VSP

166: W_OK varchar2 (3);
167: --
168: cursor C1 is
169: select 'NO'
170: from OTA_VENDOR_SUPPLIES VSP
171: where VSP.ACTIVITY_VERSION_ID = P_ACTIVITY_VERSION_ID
172: and VSP.PRIMARY_SUPPLIER_FLAG = P_PRIMARY_SUPPLIER_FLAG
173: and VSP.VENDOR_ID <> P_VENDOR_ID;
174: --

Line 258: from ota_vendor_supplies vsp

254: cursor sel_vendor_supply is
255: select vsp.vendor_id
256: , vsp.primary_supplier_flag
257: , vsp.comments
258: from ota_vendor_supplies vsp
259: where vsp.activity_version_id = p_activity_version_from;
260: --
261: Begin
262: --

Line 387: If (p_constraint_name = 'OTA_VENDOR_SUPPLIES_FK1') Then

383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: If (p_constraint_name = 'OTA_VENDOR_SUPPLIES_FK1') Then
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE', l_proc);
390: hr_utility.set_message_token('STEP','5');
391: hr_utility.raise_error;

Line 457: -- Insert the row into: ota_vendor_supplies

453: --
454: --
455: g_api_dml := true; -- Set the api dml status
456: --
457: -- Insert the row into: ota_vendor_supplies
458: --
459: insert into ota_vendor_supplies
460: ( vendor_supply_id,
461: vendor_id,

Line 459: insert into ota_vendor_supplies

455: g_api_dml := true; -- Set the api dml status
456: --
457: -- Insert the row into: ota_vendor_supplies
458: --
459: insert into ota_vendor_supplies
460: ( vendor_supply_id,
461: vendor_id,
462: activity_version_id,
463: primary_supplier_flag,

Line 544: -- Update the ota_vendor_supplies Row

540: --
541: --
542: g_api_dml := true; -- Set the api dml status
543: --
544: -- Update the ota_vendor_supplies Row
545: --
546: update ota_vendor_supplies
547: set
548: vendor_supply_id = p_rec.vendor_supply_id,

Line 546: update ota_vendor_supplies

542: g_api_dml := true; -- Set the api dml status
543: --
544: -- Update the ota_vendor_supplies Row
545: --
546: update ota_vendor_supplies
547: set
548: vendor_supply_id = p_rec.vendor_supply_id,
549: vendor_id = p_rec.vendor_id,
550: activity_version_id = p_rec.activity_version_id,

Line 623: -- Delete the ota_vendor_supplies row.

619: hr_utility.set_location('Entering:'||l_proc, 5);
620: --
621: g_api_dml := true; -- Set the api dml status
622: --
623: -- Delete the ota_vendor_supplies row.
624: --
625: delete from ota_vendor_supplies
626: where vendor_supply_id = p_rec.vendor_supply_id;
627: --

Line 625: delete from ota_vendor_supplies

621: g_api_dml := true; -- Set the api dml status
622: --
623: -- Delete the ota_vendor_supplies row.
624: --
625: delete from ota_vendor_supplies
626: where vendor_supply_id = p_rec.vendor_supply_id;
627: --
628: g_api_dml := false; -- Unset the api dml status
629: --

Line 692: Cursor C_Sel1 is select ota_vendor_supplies_s.nextval from sys.dual;

688: Procedure pre_insert(p_rec in out nocopy g_rec_type) is
689: --
690: l_proc varchar2(72) := g_package||'pre_insert';
691: --
692: Cursor C_Sel1 is select ota_vendor_supplies_s.nextval from sys.dual;
693: --
694: Begin
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: --

Line 960: from ota_vendor_supplies

956: vendor_id,
957: activity_version_id,
958: primary_supplier_flag,
959: comments
960: from ota_vendor_supplies
961: where vendor_supply_id = p_vendor_supply_id
962: for update nowait;
963: --
964: l_proc varchar2(72) := g_package||'lck';

Line 986: hr_utility.set_message_token('TABLE_NAME', 'ota_vendor_supplies');

982: -- b) The row is NOT current (i.e. failure on the object version).
983: --
984: Close C_Sel1;
985: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
986: hr_utility.set_message_token('TABLE_NAME', 'ota_vendor_supplies');
987: hr_utility.raise_error;
988: End If;
989: Close C_Sel1;
990: --

Line 1002: hr_utility.set_message_token('TABLE_NAME', 'ota_vendor_supplies');

998: -- The object is locked therefore we need to supply a meaningful
999: -- error message.
1000: --
1001: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1002: hr_utility.set_message_token('TABLE_NAME', 'ota_vendor_supplies');
1003: hr_utility.raise_error;
1004: End lck;
1005: --
1006: -- ----------------------------------------------------------------------------