DBA Data[Home] [Help]

APPS.PAY_NO_EERR_CONTINUOUS dependencies on PAY_INTERPRETER_PKG

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

804: l_emp_start_date date;
805: l_emp_end_date date;
806: l_person_id per_all_people_f.person_id%type;
807: l_event_group_id pay_event_groups.event_group_id%type;
808: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
809: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
810: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
811: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
812: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

Line 809: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

805: l_emp_end_date date;
806: l_person_id per_all_people_f.person_id%type;
807: l_event_group_id pay_event_groups.event_group_id%type;
808: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
809: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
810: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
811: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
812: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
813: l_total_hours number := 0;

Line 810: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

806: l_person_id per_all_people_f.person_id%type;
807: l_event_group_id pay_event_groups.event_group_id%type;
808: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
809: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
810: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
811: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
812: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
813: l_total_hours number := 0;
814: l_total_hours_all number := 0;

Line 811: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

807: l_event_group_id pay_event_groups.event_group_id%type;
808: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
809: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
810: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
811: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
812: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
813: l_total_hours number := 0;
814: l_total_hours_all number := 0;
815: l_frequency per_all_assignments_f.frequency%type;

Line 812: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

808: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
809: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
810: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
811: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
812: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
813: l_total_hours number := 0;
814: l_total_hours_all number := 0;
815: l_frequency per_all_assignments_f.frequency%type;
816: l_hour_effective_end_date date;

Line 862: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;

858: l_sickness_unpaid_end date;
859: l_prev_hour_flag char (1);
860: l_hour_year_change_flag char (1);
861: l_corr_change_flag char (1);
862: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
863: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
864: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
865: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
866: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;

Line 863: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;

859: l_prev_hour_flag char (1);
860: l_hour_year_change_flag char (1);
861: l_corr_change_flag char (1);
862: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
863: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
864: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
865: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
866: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;
867: merge_cnt number ;

Line 864: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;

860: l_hour_year_change_flag char (1);
861: l_corr_change_flag char (1);
862: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
863: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
864: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
865: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
866: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;
867: merge_cnt number ;
868: l_hour_old_value number;

Line 865: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;

861: l_corr_change_flag char (1);
862: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
863: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
864: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
865: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
866: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;
867: merge_cnt number ;
868: l_hour_old_value number;
869: l_prev_hour_value_primary number;

Line 866: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;

862: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
863: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
864: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
865: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
866: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;
867: merge_cnt number ;
868: l_hour_old_value number;
869: l_prev_hour_value_primary number;
870: l_prev_hour_eff_date date;

Line 1513: pay_interpreter_pkg.entry_affected (

1509: close csr_get_sick_unpaid_entry;
1510:
1511: if l_element_entry_id is not null then
1512: begin
1513: pay_interpreter_pkg.entry_affected (
1514: p_element_entry_id => l_element_entry_id,
1515: p_assignment_action_id => null,
1516: p_assignment_id => j.assignment_id,
1517: p_mode => 'DATE_EARNED',

Line 1712: pay_interpreter_pkg.entry_affected (

1708: end loop;
1709: /* Multiple entry End*/
1710:
1711: begin
1712: pay_interpreter_pkg.entry_affected (
1713: p_element_entry_id => null,
1714: p_assignment_action_id => null,
1715: p_assignment_id => j.assignment_id,
1716: p_mode => 'DATE_PROCESSED',

Line 1736: pay_interpreter_pkg.entry_affected (

1732: l_detailed_output1.delete;
1733: end;
1734: /* 8K Start */
1735: begin
1736: pay_interpreter_pkg.entry_affected (
1737: p_element_entry_id => null,
1738: p_assignment_action_id => null,
1739: p_assignment_id => j.assignment_id,
1740: p_mode => 'DATE_PROCESSED',

Line 1811: pay_interpreter_pkg.entry_affected (

1807: j.assignment_id,
1808: i.local_unit_id)
1809: loop
1810: begin
1811: pay_interpreter_pkg.entry_affected (
1812: p_element_entry_id => null,
1813: p_assignment_action_id => null,
1814: p_assignment_id => l_get_all_assignments.assignment_id,
1815: p_mode => 'DATE_PROCESSED',

Line 1833: pay_interpreter_pkg.entry_affected (

1829: when others then
1830: l_detailed_output3.delete;
1831: end;
1832: begin
1833: pay_interpreter_pkg.entry_affected (
1834: p_element_entry_id => null,
1835: p_assignment_action_id => null,
1836: p_assignment_id => l_get_all_assignments.assignment_id,
1837: p_mode => 'DATE_PROCESSED',

Line 2899: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,

2895: --------------------------------------------------------------------------------
2896: -- COPY
2897: --------------------------------------------------------------------------------
2898: procedure copy (
2899: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2900: p_from in number,
2901: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2902: p_to in number
2903: ) is

Line 2901: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,

2897: --------------------------------------------------------------------------------
2898: procedure copy (
2899: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2900: p_from in number,
2901: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2902: p_to in number
2903: ) is
2904: begin
2905: --

Line 2929: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type

2925: --------------------------------------------------------------------------------
2926: -- SORT_CHANGES
2927: --------------------------------------------------------------------------------
2928: procedure sort_changes (
2929: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type
2930: ) is
2931: --
2932: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
2933: --**x NUMBER;

Line 2932: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;

2928: procedure sort_changes (
2929: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type
2930: ) is
2931: --
2932: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
2933: --**x NUMBER;
2934: --
2935: begin
2936: if p_detail_tab.count > 0 then