eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_INTERFACES_B

Line 196: -- Interface. Updates table BNE_INTERFACES_B. --

192: --------------------------------------------------------------------------------
193: -- PROCEDURE: LINK_LIST_TO_INTERFACE --
194: -- --
195: -- DESCRIPTION: Links the Parameter List for the API to the --
196: -- Interface. Updates table BNE_INTERFACES_B. --
197: -- --
198: -- PARAMETERS: --
199: -- --
200: -- MODIFICATION HISTORY --

Line 215: UPDATE BNE_INTERFACES_B

211: IS
212: BEGIN
213: -- if there is already an upload parameter list linked to the interface, this will be overwritten
214:
215: UPDATE BNE_INTERFACES_B
216: SET UPLOAD_PARAM_LIST_APP_ID = P_PARAM_LIST_APP_ID,
217: UPLOAD_PARAM_LIST_CODE = P_PARAM_LIST_CODE,
218: OBJECT_VERSION_NUMBER = (OBJECT_VERSION_NUMBER + 1)
219: WHERE APPLICATION_ID = P_INTERFACE_APP_ID

Line 793: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;

789:
790:
791: VN_INTERFACE_EXISTS NUMBER;
792: VN_STANDARD_WHO_COUNT NUMBER;
793: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
794:
795: BEGIN
796: --
797:

Line 815: FROM BNE_INTERFACES_B

811:
812: BEGIN
813: SELECT INTERFACE_CODE
814: INTO VV_INTERFACE_CODE
815: FROM BNE_INTERFACES_B
816: WHERE APPLICATION_ID = P_APPLICATION_ID
817: AND INTERFACE_CODE = P_INTERFACE_CODE;
818: EXCEPTION
819: WHEN NO_DATA_FOUND THEN NULL;

Line 829: FROM BNE_INTERFACES_B BIB, BNE_INTERFACES_TL BIT

825:
826: BEGIN
827: SELECT 1
828: INTO VN_INTERFACE_EXISTS
829: FROM BNE_INTERFACES_B BIB, BNE_INTERFACES_TL BIT
830: WHERE BIB.APPLICATION_ID = BIT.APPLICATION_ID
831: AND BIB.INTERFACE_CODE = BIT.INTERFACE_CODE
832: AND BIB.APPLICATION_ID = P_APPLICATION_ID
833: AND BIT.LANGUAGE = P_LANGUAGE

Line 846: -- Insert into the BNE_INTERFACES_B table

842:
843: -- If the Interface Code is unique AND an Interface does not exist for this Interface table,
844: -- create the new Interface and Interface Columns.
845:
846: -- Insert into the BNE_INTERFACES_B table
847:
848: INSERT INTO BNE_INTERFACES_B
849: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
850: INTERFACE_NAME, UPLOAD_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 848: INSERT INTO BNE_INTERFACES_B

844: -- create the new Interface and Interface Columns.
845:
846: -- Insert into the BNE_INTERFACES_B table
847:
848: INSERT INTO BNE_INTERFACES_B
849: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
850: INTERFACE_NAME, UPLOAD_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
851: VALUES
852: (P_APPLICATION_ID, P_INTERFACE_CODE, 1, P_APPLICATION_ID, P_INTEGRATOR_CODE,

Line 1116: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;

1112: AND A.PROCEDURE$ = CP_API_PROCEDURE_NAME
1113: AND A.LEVEL# = 0
1114: AND A.OVERLOAD# = CP_OVERLOAD;
1115:
1116: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
1117: VN_INTERFACE_EXISTS NUMBER;
1118: VN_OVERLOAD NUMBER;
1119: BEGIN
1120: IF IS_VALID_APPL_ID(P_APPLICATION_ID) AND IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN

Line 1132: FROM BNE_INTERFACES_B

1128:
1129: BEGIN
1130: SELECT INTERFACE_CODE
1131: INTO VV_INTERFACE_CODE
1132: FROM BNE_INTERFACES_B
1133: WHERE APPLICATION_ID = P_APPLICATION_ID
1134: AND INTERFACE_CODE = P_INTERFACE_CODE;
1135: EXCEPTION
1136: WHEN NO_DATA_FOUND THEN NULL;

Line 1144: FROM BNE_INTERFACES_B BIB, BNE_INTERFACES_TL BIT

1140:
1141: BEGIN
1142: SELECT 1
1143: INTO VN_INTERFACE_EXISTS
1144: FROM BNE_INTERFACES_B BIB, BNE_INTERFACES_TL BIT
1145: WHERE BIB.APPLICATION_ID = BIT.APPLICATION_ID
1146: AND BIB.INTERFACE_CODE = BIT.INTERFACE_CODE
1147: AND BIB.INTEGRATOR_APP_ID = P_APPLICATION_ID
1148: AND BIB.INTEGRATOR_CODE = P_INTEGRATOR_CODE

Line 1190: -- Create the interface in the BNE_INTERFACES_B table

1186: P_APPLICATION_ID,
1187: P_OBJECT_CODE,
1188: P_PARAM_LIST_CODE);
1189:
1190: -- Create the interface in the BNE_INTERFACES_B table
1191:
1192: INSERT INTO BNE_INTERFACES_B
1193: (APPLICATION_ID,
1194: INTERFACE_CODE,

Line 1192: INSERT INTO BNE_INTERFACES_B

1188: P_PARAM_LIST_CODE);
1189:
1190: -- Create the interface in the BNE_INTERFACES_B table
1191:
1192: INSERT INTO BNE_INTERFACES_B
1193: (APPLICATION_ID,
1194: INTERFACE_CODE,
1195: OBJECT_VERSION_NUMBER,
1196: INTEGRATOR_APP_ID,

Line 1374: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;

1370: P_SOURCE_LANG IN VARCHAR2,
1371: P_USER_ID IN NUMBER,
1372: P_INTERFACE_CODE OUT NOCOPY VARCHAR2)
1373: IS
1374: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
1375: VN_INTERFACE_EXISTS NUMBER;
1376: VN_VALID_CONTENT NUMBER;
1377: VV_DESCRIPTION VARCHAR2(240);
1378: BEGIN

