DBA Data[Home] [Help]

APPS.BEN_ACTY_BASE_RATE_API dependencies on BEN_ACTY_BASE_RT_F

Line 155: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;

151: ) is
152: --
153: -- Declare cursors and local variables
154: --
155: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;
156: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
157: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
158: l_proc varchar2(72) := g_package||'create_acty_base_rate';
159: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;

Line 156: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;

152: --
153: -- Declare cursors and local variables
154: --
155: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;
156: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
157: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
158: l_proc varchar2(72) := g_package||'create_acty_base_rate';
159: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
160: --

Line 157: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;

153: -- Declare cursors and local variables
154: --
155: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;
156: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
157: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
158: l_proc varchar2(72) := g_package||'create_acty_base_rate';
159: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
160: --
161:

Line 159: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;

155: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;
156: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
157: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
158: l_proc varchar2(72) := g_package||'create_acty_base_rate';
159: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
160: --
161:
162: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
163: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;

Line 162: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;

158: l_proc varchar2(72) := g_package||'create_acty_base_rate';
159: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
160: --
161:
162: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
163: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
164: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
165: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
166:

Line 163: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;

159: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
160: --
161:
162: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
163: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
164: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
165: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
166:
167: --

Line 164: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;

160: --
161:
162: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
163: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
164: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
165: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
166:
167: --
168: begin

Line 165: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;

161:
162: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
163: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
164: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
165: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
166:
167: --
168: begin
169: --

Line 837: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;

833: --
834: -- Declare cursors and local variables
835: --
836: l_proc varchar2(72) := g_package||'update_acty_base_rate';
837: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
838: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
839: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
840: --
841: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;

Line 838: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;

834: -- Declare cursors and local variables
835: --
836: l_proc varchar2(72) := g_package||'update_acty_base_rate';
837: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
838: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
839: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
840: --
841: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
842: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;

Line 839: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;

835: --
836: l_proc varchar2(72) := g_package||'update_acty_base_rate';
837: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
838: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
839: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
840: --
841: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
842: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
843: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;

Line 841: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;

837: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
838: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
839: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
840: --
841: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
842: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
843: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
844: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
845: ---

Line 842: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;

838: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
839: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
840: --
841: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
842: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
843: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
844: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
845: ---
846: begin

Line 843: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;

839: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
840: --
841: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
842: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
843: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
844: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
845: ---
846: begin
847: --

Line 844: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;

840: --
841: l_use_to_calc_net_flx_cr_flag ben_acty_base_rt_f.use_to_calc_net_flx_cr_flag%TYPE := p_use_to_calc_net_flx_cr_flag;
842: l_asn_on_enrt_flag ben_acty_base_rt_f.asn_on_enrt_flag%TYPE := p_asn_on_enrt_flag;
843: l_entr_val_at_enrt_flag ben_acty_base_rt_f.entr_val_at_enrt_flag%TYPE := p_entr_val_at_enrt_flag;
844: l_prdct_flx_cr_when_elig_flag ben_acty_base_rt_f.prdct_flx_cr_when_elig_flag%TYPE := p_prdct_flx_cr_when_elig_flag;
845: ---
846: begin
847: --
848: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1379: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;

1375: --
1376: -- Declare cursors and local variables
1377: --
1378: l_proc varchar2(72) := g_package||'update_acty_base_rate';
1379: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
1380: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
1381: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
1382: l_dummy varchar2(1);
1383: l_error boolean;

Line 1380: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;

1376: -- Declare cursors and local variables
1377: --
1378: l_proc varchar2(72) := g_package||'update_acty_base_rate';
1379: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
1380: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
1381: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
1382: l_dummy varchar2(1);
1383: l_error boolean;
1384: --

Line 1381: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;

1377: --
1378: l_proc varchar2(72) := g_package||'update_acty_base_rate';
1379: l_object_version_number ben_acty_base_rt_f.object_version_number%TYPE;
1380: l_effective_start_date ben_acty_base_rt_f.effective_start_date%TYPE;
1381: l_effective_end_date ben_acty_base_rt_f.effective_end_date%TYPE;
1382: l_dummy varchar2(1);
1383: l_error boolean;
1384: --
1385: cursor c_chk_ecr is