Adding Source Code Types

If you are creating a Program or Business Area adapter, you may need to create one or more new Source Code types and a new file type for each new Source Code type.

Before you can create a source code type you must:

• Create a technology type by calling the Create Technology Type API; see Creating a Technology Type. Enter the Tech Type ID in the TECH_TYPE_ID column for the source code type.
• Add the file type you need for your adapter source code by extending the CDR_FILE_TYPES lookup; see Adding Lookup Values. Enter the file extension in the DEFAULT_EXTN column for the source code type. Do not include the dot (.) before the letters in the extension.

You then create a a new Source Code type to link your technology type with your file type. To create a new Source Code type, call the procedure cdr_srccode_types_m.insertRow:

PROCEDURE InsertRow( pRecord   in out nocopy CDR_SRCCODE_TYPES%rowtype );

The columns in the Source Code Types table include the following. See the section on Source Code in the "Defining Programs" chapter of the Oracle Life Sciences Data Hub Application Developer's Guide for information about these Source Code attributes.

• Tech Type ID. Enter the ID of your technology type. This is generated by Oracle LSH when you create the technology type; see Creating a Technology Type.
• Source Code Type RC. Enter the new file type you added to the CDR_FILE_TYPES lookup in the format $FILETYPES$NEW_FILE_TYPE.
• Binary Flag RC
• Use Libname RC
• Position
• Allowed as Primary Flag RC
• Instantiated from Different Program
• Default Extension. Enter the extension of the new file type, including the dot (.) preceding it; for example, .xml.