DBA Data[Home] [Help]

APPS.PQH_RAP_DEL dependencies on PQH_RAP_SHD

Line 52: (p_rec in pqh_rap_shd.g_rec_type

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

Line 76: pqh_rap_shd.constraint_error

72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: pqh_rap_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;

Line 115: Procedure pre_delete(p_rec in pqh_rap_shd.g_rec_type) is

111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in pqh_rap_shd.g_rec_type) is
116: --
117: l_proc constant varchar2(72):= g_package||'pre_delete';
118: --
119: Begin

Line 158: Procedure post_delete(p_rec in pqh_rap_shd.g_rec_type) is

154: -- Internal Row Handler Use Only.
155: --
156: -- {End Of Comments}
157: -- -----------------------------------------------------------------------------
158: Procedure post_delete(p_rec in pqh_rap_shd.g_rec_type) is
159: --
160: l_proc constant varchar2(72):= g_package||'post_delete';
161: --
162: Begin

Line 171: => pqh_rap_shd.g_old_rec.rank_process_id

167: pqh_rap_rkd.after_delete
168: (p_rank_process_approval_id
169: => p_rec.rank_process_approval_id
170: ,p_rank_process_id_o
171: => pqh_rap_shd.g_old_rec.rank_process_id
172: ,p_approval_date_o
173: => pqh_rap_shd.g_old_rec.approval_date
174: ,p_supervisor_id_o
175: => pqh_rap_shd.g_old_rec.supervisor_id

Line 173: => pqh_rap_shd.g_old_rec.approval_date

169: => p_rec.rank_process_approval_id
170: ,p_rank_process_id_o
171: => pqh_rap_shd.g_old_rec.rank_process_id
172: ,p_approval_date_o
173: => pqh_rap_shd.g_old_rec.approval_date
174: ,p_supervisor_id_o
175: => pqh_rap_shd.g_old_rec.supervisor_id
176: ,p_system_rank_o
177: => pqh_rap_shd.g_old_rec.system_rank

Line 175: => pqh_rap_shd.g_old_rec.supervisor_id

171: => pqh_rap_shd.g_old_rec.rank_process_id
172: ,p_approval_date_o
173: => pqh_rap_shd.g_old_rec.approval_date
174: ,p_supervisor_id_o
175: => pqh_rap_shd.g_old_rec.supervisor_id
176: ,p_system_rank_o
177: => pqh_rap_shd.g_old_rec.system_rank
178: ,p_population_count_o
179: => pqh_rap_shd.g_old_rec.population_count

Line 177: => pqh_rap_shd.g_old_rec.system_rank

173: => pqh_rap_shd.g_old_rec.approval_date
174: ,p_supervisor_id_o
175: => pqh_rap_shd.g_old_rec.supervisor_id
176: ,p_system_rank_o
177: => pqh_rap_shd.g_old_rec.system_rank
178: ,p_population_count_o
179: => pqh_rap_shd.g_old_rec.population_count
180: ,p_proposed_rank_o
181: => pqh_rap_shd.g_old_rec.proposed_rank

Line 179: => pqh_rap_shd.g_old_rec.population_count

175: => pqh_rap_shd.g_old_rec.supervisor_id
176: ,p_system_rank_o
177: => pqh_rap_shd.g_old_rec.system_rank
178: ,p_population_count_o
179: => pqh_rap_shd.g_old_rec.population_count
180: ,p_proposed_rank_o
181: => pqh_rap_shd.g_old_rec.proposed_rank
182: ,p_object_version_number_o
183: => pqh_rap_shd.g_old_rec.object_version_number

Line 181: => pqh_rap_shd.g_old_rec.proposed_rank

177: => pqh_rap_shd.g_old_rec.system_rank
178: ,p_population_count_o
179: => pqh_rap_shd.g_old_rec.population_count
180: ,p_proposed_rank_o
181: => pqh_rap_shd.g_old_rec.proposed_rank
182: ,p_object_version_number_o
183: => pqh_rap_shd.g_old_rec.object_version_number
184: );
185: --

Line 183: => pqh_rap_shd.g_old_rec.object_version_number

179: => pqh_rap_shd.g_old_rec.population_count
180: ,p_proposed_rank_o
181: => pqh_rap_shd.g_old_rec.proposed_rank
182: ,p_object_version_number_o
183: => pqh_rap_shd.g_old_rec.object_version_number
184: );
185: --
186: exception
187: --

Line 203: (p_rec in pqh_rap_shd.g_rec_type

199: -- ----------------------------------------------------------------------------
200: -- |---------------------------------< del >----------------------------------|
201: -- ----------------------------------------------------------------------------
202: Procedure del
203: (p_rec in pqh_rap_shd.g_rec_type
204: ) is
205: --
206: l_proc constant varchar2(72):= g_package||'del';
207: --

Line 214: pqh_rap_shd.lck

210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- We must lock the row which we need to delete.
213: --
214: pqh_rap_shd.lck
215: (p_rec.rank_process_approval_id
216: ,p_rec.object_version_number
217: );
218: --

Line 251: l_rec pqh_rap_shd.g_rec_type;

247: (p_rank_process_approval_id in number
248: ,p_object_version_number in number
249: ) is
250: --
251: l_rec pqh_rap_shd.g_rec_type;
252: l_proc constant varchar2(72):= g_package||'del';
253: --
254: Begin
255: