APPS.FND_FLEX_WF_PROCESSES dependencies on FND_FLEX_WORKFLOW_PROCESSES

Line 194: INSERT INTO fnd_flex_workflow_processes

190: validate_workflow_item(x_item_type);
191: validate_workflow_process(x_item_type, x_process_name);
192: END IF;
193:
194: INSERT INTO fnd_flex_workflow_processes
195: (application_id, id_flex_code, id_flex_num,
196: wf_item_type, wf_process_name,
197: last_update_date, last_updated_by,
198: creation_date, created_by, last_update_login)

Line 208: 'Insert on fnd_flex_workflow_processes failed.' ||

204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: raise_application_error(-20001,
208: 'Insert on fnd_flex_workflow_processes failed.' ||
209: g_newline || ' - Sqlerrm:' || Sqlerrm);
210: END add_workflow_item_type;
211:
212: -- --------------------------------------------------------------------

Line 221: FROM fnd_flex_workflow_processes

217: IS
218: BEGIN
219: message_init();
220: DELETE
221: FROM fnd_flex_workflow_processes
222: WHERE application_id = x_application_id
223: AND id_flex_code = x_code
224: AND id_flex_num = x_num
225: AND wf_item_type = x_item_type;

Line 252: UPDATE fnd_flex_workflow_processes

248: validate_workflow_item(x_item_type);
249: validate_workflow_process(x_item_type, x_process_name);
250: END IF;
251:
252: UPDATE fnd_flex_workflow_processes
253: SET wf_process_name = x_process_name
254: WHERE application_id = x_application_id
255: AND id_flex_code = x_code
256: AND id_flex_num = x_num

Line 268: UPDATE fnd_flex_workflow_processes

264: x_code || ',' || TO_CHAR(x_num));
265: END IF;
266:
267: IF (g_session_mode = 'customer_data') THEN
268: UPDATE fnd_flex_workflow_processes
269: SET last_update_date = l_who.last_update_date,
270: last_updated_by = l_who.last_updated_by,
271: last_update_login = l_who.last_update_login
272: WHERE application_id = x_application_id

Line 281: 'Update on fnd_flex_workflow_processes failed.'||

277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: raise_application_error(-20001,
281: 'Update on fnd_flex_workflow_processes failed.'||
282: g_newline || ' - Sqlerrm:' || Sqlerrm);
283: END change_workflow_process;
284:
285: PROCEDURE add_new_workflow_item_type(p_application_short_name IN VARCHAR2,

Line 310: INSERT INTO fnd_flex_workflow_processes

306:
307: validate_workflow_item(p_wf_item_type);
308: validate_workflow_process(p_wf_item_type, l_wf_process_name);
309:
310: INSERT INTO fnd_flex_workflow_processes
311: (
312: application_id,
313: id_flex_code,
314: id_flex_num,

Line 340: FROM fnd_flex_workflow_processes fwp

336: FROM fnd_id_flex_structures ifst
337: WHERE ifst.application_id = l_application_id
338: AND ifst.id_flex_code = p_id_flex_code
339: AND NOT exists (SELECT NULL
340: FROM fnd_flex_workflow_processes fwp
341: WHERE fwp.application_id = ifst.application_id
342: AND fwp.id_flex_code = ifst.id_flex_code
343: AND fwp.id_flex_num = ifst.id_flex_num
344: AND fwp.wf_item_type = p_wf_item_type);