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