DBA Data[Home] [Help]

APPS.OTA_TPL_INS dependencies on OTA_PRICE_LISTS

Line 63: -- Insert the row into: ota_price_lists

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

Line 65: insert into ota_price_lists

61: ota_tpl_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ota_price_lists
64: --
65: insert into ota_price_lists
66: ( price_list_id,
67: business_group_id,
68: currency_code,
69: default_flag,

Line 203: Cursor C_Sel1 is select ota_price_lists_s.nextval from sys.dual;

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