DBA Data[Home] [Help]

APPS.BEN_PLAN_GOODS_SERV_CERT_API dependencies on BEN_PL_GD_R_SVC_CTFN_F

Line 62: l_pl_gd_r_svc_ctfn_id ben_pl_gd_r_svc_ctfn_f.pl_gd_r_svc_ctfn_id%TYPE;

58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_pl_gd_r_svc_ctfn_id ben_pl_gd_r_svc_ctfn_f.pl_gd_r_svc_ctfn_id%TYPE;
63: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_plan_goods_serv_cert';
66: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;

Line 63: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;

59: --
60: -- Declare cursors and local variables
61: --
62: l_pl_gd_r_svc_ctfn_id ben_pl_gd_r_svc_ctfn_f.pl_gd_r_svc_ctfn_id%TYPE;
63: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_plan_goods_serv_cert';
66: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;
67: --

Line 64: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;

60: -- Declare cursors and local variables
61: --
62: l_pl_gd_r_svc_ctfn_id ben_pl_gd_r_svc_ctfn_f.pl_gd_r_svc_ctfn_id%TYPE;
63: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_plan_goods_serv_cert';
66: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;
67: --
68: begin

Line 66: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;

62: l_pl_gd_r_svc_ctfn_id ben_pl_gd_r_svc_ctfn_f.pl_gd_r_svc_ctfn_id%TYPE;
63: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_plan_goods_serv_cert';
66: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 356: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;

352: --
353: -- Declare cursors and local variables
354: --
355: l_proc varchar2(72) := g_package||'update_plan_goods_serv_cert';
356: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;
357: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
358: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
359: --
360: begin

Line 357: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;

353: -- Declare cursors and local variables
354: --
355: l_proc varchar2(72) := g_package||'update_plan_goods_serv_cert';
356: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;
357: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
358: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
359: --
360: begin
361: --

Line 358: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;

354: --
355: l_proc varchar2(72) := g_package||'update_plan_goods_serv_cert';
356: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;
357: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
358: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
359: --
360: begin
361: --
362: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 609: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;

605: --
606: -- Declare cursors and local variables
607: --
608: l_proc varchar2(72) := g_package||'update_plan_goods_serv_cert';
609: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;
610: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
611: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
612: --
613: begin

Line 610: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;

606: -- Declare cursors and local variables
607: --
608: l_proc varchar2(72) := g_package||'update_plan_goods_serv_cert';
609: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;
610: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
611: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
612: --
613: begin
614: --

Line 611: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;

607: --
608: l_proc varchar2(72) := g_package||'update_plan_goods_serv_cert';
609: l_object_version_number ben_pl_gd_r_svc_ctfn_f.object_version_number%TYPE;
610: l_effective_start_date ben_pl_gd_r_svc_ctfn_f.effective_start_date%TYPE;
611: l_effective_end_date ben_pl_gd_r_svc_ctfn_f.effective_end_date%TYPE;
612: --
613: begin
614: --
615: hr_utility.set_location('Entering:'|| l_proc, 10);