1 PACKAGE PN_INDEX_LEASE_TERMS_PKG AUTHID CURRENT_USER AS
2 -- $Header: PNILTRHS.pls 115.4 2002/11/12 23:00:58 stripath noship $
3
4 -- +================================================================+
5 -- | Copyright (c) 2001 Oracle Corporation
6 -- | Redwood Shores, California, USA
7 -- | All rights reserved.
8 -- +================================================================+
9 -- | Name
10 -- | PN_INDEX_LEASE_TERMS_PKG
11 -- |
12 -- | Description
13 -- | This package contains row handler procedures for populating PN_INDEX_LEASE_TERMS_ALL.
14 -- |
15 -- |
16 -- | History
17 -- | 05-dec-2001 achauhan Created
18 -- | 15-JAN-2002 Mrinal Misra Added dbdrv command.
19 -- | 01-FEB-2002 Mrinal Misra Added checkfile command.
20 -- +================================================================+
21
22 ------------------------------------------------------------------------
23 -- PROCEDURE : INSERT_ROW
24 ------------------------------------------------------------------------
25 procedure INSERT_ROW
26 (
27 X_INDEX_LEASE_TERM_ID IN OUT NOCOPY NUMBER
28 ,X_INDEX_LEASE_ID IN NUMBER
29 ,X_INDEX_PERIOD_ID IN NUMBER
30 ,X_LEASE_TERM_ID IN NUMBER
31 ,X_RENT_INCREASE_TERM_ID IN NUMBER
32 ,X_AMOUNT IN NUMBER
33 ,X_APPROVED_FLAG IN VARCHAR2
34 ,X_INDEX_TERM_INDICATOR IN VARCHAR2
35 ,X_LAST_UPDATE_DATE IN DATE
36 ,X_LAST_UPDATED_BY IN NUMBER
37 ,X_CREATION_DATE IN DATE
38 ,X_CREATED_BY IN NUMBER
39 ,X_LAST_UPDATE_LOGIN IN NUMBER
40 );
41
42
43 ------------------------------------------------------------------------
44 -- PROCEDURE : UPDATE_ROW
45 ------------------------------------------------------------------------
46 procedure UPDATE_ROW
47 (
48 X_INDEX_LEASE_TERM_ID IN NUMBER
49 ,X_INDEX_LEASE_ID IN NUMBER
50 ,X_INDEX_PERIOD_ID IN NUMBER
51 ,X_LEASE_TERM_ID IN NUMBER
52 ,X_RENT_INCREASE_TERM_ID IN NUMBER
53 ,X_AMOUNT IN NUMBER
54 ,X_APPROVED_FLAG IN VARCHAR2
55 ,X_INDEX_TERM_INDICATOR IN VARCHAR2
56 ,X_LAST_UPDATE_DATE IN DATE
57 ,X_LAST_UPDATED_BY IN NUMBER
58 ,X_LAST_UPDATE_LOGIN IN NUMBER
59 );
60 ------------------------------------------------------------------------
61 -- PROCEDURE : LOCK_ROW
62 ------------------------------------------------------------------------
63 procedure LOCK_ROW
64 (
65 X_INDEX_LEASE_TERM_ID IN NUMBER
66 ,X_INDEX_LEASE_ID IN NUMBER
67 ,X_INDEX_PERIOD_ID IN NUMBER
68 ,X_LEASE_TERM_ID IN NUMBER
69 ,X_RENT_INCREASE_TERM_ID IN NUMBER
70 ,X_AMOUNT IN NUMBER
71 ,X_APPROVED_FLAG IN VARCHAR2
72 ,X_INDEX_TERM_INDICATOR IN VARCHAR2
73 );
74 ------------------------------------------------------------------------
75 -- PROCEDURE : DELETE_ROW
76 ------------------------------------------------------------------------
77 procedure delete_row
78 (
79 X_INDEX_LEASE_TERM_ID IN NUMBER
80 ,X_INDEX_LEASE_ID IN NUMBER
81 ,X_INDEX_PERIOD_ID IN NUMBER
82 ,X_LEASE_TERM_ID IN NUMBER
83 ,X_RENT_INCREASE_TERM_ID IN NUMBER
84 );
85
86
87
88 END PN_INDEX_LEASE_TERMS_PKG;