1 PACKAGE pn_index_lease_constraints_pkg AS
2 -- $Header: PNTINLCS.pls 120.1 2005/07/26 07:03:47 appldev 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
12 | PN_INDEX_LEASE_CONSTRAINTS table.
13 | They include:
14 | INSERT_ROW - insert a row into PN_INDEX_LEASE_CONSTRAINTS.
15 | DELETE_ROW - deletes a row from PN_INDEX_LEASE_CONSTRAINTS.
16 | UPDATE_ROW - updates a row from PN_INDEX_LEASE_CONSTRAINTS.
17 | LOCKS_ROW - will check if a row has been modified since being
18 | queried by form.
19 |
20 |
21 | HISTORY
22 | 11-APR-2001 jbreyes o Created
23 | 13-DEC-2001 Mrinal o Added dbdrv command.
24 | 09-JUL-2002 ftanudja o added x_org_id param in insert_row for
25 | shared serv. enh.
26 | 05-Jul-2005 hrodda o overloaded delete_row proc to take PK as parameter
27 +============================================================================*/
28
29
30 /**** SPECIFICATIONS ****/
31
32
33 -----------------------------------------------------------------------
34 -- PROCEDURE : INSERT_ROW
35 ------------------------------------------------------------------------
36 PROCEDURE insert_row (
37 x_rowid IN OUT NOCOPY VARCHAR2
38 ,x_org_id IN NUMBER DEFAULT NULL
39 ,x_index_constraint_id IN OUT NOCOPY NUMBER
40 ,x_index_lease_id IN NUMBER
41 ,x_scope IN VARCHAR2
42 ,x_last_update_date IN DATE
43 ,x_last_updated_by IN NUMBER
44 ,x_creation_date IN DATE
45 ,x_created_by IN NUMBER
46 ,x_minimum_amount IN NUMBER
47 ,x_maximum_amount IN NUMBER
48 ,x_minimum_percent IN NUMBER
49 ,x_maximum_percent IN NUMBER
50 ,x_last_update_login IN NUMBER
51 ,x_attribute_category IN VARCHAR2
52 ,x_attribute1 IN VARCHAR2
53 ,x_attribute2 IN VARCHAR2
54 ,x_attribute3 IN VARCHAR2
55 ,x_attribute4 IN VARCHAR2
56 ,x_attribute5 IN VARCHAR2
57 ,x_attribute6 IN VARCHAR2
58 ,x_attribute7 IN VARCHAR2
59 ,x_attribute8 IN VARCHAR2
60 ,x_attribute9 IN VARCHAR2
61 ,x_attribute10 IN VARCHAR2
62 ,x_attribute11 IN VARCHAR2
63 ,x_attribute12 IN VARCHAR2
64 ,x_attribute13 IN VARCHAR2
65 ,x_attribute14 IN VARCHAR2
66 ,x_attribute15 IN VARCHAR2
67 );
68
69
70 ------------------------------------------------------------------------
71 -- PROCEDURE : UPDATE_ROW
72 ------------------------------------------------------------------------
73 PROCEDURE update_row (
74 x_rowid IN VARCHAR2
75 ,x_index_constraint_id IN NUMBER
76 ,x_index_lease_id IN NUMBER
77 ,x_scope IN VARCHAR2
78 ,x_last_update_date IN DATE
79 ,x_last_updated_by IN NUMBER
80 ,x_minimum_amount IN NUMBER
81 ,x_maximum_amount IN NUMBER
82 ,x_minimum_percent IN NUMBER
83 ,x_maximum_percent IN NUMBER
84 ,x_last_update_login IN NUMBER
85 ,x_attribute_category IN VARCHAR2
86 ,x_attribute1 IN VARCHAR2
87 ,x_attribute2 IN VARCHAR2
88 ,x_attribute3 IN VARCHAR2
89 ,x_attribute4 IN VARCHAR2
90 ,x_attribute5 IN VARCHAR2
91 ,x_attribute6 IN VARCHAR2
92 ,x_attribute7 IN VARCHAR2
93 ,x_attribute8 IN VARCHAR2
94 ,x_attribute9 IN VARCHAR2
95 ,x_attribute10 IN VARCHAR2
96 ,x_attribute11 IN VARCHAR2
97 ,x_attribute12 IN VARCHAR2
98 ,x_attribute13 IN VARCHAR2
99 ,x_attribute14 IN VARCHAR2
100 ,x_attribute15 IN VARCHAR2
101 );
102
103
104 ------------------------------------------------------------------------
105 -- PROCEDURE : LOCK_ROW
106 ------------------------------------------------------------------------
107 PROCEDURE lock_row (
108 x_rowid IN VARCHAR2
109 ,x_index_constraint_id IN NUMBER
110 ,x_index_lease_id IN NUMBER
111 ,x_scope IN VARCHAR2
112 ,x_minimum_amount IN NUMBER
113 ,x_maximum_amount IN NUMBER
114 ,x_minimum_percent IN NUMBER
115 ,x_maximum_percent IN NUMBER
116 ,x_attribute_category IN VARCHAR2
117 ,x_attribute1 IN VARCHAR2
118 ,x_attribute2 IN VARCHAR2
119 ,x_attribute3 IN VARCHAR2
120 ,x_attribute4 IN VARCHAR2
121 ,x_attribute5 IN VARCHAR2
122 ,x_attribute6 IN VARCHAR2
123 ,x_attribute7 IN VARCHAR2
124 ,x_attribute8 IN VARCHAR2
125 ,x_attribute9 IN VARCHAR2
126 ,x_attribute10 IN VARCHAR2
127 ,x_attribute11 IN VARCHAR2
128 ,x_attribute12 IN VARCHAR2
129 ,x_attribute13 IN VARCHAR2
130 ,x_attribute14 IN VARCHAR2
131 ,x_attribute15 IN VARCHAR2
132 );
133
134
135 -------------------------------------------------------------------------------
136 -- PROCEDURE : DELETE_ROW
137 -------------------------------------------------------------------------------
138 PROCEDURE delete_row (
139 x_rowid IN VARCHAR2
140 );
141
142 -------------------------------------------------------------------------------
143 -- PROCDURE : delete_row
144 -- INVOKED FROM : delete_row procedure
145 -- PURPOSE : deletes the row
146 -- NOTE : overrided delete_row procedure to take PK as in parameter
147 -- HISTORY :
148 -- 04-JUL-05 hrodda o Created.
149 -------------------------------------------------------------------------------
150 PROCEDURE delete_row (
151 x_index_constraint_id IN NUMBER
152 );
153
154
155 ----------------------------------------------------------------------------
156 -- PROCEDURE : create_check_unique_constraint_scope
157 -------------------------------------------------------------------------------
158 PROCEDURE check_unq_constraint_scope (
159 x_return_status IN OUT NOCOPY VARCHAR2
160 ,x_index_constraint_id IN NUMBER
161 ,x_index_lease_id IN NUMBER
162 ,x_scope IN VARCHAR2
163 );
164 END;