DBA Data[Home] [Help]

APPS.BEN_DESIGN_RQMT_API dependencies on BEN_DSGN_RQMT_F

Line 65: l_dsgn_rqmt_id ben_dsgn_rqmt_f.dsgn_rqmt_id%TYPE;

61: ) is
62: --
63: -- Declare cursors and local variables
64: --
65: l_dsgn_rqmt_id ben_dsgn_rqmt_f.dsgn_rqmt_id%TYPE;
66: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_design_rqmt';
69: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;

Line 66: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;

62: --
63: -- Declare cursors and local variables
64: --
65: l_dsgn_rqmt_id ben_dsgn_rqmt_f.dsgn_rqmt_id%TYPE;
66: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_design_rqmt';
69: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
70: --

Line 67: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;

63: -- Declare cursors and local variables
64: --
65: l_dsgn_rqmt_id ben_dsgn_rqmt_f.dsgn_rqmt_id%TYPE;
66: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_design_rqmt';
69: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
70: --
71: begin

Line 69: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;

65: l_dsgn_rqmt_id ben_dsgn_rqmt_f.dsgn_rqmt_id%TYPE;
66: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_design_rqmt';
69: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
70: --
71: begin
72: --
73: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 370: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;

366: --
367: -- Declare cursors and local variables
368: --
369: l_proc varchar2(72) := g_package||'update_design_rqmt';
370: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
371: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
372: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
373: --
374: begin

Line 371: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;

367: -- Declare cursors and local variables
368: --
369: l_proc varchar2(72) := g_package||'update_design_rqmt';
370: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
371: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
372: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
373: --
374: begin
375: --

Line 372: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;

368: --
369: l_proc varchar2(72) := g_package||'update_design_rqmt';
370: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
371: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
372: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
373: --
374: begin
375: --
376: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 636: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;

632: --
633: -- Declare cursors and local variables
634: --
635: l_proc varchar2(72) := g_package||'update_design_rqmt';
636: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
637: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
638: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
639: --
640: begin

Line 637: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;

633: -- Declare cursors and local variables
634: --
635: l_proc varchar2(72) := g_package||'update_design_rqmt';
636: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
637: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
638: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
639: --
640: begin
641: --

Line 638: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;

634: --
635: l_proc varchar2(72) := g_package||'update_design_rqmt';
636: l_object_version_number ben_dsgn_rqmt_f.object_version_number%TYPE;
637: l_effective_start_date ben_dsgn_rqmt_f.effective_start_date%TYPE;
638: l_effective_end_date ben_dsgn_rqmt_f.effective_end_date%TYPE;
639: --
640: begin
641: --
642: hr_utility.set_location('Entering:'|| l_proc, 10);