DBA Data[Home] [Help]

APPS.BNE_CONTENT_UTILS dependencies on BNE_MAPPINGS_TL

Line 901: VV_MAPPING_USER_NAME BNE_MAPPINGS_TL.USER_NAME%TYPE;

897: AND CC.CONTENT_CODE = CP_CONTENT_CODE
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:

Line 955: -- Create the Mapping record in the BNE_MAPPINGS_TL table

951: 'Y', P_APPLICATION_ID, P_INTERFACE_CODE,
952: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
953:
954:
955: -- Create the Mapping record in the BNE_MAPPINGS_TL table
956:
957: INSERT INTO BNE_MAPPINGS_TL
958: (APPLICATION_ID, MAPPING_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
959: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 957: INSERT INTO BNE_MAPPINGS_TL

953:
954:
955: -- Create the Mapping record in the BNE_MAPPINGS_TL table
956:
957: INSERT INTO BNE_MAPPINGS_TL
958: (APPLICATION_ID, MAPPING_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
959: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
960: VALUES
961: (P_APPLICATION_ID, P_MAPPING_CODE, P_LANGUAGE, P_SOURCE_LANGUAGE, VV_MAPPING_USER_NAME,

Line 1055: VV_MAPPING_USER_NAME BNE_MAPPINGS_TL.USER_NAME%TYPE;

1051: AND CC.CONTENT_CODE = CP_CONTENT_CODE
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:

Line 1108: -- Create the Mapping record in the BNE_MAPPINGS_TL table

1104: (P_APPLICATION_ID, P_MAPPING_CODE, 1, P_APPLICATION_ID, P_INTEGRATOR_CODE,
1105: 'N', NULL, NULL, P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
1106:
1107:
1108: -- Create the Mapping record in the BNE_MAPPINGS_TL table
1109:
1110: INSERT INTO BNE_MAPPINGS_TL
1111: (APPLICATION_ID, MAPPING_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
1112: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 1110: INSERT INTO BNE_MAPPINGS_TL

1106:
1107:
1108: -- Create the Mapping record in the BNE_MAPPINGS_TL table
1109:
1110: INSERT INTO BNE_MAPPINGS_TL
1111: (APPLICATION_ID, MAPPING_CODE, LANGUAGE, SOURCE_LANG, USER_NAME,
1112: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1113: VALUES
1114: (P_APPLICATION_ID, P_MAPPING_CODE, P_LANGUAGE, P_SOURCE_LANGUAGE, VV_MAPPING_USER_NAME,