DBA Data[Home] [Help]

APPS.PER_SOL_DEL dependencies on PER_SOLUTIONS

Line 66: p_entity_name=>'PER_SOLUTIONS',

62: -- Added the following code as a part of Zero Downtime Patching Project.
63: -- Code Starts Here.
64: --
65: PER_RIC_PKG.chk_integrity(
66: p_entity_name=>'PER_SOLUTIONS',
67: p_ref_entity_info=>
68: PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS_SELECTED',PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),

Line 69: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS_SELECTED',PER_RIC_PKG.column_info_tbl(

65: PER_RIC_PKG.chk_integrity(
66: p_entity_name=>'PER_SOLUTIONS',
67: p_ref_entity_info=>
68: PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS_SELECTED',PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('SOLUTION_ID',NULL, p_rec.solution_id,NULL))),
71: PER_RIC_PKG.ref_info_rec('PER_SOLUTION_CMPT_NAMES',PER_RIC_PKG.column_info_tbl(
72: PER_RIC_PKG.col_info_rec('SOLUTION_ID', NULL,p_rec.solution_id, NULL)))),
73: p_ref_type=>'DEL');

Line 78: -- Delete the per_solutions row.

74: --
75: -- Code Ends Here
76: --
77: --
78: -- Delete the per_solutions row.
79: --
80: delete from per_solutions
81: where solution_id = p_rec.solution_id;
82: --

Line 80: delete from per_solutions

76: --
77: --
78: -- Delete the per_solutions row.
79: --
80: delete from per_solutions
81: where solution_id = p_rec.solution_id;
82: --
83: --
84: --

Line 206: (p_module_name => 'PER_SOLUTIONS'

202: --
203: when hr_api.cannot_find_prog_unit then
204: --
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'PER_SOLUTIONS'
207: ,p_hook_type => 'AD');
208: --
209: end;
210: --