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_RMN_UPD dependencies on PQH_RMN_SHD

Line 55: (p_rec in out nocopy pqh_rmn_shd.g_rec_type

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

Line 93: pqh_rmn_shd.constraint_error

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

Line 98: pqh_rmn_shd.constraint_error

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

Line 103: pqh_rmn_shd.constraint_error

99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: pqh_rmn_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;

Line 143: (p_rec in pqh_rmn_shd.g_rec_type

139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure pre_update
143: (p_rec in pqh_rmn_shd.g_rec_type
144: ) is
145: --
146: l_proc varchar2(72) := g_package||'pre_update';
147: --

Line 187: (p_rec in pqh_rmn_shd.g_rec_type

183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure post_update
187: (p_rec in pqh_rmn_shd.g_rec_type
188: ) is
189: --
190: l_proc varchar2(72) := g_package||'post_update';
191: --

Line 220: => pqh_rmn_shd.g_old_rec.short_code

216: => p_rec.legislation_code
217: ,p_object_version_number
218: => p_rec.object_version_number
219: ,p_short_code_o
220: => pqh_rmn_shd.g_old_rec.short_code
221: ,p_pl_id_o
222: => pqh_rmn_shd.g_old_rec.pl_id
223: ,p_level_number_o
224: => pqh_rmn_shd.g_old_rec.level_number

Line 222: => pqh_rmn_shd.g_old_rec.pl_id

218: => p_rec.object_version_number
219: ,p_short_code_o
220: => pqh_rmn_shd.g_old_rec.short_code
221: ,p_pl_id_o
222: => pqh_rmn_shd.g_old_rec.pl_id
223: ,p_level_number_o
224: => pqh_rmn_shd.g_old_rec.level_number
225: ,p_criteria_short_code_o
226: => pqh_rmn_shd.g_old_rec.criteria_short_code

Line 224: => pqh_rmn_shd.g_old_rec.level_number

220: => pqh_rmn_shd.g_old_rec.short_code
221: ,p_pl_id_o
222: => pqh_rmn_shd.g_old_rec.pl_id
223: ,p_level_number_o
224: => pqh_rmn_shd.g_old_rec.level_number
225: ,p_criteria_short_code_o
226: => pqh_rmn_shd.g_old_rec.criteria_short_code
227: ,p_node_name_o
228: => pqh_rmn_shd.g_old_rec.node_name

Line 226: => pqh_rmn_shd.g_old_rec.criteria_short_code

222: => pqh_rmn_shd.g_old_rec.pl_id
223: ,p_level_number_o
224: => pqh_rmn_shd.g_old_rec.level_number
225: ,p_criteria_short_code_o
226: => pqh_rmn_shd.g_old_rec.criteria_short_code
227: ,p_node_name_o
228: => pqh_rmn_shd.g_old_rec.node_name
229: ,p_parent_node_id_o
230: => pqh_rmn_shd.g_old_rec.parent_node_id

Line 228: => pqh_rmn_shd.g_old_rec.node_name

224: => pqh_rmn_shd.g_old_rec.level_number
225: ,p_criteria_short_code_o
226: => pqh_rmn_shd.g_old_rec.criteria_short_code
227: ,p_node_name_o
228: => pqh_rmn_shd.g_old_rec.node_name
229: ,p_parent_node_id_o
230: => pqh_rmn_shd.g_old_rec.parent_node_id
231: ,p_eligy_prfl_id_o
232: => pqh_rmn_shd.g_old_rec.eligy_prfl_id

Line 230: => pqh_rmn_shd.g_old_rec.parent_node_id

226: => pqh_rmn_shd.g_old_rec.criteria_short_code
227: ,p_node_name_o
228: => pqh_rmn_shd.g_old_rec.node_name
229: ,p_parent_node_id_o
230: => pqh_rmn_shd.g_old_rec.parent_node_id
231: ,p_eligy_prfl_id_o
232: => pqh_rmn_shd.g_old_rec.eligy_prfl_id
233: ,p_business_group_id_o
234: => pqh_rmn_shd.g_old_rec.business_group_id

Line 232: => pqh_rmn_shd.g_old_rec.eligy_prfl_id

228: => pqh_rmn_shd.g_old_rec.node_name
229: ,p_parent_node_id_o
230: => pqh_rmn_shd.g_old_rec.parent_node_id
231: ,p_eligy_prfl_id_o
232: => pqh_rmn_shd.g_old_rec.eligy_prfl_id
233: ,p_business_group_id_o
234: => pqh_rmn_shd.g_old_rec.business_group_id
235: ,p_legislation_code_o
236: => pqh_rmn_shd.g_old_rec.legislation_code

Line 234: => pqh_rmn_shd.g_old_rec.business_group_id

230: => pqh_rmn_shd.g_old_rec.parent_node_id
231: ,p_eligy_prfl_id_o
232: => pqh_rmn_shd.g_old_rec.eligy_prfl_id
233: ,p_business_group_id_o
234: => pqh_rmn_shd.g_old_rec.business_group_id
235: ,p_legislation_code_o
236: => pqh_rmn_shd.g_old_rec.legislation_code
237: ,p_object_version_number_o
238: => pqh_rmn_shd.g_old_rec.object_version_number

Line 236: => pqh_rmn_shd.g_old_rec.legislation_code

232: => pqh_rmn_shd.g_old_rec.eligy_prfl_id
233: ,p_business_group_id_o
234: => pqh_rmn_shd.g_old_rec.business_group_id
235: ,p_legislation_code_o
236: => pqh_rmn_shd.g_old_rec.legislation_code
237: ,p_object_version_number_o
238: => pqh_rmn_shd.g_old_rec.object_version_number
239: );
240: --

Line 238: => pqh_rmn_shd.g_old_rec.object_version_number

234: => pqh_rmn_shd.g_old_rec.business_group_id
235: ,p_legislation_code_o
236: => pqh_rmn_shd.g_old_rec.legislation_code
237: ,p_object_version_number_o
238: => pqh_rmn_shd.g_old_rec.object_version_number
239: );
240: --
241: exception
242: --

Line 298: (p_rec in out nocopy pqh_rmn_shd.g_rec_type

294: --
295: -- {End Of Comments}
296: -- ----------------------------------------------------------------------------
297: Procedure convert_defs
298: (p_rec in out nocopy pqh_rmn_shd.g_rec_type
299: ) is
300: --
301: Begin
302: --

Line 310: pqh_rmn_shd.g_old_rec.short_code;

306: -- is being used then we must set to the 'current' argument value.
307: --
308: If (p_rec.short_code = hr_api.g_varchar2) then
309: p_rec.short_code :=
310: pqh_rmn_shd.g_old_rec.short_code;
311: End If;
312: If (p_rec.pl_id = hr_api.g_number) then
313: p_rec.pl_id :=
314: pqh_rmn_shd.g_old_rec.pl_id;

Line 314: pqh_rmn_shd.g_old_rec.pl_id;

310: pqh_rmn_shd.g_old_rec.short_code;
311: End If;
312: If (p_rec.pl_id = hr_api.g_number) then
313: p_rec.pl_id :=
314: pqh_rmn_shd.g_old_rec.pl_id;
315: End If;
316: If (p_rec.level_number = hr_api.g_number) then
317: p_rec.level_number :=
318: pqh_rmn_shd.g_old_rec.level_number;

Line 318: pqh_rmn_shd.g_old_rec.level_number;

314: pqh_rmn_shd.g_old_rec.pl_id;
315: End If;
316: If (p_rec.level_number = hr_api.g_number) then
317: p_rec.level_number :=
318: pqh_rmn_shd.g_old_rec.level_number;
319: End If;
320: If (p_rec.criteria_short_code = hr_api.g_varchar2) then
321: p_rec.criteria_short_code :=
322: pqh_rmn_shd.g_old_rec.criteria_short_code;

Line 322: pqh_rmn_shd.g_old_rec.criteria_short_code;

318: pqh_rmn_shd.g_old_rec.level_number;
319: End If;
320: If (p_rec.criteria_short_code = hr_api.g_varchar2) then
321: p_rec.criteria_short_code :=
322: pqh_rmn_shd.g_old_rec.criteria_short_code;
323: End If;
324: If (p_rec.node_name = hr_api.g_varchar2) then
325: p_rec.node_name :=
326: pqh_rmn_shd.g_old_rec.node_name;

Line 326: pqh_rmn_shd.g_old_rec.node_name;

322: pqh_rmn_shd.g_old_rec.criteria_short_code;
323: End If;
324: If (p_rec.node_name = hr_api.g_varchar2) then
325: p_rec.node_name :=
326: pqh_rmn_shd.g_old_rec.node_name;
327: End If;
328: If (p_rec.parent_node_id = hr_api.g_number) then
329: p_rec.parent_node_id :=
330: pqh_rmn_shd.g_old_rec.parent_node_id;

Line 330: pqh_rmn_shd.g_old_rec.parent_node_id;

326: pqh_rmn_shd.g_old_rec.node_name;
327: End If;
328: If (p_rec.parent_node_id = hr_api.g_number) then
329: p_rec.parent_node_id :=
330: pqh_rmn_shd.g_old_rec.parent_node_id;
331: End If;
332: If (p_rec.eligy_prfl_id = hr_api.g_number) then
333: p_rec.eligy_prfl_id :=
334: pqh_rmn_shd.g_old_rec.eligy_prfl_id;

Line 334: pqh_rmn_shd.g_old_rec.eligy_prfl_id;

330: pqh_rmn_shd.g_old_rec.parent_node_id;
331: End If;
332: If (p_rec.eligy_prfl_id = hr_api.g_number) then
333: p_rec.eligy_prfl_id :=
334: pqh_rmn_shd.g_old_rec.eligy_prfl_id;
335: End If;
336: If (p_rec.business_group_id = hr_api.g_number) then
337: p_rec.business_group_id :=
338: pqh_rmn_shd.g_old_rec.business_group_id;

Line 338: pqh_rmn_shd.g_old_rec.business_group_id;

334: pqh_rmn_shd.g_old_rec.eligy_prfl_id;
335: End If;
336: If (p_rec.business_group_id = hr_api.g_number) then
337: p_rec.business_group_id :=
338: pqh_rmn_shd.g_old_rec.business_group_id;
339: End If;
340: If (p_rec.legislation_code = hr_api.g_varchar2) then
341: p_rec.legislation_code :=
342: pqh_rmn_shd.g_old_rec.legislation_code;

Line 342: pqh_rmn_shd.g_old_rec.legislation_code;

338: pqh_rmn_shd.g_old_rec.business_group_id;
339: End If;
340: If (p_rec.legislation_code = hr_api.g_varchar2) then
341: p_rec.legislation_code :=
342: pqh_rmn_shd.g_old_rec.legislation_code;
343: End If;
344: --
345: End convert_defs;
346: --

Line 351: (p_rec in out nocopy pqh_rmn_shd.g_rec_type

347: -- ----------------------------------------------------------------------------
348: -- |---------------------------------< upd >----------------------------------|
349: -- ----------------------------------------------------------------------------
350: Procedure upd
351: (p_rec in out nocopy pqh_rmn_shd.g_rec_type
352: ) is
353: --
354: l_proc varchar2(72) := g_package||'upd';
355: --

Line 361: pqh_rmn_shd.lck

357: hr_utility.set_location('Entering:'||l_proc, 5);
358: --
359: -- We must lock the row which we need to update.
360: --
361: pqh_rmn_shd.lck
362: (p_rec.rate_matrix_node_id
363: ,p_rec.object_version_number
364: );
365: --

Line 415: l_rec pqh_rmn_shd.g_rec_type;

411: ,p_business_group_id in number default hr_api.g_number
412: ,p_legislation_code in varchar2 default hr_api.g_varchar2
413: ) is
414: --
415: l_rec pqh_rmn_shd.g_rec_type;
416: l_proc varchar2(72) := g_package||'upd';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);

Line 425: pqh_rmn_shd.convert_args

421: -- Call conversion function to turn arguments into the
422: -- l_rec structure.
423: --
424: l_rec :=
425: pqh_rmn_shd.convert_args
426: (p_rate_matrix_node_id
427: ,p_short_code
428: ,p_pl_id
429: ,p_level_number