DBA Data[Home] [Help]

APPS.BEN_PRTT_PREM_BY_MO_API dependencies on BEN_PRTT_PREM_BY_MO_F

Line 71: l_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;

67: ) is
68: --
69: -- Declare cursors and local variables
70: --
71: l_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
72: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
73: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PRTT_PREM_BY_MO';
75: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;

Line 72: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;

68: --
69: -- Declare cursors and local variables
70: --
71: l_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
72: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
73: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PRTT_PREM_BY_MO';
75: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
76: --

Line 73: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;

69: -- Declare cursors and local variables
70: --
71: l_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
72: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
73: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PRTT_PREM_BY_MO';
75: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
76: --
77: begin

Line 75: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;

71: l_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
72: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
73: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PRTT_PREM_BY_MO';
75: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
76: --
77: begin
78: --
79: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 398: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;

394: --
395: -- Declare cursors and local variables
396: --
397: l_proc varchar2(72) := g_package||'update_PRTT_PREM_BY_MO';
398: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
399: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
400: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
401: --
402: begin

Line 399: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;

395: -- Declare cursors and local variables
396: --
397: l_proc varchar2(72) := g_package||'update_PRTT_PREM_BY_MO';
398: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
399: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
400: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
401: --
402: begin
403: --

Line 400: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;

396: --
397: l_proc varchar2(72) := g_package||'update_PRTT_PREM_BY_MO';
398: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
399: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
400: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
401: --
402: begin
403: --
404: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 676: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;

672: --
673: -- Declare cursors and local variables
674: --
675: l_proc varchar2(72) := g_package||'delete_PRTT_PREM_BY_MO';
676: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
677: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
678: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
679: --
680: begin

Line 677: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;

673: -- Declare cursors and local variables
674: --
675: l_proc varchar2(72) := g_package||'delete_PRTT_PREM_BY_MO';
676: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
677: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
678: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
679: --
680: begin
681: --

Line 678: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;

674: --
675: l_proc varchar2(72) := g_package||'delete_PRTT_PREM_BY_MO';
676: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
677: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
678: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
679: --
680: begin
681: --
682: hr_utility.set_location('Entering:'|| l_proc, 10);