DBA Data[Home] [Help]

APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PAY_INTERPRETER_PKG

Line 735: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;

731: l_emp_start_date date;
732: l_emp_end_date date;
733: l_person_id per_all_people_f.person_id%type;
734: l_event_group_id pay_event_groups.event_group_id%type;
735: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
736: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
737: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
738: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
739: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

Line 736: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

732: l_emp_end_date date;
733: l_person_id per_all_people_f.person_id%type;
734: l_event_group_id pay_event_groups.event_group_id%type;
735: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
736: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
737: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
738: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
739: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
740: l_total_hours number := 0;

Line 737: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

733: l_person_id per_all_people_f.person_id%type;
734: l_event_group_id pay_event_groups.event_group_id%type;
735: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
736: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
737: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
738: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
739: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
740: l_total_hours number := 0;
741: l_total_hours_all number := 0;

Line 738: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

734: l_event_group_id pay_event_groups.event_group_id%type;
735: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
736: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
737: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
738: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
739: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
740: l_total_hours number := 0;
741: l_total_hours_all number := 0;
742: l_frequency per_all_assignments_f.frequency%type;

Line 739: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

735: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
736: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
737: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
738: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
739: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
740: l_total_hours number := 0;
741: l_total_hours_all number := 0;
742: l_frequency per_all_assignments_f.frequency%type;
743: l_hour_effective_end_date date;

Line 792: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;

788: l_prev_hour_flag char (1);
789: /* Flag to set whether the hours have got changed during the period or not*/
790: l_hour_year_change_flag char (1);
791: l_national_identifier per_all_people_f.national_identifier%type;
792: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
793: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
794: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
795: l_empty_detailed_output l_detailed_output_table_type;
796: merge_cnt number ;

Line 793: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;

789: /* Flag to set whether the hours have got changed during the period or not*/
790: l_hour_year_change_flag char (1);
791: l_national_identifier per_all_people_f.national_identifier%type;
792: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
793: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
794: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
795: l_empty_detailed_output l_detailed_output_table_type;
796: merge_cnt number ;
797: l_hour_old_value number;

Line 794: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;

790: l_hour_year_change_flag char (1);
791: l_national_identifier per_all_people_f.national_identifier%type;
792: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
793: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
794: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
795: l_empty_detailed_output l_detailed_output_table_type;
796: merge_cnt number ;
797: l_hour_old_value number;
798: l_prev_hour_value_primary number;

Line 1256: pay_interpreter_pkg.entry_affected (

1252: fetch csr_get_sick_unpaid_entry into l_element_entry_id;
1253: close csr_get_sick_unpaid_entry;
1254:
1255: begin
1256: pay_interpreter_pkg.entry_affected (
1257: p_element_entry_id => l_element_entry_id,
1258: p_assignment_action_id => null,
1259: p_assignment_id => j.assignment_id,
1260: p_mode => 'DATE_EARNED',

Line 1333: pay_interpreter_pkg.entry_affected (

1329: end if;
1330: end if;*/
1331:
1332: begin
1333: pay_interpreter_pkg.entry_affected (
1334: p_element_entry_id => null,
1335: p_assignment_action_id => null,
1336: p_assignment_id => j.assignment_id,
1337: p_mode => 'DATE_PROCESSED',

Line 1385: pay_interpreter_pkg.entry_affected (

1381: j.assignment_id,
1382: i.local_unit_id)
1383: loop
1384: begin
1385: pay_interpreter_pkg.entry_affected (
1386: p_element_entry_id => null,
1387: p_assignment_action_id => null,
1388: p_assignment_id => l_get_all_assignments.assignment_id,
1389: p_mode => 'DATE_PROCESSED',

Line 2036: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,

2032: --------------------------------------------------------------------------------
2033: -- COPY
2034: --------------------------------------------------------------------------------
2035: procedure copy (
2036: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2037: p_from in number,
2038: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2039: p_to in number
2040: ) is

Line 2038: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,

2034: --------------------------------------------------------------------------------
2035: procedure copy (
2036: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2037: p_from in number,
2038: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2039: p_to in number
2040: ) is
2041: begin
2042: --

Line 2066: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type

2062: --------------------------------------------------------------------------------
2063: -- SORT_CHANGES
2064: --------------------------------------------------------------------------------
2065: procedure sort_changes (
2066: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type
2067: ) is
2068: --
2069: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
2070: --**x NUMBER;

Line 2069: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;

2065: procedure sort_changes (
2066: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type
2067: ) is
2068: --
2069: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
2070: --**x NUMBER;
2071: --
2072: begin
2073: if p_detail_tab.count > 0 then