eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PN_VARIABLE_AMOUNT_PKG

Source


1 PACKAGE pn_variable_amount_pkg AUTHID CURRENT_USER 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