DBA Data[Home] [Help]

APPS.OTA_PLE_INS dependencies on OTA_PRICE_LIST_ENTRIES

Line 63: -- Insert the row into: ota_price_list_entries

59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: ota_ple_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ota_price_list_entries
64: --
65: insert into ota_price_list_entries
66: ( price_list_entry_id,
67: vendor_supply_id,

Line 65: insert into ota_price_list_entries

61: ota_ple_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ota_price_list_entries
64: --
65: insert into ota_price_list_entries
66: ( price_list_entry_id,
67: vendor_supply_id,
68: activity_version_id,
69: price_list_id,

Line 201: Cursor C_Sel1 is select ota_price_list_entries_s.nextval from sys.dual;

197: Procedure pre_insert(p_rec in out ota_ple_shd.g_rec_type) is
198: --
199: l_proc varchar2(72) := g_package||'pre_insert';
200: --
201: Cursor C_Sel1 is select ota_price_list_entries_s.nextval from sys.dual;
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --