DBA Data[Home] [Help]

APPS.BNE_CONTENT_UTILS dependencies on BNE_MAPPINGS_B

Line 864: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;

860: AND IC.INTERFACE_CODE = CP_INTERFACE_CODE
861: ORDER BY CC.SEQUENCE_NUM ASC;
862:
863: VV_MAPPING_USER_NAME BNE_MAPPINGS_TL.USER_NAME%TYPE;
864: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;
865: VN_SEQUENCE NUMBER;
866: BEGIN
867:
868: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND

Line 880: FROM BNE_MAPPINGS_B

876:
877: BEGIN
878: SELECT MAPPING_CODE
879: INTO VV_MAPPING_CODE
880: FROM BNE_MAPPINGS_B
881: WHERE APPLICATION_ID = P_APPLICATION_ID
882: AND MAPPING_CODE = P_MAPPING_CODE;
883: EXCEPTION
884: WHEN NO_DATA_FOUND THEN NULL;

Line 905: -- Create the Mapping record in the BNE_MAPPINGS_B table

901: EXCEPTION
902: WHEN NO_DATA_FOUND THEN NULL;
903: END;
904:
905: -- Create the Mapping record in the BNE_MAPPINGS_B table
906:
907: INSERT INTO BNE_MAPPINGS_B
908: (APPLICATION_ID, MAPPING_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
909: REPORTING_FLAG, REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE,

Line 907: INSERT INTO BNE_MAPPINGS_B

903: END;
904:
905: -- Create the Mapping record in the BNE_MAPPINGS_B table
906:
907: INSERT INTO BNE_MAPPINGS_B
908: (APPLICATION_ID, MAPPING_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
909: REPORTING_FLAG, REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE,
910: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
911: VALUES

Line 1018: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;

1014: AND IC.INTERFACE_CODE = CP_INTERFACE_CODE
1015: ORDER BY CC.SEQUENCE_NUM ASC;
1016:
1017: VV_MAPPING_USER_NAME BNE_MAPPINGS_TL.USER_NAME%TYPE;
1018: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;
1019: VN_SEQUENCE NUMBER;
1020: BEGIN
1021:
1022: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND

Line 1034: FROM BNE_MAPPINGS_B

1030:
1031: BEGIN
1032: SELECT MAPPING_CODE
1033: INTO VV_MAPPING_CODE
1034: FROM BNE_MAPPINGS_B
1035: WHERE APPLICATION_ID = P_APPLICATION_ID
1036: AND MAPPING_CODE = P_MAPPING_CODE;
1037: EXCEPTION
1038: WHEN NO_DATA_FOUND THEN NULL;

Line 1059: -- Create the Mapping record in the BNE_MAPPINGS_B table

1055: EXCEPTION
1056: WHEN NO_DATA_FOUND THEN NULL;
1057: END;
1058:
1059: -- Create the Mapping record in the BNE_MAPPINGS_B table
1060:
1061: INSERT INTO BNE_MAPPINGS_B
1062: (APPLICATION_ID, MAPPING_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
1063: REPORTING_FLAG, REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE,

Line 1061: INSERT INTO BNE_MAPPINGS_B

1057: END;
1058:
1059: -- Create the Mapping record in the BNE_MAPPINGS_B table
1060:
1061: INSERT INTO BNE_MAPPINGS_B
1062: (APPLICATION_ID, MAPPING_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
1063: REPORTING_FLAG, REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE,
1064: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1065: VALUES