570: IF l_row_not_found THEN
571: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'jtot_object1_code');
572: x_return_status := OKC_API.G_RET_STS_ERROR;
573: ELSE
574: l_cursor := DBMS_SQL.OPEN_CURSOR;
575: IF (is_number(l_select_id)) THEN
576: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ' || to_number(p_object1_id1), DBMS_SQL.V7);
577: ELSE
578: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ''' || p_object1_id1 || '''', DBMS_SQL.V7);
572: x_return_status := OKC_API.G_RET_STS_ERROR;
573: ELSE
574: l_cursor := DBMS_SQL.OPEN_CURSOR;
575: IF (is_number(l_select_id)) THEN
576: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ' || to_number(p_object1_id1), DBMS_SQL.V7);
577: ELSE
578: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ''' || p_object1_id1 || '''', DBMS_SQL.V7);
579: END IF;
580: DBMS_SQL.DEFINE_COLUMN_CHAR(l_cursor, 1, l_id, 200);
574: l_cursor := DBMS_SQL.OPEN_CURSOR;
575: IF (is_number(l_select_id)) THEN
576: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ' || to_number(p_object1_id1), DBMS_SQL.V7);
577: ELSE
578: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ''' || p_object1_id1 || '''', DBMS_SQL.V7);
579: END IF;
580: DBMS_SQL.DEFINE_COLUMN_CHAR(l_cursor, 1, l_id, 200);
581: l_rows := DBMS_SQL.EXECUTE(l_cursor);
582: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then
576: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ' || to_number(p_object1_id1), DBMS_SQL.V7);
577: ELSE
578: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ''' || p_object1_id1 || '''', DBMS_SQL.V7);
579: END IF;
580: DBMS_SQL.DEFINE_COLUMN_CHAR(l_cursor, 1, l_id, 200);
581: l_rows := DBMS_SQL.EXECUTE(l_cursor);
582: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then
583: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'object1_id1');
584: x_return_status := OKL_API.G_RET_STS_ERROR;
577: ELSE
578: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ''' || p_object1_id1 || '''', DBMS_SQL.V7);
579: END IF;
580: DBMS_SQL.DEFINE_COLUMN_CHAR(l_cursor, 1, l_id, 200);
581: l_rows := DBMS_SQL.EXECUTE(l_cursor);
582: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then
583: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'object1_id1');
584: x_return_status := OKL_API.G_RET_STS_ERROR;
585: END IF;
578: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ''' || p_object1_id1 || '''', DBMS_SQL.V7);
579: END IF;
580: DBMS_SQL.DEFINE_COLUMN_CHAR(l_cursor, 1, l_id, 200);
581: l_rows := DBMS_SQL.EXECUTE(l_cursor);
582: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then
583: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'object1_id1');
584: x_return_status := OKL_API.G_RET_STS_ERROR;
585: END IF;
586: END IF;