Line 1407: FROM BNE_INTERFACES_B

1403:
1404: BEGIN
1405: SELECT INTERFACE_CODE
1406: INTO VV_INTERFACE_CODE
1407: FROM BNE_INTERFACES_B
1408: WHERE APPLICATION_ID = P_APPLICATION_ID
1409: AND INTERFACE_CODE = P_INTERFACE_CODE;
1410: EXCEPTION
1411: WHEN NO_DATA_FOUND THEN NULL;

Line 1420: FROM BNE_INTERFACES_B BI,

1416:
1417: BEGIN
1418: SELECT 1
1419: INTO VN_INTERFACE_EXISTS
1420: FROM BNE_INTERFACES_B BI,
1421: BNE_INTERFACES_TL BITL,
1422: BNE_CONTENTS_B BC,
1423: BNE_CONTENTS_TL BCTL
1424: WHERE BI.APPLICATION_ID = P_APPLICATION_ID

Line 1455: -- Insert into BNE_INTERFACES_B

1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN NULL;
1453: END;
1454:
1455: -- Insert into BNE_INTERFACES_B
1456: -- UPLOAD_TYPE of 4 is used to reference the constant BNE_UPLOAD_TYPE_REPORTING
1457:
1458: INSERT INTO BNE_INTERFACES_B
1459: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,

Line 1458: INSERT INTO BNE_INTERFACES_B

1454:
1455: -- Insert into BNE_INTERFACES_B
1456: -- UPLOAD_TYPE of 4 is used to reference the constant BNE_UPLOAD_TYPE_REPORTING
1457:
1458: INSERT INTO BNE_INTERFACES_B
1459: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
1460: INTERFACE_NAME, UPLOAD_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1461: VALUES
1462: (P_APPLICATION_ID, P_INTERFACE_CODE, 1, P_APPLICATION_ID, P_INTEGRATOR_CODE,

Line 4572: FROM BNE_INTERFACES_B

4568: VV_UPLOAD_LIST_CODE VARCHAR2(30);
4569: BEGIN
4570: SELECT COUNT(*)
4571: INTO VV_COUNT
4572: FROM BNE_INTERFACES_B
4573: WHERE APPLICATION_ID = P_APPLICATION_ID
4574: AND INTERFACE_CODE = P_INTERFACE_CODE;
4575:
4576: IF VV_COUNT = 0

Line 4586: FROM BNE_INTERFACES_B

4582: SELECT
4583: UPLOAD_PARAM_LIST_APP_ID, UPLOAD_PARAM_LIST_CODE
4584: INTO
4585: VV_UPLOAD_LIST_APP_ID, VV_UPLOAD_LIST_CODE
4586: FROM BNE_INTERFACES_B
4587: WHERE APPLICATION_ID = P_APPLICATION_ID
4588: AND INTERFACE_CODE = P_INTERFACE_CODE;
4589:
4590: DELETE FROM BNE_INTERFACES_B

Line 4590: DELETE FROM BNE_INTERFACES_B

4586: FROM BNE_INTERFACES_B
4587: WHERE APPLICATION_ID = P_APPLICATION_ID
4588: AND INTERFACE_CODE = P_INTERFACE_CODE;
4589:
4590: DELETE FROM BNE_INTERFACES_B
4591: WHERE APPLICATION_ID = P_APPLICATION_ID
4592: AND INTERFACE_CODE = P_INTERFACE_CODE;
4593:
4594: DELETE FROM BNE_INTERFACES_TL

Line 4658: FROM BNE_INTERFACES_B

4654: VV_COUNT NUMBER;
4655: BEGIN
4656: VV_COUNT := 0;
4657: FOR I IN (SELECT APPLICATION_ID, INTERFACE_CODE
4658: FROM BNE_INTERFACES_B
4659: WHERE INTEGRATOR_APP_ID = P_APPLICATION_ID
4660: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE)
4661: LOOP
4662: VV_COUNT := VV_COUNT + DELETE_INTERFACE(I.APPLICATION_ID, I.INTERFACE_CODE);

Line 5586: FROM BNE_INTERFACES_B

5582:
5583: --
5584: SELECT COUNT(*)
5585: INTO VV_DUMMY
5586: FROM BNE_INTERFACES_B
5587: WHERE UPLOAD_PARAM_LIST_APP_ID = P_APPLICATION_ID
5588: AND UPLOAD_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5589:
5590: IF VV_DUMMY > 0