[Home] [Help]
62: assignment_id per_assignments_f.assignment_id%TYPE
63: ,start_date per_assignments_f.effective_start_date%TYPE
64: ,end_date per_assignments_f.effective_end_date%TYPE
65: ,payroll_id per_assignments_f.payroll_id%TYPE
66: ,tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
67: );
68:
69: TYPE tab_fw_dates IS TABLE OF fw_asg_data_type INDEX BY BINARY_INTEGER;
70:
90: RETURN VARCHAR2;
91:
92:
93: PROCEDURE get_foreign_worker_dates (p_assignment_id IN per_assignments_f.assignment_id%TYPE
94: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
95: ,p_start_date IN DATE
96: ,p_end_date IN DATE
97: ,p_fw_type IN VARCHAR2
98: ,p_tab_fw_dates OUT NOCOPY pay_au_foreign_workers.tab_fw_dates);
98: ,p_tab_fw_dates OUT NOCOPY pay_au_foreign_workers.tab_fw_dates);
99:
100:
101: FUNCTION check_fw_terminated(p_assignment_id IN per_assignments_f.assignment_id%TYPE
102: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
103: ,p_start_date IN DATE
104: ,p_end_date IN DATE
105: ,p_fw_type IN VARCHAR2
106: ,p_act_term_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE)
112: ,p_def_bal_tab OUT NOCOPY pay_balance_pkg.t_balance_value_tab
113: );
114:
115: FUNCTION is_le_changed(p_assignment_id IN per_assignments_f.assignment_id%TYPE
116: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
117: ,p_payroll_id IN per_time_periods.payroll_id%TYPE
118: ,p_time_period_id IN per_time_periods.time_period_id%TYPE)
119: RETURN VARCHAR2;
120:
119: RETURN VARCHAR2;
120:
121:
122: PROCEDURE get_foreign_payment_amounts(p_assignment_id IN per_assignments_f.assignment_id%TYPE
123: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
124: ,p_tab_fw_dates IN pay_au_foreign_workers.tab_fw_dates
125: ,p_start_date IN DATE
126: ,p_end_date IN DATE
127: ,p_fw_type IN VARCHAR2