APPS.OE_VALIDATE_WF SQL Statements

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

Line: 44

    SELECT DISTINCT wa.name, wa.display_name
    INTO   l_process_name, l_display_name
    FROM   wf_activities_tl wa
    WHERE  wa.item_type = l_item_type
    AND    wa.name = l_process
    AND    wa.language = userenv('LANG')
    AND    wa.version =
           ( SELECT MAX(p1.version)
	     FROM   wf_activities_tl p1
	     WHERE  p1.item_type = wa.item_type
	     AND    p1.name = wa.name
	     AND    p1.language = wa.language
	   );

Line: 99

SELECT to_process_activity
FROM   wf_activity_transitions
WHERE  from_process_activity = c_activity_id;

Line: 118

    G_loop_tbl.DELETE;

Line: 197

SELECT p.instance_id
FROM   wf_process_activities p
WHERE  p.process_item_type = l_process_item_type
AND    p.process_name = l_process
AND    p.activity_item_type = l_activity_item_type
AND    p.activity_name = l_activity
AND    p.process_version =
           ( SELECT MAX(p1.process_version)
	     FROM   wf_process_activities p1
	     WHERE  p1.process_item_type = p.process_item_type
	     AND    p1.process_name = p.process_name
	   );

Line: 212

SELECT p.activity_name
     , p.activity_item_type
FROM   wf_process_activities p
     , wf_activities wa
WHERE  p.process_item_type = l_process_item_type
AND    p.process_name = l_process
AND    p.activity_item_type = wa.item_type
AND    p.activity_name = wa.name
AND    wa.type = 'PROCESS'
AND    p.process_version =
           ( SELECT MAX(p1.process_version)
	     FROM   wf_process_activities p1
	     WHERE  p1.process_item_type = p.process_item_type
	     AND    p1.process_name = p.process_name
	   )
AND    wa.version = ( SELECT MAX(wa1.version)
                      FROM   wf_activities wa1
		      WHERE  wa1.item_type = wa.item_type
		      AND    wa1.name = wa.name
		     );

Line: 331

SELECT  p.activity_name
      , p.process_name
      , p.activity_item_type
      , p.instance_id
      , w.type
      , w.function
      , p.instance_label
      , p.start_end
FROM   wf_process_activities p , wf_activities w
WHERE  p.process_item_type = l_process_item_type
AND    p.process_name = l_process
AND    p.activity_item_type = w.item_type
AND    p.activity_name = w.name
AND    p.activity_item_type = l_activity_item_type
AND    p.activity_name = l_instance_label
AND    p.process_version = l_process_act_version
AND    SYSDATE >= w.begin_date
AND    SYSDATE <= nvl(w.end_date, SYSDATE);

Line: 353

SELECT  p.activity_name
      , p.process_name
      , p.activity_item_type
      , p.instance_id
      , w.type
      , w.function
      , p.instance_label
      , p.start_end
FROM   wf_process_activities p , wf_activities w
WHERE  p.process_item_type = l_process_item_type
AND    p.process_name = l_process
AND    p.activity_item_type = w.item_type
AND    p.activity_name = w.name
AND    p.process_version = l_process_act_version
AND    SYSDATE >= w.begin_date
AND    SYSDATE <= nvl(w.end_date, SYSDATE);

Line: 373

SELECT p.activity_name
     , p.activity_item_type
FROM   wf_process_activities p
     , wf_activities wa
WHERE  p.process_item_type = l_process_item_type
AND    p.process_name = l_process
AND    p.activity_item_type = wa.item_type
AND    p.activity_name = wa.name
AND    wa.type = 'PROCESS'
AND    p.process_version = l_process_act_version
AND    SYSDATE >= wa.begin_date
AND    SYSDATE <= nvl(wa.end_date, SYSDATE);

Line: 412

  SELECT MAX(process_version)
  INTO   l_process_act_version
  FROM   wf_process_activities p1
  WHERE  process_item_type = l_process_item_type
  AND    process_name = l_process;

Line: 528

      SELECT text_value, name
      INTO   l_text_value, l_wait_mode_name
      FROM   wf_activity_attr_values
      WHERE  process_activity_id = l_activity_id
      AND    name = 'WAIT_MODE';

Line: 542

       SELECT text_value, name
       INTO   l_mode_text_value, l_mode_name
       FROM   wf_activity_attr_values
       WHERE  process_activity_id = l_activity_id
       AND    value_type = 'CONSTANT'
       AND    name                = 'WAIT_ABSOLUTE_DATE';

Line: 556

       SELECT text_value, name
       INTO   l_mode_text_value, l_mode_name
       FROM   wf_activity_attr_values
       WHERE  process_activity_id = l_activity_id
       AND    value_type = 'CONSTANT'
       AND    name                = 'WAIT_DAY_OF_MONTH';

Line: 570

       SELECT text_value, name
       INTO   l_mode_text_value, l_mode_name
       FROM   wf_activity_attr_values
       WHERE  process_activity_id = l_activity_id
       AND    value_type = 'CONSTANT'
      AND    name                = 'WAIT_DAY_OF_WEEK';

