eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RNK_DEL dependencies on PQH_RNK_SHD

Line 52: (p_rec in pqh_rnk_shd.g_rec_type

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

Line 75: pqh_rnk_shd.constraint_error

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

Line 114: Procedure pre_delete(p_rec in pqh_rnk_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in pqh_rnk_shd.g_rec_type) is

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

Line 168: => pqh_rnk_shd.g_old_rec.pgm_id

164: pqh_rnk_rkd.after_delete
165: (p_rank_process_id
166: => p_rec.rank_process_id
167: ,p_pgm_id_o
168: => pqh_rnk_shd.g_old_rec.pgm_id
169: ,p_pl_id_o
170: => pqh_rnk_shd.g_old_rec.pl_id
171: ,p_oipl_id_o
172: => pqh_rnk_shd.g_old_rec.oipl_id

Line 170: => pqh_rnk_shd.g_old_rec.pl_id

166: => p_rec.rank_process_id
167: ,p_pgm_id_o
168: => pqh_rnk_shd.g_old_rec.pgm_id
169: ,p_pl_id_o
170: => pqh_rnk_shd.g_old_rec.pl_id
171: ,p_oipl_id_o
172: => pqh_rnk_shd.g_old_rec.oipl_id
173: ,p_process_cd_o
174: => pqh_rnk_shd.g_old_rec.process_cd

Line 172: => pqh_rnk_shd.g_old_rec.oipl_id

168: => pqh_rnk_shd.g_old_rec.pgm_id
169: ,p_pl_id_o
170: => pqh_rnk_shd.g_old_rec.pl_id
171: ,p_oipl_id_o
172: => pqh_rnk_shd.g_old_rec.oipl_id
173: ,p_process_cd_o
174: => pqh_rnk_shd.g_old_rec.process_cd
175: ,p_process_date_o
176: => pqh_rnk_shd.g_old_rec.process_date

Line 174: => pqh_rnk_shd.g_old_rec.process_cd

170: => pqh_rnk_shd.g_old_rec.pl_id
171: ,p_oipl_id_o
172: => pqh_rnk_shd.g_old_rec.oipl_id
173: ,p_process_cd_o
174: => pqh_rnk_shd.g_old_rec.process_cd
175: ,p_process_date_o
176: => pqh_rnk_shd.g_old_rec.process_date
177: ,p_benefit_action_id_o
178: => pqh_rnk_shd.g_old_rec.benefit_action_id

Line 176: => pqh_rnk_shd.g_old_rec.process_date

172: => pqh_rnk_shd.g_old_rec.oipl_id
173: ,p_process_cd_o
174: => pqh_rnk_shd.g_old_rec.process_cd
175: ,p_process_date_o
176: => pqh_rnk_shd.g_old_rec.process_date
177: ,p_benefit_action_id_o
178: => pqh_rnk_shd.g_old_rec.benefit_action_id
179: ,p_person_id_o
180: => pqh_rnk_shd.g_old_rec.person_id

Line 178: => pqh_rnk_shd.g_old_rec.benefit_action_id

174: => pqh_rnk_shd.g_old_rec.process_cd
175: ,p_process_date_o
176: => pqh_rnk_shd.g_old_rec.process_date
177: ,p_benefit_action_id_o
178: => pqh_rnk_shd.g_old_rec.benefit_action_id
179: ,p_person_id_o
180: => pqh_rnk_shd.g_old_rec.person_id
181: ,p_assignment_id_o
182: => pqh_rnk_shd.g_old_rec.assignment_id

Line 180: => pqh_rnk_shd.g_old_rec.person_id

176: => pqh_rnk_shd.g_old_rec.process_date
177: ,p_benefit_action_id_o
178: => pqh_rnk_shd.g_old_rec.benefit_action_id
179: ,p_person_id_o
180: => pqh_rnk_shd.g_old_rec.person_id
181: ,p_assignment_id_o
182: => pqh_rnk_shd.g_old_rec.assignment_id
183: ,p_total_score_o
184: => pqh_rnk_shd.g_old_rec.total_score

Line 182: => pqh_rnk_shd.g_old_rec.assignment_id

178: => pqh_rnk_shd.g_old_rec.benefit_action_id
179: ,p_person_id_o
180: => pqh_rnk_shd.g_old_rec.person_id
181: ,p_assignment_id_o
182: => pqh_rnk_shd.g_old_rec.assignment_id
183: ,p_total_score_o
184: => pqh_rnk_shd.g_old_rec.total_score
185: ,p_object_version_number_o
186: => pqh_rnk_shd.g_old_rec.object_version_number

Line 184: => pqh_rnk_shd.g_old_rec.total_score

180: => pqh_rnk_shd.g_old_rec.person_id
181: ,p_assignment_id_o
182: => pqh_rnk_shd.g_old_rec.assignment_id
183: ,p_total_score_o
184: => pqh_rnk_shd.g_old_rec.total_score
185: ,p_object_version_number_o
186: => pqh_rnk_shd.g_old_rec.object_version_number
187: ,p_request_id_o
188: => pqh_rnk_shd.g_old_rec.request_id

Line 186: => pqh_rnk_shd.g_old_rec.object_version_number

182: => pqh_rnk_shd.g_old_rec.assignment_id
183: ,p_total_score_o
184: => pqh_rnk_shd.g_old_rec.total_score
185: ,p_object_version_number_o
186: => pqh_rnk_shd.g_old_rec.object_version_number
187: ,p_request_id_o
188: => pqh_rnk_shd.g_old_rec.request_id
189: ,p_business_group_id_o
190: => pqh_rnk_shd.g_old_rec.business_group_id

Line 188: => pqh_rnk_shd.g_old_rec.request_id

184: => pqh_rnk_shd.g_old_rec.total_score
185: ,p_object_version_number_o
186: => pqh_rnk_shd.g_old_rec.object_version_number
187: ,p_request_id_o
188: => pqh_rnk_shd.g_old_rec.request_id
189: ,p_business_group_id_o
190: => pqh_rnk_shd.g_old_rec.business_group_id
191: ,p_per_in_ler_id_o
192: => pqh_rnk_shd.g_old_rec.per_in_ler_id

Line 190: => pqh_rnk_shd.g_old_rec.business_group_id

186: => pqh_rnk_shd.g_old_rec.object_version_number
187: ,p_request_id_o
188: => pqh_rnk_shd.g_old_rec.request_id
189: ,p_business_group_id_o
190: => pqh_rnk_shd.g_old_rec.business_group_id
191: ,p_per_in_ler_id_o
192: => pqh_rnk_shd.g_old_rec.per_in_ler_id
193: );
194: --

Line 192: => pqh_rnk_shd.g_old_rec.per_in_ler_id

188: => pqh_rnk_shd.g_old_rec.request_id
189: ,p_business_group_id_o
190: => pqh_rnk_shd.g_old_rec.business_group_id
191: ,p_per_in_ler_id_o
192: => pqh_rnk_shd.g_old_rec.per_in_ler_id
193: );
194: --
195: exception
196: --

Line 212: (p_rec in pqh_rnk_shd.g_rec_type

208: -- ----------------------------------------------------------------------------
209: -- |---------------------------------< del >----------------------------------|
210: -- ----------------------------------------------------------------------------
211: Procedure del
212: (p_rec in pqh_rnk_shd.g_rec_type
213: ) is
214: --
215: l_proc constant varchar2(72) := g_package||'del';
216: --

Line 222: pqh_rnk_shd.lck

218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: -- We must lock the row which we need to delete.
221: --
222: pqh_rnk_shd.lck
223: (p_rec.rank_process_id
224: ,p_rec.object_version_number
225: );
226: --

Line 259: l_rec pqh_rnk_shd.g_rec_type;

255: (p_rank_process_id in number
256: ,p_object_version_number in number
257: ) is
258: --
259: l_rec pqh_rnk_shd.g_rec_type;
260: l_proc constant varchar2(72) := g_package||'del';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);