[Home] [Help]
PACKAGE: APPS.OKL_CAU_PVT
Source
1 PACKAGE OKL_CAU_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSCAUS.pls 120.2 2006/07/11 10:13:15 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_CSH_ALLCTN_RL_HDR_V Record Spec
7 TYPE cauv_rec_type IS RECORD (
8 id NUMBER := OKL_API.G_MISS_NUM
9 ,name OKL_CSH_ALLCTN_RL_HDR.NAME%TYPE := OKL_API.G_MISS_CHAR
10 ,description OKL_CSH_ALLCTN_RL_HDR.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
11 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
12 ,attribute_category OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
13 ,attribute1 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
14 ,attribute2 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
15 ,attribute3 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
16 ,attribute4 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
17 ,attribute5 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
18 ,attribute6 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
19 ,attribute7 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
20 ,attribute8 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
21 ,attribute9 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
22 ,attribute10 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
23 ,attribute11 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
24 ,attribute12 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
25 ,attribute13 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
26 ,attribute14 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
27 ,attribute15 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
28 ,org_id NUMBER := OKL_API.G_MISS_NUM
29 ,created_by NUMBER := OKL_API.G_MISS_NUM
30 ,creation_date OKL_CSH_ALLCTN_RL_HDR.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
32 ,last_update_date OKL_CSH_ALLCTN_RL_HDR.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
34 G_MISS_cauv_rec cauv_rec_type;
35 TYPE cauv_tbl_type IS TABLE OF cauv_rec_type
36 INDEX BY BINARY_INTEGER;
37 -- OKL_CSH_ALLCTN_RL_HDR Record Spec
38 TYPE cau_rec_type IS RECORD (
39 id NUMBER := OKL_API.G_MISS_NUM
40 ,name OKL_CSH_ALLCTN_RL_HDR.NAME%TYPE := OKL_API.G_MISS_CHAR
41 ,description OKL_CSH_ALLCTN_RL_HDR.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
42 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
43 ,attribute_category OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
44 ,attribute1 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
45 ,attribute2 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
46 ,attribute3 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
47 ,attribute4 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
48 ,attribute5 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
49 ,attribute6 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
50 ,attribute7 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
51 ,attribute8 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
52 ,attribute9 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
53 ,attribute10 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
54 ,attribute11 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
55 ,attribute12 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
56 ,attribute13 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
57 ,attribute14 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
58 ,attribute15 OKL_CSH_ALLCTN_RL_HDR.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
59 ,org_id NUMBER := OKL_API.G_MISS_NUM
60 ,created_by NUMBER := OKL_API.G_MISS_NUM
61 ,creation_date OKL_CSH_ALLCTN_RL_HDR.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
62 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
63 ,last_update_date OKL_CSH_ALLCTN_RL_HDR.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
64 ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
65 G_MISS_cau_rec cau_rec_type;
66 TYPE cau_tbl_type IS TABLE OF cau_rec_type
67 INDEX BY BINARY_INTEGER;
68 ---------------------------------------------------------------------------
69 -- GLOBAL MESSAGE CONSTANTS
70 ---------------------------------------------------------------------------
71 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
72 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
73 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
74 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
75 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
76 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
77 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
78 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
79 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
80 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
81 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
82 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
83 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
84 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
85
86 ---------------------------------------------------------------------------
87 -- GLOBAL EXCEPTIONS
88 ---------------------------------------------------------------------------
89 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
90
91 ---------------------------------------------------------------------------
92 -- GLOBAL VARIABLES
93 ---------------------------------------------------------------------------
94 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CAU_PVT';
95 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
96 g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
97 ---------------------------------------------------------------------------
98 -- Procedures and Functions
99 ---------------------------------------------------------------------------
100
101 PROCEDURE qc;
102 PROCEDURE change_version;
103 PROCEDURE api_copy;
104 PROCEDURE insert_row(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_cauv_rec IN cauv_rec_type,
111 x_cauv_rec OUT NOCOPY cauv_rec_type);
112 PROCEDURE insert_row(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_cauv_tbl IN cauv_tbl_type,
119 x_cauv_tbl OUT NOCOPY cauv_tbl_type,
120 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
121 PROCEDURE insert_row(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_cauv_tbl IN cauv_tbl_type,
128 x_cauv_tbl OUT NOCOPY cauv_tbl_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_cauv_rec IN cauv_rec_type);
136 PROCEDURE lock_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_cauv_tbl IN cauv_tbl_type,
143 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
144 PROCEDURE lock_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_cauv_tbl IN cauv_tbl_type);
151 PROCEDURE update_row(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cauv_rec IN cauv_rec_type,
158 x_cauv_rec OUT NOCOPY cauv_rec_type);
159 PROCEDURE update_row(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_cauv_tbl IN cauv_tbl_type,
166 x_cauv_tbl OUT NOCOPY cauv_tbl_type,
167 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
168 PROCEDURE update_row(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cauv_tbl IN cauv_tbl_type,
175 x_cauv_tbl OUT NOCOPY cauv_tbl_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_cauv_rec IN cauv_rec_type);
183 PROCEDURE delete_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_cauv_tbl IN cauv_tbl_type,
190 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
191 PROCEDURE delete_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_cauv_tbl IN cauv_tbl_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_cauv_rec IN cauv_rec_type);
205 PROCEDURE validate_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_cauv_tbl IN cauv_tbl_type,
212 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
213 PROCEDURE validate_row(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_cauv_tbl IN cauv_tbl_type);
220 END OKL_CAU_PVT;