90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_COVERAGE_TIMES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_COVERAGE_TIMES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN oks_coverage_times_v_rec_type IS
100: CURSOR oks_ctv_pk_csr (p_id IN NUMBER) IS
101: SELECT
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN oks_coverage_times_v_rec_type IS
100: CURSOR oks_ctv_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: DNZ_CHR_ID,
123: LAST_UPDATED_BY,
124: LAST_UPDATE_DATE,
125: LAST_UPDATE_LOGIN,
126: OBJECT_VERSION_NUMBER
127: FROM Oks_Coverage_Times_V
128: WHERE oks_coverage_times_v.id = p_id;
129: l_oks_ctv_pk oks_ctv_pk_csr%ROWTYPE;
130: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
131: BEGIN
124: LAST_UPDATE_DATE,
125: LAST_UPDATE_LOGIN,
126: OBJECT_VERSION_NUMBER
127: FROM Oks_Coverage_Times_V
128: WHERE oks_coverage_times_v.id = p_id;
129: l_oks_ctv_pk oks_ctv_pk_csr%ROWTYPE;
130: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
131: BEGIN
132: x_no_data_found := TRUE;
126: OBJECT_VERSION_NUMBER
127: FROM Oks_Coverage_Times_V
128: WHERE oks_coverage_times_v.id = p_id;
129: l_oks_ctv_pk oks_ctv_pk_csr%ROWTYPE;
130: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
131: BEGIN
132: x_no_data_found := TRUE;
133: -- Get current database values
134: OPEN oks_ctv_pk_csr (p_oks_coverage_times_v_rec.id);
130: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
131: BEGIN
132: x_no_data_found := TRUE;
133: -- Get current database values
134: OPEN oks_ctv_pk_csr (p_oks_coverage_times_v_rec.id);
135: FETCH oks_ctv_pk_csr INTO
136: l_oks_coverage_times_v_rec.id,
137: l_oks_coverage_times_v_rec.dnz_chr_id,
138: l_oks_coverage_times_v_rec.cov_tze_line_id,
132: x_no_data_found := TRUE;
133: -- Get current database values
134: OPEN oks_ctv_pk_csr (p_oks_coverage_times_v_rec.id);
135: FETCH oks_ctv_pk_csr INTO
136: l_oks_coverage_times_v_rec.id,
137: l_oks_coverage_times_v_rec.dnz_chr_id,
138: l_oks_coverage_times_v_rec.cov_tze_line_id,
139: l_oks_coverage_times_v_rec.start_hour,
140: l_oks_coverage_times_v_rec.start_minute,
133: -- Get current database values
134: OPEN oks_ctv_pk_csr (p_oks_coverage_times_v_rec.id);
135: FETCH oks_ctv_pk_csr INTO
136: l_oks_coverage_times_v_rec.id,
137: l_oks_coverage_times_v_rec.dnz_chr_id,
138: l_oks_coverage_times_v_rec.cov_tze_line_id,
139: l_oks_coverage_times_v_rec.start_hour,
140: l_oks_coverage_times_v_rec.start_minute,
141: l_oks_coverage_times_v_rec.end_hour,
134: OPEN oks_ctv_pk_csr (p_oks_coverage_times_v_rec.id);
135: FETCH oks_ctv_pk_csr INTO
136: l_oks_coverage_times_v_rec.id,
137: l_oks_coverage_times_v_rec.dnz_chr_id,
138: l_oks_coverage_times_v_rec.cov_tze_line_id,
139: l_oks_coverage_times_v_rec.start_hour,
140: l_oks_coverage_times_v_rec.start_minute,
141: l_oks_coverage_times_v_rec.end_hour,
142: l_oks_coverage_times_v_rec.end_minute,
135: FETCH oks_ctv_pk_csr INTO
136: l_oks_coverage_times_v_rec.id,
137: l_oks_coverage_times_v_rec.dnz_chr_id,
138: l_oks_coverage_times_v_rec.cov_tze_line_id,
139: l_oks_coverage_times_v_rec.start_hour,
140: l_oks_coverage_times_v_rec.start_minute,
141: l_oks_coverage_times_v_rec.end_hour,
142: l_oks_coverage_times_v_rec.end_minute,
143: l_oks_coverage_times_v_rec.monday_yn,
136: l_oks_coverage_times_v_rec.id,
137: l_oks_coverage_times_v_rec.dnz_chr_id,
138: l_oks_coverage_times_v_rec.cov_tze_line_id,
139: l_oks_coverage_times_v_rec.start_hour,
140: l_oks_coverage_times_v_rec.start_minute,
141: l_oks_coverage_times_v_rec.end_hour,
142: l_oks_coverage_times_v_rec.end_minute,
143: l_oks_coverage_times_v_rec.monday_yn,
144: l_oks_coverage_times_v_rec.tuesday_yn,
137: l_oks_coverage_times_v_rec.dnz_chr_id,
138: l_oks_coverage_times_v_rec.cov_tze_line_id,
139: l_oks_coverage_times_v_rec.start_hour,
140: l_oks_coverage_times_v_rec.start_minute,
141: l_oks_coverage_times_v_rec.end_hour,
142: l_oks_coverage_times_v_rec.end_minute,
143: l_oks_coverage_times_v_rec.monday_yn,
144: l_oks_coverage_times_v_rec.tuesday_yn,
145: l_oks_coverage_times_v_rec.wednesday_yn,
138: l_oks_coverage_times_v_rec.cov_tze_line_id,
139: l_oks_coverage_times_v_rec.start_hour,
140: l_oks_coverage_times_v_rec.start_minute,
141: l_oks_coverage_times_v_rec.end_hour,
142: l_oks_coverage_times_v_rec.end_minute,
143: l_oks_coverage_times_v_rec.monday_yn,
144: l_oks_coverage_times_v_rec.tuesday_yn,
145: l_oks_coverage_times_v_rec.wednesday_yn,
146: l_oks_coverage_times_v_rec.thursday_yn,
139: l_oks_coverage_times_v_rec.start_hour,
140: l_oks_coverage_times_v_rec.start_minute,
141: l_oks_coverage_times_v_rec.end_hour,
142: l_oks_coverage_times_v_rec.end_minute,
143: l_oks_coverage_times_v_rec.monday_yn,
144: l_oks_coverage_times_v_rec.tuesday_yn,
145: l_oks_coverage_times_v_rec.wednesday_yn,
146: l_oks_coverage_times_v_rec.thursday_yn,
147: l_oks_coverage_times_v_rec.friday_yn,
140: l_oks_coverage_times_v_rec.start_minute,
141: l_oks_coverage_times_v_rec.end_hour,
142: l_oks_coverage_times_v_rec.end_minute,
143: l_oks_coverage_times_v_rec.monday_yn,
144: l_oks_coverage_times_v_rec.tuesday_yn,
145: l_oks_coverage_times_v_rec.wednesday_yn,
146: l_oks_coverage_times_v_rec.thursday_yn,
147: l_oks_coverage_times_v_rec.friday_yn,
148: l_oks_coverage_times_v_rec.saturday_yn,
141: l_oks_coverage_times_v_rec.end_hour,
142: l_oks_coverage_times_v_rec.end_minute,
143: l_oks_coverage_times_v_rec.monday_yn,
144: l_oks_coverage_times_v_rec.tuesday_yn,
145: l_oks_coverage_times_v_rec.wednesday_yn,
146: l_oks_coverage_times_v_rec.thursday_yn,
147: l_oks_coverage_times_v_rec.friday_yn,
148: l_oks_coverage_times_v_rec.saturday_yn,
149: l_oks_coverage_times_v_rec.sunday_yn,
142: l_oks_coverage_times_v_rec.end_minute,
143: l_oks_coverage_times_v_rec.monday_yn,
144: l_oks_coverage_times_v_rec.tuesday_yn,
145: l_oks_coverage_times_v_rec.wednesday_yn,
146: l_oks_coverage_times_v_rec.thursday_yn,
147: l_oks_coverage_times_v_rec.friday_yn,
148: l_oks_coverage_times_v_rec.saturday_yn,
149: l_oks_coverage_times_v_rec.sunday_yn,
150: l_oks_coverage_times_v_rec.security_group_id,
143: l_oks_coverage_times_v_rec.monday_yn,
144: l_oks_coverage_times_v_rec.tuesday_yn,
145: l_oks_coverage_times_v_rec.wednesday_yn,
146: l_oks_coverage_times_v_rec.thursday_yn,
147: l_oks_coverage_times_v_rec.friday_yn,
148: l_oks_coverage_times_v_rec.saturday_yn,
149: l_oks_coverage_times_v_rec.sunday_yn,
150: l_oks_coverage_times_v_rec.security_group_id,
151: l_oks_coverage_times_v_rec.program_application_id,
144: l_oks_coverage_times_v_rec.tuesday_yn,
145: l_oks_coverage_times_v_rec.wednesday_yn,
146: l_oks_coverage_times_v_rec.thursday_yn,
147: l_oks_coverage_times_v_rec.friday_yn,
148: l_oks_coverage_times_v_rec.saturday_yn,
149: l_oks_coverage_times_v_rec.sunday_yn,
150: l_oks_coverage_times_v_rec.security_group_id,
151: l_oks_coverage_times_v_rec.program_application_id,
152: l_oks_coverage_times_v_rec.program_id,
145: l_oks_coverage_times_v_rec.wednesday_yn,
146: l_oks_coverage_times_v_rec.thursday_yn,
147: l_oks_coverage_times_v_rec.friday_yn,
148: l_oks_coverage_times_v_rec.saturday_yn,
149: l_oks_coverage_times_v_rec.sunday_yn,
150: l_oks_coverage_times_v_rec.security_group_id,
151: l_oks_coverage_times_v_rec.program_application_id,
152: l_oks_coverage_times_v_rec.program_id,
153: l_oks_coverage_times_v_rec.program_update_date,
146: l_oks_coverage_times_v_rec.thursday_yn,
147: l_oks_coverage_times_v_rec.friday_yn,
148: l_oks_coverage_times_v_rec.saturday_yn,
149: l_oks_coverage_times_v_rec.sunday_yn,
150: l_oks_coverage_times_v_rec.security_group_id,
151: l_oks_coverage_times_v_rec.program_application_id,
152: l_oks_coverage_times_v_rec.program_id,
153: l_oks_coverage_times_v_rec.program_update_date,
154: l_oks_coverage_times_v_rec.request_id,
147: l_oks_coverage_times_v_rec.friday_yn,
148: l_oks_coverage_times_v_rec.saturday_yn,
149: l_oks_coverage_times_v_rec.sunday_yn,
150: l_oks_coverage_times_v_rec.security_group_id,
151: l_oks_coverage_times_v_rec.program_application_id,
152: l_oks_coverage_times_v_rec.program_id,
153: l_oks_coverage_times_v_rec.program_update_date,
154: l_oks_coverage_times_v_rec.request_id,
155: l_oks_coverage_times_v_rec.created_by,
148: l_oks_coverage_times_v_rec.saturday_yn,
149: l_oks_coverage_times_v_rec.sunday_yn,
150: l_oks_coverage_times_v_rec.security_group_id,
151: l_oks_coverage_times_v_rec.program_application_id,
152: l_oks_coverage_times_v_rec.program_id,
153: l_oks_coverage_times_v_rec.program_update_date,
154: l_oks_coverage_times_v_rec.request_id,
155: l_oks_coverage_times_v_rec.created_by,
156: l_oks_coverage_times_v_rec.creation_date,
149: l_oks_coverage_times_v_rec.sunday_yn,
150: l_oks_coverage_times_v_rec.security_group_id,
151: l_oks_coverage_times_v_rec.program_application_id,
152: l_oks_coverage_times_v_rec.program_id,
153: l_oks_coverage_times_v_rec.program_update_date,
154: l_oks_coverage_times_v_rec.request_id,
155: l_oks_coverage_times_v_rec.created_by,
156: l_oks_coverage_times_v_rec.creation_date,
157: l_oks_coverage_times_v_rec.last_updated_by,
150: l_oks_coverage_times_v_rec.security_group_id,
151: l_oks_coverage_times_v_rec.program_application_id,
152: l_oks_coverage_times_v_rec.program_id,
153: l_oks_coverage_times_v_rec.program_update_date,
154: l_oks_coverage_times_v_rec.request_id,
155: l_oks_coverage_times_v_rec.created_by,
156: l_oks_coverage_times_v_rec.creation_date,
157: l_oks_coverage_times_v_rec.last_updated_by,
158: l_oks_coverage_times_v_rec.last_update_date,
151: l_oks_coverage_times_v_rec.program_application_id,
152: l_oks_coverage_times_v_rec.program_id,
153: l_oks_coverage_times_v_rec.program_update_date,
154: l_oks_coverage_times_v_rec.request_id,
155: l_oks_coverage_times_v_rec.created_by,
156: l_oks_coverage_times_v_rec.creation_date,
157: l_oks_coverage_times_v_rec.last_updated_by,
158: l_oks_coverage_times_v_rec.last_update_date,
159: l_oks_coverage_times_v_rec.last_update_login,
152: l_oks_coverage_times_v_rec.program_id,
153: l_oks_coverage_times_v_rec.program_update_date,
154: l_oks_coverage_times_v_rec.request_id,
155: l_oks_coverage_times_v_rec.created_by,
156: l_oks_coverage_times_v_rec.creation_date,
157: l_oks_coverage_times_v_rec.last_updated_by,
158: l_oks_coverage_times_v_rec.last_update_date,
159: l_oks_coverage_times_v_rec.last_update_login,
160: l_oks_coverage_times_v_rec.object_version_number;
153: l_oks_coverage_times_v_rec.program_update_date,
154: l_oks_coverage_times_v_rec.request_id,
155: l_oks_coverage_times_v_rec.created_by,
156: l_oks_coverage_times_v_rec.creation_date,
157: l_oks_coverage_times_v_rec.last_updated_by,
158: l_oks_coverage_times_v_rec.last_update_date,
159: l_oks_coverage_times_v_rec.last_update_login,
160: l_oks_coverage_times_v_rec.object_version_number;
161: x_no_data_found := oks_ctv_pk_csr%NOTFOUND;
154: l_oks_coverage_times_v_rec.request_id,
155: l_oks_coverage_times_v_rec.created_by,
156: l_oks_coverage_times_v_rec.creation_date,
157: l_oks_coverage_times_v_rec.last_updated_by,
158: l_oks_coverage_times_v_rec.last_update_date,
159: l_oks_coverage_times_v_rec.last_update_login,
160: l_oks_coverage_times_v_rec.object_version_number;
161: x_no_data_found := oks_ctv_pk_csr%NOTFOUND;
162: CLOSE oks_ctv_pk_csr;
155: l_oks_coverage_times_v_rec.created_by,
156: l_oks_coverage_times_v_rec.creation_date,
157: l_oks_coverage_times_v_rec.last_updated_by,
158: l_oks_coverage_times_v_rec.last_update_date,
159: l_oks_coverage_times_v_rec.last_update_login,
160: l_oks_coverage_times_v_rec.object_version_number;
161: x_no_data_found := oks_ctv_pk_csr%NOTFOUND;
162: CLOSE oks_ctv_pk_csr;
163: RETURN(l_oks_coverage_times_v_rec);
156: l_oks_coverage_times_v_rec.creation_date,
157: l_oks_coverage_times_v_rec.last_updated_by,
158: l_oks_coverage_times_v_rec.last_update_date,
159: l_oks_coverage_times_v_rec.last_update_login,
160: l_oks_coverage_times_v_rec.object_version_number;
161: x_no_data_found := oks_ctv_pk_csr%NOTFOUND;
162: CLOSE oks_ctv_pk_csr;
163: RETURN(l_oks_coverage_times_v_rec);
164: END get_rec;
159: l_oks_coverage_times_v_rec.last_update_login,
160: l_oks_coverage_times_v_rec.object_version_number;
161: x_no_data_found := oks_ctv_pk_csr%NOTFOUND;
162: CLOSE oks_ctv_pk_csr;
163: RETURN(l_oks_coverage_times_v_rec);
164: END get_rec;
165:
166: ------------------------------------------------------------------
167: -- This version of get_rec sets error messages if no data found --
166: ------------------------------------------------------------------
167: -- This version of get_rec sets error messages if no data found --
168: ------------------------------------------------------------------
169: FUNCTION get_rec (
170: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
171: x_return_status OUT NOCOPY VARCHAR2
172: ) RETURN oks_coverage_times_v_rec_type IS
173: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
174: l_row_notfound BOOLEAN := TRUE;
168: ------------------------------------------------------------------
169: FUNCTION get_rec (
170: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
171: x_return_status OUT NOCOPY VARCHAR2
172: ) RETURN oks_coverage_times_v_rec_type IS
173: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
174: l_row_notfound BOOLEAN := TRUE;
175: BEGIN
176: x_return_status := OKC_API.G_RET_STS_SUCCESS;
169: FUNCTION get_rec (
170: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
171: x_return_status OUT NOCOPY VARCHAR2
172: ) RETURN oks_coverage_times_v_rec_type IS
173: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
174: l_row_notfound BOOLEAN := TRUE;
175: BEGIN
176: x_return_status := OKC_API.G_RET_STS_SUCCESS;
177: l_oks_coverage_times_v_rec := get_rec(p_oks_coverage_times_v_rec, l_row_notfound);
173: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
174: l_row_notfound BOOLEAN := TRUE;
175: BEGIN
176: x_return_status := OKC_API.G_RET_STS_SUCCESS;
177: l_oks_coverage_times_v_rec := get_rec(p_oks_coverage_times_v_rec, l_row_notfound);
178: IF (l_row_notfound) THEN
179: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
180: x_return_status := OKC_API.G_RET_STS_ERROR;
181: END IF;
178: IF (l_row_notfound) THEN
179: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
180: x_return_status := OKC_API.G_RET_STS_ERROR;
181: END IF;
182: RETURN(l_oks_coverage_times_v_rec);
183: END get_rec;
184: -----------------------------------------------------------
185: -- So we don't have to pass an "l_row_notfound" variable --
186: -----------------------------------------------------------
184: -----------------------------------------------------------
185: -- So we don't have to pass an "l_row_notfound" variable --
186: -----------------------------------------------------------
187: FUNCTION get_rec (
188: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
189: ) RETURN oks_coverage_times_v_rec_type IS
190: l_row_not_found BOOLEAN := TRUE;
191: BEGIN
192: RETURN(get_rec(p_oks_coverage_times_v_rec, l_row_not_found));
185: -- So we don't have to pass an "l_row_notfound" variable --
186: -----------------------------------------------------------
187: FUNCTION get_rec (
188: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
189: ) RETURN oks_coverage_times_v_rec_type IS
190: l_row_not_found BOOLEAN := TRUE;
191: BEGIN
192: RETURN(get_rec(p_oks_coverage_times_v_rec, l_row_not_found));
193: END get_rec;
188: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
189: ) RETURN oks_coverage_times_v_rec_type IS
190: l_row_not_found BOOLEAN := TRUE;
191: BEGIN
192: RETURN(get_rec(p_oks_coverage_times_v_rec, l_row_not_found));
193: END get_rec;
194: ---------------------------------------------------------------------------
195: -- FUNCTION get_rec for: OKS_COVERAGE_TIMES
196: ---------------------------------------------------------------------------
290: BEGIN
291: RETURN(get_rec(p_oks_coverage_times_rec, l_row_not_found));
292: END get_rec;
293: ---------------------------------------------------------------------------
294: -- FUNCTION null_out_defaults for: OKS_COVERAGE_TIMES_V
295: ---------------------------------------------------------------------------
296: FUNCTION null_out_defaults (
297: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
298: ) RETURN oks_coverage_times_v_rec_type IS
293: ---------------------------------------------------------------------------
294: -- FUNCTION null_out_defaults for: OKS_COVERAGE_TIMES_V
295: ---------------------------------------------------------------------------
296: FUNCTION null_out_defaults (
297: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
298: ) RETURN oks_coverage_times_v_rec_type IS
299: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
300: BEGIN
301: IF (l_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: -- FUNCTION null_out_defaults for: OKS_COVERAGE_TIMES_V
295: ---------------------------------------------------------------------------
296: FUNCTION null_out_defaults (
297: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
298: ) RETURN oks_coverage_times_v_rec_type IS
299: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
300: BEGIN
301: IF (l_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
302: l_oks_coverage_times_v_rec.id := NULL;
295: ---------------------------------------------------------------------------
296: FUNCTION null_out_defaults (
297: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
298: ) RETURN oks_coverage_times_v_rec_type IS
299: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
300: BEGIN
301: IF (l_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
302: l_oks_coverage_times_v_rec.id := NULL;
303: END IF;
297: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
298: ) RETURN oks_coverage_times_v_rec_type IS
299: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
300: BEGIN
301: IF (l_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
302: l_oks_coverage_times_v_rec.id := NULL;
303: END IF;
304: IF (l_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
305: l_oks_coverage_times_v_rec.dnz_chr_id := NULL;
298: ) RETURN oks_coverage_times_v_rec_type IS
299: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
300: BEGIN
301: IF (l_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
302: l_oks_coverage_times_v_rec.id := NULL;
303: END IF;
304: IF (l_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
305: l_oks_coverage_times_v_rec.dnz_chr_id := NULL;
306: END IF;
300: BEGIN
301: IF (l_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
302: l_oks_coverage_times_v_rec.id := NULL;
303: END IF;
304: IF (l_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
305: l_oks_coverage_times_v_rec.dnz_chr_id := NULL;
306: END IF;
307: IF (l_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM ) THEN
308: l_oks_coverage_times_v_rec.cov_tze_line_id := NULL;
301: IF (l_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
302: l_oks_coverage_times_v_rec.id := NULL;
303: END IF;
304: IF (l_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
305: l_oks_coverage_times_v_rec.dnz_chr_id := NULL;
306: END IF;
307: IF (l_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM ) THEN
308: l_oks_coverage_times_v_rec.cov_tze_line_id := NULL;
309: END IF;
303: END IF;
304: IF (l_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
305: l_oks_coverage_times_v_rec.dnz_chr_id := NULL;
306: END IF;
307: IF (l_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM ) THEN
308: l_oks_coverage_times_v_rec.cov_tze_line_id := NULL;
309: END IF;
310: IF (l_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
311: l_oks_coverage_times_v_rec.start_hour := NULL;
304: IF (l_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
305: l_oks_coverage_times_v_rec.dnz_chr_id := NULL;
306: END IF;
307: IF (l_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM ) THEN
308: l_oks_coverage_times_v_rec.cov_tze_line_id := NULL;
309: END IF;
310: IF (l_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
311: l_oks_coverage_times_v_rec.start_hour := NULL;
312: END IF;
306: END IF;
307: IF (l_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM ) THEN
308: l_oks_coverage_times_v_rec.cov_tze_line_id := NULL;
309: END IF;
310: IF (l_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
311: l_oks_coverage_times_v_rec.start_hour := NULL;
312: END IF;
313: IF (l_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
314: l_oks_coverage_times_v_rec.start_minute := NULL;
307: IF (l_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM ) THEN
308: l_oks_coverage_times_v_rec.cov_tze_line_id := NULL;
309: END IF;
310: IF (l_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
311: l_oks_coverage_times_v_rec.start_hour := NULL;
312: END IF;
313: IF (l_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
314: l_oks_coverage_times_v_rec.start_minute := NULL;
315: END IF;
309: END IF;
310: IF (l_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
311: l_oks_coverage_times_v_rec.start_hour := NULL;
312: END IF;
313: IF (l_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
314: l_oks_coverage_times_v_rec.start_minute := NULL;
315: END IF;
316: IF (l_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
317: l_oks_coverage_times_v_rec.end_hour := NULL;
310: IF (l_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
311: l_oks_coverage_times_v_rec.start_hour := NULL;
312: END IF;
313: IF (l_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
314: l_oks_coverage_times_v_rec.start_minute := NULL;
315: END IF;
316: IF (l_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
317: l_oks_coverage_times_v_rec.end_hour := NULL;
318: END IF;
312: END IF;
313: IF (l_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
314: l_oks_coverage_times_v_rec.start_minute := NULL;
315: END IF;
316: IF (l_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
317: l_oks_coverage_times_v_rec.end_hour := NULL;
318: END IF;
319: IF (l_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
320: l_oks_coverage_times_v_rec.end_minute := NULL;
313: IF (l_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
314: l_oks_coverage_times_v_rec.start_minute := NULL;
315: END IF;
316: IF (l_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
317: l_oks_coverage_times_v_rec.end_hour := NULL;
318: END IF;
319: IF (l_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
320: l_oks_coverage_times_v_rec.end_minute := NULL;
321: END IF;
315: END IF;
316: IF (l_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
317: l_oks_coverage_times_v_rec.end_hour := NULL;
318: END IF;
319: IF (l_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
320: l_oks_coverage_times_v_rec.end_minute := NULL;
321: END IF;
322: IF (l_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR ) THEN
323: l_oks_coverage_times_v_rec.monday_yn := NULL;
316: IF (l_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
317: l_oks_coverage_times_v_rec.end_hour := NULL;
318: END IF;
319: IF (l_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
320: l_oks_coverage_times_v_rec.end_minute := NULL;
321: END IF;
322: IF (l_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR ) THEN
323: l_oks_coverage_times_v_rec.monday_yn := NULL;
324: END IF;
318: END IF;
319: IF (l_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
320: l_oks_coverage_times_v_rec.end_minute := NULL;
321: END IF;
322: IF (l_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR ) THEN
323: l_oks_coverage_times_v_rec.monday_yn := NULL;
324: END IF;
325: IF (l_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR ) THEN
326: l_oks_coverage_times_v_rec.tuesday_yn := NULL;
319: IF (l_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
320: l_oks_coverage_times_v_rec.end_minute := NULL;
321: END IF;
322: IF (l_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR ) THEN
323: l_oks_coverage_times_v_rec.monday_yn := NULL;
324: END IF;
325: IF (l_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR ) THEN
326: l_oks_coverage_times_v_rec.tuesday_yn := NULL;
327: END IF;
321: END IF;
322: IF (l_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR ) THEN
323: l_oks_coverage_times_v_rec.monday_yn := NULL;
324: END IF;
325: IF (l_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR ) THEN
326: l_oks_coverage_times_v_rec.tuesday_yn := NULL;
327: END IF;
328: IF (l_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR ) THEN
329: l_oks_coverage_times_v_rec.wednesday_yn := NULL;
322: IF (l_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR ) THEN
323: l_oks_coverage_times_v_rec.monday_yn := NULL;
324: END IF;
325: IF (l_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR ) THEN
326: l_oks_coverage_times_v_rec.tuesday_yn := NULL;
327: END IF;
328: IF (l_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR ) THEN
329: l_oks_coverage_times_v_rec.wednesday_yn := NULL;
330: END IF;
324: END IF;
325: IF (l_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR ) THEN
326: l_oks_coverage_times_v_rec.tuesday_yn := NULL;
327: END IF;
328: IF (l_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR ) THEN
329: l_oks_coverage_times_v_rec.wednesday_yn := NULL;
330: END IF;
331: IF (l_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR ) THEN
332: l_oks_coverage_times_v_rec.thursday_yn := NULL;
325: IF (l_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR ) THEN
326: l_oks_coverage_times_v_rec.tuesday_yn := NULL;
327: END IF;
328: IF (l_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR ) THEN
329: l_oks_coverage_times_v_rec.wednesday_yn := NULL;
330: END IF;
331: IF (l_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR ) THEN
332: l_oks_coverage_times_v_rec.thursday_yn := NULL;
333: END IF;
327: END IF;
328: IF (l_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR ) THEN
329: l_oks_coverage_times_v_rec.wednesday_yn := NULL;
330: END IF;
331: IF (l_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR ) THEN
332: l_oks_coverage_times_v_rec.thursday_yn := NULL;
333: END IF;
334: IF (l_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR ) THEN
335: l_oks_coverage_times_v_rec.friday_yn := NULL;
328: IF (l_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR ) THEN
329: l_oks_coverage_times_v_rec.wednesday_yn := NULL;
330: END IF;
331: IF (l_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR ) THEN
332: l_oks_coverage_times_v_rec.thursday_yn := NULL;
333: END IF;
334: IF (l_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR ) THEN
335: l_oks_coverage_times_v_rec.friday_yn := NULL;
336: END IF;
330: END IF;
331: IF (l_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR ) THEN
332: l_oks_coverage_times_v_rec.thursday_yn := NULL;
333: END IF;
334: IF (l_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR ) THEN
335: l_oks_coverage_times_v_rec.friday_yn := NULL;
336: END IF;
337: IF (l_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR ) THEN
338: l_oks_coverage_times_v_rec.saturday_yn := NULL;
331: IF (l_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR ) THEN
332: l_oks_coverage_times_v_rec.thursday_yn := NULL;
333: END IF;
334: IF (l_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR ) THEN
335: l_oks_coverage_times_v_rec.friday_yn := NULL;
336: END IF;
337: IF (l_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR ) THEN
338: l_oks_coverage_times_v_rec.saturday_yn := NULL;
339: END IF;
333: END IF;
334: IF (l_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR ) THEN
335: l_oks_coverage_times_v_rec.friday_yn := NULL;
336: END IF;
337: IF (l_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR ) THEN
338: l_oks_coverage_times_v_rec.saturday_yn := NULL;
339: END IF;
340: IF (l_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_times_v_rec.sunday_yn := NULL;
334: IF (l_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR ) THEN
335: l_oks_coverage_times_v_rec.friday_yn := NULL;
336: END IF;
337: IF (l_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR ) THEN
338: l_oks_coverage_times_v_rec.saturday_yn := NULL;
339: END IF;
340: IF (l_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_times_v_rec.sunday_yn := NULL;
342: END IF;
336: END IF;
337: IF (l_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR ) THEN
338: l_oks_coverage_times_v_rec.saturday_yn := NULL;
339: END IF;
340: IF (l_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_times_v_rec.sunday_yn := NULL;
342: END IF;
343: IF (l_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_coverage_times_v_rec.security_group_id := NULL;
337: IF (l_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR ) THEN
338: l_oks_coverage_times_v_rec.saturday_yn := NULL;
339: END IF;
340: IF (l_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_times_v_rec.sunday_yn := NULL;
342: END IF;
343: IF (l_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_coverage_times_v_rec.security_group_id := NULL;
345: END IF;
339: END IF;
340: IF (l_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_times_v_rec.sunday_yn := NULL;
342: END IF;
343: IF (l_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_coverage_times_v_rec.security_group_id := NULL;
345: END IF;
346: IF (l_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_coverage_times_v_rec.program_application_id := NULL;
340: IF (l_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR ) THEN
341: l_oks_coverage_times_v_rec.sunday_yn := NULL;
342: END IF;
343: IF (l_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_coverage_times_v_rec.security_group_id := NULL;
345: END IF;
346: IF (l_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_coverage_times_v_rec.program_application_id := NULL;
348: END IF;
342: END IF;
343: IF (l_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_coverage_times_v_rec.security_group_id := NULL;
345: END IF;
346: IF (l_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_coverage_times_v_rec.program_application_id := NULL;
348: END IF;
349: IF (l_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
350: l_oks_coverage_times_v_rec.program_id := NULL;
343: IF (l_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_coverage_times_v_rec.security_group_id := NULL;
345: END IF;
346: IF (l_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_coverage_times_v_rec.program_application_id := NULL;
348: END IF;
349: IF (l_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
350: l_oks_coverage_times_v_rec.program_id := NULL;
351: END IF;
345: END IF;
346: IF (l_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_coverage_times_v_rec.program_application_id := NULL;
348: END IF;
349: IF (l_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
350: l_oks_coverage_times_v_rec.program_id := NULL;
351: END IF;
352: IF (l_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
353: l_oks_coverage_times_v_rec.program_update_date := NULL;
346: IF (l_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_coverage_times_v_rec.program_application_id := NULL;
348: END IF;
349: IF (l_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
350: l_oks_coverage_times_v_rec.program_id := NULL;
351: END IF;
352: IF (l_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
353: l_oks_coverage_times_v_rec.program_update_date := NULL;
354: END IF;
348: END IF;
349: IF (l_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
350: l_oks_coverage_times_v_rec.program_id := NULL;
351: END IF;
352: IF (l_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
353: l_oks_coverage_times_v_rec.program_update_date := NULL;
354: END IF;
355: IF (l_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
356: l_oks_coverage_times_v_rec.request_id := NULL;
349: IF (l_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
350: l_oks_coverage_times_v_rec.program_id := NULL;
351: END IF;
352: IF (l_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
353: l_oks_coverage_times_v_rec.program_update_date := NULL;
354: END IF;
355: IF (l_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
356: l_oks_coverage_times_v_rec.request_id := NULL;
357: END IF;
351: END IF;
352: IF (l_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
353: l_oks_coverage_times_v_rec.program_update_date := NULL;
354: END IF;
355: IF (l_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
356: l_oks_coverage_times_v_rec.request_id := NULL;
357: END IF;
358: IF (l_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
359: l_oks_coverage_times_v_rec.created_by := NULL;
352: IF (l_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
353: l_oks_coverage_times_v_rec.program_update_date := NULL;
354: END IF;
355: IF (l_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
356: l_oks_coverage_times_v_rec.request_id := NULL;
357: END IF;
358: IF (l_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
359: l_oks_coverage_times_v_rec.created_by := NULL;
360: END IF;
354: END IF;
355: IF (l_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
356: l_oks_coverage_times_v_rec.request_id := NULL;
357: END IF;
358: IF (l_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
359: l_oks_coverage_times_v_rec.created_by := NULL;
360: END IF;
361: IF (l_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
362: l_oks_coverage_times_v_rec.creation_date := NULL;
355: IF (l_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
356: l_oks_coverage_times_v_rec.request_id := NULL;
357: END IF;
358: IF (l_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
359: l_oks_coverage_times_v_rec.created_by := NULL;
360: END IF;
361: IF (l_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
362: l_oks_coverage_times_v_rec.creation_date := NULL;
363: END IF;
357: END IF;
358: IF (l_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
359: l_oks_coverage_times_v_rec.created_by := NULL;
360: END IF;
361: IF (l_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
362: l_oks_coverage_times_v_rec.creation_date := NULL;
363: END IF;
364: IF (l_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
365: l_oks_coverage_times_v_rec.last_updated_by := NULL;
358: IF (l_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
359: l_oks_coverage_times_v_rec.created_by := NULL;
360: END IF;
361: IF (l_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
362: l_oks_coverage_times_v_rec.creation_date := NULL;
363: END IF;
364: IF (l_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
365: l_oks_coverage_times_v_rec.last_updated_by := NULL;
366: END IF;
360: END IF;
361: IF (l_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
362: l_oks_coverage_times_v_rec.creation_date := NULL;
363: END IF;
364: IF (l_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
365: l_oks_coverage_times_v_rec.last_updated_by := NULL;
366: END IF;
367: IF (l_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
368: l_oks_coverage_times_v_rec.last_update_date := NULL;
361: IF (l_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
362: l_oks_coverage_times_v_rec.creation_date := NULL;
363: END IF;
364: IF (l_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
365: l_oks_coverage_times_v_rec.last_updated_by := NULL;
366: END IF;
367: IF (l_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
368: l_oks_coverage_times_v_rec.last_update_date := NULL;
369: END IF;
363: END IF;
364: IF (l_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
365: l_oks_coverage_times_v_rec.last_updated_by := NULL;
366: END IF;
367: IF (l_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
368: l_oks_coverage_times_v_rec.last_update_date := NULL;
369: END IF;
370: IF (l_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
371: l_oks_coverage_times_v_rec.last_update_login := NULL;
364: IF (l_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
365: l_oks_coverage_times_v_rec.last_updated_by := NULL;
366: END IF;
367: IF (l_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
368: l_oks_coverage_times_v_rec.last_update_date := NULL;
369: END IF;
370: IF (l_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
371: l_oks_coverage_times_v_rec.last_update_login := NULL;
372: END IF;
366: END IF;
367: IF (l_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
368: l_oks_coverage_times_v_rec.last_update_date := NULL;
369: END IF;
370: IF (l_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
371: l_oks_coverage_times_v_rec.last_update_login := NULL;
372: END IF;
373: IF (l_oks_coverage_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
374: l_oks_coverage_times_v_rec.object_version_number := NULL;
367: IF (l_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
368: l_oks_coverage_times_v_rec.last_update_date := NULL;
369: END IF;
370: IF (l_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
371: l_oks_coverage_times_v_rec.last_update_login := NULL;
372: END IF;
373: IF (l_oks_coverage_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
374: l_oks_coverage_times_v_rec.object_version_number := NULL;
375: END IF;
369: END IF;
370: IF (l_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
371: l_oks_coverage_times_v_rec.last_update_login := NULL;
372: END IF;
373: IF (l_oks_coverage_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
374: l_oks_coverage_times_v_rec.object_version_number := NULL;
375: END IF;
376: RETURN(l_oks_coverage_times_v_rec);
377: END null_out_defaults;
370: IF (l_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
371: l_oks_coverage_times_v_rec.last_update_login := NULL;
372: END IF;
373: IF (l_oks_coverage_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
374: l_oks_coverage_times_v_rec.object_version_number := NULL;
375: END IF;
376: RETURN(l_oks_coverage_times_v_rec);
377: END null_out_defaults;
378: ---------------------------------
372: END IF;
373: IF (l_oks_coverage_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
374: l_oks_coverage_times_v_rec.object_version_number := NULL;
375: END IF;
376: RETURN(l_oks_coverage_times_v_rec);
377: END null_out_defaults;
378: ---------------------------------
379: -- Validate_Attributes for: ID --
380: ---------------------------------
432: ---------------------------------------------------------------------------
433: -- FUNCTION Validate_Attributes
434: ---------------------------------------------------------------------------
435: --------------------------------------------------
436: -- Validate_Attributes for:OKS_COVERAGE_TIMES_V --
437: --------------------------------------------------
438: FUNCTION Validate_Attributes (
439: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
440: ) RETURN VARCHAR2 IS
435: --------------------------------------------------
436: -- Validate_Attributes for:OKS_COVERAGE_TIMES_V --
437: --------------------------------------------------
438: FUNCTION Validate_Attributes (
439: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
440: ) RETURN VARCHAR2 IS
441: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
442: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
443: BEGIN
446: -----------------------------
447: -- ***
448: -- id
449: -- ***
450: validate_id(x_return_status, p_oks_coverage_times_v_rec.id);
451: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
452: l_return_status := x_return_status;
453: RAISE G_EXCEPTION_HALT_VALIDATION;
454: END IF;
455:
456: -- ***
457: -- object_version_number
458: -- ***
459: validate_object_version_number(x_return_status, p_oks_coverage_times_v_rec.object_version_number);
460: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
461: l_return_status := x_return_status;
462: RAISE G_EXCEPTION_HALT_VALIDATION;
463: END IF;
479: ---------------------------------------------------------------------------
480: -- PROCEDURE Validate_Record
481: ---------------------------------------------------------------------------
482: ----------------------------------------------
483: -- Validate Record for:OKS_COVERAGE_TIMES_V --
484: ----------------------------------------------
485: FUNCTION Validate_Record (
486: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
487: p_db_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
482: ----------------------------------------------
483: -- Validate Record for:OKS_COVERAGE_TIMES_V --
484: ----------------------------------------------
485: FUNCTION Validate_Record (
486: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
487: p_db_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
488: ) RETURN VARCHAR2 IS
489: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
490: BEGIN
483: -- Validate Record for:OKS_COVERAGE_TIMES_V --
484: ----------------------------------------------
485: FUNCTION Validate_Record (
486: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
487: p_db_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
488: ) RETURN VARCHAR2 IS
489: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
490: BEGIN
491: RETURN (l_return_status);
490: BEGIN
491: RETURN (l_return_status);
492: END Validate_Record;
493: FUNCTION Validate_Record (
494: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
495: ) RETURN VARCHAR2 IS
496: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
497: l_db_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := get_rec(p_oks_coverage_times_v_rec);
498: BEGIN
493: FUNCTION Validate_Record (
494: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
495: ) RETURN VARCHAR2 IS
496: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
497: l_db_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := get_rec(p_oks_coverage_times_v_rec);
498: BEGIN
499: l_return_status := Validate_Record(p_oks_coverage_times_v_rec => p_oks_coverage_times_v_rec,
500: p_db_oks_coverage_times_v_rec => l_db_oks_coverage_times_v_rec);
501: RETURN (l_return_status);
495: ) RETURN VARCHAR2 IS
496: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
497: l_db_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := get_rec(p_oks_coverage_times_v_rec);
498: BEGIN
499: l_return_status := Validate_Record(p_oks_coverage_times_v_rec => p_oks_coverage_times_v_rec,
500: p_db_oks_coverage_times_v_rec => l_db_oks_coverage_times_v_rec);
501: RETURN (l_return_status);
502: END Validate_Record;
503:
496: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
497: l_db_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := get_rec(p_oks_coverage_times_v_rec);
498: BEGIN
499: l_return_status := Validate_Record(p_oks_coverage_times_v_rec => p_oks_coverage_times_v_rec,
500: p_db_oks_coverage_times_v_rec => l_db_oks_coverage_times_v_rec);
501: RETURN (l_return_status);
502: END Validate_Record;
503:
504: ---------------------------------------------------------------------------
504: ---------------------------------------------------------------------------
505: -- PROCEDURE Migrate
506: ---------------------------------------------------------------------------
507: PROCEDURE migrate (
508: p_from IN oks_coverage_times_v_rec_type,
509: p_to IN OUT NOCOPY oks_coverage_times_rec_type
510: ) IS
511: BEGIN
512: p_to.id := p_from.id;
535: p_to.object_version_number := p_from.object_version_number;
536: END migrate;
537: PROCEDURE migrate (
538: p_from IN oks_coverage_times_rec_type,
539: p_to IN OUT NOCOPY oks_coverage_times_v_rec_type
540: ) IS
541: BEGIN
542: p_to.id := p_from.id;
543: p_to.dnz_chr_id := p_from.dnz_chr_id;
567: ---------------------------------------------------------------------------
568: -- PROCEDURE validate_row
569: ---------------------------------------------------------------------------
570: -------------------------------------------
571: -- validate_row for:OKS_COVERAGE_TIMES_V --
572: -------------------------------------------
573: PROCEDURE validate_row(
574: p_api_version IN NUMBER,
575: p_init_msg_list IN VARCHAR2,
575: p_init_msg_list IN VARCHAR2,
576: x_return_status OUT NOCOPY VARCHAR2,
577: x_msg_count OUT NOCOPY NUMBER,
578: x_msg_data OUT NOCOPY VARCHAR2,
579: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type) IS
580:
581: l_api_version CONSTANT NUMBER := 1;
582: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
583: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
580:
581: l_api_version CONSTANT NUMBER := 1;
582: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
583: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
584: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
585: l_oks_coverage_times_rec oks_coverage_times_rec_type;
586: l_oks_coverage_times_rec oks_coverage_times_rec_type;
587: BEGIN
588: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
597: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
598: RAISE OKC_API.G_EXCEPTION_ERROR;
599: END IF;
600: --- Validate all non-missing attributes (Item Level Validation)
601: l_return_status := Validate_Attributes(l_oks_coverage_times_v_rec);
602: --- If any errors happen abort API
603: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
604: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
606: RAISE OKC_API.G_EXCEPTION_ERROR;
607: END IF;
608: l_return_status := Validate_Record(l_oks_coverage_times_v_rec);
609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_ERROR;
644: '_PVT'
645: );
646: END validate_row;
647: ------------------------------------------------------
648: -- PL/SQL TBL validate_row for:OKS_COVERAGE_TIMES_V --
649: ------------------------------------------------------
650: PROCEDURE validate_row(
651: p_api_version IN NUMBER,
652: p_init_msg_list IN VARCHAR2,
652: p_init_msg_list IN VARCHAR2,
653: x_return_status OUT NOCOPY VARCHAR2,
654: x_msg_count OUT NOCOPY NUMBER,
655: x_msg_data OUT NOCOPY VARCHAR2,
656: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
657: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
658:
659: l_api_version CONSTANT NUMBER := 1;
660: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
661: i NUMBER := 0;
662: BEGIN
663: OKC_API.init_msg_list(p_init_msg_list);
664: -- Make sure PL/SQL table has records in it before passing
665: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
666: i := p_oks_coverage_times_v_tbl.FIRST;
667: LOOP
668: DECLARE
669: l_error_rec OKC_API.ERROR_REC_TYPE;
662: BEGIN
663: OKC_API.init_msg_list(p_init_msg_list);
664: -- Make sure PL/SQL table has records in it before passing
665: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
666: i := p_oks_coverage_times_v_tbl.FIRST;
667: LOOP
668: DECLARE
669: l_error_rec OKC_API.ERROR_REC_TYPE;
670: BEGIN
676: p_init_msg_list => OKC_API.G_FALSE,
677: x_return_status => l_error_rec.error_type,
678: x_msg_count => l_error_rec.msg_count,
679: x_msg_data => l_error_rec.msg_data,
680: p_oks_coverage_times_v_rec => p_oks_coverage_times_v_tbl(i));
681: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
682: l_error_rec.sqlcode := SQLCODE;
683: load_error_tbl(l_error_rec, px_error_tbl);
684: ELSE
698: l_error_rec.error_type := 'OTHERS';
699: l_error_rec.sqlcode := SQLCODE;
700: load_error_tbl(l_error_rec, px_error_tbl);
701: END;
702: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
703: i := p_oks_coverage_times_v_tbl.NEXT(i);
704: END LOOP;
705: END IF;
706: -- Loop through the error_tbl to find the error with the highest severity
699: l_error_rec.sqlcode := SQLCODE;
700: load_error_tbl(l_error_rec, px_error_tbl);
701: END;
702: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
703: i := p_oks_coverage_times_v_tbl.NEXT(i);
704: END LOOP;
705: END IF;
706: -- Loop through the error_tbl to find the error with the highest severity
707: -- and return it.
740: );
741: END validate_row;
742:
743: ------------------------------------------------------
744: -- PL/SQL TBL validate_row for:OKS_COVERAGE_TIMES_V --
745: ------------------------------------------------------
746: PROCEDURE validate_row(
747: p_api_version IN NUMBER,
748: p_init_msg_list IN VARCHAR2,
748: p_init_msg_list IN VARCHAR2,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,
752: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type) IS
753:
754: l_api_version CONSTANT NUMBER := 1;
755: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
756: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
757: l_error_tbl OKC_API.ERROR_TBL_TYPE;
758: BEGIN
759: OKC_API.init_msg_list(p_init_msg_list);
760: -- Make sure PL/SQL table has records in it before passing
761: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
762: validate_row (
763: p_api_version => p_api_version,
764: p_init_msg_list => OKC_API.G_FALSE,
765: x_return_status => x_return_status,
764: p_init_msg_list => OKC_API.G_FALSE,
765: x_return_status => x_return_status,
766: x_msg_count => x_msg_count,
767: x_msg_data => x_msg_data,
768: p_oks_coverage_times_v_tbl => p_oks_coverage_times_v_tbl,
769: px_error_tbl => l_error_tbl);
770: END IF;
771: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
772: EXCEPTION
939: '_PVT'
940: );
941: END insert_row;
942: ------------------------------------------
943: -- insert_row for :OKS_COVERAGE_TIMES_V --
944: ------------------------------------------
945: PROCEDURE insert_row(
946: p_api_version IN NUMBER,
947: p_init_msg_list IN VARCHAR2,
947: p_init_msg_list IN VARCHAR2,
948: x_return_status OUT NOCOPY VARCHAR2,
949: x_msg_count OUT NOCOPY NUMBER,
950: x_msg_data OUT NOCOPY VARCHAR2,
951: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
952: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type) IS
953:
954: l_api_version CONSTANT NUMBER := 1;
955: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
948: x_return_status OUT NOCOPY VARCHAR2,
949: x_msg_count OUT NOCOPY NUMBER,
950: x_msg_data OUT NOCOPY VARCHAR2,
951: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
952: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type) IS
953:
954: l_api_version CONSTANT NUMBER := 1;
955: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
956: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
953:
954: l_api_version CONSTANT NUMBER := 1;
955: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
956: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
957: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
958: l_def_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
959: l_oks_coverage_times_rec oks_coverage_times_rec_type;
960: lx_oks_coverage_times_rec oks_coverage_times_rec_type;
961: -------------------------------
954: l_api_version CONSTANT NUMBER := 1;
955: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
956: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
957: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
958: l_def_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
959: l_oks_coverage_times_rec oks_coverage_times_rec_type;
960: lx_oks_coverage_times_rec oks_coverage_times_rec_type;
961: -------------------------------
962: -- FUNCTION fill_who_columns --
961: -------------------------------
962: -- FUNCTION fill_who_columns --
963: -------------------------------
964: FUNCTION fill_who_columns (
965: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
966: ) RETURN oks_coverage_times_v_rec_type IS
967: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
968: BEGIN
969: l_oks_coverage_times_v_rec.CREATION_DATE := SYSDATE;
962: -- FUNCTION fill_who_columns --
963: -------------------------------
964: FUNCTION fill_who_columns (
965: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
966: ) RETURN oks_coverage_times_v_rec_type IS
967: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
968: BEGIN
969: l_oks_coverage_times_v_rec.CREATION_DATE := SYSDATE;
970: l_oks_coverage_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
963: -------------------------------
964: FUNCTION fill_who_columns (
965: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
966: ) RETURN oks_coverage_times_v_rec_type IS
967: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
968: BEGIN
969: l_oks_coverage_times_v_rec.CREATION_DATE := SYSDATE;
970: l_oks_coverage_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
971: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := l_oks_coverage_times_v_rec.CREATION_DATE;
965: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
966: ) RETURN oks_coverage_times_v_rec_type IS
967: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
968: BEGIN
969: l_oks_coverage_times_v_rec.CREATION_DATE := SYSDATE;
970: l_oks_coverage_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
971: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := l_oks_coverage_times_v_rec.CREATION_DATE;
972: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
973: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
966: ) RETURN oks_coverage_times_v_rec_type IS
967: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
968: BEGIN
969: l_oks_coverage_times_v_rec.CREATION_DATE := SYSDATE;
970: l_oks_coverage_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
971: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := l_oks_coverage_times_v_rec.CREATION_DATE;
972: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
973: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
974: RETURN(l_oks_coverage_times_v_rec);
967: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
968: BEGIN
969: l_oks_coverage_times_v_rec.CREATION_DATE := SYSDATE;
970: l_oks_coverage_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
971: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := l_oks_coverage_times_v_rec.CREATION_DATE;
972: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
973: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
974: RETURN(l_oks_coverage_times_v_rec);
975: END fill_who_columns;
968: BEGIN
969: l_oks_coverage_times_v_rec.CREATION_DATE := SYSDATE;
970: l_oks_coverage_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
971: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := l_oks_coverage_times_v_rec.CREATION_DATE;
972: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
973: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
974: RETURN(l_oks_coverage_times_v_rec);
975: END fill_who_columns;
976: ---------------------------------------------
969: l_oks_coverage_times_v_rec.CREATION_DATE := SYSDATE;
970: l_oks_coverage_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
971: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := l_oks_coverage_times_v_rec.CREATION_DATE;
972: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
973: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
974: RETURN(l_oks_coverage_times_v_rec);
975: END fill_who_columns;
976: ---------------------------------------------
977: -- Set_Attributes for:OKS_COVERAGE_TIMES_V --
970: l_oks_coverage_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
971: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := l_oks_coverage_times_v_rec.CREATION_DATE;
972: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
973: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
974: RETURN(l_oks_coverage_times_v_rec);
975: END fill_who_columns;
976: ---------------------------------------------
977: -- Set_Attributes for:OKS_COVERAGE_TIMES_V --
978: ---------------------------------------------
973: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
974: RETURN(l_oks_coverage_times_v_rec);
975: END fill_who_columns;
976: ---------------------------------------------
977: -- Set_Attributes for:OKS_COVERAGE_TIMES_V --
978: ---------------------------------------------
979: FUNCTION Set_Attributes (
980: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
981: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
976: ---------------------------------------------
977: -- Set_Attributes for:OKS_COVERAGE_TIMES_V --
978: ---------------------------------------------
979: FUNCTION Set_Attributes (
980: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
981: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
982: ) RETURN VARCHAR2 IS
983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
984: BEGIN
977: -- Set_Attributes for:OKS_COVERAGE_TIMES_V --
978: ---------------------------------------------
979: FUNCTION Set_Attributes (
980: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
981: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
982: ) RETURN VARCHAR2 IS
983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
984: BEGIN
985: x_oks_coverage_times_v_rec := p_oks_coverage_times_v_rec;
981: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
982: ) RETURN VARCHAR2 IS
983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
984: BEGIN
985: x_oks_coverage_times_v_rec := p_oks_coverage_times_v_rec;
986: x_oks_coverage_times_v_rec.OBJECT_VERSION_NUMBER := 1;
987: RETURN(l_return_status);
988: END Set_Attributes;
989: BEGIN
982: ) RETURN VARCHAR2 IS
983: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
984: BEGIN
985: x_oks_coverage_times_v_rec := p_oks_coverage_times_v_rec;
986: x_oks_coverage_times_v_rec.OBJECT_VERSION_NUMBER := 1;
987: RETURN(l_return_status);
988: END Set_Attributes;
989: BEGIN
990: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
998: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1000: RAISE OKC_API.G_EXCEPTION_ERROR;
1001: END IF;
1002: l_oks_coverage_times_v_rec := null_out_defaults(p_oks_coverage_times_v_rec);
1003: -- Set primary key value
1004: l_oks_coverage_times_v_rec.ID := get_seq_id;
1005: -- Setting item attributes
1006: l_return_Status := Set_Attributes(
1000: RAISE OKC_API.G_EXCEPTION_ERROR;
1001: END IF;
1002: l_oks_coverage_times_v_rec := null_out_defaults(p_oks_coverage_times_v_rec);
1003: -- Set primary key value
1004: l_oks_coverage_times_v_rec.ID := get_seq_id;
1005: -- Setting item attributes
1006: l_return_Status := Set_Attributes(
1007: l_oks_coverage_times_v_rec, -- IN
1008: l_def_oks_coverage_times_v_rec); -- OUT
1003: -- Set primary key value
1004: l_oks_coverage_times_v_rec.ID := get_seq_id;
1005: -- Setting item attributes
1006: l_return_Status := Set_Attributes(
1007: l_oks_coverage_times_v_rec, -- IN
1008: l_def_oks_coverage_times_v_rec); -- OUT
1009: --- If any errors happen abort API
1010: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1004: l_oks_coverage_times_v_rec.ID := get_seq_id;
1005: -- Setting item attributes
1006: l_return_Status := Set_Attributes(
1007: l_oks_coverage_times_v_rec, -- IN
1008: l_def_oks_coverage_times_v_rec); -- OUT
1009: --- If any errors happen abort API
1010: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1011: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1013: RAISE OKC_API.G_EXCEPTION_ERROR;
1014: END IF;
1015: l_def_oks_coverage_times_v_rec := fill_who_columns(l_def_oks_coverage_times_v_rec);
1016: --- Validate all non-missing attributes (Item Level Validation)
1017: l_return_status := Validate_Attributes(l_def_oks_coverage_times_v_rec);
1018: --- If any errors happen abort API
1019: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE OKC_API.G_EXCEPTION_ERROR;
1014: END IF;
1015: l_def_oks_coverage_times_v_rec := fill_who_columns(l_def_oks_coverage_times_v_rec);
1016: --- Validate all non-missing attributes (Item Level Validation)
1017: l_return_status := Validate_Attributes(l_def_oks_coverage_times_v_rec);
1018: --- If any errors happen abort API
1019: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1021: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1021: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1022: RAISE OKC_API.G_EXCEPTION_ERROR;
1023: END IF;
1024: l_return_status := Validate_Record(l_def_oks_coverage_times_v_rec);
1025: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1028: RAISE OKC_API.G_EXCEPTION_ERROR;
1029: END IF;
1030: -----------------------------------------
1031: -- Move VIEW record to "Child" records --
1032: -----------------------------------------
1033: migrate(l_def_oks_coverage_times_v_rec, l_oks_coverage_times_rec);
1034: -----------------------------------------------
1035: -- Call the INSERT_ROW for each child record --
1036: -----------------------------------------------
1037: insert_row(
1046: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1047: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1048: RAISE OKC_API.G_EXCEPTION_ERROR;
1049: END IF;
1050: migrate(lx_oks_coverage_times_rec, l_def_oks_coverage_times_v_rec);
1051: -- Set OUT values
1052: x_oks_coverage_times_v_rec := l_def_oks_coverage_times_v_rec;
1053: x_return_status := l_return_status;
1054: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1048: RAISE OKC_API.G_EXCEPTION_ERROR;
1049: END IF;
1050: migrate(lx_oks_coverage_times_rec, l_def_oks_coverage_times_v_rec);
1051: -- Set OUT values
1052: x_oks_coverage_times_v_rec := l_def_oks_coverage_times_v_rec;
1053: x_return_status := l_return_status;
1054: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1055: EXCEPTION
1056: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1084: '_PVT'
1085: );
1086: END insert_row;
1087: --------------------------------------------------------
1088: -- PL/SQL TBL insert_row for:OKS_COVERAGE_TIMES_V_TBL --
1089: --------------------------------------------------------
1090: PROCEDURE insert_row(
1091: p_api_version IN NUMBER,
1092: p_init_msg_list IN VARCHAR2,
1092: p_init_msg_list IN VARCHAR2,
1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_msg_count OUT NOCOPY NUMBER,
1095: x_msg_data OUT NOCOPY VARCHAR2,
1096: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
1097: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type,
1098: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1099:
1100: l_api_version CONSTANT NUMBER := 1;
1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_msg_count OUT NOCOPY NUMBER,
1095: x_msg_data OUT NOCOPY VARCHAR2,
1096: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
1097: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type,
1098: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1099:
1100: l_api_version CONSTANT NUMBER := 1;
1101: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1102: i NUMBER := 0;
1103: BEGIN
1104: OKC_API.init_msg_list(p_init_msg_list);
1105: -- Make sure PL/SQL table has records in it before passing
1106: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
1107: i := p_oks_coverage_times_v_tbl.FIRST;
1108: LOOP
1109: DECLARE
1110: l_error_rec OKC_API.ERROR_REC_TYPE;
1103: BEGIN
1104: OKC_API.init_msg_list(p_init_msg_list);
1105: -- Make sure PL/SQL table has records in it before passing
1106: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
1107: i := p_oks_coverage_times_v_tbl.FIRST;
1108: LOOP
1109: DECLARE
1110: l_error_rec OKC_API.ERROR_REC_TYPE;
1111: BEGIN
1117: p_init_msg_list => OKC_API.G_FALSE,
1118: x_return_status => l_error_rec.error_type,
1119: x_msg_count => l_error_rec.msg_count,
1120: x_msg_data => l_error_rec.msg_data,
1121: p_oks_coverage_times_v_rec => p_oks_coverage_times_v_tbl(i),
1122: x_oks_coverage_times_v_rec => x_oks_coverage_times_v_tbl(i));
1123: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1124: l_error_rec.sqlcode := SQLCODE;
1125: load_error_tbl(l_error_rec, px_error_tbl);
1118: x_return_status => l_error_rec.error_type,
1119: x_msg_count => l_error_rec.msg_count,
1120: x_msg_data => l_error_rec.msg_data,
1121: p_oks_coverage_times_v_rec => p_oks_coverage_times_v_tbl(i),
1122: x_oks_coverage_times_v_rec => x_oks_coverage_times_v_tbl(i));
1123: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1124: l_error_rec.sqlcode := SQLCODE;
1125: load_error_tbl(l_error_rec, px_error_tbl);
1126: ELSE
1140: l_error_rec.error_type := 'OTHERS';
1141: l_error_rec.sqlcode := SQLCODE;
1142: load_error_tbl(l_error_rec, px_error_tbl);
1143: END;
1144: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
1145: i := p_oks_coverage_times_v_tbl.NEXT(i);
1146: END LOOP;
1147: END IF;
1148: -- Loop through the error_tbl to find the error with the highest severity
1141: l_error_rec.sqlcode := SQLCODE;
1142: load_error_tbl(l_error_rec, px_error_tbl);
1143: END;
1144: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
1145: i := p_oks_coverage_times_v_tbl.NEXT(i);
1146: END LOOP;
1147: END IF;
1148: -- Loop through the error_tbl to find the error with the highest severity
1149: -- and return it.
1182: );
1183: END insert_row;
1184:
1185: --------------------------------------------------------
1186: -- PL/SQL TBL insert_row for:OKS_COVERAGE_TIMES_V_TBL --
1187: --------------------------------------------------------
1188: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
1189: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
1190: PROCEDURE insert_row(
1192: p_init_msg_list IN VARCHAR2,
1193: x_return_status OUT NOCOPY VARCHAR2,
1194: x_msg_count OUT NOCOPY NUMBER,
1195: x_msg_data OUT NOCOPY VARCHAR2,
1196: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
1197: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type) IS
1198:
1199: l_api_version CONSTANT NUMBER := 1;
1200: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1193: x_return_status OUT NOCOPY VARCHAR2,
1194: x_msg_count OUT NOCOPY NUMBER,
1195: x_msg_data OUT NOCOPY VARCHAR2,
1196: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
1197: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type) IS
1198:
1199: l_api_version CONSTANT NUMBER := 1;
1200: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1201: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1202: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1203: BEGIN
1204: OKC_API.init_msg_list(p_init_msg_list);
1205: -- Make sure PL/SQL table has records in it before passing
1206: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
1207: insert_row (
1208: p_api_version => p_api_version,
1209: p_init_msg_list => OKC_API.G_FALSE,
1210: x_return_status => x_return_status,
1209: p_init_msg_list => OKC_API.G_FALSE,
1210: x_return_status => x_return_status,
1211: x_msg_count => x_msg_count,
1212: x_msg_data => x_msg_data,
1213: p_oks_coverage_times_v_tbl => p_oks_coverage_times_v_tbl,
1214: x_oks_coverage_times_v_tbl => x_oks_coverage_times_v_tbl,
1215: px_error_tbl => l_error_tbl);
1216: END IF;
1217: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1210: x_return_status => x_return_status,
1211: x_msg_count => x_msg_count,
1212: x_msg_data => x_msg_data,
1213: p_oks_coverage_times_v_tbl => p_oks_coverage_times_v_tbl,
1214: x_oks_coverage_times_v_tbl => x_oks_coverage_times_v_tbl,
1215: px_error_tbl => l_error_tbl);
1216: END IF;
1217: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1218: EXCEPTION
1358: '_PVT'
1359: );
1360: END lock_row;
1361: ----------------------------------------
1362: -- lock_row for: OKS_COVERAGE_TIMES_V --
1363: ----------------------------------------
1364: PROCEDURE lock_row(
1365: p_api_version IN NUMBER,
1366: p_init_msg_list IN VARCHAR2,
1366: p_init_msg_list IN VARCHAR2,
1367: x_return_status OUT NOCOPY VARCHAR2,
1368: x_msg_count OUT NOCOPY NUMBER,
1369: x_msg_data OUT NOCOPY VARCHAR2,
1370: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type) IS
1371:
1372: l_api_version CONSTANT NUMBER := 1;
1373: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1374: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1388: END IF;
1389: -----------------------------------------
1390: -- Move VIEW record to "Child" records --
1391: -----------------------------------------
1392: migrate(p_oks_coverage_times_v_rec, l_oks_coverage_times_rec);
1393: ---------------------------------------------
1394: -- Call the LOCK_ROW for each child record --
1395: ---------------------------------------------
1396: lock_row(
1439: '_PVT'
1440: );
1441: END lock_row;
1442: ------------------------------------------------------
1443: -- PL/SQL TBL lock_row for:OKS_COVERAGE_TIMES_V_TBL --
1444: ------------------------------------------------------
1445: PROCEDURE lock_row(
1446: p_api_version IN NUMBER,
1447: p_init_msg_list IN VARCHAR2,
1447: p_init_msg_list IN VARCHAR2,
1448: x_return_status OUT NOCOPY VARCHAR2,
1449: x_msg_count OUT NOCOPY NUMBER,
1450: x_msg_data OUT NOCOPY VARCHAR2,
1451: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
1452: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1453:
1454: l_api_version CONSTANT NUMBER := 1;
1455: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1456: i NUMBER := 0;
1457: BEGIN
1458: OKC_API.init_msg_list(p_init_msg_list);
1459: -- Make sure PL/SQL table has recrods in it before passing
1460: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
1461: i := p_oks_coverage_times_v_tbl.FIRST;
1462: LOOP
1463: DECLARE
1464: l_error_rec OKC_API.ERROR_REC_TYPE;
1457: BEGIN
1458: OKC_API.init_msg_list(p_init_msg_list);
1459: -- Make sure PL/SQL table has recrods in it before passing
1460: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
1461: i := p_oks_coverage_times_v_tbl.FIRST;
1462: LOOP
1463: DECLARE
1464: l_error_rec OKC_API.ERROR_REC_TYPE;
1465: BEGIN
1471: p_init_msg_list => OKC_API.G_FALSE,
1472: x_return_status => l_error_rec.error_type,
1473: x_msg_count => l_error_rec.msg_count,
1474: x_msg_data => l_error_rec.msg_data,
1475: p_oks_coverage_times_v_rec => p_oks_coverage_times_v_tbl(i));
1476: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1477: l_error_rec.sqlcode := SQLCODE;
1478: load_error_tbl(l_error_rec, px_error_tbl);
1479: ELSE
1493: l_error_rec.error_type := 'OTHERS';
1494: l_error_rec.sqlcode := SQLCODE;
1495: load_error_tbl(l_error_rec, px_error_tbl);
1496: END;
1497: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
1498: i := p_oks_coverage_times_v_tbl.NEXT(i);
1499: END LOOP;
1500: END IF;
1501: -- Loop through the error_tbl to find the error with the highest severity
1494: l_error_rec.sqlcode := SQLCODE;
1495: load_error_tbl(l_error_rec, px_error_tbl);
1496: END;
1497: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
1498: i := p_oks_coverage_times_v_tbl.NEXT(i);
1499: END LOOP;
1500: END IF;
1501: -- Loop through the error_tbl to find the error with the highest severity
1502: -- and return it.
1534: '_PVT'
1535: );
1536: END lock_row;
1537: ------------------------------------------------------
1538: -- PL/SQL TBL lock_row for:OKS_COVERAGE_TIMES_V_TBL --
1539: ------------------------------------------------------
1540: PROCEDURE lock_row(
1541: p_api_version IN NUMBER,
1542: p_init_msg_list IN VARCHAR2,
1542: p_init_msg_list IN VARCHAR2,
1543: x_return_status OUT NOCOPY VARCHAR2,
1544: x_msg_count OUT NOCOPY NUMBER,
1545: x_msg_data OUT NOCOPY VARCHAR2,
1546: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type) IS
1547:
1548: l_api_version CONSTANT NUMBER := 1;
1549: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1550: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1551: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1552: BEGIN
1553: OKC_API.init_msg_list(p_init_msg_list);
1554: -- Make sure PL/SQL table has recrods in it before passing
1555: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
1556: lock_row(
1557: p_api_version => p_api_version,
1558: p_init_msg_list => OKC_API.G_FALSE,
1559: x_return_status => x_return_status,
1558: p_init_msg_list => OKC_API.G_FALSE,
1559: x_return_status => x_return_status,
1560: x_msg_count => x_msg_count,
1561: x_msg_data => x_msg_data,
1562: p_oks_coverage_times_v_tbl => p_oks_coverage_times_v_tbl,
1563: px_error_tbl => l_error_tbl);
1564: END IF;
1565: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1566: EXCEPTION
1829: '_PVT'
1830: );
1831: END update_row;
1832: -----------------------------------------
1833: -- update_row for:OKS_COVERAGE_TIMES_V --
1834: -----------------------------------------
1835: PROCEDURE update_row(
1836: p_api_version IN NUMBER,
1837: p_init_msg_list IN VARCHAR2,
1837: p_init_msg_list IN VARCHAR2,
1838: x_return_status OUT NOCOPY VARCHAR2,
1839: x_msg_count OUT NOCOPY NUMBER,
1840: x_msg_data OUT NOCOPY VARCHAR2,
1841: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
1842: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type) IS
1843:
1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1838: x_return_status OUT NOCOPY VARCHAR2,
1839: x_msg_count OUT NOCOPY NUMBER,
1840: x_msg_data OUT NOCOPY VARCHAR2,
1841: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
1842: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type) IS
1843:
1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1843:
1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1847: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
1848: l_def_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
1849: l_db_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
1850: l_oks_coverage_times_rec oks_coverage_times_rec_type;
1851: lx_oks_coverage_times_rec oks_coverage_times_rec_type;
1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1847: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
1848: l_def_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
1849: l_db_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
1850: l_oks_coverage_times_rec oks_coverage_times_rec_type;
1851: lx_oks_coverage_times_rec oks_coverage_times_rec_type;
1852: -------------------------------
1845: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1847: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
1848: l_def_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
1849: l_db_oks_coverage_times_v_rec oks_coverage_times_v_rec_type;
1850: l_oks_coverage_times_rec oks_coverage_times_rec_type;
1851: lx_oks_coverage_times_rec oks_coverage_times_rec_type;
1852: -------------------------------
1853: -- FUNCTION fill_who_columns --
1852: -------------------------------
1853: -- FUNCTION fill_who_columns --
1854: -------------------------------
1855: FUNCTION fill_who_columns (
1856: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
1857: ) RETURN oks_coverage_times_v_rec_type IS
1858: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
1859: BEGIN
1860: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1853: -- FUNCTION fill_who_columns --
1854: -------------------------------
1855: FUNCTION fill_who_columns (
1856: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
1857: ) RETURN oks_coverage_times_v_rec_type IS
1858: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
1859: BEGIN
1860: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1861: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1854: -------------------------------
1855: FUNCTION fill_who_columns (
1856: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
1857: ) RETURN oks_coverage_times_v_rec_type IS
1858: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
1859: BEGIN
1860: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1861: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1862: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1856: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type
1857: ) RETURN oks_coverage_times_v_rec_type IS
1858: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
1859: BEGIN
1860: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1861: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1862: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1863: RETURN(l_oks_coverage_times_v_rec);
1864: END fill_who_columns;
1857: ) RETURN oks_coverage_times_v_rec_type IS
1858: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
1859: BEGIN
1860: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1861: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1862: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1863: RETURN(l_oks_coverage_times_v_rec);
1864: END fill_who_columns;
1865: ----------------------------------
1858: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
1859: BEGIN
1860: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1861: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1862: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1863: RETURN(l_oks_coverage_times_v_rec);
1864: END fill_who_columns;
1865: ----------------------------------
1866: -- FUNCTION populate_new_record --
1859: BEGIN
1860: l_oks_coverage_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1861: l_oks_coverage_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1862: l_oks_coverage_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1863: RETURN(l_oks_coverage_times_v_rec);
1864: END fill_who_columns;
1865: ----------------------------------
1866: -- FUNCTION populate_new_record --
1867: ----------------------------------
1865: ----------------------------------
1866: -- FUNCTION populate_new_record --
1867: ----------------------------------
1868: FUNCTION populate_new_record (
1869: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
1870: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
1871: ) RETURN VARCHAR2 IS
1872: l_row_notfound BOOLEAN := TRUE;
1873: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1866: -- FUNCTION populate_new_record --
1867: ----------------------------------
1868: FUNCTION populate_new_record (
1869: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
1870: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
1871: ) RETURN VARCHAR2 IS
1872: l_row_notfound BOOLEAN := TRUE;
1873: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1874: BEGIN
1871: ) RETURN VARCHAR2 IS
1872: l_row_notfound BOOLEAN := TRUE;
1873: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1874: BEGIN
1875: x_oks_coverage_times_v_rec := p_oks_coverage_times_v_rec;
1876: -- Get current database values
1877: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1878: -- so it may be verified through LOCK_ROW.
1879: l_db_oks_coverage_times_v_rec := get_rec(p_oks_coverage_times_v_rec, l_return_status);
1875: x_oks_coverage_times_v_rec := p_oks_coverage_times_v_rec;
1876: -- Get current database values
1877: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1878: -- so it may be verified through LOCK_ROW.
1879: l_db_oks_coverage_times_v_rec := get_rec(p_oks_coverage_times_v_rec, l_return_status);
1880: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1881: IF (x_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM)
1882: THEN
1883: x_oks_coverage_times_v_rec.id := l_db_oks_coverage_times_v_rec.id;
1877: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1878: -- so it may be verified through LOCK_ROW.
1879: l_db_oks_coverage_times_v_rec := get_rec(p_oks_coverage_times_v_rec, l_return_status);
1880: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1881: IF (x_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM)
1882: THEN
1883: x_oks_coverage_times_v_rec.id := l_db_oks_coverage_times_v_rec.id;
1884: END IF;
1885: IF (x_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1879: l_db_oks_coverage_times_v_rec := get_rec(p_oks_coverage_times_v_rec, l_return_status);
1880: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1881: IF (x_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM)
1882: THEN
1883: x_oks_coverage_times_v_rec.id := l_db_oks_coverage_times_v_rec.id;
1884: END IF;
1885: IF (x_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1886: THEN
1887: x_oks_coverage_times_v_rec.dnz_chr_id := l_db_oks_coverage_times_v_rec.dnz_chr_id;
1881: IF (x_oks_coverage_times_v_rec.id = OKC_API.G_MISS_NUM)
1882: THEN
1883: x_oks_coverage_times_v_rec.id := l_db_oks_coverage_times_v_rec.id;
1884: END IF;
1885: IF (x_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1886: THEN
1887: x_oks_coverage_times_v_rec.dnz_chr_id := l_db_oks_coverage_times_v_rec.dnz_chr_id;
1888: END IF;
1889: IF (x_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM)
1883: x_oks_coverage_times_v_rec.id := l_db_oks_coverage_times_v_rec.id;
1884: END IF;
1885: IF (x_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1886: THEN
1887: x_oks_coverage_times_v_rec.dnz_chr_id := l_db_oks_coverage_times_v_rec.dnz_chr_id;
1888: END IF;
1889: IF (x_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM)
1890: THEN
1891: x_oks_coverage_times_v_rec.cov_tze_line_id := l_db_oks_coverage_times_v_rec.cov_tze_line_id;
1885: IF (x_oks_coverage_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1886: THEN
1887: x_oks_coverage_times_v_rec.dnz_chr_id := l_db_oks_coverage_times_v_rec.dnz_chr_id;
1888: END IF;
1889: IF (x_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM)
1890: THEN
1891: x_oks_coverage_times_v_rec.cov_tze_line_id := l_db_oks_coverage_times_v_rec.cov_tze_line_id;
1892: END IF;
1893: IF (x_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM)
1887: x_oks_coverage_times_v_rec.dnz_chr_id := l_db_oks_coverage_times_v_rec.dnz_chr_id;
1888: END IF;
1889: IF (x_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM)
1890: THEN
1891: x_oks_coverage_times_v_rec.cov_tze_line_id := l_db_oks_coverage_times_v_rec.cov_tze_line_id;
1892: END IF;
1893: IF (x_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM)
1894: THEN
1895: x_oks_coverage_times_v_rec.start_hour := l_db_oks_coverage_times_v_rec.start_hour;
1889: IF (x_oks_coverage_times_v_rec.cov_tze_line_id = OKC_API.G_MISS_NUM)
1890: THEN
1891: x_oks_coverage_times_v_rec.cov_tze_line_id := l_db_oks_coverage_times_v_rec.cov_tze_line_id;
1892: END IF;
1893: IF (x_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM)
1894: THEN
1895: x_oks_coverage_times_v_rec.start_hour := l_db_oks_coverage_times_v_rec.start_hour;
1896: END IF;
1897: IF (x_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM)
1891: x_oks_coverage_times_v_rec.cov_tze_line_id := l_db_oks_coverage_times_v_rec.cov_tze_line_id;
1892: END IF;
1893: IF (x_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM)
1894: THEN
1895: x_oks_coverage_times_v_rec.start_hour := l_db_oks_coverage_times_v_rec.start_hour;
1896: END IF;
1897: IF (x_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM)
1898: THEN
1899: x_oks_coverage_times_v_rec.start_minute := l_db_oks_coverage_times_v_rec.start_minute;
1893: IF (x_oks_coverage_times_v_rec.start_hour = OKC_API.G_MISS_NUM)
1894: THEN
1895: x_oks_coverage_times_v_rec.start_hour := l_db_oks_coverage_times_v_rec.start_hour;
1896: END IF;
1897: IF (x_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM)
1898: THEN
1899: x_oks_coverage_times_v_rec.start_minute := l_db_oks_coverage_times_v_rec.start_minute;
1900: END IF;
1901: IF (x_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM)
1895: x_oks_coverage_times_v_rec.start_hour := l_db_oks_coverage_times_v_rec.start_hour;
1896: END IF;
1897: IF (x_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM)
1898: THEN
1899: x_oks_coverage_times_v_rec.start_minute := l_db_oks_coverage_times_v_rec.start_minute;
1900: END IF;
1901: IF (x_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM)
1902: THEN
1903: x_oks_coverage_times_v_rec.end_hour := l_db_oks_coverage_times_v_rec.end_hour;
1897: IF (x_oks_coverage_times_v_rec.start_minute = OKC_API.G_MISS_NUM)
1898: THEN
1899: x_oks_coverage_times_v_rec.start_minute := l_db_oks_coverage_times_v_rec.start_minute;
1900: END IF;
1901: IF (x_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM)
1902: THEN
1903: x_oks_coverage_times_v_rec.end_hour := l_db_oks_coverage_times_v_rec.end_hour;
1904: END IF;
1905: IF (x_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM)
1899: x_oks_coverage_times_v_rec.start_minute := l_db_oks_coverage_times_v_rec.start_minute;
1900: END IF;
1901: IF (x_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM)
1902: THEN
1903: x_oks_coverage_times_v_rec.end_hour := l_db_oks_coverage_times_v_rec.end_hour;
1904: END IF;
1905: IF (x_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM)
1906: THEN
1907: x_oks_coverage_times_v_rec.end_minute := l_db_oks_coverage_times_v_rec.end_minute;
1901: IF (x_oks_coverage_times_v_rec.end_hour = OKC_API.G_MISS_NUM)
1902: THEN
1903: x_oks_coverage_times_v_rec.end_hour := l_db_oks_coverage_times_v_rec.end_hour;
1904: END IF;
1905: IF (x_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM)
1906: THEN
1907: x_oks_coverage_times_v_rec.end_minute := l_db_oks_coverage_times_v_rec.end_minute;
1908: END IF;
1909: IF (x_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR)
1903: x_oks_coverage_times_v_rec.end_hour := l_db_oks_coverage_times_v_rec.end_hour;
1904: END IF;
1905: IF (x_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM)
1906: THEN
1907: x_oks_coverage_times_v_rec.end_minute := l_db_oks_coverage_times_v_rec.end_minute;
1908: END IF;
1909: IF (x_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR)
1910: THEN
1911: x_oks_coverage_times_v_rec.monday_yn := l_db_oks_coverage_times_v_rec.monday_yn;
1905: IF (x_oks_coverage_times_v_rec.end_minute = OKC_API.G_MISS_NUM)
1906: THEN
1907: x_oks_coverage_times_v_rec.end_minute := l_db_oks_coverage_times_v_rec.end_minute;
1908: END IF;
1909: IF (x_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR)
1910: THEN
1911: x_oks_coverage_times_v_rec.monday_yn := l_db_oks_coverage_times_v_rec.monday_yn;
1912: END IF;
1913: IF (x_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR)
1907: x_oks_coverage_times_v_rec.end_minute := l_db_oks_coverage_times_v_rec.end_minute;
1908: END IF;
1909: IF (x_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR)
1910: THEN
1911: x_oks_coverage_times_v_rec.monday_yn := l_db_oks_coverage_times_v_rec.monday_yn;
1912: END IF;
1913: IF (x_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR)
1914: THEN
1915: x_oks_coverage_times_v_rec.tuesday_yn := l_db_oks_coverage_times_v_rec.tuesday_yn;
1909: IF (x_oks_coverage_times_v_rec.monday_yn = OKC_API.G_MISS_CHAR)
1910: THEN
1911: x_oks_coverage_times_v_rec.monday_yn := l_db_oks_coverage_times_v_rec.monday_yn;
1912: END IF;
1913: IF (x_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR)
1914: THEN
1915: x_oks_coverage_times_v_rec.tuesday_yn := l_db_oks_coverage_times_v_rec.tuesday_yn;
1916: END IF;
1917: IF (x_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR)
1911: x_oks_coverage_times_v_rec.monday_yn := l_db_oks_coverage_times_v_rec.monday_yn;
1912: END IF;
1913: IF (x_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR)
1914: THEN
1915: x_oks_coverage_times_v_rec.tuesday_yn := l_db_oks_coverage_times_v_rec.tuesday_yn;
1916: END IF;
1917: IF (x_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR)
1918: THEN
1919: x_oks_coverage_times_v_rec.wednesday_yn := l_db_oks_coverage_times_v_rec.wednesday_yn;
1913: IF (x_oks_coverage_times_v_rec.tuesday_yn = OKC_API.G_MISS_CHAR)
1914: THEN
1915: x_oks_coverage_times_v_rec.tuesday_yn := l_db_oks_coverage_times_v_rec.tuesday_yn;
1916: END IF;
1917: IF (x_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR)
1918: THEN
1919: x_oks_coverage_times_v_rec.wednesday_yn := l_db_oks_coverage_times_v_rec.wednesday_yn;
1920: END IF;
1921: IF (x_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR)
1915: x_oks_coverage_times_v_rec.tuesday_yn := l_db_oks_coverage_times_v_rec.tuesday_yn;
1916: END IF;
1917: IF (x_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR)
1918: THEN
1919: x_oks_coverage_times_v_rec.wednesday_yn := l_db_oks_coverage_times_v_rec.wednesday_yn;
1920: END IF;
1921: IF (x_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR)
1922: THEN
1923: x_oks_coverage_times_v_rec.thursday_yn := l_db_oks_coverage_times_v_rec.thursday_yn;
1917: IF (x_oks_coverage_times_v_rec.wednesday_yn = OKC_API.G_MISS_CHAR)
1918: THEN
1919: x_oks_coverage_times_v_rec.wednesday_yn := l_db_oks_coverage_times_v_rec.wednesday_yn;
1920: END IF;
1921: IF (x_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR)
1922: THEN
1923: x_oks_coverage_times_v_rec.thursday_yn := l_db_oks_coverage_times_v_rec.thursday_yn;
1924: END IF;
1925: IF (x_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR)
1919: x_oks_coverage_times_v_rec.wednesday_yn := l_db_oks_coverage_times_v_rec.wednesday_yn;
1920: END IF;
1921: IF (x_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR)
1922: THEN
1923: x_oks_coverage_times_v_rec.thursday_yn := l_db_oks_coverage_times_v_rec.thursday_yn;
1924: END IF;
1925: IF (x_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR)
1926: THEN
1927: x_oks_coverage_times_v_rec.friday_yn := l_db_oks_coverage_times_v_rec.friday_yn;
1921: IF (x_oks_coverage_times_v_rec.thursday_yn = OKC_API.G_MISS_CHAR)
1922: THEN
1923: x_oks_coverage_times_v_rec.thursday_yn := l_db_oks_coverage_times_v_rec.thursday_yn;
1924: END IF;
1925: IF (x_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR)
1926: THEN
1927: x_oks_coverage_times_v_rec.friday_yn := l_db_oks_coverage_times_v_rec.friday_yn;
1928: END IF;
1929: IF (x_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR)
1923: x_oks_coverage_times_v_rec.thursday_yn := l_db_oks_coverage_times_v_rec.thursday_yn;
1924: END IF;
1925: IF (x_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR)
1926: THEN
1927: x_oks_coverage_times_v_rec.friday_yn := l_db_oks_coverage_times_v_rec.friday_yn;
1928: END IF;
1929: IF (x_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR)
1930: THEN
1931: x_oks_coverage_times_v_rec.saturday_yn := l_db_oks_coverage_times_v_rec.saturday_yn;
1925: IF (x_oks_coverage_times_v_rec.friday_yn = OKC_API.G_MISS_CHAR)
1926: THEN
1927: x_oks_coverage_times_v_rec.friday_yn := l_db_oks_coverage_times_v_rec.friday_yn;
1928: END IF;
1929: IF (x_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR)
1930: THEN
1931: x_oks_coverage_times_v_rec.saturday_yn := l_db_oks_coverage_times_v_rec.saturday_yn;
1932: END IF;
1933: IF (x_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR)
1927: x_oks_coverage_times_v_rec.friday_yn := l_db_oks_coverage_times_v_rec.friday_yn;
1928: END IF;
1929: IF (x_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR)
1930: THEN
1931: x_oks_coverage_times_v_rec.saturday_yn := l_db_oks_coverage_times_v_rec.saturday_yn;
1932: END IF;
1933: IF (x_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR)
1934: THEN
1935: x_oks_coverage_times_v_rec.sunday_yn := l_db_oks_coverage_times_v_rec.sunday_yn;
1929: IF (x_oks_coverage_times_v_rec.saturday_yn = OKC_API.G_MISS_CHAR)
1930: THEN
1931: x_oks_coverage_times_v_rec.saturday_yn := l_db_oks_coverage_times_v_rec.saturday_yn;
1932: END IF;
1933: IF (x_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR)
1934: THEN
1935: x_oks_coverage_times_v_rec.sunday_yn := l_db_oks_coverage_times_v_rec.sunday_yn;
1936: END IF;
1937: IF (x_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1931: x_oks_coverage_times_v_rec.saturday_yn := l_db_oks_coverage_times_v_rec.saturday_yn;
1932: END IF;
1933: IF (x_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR)
1934: THEN
1935: x_oks_coverage_times_v_rec.sunday_yn := l_db_oks_coverage_times_v_rec.sunday_yn;
1936: END IF;
1937: IF (x_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1938: THEN
1939: x_oks_coverage_times_v_rec.security_group_id := l_db_oks_coverage_times_v_rec.security_group_id;
1933: IF (x_oks_coverage_times_v_rec.sunday_yn = OKC_API.G_MISS_CHAR)
1934: THEN
1935: x_oks_coverage_times_v_rec.sunday_yn := l_db_oks_coverage_times_v_rec.sunday_yn;
1936: END IF;
1937: IF (x_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1938: THEN
1939: x_oks_coverage_times_v_rec.security_group_id := l_db_oks_coverage_times_v_rec.security_group_id;
1940: END IF;
1941: IF (x_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1935: x_oks_coverage_times_v_rec.sunday_yn := l_db_oks_coverage_times_v_rec.sunday_yn;
1936: END IF;
1937: IF (x_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1938: THEN
1939: x_oks_coverage_times_v_rec.security_group_id := l_db_oks_coverage_times_v_rec.security_group_id;
1940: END IF;
1941: IF (x_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1942: THEN
1943: x_oks_coverage_times_v_rec.program_application_id := l_db_oks_coverage_times_v_rec.program_application_id;
1937: IF (x_oks_coverage_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1938: THEN
1939: x_oks_coverage_times_v_rec.security_group_id := l_db_oks_coverage_times_v_rec.security_group_id;
1940: END IF;
1941: IF (x_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1942: THEN
1943: x_oks_coverage_times_v_rec.program_application_id := l_db_oks_coverage_times_v_rec.program_application_id;
1944: END IF;
1945: IF (x_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1939: x_oks_coverage_times_v_rec.security_group_id := l_db_oks_coverage_times_v_rec.security_group_id;
1940: END IF;
1941: IF (x_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1942: THEN
1943: x_oks_coverage_times_v_rec.program_application_id := l_db_oks_coverage_times_v_rec.program_application_id;
1944: END IF;
1945: IF (x_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1946: THEN
1947: x_oks_coverage_times_v_rec.program_id := l_db_oks_coverage_times_v_rec.program_id;
1941: IF (x_oks_coverage_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1942: THEN
1943: x_oks_coverage_times_v_rec.program_application_id := l_db_oks_coverage_times_v_rec.program_application_id;
1944: END IF;
1945: IF (x_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1946: THEN
1947: x_oks_coverage_times_v_rec.program_id := l_db_oks_coverage_times_v_rec.program_id;
1948: END IF;
1949: IF (x_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1943: x_oks_coverage_times_v_rec.program_application_id := l_db_oks_coverage_times_v_rec.program_application_id;
1944: END IF;
1945: IF (x_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1946: THEN
1947: x_oks_coverage_times_v_rec.program_id := l_db_oks_coverage_times_v_rec.program_id;
1948: END IF;
1949: IF (x_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1950: THEN
1951: x_oks_coverage_times_v_rec.program_update_date := l_db_oks_coverage_times_v_rec.program_update_date;
1945: IF (x_oks_coverage_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1946: THEN
1947: x_oks_coverage_times_v_rec.program_id := l_db_oks_coverage_times_v_rec.program_id;
1948: END IF;
1949: IF (x_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1950: THEN
1951: x_oks_coverage_times_v_rec.program_update_date := l_db_oks_coverage_times_v_rec.program_update_date;
1952: END IF;
1953: IF (x_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1947: x_oks_coverage_times_v_rec.program_id := l_db_oks_coverage_times_v_rec.program_id;
1948: END IF;
1949: IF (x_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1950: THEN
1951: x_oks_coverage_times_v_rec.program_update_date := l_db_oks_coverage_times_v_rec.program_update_date;
1952: END IF;
1953: IF (x_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1954: THEN
1955: x_oks_coverage_times_v_rec.request_id := l_db_oks_coverage_times_v_rec.request_id;
1949: IF (x_oks_coverage_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1950: THEN
1951: x_oks_coverage_times_v_rec.program_update_date := l_db_oks_coverage_times_v_rec.program_update_date;
1952: END IF;
1953: IF (x_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1954: THEN
1955: x_oks_coverage_times_v_rec.request_id := l_db_oks_coverage_times_v_rec.request_id;
1956: END IF;
1957: IF (x_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1951: x_oks_coverage_times_v_rec.program_update_date := l_db_oks_coverage_times_v_rec.program_update_date;
1952: END IF;
1953: IF (x_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1954: THEN
1955: x_oks_coverage_times_v_rec.request_id := l_db_oks_coverage_times_v_rec.request_id;
1956: END IF;
1957: IF (x_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1958: THEN
1959: x_oks_coverage_times_v_rec.created_by := l_db_oks_coverage_times_v_rec.created_by;
1953: IF (x_oks_coverage_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1954: THEN
1955: x_oks_coverage_times_v_rec.request_id := l_db_oks_coverage_times_v_rec.request_id;
1956: END IF;
1957: IF (x_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1958: THEN
1959: x_oks_coverage_times_v_rec.created_by := l_db_oks_coverage_times_v_rec.created_by;
1960: END IF;
1961: IF (x_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1955: x_oks_coverage_times_v_rec.request_id := l_db_oks_coverage_times_v_rec.request_id;
1956: END IF;
1957: IF (x_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1958: THEN
1959: x_oks_coverage_times_v_rec.created_by := l_db_oks_coverage_times_v_rec.created_by;
1960: END IF;
1961: IF (x_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1962: THEN
1963: x_oks_coverage_times_v_rec.creation_date := l_db_oks_coverage_times_v_rec.creation_date;
1957: IF (x_oks_coverage_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1958: THEN
1959: x_oks_coverage_times_v_rec.created_by := l_db_oks_coverage_times_v_rec.created_by;
1960: END IF;
1961: IF (x_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1962: THEN
1963: x_oks_coverage_times_v_rec.creation_date := l_db_oks_coverage_times_v_rec.creation_date;
1964: END IF;
1965: IF (x_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1959: x_oks_coverage_times_v_rec.created_by := l_db_oks_coverage_times_v_rec.created_by;
1960: END IF;
1961: IF (x_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1962: THEN
1963: x_oks_coverage_times_v_rec.creation_date := l_db_oks_coverage_times_v_rec.creation_date;
1964: END IF;
1965: IF (x_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1966: THEN
1967: x_oks_coverage_times_v_rec.last_updated_by := l_db_oks_coverage_times_v_rec.last_updated_by;
1961: IF (x_oks_coverage_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1962: THEN
1963: x_oks_coverage_times_v_rec.creation_date := l_db_oks_coverage_times_v_rec.creation_date;
1964: END IF;
1965: IF (x_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1966: THEN
1967: x_oks_coverage_times_v_rec.last_updated_by := l_db_oks_coverage_times_v_rec.last_updated_by;
1968: END IF;
1969: IF (x_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1963: x_oks_coverage_times_v_rec.creation_date := l_db_oks_coverage_times_v_rec.creation_date;
1964: END IF;
1965: IF (x_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1966: THEN
1967: x_oks_coverage_times_v_rec.last_updated_by := l_db_oks_coverage_times_v_rec.last_updated_by;
1968: END IF;
1969: IF (x_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1970: THEN
1971: x_oks_coverage_times_v_rec.last_update_date := l_db_oks_coverage_times_v_rec.last_update_date;
1965: IF (x_oks_coverage_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1966: THEN
1967: x_oks_coverage_times_v_rec.last_updated_by := l_db_oks_coverage_times_v_rec.last_updated_by;
1968: END IF;
1969: IF (x_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1970: THEN
1971: x_oks_coverage_times_v_rec.last_update_date := l_db_oks_coverage_times_v_rec.last_update_date;
1972: END IF;
1973: IF (x_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1967: x_oks_coverage_times_v_rec.last_updated_by := l_db_oks_coverage_times_v_rec.last_updated_by;
1968: END IF;
1969: IF (x_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1970: THEN
1971: x_oks_coverage_times_v_rec.last_update_date := l_db_oks_coverage_times_v_rec.last_update_date;
1972: END IF;
1973: IF (x_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1974: THEN
1975: x_oks_coverage_times_v_rec.last_update_login := l_db_oks_coverage_times_v_rec.last_update_login;
1969: IF (x_oks_coverage_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1970: THEN
1971: x_oks_coverage_times_v_rec.last_update_date := l_db_oks_coverage_times_v_rec.last_update_date;
1972: END IF;
1973: IF (x_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1974: THEN
1975: x_oks_coverage_times_v_rec.last_update_login := l_db_oks_coverage_times_v_rec.last_update_login;
1976: END IF;
1977: END IF;
1971: x_oks_coverage_times_v_rec.last_update_date := l_db_oks_coverage_times_v_rec.last_update_date;
1972: END IF;
1973: IF (x_oks_coverage_times_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1974: THEN
1975: x_oks_coverage_times_v_rec.last_update_login := l_db_oks_coverage_times_v_rec.last_update_login;
1976: END IF;
1977: END IF;
1978: RETURN(l_return_status);
1979: END populate_new_record;
1977: END IF;
1978: RETURN(l_return_status);
1979: END populate_new_record;
1980: ---------------------------------------------
1981: -- Set_Attributes for:OKS_COVERAGE_TIMES_V --
1982: ---------------------------------------------
1983: FUNCTION Set_Attributes (
1984: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
1985: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
1980: ---------------------------------------------
1981: -- Set_Attributes for:OKS_COVERAGE_TIMES_V --
1982: ---------------------------------------------
1983: FUNCTION Set_Attributes (
1984: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
1985: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
1986: ) RETURN VARCHAR2 IS
1987: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1988: BEGIN
1981: -- Set_Attributes for:OKS_COVERAGE_TIMES_V --
1982: ---------------------------------------------
1983: FUNCTION Set_Attributes (
1984: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type,
1985: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
1986: ) RETURN VARCHAR2 IS
1987: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1988: BEGIN
1989: x_oks_coverage_times_v_rec := p_oks_coverage_times_v_rec;
1985: x_oks_coverage_times_v_rec OUT NOCOPY oks_coverage_times_v_rec_type
1986: ) RETURN VARCHAR2 IS
1987: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1988: BEGIN
1989: x_oks_coverage_times_v_rec := p_oks_coverage_times_v_rec;
1990: RETURN(l_return_status);
1991: END Set_Attributes;
1992: BEGIN
1993: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2003: RAISE OKC_API.G_EXCEPTION_ERROR;
2004: END IF;
2005: --- Setting item attributes
2006: l_return_status := Set_Attributes(
2007: p_oks_coverage_times_v_rec, -- IN
2008: x_oks_coverage_times_v_rec); -- OUT
2009: --- If any errors happen abort API
2010: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2011: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2004: END IF;
2005: --- Setting item attributes
2006: l_return_status := Set_Attributes(
2007: p_oks_coverage_times_v_rec, -- IN
2008: x_oks_coverage_times_v_rec); -- OUT
2009: --- If any errors happen abort API
2010: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2011: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2012: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2011: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2012: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2013: RAISE OKC_API.G_EXCEPTION_ERROR;
2014: END IF;
2015: l_return_status := populate_new_record(l_oks_coverage_times_v_rec, l_def_oks_coverage_times_v_rec);
2016: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2017: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2018: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2019: RAISE OKC_API.G_EXCEPTION_ERROR;
2017: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2018: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2019: RAISE OKC_API.G_EXCEPTION_ERROR;
2020: END IF;
2021: l_def_oks_coverage_times_v_rec := fill_who_columns(l_def_oks_coverage_times_v_rec);
2022: --- Validate all non-missing attributes (Item Level Validation)
2023: l_return_status := Validate_Attributes(l_def_oks_coverage_times_v_rec);
2024: --- If any errors happen abort API
2025: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2019: RAISE OKC_API.G_EXCEPTION_ERROR;
2020: END IF;
2021: l_def_oks_coverage_times_v_rec := fill_who_columns(l_def_oks_coverage_times_v_rec);
2022: --- Validate all non-missing attributes (Item Level Validation)
2023: l_return_status := Validate_Attributes(l_def_oks_coverage_times_v_rec);
2024: --- If any errors happen abort API
2025: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2026: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2026: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2028: RAISE OKC_API.G_EXCEPTION_ERROR;
2029: END IF;
2030: l_return_status := Validate_Record(l_def_oks_coverage_times_v_rec, l_db_oks_coverage_times_v_rec);
2031: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2032: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2033: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2034: RAISE OKC_API.G_EXCEPTION_ERROR;
2040: p_init_msg_list => p_init_msg_list,
2041: x_return_status => l_return_status,
2042: x_msg_count => x_msg_count,
2043: x_msg_data => x_msg_data,
2044: p_oks_coverage_times_v_rec => p_oks_coverage_times_v_rec);
2045: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2046: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2047: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2048: RAISE OKC_API.G_EXCEPTION_ERROR;
2050:
2051: -----------------------------------------
2052: -- Move VIEW record to "Child" records --
2053: -----------------------------------------
2054: migrate(l_def_oks_coverage_times_v_rec, l_oks_coverage_times_rec);
2055: -----------------------------------------------
2056: -- Call the UPDATE_ROW for each child record --
2057: -----------------------------------------------
2058: update_row(
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;
2071: migrate(lx_oks_coverage_times_rec, l_def_oks_coverage_times_v_rec);
2072: x_oks_coverage_times_v_rec := l_def_oks_coverage_times_v_rec;
2073: x_return_status := l_return_status;
2074: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2075: EXCEPTION
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;
2071: migrate(lx_oks_coverage_times_rec, l_def_oks_coverage_times_v_rec);
2072: x_oks_coverage_times_v_rec := l_def_oks_coverage_times_v_rec;
2073: x_return_status := l_return_status;
2074: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2075: EXCEPTION
2076: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2104: '_PVT'
2105: );
2106: END update_row;
2107: --------------------------------------------------------
2108: -- PL/SQL TBL update_row for:oks_coverage_times_v_tbl --
2109: --------------------------------------------------------
2110: PROCEDURE update_row(
2111: p_api_version IN NUMBER,
2112: p_init_msg_list IN VARCHAR2,
2112: p_init_msg_list IN VARCHAR2,
2113: x_return_status OUT NOCOPY VARCHAR2,
2114: x_msg_count OUT NOCOPY NUMBER,
2115: x_msg_data OUT NOCOPY VARCHAR2,
2116: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
2117: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type,
2118: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2119:
2120: l_api_version CONSTANT NUMBER := 1;
2113: x_return_status OUT NOCOPY VARCHAR2,
2114: x_msg_count OUT NOCOPY NUMBER,
2115: x_msg_data OUT NOCOPY VARCHAR2,
2116: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
2117: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type,
2118: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2119:
2120: l_api_version CONSTANT NUMBER := 1;
2121: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2122: i NUMBER := 0;
2123: BEGIN
2124: OKC_API.init_msg_list(p_init_msg_list);
2125: -- Make sure PL/SQL table has records in it before passing
2126: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
2127: i := p_oks_coverage_times_v_tbl.FIRST;
2128: LOOP
2129: DECLARE
2130: l_error_rec OKC_API.ERROR_REC_TYPE;
2123: BEGIN
2124: OKC_API.init_msg_list(p_init_msg_list);
2125: -- Make sure PL/SQL table has records in it before passing
2126: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
2127: i := p_oks_coverage_times_v_tbl.FIRST;
2128: LOOP
2129: DECLARE
2130: l_error_rec OKC_API.ERROR_REC_TYPE;
2131: BEGIN
2137: p_init_msg_list => OKC_API.G_FALSE,
2138: x_return_status => l_error_rec.error_type,
2139: x_msg_count => l_error_rec.msg_count,
2140: x_msg_data => l_error_rec.msg_data,
2141: p_oks_coverage_times_v_rec => p_oks_coverage_times_v_tbl(i),
2142: x_oks_coverage_times_v_rec => x_oks_coverage_times_v_tbl(i));
2143: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2144: l_error_rec.sqlcode := SQLCODE;
2145: load_error_tbl(l_error_rec, px_error_tbl);
2138: x_return_status => l_error_rec.error_type,
2139: x_msg_count => l_error_rec.msg_count,
2140: x_msg_data => l_error_rec.msg_data,
2141: p_oks_coverage_times_v_rec => p_oks_coverage_times_v_tbl(i),
2142: x_oks_coverage_times_v_rec => x_oks_coverage_times_v_tbl(i));
2143: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2144: l_error_rec.sqlcode := SQLCODE;
2145: load_error_tbl(l_error_rec, px_error_tbl);
2146: ELSE
2160: l_error_rec.error_type := 'OTHERS';
2161: l_error_rec.sqlcode := SQLCODE;
2162: load_error_tbl(l_error_rec, px_error_tbl);
2163: END;
2164: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
2165: i := p_oks_coverage_times_v_tbl.NEXT(i);
2166: END LOOP;
2167: END IF;
2168: -- Loop through the error_tbl to find the error with the highest severity
2161: l_error_rec.sqlcode := SQLCODE;
2162: load_error_tbl(l_error_rec, px_error_tbl);
2163: END;
2164: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
2165: i := p_oks_coverage_times_v_tbl.NEXT(i);
2166: END LOOP;
2167: END IF;
2168: -- Loop through the error_tbl to find the error with the highest severity
2169: -- and return it.
2202: );
2203: END update_row;
2204:
2205: --------------------------------------------------------
2206: -- PL/SQL TBL update_row for:OKS_COVERAGE_TIMES_V_TBL --
2207: --------------------------------------------------------
2208: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
2209: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
2210: PROCEDURE update_row(
2212: p_init_msg_list IN VARCHAR2,
2213: x_return_status OUT NOCOPY VARCHAR2,
2214: x_msg_count OUT NOCOPY NUMBER,
2215: x_msg_data OUT NOCOPY VARCHAR2,
2216: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
2217: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type) IS
2218:
2219: l_api_version CONSTANT NUMBER := 1;
2220: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2213: x_return_status OUT NOCOPY VARCHAR2,
2214: x_msg_count OUT NOCOPY NUMBER,
2215: x_msg_data OUT NOCOPY VARCHAR2,
2216: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
2217: x_oks_coverage_times_v_tbl OUT NOCOPY oks_coverage_times_v_tbl_type) IS
2218:
2219: l_api_version CONSTANT NUMBER := 1;
2220: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2221: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2222: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2223: BEGIN
2224: OKC_API.init_msg_list(p_init_msg_list);
2225: -- Make sure PL/SQL table has records in it before passing
2226: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
2227: update_row (
2228: p_api_version => p_api_version,
2229: p_init_msg_list => OKC_API.G_FALSE,
2230: x_return_status => x_return_status,
2229: p_init_msg_list => OKC_API.G_FALSE,
2230: x_return_status => x_return_status,
2231: x_msg_count => x_msg_count,
2232: x_msg_data => x_msg_data,
2233: p_oks_coverage_times_v_tbl => p_oks_coverage_times_v_tbl,
2234: x_oks_coverage_times_v_tbl => x_oks_coverage_times_v_tbl,
2235: px_error_tbl => l_error_tbl);
2236: END IF;
2237: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2230: x_return_status => x_return_status,
2231: x_msg_count => x_msg_count,
2232: x_msg_data => x_msg_data,
2233: p_oks_coverage_times_v_tbl => p_oks_coverage_times_v_tbl,
2234: x_oks_coverage_times_v_tbl => x_oks_coverage_times_v_tbl,
2235: px_error_tbl => l_error_tbl);
2236: END IF;
2237: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2238: EXCEPTION
2334: '_PVT'
2335: );
2336: END delete_row;
2337: -----------------------------------------
2338: -- delete_row for:OKS_COVERAGE_TIMES_V --
2339: -----------------------------------------
2340: PROCEDURE delete_row(
2341: p_api_version IN NUMBER,
2342: p_init_msg_list IN VARCHAR2,
2342: p_init_msg_list IN VARCHAR2,
2343: x_return_status OUT NOCOPY VARCHAR2,
2344: x_msg_count OUT NOCOPY NUMBER,
2345: x_msg_data OUT NOCOPY VARCHAR2,
2346: p_oks_coverage_times_v_rec IN oks_coverage_times_v_rec_type) IS
2347:
2348: l_api_version CONSTANT NUMBER := 1;
2349: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2347:
2348: l_api_version CONSTANT NUMBER := 1;
2349: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2351: l_oks_coverage_times_v_rec oks_coverage_times_v_rec_type := p_oks_coverage_times_v_rec;
2352: l_oks_coverage_times_rec oks_coverage_times_rec_type;
2353: BEGIN
2354: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2355: G_PKG_NAME,
2365: END IF;
2366: -----------------------------------------
2367: -- Move VIEW record to "Child" records --
2368: -----------------------------------------
2369: migrate(l_oks_coverage_times_v_rec, l_oks_coverage_times_rec);
2370: -----------------------------------------------
2371: -- Call the DELETE_ROW for each child record --
2372: -----------------------------------------------
2373: delete_row(
2416: '_PVT'
2417: );
2418: END delete_row;
2419: ----------------------------------------------------
2420: -- PL/SQL TBL delete_row for:OKS_COVERAGE_TIMES_V --
2421: ----------------------------------------------------
2422: PROCEDURE delete_row(
2423: p_api_version IN NUMBER,
2424: p_init_msg_list IN VARCHAR2,
2424: p_init_msg_list IN VARCHAR2,
2425: x_return_status OUT NOCOPY VARCHAR2,
2426: x_msg_count OUT NOCOPY NUMBER,
2427: x_msg_data OUT NOCOPY VARCHAR2,
2428: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type,
2429: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2430:
2431: l_api_version CONSTANT NUMBER := 1;
2432: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2433: i NUMBER := 0;
2434: BEGIN
2435: OKC_API.init_msg_list(p_init_msg_list);
2436: -- Make sure PL/SQL table has records in it before passing
2437: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
2438: i := p_oks_coverage_times_v_tbl.FIRST;
2439: LOOP
2440: DECLARE
2441: l_error_rec OKC_API.ERROR_REC_TYPE;
2434: BEGIN
2435: OKC_API.init_msg_list(p_init_msg_list);
2436: -- Make sure PL/SQL table has records in it before passing
2437: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
2438: i := p_oks_coverage_times_v_tbl.FIRST;
2439: LOOP
2440: DECLARE
2441: l_error_rec OKC_API.ERROR_REC_TYPE;
2442: BEGIN
2448: p_init_msg_list => OKC_API.G_FALSE,
2449: x_return_status => l_error_rec.error_type,
2450: x_msg_count => l_error_rec.msg_count,
2451: x_msg_data => l_error_rec.msg_data,
2452: p_oks_coverage_times_v_rec => p_oks_coverage_times_v_tbl(i));
2453: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2454: l_error_rec.sqlcode := SQLCODE;
2455: load_error_tbl(l_error_rec, px_error_tbl);
2456: ELSE
2470: l_error_rec.error_type := 'OTHERS';
2471: l_error_rec.sqlcode := SQLCODE;
2472: load_error_tbl(l_error_rec, px_error_tbl);
2473: END;
2474: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
2475: i := p_oks_coverage_times_v_tbl.NEXT(i);
2476: END LOOP;
2477: END IF;
2478: -- Loop through the error_tbl to find the error with the highest severity
2471: l_error_rec.sqlcode := SQLCODE;
2472: load_error_tbl(l_error_rec, px_error_tbl);
2473: END;
2474: EXIT WHEN (i = p_oks_coverage_times_v_tbl.LAST);
2475: i := p_oks_coverage_times_v_tbl.NEXT(i);
2476: END LOOP;
2477: END IF;
2478: -- Loop through the error_tbl to find the error with the highest severity
2479: -- and return it.
2512: );
2513: END delete_row;
2514:
2515: ----------------------------------------------------
2516: -- PL/SQL TBL delete_row for:OKS_COVERAGE_TIMES_V --
2517: ----------------------------------------------------
2518: PROCEDURE delete_row(
2519: p_api_version IN NUMBER,
2520: p_init_msg_list IN VARCHAR2,
2520: p_init_msg_list IN VARCHAR2,
2521: x_return_status OUT NOCOPY VARCHAR2,
2522: x_msg_count OUT NOCOPY NUMBER,
2523: x_msg_data OUT NOCOPY VARCHAR2,
2524: p_oks_coverage_times_v_tbl IN oks_coverage_times_v_tbl_type) IS
2525:
2526: l_api_version CONSTANT NUMBER := 1;
2527: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2528: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2529: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2530: BEGIN
2531: OKC_API.init_msg_list(p_init_msg_list);
2532: -- Make sure PL/SQL table has records in it before passing
2533: IF (p_oks_coverage_times_v_tbl.COUNT > 0) THEN
2534: delete_row (
2535: p_api_version => p_api_version,
2536: p_init_msg_list => OKC_API.G_FALSE,
2537: x_return_status => x_return_status,
2536: p_init_msg_list => OKC_API.G_FALSE,
2537: x_return_status => x_return_status,
2538: x_msg_count => x_msg_count,
2539: x_msg_data => x_msg_data,
2540: p_oks_coverage_times_v_tbl => p_oks_coverage_times_v_tbl,
2541: px_error_tbl => l_error_tbl);
2542: END IF;
2543: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2544: EXCEPTION