1 PACKAGE pay_gb_p11d_car_extract 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;