[Home] [Help]
56: -- Added the following code as a part of Zero Downtime Patching Project.
57: -- Code Starts Here.
58: --
59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.consolidated_table_route_id, NULL))),
68: --
69: --
70: -- Code Ends Here
71: --
72: -- Insert the row into: pqh_transaction_categories
73: --
74: insert into pqh_transaction_categories
75: ( transaction_category_id,
76: custom_wf_process_name,
70: -- Code Ends Here
71: --
72: -- Insert the row into: pqh_transaction_categories
73: --
74: insert into pqh_transaction_categories
75: ( transaction_category_id,
76: custom_wf_process_name,
77: custom_workflow_name,
78: form_name,
177: Procedure pre_insert(p_rec in out nocopy pqh_tct_shd.g_rec_type) is
178: --
179: l_proc varchar2(72) := g_package||'pre_insert';
180: --
181: Cursor C_Sel1 is select pqh_transaction_categories_s.nextval from sys.dual;
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
268: --
269: when hr_api.cannot_find_prog_unit then
270: --
271: hr_api.cannot_find_prog_unit_error
272: (p_module_name => 'pqh_transaction_categories'
273: ,p_hook_type => 'AI');
274: --
275: end;
276: --