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.

[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_INTERFACES_B

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

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

Line 216: UPDATE BNE_INTERFACES_B

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

Line 761: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;

757:
758:
759: VN_INTERFACE_EXISTS NUMBER;
760: VN_STANDARD_WHO_COUNT NUMBER;
761: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
762:
763: BEGIN
764: --
765:

Line 783: FROM BNE_INTERFACES_B

779:
780: BEGIN
781: SELECT INTERFACE_CODE
782: INTO VV_INTERFACE_CODE
783: FROM BNE_INTERFACES_B
784: WHERE APPLICATION_ID = P_APPLICATION_ID
785: AND INTERFACE_CODE = P_INTERFACE_CODE;
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN NULL;

Line 797: FROM BNE_INTERFACES_B BIB, BNE_INTERFACES_TL BIT

793:
794: BEGIN
795: SELECT 1
796: INTO VN_INTERFACE_EXISTS
797: FROM BNE_INTERFACES_B BIB, BNE_INTERFACES_TL BIT
798: WHERE BIB.APPLICATION_ID = BIT.APPLICATION_ID
799: AND BIB.INTERFACE_CODE = BIT.INTERFACE_CODE
800: AND BIB.APPLICATION_ID = P_APPLICATION_ID
801: AND BIT.LANGUAGE = P_LANGUAGE

Line 814: -- Insert into the BNE_INTERFACES_B table

810:
811: -- If the Interface Code is unique AND an Interface does not exist for this Interface table,
812: -- create the new Interface and Interface Columns.
813:
814: -- Insert into the BNE_INTERFACES_B table
815:
816: INSERT INTO BNE_INTERFACES_B
817: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
818: INTERFACE_NAME, UPLOAD_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 816: INSERT INTO BNE_INTERFACES_B

812: -- create the new Interface and Interface Columns.
813:
814: -- Insert into the BNE_INTERFACES_B table
815:
816: INSERT INTO BNE_INTERFACES_B
817: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
818: INTERFACE_NAME, UPLOAD_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
819: VALUES
820: (P_APPLICATION_ID, P_INTERFACE_CODE, 1, P_APPLICATION_ID, P_INTEGRATOR_CODE,

Line 1024: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;

1020: AND A.PROCEDURE$ = CP_API_PROCEDURE_NAME
1021: AND A.LEVEL# = 0
1022: AND A.OVERLOAD# = CP_OVERLOAD;
1023:
1024: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
1025: VN_INTERFACE_EXISTS NUMBER;
1026: VN_OVERLOAD NUMBER;
1027: BEGIN
1028: IF IS_VALID_APPL_ID(P_APPLICATION_ID) AND IS_VALID_OBJECT_CODE(P_OBJECT_CODE) THEN

Line 1040: FROM BNE_INTERFACES_B

1036:
1037: BEGIN
1038: SELECT INTERFACE_CODE
1039: INTO VV_INTERFACE_CODE
1040: FROM BNE_INTERFACES_B
1041: WHERE APPLICATION_ID = P_APPLICATION_ID
1042: AND INTERFACE_CODE = P_INTERFACE_CODE;
1043: EXCEPTION
1044: WHEN NO_DATA_FOUND THEN NULL;

Line 1052: FROM BNE_INTERFACES_B BIB, BNE_INTERFACES_TL BIT

1048:
1049: BEGIN
1050: SELECT 1
1051: INTO VN_INTERFACE_EXISTS
1052: FROM BNE_INTERFACES_B BIB, BNE_INTERFACES_TL BIT
1053: WHERE BIB.APPLICATION_ID = BIT.APPLICATION_ID
1054: AND BIB.INTERFACE_CODE = BIT.INTERFACE_CODE
1055: AND BIB.INTEGRATOR_APP_ID = P_APPLICATION_ID
1056: AND BIB.INTEGRATOR_CODE = P_INTEGRATOR_CODE

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

1094: P_APPLICATION_ID,
1095: P_OBJECT_CODE,
1096: P_PARAM_LIST_CODE);
1097:
1098: -- Create the interface in the BNE_INTERFACES_B table
1099:
1100: INSERT INTO BNE_INTERFACES_B
1101: (APPLICATION_ID,
1102: INTERFACE_CODE,

Line 1100: INSERT INTO BNE_INTERFACES_B

1096: P_PARAM_LIST_CODE);
1097:
1098: -- Create the interface in the BNE_INTERFACES_B table
1099:
1100: INSERT INTO BNE_INTERFACES_B
1101: (APPLICATION_ID,
1102: INTERFACE_CODE,
1103: OBJECT_VERSION_NUMBER,
1104: INTEGRATOR_APP_ID,

Line 1282: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;

1278: P_SOURCE_LANG IN VARCHAR2,
1279: P_USER_ID IN NUMBER,
1280: P_INTERFACE_CODE OUT NOCOPY VARCHAR2)
1281: IS
1282: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
1283: VN_INTERFACE_EXISTS NUMBER;
1284: VN_VALID_CONTENT NUMBER;
1285: VV_DESCRIPTION VARCHAR2(240);
1286: BEGIN

Line 1315: FROM BNE_INTERFACES_B

1311:
1312: BEGIN
1313: SELECT INTERFACE_CODE
1314: INTO VV_INTERFACE_CODE
1315: FROM BNE_INTERFACES_B
1316: WHERE APPLICATION_ID = P_APPLICATION_ID
1317: AND INTERFACE_CODE = P_INTERFACE_CODE;
1318: EXCEPTION
1319: WHEN NO_DATA_FOUND THEN NULL;

Line 1328: FROM BNE_INTERFACES_B BI,

1324:
1325: BEGIN
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

Line 1363: -- Insert into BNE_INTERFACES_B

1359: EXCEPTION
1360: WHEN NO_DATA_FOUND THEN NULL;
1361: END;
1362:
1363: -- Insert into BNE_INTERFACES_B
1364: -- UPLOAD_TYPE of 4 is used to reference the constant BNE_UPLOAD_TYPE_REPORTING
1365:
1366: INSERT INTO BNE_INTERFACES_B
1367: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,

Line 1366: INSERT INTO BNE_INTERFACES_B

1362:
1363: -- Insert into BNE_INTERFACES_B
1364: -- UPLOAD_TYPE of 4 is used to reference the constant BNE_UPLOAD_TYPE_REPORTING
1365:
1366: INSERT INTO BNE_INTERFACES_B
1367: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
1368: INTERFACE_NAME, UPLOAD_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1369: VALUES
1370: (P_APPLICATION_ID, P_INTERFACE_CODE, 1, P_APPLICATION_ID, P_INTEGRATOR_CODE,

Line 4481: FROM BNE_INTERFACES_B

4477: VV_UPLOAD_LIST_CODE VARCHAR2(30);
4478: BEGIN
4479: SELECT COUNT(*)
4480: INTO VV_COUNT
4481: FROM BNE_INTERFACES_B
4482: WHERE APPLICATION_ID = P_APPLICATION_ID
4483: AND INTERFACE_CODE = P_INTERFACE_CODE;
4484:
4485: IF VV_COUNT = 0

Line 4495: FROM BNE_INTERFACES_B

4491: SELECT
4492: UPLOAD_PARAM_LIST_APP_ID, UPLOAD_PARAM_LIST_CODE
4493: INTO
4494: VV_UPLOAD_LIST_APP_ID, VV_UPLOAD_LIST_CODE
4495: FROM BNE_INTERFACES_B
4496: WHERE APPLICATION_ID = P_APPLICATION_ID
4497: AND INTERFACE_CODE = P_INTERFACE_CODE;
4498:
4499: DELETE FROM BNE_INTERFACES_B

Line 4499: DELETE FROM BNE_INTERFACES_B

4495: FROM BNE_INTERFACES_B
4496: WHERE APPLICATION_ID = P_APPLICATION_ID
4497: AND INTERFACE_CODE = P_INTERFACE_CODE;
4498:
4499: DELETE FROM BNE_INTERFACES_B
4500: WHERE APPLICATION_ID = P_APPLICATION_ID
4501: AND INTERFACE_CODE = P_INTERFACE_CODE;
4502:
4503: DELETE FROM BNE_INTERFACES_TL

Line 4567: FROM BNE_INTERFACES_B

4563: VV_COUNT NUMBER;
4564: BEGIN
4565: VV_COUNT := 0;
4566: FOR I IN (SELECT APPLICATION_ID, INTERFACE_CODE
4567: FROM BNE_INTERFACES_B
4568: WHERE INTEGRATOR_APP_ID = P_APPLICATION_ID
4569: AND INTEGRATOR_CODE = P_INTEGRATOR_CODE)
4570: LOOP
4571: VV_COUNT := VV_COUNT + DELETE_INTERFACE(I.APPLICATION_ID, I.INTERFACE_CODE);

Line 5501: FROM BNE_INTERFACES_B

5497:
5498: --
5499: SELECT COUNT(*)
5500: INTO VV_DUMMY
5501: FROM BNE_INTERFACES_B
5502: WHERE UPLOAD_PARAM_LIST_APP_ID = P_APPLICATION_ID
5503: AND UPLOAD_PARAM_LIST_CODE = P_PARAM_LIST_CODE;
5504:
5505: IF VV_DUMMY > 0