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_CRF_UPD dependencies on PQH_CRF_SHD

Line 55: (p_rec in out nocopy pqh_crf_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_crf_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 89: pqh_crf_shd.constraint_error

85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: pqh_crf_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --

Line 94: pqh_crf_shd.constraint_error

90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: pqh_crf_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --

Line 99: pqh_crf_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: pqh_crf_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: --
103: Raise;

Line 139: (p_rec in pqh_crf_shd.g_rec_type

135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure pre_update
139: (p_rec in pqh_crf_shd.g_rec_type
140: ) is
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --

Line 183: (p_rec in pqh_crf_shd.g_rec_type

179: --
180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure post_update
183: (p_rec in pqh_crf_shd.g_rec_type
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --

Line 208: => pqh_crf_shd.g_old_rec.criteria_rate_defn_id

204: => p_rec.legislation_code
205: ,p_object_version_number
206: => p_rec.object_version_number
207: ,p_criteria_rate_defn_id_o
208: => pqh_crf_shd.g_old_rec.criteria_rate_defn_id
209: ,p_parent_rate_matrix_id_o
210: => pqh_crf_shd.g_old_rec.parent_rate_matrix_id
211: ,p_parent_criteria_rate_defn__o
212: => pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id

Line 210: => pqh_crf_shd.g_old_rec.parent_rate_matrix_id

206: => p_rec.object_version_number
207: ,p_criteria_rate_defn_id_o
208: => pqh_crf_shd.g_old_rec.criteria_rate_defn_id
209: ,p_parent_rate_matrix_id_o
210: => pqh_crf_shd.g_old_rec.parent_rate_matrix_id
211: ,p_parent_criteria_rate_defn__o
212: => pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id
213: ,p_business_group_id_o
214: => pqh_crf_shd.g_old_rec.business_group_id

Line 212: => pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id

208: => pqh_crf_shd.g_old_rec.criteria_rate_defn_id
209: ,p_parent_rate_matrix_id_o
210: => pqh_crf_shd.g_old_rec.parent_rate_matrix_id
211: ,p_parent_criteria_rate_defn__o
212: => pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id
213: ,p_business_group_id_o
214: => pqh_crf_shd.g_old_rec.business_group_id
215: ,p_legislation_code_o
216: => pqh_crf_shd.g_old_rec.legislation_code

Line 214: => pqh_crf_shd.g_old_rec.business_group_id

210: => pqh_crf_shd.g_old_rec.parent_rate_matrix_id
211: ,p_parent_criteria_rate_defn__o
212: => pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id
213: ,p_business_group_id_o
214: => pqh_crf_shd.g_old_rec.business_group_id
215: ,p_legislation_code_o
216: => pqh_crf_shd.g_old_rec.legislation_code
217: ,p_object_version_number_o
218: => pqh_crf_shd.g_old_rec.object_version_number

Line 216: => pqh_crf_shd.g_old_rec.legislation_code

212: => pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id
213: ,p_business_group_id_o
214: => pqh_crf_shd.g_old_rec.business_group_id
215: ,p_legislation_code_o
216: => pqh_crf_shd.g_old_rec.legislation_code
217: ,p_object_version_number_o
218: => pqh_crf_shd.g_old_rec.object_version_number
219: );
220: --

Line 218: => pqh_crf_shd.g_old_rec.object_version_number

214: => pqh_crf_shd.g_old_rec.business_group_id
215: ,p_legislation_code_o
216: => pqh_crf_shd.g_old_rec.legislation_code
217: ,p_object_version_number_o
218: => pqh_crf_shd.g_old_rec.object_version_number
219: );
220: --
221: exception
222: --

Line 278: (p_rec in out nocopy pqh_crf_shd.g_rec_type

274: --
275: -- {End Of Comments}
276: -- ----------------------------------------------------------------------------
277: Procedure convert_defs
278: (p_rec in out nocopy pqh_crf_shd.g_rec_type
279: ) is
280: --
281: Begin
282: --

Line 290: pqh_crf_shd.g_old_rec.criteria_rate_defn_id;

286: -- is being used then we must set to the 'current' argument value.
287: --
288: If (p_rec.criteria_rate_defn_id = hr_api.g_number) then
289: p_rec.criteria_rate_defn_id :=
290: pqh_crf_shd.g_old_rec.criteria_rate_defn_id;
291: End If;
292: If (p_rec.parent_rate_matrix_id = hr_api.g_number) then
293: p_rec.parent_rate_matrix_id :=
294: pqh_crf_shd.g_old_rec.parent_rate_matrix_id;

Line 294: pqh_crf_shd.g_old_rec.parent_rate_matrix_id;

290: pqh_crf_shd.g_old_rec.criteria_rate_defn_id;
291: End If;
292: If (p_rec.parent_rate_matrix_id = hr_api.g_number) then
293: p_rec.parent_rate_matrix_id :=
294: pqh_crf_shd.g_old_rec.parent_rate_matrix_id;
295: End If;
296: If (p_rec.parent_criteria_rate_defn_id = hr_api.g_number) then
297: p_rec.parent_criteria_rate_defn_id :=
298: pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id;

Line 298: pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id;

294: pqh_crf_shd.g_old_rec.parent_rate_matrix_id;
295: End If;
296: If (p_rec.parent_criteria_rate_defn_id = hr_api.g_number) then
297: p_rec.parent_criteria_rate_defn_id :=
298: pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id;
299: End If;
300: If (p_rec.business_group_id = hr_api.g_number) then
301: p_rec.business_group_id :=
302: pqh_crf_shd.g_old_rec.business_group_id;

Line 302: pqh_crf_shd.g_old_rec.business_group_id;

298: pqh_crf_shd.g_old_rec.parent_criteria_rate_defn_id;
299: End If;
300: If (p_rec.business_group_id = hr_api.g_number) then
301: p_rec.business_group_id :=
302: pqh_crf_shd.g_old_rec.business_group_id;
303: End If;
304: If (p_rec.legislation_code = hr_api.g_varchar2) then
305: p_rec.legislation_code :=
306: pqh_crf_shd.g_old_rec.legislation_code;

Line 306: pqh_crf_shd.g_old_rec.legislation_code;

302: pqh_crf_shd.g_old_rec.business_group_id;
303: End If;
304: If (p_rec.legislation_code = hr_api.g_varchar2) then
305: p_rec.legislation_code :=
306: pqh_crf_shd.g_old_rec.legislation_code;
307: End If;
308: --
309: End convert_defs;
310: --

Line 315: (p_rec in out nocopy pqh_crf_shd.g_rec_type

311: -- ----------------------------------------------------------------------------
312: -- |---------------------------------< upd >----------------------------------|
313: -- ----------------------------------------------------------------------------
314: Procedure upd
315: (p_rec in out nocopy pqh_crf_shd.g_rec_type
316: ) is
317: --
318: l_proc varchar2(72) := g_package||'upd';
319: --

Line 325: pqh_crf_shd.lck

321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: -- We must lock the row which we need to update.
324: --
325: pqh_crf_shd.lck
326: (p_rec.criteria_rate_factor_id
327: ,p_rec.object_version_number
328: );
329: --

Line 375: l_rec pqh_crf_shd.g_rec_type;

371: ,p_business_group_id in number default hr_api.g_number
372: ,p_legislation_code in varchar2 default hr_api.g_varchar2
373: ) is
374: --
375: l_rec pqh_crf_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'upd';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);

Line 385: pqh_crf_shd.convert_args

381: -- Call conversion function to turn arguments into the
382: -- l_rec structure.
383: --
384: l_rec :=
385: pqh_crf_shd.convert_args
386: (p_criteria_rate_factor_id
387: ,p_criteria_rate_defn_id
388: ,p_parent_rate_matrix_id
389: ,p_parent_criteria_rate_defn_id