DBA Data[Home] [Help]

APPS.PER_SOL_DEL dependencies on PER_SOL_SHD

Line 52: (p_rec in per_sol_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_sol_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 91: per_sol_shd.constraint_error

87: Exception
88: When hr_api.child_integrity_violated then
89: -- Child integrity has been violated
90: --
91: per_sol_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: --
95: Raise;

Line 130: Procedure pre_delete(p_rec in per_sol_shd.g_rec_type) is

126: -- Internal Row Handler Use Only.
127: --
128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130: Procedure pre_delete(p_rec in per_sol_shd.g_rec_type) is
131: --
132: l_proc varchar2(72) := g_package||'pre_delete';
133: --
134: Begin

Line 172: Procedure post_delete(p_rec in per_sol_shd.g_rec_type) is

168: -- Internal Row Handler Use Only.
169: --
170: -- {End Of Comments}
171: -- -----------------------------------------------------------------------------
172: Procedure post_delete(p_rec in per_sol_shd.g_rec_type) is
173: --
174: l_proc varchar2(72) := g_package||'post_delete';
175: --
176: Begin

Line 184: => per_sol_shd.g_old_rec.solution_name

180: per_sol_rkd.after_delete
181: (p_solution_id
182: => p_rec.solution_id
183: ,p_solution_name_o
184: => per_sol_shd.g_old_rec.solution_name
185: ,p_description_o
186: => per_sol_shd.g_old_rec.description
187: ,p_link_to_full_description_o
188: => per_sol_shd.g_old_rec.link_to_full_description

Line 186: => per_sol_shd.g_old_rec.description

182: => p_rec.solution_id
183: ,p_solution_name_o
184: => per_sol_shd.g_old_rec.solution_name
185: ,p_description_o
186: => per_sol_shd.g_old_rec.description
187: ,p_link_to_full_description_o
188: => per_sol_shd.g_old_rec.link_to_full_description
189: ,p_solution_type_name_o
190: => per_sol_shd.g_old_rec.solution_type_name

Line 188: => per_sol_shd.g_old_rec.link_to_full_description

184: => per_sol_shd.g_old_rec.solution_name
185: ,p_description_o
186: => per_sol_shd.g_old_rec.description
187: ,p_link_to_full_description_o
188: => per_sol_shd.g_old_rec.link_to_full_description
189: ,p_solution_type_name_o
190: => per_sol_shd.g_old_rec.solution_type_name
191: ,p_vertical_o
192: => per_sol_shd.g_old_rec.vertical

Line 190: => per_sol_shd.g_old_rec.solution_type_name

186: => per_sol_shd.g_old_rec.description
187: ,p_link_to_full_description_o
188: => per_sol_shd.g_old_rec.link_to_full_description
189: ,p_solution_type_name_o
190: => per_sol_shd.g_old_rec.solution_type_name
191: ,p_vertical_o
192: => per_sol_shd.g_old_rec.vertical
193: ,p_legislation_code_o
194: => per_sol_shd.g_old_rec.legislation_code

Line 192: => per_sol_shd.g_old_rec.vertical

188: => per_sol_shd.g_old_rec.link_to_full_description
189: ,p_solution_type_name_o
190: => per_sol_shd.g_old_rec.solution_type_name
191: ,p_vertical_o
192: => per_sol_shd.g_old_rec.vertical
193: ,p_legislation_code_o
194: => per_sol_shd.g_old_rec.legislation_code
195: ,p_user_id_o
196: => per_sol_shd.g_old_rec.user_id

Line 194: => per_sol_shd.g_old_rec.legislation_code

190: => per_sol_shd.g_old_rec.solution_type_name
191: ,p_vertical_o
192: => per_sol_shd.g_old_rec.vertical
193: ,p_legislation_code_o
194: => per_sol_shd.g_old_rec.legislation_code
195: ,p_user_id_o
196: => per_sol_shd.g_old_rec.user_id
197: ,p_object_version_number_o
198: => per_sol_shd.g_old_rec.object_version_number

Line 196: => per_sol_shd.g_old_rec.user_id

192: => per_sol_shd.g_old_rec.vertical
193: ,p_legislation_code_o
194: => per_sol_shd.g_old_rec.legislation_code
195: ,p_user_id_o
196: => per_sol_shd.g_old_rec.user_id
197: ,p_object_version_number_o
198: => per_sol_shd.g_old_rec.object_version_number
199: );
200: --

Line 198: => per_sol_shd.g_old_rec.object_version_number

194: => per_sol_shd.g_old_rec.legislation_code
195: ,p_user_id_o
196: => per_sol_shd.g_old_rec.user_id
197: ,p_object_version_number_o
198: => per_sol_shd.g_old_rec.object_version_number
199: );
200: --
201: exception
202: --

Line 218: (p_rec in per_sol_shd.g_rec_type

214: -- ----------------------------------------------------------------------------
215: -- |---------------------------------< del >----------------------------------|
216: -- ----------------------------------------------------------------------------
217: Procedure del
218: (p_rec in per_sol_shd.g_rec_type
219: ) is
220: --
221: l_proc varchar2(72) := g_package||'del';
222: --

Line 228: per_sol_shd.lck

224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: -- We must lock the row which we need to delete.
227: --
228: per_sol_shd.lck
229: (p_rec.solution_id
230: ,p_rec.object_version_number
231: );
232: --

Line 265: l_rec per_sol_shd.g_rec_type;

261: (p_solution_id in number
262: ,p_object_version_number in number
263: ) is
264: --
265: l_rec per_sol_shd.g_rec_type;
266: l_proc varchar2(72) := g_package||'del';
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);