[Home] [Help]
149: p_cle_rec IN cle_rec_type)IS
150:
151: CURSOR l_csr1 IS
152: select 'x'
153: FROM Okc_Statuses_B
154: WHERE okc_statuses_b.code = p_cle_rec.sts_code;
155:
156: l_dummy1 VARCHAR2(1) := '?';
157: l_line_num VARCHAR2(400);
150:
151: CURSOR l_csr1 IS
152: select 'x'
153: FROM Okc_Statuses_B
154: WHERE okc_statuses_b.code = p_cle_rec.sts_code;
155:
156: l_dummy1 VARCHAR2(1) := '?';
157: l_line_num VARCHAR2(400);
158:
174: p_token1_value => 'STS_CODE',
175: p_token2 => g_child_table_token,
176: p_token2_value => G_VIEW,
177: p_token3 => g_parent_table_token,
178: p_token3_value => 'OKC_STATUSES_B');
179: x_return_status := OKE_API.G_RET_STS_ERROR;
180: END IF;
181: END IF;
182: