1 package PN_VAR_RENT_INV_PKG as
2 /* $Header: PNVRINVS.pls 120.1 2006/12/20 07:32:56 rdonthul noship $ */
3
4
5 -------------------------------------------------------------------------------
6 -- PROCDURE : INSERT_ROW
7 -- HISTORY
8 -- 18-AUG-06 Pikhar o Added credit_flag,true_up_amount,true_up_status
9 -- and true_up_exp_code
10 -------------------------------------------------------------------------------
11
12 procedure INSERT_ROW (
13 X_ROWID in out NOCOPY VARCHAR2,
14 X_VAR_RENT_INV_ID in out NOCOPY NUMBER,
15 X_ADJUST_NUM in NUMBER,
16 X_INVOICE_DATE in DATE,
17 X_FOR_PER_RENT in NUMBER,
18 X_TOT_ACT_VOL in NUMBER,
19 X_ACT_PER_RENT in NUMBER,
20 X_CONSTR_ACTUAL_RENT in NUMBER,
21 X_ABATEMENT_APPL in NUMBER,
22 X_REC_ABATEMENT in NUMBER,
23 X_REC_ABATEMENT_OVERRIDE in NUMBER,
24 X_NEGATIVE_RENT in NUMBER,
25 X_ACTUAL_INVOICED_AMOUNT in NUMBER,
26 X_PERIOD_ID in NUMBER,
27 X_VAR_RENT_ID in NUMBER,
28 X_FORECASTED_TERM_STATUS in VARCHAR2,
29 X_VARIANCE_TERM_STATUS in VARCHAR2,
30 X_ACTUAL_TERM_STATUS in VARCHAR2,
31 X_FORECASTED_EXP_CODE in VARCHAR2,
32 X_VARIANCE_EXP_CODE in VARCHAR2,
33 X_ACTUAL_EXP_CODE in VARCHAR2,
34 X_COMMENTS in VARCHAR2,
35 X_ATTRIBUTE_CATEGORY in VARCHAR2,
36 X_ATTRIBUTE1 in VARCHAR2,
37 X_ATTRIBUTE2 in VARCHAR2,
38 X_ATTRIBUTE3 in VARCHAR2,
39 X_ATTRIBUTE4 in VARCHAR2,
40 X_ATTRIBUTE5 in VARCHAR2,
41 X_ATTRIBUTE6 in VARCHAR2,
42 X_ATTRIBUTE7 in VARCHAR2,
43 X_ATTRIBUTE8 in VARCHAR2,
44 X_ATTRIBUTE9 in VARCHAR2,
45 X_ATTRIBUTE10 in VARCHAR2,
46 X_ATTRIBUTE11 in VARCHAR2,
47 X_ATTRIBUTE12 in VARCHAR2,
48 X_ATTRIBUTE13 in VARCHAR2,
49 X_ATTRIBUTE14 in VARCHAR2,
50 X_ATTRIBUTE15 in VARCHAR2,
51 X_CREATION_DATE in DATE,
52 X_CREATED_BY in NUMBER,
53 X_LAST_UPDATE_DATE in DATE,
54 X_LAST_UPDATED_BY in NUMBER,
55 X_LAST_UPDATE_LOGIN in NUMBER,
56 X_ORG_ID in NUMBER,
57 X_CREDIT_FLAG in VARCHAR2 DEFAULT 'N',
58 X_TRUE_UP_AMOUNT in NUMBER DEFAULT NULL,
59 X_TRUE_UP_STATUS in VARCHAR2 DEFAULT NULL,
60 X_TRUE_UP_EXP_CODE in VARCHAR2 DEFAULT NULL);
61
62
63
64 -----------------------------------------------------------------------
65 ---- PROCEDURE : LOCK_ROW_EXCEPTION
66 -----------------------------------------------------------------------
67
68 procedure lock_row_exception (p_column_name in varchar2,
69 p_new_value in varchar2);
70
71
72 -----------------------------------------------------------------------
73 -- PROCDURE : LOCK_ROW
74 -----------------------------------------------------------------------
75
76 procedure LOCK_ROW (
77 X_VAR_RENT_INV_ID in NUMBER,
78 X_ADJUST_NUM in NUMBER,
79 X_INVOICE_DATE in DATE,
80 X_FOR_PER_RENT in NUMBER,
81 X_TOT_ACT_VOL in NUMBER,
82 X_ACT_PER_RENT in NUMBER,
83 X_CONSTR_ACTUAL_RENT in NUMBER,
84 X_ABATEMENT_APPL in NUMBER,
85 X_REC_ABATEMENT in NUMBER,
86 X_REC_ABATEMENT_OVERRIDE in NUMBER,
87 X_NEGATIVE_RENT in NUMBER,
88 X_ACTUAL_INVOICED_AMOUNT in NUMBER,
89 X_PERIOD_ID in NUMBER,
90 X_VAR_RENT_ID in NUMBER,
91 X_FORECASTED_TERM_STATUS in VARCHAR2,
92 X_VARIANCE_TERM_STATUS in VARCHAR2,
93 X_ACTUAL_TERM_STATUS in VARCHAR2,
94 X_FORECASTED_EXP_CODE in VARCHAR2,
95 X_VARIANCE_EXP_CODE in VARCHAR2,
96 X_ACTUAL_EXP_CODE in VARCHAR2,
97 X_COMMENTS in VARCHAR2,
98 X_ATTRIBUTE_CATEGORY in VARCHAR2,
99 X_ATTRIBUTE1 in VARCHAR2,
100 X_ATTRIBUTE2 in VARCHAR2,
101 X_ATTRIBUTE3 in VARCHAR2,
102 X_ATTRIBUTE4 in VARCHAR2,
103 X_ATTRIBUTE5 in VARCHAR2,
104 X_ATTRIBUTE6 in VARCHAR2,
105 X_ATTRIBUTE7 in VARCHAR2,
106 X_ATTRIBUTE8 in VARCHAR2,
107 X_ATTRIBUTE9 in VARCHAR2,
108 X_ATTRIBUTE10 in VARCHAR2,
109 X_ATTRIBUTE11 in VARCHAR2,
110 X_ATTRIBUTE12 in VARCHAR2,
111 X_ATTRIBUTE13 in VARCHAR2,
112 X_ATTRIBUTE14 in VARCHAR2,
113 X_ATTRIBUTE15 in VARCHAR2
114 );
115
116 -----------------------------------------------------------------------
117 -- PROCEDURE : UPDATE_ROW
118 -----------------------------------------------------------------------
119
120
121 procedure UPDATE_ROW (
122 X_VAR_RENT_INV_ID in NUMBER,
123 X_ADJUST_NUM in NUMBER,
124 X_INVOICE_DATE in DATE,
125 X_FOR_PER_RENT in NUMBER,
126 X_TOT_ACT_VOL in NUMBER,
127 X_ACT_PER_RENT in NUMBER,
128 X_CONSTR_ACTUAL_RENT in NUMBER,
129 X_ABATEMENT_APPL in NUMBER,
130 X_REC_ABATEMENT in NUMBER,
131 X_REC_ABATEMENT_OVERRIDE in NUMBER,
132 X_NEGATIVE_RENT in NUMBER,
133 X_ACTUAL_INVOICED_AMOUNT in NUMBER,
134 X_PERIOD_ID in NUMBER,
135 X_VAR_RENT_ID in NUMBER,
136 X_FORECASTED_TERM_STATUS in VARCHAR2,
137 X_VARIANCE_TERM_STATUS in VARCHAR2,
138 X_ACTUAL_TERM_STATUS in VARCHAR2,
139 X_FORECASTED_EXP_CODE in VARCHAR2,
140 X_VARIANCE_EXP_CODE in VARCHAR2,
141 X_ACTUAL_EXP_CODE in VARCHAR2,
142 X_COMMENTS in VARCHAR2,
143 X_ATTRIBUTE_CATEGORY in VARCHAR2,
144 X_ATTRIBUTE1 in VARCHAR2,
145 X_ATTRIBUTE2 in VARCHAR2,
146 X_ATTRIBUTE3 in VARCHAR2,
147 X_ATTRIBUTE4 in VARCHAR2,
148 X_ATTRIBUTE5 in VARCHAR2,
149 X_ATTRIBUTE6 in VARCHAR2,
150 X_ATTRIBUTE7 in VARCHAR2,
151 X_ATTRIBUTE8 in VARCHAR2,
152 X_ATTRIBUTE9 in VARCHAR2,
153 X_ATTRIBUTE10 in VARCHAR2,
154 X_ATTRIBUTE11 in VARCHAR2,
155 X_ATTRIBUTE12 in VARCHAR2,
156 X_ATTRIBUTE13 in VARCHAR2,
157 X_ATTRIBUTE14 in VARCHAR2,
158 X_ATTRIBUTE15 in VARCHAR2,
159 X_LAST_UPDATE_DATE in DATE,
160 X_LAST_UPDATED_BY in NUMBER,
161 X_LAST_UPDATE_LOGIN in NUMBER
162 );
163
164 -----------------------------------------------------------------------
165 -- PROCDURE : DELETE_ROW
166 -----------------------------------------------------------------------
167
168 procedure DELETE_ROW (
169 X_VAR_RENT_INV_ID in NUMBER
170 );
171
172 END PN_VAR_RENT_INV_PKG;
173