[Home] [Help]
59: -- Added the following code as a part of Zero Downtime Patching Project.
60: -- Code Starts Here.
61: --
62: PER_RIC_PKG.chk_integrity(
63: p_entity_name=>'PQH_COPY_ENTITY_FUNCTIONS',
64: p_ref_entity_info=>
65: PER_RIC_PKG.ref_entity_tbl(
66: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.table_route_id, NULL))),
71: --
72: -- Code Ends Here
73: --
74: --
75: -- Insert the row into: pqh_copy_entity_functions
76: --
77: insert into pqh_copy_entity_functions
78: ( copy_entity_function_id,
79: table_route_id,
73: --
74: --
75: -- Insert the row into: pqh_copy_entity_functions
76: --
77: insert into pqh_copy_entity_functions
78: ( copy_entity_function_id,
79: table_route_id,
80: function_type_cd,
81: pre_copy_function_name,
154: Procedure pre_insert(p_rec in out nocopy pqh_cef_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'pre_insert';
157: --
158: Cursor C_Sel1 is select pqh_copy_entity_functions_s.nextval from sys.dual;
159: --
160: Begin
161: hr_utility.set_location('Entering:'||l_proc, 5);
162: --
232: --
233: when hr_api.cannot_find_prog_unit then
234: --
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'pqh_copy_entity_functions'
237: ,p_hook_type => 'AI');
238: --
239: end;
240: --