DBA Data[Home] [Help]

APPS.PAY_NO_EERR_CONTINUOUS dependencies on PAY_INTERPRETER_PKG

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

970: l_emp_start_date date;
971: l_emp_end_date date;
972: l_person_id per_all_people_f.person_id%type;
973: l_event_group_id pay_event_groups.event_group_id%type;
974: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
975: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
976: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
977: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
978: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

Line 975: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

971: l_emp_end_date date;
972: l_person_id per_all_people_f.person_id%type;
973: l_event_group_id pay_event_groups.event_group_id%type;
974: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
975: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
976: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
977: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
978: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
979: l_total_hours number := 0;

Line 976: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

972: l_person_id per_all_people_f.person_id%type;
973: l_event_group_id pay_event_groups.event_group_id%type;
974: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
975: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
976: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
977: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
978: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
979: l_total_hours number := 0;
980: l_total_hours_all number := 0;

Line 977: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

973: l_event_group_id pay_event_groups.event_group_id%type;
974: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
975: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
976: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
977: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
978: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
979: l_total_hours number := 0;
980: l_total_hours_all number := 0;
981: l_frequency per_all_assignments_f.frequency%type;

Line 978: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

974: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
975: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
976: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
977: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
978: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
979: l_total_hours number := 0;
980: l_total_hours_all number := 0;
981: l_frequency per_all_assignments_f.frequency%type;
982: l_hour_effective_end_date date;

Line 1028: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;

1024: l_sickness_unpaid_end date;
1025: l_prev_hour_flag char (1);
1026: l_hour_year_change_flag char (1);
1027: l_corr_change_flag char (1);
1028: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
1029: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
1030: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
1031: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
1032: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;

Line 1029: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;

1025: l_prev_hour_flag char (1);
1026: l_hour_year_change_flag char (1);
1027: l_corr_change_flag char (1);
1028: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
1029: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
1030: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
1031: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
1032: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;
1033: merge_cnt number ;

Line 1030: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;

1026: l_hour_year_change_flag char (1);
1027: l_corr_change_flag char (1);
1028: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
1029: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
1030: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
1031: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
1032: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;
1033: merge_cnt number ;
1034: l_hour_old_value number;

Line 1031: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;

1027: l_corr_change_flag char (1);
1028: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
1029: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
1030: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
1031: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
1032: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;
1033: merge_cnt number ;
1034: l_hour_old_value number;
1035: l_prev_hour_value_primary number;

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

1028: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
1029: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
1030: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
1031: l_detailed_output4 pay_interpreter_pkg.t_detailed_output_table_type;
1032: l_empty_detailed_output l_detailed_output_table_type;--pay_interpreter_pkg.t_detailed_output_table_type;
1033: merge_cnt number ;
1034: l_hour_old_value number;
1035: l_prev_hour_value_primary number;
1036: l_prev_hour_eff_date date;

Line 1679: pay_interpreter_pkg.entry_affected (

1675: close csr_get_sick_unpaid_entry;
1676:
1677: if l_element_entry_id is not null then
1678: begin
1679: pay_interpreter_pkg.entry_affected (
1680: p_element_entry_id => l_element_entry_id,
1681: p_assignment_action_id => null,
1682: p_assignment_id => j.assignment_id,
1683: p_mode => 'DATE_EARNED',

Line 1878: pay_interpreter_pkg.entry_affected (

1874: end loop;
1875: /* Multiple entry End*/
1876:
1877: begin
1878: pay_interpreter_pkg.entry_affected (
1879: p_element_entry_id => null,
1880: p_assignment_action_id => null,
1881: p_assignment_id => j.assignment_id,
1882: p_mode => 'DATE_PROCESSED',

Line 1902: pay_interpreter_pkg.entry_affected (

1898: l_detailed_output1.delete;
1899: end;
1900: /* 8K Start */
1901: begin
1902: pay_interpreter_pkg.entry_affected (
1903: p_element_entry_id => null,
1904: p_assignment_action_id => null,
1905: p_assignment_id => j.assignment_id,
1906: p_mode => 'DATE_PROCESSED',

Line 1977: pay_interpreter_pkg.entry_affected (

1973: j.assignment_id,
1974: i.local_unit_id)
1975: loop
1976: begin
1977: pay_interpreter_pkg.entry_affected (
1978: p_element_entry_id => null,
1979: p_assignment_action_id => null,
1980: p_assignment_id => l_get_all_assignments.assignment_id,
1981: p_mode => 'DATE_PROCESSED',

Line 1999: pay_interpreter_pkg.entry_affected (

1995: when others then
1996: l_detailed_output3.delete;
1997: end;
1998: begin
1999: pay_interpreter_pkg.entry_affected (
2000: p_element_entry_id => null,
2001: p_assignment_action_id => null,
2002: p_assignment_id => l_get_all_assignments.assignment_id,
2003: p_mode => 'DATE_PROCESSED',

Line 3086: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,

3082: --------------------------------------------------------------------------------
3083: -- COPY
3084: --------------------------------------------------------------------------------
3085: procedure copy (
3086: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
3087: p_from in number,
3088: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
3089: p_to in number
3090: ) is

Line 3088: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,

3084: --------------------------------------------------------------------------------
3085: procedure copy (
3086: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
3087: p_from in number,
3088: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
3089: p_to in number
3090: ) is
3091: begin
3092: --

Line 3116: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type

3112: --------------------------------------------------------------------------------
3113: -- SORT_CHANGES
3114: --------------------------------------------------------------------------------
3115: procedure sort_changes (
3116: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type
3117: ) is
3118: --
3119: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
3120: --**x NUMBER;

Line 3119: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;

3115: procedure sort_changes (
3116: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type
3117: ) is
3118: --
3119: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
3120: --**x NUMBER;
3121: --
3122: begin
3123: if p_detail_tab.count > 0 then