[Home] [Help]
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_CWB_PERSON_INFO_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: --
10: -- ----------------------------------------------------------------------------
11: -- |-------------------------< create_audit_record >--------------------------|
773: or ((l_info_new.custom_segment1 is null)
774: and (p_info_old.custom_segment1 is not null))
775: or (p_info_old.custom_segment1 <> l_info_new.custom_segment1) ) then
776: if(ben_cwb_audit_api.return_lookup_validity('CU1')=true) then
777: hr_utility.set_location('CU1',9);
778: ben_cwb_audit_api.create_audit_entry
779: (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
780: ,p_group_pl_id => l_group_pl_id
781: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
796: or ((l_info_new.custom_segment2 is null)
797: and (p_info_old.custom_segment2 is not null))
798: or (p_info_old.custom_segment2 <> l_info_new.custom_segment2) ) then
799: if(ben_cwb_audit_api.return_lookup_validity('CU2')=true) then
800: hr_utility.set_location('CU2',9);
801: ben_cwb_audit_api.create_audit_entry
802: (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
803: ,p_group_pl_id => l_group_pl_id
804: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1017: or ((l_info_new.custom_segment12 is null)
1018: and (p_info_old.custom_segment12 is not null))
1019: or (p_info_old.custom_segment12 <> l_info_new.custom_segment12) ) then
1020: if(ben_cwb_audit_api.return_lookup_validity('CU12')=true) then
1021: hr_utility.set_location('CU12',9);
1022: ben_cwb_audit_api.create_audit_entry
1023: (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1024: ,p_group_pl_id => l_group_pl_id
1025: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1106: or ((l_info_new.custom_segment16 is null)
1107: and (p_info_old.custom_segment16 is not null))
1108: or (p_info_old.custom_segment16 <> l_info_new.custom_segment16) ) then
1109: if(ben_cwb_audit_api.return_lookup_validity('CU16')=true) then
1110: hr_utility.set_location('CU16',9);
1111: ben_cwb_audit_api.create_audit_entry
1112: (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1113: ,p_group_pl_id => l_group_pl_id
1114: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1129: or ((l_info_new.custom_segment17 is null)
1130: and (p_info_old.custom_segment17 is not null))
1131: or (p_info_old.custom_segment17 <> l_info_new.custom_segment17) ) then
1132: if(ben_cwb_audit_api.return_lookup_validity('CU17')=true) then
1133: hr_utility.set_location('CU17',9);
1134: ben_cwb_audit_api.create_audit_entry
1135: (p_group_per_in_ler_id => l_info_new.group_per_in_ler_id
1136: ,p_group_pl_id => l_group_pl_id
1137: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
1381: --
1382: l_proc varchar2(72) := g_package||'create_person_info';
1383: begin
1384: if g_debug then
1385: hr_utility.set_location('Entering:'|| l_proc, 10);
1386: end if;
1387: --
1388: -- Issue a savepoint
1389: --
1890: --
1891: p_object_version_number := l_object_version_number;
1892: --
1893: if g_debug then
1894: hr_utility.set_location(' Leaving:'||l_proc, 70);
1895: end if;
1896: exception
1897: when hr_api.validate_enabled then
1898: --
1901: --
1902: rollback to create_person_info;
1903: --
1904: if g_debug then
1905: hr_utility.set_location(' Leaving:'||l_proc, 80);
1906: end if;
1907: when others then
1908: --
1909: -- A validation or unexpected error has occured
1910: --
1911: rollback to create_person_info;
1912: --
1913: if g_debug then
1914: hr_utility.set_location(' Leaving:'||l_proc, 90);
1915: end if;
1916: raise;
1917: end create_person_info;
1918: --
2089: from ben_cwb_person_info
2090: where group_per_in_ler_id = p_group_per_in_ler_id;
2091:
2092: if g_debug then
2093: hr_utility.set_location('Entering:'|| l_proc, 10);
2094: end if;
2095: --
2096: -- Issue a savepoint
2097: --
2603: --
2604: p_object_version_number := l_object_version_number;
2605: --
2606: if g_debug then
2607: hr_utility.set_location(' Leaving:'||l_proc, 70);
2608: end if;
2609:
2610: -- calling the create_audit_record procedure to write into
2611: -- the ben_cwb_audit table with the old record
2619: --
2620: rollback to update_person_info;
2621: --
2622: if g_debug then
2623: hr_utility.set_location(' Leaving:'||l_proc, 80);
2624: end if;
2625: when others then
2626: --
2627: -- A validation or unexpected error has occured
2628: --
2629: rollback to update_person_info;
2630: --
2631: if g_debug then
2632: hr_utility.set_location(' Leaving:'||l_proc, 90);
2633: end if;
2634: raise;
2635: end update_person_info;
2636: --
2648: l_proc varchar2(72) := g_package||'delete_person_info';
2649: --
2650: begin
2651: if g_debug then
2652: hr_utility.set_location('Entering:'|| l_proc, 10);
2653: end if;
2654: --
2655: -- Issue a savepoint
2656: --
2701: end;
2702:
2703:
2704: if g_debug then
2705: hr_utility.set_location(' Reached '||l_proc, 10);
2706: end if;
2707:
2708: --****************audit changes**************--
2709: -- writing into audit log for backing out event --
2707:
2708: --****************audit changes**************--
2709: -- writing into audit log for backing out event --
2710: if g_debug then
2711: hr_utility.set_location(' about to BEN_CWB_AUDIT '|| l_proc, 100);
2712: end if;
2713: ben_cwb_audit_api.update_per_record(p_group_per_in_ler_id);
2714: -- ******************************************--
2715:
2723: --
2724: -- Set all IN OUT and OUT parameters with out values
2725: --
2726: if g_debug then
2727: hr_utility.set_location(' Leaving:'||l_proc, 70);
2728: end if;
2729: exception
2730: when hr_api.validate_enabled then
2731: --
2734: --
2735: rollback to delete_person_info;
2736: --
2737: if g_debug then
2738: hr_utility.set_location(' Leaving:'||l_proc, 80);
2739: end if;
2740: when others then
2741: --
2742: -- A validation or unexpected error has occured
2743: --
2744: rollback to delete_person_info;
2745: --
2746: if g_debug then
2747: hr_utility.set_location(' Leaving:'||l_proc, 90);
2748: end if;
2749: raise;
2750: end delete_person_info;
2751: --