APPS.OKE_TERM_PVT dependencies on OKE_TERM_VALUES_V

Line 133: FROM OKE_TERM_VALUES_V

129:
130: l_dummy_val VARCHAR2(1):='?';
131: CURSOR l_csr IS
132: SELECT 'x'
133: FROM OKE_TERM_VALUES_V
134: WHERE TERM_CODE = p_term_rec.TERM_CODE;
135:
136: BEGIN
137:

Line 166: p_token3_value =>'OKE_TERM_VALUES_V');

162: p_token1_value =>'TERM_CODE',
163: p_token2 =>g_child_table_token,
164: p_token2_value =>G_VIEW,
165: p_token3 =>g_parent_table_token,
166: p_token3_value =>'OKE_TERM_VALUES_V');
167:
168: x_return_status := OKE_API.G_RET_STS_ERROR;
169: END IF;
170:

Line 198: FROM OKE_TERM_VALUES_V

194:
195: l_dummy_val VARCHAR2(1):='?';
196: CURSOR l_csr IS
197: SELECT 'x'
198: FROM OKE_TERM_VALUES_V
199: WHERE TERM_VALUE_PK1 = p_term_rec.TERM_VALUE_PK1;
200:
201: BEGIN
202:

Line 234: p_token3_value =>'OKE_TERM_VALUES_V');

230: p_token1_value =>'TERM_VALUE_PK1',
231: p_token2 =>g_child_table_token,
232: p_token2_value =>G_VIEW,
233: p_token3 =>g_parent_table_token,
234: p_token3_value =>'OKE_TERM_VALUES_V');
235:
236: x_return_status := OKE_API.G_RET_STS_ERROR;
237: END IF;
238:

Line 267: FROM OKE_TERM_VALUES_V

263:
264: l_dummy_val VARCHAR2(1):='?';
265: CURSOR l_csr IS
266: SELECT 'x'
267: FROM OKE_TERM_VALUES_V
268: WHERE TERM_VALUE_PK2 = p_term_rec.TERM_VALUE_PK2;
269:
270: BEGIN
271:

Line 303: p_token3_value =>'OKE_TERM_VALUES_V');

299: p_token1_value =>'TERM_VALUE_PK2',
300: p_token2 =>g_child_table_token,
301: p_token2_value =>G_VIEW,
302: p_token3 =>g_parent_table_token,
303: p_token3_value =>'OKE_TERM_VALUES_V');
304:
305: x_return_status := OKE_API.G_RET_STS_ERROR;
306: END IF;
307:

Line 344: FROM OKE_TERM_VALUES_V

340:
341: l_dummy_val VARCHAR2(1):='?';
342: CURSOR l_csr IS
343: SELECT 'x'
344: FROM OKE_TERM_VALUES_V
345: WHERE TERM_CODE = p_term_rec.TERM_CODE AND
346: TERM_VALUE_PK1 = p_term_rec.TERM_VALUE_PK1 AND
347: TERM_VALUE_PK2 = p_term_rec.TERM_VALUE_PK2;
348:

Line 394: p_token3_value =>'OKE_TERM_VALUES_V');

390: p_token1_value =>'TERM_CODE AND TERM_VALUE_PK1 AND TERM_VALUE_PK2',
391: p_token2 =>g_child_table_token,
392: p_token2_value =>G_VIEW,
393: p_token3 =>g_parent_table_token,
394: p_token3_value =>'OKE_TERM_VALUES_V');
395:
396: x_return_status := OKE_API.G_RET_STS_ERROR;
397: END IF;
398: