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_RER_UPD dependencies on PQH_RER_SHD

Line 55: (p_rec in out nocopy pqh_rer_shd.g_rec_type

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

Line 90: pqh_rer_shd.constraint_error

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

Line 95: pqh_rer_shd.constraint_error

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

Line 100: pqh_rer_shd.constraint_error

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

Line 140: (p_rec in pqh_rer_shd.g_rec_type

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

Line 185: ,p_rec in pqh_rer_shd.g_rec_type

181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure post_update
184: (p_effective_date in date
185: ,p_rec in pqh_rer_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --

Line 213: => pqh_rer_shd.g_old_rec.criteria_rate_element_id

209: => p_rec.legislation_code
210: ,p_object_version_number
211: => p_rec.object_version_number
212: ,p_criteria_rate_element_id_o
213: => pqh_rer_shd.g_old_rec.criteria_rate_element_id
214: ,p_relation_type_cd_o
215: => pqh_rer_shd.g_old_rec.relation_type_cd
216: ,p_rel_element_type_id_o
217: => pqh_rer_shd.g_old_rec.rel_element_type_id

Line 215: => pqh_rer_shd.g_old_rec.relation_type_cd

211: => p_rec.object_version_number
212: ,p_criteria_rate_element_id_o
213: => pqh_rer_shd.g_old_rec.criteria_rate_element_id
214: ,p_relation_type_cd_o
215: => pqh_rer_shd.g_old_rec.relation_type_cd
216: ,p_rel_element_type_id_o
217: => pqh_rer_shd.g_old_rec.rel_element_type_id
218: ,p_rel_input_value_id_o
219: => pqh_rer_shd.g_old_rec.rel_input_value_id

Line 217: => pqh_rer_shd.g_old_rec.rel_element_type_id

213: => pqh_rer_shd.g_old_rec.criteria_rate_element_id
214: ,p_relation_type_cd_o
215: => pqh_rer_shd.g_old_rec.relation_type_cd
216: ,p_rel_element_type_id_o
217: => pqh_rer_shd.g_old_rec.rel_element_type_id
218: ,p_rel_input_value_id_o
219: => pqh_rer_shd.g_old_rec.rel_input_value_id
220: ,p_business_group_id_o
221: => pqh_rer_shd.g_old_rec.business_group_id

Line 219: => pqh_rer_shd.g_old_rec.rel_input_value_id

215: => pqh_rer_shd.g_old_rec.relation_type_cd
216: ,p_rel_element_type_id_o
217: => pqh_rer_shd.g_old_rec.rel_element_type_id
218: ,p_rel_input_value_id_o
219: => pqh_rer_shd.g_old_rec.rel_input_value_id
220: ,p_business_group_id_o
221: => pqh_rer_shd.g_old_rec.business_group_id
222: ,p_legislation_code_o
223: => pqh_rer_shd.g_old_rec.legislation_code

Line 221: => pqh_rer_shd.g_old_rec.business_group_id

217: => pqh_rer_shd.g_old_rec.rel_element_type_id
218: ,p_rel_input_value_id_o
219: => pqh_rer_shd.g_old_rec.rel_input_value_id
220: ,p_business_group_id_o
221: => pqh_rer_shd.g_old_rec.business_group_id
222: ,p_legislation_code_o
223: => pqh_rer_shd.g_old_rec.legislation_code
224: ,p_object_version_number_o
225: => pqh_rer_shd.g_old_rec.object_version_number

Line 223: => pqh_rer_shd.g_old_rec.legislation_code

219: => pqh_rer_shd.g_old_rec.rel_input_value_id
220: ,p_business_group_id_o
221: => pqh_rer_shd.g_old_rec.business_group_id
222: ,p_legislation_code_o
223: => pqh_rer_shd.g_old_rec.legislation_code
224: ,p_object_version_number_o
225: => pqh_rer_shd.g_old_rec.object_version_number
226: );
227: --

Line 225: => pqh_rer_shd.g_old_rec.object_version_number

221: => pqh_rer_shd.g_old_rec.business_group_id
222: ,p_legislation_code_o
223: => pqh_rer_shd.g_old_rec.legislation_code
224: ,p_object_version_number_o
225: => pqh_rer_shd.g_old_rec.object_version_number
226: );
227: --
228: exception
229: --

Line 285: (p_rec in out nocopy pqh_rer_shd.g_rec_type

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure convert_defs
285: (p_rec in out nocopy pqh_rer_shd.g_rec_type
286: ) is
287: --
288: Begin
289: --

Line 297: pqh_rer_shd.g_old_rec.criteria_rate_element_id;

293: -- is being used then we must set to the 'current' argument value.
294: --
295: If (p_rec.criteria_rate_element_id = hr_api.g_number) then
296: p_rec.criteria_rate_element_id :=
297: pqh_rer_shd.g_old_rec.criteria_rate_element_id;
298: End If;
299: If (p_rec.relation_type_cd = hr_api.g_varchar2) then
300: p_rec.relation_type_cd :=
301: pqh_rer_shd.g_old_rec.relation_type_cd;

Line 301: pqh_rer_shd.g_old_rec.relation_type_cd;

297: pqh_rer_shd.g_old_rec.criteria_rate_element_id;
298: End If;
299: If (p_rec.relation_type_cd = hr_api.g_varchar2) then
300: p_rec.relation_type_cd :=
301: pqh_rer_shd.g_old_rec.relation_type_cd;
302: End If;
303: If (p_rec.rel_element_type_id = hr_api.g_number) then
304: p_rec.rel_element_type_id :=
305: pqh_rer_shd.g_old_rec.rel_element_type_id;

Line 305: pqh_rer_shd.g_old_rec.rel_element_type_id;

301: pqh_rer_shd.g_old_rec.relation_type_cd;
302: End If;
303: If (p_rec.rel_element_type_id = hr_api.g_number) then
304: p_rec.rel_element_type_id :=
305: pqh_rer_shd.g_old_rec.rel_element_type_id;
306: End If;
307: If (p_rec.rel_input_value_id = hr_api.g_number) then
308: p_rec.rel_input_value_id :=
309: pqh_rer_shd.g_old_rec.rel_input_value_id;

Line 309: pqh_rer_shd.g_old_rec.rel_input_value_id;

305: pqh_rer_shd.g_old_rec.rel_element_type_id;
306: End If;
307: If (p_rec.rel_input_value_id = hr_api.g_number) then
308: p_rec.rel_input_value_id :=
309: pqh_rer_shd.g_old_rec.rel_input_value_id;
310: End If;
311: If (p_rec.business_group_id = hr_api.g_number) then
312: p_rec.business_group_id :=
313: pqh_rer_shd.g_old_rec.business_group_id;

Line 313: pqh_rer_shd.g_old_rec.business_group_id;

309: pqh_rer_shd.g_old_rec.rel_input_value_id;
310: End If;
311: If (p_rec.business_group_id = hr_api.g_number) then
312: p_rec.business_group_id :=
313: pqh_rer_shd.g_old_rec.business_group_id;
314: End If;
315: If (p_rec.legislation_code = hr_api.g_varchar2) then
316: p_rec.legislation_code :=
317: pqh_rer_shd.g_old_rec.legislation_code;

Line 317: pqh_rer_shd.g_old_rec.legislation_code;

313: pqh_rer_shd.g_old_rec.business_group_id;
314: End If;
315: If (p_rec.legislation_code = hr_api.g_varchar2) then
316: p_rec.legislation_code :=
317: pqh_rer_shd.g_old_rec.legislation_code;
318: End If;
319: --
320: End convert_defs;
321: --

Line 327: ,p_rec in out nocopy pqh_rer_shd.g_rec_type

323: -- |---------------------------------< upd >----------------------------------|
324: -- ----------------------------------------------------------------------------
325: Procedure upd
326: (p_effective_date in date
327: ,p_rec in out nocopy pqh_rer_shd.g_rec_type
328: ) is
329: --
330: l_proc varchar2(72) := g_package||'upd';
331: --

Line 337: pqh_rer_shd.lck

333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- We must lock the row which we need to update.
336: --
337: pqh_rer_shd.lck
338: (p_rec.rate_element_relation_id
339: ,p_rec.object_version_number
340: );
341: --

Line 391: l_rec pqh_rer_shd.g_rec_type;

387: ,p_business_group_id in number default hr_api.g_number
388: ,p_legislation_code in varchar2 default hr_api.g_varchar2
389: ) is
390: --
391: l_rec pqh_rer_shd.g_rec_type;
392: l_proc varchar2(72) := g_package||'upd';
393: --
394: Begin
395: hr_utility.set_location('Entering:'||l_proc, 5);

Line 401: pqh_rer_shd.convert_args

397: -- Call conversion function to turn arguments into the
398: -- l_rec structure.
399: --
400: l_rec :=
401: pqh_rer_shd.convert_args
402: (p_rate_element_relation_id
403: ,p_criteria_rate_element_id
404: ,p_relation_type_cd
405: ,p_rel_element_type_id