1 PACKAGE PQP_PL_VEHICLE_ALLOCATIONS AS
2 /* $Header: pqplvalp.pkh 120.0.12000000.1 2007/01/16 04:23:52 appldev noship $ */
3
4
5 PROCEDURE CREATE_PL_VEHICLE_ALLOCATION(p_assignment_id in NUMBER
6 ,p_effective_date in DATE
7 ,p_business_group_id in NUMBER
8 ,p_vehicle_repository_id in NUMBER
9 ,p_val_information_category in varchar2
10 ,p_val_information1 in varchar2
11 ,p_val_information2 in varchar2
12 ,p_val_information3 in varchar2
13 ,p_val_information4 in varchar2
14 ,p_val_information5 in varchar2
15 ,p_val_information6 in varchar2
16 ,p_val_information7 in varchar2
17 ,p_val_information8 in varchar2
18 ,p_val_information9 in varchar2
19 ,p_val_information10 in varchar2
20 ,p_val_information11 in varchar2
21 ,p_val_information12 in varchar2
22 ,p_val_information13 in varchar2
23 ,p_val_information14 in varchar2
24 ,p_val_information15 in varchar2
25 ,p_val_information16 in varchar2
26 ,p_val_information17 in varchar2
27 ,p_val_information18 in varchar2
28 ,p_val_information19 in varchar2
29 ,p_val_information20 in varchar2);
30
31 PROCEDURE UPDATE_PL_VEHICLE_ALLOCATION(p_effective_date in DATE
32 ,p_vehicle_allocation_id in NUMBER
33 ,p_assignment_id in NUMBER
34 ,p_business_group_id in NUMBER
35 ,p_vehicle_repository_id in NUMBER
36 ,p_val_information_category in varchar2
37 ,p_val_information1 in varchar2
38 ,p_val_information2 in varchar2
39 ,p_val_information3 in varchar2
40 ,p_val_information4 in varchar2
41 ,p_val_information5 in varchar2
42 ,p_val_information6 in varchar2
43 ,p_val_information7 in varchar2
44 ,p_val_information8 in varchar2
45 ,p_val_information9 in varchar2
46 ,p_val_information10 in varchar2
47 ,p_val_information11 in varchar2
48 ,p_val_information12 in varchar2
49 ,p_val_information13 in varchar2
50 ,p_val_information14 in varchar2
51 ,p_val_information15 in varchar2
52 ,p_val_information16 in varchar2
53 ,p_val_information17 in varchar2
54 ,p_val_information18 in varchar2
55 ,p_val_information19 in varchar2
56 ,p_val_information20 in varchar2);
57
58 PROCEDURE DELETE_PL_VEHICLE_ALLOCATION(P_VALIDATE in BOOLEAN
59 ,P_EFFECTIVE_DATE in DATE
60 ,P_DATETRACK_MODE in VARCHAR2
61 ,P_VEHICLE_ALLOCATION_ID in NUMBER
62 ,P_OBJECT_VERSION_NUMBER in NUMBER);
63
64 END PQP_PL_VEHICLE_ALLOCATIONS;
[Home] [Help]