Apps New

APPS NEW

Example of Using the AD_DD Package Here is an example of using the AD_DD package to register a flexfield table and its columns: Though the use of AD_DD package does not require that the table should exist first, it is always better to create one and proceed further. Use the below mentioned script to create the dummy table. Use the APPS User ID to run the below mentioned queries from TOAD or SQL*PLUS. CREATE TABLE TEST_DESC ( RESOURCE_NAME VARCHAR2 (150), RESOURCE_TYPE VARCHAR2 (100), ATTRIBUTE_CATEGORY VARCHAR2 (40), ATTRIBUTE1 VARCHAR2 (150), ATTRIBUTE2 VARCHAR2 (150), ATTRIBUTE3 VARCHAR2 (150), ATTRIBUTE4 VARCHAR2 (150), ATTRIBUTE5 VARCHAR2 (150), ATTRIBUTE6 VARCHAR2 (150) ); BEGIN AD_DD.REGISTER_TABLE ('FND','TEST_DESC','T'); END; BEGIN AD_DD.REGISTER_COLUMN ('FND', 'VARCHAR2', 150, 'Y', 'N'); AD_DD.REGISTER_COLUMN ('FND', 'VARCHAR2', 100, 'Y', 'N'); AD_DD.REGISTER_COLUMN ('FND', 'VARCHAR2', 40, 'Y', 'N'); AD_DD.REGISTER_COLUMN ('FND', 150, 'Y', 'N'); AD_DD.REGISTER_COLUMN ('FND', 150, 'Y', 'N'); AD_DD.REGISTER_COLUMN ('FND', 150, 'Y', 'N'); AD_DD.REGISTER_COLUMN ('FND', 150, 'Y', 'N'); AD_DD.REGISTER_COLUMN ('FND', 150, 'Y', 'N'); AD_DD.REGISTER_COLUMN ('FND', 150, 'Y', 'N'); END;

'TEST_DESC','RESOURCE_NAME', 1, 'TEST_DESC','RESOURCE_TYPE', 2, 'TEST_DESC','ATTRIBUTE_CATEGORY', 3, 'TEST_DESC','ATTRIBUTE1', 4, 'VARCHAR2', 'TEST_DESC','ATTRIBUTE2', 5, 'VARCHAR2', 'TEST_DESC','ATTRIBUTE3', 6, 'VARCHAR2', 'TEST_DESC','ATTRIBUTE4', 7, 'VARCHAR2', 'TEST_DESC','ATTRIBUTE5', 8, 'VARCHAR2', 'TEST_DESC','ATTRIBUTE6', 9, 'VARCHAR2',