1 PACKAGE PN_INDEX_EXCLUDE_TERM_PKG AS
2 -- $Header: PNINXTRS.pls 120.1 2006/12/20 07:41:51 rdonthul noship $
3
4 ------------------------------------------------------------------------
5 -- PROCEDURE : INSERT_ROW
6 ------------------------------------------------------------------------
7 procedure INSERT_ROW
8 (
9 X_INDEX_EXCLUDE_TERM_ID IN OUT NOCOPY NUMBER
10 ,X_ORG_ID IN NUMBER
11 ,X_INDEX_LEASE_ID IN NUMBER
12 ,X_PAYMENT_TERM_ID IN NUMBER
13 ,X_LAST_UPDATE_DATE IN DATE
14 ,X_LAST_UPDATED_BY IN NUMBER
15 ,X_CREATION_DATE IN DATE
16 ,X_CREATED_BY IN NUMBER
17 ,X_LAST_UPDATE_LOGIN IN NUMBER
18 ,X_INCLUDE_EXCLUDE_FLAG IN VARCHAR2
19 );
20 ------------------------------------------------------------------------
21 -- PROCEDURE : UPDATE_ROW
22 ------------------------------------------------------------------------
23 procedure UPDATE_ROW
24 (
25 --x_rowid in varchar2,
26 X_INDEX_EXCLUDE_TERM_ID IN NUMBER
27 ,X_INDEX_LEASE_ID IN NUMBER
28 ,X_PAYMENT_TERM_ID IN NUMBER
29 ,X_LAST_UPDATE_DATE IN DATE
30 ,X_LAST_UPDATED_BY IN NUMBER
31 ,X_LAST_UPDATE_LOGIN IN NUMBER
32 ,X_INCLUDE_EXCLUDE_FLAG IN VARCHAR2
33 );
34 ------------------------------------------------------------------------
35 -- PROCEDURE : LOCK_ROW
36 ------------------------------------------------------------------------
37 procedure LOCK_ROW
38 (
39 --X_ROWID in VARCHAR2,
40 X_INDEX_EXCLUDE_TERM_ID IN NUMBER
41 ,X_INDEX_LEASE_ID IN NUMBER
42 ,X_PAYMENT_TERM_ID IN NUMBER
43 ,X_INCLUDE_EXCLUDE_FLAG IN VARCHAR2
44 );
45 ------------------------------------------------------------------------
46 -- PROCEDURE : DELETE_ROW
47 ------------------------------------------------------------------------
48 procedure delete_row
49 (
50 X_INDEX_LEASE_ID IN NUMBER
51 ,X_PAYMENT_TERM_ID IN NUMBER
52 );
53
54 ------------------------------------------------------------------------
55 -- PROCEDURE : DELETE_ALL_EXCLUDE_TERMS
56 ------------------------------------------------------------------------
57 procedure DELETE_ALL_EXCLUDE_TERMS
58 (
59 X_INDEX_LEASE_ID IN NUMBER
60 );
61 END PN_INDEX_EXCLUDE_TERM_PKG;