APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_CONTENTS_B

Line 532: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;

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.
536:

Line 633: VV_CONTENT_CODE BNE_CONTENTS_B.CONTENT_CODE%TYPE;

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.
637:

Line 1300: FROM BNE_CONTENTS_B

1296:
1297: BEGIN
1298: SELECT 1
1299: INTO VN_VALID_CONTENT
1300: FROM BNE_CONTENTS_B
1301: WHERE APPLICATION_ID = P_APPLICATION_ID
1302: AND CONTENT_CODE = P_CONTENT_CODE
1303: AND INTEGRATOR_APP_ID = P_APPLICATION_ID
1304: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE;

Line 1330: BNE_CONTENTS_B BC,

1326: SELECT 1
1327: INTO VN_INTERFACE_EXISTS
1328: FROM BNE_INTERFACES_B BI,
1329: BNE_INTERFACES_TL BITL,
1330: BNE_CONTENTS_B BC,
1331: BNE_CONTENTS_TL BCTL
1332: WHERE BI.APPLICATION_ID = P_APPLICATION_ID
1333: AND BI.APPLICATION_ID = BC.APPLICATION_ID
1334: AND BC.CONTENT_CODE = P_CONTENT_CODE

Line 4680: FROM BNE_CONTENTS_B

4676: VV_QUERY_KEYS BNEKEY_TAB;
4677: BEGIN
4678: SELECT COUNT(*)
4679: INTO VV_COUNT
4680: FROM BNE_CONTENTS_B
4681: WHERE APPLICATION_ID = P_APPLICATION_ID
4682: AND CONTENT_CODE = P_CONTENT_CODE;
4683:
4684: IF VV_COUNT = 0

Line 4699: DELETE FROM BNE_CONTENTS_B

4695: AND CONTENT_CODE = P_CONTENT_CODE
4696: AND QUERY_APP_ID IS NOT NULL
4697: AND QUERY_CODE IS NOT NULL;
4698:
4699: DELETE FROM BNE_CONTENTS_B
4700: WHERE APPLICATION_ID = P_APPLICATION_ID
4701: AND CONTENT_CODE = P_CONTENT_CODE;
4702:
4703: DELETE FROM BNE_CONTENTS_TL

Line 4761: FROM BNE_CONTENTS_B

4757: VV_COUNT NUMBER;
4758: BEGIN
4759: VV_COUNT := 0;
4760: FOR I IN (SELECT APPLICATION_ID, CONTENT_CODE
4761: FROM BNE_CONTENTS_B
4762: WHERE INTEGRATOR_APP_ID = P_APPLICATION_ID
4763: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE)
4764: LOOP
4765: VV_COUNT := VV_COUNT + DELETE_CONTENT(I.APPLICATION_ID, I.CONTENT_CODE);

Line 5548: FROM BNE_CONTENTS_B

5544:
5545: --
5546: SELECT COUNT(*)
5547: INTO VV_DUMMY
5548: FROM BNE_CONTENTS_B
5549: WHERE PARAM_LIST_APP_ID = P_APPLICATION_ID
5550: AND PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5551:
5552: IF VV_DUMMY > 0