DBA Data[Home] [Help]

APPS.BEN_BENEFIT_ACTIONS_API dependencies on BEN_BENEFIT_ACTIONS

Line 1: Package Body ben_benefit_actions_api as

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: --

Line 6: g_package varchar2(33) := ' ben_benefit_actions_api.';

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: -- ----------------------------------------------------------------------------

Line 121: l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;

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

Line 123: l_object_version_number ben_benefit_actions.object_version_number%TYPE;

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);

Line 144: ben_benefit_actions_bk1.create_benefit_actions_b

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

Line 365: ben_benefit_actions_bk1.create_benefit_actions_a

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

Line 639: l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;

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

Line 641: l_object_version_number ben_benefit_actions.object_version_number%TYPE;

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:

Line 661: select ben_benefit_actions_s.nextval

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

Line 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

Line 1027: l_object_version_number ben_benefit_actions.object_version_number%TYPE;

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);

Line 1047: ben_benefit_actions_bk2.update_benefit_actions_b

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

Line 1271: ben_benefit_actions_bk2.update_benefit_actions_a

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

Line 1435: l_object_version_number ben_benefit_actions.object_version_number%TYPE;

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);

Line 1455: ben_benefit_actions_bk3.delete_benefit_actions_b

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: --

Line 1481: ben_benefit_actions_bk3.delete_benefit_actions_a

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: --

Line 1555: end ben_benefit_actions_api;

1551: hr_utility.set_location(' Leaving:'||l_proc, 70);
1552: --
1553: end lck;
1554: --
1555: end ben_benefit_actions_api;