[Home] [Help]
90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_ACTION_TIME_TYPES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
98: x_no_data_found OUT NOCOPY BOOLEAN
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_ACTION_TIME_TYPES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN OksActionTimeTypesVRecType IS
100: CURSOR oks_attv_pk_csr (p_id IN NUMBER) IS
101: SELECT
118: ORIG_SYSTEM_ID1,
119: ORIG_SYSTEM_REFERENCE1,
120: ORIG_SYSTEM_SOURCE_CODE
121: -- R12 Data Model Changes 4485150 End
122: FROM Oks_Action_Time_Types_V
123: WHERE oks_action_time_types_v.id = p_id;
124: l_oks_attv_pk oks_attv_pk_csr%ROWTYPE;
125: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType;
126: BEGIN
119: ORIG_SYSTEM_REFERENCE1,
120: ORIG_SYSTEM_SOURCE_CODE
121: -- R12 Data Model Changes 4485150 End
122: FROM Oks_Action_Time_Types_V
123: WHERE oks_action_time_types_v.id = p_id;
124: l_oks_attv_pk oks_attv_pk_csr%ROWTYPE;
125: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType;
126: BEGIN
127: x_no_data_found := TRUE;
121: -- R12 Data Model Changes 4485150 End
122: FROM Oks_Action_Time_Types_V
123: WHERE oks_action_time_types_v.id = p_id;
124: l_oks_attv_pk oks_attv_pk_csr%ROWTYPE;
125: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType;
126: BEGIN
127: x_no_data_found := TRUE;
128: -- Get current database values
129: OPEN oks_attv_pk_csr (p_oks_action_time_types_v_rec.id);
125: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType;
126: BEGIN
127: x_no_data_found := TRUE;
128: -- Get current database values
129: OPEN oks_attv_pk_csr (p_oks_action_time_types_v_rec.id);
130: FETCH oks_attv_pk_csr INTO
131: l_oks_action_time_types_v_rec.id,
132: l_oks_action_time_types_v_rec.cle_id,
133: l_oks_action_time_types_v_rec.dnz_chr_id,
127: x_no_data_found := TRUE;
128: -- Get current database values
129: OPEN oks_attv_pk_csr (p_oks_action_time_types_v_rec.id);
130: FETCH oks_attv_pk_csr INTO
131: l_oks_action_time_types_v_rec.id,
132: l_oks_action_time_types_v_rec.cle_id,
133: l_oks_action_time_types_v_rec.dnz_chr_id,
134: l_oks_action_time_types_v_rec.action_type_code,
135: l_oks_action_time_types_v_rec.security_group_id,
128: -- Get current database values
129: OPEN oks_attv_pk_csr (p_oks_action_time_types_v_rec.id);
130: FETCH oks_attv_pk_csr INTO
131: l_oks_action_time_types_v_rec.id,
132: l_oks_action_time_types_v_rec.cle_id,
133: l_oks_action_time_types_v_rec.dnz_chr_id,
134: l_oks_action_time_types_v_rec.action_type_code,
135: l_oks_action_time_types_v_rec.security_group_id,
136: l_oks_action_time_types_v_rec.program_application_id,
129: OPEN oks_attv_pk_csr (p_oks_action_time_types_v_rec.id);
130: FETCH oks_attv_pk_csr INTO
131: l_oks_action_time_types_v_rec.id,
132: l_oks_action_time_types_v_rec.cle_id,
133: l_oks_action_time_types_v_rec.dnz_chr_id,
134: l_oks_action_time_types_v_rec.action_type_code,
135: l_oks_action_time_types_v_rec.security_group_id,
136: l_oks_action_time_types_v_rec.program_application_id,
137: l_oks_action_time_types_v_rec.program_id,
130: FETCH oks_attv_pk_csr INTO
131: l_oks_action_time_types_v_rec.id,
132: l_oks_action_time_types_v_rec.cle_id,
133: l_oks_action_time_types_v_rec.dnz_chr_id,
134: l_oks_action_time_types_v_rec.action_type_code,
135: l_oks_action_time_types_v_rec.security_group_id,
136: l_oks_action_time_types_v_rec.program_application_id,
137: l_oks_action_time_types_v_rec.program_id,
138: l_oks_action_time_types_v_rec.program_update_date,
131: l_oks_action_time_types_v_rec.id,
132: l_oks_action_time_types_v_rec.cle_id,
133: l_oks_action_time_types_v_rec.dnz_chr_id,
134: l_oks_action_time_types_v_rec.action_type_code,
135: l_oks_action_time_types_v_rec.security_group_id,
136: l_oks_action_time_types_v_rec.program_application_id,
137: l_oks_action_time_types_v_rec.program_id,
138: l_oks_action_time_types_v_rec.program_update_date,
139: l_oks_action_time_types_v_rec.request_id,
132: l_oks_action_time_types_v_rec.cle_id,
133: l_oks_action_time_types_v_rec.dnz_chr_id,
134: l_oks_action_time_types_v_rec.action_type_code,
135: l_oks_action_time_types_v_rec.security_group_id,
136: l_oks_action_time_types_v_rec.program_application_id,
137: l_oks_action_time_types_v_rec.program_id,
138: l_oks_action_time_types_v_rec.program_update_date,
139: l_oks_action_time_types_v_rec.request_id,
140: l_oks_action_time_types_v_rec.created_by,
133: l_oks_action_time_types_v_rec.dnz_chr_id,
134: l_oks_action_time_types_v_rec.action_type_code,
135: l_oks_action_time_types_v_rec.security_group_id,
136: l_oks_action_time_types_v_rec.program_application_id,
137: l_oks_action_time_types_v_rec.program_id,
138: l_oks_action_time_types_v_rec.program_update_date,
139: l_oks_action_time_types_v_rec.request_id,
140: l_oks_action_time_types_v_rec.created_by,
141: l_oks_action_time_types_v_rec.creation_date,
134: l_oks_action_time_types_v_rec.action_type_code,
135: l_oks_action_time_types_v_rec.security_group_id,
136: l_oks_action_time_types_v_rec.program_application_id,
137: l_oks_action_time_types_v_rec.program_id,
138: l_oks_action_time_types_v_rec.program_update_date,
139: l_oks_action_time_types_v_rec.request_id,
140: l_oks_action_time_types_v_rec.created_by,
141: l_oks_action_time_types_v_rec.creation_date,
142: l_oks_action_time_types_v_rec.last_updated_by,
135: l_oks_action_time_types_v_rec.security_group_id,
136: l_oks_action_time_types_v_rec.program_application_id,
137: l_oks_action_time_types_v_rec.program_id,
138: l_oks_action_time_types_v_rec.program_update_date,
139: l_oks_action_time_types_v_rec.request_id,
140: l_oks_action_time_types_v_rec.created_by,
141: l_oks_action_time_types_v_rec.creation_date,
142: l_oks_action_time_types_v_rec.last_updated_by,
143: l_oks_action_time_types_v_rec.last_update_date,
136: l_oks_action_time_types_v_rec.program_application_id,
137: l_oks_action_time_types_v_rec.program_id,
138: l_oks_action_time_types_v_rec.program_update_date,
139: l_oks_action_time_types_v_rec.request_id,
140: l_oks_action_time_types_v_rec.created_by,
141: l_oks_action_time_types_v_rec.creation_date,
142: l_oks_action_time_types_v_rec.last_updated_by,
143: l_oks_action_time_types_v_rec.last_update_date,
144: l_oks_action_time_types_v_rec.last_update_login,
137: l_oks_action_time_types_v_rec.program_id,
138: l_oks_action_time_types_v_rec.program_update_date,
139: l_oks_action_time_types_v_rec.request_id,
140: l_oks_action_time_types_v_rec.created_by,
141: l_oks_action_time_types_v_rec.creation_date,
142: l_oks_action_time_types_v_rec.last_updated_by,
143: l_oks_action_time_types_v_rec.last_update_date,
144: l_oks_action_time_types_v_rec.last_update_login,
145: l_oks_action_time_types_v_rec.object_version_number,
138: l_oks_action_time_types_v_rec.program_update_date,
139: l_oks_action_time_types_v_rec.request_id,
140: l_oks_action_time_types_v_rec.created_by,
141: l_oks_action_time_types_v_rec.creation_date,
142: l_oks_action_time_types_v_rec.last_updated_by,
143: l_oks_action_time_types_v_rec.last_update_date,
144: l_oks_action_time_types_v_rec.last_update_login,
145: l_oks_action_time_types_v_rec.object_version_number,
146: -- R12 Data Model Changes 4485150 Start
139: l_oks_action_time_types_v_rec.request_id,
140: l_oks_action_time_types_v_rec.created_by,
141: l_oks_action_time_types_v_rec.creation_date,
142: l_oks_action_time_types_v_rec.last_updated_by,
143: l_oks_action_time_types_v_rec.last_update_date,
144: l_oks_action_time_types_v_rec.last_update_login,
145: l_oks_action_time_types_v_rec.object_version_number,
146: -- R12 Data Model Changes 4485150 Start
147: l_oks_action_time_types_v_rec.orig_system_id1,
140: l_oks_action_time_types_v_rec.created_by,
141: l_oks_action_time_types_v_rec.creation_date,
142: l_oks_action_time_types_v_rec.last_updated_by,
143: l_oks_action_time_types_v_rec.last_update_date,
144: l_oks_action_time_types_v_rec.last_update_login,
145: l_oks_action_time_types_v_rec.object_version_number,
146: -- R12 Data Model Changes 4485150 Start
147: l_oks_action_time_types_v_rec.orig_system_id1,
148: l_oks_action_time_types_v_rec.orig_system_reference1,
141: l_oks_action_time_types_v_rec.creation_date,
142: l_oks_action_time_types_v_rec.last_updated_by,
143: l_oks_action_time_types_v_rec.last_update_date,
144: l_oks_action_time_types_v_rec.last_update_login,
145: l_oks_action_time_types_v_rec.object_version_number,
146: -- R12 Data Model Changes 4485150 Start
147: l_oks_action_time_types_v_rec.orig_system_id1,
148: l_oks_action_time_types_v_rec.orig_system_reference1,
149: l_oks_action_time_types_v_rec.orig_system_source_code
143: l_oks_action_time_types_v_rec.last_update_date,
144: l_oks_action_time_types_v_rec.last_update_login,
145: l_oks_action_time_types_v_rec.object_version_number,
146: -- R12 Data Model Changes 4485150 Start
147: l_oks_action_time_types_v_rec.orig_system_id1,
148: l_oks_action_time_types_v_rec.orig_system_reference1,
149: l_oks_action_time_types_v_rec.orig_system_source_code
150: -- R12 Data Model Changes 4485150 End
151: ;
144: l_oks_action_time_types_v_rec.last_update_login,
145: l_oks_action_time_types_v_rec.object_version_number,
146: -- R12 Data Model Changes 4485150 Start
147: l_oks_action_time_types_v_rec.orig_system_id1,
148: l_oks_action_time_types_v_rec.orig_system_reference1,
149: l_oks_action_time_types_v_rec.orig_system_source_code
150: -- R12 Data Model Changes 4485150 End
151: ;
152:
145: l_oks_action_time_types_v_rec.object_version_number,
146: -- R12 Data Model Changes 4485150 Start
147: l_oks_action_time_types_v_rec.orig_system_id1,
148: l_oks_action_time_types_v_rec.orig_system_reference1,
149: l_oks_action_time_types_v_rec.orig_system_source_code
150: -- R12 Data Model Changes 4485150 End
151: ;
152:
153: x_no_data_found := oks_attv_pk_csr%NOTFOUND;
151: ;
152:
153: x_no_data_found := oks_attv_pk_csr%NOTFOUND;
154: CLOSE oks_attv_pk_csr;
155: RETURN(l_oks_action_time_types_v_rec);
156: END get_rec;
157:
158: ------------------------------------------------------------------
159: -- This version of get_rec sets error messages if no data found --
158: ------------------------------------------------------------------
159: -- This version of get_rec sets error messages if no data found --
160: ------------------------------------------------------------------
161: FUNCTION get_rec (
162: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
163: x_return_status OUT NOCOPY VARCHAR2
164: ) RETURN OksActionTimeTypesVRecType IS
165: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType;
166: l_row_notfound BOOLEAN := TRUE;
161: FUNCTION get_rec (
162: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
163: x_return_status OUT NOCOPY VARCHAR2
164: ) RETURN OksActionTimeTypesVRecType IS
165: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType;
166: l_row_notfound BOOLEAN := TRUE;
167: BEGIN
168: x_return_status := OKC_API.G_RET_STS_SUCCESS;
169: l_oks_action_time_types_v_rec := get_rec(p_oks_action_time_types_v_rec, l_row_notfound);
165: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType;
166: l_row_notfound BOOLEAN := TRUE;
167: BEGIN
168: x_return_status := OKC_API.G_RET_STS_SUCCESS;
169: l_oks_action_time_types_v_rec := get_rec(p_oks_action_time_types_v_rec, l_row_notfound);
170: IF (l_row_notfound) THEN
171: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
172: x_return_status := OKC_API.G_RET_STS_ERROR;
173: END IF;
170: IF (l_row_notfound) THEN
171: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
172: x_return_status := OKC_API.G_RET_STS_ERROR;
173: END IF;
174: RETURN(l_oks_action_time_types_v_rec);
175: END get_rec;
176: -----------------------------------------------------------
177: -- So we don't have to pass an "l_row_notfound" variable --
178: -----------------------------------------------------------
176: -----------------------------------------------------------
177: -- So we don't have to pass an "l_row_notfound" variable --
178: -----------------------------------------------------------
179: FUNCTION get_rec (
180: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
181: ) RETURN OksActionTimeTypesVRecType IS
182: l_row_not_found BOOLEAN := TRUE;
183: BEGIN
184: RETURN(get_rec(p_oks_action_time_types_v_rec, l_row_not_found));
180: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
181: ) RETURN OksActionTimeTypesVRecType IS
182: l_row_not_found BOOLEAN := TRUE;
183: BEGIN
184: RETURN(get_rec(p_oks_action_time_types_v_rec, l_row_not_found));
185: END get_rec;
186: ---------------------------------------------------------------------------
187: -- FUNCTION get_rec for: OKS_ACTION_TIME_TYPES
188: ---------------------------------------------------------------------------
273: BEGIN
274: RETURN(get_rec(p_oks_action_time_types_rec, l_row_not_found));
275: END get_rec;
276: ---------------------------------------------------------------------------
277: -- FUNCTION null_out_defaults for: OKS_ACTION_TIME_TYPES_V
278: ---------------------------------------------------------------------------
279: FUNCTION null_out_defaults (
280: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
281: ) RETURN OksActionTimeTypesVRecType IS
276: ---------------------------------------------------------------------------
277: -- FUNCTION null_out_defaults for: OKS_ACTION_TIME_TYPES_V
278: ---------------------------------------------------------------------------
279: FUNCTION null_out_defaults (
280: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
281: ) RETURN OksActionTimeTypesVRecType IS
282: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
283: BEGIN
284: IF (l_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM ) THEN
278: ---------------------------------------------------------------------------
279: FUNCTION null_out_defaults (
280: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
281: ) RETURN OksActionTimeTypesVRecType IS
282: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
283: BEGIN
284: IF (l_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM ) THEN
285: l_oks_action_time_types_v_rec.id := NULL;
286: END IF;
280: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
281: ) RETURN OksActionTimeTypesVRecType IS
282: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
283: BEGIN
284: IF (l_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM ) THEN
285: l_oks_action_time_types_v_rec.id := NULL;
286: END IF;
287: IF (l_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
288: l_oks_action_time_types_v_rec.cle_id := NULL;
281: ) RETURN OksActionTimeTypesVRecType IS
282: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
283: BEGIN
284: IF (l_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM ) THEN
285: l_oks_action_time_types_v_rec.id := NULL;
286: END IF;
287: IF (l_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
288: l_oks_action_time_types_v_rec.cle_id := NULL;
289: END IF;
283: BEGIN
284: IF (l_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM ) THEN
285: l_oks_action_time_types_v_rec.id := NULL;
286: END IF;
287: IF (l_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
288: l_oks_action_time_types_v_rec.cle_id := NULL;
289: END IF;
290: IF (l_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
291: l_oks_action_time_types_v_rec.dnz_chr_id := NULL;
284: IF (l_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM ) THEN
285: l_oks_action_time_types_v_rec.id := NULL;
286: END IF;
287: IF (l_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
288: l_oks_action_time_types_v_rec.cle_id := NULL;
289: END IF;
290: IF (l_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
291: l_oks_action_time_types_v_rec.dnz_chr_id := NULL;
292: END IF;
286: END IF;
287: IF (l_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
288: l_oks_action_time_types_v_rec.cle_id := NULL;
289: END IF;
290: IF (l_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
291: l_oks_action_time_types_v_rec.dnz_chr_id := NULL;
292: END IF;
293: IF (l_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR ) THEN
294: l_oks_action_time_types_v_rec.action_type_code := NULL;
287: IF (l_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
288: l_oks_action_time_types_v_rec.cle_id := NULL;
289: END IF;
290: IF (l_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
291: l_oks_action_time_types_v_rec.dnz_chr_id := NULL;
292: END IF;
293: IF (l_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR ) THEN
294: l_oks_action_time_types_v_rec.action_type_code := NULL;
295: END IF;
289: END IF;
290: IF (l_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
291: l_oks_action_time_types_v_rec.dnz_chr_id := NULL;
292: END IF;
293: IF (l_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR ) THEN
294: l_oks_action_time_types_v_rec.action_type_code := NULL;
295: END IF;
296: IF (l_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_time_types_v_rec.security_group_id := NULL;
290: IF (l_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
291: l_oks_action_time_types_v_rec.dnz_chr_id := NULL;
292: END IF;
293: IF (l_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR ) THEN
294: l_oks_action_time_types_v_rec.action_type_code := NULL;
295: END IF;
296: IF (l_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_time_types_v_rec.security_group_id := NULL;
298: END IF;
292: END IF;
293: IF (l_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR ) THEN
294: l_oks_action_time_types_v_rec.action_type_code := NULL;
295: END IF;
296: IF (l_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_time_types_v_rec.security_group_id := NULL;
298: END IF;
299: IF (l_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_time_types_v_rec.program_application_id := NULL;
293: IF (l_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR ) THEN
294: l_oks_action_time_types_v_rec.action_type_code := NULL;
295: END IF;
296: IF (l_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_time_types_v_rec.security_group_id := NULL;
298: END IF;
299: IF (l_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_time_types_v_rec.program_application_id := NULL;
301: END IF;
295: END IF;
296: IF (l_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_time_types_v_rec.security_group_id := NULL;
298: END IF;
299: IF (l_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_time_types_v_rec.program_application_id := NULL;
301: END IF;
302: IF (l_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_time_types_v_rec.program_id := NULL;
296: IF (l_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_action_time_types_v_rec.security_group_id := NULL;
298: END IF;
299: IF (l_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_time_types_v_rec.program_application_id := NULL;
301: END IF;
302: IF (l_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_time_types_v_rec.program_id := NULL;
304: END IF;
298: END IF;
299: IF (l_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_time_types_v_rec.program_application_id := NULL;
301: END IF;
302: IF (l_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_time_types_v_rec.program_id := NULL;
304: END IF;
305: IF (l_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
306: l_oks_action_time_types_v_rec.program_update_date := NULL;
299: IF (l_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_action_time_types_v_rec.program_application_id := NULL;
301: END IF;
302: IF (l_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_time_types_v_rec.program_id := NULL;
304: END IF;
305: IF (l_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
306: l_oks_action_time_types_v_rec.program_update_date := NULL;
307: END IF;
301: END IF;
302: IF (l_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_time_types_v_rec.program_id := NULL;
304: END IF;
305: IF (l_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
306: l_oks_action_time_types_v_rec.program_update_date := NULL;
307: END IF;
308: IF (l_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_time_types_v_rec.request_id := NULL;
302: IF (l_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_action_time_types_v_rec.program_id := NULL;
304: END IF;
305: IF (l_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
306: l_oks_action_time_types_v_rec.program_update_date := NULL;
307: END IF;
308: IF (l_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_time_types_v_rec.request_id := NULL;
310: END IF;
304: END IF;
305: IF (l_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
306: l_oks_action_time_types_v_rec.program_update_date := NULL;
307: END IF;
308: IF (l_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_time_types_v_rec.request_id := NULL;
310: END IF;
311: IF (l_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_time_types_v_rec.created_by := NULL;
305: IF (l_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
306: l_oks_action_time_types_v_rec.program_update_date := NULL;
307: END IF;
308: IF (l_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_time_types_v_rec.request_id := NULL;
310: END IF;
311: IF (l_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_time_types_v_rec.created_by := NULL;
313: END IF;
307: END IF;
308: IF (l_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_time_types_v_rec.request_id := NULL;
310: END IF;
311: IF (l_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_time_types_v_rec.created_by := NULL;
313: END IF;
314: IF (l_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
315: l_oks_action_time_types_v_rec.creation_date := NULL;
308: IF (l_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_action_time_types_v_rec.request_id := NULL;
310: END IF;
311: IF (l_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_time_types_v_rec.created_by := NULL;
313: END IF;
314: IF (l_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
315: l_oks_action_time_types_v_rec.creation_date := NULL;
316: END IF;
310: END IF;
311: IF (l_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_time_types_v_rec.created_by := NULL;
313: END IF;
314: IF (l_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
315: l_oks_action_time_types_v_rec.creation_date := NULL;
316: END IF;
317: IF (l_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_time_types_v_rec.last_updated_by := NULL;
311: IF (l_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
312: l_oks_action_time_types_v_rec.created_by := NULL;
313: END IF;
314: IF (l_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
315: l_oks_action_time_types_v_rec.creation_date := NULL;
316: END IF;
317: IF (l_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_time_types_v_rec.last_updated_by := NULL;
319: END IF;
313: END IF;
314: IF (l_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
315: l_oks_action_time_types_v_rec.creation_date := NULL;
316: END IF;
317: IF (l_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_time_types_v_rec.last_updated_by := NULL;
319: END IF;
320: IF (l_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
321: l_oks_action_time_types_v_rec.last_update_date := NULL;
314: IF (l_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
315: l_oks_action_time_types_v_rec.creation_date := NULL;
316: END IF;
317: IF (l_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_time_types_v_rec.last_updated_by := NULL;
319: END IF;
320: IF (l_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
321: l_oks_action_time_types_v_rec.last_update_date := NULL;
322: END IF;
316: END IF;
317: IF (l_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_time_types_v_rec.last_updated_by := NULL;
319: END IF;
320: IF (l_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
321: l_oks_action_time_types_v_rec.last_update_date := NULL;
322: END IF;
323: IF (l_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_time_types_v_rec.last_update_login := NULL;
317: IF (l_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
318: l_oks_action_time_types_v_rec.last_updated_by := NULL;
319: END IF;
320: IF (l_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
321: l_oks_action_time_types_v_rec.last_update_date := NULL;
322: END IF;
323: IF (l_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_time_types_v_rec.last_update_login := NULL;
325: END IF;
319: END IF;
320: IF (l_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
321: l_oks_action_time_types_v_rec.last_update_date := NULL;
322: END IF;
323: IF (l_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_time_types_v_rec.last_update_login := NULL;
325: END IF;
326: IF (l_oks_action_time_types_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_time_types_v_rec.object_version_number := NULL;
320: IF (l_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
321: l_oks_action_time_types_v_rec.last_update_date := NULL;
322: END IF;
323: IF (l_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_time_types_v_rec.last_update_login := NULL;
325: END IF;
326: IF (l_oks_action_time_types_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_time_types_v_rec.object_version_number := NULL;
328: END IF;
322: END IF;
323: IF (l_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_time_types_v_rec.last_update_login := NULL;
325: END IF;
326: IF (l_oks_action_time_types_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_time_types_v_rec.object_version_number := NULL;
328: END IF;
329: -- R12 Data Model Changes 4485150 Start
330: IF (l_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
323: IF (l_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
324: l_oks_action_time_types_v_rec.last_update_login := NULL;
325: END IF;
326: IF (l_oks_action_time_types_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_time_types_v_rec.object_version_number := NULL;
328: END IF;
329: -- R12 Data Model Changes 4485150 Start
330: IF (l_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
331: l_oks_action_time_types_v_rec.orig_system_id1 := NULL;
326: IF (l_oks_action_time_types_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
327: l_oks_action_time_types_v_rec.object_version_number := NULL;
328: END IF;
329: -- R12 Data Model Changes 4485150 Start
330: IF (l_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
331: l_oks_action_time_types_v_rec.orig_system_id1 := NULL;
332: END IF;
333: IF (l_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
334: l_oks_action_time_types_v_rec.orig_system_reference1 := NULL;
327: l_oks_action_time_types_v_rec.object_version_number := NULL;
328: END IF;
329: -- R12 Data Model Changes 4485150 Start
330: IF (l_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
331: l_oks_action_time_types_v_rec.orig_system_id1 := NULL;
332: END IF;
333: IF (l_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
334: l_oks_action_time_types_v_rec.orig_system_reference1 := NULL;
335: END IF;
329: -- R12 Data Model Changes 4485150 Start
330: IF (l_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
331: l_oks_action_time_types_v_rec.orig_system_id1 := NULL;
332: END IF;
333: IF (l_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
334: l_oks_action_time_types_v_rec.orig_system_reference1 := NULL;
335: END IF;
336: IF (l_oks_action_time_types_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR ) THEN
337: l_oks_action_time_types_v_rec.orig_system_source_code := NULL;
330: IF (l_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM ) THEN
331: l_oks_action_time_types_v_rec.orig_system_id1 := NULL;
332: END IF;
333: IF (l_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
334: l_oks_action_time_types_v_rec.orig_system_reference1 := NULL;
335: END IF;
336: IF (l_oks_action_time_types_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR ) THEN
337: l_oks_action_time_types_v_rec.orig_system_source_code := NULL;
338: END IF;
332: END IF;
333: IF (l_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
334: l_oks_action_time_types_v_rec.orig_system_reference1 := NULL;
335: END IF;
336: IF (l_oks_action_time_types_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR ) THEN
337: l_oks_action_time_types_v_rec.orig_system_source_code := NULL;
338: END IF;
339: -- R12 Data Model Changes 4485150 End
340:
333: IF (l_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR ) THEN
334: l_oks_action_time_types_v_rec.orig_system_reference1 := NULL;
335: END IF;
336: IF (l_oks_action_time_types_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR ) THEN
337: l_oks_action_time_types_v_rec.orig_system_source_code := NULL;
338: END IF;
339: -- R12 Data Model Changes 4485150 End
340:
341: RETURN(l_oks_action_time_types_v_rec);
337: l_oks_action_time_types_v_rec.orig_system_source_code := NULL;
338: END IF;
339: -- R12 Data Model Changes 4485150 End
340:
341: RETURN(l_oks_action_time_types_v_rec);
342: END null_out_defaults;
343: ---------------------------------
344: -- Validate_Attributes for: ID --
345: ---------------------------------
397: ---------------------------------------------------------------------------
398: -- FUNCTION Validate_Attributes
399: ---------------------------------------------------------------------------
400: -----------------------------------------------------
401: -- Validate_Attributes for:OKS_ACTION_TIME_TYPES_V --
402: -----------------------------------------------------
403: FUNCTION Validate_Attributes (
404: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
405: ) RETURN VARCHAR2 IS
400: -----------------------------------------------------
401: -- Validate_Attributes for:OKS_ACTION_TIME_TYPES_V --
402: -----------------------------------------------------
403: FUNCTION Validate_Attributes (
404: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
405: ) RETURN VARCHAR2 IS
406: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
407: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
408: BEGIN
411: -----------------------------
412: -- ***
413: -- id
414: -- ***
415: validate_id(x_return_status, p_oks_action_time_types_v_rec.id);
416: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
417: l_return_status := x_return_status;
418: RAISE G_EXCEPTION_HALT_VALIDATION;
419: END IF;
420:
421: -- ***
422: -- object_version_number
423: -- ***
424: validate_object_version_number(x_return_status, p_oks_action_time_types_v_rec.object_version_number);
425: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
426: l_return_status := x_return_status;
427: RAISE G_EXCEPTION_HALT_VALIDATION;
428: END IF;
444: ---------------------------------------------------------------------------
445: -- PROCEDURE Validate_Record
446: ---------------------------------------------------------------------------
447: -------------------------------------------------
448: -- Validate Record for:OKS_ACTION_TIME_TYPES_V --
449: -------------------------------------------------
450: FUNCTION Validate_Record (
451: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
452: p_db_oks_action_tim1 IN OksActionTimeTypesVRecType
447: -------------------------------------------------
448: -- Validate Record for:OKS_ACTION_TIME_TYPES_V --
449: -------------------------------------------------
450: FUNCTION Validate_Record (
451: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
452: p_db_oks_action_tim1 IN OksActionTimeTypesVRecType
453: ) RETURN VARCHAR2 IS
454: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
455: BEGIN
455: BEGIN
456: RETURN (l_return_status);
457: END Validate_Record;
458: FUNCTION Validate_Record (
459: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
460: ) RETURN VARCHAR2 IS
461: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
462: l_db_oks_action_tim2 OksActionTimeTypesVRecType := get_rec(p_oks_action_time_types_v_rec);
463: BEGIN
458: FUNCTION Validate_Record (
459: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
460: ) RETURN VARCHAR2 IS
461: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
462: l_db_oks_action_tim2 OksActionTimeTypesVRecType := get_rec(p_oks_action_time_types_v_rec);
463: BEGIN
464: l_return_status := Validate_Record(p_oks_action_time_types_v_rec => p_oks_action_time_types_v_rec,
465: p_db_oks_action_tim1 => l_db_oks_action_tim2);
466: RETURN (l_return_status);
460: ) RETURN VARCHAR2 IS
461: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
462: l_db_oks_action_tim2 OksActionTimeTypesVRecType := get_rec(p_oks_action_time_types_v_rec);
463: BEGIN
464: l_return_status := Validate_Record(p_oks_action_time_types_v_rec => p_oks_action_time_types_v_rec,
465: p_db_oks_action_tim1 => l_db_oks_action_tim2);
466: RETURN (l_return_status);
467: END Validate_Record;
468:
522: ---------------------------------------------------------------------------
523: -- PROCEDURE validate_row
524: ---------------------------------------------------------------------------
525: ----------------------------------------------
526: -- validate_row for:OKS_ACTION_TIME_TYPES_V --
527: ----------------------------------------------
528: PROCEDURE validate_row(
529: p_api_version IN NUMBER,
530: p_init_msg_list IN VARCHAR2,
530: p_init_msg_list IN VARCHAR2,
531: x_return_status OUT NOCOPY VARCHAR2,
532: x_msg_count OUT NOCOPY NUMBER,
533: x_msg_data OUT NOCOPY VARCHAR2,
534: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType) IS
535:
536: l_api_version CONSTANT NUMBER := 1;
537: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
538: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
535:
536: l_api_version CONSTANT NUMBER := 1;
537: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
538: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
539: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
540: l_oks_action_time_types_rec oks_action_time_types_rec_type;
541: l_oks_action_time_types_rec oks_action_time_types_rec_type;
542: BEGIN
543: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
552: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
553: RAISE OKC_API.G_EXCEPTION_ERROR;
554: END IF;
555: --- Validate all non-missing attributes (Item Level Validation)
556: l_return_status := Validate_Attributes(l_oks_action_time_types_v_rec);
557: --- If any errors happen abort API
558: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
559: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
560: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
559: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
560: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
561: RAISE OKC_API.G_EXCEPTION_ERROR;
562: END IF;
563: l_return_status := Validate_Record(l_oks_action_time_types_v_rec);
564: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
565: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
566: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
567: RAISE OKC_API.G_EXCEPTION_ERROR;
599: '_PVT'
600: );
601: END validate_row;
602: ---------------------------------------------------------
603: -- PL/SQL TBL validate_row for:OKS_ACTION_TIME_TYPES_V --
604: ---------------------------------------------------------
605: PROCEDURE validate_row(
606: p_api_version IN NUMBER,
607: p_init_msg_list IN VARCHAR2,
607: p_init_msg_list IN VARCHAR2,
608: x_return_status OUT NOCOPY VARCHAR2,
609: x_msg_count OUT NOCOPY NUMBER,
610: x_msg_data OUT NOCOPY VARCHAR2,
611: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
612: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
613:
614: l_api_version CONSTANT NUMBER := 1;
615: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
616: i NUMBER := 0;
617: BEGIN
618: OKC_API.init_msg_list(p_init_msg_list);
619: -- Make sure PL/SQL table has records in it before passing
620: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
621: i := p_oks_action_time_types_v_tbl.FIRST;
622: LOOP
623: DECLARE
624: l_error_rec OKC_API.ERROR_REC_TYPE;
617: BEGIN
618: OKC_API.init_msg_list(p_init_msg_list);
619: -- Make sure PL/SQL table has records in it before passing
620: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
621: i := p_oks_action_time_types_v_tbl.FIRST;
622: LOOP
623: DECLARE
624: l_error_rec OKC_API.ERROR_REC_TYPE;
625: BEGIN
631: p_init_msg_list => OKC_API.G_FALSE,
632: x_return_status => l_error_rec.error_type,
633: x_msg_count => l_error_rec.msg_count,
634: x_msg_data => l_error_rec.msg_data,
635: p_oks_action_time_types_v_rec => p_oks_action_time_types_v_tbl(i));
636: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
637: l_error_rec.sqlcode := SQLCODE;
638: load_error_tbl(l_error_rec, px_error_tbl);
639: ELSE
653: l_error_rec.error_type := 'OTHERS';
654: l_error_rec.sqlcode := SQLCODE;
655: load_error_tbl(l_error_rec, px_error_tbl);
656: END;
657: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
658: i := p_oks_action_time_types_v_tbl.NEXT(i);
659: END LOOP;
660: END IF;
661: -- Loop through the error_tbl to find the error with the highest severity
654: l_error_rec.sqlcode := SQLCODE;
655: load_error_tbl(l_error_rec, px_error_tbl);
656: END;
657: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
658: i := p_oks_action_time_types_v_tbl.NEXT(i);
659: END LOOP;
660: END IF;
661: -- Loop through the error_tbl to find the error with the highest severity
662: -- and return it.
695: );
696: END validate_row;
697:
698: ---------------------------------------------------------
699: -- PL/SQL TBL validate_row for:OKS_ACTION_TIME_TYPES_V --
700: ---------------------------------------------------------
701: PROCEDURE validate_row(
702: p_api_version IN NUMBER,
703: p_init_msg_list IN VARCHAR2,
703: p_init_msg_list IN VARCHAR2,
704: x_return_status OUT NOCOPY VARCHAR2,
705: x_msg_count OUT NOCOPY NUMBER,
706: x_msg_data OUT NOCOPY VARCHAR2,
707: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType) IS
708:
709: l_api_version CONSTANT NUMBER := 1;
710: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
711: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
712: l_error_tbl OKC_API.ERROR_TBL_TYPE;
713: BEGIN
714: OKC_API.init_msg_list(p_init_msg_list);
715: -- Make sure PL/SQL table has records in it before passing
716: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
717: validate_row (
718: p_api_version => p_api_version,
719: p_init_msg_list => OKC_API.G_FALSE,
720: x_return_status => x_return_status,
719: p_init_msg_list => OKC_API.G_FALSE,
720: x_return_status => x_return_status,
721: x_msg_count => x_msg_count,
722: x_msg_data => x_msg_data,
723: p_oks_action_time_types_v_tbl => p_oks_action_time_types_v_tbl,
724: px_error_tbl => l_error_tbl);
725: END IF;
726: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
727: EXCEPTION
886: '_PVT'
887: );
888: END insert_row;
889: ---------------------------------------------
890: -- insert_row for :OKS_ACTION_TIME_TYPES_V --
891: ---------------------------------------------
892: PROCEDURE insert_row(
893: p_api_version IN NUMBER,
894: p_init_msg_list IN VARCHAR2,
894: p_init_msg_list IN VARCHAR2,
895: x_return_status OUT NOCOPY VARCHAR2,
896: x_msg_count OUT NOCOPY NUMBER,
897: x_msg_data OUT NOCOPY VARCHAR2,
898: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
899: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType) IS
900:
901: l_api_version CONSTANT NUMBER := 1;
902: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
895: x_return_status OUT NOCOPY VARCHAR2,
896: x_msg_count OUT NOCOPY NUMBER,
897: x_msg_data OUT NOCOPY VARCHAR2,
898: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
899: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType) IS
900:
901: l_api_version CONSTANT NUMBER := 1;
902: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
903: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
900:
901: l_api_version CONSTANT NUMBER := 1;
902: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
903: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
904: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
905: LDefOksActionTimeTypesVRec OksActionTimeTypesVRecType;
906: l_oks_action_time_types_rec oks_action_time_types_rec_type;
907: lx_oks_action_time_types_rec oks_action_time_types_rec_type;
908: -------------------------------
908: -------------------------------
909: -- FUNCTION fill_who_columns --
910: -------------------------------
911: FUNCTION fill_who_columns (
912: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
913: ) RETURN OksActionTimeTypesVRecType IS
914: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
915: BEGIN
916: l_oks_action_time_types_v_rec.CREATION_DATE := SYSDATE;
910: -------------------------------
911: FUNCTION fill_who_columns (
912: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
913: ) RETURN OksActionTimeTypesVRecType IS
914: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
915: BEGIN
916: l_oks_action_time_types_v_rec.CREATION_DATE := SYSDATE;
917: l_oks_action_time_types_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
918: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := l_oks_action_time_types_v_rec.CREATION_DATE;
912: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
913: ) RETURN OksActionTimeTypesVRecType IS
914: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
915: BEGIN
916: l_oks_action_time_types_v_rec.CREATION_DATE := SYSDATE;
917: l_oks_action_time_types_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
918: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := l_oks_action_time_types_v_rec.CREATION_DATE;
919: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
920: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
913: ) RETURN OksActionTimeTypesVRecType IS
914: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
915: BEGIN
916: l_oks_action_time_types_v_rec.CREATION_DATE := SYSDATE;
917: l_oks_action_time_types_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
918: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := l_oks_action_time_types_v_rec.CREATION_DATE;
919: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
920: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
921: RETURN(l_oks_action_time_types_v_rec);
914: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
915: BEGIN
916: l_oks_action_time_types_v_rec.CREATION_DATE := SYSDATE;
917: l_oks_action_time_types_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
918: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := l_oks_action_time_types_v_rec.CREATION_DATE;
919: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
920: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
921: RETURN(l_oks_action_time_types_v_rec);
922: END fill_who_columns;
915: BEGIN
916: l_oks_action_time_types_v_rec.CREATION_DATE := SYSDATE;
917: l_oks_action_time_types_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
918: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := l_oks_action_time_types_v_rec.CREATION_DATE;
919: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
920: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
921: RETURN(l_oks_action_time_types_v_rec);
922: END fill_who_columns;
923: ------------------------------------------------
916: l_oks_action_time_types_v_rec.CREATION_DATE := SYSDATE;
917: l_oks_action_time_types_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
918: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := l_oks_action_time_types_v_rec.CREATION_DATE;
919: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
920: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
921: RETURN(l_oks_action_time_types_v_rec);
922: END fill_who_columns;
923: ------------------------------------------------
924: -- Set_Attributes for:OKS_ACTION_TIME_TYPES_V --
917: l_oks_action_time_types_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
918: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := l_oks_action_time_types_v_rec.CREATION_DATE;
919: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
920: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
921: RETURN(l_oks_action_time_types_v_rec);
922: END fill_who_columns;
923: ------------------------------------------------
924: -- Set_Attributes for:OKS_ACTION_TIME_TYPES_V --
925: ------------------------------------------------
920: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
921: RETURN(l_oks_action_time_types_v_rec);
922: END fill_who_columns;
923: ------------------------------------------------
924: -- Set_Attributes for:OKS_ACTION_TIME_TYPES_V --
925: ------------------------------------------------
926: FUNCTION Set_Attributes (
927: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
928: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
923: ------------------------------------------------
924: -- Set_Attributes for:OKS_ACTION_TIME_TYPES_V --
925: ------------------------------------------------
926: FUNCTION Set_Attributes (
927: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
928: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
929: ) RETURN VARCHAR2 IS
930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
931: BEGIN
924: -- Set_Attributes for:OKS_ACTION_TIME_TYPES_V --
925: ------------------------------------------------
926: FUNCTION Set_Attributes (
927: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
928: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
929: ) RETURN VARCHAR2 IS
930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
931: BEGIN
932: x_oks_action_time_types_v_rec := p_oks_action_time_types_v_rec;
928: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
929: ) RETURN VARCHAR2 IS
930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
931: BEGIN
932: x_oks_action_time_types_v_rec := p_oks_action_time_types_v_rec;
933: x_oks_action_time_types_v_rec.OBJECT_VERSION_NUMBER := 1;
934: RETURN(l_return_status);
935: END Set_Attributes;
936: BEGIN
929: ) RETURN VARCHAR2 IS
930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
931: BEGIN
932: x_oks_action_time_types_v_rec := p_oks_action_time_types_v_rec;
933: x_oks_action_time_types_v_rec.OBJECT_VERSION_NUMBER := 1;
934: RETURN(l_return_status);
935: END Set_Attributes;
936: BEGIN
937: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;
949: l_oks_action_time_types_v_rec := null_out_defaults(p_oks_action_time_types_v_rec);
950: -- Set primary key value
951: l_oks_action_time_types_v_rec.ID := get_seq_id;
952: -- Setting item attributes
953: l_return_Status := Set_Attributes(
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;
949: l_oks_action_time_types_v_rec := null_out_defaults(p_oks_action_time_types_v_rec);
950: -- Set primary key value
951: l_oks_action_time_types_v_rec.ID := get_seq_id;
952: -- Setting item attributes
953: l_return_Status := Set_Attributes(
954: l_oks_action_time_types_v_rec, -- IN
955: LDefOksActionTimeTypesVRec); -- OUT
950: -- Set primary key value
951: l_oks_action_time_types_v_rec.ID := get_seq_id;
952: -- Setting item attributes
953: l_return_Status := Set_Attributes(
954: l_oks_action_time_types_v_rec, -- IN
955: LDefOksActionTimeTypesVRec); -- OUT
956: --- If any errors happen abort API
957: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
995: RAISE OKC_API.G_EXCEPTION_ERROR;
996: END IF;
997: migrate(lx_oks_action_time_types_rec, LDefOksActionTimeTypesVRec);
998: -- Set OUT values
999: x_oks_action_time_types_v_rec := LDefOksActionTimeTypesVRec;
1000: x_return_status := l_return_status;
1001: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1002: EXCEPTION
1003: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1031: '_PVT'
1032: );
1033: END insert_row;
1034: -----------------------------------------------------------
1035: -- PL/SQL TBL insert_row for:OKS_ACTION_TIME_TYPES_V_TBL --
1036: -----------------------------------------------------------
1037: PROCEDURE insert_row(
1038: p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2,
1039: p_init_msg_list IN VARCHAR2,
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: x_msg_count OUT NOCOPY NUMBER,
1042: x_msg_data OUT NOCOPY VARCHAR2,
1043: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
1044: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType,
1045: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1046:
1047: l_api_version CONSTANT NUMBER := 1;
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: x_msg_count OUT NOCOPY NUMBER,
1042: x_msg_data OUT NOCOPY VARCHAR2,
1043: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
1044: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType,
1045: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1046:
1047: l_api_version CONSTANT NUMBER := 1;
1048: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1049: i NUMBER := 0;
1050: BEGIN
1051: OKC_API.init_msg_list(p_init_msg_list);
1052: -- Make sure PL/SQL table has records in it before passing
1053: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
1054: i := p_oks_action_time_types_v_tbl.FIRST;
1055: LOOP
1056: DECLARE
1057: l_error_rec OKC_API.ERROR_REC_TYPE;
1050: BEGIN
1051: OKC_API.init_msg_list(p_init_msg_list);
1052: -- Make sure PL/SQL table has records in it before passing
1053: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
1054: i := p_oks_action_time_types_v_tbl.FIRST;
1055: LOOP
1056: DECLARE
1057: l_error_rec OKC_API.ERROR_REC_TYPE;
1058: BEGIN
1064: p_init_msg_list => OKC_API.G_FALSE,
1065: x_return_status => l_error_rec.error_type,
1066: x_msg_count => l_error_rec.msg_count,
1067: x_msg_data => l_error_rec.msg_data,
1068: p_oks_action_time_types_v_rec => p_oks_action_time_types_v_tbl(i),
1069: x_oks_action_time_types_v_rec => x_oks_action_time_types_v_tbl(i));
1070: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1071: l_error_rec.sqlcode := SQLCODE;
1072: load_error_tbl(l_error_rec, px_error_tbl);
1065: x_return_status => l_error_rec.error_type,
1066: x_msg_count => l_error_rec.msg_count,
1067: x_msg_data => l_error_rec.msg_data,
1068: p_oks_action_time_types_v_rec => p_oks_action_time_types_v_tbl(i),
1069: x_oks_action_time_types_v_rec => x_oks_action_time_types_v_tbl(i));
1070: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1071: l_error_rec.sqlcode := SQLCODE;
1072: load_error_tbl(l_error_rec, px_error_tbl);
1073: ELSE
1087: l_error_rec.error_type := 'OTHERS';
1088: l_error_rec.sqlcode := SQLCODE;
1089: load_error_tbl(l_error_rec, px_error_tbl);
1090: END;
1091: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
1092: i := p_oks_action_time_types_v_tbl.NEXT(i);
1093: END LOOP;
1094: END IF;
1095: -- Loop through the error_tbl to find the error with the highest severity
1088: l_error_rec.sqlcode := SQLCODE;
1089: load_error_tbl(l_error_rec, px_error_tbl);
1090: END;
1091: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
1092: i := p_oks_action_time_types_v_tbl.NEXT(i);
1093: END LOOP;
1094: END IF;
1095: -- Loop through the error_tbl to find the error with the highest severity
1096: -- and return it.
1129: );
1130: END insert_row;
1131:
1132: -----------------------------------------------------------
1133: -- PL/SQL TBL insert_row for:OKS_ACTION_TIME_TYPES_V_TBL --
1134: -----------------------------------------------------------
1135: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
1136: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
1137: PROCEDURE insert_row(
1139: p_init_msg_list IN VARCHAR2,
1140: x_return_status OUT NOCOPY VARCHAR2,
1141: x_msg_count OUT NOCOPY NUMBER,
1142: x_msg_data OUT NOCOPY VARCHAR2,
1143: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
1144: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType) IS
1145:
1146: l_api_version CONSTANT NUMBER := 1;
1147: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1140: x_return_status OUT NOCOPY VARCHAR2,
1141: x_msg_count OUT NOCOPY NUMBER,
1142: x_msg_data OUT NOCOPY VARCHAR2,
1143: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
1144: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType) IS
1145:
1146: l_api_version CONSTANT NUMBER := 1;
1147: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1148: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1149: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1150: BEGIN
1151: OKC_API.init_msg_list(p_init_msg_list);
1152: -- Make sure PL/SQL table has records in it before passing
1153: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
1154: insert_row (
1155: p_api_version => p_api_version,
1156: p_init_msg_list => OKC_API.G_FALSE,
1157: x_return_status => x_return_status,
1156: p_init_msg_list => OKC_API.G_FALSE,
1157: x_return_status => x_return_status,
1158: x_msg_count => x_msg_count,
1159: x_msg_data => x_msg_data,
1160: p_oks_action_time_types_v_tbl => p_oks_action_time_types_v_tbl,
1161: x_oks_action_time_types_v_tbl => x_oks_action_time_types_v_tbl,
1162: px_error_tbl => l_error_tbl);
1163: END IF;
1164: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1157: x_return_status => x_return_status,
1158: x_msg_count => x_msg_count,
1159: x_msg_data => x_msg_data,
1160: p_oks_action_time_types_v_tbl => p_oks_action_time_types_v_tbl,
1161: x_oks_action_time_types_v_tbl => x_oks_action_time_types_v_tbl,
1162: px_error_tbl => l_error_tbl);
1163: END IF;
1164: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1165: EXCEPTION
1305: '_PVT'
1306: );
1307: END lock_row;
1308: -------------------------------------------
1309: -- lock_row for: OKS_ACTION_TIME_TYPES_V --
1310: -------------------------------------------
1311: PROCEDURE lock_row(
1312: p_api_version IN NUMBER,
1313: p_init_msg_list IN VARCHAR2,
1313: p_init_msg_list IN VARCHAR2,
1314: x_return_status OUT NOCOPY VARCHAR2,
1315: x_msg_count OUT NOCOPY NUMBER,
1316: x_msg_data OUT NOCOPY VARCHAR2,
1317: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType) IS
1318:
1319: l_api_version CONSTANT NUMBER := 1;
1320: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1321: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1335: END IF;
1336: -----------------------------------------
1337: -- Move VIEW record to "Child" records --
1338: -----------------------------------------
1339: migrate(p_oks_action_time_types_v_rec, l_oks_action_time_types_rec);
1340: ---------------------------------------------
1341: -- Call the LOCK_ROW for each child record --
1342: ---------------------------------------------
1343: lock_row(
1386: '_PVT'
1387: );
1388: END lock_row;
1389: ---------------------------------------------------------
1390: -- PL/SQL TBL lock_row for:OKS_ACTION_TIME_TYPES_V_TBL --
1391: ---------------------------------------------------------
1392: PROCEDURE lock_row(
1393: p_api_version IN NUMBER,
1394: p_init_msg_list IN VARCHAR2,
1394: p_init_msg_list IN VARCHAR2,
1395: x_return_status OUT NOCOPY VARCHAR2,
1396: x_msg_count OUT NOCOPY NUMBER,
1397: x_msg_data OUT NOCOPY VARCHAR2,
1398: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
1399: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1400:
1401: l_api_version CONSTANT NUMBER := 1;
1402: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1403: i NUMBER := 0;
1404: BEGIN
1405: OKC_API.init_msg_list(p_init_msg_list);
1406: -- Make sure PL/SQL table has recrods in it before passing
1407: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
1408: i := p_oks_action_time_types_v_tbl.FIRST;
1409: LOOP
1410: DECLARE
1411: l_error_rec OKC_API.ERROR_REC_TYPE;
1404: BEGIN
1405: OKC_API.init_msg_list(p_init_msg_list);
1406: -- Make sure PL/SQL table has recrods in it before passing
1407: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
1408: i := p_oks_action_time_types_v_tbl.FIRST;
1409: LOOP
1410: DECLARE
1411: l_error_rec OKC_API.ERROR_REC_TYPE;
1412: BEGIN
1418: p_init_msg_list => OKC_API.G_FALSE,
1419: x_return_status => l_error_rec.error_type,
1420: x_msg_count => l_error_rec.msg_count,
1421: x_msg_data => l_error_rec.msg_data,
1422: p_oks_action_time_types_v_rec => p_oks_action_time_types_v_tbl(i));
1423: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1424: l_error_rec.sqlcode := SQLCODE;
1425: load_error_tbl(l_error_rec, px_error_tbl);
1426: ELSE
1440: l_error_rec.error_type := 'OTHERS';
1441: l_error_rec.sqlcode := SQLCODE;
1442: load_error_tbl(l_error_rec, px_error_tbl);
1443: END;
1444: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
1445: i := p_oks_action_time_types_v_tbl.NEXT(i);
1446: END LOOP;
1447: END IF;
1448: -- Loop through the error_tbl to find the error with the highest severity
1441: l_error_rec.sqlcode := SQLCODE;
1442: load_error_tbl(l_error_rec, px_error_tbl);
1443: END;
1444: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
1445: i := p_oks_action_time_types_v_tbl.NEXT(i);
1446: END LOOP;
1447: END IF;
1448: -- Loop through the error_tbl to find the error with the highest severity
1449: -- and return it.
1481: '_PVT'
1482: );
1483: END lock_row;
1484: ---------------------------------------------------------
1485: -- PL/SQL TBL lock_row for:OKS_ACTION_TIME_TYPES_V_TBL --
1486: ---------------------------------------------------------
1487: PROCEDURE lock_row(
1488: p_api_version IN NUMBER,
1489: p_init_msg_list IN VARCHAR2,
1489: p_init_msg_list IN VARCHAR2,
1490: x_return_status OUT NOCOPY VARCHAR2,
1491: x_msg_count OUT NOCOPY NUMBER,
1492: x_msg_data OUT NOCOPY VARCHAR2,
1493: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType) IS
1494:
1495: l_api_version CONSTANT NUMBER := 1;
1496: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1497: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1498: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1499: BEGIN
1500: OKC_API.init_msg_list(p_init_msg_list);
1501: -- Make sure PL/SQL table has recrods in it before passing
1502: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
1503: lock_row(
1504: p_api_version => p_api_version,
1505: p_init_msg_list => OKC_API.G_FALSE,
1506: x_return_status => x_return_status,
1505: p_init_msg_list => OKC_API.G_FALSE,
1506: x_return_status => x_return_status,
1507: x_msg_count => x_msg_count,
1508: x_msg_data => x_msg_data,
1509: p_oks_action_time_types_v_tbl => p_oks_action_time_types_v_tbl,
1510: px_error_tbl => l_error_tbl);
1511: END IF;
1512: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1513: EXCEPTION
1745: '_PVT'
1746: );
1747: END update_row;
1748: --------------------------------------------
1749: -- update_row for:OKS_ACTION_TIME_TYPES_V --
1750: --------------------------------------------
1751: PROCEDURE update_row(
1752: p_api_version IN NUMBER,
1753: p_init_msg_list IN VARCHAR2,
1753: p_init_msg_list IN VARCHAR2,
1754: x_return_status OUT NOCOPY VARCHAR2,
1755: x_msg_count OUT NOCOPY NUMBER,
1756: x_msg_data OUT NOCOPY VARCHAR2,
1757: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
1758: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType) IS
1759:
1760: l_api_version CONSTANT NUMBER := 1;
1761: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1754: x_return_status OUT NOCOPY VARCHAR2,
1755: x_msg_count OUT NOCOPY NUMBER,
1756: x_msg_data OUT NOCOPY VARCHAR2,
1757: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
1758: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType) IS
1759:
1760: l_api_version CONSTANT NUMBER := 1;
1761: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1762: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1759:
1760: l_api_version CONSTANT NUMBER := 1;
1761: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1762: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1763: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
1764: LDefOksActionTimeTypesVRec OksActionTimeTypesVRecType;
1765: l_db_oks_action_tim2 OksActionTimeTypesVRecType;
1766: l_oks_action_time_types_rec oks_action_time_types_rec_type;
1767: lx_oks_action_time_types_rec oks_action_time_types_rec_type;
1768: -------------------------------
1769: -- FUNCTION fill_who_columns --
1770: -------------------------------
1771: FUNCTION fill_who_columns (
1772: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
1773: ) RETURN OksActionTimeTypesVRecType IS
1774: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
1775: BEGIN
1776: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := SYSDATE;
1770: -------------------------------
1771: FUNCTION fill_who_columns (
1772: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
1773: ) RETURN OksActionTimeTypesVRecType IS
1774: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
1775: BEGIN
1776: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := SYSDATE;
1777: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1778: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1772: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType
1773: ) RETURN OksActionTimeTypesVRecType IS
1774: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
1775: BEGIN
1776: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := SYSDATE;
1777: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1778: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1779: RETURN(l_oks_action_time_types_v_rec);
1780: END fill_who_columns;
1773: ) RETURN OksActionTimeTypesVRecType IS
1774: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
1775: BEGIN
1776: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := SYSDATE;
1777: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1778: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1779: RETURN(l_oks_action_time_types_v_rec);
1780: END fill_who_columns;
1781: ----------------------------------
1774: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
1775: BEGIN
1776: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := SYSDATE;
1777: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1778: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1779: RETURN(l_oks_action_time_types_v_rec);
1780: END fill_who_columns;
1781: ----------------------------------
1782: -- FUNCTION populate_new_record --
1775: BEGIN
1776: l_oks_action_time_types_v_rec.LAST_UPDATE_DATE := SYSDATE;
1777: l_oks_action_time_types_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1778: l_oks_action_time_types_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1779: RETURN(l_oks_action_time_types_v_rec);
1780: END fill_who_columns;
1781: ----------------------------------
1782: -- FUNCTION populate_new_record --
1783: ----------------------------------
1781: ----------------------------------
1782: -- FUNCTION populate_new_record --
1783: ----------------------------------
1784: FUNCTION populate_new_record (
1785: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
1786: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
1787: ) RETURN VARCHAR2 IS
1788: l_row_notfound BOOLEAN := TRUE;
1789: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1782: -- FUNCTION populate_new_record --
1783: ----------------------------------
1784: FUNCTION populate_new_record (
1785: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
1786: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
1787: ) RETURN VARCHAR2 IS
1788: l_row_notfound BOOLEAN := TRUE;
1789: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1790: BEGIN
1787: ) RETURN VARCHAR2 IS
1788: l_row_notfound BOOLEAN := TRUE;
1789: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1790: BEGIN
1791: x_oks_action_time_types_v_rec := p_oks_action_time_types_v_rec;
1792: -- Get current database values
1793: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1794: -- so it may be verified through LOCK_ROW.
1795: l_db_oks_action_tim2 := get_rec(p_oks_action_time_types_v_rec, l_return_status);
1791: x_oks_action_time_types_v_rec := p_oks_action_time_types_v_rec;
1792: -- Get current database values
1793: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1794: -- so it may be verified through LOCK_ROW.
1795: l_db_oks_action_tim2 := get_rec(p_oks_action_time_types_v_rec, l_return_status);
1796: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1797: IF (x_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM)
1798: THEN
1799: x_oks_action_time_types_v_rec.id := l_db_oks_action_tim2.id;
1793: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1794: -- so it may be verified through LOCK_ROW.
1795: l_db_oks_action_tim2 := get_rec(p_oks_action_time_types_v_rec, l_return_status);
1796: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1797: IF (x_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM)
1798: THEN
1799: x_oks_action_time_types_v_rec.id := l_db_oks_action_tim2.id;
1800: END IF;
1801: IF (x_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM)
1795: l_db_oks_action_tim2 := get_rec(p_oks_action_time_types_v_rec, l_return_status);
1796: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1797: IF (x_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM)
1798: THEN
1799: x_oks_action_time_types_v_rec.id := l_db_oks_action_tim2.id;
1800: END IF;
1801: IF (x_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM)
1802: THEN
1803: x_oks_action_time_types_v_rec.cle_id := l_db_oks_action_tim2.cle_id;
1797: IF (x_oks_action_time_types_v_rec.id = OKC_API.G_MISS_NUM)
1798: THEN
1799: x_oks_action_time_types_v_rec.id := l_db_oks_action_tim2.id;
1800: END IF;
1801: IF (x_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM)
1802: THEN
1803: x_oks_action_time_types_v_rec.cle_id := l_db_oks_action_tim2.cle_id;
1804: END IF;
1805: IF (x_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1799: x_oks_action_time_types_v_rec.id := l_db_oks_action_tim2.id;
1800: END IF;
1801: IF (x_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM)
1802: THEN
1803: x_oks_action_time_types_v_rec.cle_id := l_db_oks_action_tim2.cle_id;
1804: END IF;
1805: IF (x_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1806: THEN
1807: x_oks_action_time_types_v_rec.dnz_chr_id := l_db_oks_action_tim2.dnz_chr_id;
1801: IF (x_oks_action_time_types_v_rec.cle_id = OKC_API.G_MISS_NUM)
1802: THEN
1803: x_oks_action_time_types_v_rec.cle_id := l_db_oks_action_tim2.cle_id;
1804: END IF;
1805: IF (x_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1806: THEN
1807: x_oks_action_time_types_v_rec.dnz_chr_id := l_db_oks_action_tim2.dnz_chr_id;
1808: END IF;
1809: IF (x_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR)
1803: x_oks_action_time_types_v_rec.cle_id := l_db_oks_action_tim2.cle_id;
1804: END IF;
1805: IF (x_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1806: THEN
1807: x_oks_action_time_types_v_rec.dnz_chr_id := l_db_oks_action_tim2.dnz_chr_id;
1808: END IF;
1809: IF (x_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR)
1810: THEN
1811: x_oks_action_time_types_v_rec.action_type_code := l_db_oks_action_tim2.action_type_code;
1805: IF (x_oks_action_time_types_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1806: THEN
1807: x_oks_action_time_types_v_rec.dnz_chr_id := l_db_oks_action_tim2.dnz_chr_id;
1808: END IF;
1809: IF (x_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR)
1810: THEN
1811: x_oks_action_time_types_v_rec.action_type_code := l_db_oks_action_tim2.action_type_code;
1812: END IF;
1813: IF (x_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1807: x_oks_action_time_types_v_rec.dnz_chr_id := l_db_oks_action_tim2.dnz_chr_id;
1808: END IF;
1809: IF (x_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR)
1810: THEN
1811: x_oks_action_time_types_v_rec.action_type_code := l_db_oks_action_tim2.action_type_code;
1812: END IF;
1813: IF (x_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1814: THEN
1815: x_oks_action_time_types_v_rec.security_group_id := l_db_oks_action_tim2.security_group_id;
1809: IF (x_oks_action_time_types_v_rec.action_type_code = OKC_API.G_MISS_CHAR)
1810: THEN
1811: x_oks_action_time_types_v_rec.action_type_code := l_db_oks_action_tim2.action_type_code;
1812: END IF;
1813: IF (x_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1814: THEN
1815: x_oks_action_time_types_v_rec.security_group_id := l_db_oks_action_tim2.security_group_id;
1816: END IF;
1817: IF (x_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1811: x_oks_action_time_types_v_rec.action_type_code := l_db_oks_action_tim2.action_type_code;
1812: END IF;
1813: IF (x_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1814: THEN
1815: x_oks_action_time_types_v_rec.security_group_id := l_db_oks_action_tim2.security_group_id;
1816: END IF;
1817: IF (x_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1818: THEN
1819: x_oks_action_time_types_v_rec.program_application_id := l_db_oks_action_tim2.program_application_id;
1813: IF (x_oks_action_time_types_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1814: THEN
1815: x_oks_action_time_types_v_rec.security_group_id := l_db_oks_action_tim2.security_group_id;
1816: END IF;
1817: IF (x_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1818: THEN
1819: x_oks_action_time_types_v_rec.program_application_id := l_db_oks_action_tim2.program_application_id;
1820: END IF;
1821: IF (x_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM)
1815: x_oks_action_time_types_v_rec.security_group_id := l_db_oks_action_tim2.security_group_id;
1816: END IF;
1817: IF (x_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1818: THEN
1819: x_oks_action_time_types_v_rec.program_application_id := l_db_oks_action_tim2.program_application_id;
1820: END IF;
1821: IF (x_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM)
1822: THEN
1823: x_oks_action_time_types_v_rec.program_id := l_db_oks_action_tim2.program_id;
1817: IF (x_oks_action_time_types_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1818: THEN
1819: x_oks_action_time_types_v_rec.program_application_id := l_db_oks_action_tim2.program_application_id;
1820: END IF;
1821: IF (x_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM)
1822: THEN
1823: x_oks_action_time_types_v_rec.program_id := l_db_oks_action_tim2.program_id;
1824: END IF;
1825: IF (x_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1819: x_oks_action_time_types_v_rec.program_application_id := l_db_oks_action_tim2.program_application_id;
1820: END IF;
1821: IF (x_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM)
1822: THEN
1823: x_oks_action_time_types_v_rec.program_id := l_db_oks_action_tim2.program_id;
1824: END IF;
1825: IF (x_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1826: THEN
1827: x_oks_action_time_types_v_rec.program_update_date := l_db_oks_action_tim2.program_update_date;
1821: IF (x_oks_action_time_types_v_rec.program_id = OKC_API.G_MISS_NUM)
1822: THEN
1823: x_oks_action_time_types_v_rec.program_id := l_db_oks_action_tim2.program_id;
1824: END IF;
1825: IF (x_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1826: THEN
1827: x_oks_action_time_types_v_rec.program_update_date := l_db_oks_action_tim2.program_update_date;
1828: END IF;
1829: IF (x_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM)
1823: x_oks_action_time_types_v_rec.program_id := l_db_oks_action_tim2.program_id;
1824: END IF;
1825: IF (x_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1826: THEN
1827: x_oks_action_time_types_v_rec.program_update_date := l_db_oks_action_tim2.program_update_date;
1828: END IF;
1829: IF (x_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM)
1830: THEN
1831: x_oks_action_time_types_v_rec.request_id := l_db_oks_action_tim2.request_id;
1825: IF (x_oks_action_time_types_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1826: THEN
1827: x_oks_action_time_types_v_rec.program_update_date := l_db_oks_action_tim2.program_update_date;
1828: END IF;
1829: IF (x_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM)
1830: THEN
1831: x_oks_action_time_types_v_rec.request_id := l_db_oks_action_tim2.request_id;
1832: END IF;
1833: IF (x_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM)
1827: x_oks_action_time_types_v_rec.program_update_date := l_db_oks_action_tim2.program_update_date;
1828: END IF;
1829: IF (x_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM)
1830: THEN
1831: x_oks_action_time_types_v_rec.request_id := l_db_oks_action_tim2.request_id;
1832: END IF;
1833: IF (x_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM)
1834: THEN
1835: x_oks_action_time_types_v_rec.created_by := l_db_oks_action_tim2.created_by;
1829: IF (x_oks_action_time_types_v_rec.request_id = OKC_API.G_MISS_NUM)
1830: THEN
1831: x_oks_action_time_types_v_rec.request_id := l_db_oks_action_tim2.request_id;
1832: END IF;
1833: IF (x_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM)
1834: THEN
1835: x_oks_action_time_types_v_rec.created_by := l_db_oks_action_tim2.created_by;
1836: END IF;
1837: IF (x_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE)
1831: x_oks_action_time_types_v_rec.request_id := l_db_oks_action_tim2.request_id;
1832: END IF;
1833: IF (x_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM)
1834: THEN
1835: x_oks_action_time_types_v_rec.created_by := l_db_oks_action_tim2.created_by;
1836: END IF;
1837: IF (x_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE)
1838: THEN
1839: x_oks_action_time_types_v_rec.creation_date := l_db_oks_action_tim2.creation_date;
1833: IF (x_oks_action_time_types_v_rec.created_by = OKC_API.G_MISS_NUM)
1834: THEN
1835: x_oks_action_time_types_v_rec.created_by := l_db_oks_action_tim2.created_by;
1836: END IF;
1837: IF (x_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE)
1838: THEN
1839: x_oks_action_time_types_v_rec.creation_date := l_db_oks_action_tim2.creation_date;
1840: END IF;
1841: IF (x_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1835: x_oks_action_time_types_v_rec.created_by := l_db_oks_action_tim2.created_by;
1836: END IF;
1837: IF (x_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE)
1838: THEN
1839: x_oks_action_time_types_v_rec.creation_date := l_db_oks_action_tim2.creation_date;
1840: END IF;
1841: IF (x_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1842: THEN
1843: x_oks_action_time_types_v_rec.last_updated_by := l_db_oks_action_tim2.last_updated_by;
1837: IF (x_oks_action_time_types_v_rec.creation_date = OKC_API.G_MISS_DATE)
1838: THEN
1839: x_oks_action_time_types_v_rec.creation_date := l_db_oks_action_tim2.creation_date;
1840: END IF;
1841: IF (x_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1842: THEN
1843: x_oks_action_time_types_v_rec.last_updated_by := l_db_oks_action_tim2.last_updated_by;
1844: END IF;
1845: IF (x_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1839: x_oks_action_time_types_v_rec.creation_date := l_db_oks_action_tim2.creation_date;
1840: END IF;
1841: IF (x_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1842: THEN
1843: x_oks_action_time_types_v_rec.last_updated_by := l_db_oks_action_tim2.last_updated_by;
1844: END IF;
1845: IF (x_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1846: THEN
1847: x_oks_action_time_types_v_rec.last_update_date := l_db_oks_action_tim2.last_update_date;
1841: IF (x_oks_action_time_types_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1842: THEN
1843: x_oks_action_time_types_v_rec.last_updated_by := l_db_oks_action_tim2.last_updated_by;
1844: END IF;
1845: IF (x_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1846: THEN
1847: x_oks_action_time_types_v_rec.last_update_date := l_db_oks_action_tim2.last_update_date;
1848: END IF;
1849: IF (x_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1843: x_oks_action_time_types_v_rec.last_updated_by := l_db_oks_action_tim2.last_updated_by;
1844: END IF;
1845: IF (x_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1846: THEN
1847: x_oks_action_time_types_v_rec.last_update_date := l_db_oks_action_tim2.last_update_date;
1848: END IF;
1849: IF (x_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1850: THEN
1851: x_oks_action_time_types_v_rec.last_update_login := l_db_oks_action_tim2.last_update_login;
1845: IF (x_oks_action_time_types_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1846: THEN
1847: x_oks_action_time_types_v_rec.last_update_date := l_db_oks_action_tim2.last_update_date;
1848: END IF;
1849: IF (x_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1850: THEN
1851: x_oks_action_time_types_v_rec.last_update_login := l_db_oks_action_tim2.last_update_login;
1852: END IF;
1853: -- R12 Data Model Changes 4485150 Start
1847: x_oks_action_time_types_v_rec.last_update_date := l_db_oks_action_tim2.last_update_date;
1848: END IF;
1849: IF (x_oks_action_time_types_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1850: THEN
1851: x_oks_action_time_types_v_rec.last_update_login := l_db_oks_action_tim2.last_update_login;
1852: END IF;
1853: -- R12 Data Model Changes 4485150 Start
1854: IF (x_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1855: THEN
1850: THEN
1851: x_oks_action_time_types_v_rec.last_update_login := l_db_oks_action_tim2.last_update_login;
1852: END IF;
1853: -- R12 Data Model Changes 4485150 Start
1854: IF (x_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1855: THEN
1856: x_oks_action_time_types_v_rec.orig_system_id1 := l_db_oks_action_tim2.orig_system_id1;
1857: END IF;
1858: IF (x_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1852: END IF;
1853: -- R12 Data Model Changes 4485150 Start
1854: IF (x_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1855: THEN
1856: x_oks_action_time_types_v_rec.orig_system_id1 := l_db_oks_action_tim2.orig_system_id1;
1857: END IF;
1858: IF (x_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1859: THEN
1860: x_oks_action_time_types_v_rec.orig_system_reference1 := l_db_oks_action_tim2.orig_system_reference1;
1854: IF (x_oks_action_time_types_v_rec.orig_system_id1 = OKC_API.G_MISS_NUM)
1855: THEN
1856: x_oks_action_time_types_v_rec.orig_system_id1 := l_db_oks_action_tim2.orig_system_id1;
1857: END IF;
1858: IF (x_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1859: THEN
1860: x_oks_action_time_types_v_rec.orig_system_reference1 := l_db_oks_action_tim2.orig_system_reference1;
1861: END IF;
1862: IF (x_oks_action_time_types_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1856: x_oks_action_time_types_v_rec.orig_system_id1 := l_db_oks_action_tim2.orig_system_id1;
1857: END IF;
1858: IF (x_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1859: THEN
1860: x_oks_action_time_types_v_rec.orig_system_reference1 := l_db_oks_action_tim2.orig_system_reference1;
1861: END IF;
1862: IF (x_oks_action_time_types_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1863: THEN
1864: x_oks_action_time_types_v_rec.orig_system_source_code := l_db_oks_action_tim2.orig_system_source_code;
1858: IF (x_oks_action_time_types_v_rec.orig_system_reference1 = OKC_API.G_MISS_CHAR)
1859: THEN
1860: x_oks_action_time_types_v_rec.orig_system_reference1 := l_db_oks_action_tim2.orig_system_reference1;
1861: END IF;
1862: IF (x_oks_action_time_types_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1863: THEN
1864: x_oks_action_time_types_v_rec.orig_system_source_code := l_db_oks_action_tim2.orig_system_source_code;
1865: END IF;
1866: -- R12 Data Model Changes 4485150 End
1860: x_oks_action_time_types_v_rec.orig_system_reference1 := l_db_oks_action_tim2.orig_system_reference1;
1861: END IF;
1862: IF (x_oks_action_time_types_v_rec.orig_system_source_code = OKC_API.G_MISS_CHAR)
1863: THEN
1864: x_oks_action_time_types_v_rec.orig_system_source_code := l_db_oks_action_tim2.orig_system_source_code;
1865: END IF;
1866: -- R12 Data Model Changes 4485150 End
1867: END IF;
1868: RETURN(l_return_status);
1867: END IF;
1868: RETURN(l_return_status);
1869: END populate_new_record;
1870: ------------------------------------------------
1871: -- Set_Attributes for:OKS_ACTION_TIME_TYPES_V --
1872: ------------------------------------------------
1873: FUNCTION Set_Attributes (
1874: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
1875: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
1870: ------------------------------------------------
1871: -- Set_Attributes for:OKS_ACTION_TIME_TYPES_V --
1872: ------------------------------------------------
1873: FUNCTION Set_Attributes (
1874: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
1875: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
1876: ) RETURN VARCHAR2 IS
1877: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1878: BEGIN
1871: -- Set_Attributes for:OKS_ACTION_TIME_TYPES_V --
1872: ------------------------------------------------
1873: FUNCTION Set_Attributes (
1874: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType,
1875: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
1876: ) RETURN VARCHAR2 IS
1877: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1878: BEGIN
1879: x_oks_action_time_types_v_rec := p_oks_action_time_types_v_rec;
1875: x_oks_action_time_types_v_rec OUT NOCOPY OksActionTimeTypesVRecType
1876: ) RETURN VARCHAR2 IS
1877: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1878: BEGIN
1879: x_oks_action_time_types_v_rec := p_oks_action_time_types_v_rec;
1880: RETURN(l_return_status);
1881: END Set_Attributes;
1882: BEGIN
1883: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1893: RAISE OKC_API.G_EXCEPTION_ERROR;
1894: END IF;
1895: --- Setting item attributes
1896: l_return_status := Set_Attributes(
1897: p_oks_action_time_types_v_rec, -- IN
1898: x_oks_action_time_types_v_rec); -- OUT
1899: --- If any errors happen abort API
1900: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1894: END IF;
1895: --- Setting item attributes
1896: l_return_status := Set_Attributes(
1897: p_oks_action_time_types_v_rec, -- IN
1898: x_oks_action_time_types_v_rec); -- OUT
1899: --- If any errors happen abort API
1900: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1903: RAISE OKC_API.G_EXCEPTION_ERROR;
1904: END IF;
1905: l_return_status := populate_new_record(l_oks_action_time_types_v_rec, LDefOksActionTimeTypesVRec);
1906: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1907: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1908: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1909: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: p_init_msg_list => p_init_msg_list,
1931: x_return_status => l_return_status,
1932: x_msg_count => x_msg_count,
1933: x_msg_data => x_msg_data,
1934: p_oks_action_time_types_v_rec => p_oks_action_time_types_v_rec);
1935: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1936: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1937: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1938: RAISE OKC_API.G_EXCEPTION_ERROR;
1958: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1959: RAISE OKC_API.G_EXCEPTION_ERROR;
1960: END IF;
1961: migrate(lx_oks_action_time_types_rec, LDefOksActionTimeTypesVRec);
1962: x_oks_action_time_types_v_rec := LDefOksActionTimeTypesVRec;
1963: x_return_status := l_return_status;
1964: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1965: EXCEPTION
1966: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1994: '_PVT'
1995: );
1996: END update_row;
1997: -----------------------------------------------------------
1998: -- PL/SQL TBL update_row for:oks_action_time_types_v_tbl --
1999: -----------------------------------------------------------
2000: PROCEDURE update_row(
2001: p_api_version IN NUMBER,
2002: p_init_msg_list IN VARCHAR2,
2002: p_init_msg_list IN VARCHAR2,
2003: x_return_status OUT NOCOPY VARCHAR2,
2004: x_msg_count OUT NOCOPY NUMBER,
2005: x_msg_data OUT NOCOPY VARCHAR2,
2006: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
2007: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType,
2008: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2009:
2010: l_api_version CONSTANT NUMBER := 1;
2003: x_return_status OUT NOCOPY VARCHAR2,
2004: x_msg_count OUT NOCOPY NUMBER,
2005: x_msg_data OUT NOCOPY VARCHAR2,
2006: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
2007: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType,
2008: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2009:
2010: l_api_version CONSTANT NUMBER := 1;
2011: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2012: i NUMBER := 0;
2013: BEGIN
2014: OKC_API.init_msg_list(p_init_msg_list);
2015: -- Make sure PL/SQL table has records in it before passing
2016: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
2017: i := p_oks_action_time_types_v_tbl.FIRST;
2018: LOOP
2019: DECLARE
2020: l_error_rec OKC_API.ERROR_REC_TYPE;
2013: BEGIN
2014: OKC_API.init_msg_list(p_init_msg_list);
2015: -- Make sure PL/SQL table has records in it before passing
2016: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
2017: i := p_oks_action_time_types_v_tbl.FIRST;
2018: LOOP
2019: DECLARE
2020: l_error_rec OKC_API.ERROR_REC_TYPE;
2021: BEGIN
2027: p_init_msg_list => OKC_API.G_FALSE,
2028: x_return_status => l_error_rec.error_type,
2029: x_msg_count => l_error_rec.msg_count,
2030: x_msg_data => l_error_rec.msg_data,
2031: p_oks_action_time_types_v_rec => p_oks_action_time_types_v_tbl(i),
2032: x_oks_action_time_types_v_rec => x_oks_action_time_types_v_tbl(i));
2033: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2034: l_error_rec.sqlcode := SQLCODE;
2035: load_error_tbl(l_error_rec, px_error_tbl);
2028: x_return_status => l_error_rec.error_type,
2029: x_msg_count => l_error_rec.msg_count,
2030: x_msg_data => l_error_rec.msg_data,
2031: p_oks_action_time_types_v_rec => p_oks_action_time_types_v_tbl(i),
2032: x_oks_action_time_types_v_rec => x_oks_action_time_types_v_tbl(i));
2033: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2034: l_error_rec.sqlcode := SQLCODE;
2035: load_error_tbl(l_error_rec, px_error_tbl);
2036: ELSE
2050: l_error_rec.error_type := 'OTHERS';
2051: l_error_rec.sqlcode := SQLCODE;
2052: load_error_tbl(l_error_rec, px_error_tbl);
2053: END;
2054: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
2055: i := p_oks_action_time_types_v_tbl.NEXT(i);
2056: END LOOP;
2057: END IF;
2058: -- Loop through the error_tbl to find the error with the highest severity
2051: l_error_rec.sqlcode := SQLCODE;
2052: load_error_tbl(l_error_rec, px_error_tbl);
2053: END;
2054: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
2055: i := p_oks_action_time_types_v_tbl.NEXT(i);
2056: END LOOP;
2057: END IF;
2058: -- Loop through the error_tbl to find the error with the highest severity
2059: -- and return it.
2092: );
2093: END update_row;
2094:
2095: -----------------------------------------------------------
2096: -- PL/SQL TBL update_row for:OKS_ACTION_TIME_TYPES_V_TBL --
2097: -----------------------------------------------------------
2098: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
2099: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
2100: PROCEDURE update_row(
2102: p_init_msg_list IN VARCHAR2,
2103: x_return_status OUT NOCOPY VARCHAR2,
2104: x_msg_count OUT NOCOPY NUMBER,
2105: x_msg_data OUT NOCOPY VARCHAR2,
2106: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
2107: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType) IS
2108:
2109: l_api_version CONSTANT NUMBER := 1;
2110: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2103: x_return_status OUT NOCOPY VARCHAR2,
2104: x_msg_count OUT NOCOPY NUMBER,
2105: x_msg_data OUT NOCOPY VARCHAR2,
2106: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
2107: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType) IS
2108:
2109: l_api_version CONSTANT NUMBER := 1;
2110: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2111: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2112: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2113: BEGIN
2114: OKC_API.init_msg_list(p_init_msg_list);
2115: -- Make sure PL/SQL table has records in it before passing
2116: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
2117: update_row (
2118: p_api_version => p_api_version,
2119: p_init_msg_list => OKC_API.G_FALSE,
2120: x_return_status => x_return_status,
2119: p_init_msg_list => OKC_API.G_FALSE,
2120: x_return_status => x_return_status,
2121: x_msg_count => x_msg_count,
2122: x_msg_data => x_msg_data,
2123: p_oks_action_time_types_v_tbl => p_oks_action_time_types_v_tbl,
2124: x_oks_action_time_types_v_tbl => x_oks_action_time_types_v_tbl,
2125: px_error_tbl => l_error_tbl);
2126: END IF;
2127: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2120: x_return_status => x_return_status,
2121: x_msg_count => x_msg_count,
2122: x_msg_data => x_msg_data,
2123: p_oks_action_time_types_v_tbl => p_oks_action_time_types_v_tbl,
2124: x_oks_action_time_types_v_tbl => x_oks_action_time_types_v_tbl,
2125: px_error_tbl => l_error_tbl);
2126: END IF;
2127: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2128: EXCEPTION
2224: '_PVT'
2225: );
2226: END delete_row;
2227: --------------------------------------------
2228: -- delete_row for:OKS_ACTION_TIME_TYPES_V --
2229: --------------------------------------------
2230: PROCEDURE delete_row(
2231: p_api_version IN NUMBER,
2232: p_init_msg_list IN VARCHAR2,
2232: p_init_msg_list IN VARCHAR2,
2233: x_return_status OUT NOCOPY VARCHAR2,
2234: x_msg_count OUT NOCOPY NUMBER,
2235: x_msg_data OUT NOCOPY VARCHAR2,
2236: p_oks_action_time_types_v_rec IN OksActionTimeTypesVRecType) IS
2237:
2238: l_api_version CONSTANT NUMBER := 1;
2239: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2237:
2238: l_api_version CONSTANT NUMBER := 1;
2239: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2241: l_oks_action_time_types_v_rec OksActionTimeTypesVRecType := p_oks_action_time_types_v_rec;
2242: l_oks_action_time_types_rec oks_action_time_types_rec_type;
2243: BEGIN
2244: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2245: G_PKG_NAME,
2255: END IF;
2256: -----------------------------------------
2257: -- Move VIEW record to "Child" records --
2258: -----------------------------------------
2259: migrate(l_oks_action_time_types_v_rec, l_oks_action_time_types_rec);
2260: -----------------------------------------------
2261: -- Call the DELETE_ROW for each child record --
2262: -----------------------------------------------
2263: delete_row(
2306: '_PVT'
2307: );
2308: END delete_row;
2309: -------------------------------------------------------
2310: -- PL/SQL TBL delete_row for:OKS_ACTION_TIME_TYPES_V --
2311: -------------------------------------------------------
2312: PROCEDURE delete_row(
2313: p_api_version IN NUMBER,
2314: p_init_msg_list IN VARCHAR2,
2314: p_init_msg_list IN VARCHAR2,
2315: x_return_status OUT NOCOPY VARCHAR2,
2316: x_msg_count OUT NOCOPY NUMBER,
2317: x_msg_data OUT NOCOPY VARCHAR2,
2318: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
2319: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2320:
2321: l_api_version CONSTANT NUMBER := 1;
2322: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2323: i NUMBER := 0;
2324: BEGIN
2325: OKC_API.init_msg_list(p_init_msg_list);
2326: -- Make sure PL/SQL table has records in it before passing
2327: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
2328: i := p_oks_action_time_types_v_tbl.FIRST;
2329: LOOP
2330: DECLARE
2331: l_error_rec OKC_API.ERROR_REC_TYPE;
2324: BEGIN
2325: OKC_API.init_msg_list(p_init_msg_list);
2326: -- Make sure PL/SQL table has records in it before passing
2327: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
2328: i := p_oks_action_time_types_v_tbl.FIRST;
2329: LOOP
2330: DECLARE
2331: l_error_rec OKC_API.ERROR_REC_TYPE;
2332: BEGIN
2338: p_init_msg_list => OKC_API.G_FALSE,
2339: x_return_status => l_error_rec.error_type,
2340: x_msg_count => l_error_rec.msg_count,
2341: x_msg_data => l_error_rec.msg_data,
2342: p_oks_action_time_types_v_rec => p_oks_action_time_types_v_tbl(i));
2343: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2344: l_error_rec.sqlcode := SQLCODE;
2345: load_error_tbl(l_error_rec, px_error_tbl);
2346: ELSE
2360: l_error_rec.error_type := 'OTHERS';
2361: l_error_rec.sqlcode := SQLCODE;
2362: load_error_tbl(l_error_rec, px_error_tbl);
2363: END;
2364: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
2365: i := p_oks_action_time_types_v_tbl.NEXT(i);
2366: END LOOP;
2367: END IF;
2368: -- Loop through the error_tbl to find the error with the highest severity
2361: l_error_rec.sqlcode := SQLCODE;
2362: load_error_tbl(l_error_rec, px_error_tbl);
2363: END;
2364: EXIT WHEN (i = p_oks_action_time_types_v_tbl.LAST);
2365: i := p_oks_action_time_types_v_tbl.NEXT(i);
2366: END LOOP;
2367: END IF;
2368: -- Loop through the error_tbl to find the error with the highest severity
2369: -- and return it.
2402: );
2403: END delete_row;
2404:
2405: -------------------------------------------------------
2406: -- PL/SQL TBL delete_row for:OKS_ACTION_TIME_TYPES_V --
2407: -------------------------------------------------------
2408: PROCEDURE delete_row(
2409: p_api_version IN NUMBER,
2410: p_init_msg_list IN VARCHAR2,
2410: p_init_msg_list IN VARCHAR2,
2411: x_return_status OUT NOCOPY VARCHAR2,
2412: x_msg_count OUT NOCOPY NUMBER,
2413: x_msg_data OUT NOCOPY VARCHAR2,
2414: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType) IS
2415:
2416: l_api_version CONSTANT NUMBER := 1;
2417: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2418: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2419: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2420: BEGIN
2421: OKC_API.init_msg_list(p_init_msg_list);
2422: -- Make sure PL/SQL table has records in it before passing
2423: IF (p_oks_action_time_types_v_tbl.COUNT > 0) THEN
2424: delete_row (
2425: p_api_version => p_api_version,
2426: p_init_msg_list => OKC_API.G_FALSE,
2427: x_return_status => x_return_status,
2426: p_init_msg_list => OKC_API.G_FALSE,
2427: x_return_status => x_return_status,
2428: x_msg_count => x_msg_count,
2429: x_msg_data => x_msg_data,
2430: p_oks_action_time_types_v_tbl => p_oks_action_time_types_v_tbl,
2431: px_error_tbl => l_error_tbl);
2432: END IF;
2433: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2434: EXCEPTION