59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: hr_ppu_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_pattern_purpose_usages
64: --
65: insert into hr_pattern_purpose_usages
66: ( purpose_usage_id,
67: entity_name,
61: hr_ppu_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_pattern_purpose_usages
64: --
65: insert into hr_pattern_purpose_usages
66: ( purpose_usage_id,
67: entity_name,
68: pattern_purpose,
69: hierarchy_level,
141: Procedure pre_insert(p_rec in out hr_ppu_shd.g_rec_type) is
142: --
143: l_proc varchar2(72) := g_package||'pre_insert';
144: --
145: Cursor C_Sel1 is select hr_pattern_purpose_usages_s.nextval from sys.dual;
146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --