[Home] [Help]
PACKAGE: APPS.OKL_KPL_PVT
Source
1 PACKAGE OKL_KPL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSKPLS.pls 120.0 2005/10/18 17:34:03 rpillay noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_K_PARTY_ROLES_V Record Spec
7 TYPE kplv_rec_type IS RECORD (
8 id NUMBER := OKL_API.G_MISS_NUM
9 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10 ,attribute_category OKL_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
11 ,attribute1 OKL_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
12 ,attribute2 OKL_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
13 ,attribute3 OKL_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
14 ,attribute4 OKL_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
15 ,attribute5 OKL_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
16 ,attribute6 OKL_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
17 ,attribute7 OKL_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
18 ,attribute8 OKL_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
19 ,attribute9 OKL_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
20 ,attribute10 OKL_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
21 ,attribute11 OKL_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
22 ,attribute12 OKL_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
23 ,attribute13 OKL_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
24 ,attribute14 OKL_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
25 ,attribute15 OKL_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
26 ,created_by NUMBER := OKL_API.G_MISS_NUM
27 ,creation_date OKL_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
28 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
29 ,last_update_date OKL_K_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
30 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
31 ,validate_dff_yn VARCHAR2(3) := OKL_API.G_MISS_CHAR);
32 G_MISS_kplv_rec kplv_rec_type;
33 TYPE kplv_tbl_type IS TABLE OF kplv_rec_type
34 INDEX BY BINARY_INTEGER;
35 -- OKL_K_PARTY_ROLES Record Spec
36 TYPE kpl_rec_type IS RECORD (
37 id NUMBER := OKL_API.G_MISS_NUM
38 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
39 ,attribute_category OKL_K_PARTY_ROLES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
40 ,attribute1 OKL_K_PARTY_ROLES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
41 ,attribute2 OKL_K_PARTY_ROLES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
42 ,attribute3 OKL_K_PARTY_ROLES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
43 ,attribute4 OKL_K_PARTY_ROLES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
44 ,attribute5 OKL_K_PARTY_ROLES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
45 ,attribute6 OKL_K_PARTY_ROLES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
46 ,attribute7 OKL_K_PARTY_ROLES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
47 ,attribute8 OKL_K_PARTY_ROLES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
48 ,attribute9 OKL_K_PARTY_ROLES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
49 ,attribute10 OKL_K_PARTY_ROLES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
50 ,attribute11 OKL_K_PARTY_ROLES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
51 ,attribute12 OKL_K_PARTY_ROLES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
52 ,attribute13 OKL_K_PARTY_ROLES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
53 ,attribute14 OKL_K_PARTY_ROLES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
54 ,attribute15 OKL_K_PARTY_ROLES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
55 ,created_by NUMBER := OKL_API.G_MISS_NUM
56 ,creation_date OKL_K_PARTY_ROLES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
57 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
58 ,last_update_date OKL_K_PARTY_ROLES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
59 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
60 G_MISS_kpl_rec kpl_rec_type;
61 TYPE kpl_tbl_type IS TABLE OF kpl_rec_type
62 INDEX BY BINARY_INTEGER;
63 ---------------------------------------------------------------------------
64 -- GLOBAL MESSAGE CONSTANTS
65 ---------------------------------------------------------------------------
66 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
67 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
68 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
69 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
70 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
71 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
72 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
73 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
74 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
75 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
76 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
77 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
78 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
79
80 ---------------------------------------------------------------------------
81 -- GLOBAL EXCEPTIONS
82 ---------------------------------------------------------------------------
83 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
84
85 ---------------------------------------------------------------------------
86 -- GLOBAL VARIABLES
87 ---------------------------------------------------------------------------
88 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_KPL_PVT';
89 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
90 ---------------------------------------------------------------------------
91 -- Procedures and Functions
92 ---------------------------------------------------------------------------
93
94 PROCEDURE qc;
95 PROCEDURE change_version;
96 PROCEDURE api_copy;
97 PROCEDURE insert_row(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_kplv_rec IN kplv_rec_type,
104 x_kplv_rec OUT NOCOPY kplv_rec_type);
105 PROCEDURE insert_row(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_kplv_tbl IN kplv_tbl_type,
112 x_kplv_tbl OUT NOCOPY kplv_tbl_type,
113 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
114 PROCEDURE insert_row(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_kplv_tbl IN kplv_tbl_type,
121 x_kplv_tbl OUT NOCOPY kplv_tbl_type);
122 PROCEDURE lock_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_kplv_rec IN kplv_rec_type);
129 PROCEDURE lock_row(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_kplv_tbl IN kplv_tbl_type,
136 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
137 PROCEDURE lock_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_kplv_tbl IN kplv_tbl_type);
144 PROCEDURE update_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_kplv_rec IN kplv_rec_type,
151 x_kplv_rec OUT NOCOPY kplv_rec_type);
152 PROCEDURE update_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_kplv_tbl IN kplv_tbl_type,
159 x_kplv_tbl OUT NOCOPY kplv_tbl_type,
160 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
161 PROCEDURE update_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_kplv_tbl IN kplv_tbl_type,
168 x_kplv_tbl OUT NOCOPY kplv_tbl_type);
169 PROCEDURE delete_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_kplv_rec IN kplv_rec_type);
176 PROCEDURE delete_row(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_kplv_tbl IN kplv_tbl_type,
183 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
184 PROCEDURE delete_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_kplv_tbl IN kplv_tbl_type);
191 PROCEDURE validate_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_kplv_rec IN kplv_rec_type);
198 PROCEDURE validate_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_kplv_tbl IN kplv_tbl_type,
205 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
206 PROCEDURE validate_row(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_kplv_tbl IN kplv_tbl_type);
213
214 FUNCTION create_version(
215 p_chr_id IN NUMBER,
216 p_major_version IN NUMBER) RETURN VARCHAR2;
217
218 FUNCTION restore_version(
219 p_chr_id IN NUMBER,
220 p_major_version IN NUMBER) RETURN VARCHAR2;
221
222 END OKL_KPL_PVT;