[Home] [Help]
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: ---------------------------------------------------------------------------
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,
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
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: -------------------------------
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;
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
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;
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(
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
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;
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;
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
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,
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(
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