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 3352: FROM DUAL

3348: sysdate,
3349: l_user_id,
3350: l_login_id,
3351: sysdate
3352: FROM DUAL
3353: WHERE inf_action_tbl(i) = 'N' and
3354: inf_process_status_tbl(i) in ('S', 'W') ;
3355:
3356: -- Using a " select from dual" aproach as above prevents creation of

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

3352: FROM DUAL
3353: WHERE inf_action_tbl(i) = 'N' and
3354: inf_process_status_tbl(i) in ('S', 'W') ;
3355:
3356: -- Using a " select from dual" aproach as above prevents creation of
3357: -- additional PL/SQL tables for bulk insert of
3358: -- articles if we were to use a FORALL INSERT INTO .... VALUES .... approach.
3359: -- We cannot use FORALL INSERT INTO .... VALUES ....using
3360: -- the existing inf*tbl since the error rows need to be

Line 5256: FROM DUAL

5252: sysdate,
5253: l_user_id,
5254: l_login_id,
5255: sysdate
5256: FROM DUAL
5257: WHERE vinf_action_tbl(i) = 'N' and
5258: vinf_process_status_tbl(i) in ('S', 'W') and
5259: vinf_language_tbl(i) = USERENV('LANG');
5260:

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

5257: WHERE vinf_action_tbl(i) = 'N' and
5258: vinf_process_status_tbl(i) in ('S', 'W') and
5259: vinf_language_tbl(i) = USERENV('LANG');
5260:
5261: -- Using a " select from dual" aproach as above prevents creation of
5262: -- additional PL/SQL tables for bulk insert of
5263: -- variables if we were to use a FORALL INSERT INTO .... VALUES .... approach.
5264: -- We cannot use FORALL INSERT INTO .... VALUES ....using
5265: -- the existing inf*tbl since the error rows need to be

Line 6593: FROM DUAL

6589: sysdate,
6590: l_user_id,
6591: l_login_id,
6592: sysdate
6593: FROM DUAL
6594: WHERE rinf_action_tbl(i) = 'N' and
6595: rinf_process_status_tbl(i) in ('S', 'W') ;
6596:
6597:

Line 6621: FROM DUAL

6617: sysdate,
6618: l_user_id,
6619: l_login_id,
6620: sysdate
6621: FROM DUAL
6622: WHERE rinf_action_tbl(i) = 'N' and
6623: rinf_process_status_tbl(i) in ('S', 'W') ;
6624: EXCEPTION
6625: WHEN OTHERS THEN