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