1 PACKAGE pn_variable_term_pkg AS
2 -- $Header: PNVTERMS.pls 120.3 2007/04/17 06:52:35 piagrawa noship $
3 g_currency_code pn_var_rents_all.currency_code%TYPE;
4
5 PROCEDURE create_payment_term_batch(
6 errbuf OUT NOCOPY VARCHAR2,
7 retcode OUT NOCOPY VARCHAR2,
8 p_lease_num_from IN VARCHAR2,
9 p_lease_num_to IN VARCHAR2,
10 p_location_code_from IN VARCHAR2,
11 p_location_code_to IN VARCHAR2,
12 p_vrent_num_from IN VARCHAR2,
13 p_vrent_num_to IN VARCHAR2,
14 p_period_num_from IN NUMBER,
15 p_period_num_to IN NUMBER,
16 p_responsible_user IN NUMBER,
17 p_period_id IN NUMBER,
18 p_org_id IN NUMBER DEFAULT NULL,
19 p_period_date IN VARCHAR2 DEFAULT NULL
20 );
21
22
23 PROCEDURE create_payment_terms(
24 p_lease_id IN NUMBER
25 ,p_period_id IN NUMBER
26 ,p_payment_amount IN NUMBER
27 ,p_invoice_date IN DATE
28 ,p_var_rent_id IN NUMBER
29 ,p_var_rent_inv_id IN NUMBER
30 ,p_location_id IN NUMBER
31 ,p_var_rent_type IN VARCHAR2
32 ,p_org_id IN NUMBER
33 );
34
35 PROCEDURE get_schedule_status ( p_lease_id IN NUMBER,
36 p_schedule_date IN DATE,
37 x_payment_status_lookup_code OUT NOCOPY VARCHAR2) ;
38
39 FUNCTION find_volume_continuous (p_var_rent_id IN NUMBER,
40 p_period_id IN NUMBER,
41 p_invoice_date IN DATE
42 )
43 RETURN VARCHAR2;
44
45 FUNCTION find_volume_continuous_for (p_var_rent_id IN NUMBER,
46 p_period_id IN NUMBER,
47 p_invoice_date IN DATE,
48 p_rent_type IN VARCHAR2
49 )
50 RETURN VARCHAR2;
51
52 FUNCTION get_period(p_vr_id IN NUMBER,
53 p_date IN DATE
54 )
55 RETURN NUMBER;
56
57 FUNCTION get_line(p_prd_id IN NUMBER,
58 p_line_id IN NUMBER
59 )
60 RETURN NUMBER;
61
62 FUNCTION get_inv_date(p_prd_id IN NUMBER,
63 p_date IN DATE
64 )
65 RETURN DATE ;
66
67 PROCEDURE create_reversal_terms(
68 p_payment_term_id IN NUMBER
69 ,p_var_rent_inv_id IN NUMBER
70 ,p_var_rent_type IN VARCHAR2
71 );
72
73 END pn_variable_term_pkg;
74
75