859: AND CC.CONTENT_CODE = CP_CONTENT_CODE
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:
913: 'Y', P_APPLICATION_ID, P_INTERFACE_CODE,
914: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
915:
916:
917: -- Create the Mapping record in the BNE_MAPPINGS_TL table
918:
919: INSERT INTO BNE_MAPPINGS_TL
920: (APPLICATION_ID, MAPPING_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
921: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
915:
916:
917: -- Create the Mapping record in the BNE_MAPPINGS_TL table
918:
919: INSERT INTO BNE_MAPPINGS_TL
920: (APPLICATION_ID, MAPPING_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
921: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
922: VALUES
923: (P_APPLICATION_ID, P_MAPPING_CODE, P_LANGUAGE, P_SOURCE_LANGUAGE, VV_MAPPING_USER_NAME,
1013: AND CC.CONTENT_CODE = CP_CONTENT_CODE
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:
1066: (P_APPLICATION_ID, P_MAPPING_CODE, 1, P_APPLICATION_ID, P_INTEGRATOR_CODE,
1067: 'N', NULL, NULL, P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
1068:
1069:
1070: -- Create the Mapping record in the BNE_MAPPINGS_TL table
1071:
1072: INSERT INTO BNE_MAPPINGS_TL
1073: (APPLICATION_ID, MAPPING_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
1074: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1068:
1069:
1070: -- Create the Mapping record in the BNE_MAPPINGS_TL table
1071:
1072: INSERT INTO BNE_MAPPINGS_TL
1073: (APPLICATION_ID, MAPPING_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
1074: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1075: VALUES
1076: (P_APPLICATION_ID, P_MAPPING_CODE, P_LANGUAGE, P_SOURCE_LANGUAGE, VV_MAPPING_USER_NAME,