1 PACKAGE pn_index_history_headers_pkg AUTHID CURRENT_USER AS
2 -- $Header: PNTINHHS.pls 115.4 2002/11/12 23:06:01 stripath ship $
3
4 /*============================================================================+
5 | Copyright (c) 2001 Oracle Corporation
6 | Redwood Shores, California, USA
7 | All rights reserved.
8 | DESCRIPTION
9 |
10 | These procedures consist are used a table handlers for the PN_INDEX_HISTORY_HEADERS table.
11 | They include:
12 | INSERT_ROW - insert a row into PN_INDEX_HISTORY_HEADERS.
13 | DELETE_ROW - deletes a row from PN_INDEX_HISTORY_HEADERS.
14 | UPDATE_ROW - updates a row from PN_INDEX_HISTORY_HEADERS.
15 | LOCKS_ROW - will check if a row has been modified since being queried by form.
16 |
17 |
18 | HISTORY
19 | 24-APR-01 jbreyes - Created
20 | 13-DEC-01 Mrinal Misra - Added dbdrv command.
21 ==============================================================================*/
22
23
24 /**** SPECIFICATIONS ****/
25 ------------------------------------------------------------------------
26 -- PROCEDURE : INSERT_ROW
27 ------------------------------------------------------------------------
28 PROCEDURE insert_row (
29 x_rowid IN OUT NOCOPY VARCHAR2
30 ,x_index_id IN OUT NOCOPY NUMBER
31 ,x_last_update_date IN DATE
32 ,x_last_updated_by IN NUMBER
33 ,x_creation_date IN DATE
34 ,x_created_by IN NUMBER
35 ,x_name IN VARCHAR2
36 ,x_last_update_login IN NUMBER
37 ,x_source IN VARCHAR2
38 ,x_comments IN VARCHAR2
39 ,x_attribute_category IN VARCHAR2
40 ,x_attribute1 IN VARCHAR2
41 ,x_attribute2 IN VARCHAR2
42 ,x_attribute3 IN VARCHAR2
43 ,x_attribute4 IN VARCHAR2
44 ,x_attribute5 IN VARCHAR2
45 ,x_attribute6 IN VARCHAR2
46 ,x_attribute7 IN VARCHAR2
47 ,x_attribute8 IN VARCHAR2
48 ,x_attribute9 IN VARCHAR2
49 ,x_attribute10 IN VARCHAR2
50 ,x_attribute11 IN VARCHAR2
51 ,x_attribute12 IN VARCHAR2
52 ,x_attribute13 IN VARCHAR2
53 ,x_attribute14 IN VARCHAR2
54 ,x_attribute15 IN VARCHAR2
55 );
56
57
58 ------------------------------------------------------------------------
59 -- PROCEDURE : UPDATE_ROW
60 ------------------------------------------------------------------------
61 PROCEDURE update_row (
62 x_rowid IN VARCHAR2
63 ,x_index_id IN NUMBER
64 ,x_last_update_date IN DATE
65 ,x_last_updated_by IN NUMBER
66 ,x_name IN VARCHAR2
67 ,x_last_update_login IN NUMBER
68 ,x_source IN VARCHAR2
69 ,x_comments IN VARCHAR2
70 ,x_attribute_category IN VARCHAR2
71 ,x_attribute1 IN VARCHAR2
72 ,x_attribute2 IN VARCHAR2
73 ,x_attribute3 IN VARCHAR2
74 ,x_attribute4 IN VARCHAR2
75 ,x_attribute5 IN VARCHAR2
76 ,x_attribute6 IN VARCHAR2
77 ,x_attribute7 IN VARCHAR2
78 ,x_attribute8 IN VARCHAR2
79 ,x_attribute9 IN VARCHAR2
80 ,x_attribute10 IN VARCHAR2
81 ,x_attribute11 IN VARCHAR2
82 ,x_attribute12 IN VARCHAR2
83 ,x_attribute13 IN VARCHAR2
84 ,x_attribute14 IN VARCHAR2
85 ,x_attribute15 IN VARCHAR2
86 );
87
88
89 ------------------------------------------------------------------------
90 -- PROCEDURE : LOCK_ROW
91 ------------------------------------------------------------------------
92 PROCEDURE lock_row (
93 x_rowid IN VARCHAR2
94 ,x_index_id IN NUMBER
95 ,x_name IN VARCHAR2
96 ,x_source IN VARCHAR2
97 ,x_comments IN VARCHAR2
98 ,x_attribute_category IN VARCHAR2
99 ,x_attribute1 IN VARCHAR2
100 ,x_attribute2 IN VARCHAR2
101 ,x_attribute3 IN VARCHAR2
102 ,x_attribute4 IN VARCHAR2
103 ,x_attribute5 IN VARCHAR2
104 ,x_attribute6 IN VARCHAR2
105 ,x_attribute7 IN VARCHAR2
106 ,x_attribute8 IN VARCHAR2
107 ,x_attribute9 IN VARCHAR2
108 ,x_attribute10 IN VARCHAR2
109 ,x_attribute11 IN VARCHAR2
110 ,x_attribute12 IN VARCHAR2
111 ,x_attribute13 IN VARCHAR2
112 ,x_attribute14 IN VARCHAR2
113 ,x_attribute15 IN VARCHAR2
114 );
115
116
117 ------------------------------------------------------------------------
118 -- PROCEDURE : DELETE_ROW
119 ------------------------------------------------------------------------
120 PROCEDURE delete_row (
121 x_rowid IN VARCHAR2
122 );
123
124
125 ------------------------------------------------------------------------
126 -- PROCEDURE : check_unique_index_type
127 ------------------------------------------------------------------------
128 PROCEDURE check_unq_index_type (
129 x_return_status IN OUT NOCOPY VARCHAR2
130 ,x_index_id IN NUMBER
131 ,x_name IN VARCHAR2
132 );
133 END pn_index_history_headers_pkg;