APPS.OKC_UTIL dependencies on JTF_OBJECTS_B

Line 1338: FROM JTF_OBJECTS_B

1334: l_not_found BOOLEAN;
1335:
1336: Cursor jtfv_csr IS
1337: SELECT FROM_TABLE, WHERE_CLAUSE
1338: FROM JTF_OBJECTS_B
1339: WHERE OBJECT_CODE = p_object_code;
1340: Type SOURCE_CSR IS REF CURSOR;
1341: c SOURCE_CSR;
1342:

Line 1350: --my_message('Cannot find OBJECT in JTF_OBJECTS_B table');

1346: l_not_found := jtfv_csr%NOTFOUND;
1347: close jtfv_csr;
1348:
1349: If (l_not_found) Then
1350: --my_message('Cannot find OBJECT in JTF_OBJECTS_B table');
1351: return NULL;
1352: End if;
1353:
1354: l_sql_stmt := 'SELECT name FROM ' || l_from_table ||

Line 1395: FROM JTF_OBJECTS_B

1391: l_not_found BOOLEAN;
1392:
1393: Cursor jtfv_csr IS
1394: SELECT FROM_TABLE, WHERE_CLAUSE
1395: FROM JTF_OBJECTS_B
1396: WHERE OBJECT_CODE = p_object_code;
1397: Type SOURCE_CSR IS REF CURSOR;
1398: c SOURCE_CSR;
1399:

Line 1407: --my_message('Cannot find OBJECT in JTF_OBJECTS_B table');

1403: l_not_found := jtfv_csr%NOTFOUND;
1404: close jtfv_csr;
1405:
1406: If (l_not_found) Then
1407: --my_message('Cannot find OBJECT in JTF_OBJECTS_B table');
1408: return NULL;
1409: End if;
1410:
1411:

Line 1453: FROM JTF_OBJECTS_B

1449: l_not_found BOOLEAN;
1450:
1451: Cursor jtfv_csr IS
1452: SELECT FROM_TABLE, WHERE_CLAUSE
1453: FROM JTF_OBJECTS_B
1454: WHERE OBJECT_CODE = p_object_code;
1455: Type SOURCE_CSR IS REF CURSOR;
1456: c SOURCE_CSR;
1457:

Line 1465: --my_message('Cannot find OBJECT in JTF_OBJECTS_B table');

1461: l_not_found := jtfv_csr%NOTFOUND;
1462: close jtfv_csr;
1463:
1464: If (l_not_found) Then
1465: --my_message('Cannot find OBJECT in JTF_OBJECTS_B table');
1466: return;
1467: End if;
1468: l_sql_stmt := 'SELECT name,description FROM ' || l_from_table ||
1469: ' WHERE ID1 = :id_1 AND ID2 = :id2';

Line 1506: FROM jtf_objects_b

1502: l_return_str VARCHAR(2500);
1503: l_not_found BOOLEAN;
1504: Cursor jtfv_csr(p_object_code IN VARCHAR2) Is
1505: SELECT from_table, where_clause, order_by_clause
1506: FROM jtf_objects_b
1507: WHERE object_code = p_object_code;
1508: BEGIN
1509: open jtfv_csr(p_object_code);
1510: fetch jtfv_csr into l_from_table, l_where_clause, l_order_by_clause;

Line 1551: FROM JTF_OBJECTS_B

1547: l_not_found BOOLEAN;
1548:
1549: CURSOR jtfv_csr IS
1550: SELECT SELECT_ID,SELECT_NAME,FROM_TABLE,WHERE_CLAUSE
1551: FROM JTF_OBJECTS_B
1552: WHERE OBJECT_CODE = p_object_code;
1553: Type SOURCE_CSR IS REF CURSOR ;
1554: c SOURCE_CSR;
1555: BEGIN