1 PACKAGE pqp_ss_vehicle_mileage_claims AS
2 /* $Header: pqpssvehmlgclm.pkh 120.2 2005/09/29 05:18:47 rrazdan noship $ */
3 /*
4 Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5 --
6 --
7
8 --
9 */
10 --
11 --
12 TYPE ref_cursor IS REF CURSOR;
13 TYPE r_user_info IS RECORD (person_id per_all_people_f.person_id%TYPE
14 ,assignment_id per_all_assignments_f.assignment_id%TYPE
15 ,user_type VARCHAR2(10)) ;
16
17
18 procedure get_transaction_id
19 (p_transaction_step_id in number
20 ,p_transaction out nocopy number);
21 --
22 --
23 --
24
25 PROCEDURE delete_validate_mileage_claim (
26 p_effective_date IN DATE
27 ,p_assignment_id IN NUMBER
28 ,p_mileage_claim_element IN NUMBER
29 ,p_element_entry_id IN OUT NOCOPY NUMBER
30 ,p_element_entry_date IN OUT NOCOPY DATE
31 ,p_error_status OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE get_dml_status (
35 itemtype IN VARCHAR2,
36 itemkey IN VARCHAR2,
37 actid IN NUMBER,
38 funcmode IN VARCHAR2,
39 result OUT NOCOPY VARCHAR2 );
40
41 PROCEDURE delete_vehicle_mileage_claim(
42 x_effective_date IN DATE
43 ,x_login_person_id IN NUMBER
44 ,x_person_id IN NUMBER
45 ,x_assignment_id IN NUMBER
46 ,x_business_group_id IN NUMBER
47 ,x_item_key IN NUMBER
48 ,x_item_type IN VARCHAR2
49 ,x_element_entry_id IN NUMBER
50 ,p_status IN VARCHAR2
51 ,x_transaction_id IN OUT NOCOPY NUMBER
52 ,x_transaction_step_id IN OUT NOCOPY NUMBER
53 ,x_confirmation_number OUT NOCOPY NUMBER
54 ,x_error_status OUT NOCOPY VARCHAR2
55 );
56 PROCEDURE update_transaction_itemkey (
57 itemtype IN VARCHAR2,
58 itemkey IN VARCHAR2,
59 actid IN NUMBER,
60 funcmode IN VARCHAR2,
61 result OUT NOCOPY VARCHAR2 );
62
63
64 FUNCTION get_vehicle_mileage_claim (
65 p_transaction_step_id in varchar2 ) RETURN ref_cursor;
66 --
67 --
68 --
69 --
70 PROCEDURE create_vehicle_mileage_claims
71 (
72 p_effective_date IN DATE,
73 p_web_adi_identifier IN VARCHAR2 ,
74 p_info_id IN VARCHAR2 ,
75 p_time_stamp IN VARCHAR2 ,
76 p_assignment_id IN NUMBER,
77 p_business_group_id IN NUMBER,
78 p_ownership IN VARCHAR2 ,
79 p_usage_type IN VARCHAR2 ,
80 p_vehicle_type IN VARCHAR2,
81 p_start_date IN VARCHAR2 ,
82 p_end_date IN VARCHAR2 ,
83 p_claimed_mileage IN VARCHAR2 ,
84 p_actual_mileage IN VARCHAR2 default null,
85 p_claimed_mileage_o IN VARCHAR2 default null,
86 p_actual_mileage_o IN VARCHAR2 default null,
87 p_registration_number IN VARCHAR2 default null,
88 p_engine_capacity IN VARCHAR2 default null,
89 p_fuel_type IN VARCHAR2 default null,
90 p_fiscal_ratings IN VARCHAR2 default null,
91 p_no_of_passengers IN VARCHAR2 default null,
92 p_purpose IN VARCHAR2 default null,
93 p_user_type IN VARCHAR2 default 'SS',
94 p_mileage_claim_element IN OUT NOCOPY NUMBER ,
95 p_element_entry_id IN OUT NOCOPY NUMBER ,
96 p_element_entry_date IN OUT NOCOPY DATE,
97 p_mode OUT NOCOPY VARCHAR2,
98 p_return_status OUT NOCOPY VARCHAR2
99
100 );
101 PROCEDURE delete_process_api (
102 p_validate IN BOOLEAN DEFAULT FALSE,
103 p_transaction_step_id IN NUMBER );
104
105 PROCEDURE process_api
106 (p_validate in boolean default false
107 ,p_transaction_step_id in number default null
108 ,p_effective_date in varchar2 default null
109 ) ;
110
111 /*PROCEDURE process_api (
112 p_validate IN BOOLEAN DEFAULT FALSE,
113 p_transaction_step_id IN NUMBER ); */
114 --
115 --
116
117 PROCEDURE set_vehicle_mileage_claim (
118 x_p_validate in boolean
119 ,x_effective_date in date
120 ,x_login_person_id in number
121 ,x_person_id in number
122 ,x_assignment_id in number
123 ,x_item_type in varchar2
124 ,x_item_key in number
125 ,x_activity_id in number
126 ,x_business_group_id IN NUMBER
127 ,x_legislation_code IN VARCHAR2
128 ,x_ownership IN VARCHAR2
129 ,x_usage_type IN VARCHAR2
130 ,x_vehicle_type IN VARCHAR2
131 ,x_start_date IN DATE
132 ,x_end_date IN DATE
133 ,x_claimed_mileage IN VARCHAR2
134 ,x_actual_mileage IN VARCHAR2 default null
135 ,x_claimed_mileage_o IN VARCHAR2 default null
136 ,x_actual_mileage_o IN VARCHAR2 default null
137 ,x_registration_number IN VARCHAR2 default null
138 ,x_engine_capacity IN VARCHAR2 default null
139 ,x_fuel_type IN VARCHAR2 default null
140 ,x_fiscal_ratings IN VARCHAR2 default null
141 ,x_no_of_passengers IN VARCHAR2 default null
142 ,x_purpose IN VARCHAR2 default null
143 ,x_element_entry_id IN NUMBER default NULL
144 ,x_status IN VARCHAR2 DEFAULT NULL
145 ,x_effective_date_option IN VARCHAR2 DEFAULT NULL
146 ,x_return_status OUT NOCOPY VARCHAR2
147 ,x_object_version_number IN NUMBER
148 ,x_error_status OUT NOCOPY varchar2
149 ,x_transaction_id in out nocopy NUMBER
150 ,x_transaction_step_id in out nocopy NUMBER
151 ,x_confirmation_number OUT NOCOPY NUMBER
152 );
153 PROCEDURE rollback_transaction (
154 itemType IN VARCHAR2,
155 itemKey IN VARCHAR2,
156 result OUT NOCOPY VARCHAR2) ;
157 --
158 --
159 PROCEDURE self_or_subordinate (
160 itemtype IN VARCHAR2,
161 itemkey IN VARCHAR2,
162 actid IN NUMBER,
163 funcmode IN VARCHAR2,
164 resultout IN OUT NOCOPY VARCHAR2);
165 --
166 --
167 END pqp_ss_vehicle_mileage_claims;