APPS.OKC_ARTICLES_IMPORT_GRP dependencies on DUAL

Line 63: FROM DUAL;

59: -- One Time fetch and cache the current Org.
60: CURSOR CUR_ORG_CSR IS
61: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
62: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
63: FROM DUAL;
64: */
65:
66: /*===================================================
67: | Private Functions

Line 838: FROM DUAL;

834: l_entity_tbl_type := entity_tbl_type('Clause','Variable','Relationship','Valueset','Value');
835: -- Generate batch_process_id
836: SELECT
837: OKC_ART_INT_BATPROCS_ALL_S1.nextval into lc_batch_process_id
838: FROM DUAL;
839:
840: FOR i IN 1..l_entity_tbl_type.LAST LOOP
841:
842: INSERT INTO OKC_ART_INT_BATPROCS_ALL

Line 1334: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;

1330: p_object_type IN VARCHAR2,
1331: x_object_id OUT NOCOPY NUMBER
1332: ) RETURN VARCHAR2 IS
1333: CURSOR l_art_csr IS
1334: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;
1335: CURSOR l_ver_csr IS
1336: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
1337: BEGIN
1338: IF (l_debug = 'Y') THEN

Line 1336: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;

1332: ) RETURN VARCHAR2 IS
1333: CURSOR l_art_csr IS
1334: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;
1335: CURSOR l_ver_csr IS
1336: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
1337: BEGIN
1338: IF (l_debug = 'Y') THEN
1339: Okc_Debug.Log('100: Entered get_seq_id', 2);
1340: END IF;

Line 3403: FROM DUAL

3399: sysdate,
3400: l_user_id,
3401: l_login_id,
3402: sysdate
3403: FROM DUAL
3404: WHERE inf_action_tbl(i) = 'N' and
3405: inf_process_status_tbl(i) in ('S', 'W') ;
3406:
3407: -- Using a " select from dual" aproach as above prevents creation of

Line 3407: -- Using a " select from dual" aproach as above prevents creation of

3403: FROM DUAL
3404: WHERE inf_action_tbl(i) = 'N' and
3405: inf_process_status_tbl(i) in ('S', 'W') ;
3406:
3407: -- Using a " select from dual" aproach as above prevents creation of
3408: -- additional PL/SQL tables for bulk insert of
3409: -- articles if we were to use a FORALL INSERT INTO .... VALUES .... approach.
3410: -- We cannot use FORALL INSERT INTO .... VALUES ....using
3411: -- the existing inf*tbl since the error rows need to be

Line 5324: FROM DUAL

5320: l_user_id,
5321: l_login_id,
5322: sysdate,
5323: 'M' --Added for Bug 10227193
5324: FROM DUAL
5325: WHERE vinf_action_tbl(i) = 'N' and
5326: vinf_process_status_tbl(i) in ('S', 'W') and
5327: vinf_language_tbl(i) = USERENV('LANG');
5328:

Line 5329: -- Using a " select from dual" aproach as above prevents creation of

5325: WHERE vinf_action_tbl(i) = 'N' and
5326: vinf_process_status_tbl(i) in ('S', 'W') and
5327: vinf_language_tbl(i) = USERENV('LANG');
5328:
5329: -- Using a " select from dual" aproach as above prevents creation of
5330: -- additional PL/SQL tables for bulk insert of
5331: -- variables if we were to use a FORALL INSERT INTO .... VALUES .... approach.
5332: -- We cannot use FORALL INSERT INTO .... VALUES ....using
5333: -- the existing inf*tbl since the error rows need to be

Line 6661: FROM DUAL

6657: sysdate,
6658: l_user_id,
6659: l_login_id,
6660: sysdate
6661: FROM DUAL
6662: WHERE rinf_action_tbl(i) = 'N' and
6663: rinf_process_status_tbl(i) in ('S', 'W') ;
6664:
6665:

Line 6689: FROM DUAL

6685: sysdate,
6686: l_user_id,
6687: l_login_id,
6688: sysdate
6689: FROM DUAL
6690: WHERE rinf_action_tbl(i) = 'N' and
6691: rinf_process_status_tbl(i) in ('S', 'W') ;
6692: EXCEPTION
6693: WHEN OTHERS THEN