DBA Data[Home] [Help]

APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PAY_INTERPRETER_PKG

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

907: l_emp_start_date date;
908: l_emp_end_date date;
909: l_person_id per_all_people_f.person_id%type;
910: l_event_group_id pay_event_groups.event_group_id%type;
911: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
912: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
913: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
914: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
915: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

Line 912: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;

908: l_emp_end_date date;
909: l_person_id per_all_people_f.person_id%type;
910: l_event_group_id pay_event_groups.event_group_id%type;
911: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
912: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
913: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
914: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
915: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
916: l_total_hours number := 0;

Line 913: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;

909: l_person_id per_all_people_f.person_id%type;
910: l_event_group_id pay_event_groups.event_group_id%type;
911: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
912: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
913: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
914: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
915: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
916: l_total_hours number := 0;
917: l_total_hours_all number := 0;

Line 914: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;

910: l_event_group_id pay_event_groups.event_group_id%type;
911: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
912: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
913: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
914: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
915: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
916: l_total_hours number := 0;
917: l_total_hours_all number := 0;
918: l_frequency per_all_assignments_f.frequency%type;

Line 915: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

911: l_detailed_output l_detailed_output_table_type; -- pay_interpreter_pkg.t_detailed_output_table_type;
912: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
913: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
914: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
915: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
916: l_total_hours number := 0;
917: l_total_hours_all number := 0;
918: l_frequency per_all_assignments_f.frequency%type;
919: l_hour_effective_end_date date;

Line 968: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;

964: l_prev_hour_flag char (1);
965: /* Flag to set whether the hours have got changed during the period or not*/
966: l_hour_year_change_flag char (1);
967: l_national_identifier per_all_people_f.national_identifier%type;
968: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
969: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
970: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
971: l_empty_detailed_output l_detailed_output_table_type;
972: merge_cnt number ;

Line 969: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;

965: /* Flag to set whether the hours have got changed during the period or not*/
966: l_hour_year_change_flag char (1);
967: l_national_identifier per_all_people_f.national_identifier%type;
968: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
969: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
970: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
971: l_empty_detailed_output l_detailed_output_table_type;
972: merge_cnt number ;
973: l_hour_old_value number;

Line 970: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;

966: l_hour_year_change_flag char (1);
967: l_national_identifier per_all_people_f.national_identifier%type;
968: l_detailed_output1 pay_interpreter_pkg.t_detailed_output_table_type;
969: l_detailed_output2 pay_interpreter_pkg.t_detailed_output_table_type;
970: l_detailed_output3 pay_interpreter_pkg.t_detailed_output_table_type;
971: l_empty_detailed_output l_detailed_output_table_type;
972: merge_cnt number ;
973: l_hour_old_value number;
974: l_prev_hour_value_primary number;

Line 1433: pay_interpreter_pkg.entry_affected (

1429: fetch csr_get_sick_unpaid_entry into l_element_entry_id;
1430: close csr_get_sick_unpaid_entry;
1431:
1432: begin
1433: pay_interpreter_pkg.entry_affected (
1434: p_element_entry_id => l_element_entry_id,
1435: p_assignment_action_id => null,
1436: p_assignment_id => j.assignment_id,
1437: p_mode => 'DATE_EARNED',

Line 1510: pay_interpreter_pkg.entry_affected (

1506: end if;
1507: end if;*/
1508:
1509: begin
1510: pay_interpreter_pkg.entry_affected (
1511: p_element_entry_id => null,
1512: p_assignment_action_id => null,
1513: p_assignment_id => j.assignment_id,
1514: p_mode => 'DATE_PROCESSED',

Line 1562: pay_interpreter_pkg.entry_affected (

1558: j.assignment_id,
1559: i.local_unit_id)
1560: loop
1561: begin
1562: pay_interpreter_pkg.entry_affected (
1563: p_element_entry_id => null,
1564: p_assignment_action_id => null,
1565: p_assignment_id => l_get_all_assignments.assignment_id,
1566: p_mode => 'DATE_PROCESSED',

Line 2213: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,

2209: --------------------------------------------------------------------------------
2210: -- COPY
2211: --------------------------------------------------------------------------------
2212: procedure copy (
2213: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2214: p_from in number,
2215: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2216: p_to in number
2217: ) is

Line 2215: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,

2211: --------------------------------------------------------------------------------
2212: procedure copy (
2213: p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2214: p_from in number,
2215: p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
2216: p_to in number
2217: ) is
2218: begin
2219: --

Line 2243: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type

2239: --------------------------------------------------------------------------------
2240: -- SORT_CHANGES
2241: --------------------------------------------------------------------------------
2242: procedure sort_changes (
2243: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type
2244: ) is
2245: --
2246: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
2247: --**x NUMBER;

Line 2246: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;

2242: procedure sort_changes (
2243: p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type
2244: ) is
2245: --
2246: l_temp_table pay_interpreter_pkg.t_detailed_output_table_type;
2247: --**x NUMBER;
2248: --
2249: begin
2250: if p_detail_tab.count > 0 then