[Home] [Help]
PACKAGE: APPS.PN_VARIABLE_AMOUNT_PKG
Source
1 PACKAGE pn_variable_amount_pkg AS
2 -- $Header: PNVRAMTS.pls 120.2 2007/03/16 10:45:08 rdonthul noship $
3
4
5 -- LEASE CLASS
6 c_lease_class_direct CONSTANT CHAR (6) := 'DIRECT';
7
8 -- PAYMENT STATUS
9 c_payment_term_status_draft CONSTANT CHAR (5) := 'DRAFT';
10 c_payment_term_status_approved CONSTANT CHAR (8) := 'APPROVED';
11
12
13
14 PROCEDURE process_variable_rent (
15 p_var_rent_id IN NUMBER,
16 p_period_id IN NUMBER,
17 p_line_item_id IN NUMBER,
18 p_cumulative IN VARCHAR2,
19 p_invoice_on IN VARCHAR2,
20 p_calc_type IN VARCHAR2,
21 p_invoice_date IN DATE DEFAULT NULL);
22
23 PROCEDURE process_rent (
24 p_var_rent_id IN NUMBER,
25 p_period_id IN NUMBER,
26 p_line_item_id IN NUMBER,
27 p_grp_date_id IN NUMBER,
28 p_invoice_date IN DATE,
29 p_group_date IN DATE,
30 p_tot_vol IN NUMBER,
31 p_tot_ded IN NUMBER,
32 p_var_rent IN NUMBER,
33 p_calc_type IN VARCHAR2,
34 p_cumulative IN VARCHAR2
35 );
36
37 PROCEDURE Insert_invoice(
38 p_calc_type IN VARCHAR2,
39 p_period_id IN NUMBER,
40 p_var_rent_id IN NUMBER);
41
42 FUNCTION get_rent_applicable (
43 p_cumulative IN VARCHAR2,
44 p_net_volume IN NUMBER,
45 p_percent_days_open IN NUMBER)
46 RETURN NUMBER;
47
48
49 PROCEDURE process_calculate_type (
50 p_line_item_id IN NUMBER,
51 p_cumulative IN VARCHAR2,
52 p_calc_type IN VARCHAR2,
53 p_period_id IN NUMBER,
54 p_invoice_date IN DATE);
55
56
57 PROCEDURE get_cum_vol_by_grpdt(
58 p_grp_date_id IN NUMBER,
59 p_cum_actual_vol OUT NOCOPY NUMBER,
60 p_cum_for_vol OUT NOCOPY NUMBER,
61 p_cum_ded OUT NOCOPY NUMBER);
62
63
64 PROCEDURE get_bkp_details (p_line_item_id IN NUMBER);
65
66 FUNCTION find_varrent_exists (
67 p_line_item_id IN NUMBER,
68 p_grp_date_id IN NUMBER)
69 RETURN VARCHAR2;
70
71
72 PROCEDURE calculate_var_rent (
73 p_grp_date_id IN NUMBER,
74 p_line_item_id IN NUMBER,
75 p_volume IN NUMBER,
76 p_cum_volume IN NUMBER,
77 p_cum_ded IN NUMBER,
78 p_cumulative IN VARCHAR2,
79 p_calc_type IN VARCHAR2);
80
81
82
83 PROCEDURE get_varrent_details (
84 p_var_rent_id IN NUMBER,
85 p_cumulative OUT NOCOPY VARCHAR2,
86 p_invoice_on OUT NOCOPY VARCHAR2,
87 p_negative_rent OUT NOCOPY VARCHAR2);
88
89 FUNCTION apply_constraints(
90 p_period_id IN NUMBER,
91 p_actual_rent IN NUMBER)
92 RETURN NUMBER;
93
94
95 PROCEDURE get_transferred_flag(
96 p_period_id IN NUMBER,
97 p_invoice_date IN DATE,
98 p_actual_flag OUT NOCOPY VARCHAR2,
99 p_forecasted_flag OUT NOCOPY VARCHAR2,
100 p_variance_flag OUT NOCOPY VARCHAR2);
101
102 FUNCTION get_prior_transfer_flag(
103 p_var_rent_inv_id NUMBER,
104 p_var_rent_type VARCHAR2,
105 p_var_rent_id NUMBER)
106 RETURN VARCHAR2;
107
108 FUNCTION get_prev_inv_amt(
109 p_var_rent_id NUMBER,
110 p_invoice_date DATE,
111 p_adjust_num NUMBER)
112 RETURN NUMBER;
113
114
115 FUNCTION find_if_term_exists (
116 p_var_rent_inv_id IN NUMBER,
117 p_var_rent_type IN VARCHAR2)
118 RETURN VARCHAR2;
119
120 FUNCTION find_volume_exists (
121 p_period_id IN NUMBER,
122 p_invoice_date IN DATE,
123 p_var_rent_type IN VARCHAR2)
124 RETURN VARCHAR2;
125
126 PROCEDURE get_deductions(p_line_item_id IN NUMBER);
127
128 PROCEDURE get_percent_open (
129 p_period_id IN NUMBER,
130 p_cumulative IN VARCHAR2,
131 p_start_date IN DATE,
132 p_end_date IN DATE );
133
134 PROCEDURE get_cumulative_volume (
135 p_line_item_id IN NUMBER);
136
137 PROCEDURE put_log(p_string VARCHAR2);
138
139 PROCEDURE put_output(p_string VARCHAR2);
140
141 PROCEDURE apply_abatements (p_var_rent_id IN NUMBER);
142
143 FUNCTION get_vol_ded(
144 p_line_item_id NUMBER,
145 p_group_date DATE,
146 p_type VARCHAR2)
147 RETURN NUMBER;
148
149
150 PROCEDURE process_rent_batch (
151 errbuf OUT NOCOPY VARCHAR2,
152 retcode OUT NOCOPY VARCHAR2,
153 p_lease_num_from IN VARCHAR2,
154 p_lease_num_to IN VARCHAR2,
155 p_location_code_from IN VARCHAR2,
156 p_location_code_to IN VARCHAR2,
157 p_vrent_num_from IN VARCHAR2,
158 p_vrent_num_to IN VARCHAR2,
159 p_period_num_from IN NUMBER,
160 p_period_num_to IN NUMBER,
161 p_responsible_user IN NUMBER,
162 p_invoice_on IN VARCHAR2 DEFAULT NULL,
163 p_var_rent_id IN NUMBER,
164 p_period_id IN NUMBER,
165 p_line_item_id IN NUMBER,
166 p_invoice_date IN DATE,
167 p_calc_type IN VARCHAR2,
168 p_period_date IN VARCHAR2 DEFAULT NULL,
169 p_org_id IN NUMBER DEFAULT NULL);
170
171 PROCEDURE process_vol_hist (
172 p_grp_date_id IN NUMBER,
173 p_invoice_date IN DATE,
174 p_period_id IN NUMBER,
175 p_line_item_id IN NUMBER,
176 p_invoice_on IN VARCHAR2,
177 p_calc_type OUT NOCOPY VARCHAR2);
178
179 FUNCTION get_msg (
180 p_calc IN VARCHAR2,
181 p_adj IN VARCHAR2,
182 p_rec IN VARCHAR2)
183 RETURN VARCHAR2;
184
185 FUNCTION get_prorated_bkpt(p_cumulative IN VARCHAR2,
186 p_grp_st_dt IN DATE,
187 p_grp_end_dt IN DATE,
188 p_per_st_dt IN DATE,
189 p_per_end_dt IN DATE,
190 p_per_bkpt IN NUMBER,
191 p_grp_bkpt IN NUMBER,
192 p_pror_factor IN NUMBER)
193 RETURN NUMBER;
194
195 FUNCTION derive_actual_invoiced_amt(p_constr_actual_rent number,
196 p_negative_rent_flag varchar2,
197 p_abatement_appl number,
198 p_negative_rent number,
199 p_rec_abatement number,
200 p_rec_abatement_override number)
201 RETURN NUMBER;
202
203 PROCEDURE get_approved_flag(
204 p_period_id IN NUMBER,
205 p_invoice_date IN DATE,
206 p_true_up_flag IN VARCHAR2,
207 p_actual_flag OUT NOCOPY VARCHAR2,
208 p_forecasted_flag OUT NOCOPY VARCHAR2,
209 p_variance_flag OUT NOCOPY VARCHAR2);
210
211 END pn_variable_amount_pkg;
212
213