DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_CONTENTS_TL

Line 1331: BNE_CONTENTS_TL BCTL

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
1335: AND BI.APPLICATION_ID = BITL.APPLICATION_ID

Line 1355: FROM BNE_CONTENTS_TL

1351:
1352: BEGIN
1353: SELECT USER_NAME
1354: INTO VV_DESCRIPTION
1355: FROM BNE_CONTENTS_TL
1356: WHERE APPLICATION_ID = P_APPLICATION_ID
1357: AND CONTENT_CODE = P_CONTENT_CODE
1358: AND LANGUAGE = P_LANGUAGE;
1359: EXCEPTION

Line 4703: DELETE FROM BNE_CONTENTS_TL

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
4704: WHERE APPLICATION_ID = P_APPLICATION_ID
4705: AND CONTENT_CODE = P_CONTENT_CODE;
4706:
4707: DELETE FROM BNE_STORED_SQL