PACKAGE: APPS.PAY_IE_BIK

Source

1 PACKAGE pay_ie_bik AUTHID CURRENT_USER AS
2 /* $Header: pyiebik.pkh 120.1 2009/03/20 05:59:04 knadhan ship $ */
3 
4 FUNCTION get_global_value(p_name in VARCHAR2,
5                           p_effective_date in DATE)
6 return number;
7 
8 FUNCTION get_max_start_date(p_payroll_action_id IN number,
9                             p_max_start_date in DATE,
10                             p_benefit_start_date IN DATE)
11 return date;
12 
13 FUNCTION get_max_no_of_periods(p_payroll_action_id  in number,
14                                p_maximum_start_date in DATE,
15                                p_minimum_end_date in DATE,
16                                p_formula_context in varchar2)
17 return number;
18 
19 FUNCTION get_least_date(p_payroll_action_id  in number,
20                         c_end_date in date)
21 return date;
22 
23 
24 FUNCTION get_balance_values(p_assignment_action_id number,
25                             p_source_id number,
26                             p_date_earned date,
27                             p_balance_name varchar2)
28 return number ;
29 
30 FUNCTION get_address(l_address_type varchar2,
31                      l_address_id varchar2)
32 return varchar2;
33 
34 FUNCTION get_landlord_address(l_address_type varchar2,
35                               l_address_id varchar2)
36 return varchar2 ;
37 /*ADDED 3 new functions for Bug No. 3745749*/
38 FUNCTION GET_INV_UNA_DAYS(p_element_entry_id in number,
39                           p_vehicle_alloc_end_date in DATE,
40 			  p_curr_period_end_date in DATE) return number;
41 FUNCTION GET_INV_TOT_MLGE(p_element_entry_id in number,
42                           p_vehicle_alloc_end_date in DATE,
43 			  p_curr_period_end_date in DATE) return number;
44 FUNCTION GET_INV_BUS_MLGE(p_element_entry_id in number,
45                           p_vehicle_alloc_end_date in DATE,
46 			  p_curr_period_end_date in DATE) return number;
47 
48 /*ADDED for 2009 BIK Vehicle based on Emission 8236523 */
49 FUNCTION get_fiscal_rating(p_allocation_id in number)
50                         return number;
51 
52 end pay_ie_bik;