APPS.FND_FLEX_WF_PROCESSES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

   last_updated_by   NUMBER,
   last_update_date  DATE,
   last_update_login NUMBER
   );

Line: 40

   l_who.last_updated_by   := l_who.created_by;

Line: 41

   l_who.last_update_date  := l_who.creation_date;

Line: 42

   l_who.last_update_login := 0;

Line: 66

   SELECT 1
     INTO dummy
     FROM fnd_id_flex_structures
     WHERE application_id = x_application_id
     AND id_flex_code = x_code
     AND id_flex_num = x_num;

Line: 89

      SELECT 1
	INTO dummy
	FROM  wf_runnable_processes_v
	WHERE item_type = x_item_type
	AND process_name = x_process;

Line: 113

      SELECT 1
	INTO dummy
	FROM  wf_item_types_vl item
	WHERE item.name = x_name;

Line: 194

   INSERT INTO fnd_flex_workflow_processes
     (application_id, id_flex_code, id_flex_num,
      wf_item_type, wf_process_name,
      last_update_date, last_updated_by,
      creation_date, created_by, last_update_login)
     VALUES
     (x_application_id, x_code, x_num,
      x_item_type, x_process_name,
      l_who.last_update_date, l_who.last_updated_by,
      l_who.creation_date, l_who.created_by, l_who.last_update_login);

Line: 208

			      'Insert on fnd_flex_workflow_processes failed.' ||
			      g_newline || ' - Sqlerrm:' || Sqlerrm);

Line: 213

PROCEDURE delete_workflow_item_type(x_application_id IN NUMBER,
				    x_code           IN VARCHAR2,
				    x_num            IN NUMBER,
				    x_item_type      IN VARCHAR2)
  IS
BEGIN
   message_init();

Line: 220

   DELETE
     FROM fnd_flex_workflow_processes
     WHERE application_id = x_application_id
     AND id_flex_code = x_code
     AND id_flex_num = x_num
     AND wf_item_type = x_item_type;

Line: 229

			      'Delete failed.' ||
			      g_newline || ' - Sqlerrm:' || Sqlerrm);

Line: 231

END delete_workflow_item_type;

Line: 252

   UPDATE fnd_flex_workflow_processes
     SET wf_process_name = x_process_name
     WHERE application_id = x_application_id
     AND id_flex_code = x_code
     AND id_flex_num = x_num
     AND wf_item_type = x_item_type;

Line: 268

      UPDATE fnd_flex_workflow_processes
	SET last_update_date = l_who.last_update_date,
	last_updated_by = l_who.last_updated_by,
	last_update_login = l_who.last_update_login
	WHERE application_id = x_application_id
	AND id_flex_code = x_code
	AND id_flex_num = x_num
	AND x_item_type = x_item_type;

Line: 281

			      'Update on fnd_flex_workflow_processes failed.'||
			      g_newline || ' - Sqlerrm:' || Sqlerrm);

Line: 297

      SELECT application_id
	INTO l_application_id
	FROM fnd_application
	WHERE application_short_name = p_application_short_name;

Line: 310

   INSERT INTO fnd_flex_workflow_processes
     (
      application_id,
      id_flex_code,
      id_flex_num,
      wf_item_type,
      wf_process_name,

      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login
      )
     SELECT
     ifst.application_id,
     ifst.id_flex_code,
     ifst.id_flex_num,
     p_wf_item_type,
     l_wf_process_name,

     l_who.last_update_date,
     l_who.last_updated_by,
     l_who.creation_date,
     l_who.created_by,
     l_who.last_update_login
     FROM fnd_id_flex_structures ifst
     WHERE ifst.application_id = l_application_id
     AND ifst.id_flex_code = p_id_flex_code
     AND NOT exists (SELECT NULL
		     FROM fnd_flex_workflow_processes fwp
		     WHERE fwp.application_id = ifst.application_id
		     AND fwp.id_flex_code = ifst.id_flex_code
		     AND fwp.id_flex_num = ifst.id_flex_num
		     AND fwp.wf_item_type = p_wf_item_type);