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_RLA_UPD dependencies on PQH_RLA_SHD

Line 55: (p_rec in out nocopy pqh_rla_shd.g_rec_type

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

Line 88: pqh_rla_shd.constraint_error

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

Line 93: pqh_rla_shd.constraint_error

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

Line 98: pqh_rla_shd.constraint_error

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

Line 138: (p_rec in pqh_rla_shd.g_rec_type

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

Line 182: (p_rec in pqh_rla_shd.g_rec_type

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

Line 205: => pqh_rla_shd.g_old_rec.rule_set_id

201: => p_rec.attribute_value
202: ,p_object_version_number
203: => p_rec.object_version_number
204: ,p_rule_set_id_o
205: => pqh_rla_shd.g_old_rec.rule_set_id
206: ,p_attribute_code_o
207: => pqh_rla_shd.g_old_rec.attribute_code
208: ,p_operation_code_o
209: => pqh_rla_shd.g_old_rec.operation_code

Line 207: => pqh_rla_shd.g_old_rec.attribute_code

203: => p_rec.object_version_number
204: ,p_rule_set_id_o
205: => pqh_rla_shd.g_old_rec.rule_set_id
206: ,p_attribute_code_o
207: => pqh_rla_shd.g_old_rec.attribute_code
208: ,p_operation_code_o
209: => pqh_rla_shd.g_old_rec.operation_code
210: ,p_attribute_value_o
211: => pqh_rla_shd.g_old_rec.attribute_value

Line 209: => pqh_rla_shd.g_old_rec.operation_code

205: => pqh_rla_shd.g_old_rec.rule_set_id
206: ,p_attribute_code_o
207: => pqh_rla_shd.g_old_rec.attribute_code
208: ,p_operation_code_o
209: => pqh_rla_shd.g_old_rec.operation_code
210: ,p_attribute_value_o
211: => pqh_rla_shd.g_old_rec.attribute_value
212: ,p_object_version_number_o
213: => pqh_rla_shd.g_old_rec.object_version_number

Line 211: => pqh_rla_shd.g_old_rec.attribute_value

207: => pqh_rla_shd.g_old_rec.attribute_code
208: ,p_operation_code_o
209: => pqh_rla_shd.g_old_rec.operation_code
210: ,p_attribute_value_o
211: => pqh_rla_shd.g_old_rec.attribute_value
212: ,p_object_version_number_o
213: => pqh_rla_shd.g_old_rec.object_version_number
214: );
215: --

Line 213: => pqh_rla_shd.g_old_rec.object_version_number

209: => pqh_rla_shd.g_old_rec.operation_code
210: ,p_attribute_value_o
211: => pqh_rla_shd.g_old_rec.attribute_value
212: ,p_object_version_number_o
213: => pqh_rla_shd.g_old_rec.object_version_number
214: );
215: --
216: exception
217: --

Line 273: (p_rec in out nocopy pqh_rla_shd.g_rec_type

269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure convert_defs
273: (p_rec in out nocopy pqh_rla_shd.g_rec_type
274: ) is
275: --
276: Begin
277: --

Line 285: pqh_rla_shd.g_old_rec.rule_set_id;

281: -- is being used then we must set to the 'current' argument value.
282: --
283: If (p_rec.rule_set_id = hr_api.g_number) then
284: p_rec.rule_set_id :=
285: pqh_rla_shd.g_old_rec.rule_set_id;
286: End If;
287: If (p_rec.attribute_code = hr_api.g_varchar2) then
288: p_rec.attribute_code :=
289: pqh_rla_shd.g_old_rec.attribute_code;

Line 289: pqh_rla_shd.g_old_rec.attribute_code;

285: pqh_rla_shd.g_old_rec.rule_set_id;
286: End If;
287: If (p_rec.attribute_code = hr_api.g_varchar2) then
288: p_rec.attribute_code :=
289: pqh_rla_shd.g_old_rec.attribute_code;
290: End If;
291: If (p_rec.operation_code = hr_api.g_varchar2) then
292: p_rec.operation_code :=
293: pqh_rla_shd.g_old_rec.operation_code;

Line 293: pqh_rla_shd.g_old_rec.operation_code;

289: pqh_rla_shd.g_old_rec.attribute_code;
290: End If;
291: If (p_rec.operation_code = hr_api.g_varchar2) then
292: p_rec.operation_code :=
293: pqh_rla_shd.g_old_rec.operation_code;
294: End If;
295: If (p_rec.attribute_value = hr_api.g_varchar2) then
296: p_rec.attribute_value :=
297: pqh_rla_shd.g_old_rec.attribute_value;

Line 297: pqh_rla_shd.g_old_rec.attribute_value;

293: pqh_rla_shd.g_old_rec.operation_code;
294: End If;
295: If (p_rec.attribute_value = hr_api.g_varchar2) then
296: p_rec.attribute_value :=
297: pqh_rla_shd.g_old_rec.attribute_value;
298: End If;
299: --
300: End convert_defs;
301: --

Line 306: (p_rec in out nocopy pqh_rla_shd.g_rec_type

302: -- ----------------------------------------------------------------------------
303: -- |---------------------------------< upd >----------------------------------|
304: -- ----------------------------------------------------------------------------
305: Procedure upd
306: (p_rec in out nocopy pqh_rla_shd.g_rec_type
307: ) is
308: --
309: l_proc varchar2(72) := g_package||'upd';
310: --

Line 316: pqh_rla_shd.lck

312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: -- We must lock the row which we need to update.
315: --
316: pqh_rla_shd.lck
317: (p_rec.rule_attribute_id
318: ,p_rec.object_version_number
319: );
320: --

Line 365: l_rec pqh_rla_shd.g_rec_type;

361: ,p_operation_code in varchar2 default hr_api.g_varchar2
362: ,p_attribute_value in varchar2 default hr_api.g_varchar2
363: ) is
364: --
365: l_rec pqh_rla_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'upd';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);

Line 375: pqh_rla_shd.convert_args

371: -- Call conversion function to turn arguments into the
372: -- l_rec structure.
373: --
374: l_rec :=
375: pqh_rla_shd.convert_args
376: (p_rule_attribute_id
377: ,p_rule_set_id
378: ,p_attribute_code
379: ,p_operation_code