1 PACKAGE PN_VAR_TRUEUP_PKG AS
2 -- $Header: PNVRTRPS.pls 120.0 2007/10/03 14:29:57 rthumma noship $
3
4 /**Global variables*/
5
6 TYPE ALLOW_REC is RECORD(
7 rolling_allow NUMBER,
8 allow_applied NUMBER,
9 start_date DATE,
10 end_date DATE,
11 abatement_id NUMBER
12 );
13 TYPE ALLOW_TBL is TABLE of ALLOW_REC INDEX BY BINARY_INTEGER;
14
15 FUNCTION can_do_trueup( p_var_rent_id IN NUMBER
16 ,p_period_id IN NUMBER)
17 RETURN BOOLEAN;
18
19 PROCEDURE post_summary_trueup ( p_var_rent_id IN NUMBER
20 ,p_period_id IN NUMBER
21 ,p_proration_rule IN VARCHAR2);
22
23 PROCEDURE insert_invoice_trueup ( p_var_rent_id IN NUMBER
24 ,p_period_id IN NUMBER);
25 /*Procedures to calculate true up abatements*/
26 PROCEDURE apply_abatements(p_var_rent_id NUMBER,
27 p_period_id IN NUMBER,
28 p_flag IN VARCHAR2);
29 PROCEDURE apply_allow(p_var_rent_id IN NUMBER,
30 p_period_id IN NUMBER,
31 p_inv_id IN NUMBER,
32 p_allow_t IN ALLOW_TBL,
33 p_allow_tu_t IN ALLOW_TBL,
34 x_abated_rent IN OUT NOCOPY NUMBER);
35 PROCEDURE apply_abat(p_var_rent_id IN NUMBER,
36 p_period_id IN NUMBER,
37 p_inv_id IN NUMBER,
38 x_abated_rent IN OUT NOCOPY NUMBER);
39 PROCEDURE populate_abat(p_var_rent_id IN NUMBER,
40 p_period_id IN NUMBER,
41 p_inv_id IN NUMBER);
42 PROCEDURE reset_abatements(p_var_rent_id IN NUMBER
43 );
44 FUNCTION get_dated_allow(p_allow_t ALLOW_TBL,
45 p_start_date DATE,
46 p_end_date DATE) RETURN ALLOW_TBL;
47 PROCEDURE populate_neg_rent(p_var_rent_id IN NUMBER,
48 p_period_id IN NUMBER
49 ,p_inv_id IN NUMBER,
50 x_abated_rent IN OUT NOCOPY NUMBER);
51 PROCEDURE apply_def_neg_rent(p_var_rent_id IN NUMBER,
52 p_period_id IN NUMBER,
53 p_inv_id IN NUMBER,
54 x_abated_rent IN OUT NOCOPY NUMBER);
55 PROCEDURE calculate_trueup( p_var_rent_id IN NUMBER
56 ,p_prd_date IN DATE);
57
58 PROCEDURE trueup_batch_process( errbuf OUT NOCOPY VARCHAR2
59 ,retcode OUT NOCOPY VARCHAR2
60 ,p_property_code IN VARCHAR2
61 ,p_lease_num_low IN VARCHAR2
62 ,p_lease_num_high IN VARCHAR2
63 ,p_vr_num_low IN VARCHAR2
64 ,p_vr_num_high IN VARCHAR2
65 ,p_date IN VARCHAR2);
66
67 PROCEDURE set_trueup_flag(l_flag VARCHAR2);
68
69 END PN_VAR_TRUEUP_PKG;