1 package pay_sg_cpfline_balances as
2 /* $Header: pysgcpfb.pkh 120.0.12000000.1 2007/01/18 01:29:22 appldev noship $ */
3 ------------------------------------------------------
4 -- Global Variables used in function get_balance_value
5 ------------------------------------------------------
6 global_exist_emp boolean := true;
7 global_bal_count number := 0 ;
8 ------------------------------------------------------
9 -- Record Used in function get_balance_value
10 -- Bug No:3298317 Added column permit_type
11 -- Bug No:4226037 Added column termination_date
12 ------------------------------------------------------
13 type dup_employee_store_rec is record
14 ( cpf_acc_number varchar2(150),
15 legal_name varchar2(150),
16 employee_number varchar2(30),
17 permit_type per_people_f.per_information6%type,
18 department varchar2(200),
19 assignment_id per_all_assignments_f.assignment_id%type,
20 assignment_action_id pay_assignment_actions.assignment_action_id%type,
21 tax_unit_id pay_assignment_actions.tax_unit_id%type,
22 effective_date pay_payroll_actions.effective_date%type,
23 cl_record_status varchar2(1),
24 mf_record_status varchar2(1),
25 termination_date pay_action_information.action_information19%type
26 );
27 --
28 type dup_employee_store_tab is table of dup_employee_store_rec index by binary_integer;
29 t_dup_emp_rec dup_employee_store_tab;
30 ------------------------------------------------------------
31 -- This function is called from company_identification cursor
32 ------------------------------------------------------------
33 function stat_type_amount
34 ( p_payroll_action_id in number,
35 p_stat_type in varchar2 )
36 return number ;
37 ------------------------------------------------------------
38 -- This function is called from company_identification cursor
39 ------------------------------------------------------------
40 function balance_amount
41 ( p_payroll_action_id in number,
42 p_balance_name in varchar2 )
43 return number ;
44 ------------------------------------------------------------
45 -- This function is called from company_identification cursor
46 ------------------------------------------------------------
47 function stat_type_count
48 ( p_payroll_action_id in number,
49 p_stat_type in varchar2 )
50 return number;
51 --------------------------------------------------------------------------
52 -- This function is called from existing_employee and new_employee cursors
53 --------------------------------------------------------------------------
54 function get_balance_value
55 ( p_employee_type in varchar2,
56 p_assignment_id in per_all_assignments_f.assignment_id%type,
57 p_cpf_acc_number in varchar2,
58 p_department in varchar2,
59 p_assignment_action_id in varchar2,
60 p_tax_unit_id in varchar2,
61 p_balance_name in varchar2,
62 p_balance_value in varchar2,
63 p_payroll_action_id in number ,
64 p_permit_type in per_people_f.per_information6%type )
65 return varchar2 ;
66 --------------------------------------------------------------------------
67 --Bug# 3501950
68 -- This function is called from company_identification cursor
69 --------------------------------------------------------------------------
70 function get_cpf_interest
71 (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
72 return varchar2;
73 --------------------------------------------------------------------------
74 --Bug# 3501950
75 -- This function is called from company_identification cursor
76 --------------------------------------------------------------------------
77 function get_fwl_interest
78 (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
79 return varchar2;
80 end pay_sg_cpfline_balances;