DBA Data[Home] [Help]

APPS.GHR_ELEMENT_ENTRY_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 88: l_creator_type pay_element_entries_f.creator_type%TYPE;

84: ) IS
85: --
86: -- Declare cursors and local variables
87: --
88: l_creator_type pay_element_entries_f.creator_type%TYPE;
89: l_creator_id pay_element_entries_f.creator_id%TYPE;
90: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
91: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
92: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

Line 89: l_creator_id pay_element_entries_f.creator_id%TYPE;

85: --
86: -- Declare cursors and local variables
87: --
88: l_creator_type pay_element_entries_f.creator_type%TYPE;
89: l_creator_id pay_element_entries_f.creator_id%TYPE;
90: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
91: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
92: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
93: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

Line 90: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

86: -- Declare cursors and local variables
87: --
88: l_creator_type pay_element_entries_f.creator_type%TYPE;
89: l_creator_id pay_element_entries_f.creator_id%TYPE;
90: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
91: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
92: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
93: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
94: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;

Line 91: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

87: --
88: l_creator_type pay_element_entries_f.creator_type%TYPE;
89: l_creator_id pay_element_entries_f.creator_id%TYPE;
90: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
91: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
92: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
93: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
94: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
95: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;

Line 92: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

88: l_creator_type pay_element_entries_f.creator_type%TYPE;
89: l_creator_id pay_element_entries_f.creator_id%TYPE;
90: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
91: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
92: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
93: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
94: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
95: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
96: l_period_status per_time_periods.status%TYPE;

Line 93: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

89: l_creator_id pay_element_entries_f.creator_id%TYPE;
90: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
91: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
92: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
93: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
94: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
95: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
96: l_period_status per_time_periods.status%TYPE;
97: l_date_on_which_time_served_ok date;

Line 310: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

306: -- Declare cursors and local variables
307: --
308:
309: l_proc varchar2(72) := g_package||'update_element_entry';
310: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
311: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
312: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
313: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
314: l_creator_type pay_element_entries_f.creator_type%TYPE;

Line 311: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

307: --
308:
309: l_proc varchar2(72) := g_package||'update_element_entry';
310: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
311: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
312: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
313: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
314: l_creator_type pay_element_entries_f.creator_type%TYPE;
315: l_creator_id pay_element_entries_f.creator_id%TYPE;

Line 312: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

308:
309: l_proc varchar2(72) := g_package||'update_element_entry';
310: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
311: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
312: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
313: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
314: l_creator_type pay_element_entries_f.creator_type%TYPE;
315: l_creator_id pay_element_entries_f.creator_id%TYPE;
316: --

Line 313: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

309: l_proc varchar2(72) := g_package||'update_element_entry';
310: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
311: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
312: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
313: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
314: l_creator_type pay_element_entries_f.creator_type%TYPE;
315: l_creator_id pay_element_entries_f.creator_id%TYPE;
316: --
317: BEGIN

Line 314: l_creator_type pay_element_entries_f.creator_type%TYPE;

310: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
311: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
312: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
313: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
314: l_creator_type pay_element_entries_f.creator_type%TYPE;
315: l_creator_id pay_element_entries_f.creator_id%TYPE;
316: --
317: BEGIN
318: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 315: l_creator_id pay_element_entries_f.creator_id%TYPE;

311: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
312: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
313: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
314: l_creator_type pay_element_entries_f.creator_type%TYPE;
315: l_creator_id pay_element_entries_f.creator_id%TYPE;
316: --
317: BEGIN
318: hr_utility.set_location('Entering:'|| l_proc, 5);
319: --