[Home] [Help]
PACKAGE: APPS.PQP_VEH_MULTI_ALLOC
Source
1 Package PQP_VEH_MULTI_ALLOC as
2 /* $Header: pqvalmul.pkh 120.0 2005/05/29 02:17:18 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------< CREATE_VEHICLE_MULTIPLE_ALLOCATION >---------------|
6 -- ----------------------------------------------------------------------------
7 procedure create_veh_multi_alloc
8 (p_validate in boolean default false
9 ,p_effective_date in date
10 ,p_assignment_id in number
11 ,p_business_group_id in number
12 ,p_vehicle_repository_id in number
13 ,p_across_assignments in varchar2 default null
14 ,p_usage_type in varchar2 default null
15 ,p_capital_contribution in number default null
16 ,p_private_contribution in number default null
17 ,p_default_vehicle in varchar2 default null
18 ,p_fuel_card in varchar2 default null
19 ,p_fuel_card_number in varchar2 default null
20 ,p_calculation_method in varchar2 default null
21 ,p_rates_table_id in number default null
22 ,p_element_type_id in number default null
23 ,p_private_use_flag in varchar2 default null
24 ,p_insurance_number in varchar2 default null
25 ,p_insurance_expiry_date in date default null
26 ,p_val_attribute_category in varchar2 default null
27 ,p_val_attribute1 in varchar2 default null
28 ,p_val_attribute2 in varchar2 default null
29 ,p_val_attribute3 in varchar2 default null
30 ,p_val_attribute4 in varchar2 default null
31 ,p_val_attribute5 in varchar2 default null
32 ,p_val_attribute6 in varchar2 default null
33 ,p_val_attribute7 in varchar2 default null
34 ,p_val_attribute8 in varchar2 default null
35 ,p_val_attribute9 in varchar2 default null
36 ,p_val_attribute10 in varchar2 default null
37 ,p_val_attribute11 in varchar2 default null
38 ,p_val_attribute12 in varchar2 default null
39 ,p_val_attribute13 in varchar2 default null
40 ,p_val_attribute14 in varchar2 default null
41 ,p_val_attribute15 in varchar2 default null
42 ,p_val_attribute16 in varchar2 default null
43 ,p_val_attribute17 in varchar2 default null
44 ,p_val_attribute18 in varchar2 default null
45 ,p_val_attribute19 in varchar2 default null
46 ,p_val_attribute20 in varchar2 default null
47 ,p_val_information_category in varchar2 default null
48 ,p_val_information1 in varchar2 default null
49 ,p_val_information2 in varchar2 default null
50 ,p_val_information3 in varchar2 default null
51 ,p_val_information4 in varchar2 default null
52 ,p_val_information5 in varchar2 default null
53 ,p_val_information6 in varchar2 default null
54 ,p_val_information7 in varchar2 default null
55 ,p_val_information8 in varchar2 default null
56 ,p_val_information9 in varchar2 default null
57 ,p_val_information10 in varchar2 default null
58 ,p_val_information11 in varchar2 default null
59 ,p_val_information12 in varchar2 default null
60 ,p_val_information13 in varchar2 default null
61 ,p_val_information14 in varchar2 default null
62 ,p_val_information15 in varchar2 default null
63 ,p_val_information16 in varchar2 default null
64 ,p_val_information17 in varchar2 default null
65 ,p_val_information18 in varchar2 default null
66 ,p_val_information19 in varchar2 default null
67 ,p_val_information20 in varchar2 default null
68 ,p_fuel_benefit in varchar2 default null
69 ,p_sliding_rates_info in varchar2 default null
70 );
71
72
73 --
74 --
75 -- ----------------------------------------------------------------------------
76 -- |------------------< UPDATE_VEHICLE_MULTIPLE_ALLOCATION >------------------|
77 -- ----------------------------------------------------------------------------
78
79
80
81 procedure update_veh_multi_alloc
82 (p_validate in boolean default false
83 ,p_effective_date in date
84 ,p_datetrack_mode in varchar2
85 ,p_vehicle_allocation_id in number
86 ,p_object_version_number in out nocopy number
87 ,p_assignment_id in number default hr_api.g_number
88 ,p_business_group_id in number default hr_api.g_number
89 ,p_vehicle_repository_id in number default hr_api.g_number
90 ,p_across_assignments in varchar2 default hr_api.g_varchar2
91 ,p_usage_type in varchar2 default hr_api.g_varchar2
92 ,p_capital_contribution in number default hr_api.g_number
93 ,p_private_contribution in number default hr_api.g_number
94 ,p_default_vehicle in varchar2 default hr_api.g_varchar2
95 ,p_fuel_card in varchar2 default hr_api.g_varchar2
96 ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
97 ,p_calculation_method in varchar2 default hr_api.g_varchar2
98 ,p_rates_table_id in number default hr_api.g_number
99 ,p_element_type_id in number default hr_api.g_number
100 ,p_private_use_flag in varchar2 default hr_api.g_varchar2
101 ,p_insurance_number in varchar2 default hr_api.g_varchar2
102 ,p_insurance_expiry_date in date default hr_api.g_date
103 ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
104 ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
105 ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
106 ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
107 ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
108 ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
109 ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
110 ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
111 ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
112 ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
113 ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
114 ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
115 ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
116 ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
117 ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
118 ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
119 ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
120 ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
121 ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
122 ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
123 ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
124 ,p_val_information_category in varchar2 default hr_api.g_varchar2
125 ,p_val_information1 in varchar2 default hr_api.g_varchar2
126 ,p_val_information2 in varchar2 default hr_api.g_varchar2
127 ,p_val_information3 in varchar2 default hr_api.g_varchar2
128 ,p_val_information4 in varchar2 default hr_api.g_varchar2
129 ,p_val_information5 in varchar2 default hr_api.g_varchar2
130 ,p_val_information6 in varchar2 default hr_api.g_varchar2
131 ,p_val_information7 in varchar2 default hr_api.g_varchar2
132 ,p_val_information8 in varchar2 default hr_api.g_varchar2
133 ,p_val_information9 in varchar2 default hr_api.g_varchar2
134 ,p_val_information10 in varchar2 default hr_api.g_varchar2
135 ,p_val_information11 in varchar2 default hr_api.g_varchar2
136 ,p_val_information12 in varchar2 default hr_api.g_varchar2
137 ,p_val_information13 in varchar2 default hr_api.g_varchar2
138 ,p_val_information14 in varchar2 default hr_api.g_varchar2
139 ,p_val_information15 in varchar2 default hr_api.g_varchar2
140 ,p_val_information16 in varchar2 default hr_api.g_varchar2
141 ,p_val_information17 in varchar2 default hr_api.g_varchar2
142 ,p_val_information18 in varchar2 default hr_api.g_varchar2
143 ,p_val_information19 in varchar2 default hr_api.g_varchar2
144 ,p_val_information20 in varchar2 default hr_api.g_varchar2
145 ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
146 ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
147 );
148
149
150
151 -- ----------------------------------------------------------------------------
152 -- |------------------< DELETE_VEHICLE_MULTIPLE_ALLOCATION >------------------|
153 -- ----------------------------------------------------------------------------
154 procedure delete_veh_multi_alloc
155 (p_validate in boolean default false
156 ,p_effective_date in date
157 ,p_datetrack_mode in varchar2
158 ,p_vehicle_allocation_id in number
159 );
160
161 end PQP_VEH_MULTI_ALLOC;