[Home] [Help]
92: null;
93: END api_copy;
94:
95: ---------------------------------------------------------------------------
96: -- FUNCTION get_rec for: OKC_PH_LINE_BREAKS_V
97: ---------------------------------------------------------------------------
98: FUNCTION get_rec (
99: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
100: x_no_data_found OUT NOCOPY BOOLEAN
95: ---------------------------------------------------------------------------
96: -- FUNCTION get_rec for: OKC_PH_LINE_BREAKS_V
97: ---------------------------------------------------------------------------
98: FUNCTION get_rec (
99: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
100: x_no_data_found OUT NOCOPY BOOLEAN
101: ) RETURN okc_ph_line_breaks_v_rec_type IS
102: CURSOR okc_phlbv_pk_csr (p_id IN NUMBER) IS
103: SELECT
97: ---------------------------------------------------------------------------
98: FUNCTION get_rec (
99: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
100: x_no_data_found OUT NOCOPY BOOLEAN
101: ) RETURN okc_ph_line_breaks_v_rec_type IS
102: CURSOR okc_phlbv_pk_csr (p_id IN NUMBER) IS
103: SELECT
104: ID,
105: CLE_ID,
122: QP_REFERENCE_ID,
123: SHIP_TO_ORGANIZATION_ID,
124: SHIP_TO_LOCATION_ID,
125: LAST_UPDATE_LOGIN
126: FROM Okc_Ph_Line_Breaks_V
127: WHERE okc_ph_line_breaks_v.id = p_id;
128: l_okc_phlbv_pk okc_phlbv_pk_csr%ROWTYPE;
129: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
130: BEGIN
123: SHIP_TO_ORGANIZATION_ID,
124: SHIP_TO_LOCATION_ID,
125: LAST_UPDATE_LOGIN
126: FROM Okc_Ph_Line_Breaks_V
127: WHERE okc_ph_line_breaks_v.id = p_id;
128: l_okc_phlbv_pk okc_phlbv_pk_csr%ROWTYPE;
129: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
130: BEGIN
131: x_no_data_found := TRUE;
125: LAST_UPDATE_LOGIN
126: FROM Okc_Ph_Line_Breaks_V
127: WHERE okc_ph_line_breaks_v.id = p_id;
128: l_okc_phlbv_pk okc_phlbv_pk_csr%ROWTYPE;
129: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
130: BEGIN
131: x_no_data_found := TRUE;
132: -- Get current database values
133: OPEN okc_phlbv_pk_csr (p_okc_ph_line_breaks_v_rec.id);
129: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
130: BEGIN
131: x_no_data_found := TRUE;
132: -- Get current database values
133: OPEN okc_phlbv_pk_csr (p_okc_ph_line_breaks_v_rec.id);
134: FETCH okc_phlbv_pk_csr INTO
135: l_okc_ph_line_breaks_v_rec.id,
136: l_okc_ph_line_breaks_v_rec.cle_id,
137: l_okc_ph_line_breaks_v_rec.value_from,
131: x_no_data_found := TRUE;
132: -- Get current database values
133: OPEN okc_phlbv_pk_csr (p_okc_ph_line_breaks_v_rec.id);
134: FETCH okc_phlbv_pk_csr INTO
135: l_okc_ph_line_breaks_v_rec.id,
136: l_okc_ph_line_breaks_v_rec.cle_id,
137: l_okc_ph_line_breaks_v_rec.value_from,
138: l_okc_ph_line_breaks_v_rec.value_to,
139: l_okc_ph_line_breaks_v_rec.pricing_type,
132: -- Get current database values
133: OPEN okc_phlbv_pk_csr (p_okc_ph_line_breaks_v_rec.id);
134: FETCH okc_phlbv_pk_csr INTO
135: l_okc_ph_line_breaks_v_rec.id,
136: l_okc_ph_line_breaks_v_rec.cle_id,
137: l_okc_ph_line_breaks_v_rec.value_from,
138: l_okc_ph_line_breaks_v_rec.value_to,
139: l_okc_ph_line_breaks_v_rec.pricing_type,
140: l_okc_ph_line_breaks_v_rec.value,
133: OPEN okc_phlbv_pk_csr (p_okc_ph_line_breaks_v_rec.id);
134: FETCH okc_phlbv_pk_csr INTO
135: l_okc_ph_line_breaks_v_rec.id,
136: l_okc_ph_line_breaks_v_rec.cle_id,
137: l_okc_ph_line_breaks_v_rec.value_from,
138: l_okc_ph_line_breaks_v_rec.value_to,
139: l_okc_ph_line_breaks_v_rec.pricing_type,
140: l_okc_ph_line_breaks_v_rec.value,
141: l_okc_ph_line_breaks_v_rec.start_date,
134: FETCH okc_phlbv_pk_csr INTO
135: l_okc_ph_line_breaks_v_rec.id,
136: l_okc_ph_line_breaks_v_rec.cle_id,
137: l_okc_ph_line_breaks_v_rec.value_from,
138: l_okc_ph_line_breaks_v_rec.value_to,
139: l_okc_ph_line_breaks_v_rec.pricing_type,
140: l_okc_ph_line_breaks_v_rec.value,
141: l_okc_ph_line_breaks_v_rec.start_date,
142: l_okc_ph_line_breaks_v_rec.end_date,
135: l_okc_ph_line_breaks_v_rec.id,
136: l_okc_ph_line_breaks_v_rec.cle_id,
137: l_okc_ph_line_breaks_v_rec.value_from,
138: l_okc_ph_line_breaks_v_rec.value_to,
139: l_okc_ph_line_breaks_v_rec.pricing_type,
140: l_okc_ph_line_breaks_v_rec.value,
141: l_okc_ph_line_breaks_v_rec.start_date,
142: l_okc_ph_line_breaks_v_rec.end_date,
143: l_okc_ph_line_breaks_v_rec.object_version_number,
136: l_okc_ph_line_breaks_v_rec.cle_id,
137: l_okc_ph_line_breaks_v_rec.value_from,
138: l_okc_ph_line_breaks_v_rec.value_to,
139: l_okc_ph_line_breaks_v_rec.pricing_type,
140: l_okc_ph_line_breaks_v_rec.value,
141: l_okc_ph_line_breaks_v_rec.start_date,
142: l_okc_ph_line_breaks_v_rec.end_date,
143: l_okc_ph_line_breaks_v_rec.object_version_number,
144: l_okc_ph_line_breaks_v_rec.created_by,
137: l_okc_ph_line_breaks_v_rec.value_from,
138: l_okc_ph_line_breaks_v_rec.value_to,
139: l_okc_ph_line_breaks_v_rec.pricing_type,
140: l_okc_ph_line_breaks_v_rec.value,
141: l_okc_ph_line_breaks_v_rec.start_date,
142: l_okc_ph_line_breaks_v_rec.end_date,
143: l_okc_ph_line_breaks_v_rec.object_version_number,
144: l_okc_ph_line_breaks_v_rec.created_by,
145: l_okc_ph_line_breaks_v_rec.creation_date,
138: l_okc_ph_line_breaks_v_rec.value_to,
139: l_okc_ph_line_breaks_v_rec.pricing_type,
140: l_okc_ph_line_breaks_v_rec.value,
141: l_okc_ph_line_breaks_v_rec.start_date,
142: l_okc_ph_line_breaks_v_rec.end_date,
143: l_okc_ph_line_breaks_v_rec.object_version_number,
144: l_okc_ph_line_breaks_v_rec.created_by,
145: l_okc_ph_line_breaks_v_rec.creation_date,
146: l_okc_ph_line_breaks_v_rec.last_updated_by,
139: l_okc_ph_line_breaks_v_rec.pricing_type,
140: l_okc_ph_line_breaks_v_rec.value,
141: l_okc_ph_line_breaks_v_rec.start_date,
142: l_okc_ph_line_breaks_v_rec.end_date,
143: l_okc_ph_line_breaks_v_rec.object_version_number,
144: l_okc_ph_line_breaks_v_rec.created_by,
145: l_okc_ph_line_breaks_v_rec.creation_date,
146: l_okc_ph_line_breaks_v_rec.last_updated_by,
147: l_okc_ph_line_breaks_v_rec.last_update_date,
140: l_okc_ph_line_breaks_v_rec.value,
141: l_okc_ph_line_breaks_v_rec.start_date,
142: l_okc_ph_line_breaks_v_rec.end_date,
143: l_okc_ph_line_breaks_v_rec.object_version_number,
144: l_okc_ph_line_breaks_v_rec.created_by,
145: l_okc_ph_line_breaks_v_rec.creation_date,
146: l_okc_ph_line_breaks_v_rec.last_updated_by,
147: l_okc_ph_line_breaks_v_rec.last_update_date,
148: l_okc_ph_line_breaks_v_rec.program_application_id,
141: l_okc_ph_line_breaks_v_rec.start_date,
142: l_okc_ph_line_breaks_v_rec.end_date,
143: l_okc_ph_line_breaks_v_rec.object_version_number,
144: l_okc_ph_line_breaks_v_rec.created_by,
145: l_okc_ph_line_breaks_v_rec.creation_date,
146: l_okc_ph_line_breaks_v_rec.last_updated_by,
147: l_okc_ph_line_breaks_v_rec.last_update_date,
148: l_okc_ph_line_breaks_v_rec.program_application_id,
149: l_okc_ph_line_breaks_v_rec.program_id,
142: l_okc_ph_line_breaks_v_rec.end_date,
143: l_okc_ph_line_breaks_v_rec.object_version_number,
144: l_okc_ph_line_breaks_v_rec.created_by,
145: l_okc_ph_line_breaks_v_rec.creation_date,
146: l_okc_ph_line_breaks_v_rec.last_updated_by,
147: l_okc_ph_line_breaks_v_rec.last_update_date,
148: l_okc_ph_line_breaks_v_rec.program_application_id,
149: l_okc_ph_line_breaks_v_rec.program_id,
150: l_okc_ph_line_breaks_v_rec.program_update_date,
143: l_okc_ph_line_breaks_v_rec.object_version_number,
144: l_okc_ph_line_breaks_v_rec.created_by,
145: l_okc_ph_line_breaks_v_rec.creation_date,
146: l_okc_ph_line_breaks_v_rec.last_updated_by,
147: l_okc_ph_line_breaks_v_rec.last_update_date,
148: l_okc_ph_line_breaks_v_rec.program_application_id,
149: l_okc_ph_line_breaks_v_rec.program_id,
150: l_okc_ph_line_breaks_v_rec.program_update_date,
151: l_okc_ph_line_breaks_v_rec.request_id,
144: l_okc_ph_line_breaks_v_rec.created_by,
145: l_okc_ph_line_breaks_v_rec.creation_date,
146: l_okc_ph_line_breaks_v_rec.last_updated_by,
147: l_okc_ph_line_breaks_v_rec.last_update_date,
148: l_okc_ph_line_breaks_v_rec.program_application_id,
149: l_okc_ph_line_breaks_v_rec.program_id,
150: l_okc_ph_line_breaks_v_rec.program_update_date,
151: l_okc_ph_line_breaks_v_rec.request_id,
152: l_okc_ph_line_breaks_v_rec.integrated_with_qp,
145: l_okc_ph_line_breaks_v_rec.creation_date,
146: l_okc_ph_line_breaks_v_rec.last_updated_by,
147: l_okc_ph_line_breaks_v_rec.last_update_date,
148: l_okc_ph_line_breaks_v_rec.program_application_id,
149: l_okc_ph_line_breaks_v_rec.program_id,
150: l_okc_ph_line_breaks_v_rec.program_update_date,
151: l_okc_ph_line_breaks_v_rec.request_id,
152: l_okc_ph_line_breaks_v_rec.integrated_with_qp,
153: l_okc_ph_line_breaks_v_rec.qp_reference_id,
146: l_okc_ph_line_breaks_v_rec.last_updated_by,
147: l_okc_ph_line_breaks_v_rec.last_update_date,
148: l_okc_ph_line_breaks_v_rec.program_application_id,
149: l_okc_ph_line_breaks_v_rec.program_id,
150: l_okc_ph_line_breaks_v_rec.program_update_date,
151: l_okc_ph_line_breaks_v_rec.request_id,
152: l_okc_ph_line_breaks_v_rec.integrated_with_qp,
153: l_okc_ph_line_breaks_v_rec.qp_reference_id,
154: l_okc_ph_line_breaks_v_rec.ship_to_organization_id,
147: l_okc_ph_line_breaks_v_rec.last_update_date,
148: l_okc_ph_line_breaks_v_rec.program_application_id,
149: l_okc_ph_line_breaks_v_rec.program_id,
150: l_okc_ph_line_breaks_v_rec.program_update_date,
151: l_okc_ph_line_breaks_v_rec.request_id,
152: l_okc_ph_line_breaks_v_rec.integrated_with_qp,
153: l_okc_ph_line_breaks_v_rec.qp_reference_id,
154: l_okc_ph_line_breaks_v_rec.ship_to_organization_id,
155: l_okc_ph_line_breaks_v_rec.ship_to_location_id,
148: l_okc_ph_line_breaks_v_rec.program_application_id,
149: l_okc_ph_line_breaks_v_rec.program_id,
150: l_okc_ph_line_breaks_v_rec.program_update_date,
151: l_okc_ph_line_breaks_v_rec.request_id,
152: l_okc_ph_line_breaks_v_rec.integrated_with_qp,
153: l_okc_ph_line_breaks_v_rec.qp_reference_id,
154: l_okc_ph_line_breaks_v_rec.ship_to_organization_id,
155: l_okc_ph_line_breaks_v_rec.ship_to_location_id,
156: l_okc_ph_line_breaks_v_rec.last_update_login;
149: l_okc_ph_line_breaks_v_rec.program_id,
150: l_okc_ph_line_breaks_v_rec.program_update_date,
151: l_okc_ph_line_breaks_v_rec.request_id,
152: l_okc_ph_line_breaks_v_rec.integrated_with_qp,
153: l_okc_ph_line_breaks_v_rec.qp_reference_id,
154: l_okc_ph_line_breaks_v_rec.ship_to_organization_id,
155: l_okc_ph_line_breaks_v_rec.ship_to_location_id,
156: l_okc_ph_line_breaks_v_rec.last_update_login;
157: x_no_data_found := okc_phlbv_pk_csr%NOTFOUND;
150: l_okc_ph_line_breaks_v_rec.program_update_date,
151: l_okc_ph_line_breaks_v_rec.request_id,
152: l_okc_ph_line_breaks_v_rec.integrated_with_qp,
153: l_okc_ph_line_breaks_v_rec.qp_reference_id,
154: l_okc_ph_line_breaks_v_rec.ship_to_organization_id,
155: l_okc_ph_line_breaks_v_rec.ship_to_location_id,
156: l_okc_ph_line_breaks_v_rec.last_update_login;
157: x_no_data_found := okc_phlbv_pk_csr%NOTFOUND;
158: CLOSE okc_phlbv_pk_csr;
151: l_okc_ph_line_breaks_v_rec.request_id,
152: l_okc_ph_line_breaks_v_rec.integrated_with_qp,
153: l_okc_ph_line_breaks_v_rec.qp_reference_id,
154: l_okc_ph_line_breaks_v_rec.ship_to_organization_id,
155: l_okc_ph_line_breaks_v_rec.ship_to_location_id,
156: l_okc_ph_line_breaks_v_rec.last_update_login;
157: x_no_data_found := okc_phlbv_pk_csr%NOTFOUND;
158: CLOSE okc_phlbv_pk_csr;
159: RETURN(l_okc_ph_line_breaks_v_rec);
152: l_okc_ph_line_breaks_v_rec.integrated_with_qp,
153: l_okc_ph_line_breaks_v_rec.qp_reference_id,
154: l_okc_ph_line_breaks_v_rec.ship_to_organization_id,
155: l_okc_ph_line_breaks_v_rec.ship_to_location_id,
156: l_okc_ph_line_breaks_v_rec.last_update_login;
157: x_no_data_found := okc_phlbv_pk_csr%NOTFOUND;
158: CLOSE okc_phlbv_pk_csr;
159: RETURN(l_okc_ph_line_breaks_v_rec);
160: END get_rec;
155: l_okc_ph_line_breaks_v_rec.ship_to_location_id,
156: l_okc_ph_line_breaks_v_rec.last_update_login;
157: x_no_data_found := okc_phlbv_pk_csr%NOTFOUND;
158: CLOSE okc_phlbv_pk_csr;
159: RETURN(l_okc_ph_line_breaks_v_rec);
160: END get_rec;
161:
162: ------------------------------------------------------------------
163: -- This version of get_rec sets error messages if no data found --
162: ------------------------------------------------------------------
163: -- This version of get_rec sets error messages if no data found --
164: ------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
167: x_return_status OUT NOCOPY VARCHAR2
168: ) RETURN okc_ph_line_breaks_v_rec_type IS
169: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
164: ------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
167: x_return_status OUT NOCOPY VARCHAR2
168: ) RETURN okc_ph_line_breaks_v_rec_type IS
169: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
171: BEGIN
172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
165: FUNCTION get_rec (
166: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
167: x_return_status OUT NOCOPY VARCHAR2
168: ) RETURN okc_ph_line_breaks_v_rec_type IS
169: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
171: BEGIN
172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
173: l_okc_ph_line_breaks_v_rec := get_rec(p_okc_ph_line_breaks_v_rec, l_row_notfound);
169: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
171: BEGIN
172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
173: l_okc_ph_line_breaks_v_rec := get_rec(p_okc_ph_line_breaks_v_rec, l_row_notfound);
174: IF (l_row_notfound) THEN
175: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
176: x_return_status := OKC_API.G_RET_STS_ERROR;
177: END IF;
174: IF (l_row_notfound) THEN
175: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
176: x_return_status := OKC_API.G_RET_STS_ERROR;
177: END IF;
178: RETURN(l_okc_ph_line_breaks_v_rec);
179: END get_rec;
180: -----------------------------------------------------------
181: -- So we don't have to pass an "l_row_notfound" variable --
182: -----------------------------------------------------------
180: -----------------------------------------------------------
181: -- So we don't have to pass an "l_row_notfound" variable --
182: -----------------------------------------------------------
183: FUNCTION get_rec (
184: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
185: ) RETURN okc_ph_line_breaks_v_rec_type IS
186: l_row_not_found BOOLEAN := TRUE;
187: BEGIN
188: RETURN(get_rec(p_okc_ph_line_breaks_v_rec, l_row_not_found));
181: -- So we don't have to pass an "l_row_notfound" variable --
182: -----------------------------------------------------------
183: FUNCTION get_rec (
184: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
185: ) RETURN okc_ph_line_breaks_v_rec_type IS
186: l_row_not_found BOOLEAN := TRUE;
187: BEGIN
188: RETURN(get_rec(p_okc_ph_line_breaks_v_rec, l_row_not_found));
189: END get_rec;
184: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
185: ) RETURN okc_ph_line_breaks_v_rec_type IS
186: l_row_not_found BOOLEAN := TRUE;
187: BEGIN
188: RETURN(get_rec(p_okc_ph_line_breaks_v_rec, l_row_not_found));
189: END get_rec;
190: ---------------------------------------------------------------------------
191: -- FUNCTION get_rec for: OKC_PH_LINE_BREAKS
192: ---------------------------------------------------------------------------
282: BEGIN
283: RETURN(get_rec(p_okc_ph_line_breaks_rec, l_row_not_found));
284: END get_rec;
285: ---------------------------------------------------------------------------
286: -- FUNCTION null_out_defaults for: OKC_PH_LINE_BREAKS_V
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
290: ) RETURN okc_ph_line_breaks_v_rec_type IS
285: ---------------------------------------------------------------------------
286: -- FUNCTION null_out_defaults for: OKC_PH_LINE_BREAKS_V
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
290: ) RETURN okc_ph_line_breaks_v_rec_type IS
291: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
292: BEGIN
293: IF (l_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM ) THEN
286: -- FUNCTION null_out_defaults for: OKC_PH_LINE_BREAKS_V
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
290: ) RETURN okc_ph_line_breaks_v_rec_type IS
291: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
292: BEGIN
293: IF (l_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_okc_ph_line_breaks_v_rec.id := NULL;
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
290: ) RETURN okc_ph_line_breaks_v_rec_type IS
291: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
292: BEGIN
293: IF (l_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_okc_ph_line_breaks_v_rec.id := NULL;
295: END IF;
289: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
290: ) RETURN okc_ph_line_breaks_v_rec_type IS
291: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
292: BEGIN
293: IF (l_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_okc_ph_line_breaks_v_rec.id := NULL;
295: END IF;
296: IF (l_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
297: l_okc_ph_line_breaks_v_rec.cle_id := NULL;
290: ) RETURN okc_ph_line_breaks_v_rec_type IS
291: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
292: BEGIN
293: IF (l_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_okc_ph_line_breaks_v_rec.id := NULL;
295: END IF;
296: IF (l_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
297: l_okc_ph_line_breaks_v_rec.cle_id := NULL;
298: END IF;
292: BEGIN
293: IF (l_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_okc_ph_line_breaks_v_rec.id := NULL;
295: END IF;
296: IF (l_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
297: l_okc_ph_line_breaks_v_rec.cle_id := NULL;
298: END IF;
299: IF (l_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM ) THEN
300: l_okc_ph_line_breaks_v_rec.value_from := NULL;
293: IF (l_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_okc_ph_line_breaks_v_rec.id := NULL;
295: END IF;
296: IF (l_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
297: l_okc_ph_line_breaks_v_rec.cle_id := NULL;
298: END IF;
299: IF (l_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM ) THEN
300: l_okc_ph_line_breaks_v_rec.value_from := NULL;
301: END IF;
295: END IF;
296: IF (l_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
297: l_okc_ph_line_breaks_v_rec.cle_id := NULL;
298: END IF;
299: IF (l_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM ) THEN
300: l_okc_ph_line_breaks_v_rec.value_from := NULL;
301: END IF;
302: IF (l_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM ) THEN
303: l_okc_ph_line_breaks_v_rec.value_to := NULL;
296: IF (l_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
297: l_okc_ph_line_breaks_v_rec.cle_id := NULL;
298: END IF;
299: IF (l_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM ) THEN
300: l_okc_ph_line_breaks_v_rec.value_from := NULL;
301: END IF;
302: IF (l_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM ) THEN
303: l_okc_ph_line_breaks_v_rec.value_to := NULL;
304: END IF;
298: END IF;
299: IF (l_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM ) THEN
300: l_okc_ph_line_breaks_v_rec.value_from := NULL;
301: END IF;
302: IF (l_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM ) THEN
303: l_okc_ph_line_breaks_v_rec.value_to := NULL;
304: END IF;
305: IF (l_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR ) THEN
306: l_okc_ph_line_breaks_v_rec.pricing_type := NULL;
299: IF (l_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM ) THEN
300: l_okc_ph_line_breaks_v_rec.value_from := NULL;
301: END IF;
302: IF (l_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM ) THEN
303: l_okc_ph_line_breaks_v_rec.value_to := NULL;
304: END IF;
305: IF (l_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR ) THEN
306: l_okc_ph_line_breaks_v_rec.pricing_type := NULL;
307: END IF;
301: END IF;
302: IF (l_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM ) THEN
303: l_okc_ph_line_breaks_v_rec.value_to := NULL;
304: END IF;
305: IF (l_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR ) THEN
306: l_okc_ph_line_breaks_v_rec.pricing_type := NULL;
307: END IF;
308: IF (l_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM ) THEN
309: l_okc_ph_line_breaks_v_rec.value := NULL;
302: IF (l_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM ) THEN
303: l_okc_ph_line_breaks_v_rec.value_to := NULL;
304: END IF;
305: IF (l_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR ) THEN
306: l_okc_ph_line_breaks_v_rec.pricing_type := NULL;
307: END IF;
308: IF (l_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM ) THEN
309: l_okc_ph_line_breaks_v_rec.value := NULL;
310: END IF;
304: END IF;
305: IF (l_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR ) THEN
306: l_okc_ph_line_breaks_v_rec.pricing_type := NULL;
307: END IF;
308: IF (l_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM ) THEN
309: l_okc_ph_line_breaks_v_rec.value := NULL;
310: END IF;
311: IF (l_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE ) THEN
312: l_okc_ph_line_breaks_v_rec.start_date := NULL;
305: IF (l_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR ) THEN
306: l_okc_ph_line_breaks_v_rec.pricing_type := NULL;
307: END IF;
308: IF (l_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM ) THEN
309: l_okc_ph_line_breaks_v_rec.value := NULL;
310: END IF;
311: IF (l_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE ) THEN
312: l_okc_ph_line_breaks_v_rec.start_date := NULL;
313: END IF;
307: END IF;
308: IF (l_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM ) THEN
309: l_okc_ph_line_breaks_v_rec.value := NULL;
310: END IF;
311: IF (l_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE ) THEN
312: l_okc_ph_line_breaks_v_rec.start_date := NULL;
313: END IF;
314: IF (l_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE ) THEN
315: l_okc_ph_line_breaks_v_rec.end_date := NULL;
308: IF (l_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM ) THEN
309: l_okc_ph_line_breaks_v_rec.value := NULL;
310: END IF;
311: IF (l_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE ) THEN
312: l_okc_ph_line_breaks_v_rec.start_date := NULL;
313: END IF;
314: IF (l_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE ) THEN
315: l_okc_ph_line_breaks_v_rec.end_date := NULL;
316: END IF;
310: END IF;
311: IF (l_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE ) THEN
312: l_okc_ph_line_breaks_v_rec.start_date := NULL;
313: END IF;
314: IF (l_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE ) THEN
315: l_okc_ph_line_breaks_v_rec.end_date := NULL;
316: END IF;
317: IF (l_okc_ph_line_breaks_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
318: l_okc_ph_line_breaks_v_rec.object_version_number := NULL;
311: IF (l_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE ) THEN
312: l_okc_ph_line_breaks_v_rec.start_date := NULL;
313: END IF;
314: IF (l_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE ) THEN
315: l_okc_ph_line_breaks_v_rec.end_date := NULL;
316: END IF;
317: IF (l_okc_ph_line_breaks_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
318: l_okc_ph_line_breaks_v_rec.object_version_number := NULL;
319: END IF;
313: END IF;
314: IF (l_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE ) THEN
315: l_okc_ph_line_breaks_v_rec.end_date := NULL;
316: END IF;
317: IF (l_okc_ph_line_breaks_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
318: l_okc_ph_line_breaks_v_rec.object_version_number := NULL;
319: END IF;
320: IF (l_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
321: l_okc_ph_line_breaks_v_rec.created_by := NULL;
314: IF (l_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE ) THEN
315: l_okc_ph_line_breaks_v_rec.end_date := NULL;
316: END IF;
317: IF (l_okc_ph_line_breaks_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
318: l_okc_ph_line_breaks_v_rec.object_version_number := NULL;
319: END IF;
320: IF (l_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
321: l_okc_ph_line_breaks_v_rec.created_by := NULL;
322: END IF;
316: END IF;
317: IF (l_okc_ph_line_breaks_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
318: l_okc_ph_line_breaks_v_rec.object_version_number := NULL;
319: END IF;
320: IF (l_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
321: l_okc_ph_line_breaks_v_rec.created_by := NULL;
322: END IF;
323: IF (l_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
324: l_okc_ph_line_breaks_v_rec.creation_date := NULL;
317: IF (l_okc_ph_line_breaks_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
318: l_okc_ph_line_breaks_v_rec.object_version_number := NULL;
319: END IF;
320: IF (l_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
321: l_okc_ph_line_breaks_v_rec.created_by := NULL;
322: END IF;
323: IF (l_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
324: l_okc_ph_line_breaks_v_rec.creation_date := NULL;
325: END IF;
319: END IF;
320: IF (l_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
321: l_okc_ph_line_breaks_v_rec.created_by := NULL;
322: END IF;
323: IF (l_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
324: l_okc_ph_line_breaks_v_rec.creation_date := NULL;
325: END IF;
326: IF (l_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
327: l_okc_ph_line_breaks_v_rec.last_updated_by := NULL;
320: IF (l_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
321: l_okc_ph_line_breaks_v_rec.created_by := NULL;
322: END IF;
323: IF (l_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
324: l_okc_ph_line_breaks_v_rec.creation_date := NULL;
325: END IF;
326: IF (l_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
327: l_okc_ph_line_breaks_v_rec.last_updated_by := NULL;
328: END IF;
322: END IF;
323: IF (l_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
324: l_okc_ph_line_breaks_v_rec.creation_date := NULL;
325: END IF;
326: IF (l_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
327: l_okc_ph_line_breaks_v_rec.last_updated_by := NULL;
328: END IF;
329: IF (l_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
330: l_okc_ph_line_breaks_v_rec.last_update_date := NULL;
323: IF (l_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
324: l_okc_ph_line_breaks_v_rec.creation_date := NULL;
325: END IF;
326: IF (l_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
327: l_okc_ph_line_breaks_v_rec.last_updated_by := NULL;
328: END IF;
329: IF (l_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
330: l_okc_ph_line_breaks_v_rec.last_update_date := NULL;
331: END IF;
325: END IF;
326: IF (l_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
327: l_okc_ph_line_breaks_v_rec.last_updated_by := NULL;
328: END IF;
329: IF (l_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
330: l_okc_ph_line_breaks_v_rec.last_update_date := NULL;
331: END IF;
332: IF (l_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_okc_ph_line_breaks_v_rec.program_application_id := NULL;
326: IF (l_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
327: l_okc_ph_line_breaks_v_rec.last_updated_by := NULL;
328: END IF;
329: IF (l_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
330: l_okc_ph_line_breaks_v_rec.last_update_date := NULL;
331: END IF;
332: IF (l_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_okc_ph_line_breaks_v_rec.program_application_id := NULL;
334: END IF;
328: END IF;
329: IF (l_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
330: l_okc_ph_line_breaks_v_rec.last_update_date := NULL;
331: END IF;
332: IF (l_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_okc_ph_line_breaks_v_rec.program_application_id := NULL;
334: END IF;
335: IF (l_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_okc_ph_line_breaks_v_rec.program_id := NULL;
329: IF (l_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
330: l_okc_ph_line_breaks_v_rec.last_update_date := NULL;
331: END IF;
332: IF (l_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_okc_ph_line_breaks_v_rec.program_application_id := NULL;
334: END IF;
335: IF (l_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_okc_ph_line_breaks_v_rec.program_id := NULL;
337: END IF;
331: END IF;
332: IF (l_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_okc_ph_line_breaks_v_rec.program_application_id := NULL;
334: END IF;
335: IF (l_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_okc_ph_line_breaks_v_rec.program_id := NULL;
337: END IF;
338: IF (l_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_okc_ph_line_breaks_v_rec.program_update_date := NULL;
332: IF (l_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
333: l_okc_ph_line_breaks_v_rec.program_application_id := NULL;
334: END IF;
335: IF (l_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_okc_ph_line_breaks_v_rec.program_id := NULL;
337: END IF;
338: IF (l_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_okc_ph_line_breaks_v_rec.program_update_date := NULL;
340: END IF;
334: END IF;
335: IF (l_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_okc_ph_line_breaks_v_rec.program_id := NULL;
337: END IF;
338: IF (l_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_okc_ph_line_breaks_v_rec.program_update_date := NULL;
340: END IF;
341: IF (l_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_okc_ph_line_breaks_v_rec.request_id := NULL;
335: IF (l_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
336: l_okc_ph_line_breaks_v_rec.program_id := NULL;
337: END IF;
338: IF (l_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_okc_ph_line_breaks_v_rec.program_update_date := NULL;
340: END IF;
341: IF (l_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_okc_ph_line_breaks_v_rec.request_id := NULL;
343: END IF;
337: END IF;
338: IF (l_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_okc_ph_line_breaks_v_rec.program_update_date := NULL;
340: END IF;
341: IF (l_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_okc_ph_line_breaks_v_rec.request_id := NULL;
343: END IF;
344: IF (l_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR ) THEN
345: l_okc_ph_line_breaks_v_rec.integrated_with_qp := NULL;
338: IF (l_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
339: l_okc_ph_line_breaks_v_rec.program_update_date := NULL;
340: END IF;
341: IF (l_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_okc_ph_line_breaks_v_rec.request_id := NULL;
343: END IF;
344: IF (l_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR ) THEN
345: l_okc_ph_line_breaks_v_rec.integrated_with_qp := NULL;
346: END IF;
340: END IF;
341: IF (l_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_okc_ph_line_breaks_v_rec.request_id := NULL;
343: END IF;
344: IF (l_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR ) THEN
345: l_okc_ph_line_breaks_v_rec.integrated_with_qp := NULL;
346: END IF;
347: IF (l_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM ) THEN
348: l_okc_ph_line_breaks_v_rec.qp_reference_id := NULL;
341: IF (l_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
342: l_okc_ph_line_breaks_v_rec.request_id := NULL;
343: END IF;
344: IF (l_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR ) THEN
345: l_okc_ph_line_breaks_v_rec.integrated_with_qp := NULL;
346: END IF;
347: IF (l_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM ) THEN
348: l_okc_ph_line_breaks_v_rec.qp_reference_id := NULL;
349: END IF;
343: END IF;
344: IF (l_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR ) THEN
345: l_okc_ph_line_breaks_v_rec.integrated_with_qp := NULL;
346: END IF;
347: IF (l_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM ) THEN
348: l_okc_ph_line_breaks_v_rec.qp_reference_id := NULL;
349: END IF;
350: IF (l_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM ) THEN
351: l_okc_ph_line_breaks_v_rec.ship_to_organization_id := NULL;
344: IF (l_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR ) THEN
345: l_okc_ph_line_breaks_v_rec.integrated_with_qp := NULL;
346: END IF;
347: IF (l_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM ) THEN
348: l_okc_ph_line_breaks_v_rec.qp_reference_id := NULL;
349: END IF;
350: IF (l_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM ) THEN
351: l_okc_ph_line_breaks_v_rec.ship_to_organization_id := NULL;
352: END IF;
346: END IF;
347: IF (l_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM ) THEN
348: l_okc_ph_line_breaks_v_rec.qp_reference_id := NULL;
349: END IF;
350: IF (l_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM ) THEN
351: l_okc_ph_line_breaks_v_rec.ship_to_organization_id := NULL;
352: END IF;
353: IF (l_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM ) THEN
354: l_okc_ph_line_breaks_v_rec.ship_to_location_id := NULL;
347: IF (l_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM ) THEN
348: l_okc_ph_line_breaks_v_rec.qp_reference_id := NULL;
349: END IF;
350: IF (l_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM ) THEN
351: l_okc_ph_line_breaks_v_rec.ship_to_organization_id := NULL;
352: END IF;
353: IF (l_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM ) THEN
354: l_okc_ph_line_breaks_v_rec.ship_to_location_id := NULL;
355: END IF;
349: END IF;
350: IF (l_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM ) THEN
351: l_okc_ph_line_breaks_v_rec.ship_to_organization_id := NULL;
352: END IF;
353: IF (l_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM ) THEN
354: l_okc_ph_line_breaks_v_rec.ship_to_location_id := NULL;
355: END IF;
356: IF (l_okc_ph_line_breaks_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_okc_ph_line_breaks_v_rec.last_update_login := NULL;
350: IF (l_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM ) THEN
351: l_okc_ph_line_breaks_v_rec.ship_to_organization_id := NULL;
352: END IF;
353: IF (l_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM ) THEN
354: l_okc_ph_line_breaks_v_rec.ship_to_location_id := NULL;
355: END IF;
356: IF (l_okc_ph_line_breaks_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_okc_ph_line_breaks_v_rec.last_update_login := NULL;
358: END IF;
352: END IF;
353: IF (l_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM ) THEN
354: l_okc_ph_line_breaks_v_rec.ship_to_location_id := NULL;
355: END IF;
356: IF (l_okc_ph_line_breaks_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_okc_ph_line_breaks_v_rec.last_update_login := NULL;
358: END IF;
359: RETURN(l_okc_ph_line_breaks_v_rec);
360: END null_out_defaults;
353: IF (l_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM ) THEN
354: l_okc_ph_line_breaks_v_rec.ship_to_location_id := NULL;
355: END IF;
356: IF (l_okc_ph_line_breaks_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_okc_ph_line_breaks_v_rec.last_update_login := NULL;
358: END IF;
359: RETURN(l_okc_ph_line_breaks_v_rec);
360: END null_out_defaults;
361: ---------------------------------
355: END IF;
356: IF (l_okc_ph_line_breaks_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
357: l_okc_ph_line_breaks_v_rec.last_update_login := NULL;
358: END IF;
359: RETURN(l_okc_ph_line_breaks_v_rec);
360: END null_out_defaults;
361: ---------------------------------
362: -- Validate_Attributes for: ID --
363: ---------------------------------
443: -- Validate_Attributes for: VALUE_FROM and VALUE_TO --
444: --------------------------------------------------
445: PROCEDURE validate_values_from_to(
446: x_return_status OUT NOCOPY VARCHAR2,
447: p_phlv_rec IN okc_ph_line_breaks_v_rec_type) IS
448: l_dummy_var VARCHAR2(1) := '?';
449: l_MAX_NUM NUMBER := 9999999999999999999999999999999999999999;
450: CURSOR c_overlaping( p_from NUMBER, p_to NUMBER, p_cle_id NUMBER, p_id NUMBER) IS
451: SELECT 'x'
503: ---------------------------------------------------------------------------
504: -- FUNCTION Validate_Attributes
505: ---------------------------------------------------------------------------
506: --------------------------------------------------
507: -- Validate_Attributes for:OKC_PH_LINE_BREAKS_V --
508: --------------------------------------------------
509: FUNCTION Validate_Attributes (
510: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
511: ) RETURN VARCHAR2 IS
506: --------------------------------------------------
507: -- Validate_Attributes for:OKC_PH_LINE_BREAKS_V --
508: --------------------------------------------------
509: FUNCTION Validate_Attributes (
510: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
511: ) RETURN VARCHAR2 IS
512: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
513: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
514: BEGIN
517: -----------------------------
518: -- ***
519: -- id
520: -- ***
521: validate_id(x_return_status, p_okc_ph_line_breaks_v_rec.id);
522: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
523: l_return_status := x_return_status;
524: RAISE G_EXCEPTION_HALT_VALIDATION;
525: END IF;
526:
527: -- ***
528: -- cle_id
529: -- ***
530: validate_cle_id(x_return_status, p_okc_ph_line_breaks_v_rec.cle_id);
531: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
532: l_return_status := x_return_status;
533: RAISE G_EXCEPTION_HALT_VALIDATION;
534: END IF;
535:
536: -- ***
537: -- pricing_type
538: -- ***
539: validate_pricing_type(x_return_status, p_okc_ph_line_breaks_v_rec.pricing_type);
540: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
541: l_return_status := x_return_status;
542: RAISE G_EXCEPTION_HALT_VALIDATION;
543: END IF;
544:
545: -- ***
546: -- value_from and value_to
547: -- ***
548: validate_values_from_to(x_return_status, p_okc_ph_line_breaks_v_rec);
549: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
550: l_return_status := x_return_status;
551: RAISE G_EXCEPTION_HALT_VALIDATION;
552: END IF;
569: ---------------------------------------------------------------------------
570: -- PROCEDURE Validate_Record
571: ---------------------------------------------------------------------------
572: ----------------------------------------------
573: -- Validate Record for:OKC_PH_LINE_BREAKS_V --
574: ----------------------------------------------
575: FUNCTION Validate_Record (
576: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
577: p_db_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
572: ----------------------------------------------
573: -- Validate Record for:OKC_PH_LINE_BREAKS_V --
574: ----------------------------------------------
575: FUNCTION Validate_Record (
576: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
577: p_db_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
578: ) RETURN VARCHAR2 IS
579: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
580: ------------------------------------
573: -- Validate Record for:OKC_PH_LINE_BREAKS_V --
574: ----------------------------------------------
575: FUNCTION Validate_Record (
576: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
577: p_db_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
578: ) RETURN VARCHAR2 IS
579: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
580: ------------------------------------
581: -- FUNCTION validate_foreign_keys --
580: ------------------------------------
581: -- FUNCTION validate_foreign_keys --
582: ------------------------------------
583: FUNCTION validate_foreign_keys (
584: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
585: p_db_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
586: ) RETURN VARCHAR2 IS
587: item_not_found_error EXCEPTION;
588: CURSOR okc_phlbv_hraouv_fk_csr (p_organization_id IN NUMBER) IS
581: -- FUNCTION validate_foreign_keys --
582: ------------------------------------
583: FUNCTION validate_foreign_keys (
584: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
585: p_db_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
586: ) RETURN VARCHAR2 IS
587: item_not_found_error EXCEPTION;
588: CURSOR okc_phlbv_hraouv_fk_csr (p_organization_id IN NUMBER) IS
589: SELECT 'x'
611:
612: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
613: l_row_notfound BOOLEAN := TRUE;
614: BEGIN
615: IF ((p_okc_ph_line_breaks_v_rec.PRICING_TYPE IS NOT NULL)
616: AND
617: (p_okc_ph_line_breaks_v_rec.PRICING_TYPE <> p_db_okc_ph_line_breaks_v_rec.PRICING_TYPE))
618: THEN
619: OPEN okc_phlbv_flkup_fk_csr (p_okc_ph_line_breaks_v_rec.PRICING_TYPE);
613: l_row_notfound BOOLEAN := TRUE;
614: BEGIN
615: IF ((p_okc_ph_line_breaks_v_rec.PRICING_TYPE IS NOT NULL)
616: AND
617: (p_okc_ph_line_breaks_v_rec.PRICING_TYPE <> p_db_okc_ph_line_breaks_v_rec.PRICING_TYPE))
618: THEN
619: OPEN okc_phlbv_flkup_fk_csr (p_okc_ph_line_breaks_v_rec.PRICING_TYPE);
620: FETCH okc_phlbv_flkup_fk_csr INTO l_okc_phlbv_flkup_fk;
621: l_row_notfound := okc_phlbv_flkup_fk_csr%NOTFOUND;
615: IF ((p_okc_ph_line_breaks_v_rec.PRICING_TYPE IS NOT NULL)
616: AND
617: (p_okc_ph_line_breaks_v_rec.PRICING_TYPE <> p_db_okc_ph_line_breaks_v_rec.PRICING_TYPE))
618: THEN
619: OPEN okc_phlbv_flkup_fk_csr (p_okc_ph_line_breaks_v_rec.PRICING_TYPE);
620: FETCH okc_phlbv_flkup_fk_csr INTO l_okc_phlbv_flkup_fk;
621: l_row_notfound := okc_phlbv_flkup_fk_csr%NOTFOUND;
622: CLOSE okc_phlbv_flkup_fk_csr;
623: IF (l_row_notfound) THEN
624: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PRICING_TYPE');
625: RAISE item_not_found_error;
626: END IF;
627: END IF;
628: IF ((p_okc_ph_line_breaks_v_rec.CLE_ID IS NOT NULL)
629: AND
630: (p_okc_ph_line_breaks_v_rec.CLE_ID <> p_db_okc_ph_line_breaks_v_rec.CLE_ID))
631: THEN
632: OPEN okc_phlbv_okcklv_fk_csr (p_okc_ph_line_breaks_v_rec.CLE_ID);
626: END IF;
627: END IF;
628: IF ((p_okc_ph_line_breaks_v_rec.CLE_ID IS NOT NULL)
629: AND
630: (p_okc_ph_line_breaks_v_rec.CLE_ID <> p_db_okc_ph_line_breaks_v_rec.CLE_ID))
631: THEN
632: OPEN okc_phlbv_okcklv_fk_csr (p_okc_ph_line_breaks_v_rec.CLE_ID);
633: FETCH okc_phlbv_okcklv_fk_csr INTO l_okc_phlbv_okcklv_fk;
634: l_row_notfound := okc_phlbv_okcklv_fk_csr%NOTFOUND;
628: IF ((p_okc_ph_line_breaks_v_rec.CLE_ID IS NOT NULL)
629: AND
630: (p_okc_ph_line_breaks_v_rec.CLE_ID <> p_db_okc_ph_line_breaks_v_rec.CLE_ID))
631: THEN
632: OPEN okc_phlbv_okcklv_fk_csr (p_okc_ph_line_breaks_v_rec.CLE_ID);
633: FETCH okc_phlbv_okcklv_fk_csr INTO l_okc_phlbv_okcklv_fk;
634: l_row_notfound := okc_phlbv_okcklv_fk_csr%NOTFOUND;
635: CLOSE okc_phlbv_okcklv_fk_csr;
636: IF (l_row_notfound) THEN
637: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CLE_ID');
638: RAISE item_not_found_error;
639: END IF;
640: END IF;
641: IF ((p_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID IS NOT NULL)
642: AND
643: (p_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID <> p_db_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID))
644: THEN
645: OPEN okc_phlbv_hrlav_fk_csr (p_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID);
639: END IF;
640: END IF;
641: IF ((p_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID IS NOT NULL)
642: AND
643: (p_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID <> p_db_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID))
644: THEN
645: OPEN okc_phlbv_hrlav_fk_csr (p_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID);
646: FETCH okc_phlbv_hrlav_fk_csr INTO l_okc_phlbv_hrlav_fk;
647: l_row_notfound := okc_phlbv_hrlav_fk_csr%NOTFOUND;
641: IF ((p_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID IS NOT NULL)
642: AND
643: (p_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID <> p_db_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID))
644: THEN
645: OPEN okc_phlbv_hrlav_fk_csr (p_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID);
646: FETCH okc_phlbv_hrlav_fk_csr INTO l_okc_phlbv_hrlav_fk;
647: l_row_notfound := okc_phlbv_hrlav_fk_csr%NOTFOUND;
648: CLOSE okc_phlbv_hrlav_fk_csr;
649: IF (l_row_notfound) THEN
650: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SHIP_TO_LOCATION_ID');
651: RAISE item_not_found_error;
652: END IF;
653: END IF;
654: IF ((p_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID IS NOT NULL)
655: AND
656: (p_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID <> p_db_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID))
657: THEN
658: OPEN okc_phlbv_hraouv_fk_csr (p_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID);
652: END IF;
653: END IF;
654: IF ((p_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID IS NOT NULL)
655: AND
656: (p_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID <> p_db_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID))
657: THEN
658: OPEN okc_phlbv_hraouv_fk_csr (p_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID);
659: FETCH okc_phlbv_hraouv_fk_csr INTO l_okc_phlbv_hraouv_fk;
660: l_row_notfound := okc_phlbv_hraouv_fk_csr%NOTFOUND;
654: IF ((p_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID IS NOT NULL)
655: AND
656: (p_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID <> p_db_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID))
657: THEN
658: OPEN okc_phlbv_hraouv_fk_csr (p_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID);
659: FETCH okc_phlbv_hraouv_fk_csr INTO l_okc_phlbv_hraouv_fk;
660: l_row_notfound := okc_phlbv_hraouv_fk_csr%NOTFOUND;
661: CLOSE okc_phlbv_hraouv_fk_csr;
662: IF (l_row_notfound) THEN
670: l_return_status := OKC_API.G_RET_STS_ERROR;
671: RETURN (l_return_status);
672: END validate_foreign_keys;
673: BEGIN
674: l_return_status := validate_foreign_keys(p_okc_ph_line_breaks_v_rec, p_db_okc_ph_line_breaks_v_rec);
675: RETURN (l_return_status);
676: END Validate_Record;
677: FUNCTION Validate_Record (
678: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
674: l_return_status := validate_foreign_keys(p_okc_ph_line_breaks_v_rec, p_db_okc_ph_line_breaks_v_rec);
675: RETURN (l_return_status);
676: END Validate_Record;
677: FUNCTION Validate_Record (
678: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
679: ) RETURN VARCHAR2 IS
680: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
681: l_db_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := get_rec(p_okc_ph_line_breaks_v_rec);
682: BEGIN
677: FUNCTION Validate_Record (
678: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
679: ) RETURN VARCHAR2 IS
680: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
681: l_db_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := get_rec(p_okc_ph_line_breaks_v_rec);
682: BEGIN
683: l_return_status := Validate_Record(p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_rec,
684: p_db_okc_ph_line_breaks_v_rec => l_db_okc_ph_line_breaks_v_rec);
685: RETURN (l_return_status);
679: ) RETURN VARCHAR2 IS
680: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
681: l_db_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := get_rec(p_okc_ph_line_breaks_v_rec);
682: BEGIN
683: l_return_status := Validate_Record(p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_rec,
684: p_db_okc_ph_line_breaks_v_rec => l_db_okc_ph_line_breaks_v_rec);
685: RETURN (l_return_status);
686: END Validate_Record;
687:
680: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
681: l_db_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := get_rec(p_okc_ph_line_breaks_v_rec);
682: BEGIN
683: l_return_status := Validate_Record(p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_rec,
684: p_db_okc_ph_line_breaks_v_rec => l_db_okc_ph_line_breaks_v_rec);
685: RETURN (l_return_status);
686: END Validate_Record;
687:
688: ---------------------------------------------------------------------------
688: ---------------------------------------------------------------------------
689: -- PROCEDURE Migrate
690: ---------------------------------------------------------------------------
691: PROCEDURE migrate (
692: p_from IN okc_ph_line_breaks_v_rec_type,
693: p_to IN OUT NOCOPY okc_ph_line_breaks_rec_type
694: ) IS
695: BEGIN
696: p_to.id := p_from.id;
717: p_to.last_update_login := p_from.last_update_login;
718: END migrate;
719: PROCEDURE migrate (
720: p_from IN okc_ph_line_breaks_rec_type,
721: p_to IN OUT NOCOPY okc_ph_line_breaks_v_rec_type
722: ) IS
723: BEGIN
724: p_to.id := p_from.id;
725: p_to.cle_id := p_from.cle_id;
747: ---------------------------------------------------------------------------
748: -- PROCEDURE validate_row
749: ---------------------------------------------------------------------------
750: -------------------------------------------
751: -- validate_row for:OKC_PH_LINE_BREAKS_V --
752: -------------------------------------------
753: PROCEDURE validate_row(
754: p_api_version IN NUMBER,
755: p_init_msg_list IN VARCHAR2 ,
755: p_init_msg_list IN VARCHAR2 ,
756: x_return_status OUT NOCOPY VARCHAR2,
757: x_msg_count OUT NOCOPY NUMBER,
758: x_msg_data OUT NOCOPY VARCHAR2,
759: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type) IS
760:
761: l_api_version CONSTANT NUMBER := 1;
762: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
763: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
760:
761: l_api_version CONSTANT NUMBER := 1;
762: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
763: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
764: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
765: l_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
766: l_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
767: BEGIN
768: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
777: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;
780: --- Validate all non-missing attributes (Item Level Validation)
781: l_return_status := Validate_Attributes(l_okc_ph_line_breaks_v_rec);
782: --- If any errors happen abort API
783: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
785: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
785: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
786: RAISE OKC_API.G_EXCEPTION_ERROR;
787: END IF;
788: l_return_status := Validate_Record(l_okc_ph_line_breaks_v_rec);
789: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
791: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
792: RAISE OKC_API.G_EXCEPTION_ERROR;
824: '_PVT'
825: );
826: END validate_row;
827: ------------------------------------------------------
828: -- PL/SQL TBL validate_row for:OKC_PH_LINE_BREAKS_V --
829: ------------------------------------------------------
830: PROCEDURE validate_row(
831: p_api_version IN NUMBER,
832: p_init_msg_list IN VARCHAR2 ,
832: p_init_msg_list IN VARCHAR2 ,
833: x_return_status OUT NOCOPY VARCHAR2,
834: x_msg_count OUT NOCOPY NUMBER,
835: x_msg_data OUT NOCOPY VARCHAR2,
836: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
837: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
838:
839: l_api_version CONSTANT NUMBER := 1;
840: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
841: i NUMBER := 0;
842: BEGIN
843: OKC_API.init_msg_list(p_init_msg_list);
844: -- Make sure PL/SQL table has records in it before passing
845: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
846: i := p_okc_ph_line_breaks_v_tbl.FIRST;
847: LOOP
848: DECLARE
849: l_error_rec OKC_API.ERROR_REC_TYPE;
842: BEGIN
843: OKC_API.init_msg_list(p_init_msg_list);
844: -- Make sure PL/SQL table has records in it before passing
845: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
846: i := p_okc_ph_line_breaks_v_tbl.FIRST;
847: LOOP
848: DECLARE
849: l_error_rec OKC_API.ERROR_REC_TYPE;
850: BEGIN
856: p_init_msg_list => OKC_API.G_FALSE,
857: x_return_status => l_error_rec.error_type,
858: x_msg_count => l_error_rec.msg_count,
859: x_msg_data => l_error_rec.msg_data,
860: p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_tbl(i));
861: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
862: l_error_rec.sqlcode := SQLCODE;
863: load_error_tbl(l_error_rec, px_error_tbl);
864: ELSE
878: l_error_rec.error_type := 'OTHERS';
879: l_error_rec.sqlcode := SQLCODE;
880: load_error_tbl(l_error_rec, px_error_tbl);
881: END;
882: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
883: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
884: END LOOP;
885: END IF;
886: -- Loop through the error_tbl to find the error with the highest severity
879: l_error_rec.sqlcode := SQLCODE;
880: load_error_tbl(l_error_rec, px_error_tbl);
881: END;
882: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
883: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
884: END LOOP;
885: END IF;
886: -- Loop through the error_tbl to find the error with the highest severity
887: -- and return it.
920: );
921: END validate_row;
922:
923: ------------------------------------------------------
924: -- PL/SQL TBL validate_row for:OKC_PH_LINE_BREAKS_V --
925: ------------------------------------------------------
926: PROCEDURE validate_row(
927: p_api_version IN NUMBER,
928: p_init_msg_list IN VARCHAR2 ,
928: p_init_msg_list IN VARCHAR2 ,
929: x_return_status OUT NOCOPY VARCHAR2,
930: x_msg_count OUT NOCOPY NUMBER,
931: x_msg_data OUT NOCOPY VARCHAR2,
932: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type) IS
933:
934: l_api_version CONSTANT NUMBER := 1;
935: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
936: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
937: l_error_tbl OKC_API.ERROR_TBL_TYPE;
938: BEGIN
939: OKC_API.init_msg_list(p_init_msg_list);
940: -- Make sure PL/SQL table has records in it before passing
941: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
942: validate_row (
943: p_api_version => p_api_version,
944: p_init_msg_list => OKC_API.G_FALSE,
945: x_return_status => x_return_status,
944: p_init_msg_list => OKC_API.G_FALSE,
945: x_return_status => x_return_status,
946: x_msg_count => x_msg_count,
947: x_msg_data => x_msg_data,
948: p_okc_ph_line_breaks_v_tbl => p_okc_ph_line_breaks_v_tbl,
949: px_error_tbl => l_error_tbl);
950: END IF;
951: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
952: EXCEPTION
1115: '_PVT'
1116: );
1117: END insert_row;
1118: ------------------------------------------
1119: -- insert_row for :OKC_PH_LINE_BREAKS_V --
1120: ------------------------------------------
1121: PROCEDURE insert_row(
1122: p_api_version IN NUMBER,
1123: p_init_msg_list IN VARCHAR2 ,
1123: p_init_msg_list IN VARCHAR2 ,
1124: x_return_status OUT NOCOPY VARCHAR2,
1125: x_msg_count OUT NOCOPY NUMBER,
1126: x_msg_data OUT NOCOPY VARCHAR2,
1127: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
1128: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type) IS
1129:
1130: l_api_version CONSTANT NUMBER := 1;
1131: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1124: x_return_status OUT NOCOPY VARCHAR2,
1125: x_msg_count OUT NOCOPY NUMBER,
1126: x_msg_data OUT NOCOPY VARCHAR2,
1127: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
1128: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type) IS
1129:
1130: l_api_version CONSTANT NUMBER := 1;
1131: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1132: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1129:
1130: l_api_version CONSTANT NUMBER := 1;
1131: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1132: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1133: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
1134: l_def_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
1135: l_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
1136: lx_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
1137: -------------------------------
1130: l_api_version CONSTANT NUMBER := 1;
1131: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1132: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1133: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
1134: l_def_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
1135: l_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
1136: lx_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
1137: -------------------------------
1138: -- FUNCTION fill_who_columns --
1137: -------------------------------
1138: -- FUNCTION fill_who_columns --
1139: -------------------------------
1140: FUNCTION fill_who_columns (
1141: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
1142: ) RETURN okc_ph_line_breaks_v_rec_type IS
1143: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
1144: BEGIN
1145: l_okc_ph_line_breaks_v_rec.CREATION_DATE := SYSDATE;
1138: -- FUNCTION fill_who_columns --
1139: -------------------------------
1140: FUNCTION fill_who_columns (
1141: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
1142: ) RETURN okc_ph_line_breaks_v_rec_type IS
1143: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
1144: BEGIN
1145: l_okc_ph_line_breaks_v_rec.CREATION_DATE := SYSDATE;
1146: l_okc_ph_line_breaks_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1139: -------------------------------
1140: FUNCTION fill_who_columns (
1141: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
1142: ) RETURN okc_ph_line_breaks_v_rec_type IS
1143: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
1144: BEGIN
1145: l_okc_ph_line_breaks_v_rec.CREATION_DATE := SYSDATE;
1146: l_okc_ph_line_breaks_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1147: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := l_okc_ph_line_breaks_v_rec.CREATION_DATE;
1141: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
1142: ) RETURN okc_ph_line_breaks_v_rec_type IS
1143: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
1144: BEGIN
1145: l_okc_ph_line_breaks_v_rec.CREATION_DATE := SYSDATE;
1146: l_okc_ph_line_breaks_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1147: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := l_okc_ph_line_breaks_v_rec.CREATION_DATE;
1148: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1149: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1142: ) RETURN okc_ph_line_breaks_v_rec_type IS
1143: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
1144: BEGIN
1145: l_okc_ph_line_breaks_v_rec.CREATION_DATE := SYSDATE;
1146: l_okc_ph_line_breaks_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1147: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := l_okc_ph_line_breaks_v_rec.CREATION_DATE;
1148: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1149: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1150: RETURN(l_okc_ph_line_breaks_v_rec);
1143: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
1144: BEGIN
1145: l_okc_ph_line_breaks_v_rec.CREATION_DATE := SYSDATE;
1146: l_okc_ph_line_breaks_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1147: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := l_okc_ph_line_breaks_v_rec.CREATION_DATE;
1148: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1149: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1150: RETURN(l_okc_ph_line_breaks_v_rec);
1151: END fill_who_columns;
1144: BEGIN
1145: l_okc_ph_line_breaks_v_rec.CREATION_DATE := SYSDATE;
1146: l_okc_ph_line_breaks_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1147: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := l_okc_ph_line_breaks_v_rec.CREATION_DATE;
1148: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1149: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1150: RETURN(l_okc_ph_line_breaks_v_rec);
1151: END fill_who_columns;
1152: ---------------------------------------------
1145: l_okc_ph_line_breaks_v_rec.CREATION_DATE := SYSDATE;
1146: l_okc_ph_line_breaks_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1147: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := l_okc_ph_line_breaks_v_rec.CREATION_DATE;
1148: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1149: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1150: RETURN(l_okc_ph_line_breaks_v_rec);
1151: END fill_who_columns;
1152: ---------------------------------------------
1153: -- Set_Attributes for:OKC_PH_LINE_BREAKS_V --
1146: l_okc_ph_line_breaks_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1147: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := l_okc_ph_line_breaks_v_rec.CREATION_DATE;
1148: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1149: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1150: RETURN(l_okc_ph_line_breaks_v_rec);
1151: END fill_who_columns;
1152: ---------------------------------------------
1153: -- Set_Attributes for:OKC_PH_LINE_BREAKS_V --
1154: ---------------------------------------------
1149: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1150: RETURN(l_okc_ph_line_breaks_v_rec);
1151: END fill_who_columns;
1152: ---------------------------------------------
1153: -- Set_Attributes for:OKC_PH_LINE_BREAKS_V --
1154: ---------------------------------------------
1155: FUNCTION Set_Attributes (
1156: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
1157: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
1152: ---------------------------------------------
1153: -- Set_Attributes for:OKC_PH_LINE_BREAKS_V --
1154: ---------------------------------------------
1155: FUNCTION Set_Attributes (
1156: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
1157: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
1158: ) RETURN VARCHAR2 IS
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1160: BEGIN
1153: -- Set_Attributes for:OKC_PH_LINE_BREAKS_V --
1154: ---------------------------------------------
1155: FUNCTION Set_Attributes (
1156: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
1157: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
1158: ) RETURN VARCHAR2 IS
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1160: BEGIN
1161: x_okc_ph_line_breaks_v_rec := p_okc_ph_line_breaks_v_rec;
1157: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
1158: ) RETURN VARCHAR2 IS
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1160: BEGIN
1161: x_okc_ph_line_breaks_v_rec := p_okc_ph_line_breaks_v_rec;
1162: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER := 1;
1163: RETURN(l_return_status);
1164: END Set_Attributes;
1165: BEGIN
1158: ) RETURN VARCHAR2 IS
1159: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1160: BEGIN
1161: x_okc_ph_line_breaks_v_rec := p_okc_ph_line_breaks_v_rec;
1162: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER := 1;
1163: RETURN(l_return_status);
1164: END Set_Attributes;
1165: BEGIN
1166: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1176: RAISE OKC_API.G_EXCEPTION_ERROR;
1177: END IF;
1178: l_okc_ph_line_breaks_v_rec := null_out_defaults(p_okc_ph_line_breaks_v_rec);
1179: -- Set primary key value
1180: l_okc_ph_line_breaks_v_rec.ID := get_seq_id;
1181: -- Setting item attributes
1182: l_return_Status := Set_Attributes(
1176: RAISE OKC_API.G_EXCEPTION_ERROR;
1177: END IF;
1178: l_okc_ph_line_breaks_v_rec := null_out_defaults(p_okc_ph_line_breaks_v_rec);
1179: -- Set primary key value
1180: l_okc_ph_line_breaks_v_rec.ID := get_seq_id;
1181: -- Setting item attributes
1182: l_return_Status := Set_Attributes(
1183: l_okc_ph_line_breaks_v_rec, -- IN
1184: l_def_okc_ph_line_breaks_v_rec); -- OUT
1179: -- Set primary key value
1180: l_okc_ph_line_breaks_v_rec.ID := get_seq_id;
1181: -- Setting item attributes
1182: l_return_Status := Set_Attributes(
1183: l_okc_ph_line_breaks_v_rec, -- IN
1184: l_def_okc_ph_line_breaks_v_rec); -- OUT
1185: --- If any errors happen abort API
1186: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1180: l_okc_ph_line_breaks_v_rec.ID := get_seq_id;
1181: -- Setting item attributes
1182: l_return_Status := Set_Attributes(
1183: l_okc_ph_line_breaks_v_rec, -- IN
1184: l_def_okc_ph_line_breaks_v_rec); -- OUT
1185: --- If any errors happen abort API
1186: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1188: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1188: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_ERROR;
1190: END IF;
1191: l_def_okc_ph_line_breaks_v_rec := fill_who_columns(l_def_okc_ph_line_breaks_v_rec);
1192: --- Validate all non-missing attributes (Item Level Validation)
1193: l_return_status := Validate_Attributes(l_def_okc_ph_line_breaks_v_rec);
1194: --- If any errors happen abort API
1195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE OKC_API.G_EXCEPTION_ERROR;
1190: END IF;
1191: l_def_okc_ph_line_breaks_v_rec := fill_who_columns(l_def_okc_ph_line_breaks_v_rec);
1192: --- Validate all non-missing attributes (Item Level Validation)
1193: l_return_status := Validate_Attributes(l_def_okc_ph_line_breaks_v_rec);
1194: --- If any errors happen abort API
1195: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1196: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1197: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1198: RAISE OKC_API.G_EXCEPTION_ERROR;
1199: END IF;
1200: l_return_status := Validate_Record(l_def_okc_ph_line_breaks_v_rec);
1201: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1202: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1203: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1204: RAISE OKC_API.G_EXCEPTION_ERROR;
1205: END IF;
1206: -----------------------------------------
1207: -- Move VIEW record to "Child" records --
1208: -----------------------------------------
1209: migrate(l_def_okc_ph_line_breaks_v_rec, l_okc_ph_line_breaks_rec);
1210: -----------------------------------------------
1211: -- Call the INSERT_ROW for each child record --
1212: -----------------------------------------------
1213: insert_row(
1222: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1224: RAISE OKC_API.G_EXCEPTION_ERROR;
1225: END IF;
1226: migrate(lx_okc_ph_line_breaks_rec, l_def_okc_ph_line_breaks_v_rec);
1227: -- Set OUT values
1228: x_okc_ph_line_breaks_v_rec := l_def_okc_ph_line_breaks_v_rec;
1229: x_return_status := l_return_status;
1230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1224: RAISE OKC_API.G_EXCEPTION_ERROR;
1225: END IF;
1226: migrate(lx_okc_ph_line_breaks_rec, l_def_okc_ph_line_breaks_v_rec);
1227: -- Set OUT values
1228: x_okc_ph_line_breaks_v_rec := l_def_okc_ph_line_breaks_v_rec;
1229: x_return_status := l_return_status;
1230: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1231: EXCEPTION
1232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1260: '_PVT'
1261: );
1262: END insert_row;
1263: --------------------------------------------------------
1264: -- PL/SQL TBL insert_row for:OKC_PH_LINE_BREAKS_V_TBL --
1265: --------------------------------------------------------
1266: PROCEDURE insert_row(
1267: p_api_version IN NUMBER,
1268: p_init_msg_list IN VARCHAR2 ,
1268: p_init_msg_list IN VARCHAR2 ,
1269: x_return_status OUT NOCOPY VARCHAR2,
1270: x_msg_count OUT NOCOPY NUMBER,
1271: x_msg_data OUT NOCOPY VARCHAR2,
1272: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
1273: x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type,
1274: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1275:
1276: l_api_version CONSTANT NUMBER := 1;
1269: x_return_status OUT NOCOPY VARCHAR2,
1270: x_msg_count OUT NOCOPY NUMBER,
1271: x_msg_data OUT NOCOPY VARCHAR2,
1272: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
1273: x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type,
1274: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1275:
1276: l_api_version CONSTANT NUMBER := 1;
1277: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1278: i NUMBER := 0;
1279: BEGIN
1280: OKC_API.init_msg_list(p_init_msg_list);
1281: -- Make sure PL/SQL table has records in it before passing
1282: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
1283: i := p_okc_ph_line_breaks_v_tbl.FIRST;
1284: LOOP
1285: DECLARE
1286: l_error_rec OKC_API.ERROR_REC_TYPE;
1279: BEGIN
1280: OKC_API.init_msg_list(p_init_msg_list);
1281: -- Make sure PL/SQL table has records in it before passing
1282: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
1283: i := p_okc_ph_line_breaks_v_tbl.FIRST;
1284: LOOP
1285: DECLARE
1286: l_error_rec OKC_API.ERROR_REC_TYPE;
1287: BEGIN
1293: p_init_msg_list => OKC_API.G_FALSE,
1294: x_return_status => l_error_rec.error_type,
1295: x_msg_count => l_error_rec.msg_count,
1296: x_msg_data => l_error_rec.msg_data,
1297: p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_tbl(i),
1298: x_okc_ph_line_breaks_v_rec => x_okc_ph_line_breaks_v_tbl(i));
1299: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1300: l_error_rec.sqlcode := SQLCODE;
1301: load_error_tbl(l_error_rec, px_error_tbl);
1294: x_return_status => l_error_rec.error_type,
1295: x_msg_count => l_error_rec.msg_count,
1296: x_msg_data => l_error_rec.msg_data,
1297: p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_tbl(i),
1298: x_okc_ph_line_breaks_v_rec => x_okc_ph_line_breaks_v_tbl(i));
1299: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1300: l_error_rec.sqlcode := SQLCODE;
1301: load_error_tbl(l_error_rec, px_error_tbl);
1302: ELSE
1316: l_error_rec.error_type := 'OTHERS';
1317: l_error_rec.sqlcode := SQLCODE;
1318: load_error_tbl(l_error_rec, px_error_tbl);
1319: END;
1320: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
1321: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
1322: END LOOP;
1323: END IF;
1324: -- Loop through the error_tbl to find the error with the highest severity
1317: l_error_rec.sqlcode := SQLCODE;
1318: load_error_tbl(l_error_rec, px_error_tbl);
1319: END;
1320: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
1321: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
1322: END LOOP;
1323: END IF;
1324: -- Loop through the error_tbl to find the error with the highest severity
1325: -- and return it.
1358: );
1359: END insert_row;
1360:
1361: --------------------------------------------------------
1362: -- PL/SQL TBL insert_row for:OKC_PH_LINE_BREAKS_V_TBL --
1363: --------------------------------------------------------
1364: PROCEDURE insert_row(
1365: p_api_version IN NUMBER,
1366: p_init_msg_list IN VARCHAR2 ,
1366: p_init_msg_list IN VARCHAR2 ,
1367: x_return_status OUT NOCOPY VARCHAR2,
1368: x_msg_count OUT NOCOPY NUMBER,
1369: x_msg_data OUT NOCOPY VARCHAR2,
1370: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
1371: x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type) IS
1372:
1373: l_api_version CONSTANT NUMBER := 1;
1374: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1367: x_return_status OUT NOCOPY VARCHAR2,
1368: x_msg_count OUT NOCOPY NUMBER,
1369: x_msg_data OUT NOCOPY VARCHAR2,
1370: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
1371: x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type) IS
1372:
1373: l_api_version CONSTANT NUMBER := 1;
1374: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1375: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1376: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1377: BEGIN
1378: OKC_API.init_msg_list(p_init_msg_list);
1379: -- Make sure PL/SQL table has records in it before passing
1380: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
1381: insert_row (
1382: p_api_version => p_api_version,
1383: p_init_msg_list => OKC_API.G_FALSE,
1384: x_return_status => x_return_status,
1383: p_init_msg_list => OKC_API.G_FALSE,
1384: x_return_status => x_return_status,
1385: x_msg_count => x_msg_count,
1386: x_msg_data => x_msg_data,
1387: p_okc_ph_line_breaks_v_tbl => p_okc_ph_line_breaks_v_tbl,
1388: x_okc_ph_line_breaks_v_tbl => x_okc_ph_line_breaks_v_tbl,
1389: px_error_tbl => l_error_tbl);
1390: END IF;
1391: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1384: x_return_status => x_return_status,
1385: x_msg_count => x_msg_count,
1386: x_msg_data => x_msg_data,
1387: p_okc_ph_line_breaks_v_tbl => p_okc_ph_line_breaks_v_tbl,
1388: x_okc_ph_line_breaks_v_tbl => x_okc_ph_line_breaks_v_tbl,
1389: px_error_tbl => l_error_tbl);
1390: END IF;
1391: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1392: EXCEPTION
1532: '_PVT'
1533: );
1534: END lock_row;
1535: ----------------------------------------
1536: -- lock_row for: OKC_PH_LINE_BREAKS_V --
1537: ----------------------------------------
1538: PROCEDURE lock_row(
1539: p_api_version IN NUMBER,
1540: p_init_msg_list IN VARCHAR2 ,
1540: p_init_msg_list IN VARCHAR2 ,
1541: x_return_status OUT NOCOPY VARCHAR2,
1542: x_msg_count OUT NOCOPY NUMBER,
1543: x_msg_data OUT NOCOPY VARCHAR2,
1544: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type) IS
1545:
1546: l_api_version CONSTANT NUMBER := 1;
1547: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1548: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1562: END IF;
1563: -----------------------------------------
1564: -- Move VIEW record to "Child" records --
1565: -----------------------------------------
1566: migrate(p_okc_ph_line_breaks_v_rec, l_okc_ph_line_breaks_rec);
1567: ---------------------------------------------
1568: -- Call the LOCK_ROW for each child record --
1569: ---------------------------------------------
1570: lock_row(
1613: '_PVT'
1614: );
1615: END lock_row;
1616: ------------------------------------------------------
1617: -- PL/SQL TBL lock_row for:OKC_PH_LINE_BREAKS_V_TBL --
1618: ------------------------------------------------------
1619: PROCEDURE lock_row(
1620: p_api_version IN NUMBER,
1621: p_init_msg_list IN VARCHAR2 ,
1621: p_init_msg_list IN VARCHAR2 ,
1622: x_return_status OUT NOCOPY VARCHAR2,
1623: x_msg_count OUT NOCOPY NUMBER,
1624: x_msg_data OUT NOCOPY VARCHAR2,
1625: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
1626: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1627:
1628: l_api_version CONSTANT NUMBER := 1;
1629: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1630: i NUMBER := 0;
1631: BEGIN
1632: OKC_API.init_msg_list(p_init_msg_list);
1633: -- Make sure PL/SQL table has recrods in it before passing
1634: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
1635: i := p_okc_ph_line_breaks_v_tbl.FIRST;
1636: LOOP
1637: DECLARE
1638: l_error_rec OKC_API.ERROR_REC_TYPE;
1631: BEGIN
1632: OKC_API.init_msg_list(p_init_msg_list);
1633: -- Make sure PL/SQL table has recrods in it before passing
1634: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
1635: i := p_okc_ph_line_breaks_v_tbl.FIRST;
1636: LOOP
1637: DECLARE
1638: l_error_rec OKC_API.ERROR_REC_TYPE;
1639: BEGIN
1645: p_init_msg_list => OKC_API.G_FALSE,
1646: x_return_status => l_error_rec.error_type,
1647: x_msg_count => l_error_rec.msg_count,
1648: x_msg_data => l_error_rec.msg_data,
1649: p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_tbl(i));
1650: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1651: l_error_rec.sqlcode := SQLCODE;
1652: load_error_tbl(l_error_rec, px_error_tbl);
1653: ELSE
1667: l_error_rec.error_type := 'OTHERS';
1668: l_error_rec.sqlcode := SQLCODE;
1669: load_error_tbl(l_error_rec, px_error_tbl);
1670: END;
1671: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
1672: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
1673: END LOOP;
1674: END IF;
1675: -- Loop through the error_tbl to find the error with the highest severity
1668: l_error_rec.sqlcode := SQLCODE;
1669: load_error_tbl(l_error_rec, px_error_tbl);
1670: END;
1671: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
1672: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
1673: END LOOP;
1674: END IF;
1675: -- Loop through the error_tbl to find the error with the highest severity
1676: -- and return it.
1708: '_PVT'
1709: );
1710: END lock_row;
1711: ------------------------------------------------------
1712: -- PL/SQL TBL lock_row for:OKC_PH_LINE_BREAKS_V_TBL --
1713: ------------------------------------------------------
1714: PROCEDURE lock_row(
1715: p_api_version IN NUMBER,
1716: p_init_msg_list IN VARCHAR2 ,
1716: p_init_msg_list IN VARCHAR2 ,
1717: x_return_status OUT NOCOPY VARCHAR2,
1718: x_msg_count OUT NOCOPY NUMBER,
1719: x_msg_data OUT NOCOPY VARCHAR2,
1720: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type) IS
1721:
1722: l_api_version CONSTANT NUMBER := 1;
1723: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1724: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1725: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1726: BEGIN
1727: OKC_API.init_msg_list(p_init_msg_list);
1728: -- Make sure PL/SQL table has recrods in it before passing
1729: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
1730: lock_row(
1731: p_api_version => p_api_version,
1732: p_init_msg_list => OKC_API.G_FALSE,
1733: x_return_status => x_return_status,
1732: p_init_msg_list => OKC_API.G_FALSE,
1733: x_return_status => x_return_status,
1734: x_msg_count => x_msg_count,
1735: x_msg_data => x_msg_data,
1736: p_okc_ph_line_breaks_v_tbl => p_okc_ph_line_breaks_v_tbl,
1737: px_error_tbl => l_error_tbl);
1738: END IF;
1739: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1740: EXCEPTION
1993: '_PVT'
1994: );
1995: END update_row;
1996: -----------------------------------------
1997: -- update_row for:OKC_PH_LINE_BREAKS_V --
1998: -----------------------------------------
1999: PROCEDURE update_row(
2000: p_api_version IN NUMBER,
2001: p_init_msg_list IN VARCHAR2 ,
2001: p_init_msg_list IN VARCHAR2 ,
2002: x_return_status OUT NOCOPY VARCHAR2,
2003: x_msg_count OUT NOCOPY NUMBER,
2004: x_msg_data OUT NOCOPY VARCHAR2,
2005: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
2006: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type) IS
2007:
2008: l_api_version CONSTANT NUMBER := 1;
2009: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2002: x_return_status OUT NOCOPY VARCHAR2,
2003: x_msg_count OUT NOCOPY NUMBER,
2004: x_msg_data OUT NOCOPY VARCHAR2,
2005: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
2006: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type) IS
2007:
2008: l_api_version CONSTANT NUMBER := 1;
2009: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2010: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2007:
2008: l_api_version CONSTANT NUMBER := 1;
2009: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2010: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2011: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2012: l_def_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
2013: l_db_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
2014: l_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
2015: lx_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
2008: l_api_version CONSTANT NUMBER := 1;
2009: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2010: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2011: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2012: l_def_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
2013: l_db_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
2014: l_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
2015: lx_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
2016: -------------------------------
2009: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2010: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2011: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2012: l_def_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
2013: l_db_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type;
2014: l_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
2015: lx_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
2016: -------------------------------
2017: -- FUNCTION fill_who_columns --
2016: -------------------------------
2017: -- FUNCTION fill_who_columns --
2018: -------------------------------
2019: FUNCTION fill_who_columns (
2020: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
2021: ) RETURN okc_ph_line_breaks_v_rec_type IS
2022: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2023: BEGIN
2024: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := SYSDATE;
2017: -- FUNCTION fill_who_columns --
2018: -------------------------------
2019: FUNCTION fill_who_columns (
2020: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
2021: ) RETURN okc_ph_line_breaks_v_rec_type IS
2022: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2023: BEGIN
2024: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := SYSDATE;
2025: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2018: -------------------------------
2019: FUNCTION fill_who_columns (
2020: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
2021: ) RETURN okc_ph_line_breaks_v_rec_type IS
2022: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2023: BEGIN
2024: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := SYSDATE;
2025: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2026: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2020: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type
2021: ) RETURN okc_ph_line_breaks_v_rec_type IS
2022: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2023: BEGIN
2024: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := SYSDATE;
2025: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2026: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2027: RETURN(l_okc_ph_line_breaks_v_rec);
2028: END fill_who_columns;
2021: ) RETURN okc_ph_line_breaks_v_rec_type IS
2022: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2023: BEGIN
2024: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := SYSDATE;
2025: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2026: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2027: RETURN(l_okc_ph_line_breaks_v_rec);
2028: END fill_who_columns;
2029: ----------------------------------
2022: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2023: BEGIN
2024: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := SYSDATE;
2025: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2026: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2027: RETURN(l_okc_ph_line_breaks_v_rec);
2028: END fill_who_columns;
2029: ----------------------------------
2030: -- FUNCTION populate_new_record --
2023: BEGIN
2024: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE := SYSDATE;
2025: l_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2026: l_okc_ph_line_breaks_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2027: RETURN(l_okc_ph_line_breaks_v_rec);
2028: END fill_who_columns;
2029: ----------------------------------
2030: -- FUNCTION populate_new_record --
2031: ----------------------------------
2029: ----------------------------------
2030: -- FUNCTION populate_new_record --
2031: ----------------------------------
2032: FUNCTION populate_new_record (
2033: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
2034: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
2035: ) RETURN VARCHAR2 IS
2036: l_row_notfound BOOLEAN := TRUE;
2037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2030: -- FUNCTION populate_new_record --
2031: ----------------------------------
2032: FUNCTION populate_new_record (
2033: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
2034: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
2035: ) RETURN VARCHAR2 IS
2036: l_row_notfound BOOLEAN := TRUE;
2037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2038: BEGIN
2035: ) RETURN VARCHAR2 IS
2036: l_row_notfound BOOLEAN := TRUE;
2037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2038: BEGIN
2039: x_okc_ph_line_breaks_v_rec := p_okc_ph_line_breaks_v_rec;
2040: -- Get current database values
2041: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2042: -- so it may be verified through LOCK_ROW.
2043: l_db_okc_ph_line_breaks_v_rec := get_rec(p_okc_ph_line_breaks_v_rec, l_return_status);
2039: x_okc_ph_line_breaks_v_rec := p_okc_ph_line_breaks_v_rec;
2040: -- Get current database values
2041: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2042: -- so it may be verified through LOCK_ROW.
2043: l_db_okc_ph_line_breaks_v_rec := get_rec(p_okc_ph_line_breaks_v_rec, l_return_status);
2044: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2045: IF (x_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM)
2046: THEN
2047: x_okc_ph_line_breaks_v_rec.id := l_db_okc_ph_line_breaks_v_rec.id;
2041: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2042: -- so it may be verified through LOCK_ROW.
2043: l_db_okc_ph_line_breaks_v_rec := get_rec(p_okc_ph_line_breaks_v_rec, l_return_status);
2044: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2045: IF (x_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM)
2046: THEN
2047: x_okc_ph_line_breaks_v_rec.id := l_db_okc_ph_line_breaks_v_rec.id;
2048: END IF;
2049: IF (x_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM)
2043: l_db_okc_ph_line_breaks_v_rec := get_rec(p_okc_ph_line_breaks_v_rec, l_return_status);
2044: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2045: IF (x_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM)
2046: THEN
2047: x_okc_ph_line_breaks_v_rec.id := l_db_okc_ph_line_breaks_v_rec.id;
2048: END IF;
2049: IF (x_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM)
2050: THEN
2051: x_okc_ph_line_breaks_v_rec.cle_id := l_db_okc_ph_line_breaks_v_rec.cle_id;
2045: IF (x_okc_ph_line_breaks_v_rec.id = OKC_API.G_MISS_NUM)
2046: THEN
2047: x_okc_ph_line_breaks_v_rec.id := l_db_okc_ph_line_breaks_v_rec.id;
2048: END IF;
2049: IF (x_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM)
2050: THEN
2051: x_okc_ph_line_breaks_v_rec.cle_id := l_db_okc_ph_line_breaks_v_rec.cle_id;
2052: END IF;
2053: IF (x_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM)
2047: x_okc_ph_line_breaks_v_rec.id := l_db_okc_ph_line_breaks_v_rec.id;
2048: END IF;
2049: IF (x_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM)
2050: THEN
2051: x_okc_ph_line_breaks_v_rec.cle_id := l_db_okc_ph_line_breaks_v_rec.cle_id;
2052: END IF;
2053: IF (x_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM)
2054: THEN
2055: x_okc_ph_line_breaks_v_rec.value_from := l_db_okc_ph_line_breaks_v_rec.value_from;
2049: IF (x_okc_ph_line_breaks_v_rec.cle_id = OKC_API.G_MISS_NUM)
2050: THEN
2051: x_okc_ph_line_breaks_v_rec.cle_id := l_db_okc_ph_line_breaks_v_rec.cle_id;
2052: END IF;
2053: IF (x_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM)
2054: THEN
2055: x_okc_ph_line_breaks_v_rec.value_from := l_db_okc_ph_line_breaks_v_rec.value_from;
2056: END IF;
2057: IF (x_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM)
2051: x_okc_ph_line_breaks_v_rec.cle_id := l_db_okc_ph_line_breaks_v_rec.cle_id;
2052: END IF;
2053: IF (x_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM)
2054: THEN
2055: x_okc_ph_line_breaks_v_rec.value_from := l_db_okc_ph_line_breaks_v_rec.value_from;
2056: END IF;
2057: IF (x_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM)
2058: THEN
2059: x_okc_ph_line_breaks_v_rec.value_to := l_db_okc_ph_line_breaks_v_rec.value_to;
2053: IF (x_okc_ph_line_breaks_v_rec.value_from = OKC_API.G_MISS_NUM)
2054: THEN
2055: x_okc_ph_line_breaks_v_rec.value_from := l_db_okc_ph_line_breaks_v_rec.value_from;
2056: END IF;
2057: IF (x_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM)
2058: THEN
2059: x_okc_ph_line_breaks_v_rec.value_to := l_db_okc_ph_line_breaks_v_rec.value_to;
2060: END IF;
2061: IF (x_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR)
2055: x_okc_ph_line_breaks_v_rec.value_from := l_db_okc_ph_line_breaks_v_rec.value_from;
2056: END IF;
2057: IF (x_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM)
2058: THEN
2059: x_okc_ph_line_breaks_v_rec.value_to := l_db_okc_ph_line_breaks_v_rec.value_to;
2060: END IF;
2061: IF (x_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_okc_ph_line_breaks_v_rec.pricing_type := l_db_okc_ph_line_breaks_v_rec.pricing_type;
2057: IF (x_okc_ph_line_breaks_v_rec.value_to = OKC_API.G_MISS_NUM)
2058: THEN
2059: x_okc_ph_line_breaks_v_rec.value_to := l_db_okc_ph_line_breaks_v_rec.value_to;
2060: END IF;
2061: IF (x_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_okc_ph_line_breaks_v_rec.pricing_type := l_db_okc_ph_line_breaks_v_rec.pricing_type;
2064: END IF;
2065: IF (x_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM)
2059: x_okc_ph_line_breaks_v_rec.value_to := l_db_okc_ph_line_breaks_v_rec.value_to;
2060: END IF;
2061: IF (x_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_okc_ph_line_breaks_v_rec.pricing_type := l_db_okc_ph_line_breaks_v_rec.pricing_type;
2064: END IF;
2065: IF (x_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM)
2066: THEN
2067: x_okc_ph_line_breaks_v_rec.value := l_db_okc_ph_line_breaks_v_rec.value;
2061: IF (x_okc_ph_line_breaks_v_rec.pricing_type = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_okc_ph_line_breaks_v_rec.pricing_type := l_db_okc_ph_line_breaks_v_rec.pricing_type;
2064: END IF;
2065: IF (x_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM)
2066: THEN
2067: x_okc_ph_line_breaks_v_rec.value := l_db_okc_ph_line_breaks_v_rec.value;
2068: END IF;
2069: IF (x_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE)
2063: x_okc_ph_line_breaks_v_rec.pricing_type := l_db_okc_ph_line_breaks_v_rec.pricing_type;
2064: END IF;
2065: IF (x_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM)
2066: THEN
2067: x_okc_ph_line_breaks_v_rec.value := l_db_okc_ph_line_breaks_v_rec.value;
2068: END IF;
2069: IF (x_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE)
2070: THEN
2071: x_okc_ph_line_breaks_v_rec.start_date := l_db_okc_ph_line_breaks_v_rec.start_date;
2065: IF (x_okc_ph_line_breaks_v_rec.value = OKC_API.G_MISS_NUM)
2066: THEN
2067: x_okc_ph_line_breaks_v_rec.value := l_db_okc_ph_line_breaks_v_rec.value;
2068: END IF;
2069: IF (x_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE)
2070: THEN
2071: x_okc_ph_line_breaks_v_rec.start_date := l_db_okc_ph_line_breaks_v_rec.start_date;
2072: END IF;
2073: IF (x_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE)
2067: x_okc_ph_line_breaks_v_rec.value := l_db_okc_ph_line_breaks_v_rec.value;
2068: END IF;
2069: IF (x_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE)
2070: THEN
2071: x_okc_ph_line_breaks_v_rec.start_date := l_db_okc_ph_line_breaks_v_rec.start_date;
2072: END IF;
2073: IF (x_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE)
2074: THEN
2075: x_okc_ph_line_breaks_v_rec.end_date := l_db_okc_ph_line_breaks_v_rec.end_date;
2069: IF (x_okc_ph_line_breaks_v_rec.start_date = OKC_API.G_MISS_DATE)
2070: THEN
2071: x_okc_ph_line_breaks_v_rec.start_date := l_db_okc_ph_line_breaks_v_rec.start_date;
2072: END IF;
2073: IF (x_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE)
2074: THEN
2075: x_okc_ph_line_breaks_v_rec.end_date := l_db_okc_ph_line_breaks_v_rec.end_date;
2076: END IF;
2077: IF (x_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM)
2071: x_okc_ph_line_breaks_v_rec.start_date := l_db_okc_ph_line_breaks_v_rec.start_date;
2072: END IF;
2073: IF (x_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE)
2074: THEN
2075: x_okc_ph_line_breaks_v_rec.end_date := l_db_okc_ph_line_breaks_v_rec.end_date;
2076: END IF;
2077: IF (x_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM)
2078: THEN
2079: x_okc_ph_line_breaks_v_rec.created_by := l_db_okc_ph_line_breaks_v_rec.created_by;
2073: IF (x_okc_ph_line_breaks_v_rec.end_date = OKC_API.G_MISS_DATE)
2074: THEN
2075: x_okc_ph_line_breaks_v_rec.end_date := l_db_okc_ph_line_breaks_v_rec.end_date;
2076: END IF;
2077: IF (x_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM)
2078: THEN
2079: x_okc_ph_line_breaks_v_rec.created_by := l_db_okc_ph_line_breaks_v_rec.created_by;
2080: END IF;
2081: IF (x_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE)
2075: x_okc_ph_line_breaks_v_rec.end_date := l_db_okc_ph_line_breaks_v_rec.end_date;
2076: END IF;
2077: IF (x_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM)
2078: THEN
2079: x_okc_ph_line_breaks_v_rec.created_by := l_db_okc_ph_line_breaks_v_rec.created_by;
2080: END IF;
2081: IF (x_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE)
2082: THEN
2083: x_okc_ph_line_breaks_v_rec.creation_date := l_db_okc_ph_line_breaks_v_rec.creation_date;
2077: IF (x_okc_ph_line_breaks_v_rec.created_by = OKC_API.G_MISS_NUM)
2078: THEN
2079: x_okc_ph_line_breaks_v_rec.created_by := l_db_okc_ph_line_breaks_v_rec.created_by;
2080: END IF;
2081: IF (x_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE)
2082: THEN
2083: x_okc_ph_line_breaks_v_rec.creation_date := l_db_okc_ph_line_breaks_v_rec.creation_date;
2084: END IF;
2085: IF (x_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2079: x_okc_ph_line_breaks_v_rec.created_by := l_db_okc_ph_line_breaks_v_rec.created_by;
2080: END IF;
2081: IF (x_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE)
2082: THEN
2083: x_okc_ph_line_breaks_v_rec.creation_date := l_db_okc_ph_line_breaks_v_rec.creation_date;
2084: END IF;
2085: IF (x_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_okc_ph_line_breaks_v_rec.last_updated_by := l_db_okc_ph_line_breaks_v_rec.last_updated_by;
2081: IF (x_okc_ph_line_breaks_v_rec.creation_date = OKC_API.G_MISS_DATE)
2082: THEN
2083: x_okc_ph_line_breaks_v_rec.creation_date := l_db_okc_ph_line_breaks_v_rec.creation_date;
2084: END IF;
2085: IF (x_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_okc_ph_line_breaks_v_rec.last_updated_by := l_db_okc_ph_line_breaks_v_rec.last_updated_by;
2088: END IF;
2089: IF (x_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2083: x_okc_ph_line_breaks_v_rec.creation_date := l_db_okc_ph_line_breaks_v_rec.creation_date;
2084: END IF;
2085: IF (x_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_okc_ph_line_breaks_v_rec.last_updated_by := l_db_okc_ph_line_breaks_v_rec.last_updated_by;
2088: END IF;
2089: IF (x_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_okc_ph_line_breaks_v_rec.last_update_date := l_db_okc_ph_line_breaks_v_rec.last_update_date;
2085: IF (x_okc_ph_line_breaks_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_okc_ph_line_breaks_v_rec.last_updated_by := l_db_okc_ph_line_breaks_v_rec.last_updated_by;
2088: END IF;
2089: IF (x_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_okc_ph_line_breaks_v_rec.last_update_date := l_db_okc_ph_line_breaks_v_rec.last_update_date;
2092: END IF;
2093: IF (x_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2087: x_okc_ph_line_breaks_v_rec.last_updated_by := l_db_okc_ph_line_breaks_v_rec.last_updated_by;
2088: END IF;
2089: IF (x_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_okc_ph_line_breaks_v_rec.last_update_date := l_db_okc_ph_line_breaks_v_rec.last_update_date;
2092: END IF;
2093: IF (x_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_okc_ph_line_breaks_v_rec.program_application_id := l_db_okc_ph_line_breaks_v_rec.program_application_id;
2089: IF (x_okc_ph_line_breaks_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_okc_ph_line_breaks_v_rec.last_update_date := l_db_okc_ph_line_breaks_v_rec.last_update_date;
2092: END IF;
2093: IF (x_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_okc_ph_line_breaks_v_rec.program_application_id := l_db_okc_ph_line_breaks_v_rec.program_application_id;
2096: END IF;
2097: IF (x_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM)
2091: x_okc_ph_line_breaks_v_rec.last_update_date := l_db_okc_ph_line_breaks_v_rec.last_update_date;
2092: END IF;
2093: IF (x_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_okc_ph_line_breaks_v_rec.program_application_id := l_db_okc_ph_line_breaks_v_rec.program_application_id;
2096: END IF;
2097: IF (x_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM)
2098: THEN
2099: x_okc_ph_line_breaks_v_rec.program_id := l_db_okc_ph_line_breaks_v_rec.program_id;
2093: IF (x_okc_ph_line_breaks_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_okc_ph_line_breaks_v_rec.program_application_id := l_db_okc_ph_line_breaks_v_rec.program_application_id;
2096: END IF;
2097: IF (x_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM)
2098: THEN
2099: x_okc_ph_line_breaks_v_rec.program_id := l_db_okc_ph_line_breaks_v_rec.program_id;
2100: END IF;
2101: IF (x_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2095: x_okc_ph_line_breaks_v_rec.program_application_id := l_db_okc_ph_line_breaks_v_rec.program_application_id;
2096: END IF;
2097: IF (x_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM)
2098: THEN
2099: x_okc_ph_line_breaks_v_rec.program_id := l_db_okc_ph_line_breaks_v_rec.program_id;
2100: END IF;
2101: IF (x_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2102: THEN
2103: x_okc_ph_line_breaks_v_rec.program_update_date := l_db_okc_ph_line_breaks_v_rec.program_update_date;
2097: IF (x_okc_ph_line_breaks_v_rec.program_id = OKC_API.G_MISS_NUM)
2098: THEN
2099: x_okc_ph_line_breaks_v_rec.program_id := l_db_okc_ph_line_breaks_v_rec.program_id;
2100: END IF;
2101: IF (x_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2102: THEN
2103: x_okc_ph_line_breaks_v_rec.program_update_date := l_db_okc_ph_line_breaks_v_rec.program_update_date;
2104: END IF;
2105: IF (x_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM)
2099: x_okc_ph_line_breaks_v_rec.program_id := l_db_okc_ph_line_breaks_v_rec.program_id;
2100: END IF;
2101: IF (x_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2102: THEN
2103: x_okc_ph_line_breaks_v_rec.program_update_date := l_db_okc_ph_line_breaks_v_rec.program_update_date;
2104: END IF;
2105: IF (x_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM)
2106: THEN
2107: x_okc_ph_line_breaks_v_rec.request_id := l_db_okc_ph_line_breaks_v_rec.request_id;
2101: IF (x_okc_ph_line_breaks_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2102: THEN
2103: x_okc_ph_line_breaks_v_rec.program_update_date := l_db_okc_ph_line_breaks_v_rec.program_update_date;
2104: END IF;
2105: IF (x_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM)
2106: THEN
2107: x_okc_ph_line_breaks_v_rec.request_id := l_db_okc_ph_line_breaks_v_rec.request_id;
2108: END IF;
2109: IF (x_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR)
2103: x_okc_ph_line_breaks_v_rec.program_update_date := l_db_okc_ph_line_breaks_v_rec.program_update_date;
2104: END IF;
2105: IF (x_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM)
2106: THEN
2107: x_okc_ph_line_breaks_v_rec.request_id := l_db_okc_ph_line_breaks_v_rec.request_id;
2108: END IF;
2109: IF (x_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR)
2110: THEN
2111: x_okc_ph_line_breaks_v_rec.integrated_with_qp := l_db_okc_ph_line_breaks_v_rec.integrated_with_qp;
2105: IF (x_okc_ph_line_breaks_v_rec.request_id = OKC_API.G_MISS_NUM)
2106: THEN
2107: x_okc_ph_line_breaks_v_rec.request_id := l_db_okc_ph_line_breaks_v_rec.request_id;
2108: END IF;
2109: IF (x_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR)
2110: THEN
2111: x_okc_ph_line_breaks_v_rec.integrated_with_qp := l_db_okc_ph_line_breaks_v_rec.integrated_with_qp;
2112: END IF;
2113: IF (x_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM)
2107: x_okc_ph_line_breaks_v_rec.request_id := l_db_okc_ph_line_breaks_v_rec.request_id;
2108: END IF;
2109: IF (x_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR)
2110: THEN
2111: x_okc_ph_line_breaks_v_rec.integrated_with_qp := l_db_okc_ph_line_breaks_v_rec.integrated_with_qp;
2112: END IF;
2113: IF (x_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM)
2114: THEN
2115: x_okc_ph_line_breaks_v_rec.qp_reference_id := l_db_okc_ph_line_breaks_v_rec.qp_reference_id;
2109: IF (x_okc_ph_line_breaks_v_rec.integrated_with_qp = OKC_API.G_MISS_CHAR)
2110: THEN
2111: x_okc_ph_line_breaks_v_rec.integrated_with_qp := l_db_okc_ph_line_breaks_v_rec.integrated_with_qp;
2112: END IF;
2113: IF (x_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM)
2114: THEN
2115: x_okc_ph_line_breaks_v_rec.qp_reference_id := l_db_okc_ph_line_breaks_v_rec.qp_reference_id;
2116: END IF;
2117: IF (x_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM)
2111: x_okc_ph_line_breaks_v_rec.integrated_with_qp := l_db_okc_ph_line_breaks_v_rec.integrated_with_qp;
2112: END IF;
2113: IF (x_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM)
2114: THEN
2115: x_okc_ph_line_breaks_v_rec.qp_reference_id := l_db_okc_ph_line_breaks_v_rec.qp_reference_id;
2116: END IF;
2117: IF (x_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM)
2118: THEN
2119: x_okc_ph_line_breaks_v_rec.ship_to_organization_id := l_db_okc_ph_line_breaks_v_rec.ship_to_organization_id;
2113: IF (x_okc_ph_line_breaks_v_rec.qp_reference_id = OKC_API.G_MISS_NUM)
2114: THEN
2115: x_okc_ph_line_breaks_v_rec.qp_reference_id := l_db_okc_ph_line_breaks_v_rec.qp_reference_id;
2116: END IF;
2117: IF (x_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM)
2118: THEN
2119: x_okc_ph_line_breaks_v_rec.ship_to_organization_id := l_db_okc_ph_line_breaks_v_rec.ship_to_organization_id;
2120: END IF;
2121: IF (x_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM)
2115: x_okc_ph_line_breaks_v_rec.qp_reference_id := l_db_okc_ph_line_breaks_v_rec.qp_reference_id;
2116: END IF;
2117: IF (x_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM)
2118: THEN
2119: x_okc_ph_line_breaks_v_rec.ship_to_organization_id := l_db_okc_ph_line_breaks_v_rec.ship_to_organization_id;
2120: END IF;
2121: IF (x_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM)
2122: THEN
2123: x_okc_ph_line_breaks_v_rec.ship_to_location_id := l_db_okc_ph_line_breaks_v_rec.ship_to_location_id;
2117: IF (x_okc_ph_line_breaks_v_rec.ship_to_organization_id = OKC_API.G_MISS_NUM)
2118: THEN
2119: x_okc_ph_line_breaks_v_rec.ship_to_organization_id := l_db_okc_ph_line_breaks_v_rec.ship_to_organization_id;
2120: END IF;
2121: IF (x_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM)
2122: THEN
2123: x_okc_ph_line_breaks_v_rec.ship_to_location_id := l_db_okc_ph_line_breaks_v_rec.ship_to_location_id;
2124: END IF;
2125: IF (x_okc_ph_line_breaks_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2119: x_okc_ph_line_breaks_v_rec.ship_to_organization_id := l_db_okc_ph_line_breaks_v_rec.ship_to_organization_id;
2120: END IF;
2121: IF (x_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM)
2122: THEN
2123: x_okc_ph_line_breaks_v_rec.ship_to_location_id := l_db_okc_ph_line_breaks_v_rec.ship_to_location_id;
2124: END IF;
2125: IF (x_okc_ph_line_breaks_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2126: THEN
2127: x_okc_ph_line_breaks_v_rec.last_update_login := l_db_okc_ph_line_breaks_v_rec.last_update_login;
2121: IF (x_okc_ph_line_breaks_v_rec.ship_to_location_id = OKC_API.G_MISS_NUM)
2122: THEN
2123: x_okc_ph_line_breaks_v_rec.ship_to_location_id := l_db_okc_ph_line_breaks_v_rec.ship_to_location_id;
2124: END IF;
2125: IF (x_okc_ph_line_breaks_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2126: THEN
2127: x_okc_ph_line_breaks_v_rec.last_update_login := l_db_okc_ph_line_breaks_v_rec.last_update_login;
2128: END IF;
2129: END IF;
2123: x_okc_ph_line_breaks_v_rec.ship_to_location_id := l_db_okc_ph_line_breaks_v_rec.ship_to_location_id;
2124: END IF;
2125: IF (x_okc_ph_line_breaks_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2126: THEN
2127: x_okc_ph_line_breaks_v_rec.last_update_login := l_db_okc_ph_line_breaks_v_rec.last_update_login;
2128: END IF;
2129: END IF;
2130: RETURN(l_return_status);
2131: END populate_new_record;
2129: END IF;
2130: RETURN(l_return_status);
2131: END populate_new_record;
2132: ---------------------------------------------
2133: -- Set_Attributes for:OKC_PH_LINE_BREAKS_V --
2134: ---------------------------------------------
2135: FUNCTION Set_Attributes (
2136: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
2137: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
2132: ---------------------------------------------
2133: -- Set_Attributes for:OKC_PH_LINE_BREAKS_V --
2134: ---------------------------------------------
2135: FUNCTION Set_Attributes (
2136: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
2137: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
2138: ) RETURN VARCHAR2 IS
2139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2140: BEGIN
2133: -- Set_Attributes for:OKC_PH_LINE_BREAKS_V --
2134: ---------------------------------------------
2135: FUNCTION Set_Attributes (
2136: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type,
2137: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
2138: ) RETURN VARCHAR2 IS
2139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2140: BEGIN
2141: x_okc_ph_line_breaks_v_rec := p_okc_ph_line_breaks_v_rec;
2137: x_okc_ph_line_breaks_v_rec OUT NOCOPY okc_ph_line_breaks_v_rec_type
2138: ) RETURN VARCHAR2 IS
2139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2140: BEGIN
2141: x_okc_ph_line_breaks_v_rec := p_okc_ph_line_breaks_v_rec;
2142: RETURN(l_return_status);
2143: END Set_Attributes;
2144: BEGIN
2145: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2155: RAISE OKC_API.G_EXCEPTION_ERROR;
2156: END IF;
2157: --- Setting item attributes
2158: l_return_status := Set_Attributes(
2159: p_okc_ph_line_breaks_v_rec, -- IN
2160: x_okc_ph_line_breaks_v_rec); -- OUT
2161: --- If any errors happen abort API
2162: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2163: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2156: END IF;
2157: --- Setting item attributes
2158: l_return_status := Set_Attributes(
2159: p_okc_ph_line_breaks_v_rec, -- IN
2160: x_okc_ph_line_breaks_v_rec); -- OUT
2161: --- If any errors happen abort API
2162: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2163: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2164: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2163: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2164: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2165: RAISE OKC_API.G_EXCEPTION_ERROR;
2166: END IF;
2167: l_return_status := populate_new_record(l_okc_ph_line_breaks_v_rec, l_def_okc_ph_line_breaks_v_rec);
2168: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2169: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2170: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2171: RAISE OKC_API.G_EXCEPTION_ERROR;
2169: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2170: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2171: RAISE OKC_API.G_EXCEPTION_ERROR;
2172: END IF;
2173: l_def_okc_ph_line_breaks_v_rec := fill_who_columns(l_def_okc_ph_line_breaks_v_rec);
2174: --- Validate all non-missing attributes (Item Level Validation)
2175: l_return_status := Validate_Attributes(l_def_okc_ph_line_breaks_v_rec);
2176: --- If any errors happen abort API
2177: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2171: RAISE OKC_API.G_EXCEPTION_ERROR;
2172: END IF;
2173: l_def_okc_ph_line_breaks_v_rec := fill_who_columns(l_def_okc_ph_line_breaks_v_rec);
2174: --- Validate all non-missing attributes (Item Level Validation)
2175: l_return_status := Validate_Attributes(l_def_okc_ph_line_breaks_v_rec);
2176: --- If any errors happen abort API
2177: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2178: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2178: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2180: RAISE OKC_API.G_EXCEPTION_ERROR;
2181: END IF;
2182: l_return_status := Validate_Record(l_def_okc_ph_line_breaks_v_rec, l_db_okc_ph_line_breaks_v_rec);
2183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2186: RAISE OKC_API.G_EXCEPTION_ERROR;
2192: p_init_msg_list => p_init_msg_list,
2193: x_return_status => l_return_status,
2194: x_msg_count => x_msg_count,
2195: x_msg_data => x_msg_data,
2196: p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_rec);
2197: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2199: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_ERROR;
2202:
2203: -----------------------------------------
2204: -- Move VIEW record to "Child" records --
2205: -----------------------------------------
2206: migrate(l_def_okc_ph_line_breaks_v_rec, l_okc_ph_line_breaks_rec);
2207: -----------------------------------------------
2208: -- Call the UPDATE_ROW for each child record --
2209: -----------------------------------------------
2210: update_row(
2219: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2220: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2221: RAISE OKC_API.G_EXCEPTION_ERROR;
2222: END IF;
2223: migrate(lx_okc_ph_line_breaks_rec, l_def_okc_ph_line_breaks_v_rec);
2224: x_okc_ph_line_breaks_v_rec := l_def_okc_ph_line_breaks_v_rec;
2225: x_return_status := l_return_status;
2226: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2227: EXCEPTION
2220: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2221: RAISE OKC_API.G_EXCEPTION_ERROR;
2222: END IF;
2223: migrate(lx_okc_ph_line_breaks_rec, l_def_okc_ph_line_breaks_v_rec);
2224: x_okc_ph_line_breaks_v_rec := l_def_okc_ph_line_breaks_v_rec;
2225: x_return_status := l_return_status;
2226: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2227: EXCEPTION
2228: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2256: '_PVT'
2257: );
2258: END update_row;
2259: --------------------------------------------------------
2260: -- PL/SQL TBL update_row for:okc_ph_line_breaks_v_tbl --
2261: --------------------------------------------------------
2262: PROCEDURE update_row(
2263: p_api_version IN NUMBER,
2264: p_init_msg_list IN VARCHAR2 ,
2264: p_init_msg_list IN VARCHAR2 ,
2265: x_return_status OUT NOCOPY VARCHAR2,
2266: x_msg_count OUT NOCOPY NUMBER,
2267: x_msg_data OUT NOCOPY VARCHAR2,
2268: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
2269: x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type,
2270: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2271:
2272: l_api_version CONSTANT NUMBER := 1;
2265: x_return_status OUT NOCOPY VARCHAR2,
2266: x_msg_count OUT NOCOPY NUMBER,
2267: x_msg_data OUT NOCOPY VARCHAR2,
2268: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
2269: x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type,
2270: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2271:
2272: l_api_version CONSTANT NUMBER := 1;
2273: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2274: i NUMBER := 0;
2275: BEGIN
2276: OKC_API.init_msg_list(p_init_msg_list);
2277: -- Make sure PL/SQL table has records in it before passing
2278: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
2279: i := p_okc_ph_line_breaks_v_tbl.FIRST;
2280: LOOP
2281: DECLARE
2282: l_error_rec OKC_API.ERROR_REC_TYPE;
2275: BEGIN
2276: OKC_API.init_msg_list(p_init_msg_list);
2277: -- Make sure PL/SQL table has records in it before passing
2278: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
2279: i := p_okc_ph_line_breaks_v_tbl.FIRST;
2280: LOOP
2281: DECLARE
2282: l_error_rec OKC_API.ERROR_REC_TYPE;
2283: BEGIN
2289: p_init_msg_list => OKC_API.G_FALSE,
2290: x_return_status => l_error_rec.error_type,
2291: x_msg_count => l_error_rec.msg_count,
2292: x_msg_data => l_error_rec.msg_data,
2293: p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_tbl(i),
2294: x_okc_ph_line_breaks_v_rec => x_okc_ph_line_breaks_v_tbl(i));
2295: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2296: l_error_rec.sqlcode := SQLCODE;
2297: load_error_tbl(l_error_rec, px_error_tbl);
2290: x_return_status => l_error_rec.error_type,
2291: x_msg_count => l_error_rec.msg_count,
2292: x_msg_data => l_error_rec.msg_data,
2293: p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_tbl(i),
2294: x_okc_ph_line_breaks_v_rec => x_okc_ph_line_breaks_v_tbl(i));
2295: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2296: l_error_rec.sqlcode := SQLCODE;
2297: load_error_tbl(l_error_rec, px_error_tbl);
2298: ELSE
2312: l_error_rec.error_type := 'OTHERS';
2313: l_error_rec.sqlcode := SQLCODE;
2314: load_error_tbl(l_error_rec, px_error_tbl);
2315: END;
2316: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
2317: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
2318: END LOOP;
2319: END IF;
2320: -- Loop through the error_tbl to find the error with the highest severity
2313: l_error_rec.sqlcode := SQLCODE;
2314: load_error_tbl(l_error_rec, px_error_tbl);
2315: END;
2316: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
2317: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
2318: END LOOP;
2319: END IF;
2320: -- Loop through the error_tbl to find the error with the highest severity
2321: -- and return it.
2354: );
2355: END update_row;
2356:
2357: --------------------------------------------------------
2358: -- PL/SQL TBL update_row for:OKC_PH_LINE_BREAKS_V_TBL --
2359: --------------------------------------------------------
2360: PROCEDURE update_row(
2361: p_api_version IN NUMBER,
2362: p_init_msg_list IN VARCHAR2 ,
2362: p_init_msg_list IN VARCHAR2 ,
2363: x_return_status OUT NOCOPY VARCHAR2,
2364: x_msg_count OUT NOCOPY NUMBER,
2365: x_msg_data OUT NOCOPY VARCHAR2,
2366: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
2367: x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type) IS
2368:
2369: l_api_version CONSTANT NUMBER := 1;
2370: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2363: x_return_status OUT NOCOPY VARCHAR2,
2364: x_msg_count OUT NOCOPY NUMBER,
2365: x_msg_data OUT NOCOPY VARCHAR2,
2366: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
2367: x_okc_ph_line_breaks_v_tbl OUT NOCOPY okc_ph_line_breaks_v_tbl_type) IS
2368:
2369: l_api_version CONSTANT NUMBER := 1;
2370: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2371: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2372: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2373: BEGIN
2374: OKC_API.init_msg_list(p_init_msg_list);
2375: -- Make sure PL/SQL table has records in it before passing
2376: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
2377: update_row (
2378: p_api_version => p_api_version,
2379: p_init_msg_list => OKC_API.G_FALSE,
2380: x_return_status => x_return_status,
2379: p_init_msg_list => OKC_API.G_FALSE,
2380: x_return_status => x_return_status,
2381: x_msg_count => x_msg_count,
2382: x_msg_data => x_msg_data,
2383: p_okc_ph_line_breaks_v_tbl => p_okc_ph_line_breaks_v_tbl,
2384: x_okc_ph_line_breaks_v_tbl => x_okc_ph_line_breaks_v_tbl,
2385: px_error_tbl => l_error_tbl);
2386: END IF;
2387: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2380: x_return_status => x_return_status,
2381: x_msg_count => x_msg_count,
2382: x_msg_data => x_msg_data,
2383: p_okc_ph_line_breaks_v_tbl => p_okc_ph_line_breaks_v_tbl,
2384: x_okc_ph_line_breaks_v_tbl => x_okc_ph_line_breaks_v_tbl,
2385: px_error_tbl => l_error_tbl);
2386: END IF;
2387: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2388: EXCEPTION
2484: '_PVT'
2485: );
2486: END delete_row;
2487: -----------------------------------------
2488: -- delete_row for:OKC_PH_LINE_BREAKS_V --
2489: -----------------------------------------
2490: PROCEDURE delete_row(
2491: p_api_version IN NUMBER,
2492: p_init_msg_list IN VARCHAR2 ,
2492: p_init_msg_list IN VARCHAR2 ,
2493: x_return_status OUT NOCOPY VARCHAR2,
2494: x_msg_count OUT NOCOPY NUMBER,
2495: x_msg_data OUT NOCOPY VARCHAR2,
2496: p_okc_ph_line_breaks_v_rec IN okc_ph_line_breaks_v_rec_type) IS
2497:
2498: l_api_version CONSTANT NUMBER := 1;
2499: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2500: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2497:
2498: l_api_version CONSTANT NUMBER := 1;
2499: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2500: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2501: l_okc_ph_line_breaks_v_rec okc_ph_line_breaks_v_rec_type := p_okc_ph_line_breaks_v_rec;
2502: l_okc_ph_line_breaks_rec okc_ph_line_breaks_rec_type;
2503: BEGIN
2504: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2505: G_PKG_NAME,
2515: END IF;
2516: -----------------------------------------
2517: -- Move VIEW record to "Child" records --
2518: -----------------------------------------
2519: migrate(l_okc_ph_line_breaks_v_rec, l_okc_ph_line_breaks_rec);
2520: -----------------------------------------------
2521: -- Call the DELETE_ROW for each child record --
2522: -----------------------------------------------
2523: delete_row(
2566: '_PVT'
2567: );
2568: END delete_row;
2569: ----------------------------------------------------
2570: -- PL/SQL TBL delete_row for:OKC_PH_LINE_BREAKS_V --
2571: ----------------------------------------------------
2572: PROCEDURE delete_row(
2573: p_api_version IN NUMBER,
2574: p_init_msg_list IN VARCHAR2 ,
2574: p_init_msg_list IN VARCHAR2 ,
2575: x_return_status OUT NOCOPY VARCHAR2,
2576: x_msg_count OUT NOCOPY NUMBER,
2577: x_msg_data OUT NOCOPY VARCHAR2,
2578: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type,
2579: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2580:
2581: l_api_version CONSTANT NUMBER := 1;
2582: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2583: i NUMBER := 0;
2584: BEGIN
2585: OKC_API.init_msg_list(p_init_msg_list);
2586: -- Make sure PL/SQL table has records in it before passing
2587: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
2588: i := p_okc_ph_line_breaks_v_tbl.FIRST;
2589: LOOP
2590: DECLARE
2591: l_error_rec OKC_API.ERROR_REC_TYPE;
2584: BEGIN
2585: OKC_API.init_msg_list(p_init_msg_list);
2586: -- Make sure PL/SQL table has records in it before passing
2587: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
2588: i := p_okc_ph_line_breaks_v_tbl.FIRST;
2589: LOOP
2590: DECLARE
2591: l_error_rec OKC_API.ERROR_REC_TYPE;
2592: BEGIN
2598: p_init_msg_list => OKC_API.G_FALSE,
2599: x_return_status => l_error_rec.error_type,
2600: x_msg_count => l_error_rec.msg_count,
2601: x_msg_data => l_error_rec.msg_data,
2602: p_okc_ph_line_breaks_v_rec => p_okc_ph_line_breaks_v_tbl(i));
2603: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2604: l_error_rec.sqlcode := SQLCODE;
2605: load_error_tbl(l_error_rec, px_error_tbl);
2606: ELSE
2620: l_error_rec.error_type := 'OTHERS';
2621: l_error_rec.sqlcode := SQLCODE;
2622: load_error_tbl(l_error_rec, px_error_tbl);
2623: END;
2624: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
2625: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
2626: END LOOP;
2627: END IF;
2628: -- Loop through the error_tbl to find the error with the highest severity
2621: l_error_rec.sqlcode := SQLCODE;
2622: load_error_tbl(l_error_rec, px_error_tbl);
2623: END;
2624: EXIT WHEN (i = p_okc_ph_line_breaks_v_tbl.LAST);
2625: i := p_okc_ph_line_breaks_v_tbl.NEXT(i);
2626: END LOOP;
2627: END IF;
2628: -- Loop through the error_tbl to find the error with the highest severity
2629: -- and return it.
2662: );
2663: END delete_row;
2664:
2665: ----------------------------------------------------
2666: -- PL/SQL TBL delete_row for:OKC_PH_LINE_BREAKS_V --
2667: ----------------------------------------------------
2668: PROCEDURE delete_row(
2669: p_api_version IN NUMBER,
2670: p_init_msg_list IN VARCHAR2 ,
2670: p_init_msg_list IN VARCHAR2 ,
2671: x_return_status OUT NOCOPY VARCHAR2,
2672: x_msg_count OUT NOCOPY NUMBER,
2673: x_msg_data OUT NOCOPY VARCHAR2,
2674: p_okc_ph_line_breaks_v_tbl IN okc_ph_line_breaks_v_tbl_type) IS
2675:
2676: l_api_version CONSTANT NUMBER := 1;
2677: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2678: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2679: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2680: BEGIN
2681: OKC_API.init_msg_list(p_init_msg_list);
2682: -- Make sure PL/SQL table has records in it before passing
2683: IF (p_okc_ph_line_breaks_v_tbl.COUNT > 0) THEN
2684: delete_row (
2685: p_api_version => p_api_version,
2686: p_init_msg_list => OKC_API.G_FALSE,
2687: x_return_status => x_return_status,
2686: p_init_msg_list => OKC_API.G_FALSE,
2687: x_return_status => x_return_status,
2688: x_msg_count => x_msg_count,
2689: x_msg_data => x_msg_data,
2690: p_okc_ph_line_breaks_v_tbl => p_okc_ph_line_breaks_v_tbl,
2691: px_error_tbl => l_error_tbl);
2692: END IF;
2693: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2694: EXCEPTION