[Home] [Help]
170:
171: --
172: -- **GL Accounting Flexfield specific validation**
173: -- After inserting a new structure for the "GL Accounting Flexfield",
174: -- we also need to insert some default rows into the FND_FLEX_WORKFLOW_PROCESSES table.
175: --
176: IF (v_application_id = 101 AND v_id_flex_code = 'GL#'
177: AND v_id_flex_num <> 101 AND v_operation = 'DML_INSERT') THEN
178: INSERT INTO FND_FLEX_WORKFLOW_PROCESSES(APPLICATION_ID,
174: -- we also need to insert some default rows into the FND_FLEX_WORKFLOW_PROCESSES table.
175: --
176: IF (v_application_id = 101 AND v_id_flex_code = 'GL#'
177: AND v_id_flex_num <> 101 AND v_operation = 'DML_INSERT') THEN
178: INSERT INTO FND_FLEX_WORKFLOW_PROCESSES(APPLICATION_ID,
179: ID_FLEX_CODE,
180: ID_FLEX_NUM,
181: WF_ITEM_TYPE,
182: WF_PROCESS_NAME,
194: FS.LAST_UPDATED_BY,
195: SYSDATE,
196: FS.CREATED_BY,
197: FS.LAST_UPDATE_LOGIN
198: FROM FND_FLEX_WORKFLOW_PROCESSES FWP,
199: FND_ID_FLEX_STRUCTURES FS
200: WHERE FWP.APPLICATION_ID = v_application_id
201: AND FWP.ID_FLEX_CODE = v_id_flex_code
202: AND FWP.ID_FLEX_NUM = 101
203: AND FS.APPLICATION_ID = v_application_id
204: AND FS.ID_FLEX_CODE = v_id_flex_code
205: AND FS.ID_FLEX_NUM = v_id_flex_num
206: AND NOT EXISTS (SELECT 'Row already exists'
207: FROM FND_FLEX_WORKFLOW_PROCESSES FWP2
208: WHERE FWP2.APPLICATION_ID = v_application_id
209: AND FWP2.ID_FLEX_CODE = v_id_flex_code
210: AND FWP2.ID_FLEX_NUM = v_id_flex_num
211: AND FWP2.WF_ITEM_TYPE = FWP.WF_ITEM_TYPE);