APPS.BEN_COMP_COMM_TYPES_API dependencies on BEN_CM_TYP_F

Line 69: l_cm_typ_id ben_cm_typ_f.cm_typ_id%TYPE;

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

Line 70: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;

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

Line 71: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;

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

Line 73: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;

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

Line 383: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;

379: --
380: -- Declare cursors and local variables
381: --
382: l_proc varchar2(72) := g_package||'update_comp_comm_types';
383: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
384: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
385: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
386: --
387: begin

Line 384: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;

380: -- Declare cursors and local variables
381: --
382: l_proc varchar2(72) := g_package||'update_comp_comm_types';
383: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
384: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
385: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
386: --
387: begin
388: --

Line 385: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;

381: --
382: l_proc varchar2(72) := g_package||'update_comp_comm_types';
383: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
384: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
385: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
386: --
387: begin
388: --
389: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 655: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;

651: --
652: -- Declare cursors and local variables
653: --
654: l_proc varchar2(72) := g_package||'update_comp_comm_types';
655: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
656: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
657: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
658: --
659: begin

Line 656: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;

652: -- Declare cursors and local variables
653: --
654: l_proc varchar2(72) := g_package||'update_comp_comm_types';
655: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
656: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
657: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
658: --
659: begin
660: --

Line 657: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;

653: --
654: l_proc varchar2(72) := g_package||'update_comp_comm_types';
655: l_object_version_number ben_cm_typ_f.object_version_number%TYPE;
656: l_effective_start_date ben_cm_typ_f.effective_start_date%TYPE;
657: l_effective_end_date ben_cm_typ_f.effective_end_date%TYPE;
658: --
659: begin
660: --
661: hr_utility.set_location('Entering:'|| l_proc, 10);