DBA Data[Home] [Help]

APPS.BNE_CONTENT_UTILS dependencies on BNE_MAPPINGS_B

Line 902: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;

898: AND IC.INTERFACE_CODE = CP_INTERFACE_CODE
899: ORDER BY CC.SEQUENCE_NUM ASC;
900:
901: VV_MAPPING_USER_NAME BNE_MAPPINGS_TL.USER_NAME%TYPE;
902: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;
903: VN_SEQUENCE NUMBER;
904: BEGIN
905:
906: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND

Line 918: FROM BNE_MAPPINGS_B

914:
915: BEGIN
916: SELECT MAPPING_CODE
917: INTO VV_MAPPING_CODE
918: FROM BNE_MAPPINGS_B
919: WHERE APPLICATION_ID = P_APPLICATION_ID
920: AND MAPPING_CODE = P_MAPPING_CODE;
921: EXCEPTION
922: WHEN NO_DATA_FOUND THEN NULL;

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

939: EXCEPTION
940: WHEN NO_DATA_FOUND THEN NULL;
941: END;
942:
943: -- Create the Mapping record in the BNE_MAPPINGS_B table
944:
945: INSERT INTO BNE_MAPPINGS_B
946: (APPLICATION_ID, MAPPING_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
947: REPORTING_FLAG, REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE,

Line 945: INSERT INTO BNE_MAPPINGS_B

941: END;
942:
943: -- Create the Mapping record in the BNE_MAPPINGS_B table
944:
945: INSERT INTO BNE_MAPPINGS_B
946: (APPLICATION_ID, MAPPING_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
947: REPORTING_FLAG, REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE,
948: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
949: VALUES

Line 1056: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;

1052: AND IC.INTERFACE_CODE = CP_INTERFACE_CODE
1053: ORDER BY CC.SEQUENCE_NUM ASC;
1054:
1055: VV_MAPPING_USER_NAME BNE_MAPPINGS_TL.USER_NAME%TYPE;
1056: VV_MAPPING_CODE BNE_MAPPINGS_B.MAPPING_CODE%TYPE;
1057: VN_SEQUENCE NUMBER;
1058: BEGIN
1059:
1060: IF BNE_INTEGRATOR_UTILS.IS_VALID_APPL_ID(P_APPLICATION_ID) AND

Line 1072: FROM BNE_MAPPINGS_B

1068:
1069: BEGIN
1070: SELECT MAPPING_CODE
1071: INTO VV_MAPPING_CODE
1072: FROM BNE_MAPPINGS_B
1073: WHERE APPLICATION_ID = P_APPLICATION_ID
1074: AND MAPPING_CODE = P_MAPPING_CODE;
1075: EXCEPTION
1076: WHEN NO_DATA_FOUND THEN NULL;

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

1093: EXCEPTION
1094: WHEN NO_DATA_FOUND THEN NULL;
1095: END;
1096:
1097: -- Create the Mapping record in the BNE_MAPPINGS_B table
1098:
1099: INSERT INTO BNE_MAPPINGS_B
1100: (APPLICATION_ID, MAPPING_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
1101: REPORTING_FLAG, REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE,

Line 1099: INSERT INTO BNE_MAPPINGS_B

1095: END;
1096:
1097: -- Create the Mapping record in the BNE_MAPPINGS_B table
1098:
1099: INSERT INTO BNE_MAPPINGS_B
1100: (APPLICATION_ID, MAPPING_CODE, OBJECT_VERSION_NUMBER, INTEGRATOR_APP_ID, INTEGRATOR_CODE,
1101: REPORTING_FLAG, REPORTING_INTERFACE_APP_ID, REPORTING_INTERFACE_CODE,
1102: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1103: VALUES