48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: --
54: --
55: --
56: -- Insert the row into: pqh_rule_sets_tl
70: p_rec.source_lang
71: );
72: --
73: --
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: Exception
76: When hr_api.check_integrity_violated Then
77: -- A check constraint has been violated
78: pqh_rtl_shd.constraint_error
132: l_proc varchar2(72) := g_package||'pre_insert';
133: --
134: --
135: Begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --
138: --
139: -- Select the next sequence number
140: --
139: -- Select the next sequence number
140: --
141: p_rec.rule_set_id := p_rule_set_id;
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_insert;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< post_insert >------------------------------|
179: --
180: l_proc varchar2(72) := g_package||'post_insert';
181: --
182: Begin
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: --
186: -- Start of API User Hook for post_insert.
187: --
208: --
209: -- End of API User Hook for post_insert.
210: --
211: --
212: hr_utility.set_location(' Leaving:'||l_proc, 10);
213: End post_insert;
214: --
215: -- ----------------------------------------------------------------------------
216: -- |---------------------------------< ins >----------------------------------|
223: --
224: l_proc varchar2(72) := g_package||'ins';
225: --
226: Begin
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: -- Call the supporting insert validate operations
230: --
231: pqh_rtl_bus.insert_validate(p_rec);
259: l_rec pqh_rtl_shd.g_rec_type;
260: l_proc varchar2(72) := g_package||'ins';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: -- Call conversion function to turn arguments into the
266: -- p_rec structure.
267: --
282: ins(p_rec => l_rec,
283: p_rule_set_id => p_rule_set_id);
284: --
285: --
286: hr_utility.set_location(' Leaving:'||l_proc, 10);
287: End ins;
288: --
289: -- ----------------------------------------------------------------------------
290: -- |------------------------------< ins_tl >----------------------------------|
308: l_proc varchar2(72) := g_package||'ins_tl';
309: --
310: begin
311: --
312: hr_utility.set_location(' Entering:'||l_proc, 10);
313: --
314: for l_lang in csr_ins_langs loop
315:
316: ins(p_rule_set_id => p_rule_set_id,
320: p_source_lang => p_language_code);
321: --
322: end loop;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 20);
325: --
326: end ins_tl;
327: --
328: end pqh_rtl_ins;