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_RST_UPD dependencies on HR_API

Line 87: When hr_api.check_integrity_violated Then

83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pqh_rst_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then

Line 90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pqh_rst_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: pqh_rst_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 91: When hr_api.parent_integrity_violated Then

87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pqh_rst_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: pqh_rst_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then

Line 94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: pqh_rst_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: pqh_rst_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 95: When hr_api.unique_integrity_violated Then

91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pqh_rst_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: pqh_rst_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then

Line 98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: pqh_rst_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: Raise;
101: End update_dml;
102: --

Line 224: when hr_api.cannot_find_prog_unit then

220: );
221: --
222: exception
223: --
224: when hr_api.cannot_find_prog_unit then
225: --
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'pqh_rule_sets'
228: ,p_hook_type => 'AU');

Line 226: hr_api.cannot_find_prog_unit_error

222: exception
223: --
224: when hr_api.cannot_find_prog_unit then
225: --
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'pqh_rule_sets'
228: ,p_hook_type => 'AU');
229: --
230: end;

Line 294: If (p_rec.business_group_id = hr_api.g_number) then

290: -- p_rec plsql record structure
291: -- to see if a system default is being used. If a system default
292: -- is being used then we must set to the 'current' argument value.
293: --
294: If (p_rec.business_group_id = hr_api.g_number) then
295: p_rec.business_group_id :=
296: pqh_rst_shd.g_old_rec.business_group_id;
297: End If;
298: If (p_rec.rule_set_name = hr_api.g_varchar2) then

Line 298: If (p_rec.rule_set_name = hr_api.g_varchar2) then

294: If (p_rec.business_group_id = hr_api.g_number) then
295: p_rec.business_group_id :=
296: pqh_rst_shd.g_old_rec.business_group_id;
297: End If;
298: If (p_rec.rule_set_name = hr_api.g_varchar2) then
299: p_rec.rule_set_name :=
300: pqh_rst_shd.g_old_rec.rule_set_name;
301: End If;
302: If (p_rec.organization_structure_id = hr_api.g_number) then

Line 302: If (p_rec.organization_structure_id = hr_api.g_number) then

298: If (p_rec.rule_set_name = hr_api.g_varchar2) then
299: p_rec.rule_set_name :=
300: pqh_rst_shd.g_old_rec.rule_set_name;
301: End If;
302: If (p_rec.organization_structure_id = hr_api.g_number) then
303: p_rec.organization_structure_id :=
304: pqh_rst_shd.g_old_rec.organization_structure_id;
305: End If;
306: If (p_rec.organization_id = hr_api.g_number) then

Line 306: If (p_rec.organization_id = hr_api.g_number) then

302: If (p_rec.organization_structure_id = hr_api.g_number) then
303: p_rec.organization_structure_id :=
304: pqh_rst_shd.g_old_rec.organization_structure_id;
305: End If;
306: If (p_rec.organization_id = hr_api.g_number) then
307: p_rec.organization_id :=
308: pqh_rst_shd.g_old_rec.organization_id;
309: End If;
310: If (p_rec.referenced_rule_set_id = hr_api.g_number) then

Line 310: If (p_rec.referenced_rule_set_id = hr_api.g_number) then

306: If (p_rec.organization_id = hr_api.g_number) then
307: p_rec.organization_id :=
308: pqh_rst_shd.g_old_rec.organization_id;
309: End If;
310: If (p_rec.referenced_rule_set_id = hr_api.g_number) then
311: p_rec.referenced_rule_set_id :=
312: pqh_rst_shd.g_old_rec.referenced_rule_set_id;
313: End If;
314: If (p_rec.rule_level_cd = hr_api.g_varchar2) then

Line 314: If (p_rec.rule_level_cd = hr_api.g_varchar2) then

310: If (p_rec.referenced_rule_set_id = hr_api.g_number) then
311: p_rec.referenced_rule_set_id :=
312: pqh_rst_shd.g_old_rec.referenced_rule_set_id;
313: End If;
314: If (p_rec.rule_level_cd = hr_api.g_varchar2) then
315: p_rec.rule_level_cd :=
316: pqh_rst_shd.g_old_rec.rule_level_cd;
317: End If;
318: If (p_rec.short_name = hr_api.g_varchar2) then

Line 318: If (p_rec.short_name = hr_api.g_varchar2) then

314: If (p_rec.rule_level_cd = hr_api.g_varchar2) then
315: p_rec.rule_level_cd :=
316: pqh_rst_shd.g_old_rec.rule_level_cd;
317: End If;
318: If (p_rec.short_name = hr_api.g_varchar2) then
319: p_rec.short_name :=
320: pqh_rst_shd.g_old_rec.short_name;
321: End If;
322: If (p_rec.rule_applicability = hr_api.g_varchar2) then

Line 322: If (p_rec.rule_applicability = hr_api.g_varchar2) then

