[Home] [Help]
PACKAGE: APPS.OKL_CFP_PVT
Source
1 PACKAGE OKL_CFP_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSCFPS.pls 115.1 2003/10/16 02:37:11 sechawla noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_CF_OBJECT_PERIODS_V Record Spec
7 TYPE cfpv_rec_type IS RECORD (
8 id NUMBER := OKL_API.G_MISS_NUM
9 ,cfo_id NUMBER := OKL_API.G_MISS_NUM
10 ,ptp_code OKL_CF_OBJECT_PERIODS_V.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
11 ,start_date OKL_CF_OBJECT_PERIODS_V.START_DATE%TYPE := OKL_API.G_MISS_DATE
12 ,end_date OKL_CF_OBJECT_PERIODS_V.END_DATE%TYPE := OKL_API.G_MISS_CHAR
13 ,attribute_category OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
14 ,attribute1 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
15 ,attribute2 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
16 ,attribute3 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
17 ,attribute4 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
18 ,attribute5 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
19 ,attribute6 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
20 ,attribute7 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
21 ,attribute8 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
22 ,attribute9 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
23 ,attribute10 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
24 ,attribute11 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
25 ,attribute12 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
26 ,attribute13 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
27 ,attribute14 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
28 ,attribute15 OKL_CF_OBJECT_PERIODS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
29 ,created_by NUMBER := OKL_API.G_MISS_NUM
30 ,creation_date OKL_CF_OBJECT_PERIODS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
31 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
32 ,last_update_date OKL_CF_OBJECT_PERIODS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
33 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
34 ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
35 G_MISS_cfpv_rec cfpv_rec_type;
36 TYPE cfpv_tbl_type IS TABLE OF cfpv_rec_type
37 INDEX BY BINARY_INTEGER;
38 -- OKL_CF_OBJECT_PERIODS Record Spec
39 TYPE cfp_rec_type IS RECORD (
40 id NUMBER := OKL_API.G_MISS_NUM
41 ,cfo_id NUMBER := OKL_API.G_MISS_NUM
42 ,ptp_code OKL_CF_OBJECT_PERIODS.PTP_CODE%TYPE := OKL_API.G_MISS_CHAR
43 ,start_date OKL_CF_OBJECT_PERIODS.START_DATE%TYPE := OKL_API.G_MISS_DATE
44 ,end_date OKL_CF_OBJECT_PERIODS.END_DATE%TYPE := OKL_API.G_MISS_CHAR
45 ,attribute_category OKL_CF_OBJECT_PERIODS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
46 ,attribute1 OKL_CF_OBJECT_PERIODS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
47 ,attribute2 OKL_CF_OBJECT_PERIODS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
48 ,attribute3 OKL_CF_OBJECT_PERIODS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
49 ,attribute4 OKL_CF_OBJECT_PERIODS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
50 ,attribute5 OKL_CF_OBJECT_PERIODS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
51 ,attribute6 OKL_CF_OBJECT_PERIODS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
52 ,attribute7 OKL_CF_OBJECT_PERIODS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
53 ,attribute8 OKL_CF_OBJECT_PERIODS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
54 ,attribute9 OKL_CF_OBJECT_PERIODS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
55 ,attribute10 OKL_CF_OBJECT_PERIODS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
56 ,attribute11 OKL_CF_OBJECT_PERIODS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
57 ,attribute12 OKL_CF_OBJECT_PERIODS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
58 ,attribute13 OKL_CF_OBJECT_PERIODS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
59 ,attribute14 OKL_CF_OBJECT_PERIODS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
60 ,attribute15 OKL_CF_OBJECT_PERIODS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
61 ,created_by NUMBER := OKL_API.G_MISS_NUM
62 ,creation_date OKL_CF_OBJECT_PERIODS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
63 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
64 ,last_update_date OKL_CF_OBJECT_PERIODS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
65 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
66 ,object_version_number NUMBER := OKL_API.G_MISS_NUM);
67 G_MISS_cfp_rec cfp_rec_type;
68 TYPE cfp_tbl_type IS TABLE OF cfp_rec_type
69 INDEX BY BINARY_INTEGER;
70 ---------------------------------------------------------------------------
71 -- GLOBAL MESSAGE CONSTANTS
72 ---------------------------------------------------------------------------
73 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
74 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
75 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
76 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
77 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
78 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
79 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
80 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
81 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
82 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
83 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
84 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
85 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
86 -- SECHAWLA Added
87 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
88
89 ---------------------------------------------------------------------------
90 -- GLOBAL EXCEPTIONS
91 ---------------------------------------------------------------------------
92 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
93
94 ---------------------------------------------------------------------------
95 -- GLOBAL VARIABLES
96 ---------------------------------------------------------------------------
97 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CFP_PVT';
98 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
99 ---------------------------------------------------------------------------
100 -- Procedures and Functions
101 ---------------------------------------------------------------------------
102
103 PROCEDURE qc;
104 PROCEDURE change_version;
105 PROCEDURE api_copy;
106 PROCEDURE insert_row(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_cfpv_rec IN cfpv_rec_type,
113 x_cfpv_rec OUT NOCOPY cfpv_rec_type);
114 PROCEDURE insert_row(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_cfpv_tbl IN cfpv_tbl_type,
121 x_cfpv_tbl OUT NOCOPY cfpv_tbl_type,
122 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
123 PROCEDURE insert_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_cfpv_tbl IN cfpv_tbl_type,
130 x_cfpv_tbl OUT NOCOPY cfpv_tbl_type);
131 PROCEDURE lock_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_cfpv_rec IN cfpv_rec_type);
138 PROCEDURE lock_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_cfpv_tbl IN cfpv_tbl_type,
145 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
146 PROCEDURE lock_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_cfpv_tbl IN cfpv_tbl_type);
153 PROCEDURE update_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_cfpv_rec IN cfpv_rec_type,
160 x_cfpv_rec OUT NOCOPY cfpv_rec_type);
161 PROCEDURE update_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_cfpv_tbl IN cfpv_tbl_type,
168 x_cfpv_tbl OUT NOCOPY cfpv_tbl_type,
169 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
170 PROCEDURE update_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_cfpv_tbl IN cfpv_tbl_type,
177 x_cfpv_tbl OUT NOCOPY cfpv_tbl_type);
178 PROCEDURE delete_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_cfpv_rec IN cfpv_rec_type);
185 PROCEDURE delete_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_cfpv_tbl IN cfpv_tbl_type,
192 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
193 PROCEDURE delete_row(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_cfpv_tbl IN cfpv_tbl_type);
200 PROCEDURE validate_row(
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_cfpv_rec IN cfpv_rec_type);
207 PROCEDURE validate_row(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_cfpv_tbl IN cfpv_tbl_type,
214 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
215 PROCEDURE validate_row(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_cfpv_tbl IN cfpv_tbl_type);
222 END OKL_CFP_PVT;