1: Package Body ben_benefit_actions_api as
2: /* $Header: bebftapi.pkb 115.19 2003/08/18 05:06:05 rpgupta ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: bebftapi.pkb 115.19 2003/08/18 05:06:05 rpgupta ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_benefit_actions_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_benefit_actions >------------------------|
10: -- ----------------------------------------------------------------------------
117: ,p_grant_price_val in number default null) is
118: --
119: -- Declare cursors and local variables
120: --
121: l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;
122: l_proc varchar2(72) := g_package||'create_benefit_actions';
123: l_object_version_number ben_benefit_actions.object_version_number%TYPE;
124: --
125: begin
119: -- Declare cursors and local variables
120: --
121: l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;
122: l_proc varchar2(72) := g_package||'create_benefit_actions';
123: l_object_version_number ben_benefit_actions.object_version_number%TYPE;
124: --
125: begin
126: --
127: hr_utility.set_location('Entering:'|| l_proc, 10);
140: begin
141: --
142: -- Start of API User Hook for the before hook of create_benefit_actions
143: --
144: ben_benefit_actions_bk1.create_benefit_actions_b
145: (p_process_date => p_process_date
146: ,p_uneai_effective_date => p_uneai_effective_date
147: ,p_mode_cd => p_mode_cd
148: ,p_derivable_factors_flag => p_derivable_factors_flag
361: begin
362: --
363: -- Start of API User Hook for the after hook of create_benefit_actions
364: --
365: ben_benefit_actions_bk1.create_benefit_actions_a
366: (p_benefit_action_id => l_benefit_action_id
367: ,p_process_date => p_process_date
368: ,p_uneai_effective_date => p_uneai_effective_date
369: ,p_mode_cd => p_mode_cd
635: ) is
636: --
637: -- Declare cursors and local variables
638: --
639: l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;
640: l_proc varchar2(72) := g_package||'create_perf_benefit_actions';
641: l_object_version_number ben_benefit_actions.object_version_number%TYPE;
642: --
643: begin
637: -- Declare cursors and local variables
638: --
639: l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;
640: l_proc varchar2(72) := g_package||'create_perf_benefit_actions';
641: l_object_version_number ben_benefit_actions.object_version_number%TYPE;
642: --
643: begin
644: --
645:
657: -- Process Logic
658: --
659: l_object_version_number := 1;
660: --
661: select ben_benefit_actions_s.nextval
662: into l_benefit_action_id
663: from sys.dual;
664: --
665: insert into ben_benefit_actions
661: select ben_benefit_actions_s.nextval
662: into l_benefit_action_id
663: from sys.dual;
664: --
665: insert into ben_benefit_actions
666: (benefit_action_id
667: ,process_date
668: ,uneai_effective_date
669: ,mode_cd
1023: --
1024: -- Declare cursors and local variables
1025: --
1026: l_proc varchar2(72) := g_package||'update_benefit_actions';
1027: l_object_version_number ben_benefit_actions.object_version_number%TYPE;
1028: --
1029: begin
1030: --
1031: hr_utility.set_location('Entering:'|| l_proc, 10);
1043: begin
1044: --
1045: -- Start of API User Hook for the before hook of update_benefit_actions
1046: --
1047: ben_benefit_actions_bk2.update_benefit_actions_b
1048: (p_benefit_action_id => p_benefit_action_id
1049: ,p_process_date => p_process_date
1050: ,p_uneai_effective_date => p_uneai_effective_date
1051: ,p_mode_cd => p_mode_cd
1267: begin
1268: --
1269: -- Start of API User Hook for the after hook of update_benefit_actions
1270: --
1271: ben_benefit_actions_bk2.update_benefit_actions_a
1272: (p_benefit_action_id => p_benefit_action_id
1273: ,p_process_date => p_process_date
1274: ,p_uneai_effective_date => p_uneai_effective_date
1275: ,p_mode_cd => p_mode_cd
1431: --
1432: -- Declare cursors and local variables
1433: --
1434: l_proc varchar2(72) := g_package||'update_benefit_actions';
1435: l_object_version_number ben_benefit_actions.object_version_number%TYPE;
1436: --
1437: begin
1438: --
1439: hr_utility.set_location('Entering:'|| l_proc, 10);
1451: begin
1452: --
1453: -- Start of API User Hook for the before hook of delete_benefit_actions
1454: --
1455: ben_benefit_actions_bk3.delete_benefit_actions_b
1456: (p_benefit_action_id => p_benefit_action_id
1457: ,p_object_version_number => p_object_version_number
1458: ,p_effective_date => trunc(p_effective_date));
1459: --
1477: begin
1478: --
1479: -- Start of API User Hook for the after hook of delete_benefit_actions
1480: --
1481: ben_benefit_actions_bk3.delete_benefit_actions_a
1482: (p_benefit_action_id => p_benefit_action_id
1483: ,p_object_version_number => l_object_version_number
1484: ,p_effective_date => trunc(p_effective_date));
1485: --
1551: hr_utility.set_location(' Leaving:'||l_proc, 70);
1552: --
1553: end lck;
1554: --
1555: end ben_benefit_actions_api;