Line: 584

       SELECT text_value, name
       INTO   l_mode_text_value, l_mode_name
       FROM   wf_activity_attr_values
       WHERE  process_activity_id = l_activity_id
       AND    value_type = 'CONSTANT'
       AND    name                = 'WAIT_RELATIVE_TIME';

Line: 598

       SELECT text_value, name
       INTO   l_mode_text_value, l_mode_name
       FROM   wf_activity_attr_values
       WHERE  process_activity_id = l_activity_id
       AND    value_type = 'CONSTANT'
       AND    name                = 'WAIT_TIME';

Line: 650

       SELECT text_value
       INTO   l_text_value_relative
       FROM   wf_activity_attr_values
       WHERE  process_activity_id = l_activity_id
       AND    name = 'WAIT_MODE';

Line: 664

         SELECT number_value
	 INTO   l_number_value
         FROM   wf_activity_attr_values
         WHERE  process_activity_id = l_activity_id
         AND    name = 'WAIT_RELATIVE_TIME';

Line: 878

  SELECT process_name,
         item_type_code /* Bug # 4908592 */
  FROM   oe_workflow_assignments
  WHERE  order_type_id = c_type_id
  AND    line_type_id IS NOT NULL
  AND    NVL(wf_item_type,'OEOL') = 'OEOL'
  AND    SYSDATE >= start_date_active
  AND    TRUNC(SYSDATE) <= nvl(end_date_active, SYSDATE);

Line: 947

      SELECT text_value
      INTO   l_wait_text_default
      FROM   wf_activity_attr_values waa
      WHERE  waa.name = 'WAITING_ACTIVITY'
      AND    process_activity_id = l_instance_id;

Line: 970

      SELECT 'YES'
      INTO   l_coresp_cont_act
      FROM   wf_activities wa
      WHERE  wa.function = 'WF_STANDARD.WAITFORFLOW'
      AND    wa.name = l_wait_text_default
      AND    wa.item_type IN ('OEOH','OEOL')
      AND    wa.version = ( SELECT MAX(version)
                            FROM   wf_activities wa1
	                    WHERE  wa1.item_type = wa.item_type
	    		    AND    wa1.name = wa.name );

Line: 997

      SELECT text_value
      INTO   l_flow_name
      FROM   wf_activity_attr_values waa
      WHERE  waa.name = 'WAITING_FLOW'
      AND    process_activity_id = l_instance_id;

Line: 1051

      SELECT text_value
      INTO   l_cont_text_default
      FROM   wf_activity_attr_values waa
      WHERE  waa.name = 'CONTINUATION_ACTIVITY'
      AND    process_activity_id = l_instance_id;

Line: 1073

      SELECT 'YES'
      INTO   l_coresp_wait_act
      FROM   wf_activities wa
      WHERE  wa.function = 'WF_STANDARD.CONTINUEFLOW'
      AND    wa.name = l_cont_text_default
      AND    wa.item_type IN ('OEOH','OEOL')
      AND    wa.version = ( SELECT MAX(version)
                            FROM   wf_activities wa1
	                    WHERE  wa1.item_type = wa.item_type
	    		    AND    wa1.name = wa.name );

Line: 1100

      SELECT text_value
      INTO   l_flow_name
      FROM   wf_activity_attr_values waa
      WHERE  waa.name = 'CONTINUATION_FLOW'
      AND    process_activity_id = l_instance_id;

Line: 1169

      G_all_activity_tbl.DELETE;

Line: 1282

	G_all_activity_tbl.DELETE;

Line: 1438

  G_all_activity_tbl.DELETE;

Line: 1456

          SELECT 'Y'
          INTO l_from_process_activity_exists
          FROM   wf_activity_transitions
          WHERE  from_process_activity =
                          l_all_activity_tbl(l_instance).instance_id
          AND    ROWNUM = 1;

Line: 1524

select TEXT_VALUE FulfillAttr
from   wf_activity_attr_values
where  process_activity_id = c_instance_id
and    NAME IN ( 'FULFILLMENT_ACTIVITY'
               , 'INBOUND_FULFILLMENT_ACTIVITY');

Line: 1580

  G_all_activity_tbl.DELETE;

Line: 1602

  	  -- AND is selected for the first time - using variable
	  -- 'l_attr_first_time' and 'l_continue_further'
          IF fulfill_attributes.FulfillAttr IS NOT NULL THEN
            IF l_attr_first_time IS NULL THEN
              l_attr_first_time := ''''||fulfill_attributes.FulfillAttr||'''';

Line: 1671

      G_all_activity_tbl.DELETE;

Line: 1701

                SELECT text_value
                INTO   l_activity
                FROM   wf_activity_attr_values waa
                WHERE  waa.name = 'WAITING_ACTIVITY'
                AND    process_activity_id = l_hdr_activity_tbl(hdr_instance).instance_id;

Line: 1723

                SELECT text_value
                INTO   l_activity
                FROM   wf_activity_attr_values waa
                WHERE  waa.name = 'CONTINUATION_ACTIVITY'
                AND    process_activity_id = l_hdr_activity_tbl(hdr_instance).instance_id;

