DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG3 dependencies on HR_ENTRY

Line 365: p_passed_inp_tbl in hr_entry.number_table,

361: p_absence_att_type_id in number,
362: p_entry_values_count in number,
363: p_date_start in date,
364: p_date_end in date,
365: p_passed_inp_tbl in hr_entry.number_table,
366: p_passed_val_tbl in hr_entry.varchar2_table
367: ) is
368: --
369: l_proc varchar2(72) := g_package||'insert_absence_element';

Line 366: p_passed_val_tbl in hr_entry.varchar2_table

362: p_entry_values_count in number,
363: p_date_start in date,
364: p_date_end in date,
365: p_passed_inp_tbl in hr_entry.number_table,
366: p_passed_val_tbl in hr_entry.varchar2_table
367: ) is
368: --
369: l_proc varchar2(72) := g_package||'insert_absence_element';
370: -- Local variables

Line 381: l_passed_inp_tbl hr_entry.number_table;

377: l_reason hr_lookups.lookup_code%Type;
378: l_processing_type pay_element_types_f.processing_type%Type;
379: l_element_link_id pay_element_links_f.element_link_id%Type;
380: l_element_entry_id pay_element_entries_f.element_entry_id%Type;
381: l_passed_inp_tbl hr_entry.number_table;
382: l_passed_val_tbl hr_entry.varchar2_table;
383: -- Cursor to pickup the lookup code
384: cursor csr_lookup_code(p_meaning hr_lookups.meaning%Type) is
385: select hl.lookup_code

Line 382: l_passed_val_tbl hr_entry.varchar2_table;

378: l_processing_type pay_element_types_f.processing_type%Type;
379: l_element_link_id pay_element_links_f.element_link_id%Type;
380: l_element_entry_id pay_element_entries_f.element_entry_id%Type;
381: l_passed_inp_tbl hr_entry.number_table;
382: l_passed_val_tbl hr_entry.varchar2_table;
383: -- Cursor to pickup the lookup code
384: cursor csr_lookup_code(p_meaning hr_lookups.meaning%Type) is
385: select hl.lookup_code
386: from hr_lookups hl

Line 418: l_element_link_id := hr_entry_api.get_link(

414: p_entry_value => l_entry_value);
415: -- Checking element link
416: hr_utility.set_location(l_proc, 40);
417: --
418: l_element_link_id := hr_entry_api.get_link(
419: p_assignment_id => p_line_record.assignment_id,
420: p_element_type_id => l_element_type_id,
421: p_session_date => p_date_start);
422: --

Line 460: hr_entry_api.insert_element_entry(

456: --
457: l_count := l_passed_val_tbl.count;
458: --
459: -- Calling the API to create EE
460: hr_entry_api.insert_element_entry(
461: p_effective_start_date => l_effective_start_date,
462: p_effective_end_date => l_effective_end_date,
463: p_element_entry_id => l_element_entry_id,
464: p_assignment_id => p_line_record.assignment_id,

Line 542: hr_entry_api.delete_element_entry(

538: and l_element_entry_id is not null then
539: --
540: hr_utility.set_location(l_proc, 70);
541: --
542: hr_entry_api.delete_element_entry(
543: p_dt_delete_mode => 'DELETE',
544: p_session_date => p_date_end,
545: p_element_entry_id => l_element_entry_id);
546: --

Line 1385: p_passed_inp_tbl in hr_entry.number_table,

1381: p_value in varchar2,
1382: p_date_start in date,
1383: p_date_end in date,
1384: p_line_record in pay_batch_lines%Rowtype,
1385: p_passed_inp_tbl in hr_entry.number_table,
1386: p_passed_val_tbl in hr_entry.varchar2_table,
1387: p_absence_attendance_id out nocopy number,
1388: p_warning_table out nocopy t_message_table,
1389: p_error_table out nocopy t_message_table

Line 1386: p_passed_val_tbl in hr_entry.varchar2_table,

1382: p_date_start in date,
1383: p_date_end in date,
1384: p_line_record in pay_batch_lines%Rowtype,
1385: p_passed_inp_tbl in hr_entry.number_table,
1386: p_passed_val_tbl in hr_entry.varchar2_table,
1387: p_absence_attendance_id out nocopy number,
1388: p_warning_table out nocopy t_message_table,
1389: p_error_table out nocopy t_message_table
1390: ) is