1 package PN_VAR_ABATEMENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: PNVRABTS.pls 120.3 2007/07/02 15:20:28 lbala noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_VAR_ABATEMENT_ID in out NOCOPY NUMBER,
7 X_VAR_RENT_ID in NUMBER,
8 X_VAR_RENT_INV_ID in NUMBER,
9 X_PAYMENT_TERM_ID in NUMBER,
10 X_INCLUDE_TERM in VARCHAR2,
11 X_INCLUDE_INCREASES in VARCHAR2,
12 X_UPDATE_FLAG in VARCHAR2,
13 X_CREATION_DATE in DATE,
14 X_CREATED_BY in NUMBER,
15 X_LAST_UPDATE_DATE in DATE,
16 X_LAST_UPDATED_BY in NUMBER,
17 X_LAST_UPDATE_LOGIN in NUMBER,
18 X_ORG_ID in NUMBER
19 );
20
21 procedure LOCK_ROW (
22 X_VAR_RENT_ID in NUMBER,
23 X_VAR_RENT_INV_ID in NUMBER,
24 X_PAYMENT_TERM_ID in NUMBER
25 );
26
27 procedure UPDATE_ROW (
28 X_VAR_RENT_ID in NUMBER,
29 X_VAR_RENT_INV_ID in NUMBER,
30 X_PAYMENT_TERM_ID in NUMBER,
31 X_INCLUDE_TERM in VARCHAR2,
32 X_INCLUDE_INCREASES in VARCHAR2,
33 X_UPDATE_FLAG in VARCHAR2,
34 X_LAST_UPDATE_DATE in DATE,
35 X_LAST_UPDATED_BY in NUMBER,
36 X_LAST_UPDATE_LOGIN in NUMBER
37 );
38
39 procedure DELETE_ROW (
40 X_VAR_RENT_ID in NUMBER,
41 X_VAR_RENT_INV_ID in NUMBER,
42 X_PAYMENT_TERM_ID in NUMBER
43 );
44
45 FUNCTION CHECK_CALC_INV_EXISTS (
46 p_var_rent_inv_id IN NUMBER,
47 p_var_rent_id IN NUMBER
48 ) RETURN VARCHAR2;
49
50 PROCEDURE ROLL_FWD_ON_UPD (
51 p_var_rentId IN NUMBER,
52 p_var_rent_inv_id IN NUMBER,
53 p_pmt_term_id IN NUMBER,
54 flag IN NUMBER
55 );
56
57 FUNCTION ABTMT_EXISTS (
58 p_var_rentId IN NUMBER,
59 p_var_rent_inv_id IN NUMBER,
60 p_pmt_term_id IN NUMBER
61 ) RETURN VARCHAR2;
62
63 PROCEDURE RESET_UPDATE_FLAG (
64 p_var_rentId IN NUMBER,
65 p_var_rent_inv_id IN NUMBER
66 );
67
68 FUNCTION GET_INCLUDE_TERM(
69 p_payment_term_id IN NUMBER,
70 p_var_rent_inv_id IN NUMBER,
71 p_var_rent_id IN NUMBER
72 )
73 RETURN VARCHAR2;
74
75 FUNCTION GET_INCLUDE_INCREASES(
76 p_payment_term_id IN NUMBER,
77 p_var_rent_inv_id IN NUMBER,
78 p_var_rent_id IN NUMBER
79 )
80 RETURN VARCHAR2 ;
81
82 PROCEDURE ROLL_FWD_FST_ON_UPD(
83 p_var_rentId IN NUMBER,
84 p_var_rent_inv_id IN NUMBER,
85 p_pmt_term_id IN NUMBER,
86 flag IN NUMBER
87 );
88
89 FUNCTION CHECK_TRUE_UP_INVOICE (p_var_rent_inv_id IN NUMBER)
90 RETURN VARCHAR2 ;
91
92 end PN_VAR_ABATEMENTS_PKG;