1 Package pay_fr_attestation_assedic AUTHID CURRENT_USER As
2 /* $Header: pyfraasd.pkh 115.3 2003/06/03 12:12:10 sspratur noship $ */
3
4 Type number_tab is Table Of Number Index by binary_integer;
5 g_service_id number_tab;
6 g_npil_payment_id Number;
7 g_legal_term_indemnity_id Number;
8 g_conventional_indemnity_id Number;
9 --Added the following global variables --Bug#2953410
10 g_contractual_indemnity_id Number;
11 g_transactional_indemnity_id Number;
12
13 Procedure set_defined_balance_ids(p_actual_hours_worked_id Out Nocopy Number ,
14 p_days_unpaid_id Out Nocopy Number ,
15 p_days_partially_paid_id Out Nocopy Number,
16 p_subject_to_unemployment_id Out Nocopy Number,
17 p_non_monthly_earnings_id Out Nocopy Number,
18 p_ee_unemployment_ta_id Out Nocopy Number,
19 p_ee_unemployment_tb_id Out Nocopy Number
20 );
21 Function get_last_fulltime_day_worked(p_person_id In Number ,
22 p_last_day_worked In Date) Return Date;
23
24 Function get_estab_head_count(p_establishment_id Number ,
25 p_actual_termination_date Date) Return Number;
26
27 Function get_pension_provider_info(p_assignment_id Number ,
28 p_establishment_id Number ,
29 p_termination_date Date,
30 p_type Varchar2) Return Varchar2 ;
31
32 Function pension_category(p_business_group_id Number ,
33 p_assignment_id Number,
34 p_actual_termination_date Date,
35 p_period_of_service_id Number) Return Varchar2 ;
36
37 --Changed the signature to accept two more parameters --Bug#2953410
38 --p_transactional_indemnity and p_contractual_indemnity
39
40 Procedure get_termination_indemnities(p_assignment_id In Number ,
41 p_last_day_worked In Date ,
42 p_actual_termination_date In Date ,
43 p_npil Out Nocopy Number ,
44 p_holiday_pay_amount Out Nocopy Number,
45 p_hoilday_pay_rate Out Nocopy Number ,
46 p_ft_contract_indemnity Out Nocopy Number,
47 p_legal_indemnity Out Nocopy Number,
48 p_conventional_indemnity Out Nocopy Number,
49 p_transactional_indemnity Out Nocopy Number,
50 p_contractual_indemnity Out Nocopy Number);
51
52 Procedure insert_date_run(p_effective_date varchar2);
53
54 End pay_fr_attestation_assedic;