APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_INTEGRATORS_B

Line 530: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

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

Line 555: FROM BNE_INTEGRATORS_B

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

Line 568: INSERT INTO BNE_INTEGRATORS_B

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

Line 631: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;

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

Line 650: FROM BNE_INTEGRATORS_B

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

Line 663: INSERT INTO BNE_INTEGRATORS_B

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

Line 4272: FROM BNE_INTEGRATORS_B

4268: VV_SECURITY_RULE_CODE VARCHAR2(30);
4269: BEGIN
4270: SELECT COUNT(*)
4271: INTO VV_COUNT
4272: FROM BNE_INTEGRATORS_B
4273: WHERE APPLICATION_ID = P_APPLICATION_ID
4274: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
4275:
4276: IF VV_COUNT = 0

Line 4306: FROM BNE_INTEGRATORS_B

4302: VV_UPLOAD_SERV_LIST_APP_ID, VV_UPLOAD_SERV_LIST_CODE,
4303: VV_IMPORT_LIST_APP_ID, VV_IMPORT_LIST_CODE,
4304: VV_CREATE_DOC_LIST_APP_ID, VV_CREATE_DOC_LIST_CODE,
4305: VV_SESSION_LIST_APP_ID, VV_SESSION_LIST_CODE
4306: FROM BNE_INTEGRATORS_B
4307: WHERE APPLICATION_ID = P_APPLICATION_ID
4308: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
4309:
4310: VV_DUMMY := DELETE_ALL_MAPPINGS(P_APPLICATION_ID, P_INTEGRATOR_CODE);

Line 4317: DELETE FROM BNE_INTEGRATORS_B

4313: VV_DUMMY := DELETE_ALL_INTERFACES(P_APPLICATION_ID, P_INTEGRATOR_CODE);
4314: VV_DUMMY := DELETE_ALL_DUP_PROFILES(P_APPLICATION_ID, P_INTEGRATOR_CODE);
4315:
4316:
4317: DELETE FROM BNE_INTEGRATORS_B
4318: WHERE APPLICATION_ID = P_APPLICATION_ID
4319: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;
4320:
4321: DELETE FROM BNE_INTEGRATORS_TL

Line 4446: FROM BNE_INTEGRATORS_B

4442: VV_COUNT NUMBER;
4443: BEGIN
4444: VV_COUNT := 0;
4445: FOR I IN (SELECT INTEGRATOR_CODE
4446: FROM BNE_INTEGRATORS_B
4447: WHERE APPLICATION_ID = P_APPLICATION_ID)
4448: LOOP
4449: VV_COUNT := VV_COUNT + DELETE_INTEGRATOR(P_APPLICATION_ID, I.INTEGRATOR_CODE);
4450: END LOOP;

Line 5526: FROM BNE_INTEGRATORS_B

5522: VV_COUNT := 0;
5523:
5524: SELECT COUNT(*)
5525: INTO VV_DUMMY
5526: FROM BNE_INTEGRATORS_B
5527: WHERE UPLOAD_PARAM_LIST_APP_ID = P_APPLICATION_ID
5528: AND UPLOAD_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5529:
5530: IF VV_DUMMY > 0

Line 5538: FROM BNE_INTEGRATORS_B

5534:
5535: --
5536: SELECT COUNT(*)
5537: INTO VV_DUMMY
5538: FROM BNE_INTEGRATORS_B
5539: WHERE UPLOAD_SERV_PARAM_LIST_APP_ID = P_APPLICATION_ID
5540: AND UPLOAD_SERV_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5541:
5542: IF VV_DUMMY > 0

Line 5550: FROM BNE_INTEGRATORS_B

5546:
5547: --
5548: SELECT COUNT(*)
5549: INTO VV_DUMMY
5550: FROM BNE_INTEGRATORS_B
5551: WHERE IMPORT_PARAM_LIST_APP_ID = P_APPLICATION_ID
5552: AND IMPORT_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5553:
5554: IF VV_DUMMY > 0

Line 5562: FROM BNE_INTEGRATORS_B

5558:
5559: --
5560: SELECT COUNT(*)
5561: INTO VV_DUMMY
5562: FROM BNE_INTEGRATORS_B
5563: WHERE CREATE_DOC_LIST_APP_ID = P_APPLICATION_ID
5564: AND CREATE_DOC_LIST_CODE = P_PARAM_LIST_CODE;
5565:
5566: IF VV_DUMMY > 0

Line 5574: FROM BNE_INTEGRATORS_B

5570:
5571: --
5572: SELECT COUNT(*)
5573: INTO VV_DUMMY
5574: FROM BNE_INTEGRATORS_B
5575: WHERE SESSION_PARAM_LIST_APP_ID = P_APPLICATION_ID
5576: AND SESSION_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5577:
5578: IF VV_DUMMY > 0