APPS.FND_FLEX_WORKFLOW SQL Statements

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

Line: 176

FUNCTION select_process(appl_short_name IN VARCHAR2,
			code            IN VARCHAR2,
			num             IN NUMBER,
			itemtype        IN VARCHAR2)
  RETURN VARCHAR2
  IS
     l_pname VARCHAR2(30);

Line: 195

      SELECT
	wf_process_name
	INTO l_pname
	FROM fnd_flex_workflow_processes fwk, fnd_application app
	WHERE app.application_short_name = appl_short_name
	AND fwk.application_id = app.application_id
	AND fwk.id_flex_code = code
	AND fwk.id_flex_num = num
	AND fwk.wf_item_type = itemtype;

Line: 218

END select_process;

Line: 308

      SELECT
	application_id
	INTO l_application_id
	FROM fnd_application
	WHERE application_short_name = appl_short_name;

Line: 336

      SELECT
	COUNT(*)
	INTO l_nsegments
	FROM fnd_id_flex_segments
	WHERE application_id = l_application_id
	AND id_flex_code = code
	AND id_flex_num = num
	AND enabled_flag = 'Y';

Line: 371

      SELECT
	TO_CHAR(FND_FLEX_WORKFLOW_ITEMKEY_S.NEXTVAL)
	INTO l_itemkey
	FROM DUAL;

Line: 382

   l_pname := fnd_flex_workflow.select_process(appl_short_name, code, num,
					       itemtype);

Line: 437

   wf_engine.AddItemAttr(itemtype, l_itemkey, 'FND_FLEX_INSERT');

Line: 513

     l_insert_if_new   BOOLEAN := FALSE;

Line: 516

   RETURN generate(itemtype, itemkey, l_insert_if_new, ccid, concat_segs,
		   concat_ids, concat_descrs, error_message,
		   l_new_combination);

Line: 523

		  insert_if_new   IN BOOLEAN,
		  ccid            IN OUT nocopy NUMBER,
		  concat_segs     IN OUT nocopy VARCHAR2,
		  concat_ids      IN OUT nocopy VARCHAR2,
		  concat_descrs   IN OUT nocopy VARCHAR2,
		  error_message   IN OUT nocopy VARCHAR2,
		  new_combination IN OUT nocopy BOOLEAN) RETURN BOOLEAN
  IS
     l_process_status    VARCHAR2(100);

Line: 544

      debug('INSERT_IF_NEW = ' || bool_to_char(insert_if_new));

Line: 556

   IF (insert_if_new) THEN
      wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_INSERT', 'Y');

Line: 559

      wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_INSERT', 'N');

Line: 754

     l_insert_if_new BOOLEAN := FALSE;

Line: 758

			   l_insert_if_new, ccid, concat_segs, concat_ids,
			   concat_descrs, error_message, l_new_combination);

Line: 766

			  insert_if_new   IN BOOLEAN,
			  ccid            IN OUT nocopy NUMBER,
			  concat_segs     IN OUT nocopy VARCHAR2,
			  concat_ids      IN OUT nocopy VARCHAR2,
			  concat_descrs   IN OUT nocopy VARCHAR2,
			  error_message   IN OUT nocopy VARCHAR2,
			  new_combination IN OUT nocopy BOOLEAN)
  RETURN BOOLEAN
  IS
     l_process_status    VARCHAR2(100);

Line: 790

      debug('INSERT_IF_NEW = ' || bool_to_char(insert_if_new));

Line: 798

   IF (insert_if_new) THEN
      wf_engine.SetItemAttrText(itemtype, itemkey,
				'FND_FLEX_INSERT', 'Y');

Line: 803

				'FND_FLEX_INSERT', 'N');

Line: 949

   wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_INSERT', NULL);