1 PACKAGE PN_NOTE_HEADERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: PNTNOTHS.pls 115.8 2004/05/26 06:59:44 abanerje ship $ */
3 ------------------------------------------------------------------
4 -- PROCEDURE : INSERT_ROW
5 ------------------------------------------------------------------
6 procedure INSERT_ROW
7 (
8 X_ROWID IN OUT NOCOPY VARCHAR2,
9 X_NOTE_HEADER_ID IN OUT NOCOPY NUMBER,
10 X_LEASE_ID IN NUMBER,
11 X_NOTE_TYPE_LOOKUP_CODE IN VARCHAR2,
12 X_NOTE_DATE IN DATE,
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_ATTRIBUTE_CATEGORY IN VARCHAR2, --3626177
19 X_ATTRIBUTE1 IN VARCHAR2,
20 X_ATTRIBUTE2 IN VARCHAR2,
21 X_ATTRIBUTE3 IN VARCHAR2,
22 X_ATTRIBUTE4 IN VARCHAR2,
23 X_ATTRIBUTE5 IN VARCHAR2,
24 X_ATTRIBUTE6 IN VARCHAR2,
25 X_ATTRIBUTE7 IN VARCHAR2,
26 X_ATTRIBUTE8 IN VARCHAR2,
27 X_ATTRIBUTE9 IN VARCHAR2,
28 X_ATTRIBUTE10 IN VARCHAR2,
29 X_ATTRIBUTE11 IN VARCHAR2,
30 X_ATTRIBUTE12 IN VARCHAR2,
31 X_ATTRIBUTE13 IN VARCHAR2,
32 X_ATTRIBUTE14 IN VARCHAR2,
33 X_ATTRIBUTE15 IN VARCHAR2
34 );
35
36 ------------------------------------------------------------------
37 -- PROCEDURE : LOCK_ROW
38 ------------------------------------------------------------------
39 procedure LOCK_ROW
40 (
41 X_NOTE_HEADER_ID IN NUMBER,
42 X_LEASE_ID IN NUMBER,
43 X_NOTE_DATE IN DATE,
44 X_NOTE_TYPE_LOOKUP_CODE IN VARCHAR2,
45 X_ATTRIBUTE_CATEGORY IN VARCHAR2, --3626177
46 X_ATTRIBUTE1 IN VARCHAR2,
47 X_ATTRIBUTE2 IN VARCHAR2,
48 X_ATTRIBUTE3 IN VARCHAR2,
49 X_ATTRIBUTE4 IN VARCHAR2,
50 X_ATTRIBUTE5 IN VARCHAR2,
51 X_ATTRIBUTE6 IN VARCHAR2,
52 X_ATTRIBUTE7 IN VARCHAR2,
53 X_ATTRIBUTE8 IN VARCHAR2,
54 X_ATTRIBUTE9 IN VARCHAR2,
55 X_ATTRIBUTE10 IN VARCHAR2,
56 X_ATTRIBUTE11 IN VARCHAR2,
57 X_ATTRIBUTE12 IN VARCHAR2,
58 X_ATTRIBUTE13 IN VARCHAR2,
59 X_ATTRIBUTE14 IN VARCHAR2,
60 X_ATTRIBUTE15 IN VARCHAR2
61 );
62
63 ------------------------------------------------------------------
64 -- PROCEDURE : UPDATE_ROW
65 ------------------------------------------------------------------
66 procedure UPDATE_ROW
67 (
68 X_NOTE_HEADER_ID IN NUMBER,
69 X_LEASE_ID IN NUMBER,
70 X_NOTE_TYPE_LOOKUP_CODE IN VARCHAR2,
71 X_NOTE_DATE IN DATE,
72 X_LAST_UPDATE_DATE IN DATE,
73 X_LAST_UPDATED_BY IN NUMBER,
74 X_LAST_UPDATE_LOGIN IN NUMBER,
75 X_ATTRIBUTE_CATEGORY IN VARCHAR2, --3626177
76 X_ATTRIBUTE1 IN VARCHAR2,
77 X_ATTRIBUTE2 IN VARCHAR2,
78 X_ATTRIBUTE3 IN VARCHAR2,
79 X_ATTRIBUTE4 IN VARCHAR2,
80 X_ATTRIBUTE5 IN VARCHAR2,
81 X_ATTRIBUTE6 IN VARCHAR2,
82 X_ATTRIBUTE7 IN VARCHAR2,
83 X_ATTRIBUTE8 IN VARCHAR2,
84 X_ATTRIBUTE9 IN VARCHAR2,
85 X_ATTRIBUTE10 IN VARCHAR2,
86 X_ATTRIBUTE11 IN VARCHAR2,
87 X_ATTRIBUTE12 IN VARCHAR2,
88 X_ATTRIBUTE13 IN VARCHAR2,
89 X_ATTRIBUTE14 IN VARCHAR2,
90 X_ATTRIBUTE15 IN VARCHAR2
91 );
92
93 ------------------------------------------------------------------
94 -- PROCEDURE : DELETE_ROW
95 ------------------------------------------------------------------
96 procedure DELETE_ROW
97 (
98 X_NOTE_HEADER_ID in NUMBER
99 );
100 END PN_NOTE_HEADERS_PKG;