DBA Data[Home] [Help]

APPS.OKC_ARTICLE_VERSIONS_PVT dependencies on DUAL

Line 60: FROM DUAL;

56: /*
57: CURSOR CUR_ORG_CSR IS
58: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
59: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
60: FROM DUAL;
61: */
62:
63: ---------------------------------------------------------------------------
64: -- FUNCTION get_seq_id

Line 71: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;

67: p_article_version_id IN NUMBER,
68: x_article_version_id OUT NOCOPY NUMBER
69: ) RETURN VARCHAR2 IS
70: CURSOR l_seq_csr IS
71: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
72: BEGIN
73: IF (l_debug = 'Y') THEN
74: Okc_Debug.Log('100: Entered get_seq_id', 2);
75: END IF;