90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_COVERAGE_TIMEZONES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
98: x_no_data_found OUT NOCOPY BOOLEAN
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_COVERAGE_TIMEZONES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN OksCoverageTimezonesVRecType IS
100: CURSOR oks_ctzv_pk_csr (p_id IN NUMBER) IS
101: SELECT
119: ORIG_SYSTEM_ID1,
120: ORIG_SYSTEM_REFERENCE1,
121: ORIG_SYSTEM_SOURCE_CODE
122: -- R12 Data Model Changes 4485150 End
123: FROM Oks_Coverage_Timezones_V
124: WHERE oks_coverage_timezones_v.id = p_id;
125: l_oks_ctzv_pk oks_ctzv_pk_csr%ROWTYPE;
126: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType;
127: BEGIN
120: ORIG_SYSTEM_REFERENCE1,
121: ORIG_SYSTEM_SOURCE_CODE
122: -- R12 Data Model Changes 4485150 End
123: FROM Oks_Coverage_Timezones_V
124: WHERE oks_coverage_timezones_v.id = p_id;
125: l_oks_ctzv_pk oks_ctzv_pk_csr%ROWTYPE;
126: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType;
127: BEGIN
128: x_no_data_found := TRUE;
122: -- R12 Data Model Changes 4485150 End
123: FROM Oks_Coverage_Timezones_V
124: WHERE oks_coverage_timezones_v.id = p_id;
125: l_oks_ctzv_pk oks_ctzv_pk_csr%ROWTYPE;
126: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType;
127: BEGIN
128: x_no_data_found := TRUE;
129: -- Get current database values
130: OPEN oks_ctzv_pk_csr (p_oks_coverage_timezones_v_rec.id);
126: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType;
127: BEGIN
128: x_no_data_found := TRUE;
129: -- Get current database values
130: OPEN oks_ctzv_pk_csr (p_oks_coverage_timezones_v_rec.id);
131: FETCH oks_ctzv_pk_csr INTO
132: l_oks_coverage_timezones_v_rec.id,
133: l_oks_coverage_timezones_v_rec.cle_id,
134: l_oks_coverage_timezones_v_rec.default_yn,
128: x_no_data_found := TRUE;
129: -- Get current database values
130: OPEN oks_ctzv_pk_csr (p_oks_coverage_timezones_v_rec.id);
131: FETCH oks_ctzv_pk_csr INTO
132: l_oks_coverage_timezones_v_rec.id,
133: l_oks_coverage_timezones_v_rec.cle_id,
134: l_oks_coverage_timezones_v_rec.default_yn,
135: l_oks_coverage_timezones_v_rec.timezone_id,
136: l_oks_coverage_timezones_v_rec.dnz_chr_id,
129: -- Get current database values
130: OPEN oks_ctzv_pk_csr (p_oks_coverage_timezones_v_rec.id);
131: FETCH oks_ctzv_pk_csr INTO
132: l_oks_coverage_timezones_v_rec.id,
133: l_oks_coverage_timezones_v_rec.cle_id,
134: l_oks_coverage_timezones_v_rec.default_yn,
135: l_oks_coverage_timezones_v_rec.timezone_id,
136: l_oks_coverage_timezones_v_rec.dnz_chr_id,
137: l_oks_coverage_timezones_v_rec.security_group_id,
130: OPEN oks_ctzv_pk_csr (p_oks_coverage_timezones_v_rec.id);
131: FETCH oks_ctzv_pk_csr INTO
132: l_oks_coverage_timezones_v_rec.id,
133: l_oks_coverage_timezones_v_rec.cle_id,
134: l_oks_coverage_timezones_v_rec.default_yn,
135: l_oks_coverage_timezones_v_rec.timezone_id,
136: l_oks_coverage_timezones_v_rec.dnz_chr_id,
137: l_oks_coverage_timezones_v_rec.security_group_id,
138: l_oks_coverage_timezones_v_rec.program_application_id,
131: FETCH oks_ctzv_pk_csr INTO
132: l_oks_coverage_timezones_v_rec.id,
133: l_oks_coverage_timezones_v_rec.cle_id,
134: l_oks_coverage_timezones_v_rec.default_yn,
135: l_oks_coverage_timezones_v_rec.timezone_id,
136: l_oks_coverage_timezones_v_rec.dnz_chr_id,
137: l_oks_coverage_timezones_v_rec.security_group_id,
138: l_oks_coverage_timezones_v_rec.program_application_id,
139: l_oks_coverage_timezones_v_rec.program_id,
132: l_oks_coverage_timezones_v_rec.id,
133: l_oks_coverage_timezones_v_rec.cle_id,
134: l_oks_coverage_timezones_v_rec.default_yn,
135: l_oks_coverage_timezones_v_rec.timezone_id,
136: l_oks_coverage_timezones_v_rec.dnz_chr_id,
137: l_oks_coverage_timezones_v_rec.security_group_id,
138: l_oks_coverage_timezones_v_rec.program_application_id,
139: l_oks_coverage_timezones_v_rec.program_id,
140: l_oks_coverage_timezones_v_rec.program_update_date,
133: l_oks_coverage_timezones_v_rec.cle_id,
134: l_oks_coverage_timezones_v_rec.default_yn,
135: l_oks_coverage_timezones_v_rec.timezone_id,
136: l_oks_coverage_timezones_v_rec.dnz_chr_id,
137: l_oks_coverage_timezones_v_rec.security_group_id,
138: l_oks_coverage_timezones_v_rec.program_application_id,
139: l_oks_coverage_timezones_v_rec.program_id,
140: l_oks_coverage_timezones_v_rec.program_update_date,
141: l_oks_coverage_timezones_v_rec.request_id,
134: l_oks_coverage_timezones_v_rec.default_yn,
135: l_oks_coverage_timezones_v_rec.timezone_id,
136: l_oks_coverage_timezones_v_rec.dnz_chr_id,
137: l_oks_coverage_timezones_v_rec.security_group_id,
138: l_oks_coverage_timezones_v_rec.program_application_id,
139: l_oks_coverage_timezones_v_rec.program_id,
140: l_oks_coverage_timezones_v_rec.program_update_date,
141: l_oks_coverage_timezones_v_rec.request_id,
142: l_oks_coverage_timezones_v_rec.created_by,
135: l_oks_coverage_timezones_v_rec.timezone_id,
136: l_oks_coverage_timezones_v_rec.dnz_chr_id,
137: l_oks_coverage_timezones_v_rec.security_group_id,
138: l_oks_coverage_timezones_v_rec.program_application_id,
139: l_oks_coverage_timezones_v_rec.program_id,
140: l_oks_coverage_timezones_v_rec.program_update_date,
141: l_oks_coverage_timezones_v_rec.request_id,
142: l_oks_coverage_timezones_v_rec.created_by,
143: l_oks_coverage_timezones_v_rec.creation_date,
136: l_oks_coverage_timezones_v_rec.dnz_chr_id,
137: l_oks_coverage_timezones_v_rec.security_group_id,
138: l_oks_coverage_timezones_v_rec.program_application_id,
139: l_oks_coverage_timezones_v_rec.program_id,
140: l_oks_coverage_timezones_v_rec.program_update_date,
141: l_oks_coverage_timezones_v_rec.request_id,
142: l_oks_coverage_timezones_v_rec.created_by,
143: l_oks_coverage_timezones_v_rec.creation_date,
144: l_oks_coverage_timezones_v_rec.last_updated_by,
137: l_oks_coverage_timezones_v_rec.security_group_id,
138: l_oks_coverage_timezones_v_rec.program_application_id,
139: l_oks_coverage_timezones_v_rec.program_id,
140: l_oks_coverage_timezones_v_rec.program_update_date,
141: l_oks_coverage_timezones_v_rec.request_id,
142: l_oks_coverage_timezones_v_rec.created_by,
143: l_oks_coverage_timezones_v_rec.creation_date,
144: l_oks_coverage_timezones_v_rec.last_updated_by,
145: l_oks_coverage_timezones_v_rec.last_update_date,
138: l_oks_coverage_timezones_v_rec.program_application_id,
139: l_oks_coverage_timezones_v_rec.program_id,
140: l_oks_coverage_timezones_v_rec.program_update_date,
141: l_oks_coverage_timezones_v_rec.request_id,
142: l_oks_coverage_timezones_v_rec.created_by,
143: l_oks_coverage_timezones_v_rec.creation_date,
144: l_oks_coverage_timezones_v_rec.last_updated_by,
145: l_oks_coverage_timezones_v_rec.last_update_date,
146: l_oks_coverage_timezones_v_rec.last_update_login,
139: l_oks_coverage_timezones_v_rec.program_id,
140: l_oks_coverage_timezones_v_rec.program_update_date,
141: l_oks_coverage_timezones_v_rec.request_id,
142: l_oks_coverage_timezones_v_rec.created_by,
143: l_oks_coverage_timezones_v_rec.creation_date,
144: l_oks_coverage_timezones_v_rec.last_updated_by,
145: l_oks_coverage_timezones_v_rec.last_update_date,
146: l_oks_coverage_timezones_v_rec.last_update_login,
147: l_oks_coverage_timezones_v_rec.object_version_number,
140: l_oks_coverage_timezones_v_rec.program_update_date,
141: l_oks_coverage_timezones_v_rec.request_id,
142: l_oks_coverage_timezones_v_rec.created_by,
143: l_oks_coverage_timezones_v_rec.creation_date,
144: l_oks_coverage_timezones_v_rec.last_updated_by,
145: l_oks_coverage_timezones_v_rec.last_update_date,
146: l_oks_coverage_timezones_v_rec.last_update_login,
147: l_oks_coverage_timezones_v_rec.object_version_number,
148: -- R12 Data Model Changes 4485150 Start
141: l_oks_coverage_timezones_v_rec.request_id,
142: l_oks_coverage_timezones_v_rec.created_by,
143: l_oks_coverage_timezones_v_rec.creation_date,
144: l_oks_coverage_timezones_v_rec.last_updated_by,
145: l_oks_coverage_timezones_v_rec.last_update_date,
146: l_oks_coverage_timezones_v_rec.last_update_login,
147: l_oks_coverage_timezones_v_rec.object_version_number,
148: -- R12 Data Model Changes 4485150 Start
149: l_oks_coverage_timezones_v_rec.orig_system_id1,
142: l_oks_coverage_timezones_v_rec.created_by,
143: l_oks_coverage_timezones_v_rec.creation_date,
144: l_oks_coverage_timezones_v_rec.last_updated_by,
145: l_oks_coverage_timezones_v_rec.last_update_date,
146: l_oks_coverage_timezones_v_rec.last_update_login,
147: l_oks_coverage_timezones_v_rec.object_version_number,
148: -- R12 Data Model Changes 4485150 Start
149: l_oks_coverage_timezones_v_rec.orig_system_id1,
150: l_oks_coverage_timezones_v_rec.orig_system_reference1,
143: l_oks_coverage_timezones_v_rec.creation_date,
144: l_oks_coverage_timezones_v_rec.last_updated_by,
145: l_oks_coverage_timezones_v_rec.last_update_date,
146: l_oks_coverage_timezones_v_rec.last_update_login,
147: l_oks_coverage_timezones_v_rec.object_version_number,
148: -- R12 Data Model Changes 4485150 Start
149: l_oks_coverage_timezones_v_rec.orig_system_id1,
150: l_oks_coverage_timezones_v_rec.orig_system_reference1,
151: l_oks_coverage_timezones_v_rec.orig_system_source_code
145: l_oks_coverage_timezones_v_rec.last_update_date,
146: l_oks_coverage_timezones_v_rec.last_update_login,
147: l_oks_coverage_timezones_v_rec.object_version_number,
148: -- R12 Data Model Changes 4485150 Start
149: l_oks_coverage_timezones_v_rec.orig_system_id1,
150: l_oks_coverage_timezones_v_rec.orig_system_reference1,
151: l_oks_coverage_timezones_v_rec.orig_system_source_code
152: -- R12 Data Model Changes 4485150 End
153: ;
146: l_oks_coverage_timezones_v_rec.last_update_login,
147: l_oks_coverage_timezones_v_rec.object_version_number,
148: -- R12 Data Model Changes 4485150 Start
149: l_oks_coverage_timezones_v_rec.orig_system_id1,
150: l_oks_coverage_timezones_v_rec.orig_system_reference1,
151: l_oks_coverage_timezones_v_rec.orig_system_source_code
152: -- R12 Data Model Changes 4485150 End
153: ;
154: x_no_data_found := oks_ctzv_pk_csr%NOTFOUND;
147: l_oks_coverage_timezones_v_rec.object_version_number,
148: -- R12 Data Model Changes 4485150 Start
149: l_oks_coverage_timezones_v_rec.orig_system_id1,
150: l_oks_coverage_timezones_v_rec.orig_system_reference1,
151: l_oks_coverage_timezones_v_rec.orig_system_source_code
152: -- R12 Data Model Changes 4485150 End
153: ;
154: x_no_data_found := oks_ctzv_pk_csr%NOTFOUND;
155: CLOSE oks_ctzv_pk_csr;
152: -- R12 Data Model Changes 4485150 End
153: ;
154: x_no_data_found := oks_ctzv_pk_csr%NOTFOUND;
155: CLOSE oks_ctzv_pk_csr;
156: RETURN(l_oks_coverage_timezones_v_rec);
157: END get_rec;
158:
159: ------------------------------------------------------------------
160: -- This version of get_rec sets error messages if no data found --
159: ------------------------------------------------------------------
160: -- This version of get_rec sets error messages if no data found --
161: ------------------------------------------------------------------
162: FUNCTION get_rec (
163: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
164: x_return_status OUT NOCOPY VARCHAR2
165: ) RETURN OksCoverageTimezonesVRecType IS
166: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType;
167: l_row_notfound BOOLEAN := TRUE;
162: FUNCTION get_rec (
163: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
164: x_return_status OUT NOCOPY VARCHAR2
165: ) RETURN OksCoverageTimezonesVRecType IS
166: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType;
167: l_row_notfound BOOLEAN := TRUE;
168: BEGIN
169: x_return_status := OKC_API.G_RET_STS_SUCCESS;
170: l_oks_coverage_timezones_v_rec := get_rec(p_oks_coverage_timezones_v_rec, l_row_notfound);
166: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType;
167: l_row_notfound BOOLEAN := TRUE;
168: BEGIN
169: x_return_status := OKC_API.G_RET_STS_SUCCESS;
170: l_oks_coverage_timezones_v_rec := get_rec(p_oks_coverage_timezones_v_rec, l_row_notfound);
171: IF (l_row_notfound) THEN
172: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
173: x_return_status := OKC_API.G_RET_STS_ERROR;
174: END IF;
171: IF (l_row_notfound) THEN
172: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
173: x_return_status := OKC_API.G_RET_STS_ERROR;
174: END IF;
175: RETURN(l_oks_coverage_timezones_v_rec);
176: END get_rec;
177: -----------------------------------------------------------
178: -- So we don't have to pass an "l_row_notfound" variable --
179: -----------------------------------------------------------
177: -----------------------------------------------------------
178: -- So we don't have to pass an "l_row_notfound" variable --
179: -----------------------------------------------------------
180: FUNCTION get_rec (
181: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
182: ) RETURN OksCoverageTimezonesVRecType IS
183: l_row_not_found BOOLEAN := TRUE;
184: BEGIN
185: RETURN(get_rec(p_oks_coverage_timezones_v_rec, l_row_not_found));
181: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
182: ) RETURN OksCoverageTimezonesVRecType IS
183: l_row_not_found BOOLEAN := TRUE;
184: BEGIN
185: RETURN(get_rec(p_oks_coverage_timezones_v_rec, l_row_not_found));
186: END get_rec;
187: ---------------------------------------------------------------------------
188: -- FUNCTION get_rec for: OKS_COVERAGE_TIMEZONES
189: ---------------------------------------------------------------------------
184: BEGIN
185: RETURN(get_rec(p_oks_coverage_timezones_v_rec, l_row_not_found));
186: END get_rec;
187: ---------------------------------------------------------------------------
188: -- FUNCTION get_rec for: OKS_COVERAGE_TIMEZONES
189: ---------------------------------------------------------------------------
190: FUNCTION get_rec (
191: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
192: x_no_data_found OUT NOCOPY BOOLEAN
187: ---------------------------------------------------------------------------
188: -- FUNCTION get_rec for: OKS_COVERAGE_TIMEZONES
189: ---------------------------------------------------------------------------
190: FUNCTION get_rec (
191: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
192: x_no_data_found OUT NOCOPY BOOLEAN
193: ) RETURN OksCoverageTimezonesRecType IS
194: CURSOR oks_ctz_pk_csr (p_id IN NUMBER) IS
195: SELECT
212: ORIG_SYSTEM_ID1,
213: ORIG_SYSTEM_REFERENCE1,
214: ORIG_SYSTEM_SOURCE_CODE
215: -- R12 Data Model Changes 4485150 End
216: FROM Oks_Coverage_Timezones
217: WHERE oks_coverage_timezones.id = p_id;
218: l_oks_ctz_pk oks_ctz_pk_csr%ROWTYPE;
219: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
220: BEGIN
213: ORIG_SYSTEM_REFERENCE1,
214: ORIG_SYSTEM_SOURCE_CODE
215: -- R12 Data Model Changes 4485150 End
216: FROM Oks_Coverage_Timezones
217: WHERE oks_coverage_timezones.id = p_id;
218: l_oks_ctz_pk oks_ctz_pk_csr%ROWTYPE;
219: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
220: BEGIN
221: x_no_data_found := TRUE;
215: -- R12 Data Model Changes 4485150 End
216: FROM Oks_Coverage_Timezones
217: WHERE oks_coverage_timezones.id = p_id;
218: l_oks_ctz_pk oks_ctz_pk_csr%ROWTYPE;
219: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
220: BEGIN
221: x_no_data_found := TRUE;
222: -- Get current database values
223: OPEN oks_ctz_pk_csr (p_oks_coverage_timezones_rec.id);
219: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
220: BEGIN
221: x_no_data_found := TRUE;
222: -- Get current database values
223: OPEN oks_ctz_pk_csr (p_oks_coverage_timezones_rec.id);
224: FETCH oks_ctz_pk_csr INTO
225: l_oks_coverage_timezones_rec.id,
226: l_oks_coverage_timezones_rec.cle_id,
227: l_oks_coverage_timezones_rec.default_yn,
221: x_no_data_found := TRUE;
222: -- Get current database values
223: OPEN oks_ctz_pk_csr (p_oks_coverage_timezones_rec.id);
224: FETCH oks_ctz_pk_csr INTO
225: l_oks_coverage_timezones_rec.id,
226: l_oks_coverage_timezones_rec.cle_id,
227: l_oks_coverage_timezones_rec.default_yn,
228: l_oks_coverage_timezones_rec.timezone_id,
229: l_oks_coverage_timezones_rec.dnz_chr_id,
222: -- Get current database values
223: OPEN oks_ctz_pk_csr (p_oks_coverage_timezones_rec.id);
224: FETCH oks_ctz_pk_csr INTO
225: l_oks_coverage_timezones_rec.id,
226: l_oks_coverage_timezones_rec.cle_id,
227: l_oks_coverage_timezones_rec.default_yn,
228: l_oks_coverage_timezones_rec.timezone_id,
229: l_oks_coverage_timezones_rec.dnz_chr_id,
230: l_oks_coverage_timezones_rec.program_application_id,
223: OPEN oks_ctz_pk_csr (p_oks_coverage_timezones_rec.id);
224: FETCH oks_ctz_pk_csr INTO
225: l_oks_coverage_timezones_rec.id,
226: l_oks_coverage_timezones_rec.cle_id,
227: l_oks_coverage_timezones_rec.default_yn,
228: l_oks_coverage_timezones_rec.timezone_id,
229: l_oks_coverage_timezones_rec.dnz_chr_id,
230: l_oks_coverage_timezones_rec.program_application_id,
231: l_oks_coverage_timezones_rec.program_id,
224: FETCH oks_ctz_pk_csr INTO
225: l_oks_coverage_timezones_rec.id,
226: l_oks_coverage_timezones_rec.cle_id,
227: l_oks_coverage_timezones_rec.default_yn,
228: l_oks_coverage_timezones_rec.timezone_id,
229: l_oks_coverage_timezones_rec.dnz_chr_id,
230: l_oks_coverage_timezones_rec.program_application_id,
231: l_oks_coverage_timezones_rec.program_id,
232: l_oks_coverage_timezones_rec.program_update_date,
225: l_oks_coverage_timezones_rec.id,
226: l_oks_coverage_timezones_rec.cle_id,
227: l_oks_coverage_timezones_rec.default_yn,
228: l_oks_coverage_timezones_rec.timezone_id,
229: l_oks_coverage_timezones_rec.dnz_chr_id,
230: l_oks_coverage_timezones_rec.program_application_id,
231: l_oks_coverage_timezones_rec.program_id,
232: l_oks_coverage_timezones_rec.program_update_date,
233: l_oks_coverage_timezones_rec.request_id,
226: l_oks_coverage_timezones_rec.cle_id,
227: l_oks_coverage_timezones_rec.default_yn,
228: l_oks_coverage_timezones_rec.timezone_id,
229: l_oks_coverage_timezones_rec.dnz_chr_id,
230: l_oks_coverage_timezones_rec.program_application_id,
231: l_oks_coverage_timezones_rec.program_id,
232: l_oks_coverage_timezones_rec.program_update_date,
233: l_oks_coverage_timezones_rec.request_id,
234: l_oks_coverage_timezones_rec.created_by,
227: l_oks_coverage_timezones_rec.default_yn,
228: l_oks_coverage_timezones_rec.timezone_id,
229: l_oks_coverage_timezones_rec.dnz_chr_id,
230: l_oks_coverage_timezones_rec.program_application_id,
231: l_oks_coverage_timezones_rec.program_id,
232: l_oks_coverage_timezones_rec.program_update_date,
233: l_oks_coverage_timezones_rec.request_id,
234: l_oks_coverage_timezones_rec.created_by,
235: l_oks_coverage_timezones_rec.creation_date,
228: l_oks_coverage_timezones_rec.timezone_id,
229: l_oks_coverage_timezones_rec.dnz_chr_id,
230: l_oks_coverage_timezones_rec.program_application_id,
231: l_oks_coverage_timezones_rec.program_id,
232: l_oks_coverage_timezones_rec.program_update_date,
233: l_oks_coverage_timezones_rec.request_id,
234: l_oks_coverage_timezones_rec.created_by,
235: l_oks_coverage_timezones_rec.creation_date,
236: l_oks_coverage_timezones_rec.last_updated_by,
229: l_oks_coverage_timezones_rec.dnz_chr_id,
230: l_oks_coverage_timezones_rec.program_application_id,
231: l_oks_coverage_timezones_rec.program_id,
232: l_oks_coverage_timezones_rec.program_update_date,
233: l_oks_coverage_timezones_rec.request_id,
234: l_oks_coverage_timezones_rec.created_by,
235: l_oks_coverage_timezones_rec.creation_date,
236: l_oks_coverage_timezones_rec.last_updated_by,
237: l_oks_coverage_timezones_rec.last_update_date,
230: l_oks_coverage_timezones_rec.program_application_id,
231: l_oks_coverage_timezones_rec.program_id,
232: l_oks_coverage_timezones_rec.program_update_date,
233: l_oks_coverage_timezones_rec.request_id,
234: l_oks_coverage_timezones_rec.created_by,
235: l_oks_coverage_timezones_rec.creation_date,
236: l_oks_coverage_timezones_rec.last_updated_by,
237: l_oks_coverage_timezones_rec.last_update_date,
238: l_oks_coverage_timezones_rec.last_update_login,
231: l_oks_coverage_timezones_rec.program_id,
232: l_oks_coverage_timezones_rec.program_update_date,
233: l_oks_coverage_timezones_rec.request_id,
234: l_oks_coverage_timezones_rec.created_by,
235: l_oks_coverage_timezones_rec.creation_date,
236: l_oks_coverage_timezones_rec.last_updated_by,
237: l_oks_coverage_timezones_rec.last_update_date,
238: l_oks_coverage_timezones_rec.last_update_login,
239: l_oks_coverage_timezones_rec.object_version_number,
232: l_oks_coverage_timezones_rec.program_update_date,
233: l_oks_coverage_timezones_rec.request_id,
234: l_oks_coverage_timezones_rec.created_by,
235: l_oks_coverage_timezones_rec.creation_date,
236: l_oks_coverage_timezones_rec.last_updated_by,
237: l_oks_coverage_timezones_rec.last_update_date,
238: l_oks_coverage_timezones_rec.last_update_login,
239: l_oks_coverage_timezones_rec.object_version_number,
240: -- R12 Data Model Changes 4485150 Start
233: l_oks_coverage_timezones_rec.request_id,
234: l_oks_coverage_timezones_rec.created_by,
235: l_oks_coverage_timezones_rec.creation_date,
236: l_oks_coverage_timezones_rec.last_updated_by,
237: l_oks_coverage_timezones_rec.last_update_date,
238: l_oks_coverage_timezones_rec.last_update_login,
239: l_oks_coverage_timezones_rec.object_version_number,
240: -- R12 Data Model Changes 4485150 Start
241: l_oks_coverage_timezones_rec.orig_system_id1,
234: l_oks_coverage_timezones_rec.created_by,
235: l_oks_coverage_timezones_rec.creation_date,
236: l_oks_coverage_timezones_rec.last_updated_by,
237: l_oks_coverage_timezones_rec.last_update_date,
238: l_oks_coverage_timezones_rec.last_update_login,
239: l_oks_coverage_timezones_rec.object_version_number,
240: -- R12 Data Model Changes 4485150 Start
241: l_oks_coverage_timezones_rec.orig_system_id1,
242: l_oks_coverage_timezones_rec.orig_system_reference1,
235: l_oks_coverage_timezones_rec.creation_date,
236: l_oks_coverage_timezones_rec.last_updated_by,
237: l_oks_coverage_timezones_rec.last_update_date,
238: l_oks_coverage_timezones_rec.last_update_login,
239: l_oks_coverage_timezones_rec.object_version_number,
240: -- R12 Data Model Changes 4485150 Start
241: l_oks_coverage_timezones_rec.orig_system_id1,
242: l_oks_coverage_timezones_rec.orig_system_reference1,
243: l_oks_coverage_timezones_rec.orig_system_source_code
237: l_oks_coverage_timezones_rec.last_update_date,
238: l_oks_coverage_timezones_rec.last_update_login,
239: l_oks_coverage_timezones_rec.object_version_number,
240: -- R12 Data Model Changes 4485150 Start
241: l_oks_coverage_timezones_rec.orig_system_id1,
242: l_oks_coverage_timezones_rec.orig_system_reference1,
243: l_oks_coverage_timezones_rec.orig_system_source_code
244: -- R12 Data Model Changes 4485150 End
245:
238: l_oks_coverage_timezones_rec.last_update_login,
239: l_oks_coverage_timezones_rec.object_version_number,
240: -- R12 Data Model Changes 4485150 Start
241: l_oks_coverage_timezones_rec.orig_system_id1,
242: l_oks_coverage_timezones_rec.orig_system_reference1,
243: l_oks_coverage_timezones_rec.orig_system_source_code
244: -- R12 Data Model Changes 4485150 End
245:
246: ;
239: l_oks_coverage_timezones_rec.object_version_number,
240: -- R12 Data Model Changes 4485150 Start
241: l_oks_coverage_timezones_rec.orig_system_id1,
242: l_oks_coverage_timezones_rec.orig_system_reference1,
243: l_oks_coverage_timezones_rec.orig_system_source_code
244: -- R12 Data Model Changes 4485150 End
245:
246: ;
247: x_no_data_found := oks_ctz_pk_csr%NOTFOUND;
245:
246: ;
247: x_no_data_found := oks_ctz_pk_csr%NOTFOUND;
248: CLOSE oks_ctz_pk_csr;
249: RETURN(l_oks_coverage_timezones_rec);
250: END get_rec;
251:
252: ------------------------------------------------------------------
253: -- This version of get_rec sets error messages if no data found --
252: ------------------------------------------------------------------
253: -- This version of get_rec sets error messages if no data found --
254: ------------------------------------------------------------------
255: FUNCTION get_rec (
256: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
257: x_return_status OUT NOCOPY VARCHAR2
258: ) RETURN OksCoverageTimezonesRecType IS
259: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
260: l_row_notfound BOOLEAN := TRUE;
255: FUNCTION get_rec (
256: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
257: x_return_status OUT NOCOPY VARCHAR2
258: ) RETURN OksCoverageTimezonesRecType IS
259: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
260: l_row_notfound BOOLEAN := TRUE;
261: BEGIN
262: x_return_status := OKC_API.G_RET_STS_SUCCESS;
263: l_oks_coverage_timezones_rec := get_rec(p_oks_coverage_timezones_rec, l_row_notfound);
259: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
260: l_row_notfound BOOLEAN := TRUE;
261: BEGIN
262: x_return_status := OKC_API.G_RET_STS_SUCCESS;
263: l_oks_coverage_timezones_rec := get_rec(p_oks_coverage_timezones_rec, l_row_notfound);
264: IF (l_row_notfound) THEN
265: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
266: x_return_status := OKC_API.G_RET_STS_ERROR;
267: END IF;
264: IF (l_row_notfound) THEN
265: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
266: x_return_status := OKC_API.G_RET_STS_ERROR;
267: END IF;
268: RETURN(l_oks_coverage_timezones_rec);
269: END get_rec;
270: -----------------------------------------------------------
271: -- So we don't have to pass an "l_row_notfound" variable --
272: -----------------------------------------------------------
270: -----------------------------------------------------------
271: -- So we don't have to pass an "l_row_notfound" variable --
272: -----------------------------------------------------------
273: FUNCTION get_rec (
274: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType
275: ) RETURN OksCoverageTimezonesRecType IS
276: l_row_not_found BOOLEAN := TRUE;
277: BEGIN
278: RETURN(get_rec(p_oks_coverage_timezones_rec, l_row_not_found));
274: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType
275: ) RETURN OksCoverageTimezonesRecType IS
276: l_row_not_found BOOLEAN := TRUE;
277: BEGIN
278: RETURN(get_rec(p_oks_coverage_timezones_rec, l_row_not_found));
279: END get_rec;
280: ---------------------------------------------------------------------------
281: -- FUNCTION null_out_defaults for: OKS_COVERAGE_TIMEZONES_V
282: ---------------------------------------------------------------------------
277: BEGIN
278: RETURN(get_rec(p_oks_coverage_timezones_rec, l_row_not_found));
279: END get_rec;
280: ---------------------------------------------------------------------------
281: -- FUNCTION null_out_defaults for: OKS_COVERAGE_TIMEZONES_V
282: ---------------------------------------------------------------------------
283: FUNCTION null_out_defaults (
284: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
285: ) RETURN OksCoverageTimezonesVRecType IS
280: ---------------------------------------------------------------------------
281: -- FUNCTION null_out_defaults for: OKS_COVERAGE_TIMEZONES_V
282: ---------------------------------------------------------------------------
283: FUNCTION null_out_defaults (
284: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
285: ) RETURN OksCoverageTimezonesVRecType IS
286: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
287: BEGIN
288: IF (l_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM ) THEN
282: ---------------------------------------------------------------------------
283: FUNCTION null_out_defaults (
284: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
285: ) RETURN OksCoverageTimezonesVRecType IS
286: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
287: BEGIN
288: IF (l_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM ) THEN
289: l_oks_coverage_timezones_v_rec.id := NULL;
290: END IF;
284: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
285: ) RETURN OksCoverageTimezonesVRecType IS
286: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
287: BEGIN
288: IF (l_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM ) THEN
289: l_oks_coverage_timezones_v_rec.id := NULL;
290: END IF;
291: IF (l_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
292: l_oks_coverage_timezones_v_rec.cle_id := NULL;
285: ) RETURN OksCoverageTimezonesVRecType IS
286: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
287: BEGIN
288: IF (l_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM ) THEN
289: l_oks_coverage_timezones_v_rec.id := NULL;
290: END IF;
291: IF (l_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
292: l_oks_coverage_timezones_v_rec.cle_id := NULL;
293: END IF;
287: BEGIN
288: IF (l_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM ) THEN
289: l_oks_coverage_timezones_v_rec.id := NULL;
290: END IF;
291: IF (l_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
292: l_oks_coverage_timezones_v_rec.cle_id := NULL;
293: END IF;
294: IF (l_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR ) THEN
295: l_oks_coverage_timezones_v_rec.default_yn := NULL;
288: IF (l_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM ) THEN
289: l_oks_coverage_timezones_v_rec.id := NULL;
290: END IF;
291: IF (l_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
292: l_oks_coverage_timezones_v_rec.cle_id := NULL;
293: END IF;
294: IF (l_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR ) THEN
295: l_oks_coverage_timezones_v_rec.default_yn := NULL;
296: END IF;
290: END IF;
291: IF (l_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
292: l_oks_coverage_timezones_v_rec.cle_id := NULL;
293: END IF;
294: IF (l_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR ) THEN
295: l_oks_coverage_timezones_v_rec.default_yn := NULL;
296: END IF;
297: IF (l_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM ) THEN
298: l_oks_coverage_timezones_v_rec.timezone_id := NULL;
291: IF (l_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
292: l_oks_coverage_timezones_v_rec.cle_id := NULL;
293: END IF;
294: IF (l_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR ) THEN
295: l_oks_coverage_timezones_v_rec.default_yn := NULL;
296: END IF;
297: IF (l_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM ) THEN
298: l_oks_coverage_timezones_v_rec.timezone_id := NULL;
299: END IF;
293: END IF;
294: IF (l_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR ) THEN
295: l_oks_coverage_timezones_v_rec.default_yn := NULL;
296: END IF;
297: IF (l_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM ) THEN
298: l_oks_coverage_timezones_v_rec.timezone_id := NULL;
299: END IF;
300: IF (l_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
301: l_oks_coverage_timezones_v_rec.dnz_chr_id := NULL;
294: IF (l_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR ) THEN
295: l_oks_coverage_timezones_v_rec.default_yn := NULL;
296: END IF;
297: IF (l_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM ) THEN
298: l_oks_coverage_timezones_v_rec.timezone_id := NULL;
299: END IF;
300: IF (l_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
301: l_oks_coverage_timezones_v_rec.dnz_chr_id := NULL;
302: END IF;
296: END IF;
297: IF (l_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM ) THEN
298: l_oks_coverage_timezones_v_rec.timezone_id := NULL;
299: END IF;
300: IF (l_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
301: l_oks_coverage_timezones_v_rec.dnz_chr_id := NULL;
302: END IF;
303: IF (l_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
304: l_oks_coverage_timezones_v_rec.security_group_id := NULL;
297: IF (l_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM ) THEN
298: l_oks_coverage_timezones_v_rec.timezone_id := NULL;
299: END IF;
300: IF (l_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
301: l_oks_coverage_timezones_v_rec.dnz_chr_id := NULL;
302: END IF;
303: IF (l_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
304: l_oks_coverage_timezones_v_rec.security_group_id := NULL;
305: END IF;
299: END IF;
300: IF (l_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
301: l_oks_coverage_timezones_v_rec.dnz_chr_id := NULL;
302: END IF;
303: IF (l_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
304: l_oks_coverage_timezones_v_rec.security_group_id := NULL;
305: END IF;
306: IF (l_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
307: l_oks_coverage_timezones_v_rec.program_application_id := NULL;
300: IF (l_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
301: l_oks_coverage_timezones_v_rec.dnz_chr_id := NULL;
302: END IF;
303: IF (l_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
304: l_oks_coverage_timezones_v_rec.security_group_id := NULL;
305: END IF;
306: IF (l_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
307: l_oks_coverage_timezones_v_rec.program_application_id := NULL;
308: END IF;
302: END IF;
303: IF (l_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
304: l_oks_coverage_timezones_v_rec.security_group_id := NULL;
305: END IF;
306: IF (l_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
307: l_oks_coverage_timezones_v_rec.program_application_id := NULL;
308: END IF;
309: IF (l_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
310: l_oks_coverage_timezones_v_rec.program_id := NULL;
303: IF (l_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
304: l_oks_coverage_timezones_v_rec.security_group_id := NULL;
305: END IF;
306: IF (l_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
307: l_oks_coverage_timezones_v_rec.program_application_id := NULL;
308: END IF;
309: IF (l_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
310: l_oks_coverage_timezones_v_rec.program_id := NULL;
311: END IF;
305: END IF;
306: IF (l_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
307: l_oks_coverage_timezones_v_rec.program_application_id := NULL;
308: END IF;
309: IF (l_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
310: l_oks_coverage_timezones_v_rec.program_id := NULL;
311: END IF;
312: IF (l_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
313: l_oks_coverage_timezones_v_rec.program_update_date := NULL;
306: IF (l_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
307: l_oks_coverage_timezones_v_rec.program_application_id := NULL;
308: END IF;
309: IF (l_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
310: l_oks_coverage_timezones_v_rec.program_id := NULL;
311: END IF;
312: IF (l_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
313: l_oks_coverage_timezones_v_rec.program_update_date := NULL;
314: END IF;
308: END IF;
309: IF (l_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
310: l_oks_coverage_timezones_v_rec.program_id := NULL;
311: END IF;
312: IF (l_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
313: l_oks_coverage_timezones_v_rec.program_update_date := NULL;
314: END IF;
315: IF (l_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
316: l_oks_coverage_timezones_v_rec.request_id := NULL;
309: IF (l_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
310: l_oks_coverage_timezones_v_rec.program_id := NULL;
311: END IF;
312: IF (l_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
313: l_oks_coverage_timezones_v_rec.program_update_date := NULL;
314: END IF;
315: IF (l_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
316: l_oks_coverage_timezones_v_rec.request_id := NULL;
317: END IF;
311: END IF;
312: IF (l_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
313: l_oks_coverage_timezones_v_rec.program_update_date := NULL;
314: END IF;
315: IF (l_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
316: l_oks_coverage_timezones_v_rec.request_id := NULL;
317: END IF;
318: IF (l_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
319: l_oks_coverage_timezones_v_rec.created_by := NULL;
312: IF (l_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
313: l_oks_coverage_timezones_v_rec.program_update_date := NULL;
314: END IF;
315: IF (l_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
316: l_oks_coverage_timezones_v_rec.request_id := NULL;
317: END IF;
318: IF (l_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
319: l_oks_coverage_timezones_v_rec.created_by := NULL;
320: END IF;
314: END IF;
315: IF (l_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
316: l_oks_coverage_timezones_v_rec.request_id := NULL;
317: END IF;
318: IF (l_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
319: l_oks_coverage_timezones_v_rec.created_by := NULL;
320: END IF;
321: IF (l_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
322: l_oks_coverage_timezones_v_rec.creation_date := NULL;
315: IF (l_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
316: l_oks_coverage_timezones_v_rec.request_id := NULL;
317: END IF;
318: IF (l_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
319: l_oks_coverage_timezones_v_rec.created_by := NULL;
320: END IF;
321: IF (l_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
322: l_oks_coverage_timezones_v_rec.creation_date := NULL;
323: END IF;
317: END IF;
318: IF (l_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
319: l_oks_coverage_timezones_v_rec.created_by := NULL;
320: END IF;
321: IF (l_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
322: l_oks_coverage_timezones_v_rec.creation_date := NULL;
323: END IF;
324: IF (l_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
325: l_oks_coverage_timezones_v_rec.last_updated_by := NULL;
318: IF (l_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
319: l_oks_coverage_timezones_v_rec.created_by := NULL;
320: END IF;
321: IF (l_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
322: l_oks_coverage_timezones_v_rec.creation_date := NULL;
323: END IF;
324: IF (l_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
325: l_oks_coverage_timezones_v_rec.last_updated_by := NULL;
326: END IF;
320: END IF;
321: IF (l_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
322: l_oks_coverage_timezones_v_rec.creation_date := NULL;
323: END IF;
324: IF (l_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
325: l_oks_coverage_timezones_v_rec.last_updated_by := NULL;
326: END IF;
327: IF (l_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
328: l_oks_coverage_timezones_v_rec.last_update_date := NULL;
321: IF (l_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
322: l_oks_coverage_timezones_v_rec.creation_date := NULL;
323: END IF;
324: IF (l_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
325: l_oks_coverage_timezones_v_rec.last_updated_by := NULL;
326: END IF;
327: IF (l_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
328: l_oks_coverage_timezones_v_rec.last_update_date := NULL;
329: END IF;
323: END IF;
324: IF (l_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
325: l_oks_coverage_timezones_v_rec.last_updated_by := NULL;
326: END IF;
327: IF (l_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
328: l_oks_coverage_timezones_v_rec.last_update_date := NULL;
329: END IF;
330: IF (l_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
331: l_oks_coverage_timezones_v_rec.last_update_login := NULL;
324: IF (l_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
325: l_oks_coverage_timezones_v_rec.last_updated_by := NULL;
326: END IF;
327: IF (l_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
328: l_oks_coverage_timezones_v_rec.last_update_date := NULL;
329: END IF;
330: IF (l_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
331: l_oks_coverage_timezones_v_rec.last_update_login := NULL;
332: END IF;
326: END IF;
327: IF (l_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
328: l_oks_coverage_timezones_v_rec.last_update_date := NULL;
329: END IF;
330: IF (l_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
331: l_oks_coverage_timezones_v_rec.last_update_login := NULL;
332: END IF;
333: IF (l_oks_coverage_timezones_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
334: l_oks_coverage_timezones_v_rec.object_version_number := NULL;
327: IF (l_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
328: l_oks_coverage_timezones_v_rec.last_update_date := NULL;
329: END IF;
330: IF (l_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
331: l_oks_coverage_timezones_v_rec.last_update_login := NULL;
332: END IF;
333: IF (l_oks_coverage_timezones_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
334: l_oks_coverage_timezones_v_rec.object_version_number := NULL;
335: END IF;
329: END IF;
330: IF (l_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
331: l_oks_coverage_timezones_v_rec.last_update_login := NULL;
332: END IF;
333: IF (l_oks_coverage_timezones_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
334: l_oks_coverage_timezones_v_rec.object_version_number := NULL;
335: END IF;
336: -- R12 Data Model Changes 4485150 Start
337: IF (l_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
330: IF (l_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
331: l_oks_coverage_timezones_v_rec.last_update_login := NULL;
332: END IF;
333: IF (l_oks_coverage_timezones_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
334: l_oks_coverage_timezones_v_rec.object_version_number := NULL;
335: END IF;
336: -- R12 Data Model Changes 4485150 Start
337: IF (l_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
338: l_oks_coverage_timezones_v_rec.orig_system_id1 := NULL;
333: IF (l_oks_coverage_timezones_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
334: l_oks_coverage_timezones_v_rec.object_version_number := NULL;
335: END IF;
336: -- R12 Data Model Changes 4485150 Start
337: IF (l_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
338: l_oks_coverage_timezones_v_rec.orig_system_id1 := NULL;
339: END IF;
340: IF (l_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_timezones_v_rec.orig_system_reference1 := NULL;
334: l_oks_coverage_timezones_v_rec.object_version_number := NULL;
335: END IF;
336: -- R12 Data Model Changes 4485150 Start
337: IF (l_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
338: l_oks_coverage_timezones_v_rec.orig_system_id1 := NULL;
339: END IF;
340: IF (l_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_timezones_v_rec.orig_system_reference1 := NULL;
342: END IF;
336: -- R12 Data Model Changes 4485150 Start
337: IF (l_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
338: l_oks_coverage_timezones_v_rec.orig_system_id1 := NULL;
339: END IF;
340: IF (l_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_timezones_v_rec.orig_system_reference1 := NULL;
342: END IF;
343: IF (l_oks_coverage_timezones_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR ) THEN
344: l_oks_coverage_timezones_v_rec.orig_system_source_code := NULL;
337: IF (l_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
338: l_oks_coverage_timezones_v_rec.orig_system_id1 := NULL;
339: END IF;
340: IF (l_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_timezones_v_rec.orig_system_reference1 := NULL;
342: END IF;
343: IF (l_oks_coverage_timezones_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR ) THEN
344: l_oks_coverage_timezones_v_rec.orig_system_source_code := NULL;
345: END IF;
339: END IF;
340: IF (l_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_timezones_v_rec.orig_system_reference1 := NULL;
342: END IF;
343: IF (l_oks_coverage_timezones_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR ) THEN
344: l_oks_coverage_timezones_v_rec.orig_system_source_code := NULL;
345: END IF;
346: -- R12 Data Model Changes 4485150 End
347: RETURN(l_oks_coverage_timezones_v_rec);
340: IF (l_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_timezones_v_rec.orig_system_reference1 := NULL;
342: END IF;
343: IF (l_oks_coverage_timezones_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR ) THEN
344: l_oks_coverage_timezones_v_rec.orig_system_source_code := NULL;
345: END IF;
346: -- R12 Data Model Changes 4485150 End
347: RETURN(l_oks_coverage_timezones_v_rec);
348: END null_out_defaults;
343: IF (l_oks_coverage_timezones_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR ) THEN
344: l_oks_coverage_timezones_v_rec.orig_system_source_code := NULL;
345: END IF;
346: -- R12 Data Model Changes 4485150 End
347: RETURN(l_oks_coverage_timezones_v_rec);
348: END null_out_defaults;
349: ---------------------------------
350: -- Validate_Attributes for: ID --
351: ---------------------------------
403: ---------------------------------------------------------------------------
404: -- FUNCTION Validate_Attributes
405: ---------------------------------------------------------------------------
406: ------------------------------------------------------
407: -- Validate_Attributes for:OKS_COVERAGE_TIMEZONES_V --
408: ------------------------------------------------------
409: FUNCTION Validate_Attributes (
410: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
411: ) RETURN VARCHAR2 IS
406: ------------------------------------------------------
407: -- Validate_Attributes for:OKS_COVERAGE_TIMEZONES_V --
408: ------------------------------------------------------
409: FUNCTION Validate_Attributes (
410: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
411: ) RETURN VARCHAR2 IS
412: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
413: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
414: BEGIN
417: -----------------------------
418: -- ***
419: -- id
420: -- ***
421: validate_id(x_return_status, p_oks_coverage_timezones_v_rec.id);
422: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
423: l_return_status := x_return_status;
424: RAISE G_EXCEPTION_HALT_VALIDATION;
425: END IF;
426:
427: -- ***
428: -- object_version_number
429: -- ***
430: validate_object_version_number(x_return_status, p_oks_coverage_timezones_v_rec.object_version_number);
431: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
432: l_return_status := x_return_status;
433: RAISE G_EXCEPTION_HALT_VALIDATION;
434: END IF;
450: ---------------------------------------------------------------------------
451: -- PROCEDURE Validate_Record
452: ---------------------------------------------------------------------------
453: --------------------------------------------------
454: -- Validate Record for:OKS_COVERAGE_TIMEZONES_V --
455: --------------------------------------------------
456: FUNCTION Validate_Record (
457: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
458: p_db_oks_coverage_tim44 IN OksCoverageTimezonesVRecType
453: --------------------------------------------------
454: -- Validate Record for:OKS_COVERAGE_TIMEZONES_V --
455: --------------------------------------------------
456: FUNCTION Validate_Record (
457: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
458: p_db_oks_coverage_tim44 IN OksCoverageTimezonesVRecType
459: ) RETURN VARCHAR2 IS
460: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
461: BEGIN
461: BEGIN
462: RETURN (l_return_status);
463: END Validate_Record;
464: FUNCTION Validate_Record (
465: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
466: ) RETURN VARCHAR2 IS
467: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
468: l_db_oks_coverage_tim44 OksCoverageTimezonesVRecType := get_rec(p_oks_coverage_timezones_v_rec);
469: BEGIN
464: FUNCTION Validate_Record (
465: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
466: ) RETURN VARCHAR2 IS
467: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
468: l_db_oks_coverage_tim44 OksCoverageTimezonesVRecType := get_rec(p_oks_coverage_timezones_v_rec);
469: BEGIN
470: l_return_status := Validate_Record(p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_rec,
471: p_db_oks_coverage_tim44 => l_db_oks_coverage_tim44);
472: RETURN (l_return_status);
466: ) RETURN VARCHAR2 IS
467: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
468: l_db_oks_coverage_tim44 OksCoverageTimezonesVRecType := get_rec(p_oks_coverage_timezones_v_rec);
469: BEGIN
470: l_return_status := Validate_Record(p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_rec,
471: p_db_oks_coverage_tim44 => l_db_oks_coverage_tim44);
472: RETURN (l_return_status);
473: END Validate_Record;
474:
530: ---------------------------------------------------------------------------
531: -- PROCEDURE validate_row
532: ---------------------------------------------------------------------------
533: -----------------------------------------------
534: -- validate_row for:OKS_COVERAGE_TIMEZONES_V --
535: -----------------------------------------------
536: PROCEDURE validate_row(
537: p_api_version IN NUMBER,
538: p_init_msg_list IN VARCHAR2,
538: p_init_msg_list IN VARCHAR2,
539: x_return_status OUT NOCOPY VARCHAR2,
540: x_msg_count OUT NOCOPY NUMBER,
541: x_msg_data OUT NOCOPY VARCHAR2,
542: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType) IS
543:
544: l_api_version CONSTANT NUMBER := 1;
545: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
546: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
543:
544: l_api_version CONSTANT NUMBER := 1;
545: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
546: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
547: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
548: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
549: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
550: BEGIN
551: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
544: l_api_version CONSTANT NUMBER := 1;
545: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
546: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
547: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
548: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
549: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
550: BEGIN
551: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
552: G_PKG_NAME,
545: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
546: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
547: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
548: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
549: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
550: BEGIN
551: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
552: G_PKG_NAME,
553: p_init_msg_list,
560: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
561: RAISE OKC_API.G_EXCEPTION_ERROR;
562: END IF;
563: --- Validate all non-missing attributes (Item Level Validation)
564: l_return_status := Validate_Attributes(l_oks_coverage_timezones_v_rec);
565: --- If any errors happen abort API
566: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
569: RAISE OKC_API.G_EXCEPTION_ERROR;
570: END IF;
571: l_return_status := Validate_Record(l_oks_coverage_timezones_v_rec);
572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
574: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
575: RAISE OKC_API.G_EXCEPTION_ERROR;
607: '_PVT'
608: );
609: END validate_row;
610: ----------------------------------------------------------
611: -- PL/SQL TBL validate_row for:OKS_COVERAGE_TIMEZONES_V --
612: ----------------------------------------------------------
613: PROCEDURE validate_row(
614: p_api_version IN NUMBER,
615: p_init_msg_list IN VARCHAR2,
615: p_init_msg_list IN VARCHAR2,
616: x_return_status OUT NOCOPY VARCHAR2,
617: x_msg_count OUT NOCOPY NUMBER,
618: x_msg_data OUT NOCOPY VARCHAR2,
619: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
620: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
621:
622: l_api_version CONSTANT NUMBER := 1;
623: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
624: i NUMBER := 0;
625: BEGIN
626: OKC_API.init_msg_list(p_init_msg_list);
627: -- Make sure PL/SQL table has records in it before passing
628: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
629: i := p_oks_coverage_timezones_v_tbl.FIRST;
630: LOOP
631: DECLARE
632: l_error_rec OKC_API.ERROR_REC_TYPE;
625: BEGIN
626: OKC_API.init_msg_list(p_init_msg_list);
627: -- Make sure PL/SQL table has records in it before passing
628: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
629: i := p_oks_coverage_timezones_v_tbl.FIRST;
630: LOOP
631: DECLARE
632: l_error_rec OKC_API.ERROR_REC_TYPE;
633: BEGIN
639: p_init_msg_list => OKC_API.G_FALSE,
640: x_return_status => l_error_rec.error_type,
641: x_msg_count => l_error_rec.msg_count,
642: x_msg_data => l_error_rec.msg_data,
643: p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i));
644: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
645: l_error_rec.sqlcode := SQLCODE;
646: load_error_tbl(l_error_rec, px_error_tbl);
647: ELSE
661: l_error_rec.error_type := 'OTHERS';
662: l_error_rec.sqlcode := SQLCODE;
663: load_error_tbl(l_error_rec, px_error_tbl);
664: END;
665: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
666: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
667: END LOOP;
668: END IF;
669: -- Loop through the error_tbl to find the error with the highest severity
662: l_error_rec.sqlcode := SQLCODE;
663: load_error_tbl(l_error_rec, px_error_tbl);
664: END;
665: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
666: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
667: END LOOP;
668: END IF;
669: -- Loop through the error_tbl to find the error with the highest severity
670: -- and return it.
703: );
704: END validate_row;
705:
706: ----------------------------------------------------------
707: -- PL/SQL TBL validate_row for:OKS_COVERAGE_TIMEZONES_V --
708: ----------------------------------------------------------
709: PROCEDURE validate_row(
710: p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2,
711: p_init_msg_list IN VARCHAR2,
712: x_return_status OUT NOCOPY VARCHAR2,
713: x_msg_count OUT NOCOPY NUMBER,
714: x_msg_data OUT NOCOPY VARCHAR2,
715: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType) IS
716:
717: l_api_version CONSTANT NUMBER := 1;
718: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
719: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
720: l_error_tbl OKC_API.ERROR_TBL_TYPE;
721: BEGIN
722: OKC_API.init_msg_list(p_init_msg_list);
723: -- Make sure PL/SQL table has records in it before passing
724: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
725: validate_row (
726: p_api_version => p_api_version,
727: p_init_msg_list => OKC_API.G_FALSE,
728: x_return_status => x_return_status,
727: p_init_msg_list => OKC_API.G_FALSE,
728: x_return_status => x_return_status,
729: x_msg_count => x_msg_count,
730: x_msg_data => x_msg_data,
731: p_oks_coverage_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
732: px_error_tbl => l_error_tbl);
733: END IF;
734: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
735: EXCEPTION
768: ---------------------------------------------------------------------------
769: -- PROCEDURE insert_row
770: ---------------------------------------------------------------------------
771: -------------------------------------------
772: -- insert_row for:OKS_COVERAGE_TIMEZONES --
773: -------------------------------------------
774: PROCEDURE insert_row(
775: p_init_msg_list IN VARCHAR2,
776: x_return_status OUT NOCOPY VARCHAR2,
775: p_init_msg_list IN VARCHAR2,
776: x_return_status OUT NOCOPY VARCHAR2,
777: x_msg_count OUT NOCOPY NUMBER,
778: x_msg_data OUT NOCOPY VARCHAR2,
779: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
780: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType) IS
781:
782: l_api_version CONSTANT NUMBER := 1;
783: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
776: x_return_status OUT NOCOPY VARCHAR2,
777: x_msg_count OUT NOCOPY NUMBER,
778: x_msg_data OUT NOCOPY VARCHAR2,
779: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
780: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType) IS
781:
782: l_api_version CONSTANT NUMBER := 1;
783: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
784: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
781:
782: l_api_version CONSTANT NUMBER := 1;
783: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
784: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
785: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType := p_oks_coverage_timezones_rec;
786: LDefOksCoverageTimezonesRec OksCoverageTimezonesRecType;
787: -----------------------------------------------
788: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES --
789: -----------------------------------------------
784: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
785: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType := p_oks_coverage_timezones_rec;
786: LDefOksCoverageTimezonesRec OksCoverageTimezonesRecType;
787: -----------------------------------------------
788: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES --
789: -----------------------------------------------
790: FUNCTION Set_Attributes (
791: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
792: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
787: -----------------------------------------------
788: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES --
789: -----------------------------------------------
790: FUNCTION Set_Attributes (
791: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
792: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
793: ) RETURN VARCHAR2 IS
794: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
795: BEGIN
788: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES --
789: -----------------------------------------------
790: FUNCTION Set_Attributes (
791: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
792: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
793: ) RETURN VARCHAR2 IS
794: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
795: BEGIN
796: x_oks_coverage_timezones_rec := p_oks_coverage_timezones_rec;
792: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
793: ) RETURN VARCHAR2 IS
794: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
795: BEGIN
796: x_oks_coverage_timezones_rec := p_oks_coverage_timezones_rec;
797: RETURN(l_return_status);
798: END Set_Attributes;
799: BEGIN
800: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
807: RAISE OKC_API.G_EXCEPTION_ERROR;
808: END IF;
809: --- Setting item atributes
810: l_return_status := Set_Attributes(
811: p_oks_coverage_timezones_rec, -- IN
812: l_oks_coverage_timezones_rec); -- OUT
813: --- If any errors happen abort API
814: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
808: END IF;
809: --- Setting item atributes
810: l_return_status := Set_Attributes(
811: p_oks_coverage_timezones_rec, -- IN
812: l_oks_coverage_timezones_rec); -- OUT
813: --- If any errors happen abort API
814: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;
819: INSERT INTO OKS_COVERAGE_TIMEZONES(
820: id,
821: cle_id,
822: default_yn,
823: timezone_id,
838: orig_system_source_code
839: -- R12 Data Model Changes 4485150 End
840: )
841: VALUES (
842: l_oks_coverage_timezones_rec.id,
843: l_oks_coverage_timezones_rec.cle_id,
844: l_oks_coverage_timezones_rec.default_yn,
845: l_oks_coverage_timezones_rec.timezone_id,
846: l_oks_coverage_timezones_rec.dnz_chr_id,
839: -- R12 Data Model Changes 4485150 End
840: )
841: VALUES (
842: l_oks_coverage_timezones_rec.id,
843: l_oks_coverage_timezones_rec.cle_id,
844: l_oks_coverage_timezones_rec.default_yn,
845: l_oks_coverage_timezones_rec.timezone_id,
846: l_oks_coverage_timezones_rec.dnz_chr_id,
847: l_oks_coverage_timezones_rec.program_application_id,
840: )
841: VALUES (
842: l_oks_coverage_timezones_rec.id,
843: l_oks_coverage_timezones_rec.cle_id,
844: l_oks_coverage_timezones_rec.default_yn,
845: l_oks_coverage_timezones_rec.timezone_id,
846: l_oks_coverage_timezones_rec.dnz_chr_id,
847: l_oks_coverage_timezones_rec.program_application_id,
848: l_oks_coverage_timezones_rec.program_id,
841: VALUES (
842: l_oks_coverage_timezones_rec.id,
843: l_oks_coverage_timezones_rec.cle_id,
844: l_oks_coverage_timezones_rec.default_yn,
845: l_oks_coverage_timezones_rec.timezone_id,
846: l_oks_coverage_timezones_rec.dnz_chr_id,
847: l_oks_coverage_timezones_rec.program_application_id,
848: l_oks_coverage_timezones_rec.program_id,
849: l_oks_coverage_timezones_rec.program_update_date,
842: l_oks_coverage_timezones_rec.id,
843: l_oks_coverage_timezones_rec.cle_id,
844: l_oks_coverage_timezones_rec.default_yn,
845: l_oks_coverage_timezones_rec.timezone_id,
846: l_oks_coverage_timezones_rec.dnz_chr_id,
847: l_oks_coverage_timezones_rec.program_application_id,
848: l_oks_coverage_timezones_rec.program_id,
849: l_oks_coverage_timezones_rec.program_update_date,
850: l_oks_coverage_timezones_rec.request_id,
843: l_oks_coverage_timezones_rec.cle_id,
844: l_oks_coverage_timezones_rec.default_yn,
845: l_oks_coverage_timezones_rec.timezone_id,
846: l_oks_coverage_timezones_rec.dnz_chr_id,
847: l_oks_coverage_timezones_rec.program_application_id,
848: l_oks_coverage_timezones_rec.program_id,
849: l_oks_coverage_timezones_rec.program_update_date,
850: l_oks_coverage_timezones_rec.request_id,
851: l_oks_coverage_timezones_rec.created_by,
844: l_oks_coverage_timezones_rec.default_yn,
845: l_oks_coverage_timezones_rec.timezone_id,
846: l_oks_coverage_timezones_rec.dnz_chr_id,
847: l_oks_coverage_timezones_rec.program_application_id,
848: l_oks_coverage_timezones_rec.program_id,
849: l_oks_coverage_timezones_rec.program_update_date,
850: l_oks_coverage_timezones_rec.request_id,
851: l_oks_coverage_timezones_rec.created_by,
852: l_oks_coverage_timezones_rec.creation_date,
845: l_oks_coverage_timezones_rec.timezone_id,
846: l_oks_coverage_timezones_rec.dnz_chr_id,
847: l_oks_coverage_timezones_rec.program_application_id,
848: l_oks_coverage_timezones_rec.program_id,
849: l_oks_coverage_timezones_rec.program_update_date,
850: l_oks_coverage_timezones_rec.request_id,
851: l_oks_coverage_timezones_rec.created_by,
852: l_oks_coverage_timezones_rec.creation_date,
853: l_oks_coverage_timezones_rec.last_updated_by,
846: l_oks_coverage_timezones_rec.dnz_chr_id,
847: l_oks_coverage_timezones_rec.program_application_id,
848: l_oks_coverage_timezones_rec.program_id,
849: l_oks_coverage_timezones_rec.program_update_date,
850: l_oks_coverage_timezones_rec.request_id,
851: l_oks_coverage_timezones_rec.created_by,
852: l_oks_coverage_timezones_rec.creation_date,
853: l_oks_coverage_timezones_rec.last_updated_by,
854: l_oks_coverage_timezones_rec.last_update_date,
847: l_oks_coverage_timezones_rec.program_application_id,
848: l_oks_coverage_timezones_rec.program_id,
849: l_oks_coverage_timezones_rec.program_update_date,
850: l_oks_coverage_timezones_rec.request_id,
851: l_oks_coverage_timezones_rec.created_by,
852: l_oks_coverage_timezones_rec.creation_date,
853: l_oks_coverage_timezones_rec.last_updated_by,
854: l_oks_coverage_timezones_rec.last_update_date,
855: l_oks_coverage_timezones_rec.last_update_login,
848: l_oks_coverage_timezones_rec.program_id,
849: l_oks_coverage_timezones_rec.program_update_date,
850: l_oks_coverage_timezones_rec.request_id,
851: l_oks_coverage_timezones_rec.created_by,
852: l_oks_coverage_timezones_rec.creation_date,
853: l_oks_coverage_timezones_rec.last_updated_by,
854: l_oks_coverage_timezones_rec.last_update_date,
855: l_oks_coverage_timezones_rec.last_update_login,
856: l_oks_coverage_timezones_rec.object_version_number,
849: l_oks_coverage_timezones_rec.program_update_date,
850: l_oks_coverage_timezones_rec.request_id,
851: l_oks_coverage_timezones_rec.created_by,
852: l_oks_coverage_timezones_rec.creation_date,
853: l_oks_coverage_timezones_rec.last_updated_by,
854: l_oks_coverage_timezones_rec.last_update_date,
855: l_oks_coverage_timezones_rec.last_update_login,
856: l_oks_coverage_timezones_rec.object_version_number,
857: -- R12 Data Model Changes 4485150 Start
850: l_oks_coverage_timezones_rec.request_id,
851: l_oks_coverage_timezones_rec.created_by,
852: l_oks_coverage_timezones_rec.creation_date,
853: l_oks_coverage_timezones_rec.last_updated_by,
854: l_oks_coverage_timezones_rec.last_update_date,
855: l_oks_coverage_timezones_rec.last_update_login,
856: l_oks_coverage_timezones_rec.object_version_number,
857: -- R12 Data Model Changes 4485150 Start
858: l_oks_coverage_timezones_rec.orig_system_id1,
851: l_oks_coverage_timezones_rec.created_by,
852: l_oks_coverage_timezones_rec.creation_date,
853: l_oks_coverage_timezones_rec.last_updated_by,
854: l_oks_coverage_timezones_rec.last_update_date,
855: l_oks_coverage_timezones_rec.last_update_login,
856: l_oks_coverage_timezones_rec.object_version_number,
857: -- R12 Data Model Changes 4485150 Start
858: l_oks_coverage_timezones_rec.orig_system_id1,
859: l_oks_coverage_timezones_rec.orig_system_reference1,
852: l_oks_coverage_timezones_rec.creation_date,
853: l_oks_coverage_timezones_rec.last_updated_by,
854: l_oks_coverage_timezones_rec.last_update_date,
855: l_oks_coverage_timezones_rec.last_update_login,
856: l_oks_coverage_timezones_rec.object_version_number,
857: -- R12 Data Model Changes 4485150 Start
858: l_oks_coverage_timezones_rec.orig_system_id1,
859: l_oks_coverage_timezones_rec.orig_system_reference1,
860: l_oks_coverage_timezones_rec.orig_system_source_code
854: l_oks_coverage_timezones_rec.last_update_date,
855: l_oks_coverage_timezones_rec.last_update_login,
856: l_oks_coverage_timezones_rec.object_version_number,
857: -- R12 Data Model Changes 4485150 Start
858: l_oks_coverage_timezones_rec.orig_system_id1,
859: l_oks_coverage_timezones_rec.orig_system_reference1,
860: l_oks_coverage_timezones_rec.orig_system_source_code
861: -- R12 Data Model Changes 4485150 End
862: );
855: l_oks_coverage_timezones_rec.last_update_login,
856: l_oks_coverage_timezones_rec.object_version_number,
857: -- R12 Data Model Changes 4485150 Start
858: l_oks_coverage_timezones_rec.orig_system_id1,
859: l_oks_coverage_timezones_rec.orig_system_reference1,
860: l_oks_coverage_timezones_rec.orig_system_source_code
861: -- R12 Data Model Changes 4485150 End
862: );
863: -- Set OUT values
856: l_oks_coverage_timezones_rec.object_version_number,
857: -- R12 Data Model Changes 4485150 Start
858: l_oks_coverage_timezones_rec.orig_system_id1,
859: l_oks_coverage_timezones_rec.orig_system_reference1,
860: l_oks_coverage_timezones_rec.orig_system_source_code
861: -- R12 Data Model Changes 4485150 End
862: );
863: -- Set OUT values
864: x_oks_coverage_timezones_rec := l_oks_coverage_timezones_rec;
860: l_oks_coverage_timezones_rec.orig_system_source_code
861: -- R12 Data Model Changes 4485150 End
862: );
863: -- Set OUT values
864: x_oks_coverage_timezones_rec := l_oks_coverage_timezones_rec;
865: x_return_status := l_return_status;
866: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
867: EXCEPTION
868: WHEN OKC_API.G_EXCEPTION_ERROR THEN
896: '_PVT'
897: );
898: END insert_row;
899: ----------------------------------------------
900: -- insert_row for :OKS_COVERAGE_TIMEZONES_V --
901: ----------------------------------------------
902: PROCEDURE insert_row(
903: p_api_version IN NUMBER,
904: p_init_msg_list IN VARCHAR2,
904: p_init_msg_list IN VARCHAR2,
905: x_return_status OUT NOCOPY VARCHAR2,
906: x_msg_count OUT NOCOPY NUMBER,
907: x_msg_data OUT NOCOPY VARCHAR2,
908: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
909: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType) IS
910:
911: l_api_version CONSTANT NUMBER := 1;
912: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
905: x_return_status OUT NOCOPY VARCHAR2,
906: x_msg_count OUT NOCOPY NUMBER,
907: x_msg_data OUT NOCOPY VARCHAR2,
908: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
909: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType) IS
910:
911: l_api_version CONSTANT NUMBER := 1;
912: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
913: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
910:
911: l_api_version CONSTANT NUMBER := 1;
912: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
913: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
914: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
915: LDefOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
916: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
917: lx_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
918: -------------------------------
912: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
913: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
914: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
915: LDefOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
916: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
917: lx_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
918: -------------------------------
919: -- FUNCTION fill_who_columns --
920: -------------------------------
913: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
914: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
915: LDefOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
916: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
917: lx_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
918: -------------------------------
919: -- FUNCTION fill_who_columns --
920: -------------------------------
921: FUNCTION fill_who_columns (
918: -------------------------------
919: -- FUNCTION fill_who_columns --
920: -------------------------------
921: FUNCTION fill_who_columns (
922: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
923: ) RETURN OksCoverageTimezonesVRecType IS
924: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
925: BEGIN
926: l_oks_coverage_timezones_v_rec.CREATION_DATE := SYSDATE;
920: -------------------------------
921: FUNCTION fill_who_columns (
922: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
923: ) RETURN OksCoverageTimezonesVRecType IS
924: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
925: BEGIN
926: l_oks_coverage_timezones_v_rec.CREATION_DATE := SYSDATE;
927: l_oks_coverage_timezones_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
928: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := l_oks_coverage_timezones_v_rec.CREATION_DATE;
922: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
923: ) RETURN OksCoverageTimezonesVRecType IS
924: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
925: BEGIN
926: l_oks_coverage_timezones_v_rec.CREATION_DATE := SYSDATE;
927: l_oks_coverage_timezones_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
928: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := l_oks_coverage_timezones_v_rec.CREATION_DATE;
929: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
930: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
923: ) RETURN OksCoverageTimezonesVRecType IS
924: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
925: BEGIN
926: l_oks_coverage_timezones_v_rec.CREATION_DATE := SYSDATE;
927: l_oks_coverage_timezones_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
928: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := l_oks_coverage_timezones_v_rec.CREATION_DATE;
929: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
930: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
931: RETURN(l_oks_coverage_timezones_v_rec);
924: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
925: BEGIN
926: l_oks_coverage_timezones_v_rec.CREATION_DATE := SYSDATE;
927: l_oks_coverage_timezones_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
928: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := l_oks_coverage_timezones_v_rec.CREATION_DATE;
929: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
930: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
931: RETURN(l_oks_coverage_timezones_v_rec);
932: END fill_who_columns;
925: BEGIN
926: l_oks_coverage_timezones_v_rec.CREATION_DATE := SYSDATE;
927: l_oks_coverage_timezones_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
928: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := l_oks_coverage_timezones_v_rec.CREATION_DATE;
929: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
930: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
931: RETURN(l_oks_coverage_timezones_v_rec);
932: END fill_who_columns;
933: -------------------------------------------------
926: l_oks_coverage_timezones_v_rec.CREATION_DATE := SYSDATE;
927: l_oks_coverage_timezones_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
928: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := l_oks_coverage_timezones_v_rec.CREATION_DATE;
929: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
930: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
931: RETURN(l_oks_coverage_timezones_v_rec);
932: END fill_who_columns;
933: -------------------------------------------------
934: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES_V --
927: l_oks_coverage_timezones_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
928: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := l_oks_coverage_timezones_v_rec.CREATION_DATE;
929: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
930: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
931: RETURN(l_oks_coverage_timezones_v_rec);
932: END fill_who_columns;
933: -------------------------------------------------
934: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES_V --
935: -------------------------------------------------
930: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
931: RETURN(l_oks_coverage_timezones_v_rec);
932: END fill_who_columns;
933: -------------------------------------------------
934: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES_V --
935: -------------------------------------------------
936: FUNCTION Set_Attributes (
937: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
938: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
933: -------------------------------------------------
934: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES_V --
935: -------------------------------------------------
936: FUNCTION Set_Attributes (
937: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
938: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
939: ) RETURN VARCHAR2 IS
940: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
941: BEGIN
934: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES_V --
935: -------------------------------------------------
936: FUNCTION Set_Attributes (
937: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
938: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
939: ) RETURN VARCHAR2 IS
940: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
941: BEGIN
942: x_oks_coverage_timezones_v_rec := p_oks_coverage_timezones_v_rec;
938: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
939: ) RETURN VARCHAR2 IS
940: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
941: BEGIN
942: x_oks_coverage_timezones_v_rec := p_oks_coverage_timezones_v_rec;
943: x_oks_coverage_timezones_v_rec.OBJECT_VERSION_NUMBER := 1;
944: RETURN(l_return_status);
945: END Set_Attributes;
946: BEGIN
939: ) RETURN VARCHAR2 IS
940: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
941: BEGIN
942: x_oks_coverage_timezones_v_rec := p_oks_coverage_timezones_v_rec;
943: x_oks_coverage_timezones_v_rec.OBJECT_VERSION_NUMBER := 1;
944: RETURN(l_return_status);
945: END Set_Attributes;
946: BEGIN
947: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
955: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
956: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
957: RAISE OKC_API.G_EXCEPTION_ERROR;
958: END IF;
959: l_oks_coverage_timezones_v_rec := null_out_defaults(p_oks_coverage_timezones_v_rec);
960: -- Set primary key value
961: l_oks_coverage_timezones_v_rec.ID := get_seq_id;
962: -- Setting item attributes
963: l_return_Status := Set_Attributes(
957: RAISE OKC_API.G_EXCEPTION_ERROR;
958: END IF;
959: l_oks_coverage_timezones_v_rec := null_out_defaults(p_oks_coverage_timezones_v_rec);
960: -- Set primary key value
961: l_oks_coverage_timezones_v_rec.ID := get_seq_id;
962: -- Setting item attributes
963: l_return_Status := Set_Attributes(
964: l_oks_coverage_timezones_v_rec, -- IN
965: LDefOksCoverageTimezonesVRec); -- OUT
960: -- Set primary key value
961: l_oks_coverage_timezones_v_rec.ID := get_seq_id;
962: -- Setting item attributes
963: l_return_Status := Set_Attributes(
964: l_oks_coverage_timezones_v_rec, -- IN
965: LDefOksCoverageTimezonesVRec); -- OUT
966: --- If any errors happen abort API
967: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
986: END IF;
987: -----------------------------------------
988: -- Move VIEW record to "Child" records --
989: -----------------------------------------
990: migrate(LDefOksCoverageTimezonesVRec, l_oks_coverage_timezones_rec);
991: -----------------------------------------------
992: -- Call the INSERT_ROW for each child record --
993: -----------------------------------------------
994: insert_row(
995: p_init_msg_list,
996: l_return_status,
997: x_msg_count,
998: x_msg_data,
999: l_oks_coverage_timezones_rec,
1000: lx_oks_coverage_timezones_rec
1001: );
1002: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1003: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
996: l_return_status,
997: x_msg_count,
998: x_msg_data,
999: l_oks_coverage_timezones_rec,
1000: lx_oks_coverage_timezones_rec
1001: );
1002: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1003: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1004: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1003: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1004: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1005: RAISE OKC_API.G_EXCEPTION_ERROR;
1006: END IF;
1007: migrate(lx_oks_coverage_timezones_rec, LDefOksCoverageTimezonesVRec);
1008: -- Set OUT values
1009: x_oks_coverage_timezones_v_rec := LDefOksCoverageTimezonesVRec;
1010: x_return_status := l_return_status;
1011: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1005: RAISE OKC_API.G_EXCEPTION_ERROR;
1006: END IF;
1007: migrate(lx_oks_coverage_timezones_rec, LDefOksCoverageTimezonesVRec);
1008: -- Set OUT values
1009: x_oks_coverage_timezones_v_rec := LDefOksCoverageTimezonesVRec;
1010: x_return_status := l_return_status;
1011: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1012: EXCEPTION
1013: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1041: '_PVT'
1042: );
1043: END insert_row;
1044: ------------------------------------------------------------
1045: -- PL/SQL TBL insert_row for:OKS_COVERAGE_TIMEZONES_V_TBL --
1046: ------------------------------------------------------------
1047: PROCEDURE insert_row(
1048: p_api_version IN NUMBER,
1049: p_init_msg_list IN VARCHAR2,
1049: p_init_msg_list IN VARCHAR2,
1050: x_return_status OUT NOCOPY VARCHAR2,
1051: x_msg_count OUT NOCOPY NUMBER,
1052: x_msg_data OUT NOCOPY VARCHAR2,
1053: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
1054: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
1055: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1056:
1057: l_api_version CONSTANT NUMBER := 1;
1050: x_return_status OUT NOCOPY VARCHAR2,
1051: x_msg_count OUT NOCOPY NUMBER,
1052: x_msg_data OUT NOCOPY VARCHAR2,
1053: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
1054: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
1055: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1056:
1057: l_api_version CONSTANT NUMBER := 1;
1058: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1059: i NUMBER := 0;
1060: BEGIN
1061: OKC_API.init_msg_list(p_init_msg_list);
1062: -- Make sure PL/SQL table has records in it before passing
1063: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
1064: i := p_oks_coverage_timezones_v_tbl.FIRST;
1065: LOOP
1066: DECLARE
1067: l_error_rec OKC_API.ERROR_REC_TYPE;
1060: BEGIN
1061: OKC_API.init_msg_list(p_init_msg_list);
1062: -- Make sure PL/SQL table has records in it before passing
1063: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
1064: i := p_oks_coverage_timezones_v_tbl.FIRST;
1065: LOOP
1066: DECLARE
1067: l_error_rec OKC_API.ERROR_REC_TYPE;
1068: BEGIN
1074: p_init_msg_list => OKC_API.G_FALSE,
1075: x_return_status => l_error_rec.error_type,
1076: x_msg_count => l_error_rec.msg_count,
1077: x_msg_data => l_error_rec.msg_data,
1078: p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i),
1079: x_oks_coverage_timezones_v_rec => x_oks_coverage_timezones_v_tbl(i));
1080: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1081: l_error_rec.sqlcode := SQLCODE;
1082: load_error_tbl(l_error_rec, px_error_tbl);
1075: x_return_status => l_error_rec.error_type,
1076: x_msg_count => l_error_rec.msg_count,
1077: x_msg_data => l_error_rec.msg_data,
1078: p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i),
1079: x_oks_coverage_timezones_v_rec => x_oks_coverage_timezones_v_tbl(i));
1080: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1081: l_error_rec.sqlcode := SQLCODE;
1082: load_error_tbl(l_error_rec, px_error_tbl);
1083: ELSE
1097: l_error_rec.error_type := 'OTHERS';
1098: l_error_rec.sqlcode := SQLCODE;
1099: load_error_tbl(l_error_rec, px_error_tbl);
1100: END;
1101: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
1102: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
1103: END LOOP;
1104: END IF;
1105: -- Loop through the error_tbl to find the error with the highest severity
1098: l_error_rec.sqlcode := SQLCODE;
1099: load_error_tbl(l_error_rec, px_error_tbl);
1100: END;
1101: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
1102: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
1103: END LOOP;
1104: END IF;
1105: -- Loop through the error_tbl to find the error with the highest severity
1106: -- and return it.
1139: );
1140: END insert_row;
1141:
1142: ------------------------------------------------------------
1143: -- PL/SQL TBL insert_row for:OKS_COVERAGE_TIMEZONES_V_TBL --
1144: ------------------------------------------------------------
1145: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
1146: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
1147: PROCEDURE insert_row(
1149: p_init_msg_list IN VARCHAR2,
1150: x_return_status OUT NOCOPY VARCHAR2,
1151: x_msg_count OUT NOCOPY NUMBER,
1152: x_msg_data OUT NOCOPY VARCHAR2,
1153: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
1154: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType) IS
1155:
1156: l_api_version CONSTANT NUMBER := 1;
1157: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1150: x_return_status OUT NOCOPY VARCHAR2,
1151: x_msg_count OUT NOCOPY NUMBER,
1152: x_msg_data OUT NOCOPY VARCHAR2,
1153: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
1154: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType) IS
1155:
1156: l_api_version CONSTANT NUMBER := 1;
1157: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1158: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1159: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1160: BEGIN
1161: OKC_API.init_msg_list(p_init_msg_list);
1162: -- Make sure PL/SQL table has records in it before passing
1163: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
1164: insert_row (
1165: p_api_version => p_api_version,
1166: p_init_msg_list => OKC_API.G_FALSE,
1167: x_return_status => x_return_status,
1166: p_init_msg_list => OKC_API.G_FALSE,
1167: x_return_status => x_return_status,
1168: x_msg_count => x_msg_count,
1169: x_msg_data => x_msg_data,
1170: p_oks_coverage_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
1171: x_oks_coverage_timezones_v_tbl => x_oks_coverage_timezones_v_tbl,
1172: px_error_tbl => l_error_tbl);
1173: END IF;
1174: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1167: x_return_status => x_return_status,
1168: x_msg_count => x_msg_count,
1169: x_msg_data => x_msg_data,
1170: p_oks_coverage_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
1171: x_oks_coverage_timezones_v_tbl => x_oks_coverage_timezones_v_tbl,
1172: px_error_tbl => l_error_tbl);
1173: END IF;
1174: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1175: EXCEPTION
1208: ---------------------------------------------------------------------------
1209: -- PROCEDURE lock_row
1210: ---------------------------------------------------------------------------
1211: -----------------------------------------
1212: -- lock_row for:OKS_COVERAGE_TIMEZONES --
1213: -----------------------------------------
1214: PROCEDURE lock_row(
1215: p_init_msg_list IN VARCHAR2,
1216: x_return_status OUT NOCOPY VARCHAR2,
1215: p_init_msg_list IN VARCHAR2,
1216: x_return_status OUT NOCOPY VARCHAR2,
1217: x_msg_count OUT NOCOPY NUMBER,
1218: x_msg_data OUT NOCOPY VARCHAR2,
1219: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1220:
1221: E_Resource_Busy EXCEPTION;
1222: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1223: CURSOR lock_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1219: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1220:
1221: E_Resource_Busy EXCEPTION;
1222: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1223: CURSOR lock_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1224: SELECT OBJECT_VERSION_NUMBER
1225: FROM OKS_COVERAGE_TIMEZONES
1226: WHERE ID = p_oks_coverage_timezones_rec.id
1227: AND OBJECT_VERSION_NUMBER = p_oks_coverage_timezones_rec.object_version_number
1221: E_Resource_Busy EXCEPTION;
1222: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1223: CURSOR lock_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1224: SELECT OBJECT_VERSION_NUMBER
1225: FROM OKS_COVERAGE_TIMEZONES
1226: WHERE ID = p_oks_coverage_timezones_rec.id
1227: AND OBJECT_VERSION_NUMBER = p_oks_coverage_timezones_rec.object_version_number
1228: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1229:
1222: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1223: CURSOR lock_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1224: SELECT OBJECT_VERSION_NUMBER
1225: FROM OKS_COVERAGE_TIMEZONES
1226: WHERE ID = p_oks_coverage_timezones_rec.id
1227: AND OBJECT_VERSION_NUMBER = p_oks_coverage_timezones_rec.object_version_number
1228: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1229:
1230: CURSOR lchk_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1223: CURSOR lock_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1224: SELECT OBJECT_VERSION_NUMBER
1225: FROM OKS_COVERAGE_TIMEZONES
1226: WHERE ID = p_oks_coverage_timezones_rec.id
1227: AND OBJECT_VERSION_NUMBER = p_oks_coverage_timezones_rec.object_version_number
1228: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1229:
1230: CURSOR lchk_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1231: SELECT OBJECT_VERSION_NUMBER
1226: WHERE ID = p_oks_coverage_timezones_rec.id
1227: AND OBJECT_VERSION_NUMBER = p_oks_coverage_timezones_rec.object_version_number
1228: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1229:
1230: CURSOR lchk_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1231: SELECT OBJECT_VERSION_NUMBER
1232: FROM OKS_COVERAGE_TIMEZONES
1233: WHERE ID = p_oks_coverage_timezones_rec.id;
1234: l_api_version CONSTANT NUMBER := 1;
1228: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1229:
1230: CURSOR lchk_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1231: SELECT OBJECT_VERSION_NUMBER
1232: FROM OKS_COVERAGE_TIMEZONES
1233: WHERE ID = p_oks_coverage_timezones_rec.id;
1234: l_api_version CONSTANT NUMBER := 1;
1235: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1229:
1230: CURSOR lchk_csr (p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
1231: SELECT OBJECT_VERSION_NUMBER
1232: FROM OKS_COVERAGE_TIMEZONES
1233: WHERE ID = p_oks_coverage_timezones_rec.id;
1234: l_api_version CONSTANT NUMBER := 1;
1235: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1237: l_object_version_number OKS_COVERAGE_TIMEZONES.OBJECT_VERSION_NUMBER%TYPE;
1233: WHERE ID = p_oks_coverage_timezones_rec.id;
1234: l_api_version CONSTANT NUMBER := 1;
1235: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1237: l_object_version_number OKS_COVERAGE_TIMEZONES.OBJECT_VERSION_NUMBER%TYPE;
1238: lc_object_version_number OKS_COVERAGE_TIMEZONES.OBJECT_VERSION_NUMBER%TYPE;
1239: l_row_notfound BOOLEAN := FALSE;
1240: lc_row_notfound BOOLEAN := FALSE;
1241: BEGIN
1234: l_api_version CONSTANT NUMBER := 1;
1235: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1237: l_object_version_number OKS_COVERAGE_TIMEZONES.OBJECT_VERSION_NUMBER%TYPE;
1238: lc_object_version_number OKS_COVERAGE_TIMEZONES.OBJECT_VERSION_NUMBER%TYPE;
1239: l_row_notfound BOOLEAN := FALSE;
1240: lc_row_notfound BOOLEAN := FALSE;
1241: BEGIN
1242: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1248: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1249: RAISE OKC_API.G_EXCEPTION_ERROR;
1250: END IF;
1251: BEGIN
1252: OPEN lock_csr(p_oks_coverage_timezones_rec);
1253: FETCH lock_csr INTO l_object_version_number;
1254: l_row_notfound := lock_csr%NOTFOUND;
1255: CLOSE lock_csr;
1256: EXCEPTION
1262: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1263: END;
1264:
1265: IF ( l_row_notfound ) THEN
1266: OPEN lchk_csr(p_oks_coverage_timezones_rec);
1267: FETCH lchk_csr INTO lc_object_version_number;
1268: lc_row_notfound := lchk_csr%NOTFOUND;
1269: CLOSE lchk_csr;
1270: END IF;
1270: END IF;
1271: IF (lc_row_notfound) THEN
1272: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1273: RAISE OKC_API.G_EXCEPTION_ERROR;
1274: ELSIF lc_object_version_number > p_oks_coverage_timezones_rec.object_version_number THEN
1275: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: ELSIF lc_object_version_number <> p_oks_coverage_timezones_rec.object_version_number THEN
1278: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1273: RAISE OKC_API.G_EXCEPTION_ERROR;
1274: ELSIF lc_object_version_number > p_oks_coverage_timezones_rec.object_version_number THEN
1275: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: ELSIF lc_object_version_number <> p_oks_coverage_timezones_rec.object_version_number THEN
1278: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1279: RAISE OKC_API.G_EXCEPTION_ERROR;
1280: ELSIF lc_object_version_number = -1 THEN
1281: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1315: '_PVT'
1316: );
1317: END lock_row;
1318: --------------------------------------------
1319: -- lock_row for: OKS_COVERAGE_TIMEZONES_V --
1320: --------------------------------------------
1321: PROCEDURE lock_row(
1322: p_api_version IN NUMBER,
1323: p_init_msg_list IN VARCHAR2,
1323: p_init_msg_list IN VARCHAR2,
1324: x_return_status OUT NOCOPY VARCHAR2,
1325: x_msg_count OUT NOCOPY NUMBER,
1326: x_msg_data OUT NOCOPY VARCHAR2,
1327: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType) IS
1328:
1329: l_api_version CONSTANT NUMBER := 1;
1330: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1328:
1329: l_api_version CONSTANT NUMBER := 1;
1330: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1332: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1333: BEGIN
1334: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1335: G_PKG_NAME,
1336: p_init_msg_list,
1345: END IF;
1346: -----------------------------------------
1347: -- Move VIEW record to "Child" records --
1348: -----------------------------------------
1349: migrate(p_oks_coverage_timezones_v_rec, l_oks_coverage_timezones_rec);
1350: ---------------------------------------------
1351: -- Call the LOCK_ROW for each child record --
1352: ---------------------------------------------
1353: lock_row(
1354: p_init_msg_list,
1355: l_return_status,
1356: x_msg_count,
1357: x_msg_data,
1358: l_oks_coverage_timezones_rec
1359: );
1360: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1361: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1362: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1396: '_PVT'
1397: );
1398: END lock_row;
1399: ----------------------------------------------------------
1400: -- PL/SQL TBL lock_row for:OKS_COVERAGE_TIMEZONES_V_TBL --
1401: ----------------------------------------------------------
1402: PROCEDURE lock_row(
1403: p_api_version IN NUMBER,
1404: p_init_msg_list IN VARCHAR2,
1404: p_init_msg_list IN VARCHAR2,
1405: x_return_status OUT NOCOPY VARCHAR2,
1406: x_msg_count OUT NOCOPY NUMBER,
1407: x_msg_data OUT NOCOPY VARCHAR2,
1408: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
1409: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1410:
1411: l_api_version CONSTANT NUMBER := 1;
1412: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1413: i NUMBER := 0;
1414: BEGIN
1415: OKC_API.init_msg_list(p_init_msg_list);
1416: -- Make sure PL/SQL table has recrods in it before passing
1417: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
1418: i := p_oks_coverage_timezones_v_tbl.FIRST;
1419: LOOP
1420: DECLARE
1421: l_error_rec OKC_API.ERROR_REC_TYPE;
1414: BEGIN
1415: OKC_API.init_msg_list(p_init_msg_list);
1416: -- Make sure PL/SQL table has recrods in it before passing
1417: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
1418: i := p_oks_coverage_timezones_v_tbl.FIRST;
1419: LOOP
1420: DECLARE
1421: l_error_rec OKC_API.ERROR_REC_TYPE;
1422: BEGIN
1428: p_init_msg_list => OKC_API.G_FALSE,
1429: x_return_status => l_error_rec.error_type,
1430: x_msg_count => l_error_rec.msg_count,
1431: x_msg_data => l_error_rec.msg_data,
1432: p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i));
1433: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1434: l_error_rec.sqlcode := SQLCODE;
1435: load_error_tbl(l_error_rec, px_error_tbl);
1436: ELSE
1450: l_error_rec.error_type := 'OTHERS';
1451: l_error_rec.sqlcode := SQLCODE;
1452: load_error_tbl(l_error_rec, px_error_tbl);
1453: END;
1454: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
1455: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
1456: END LOOP;
1457: END IF;
1458: -- Loop through the error_tbl to find the error with the highest severity
1451: l_error_rec.sqlcode := SQLCODE;
1452: load_error_tbl(l_error_rec, px_error_tbl);
1453: END;
1454: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
1455: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
1456: END LOOP;
1457: END IF;
1458: -- Loop through the error_tbl to find the error with the highest severity
1459: -- and return it.
1491: '_PVT'
1492: );
1493: END lock_row;
1494: ----------------------------------------------------------
1495: -- PL/SQL TBL lock_row for:OKS_COVERAGE_TIMEZONES_V_TBL --
1496: ----------------------------------------------------------
1497: PROCEDURE lock_row(
1498: p_api_version IN NUMBER,
1499: p_init_msg_list IN VARCHAR2,
1499: p_init_msg_list IN VARCHAR2,
1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,
1502: x_msg_data OUT NOCOPY VARCHAR2,
1503: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType) IS
1504:
1505: l_api_version CONSTANT NUMBER := 1;
1506: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1507: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1508: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1509: BEGIN
1510: OKC_API.init_msg_list(p_init_msg_list);
1511: -- Make sure PL/SQL table has recrods in it before passing
1512: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
1513: lock_row(
1514: p_api_version => p_api_version,
1515: p_init_msg_list => OKC_API.G_FALSE,
1516: x_return_status => x_return_status,
1515: p_init_msg_list => OKC_API.G_FALSE,
1516: x_return_status => x_return_status,
1517: x_msg_count => x_msg_count,
1518: x_msg_data => x_msg_data,
1519: p_oks_coverage_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
1520: px_error_tbl => l_error_tbl);
1521: END IF;
1522: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1523: EXCEPTION
1555: ---------------------------------------------------------------------------
1556: -- PROCEDURE update_row
1557: ---------------------------------------------------------------------------
1558: -------------------------------------------
1559: -- update_row for:OKS_COVERAGE_TIMEZONES --
1560: -------------------------------------------
1561: PROCEDURE update_row(
1562: p_init_msg_list IN VARCHAR2,
1563: x_return_status OUT NOCOPY VARCHAR2,
1562: p_init_msg_list IN VARCHAR2,
1563: x_return_status OUT NOCOPY VARCHAR2,
1564: x_msg_count OUT NOCOPY NUMBER,
1565: x_msg_data OUT NOCOPY VARCHAR2,
1566: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
1567: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType) IS
1568:
1569: l_api_version CONSTANT NUMBER := 1;
1570: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1563: x_return_status OUT NOCOPY VARCHAR2,
1564: x_msg_count OUT NOCOPY NUMBER,
1565: x_msg_data OUT NOCOPY VARCHAR2,
1566: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
1567: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType) IS
1568:
1569: l_api_version CONSTANT NUMBER := 1;
1570: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1571: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1568:
1569: l_api_version CONSTANT NUMBER := 1;
1570: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1571: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1572: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType := p_oks_coverage_timezones_rec;
1573: LDefOksCoverageTimezonesRec OksCoverageTimezonesRecType;
1574: l_row_notfound BOOLEAN := TRUE;
1575: ----------------------------------
1576: -- FUNCTION populate_new_record --
1575: ----------------------------------
1576: -- FUNCTION populate_new_record --
1577: ----------------------------------
1578: FUNCTION populate_new_record (
1579: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
1580: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
1581: ) RETURN VARCHAR2 IS
1582: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1583: l_row_notfound BOOLEAN := TRUE;
1576: -- FUNCTION populate_new_record --
1577: ----------------------------------
1578: FUNCTION populate_new_record (
1579: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
1580: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
1581: ) RETURN VARCHAR2 IS
1582: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1583: l_row_notfound BOOLEAN := TRUE;
1584: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1578: FUNCTION populate_new_record (
1579: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
1580: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
1581: ) RETURN VARCHAR2 IS
1582: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1583: l_row_notfound BOOLEAN := TRUE;
1584: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1585: BEGIN
1586: x_oks_coverage_timezones_rec := p_oks_coverage_timezones_rec;
1582: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1583: l_row_notfound BOOLEAN := TRUE;
1584: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1585: BEGIN
1586: x_oks_coverage_timezones_rec := p_oks_coverage_timezones_rec;
1587: -- Get current database values
1588: l_oks_coverage_timezones_rec := get_rec(p_oks_coverage_timezones_rec, l_return_status);
1589: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1590: IF (x_oks_coverage_timezones_rec.id = OKC_API.G_MISS_NUM)
1584: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1585: BEGIN
1586: x_oks_coverage_timezones_rec := p_oks_coverage_timezones_rec;
1587: -- Get current database values
1588: l_oks_coverage_timezones_rec := get_rec(p_oks_coverage_timezones_rec, l_return_status);
1589: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1590: IF (x_oks_coverage_timezones_rec.id = OKC_API.G_MISS_NUM)
1591: THEN
1592: x_oks_coverage_timezones_rec.id := l_oks_coverage_timezones_rec.id;
1586: x_oks_coverage_timezones_rec := p_oks_coverage_timezones_rec;
1587: -- Get current database values
1588: l_oks_coverage_timezones_rec := get_rec(p_oks_coverage_timezones_rec, l_return_status);
1589: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1590: IF (x_oks_coverage_timezones_rec.id = OKC_API.G_MISS_NUM)
1591: THEN
1592: x_oks_coverage_timezones_rec.id := l_oks_coverage_timezones_rec.id;
1593: END IF;
1594: IF (x_oks_coverage_timezones_rec.cle_id = OKC_API.G_MISS_NUM)
1588: l_oks_coverage_timezones_rec := get_rec(p_oks_coverage_timezones_rec, l_return_status);
1589: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1590: IF (x_oks_coverage_timezones_rec.id = OKC_API.G_MISS_NUM)
1591: THEN
1592: x_oks_coverage_timezones_rec.id := l_oks_coverage_timezones_rec.id;
1593: END IF;
1594: IF (x_oks_coverage_timezones_rec.cle_id = OKC_API.G_MISS_NUM)
1595: THEN
1596: x_oks_coverage_timezones_rec.cle_id := l_oks_coverage_timezones_rec.cle_id;
1590: IF (x_oks_coverage_timezones_rec.id = OKC_API.G_MISS_NUM)
1591: THEN
1592: x_oks_coverage_timezones_rec.id := l_oks_coverage_timezones_rec.id;
1593: END IF;
1594: IF (x_oks_coverage_timezones_rec.cle_id = OKC_API.G_MISS_NUM)
1595: THEN
1596: x_oks_coverage_timezones_rec.cle_id := l_oks_coverage_timezones_rec.cle_id;
1597: END IF;
1598: IF (x_oks_coverage_timezones_rec.default_yn = OKC_API.G_MISS_CHAR)
1592: x_oks_coverage_timezones_rec.id := l_oks_coverage_timezones_rec.id;
1593: END IF;
1594: IF (x_oks_coverage_timezones_rec.cle_id = OKC_API.G_MISS_NUM)
1595: THEN
1596: x_oks_coverage_timezones_rec.cle_id := l_oks_coverage_timezones_rec.cle_id;
1597: END IF;
1598: IF (x_oks_coverage_timezones_rec.default_yn = OKC_API.G_MISS_CHAR)
1599: THEN
1600: x_oks_coverage_timezones_rec.default_yn := l_oks_coverage_timezones_rec.default_yn;
1594: IF (x_oks_coverage_timezones_rec.cle_id = OKC_API.G_MISS_NUM)
1595: THEN
1596: x_oks_coverage_timezones_rec.cle_id := l_oks_coverage_timezones_rec.cle_id;
1597: END IF;
1598: IF (x_oks_coverage_timezones_rec.default_yn = OKC_API.G_MISS_CHAR)
1599: THEN
1600: x_oks_coverage_timezones_rec.default_yn := l_oks_coverage_timezones_rec.default_yn;
1601: END IF;
1602: IF (x_oks_coverage_timezones_rec.timezone_id = OKC_API.G_MISS_NUM)
1596: x_oks_coverage_timezones_rec.cle_id := l_oks_coverage_timezones_rec.cle_id;
1597: END IF;
1598: IF (x_oks_coverage_timezones_rec.default_yn = OKC_API.G_MISS_CHAR)
1599: THEN
1600: x_oks_coverage_timezones_rec.default_yn := l_oks_coverage_timezones_rec.default_yn;
1601: END IF;
1602: IF (x_oks_coverage_timezones_rec.timezone_id = OKC_API.G_MISS_NUM)
1603: THEN
1604: x_oks_coverage_timezones_rec.timezone_id := l_oks_coverage_timezones_rec.timezone_id;
1598: IF (x_oks_coverage_timezones_rec.default_yn = OKC_API.G_MISS_CHAR)
1599: THEN
1600: x_oks_coverage_timezones_rec.default_yn := l_oks_coverage_timezones_rec.default_yn;
1601: END IF;
1602: IF (x_oks_coverage_timezones_rec.timezone_id = OKC_API.G_MISS_NUM)
1603: THEN
1604: x_oks_coverage_timezones_rec.timezone_id := l_oks_coverage_timezones_rec.timezone_id;
1605: END IF;
1606: IF (x_oks_coverage_timezones_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1600: x_oks_coverage_timezones_rec.default_yn := l_oks_coverage_timezones_rec.default_yn;
1601: END IF;
1602: IF (x_oks_coverage_timezones_rec.timezone_id = OKC_API.G_MISS_NUM)
1603: THEN
1604: x_oks_coverage_timezones_rec.timezone_id := l_oks_coverage_timezones_rec.timezone_id;
1605: END IF;
1606: IF (x_oks_coverage_timezones_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1607: THEN
1608: x_oks_coverage_timezones_rec.dnz_chr_id := l_oks_coverage_timezones_rec.dnz_chr_id;
1602: IF (x_oks_coverage_timezones_rec.timezone_id = OKC_API.G_MISS_NUM)
1603: THEN
1604: x_oks_coverage_timezones_rec.timezone_id := l_oks_coverage_timezones_rec.timezone_id;
1605: END IF;
1606: IF (x_oks_coverage_timezones_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1607: THEN
1608: x_oks_coverage_timezones_rec.dnz_chr_id := l_oks_coverage_timezones_rec.dnz_chr_id;
1609: END IF;
1610: IF (x_oks_coverage_timezones_rec.program_application_id = OKC_API.G_MISS_NUM)
1604: x_oks_coverage_timezones_rec.timezone_id := l_oks_coverage_timezones_rec.timezone_id;
1605: END IF;
1606: IF (x_oks_coverage_timezones_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1607: THEN
1608: x_oks_coverage_timezones_rec.dnz_chr_id := l_oks_coverage_timezones_rec.dnz_chr_id;
1609: END IF;
1610: IF (x_oks_coverage_timezones_rec.program_application_id = OKC_API.G_MISS_NUM)
1611: THEN
1612: x_oks_coverage_timezones_rec.program_application_id := l_oks_coverage_timezones_rec.program_application_id;
1606: IF (x_oks_coverage_timezones_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1607: THEN
1608: x_oks_coverage_timezones_rec.dnz_chr_id := l_oks_coverage_timezones_rec.dnz_chr_id;
1609: END IF;
1610: IF (x_oks_coverage_timezones_rec.program_application_id = OKC_API.G_MISS_NUM)
1611: THEN
1612: x_oks_coverage_timezones_rec.program_application_id := l_oks_coverage_timezones_rec.program_application_id;
1613: END IF;
1614: IF (x_oks_coverage_timezones_rec.program_id = OKC_API.G_MISS_NUM)
1608: x_oks_coverage_timezones_rec.dnz_chr_id := l_oks_coverage_timezones_rec.dnz_chr_id;
1609: END IF;
1610: IF (x_oks_coverage_timezones_rec.program_application_id = OKC_API.G_MISS_NUM)
1611: THEN
1612: x_oks_coverage_timezones_rec.program_application_id := l_oks_coverage_timezones_rec.program_application_id;
1613: END IF;
1614: IF (x_oks_coverage_timezones_rec.program_id = OKC_API.G_MISS_NUM)
1615: THEN
1616: x_oks_coverage_timezones_rec.program_id := l_oks_coverage_timezones_rec.program_id;
1610: IF (x_oks_coverage_timezones_rec.program_application_id = OKC_API.G_MISS_NUM)
1611: THEN
1612: x_oks_coverage_timezones_rec.program_application_id := l_oks_coverage_timezones_rec.program_application_id;
1613: END IF;
1614: IF (x_oks_coverage_timezones_rec.program_id = OKC_API.G_MISS_NUM)
1615: THEN
1616: x_oks_coverage_timezones_rec.program_id := l_oks_coverage_timezones_rec.program_id;
1617: END IF;
1618: IF (x_oks_coverage_timezones_rec.program_update_date = OKC_API.G_MISS_DATE)
1612: x_oks_coverage_timezones_rec.program_application_id := l_oks_coverage_timezones_rec.program_application_id;
1613: END IF;
1614: IF (x_oks_coverage_timezones_rec.program_id = OKC_API.G_MISS_NUM)
1615: THEN
1616: x_oks_coverage_timezones_rec.program_id := l_oks_coverage_timezones_rec.program_id;
1617: END IF;
1618: IF (x_oks_coverage_timezones_rec.program_update_date = OKC_API.G_MISS_DATE)
1619: THEN
1620: x_oks_coverage_timezones_rec.program_update_date := l_oks_coverage_timezones_rec.program_update_date;
1614: IF (x_oks_coverage_timezones_rec.program_id = OKC_API.G_MISS_NUM)
1615: THEN
1616: x_oks_coverage_timezones_rec.program_id := l_oks_coverage_timezones_rec.program_id;
1617: END IF;
1618: IF (x_oks_coverage_timezones_rec.program_update_date = OKC_API.G_MISS_DATE)
1619: THEN
1620: x_oks_coverage_timezones_rec.program_update_date := l_oks_coverage_timezones_rec.program_update_date;
1621: END IF;
1622: IF (x_oks_coverage_timezones_rec.request_id = OKC_API.G_MISS_NUM)
1616: x_oks_coverage_timezones_rec.program_id := l_oks_coverage_timezones_rec.program_id;
1617: END IF;
1618: IF (x_oks_coverage_timezones_rec.program_update_date = OKC_API.G_MISS_DATE)
1619: THEN
1620: x_oks_coverage_timezones_rec.program_update_date := l_oks_coverage_timezones_rec.program_update_date;
1621: END IF;
1622: IF (x_oks_coverage_timezones_rec.request_id = OKC_API.G_MISS_NUM)
1623: THEN
1624: x_oks_coverage_timezones_rec.request_id := l_oks_coverage_timezones_rec.request_id;
1618: IF (x_oks_coverage_timezones_rec.program_update_date = OKC_API.G_MISS_DATE)
1619: THEN
1620: x_oks_coverage_timezones_rec.program_update_date := l_oks_coverage_timezones_rec.program_update_date;
1621: END IF;
1622: IF (x_oks_coverage_timezones_rec.request_id = OKC_API.G_MISS_NUM)
1623: THEN
1624: x_oks_coverage_timezones_rec.request_id := l_oks_coverage_timezones_rec.request_id;
1625: END IF;
1626: IF (x_oks_coverage_timezones_rec.created_by = OKC_API.G_MISS_NUM)
1620: x_oks_coverage_timezones_rec.program_update_date := l_oks_coverage_timezones_rec.program_update_date;
1621: END IF;
1622: IF (x_oks_coverage_timezones_rec.request_id = OKC_API.G_MISS_NUM)
1623: THEN
1624: x_oks_coverage_timezones_rec.request_id := l_oks_coverage_timezones_rec.request_id;
1625: END IF;
1626: IF (x_oks_coverage_timezones_rec.created_by = OKC_API.G_MISS_NUM)
1627: THEN
1628: x_oks_coverage_timezones_rec.created_by := l_oks_coverage_timezones_rec.created_by;
1622: IF (x_oks_coverage_timezones_rec.request_id = OKC_API.G_MISS_NUM)
1623: THEN
1624: x_oks_coverage_timezones_rec.request_id := l_oks_coverage_timezones_rec.request_id;
1625: END IF;
1626: IF (x_oks_coverage_timezones_rec.created_by = OKC_API.G_MISS_NUM)
1627: THEN
1628: x_oks_coverage_timezones_rec.created_by := l_oks_coverage_timezones_rec.created_by;
1629: END IF;
1630: IF (x_oks_coverage_timezones_rec.creation_date = OKC_API.G_MISS_DATE)
1624: x_oks_coverage_timezones_rec.request_id := l_oks_coverage_timezones_rec.request_id;
1625: END IF;
1626: IF (x_oks_coverage_timezones_rec.created_by = OKC_API.G_MISS_NUM)
1627: THEN
1628: x_oks_coverage_timezones_rec.created_by := l_oks_coverage_timezones_rec.created_by;
1629: END IF;
1630: IF (x_oks_coverage_timezones_rec.creation_date = OKC_API.G_MISS_DATE)
1631: THEN
1632: x_oks_coverage_timezones_rec.creation_date := l_oks_coverage_timezones_rec.creation_date;
1626: IF (x_oks_coverage_timezones_rec.created_by = OKC_API.G_MISS_NUM)
1627: THEN
1628: x_oks_coverage_timezones_rec.created_by := l_oks_coverage_timezones_rec.created_by;
1629: END IF;
1630: IF (x_oks_coverage_timezones_rec.creation_date = OKC_API.G_MISS_DATE)
1631: THEN
1632: x_oks_coverage_timezones_rec.creation_date := l_oks_coverage_timezones_rec.creation_date;
1633: END IF;
1634: IF (x_oks_coverage_timezones_rec.last_updated_by = OKC_API.G_MISS_NUM)
1628: x_oks_coverage_timezones_rec.created_by := l_oks_coverage_timezones_rec.created_by;
1629: END IF;
1630: IF (x_oks_coverage_timezones_rec.creation_date = OKC_API.G_MISS_DATE)
1631: THEN
1632: x_oks_coverage_timezones_rec.creation_date := l_oks_coverage_timezones_rec.creation_date;
1633: END IF;
1634: IF (x_oks_coverage_timezones_rec.last_updated_by = OKC_API.G_MISS_NUM)
1635: THEN
1636: x_oks_coverage_timezones_rec.last_updated_by := l_oks_coverage_timezones_rec.last_updated_by;
1630: IF (x_oks_coverage_timezones_rec.creation_date = OKC_API.G_MISS_DATE)
1631: THEN
1632: x_oks_coverage_timezones_rec.creation_date := l_oks_coverage_timezones_rec.creation_date;
1633: END IF;
1634: IF (x_oks_coverage_timezones_rec.last_updated_by = OKC_API.G_MISS_NUM)
1635: THEN
1636: x_oks_coverage_timezones_rec.last_updated_by := l_oks_coverage_timezones_rec.last_updated_by;
1637: END IF;
1638: IF (x_oks_coverage_timezones_rec.last_update_date = OKC_API.G_MISS_DATE)
1632: x_oks_coverage_timezones_rec.creation_date := l_oks_coverage_timezones_rec.creation_date;
1633: END IF;
1634: IF (x_oks_coverage_timezones_rec.last_updated_by = OKC_API.G_MISS_NUM)
1635: THEN
1636: x_oks_coverage_timezones_rec.last_updated_by := l_oks_coverage_timezones_rec.last_updated_by;
1637: END IF;
1638: IF (x_oks_coverage_timezones_rec.last_update_date = OKC_API.G_MISS_DATE)
1639: THEN
1640: x_oks_coverage_timezones_rec.last_update_date := l_oks_coverage_timezones_rec.last_update_date;
1634: IF (x_oks_coverage_timezones_rec.last_updated_by = OKC_API.G_MISS_NUM)
1635: THEN
1636: x_oks_coverage_timezones_rec.last_updated_by := l_oks_coverage_timezones_rec.last_updated_by;
1637: END IF;
1638: IF (x_oks_coverage_timezones_rec.last_update_date = OKC_API.G_MISS_DATE)
1639: THEN
1640: x_oks_coverage_timezones_rec.last_update_date := l_oks_coverage_timezones_rec.last_update_date;
1641: END IF;
1642: IF (x_oks_coverage_timezones_rec.last_update_login = OKC_API.G_MISS_NUM)
1636: x_oks_coverage_timezones_rec.last_updated_by := l_oks_coverage_timezones_rec.last_updated_by;
1637: END IF;
1638: IF (x_oks_coverage_timezones_rec.last_update_date = OKC_API.G_MISS_DATE)
1639: THEN
1640: x_oks_coverage_timezones_rec.last_update_date := l_oks_coverage_timezones_rec.last_update_date;
1641: END IF;
1642: IF (x_oks_coverage_timezones_rec.last_update_login = OKC_API.G_MISS_NUM)
1643: THEN
1644: x_oks_coverage_timezones_rec.last_update_login := l_oks_coverage_timezones_rec.last_update_login;
1638: IF (x_oks_coverage_timezones_rec.last_update_date = OKC_API.G_MISS_DATE)
1639: THEN
1640: x_oks_coverage_timezones_rec.last_update_date := l_oks_coverage_timezones_rec.last_update_date;
1641: END IF;
1642: IF (x_oks_coverage_timezones_rec.last_update_login = OKC_API.G_MISS_NUM)
1643: THEN
1644: x_oks_coverage_timezones_rec.last_update_login := l_oks_coverage_timezones_rec.last_update_login;
1645: END IF;
1646: IF (x_oks_coverage_timezones_rec.object_version_number = OKC_API.G_MISS_NUM)
1640: x_oks_coverage_timezones_rec.last_update_date := l_oks_coverage_timezones_rec.last_update_date;
1641: END IF;
1642: IF (x_oks_coverage_timezones_rec.last_update_login = OKC_API.G_MISS_NUM)
1643: THEN
1644: x_oks_coverage_timezones_rec.last_update_login := l_oks_coverage_timezones_rec.last_update_login;
1645: END IF;
1646: IF (x_oks_coverage_timezones_rec.object_version_number = OKC_API.G_MISS_NUM)
1647: THEN
1648: x_oks_coverage_timezones_rec.object_version_number := l_oks_coverage_timezones_rec.object_version_number;
1642: IF (x_oks_coverage_timezones_rec.last_update_login = OKC_API.G_MISS_NUM)
1643: THEN
1644: x_oks_coverage_timezones_rec.last_update_login := l_oks_coverage_timezones_rec.last_update_login;
1645: END IF;
1646: IF (x_oks_coverage_timezones_rec.object_version_number = OKC_API.G_MISS_NUM)
1647: THEN
1648: x_oks_coverage_timezones_rec.object_version_number := l_oks_coverage_timezones_rec.object_version_number;
1649: END IF;
1650: -- R12 Data Model Changes 4485150 Start
1644: x_oks_coverage_timezones_rec.last_update_login := l_oks_coverage_timezones_rec.last_update_login;
1645: END IF;
1646: IF (x_oks_coverage_timezones_rec.object_version_number = OKC_API.G_MISS_NUM)
1647: THEN
1648: x_oks_coverage_timezones_rec.object_version_number := l_oks_coverage_timezones_rec.object_version_number;
1649: END IF;
1650: -- R12 Data Model Changes 4485150 Start
1651: IF (x_oks_coverage_timezones_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1652: THEN
1647: THEN
1648: x_oks_coverage_timezones_rec.object_version_number := l_oks_coverage_timezones_rec.object_version_number;
1649: END IF;
1650: -- R12 Data Model Changes 4485150 Start
1651: IF (x_oks_coverage_timezones_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1652: THEN
1653: x_oks_coverage_timezones_rec.orig_system_id1 := l_oks_coverage_timezones_rec.orig_system_id1;
1654: END IF;
1655: IF (x_oks_coverage_timezones_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1649: END IF;
1650: -- R12 Data Model Changes 4485150 Start
1651: IF (x_oks_coverage_timezones_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1652: THEN
1653: x_oks_coverage_timezones_rec.orig_system_id1 := l_oks_coverage_timezones_rec.orig_system_id1;
1654: END IF;
1655: IF (x_oks_coverage_timezones_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1656: THEN
1657: x_oks_coverage_timezones_rec.orig_system_reference1 := l_oks_coverage_timezones_rec.orig_system_reference1;
1651: IF (x_oks_coverage_timezones_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1652: THEN
1653: x_oks_coverage_timezones_rec.orig_system_id1 := l_oks_coverage_timezones_rec.orig_system_id1;
1654: END IF;
1655: IF (x_oks_coverage_timezones_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1656: THEN
1657: x_oks_coverage_timezones_rec.orig_system_reference1 := l_oks_coverage_timezones_rec.orig_system_reference1;
1658: END IF;
1659: IF (x_oks_coverage_timezones_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1653: x_oks_coverage_timezones_rec.orig_system_id1 := l_oks_coverage_timezones_rec.orig_system_id1;
1654: END IF;
1655: IF (x_oks_coverage_timezones_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1656: THEN
1657: x_oks_coverage_timezones_rec.orig_system_reference1 := l_oks_coverage_timezones_rec.orig_system_reference1;
1658: END IF;
1659: IF (x_oks_coverage_timezones_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1660: THEN
1661: x_oks_coverage_timezones_rec.orig_system_source_code := l_oks_coverage_timezones_rec.orig_system_source_code;
1655: IF (x_oks_coverage_timezones_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1656: THEN
1657: x_oks_coverage_timezones_rec.orig_system_reference1 := l_oks_coverage_timezones_rec.orig_system_reference1;
1658: END IF;
1659: IF (x_oks_coverage_timezones_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1660: THEN
1661: x_oks_coverage_timezones_rec.orig_system_source_code := l_oks_coverage_timezones_rec.orig_system_source_code;
1662: END IF;
1663: -- R12 Data Model Changes 4485150 End
1657: x_oks_coverage_timezones_rec.orig_system_reference1 := l_oks_coverage_timezones_rec.orig_system_reference1;
1658: END IF;
1659: IF (x_oks_coverage_timezones_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1660: THEN
1661: x_oks_coverage_timezones_rec.orig_system_source_code := l_oks_coverage_timezones_rec.orig_system_source_code;
1662: END IF;
1663: -- R12 Data Model Changes 4485150 End
1664: END IF;
1665: RETURN(l_return_status);
1664: END IF;
1665: RETURN(l_return_status);
1666: END populate_new_record;
1667: -----------------------------------------------
1668: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES --
1669: -----------------------------------------------
1670: FUNCTION Set_Attributes (
1671: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
1672: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
1667: -----------------------------------------------
1668: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES --
1669: -----------------------------------------------
1670: FUNCTION Set_Attributes (
1671: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
1672: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
1673: ) RETURN VARCHAR2 IS
1674: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1675: BEGIN
1668: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES --
1669: -----------------------------------------------
1670: FUNCTION Set_Attributes (
1671: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType,
1672: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
1673: ) RETURN VARCHAR2 IS
1674: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1675: BEGIN
1676: x_oks_coverage_timezones_rec := p_oks_coverage_timezones_rec;
1672: x_oks_coverage_timezones_rec OUT NOCOPY OksCoverageTimezonesRecType
1673: ) RETURN VARCHAR2 IS
1674: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1675: BEGIN
1676: x_oks_coverage_timezones_rec := p_oks_coverage_timezones_rec;
1677: x_oks_coverage_timezones_rec.OBJECT_VERSION_NUMBER := p_oks_coverage_timezones_rec.OBJECT_VERSION_NUMBER + 1;
1678: RETURN(l_return_status);
1679: END Set_Attributes;
1680: BEGIN
1673: ) RETURN VARCHAR2 IS
1674: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1675: BEGIN
1676: x_oks_coverage_timezones_rec := p_oks_coverage_timezones_rec;
1677: x_oks_coverage_timezones_rec.OBJECT_VERSION_NUMBER := p_oks_coverage_timezones_rec.OBJECT_VERSION_NUMBER + 1;
1678: RETURN(l_return_status);
1679: END Set_Attributes;
1680: BEGIN
1681: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1688: RAISE OKC_API.G_EXCEPTION_ERROR;
1689: END IF;
1690: --- Setting item attributes
1691: l_return_status := Set_Attributes(
1692: p_oks_coverage_timezones_rec, -- IN
1693: l_oks_coverage_timezones_rec); -- OUT
1694: --- If any errors happen abort API
1695: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1696: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1689: END IF;
1690: --- Setting item attributes
1691: l_return_status := Set_Attributes(
1692: p_oks_coverage_timezones_rec, -- IN
1693: l_oks_coverage_timezones_rec); -- OUT
1694: --- If any errors happen abort API
1695: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1696: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1697: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1696: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1697: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1698: RAISE OKC_API.G_EXCEPTION_ERROR;
1699: END IF;
1700: l_return_status := populate_new_record(l_oks_coverage_timezones_rec, LDefOksCoverageTimezonesRec);
1701: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1702: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1703: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1704: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1703: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1704: RAISE OKC_API.G_EXCEPTION_ERROR;
1705: END IF;
1706: UPDATE OKS_COVERAGE_TIMEZONES
1707: SET CLE_ID = LDefOksCoverageTimezonesRec.cle_id,
1708: DEFAULT_YN = LDefOksCoverageTimezonesRec.default_yn,
1709: TIMEZONE_ID = LDefOksCoverageTimezonesRec.timezone_id,
1710: DNZ_CHR_ID = LDefOksCoverageTimezonesRec.dnz_chr_id,
1724: ORIG_SYSTEM_SOURCE_CODE = LDefOksCoverageTimezonesRec.orig_system_source_code
1725: -- R12 Data Model Changes 4485150 End
1726: WHERE ID = LDefOksCoverageTimezonesRec.id;
1727:
1728: x_oks_coverage_timezones_rec := l_oks_coverage_timezones_rec;
1729: x_return_status := l_return_status;
1730: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1731: EXCEPTION
1732: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1760: '_PVT'
1761: );
1762: END update_row;
1763: ---------------------------------------------
1764: -- update_row for:OKS_COVERAGE_TIMEZONES_V --
1765: ---------------------------------------------
1766: PROCEDURE update_row(
1767: p_api_version IN NUMBER,
1768: p_init_msg_list IN VARCHAR2,
1768: p_init_msg_list IN VARCHAR2,
1769: x_return_status OUT NOCOPY VARCHAR2,
1770: x_msg_count OUT NOCOPY NUMBER,
1771: x_msg_data OUT NOCOPY VARCHAR2,
1772: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
1773: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType) IS
1774:
1775: l_api_version CONSTANT NUMBER := 1;
1776: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1769: x_return_status OUT NOCOPY VARCHAR2,
1770: x_msg_count OUT NOCOPY NUMBER,
1771: x_msg_data OUT NOCOPY VARCHAR2,
1772: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
1773: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType) IS
1774:
1775: l_api_version CONSTANT NUMBER := 1;
1776: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1774:
1775: l_api_version CONSTANT NUMBER := 1;
1776: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1778: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
1779: LDefOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
1780: l_db_oks_coverage_tim44 OksCoverageTimezonesVRecType;
1781: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1782: lx_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1778: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
1779: LDefOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
1780: l_db_oks_coverage_tim44 OksCoverageTimezonesVRecType;
1781: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1782: lx_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1783: -------------------------------
1784: -- FUNCTION fill_who_columns --
1785: -------------------------------
1778: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
1779: LDefOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
1780: l_db_oks_coverage_tim44 OksCoverageTimezonesVRecType;
1781: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1782: lx_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
1783: -------------------------------
1784: -- FUNCTION fill_who_columns --
1785: -------------------------------
1786: FUNCTION fill_who_columns (
1783: -------------------------------
1784: -- FUNCTION fill_who_columns --
1785: -------------------------------
1786: FUNCTION fill_who_columns (
1787: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
1788: ) RETURN OksCoverageTimezonesVRecType IS
1789: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
1790: BEGIN
1791: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := SYSDATE;
1785: -------------------------------
1786: FUNCTION fill_who_columns (
1787: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
1788: ) RETURN OksCoverageTimezonesVRecType IS
1789: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
1790: BEGIN
1791: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := SYSDATE;
1792: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1793: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1787: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType
1788: ) RETURN OksCoverageTimezonesVRecType IS
1789: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
1790: BEGIN
1791: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := SYSDATE;
1792: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1793: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1794: RETURN(l_oks_coverage_timezones_v_rec);
1795: END fill_who_columns;
1788: ) RETURN OksCoverageTimezonesVRecType IS
1789: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
1790: BEGIN
1791: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := SYSDATE;
1792: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1793: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1794: RETURN(l_oks_coverage_timezones_v_rec);
1795: END fill_who_columns;
1796: ----------------------------------
1789: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
1790: BEGIN
1791: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := SYSDATE;
1792: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1793: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1794: RETURN(l_oks_coverage_timezones_v_rec);
1795: END fill_who_columns;
1796: ----------------------------------
1797: -- FUNCTION populate_new_record --
1790: BEGIN
1791: l_oks_coverage_timezones_v_rec.LAST_UPDATE_DATE := SYSDATE;
1792: l_oks_coverage_timezones_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1793: l_oks_coverage_timezones_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1794: RETURN(l_oks_coverage_timezones_v_rec);
1795: END fill_who_columns;
1796: ----------------------------------
1797: -- FUNCTION populate_new_record --
1798: ----------------------------------
1796: ----------------------------------
1797: -- FUNCTION populate_new_record --
1798: ----------------------------------
1799: FUNCTION populate_new_record (
1800: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
1801: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
1802: ) RETURN VARCHAR2 IS
1803: l_row_notfound BOOLEAN := TRUE;
1804: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1797: -- FUNCTION populate_new_record --
1798: ----------------------------------
1799: FUNCTION populate_new_record (
1800: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
1801: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
1802: ) RETURN VARCHAR2 IS
1803: l_row_notfound BOOLEAN := TRUE;
1804: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1805: BEGIN
1802: ) RETURN VARCHAR2 IS
1803: l_row_notfound BOOLEAN := TRUE;
1804: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1805: BEGIN
1806: x_oks_coverage_timezones_v_rec := p_oks_coverage_timezones_v_rec;
1807: -- Get current database values
1808: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1809: -- so it may be verified through LOCK_ROW.
1810: l_db_oks_coverage_tim44 := get_rec(p_oks_coverage_timezones_v_rec, l_return_status);
1806: x_oks_coverage_timezones_v_rec := p_oks_coverage_timezones_v_rec;
1807: -- Get current database values
1808: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1809: -- so it may be verified through LOCK_ROW.
1810: l_db_oks_coverage_tim44 := get_rec(p_oks_coverage_timezones_v_rec, l_return_status);
1811: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1812: IF (x_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM)
1813: THEN
1814: x_oks_coverage_timezones_v_rec.id := l_db_oks_coverage_tim44.id;
1808: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1809: -- so it may be verified through LOCK_ROW.
1810: l_db_oks_coverage_tim44 := get_rec(p_oks_coverage_timezones_v_rec, l_return_status);
1811: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1812: IF (x_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM)
1813: THEN
1814: x_oks_coverage_timezones_v_rec.id := l_db_oks_coverage_tim44.id;
1815: END IF;
1816: IF (x_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM)
1810: l_db_oks_coverage_tim44 := get_rec(p_oks_coverage_timezones_v_rec, l_return_status);
1811: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1812: IF (x_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM)
1813: THEN
1814: x_oks_coverage_timezones_v_rec.id := l_db_oks_coverage_tim44.id;
1815: END IF;
1816: IF (x_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM)
1817: THEN
1818: x_oks_coverage_timezones_v_rec.cle_id := l_db_oks_coverage_tim44.cle_id;
1812: IF (x_oks_coverage_timezones_v_rec.id = OKC_API.G_MISS_NUM)
1813: THEN
1814: x_oks_coverage_timezones_v_rec.id := l_db_oks_coverage_tim44.id;
1815: END IF;
1816: IF (x_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM)
1817: THEN
1818: x_oks_coverage_timezones_v_rec.cle_id := l_db_oks_coverage_tim44.cle_id;
1819: END IF;
1820: IF (x_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR)
1814: x_oks_coverage_timezones_v_rec.id := l_db_oks_coverage_tim44.id;
1815: END IF;
1816: IF (x_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM)
1817: THEN
1818: x_oks_coverage_timezones_v_rec.cle_id := l_db_oks_coverage_tim44.cle_id;
1819: END IF;
1820: IF (x_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR)
1821: THEN
1822: x_oks_coverage_timezones_v_rec.default_yn := l_db_oks_coverage_tim44.default_yn;
1816: IF (x_oks_coverage_timezones_v_rec.cle_id = OKC_API.G_MISS_NUM)
1817: THEN
1818: x_oks_coverage_timezones_v_rec.cle_id := l_db_oks_coverage_tim44.cle_id;
1819: END IF;
1820: IF (x_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR)
1821: THEN
1822: x_oks_coverage_timezones_v_rec.default_yn := l_db_oks_coverage_tim44.default_yn;
1823: END IF;
1824: IF (x_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM)
1818: x_oks_coverage_timezones_v_rec.cle_id := l_db_oks_coverage_tim44.cle_id;
1819: END IF;
1820: IF (x_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR)
1821: THEN
1822: x_oks_coverage_timezones_v_rec.default_yn := l_db_oks_coverage_tim44.default_yn;
1823: END IF;
1824: IF (x_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM)
1825: THEN
1826: x_oks_coverage_timezones_v_rec.timezone_id := l_db_oks_coverage_tim44.timezone_id;
1820: IF (x_oks_coverage_timezones_v_rec.default_yn = OKC_API.G_MISS_CHAR)
1821: THEN
1822: x_oks_coverage_timezones_v_rec.default_yn := l_db_oks_coverage_tim44.default_yn;
1823: END IF;
1824: IF (x_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM)
1825: THEN
1826: x_oks_coverage_timezones_v_rec.timezone_id := l_db_oks_coverage_tim44.timezone_id;
1827: END IF;
1828: IF (x_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1822: x_oks_coverage_timezones_v_rec.default_yn := l_db_oks_coverage_tim44.default_yn;
1823: END IF;
1824: IF (x_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM)
1825: THEN
1826: x_oks_coverage_timezones_v_rec.timezone_id := l_db_oks_coverage_tim44.timezone_id;
1827: END IF;
1828: IF (x_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1829: THEN
1830: x_oks_coverage_timezones_v_rec.dnz_chr_id := l_db_oks_coverage_tim44.dnz_chr_id;
1824: IF (x_oks_coverage_timezones_v_rec.timezone_id = OKC_API.G_MISS_NUM)
1825: THEN
1826: x_oks_coverage_timezones_v_rec.timezone_id := l_db_oks_coverage_tim44.timezone_id;
1827: END IF;
1828: IF (x_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1829: THEN
1830: x_oks_coverage_timezones_v_rec.dnz_chr_id := l_db_oks_coverage_tim44.dnz_chr_id;
1831: END IF;
1832: IF (x_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1826: x_oks_coverage_timezones_v_rec.timezone_id := l_db_oks_coverage_tim44.timezone_id;
1827: END IF;
1828: IF (x_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1829: THEN
1830: x_oks_coverage_timezones_v_rec.dnz_chr_id := l_db_oks_coverage_tim44.dnz_chr_id;
1831: END IF;
1832: IF (x_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1833: THEN
1834: x_oks_coverage_timezones_v_rec.security_group_id := l_db_oks_coverage_tim44.security_group_id;
1828: IF (x_oks_coverage_timezones_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1829: THEN
1830: x_oks_coverage_timezones_v_rec.dnz_chr_id := l_db_oks_coverage_tim44.dnz_chr_id;
1831: END IF;
1832: IF (x_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1833: THEN
1834: x_oks_coverage_timezones_v_rec.security_group_id := l_db_oks_coverage_tim44.security_group_id;
1835: END IF;
1836: IF (x_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1830: x_oks_coverage_timezones_v_rec.dnz_chr_id := l_db_oks_coverage_tim44.dnz_chr_id;
1831: END IF;
1832: IF (x_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1833: THEN
1834: x_oks_coverage_timezones_v_rec.security_group_id := l_db_oks_coverage_tim44.security_group_id;
1835: END IF;
1836: IF (x_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1837: THEN
1838: x_oks_coverage_timezones_v_rec.program_application_id := l_db_oks_coverage_tim44.program_application_id;
1832: IF (x_oks_coverage_timezones_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1833: THEN
1834: x_oks_coverage_timezones_v_rec.security_group_id := l_db_oks_coverage_tim44.security_group_id;
1835: END IF;
1836: IF (x_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1837: THEN
1838: x_oks_coverage_timezones_v_rec.program_application_id := l_db_oks_coverage_tim44.program_application_id;
1839: END IF;
1840: IF (x_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM)
1834: x_oks_coverage_timezones_v_rec.security_group_id := l_db_oks_coverage_tim44.security_group_id;
1835: END IF;
1836: IF (x_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1837: THEN
1838: x_oks_coverage_timezones_v_rec.program_application_id := l_db_oks_coverage_tim44.program_application_id;
1839: END IF;
1840: IF (x_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM)
1841: THEN
1842: x_oks_coverage_timezones_v_rec.program_id := l_db_oks_coverage_tim44.program_id;
1836: IF (x_oks_coverage_timezones_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1837: THEN
1838: x_oks_coverage_timezones_v_rec.program_application_id := l_db_oks_coverage_tim44.program_application_id;
1839: END IF;
1840: IF (x_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM)
1841: THEN
1842: x_oks_coverage_timezones_v_rec.program_id := l_db_oks_coverage_tim44.program_id;
1843: END IF;
1844: IF (x_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1838: x_oks_coverage_timezones_v_rec.program_application_id := l_db_oks_coverage_tim44.program_application_id;
1839: END IF;
1840: IF (x_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM)
1841: THEN
1842: x_oks_coverage_timezones_v_rec.program_id := l_db_oks_coverage_tim44.program_id;
1843: END IF;
1844: IF (x_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1845: THEN
1846: x_oks_coverage_timezones_v_rec.program_update_date := l_db_oks_coverage_tim44.program_update_date;
1840: IF (x_oks_coverage_timezones_v_rec.program_id = OKC_API.G_MISS_NUM)
1841: THEN
1842: x_oks_coverage_timezones_v_rec.program_id := l_db_oks_coverage_tim44.program_id;
1843: END IF;
1844: IF (x_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1845: THEN
1846: x_oks_coverage_timezones_v_rec.program_update_date := l_db_oks_coverage_tim44.program_update_date;
1847: END IF;
1848: IF (x_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM)
1842: x_oks_coverage_timezones_v_rec.program_id := l_db_oks_coverage_tim44.program_id;
1843: END IF;
1844: IF (x_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1845: THEN
1846: x_oks_coverage_timezones_v_rec.program_update_date := l_db_oks_coverage_tim44.program_update_date;
1847: END IF;
1848: IF (x_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM)
1849: THEN
1850: x_oks_coverage_timezones_v_rec.request_id := l_db_oks_coverage_tim44.request_id;
1844: IF (x_oks_coverage_timezones_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1845: THEN
1846: x_oks_coverage_timezones_v_rec.program_update_date := l_db_oks_coverage_tim44.program_update_date;
1847: END IF;
1848: IF (x_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM)
1849: THEN
1850: x_oks_coverage_timezones_v_rec.request_id := l_db_oks_coverage_tim44.request_id;
1851: END IF;
1852: IF (x_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM)
1846: x_oks_coverage_timezones_v_rec.program_update_date := l_db_oks_coverage_tim44.program_update_date;
1847: END IF;
1848: IF (x_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM)
1849: THEN
1850: x_oks_coverage_timezones_v_rec.request_id := l_db_oks_coverage_tim44.request_id;
1851: END IF;
1852: IF (x_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM)
1853: THEN
1854: x_oks_coverage_timezones_v_rec.created_by := l_db_oks_coverage_tim44.created_by;
1848: IF (x_oks_coverage_timezones_v_rec.request_id = OKC_API.G_MISS_NUM)
1849: THEN
1850: x_oks_coverage_timezones_v_rec.request_id := l_db_oks_coverage_tim44.request_id;
1851: END IF;
1852: IF (x_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM)
1853: THEN
1854: x_oks_coverage_timezones_v_rec.created_by := l_db_oks_coverage_tim44.created_by;
1855: END IF;
1856: IF (x_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE)
1850: x_oks_coverage_timezones_v_rec.request_id := l_db_oks_coverage_tim44.request_id;
1851: END IF;
1852: IF (x_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM)
1853: THEN
1854: x_oks_coverage_timezones_v_rec.created_by := l_db_oks_coverage_tim44.created_by;
1855: END IF;
1856: IF (x_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE)
1857: THEN
1858: x_oks_coverage_timezones_v_rec.creation_date := l_db_oks_coverage_tim44.creation_date;
1852: IF (x_oks_coverage_timezones_v_rec.created_by = OKC_API.G_MISS_NUM)
1853: THEN
1854: x_oks_coverage_timezones_v_rec.created_by := l_db_oks_coverage_tim44.created_by;
1855: END IF;
1856: IF (x_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE)
1857: THEN
1858: x_oks_coverage_timezones_v_rec.creation_date := l_db_oks_coverage_tim44.creation_date;
1859: END IF;
1860: IF (x_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1854: x_oks_coverage_timezones_v_rec.created_by := l_db_oks_coverage_tim44.created_by;
1855: END IF;
1856: IF (x_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE)
1857: THEN
1858: x_oks_coverage_timezones_v_rec.creation_date := l_db_oks_coverage_tim44.creation_date;
1859: END IF;
1860: IF (x_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1861: THEN
1862: x_oks_coverage_timezones_v_rec.last_updated_by := l_db_oks_coverage_tim44.last_updated_by;
1856: IF (x_oks_coverage_timezones_v_rec.creation_date = OKC_API.G_MISS_DATE)
1857: THEN
1858: x_oks_coverage_timezones_v_rec.creation_date := l_db_oks_coverage_tim44.creation_date;
1859: END IF;
1860: IF (x_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1861: THEN
1862: x_oks_coverage_timezones_v_rec.last_updated_by := l_db_oks_coverage_tim44.last_updated_by;
1863: END IF;
1864: IF (x_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1858: x_oks_coverage_timezones_v_rec.creation_date := l_db_oks_coverage_tim44.creation_date;
1859: END IF;
1860: IF (x_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1861: THEN
1862: x_oks_coverage_timezones_v_rec.last_updated_by := l_db_oks_coverage_tim44.last_updated_by;
1863: END IF;
1864: IF (x_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1865: THEN
1866: x_oks_coverage_timezones_v_rec.last_update_date := l_db_oks_coverage_tim44.last_update_date;
1860: IF (x_oks_coverage_timezones_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1861: THEN
1862: x_oks_coverage_timezones_v_rec.last_updated_by := l_db_oks_coverage_tim44.last_updated_by;
1863: END IF;
1864: IF (x_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1865: THEN
1866: x_oks_coverage_timezones_v_rec.last_update_date := l_db_oks_coverage_tim44.last_update_date;
1867: END IF;
1868: IF (x_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1862: x_oks_coverage_timezones_v_rec.last_updated_by := l_db_oks_coverage_tim44.last_updated_by;
1863: END IF;
1864: IF (x_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1865: THEN
1866: x_oks_coverage_timezones_v_rec.last_update_date := l_db_oks_coverage_tim44.last_update_date;
1867: END IF;
1868: IF (x_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1869: THEN
1870: x_oks_coverage_timezones_v_rec.last_update_login := l_db_oks_coverage_tim44.last_update_login;
1864: IF (x_oks_coverage_timezones_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1865: THEN
1866: x_oks_coverage_timezones_v_rec.last_update_date := l_db_oks_coverage_tim44.last_update_date;
1867: END IF;
1868: IF (x_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1869: THEN
1870: x_oks_coverage_timezones_v_rec.last_update_login := l_db_oks_coverage_tim44.last_update_login;
1871: END IF;
1872: -- R12 Data Model Changes 4485150 Start
1866: x_oks_coverage_timezones_v_rec.last_update_date := l_db_oks_coverage_tim44.last_update_date;
1867: END IF;
1868: IF (x_oks_coverage_timezones_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1869: THEN
1870: x_oks_coverage_timezones_v_rec.last_update_login := l_db_oks_coverage_tim44.last_update_login;
1871: END IF;
1872: -- R12 Data Model Changes 4485150 Start
1873: IF (x_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1874: THEN
1869: THEN
1870: x_oks_coverage_timezones_v_rec.last_update_login := l_db_oks_coverage_tim44.last_update_login;
1871: END IF;
1872: -- R12 Data Model Changes 4485150 Start
1873: IF (x_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1874: THEN
1875: x_oks_coverage_timezones_v_rec.orig_system_id1 := l_db_oks_coverage_tim44.orig_system_id1;
1876: END IF;
1877: IF (x_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1871: END IF;
1872: -- R12 Data Model Changes 4485150 Start
1873: IF (x_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1874: THEN
1875: x_oks_coverage_timezones_v_rec.orig_system_id1 := l_db_oks_coverage_tim44.orig_system_id1;
1876: END IF;
1877: IF (x_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1878: THEN
1879: x_oks_coverage_timezones_v_rec.orig_system_reference1 := l_db_oks_coverage_tim44.orig_system_reference1;
1873: IF (x_oks_coverage_timezones_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1874: THEN
1875: x_oks_coverage_timezones_v_rec.orig_system_id1 := l_db_oks_coverage_tim44.orig_system_id1;
1876: END IF;
1877: IF (x_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1878: THEN
1879: x_oks_coverage_timezones_v_rec.orig_system_reference1 := l_db_oks_coverage_tim44.orig_system_reference1;
1880: END IF;
1881: IF (x_oks_coverage_timezones_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1875: x_oks_coverage_timezones_v_rec.orig_system_id1 := l_db_oks_coverage_tim44.orig_system_id1;
1876: END IF;
1877: IF (x_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1878: THEN
1879: x_oks_coverage_timezones_v_rec.orig_system_reference1 := l_db_oks_coverage_tim44.orig_system_reference1;
1880: END IF;
1881: IF (x_oks_coverage_timezones_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1882: THEN
1883: x_oks_coverage_timezones_v_rec.orig_system_source_code := l_db_oks_coverage_tim44.orig_system_source_code;
1877: IF (x_oks_coverage_timezones_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1878: THEN
1879: x_oks_coverage_timezones_v_rec.orig_system_reference1 := l_db_oks_coverage_tim44.orig_system_reference1;
1880: END IF;
1881: IF (x_oks_coverage_timezones_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1882: THEN
1883: x_oks_coverage_timezones_v_rec.orig_system_source_code := l_db_oks_coverage_tim44.orig_system_source_code;
1884: END IF;
1885: -- R12 Data Model Changes 4485150 End
1879: x_oks_coverage_timezones_v_rec.orig_system_reference1 := l_db_oks_coverage_tim44.orig_system_reference1;
1880: END IF;
1881: IF (x_oks_coverage_timezones_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1882: THEN
1883: x_oks_coverage_timezones_v_rec.orig_system_source_code := l_db_oks_coverage_tim44.orig_system_source_code;
1884: END IF;
1885: -- R12 Data Model Changes 4485150 End
1886: END IF;
1887: RETURN(l_return_status);
1886: END IF;
1887: RETURN(l_return_status);
1888: END populate_new_record;
1889: -------------------------------------------------
1890: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES_V --
1891: -------------------------------------------------
1892: FUNCTION Set_Attributes (
1893: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
1894: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
1889: -------------------------------------------------
1890: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES_V --
1891: -------------------------------------------------
1892: FUNCTION Set_Attributes (
1893: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
1894: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
1895: ) RETURN VARCHAR2 IS
1896: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1897: BEGIN
1890: -- Set_Attributes for:OKS_COVERAGE_TIMEZONES_V --
1891: -------------------------------------------------
1892: FUNCTION Set_Attributes (
1893: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
1894: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
1895: ) RETURN VARCHAR2 IS
1896: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1897: BEGIN
1898: x_oks_coverage_timezones_v_rec := p_oks_coverage_timezones_v_rec;
1894: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType
1895: ) RETURN VARCHAR2 IS
1896: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1897: BEGIN
1898: x_oks_coverage_timezones_v_rec := p_oks_coverage_timezones_v_rec;
1899: RETURN(l_return_status);
1900: END Set_Attributes;
1901: BEGIN
1902: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1912: RAISE OKC_API.G_EXCEPTION_ERROR;
1913: END IF;
1914: --- Setting item attributes
1915: l_return_status := Set_Attributes(
1916: p_oks_coverage_timezones_v_rec, -- IN
1917: x_oks_coverage_timezones_v_rec); -- OUT
1918: --- If any errors happen abort API
1919: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1913: END IF;
1914: --- Setting item attributes
1915: l_return_status := Set_Attributes(
1916: p_oks_coverage_timezones_v_rec, -- IN
1917: x_oks_coverage_timezones_v_rec); -- OUT
1918: --- If any errors happen abort API
1919: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1921: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1920: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1921: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1922: RAISE OKC_API.G_EXCEPTION_ERROR;
1923: END IF;
1924: l_return_status := populate_new_record(l_oks_coverage_timezones_v_rec, LDefOksCoverageTimezonesVRec);
1925: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1926: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1927: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1928: RAISE OKC_API.G_EXCEPTION_ERROR;
1949: p_init_msg_list => p_init_msg_list,
1950: x_return_status => l_return_status,
1951: x_msg_count => x_msg_count,
1952: x_msg_data => x_msg_data,
1953: p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_rec);
1954: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1955: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1956: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1957: RAISE OKC_API.G_EXCEPTION_ERROR;
1959:
1960: -----------------------------------------
1961: -- Move VIEW record to "Child" records --
1962: -----------------------------------------
1963: migrate(LDefOksCoverageTimezonesVRec, l_oks_coverage_timezones_rec);
1964: -----------------------------------------------
1965: -- Call the UPDATE_ROW for each child record --
1966: -----------------------------------------------
1967: update_row(
1968: p_init_msg_list,
1969: l_return_status,
1970: x_msg_count,
1971: x_msg_data,
1972: l_oks_coverage_timezones_rec,
1973: lx_oks_coverage_timezones_rec
1974: );
1975: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1976: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1969: l_return_status,
1970: x_msg_count,
1971: x_msg_data,
1972: l_oks_coverage_timezones_rec,
1973: lx_oks_coverage_timezones_rec
1974: );
1975: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1976: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1977: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1976: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1977: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1978: RAISE OKC_API.G_EXCEPTION_ERROR;
1979: END IF;
1980: migrate(lx_oks_coverage_timezones_rec, LDefOksCoverageTimezonesVRec);
1981: x_oks_coverage_timezones_v_rec := LDefOksCoverageTimezonesVRec;
1982: x_return_status := l_return_status;
1983: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1984: EXCEPTION
1977: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1978: RAISE OKC_API.G_EXCEPTION_ERROR;
1979: END IF;
1980: migrate(lx_oks_coverage_timezones_rec, LDefOksCoverageTimezonesVRec);
1981: x_oks_coverage_timezones_v_rec := LDefOksCoverageTimezonesVRec;
1982: x_return_status := l_return_status;
1983: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1984: EXCEPTION
1985: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2013: '_PVT'
2014: );
2015: END update_row;
2016: ------------------------------------------------------------
2017: -- PL/SQL TBL update_row for:oks_coverage_timezones_v_tbl --
2018: ------------------------------------------------------------
2019: PROCEDURE update_row(
2020: p_api_version IN NUMBER,
2021: p_init_msg_list IN VARCHAR2,
2021: p_init_msg_list IN VARCHAR2,
2022: x_return_status OUT NOCOPY VARCHAR2,
2023: x_msg_count OUT NOCOPY NUMBER,
2024: x_msg_data OUT NOCOPY VARCHAR2,
2025: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
2026: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
2027: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2028:
2029: l_api_version CONSTANT NUMBER := 1;
2022: x_return_status OUT NOCOPY VARCHAR2,
2023: x_msg_count OUT NOCOPY NUMBER,
2024: x_msg_data OUT NOCOPY VARCHAR2,
2025: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
2026: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
2027: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2028:
2029: l_api_version CONSTANT NUMBER := 1;
2030: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2031: i NUMBER := 0;
2032: BEGIN
2033: OKC_API.init_msg_list(p_init_msg_list);
2034: -- Make sure PL/SQL table has records in it before passing
2035: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
2036: i := p_oks_coverage_timezones_v_tbl.FIRST;
2037: LOOP
2038: DECLARE
2039: l_error_rec OKC_API.ERROR_REC_TYPE;
2032: BEGIN
2033: OKC_API.init_msg_list(p_init_msg_list);
2034: -- Make sure PL/SQL table has records in it before passing
2035: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
2036: i := p_oks_coverage_timezones_v_tbl.FIRST;
2037: LOOP
2038: DECLARE
2039: l_error_rec OKC_API.ERROR_REC_TYPE;
2040: BEGIN
2046: p_init_msg_list => OKC_API.G_FALSE,
2047: x_return_status => l_error_rec.error_type,
2048: x_msg_count => l_error_rec.msg_count,
2049: x_msg_data => l_error_rec.msg_data,
2050: p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i),
2051: x_oks_coverage_timezones_v_rec => x_oks_coverage_timezones_v_tbl(i));
2052: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2053: l_error_rec.sqlcode := SQLCODE;
2054: load_error_tbl(l_error_rec, px_error_tbl);
2047: x_return_status => l_error_rec.error_type,
2048: x_msg_count => l_error_rec.msg_count,
2049: x_msg_data => l_error_rec.msg_data,
2050: p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i),
2051: x_oks_coverage_timezones_v_rec => x_oks_coverage_timezones_v_tbl(i));
2052: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2053: l_error_rec.sqlcode := SQLCODE;
2054: load_error_tbl(l_error_rec, px_error_tbl);
2055: ELSE
2069: l_error_rec.error_type := 'OTHERS';
2070: l_error_rec.sqlcode := SQLCODE;
2071: load_error_tbl(l_error_rec, px_error_tbl);
2072: END;
2073: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
2074: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
2075: END LOOP;
2076: END IF;
2077: -- Loop through the error_tbl to find the error with the highest severity
2070: l_error_rec.sqlcode := SQLCODE;
2071: load_error_tbl(l_error_rec, px_error_tbl);
2072: END;
2073: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
2074: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
2075: END LOOP;
2076: END IF;
2077: -- Loop through the error_tbl to find the error with the highest severity
2078: -- and return it.
2111: );
2112: END update_row;
2113:
2114: ------------------------------------------------------------
2115: -- PL/SQL TBL update_row for:OKS_COVERAGE_TIMEZONES_V_TBL --
2116: ------------------------------------------------------------
2117: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
2118: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
2119: PROCEDURE update_row(
2121: p_init_msg_list IN VARCHAR2,
2122: x_return_status OUT NOCOPY VARCHAR2,
2123: x_msg_count OUT NOCOPY NUMBER,
2124: x_msg_data OUT NOCOPY VARCHAR2,
2125: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
2126: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType) IS
2127:
2128: l_api_version CONSTANT NUMBER := 1;
2129: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2122: x_return_status OUT NOCOPY VARCHAR2,
2123: x_msg_count OUT NOCOPY NUMBER,
2124: x_msg_data OUT NOCOPY VARCHAR2,
2125: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
2126: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType) IS
2127:
2128: l_api_version CONSTANT NUMBER := 1;
2129: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2130: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2131: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2132: BEGIN
2133: OKC_API.init_msg_list(p_init_msg_list);
2134: -- Make sure PL/SQL table has records in it before passing
2135: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
2136: update_row (
2137: p_api_version => p_api_version,
2138: p_init_msg_list => OKC_API.G_FALSE,
2139: x_return_status => x_return_status,
2138: p_init_msg_list => OKC_API.G_FALSE,
2139: x_return_status => x_return_status,
2140: x_msg_count => x_msg_count,
2141: x_msg_data => x_msg_data,
2142: p_oks_coverage_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
2143: x_oks_coverage_timezones_v_tbl => x_oks_coverage_timezones_v_tbl,
2144: px_error_tbl => l_error_tbl);
2145: END IF;
2146: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2139: x_return_status => x_return_status,
2140: x_msg_count => x_msg_count,
2141: x_msg_data => x_msg_data,
2142: p_oks_coverage_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
2143: x_oks_coverage_timezones_v_tbl => x_oks_coverage_timezones_v_tbl,
2144: px_error_tbl => l_error_tbl);
2145: END IF;
2146: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2147: EXCEPTION
2180: ---------------------------------------------------------------------------
2181: -- PROCEDURE delete_row
2182: ---------------------------------------------------------------------------
2183: -------------------------------------------
2184: -- delete_row for:OKS_COVERAGE_TIMEZONES --
2185: -------------------------------------------
2186: PROCEDURE delete_row(
2187: p_init_msg_list IN VARCHAR2,
2188: x_return_status OUT NOCOPY VARCHAR2,
2187: p_init_msg_list IN VARCHAR2,
2188: x_return_status OUT NOCOPY VARCHAR2,
2189: x_msg_count OUT NOCOPY NUMBER,
2190: x_msg_data OUT NOCOPY VARCHAR2,
2191: p_oks_coverage_timezones_rec IN OksCoverageTimezonesRecType) IS
2192:
2193: l_api_version CONSTANT NUMBER := 1;
2194: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2195: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2192:
2193: l_api_version CONSTANT NUMBER := 1;
2194: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2195: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2196: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType := p_oks_coverage_timezones_rec;
2197: l_row_notfound BOOLEAN := TRUE;
2198: BEGIN
2199: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2200: p_init_msg_list,
2205: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2206: RAISE OKC_API.G_EXCEPTION_ERROR;
2207: END IF;
2208:
2209: DELETE FROM OKS_COVERAGE_TIMEZONES
2210: WHERE ID = p_oks_coverage_timezones_rec.id;
2211:
2212: x_return_status := l_return_status;
2213: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2206: RAISE OKC_API.G_EXCEPTION_ERROR;
2207: END IF;
2208:
2209: DELETE FROM OKS_COVERAGE_TIMEZONES
2210: WHERE ID = p_oks_coverage_timezones_rec.id;
2211:
2212: x_return_status := l_return_status;
2213: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2214: EXCEPTION
2243: '_PVT'
2244: );
2245: END delete_row;
2246: ---------------------------------------------
2247: -- delete_row for:OKS_COVERAGE_TIMEZONES_V --
2248: ---------------------------------------------
2249: PROCEDURE delete_row(
2250: p_api_version IN NUMBER,
2251: p_init_msg_list IN VARCHAR2,
2251: p_init_msg_list IN VARCHAR2,
2252: x_return_status OUT NOCOPY VARCHAR2,
2253: x_msg_count OUT NOCOPY NUMBER,
2254: x_msg_data OUT NOCOPY VARCHAR2,
2255: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType) IS
2256:
2257: l_api_version CONSTANT NUMBER := 1;
2258: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2259: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2256:
2257: l_api_version CONSTANT NUMBER := 1;
2258: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2259: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2260: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
2261: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
2262: BEGIN
2263: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2264: G_PKG_NAME,
2257: l_api_version CONSTANT NUMBER := 1;
2258: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2259: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2260: l_oks_coverage_timezones_v_rec OksCoverageTimezonesVRecType := p_oks_coverage_timezones_v_rec;
2261: l_oks_coverage_timezones_rec OksCoverageTimezonesRecType;
2262: BEGIN
2263: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2264: G_PKG_NAME,
2265: p_init_msg_list,
2274: END IF;
2275: -----------------------------------------
2276: -- Move VIEW record to "Child" records --
2277: -----------------------------------------
2278: migrate(l_oks_coverage_timezones_v_rec, l_oks_coverage_timezones_rec);
2279: -----------------------------------------------
2280: -- Call the DELETE_ROW for each child record --
2281: -----------------------------------------------
2282: delete_row(
2283: p_init_msg_list,
2284: l_return_status,
2285: x_msg_count,
2286: x_msg_data,
2287: l_oks_coverage_timezones_rec
2288: );
2289: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2325: '_PVT'
2326: );
2327: END delete_row;
2328: --------------------------------------------------------
2329: -- PL/SQL TBL delete_row for:OKS_COVERAGE_TIMEZONES_V --
2330: --------------------------------------------------------
2331: PROCEDURE delete_row(
2332: p_api_version IN NUMBER,
2333: p_init_msg_list IN VARCHAR2,
2333: p_init_msg_list IN VARCHAR2,
2334: x_return_status OUT NOCOPY VARCHAR2,
2335: x_msg_count OUT NOCOPY NUMBER,
2336: x_msg_data OUT NOCOPY VARCHAR2,
2337: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
2338: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2339:
2340: l_api_version CONSTANT NUMBER := 1;
2341: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2342: i NUMBER := 0;
2343: BEGIN
2344: OKC_API.init_msg_list(p_init_msg_list);
2345: -- Make sure PL/SQL table has records in it before passing
2346: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
2347: i := p_oks_coverage_timezones_v_tbl.FIRST;
2348: LOOP
2349: DECLARE
2350: l_error_rec OKC_API.ERROR_REC_TYPE;
2343: BEGIN
2344: OKC_API.init_msg_list(p_init_msg_list);
2345: -- Make sure PL/SQL table has records in it before passing
2346: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
2347: i := p_oks_coverage_timezones_v_tbl.FIRST;
2348: LOOP
2349: DECLARE
2350: l_error_rec OKC_API.ERROR_REC_TYPE;
2351: BEGIN
2357: p_init_msg_list => OKC_API.G_FALSE,
2358: x_return_status => l_error_rec.error_type,
2359: x_msg_count => l_error_rec.msg_count,
2360: x_msg_data => l_error_rec.msg_data,
2361: p_oks_coverage_timezones_v_rec => p_oks_coverage_timezones_v_tbl(i));
2362: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2363: l_error_rec.sqlcode := SQLCODE;
2364: load_error_tbl(l_error_rec, px_error_tbl);
2365: ELSE
2379: l_error_rec.error_type := 'OTHERS';
2380: l_error_rec.sqlcode := SQLCODE;
2381: load_error_tbl(l_error_rec, px_error_tbl);
2382: END;
2383: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
2384: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
2385: END LOOP;
2386: END IF;
2387: -- Loop through the error_tbl to find the error with the highest severity
2380: l_error_rec.sqlcode := SQLCODE;
2381: load_error_tbl(l_error_rec, px_error_tbl);
2382: END;
2383: EXIT WHEN (i = p_oks_coverage_timezones_v_tbl.LAST);
2384: i := p_oks_coverage_timezones_v_tbl.NEXT(i);
2385: END LOOP;
2386: END IF;
2387: -- Loop through the error_tbl to find the error with the highest severity
2388: -- and return it.
2421: );
2422: END delete_row;
2423:
2424: --------------------------------------------------------
2425: -- PL/SQL TBL delete_row for:OKS_COVERAGE_TIMEZONES_V --
2426: --------------------------------------------------------
2427: PROCEDURE delete_row(
2428: p_api_version IN NUMBER,
2429: p_init_msg_list IN VARCHAR2,
2429: p_init_msg_list IN VARCHAR2,
2430: x_return_status OUT NOCOPY VARCHAR2,
2431: x_msg_count OUT NOCOPY NUMBER,
2432: x_msg_data OUT NOCOPY VARCHAR2,
2433: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType) IS
2434:
2435: l_api_version CONSTANT NUMBER := 1;
2436: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2438: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2439: BEGIN
2440: OKC_API.init_msg_list(p_init_msg_list);
2441: -- Make sure PL/SQL table has records in it before passing
2442: IF (p_oks_coverage_timezones_v_tbl.COUNT > 0) THEN
2443: delete_row (
2444: p_api_version => p_api_version,
2445: p_init_msg_list => OKC_API.G_FALSE,
2446: x_return_status => x_return_status,
2445: p_init_msg_list => OKC_API.G_FALSE,
2446: x_return_status => x_return_status,
2447: x_msg_count => x_msg_count,
2448: x_msg_data => x_msg_data,
2449: p_oks_coverage_timezones_v_tbl => p_oks_coverage_timezones_v_tbl,
2450: px_error_tbl => l_error_tbl);
2451: END IF;
2452: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2453: EXCEPTION
2497: okc_debug.Set_Indentation('OKS_CTZ_PVT');
2498: okc_debug.log('23700: Entered create_version', 2);
2499: END IF;
2500:
2501: INSERT INTO OKS_COVERAGE_TIMEZONES_H(
2502: ID,
2503: CLE_ID,
2504: DEFAULT_YN,
2505: TIMEZONE_ID,
2544: /* ORIG_SYSTEM_ID1,
2545: ORIG_SYSTEM_REFERENCE1,
2546: ORIG_SYSTEM_SOURCE_CODE */
2547: -- R12 Data Model Changes 4485150 End
2548: FROM OKS_COVERAGE_TIMEZONES
2549: WHERE DNZ_CHR_ID = P_Id;
2550:
2551: RETURN l_return_status;
2552:
2590: okc_debug.Set_Indentation('OKS_CTZ_PVT');
2591: okc_debug.log('24000: Exiting restore_version:OTHERS Exception', 2);
2592: END IF;
2593:
2594: DELETE OKS_COVERAGE_TIMEZONES
2595: WHERE DNZ_CHR_ID = p_id;
2596:
2597:
2598:
2597:
2598:
2599:
2600:
2601: INSERT INTO OKS_COVERAGE_TIMEZONES(
2602: ID,
2603: CLE_ID,
2604: DEFAULT_YN,
2605: TIMEZONE_ID,
2642: /* ORIG_SYSTEM_ID1,
2643: ORIG_SYSTEM_REFERENCE1,
2644: ORIG_SYSTEM_SOURCE_CODE */
2645: -- R12 Data Model Changes 4485150 End
2646: FROM OKS_COVERAGE_TIMEZONES_H
2647: WHERE DNZ_CHR_ID = P_Id
2648: AND major_version = p_major_version;
2649: RETURN l_return_status;
2650: