APPS.BEN_COMP_COMM_TYPES_API dependencies on BEN_CM_TYP_F

Line 70: l_cm_typ_id ben_cm_typ_f.cm_typ_id%TYPE;

66: ,p_effective_date in date) is
67: --
68: -- Declare cursors and local variables
69: --
70: l_cm_typ_id ben_cm_typ_f.cm_typ_id%TYPE;
71: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
72: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_comp_comm_types';
74: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;

Line 71: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;

67: --
68: -- Declare cursors and local variables
69: --
70: l_cm_typ_id ben_cm_typ_f.cm_typ_id%TYPE;
71: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
72: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_comp_comm_types';
74: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
75: --

Line 72: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;

68: -- Declare cursors and local variables
69: --
70: l_cm_typ_id ben_cm_typ_f.cm_typ_id%TYPE;
71: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
72: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_comp_comm_types';
74: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
75: --
76: begin

Line 74: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;

70: l_cm_typ_id ben_cm_typ_f.cm_typ_id%TYPE;
71: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
72: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_comp_comm_types';
74: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
75: --
76: begin
77: --
78: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 391: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;

387: --
388: -- Declare cursors and local variables
389: --
390: l_proc varchar2(72) := g_package||'update_comp_comm_types';
391: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
392: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
393: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
394: --
395: begin

Line 392: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;

388: -- Declare cursors and local variables
389: --
390: l_proc varchar2(72) := g_package||'update_comp_comm_types';
391: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
392: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
393: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
394: --
395: begin
396: --

Line 393: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;

389: --
390: l_proc varchar2(72) := g_package||'update_comp_comm_types';
391: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
392: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
393: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
394: --
395: begin
396: --
397: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 669: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;

665: --
666: -- Declare cursors and local variables
667: --
668: l_proc varchar2(72) := g_package||'update_comp_comm_types';
669: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
670: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
671: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
672: --
673: begin

Line 670: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;

666: -- Declare cursors and local variables
667: --
668: l_proc varchar2(72) := g_package||'update_comp_comm_types';
669: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
670: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
671: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
672: --
673: begin
674: --

Line 671: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;

667: --
668: l_proc varchar2(72) := g_package||'update_comp_comm_types';
669: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
670: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
671: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
672: --
673: begin
674: --
675: hr_utility.set_location('Entering:'|| l_proc, 10);