1 package hrdpp_CREATE_VEHICLE as
2 /*
3 * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:46
4 * Generated for API: PQP_VEHICLE_REPOSITORY_API.CREATE_VEHICLE
5 */
6 --
7 g_generator_version constant varchar2(128) default '$Revision: 120.4 $';
8 --
9
10 function dc(p in date) return varchar2;
11 pragma restrict_references(dc,WNDS);
12
13 function d(p in varchar2) return date;
14 pragma restrict_references(d,WNDS);
15 function n(p in varchar2) return number;
16 pragma restrict_references(n,WNDS);
17 function dd(p in date,i in varchar2) return varchar2;
18 pragma restrict_references(dd,WNDS);
19 function nd(p in number,i in varchar2) return varchar2;
20 pragma restrict_references(nd,WNDS);
21 --
22 procedure insert_batch_lines
23 (p_batch_id in number
24 ,p_data_pump_batch_line_id in number default null
25 ,p_data_pump_business_grp_name in varchar2 default null
26 ,p_user_sequence in number default null
27 ,p_link_value in number default null
28 ,P_EFFECTIVE_DATE in date
29 ,P_REGISTRATION_NUMBER in varchar2 default null
30 ,P_VEHICLE_TYPE in varchar2
31 ,P_VEHICLE_ID_NUMBER in varchar2 default null
32 ,P_MAKE in varchar2
33 ,P_ENGINE_CAPACITY_IN_CC in number default null
34 ,P_FUEL_TYPE in varchar2 default null
35 ,P_CURRENCY_CODE in varchar2 default null
36 ,P_VEHICLE_STATUS in varchar2 default null
37 ,P_VEHICLE_INACTIVITY_REASON in varchar2 default null
38 ,P_MODEL in varchar2
39 ,P_INITIAL_REGISTRATION in date default null
40 ,P_LAST_REGISTRATION_RENEW_DATE in date default null
41 ,P_LIST_PRICE in number default null
42 ,P_ACCESSORY_VALUE_AT_STARTDATE in number default null
43 ,P_ACCESSORY_VALUE_ADDED_LATER in number default null
44 ,P_MARKET_VALUE_CLASSIC_CAR in number default null
45 ,P_FISCAL_RATINGS in number default null
46 ,P_FISCAL_RATINGS_UOM in varchar2 default null
47 ,P_VEHICLE_PROVIDER in varchar2 default null
48 ,P_VEHICLE_OWNERSHIP in varchar2 default null
49 ,P_SHARED_VEHICLE in varchar2 default null
50 ,P_ASSET_NUMBER in varchar2 default null
51 ,P_LEASE_CONTRACT_NUMBER in varchar2 default null
52 ,P_LEASE_CONTRACT_EXPIRY_DATE in date default null
53 ,P_TAXATION_METHOD in varchar2 default null
54 ,P_FLEET_INFO in varchar2 default null
55 ,P_FLEET_TRANSFER_DATE in date default null
56 ,P_COLOR in varchar2 default null
57 ,P_SEATING_CAPACITY in number default null
58 ,P_WEIGHT in number default null
59 ,P_WEIGHT_UOM in varchar2 default null
60 ,P_MODEL_YEAR in number default null
61 ,P_INSURANCE_NUMBER in varchar2 default null
62 ,P_INSURANCE_EXPIRY_DATE in date default null
63 ,P_COMMENTS in varchar2 default null
64 ,P_VRE_ATTRIBUTE_CATEGORY in varchar2 default null
65 ,P_VRE_ATTRIBUTE1 in varchar2 default null
66 ,P_VRE_ATTRIBUTE2 in varchar2 default null
67 ,P_VRE_ATTRIBUTE3 in varchar2 default null
68 ,P_VRE_ATTRIBUTE4 in varchar2 default null
69 ,P_VRE_ATTRIBUTE5 in varchar2 default null
70 ,P_VRE_ATTRIBUTE6 in varchar2 default null
71 ,P_VRE_ATTRIBUTE7 in varchar2 default null
72 ,P_VRE_ATTRIBUTE8 in varchar2 default null
73 ,P_VRE_ATTRIBUTE9 in varchar2 default null
74 ,P_VRE_ATTRIBUTE10 in varchar2 default null
75 ,P_VRE_ATTRIBUTE11 in varchar2 default null
76 ,P_VRE_ATTRIBUTE12 in varchar2 default null
77 ,P_VRE_ATTRIBUTE13 in varchar2 default null
78 ,P_VRE_ATTRIBUTE14 in varchar2 default null
79 ,P_VRE_ATTRIBUTE15 in varchar2 default null
80 ,P_VRE_ATTRIBUTE16 in varchar2 default null
81 ,P_VRE_ATTRIBUTE17 in varchar2 default null
82 ,P_VRE_ATTRIBUTE18 in varchar2 default null
83 ,P_VRE_ATTRIBUTE19 in varchar2 default null
84 ,P_VRE_ATTRIBUTE20 in varchar2 default null
85 ,P_VRE_INFORMATION_CATEGORY in varchar2 default null
86 ,P_VRE_INFORMATION1 in varchar2 default null
87 ,P_VRE_INFORMATION2 in varchar2 default null
88 ,P_VRE_INFORMATION3 in varchar2 default null
89 ,P_VRE_INFORMATION4 in varchar2 default null
90 ,P_VRE_INFORMATION5 in varchar2 default null
91 ,P_VRE_INFORMATION6 in varchar2 default null
92 ,P_VRE_INFORMATION7 in varchar2 default null
93 ,P_VRE_INFORMATION8 in varchar2 default null
94 ,P_VRE_INFORMATION9 in varchar2 default null
95 ,P_VRE_INFORMATION10 in varchar2 default null
96 ,P_VRE_INFORMATION11 in varchar2 default null
97 ,P_VRE_INFORMATION12 in varchar2 default null
98 ,P_VRE_INFORMATION13 in varchar2 default null
99 ,P_VRE_INFORMATION14 in varchar2 default null
100 ,P_VRE_INFORMATION15 in varchar2 default null
101 ,P_VRE_INFORMATION16 in varchar2 default null
102 ,P_VRE_INFORMATION17 in varchar2 default null
103 ,P_VRE_INFORMATION18 in varchar2 default null
104 ,P_VRE_INFORMATION19 in varchar2 default null
105 ,P_VRE_INFORMATION20 in varchar2 default null);
106 --
107 procedure call
108 (p_business_group_id in number,
109 p_batch_line_id in number);
110 end hrdpp_CREATE_VEHICLE;
[Home] [Help]