DBA Data[Home] [Help]

APPS.HR_OBJECTIVES_API dependencies on PER_OBJECTIVES

Line 93: l_objective_id per_objectives.objective_id%TYPE;

89: -- Declare cursors and local variables
90: --
91: --
92: l_proc varchar2(72) := g_package||'create_objective';
93: l_objective_id per_objectives.objective_id%TYPE;
94: l_object_version_number per_objectives.object_version_number%TYPE;
95: l_effective_date date;
96: l_start_date per_objectives.start_date%TYPE;
97: l_target_date per_objectives.target_date%TYPE;

Line 94: l_object_version_number per_objectives.object_version_number%TYPE;

90: --
91: --
92: l_proc varchar2(72) := g_package||'create_objective';
93: l_objective_id per_objectives.objective_id%TYPE;
94: l_object_version_number per_objectives.object_version_number%TYPE;
95: l_effective_date date;
96: l_start_date per_objectives.start_date%TYPE;
97: l_target_date per_objectives.target_date%TYPE;
98: l_achievement_date per_objectives.achievement_date%TYPE;

Line 96: l_start_date per_objectives.start_date%TYPE;

92: l_proc varchar2(72) := g_package||'create_objective';
93: l_objective_id per_objectives.objective_id%TYPE;
94: l_object_version_number per_objectives.object_version_number%TYPE;
95: l_effective_date date;
96: l_start_date per_objectives.start_date%TYPE;
97: l_target_date per_objectives.target_date%TYPE;
98: l_achievement_date per_objectives.achievement_date%TYPE;
99:
100: l_weighting_over_100_warning boolean := false;

Line 97: l_target_date per_objectives.target_date%TYPE;

93: l_objective_id per_objectives.objective_id%TYPE;
94: l_object_version_number per_objectives.object_version_number%TYPE;
95: l_effective_date date;
96: l_start_date per_objectives.start_date%TYPE;
97: l_target_date per_objectives.target_date%TYPE;
98: l_achievement_date per_objectives.achievement_date%TYPE;
99:
100: l_weighting_over_100_warning boolean := false;
101: l_weighting_appraisal_warning boolean := false;

Line 98: l_achievement_date per_objectives.achievement_date%TYPE;

94: l_object_version_number per_objectives.object_version_number%TYPE;
95: l_effective_date date;
96: l_start_date per_objectives.start_date%TYPE;
97: l_target_date per_objectives.target_date%TYPE;
98: l_achievement_date per_objectives.achievement_date%TYPE;
99:
100: l_weighting_over_100_warning boolean := false;
101: l_weighting_appraisal_warning boolean := false;
102: begin

Line 507: l_object_version_number per_objectives.object_version_number%TYPE;

503: --
504: -- Declare cursors and local variables
505: --
506: l_proc varchar2(72) := g_package||'update_objective';
507: l_object_version_number per_objectives.object_version_number%TYPE;
508: l_ovn per_objectives.object_version_number%TYPE := p_object_version_number;
509: l_effective_date date;
510: l_start_date per_objectives.start_date%TYPE;
511: l_target_date per_objectives.target_date%TYPE;

Line 508: l_ovn per_objectives.object_version_number%TYPE := p_object_version_number;

504: -- Declare cursors and local variables
505: --
506: l_proc varchar2(72) := g_package||'update_objective';
507: l_object_version_number per_objectives.object_version_number%TYPE;
508: l_ovn per_objectives.object_version_number%TYPE := p_object_version_number;
509: l_effective_date date;
510: l_start_date per_objectives.start_date%TYPE;
511: l_target_date per_objectives.target_date%TYPE;
512: l_achievement_date per_objectives.achievement_date%TYPE;

Line 510: l_start_date per_objectives.start_date%TYPE;

506: l_proc varchar2(72) := g_package||'update_objective';
507: l_object_version_number per_objectives.object_version_number%TYPE;
508: l_ovn per_objectives.object_version_number%TYPE := p_object_version_number;
509: l_effective_date date;
510: l_start_date per_objectives.start_date%TYPE;
511: l_target_date per_objectives.target_date%TYPE;
512: l_achievement_date per_objectives.achievement_date%TYPE;
513: l_weighting_over_100_warning boolean := false;
514: l_weighting_appraisal_warning boolean := false;

Line 511: l_target_date per_objectives.target_date%TYPE;

507: l_object_version_number per_objectives.object_version_number%TYPE;
508: l_ovn per_objectives.object_version_number%TYPE := p_object_version_number;
509: l_effective_date date;
510: l_start_date per_objectives.start_date%TYPE;
511: l_target_date per_objectives.target_date%TYPE;
512: l_achievement_date per_objectives.achievement_date%TYPE;
513: l_weighting_over_100_warning boolean := false;
514: l_weighting_appraisal_warning boolean := false;
515: --

Line 512: l_achievement_date per_objectives.achievement_date%TYPE;

508: l_ovn per_objectives.object_version_number%TYPE := p_object_version_number;
509: l_effective_date date;
510: l_start_date per_objectives.start_date%TYPE;
511: l_target_date per_objectives.target_date%TYPE;
512: l_achievement_date per_objectives.achievement_date%TYPE;
513: l_weighting_over_100_warning boolean := false;
514: l_weighting_appraisal_warning boolean := false;
515: --
516: begin