68: p_rec.object_version_number := 1; -- Initialise the object version
69: --
70: hxc_rtc_shd.g_api_dml := true; -- Set the api dml status
71: --
72: -- Insert the row into: hxc_retrieval_rule_comps
73: --
74: insert into hxc_retrieval_rule_comps
75: (retrieval_rule_comp_id
76: ,retrieval_rule_id
70: hxc_rtc_shd.g_api_dml := true; -- Set the api dml status
71: --
72: -- Insert the row into: hxc_retrieval_rule_comps
73: --
74: insert into hxc_retrieval_rule_comps
75: (retrieval_rule_comp_id
76: ,retrieval_rule_id
77: ,status
78: ,object_version_number
164: ) is
165: --
166: l_proc varchar2(72);
167: --
168: Cursor C_Sel1 is select hxc_retrieval_rule_comps_s.nextval from sys.dual;
169: --
170: Begin
171:
172:
253: --
254: when hr_api.cannot_find_prog_unit then
255: --
256: hr_api.cannot_find_prog_unit_error
257: (p_module_name => 'HXC_RETRIEVAL_RULE_COMPS'
258: ,p_hook_type => 'AI');
259: --
260: end;
261: --