[Home] [Help]
120: sysdate,
121: -1351,
122: -1351 );
123:
124: insert into CS_KB_ELEMENT_TYPES_TL (
125: ELEMENT_TYPE_ID,
126: NAME,
127: DESCRIPTION,
128: CREATION_DATE,
146: from FND_LANGUAGES L
147: where L.INSTALLED_FLAG in ('I', 'B')
148: and not exists
149: (select NULL
150: from CS_KB_ELEMENT_TYPES_TL T
151: where T.ELEMENT_TYPE_ID = P_ID
152: and T.LANGUAGE = L.LANGUAGE_CODE);
153: END Create_Stmt_Type;
154:
242: -------------------------------------------------------------
243: -- Create Seeded Statement Types
244: -------------------------------------------------------------
245: DELETE FROM CS_KB_ELEMENT_TYPES_B WHERE ELEMENT_TYPE_ID = STMT_TYPE_FAQ_API_TEST;
246: DELETE FROM CS_KB_ELEMENT_TYPES_TL WHERE ELEMENT_TYPE_ID = STMT_TYPE_FAQ_API_TEST;
247: Create_Stmt_Type (P_ID => STMT_TYPE_FAQ_API_TEST, P_NAME => 'FAQ_API_TEST');
248:
249: -------------------------------------------------------------
250: -- Create Seeded Solution to Statement Type Associations