PACKAGE: APPS.PAY_GB_P11D_CAR_EXTRACT

Source

1 PACKAGE pay_gb_p11d_car_extract AUTHID CURRENT_USER AS
2 /* $Header: pygb11ce.pkh 120.0.12010000.1 2008/07/27 22:42:56 appldev ship $ */
3 
4 FUNCTION get_prim_asg_start_date(p_assignment_id IN NUMBER) RETURN VARCHAR2;
5 
6 FUNCTION get_prim_asg_end_date(p_assignment_id IN NUMBER) RETURN VARCHAR2;
7 
8 FUNCTION get_prim_ben_start_date(p_assignment_id IN NUMBER) RETURN VARCHAR2;
9 
10 FUNCTION prim_ben_start_date(p_assignment_id IN NUMBER) RETURN VARCHAR2;
11 
12 FUNCTION get_prim_ben_end_date(p_assignment_id IN NUMBER) RETURN VARCHAR2;
13 
14 FUNCTION prim_ben_end_date(p_assignment_id IN NUMBER) RETURN VARCHAR2;
15 
16 FUNCTION get_prim_vin(p_assignment_id IN NUMBER) RETURN VARCHAR2;
17 
18 FUNCTION prim_vin(p_assignment_id IN NUMBER) RETURN VARCHAR2;
19 
20 FUNCTION get_prim_make(p_assignment_id IN NUMBER) RETURN VARCHAR2;
21 
22 FUNCTION prim_make(p_assignment_id IN NUMBER) RETURN VARCHAR2;
23 
24 FUNCTION get_prim_model(p_assignment_id IN NUMBER) RETURN VARCHAR2;
25 
26 FUNCTION prim_model(p_assignment_id IN NUMBER) RETURN VARCHAR2;
27 
28 FUNCTION get_prim_dfr(p_assignment_id IN NUMBER) RETURN VARCHAR2;
29 
30 FUNCTION prim_dfr(p_assignment_id IN NUMBER) RETURN VARCHAR2;
31 
32 FUNCTION get_prim_price(p_assignment_id IN NUMBER) RETURN VARCHAR2;
33 
34 FUNCTION prim_price(p_assignment_id IN NUMBER) RETURN VARCHAR2;
35 
36 FUNCTION get_prim_fuel_type(p_assignment_id IN NUMBER) RETURN VARCHAR2;
37 
38 FUNCTION prim_fuel_type(p_assignment_id IN NUMBER) RETURN VARCHAR2;
39 
40 FUNCTION get_prim_co2_emi(p_assignment_id IN NUMBER) RETURN VARCHAR2;
41 
42 FUNCTION prim_co2_emi(p_assignment_id IN NUMBER) RETURN VARCHAR2;
43 
44 FUNCTION get_prim_optional_acc(p_assignment_id IN NUMBER) RETURN VARCHAR2;
45 
46 FUNCTION prim_optional_acc(p_assignment_id IN NUMBER) RETURN VARCHAR2;
47 
48 FUNCTION get_prim_acc_added_after(p_assignment_id IN NUMBER) RETURN VARCHAR2;
49 
50 FUNCTION get_prim_capital_contrib(p_assignment_id IN NUMBER) RETURN VARCHAR2;
51 
52 FUNCTION prim_capital_contrib(p_assignment_id IN NUMBER) RETURN VARCHAR2;
53 
54 FUNCTION get_prim_private_contrib(p_assignment_id IN NUMBER) RETURN VARCHAR2;
55 
56 FUNCTION prim_private_contrib(p_assignment_id IN NUMBER) RETURN VARCHAR2;
57 
58 FUNCTION get_prim_engine_capacity(p_assignment_id IN NUMBER) RETURN VARCHAR2;
59 
60 FUNCTION prim_engine_capacity(p_assignment_id IN NUMBER) RETURN VARCHAR2;
61 
62 FUNCTION get_prim_fuel_benefit(p_assignment_id IN NUMBER) RETURN VARCHAR2;
63 
64 FUNCTION prim_fuel_benefit(p_assignment_id IN NUMBER) RETURN VARCHAR2;
65 
66 FUNCTION get_prim_vehicle_details_id(p_assignment_id IN NUMBER) RETURN VARCHAR2;
67 
68 FUNCTION prim_fuel_reinstated(p_assignment_id IN NUMBER) RETURN VARCHAR2;
69 
70 FUNCTION prim_free_fuel_withdrawn(p_assignment_id IN NUMBER) RETURN VARCHAR2;
71 
72 FUNCTION prim_additional_fuel_days(p_assignment_id IN NUMBER) RETURN VARCHAR2;
73 
74 FUNCTION check_person_inclusion(p_assignment_id IN NUMBER) RETURN VARCHAR2;
75 
76 FUNCTION post_process_rule(p_ext_rslt_id IN NUMBER) RETURN VARCHAR2;
77 
78 FUNCTION post_process_rule_04(p_ext_rslt_id IN NUMBER) RETURN VARCHAR2;
79 
80 
81 END pay_gb_p11d_car_extract;