318: If (p_rec.short_name = hr_api.g_varchar2) then
319: p_rec.short_name :=
320: pqh_rst_shd.g_old_rec.short_name;
321: End If;
322: If (p_rec.rule_applicability = hr_api.g_varchar2) then
323: p_rec.rule_applicability :=
324: pqh_rst_shd.g_old_rec.rule_applicability;
325: End If;
326: If (p_rec.rule_category = hr_api.g_varchar2) then

Line 326: If (p_rec.rule_category = hr_api.g_varchar2) then

322: If (p_rec.rule_applicability = hr_api.g_varchar2) then
323: p_rec.rule_applicability :=
324: pqh_rst_shd.g_old_rec.rule_applicability;
325: End If;
326: If (p_rec.rule_category = hr_api.g_varchar2) then
327: p_rec.rule_category :=
328: pqh_rst_shd.g_old_rec.rule_category;
329: End If;
330: If (p_rec.starting_organization_id = hr_api.g_number) then

Line 330: If (p_rec.starting_organization_id = hr_api.g_number) then

326: If (p_rec.rule_category = hr_api.g_varchar2) then
327: p_rec.rule_category :=
328: pqh_rst_shd.g_old_rec.rule_category;
329: End If;
330: If (p_rec.starting_organization_id = hr_api.g_number) then
331: p_rec.starting_organization_id :=
332: pqh_rst_shd.g_old_rec.starting_organization_id;
333: End If;
334: If (p_rec.seeded_rule_flag = hr_api.g_varchar2) then

Line 334: If (p_rec.seeded_rule_flag = hr_api.g_varchar2) then

330: If (p_rec.starting_organization_id = hr_api.g_number) then
331: p_rec.starting_organization_id :=
332: pqh_rst_shd.g_old_rec.starting_organization_id;
333: End If;
334: If (p_rec.seeded_rule_flag = hr_api.g_varchar2) then
335: p_rec.seeded_rule_flag :=
336: pqh_rst_shd.g_old_rec.seeded_rule_flag;
337: End If;
338: If (p_rec.status = hr_api.g_varchar2) then

Line 338: If (p_rec.status = hr_api.g_varchar2) then

334: If (p_rec.seeded_rule_flag = hr_api.g_varchar2) then
335: p_rec.seeded_rule_flag :=
336: pqh_rst_shd.g_old_rec.seeded_rule_flag;
337: End If;
338: If (p_rec.status = hr_api.g_varchar2) then
339: p_rec.status :=
340: pqh_rst_shd.g_old_rec.status;
341: End If;
342: --

Line 399: p_business_group_id in number default hr_api.g_number,

