DBA Data[Home] [Help]

APPS.BEN_CMBN_PTIP_API dependencies on BEN_CMBN_PTIP_F

Line 57: l_cmbn_ptip_id ben_cmbn_ptip_f.cmbn_ptip_id%TYPE;

53: ) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_cmbn_ptip_id ben_cmbn_ptip_f.cmbn_ptip_id%TYPE;
58: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_CMBN_PTIP';
61: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;

Line 58: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;

54: --
55: -- Declare cursors and local variables
56: --
57: l_cmbn_ptip_id ben_cmbn_ptip_f.cmbn_ptip_id%TYPE;
58: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_CMBN_PTIP';
61: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;
62: --

Line 59: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;

55: -- Declare cursors and local variables
56: --
57: l_cmbn_ptip_id ben_cmbn_ptip_f.cmbn_ptip_id%TYPE;
58: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_CMBN_PTIP';
61: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;
62: --
63: begin

Line 61: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;

57: l_cmbn_ptip_id ben_cmbn_ptip_f.cmbn_ptip_id%TYPE;
58: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
59: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_CMBN_PTIP';
61: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;
62: --
63: begin
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 330: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;

326: --
327: -- Declare cursors and local variables
328: --
329: l_proc varchar2(72) := g_package||'update_CMBN_PTIP';
330: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;
331: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
332: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
333: --
334: begin

Line 331: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;

327: -- Declare cursors and local variables
328: --
329: l_proc varchar2(72) := g_package||'update_CMBN_PTIP';
330: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;
331: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
332: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
333: --
334: begin
335: --

Line 332: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;

328: --
329: l_proc varchar2(72) := g_package||'update_CMBN_PTIP';
330: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;
331: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
332: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
333: --
334: begin
335: --
336: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 567: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;

563: --
564: -- Declare cursors and local variables
565: --
566: l_proc varchar2(72) := g_package||'update_CMBN_PTIP';
567: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;
568: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
569: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
570: --
571: begin

Line 568: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;

564: -- Declare cursors and local variables
565: --
566: l_proc varchar2(72) := g_package||'update_CMBN_PTIP';
567: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;
568: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
569: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
570: --
571: begin
572: --

Line 569: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;

565: --
566: l_proc varchar2(72) := g_package||'update_CMBN_PTIP';
567: l_object_version_number ben_cmbn_ptip_f.object_version_number%TYPE;
568: l_effective_start_date ben_cmbn_ptip_f.effective_start_date%TYPE;
569: l_effective_end_date ben_cmbn_ptip_f.effective_end_date%TYPE;
570: --
571: begin
572: --
573: hr_utility.set_location('Entering:'|| l_proc, 10);