APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_INTEGRATORS_B

Line 531: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

527: P_SOURCE_LANGUAGE IN VARCHAR2,
528: P_USER_ID IN NUMBER,
529: P_INTEGRATOR_CODE OUT NOCOPY VARCHAR2)
530: IS
531: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
532: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
533: BEGIN
534:
535: -- Only create the Integrator and Content if the OBJECT_CODE supplied is VALID.

Line 556: FROM BNE_INTEGRATORS_B

552:
553: BEGIN
554: SELECT INTEGRATOR_CODE
555: INTO VV_INTEGRATOR_CODE
556: FROM BNE_INTEGRATORS_B
557: WHERE APPLICATION_ID = P_APPLICATION_ID
558: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
559: EXCEPTION
560: WHEN NO_DATA_FOUND THEN NULL;

Line 569: INSERT INTO BNE_INTEGRATORS_B

565: IF ( VV_INTEGRATOR_CODE IS NULL) THEN
566:
567: -- Add the Integrator
568:
569: INSERT INTO BNE_INTEGRATORS_B
570: (APPLICATION_ID, INTEGRATOR_CODE, OBJECT_VERSION_NUMBER, DATE_FORMAT,
571: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ENABLED_FLAG)
572: VALUES
573: (P_APPLICATION_ID, P_INTEGRATOR_CODE, 1, 'yyyy-MM-dd',

Line 632: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

628: P_INTEGRATOR_CODE OUT NOCOPY VARCHAR2
629: )
630:
631: IS
632: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
633: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;
634: BEGIN
635:
636: -- Only create the Integrator if the OBJECT_CODE supplied is VALID.

Line 651: FROM BNE_INTEGRATORS_B

647:
648: BEGIN
649: SELECT INTEGRATOR_CODE
650: INTO VV_INTEGRATOR_CODE
651: FROM BNE_INTEGRATORS_B
652: WHERE APPLICATION_ID = P_APPLICATION_ID
653: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
654: EXCEPTION
655: WHEN NO_DATA_FOUND THEN NULL;

Line 664: INSERT INTO BNE_INTEGRATORS_B

660: IF (VV_INTEGRATOR_CODE IS NULL) THEN
661:
662: -- Add the Integrator
663:
664: INSERT INTO BNE_INTEGRATORS_B
665: (APPLICATION_ID, INTEGRATOR_CODE, OBJECT_VERSION_NUMBER, DATE_FORMAT,
666: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ENABLED_FLAG)
667: VALUES
668: (P_APPLICATION_ID, P_INTEGRATOR_CODE, 1, 'yyyy-MM-dd',

Line 4181: FROM BNE_INTEGRATORS_B

4177: VV_SECURITY_RULE_CODE VARCHAR2(30);
4178: BEGIN
4179: SELECT COUNT(*)
4180: INTO VV_COUNT
4181: FROM BNE_INTEGRATORS_B
4182: WHERE APPLICATION_ID = P_APPLICATION_ID
4183: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
4184:
4185: IF VV_COUNT = 0

Line 4215: FROM BNE_INTEGRATORS_B

4211: VV_UPLOAD_SERV_LIST_APP_ID, VV_UPLOAD_SERV_LIST_CODE,
4212: VV_IMPORT_LIST_APP_ID, VV_IMPORT_LIST_CODE,
4213: VV_CREATE_DOC_LIST_APP_ID, VV_CREATE_DOC_LIST_CODE,
4214: VV_SESSION_LIST_APP_ID, VV_SESSION_LIST_CODE
4215: FROM BNE_INTEGRATORS_B
4216: WHERE APPLICATION_ID = P_APPLICATION_ID
4217: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
4218:
4219: VV_DUMMY := DELETE_ALL_MAPPINGS(P_APPLICATION_ID, P_INTEGRATOR_CODE);

Line 4226: DELETE FROM BNE_INTEGRATORS_B

4222: VV_DUMMY := DELETE_ALL_INTERFACES(P_APPLICATION_ID, P_INTEGRATOR_CODE);
4223: VV_DUMMY := DELETE_ALL_DUP_PROFILES(P_APPLICATION_ID, P_INTEGRATOR_CODE);
4224:
4225:
4226: DELETE FROM BNE_INTEGRATORS_B
4227: WHERE APPLICATION_ID = P_APPLICATION_ID
4228: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
4229:
4230: DELETE FROM BNE_INTEGRATORS_TL

Line 4355: FROM BNE_INTEGRATORS_B

4351: VV_COUNT NUMBER;
4352: BEGIN
4353: VV_COUNT := 0;
4354: FOR I IN (SELECT INTEGRATOR_CODE
4355: FROM BNE_INTEGRATORS_B
4356: WHERE APPLICATION_ID = P_APPLICATION_ID)
4357: LOOP
4358: VV_COUNT := VV_COUNT + DELETE_INTEGRATOR(P_APPLICATION_ID, I.INTEGRATOR_CODE);
4359: END LOOP;

Line 5441: FROM BNE_INTEGRATORS_B

5437: VV_SUB_LIST_DELETED := 0;
5438:
5439: SELECT COUNT(*)
5440: INTO VV_DUMMY
5441: FROM BNE_INTEGRATORS_B
5442: WHERE UPLOAD_PARAM_LIST_APP_ID = P_APPLICATION_ID
5443: AND UPLOAD_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5444:
5445: IF VV_DUMMY > 0

Line 5453: FROM BNE_INTEGRATORS_B

5449:
5450: --
5451: SELECT COUNT(*)
5452: INTO VV_DUMMY
5453: FROM BNE_INTEGRATORS_B
5454: WHERE UPLOAD_SERV_PARAM_LIST_APP_ID = P_APPLICATION_ID
5455: AND UPLOAD_SERV_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5456:
5457: IF VV_DUMMY > 0

Line 5465: FROM BNE_INTEGRATORS_B

5461:
5462: --
5463: SELECT COUNT(*)
5464: INTO VV_DUMMY
5465: FROM BNE_INTEGRATORS_B
5466: WHERE IMPORT_PARAM_LIST_APP_ID = P_APPLICATION_ID
5467: AND IMPORT_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5468:
5469: IF VV_DUMMY > 0

Line 5477: FROM BNE_INTEGRATORS_B

5473:
5474: --
5475: SELECT COUNT(*)
5476: INTO VV_DUMMY
5477: FROM BNE_INTEGRATORS_B
5478: WHERE CREATE_DOC_LIST_APP_ID = P_APPLICATION_ID
5479: AND CREATE_DOC_LIST_CODE = P_PARAM_LIST_CODE;
5480:
5481: IF VV_DUMMY > 0

Line 5489: FROM BNE_INTEGRATORS_B

5485:
5486: --
5487: SELECT COUNT(*)
5488: INTO VV_DUMMY
5489: FROM BNE_INTEGRATORS_B
5490: WHERE SESSION_PARAM_LIST_APP_ID = P_APPLICATION_ID
5491: AND SESSION_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5492:
5493: IF VV_DUMMY > 0