[Home] [Help]
1: Package Body pqh_trl_ins as
2: /* $Header: pqtrlrhi.pkb 115.3 2002/12/12 21:39:54 rpasapul noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_trl_ins.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< insert_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
239: );
240: --
241: -- Call the supporting pre-insert operation
242: --
243: pqh_trl_ins.pre_insert
244: (p_rec => p_rec
245: ,p_table_route_id => p_table_route_id
246: );
247: --
246: );
247: --
248: -- Insert the row
249: --
250: pqh_trl_ins.insert_dml(p_rec);
251: --
252: -- Call the supporting post-insert operation
253: --
254: pqh_trl_ins.post_insert
250: pqh_trl_ins.insert_dml(p_rec);
251: --
252: -- Call the supporting post-insert operation
253: --
254: pqh_trl_ins.post_insert
255: (p_rec
256: );
257: --
258: hr_utility.set_location('Leaving:'||l_proc, 20);
287: --
288: -- Having converted the arguments into the pqh_trl_rec
289: -- plsql record structure we call the corresponding record business process.
290: --
291: pqh_trl_ins.ins
292: (p_rec => l_rec
293: ,p_table_route_id => p_table_route_id
294: );
295: --
328: --
329: -- Insert a row for the base language and every installed language.
330: --
331: for l_lang in csr_ins_langs loop
332: pqh_trl_ins.ins
333: (p_table_route_id => p_table_route_id
334: ,p_language => l_lang.language_code
335: ,p_source_lang => p_language_code
336: ,p_display_name => p_display_name
339: --
340: hr_utility.set_location('Leaving:'||l_proc,20);
341: End ins_tl;
342: --
343: end pqh_trl_ins;