395: -- ----------------------------------------------------------------------------
396: Procedure upd
397: (
398: p_effective_date in date,
399: p_business_group_id in number default hr_api.g_number,
400: p_rule_set_id in number,
401: p_rule_set_name in varchar2 default hr_api.g_varchar2,
402: p_organization_structure_id in number default hr_api.g_number,
403: p_organization_id in number default hr_api.g_number,

Line 401: p_rule_set_name in varchar2 default hr_api.g_varchar2,

397: (
398: p_effective_date in date,
399: p_business_group_id in number default hr_api.g_number,
400: p_rule_set_id in number,
401: p_rule_set_name in varchar2 default hr_api.g_varchar2,
402: p_organization_structure_id in number default hr_api.g_number,
403: p_organization_id in number default hr_api.g_number,
404: p_referenced_rule_set_id in number default hr_api.g_number,
405: p_rule_level_cd in varchar2 default hr_api.g_varchar2,

Line 402: p_organization_structure_id in number default hr_api.g_number,

398: p_effective_date in date,
399: p_business_group_id in number default hr_api.g_number,
400: p_rule_set_id in number,
401: p_rule_set_name in varchar2 default hr_api.g_varchar2,
402: p_organization_structure_id in number default hr_api.g_number,
403: p_organization_id in number default hr_api.g_number,
404: p_referenced_rule_set_id in number default hr_api.g_number,
405: p_rule_level_cd in varchar2 default hr_api.g_varchar2,
406: p_object_version_number in out nocopy number,

Line 403: p_organization_id in number default hr_api.g_number,

399: p_business_group_id in number default hr_api.g_number,
400: p_rule_set_id in number,
401: p_rule_set_name in varchar2 default hr_api.g_varchar2,
402: p_organization_structure_id in number default hr_api.g_number,
403: p_organization_id in number default hr_api.g_number,
404: p_referenced_rule_set_id in number default hr_api.g_number,
405: p_rule_level_cd in varchar2 default hr_api.g_varchar2,
406: p_object_version_number in out nocopy number,
407: p_short_name in varchar2 default hr_api.g_varchar2,

Line 404: p_referenced_rule_set_id in number default hr_api.g_number,

400: p_rule_set_id in number,
401: p_rule_set_name in varchar2 default hr_api.g_varchar2,
402: p_organization_structure_id in number default hr_api.g_number,
403: p_organization_id in number default hr_api.g_number,
404: p_referenced_rule_set_id in number default hr_api.g_number,
405: p_rule_level_cd in varchar2 default hr_api.g_varchar2,
406: p_object_version_number in out nocopy number,
407: p_short_name in varchar2 default hr_api.g_varchar2,
408: p_rule_applicability in varchar2 default hr_api.g_varchar2,

Line 405: p_rule_level_cd in varchar2 default hr_api.g_varchar2,

401: p_rule_set_name in varchar2 default hr_api.g_varchar2,
402: p_organization_structure_id in number default hr_api.g_number,
403: p_organization_id in number default hr_api.g_number,
404: p_referenced_rule_set_id in number default hr_api.g_number,
405: p_rule_level_cd in varchar2 default hr_api.g_varchar2,
406: p_object_version_number in out nocopy number,
407: p_short_name in varchar2 default hr_api.g_varchar2,
408: p_rule_applicability in varchar2 default hr_api.g_varchar2,
409: p_rule_category in varchar2 default hr_api.g_varchar2,

Line 407: p_short_name in varchar2 default hr_api.g_varchar2,

403: p_organization_id in number default hr_api.g_number,
404: p_referenced_rule_set_id in number default hr_api.g_number,
405: p_rule_level_cd in varchar2 default hr_api.g_varchar2,
406: p_object_version_number in out nocopy number,
407: p_short_name in varchar2 default hr_api.g_varchar2,
408: p_rule_applicability in varchar2 default hr_api.g_varchar2,
409: p_rule_category in varchar2 default hr_api.g_varchar2,
410: p_starting_organization_id in number default hr_api.g_number,
411: p_seeded_rule_flag in varchar2 default hr_api.g_varchar2,

Line 408: p_rule_applicability in varchar2 default hr_api.g_varchar2,

404: p_referenced_rule_set_id in number default hr_api.g_number,
405: p_rule_level_cd in varchar2 default hr_api.g_varchar2,
406: p_object_version_number in out nocopy number,
407: p_short_name in varchar2 default hr_api.g_varchar2,
408: p_rule_applicability in varchar2 default hr_api.g_varchar2,
409: p_rule_category in varchar2 default hr_api.g_varchar2,
410: p_starting_organization_id in number default hr_api.g_number,
411: p_seeded_rule_flag in varchar2 default hr_api.g_varchar2,
412: p_status in varchar2 default hr_api.g_varchar2

Line 409: p_rule_category in varchar2 default hr_api.g_varchar2,

405: p_rule_level_cd in varchar2 default hr_api.g_varchar2,
406: p_object_version_number in out nocopy number,
407: p_short_name in varchar2 default hr_api.g_varchar2,
408: p_rule_applicability in varchar2 default hr_api.g_varchar2,
409: p_rule_category in varchar2 default hr_api.g_varchar2,
410: p_starting_organization_id in number default hr_api.g_number,
411: p_seeded_rule_flag in varchar2 default hr_api.g_varchar2,
412: p_status in varchar2 default hr_api.g_varchar2
413: ) is

Line 410: p_starting_organization_id in number default hr_api.g_number,

406: p_object_version_number in out nocopy number,
407: p_short_name in varchar2 default hr_api.g_varchar2,
408: p_rule_applicability in varchar2 default hr_api.g_varchar2,
409: p_rule_category in varchar2 default hr_api.g_varchar2,
410: p_starting_organization_id in number default hr_api.g_number,
411: p_seeded_rule_flag in varchar2 default hr_api.g_varchar2,
412: p_status in varchar2 default hr_api.g_varchar2
413: ) is
414: --

Line 411: p_seeded_rule_flag in varchar2 default hr_api.g_varchar2,

407: p_short_name in varchar2 default hr_api.g_varchar2,
408: p_rule_applicability in varchar2 default hr_api.g_varchar2,
409: p_rule_category in varchar2 default hr_api.g_varchar2,
410: p_starting_organization_id in number default hr_api.g_number,
411: p_seeded_rule_flag in varchar2 default hr_api.g_varchar2,
412: p_status in varchar2 default hr_api.g_varchar2
413: ) is
414: --
415: l_rec pqh_rst_shd.g_rec_type;

Line 412: p_status in varchar2 default hr_api.g_varchar2

408: p_rule_applicability in varchar2 default hr_api.g_varchar2,
409: p_rule_category in varchar2 default hr_api.g_varchar2,
410: p_starting_organization_id in number default hr_api.g_number,
411: p_seeded_rule_flag in varchar2 default hr_api.g_varchar2,
412: p_status in varchar2 default hr_api.g_varchar2
413: ) is
414: --
415: l_rec pqh_rst_shd.g_rec_type;
416: l_proc varchar2(72) := g_package||'upd';