1 package PN_VAR_ABAT_DEFAULTS_PKG AUTHID CURRENT_USER as
2 /* $Header: PNVRABDS.pls 120.0 2007/10/03 14:27:30 rthumma noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2
6 ,X_ABATEMENT_ID in out NOCOPY NUMBER
7 ,X_VAR_RENT_ID in NUMBER
8 ,X_START_DATE in DATE
9 ,X_END_DATE in DATE
10 ,X_TYPE_CODE in VARCHAR2
11 ,X_AMOUNT in NUMBER
12 ,X_DESCRIPTION in VARCHAR2
13 ,X_LAST_UPDATE_DATE in DATE
14 ,X_LAST_UPDATED_BY in NUMBER
15 ,X_CREATION_DATE in DATE
16 ,X_CREATED_BY in NUMBER
17 ,X_LAST_UPDATE_LOGIN in NUMBER
18 ,X_COMMENTS in VARCHAR2
19 ,X_ATTRIBUTE_CATEGORY in VARCHAR2
20 ,X_ATTRIBUTE1 in VARCHAR2
21 ,X_ATTRIBUTE2 in VARCHAR2
22 ,X_ATTRIBUTE3 in VARCHAR2
23 ,X_ATTRIBUTE4 in VARCHAR2
24 ,X_ATTRIBUTE5 in VARCHAR2
25 ,X_ATTRIBUTE6 in VARCHAR2
26 ,X_ATTRIBUTE7 in VARCHAR2
27 ,X_ATTRIBUTE8 in VARCHAR2
28 ,X_ATTRIBUTE9 in VARCHAR2
29 ,X_ATTRIBUTE10 in VARCHAR2
30 ,X_ATTRIBUTE11 in VARCHAR2
31 ,X_ATTRIBUTE12 in VARCHAR2
32 ,X_ATTRIBUTE13 in VARCHAR2
33 ,X_ATTRIBUTE14 in VARCHAR2
34 ,X_ATTRIBUTE15 in VARCHAR2
35 ,X_ORG_ID in NUMBER);
36
37
38 procedure LOCK_ROW (
39 X_ABATEMENT_ID in NUMBER
40 ,X_VAR_RENT_ID in NUMBER
41 ,X_START_DATE in DATE
42 ,X_END_DATE in DATE
43 ,X_TYPE_CODE in VARCHAR2
44 ,X_AMOUNT in NUMBER
45 ,X_DESCRIPTION in VARCHAR2
46 ,X_LAST_UPDATE_DATE in DATE
47 ,X_LAST_UPDATED_BY in NUMBER
48 ,X_CREATION_DATE in DATE
49 ,X_CREATED_BY in NUMBER
50 ,X_LAST_UPDATE_LOGIN in NUMBER
51 ,X_COMMENTS in VARCHAR2
52 ,X_ATTRIBUTE_CATEGORY in VARCHAR2
53 ,X_ATTRIBUTE1 in VARCHAR2
54 ,X_ATTRIBUTE2 in VARCHAR2
55 ,X_ATTRIBUTE3 in VARCHAR2
56 ,X_ATTRIBUTE4 in VARCHAR2
57 ,X_ATTRIBUTE5 in VARCHAR2
58 ,X_ATTRIBUTE6 in VARCHAR2
59 ,X_ATTRIBUTE7 in VARCHAR2
60 ,X_ATTRIBUTE8 in VARCHAR2
61 ,X_ATTRIBUTE9 in VARCHAR2
62 ,X_ATTRIBUTE10 in VARCHAR2
63 ,X_ATTRIBUTE11 in VARCHAR2
64 ,X_ATTRIBUTE12 in VARCHAR2
65 ,X_ATTRIBUTE13 in VARCHAR2
66 ,X_ATTRIBUTE14 in VARCHAR2
67 ,X_ATTRIBUTE15 in VARCHAR2
68 ,X_ORG_ID in NUMBER);
69
70 procedure UPDATE_ROW (
71 X_ABATEMENT_ID in NUMBER
72 ,X_VAR_RENT_ID in NUMBER
73 ,X_START_DATE in DATE
74 ,X_END_DATE in DATE
75 ,X_TYPE_CODE in VARCHAR2
76 ,X_AMOUNT in NUMBER
77 ,X_DESCRIPTION in VARCHAR2
78 ,X_LAST_UPDATE_DATE in DATE
79 ,X_LAST_UPDATED_BY in NUMBER
80 ,X_CREATION_DATE in DATE
81 ,X_CREATED_BY in NUMBER
82 ,X_LAST_UPDATE_LOGIN in NUMBER
83 ,X_COMMENTS in VARCHAR2
84 ,X_ATTRIBUTE_CATEGORY in VARCHAR2
85 ,X_ATTRIBUTE1 in VARCHAR2
86 ,X_ATTRIBUTE2 in VARCHAR2
87 ,X_ATTRIBUTE3 in VARCHAR2
88 ,X_ATTRIBUTE4 in VARCHAR2
89 ,X_ATTRIBUTE5 in VARCHAR2
90 ,X_ATTRIBUTE6 in VARCHAR2
91 ,X_ATTRIBUTE7 in VARCHAR2
92 ,X_ATTRIBUTE8 in VARCHAR2
93 ,X_ATTRIBUTE9 in VARCHAR2
94 ,X_ATTRIBUTE10 in VARCHAR2
95 ,X_ATTRIBUTE11 in VARCHAR2
96 ,X_ATTRIBUTE12 in VARCHAR2
97 ,X_ATTRIBUTE13 in VARCHAR2
98 ,X_ATTRIBUTE14 in VARCHAR2
99 ,X_ATTRIBUTE15 in VARCHAR2
100 ,X_ORG_ID in NUMBER);
101
102 procedure DELETE_ROW (
103 X_ABATEMENT_ID in NUMBER
104 );
105
106 end PN_VAR_ABAT_DEFAULTS_PKG;
[Home] [Help]