80:
81: -- Procedure for Batch Balance Retrieval
82: PROCEDURE get_value_bbr(c_year_start DATE,
83: c_year_end DATE,
84: c_assignment_id pay_assignment_actions.assignment_id%type,
85: c_fbt_rate ff_globals_f.global_value%TYPE,
86: c_ml_rate ff_globals_f.global_value%TYPE,
87: p_assignment_action_id pay_assignment_actions.assignment_id%type,
88: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
83: c_year_end DATE,
84: c_assignment_id pay_assignment_actions.assignment_id%type,
85: c_fbt_rate ff_globals_f.global_value%TYPE,
86: c_ml_rate ff_globals_f.global_value%TYPE,
87: p_assignment_action_id pay_assignment_actions.assignment_id%type,
88: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
89: p_termination_date DATE, --Bug 3098367
90: p_display_flag OUT NOCOPY VARCHAR2, --Bug 3098367
91: p_output_tab OUT NOCOPY bal_tab,
142:
143:
144: Function get_total_allowances(c_year_start DATE,
145: c_year_end DATE,
146: c_assignment_id pay_assignment_actions.assignment_id%type,
147: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
148: c_registered_employer NUMBER,
149: c_message OUT NOCOPY VARCHAR2) /* Bug#4863149 */
150: return number;
143:
144: Function get_total_allowances(c_year_start DATE,
145: c_year_end DATE,
146: c_assignment_id pay_assignment_actions.assignment_id%type,
147: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
148: c_registered_employer NUMBER,
149: c_message OUT NOCOPY VARCHAR2) /* Bug#4863149 */
150: return number;
151:
151:
152:
153:
154: Function get_total_fbt(c_year_start DATE, --Bug#3213539
155: c_assignment_id pay_assignment_actions.assignment_id%type,
156: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
157: c_fbt_rate ff_globals_f.global_value%TYPE,
158: c_ml_rate ff_globals_f.global_value%TYPE,
159: p_termination VARCHAR2)
176: function Total_Lump_Sum_D_Payments -- Bug 3263659
177: return number ;
178:
179: function Total_Lump_Sum_E_Payments(c_year_end DATE,
180: c_assignment_id pay_assignment_actions.assignment_id%type,
181: c_registered_employer NUMBER) --2610141
182: return number ;
183:
184: function Total_Union_fees -- Bug 3263659
196: function Total_Invalidity_Payments -- Bug 3263659
197: return number ;
198:
199: function etp_details
200: (p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
201: ,p_year_start in pay_payroll_Actions.effective_date%type
202: ,p_year_end in pay_payroll_Actions.effective_date%type)
203: return number;
204:
230:
231: PROCEDURE populate_group_def_bal_ids (p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE);
232:
233: PROCEDURE get_group_values_bbr
234: ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
235: , p_date_earned IN date
236: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
237: , p_group_output_tab OUT NOCOPY bal_tab );
238:
232:
233: PROCEDURE get_group_values_bbr
234: ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
235: , p_date_earned IN date
236: , p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
237: , p_group_output_tab OUT NOCOPY bal_tab );
238:
239: PROCEDURE get_assgt_curr_term_values_bbr
240: ( p_year_start IN DATE
238:
239: PROCEDURE get_assgt_curr_term_values_bbr
240: ( p_year_start IN DATE
241: , p_year_end IN DATE
242: , p_assignment_id IN pay_assignment_actions.assignment_id%type
243: , p_fbt_rate IN ff_globals_f.global_value%TYPE
244: , p_ml_rate IN ff_globals_f.global_value%TYPE
245: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
246: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
241: , p_year_end IN DATE
242: , p_assignment_id IN pay_assignment_actions.assignment_id%type
243: , p_fbt_rate IN ff_globals_f.global_value%TYPE
244: , p_ml_rate IN ff_globals_f.global_value%TYPE
245: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
246: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
247: , p_emp_type IN varchar2
248: , p_term_output_tab OUT NOCOPY bal_tab
249: , p_message OUT NOCOPY VARCHAR2); /* Bug#4863149 */
296: -- internally calls private procedures to archive balances ,
297: -- employee details, employer details and supplier details .
298: --------------------------------------------------------------------
299: procedure archive_code
300: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
301: p_effective_date in date);
302:
303:
304: procedure spawn_ps_report