1 PACKAGE pqp_mileage_claim_pkg AS
2 /* $Header: pqmlgclm.pkh 120.0 2005/05/29 01:53:08 appldev noship $ */
3
4 PROCEDURE pqp_insert_mileage_claim
5 ( p_effective_date IN DATE,
6 p_web_adi_identifier IN VARCHAR2 ,
7 p_info_id IN VARCHAR2 ,
8 p_time_stamp IN VARCHAR2 ,
9 p_assignment_id IN NUMBER,
10 p_business_group_id IN NUMBER,
11 p_legislation_code IN VARCHAR2,
12 p_ownership IN VARCHAR2 ,
13 p_usage_type IN VARCHAR2 ,
14 p_vehicle_type IN VARCHAR2,
15 p_start_date IN DATE ,
16 p_end_date IN DATE ,
17 p_claimed_mileage IN VARCHAR2 ,
18 p_actual_mileage IN VARCHAR2 default null,
19 p_registration_number IN VARCHAR2 default null,
20 p_engine_capacity IN VARCHAR2 default null,
21 p_fuel_type IN VARCHAR2 default null,
22 p_calculation_method IN VARCHAR2 default null,
23 p_user_rates_table IN VARCHAR2 default null,
24 p_fiscal_ratings IN VARCHAR2 default null,
25 p_PAYE_taxable IN VARCHAR2 default null,
26 p_no_of_passengers IN VARCHAR2 default null,
27 p_data_source IN VARCHAR2 default 'I',
28 p_mileage_claim_element IN OUT NOCOPY NUMBER ,
29 p_element_entry_id IN OUT NOCOPY NUMBER ,
30 p_element_entry_date IN OUT NOCOPY DATE,
31 p_return_status OUT NOCOPY VARCHAR2,
32 p_purpose IN VARCHAR2 default null,
33 p_user_type IN VARCHAR2 default 'PUI'
34 );
35
36
37
38 PROCEDURE pqp_update_mileage_claim
39 ( p_effective_date IN DATE,
40 p_assignment_id IN number,
41 p_business_group_id IN NUMBER,
42 p_legislation_code IN VARCHAR2,
43 p_ownership IN VARCHAR2 DEFAULT NULL,
44 p_usage_type IN VARCHAR2 DEFAULT NULL,
45 p_vehicle_type IN VARCHAR2,
46 p_start_date_o IN DATE DEFAULT NULL,
47 p_start_date IN DATE DEFAULT NULL,
48 p_end_date_o IN DATE DEFAULT NULL,
49 p_end_date IN DATE DEFAULT NULL,
50 p_claimed_mileage_o IN VARCHAR2 DEFAULT NULL,
51 p_claimed_mileage IN VARCHAR2 DEFAULT NULL,
52 p_actual_mileage_o IN VARCHAR2 DEFAULT NULL,
53 p_actual_mileage IN VARCHAR2 DEFAULT NULL,
54 p_registration_number IN VARCHAR2 DEFAULT NULL,
55 p_engine_capacity IN VARCHAR2 DEFAULT NULL,
56 p_fuel_type IN VARCHAR2 DEFAULT NULL,
57 p_calculation_method IN VARCHAR2 DEFAULT NULL,
58 p_user_rates_table IN VARCHAR2 DEFAULT NULL,
59 p_fiscal_ratings_o IN VARCHAR2 DEFAULT NULL,
60 p_fiscal_ratings IN VARCHAR2 DEFAULT NULL,
61 p_PAYE_taxable IN VARCHAR2 DEFAULT NULL,
62 p_no_of_passengers_o IN VARCHAR2 DEFAULT NULL,
63 p_no_of_passengers IN VARCHAR2 DEFAULT NULL,
64 p_purpose IN VARCHAR2 default null,
65 p_data_source IN VARCHAR2 DEFAULT 'I',
66 p_mileage_claim_element IN OUT NOCOPY NUMBER ,
67 p_element_entry_id IN OUT NOCOPY NUMBER ,
68 p_element_entry_date IN OUT NOCOPY DATE,
69 p_return_status OUT NOCOPY VARCHAR2
70 );
71
72
73
74 PROCEDURE pqp_delete_mileage_claim
75 ( p_effective_date IN DATE,
76 p_assignment_id IN NUMBER,
77 p_mileage_claim_element IN OUT NOCOPY NUMBER ,
78 p_element_entry_id IN OUT NOCOPY NUMBER ,
79 p_element_entry_date IN OUT NOCOPY DATE,
80 p_return_status OUT NOCOPY VARCHAR2
81 ) ;
82
83
84 ---Called from JDEV
85
86
87 -- Function get_code returns the code of the meaning passed
88 --
89 -- The Code depends on the value of the p_option parameter
90 -- p_option = 'R' -> p_field has the rates table
91 --name and it Returns the Rates table id
92 --
93 FUNCTION get_code
94 (p_option IN VARCHAR2
95 ,p_field IN VARCHAR2
96 )
97 RETURN VARCHAR2;
98
99 --
100 -- Function get_meaning returns the meaning string of the id passed
101 --
102 -- The Meaning depends on the value of the p_option parameter
103 -- p_option = 'R' -> p_field_id has the rates table id and it Returns the Rates table Name
104 -- p_option = 'E' -> p_field_id has the element type id and it Returns the Element Name
105 --
106 FUNCTION get_meaning
107 (p_option IN VARCHAR2
108 ,p_field_id IN NUMBER
109 )
110 RETURN VARCHAR2;
111
112
113 ---------
114
115 END;