[Home] [Help]
PACKAGE: APPS.OKS_CVT_PVT
Source
1 PACKAGE OKS_CVT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSCOVTS.pls 120.0 2005/05/25 17:57:03 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_COVERAGE_TIMES_V Record Spec
7 TYPE oks_coverage_times_v_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
10 ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
11 ,start_hour NUMBER := OKC_API.G_MISS_NUM
12 ,start_minute NUMBER := OKC_API.G_MISS_NUM
13 ,end_hour NUMBER := OKC_API.G_MISS_NUM
14 ,end_minute NUMBER := OKC_API.G_MISS_NUM
15 ,monday_yn OKS_COVERAGE_TIMES_V.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
16 ,tuesday_yn OKS_COVERAGE_TIMES_V.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
17 ,wednesday_yn OKS_COVERAGE_TIMES_V.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
18 ,thursday_yn OKS_COVERAGE_TIMES_V.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
19 ,friday_yn OKS_COVERAGE_TIMES_V.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
20 ,saturday_yn OKS_COVERAGE_TIMES_V.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
21 ,sunday_yn OKS_COVERAGE_TIMES_V.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
22 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
23 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
24 ,program_id NUMBER := OKC_API.G_MISS_NUM
25 ,program_update_date OKS_COVERAGE_TIMES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26 ,request_id NUMBER := OKC_API.G_MISS_NUM
27 ,created_by NUMBER := OKC_API.G_MISS_NUM
28 ,creation_date OKS_COVERAGE_TIMES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30 ,last_update_date OKS_COVERAGE_TIMES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32 ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
33 GMissOksCoverageTimesVRec oks_coverage_times_v_rec_type;
34 TYPE oks_coverage_times_v_tbl_type IS TABLE OF oks_coverage_times_v_rec_type
35 INDEX BY BINARY_INTEGER;
36 -- OKS_COVERAGE_TIMES Record Spec
37 TYPE oks_coverage_times_rec_type IS RECORD (
38 id NUMBER := OKC_API.G_MISS_NUM
39 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40 ,cov_tze_line_id NUMBER := OKC_API.G_MISS_NUM
41 ,start_hour NUMBER := OKC_API.G_MISS_NUM
42 ,start_minute NUMBER := OKC_API.G_MISS_NUM
43 ,end_hour NUMBER := OKC_API.G_MISS_NUM
44 ,end_minute NUMBER := OKC_API.G_MISS_NUM
45 ,monday_yn OKS_COVERAGE_TIMES.MONDAY_YN%TYPE := OKC_API.G_MISS_CHAR
46 ,tuesday_yn OKS_COVERAGE_TIMES.TUESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
47 ,wednesday_yn OKS_COVERAGE_TIMES.WEDNESDAY_YN%TYPE := OKC_API.G_MISS_CHAR
48 ,thursday_yn OKS_COVERAGE_TIMES.THURSDAY_YN%TYPE := OKC_API.G_MISS_CHAR
49 ,friday_yn OKS_COVERAGE_TIMES.FRIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
50 ,saturday_yn OKS_COVERAGE_TIMES.SATURDAY_YN%TYPE := OKC_API.G_MISS_CHAR
51 ,sunday_yn OKS_COVERAGE_TIMES.SUNDAY_YN%TYPE := OKC_API.G_MISS_CHAR
52 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
53 ,program_id NUMBER := OKC_API.G_MISS_NUM
54 ,program_update_date OKS_COVERAGE_TIMES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
55 ,request_id NUMBER := OKC_API.G_MISS_NUM
56 ,created_by NUMBER := OKC_API.G_MISS_NUM
57 ,creation_date OKS_COVERAGE_TIMES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59 ,last_update_date OKS_COVERAGE_TIMES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
61 ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
62 G_MISS_oks_coverage_times_rec oks_coverage_times_rec_type;
63 TYPE oks_coverage_times_tbl_type IS TABLE OF oks_coverage_times_rec_type
64 INDEX BY BINARY_INTEGER;
65 ---------------------------------------------------------------------------
66 -- GLOBAL MESSAGE CONSTANTS
67 ---------------------------------------------------------------------------
68 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
69 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
70 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
71 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
78 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
79 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
80 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
81
82 ---------------------------------------------------------------------------
83 -- GLOBAL EXCEPTIONS
84 ---------------------------------------------------------------------------
85 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
86
87 ---------------------------------------------------------------------------
88 -- GLOBAL VARIABLES
89 ---------------------------------------------------------------------------
90 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_CVT_PVT';
91 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
92 ---------------------------------------------------------------------------
93 -- Procedures and Functions
94 ---------------------------------------------------------------------------
95
96 PROCEDURE qc;
97 PROCEDURE change_version;
98 PROCEDURE api_copy;
99 PROCEDURE insert_row(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
106 x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type);
107 PROCEDURE insert_row(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
114 x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type,
115 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
116 PROCEDURE insert_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
123 x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type);
124 PROCEDURE lock_row(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_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_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
138 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
139 PROCEDURE lock_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type);
146 PROCEDURE update_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_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
153 x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type);
154 PROCEDURE update_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
161 x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type,
162 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
163 PROCEDURE update_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
170 x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type);
171 PROCEDURE delete_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_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_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
185 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
186 PROCEDURE delete_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type);
193 PROCEDURE validate_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_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_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_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
207 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
208 PROCEDURE validate_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type);
215
216
217 FUNCTION Create_Version(
218 p_id IN NUMBER,
219 p_major_version IN NUMBER) RETURN VARCHAR2;
220
221 FUNCTION restore_version(
222 p_id IN NUMBER,
223 p_major_version IN NUMBER) RETURN VARCHAR2;
224
225 END OKS_CVT_PVT;