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
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));
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
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));
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
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: --
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');
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;
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
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
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
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
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
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
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
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
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
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
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
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: --
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,
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,
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,
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,
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,
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,
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,
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
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
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: --
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;
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';