Line: 2027

  G_all_activity_tbl.DELETE;

Line: 2043

        SELECT DISTINCT process_name
        INTO   l_line_process_name
        FROM   oe_workflow_assignments
        WHERE  order_type_id = l_order_type_id
        AND    line_type_id IS NOT NULL
        AND    NVL(wf_item_type,'OEOL') = 'OEOL'
        AND    SYSDATE >= start_date_active
        AND    TRUNC(SYSDATE) <= nvl(end_date_active, SYSDATE)
        AND    ROWNUM = 1;

Line: 2053

        G_all_activity_tbl.DELETE;

Line: 2077

                  SELECT text_value
                  INTO   l_activity
                  FROM   wf_activity_attr_values waa
                  WHERE  waa.name = 'WAITING_ACTIVITY'
                  AND    process_activity_id = l_lin_activity_tbl(line_instance).instance_id;

Line: 2099

                  SELECT text_value
                  INTO   l_activity
                  FROM   wf_activity_attr_values waa
                  WHERE  waa.name = 'CONTINUATION_ACTIVITY'
                  AND    process_activity_id = l_lin_activity_tbl(line_instance).instance_id;

Line: 2329

  SELECT sales_document_type_code
       , transaction_type_id
       , transaction_type_code
       , order_category_code
       , start_date_active
       , end_date_active
  FROM   oe_transaction_types_vl
  WHERE  transaction_type_code  = 'ORDER'
  AND    SYSDATE >= start_date_active
  AND    TRUNC(SYSDATE) <= NVL(end_date_active, SYSDATE);

Line: 2341

  SELECT DISTINCT process_name, item_type_code
  FROM   oe_workflow_assignments
  WHERE  order_type_id = c_type_id
  AND    line_type_id IS NOT NULL
  AND    NVL(wf_item_type, 'OEOL') = 'OEOL'
  AND    SYSDATE >= start_date_active
  AND    TRUNC(SYSDATE) <= nvl(end_date_active, SYSDATE);

Line: 2350

  SELECT DISTINCT process_name
  FROM   oe_workflow_assignments
  WHERE  order_type_id = c_type_id
  AND    line_type_id IS NOT NULL
  AND    NVL(wf_item_type,'OEOL') = 'OEOL'
  AND    SYSDATE >= start_date_active
  AND    TRUNC(SYSDATE) <= nvl(end_date_active, SYSDATE);

Line: 2359

  SELECT DISTINCT process_name
  FROM   oe_workflow_assignments
  WHERE  order_type_id = c_type_id
  AND    wf_item_type = c_item_type
  AND    SYSDATE >= start_date_active
  AND    TRUNC(SYSDATE) <= nvl(end_date_active, SYSDATE);

Line: 2395

    SELECT sales_document_type_code
         , transaction_type_id
         , transaction_type_code
         , order_category_code
         , start_date_active
         , end_date_active
    INTO   l_transaction_tbl(1).sales_document_type_code
         , l_transaction_tbl(1).transaction_type_id
         , l_transaction_tbl(1).transaction_type_code
         , l_transaction_tbl(1).order_category_code
         , l_transaction_tbl(1).start_date_active
         , l_transaction_tbl(1).end_date_active
    FROM   oe_transaction_types_all
    WHERE  transaction_type_id = l_order_type_id;

Line: 2431

        SELECT name
        INTO   l_validating_flow
        FROM oe_transaction_types_vl
        WHERE TRANSACTION_TYPE_ID = l_transaction_tbl(l_record_count).transaction_type_id;

Line: 2454

          SELECT process_name
          INTO   l_process_name
          FROM   oe_workflow_assignments
          WHERE  order_type_id = l_transaction_tbl(l_record_count).transaction_type_id
          AND    line_type_id IS NULL
          AND    wf_item_type = 'OEOH'
          AND    SYSDATE >= start_date_active
          AND    TRUNC(SYSDATE) <= NVL(end_date_active, SYSDATE);

Line: 2484

          /* Selecting from oe_workflow_assignments distinct order line
             (OEOL) internal workflow process names and OM item type
             combinations assigned to this order type */

          FOR line_item_processes IN c_line_item_process(l_transaction_tbl(l_record_count).transaction_type_id) LOOP

            OE_VALIDATE_WF.LINE_FLOW_ASSIGNMENT
            ( p_name          => line_item_processes.process_name
            , p_item_type     => line_item_processes.item_type_code
            , x_return_status => l_return_status
            , x_msg_count     => l_msg_count
            );

Line: 2501

          /* Selecting from oe_workflow_assignments distinct order line
             (OEOL) internal workflow process names assigned to this
             order type */

          FOR line_processes IN c_line_process(l_transaction_tbl(l_record_count).transaction_type_id) LOOP
            OE_VALIDATE_WF.VALIDATE_LINE_FLOW
	    ( p_name          => line_processes.process_name
 	    , p_order_flow    => l_process_name
 	    , p_quick_val     => FALSE
 	    , x_return_status => l_return_status
 	    , x_msg_count     => l_msg_count
	    , x_msg_data      => l_msg_data
	    );