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,
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,
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: --