[Home] [Help]
PACKAGE: APPS.OKL_IDX_PVT
Source
1 Package OKL_IDX_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSIDXS.pls 115.6 2002/03/03 15:59:17 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE idx_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 name OKL_INDICES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9 idx_type OKL_INDICES.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
10 idx_frequency OKL_INDICES.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
11 object_version_number NUMBER := OKC_API.G_MISS_NUM,
12 description OKL_INDICES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13 program_id NUMBER := OKC_API.G_MISS_NUM,
14 request_id NUMBER := OKC_API.G_MISS_NUM,
15 program_application_id NUMBER := OKC_API.G_MISS_NUM,
16 program_update_date OKL_INDICES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17 attribute_category OKL_INDICES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
18 attribute1 OKL_INDICES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19 attribute2 OKL_INDICES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
20 attribute3 OKL_INDICES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
21 attribute4 OKL_INDICES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22 attribute5 OKL_INDICES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23 attribute6 OKL_INDICES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24 attribute7 OKL_INDICES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25 attribute8 OKL_INDICES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26 attribute9 OKL_INDICES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27 attribute10 OKL_INDICES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28 attribute11 OKL_INDICES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29 attribute12 OKL_INDICES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30 attribute13 OKL_INDICES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31 attribute14 OKL_INDICES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32 attribute15 OKL_INDICES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
33 created_by NUMBER := OKC_API.G_MISS_NUM,
34 creation_date OKL_INDICES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36 last_update_date OKL_INDICES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
37 last_update_login NUMBER := OKC_API.G_MISS_NUM);
38 g_miss_idx_rec idx_rec_type;
39 TYPE idx_tbl_type IS TABLE OF idx_rec_type
40 INDEX BY BINARY_INTEGER;
41 TYPE idxv_rec_type IS RECORD (
42 id NUMBER := OKC_API.G_MISS_NUM,
43 object_version_number NUMBER := OKC_API.G_MISS_NUM,
44 name OKL_INDICES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
45 description OKL_INDICES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
46 attribute_category OKL_INDICES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47 attribute1 OKL_INDICES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48 attribute2 OKL_INDICES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49 attribute3 OKL_INDICES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50 attribute4 OKL_INDICES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51 attribute5 OKL_INDICES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52 attribute6 OKL_INDICES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53 attribute7 OKL_INDICES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54 attribute8 OKL_INDICES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55 attribute9 OKL_INDICES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56 attribute10 OKL_INDICES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57 attribute11 OKL_INDICES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58 attribute12 OKL_INDICES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59 attribute13 OKL_INDICES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60 attribute14 OKL_INDICES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61 attribute15 OKL_INDICES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62 idx_type OKL_INDICES_V.IDX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63 idx_frequency OKL_INDICES_V.IDX_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR,
64 program_id NUMBER := OKC_API.G_MISS_NUM,
65 request_id NUMBER := OKC_API.G_MISS_NUM,
66 program_application_id NUMBER := OKC_API.G_MISS_NUM,
67 program_update_date OKL_INDICES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68 created_by NUMBER := OKC_API.G_MISS_NUM,
69 creation_date OKL_INDICES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71 last_update_date OKL_INDICES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72 last_update_login NUMBER := OKC_API.G_MISS_NUM);
73 g_miss_idxv_rec idxv_rec_type;
74 TYPE idxv_tbl_type IS TABLE OF idxv_rec_type
75 INDEX BY BINARY_INTEGER;
76 ---------------------------------------------------------------------------
77 -- GLOBAL MESSAGE CONSTANTS
78 ---------------------------------------------------------------------------
79 -- Added 04/20/2001 Robin Edwin for validate attribute
80
81 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
82 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
83 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
84 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
85
86 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96 ---------------------------------------------------------------------------
97 -- GLOBAL VARIABLES
98 ---------------------------------------------------------------------------
99 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IDX_PVT';
100 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
101 ---------------------------------------------------------------------------
102 -- Procedures and Functions
103 ---------------------------------------------------------------------------
104
105 PROCEDURE qc;
106 PROCEDURE change_version;
107 PROCEDURE api_copy;
108 PROCEDURE insert_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_idxv_rec IN idxv_rec_type,
115 x_idxv_rec OUT NOCOPY idxv_rec_type);
116
117 PROCEDURE insert_row(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_idxv_tbl IN idxv_tbl_type,
124 x_idxv_tbl OUT NOCOPY idxv_tbl_type);
125
126 PROCEDURE lock_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_idxv_rec IN idxv_rec_type);
133
134 PROCEDURE lock_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_idxv_tbl IN idxv_tbl_type);
141
142 PROCEDURE update_row(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_idxv_rec IN idxv_rec_type,
149 x_idxv_rec OUT NOCOPY idxv_rec_type);
150
151 PROCEDURE update_row(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_idxv_tbl IN idxv_tbl_type,
158 x_idxv_tbl OUT NOCOPY idxv_tbl_type);
159
160 PROCEDURE delete_row(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_idxv_rec IN idxv_rec_type);
167
168 PROCEDURE delete_row(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_idxv_tbl IN idxv_tbl_type);
175
176 PROCEDURE validate_row(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_idxv_rec IN idxv_rec_type);
183
184 PROCEDURE validate_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_idxv_tbl IN idxv_tbl_type);
191
192 END OKL_IDX_PVT;