[Home] [Help]
90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_ACTION_TIMES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_ACTION_TIMES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN oks_action_times_v_rec_type IS
100: CURSOR oks_atv_pk_csr (p_id IN NUMBER) IS
101: SELECT
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN oks_action_times_v_rec_type IS
100: CURSOR oks_atv_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: COV_ACTION_TYPE_ID,
121: LAST_UPDATED_BY,
122: LAST_UPDATE_DATE,
123: LAST_UPDATE_LOGIN,
124: OBJECT_VERSION_NUMBER
125: FROM Oks_Action_Times_V
126: WHERE oks_action_times_v.id = p_id;
127: l_oks_atv_pk oks_atv_pk_csr%ROWTYPE;
128: l_oks_action_times_v_rec oks_action_times_v_rec_type;
129: BEGIN
122: LAST_UPDATE_DATE,
123: LAST_UPDATE_LOGIN,
124: OBJECT_VERSION_NUMBER
125: FROM Oks_Action_Times_V
126: WHERE oks_action_times_v.id = p_id;
127: l_oks_atv_pk oks_atv_pk_csr%ROWTYPE;
128: l_oks_action_times_v_rec oks_action_times_v_rec_type;
129: BEGIN
130: x_no_data_found := TRUE;
124: OBJECT_VERSION_NUMBER
125: FROM Oks_Action_Times_V
126: WHERE oks_action_times_v.id = p_id;
127: l_oks_atv_pk oks_atv_pk_csr%ROWTYPE;
128: l_oks_action_times_v_rec oks_action_times_v_rec_type;
129: BEGIN
130: x_no_data_found := TRUE;
131: -- Get current database values
132: OPEN oks_atv_pk_csr (p_oks_action_times_v_rec.id);
128: l_oks_action_times_v_rec oks_action_times_v_rec_type;
129: BEGIN
130: x_no_data_found := TRUE;
131: -- Get current database values
132: OPEN oks_atv_pk_csr (p_oks_action_times_v_rec.id);
133: FETCH oks_atv_pk_csr INTO
134: l_oks_action_times_v_rec.id,
135: l_oks_action_times_v_rec.cov_action_type_id,
136: l_oks_action_times_v_rec.cle_id,
130: x_no_data_found := TRUE;
131: -- Get current database values
132: OPEN oks_atv_pk_csr (p_oks_action_times_v_rec.id);
133: FETCH oks_atv_pk_csr INTO
134: l_oks_action_times_v_rec.id,
135: l_oks_action_times_v_rec.cov_action_type_id,
136: l_oks_action_times_v_rec.cle_id,
137: l_oks_action_times_v_rec.dnz_chr_id,
138: l_oks_action_times_v_rec.uom_code,
131: -- Get current database values
132: OPEN oks_atv_pk_csr (p_oks_action_times_v_rec.id);
133: FETCH oks_atv_pk_csr INTO
134: l_oks_action_times_v_rec.id,
135: l_oks_action_times_v_rec.cov_action_type_id,
136: l_oks_action_times_v_rec.cle_id,
137: l_oks_action_times_v_rec.dnz_chr_id,
138: l_oks_action_times_v_rec.uom_code,
139: l_oks_action_times_v_rec.sun_duration,
132: OPEN oks_atv_pk_csr (p_oks_action_times_v_rec.id);
133: FETCH oks_atv_pk_csr INTO
134: l_oks_action_times_v_rec.id,
135: l_oks_action_times_v_rec.cov_action_type_id,
136: l_oks_action_times_v_rec.cle_id,
137: l_oks_action_times_v_rec.dnz_chr_id,
138: l_oks_action_times_v_rec.uom_code,
139: l_oks_action_times_v_rec.sun_duration,
140: l_oks_action_times_v_rec.mon_duration,
133: FETCH oks_atv_pk_csr INTO
134: l_oks_action_times_v_rec.id,
135: l_oks_action_times_v_rec.cov_action_type_id,
136: l_oks_action_times_v_rec.cle_id,
137: l_oks_action_times_v_rec.dnz_chr_id,
138: l_oks_action_times_v_rec.uom_code,
139: l_oks_action_times_v_rec.sun_duration,
140: l_oks_action_times_v_rec.mon_duration,
141: l_oks_action_times_v_rec.tue_duration,
134: l_oks_action_times_v_rec.id,
135: l_oks_action_times_v_rec.cov_action_type_id,
136: l_oks_action_times_v_rec.cle_id,
137: l_oks_action_times_v_rec.dnz_chr_id,
138: l_oks_action_times_v_rec.uom_code,
139: l_oks_action_times_v_rec.sun_duration,
140: l_oks_action_times_v_rec.mon_duration,
141: l_oks_action_times_v_rec.tue_duration,
142: l_oks_action_times_v_rec.wed_duration,
135: l_oks_action_times_v_rec.cov_action_type_id,
136: l_oks_action_times_v_rec.cle_id,
137: l_oks_action_times_v_rec.dnz_chr_id,
138: l_oks_action_times_v_rec.uom_code,
139: l_oks_action_times_v_rec.sun_duration,
140: l_oks_action_times_v_rec.mon_duration,
141: l_oks_action_times_v_rec.tue_duration,
142: l_oks_action_times_v_rec.wed_duration,
143: l_oks_action_times_v_rec.thu_duration,
136: l_oks_action_times_v_rec.cle_id,
137: l_oks_action_times_v_rec.dnz_chr_id,
138: l_oks_action_times_v_rec.uom_code,
139: l_oks_action_times_v_rec.sun_duration,
140: l_oks_action_times_v_rec.mon_duration,
141: l_oks_action_times_v_rec.tue_duration,
142: l_oks_action_times_v_rec.wed_duration,
143: l_oks_action_times_v_rec.thu_duration,
144: l_oks_action_times_v_rec.fri_duration,
137: l_oks_action_times_v_rec.dnz_chr_id,
138: l_oks_action_times_v_rec.uom_code,
139: l_oks_action_times_v_rec.sun_duration,
140: l_oks_action_times_v_rec.mon_duration,
141: l_oks_action_times_v_rec.tue_duration,
142: l_oks_action_times_v_rec.wed_duration,
143: l_oks_action_times_v_rec.thu_duration,
144: l_oks_action_times_v_rec.fri_duration,
145: l_oks_action_times_v_rec.sat_duration,
138: l_oks_action_times_v_rec.uom_code,
139: l_oks_action_times_v_rec.sun_duration,
140: l_oks_action_times_v_rec.mon_duration,
141: l_oks_action_times_v_rec.tue_duration,
142: l_oks_action_times_v_rec.wed_duration,
143: l_oks_action_times_v_rec.thu_duration,
144: l_oks_action_times_v_rec.fri_duration,
145: l_oks_action_times_v_rec.sat_duration,
146: l_oks_action_times_v_rec.security_group_id,
139: l_oks_action_times_v_rec.sun_duration,
140: l_oks_action_times_v_rec.mon_duration,
141: l_oks_action_times_v_rec.tue_duration,
142: l_oks_action_times_v_rec.wed_duration,
143: l_oks_action_times_v_rec.thu_duration,
144: l_oks_action_times_v_rec.fri_duration,
145: l_oks_action_times_v_rec.sat_duration,
146: l_oks_action_times_v_rec.security_group_id,
147: l_oks_action_times_v_rec.program_application_id,
140: l_oks_action_times_v_rec.mon_duration,
141: l_oks_action_times_v_rec.tue_duration,
142: l_oks_action_times_v_rec.wed_duration,
143: l_oks_action_times_v_rec.thu_duration,
144: l_oks_action_times_v_rec.fri_duration,
145: l_oks_action_times_v_rec.sat_duration,
146: l_oks_action_times_v_rec.security_group_id,
147: l_oks_action_times_v_rec.program_application_id,
148: l_oks_action_times_v_rec.program_id,
141: l_oks_action_times_v_rec.tue_duration,
142: l_oks_action_times_v_rec.wed_duration,
143: l_oks_action_times_v_rec.thu_duration,
144: l_oks_action_times_v_rec.fri_duration,
145: l_oks_action_times_v_rec.sat_duration,
146: l_oks_action_times_v_rec.security_group_id,
147: l_oks_action_times_v_rec.program_application_id,
148: l_oks_action_times_v_rec.program_id,
149: l_oks_action_times_v_rec.program_update_date,
142: l_oks_action_times_v_rec.wed_duration,
143: l_oks_action_times_v_rec.thu_duration,
144: l_oks_action_times_v_rec.fri_duration,
145: l_oks_action_times_v_rec.sat_duration,
146: l_oks_action_times_v_rec.security_group_id,
147: l_oks_action_times_v_rec.program_application_id,
148: l_oks_action_times_v_rec.program_id,
149: l_oks_action_times_v_rec.program_update_date,
150: l_oks_action_times_v_rec.request_id,
143: l_oks_action_times_v_rec.thu_duration,
144: l_oks_action_times_v_rec.fri_duration,
145: l_oks_action_times_v_rec.sat_duration,
146: l_oks_action_times_v_rec.security_group_id,
147: l_oks_action_times_v_rec.program_application_id,
148: l_oks_action_times_v_rec.program_id,
149: l_oks_action_times_v_rec.program_update_date,
150: l_oks_action_times_v_rec.request_id,
151: l_oks_action_times_v_rec.created_by,
144: l_oks_action_times_v_rec.fri_duration,
145: l_oks_action_times_v_rec.sat_duration,
146: l_oks_action_times_v_rec.security_group_id,
147: l_oks_action_times_v_rec.program_application_id,
148: l_oks_action_times_v_rec.program_id,
149: l_oks_action_times_v_rec.program_update_date,
150: l_oks_action_times_v_rec.request_id,
151: l_oks_action_times_v_rec.created_by,
152: l_oks_action_times_v_rec.creation_date,
145: l_oks_action_times_v_rec.sat_duration,
146: l_oks_action_times_v_rec.security_group_id,
147: l_oks_action_times_v_rec.program_application_id,
148: l_oks_action_times_v_rec.program_id,
149: l_oks_action_times_v_rec.program_update_date,
150: l_oks_action_times_v_rec.request_id,
151: l_oks_action_times_v_rec.created_by,
152: l_oks_action_times_v_rec.creation_date,
153: l_oks_action_times_v_rec.last_updated_by,
146: l_oks_action_times_v_rec.security_group_id,
147: l_oks_action_times_v_rec.program_application_id,
148: l_oks_action_times_v_rec.program_id,
149: l_oks_action_times_v_rec.program_update_date,
150: l_oks_action_times_v_rec.request_id,
151: l_oks_action_times_v_rec.created_by,
152: l_oks_action_times_v_rec.creation_date,
153: l_oks_action_times_v_rec.last_updated_by,
154: l_oks_action_times_v_rec.last_update_date,
147: l_oks_action_times_v_rec.program_application_id,
148: l_oks_action_times_v_rec.program_id,
149: l_oks_action_times_v_rec.program_update_date,
150: l_oks_action_times_v_rec.request_id,
151: l_oks_action_times_v_rec.created_by,
152: l_oks_action_times_v_rec.creation_date,
153: l_oks_action_times_v_rec.last_updated_by,
154: l_oks_action_times_v_rec.last_update_date,
155: l_oks_action_times_v_rec.last_update_login,
148: l_oks_action_times_v_rec.program_id,
149: l_oks_action_times_v_rec.program_update_date,
150: l_oks_action_times_v_rec.request_id,
151: l_oks_action_times_v_rec.created_by,
152: l_oks_action_times_v_rec.creation_date,
153: l_oks_action_times_v_rec.last_updated_by,
154: l_oks_action_times_v_rec.last_update_date,
155: l_oks_action_times_v_rec.last_update_login,
156: l_oks_action_times_v_rec.object_version_number;
149: l_oks_action_times_v_rec.program_update_date,
150: l_oks_action_times_v_rec.request_id,
151: l_oks_action_times_v_rec.created_by,
152: l_oks_action_times_v_rec.creation_date,
153: l_oks_action_times_v_rec.last_updated_by,
154: l_oks_action_times_v_rec.last_update_date,
155: l_oks_action_times_v_rec.last_update_login,
156: l_oks_action_times_v_rec.object_version_number;
157: x_no_data_found := oks_atv_pk_csr%NOTFOUND;
150: l_oks_action_times_v_rec.request_id,
151: l_oks_action_times_v_rec.created_by,
152: l_oks_action_times_v_rec.creation_date,
153: l_oks_action_times_v_rec.last_updated_by,
154: l_oks_action_times_v_rec.last_update_date,
155: l_oks_action_times_v_rec.last_update_login,
156: l_oks_action_times_v_rec.object_version_number;
157: x_no_data_found := oks_atv_pk_csr%NOTFOUND;
158: CLOSE oks_atv_pk_csr;
151: l_oks_action_times_v_rec.created_by,
152: l_oks_action_times_v_rec.creation_date,
153: l_oks_action_times_v_rec.last_updated_by,
154: l_oks_action_times_v_rec.last_update_date,
155: l_oks_action_times_v_rec.last_update_login,
156: l_oks_action_times_v_rec.object_version_number;
157: x_no_data_found := oks_atv_pk_csr%NOTFOUND;
158: CLOSE oks_atv_pk_csr;
159: RETURN(l_oks_action_times_v_rec);
152: l_oks_action_times_v_rec.creation_date,
153: l_oks_action_times_v_rec.last_updated_by,
154: l_oks_action_times_v_rec.last_update_date,
155: l_oks_action_times_v_rec.last_update_login,
156: l_oks_action_times_v_rec.object_version_number;
157: x_no_data_found := oks_atv_pk_csr%NOTFOUND;
158: CLOSE oks_atv_pk_csr;
159: RETURN(l_oks_action_times_v_rec);
160: END get_rec;
155: l_oks_action_times_v_rec.last_update_login,
156: l_oks_action_times_v_rec.object_version_number;
157: x_no_data_found := oks_atv_pk_csr%NOTFOUND;
158: CLOSE oks_atv_pk_csr;
159: RETURN(l_oks_action_times_v_rec);
160: END get_rec;
161:
162: ------------------------------------------------------------------
163: -- This version of get_rec sets error messages if no data found --
162: ------------------------------------------------------------------
163: -- This version of get_rec sets error messages if no data found --
164: ------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
167: x_return_status OUT NOCOPY VARCHAR2
168: ) RETURN oks_action_times_v_rec_type IS
169: l_oks_action_times_v_rec oks_action_times_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
164: ------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
167: x_return_status OUT NOCOPY VARCHAR2
168: ) RETURN oks_action_times_v_rec_type IS
169: l_oks_action_times_v_rec oks_action_times_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
171: BEGIN
172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
165: FUNCTION get_rec (
166: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
167: x_return_status OUT NOCOPY VARCHAR2
168: ) RETURN oks_action_times_v_rec_type IS
169: l_oks_action_times_v_rec oks_action_times_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
171: BEGIN
172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
173: l_oks_action_times_v_rec := get_rec(p_oks_action_times_v_rec, l_row_notfound);
169: l_oks_action_times_v_rec oks_action_times_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
171: BEGIN
172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
173: l_oks_action_times_v_rec := get_rec(p_oks_action_times_v_rec, l_row_notfound);
174: IF (l_row_notfound) THEN
175: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
176: x_return_status := OKC_API.G_RET_STS_ERROR;
177: END IF;
174: IF (l_row_notfound) THEN
175: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
176: x_return_status := OKC_API.G_RET_STS_ERROR;
177: END IF;
178: RETURN(l_oks_action_times_v_rec);
179: END get_rec;
180: -----------------------------------------------------------
181: -- So we don't have to pass an "l_row_notfound" variable --
182: -----------------------------------------------------------
180: -----------------------------------------------------------
181: -- So we don't have to pass an "l_row_notfound" variable --
182: -----------------------------------------------------------
183: FUNCTION get_rec (
184: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
185: ) RETURN oks_action_times_v_rec_type IS
186: l_row_not_found BOOLEAN := TRUE;
187: BEGIN
188: RETURN(get_rec(p_oks_action_times_v_rec, l_row_not_found));
181: -- So we don't have to pass an "l_row_notfound" variable --
182: -----------------------------------------------------------
183: FUNCTION get_rec (
184: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
185: ) RETURN oks_action_times_v_rec_type IS
186: l_row_not_found BOOLEAN := TRUE;
187: BEGIN
188: RETURN(get_rec(p_oks_action_times_v_rec, l_row_not_found));
189: END get_rec;
184: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
185: ) RETURN oks_action_times_v_rec_type IS
186: l_row_not_found BOOLEAN := TRUE;
187: BEGIN
188: RETURN(get_rec(p_oks_action_times_v_rec, l_row_not_found));
189: END get_rec;
190: ---------------------------------------------------------------------------
191: -- FUNCTION get_rec for: OKS_ACTION_TIMES
192: ---------------------------------------------------------------------------
282: BEGIN
283: RETURN(get_rec(p_oks_action_times_rec, l_row_not_found));
284: END get_rec;
285: ---------------------------------------------------------------------------
286: -- FUNCTION null_out_defaults for: OKS_ACTION_TIMES_V
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
290: ) RETURN oks_action_times_v_rec_type IS
285: ---------------------------------------------------------------------------
286: -- FUNCTION null_out_defaults for: OKS_ACTION_TIMES_V
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
290: ) RETURN oks_action_times_v_rec_type IS
291: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
292: BEGIN
293: IF (l_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
286: -- FUNCTION null_out_defaults for: OKS_ACTION_TIMES_V
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
290: ) RETURN oks_action_times_v_rec_type IS
291: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
292: BEGIN
293: IF (l_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_action_times_v_rec.id := NULL;
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
290: ) RETURN oks_action_times_v_rec_type IS
291: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
292: BEGIN
293: IF (l_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_action_times_v_rec.id := NULL;
295: END IF;
289: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
290: ) RETURN oks_action_times_v_rec_type IS
291: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
292: BEGIN
293: IF (l_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_action_times_v_rec.id := NULL;
295: END IF;
296: IF (l_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_times_v_rec.cov_action_type_id := NULL;
290: ) RETURN oks_action_times_v_rec_type IS
291: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
292: BEGIN
293: IF (l_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_action_times_v_rec.id := NULL;
295: END IF;
296: IF (l_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_times_v_rec.cov_action_type_id := NULL;
298: END IF;
292: BEGIN
293: IF (l_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_action_times_v_rec.id := NULL;
295: END IF;
296: IF (l_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_times_v_rec.cov_action_type_id := NULL;
298: END IF;
299: IF (l_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_times_v_rec.cle_id := NULL;
293: IF (l_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_action_times_v_rec.id := NULL;
295: END IF;
296: IF (l_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_times_v_rec.cov_action_type_id := NULL;
298: END IF;
299: IF (l_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_times_v_rec.cle_id := NULL;
301: END IF;
295: END IF;
296: IF (l_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_times_v_rec.cov_action_type_id := NULL;
298: END IF;
299: IF (l_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_times_v_rec.cle_id := NULL;
301: END IF;
302: IF (l_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_times_v_rec.dnz_chr_id := NULL;
296: IF (l_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_times_v_rec.cov_action_type_id := NULL;
298: END IF;
299: IF (l_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_times_v_rec.cle_id := NULL;
301: END IF;
302: IF (l_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_times_v_rec.dnz_chr_id := NULL;
304: END IF;
298: END IF;
299: IF (l_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_times_v_rec.cle_id := NULL;
301: END IF;
302: IF (l_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_times_v_rec.dnz_chr_id := NULL;
304: END IF;
305: IF (l_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR ) THEN
306: l_oks_action_times_v_rec.uom_code := NULL;
299: IF (l_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_times_v_rec.cle_id := NULL;
301: END IF;
302: IF (l_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_times_v_rec.dnz_chr_id := NULL;
304: END IF;
305: IF (l_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR ) THEN
306: l_oks_action_times_v_rec.uom_code := NULL;
307: END IF;
301: END IF;
302: IF (l_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_times_v_rec.dnz_chr_id := NULL;
304: END IF;
305: IF (l_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR ) THEN
306: l_oks_action_times_v_rec.uom_code := NULL;
307: END IF;
308: IF (l_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_times_v_rec.sun_duration := NULL;
302: IF (l_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_times_v_rec.dnz_chr_id := NULL;
304: END IF;
305: IF (l_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR ) THEN
306: l_oks_action_times_v_rec.uom_code := NULL;
307: END IF;
308: IF (l_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_times_v_rec.sun_duration := NULL;
310: END IF;
304: END IF;
305: IF (l_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR ) THEN
306: l_oks_action_times_v_rec.uom_code := NULL;
307: END IF;
308: IF (l_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_times_v_rec.sun_duration := NULL;
310: END IF;
311: IF (l_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_times_v_rec.mon_duration := NULL;
305: IF (l_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR ) THEN
306: l_oks_action_times_v_rec.uom_code := NULL;
307: END IF;
308: IF (l_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_times_v_rec.sun_duration := NULL;
310: END IF;
311: IF (l_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_times_v_rec.mon_duration := NULL;
313: END IF;
307: END IF;
308: IF (l_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_times_v_rec.sun_duration := NULL;
310: END IF;
311: IF (l_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_times_v_rec.mon_duration := NULL;
313: END IF;
314: IF (l_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM ) THEN
315: l_oks_action_times_v_rec.tue_duration := NULL;
308: IF (l_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_times_v_rec.sun_duration := NULL;
310: END IF;
311: IF (l_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_times_v_rec.mon_duration := NULL;
313: END IF;
314: IF (l_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM ) THEN
315: l_oks_action_times_v_rec.tue_duration := NULL;
316: END IF;
310: END IF;
311: IF (l_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_times_v_rec.mon_duration := NULL;
313: END IF;
314: IF (l_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM ) THEN
315: l_oks_action_times_v_rec.tue_duration := NULL;
316: END IF;
317: IF (l_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_times_v_rec.wed_duration := NULL;
311: IF (l_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_times_v_rec.mon_duration := NULL;
313: END IF;
314: IF (l_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM ) THEN
315: l_oks_action_times_v_rec.tue_duration := NULL;
316: END IF;
317: IF (l_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_times_v_rec.wed_duration := NULL;
319: END IF;
313: END IF;
314: IF (l_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM ) THEN
315: l_oks_action_times_v_rec.tue_duration := NULL;
316: END IF;
317: IF (l_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_times_v_rec.wed_duration := NULL;
319: END IF;
320: IF (l_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM ) THEN
321: l_oks_action_times_v_rec.thu_duration := NULL;
314: IF (l_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM ) THEN
315: l_oks_action_times_v_rec.tue_duration := NULL;
316: END IF;
317: IF (l_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_times_v_rec.wed_duration := NULL;
319: END IF;
320: IF (l_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM ) THEN
321: l_oks_action_times_v_rec.thu_duration := NULL;
322: END IF;
316: END IF;
317: IF (l_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_times_v_rec.wed_duration := NULL;
319: END IF;
320: IF (l_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM ) THEN
321: l_oks_action_times_v_rec.thu_duration := NULL;
322: END IF;
323: IF (l_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_times_v_rec.fri_duration := NULL;
317: IF (l_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_times_v_rec.wed_duration := NULL;
319: END IF;
320: IF (l_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM ) THEN
321: l_oks_action_times_v_rec.thu_duration := NULL;
322: END IF;
323: IF (l_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_times_v_rec.fri_duration := NULL;
325: END IF;
319: END IF;
320: IF (l_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM ) THEN
321: l_oks_action_times_v_rec.thu_duration := NULL;
322: END IF;
323: IF (l_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_times_v_rec.fri_duration := NULL;
325: END IF;
326: IF (l_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_times_v_rec.sat_duration := NULL;
320: IF (l_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM ) THEN
321: l_oks_action_times_v_rec.thu_duration := NULL;
322: END IF;
323: IF (l_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_times_v_rec.fri_duration := NULL;
325: END IF;
326: IF (l_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_times_v_rec.sat_duration := NULL;
328: END IF;
322: END IF;
323: IF (l_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_times_v_rec.fri_duration := NULL;
325: END IF;
326: IF (l_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_times_v_rec.sat_duration := NULL;
328: END IF;
329: IF (l_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
330: l_oks_action_times_v_rec.security_group_id := NULL;
323: IF (l_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_times_v_rec.fri_duration := NULL;
325: END IF;
326: IF (l_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_times_v_rec.sat_duration := NULL;
328: END IF;
329: IF (l_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
330: l_oks_action_times_v_rec.security_group_id := NULL;
331: END IF;
325: END IF;
326: IF (l_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_times_v_rec.sat_duration := NULL;
328: END IF;
329: IF (l_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
330: l_oks_action_times_v_rec.security_group_id := NULL;
331: END IF;
332: IF (l_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_oks_action_times_v_rec.program_application_id := NULL;
326: IF (l_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_times_v_rec.sat_duration := NULL;
328: END IF;
329: IF (l_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
330: l_oks_action_times_v_rec.security_group_id := NULL;
331: END IF;
332: IF (l_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_oks_action_times_v_rec.program_application_id := NULL;
334: END IF;
328: END IF;
329: IF (l_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
330: l_oks_action_times_v_rec.security_group_id := NULL;
331: END IF;
332: IF (l_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_oks_action_times_v_rec.program_application_id := NULL;
334: END IF;
335: IF (l_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_oks_action_times_v_rec.program_id := NULL;
329: IF (l_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
330: l_oks_action_times_v_rec.security_group_id := NULL;
331: END IF;
332: IF (l_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_oks_action_times_v_rec.program_application_id := NULL;
334: END IF;
335: IF (l_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_oks_action_times_v_rec.program_id := NULL;
337: END IF;
331: END IF;
332: IF (l_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_oks_action_times_v_rec.program_application_id := NULL;
334: END IF;
335: IF (l_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_oks_action_times_v_rec.program_id := NULL;
337: END IF;
338: IF (l_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_oks_action_times_v_rec.program_update_date := NULL;
332: IF (l_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_oks_action_times_v_rec.program_application_id := NULL;
334: END IF;
335: IF (l_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_oks_action_times_v_rec.program_id := NULL;
337: END IF;
338: IF (l_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_oks_action_times_v_rec.program_update_date := NULL;
340: END IF;
334: END IF;
335: IF (l_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_oks_action_times_v_rec.program_id := NULL;
337: END IF;
338: IF (l_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_oks_action_times_v_rec.program_update_date := NULL;
340: END IF;
341: IF (l_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_action_times_v_rec.request_id := NULL;
335: IF (l_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_oks_action_times_v_rec.program_id := NULL;
337: END IF;
338: IF (l_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_oks_action_times_v_rec.program_update_date := NULL;
340: END IF;
341: IF (l_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_action_times_v_rec.request_id := NULL;
343: END IF;
337: END IF;
338: IF (l_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_oks_action_times_v_rec.program_update_date := NULL;
340: END IF;
341: IF (l_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_action_times_v_rec.request_id := NULL;
343: END IF;
344: IF (l_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
345: l_oks_action_times_v_rec.created_by := NULL;
338: IF (l_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_oks_action_times_v_rec.program_update_date := NULL;
340: END IF;
341: IF (l_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_action_times_v_rec.request_id := NULL;
343: END IF;
344: IF (l_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
345: l_oks_action_times_v_rec.created_by := NULL;
346: END IF;
340: END IF;
341: IF (l_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_action_times_v_rec.request_id := NULL;
343: END IF;
344: IF (l_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
345: l_oks_action_times_v_rec.created_by := NULL;
346: END IF;
347: IF (l_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
348: l_oks_action_times_v_rec.creation_date := NULL;
341: IF (l_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_action_times_v_rec.request_id := NULL;
343: END IF;
344: IF (l_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
345: l_oks_action_times_v_rec.created_by := NULL;
346: END IF;
347: IF (l_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
348: l_oks_action_times_v_rec.creation_date := NULL;
349: END IF;
343: END IF;
344: IF (l_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
345: l_oks_action_times_v_rec.created_by := NULL;
346: END IF;
347: IF (l_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
348: l_oks_action_times_v_rec.creation_date := NULL;
349: END IF;
350: IF (l_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
351: l_oks_action_times_v_rec.last_updated_by := NULL;
344: IF (l_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
345: l_oks_action_times_v_rec.created_by := NULL;
346: END IF;
347: IF (l_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
348: l_oks_action_times_v_rec.creation_date := NULL;
349: END IF;
350: IF (l_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
351: l_oks_action_times_v_rec.last_updated_by := NULL;
352: END IF;
346: END IF;
347: IF (l_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
348: l_oks_action_times_v_rec.creation_date := NULL;
349: END IF;
350: IF (l_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
351: l_oks_action_times_v_rec.last_updated_by := NULL;
352: END IF;
353: IF (l_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
354: l_oks_action_times_v_rec.last_update_date := NULL;
347: IF (l_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
348: l_oks_action_times_v_rec.creation_date := NULL;
349: END IF;
350: IF (l_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
351: l_oks_action_times_v_rec.last_updated_by := NULL;
352: END IF;
353: IF (l_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
354: l_oks_action_times_v_rec.last_update_date := NULL;
355: END IF;
349: END IF;
350: IF (l_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
351: l_oks_action_times_v_rec.last_updated_by := NULL;
352: END IF;
353: IF (l_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
354: l_oks_action_times_v_rec.last_update_date := NULL;
355: END IF;
356: IF (l_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_oks_action_times_v_rec.last_update_login := NULL;
350: IF (l_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
351: l_oks_action_times_v_rec.last_updated_by := NULL;
352: END IF;
353: IF (l_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
354: l_oks_action_times_v_rec.last_update_date := NULL;
355: END IF;
356: IF (l_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_oks_action_times_v_rec.last_update_login := NULL;
358: END IF;
352: END IF;
353: IF (l_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
354: l_oks_action_times_v_rec.last_update_date := NULL;
355: END IF;
356: IF (l_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_oks_action_times_v_rec.last_update_login := NULL;
358: END IF;
359: IF (l_oks_action_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
360: l_oks_action_times_v_rec.object_version_number := NULL;
353: IF (l_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
354: l_oks_action_times_v_rec.last_update_date := NULL;
355: END IF;
356: IF (l_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_oks_action_times_v_rec.last_update_login := NULL;
358: END IF;
359: IF (l_oks_action_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
360: l_oks_action_times_v_rec.object_version_number := NULL;
361: END IF;
355: END IF;
356: IF (l_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_oks_action_times_v_rec.last_update_login := NULL;
358: END IF;
359: IF (l_oks_action_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
360: l_oks_action_times_v_rec.object_version_number := NULL;
361: END IF;
362: RETURN(l_oks_action_times_v_rec);
363: END null_out_defaults;
356: IF (l_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_oks_action_times_v_rec.last_update_login := NULL;
358: END IF;
359: IF (l_oks_action_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
360: l_oks_action_times_v_rec.object_version_number := NULL;
361: END IF;
362: RETURN(l_oks_action_times_v_rec);
363: END null_out_defaults;
364: ---------------------------------
358: END IF;
359: IF (l_oks_action_times_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
360: l_oks_action_times_v_rec.object_version_number := NULL;
361: END IF;
362: RETURN(l_oks_action_times_v_rec);
363: END null_out_defaults;
364: ---------------------------------
365: -- Validate_Attributes for: ID --
366: ---------------------------------
418: ---------------------------------------------------------------------------
419: -- FUNCTION Validate_Attributes
420: ---------------------------------------------------------------------------
421: ------------------------------------------------
422: -- Validate_Attributes for:OKS_ACTION_TIMES_V --
423: ------------------------------------------------
424: FUNCTION Validate_Attributes (
425: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
426: ) RETURN VARCHAR2 IS
421: ------------------------------------------------
422: -- Validate_Attributes for:OKS_ACTION_TIMES_V --
423: ------------------------------------------------
424: FUNCTION Validate_Attributes (
425: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
426: ) RETURN VARCHAR2 IS
427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
428: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
429: BEGIN
432: -----------------------------
433: -- ***
434: -- id
435: -- ***
436: validate_id(x_return_status, p_oks_action_times_v_rec.id);
437: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
438: l_return_status := x_return_status;
439: RAISE G_EXCEPTION_HALT_VALIDATION;
440: END IF;
441:
442: -- ***
443: -- object_version_number
444: -- ***
445: validate_object_version_number(x_return_status, p_oks_action_times_v_rec.object_version_number);
446: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
447: l_return_status := x_return_status;
448: RAISE G_EXCEPTION_HALT_VALIDATION;
449: END IF;
465: ---------------------------------------------------------------------------
466: -- PROCEDURE Validate_Record
467: ---------------------------------------------------------------------------
468: --------------------------------------------
469: -- Validate Record for:OKS_ACTION_TIMES_V --
470: --------------------------------------------
471: FUNCTION Validate_Record (
472: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
473: p_db_oks_action_times_v_rec IN oks_action_times_v_rec_type
468: --------------------------------------------
469: -- Validate Record for:OKS_ACTION_TIMES_V --
470: --------------------------------------------
471: FUNCTION Validate_Record (
472: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
473: p_db_oks_action_times_v_rec IN oks_action_times_v_rec_type
474: ) RETURN VARCHAR2 IS
475: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
476: BEGIN
469: -- Validate Record for:OKS_ACTION_TIMES_V --
470: --------------------------------------------
471: FUNCTION Validate_Record (
472: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
473: p_db_oks_action_times_v_rec IN oks_action_times_v_rec_type
474: ) RETURN VARCHAR2 IS
475: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
476: BEGIN
477: RETURN (l_return_status);
476: BEGIN
477: RETURN (l_return_status);
478: END Validate_Record;
479: FUNCTION Validate_Record (
480: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
481: ) RETURN VARCHAR2 IS
482: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
483: l_db_oks_action_times_v_rec oks_action_times_v_rec_type := get_rec(p_oks_action_times_v_rec);
484: BEGIN
479: FUNCTION Validate_Record (
480: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
481: ) RETURN VARCHAR2 IS
482: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
483: l_db_oks_action_times_v_rec oks_action_times_v_rec_type := get_rec(p_oks_action_times_v_rec);
484: BEGIN
485: l_return_status := Validate_Record(p_oks_action_times_v_rec => p_oks_action_times_v_rec,
486: p_db_oks_action_times_v_rec => l_db_oks_action_times_v_rec);
487: RETURN (l_return_status);
481: ) RETURN VARCHAR2 IS
482: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
483: l_db_oks_action_times_v_rec oks_action_times_v_rec_type := get_rec(p_oks_action_times_v_rec);
484: BEGIN
485: l_return_status := Validate_Record(p_oks_action_times_v_rec => p_oks_action_times_v_rec,
486: p_db_oks_action_times_v_rec => l_db_oks_action_times_v_rec);
487: RETURN (l_return_status);
488: END Validate_Record;
489:
482: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
483: l_db_oks_action_times_v_rec oks_action_times_v_rec_type := get_rec(p_oks_action_times_v_rec);
484: BEGIN
485: l_return_status := Validate_Record(p_oks_action_times_v_rec => p_oks_action_times_v_rec,
486: p_db_oks_action_times_v_rec => l_db_oks_action_times_v_rec);
487: RETURN (l_return_status);
488: END Validate_Record;
489:
490: ---------------------------------------------------------------------------
490: ---------------------------------------------------------------------------
491: -- PROCEDURE Migrate
492: ---------------------------------------------------------------------------
493: PROCEDURE migrate (
494: p_from IN oks_action_times_v_rec_type,
495: p_to IN OUT NOCOPY oks_action_times_rec_type
496: ) IS
497: BEGIN
498: p_to.id := p_from.id;
519: p_to.object_version_number := p_from.object_version_number;
520: END migrate;
521: PROCEDURE migrate (
522: p_from IN oks_action_times_rec_type,
523: p_to IN OUT NOCOPY oks_action_times_v_rec_type
524: ) IS
525: BEGIN
526: p_to.id := p_from.id;
527: p_to.cov_action_type_id := p_from.cov_action_type_id;
549: ---------------------------------------------------------------------------
550: -- PROCEDURE validate_row
551: ---------------------------------------------------------------------------
552: -----------------------------------------
553: -- validate_row for:OKS_ACTION_TIMES_V --
554: -----------------------------------------
555: PROCEDURE validate_row(
556: p_api_version IN NUMBER,
557: p_init_msg_list IN VARCHAR2,
557: p_init_msg_list IN VARCHAR2,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,
561: p_oks_action_times_v_rec IN oks_action_times_v_rec_type) IS
562:
563: l_api_version CONSTANT NUMBER := 1;
564: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
565: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
562:
563: l_api_version CONSTANT NUMBER := 1;
564: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
565: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
566: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
567: l_oks_action_times_rec oks_action_times_rec_type;
568: l_oks_action_times_rec oks_action_times_rec_type;
569: BEGIN
570: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
579: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
580: RAISE OKC_API.G_EXCEPTION_ERROR;
581: END IF;
582: --- Validate all non-missing attributes (Item Level Validation)
583: l_return_status := Validate_Attributes(l_oks_action_times_v_rec);
584: --- If any errors happen abort API
585: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
586: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
587: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
586: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
587: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
588: RAISE OKC_API.G_EXCEPTION_ERROR;
589: END IF;
590: l_return_status := Validate_Record(l_oks_action_times_v_rec);
591: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
592: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
593: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
594: RAISE OKC_API.G_EXCEPTION_ERROR;
626: '_PVT'
627: );
628: END validate_row;
629: ----------------------------------------------------
630: -- PL/SQL TBL validate_row for:OKS_ACTION_TIMES_V --
631: ----------------------------------------------------
632: PROCEDURE validate_row(
633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2,
634: p_init_msg_list IN VARCHAR2,
635: x_return_status OUT NOCOPY VARCHAR2,
636: x_msg_count OUT NOCOPY NUMBER,
637: x_msg_data OUT NOCOPY VARCHAR2,
638: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
639: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
640:
641: l_api_version CONSTANT NUMBER := 1;
642: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
643: i NUMBER := 0;
644: BEGIN
645: OKC_API.init_msg_list(p_init_msg_list);
646: -- Make sure PL/SQL table has records in it before passing
647: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
648: i := p_oks_action_times_v_tbl.FIRST;
649: LOOP
650: DECLARE
651: l_error_rec OKC_API.ERROR_REC_TYPE;
644: BEGIN
645: OKC_API.init_msg_list(p_init_msg_list);
646: -- Make sure PL/SQL table has records in it before passing
647: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
648: i := p_oks_action_times_v_tbl.FIRST;
649: LOOP
650: DECLARE
651: l_error_rec OKC_API.ERROR_REC_TYPE;
652: BEGIN
658: p_init_msg_list => OKC_API.G_FALSE,
659: x_return_status => l_error_rec.error_type,
660: x_msg_count => l_error_rec.msg_count,
661: x_msg_data => l_error_rec.msg_data,
662: p_oks_action_times_v_rec => p_oks_action_times_v_tbl(i));
663: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
664: l_error_rec.sqlcode := SQLCODE;
665: load_error_tbl(l_error_rec, px_error_tbl);
666: ELSE
680: l_error_rec.error_type := 'OTHERS';
681: l_error_rec.sqlcode := SQLCODE;
682: load_error_tbl(l_error_rec, px_error_tbl);
683: END;
684: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
685: i := p_oks_action_times_v_tbl.NEXT(i);
686: END LOOP;
687: END IF;
688: -- Loop through the error_tbl to find the error with the highest severity
681: l_error_rec.sqlcode := SQLCODE;
682: load_error_tbl(l_error_rec, px_error_tbl);
683: END;
684: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
685: i := p_oks_action_times_v_tbl.NEXT(i);
686: END LOOP;
687: END IF;
688: -- Loop through the error_tbl to find the error with the highest severity
689: -- and return it.
722: );
723: END validate_row;
724:
725: ----------------------------------------------------
726: -- PL/SQL TBL validate_row for:OKS_ACTION_TIMES_V --
727: ----------------------------------------------------
728: PROCEDURE validate_row(
729: p_api_version IN NUMBER,
730: p_init_msg_list IN VARCHAR2,
730: p_init_msg_list IN VARCHAR2,
731: x_return_status OUT NOCOPY VARCHAR2,
732: x_msg_count OUT NOCOPY NUMBER,
733: x_msg_data OUT NOCOPY VARCHAR2,
734: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type) IS
735:
736: l_api_version CONSTANT NUMBER := 1;
737: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
738: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
739: l_error_tbl OKC_API.ERROR_TBL_TYPE;
740: BEGIN
741: OKC_API.init_msg_list(p_init_msg_list);
742: -- Make sure PL/SQL table has records in it before passing
743: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
744: validate_row (
745: p_api_version => p_api_version,
746: p_init_msg_list => OKC_API.G_FALSE,
747: x_return_status => x_return_status,
746: p_init_msg_list => OKC_API.G_FALSE,
747: x_return_status => x_return_status,
748: x_msg_count => x_msg_count,
749: x_msg_data => x_msg_data,
750: p_oks_action_times_v_tbl => p_oks_action_times_v_tbl,
751: px_error_tbl => l_error_tbl);
752: END IF;
753: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
754: EXCEPTION
917: '_PVT'
918: );
919: END insert_row;
920: ----------------------------------------
921: -- insert_row for :OKS_ACTION_TIMES_V --
922: ----------------------------------------
923: PROCEDURE insert_row(
924: p_api_version IN NUMBER,
925: p_init_msg_list IN VARCHAR2,
925: p_init_msg_list IN VARCHAR2,
926: x_return_status OUT NOCOPY VARCHAR2,
927: x_msg_count OUT NOCOPY NUMBER,
928: x_msg_data OUT NOCOPY VARCHAR2,
929: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
930: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type) IS
931:
932: l_api_version CONSTANT NUMBER := 1;
933: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
926: x_return_status OUT NOCOPY VARCHAR2,
927: x_msg_count OUT NOCOPY NUMBER,
928: x_msg_data OUT NOCOPY VARCHAR2,
929: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
930: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type) IS
931:
932: l_api_version CONSTANT NUMBER := 1;
933: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
934: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
931:
932: l_api_version CONSTANT NUMBER := 1;
933: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
934: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
935: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
936: l_def_oks_action_times_v_rec oks_action_times_v_rec_type;
937: l_oks_action_times_rec oks_action_times_rec_type;
938: lx_oks_action_times_rec oks_action_times_rec_type;
939: -------------------------------
932: l_api_version CONSTANT NUMBER := 1;
933: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
934: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
935: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
936: l_def_oks_action_times_v_rec oks_action_times_v_rec_type;
937: l_oks_action_times_rec oks_action_times_rec_type;
938: lx_oks_action_times_rec oks_action_times_rec_type;
939: -------------------------------
940: -- FUNCTION fill_who_columns --
939: -------------------------------
940: -- FUNCTION fill_who_columns --
941: -------------------------------
942: FUNCTION fill_who_columns (
943: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
944: ) RETURN oks_action_times_v_rec_type IS
945: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
946: BEGIN
947: l_oks_action_times_v_rec.CREATION_DATE := SYSDATE;
940: -- FUNCTION fill_who_columns --
941: -------------------------------
942: FUNCTION fill_who_columns (
943: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
944: ) RETURN oks_action_times_v_rec_type IS
945: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
946: BEGIN
947: l_oks_action_times_v_rec.CREATION_DATE := SYSDATE;
948: l_oks_action_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
941: -------------------------------
942: FUNCTION fill_who_columns (
943: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
944: ) RETURN oks_action_times_v_rec_type IS
945: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
946: BEGIN
947: l_oks_action_times_v_rec.CREATION_DATE := SYSDATE;
948: l_oks_action_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
949: l_oks_action_times_v_rec.LAST_UPDATE_DATE := l_oks_action_times_v_rec.CREATION_DATE;
943: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
944: ) RETURN oks_action_times_v_rec_type IS
945: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
946: BEGIN
947: l_oks_action_times_v_rec.CREATION_DATE := SYSDATE;
948: l_oks_action_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
949: l_oks_action_times_v_rec.LAST_UPDATE_DATE := l_oks_action_times_v_rec.CREATION_DATE;
950: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
951: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
944: ) RETURN oks_action_times_v_rec_type IS
945: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
946: BEGIN
947: l_oks_action_times_v_rec.CREATION_DATE := SYSDATE;
948: l_oks_action_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
949: l_oks_action_times_v_rec.LAST_UPDATE_DATE := l_oks_action_times_v_rec.CREATION_DATE;
950: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
951: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
952: RETURN(l_oks_action_times_v_rec);
945: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
946: BEGIN
947: l_oks_action_times_v_rec.CREATION_DATE := SYSDATE;
948: l_oks_action_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
949: l_oks_action_times_v_rec.LAST_UPDATE_DATE := l_oks_action_times_v_rec.CREATION_DATE;
950: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
951: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
952: RETURN(l_oks_action_times_v_rec);
953: END fill_who_columns;
946: BEGIN
947: l_oks_action_times_v_rec.CREATION_DATE := SYSDATE;
948: l_oks_action_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
949: l_oks_action_times_v_rec.LAST_UPDATE_DATE := l_oks_action_times_v_rec.CREATION_DATE;
950: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
951: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
952: RETURN(l_oks_action_times_v_rec);
953: END fill_who_columns;
954: -------------------------------------------
947: l_oks_action_times_v_rec.CREATION_DATE := SYSDATE;
948: l_oks_action_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
949: l_oks_action_times_v_rec.LAST_UPDATE_DATE := l_oks_action_times_v_rec.CREATION_DATE;
950: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
951: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
952: RETURN(l_oks_action_times_v_rec);
953: END fill_who_columns;
954: -------------------------------------------
955: -- Set_Attributes for:OKS_ACTION_TIMES_V --
948: l_oks_action_times_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
949: l_oks_action_times_v_rec.LAST_UPDATE_DATE := l_oks_action_times_v_rec.CREATION_DATE;
950: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
951: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
952: RETURN(l_oks_action_times_v_rec);
953: END fill_who_columns;
954: -------------------------------------------
955: -- Set_Attributes for:OKS_ACTION_TIMES_V --
956: -------------------------------------------
951: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
952: RETURN(l_oks_action_times_v_rec);
953: END fill_who_columns;
954: -------------------------------------------
955: -- Set_Attributes for:OKS_ACTION_TIMES_V --
956: -------------------------------------------
957: FUNCTION Set_Attributes (
958: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
959: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
954: -------------------------------------------
955: -- Set_Attributes for:OKS_ACTION_TIMES_V --
956: -------------------------------------------
957: FUNCTION Set_Attributes (
958: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
959: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
960: ) RETURN VARCHAR2 IS
961: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
962: BEGIN
955: -- Set_Attributes for:OKS_ACTION_TIMES_V --
956: -------------------------------------------
957: FUNCTION Set_Attributes (
958: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
959: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
960: ) RETURN VARCHAR2 IS
961: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
962: BEGIN
963: x_oks_action_times_v_rec := p_oks_action_times_v_rec;
959: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
960: ) RETURN VARCHAR2 IS
961: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
962: BEGIN
963: x_oks_action_times_v_rec := p_oks_action_times_v_rec;
964: x_oks_action_times_v_rec.OBJECT_VERSION_NUMBER := 1;
965: RETURN(l_return_status);
966: END Set_Attributes;
967: BEGIN
960: ) RETURN VARCHAR2 IS
961: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
962: BEGIN
963: x_oks_action_times_v_rec := p_oks_action_times_v_rec;
964: x_oks_action_times_v_rec.OBJECT_VERSION_NUMBER := 1;
965: RETURN(l_return_status);
966: END Set_Attributes;
967: BEGIN
968: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
976: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
977: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_ERROR;
979: END IF;
980: l_oks_action_times_v_rec := null_out_defaults(p_oks_action_times_v_rec);
981: -- Set primary key value
982: l_oks_action_times_v_rec.ID := get_seq_id;
983: -- Setting item attributes
984: l_return_Status := Set_Attributes(
978: RAISE OKC_API.G_EXCEPTION_ERROR;
979: END IF;
980: l_oks_action_times_v_rec := null_out_defaults(p_oks_action_times_v_rec);
981: -- Set primary key value
982: l_oks_action_times_v_rec.ID := get_seq_id;
983: -- Setting item attributes
984: l_return_Status := Set_Attributes(
985: l_oks_action_times_v_rec, -- IN
986: l_def_oks_action_times_v_rec); -- OUT
981: -- Set primary key value
982: l_oks_action_times_v_rec.ID := get_seq_id;
983: -- Setting item attributes
984: l_return_Status := Set_Attributes(
985: l_oks_action_times_v_rec, -- IN
986: l_def_oks_action_times_v_rec); -- OUT
987: --- If any errors happen abort API
988: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
982: l_oks_action_times_v_rec.ID := get_seq_id;
983: -- Setting item attributes
984: l_return_Status := Set_Attributes(
985: l_oks_action_times_v_rec, -- IN
986: l_def_oks_action_times_v_rec); -- OUT
987: --- If any errors happen abort API
988: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
989: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
989: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
991: RAISE OKC_API.G_EXCEPTION_ERROR;
992: END IF;
993: l_def_oks_action_times_v_rec := fill_who_columns(l_def_oks_action_times_v_rec);
994: --- Validate all non-missing attributes (Item Level Validation)
995: l_return_status := Validate_Attributes(l_def_oks_action_times_v_rec);
996: --- If any errors happen abort API
997: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE OKC_API.G_EXCEPTION_ERROR;
992: END IF;
993: l_def_oks_action_times_v_rec := fill_who_columns(l_def_oks_action_times_v_rec);
994: --- Validate all non-missing attributes (Item Level Validation)
995: l_return_status := Validate_Attributes(l_def_oks_action_times_v_rec);
996: --- If any errors happen abort API
997: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
998: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
999: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
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_return_status := Validate_Record(l_def_oks_action_times_v_rec);
1003: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1004: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1005: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1006: RAISE OKC_API.G_EXCEPTION_ERROR;
1007: END IF;
1008: -----------------------------------------
1009: -- Move VIEW record to "Child" records --
1010: -----------------------------------------
1011: migrate(l_def_oks_action_times_v_rec, l_oks_action_times_rec);
1012: -----------------------------------------------
1013: -- Call the INSERT_ROW for each child record --
1014: -----------------------------------------------
1015: insert_row(
1024: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: migrate(lx_oks_action_times_rec, l_def_oks_action_times_v_rec);
1029: -- Set OUT values
1030: x_oks_action_times_v_rec := l_def_oks_action_times_v_rec;
1031: x_return_status := l_return_status;
1032: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: migrate(lx_oks_action_times_rec, l_def_oks_action_times_v_rec);
1029: -- Set OUT values
1030: x_oks_action_times_v_rec := l_def_oks_action_times_v_rec;
1031: x_return_status := l_return_status;
1032: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1033: EXCEPTION
1034: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1062: '_PVT'
1063: );
1064: END insert_row;
1065: ------------------------------------------------------
1066: -- PL/SQL TBL insert_row for:OKS_ACTION_TIMES_V_TBL --
1067: ------------------------------------------------------
1068: PROCEDURE insert_row(
1069: p_api_version IN NUMBER,
1070: p_init_msg_list IN VARCHAR2,
1070: p_init_msg_list IN VARCHAR2,
1071: x_return_status OUT NOCOPY VARCHAR2,
1072: x_msg_count OUT NOCOPY NUMBER,
1073: x_msg_data OUT NOCOPY VARCHAR2,
1074: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
1075: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type,
1076: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1077:
1078: l_api_version CONSTANT NUMBER := 1;
1071: x_return_status OUT NOCOPY VARCHAR2,
1072: x_msg_count OUT NOCOPY NUMBER,
1073: x_msg_data OUT NOCOPY VARCHAR2,
1074: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
1075: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type,
1076: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1077:
1078: l_api_version CONSTANT NUMBER := 1;
1079: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1080: i NUMBER := 0;
1081: BEGIN
1082: OKC_API.init_msg_list(p_init_msg_list);
1083: -- Make sure PL/SQL table has records in it before passing
1084: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
1085: i := p_oks_action_times_v_tbl.FIRST;
1086: LOOP
1087: DECLARE
1088: l_error_rec OKC_API.ERROR_REC_TYPE;
1081: BEGIN
1082: OKC_API.init_msg_list(p_init_msg_list);
1083: -- Make sure PL/SQL table has records in it before passing
1084: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
1085: i := p_oks_action_times_v_tbl.FIRST;
1086: LOOP
1087: DECLARE
1088: l_error_rec OKC_API.ERROR_REC_TYPE;
1089: BEGIN
1095: p_init_msg_list => OKC_API.G_FALSE,
1096: x_return_status => l_error_rec.error_type,
1097: x_msg_count => l_error_rec.msg_count,
1098: x_msg_data => l_error_rec.msg_data,
1099: p_oks_action_times_v_rec => p_oks_action_times_v_tbl(i),
1100: x_oks_action_times_v_rec => x_oks_action_times_v_tbl(i));
1101: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1102: l_error_rec.sqlcode := SQLCODE;
1103: load_error_tbl(l_error_rec, px_error_tbl);
1096: x_return_status => l_error_rec.error_type,
1097: x_msg_count => l_error_rec.msg_count,
1098: x_msg_data => l_error_rec.msg_data,
1099: p_oks_action_times_v_rec => p_oks_action_times_v_tbl(i),
1100: x_oks_action_times_v_rec => x_oks_action_times_v_tbl(i));
1101: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1102: l_error_rec.sqlcode := SQLCODE;
1103: load_error_tbl(l_error_rec, px_error_tbl);
1104: ELSE
1118: l_error_rec.error_type := 'OTHERS';
1119: l_error_rec.sqlcode := SQLCODE;
1120: load_error_tbl(l_error_rec, px_error_tbl);
1121: END;
1122: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
1123: i := p_oks_action_times_v_tbl.NEXT(i);
1124: END LOOP;
1125: END IF;
1126: -- Loop through the error_tbl to find the error with the highest severity
1119: l_error_rec.sqlcode := SQLCODE;
1120: load_error_tbl(l_error_rec, px_error_tbl);
1121: END;
1122: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
1123: i := p_oks_action_times_v_tbl.NEXT(i);
1124: END LOOP;
1125: END IF;
1126: -- Loop through the error_tbl to find the error with the highest severity
1127: -- and return it.
1160: );
1161: END insert_row;
1162:
1163: ------------------------------------------------------
1164: -- PL/SQL TBL insert_row for:OKS_ACTION_TIMES_V_TBL --
1165: ------------------------------------------------------
1166: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
1167: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
1168: PROCEDURE insert_row(
1170: p_init_msg_list IN VARCHAR2,
1171: x_return_status OUT NOCOPY VARCHAR2,
1172: x_msg_count OUT NOCOPY NUMBER,
1173: x_msg_data OUT NOCOPY VARCHAR2,
1174: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
1175: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type) IS
1176:
1177: l_api_version CONSTANT NUMBER := 1;
1178: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1171: x_return_status OUT NOCOPY VARCHAR2,
1172: x_msg_count OUT NOCOPY NUMBER,
1173: x_msg_data OUT NOCOPY VARCHAR2,
1174: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
1175: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type) IS
1176:
1177: l_api_version CONSTANT NUMBER := 1;
1178: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1179: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1180: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1181: BEGIN
1182: OKC_API.init_msg_list(p_init_msg_list);
1183: -- Make sure PL/SQL table has records in it before passing
1184: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
1185: insert_row (
1186: p_api_version => p_api_version,
1187: p_init_msg_list => OKC_API.G_FALSE,
1188: x_return_status => x_return_status,
1187: p_init_msg_list => OKC_API.G_FALSE,
1188: x_return_status => x_return_status,
1189: x_msg_count => x_msg_count,
1190: x_msg_data => x_msg_data,
1191: p_oks_action_times_v_tbl => p_oks_action_times_v_tbl,
1192: x_oks_action_times_v_tbl => x_oks_action_times_v_tbl,
1193: px_error_tbl => l_error_tbl);
1194: END IF;
1195: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1188: x_return_status => x_return_status,
1189: x_msg_count => x_msg_count,
1190: x_msg_data => x_msg_data,
1191: p_oks_action_times_v_tbl => p_oks_action_times_v_tbl,
1192: x_oks_action_times_v_tbl => x_oks_action_times_v_tbl,
1193: px_error_tbl => l_error_tbl);
1194: END IF;
1195: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1196: EXCEPTION
1336: '_PVT'
1337: );
1338: END lock_row;
1339: --------------------------------------
1340: -- lock_row for: OKS_ACTION_TIMES_V --
1341: --------------------------------------
1342: PROCEDURE lock_row(
1343: p_api_version IN NUMBER,
1344: p_init_msg_list IN VARCHAR2,
1344: p_init_msg_list IN VARCHAR2,
1345: x_return_status OUT NOCOPY VARCHAR2,
1346: x_msg_count OUT NOCOPY NUMBER,
1347: x_msg_data OUT NOCOPY VARCHAR2,
1348: p_oks_action_times_v_rec IN oks_action_times_v_rec_type) IS
1349:
1350: l_api_version CONSTANT NUMBER := 1;
1351: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1352: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1366: END IF;
1367: -----------------------------------------
1368: -- Move VIEW record to "Child" records --
1369: -----------------------------------------
1370: migrate(p_oks_action_times_v_rec, l_oks_action_times_rec);
1371: ---------------------------------------------
1372: -- Call the LOCK_ROW for each child record --
1373: ---------------------------------------------
1374: lock_row(
1417: '_PVT'
1418: );
1419: END lock_row;
1420: ----------------------------------------------------
1421: -- PL/SQL TBL lock_row for:OKS_ACTION_TIMES_V_TBL --
1422: ----------------------------------------------------
1423: PROCEDURE lock_row(
1424: p_api_version IN NUMBER,
1425: p_init_msg_list IN VARCHAR2,
1425: p_init_msg_list IN VARCHAR2,
1426: x_return_status OUT NOCOPY VARCHAR2,
1427: x_msg_count OUT NOCOPY NUMBER,
1428: x_msg_data OUT NOCOPY VARCHAR2,
1429: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
1430: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1431:
1432: l_api_version CONSTANT NUMBER := 1;
1433: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1434: i NUMBER := 0;
1435: BEGIN
1436: OKC_API.init_msg_list(p_init_msg_list);
1437: -- Make sure PL/SQL table has recrods in it before passing
1438: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
1439: i := p_oks_action_times_v_tbl.FIRST;
1440: LOOP
1441: DECLARE
1442: l_error_rec OKC_API.ERROR_REC_TYPE;
1435: BEGIN
1436: OKC_API.init_msg_list(p_init_msg_list);
1437: -- Make sure PL/SQL table has recrods in it before passing
1438: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
1439: i := p_oks_action_times_v_tbl.FIRST;
1440: LOOP
1441: DECLARE
1442: l_error_rec OKC_API.ERROR_REC_TYPE;
1443: BEGIN
1449: p_init_msg_list => OKC_API.G_FALSE,
1450: x_return_status => l_error_rec.error_type,
1451: x_msg_count => l_error_rec.msg_count,
1452: x_msg_data => l_error_rec.msg_data,
1453: p_oks_action_times_v_rec => p_oks_action_times_v_tbl(i));
1454: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1455: l_error_rec.sqlcode := SQLCODE;
1456: load_error_tbl(l_error_rec, px_error_tbl);
1457: ELSE
1471: l_error_rec.error_type := 'OTHERS';
1472: l_error_rec.sqlcode := SQLCODE;
1473: load_error_tbl(l_error_rec, px_error_tbl);
1474: END;
1475: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
1476: i := p_oks_action_times_v_tbl.NEXT(i);
1477: END LOOP;
1478: END IF;
1479: -- Loop through the error_tbl to find the error with the highest severity
1472: l_error_rec.sqlcode := SQLCODE;
1473: load_error_tbl(l_error_rec, px_error_tbl);
1474: END;
1475: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
1476: i := p_oks_action_times_v_tbl.NEXT(i);
1477: END LOOP;
1478: END IF;
1479: -- Loop through the error_tbl to find the error with the highest severity
1480: -- and return it.
1512: '_PVT'
1513: );
1514: END lock_row;
1515: ----------------------------------------------------
1516: -- PL/SQL TBL lock_row for:OKS_ACTION_TIMES_V_TBL --
1517: ----------------------------------------------------
1518: PROCEDURE lock_row(
1519: p_api_version IN NUMBER,
1520: p_init_msg_list IN VARCHAR2,
1520: p_init_msg_list IN VARCHAR2,
1521: x_return_status OUT NOCOPY VARCHAR2,
1522: x_msg_count OUT NOCOPY NUMBER,
1523: x_msg_data OUT NOCOPY VARCHAR2,
1524: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type) IS
1525:
1526: l_api_version CONSTANT NUMBER := 1;
1527: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1528: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1529: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1530: BEGIN
1531: OKC_API.init_msg_list(p_init_msg_list);
1532: -- Make sure PL/SQL table has recrods in it before passing
1533: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
1534: lock_row(
1535: p_api_version => p_api_version,
1536: p_init_msg_list => OKC_API.G_FALSE,
1537: x_return_status => x_return_status,
1536: p_init_msg_list => OKC_API.G_FALSE,
1537: x_return_status => x_return_status,
1538: x_msg_count => x_msg_count,
1539: x_msg_data => x_msg_data,
1540: p_oks_action_times_v_tbl => p_oks_action_times_v_tbl,
1541: px_error_tbl => l_error_tbl);
1542: END IF;
1543: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1544: EXCEPTION
1797: '_PVT'
1798: );
1799: END update_row;
1800: ---------------------------------------
1801: -- update_row for:OKS_ACTION_TIMES_V --
1802: ---------------------------------------
1803: PROCEDURE update_row(
1804: p_api_version IN NUMBER,
1805: p_init_msg_list IN VARCHAR2,
1805: p_init_msg_list IN VARCHAR2,
1806: x_return_status OUT NOCOPY VARCHAR2,
1807: x_msg_count OUT NOCOPY NUMBER,
1808: x_msg_data OUT NOCOPY VARCHAR2,
1809: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
1810: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type) IS
1811:
1812: l_api_version CONSTANT NUMBER := 1;
1813: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1806: x_return_status OUT NOCOPY VARCHAR2,
1807: x_msg_count OUT NOCOPY NUMBER,
1808: x_msg_data OUT NOCOPY VARCHAR2,
1809: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
1810: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type) IS
1811:
1812: l_api_version CONSTANT NUMBER := 1;
1813: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1814: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1811:
1812: l_api_version CONSTANT NUMBER := 1;
1813: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1814: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1815: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
1816: l_def_oks_action_times_v_rec oks_action_times_v_rec_type;
1817: l_db_oks_action_times_v_rec oks_action_times_v_rec_type;
1818: l_oks_action_times_rec oks_action_times_rec_type;
1819: lx_oks_action_times_rec oks_action_times_rec_type;
1812: l_api_version CONSTANT NUMBER := 1;
1813: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1814: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1815: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
1816: l_def_oks_action_times_v_rec oks_action_times_v_rec_type;
1817: l_db_oks_action_times_v_rec oks_action_times_v_rec_type;
1818: l_oks_action_times_rec oks_action_times_rec_type;
1819: lx_oks_action_times_rec oks_action_times_rec_type;
1820: -------------------------------
1813: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1814: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1815: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
1816: l_def_oks_action_times_v_rec oks_action_times_v_rec_type;
1817: l_db_oks_action_times_v_rec oks_action_times_v_rec_type;
1818: l_oks_action_times_rec oks_action_times_rec_type;
1819: lx_oks_action_times_rec oks_action_times_rec_type;
1820: -------------------------------
1821: -- FUNCTION fill_who_columns --
1820: -------------------------------
1821: -- FUNCTION fill_who_columns --
1822: -------------------------------
1823: FUNCTION fill_who_columns (
1824: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
1825: ) RETURN oks_action_times_v_rec_type IS
1826: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
1827: BEGIN
1828: l_oks_action_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1821: -- FUNCTION fill_who_columns --
1822: -------------------------------
1823: FUNCTION fill_who_columns (
1824: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
1825: ) RETURN oks_action_times_v_rec_type IS
1826: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
1827: BEGIN
1828: l_oks_action_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1829: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1822: -------------------------------
1823: FUNCTION fill_who_columns (
1824: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
1825: ) RETURN oks_action_times_v_rec_type IS
1826: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
1827: BEGIN
1828: l_oks_action_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1829: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1830: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1824: p_oks_action_times_v_rec IN oks_action_times_v_rec_type
1825: ) RETURN oks_action_times_v_rec_type IS
1826: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
1827: BEGIN
1828: l_oks_action_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1829: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1830: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1831: RETURN(l_oks_action_times_v_rec);
1832: END fill_who_columns;
1825: ) RETURN oks_action_times_v_rec_type IS
1826: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
1827: BEGIN
1828: l_oks_action_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1829: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1830: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1831: RETURN(l_oks_action_times_v_rec);
1832: END fill_who_columns;
1833: ----------------------------------
1826: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
1827: BEGIN
1828: l_oks_action_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1829: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1830: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1831: RETURN(l_oks_action_times_v_rec);
1832: END fill_who_columns;
1833: ----------------------------------
1834: -- FUNCTION populate_new_record --
1827: BEGIN
1828: l_oks_action_times_v_rec.LAST_UPDATE_DATE := SYSDATE;
1829: l_oks_action_times_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1830: l_oks_action_times_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1831: RETURN(l_oks_action_times_v_rec);
1832: END fill_who_columns;
1833: ----------------------------------
1834: -- FUNCTION populate_new_record --
1835: ----------------------------------
1833: ----------------------------------
1834: -- FUNCTION populate_new_record --
1835: ----------------------------------
1836: FUNCTION populate_new_record (
1837: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
1838: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
1839: ) RETURN VARCHAR2 IS
1840: l_row_notfound BOOLEAN := TRUE;
1841: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1834: -- FUNCTION populate_new_record --
1835: ----------------------------------
1836: FUNCTION populate_new_record (
1837: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
1838: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
1839: ) RETURN VARCHAR2 IS
1840: l_row_notfound BOOLEAN := TRUE;
1841: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1842: BEGIN
1839: ) RETURN VARCHAR2 IS
1840: l_row_notfound BOOLEAN := TRUE;
1841: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1842: BEGIN
1843: x_oks_action_times_v_rec := p_oks_action_times_v_rec;
1844: -- Get current database values
1845: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1846: -- so it may be verified through LOCK_ROW.
1847: l_db_oks_action_times_v_rec := get_rec(p_oks_action_times_v_rec, l_return_status);
1843: x_oks_action_times_v_rec := p_oks_action_times_v_rec;
1844: -- Get current database values
1845: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1846: -- so it may be verified through LOCK_ROW.
1847: l_db_oks_action_times_v_rec := get_rec(p_oks_action_times_v_rec, l_return_status);
1848: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1849: IF (x_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM)
1850: THEN
1851: x_oks_action_times_v_rec.id := l_db_oks_action_times_v_rec.id;
1845: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1846: -- so it may be verified through LOCK_ROW.
1847: l_db_oks_action_times_v_rec := get_rec(p_oks_action_times_v_rec, l_return_status);
1848: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1849: IF (x_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM)
1850: THEN
1851: x_oks_action_times_v_rec.id := l_db_oks_action_times_v_rec.id;
1852: END IF;
1853: IF (x_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM)
1847: l_db_oks_action_times_v_rec := get_rec(p_oks_action_times_v_rec, l_return_status);
1848: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1849: IF (x_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM)
1850: THEN
1851: x_oks_action_times_v_rec.id := l_db_oks_action_times_v_rec.id;
1852: END IF;
1853: IF (x_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM)
1854: THEN
1855: x_oks_action_times_v_rec.cov_action_type_id := l_db_oks_action_times_v_rec.cov_action_type_id;
1849: IF (x_oks_action_times_v_rec.id = OKC_API.G_MISS_NUM)
1850: THEN
1851: x_oks_action_times_v_rec.id := l_db_oks_action_times_v_rec.id;
1852: END IF;
1853: IF (x_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM)
1854: THEN
1855: x_oks_action_times_v_rec.cov_action_type_id := l_db_oks_action_times_v_rec.cov_action_type_id;
1856: END IF;
1857: IF (x_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM)
1851: x_oks_action_times_v_rec.id := l_db_oks_action_times_v_rec.id;
1852: END IF;
1853: IF (x_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM)
1854: THEN
1855: x_oks_action_times_v_rec.cov_action_type_id := l_db_oks_action_times_v_rec.cov_action_type_id;
1856: END IF;
1857: IF (x_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM)
1858: THEN
1859: x_oks_action_times_v_rec.cle_id := l_db_oks_action_times_v_rec.cle_id;
1853: IF (x_oks_action_times_v_rec.cov_action_type_id = OKC_API.G_MISS_NUM)
1854: THEN
1855: x_oks_action_times_v_rec.cov_action_type_id := l_db_oks_action_times_v_rec.cov_action_type_id;
1856: END IF;
1857: IF (x_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM)
1858: THEN
1859: x_oks_action_times_v_rec.cle_id := l_db_oks_action_times_v_rec.cle_id;
1860: END IF;
1861: IF (x_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1855: x_oks_action_times_v_rec.cov_action_type_id := l_db_oks_action_times_v_rec.cov_action_type_id;
1856: END IF;
1857: IF (x_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM)
1858: THEN
1859: x_oks_action_times_v_rec.cle_id := l_db_oks_action_times_v_rec.cle_id;
1860: END IF;
1861: IF (x_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1862: THEN
1863: x_oks_action_times_v_rec.dnz_chr_id := l_db_oks_action_times_v_rec.dnz_chr_id;
1857: IF (x_oks_action_times_v_rec.cle_id = OKC_API.G_MISS_NUM)
1858: THEN
1859: x_oks_action_times_v_rec.cle_id := l_db_oks_action_times_v_rec.cle_id;
1860: END IF;
1861: IF (x_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1862: THEN
1863: x_oks_action_times_v_rec.dnz_chr_id := l_db_oks_action_times_v_rec.dnz_chr_id;
1864: END IF;
1865: IF (x_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR)
1859: x_oks_action_times_v_rec.cle_id := l_db_oks_action_times_v_rec.cle_id;
1860: END IF;
1861: IF (x_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1862: THEN
1863: x_oks_action_times_v_rec.dnz_chr_id := l_db_oks_action_times_v_rec.dnz_chr_id;
1864: END IF;
1865: IF (x_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR)
1866: THEN
1867: x_oks_action_times_v_rec.uom_code := l_db_oks_action_times_v_rec.uom_code;
1861: IF (x_oks_action_times_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1862: THEN
1863: x_oks_action_times_v_rec.dnz_chr_id := l_db_oks_action_times_v_rec.dnz_chr_id;
1864: END IF;
1865: IF (x_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR)
1866: THEN
1867: x_oks_action_times_v_rec.uom_code := l_db_oks_action_times_v_rec.uom_code;
1868: END IF;
1869: IF (x_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM)
1863: x_oks_action_times_v_rec.dnz_chr_id := l_db_oks_action_times_v_rec.dnz_chr_id;
1864: END IF;
1865: IF (x_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR)
1866: THEN
1867: x_oks_action_times_v_rec.uom_code := l_db_oks_action_times_v_rec.uom_code;
1868: END IF;
1869: IF (x_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM)
1870: THEN
1871: x_oks_action_times_v_rec.sun_duration := l_db_oks_action_times_v_rec.sun_duration;
1865: IF (x_oks_action_times_v_rec.uom_code = OKC_API.G_MISS_CHAR)
1866: THEN
1867: x_oks_action_times_v_rec.uom_code := l_db_oks_action_times_v_rec.uom_code;
1868: END IF;
1869: IF (x_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM)
1870: THEN
1871: x_oks_action_times_v_rec.sun_duration := l_db_oks_action_times_v_rec.sun_duration;
1872: END IF;
1873: IF (x_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM)
1867: x_oks_action_times_v_rec.uom_code := l_db_oks_action_times_v_rec.uom_code;
1868: END IF;
1869: IF (x_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM)
1870: THEN
1871: x_oks_action_times_v_rec.sun_duration := l_db_oks_action_times_v_rec.sun_duration;
1872: END IF;
1873: IF (x_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM)
1874: THEN
1875: x_oks_action_times_v_rec.mon_duration := l_db_oks_action_times_v_rec.mon_duration;
1869: IF (x_oks_action_times_v_rec.sun_duration = OKC_API.G_MISS_NUM)
1870: THEN
1871: x_oks_action_times_v_rec.sun_duration := l_db_oks_action_times_v_rec.sun_duration;
1872: END IF;
1873: IF (x_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM)
1874: THEN
1875: x_oks_action_times_v_rec.mon_duration := l_db_oks_action_times_v_rec.mon_duration;
1876: END IF;
1877: IF (x_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM)
1871: x_oks_action_times_v_rec.sun_duration := l_db_oks_action_times_v_rec.sun_duration;
1872: END IF;
1873: IF (x_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM)
1874: THEN
1875: x_oks_action_times_v_rec.mon_duration := l_db_oks_action_times_v_rec.mon_duration;
1876: END IF;
1877: IF (x_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM)
1878: THEN
1879: x_oks_action_times_v_rec.tue_duration := l_db_oks_action_times_v_rec.tue_duration;
1873: IF (x_oks_action_times_v_rec.mon_duration = OKC_API.G_MISS_NUM)
1874: THEN
1875: x_oks_action_times_v_rec.mon_duration := l_db_oks_action_times_v_rec.mon_duration;
1876: END IF;
1877: IF (x_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM)
1878: THEN
1879: x_oks_action_times_v_rec.tue_duration := l_db_oks_action_times_v_rec.tue_duration;
1880: END IF;
1881: IF (x_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM)
1875: x_oks_action_times_v_rec.mon_duration := l_db_oks_action_times_v_rec.mon_duration;
1876: END IF;
1877: IF (x_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM)
1878: THEN
1879: x_oks_action_times_v_rec.tue_duration := l_db_oks_action_times_v_rec.tue_duration;
1880: END IF;
1881: IF (x_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM)
1882: THEN
1883: x_oks_action_times_v_rec.wed_duration := l_db_oks_action_times_v_rec.wed_duration;
1877: IF (x_oks_action_times_v_rec.tue_duration = OKC_API.G_MISS_NUM)
1878: THEN
1879: x_oks_action_times_v_rec.tue_duration := l_db_oks_action_times_v_rec.tue_duration;
1880: END IF;
1881: IF (x_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM)
1882: THEN
1883: x_oks_action_times_v_rec.wed_duration := l_db_oks_action_times_v_rec.wed_duration;
1884: END IF;
1885: IF (x_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM)
1879: x_oks_action_times_v_rec.tue_duration := l_db_oks_action_times_v_rec.tue_duration;
1880: END IF;
1881: IF (x_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM)
1882: THEN
1883: x_oks_action_times_v_rec.wed_duration := l_db_oks_action_times_v_rec.wed_duration;
1884: END IF;
1885: IF (x_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM)
1886: THEN
1887: x_oks_action_times_v_rec.thu_duration := l_db_oks_action_times_v_rec.thu_duration;
1881: IF (x_oks_action_times_v_rec.wed_duration = OKC_API.G_MISS_NUM)
1882: THEN
1883: x_oks_action_times_v_rec.wed_duration := l_db_oks_action_times_v_rec.wed_duration;
1884: END IF;
1885: IF (x_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM)
1886: THEN
1887: x_oks_action_times_v_rec.thu_duration := l_db_oks_action_times_v_rec.thu_duration;
1888: END IF;
1889: IF (x_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM)
1883: x_oks_action_times_v_rec.wed_duration := l_db_oks_action_times_v_rec.wed_duration;
1884: END IF;
1885: IF (x_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM)
1886: THEN
1887: x_oks_action_times_v_rec.thu_duration := l_db_oks_action_times_v_rec.thu_duration;
1888: END IF;
1889: IF (x_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM)
1890: THEN
1891: x_oks_action_times_v_rec.fri_duration := l_db_oks_action_times_v_rec.fri_duration;
1885: IF (x_oks_action_times_v_rec.thu_duration = OKC_API.G_MISS_NUM)
1886: THEN
1887: x_oks_action_times_v_rec.thu_duration := l_db_oks_action_times_v_rec.thu_duration;
1888: END IF;
1889: IF (x_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM)
1890: THEN
1891: x_oks_action_times_v_rec.fri_duration := l_db_oks_action_times_v_rec.fri_duration;
1892: END IF;
1893: IF (x_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM)
1887: x_oks_action_times_v_rec.thu_duration := l_db_oks_action_times_v_rec.thu_duration;
1888: END IF;
1889: IF (x_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM)
1890: THEN
1891: x_oks_action_times_v_rec.fri_duration := l_db_oks_action_times_v_rec.fri_duration;
1892: END IF;
1893: IF (x_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM)
1894: THEN
1895: x_oks_action_times_v_rec.sat_duration := l_db_oks_action_times_v_rec.sat_duration;
1889: IF (x_oks_action_times_v_rec.fri_duration = OKC_API.G_MISS_NUM)
1890: THEN
1891: x_oks_action_times_v_rec.fri_duration := l_db_oks_action_times_v_rec.fri_duration;
1892: END IF;
1893: IF (x_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM)
1894: THEN
1895: x_oks_action_times_v_rec.sat_duration := l_db_oks_action_times_v_rec.sat_duration;
1896: END IF;
1897: IF (x_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1891: x_oks_action_times_v_rec.fri_duration := l_db_oks_action_times_v_rec.fri_duration;
1892: END IF;
1893: IF (x_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM)
1894: THEN
1895: x_oks_action_times_v_rec.sat_duration := l_db_oks_action_times_v_rec.sat_duration;
1896: END IF;
1897: IF (x_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1898: THEN
1899: x_oks_action_times_v_rec.security_group_id := l_db_oks_action_times_v_rec.security_group_id;
1893: IF (x_oks_action_times_v_rec.sat_duration = OKC_API.G_MISS_NUM)
1894: THEN
1895: x_oks_action_times_v_rec.sat_duration := l_db_oks_action_times_v_rec.sat_duration;
1896: END IF;
1897: IF (x_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1898: THEN
1899: x_oks_action_times_v_rec.security_group_id := l_db_oks_action_times_v_rec.security_group_id;
1900: END IF;
1901: IF (x_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1895: x_oks_action_times_v_rec.sat_duration := l_db_oks_action_times_v_rec.sat_duration;
1896: END IF;
1897: IF (x_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1898: THEN
1899: x_oks_action_times_v_rec.security_group_id := l_db_oks_action_times_v_rec.security_group_id;
1900: END IF;
1901: IF (x_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1902: THEN
1903: x_oks_action_times_v_rec.program_application_id := l_db_oks_action_times_v_rec.program_application_id;
1897: IF (x_oks_action_times_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1898: THEN
1899: x_oks_action_times_v_rec.security_group_id := l_db_oks_action_times_v_rec.security_group_id;
1900: END IF;
1901: IF (x_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1902: THEN
1903: x_oks_action_times_v_rec.program_application_id := l_db_oks_action_times_v_rec.program_application_id;
1904: END IF;
1905: IF (x_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1899: x_oks_action_times_v_rec.security_group_id := l_db_oks_action_times_v_rec.security_group_id;
1900: END IF;
1901: IF (x_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1902: THEN
1903: x_oks_action_times_v_rec.program_application_id := l_db_oks_action_times_v_rec.program_application_id;
1904: END IF;
1905: IF (x_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1906: THEN
1907: x_oks_action_times_v_rec.program_id := l_db_oks_action_times_v_rec.program_id;
1901: IF (x_oks_action_times_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1902: THEN
1903: x_oks_action_times_v_rec.program_application_id := l_db_oks_action_times_v_rec.program_application_id;
1904: END IF;
1905: IF (x_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1906: THEN
1907: x_oks_action_times_v_rec.program_id := l_db_oks_action_times_v_rec.program_id;
1908: END IF;
1909: IF (x_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1903: x_oks_action_times_v_rec.program_application_id := l_db_oks_action_times_v_rec.program_application_id;
1904: END IF;
1905: IF (x_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1906: THEN
1907: x_oks_action_times_v_rec.program_id := l_db_oks_action_times_v_rec.program_id;
1908: END IF;
1909: IF (x_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1910: THEN
1911: x_oks_action_times_v_rec.program_update_date := l_db_oks_action_times_v_rec.program_update_date;
1905: IF (x_oks_action_times_v_rec.program_id = OKC_API.G_MISS_NUM)
1906: THEN
1907: x_oks_action_times_v_rec.program_id := l_db_oks_action_times_v_rec.program_id;
1908: END IF;
1909: IF (x_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1910: THEN
1911: x_oks_action_times_v_rec.program_update_date := l_db_oks_action_times_v_rec.program_update_date;
1912: END IF;
1913: IF (x_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1907: x_oks_action_times_v_rec.program_id := l_db_oks_action_times_v_rec.program_id;
1908: END IF;
1909: IF (x_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1910: THEN
1911: x_oks_action_times_v_rec.program_update_date := l_db_oks_action_times_v_rec.program_update_date;
1912: END IF;
1913: IF (x_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1914: THEN
1915: x_oks_action_times_v_rec.request_id := l_db_oks_action_times_v_rec.request_id;
1909: IF (x_oks_action_times_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1910: THEN
1911: x_oks_action_times_v_rec.program_update_date := l_db_oks_action_times_v_rec.program_update_date;
1912: END IF;
1913: IF (x_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1914: THEN
1915: x_oks_action_times_v_rec.request_id := l_db_oks_action_times_v_rec.request_id;
1916: END IF;
1917: IF (x_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1911: x_oks_action_times_v_rec.program_update_date := l_db_oks_action_times_v_rec.program_update_date;
1912: END IF;
1913: IF (x_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1914: THEN
1915: x_oks_action_times_v_rec.request_id := l_db_oks_action_times_v_rec.request_id;
1916: END IF;
1917: IF (x_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1918: THEN
1919: x_oks_action_times_v_rec.created_by := l_db_oks_action_times_v_rec.created_by;
1913: IF (x_oks_action_times_v_rec.request_id = OKC_API.G_MISS_NUM)
1914: THEN
1915: x_oks_action_times_v_rec.request_id := l_db_oks_action_times_v_rec.request_id;
1916: END IF;
1917: IF (x_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1918: THEN
1919: x_oks_action_times_v_rec.created_by := l_db_oks_action_times_v_rec.created_by;
1920: END IF;
1921: IF (x_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1915: x_oks_action_times_v_rec.request_id := l_db_oks_action_times_v_rec.request_id;
1916: END IF;
1917: IF (x_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1918: THEN
1919: x_oks_action_times_v_rec.created_by := l_db_oks_action_times_v_rec.created_by;
1920: END IF;
1921: IF (x_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1922: THEN
1923: x_oks_action_times_v_rec.creation_date := l_db_oks_action_times_v_rec.creation_date;
1917: IF (x_oks_action_times_v_rec.created_by = OKC_API.G_MISS_NUM)
1918: THEN
1919: x_oks_action_times_v_rec.created_by := l_db_oks_action_times_v_rec.created_by;
1920: END IF;
1921: IF (x_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1922: THEN
1923: x_oks_action_times_v_rec.creation_date := l_db_oks_action_times_v_rec.creation_date;
1924: END IF;
1925: IF (x_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1919: x_oks_action_times_v_rec.created_by := l_db_oks_action_times_v_rec.created_by;
1920: END IF;
1921: IF (x_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1922: THEN
1923: x_oks_action_times_v_rec.creation_date := l_db_oks_action_times_v_rec.creation_date;
1924: END IF;
1925: IF (x_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1926: THEN
1927: x_oks_action_times_v_rec.last_updated_by := l_db_oks_action_times_v_rec.last_updated_by;
1921: IF (x_oks_action_times_v_rec.creation_date = OKC_API.G_MISS_DATE)
1922: THEN
1923: x_oks_action_times_v_rec.creation_date := l_db_oks_action_times_v_rec.creation_date;
1924: END IF;
1925: IF (x_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1926: THEN
1927: x_oks_action_times_v_rec.last_updated_by := l_db_oks_action_times_v_rec.last_updated_by;
1928: END IF;
1929: IF (x_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1923: x_oks_action_times_v_rec.creation_date := l_db_oks_action_times_v_rec.creation_date;
1924: END IF;
1925: IF (x_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1926: THEN
1927: x_oks_action_times_v_rec.last_updated_by := l_db_oks_action_times_v_rec.last_updated_by;
1928: END IF;
1929: IF (x_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1930: THEN
1931: x_oks_action_times_v_rec.last_update_date := l_db_oks_action_times_v_rec.last_update_date;
1925: IF (x_oks_action_times_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1926: THEN
1927: x_oks_action_times_v_rec.last_updated_by := l_db_oks_action_times_v_rec.last_updated_by;
1928: END IF;
1929: IF (x_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1930: THEN
1931: x_oks_action_times_v_rec.last_update_date := l_db_oks_action_times_v_rec.last_update_date;
1932: END IF;
1933: IF (x_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1927: x_oks_action_times_v_rec.last_updated_by := l_db_oks_action_times_v_rec.last_updated_by;
1928: END IF;
1929: IF (x_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1930: THEN
1931: x_oks_action_times_v_rec.last_update_date := l_db_oks_action_times_v_rec.last_update_date;
1932: END IF;
1933: IF (x_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1934: THEN
1935: x_oks_action_times_v_rec.last_update_login := l_db_oks_action_times_v_rec.last_update_login;
1929: IF (x_oks_action_times_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1930: THEN
1931: x_oks_action_times_v_rec.last_update_date := l_db_oks_action_times_v_rec.last_update_date;
1932: END IF;
1933: IF (x_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1934: THEN
1935: x_oks_action_times_v_rec.last_update_login := l_db_oks_action_times_v_rec.last_update_login;
1936: END IF;
1937: END IF;
1931: x_oks_action_times_v_rec.last_update_date := l_db_oks_action_times_v_rec.last_update_date;
1932: END IF;
1933: IF (x_oks_action_times_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1934: THEN
1935: x_oks_action_times_v_rec.last_update_login := l_db_oks_action_times_v_rec.last_update_login;
1936: END IF;
1937: END IF;
1938: RETURN(l_return_status);
1939: END populate_new_record;
1937: END IF;
1938: RETURN(l_return_status);
1939: END populate_new_record;
1940: -------------------------------------------
1941: -- Set_Attributes for:OKS_ACTION_TIMES_V --
1942: -------------------------------------------
1943: FUNCTION Set_Attributes (
1944: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
1945: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
1940: -------------------------------------------
1941: -- Set_Attributes for:OKS_ACTION_TIMES_V --
1942: -------------------------------------------
1943: FUNCTION Set_Attributes (
1944: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
1945: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
1946: ) RETURN VARCHAR2 IS
1947: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1948: BEGIN
1941: -- Set_Attributes for:OKS_ACTION_TIMES_V --
1942: -------------------------------------------
1943: FUNCTION Set_Attributes (
1944: p_oks_action_times_v_rec IN oks_action_times_v_rec_type,
1945: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
1946: ) RETURN VARCHAR2 IS
1947: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1948: BEGIN
1949: x_oks_action_times_v_rec := p_oks_action_times_v_rec;
1945: x_oks_action_times_v_rec OUT NOCOPY oks_action_times_v_rec_type
1946: ) RETURN VARCHAR2 IS
1947: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1948: BEGIN
1949: x_oks_action_times_v_rec := p_oks_action_times_v_rec;
1950: RETURN(l_return_status);
1951: END Set_Attributes;
1952: BEGIN
1953: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1963: RAISE OKC_API.G_EXCEPTION_ERROR;
1964: END IF;
1965: --- Setting item attributes
1966: l_return_status := Set_Attributes(
1967: p_oks_action_times_v_rec, -- IN
1968: x_oks_action_times_v_rec); -- OUT
1969: --- If any errors happen abort API
1970: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1971: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1964: END IF;
1965: --- Setting item attributes
1966: l_return_status := Set_Attributes(
1967: p_oks_action_times_v_rec, -- IN
1968: x_oks_action_times_v_rec); -- OUT
1969: --- If any errors happen abort API
1970: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1971: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1972: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1971: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1972: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1973: RAISE OKC_API.G_EXCEPTION_ERROR;
1974: END IF;
1975: l_return_status := populate_new_record(l_oks_action_times_v_rec, l_def_oks_action_times_v_rec);
1976: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1978: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_ERROR;
1977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1978: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_ERROR;
1980: END IF;
1981: l_def_oks_action_times_v_rec := fill_who_columns(l_def_oks_action_times_v_rec);
1982: --- Validate all non-missing attributes (Item Level Validation)
1983: l_return_status := Validate_Attributes(l_def_oks_action_times_v_rec);
1984: --- If any errors happen abort API
1985: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_ERROR;
1980: END IF;
1981: l_def_oks_action_times_v_rec := fill_who_columns(l_def_oks_action_times_v_rec);
1982: --- Validate all non-missing attributes (Item Level Validation)
1983: l_return_status := Validate_Attributes(l_def_oks_action_times_v_rec);
1984: --- If any errors happen abort API
1985: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1986: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1987: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1986: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1987: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1988: RAISE OKC_API.G_EXCEPTION_ERROR;
1989: END IF;
1990: l_return_status := Validate_Record(l_def_oks_action_times_v_rec, l_db_oks_action_times_v_rec);
1991: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1992: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1993: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1994: RAISE OKC_API.G_EXCEPTION_ERROR;
2000: p_init_msg_list => p_init_msg_list,
2001: x_return_status => l_return_status,
2002: x_msg_count => x_msg_count,
2003: x_msg_data => x_msg_data,
2004: p_oks_action_times_v_rec => p_oks_action_times_v_rec);
2005: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2008: RAISE OKC_API.G_EXCEPTION_ERROR;
2010:
2011: -----------------------------------------
2012: -- Move VIEW record to "Child" records --
2013: -----------------------------------------
2014: migrate(l_def_oks_action_times_v_rec, l_oks_action_times_rec);
2015: -----------------------------------------------
2016: -- Call the UPDATE_ROW for each child record --
2017: -----------------------------------------------
2018: update_row(
2027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2028: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2029: RAISE OKC_API.G_EXCEPTION_ERROR;
2030: END IF;
2031: migrate(lx_oks_action_times_rec, l_def_oks_action_times_v_rec);
2032: x_oks_action_times_v_rec := l_def_oks_action_times_v_rec;
2033: x_return_status := l_return_status;
2034: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2035: EXCEPTION
2028: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2029: RAISE OKC_API.G_EXCEPTION_ERROR;
2030: END IF;
2031: migrate(lx_oks_action_times_rec, l_def_oks_action_times_v_rec);
2032: x_oks_action_times_v_rec := l_def_oks_action_times_v_rec;
2033: x_return_status := l_return_status;
2034: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2035: EXCEPTION
2036: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2064: '_PVT'
2065: );
2066: END update_row;
2067: ------------------------------------------------------
2068: -- PL/SQL TBL update_row for:oks_action_times_v_tbl --
2069: ------------------------------------------------------
2070: PROCEDURE update_row(
2071: p_api_version IN NUMBER,
2072: p_init_msg_list IN VARCHAR2,
2072: p_init_msg_list IN VARCHAR2,
2073: x_return_status OUT NOCOPY VARCHAR2,
2074: x_msg_count OUT NOCOPY NUMBER,
2075: x_msg_data OUT NOCOPY VARCHAR2,
2076: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
2077: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type,
2078: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2079:
2080: l_api_version CONSTANT NUMBER := 1;
2073: x_return_status OUT NOCOPY VARCHAR2,
2074: x_msg_count OUT NOCOPY NUMBER,
2075: x_msg_data OUT NOCOPY VARCHAR2,
2076: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
2077: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type,
2078: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2079:
2080: l_api_version CONSTANT NUMBER := 1;
2081: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2082: i NUMBER := 0;
2083: BEGIN
2084: OKC_API.init_msg_list(p_init_msg_list);
2085: -- Make sure PL/SQL table has records in it before passing
2086: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
2087: i := p_oks_action_times_v_tbl.FIRST;
2088: LOOP
2089: DECLARE
2090: l_error_rec OKC_API.ERROR_REC_TYPE;
2083: BEGIN
2084: OKC_API.init_msg_list(p_init_msg_list);
2085: -- Make sure PL/SQL table has records in it before passing
2086: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
2087: i := p_oks_action_times_v_tbl.FIRST;
2088: LOOP
2089: DECLARE
2090: l_error_rec OKC_API.ERROR_REC_TYPE;
2091: BEGIN
2097: p_init_msg_list => OKC_API.G_FALSE,
2098: x_return_status => l_error_rec.error_type,
2099: x_msg_count => l_error_rec.msg_count,
2100: x_msg_data => l_error_rec.msg_data,
2101: p_oks_action_times_v_rec => p_oks_action_times_v_tbl(i),
2102: x_oks_action_times_v_rec => x_oks_action_times_v_tbl(i));
2103: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2104: l_error_rec.sqlcode := SQLCODE;
2105: load_error_tbl(l_error_rec, px_error_tbl);
2098: x_return_status => l_error_rec.error_type,
2099: x_msg_count => l_error_rec.msg_count,
2100: x_msg_data => l_error_rec.msg_data,
2101: p_oks_action_times_v_rec => p_oks_action_times_v_tbl(i),
2102: x_oks_action_times_v_rec => x_oks_action_times_v_tbl(i));
2103: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2104: l_error_rec.sqlcode := SQLCODE;
2105: load_error_tbl(l_error_rec, px_error_tbl);
2106: ELSE
2120: l_error_rec.error_type := 'OTHERS';
2121: l_error_rec.sqlcode := SQLCODE;
2122: load_error_tbl(l_error_rec, px_error_tbl);
2123: END;
2124: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
2125: i := p_oks_action_times_v_tbl.NEXT(i);
2126: END LOOP;
2127: END IF;
2128: -- Loop through the error_tbl to find the error with the highest severity
2121: l_error_rec.sqlcode := SQLCODE;
2122: load_error_tbl(l_error_rec, px_error_tbl);
2123: END;
2124: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
2125: i := p_oks_action_times_v_tbl.NEXT(i);
2126: END LOOP;
2127: END IF;
2128: -- Loop through the error_tbl to find the error with the highest severity
2129: -- and return it.
2162: );
2163: END update_row;
2164:
2165: ------------------------------------------------------
2166: -- PL/SQL TBL update_row for:OKS_ACTION_TIMES_V_TBL --
2167: ------------------------------------------------------
2168: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
2169: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
2170: PROCEDURE update_row(
2172: p_init_msg_list IN VARCHAR2,
2173: x_return_status OUT NOCOPY VARCHAR2,
2174: x_msg_count OUT NOCOPY NUMBER,
2175: x_msg_data OUT NOCOPY VARCHAR2,
2176: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
2177: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type) IS
2178:
2179: l_api_version CONSTANT NUMBER := 1;
2180: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2173: x_return_status OUT NOCOPY VARCHAR2,
2174: x_msg_count OUT NOCOPY NUMBER,
2175: x_msg_data OUT NOCOPY VARCHAR2,
2176: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
2177: x_oks_action_times_v_tbl OUT NOCOPY oks_action_times_v_tbl_type) IS
2178:
2179: l_api_version CONSTANT NUMBER := 1;
2180: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2181: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2182: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2183: BEGIN
2184: OKC_API.init_msg_list(p_init_msg_list);
2185: -- Make sure PL/SQL table has records in it before passing
2186: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
2187: update_row (
2188: p_api_version => p_api_version,
2189: p_init_msg_list => OKC_API.G_FALSE,
2190: x_return_status => x_return_status,
2189: p_init_msg_list => OKC_API.G_FALSE,
2190: x_return_status => x_return_status,
2191: x_msg_count => x_msg_count,
2192: x_msg_data => x_msg_data,
2193: p_oks_action_times_v_tbl => p_oks_action_times_v_tbl,
2194: x_oks_action_times_v_tbl => x_oks_action_times_v_tbl,
2195: px_error_tbl => l_error_tbl);
2196: END IF;
2197: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2190: x_return_status => x_return_status,
2191: x_msg_count => x_msg_count,
2192: x_msg_data => x_msg_data,
2193: p_oks_action_times_v_tbl => p_oks_action_times_v_tbl,
2194: x_oks_action_times_v_tbl => x_oks_action_times_v_tbl,
2195: px_error_tbl => l_error_tbl);
2196: END IF;
2197: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2198: EXCEPTION
2294: '_PVT'
2295: );
2296: END delete_row;
2297: ---------------------------------------
2298: -- delete_row for:OKS_ACTION_TIMES_V --
2299: ---------------------------------------
2300: PROCEDURE delete_row(
2301: p_api_version IN NUMBER,
2302: p_init_msg_list IN VARCHAR2,
2302: p_init_msg_list IN VARCHAR2,
2303: x_return_status OUT NOCOPY VARCHAR2,
2304: x_msg_count OUT NOCOPY NUMBER,
2305: x_msg_data OUT NOCOPY VARCHAR2,
2306: p_oks_action_times_v_rec IN oks_action_times_v_rec_type) IS
2307:
2308: l_api_version CONSTANT NUMBER := 1;
2309: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2310: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2307:
2308: l_api_version CONSTANT NUMBER := 1;
2309: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2310: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2311: l_oks_action_times_v_rec oks_action_times_v_rec_type := p_oks_action_times_v_rec;
2312: l_oks_action_times_rec oks_action_times_rec_type;
2313: BEGIN
2314: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2315: G_PKG_NAME,
2325: END IF;
2326: -----------------------------------------
2327: -- Move VIEW record to "Child" records --
2328: -----------------------------------------
2329: migrate(l_oks_action_times_v_rec, l_oks_action_times_rec);
2330: -----------------------------------------------
2331: -- Call the DELETE_ROW for each child record --
2332: -----------------------------------------------
2333: delete_row(
2376: '_PVT'
2377: );
2378: END delete_row;
2379: --------------------------------------------------
2380: -- PL/SQL TBL delete_row for:OKS_ACTION_TIMES_V --
2381: --------------------------------------------------
2382: PROCEDURE delete_row(
2383: p_api_version IN NUMBER,
2384: p_init_msg_list IN VARCHAR2,
2384: p_init_msg_list IN VARCHAR2,
2385: x_return_status OUT NOCOPY VARCHAR2,
2386: x_msg_count OUT NOCOPY NUMBER,
2387: x_msg_data OUT NOCOPY VARCHAR2,
2388: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type,
2389: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2390:
2391: l_api_version CONSTANT NUMBER := 1;
2392: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2393: i NUMBER := 0;
2394: BEGIN
2395: OKC_API.init_msg_list(p_init_msg_list);
2396: -- Make sure PL/SQL table has records in it before passing
2397: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
2398: i := p_oks_action_times_v_tbl.FIRST;
2399: LOOP
2400: DECLARE
2401: l_error_rec OKC_API.ERROR_REC_TYPE;
2394: BEGIN
2395: OKC_API.init_msg_list(p_init_msg_list);
2396: -- Make sure PL/SQL table has records in it before passing
2397: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
2398: i := p_oks_action_times_v_tbl.FIRST;
2399: LOOP
2400: DECLARE
2401: l_error_rec OKC_API.ERROR_REC_TYPE;
2402: BEGIN
2408: p_init_msg_list => OKC_API.G_FALSE,
2409: x_return_status => l_error_rec.error_type,
2410: x_msg_count => l_error_rec.msg_count,
2411: x_msg_data => l_error_rec.msg_data,
2412: p_oks_action_times_v_rec => p_oks_action_times_v_tbl(i));
2413: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2414: l_error_rec.sqlcode := SQLCODE;
2415: load_error_tbl(l_error_rec, px_error_tbl);
2416: ELSE
2430: l_error_rec.error_type := 'OTHERS';
2431: l_error_rec.sqlcode := SQLCODE;
2432: load_error_tbl(l_error_rec, px_error_tbl);
2433: END;
2434: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
2435: i := p_oks_action_times_v_tbl.NEXT(i);
2436: END LOOP;
2437: END IF;
2438: -- Loop through the error_tbl to find the error with the highest severity
2431: l_error_rec.sqlcode := SQLCODE;
2432: load_error_tbl(l_error_rec, px_error_tbl);
2433: END;
2434: EXIT WHEN (i = p_oks_action_times_v_tbl.LAST);
2435: i := p_oks_action_times_v_tbl.NEXT(i);
2436: END LOOP;
2437: END IF;
2438: -- Loop through the error_tbl to find the error with the highest severity
2439: -- and return it.
2472: );
2473: END delete_row;
2474:
2475: --------------------------------------------------
2476: -- PL/SQL TBL delete_row for:OKS_ACTION_TIMES_V --
2477: --------------------------------------------------
2478: PROCEDURE delete_row(
2479: p_api_version IN NUMBER,
2480: p_init_msg_list IN VARCHAR2,
2480: p_init_msg_list IN VARCHAR2,
2481: x_return_status OUT NOCOPY VARCHAR2,
2482: x_msg_count OUT NOCOPY NUMBER,
2483: x_msg_data OUT NOCOPY VARCHAR2,
2484: p_oks_action_times_v_tbl IN oks_action_times_v_tbl_type) IS
2485:
2486: l_api_version CONSTANT NUMBER := 1;
2487: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2488: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2489: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2490: BEGIN
2491: OKC_API.init_msg_list(p_init_msg_list);
2492: -- Make sure PL/SQL table has records in it before passing
2493: IF (p_oks_action_times_v_tbl.COUNT > 0) THEN
2494: delete_row (
2495: p_api_version => p_api_version,
2496: p_init_msg_list => OKC_API.G_FALSE,
2497: x_return_status => x_return_status,
2496: p_init_msg_list => OKC_API.G_FALSE,
2497: x_return_status => x_return_status,
2498: x_msg_count => x_msg_count,
2499: x_msg_data => x_msg_data,
2500: p_oks_action_times_v_tbl => p_oks_action_times_v_tbl,
2501: px_error_tbl => l_error_tbl);
2502: END IF;
2503: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2504: EXCEPTION