APPS.WF_FWKMON SQL Statements

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

Line: 19

      SELECT decode(ma.type,
                  'NUMBER', to_char(na.number_value),
                  'DATE',   to_char(na.date_value,
                                 nvl(ma.format, 'DD/MON/YYYY HH24:MI:SS')),
                  'LOOKUP', wf_core.activity_result(ma.format, na.text_value),
                     na.text_value) result
        FROM   wf_notification_attributes na,
               wf_message_attributes_vl ma,
               wf_notifications n
        WHERE  n.notification_id = x_notificationId
        AND    n.message_type = ma.message_type
        AND    n.message_name = ma.message_name
        AND    ma.name = na.name
        AND    ma.name = 'RESULT'
        AND    na.notification_id = n.notification_id;

Line: 63

  SELECT 1
  INTO   resp_exists
  FROM	 wf_notifications wn,
	 wf_notification_attributes wna,
         wf_message_attributes m
  WHERE  wn.notification_id = x_notificationId
  AND	 wn.notification_id = wna.notification_id
  AND	 wn.message_name = m.message_name
  AND 	 wn.message_type = m.message_type
  AND	 m.name = wna.name
  AND    m.subtype = 'RESPOND'
  AND    rownum = 1;

Line: 105

  SELECT wias.activity_result_code,
         wias.activity_status
  FROM   wf_item_activity_statuses  wias,
         wf_activities    wa,
         wf_process_activities   wpa
 WHERE   wias.item_key = x_itemKey
         AND wias.item_type = x_itemType
         AND wa.name = x_rootProcess
         AND wa.version = x_rootVersion
  AND wa.item_type = x_itemType
  AND wa.name = wpa.activity_name
  AND wpa.instance_id = wias.process_activity;

Line: 129

    SELECT 1
    INTO   error_count
    FROM   wf_item_activity_statuses
    WHERE  item_type = x_itemType
    AND    item_key = x_itemKey
    AND    activity_status = 'ERROR'
    AND    rownum = 1;

Line: 185

    select email_address
    from wf_roles
    where name = x_role_name
    and   ORIG_SYSTEM NOT IN ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
                              'HZ_GROUP','CUST_CONT');

Line: 192

    select email_address
    from wf_roles
    where orig_system = substr(x_role_name, 1, colon-1)
    and orig_system_id = substr(x_role_name, colon+1)
    and name = x_role_name;

Line: 449

    icx_sec.updateSessionContext(p_application_id => 178,
                                 p_responsibility_id => 20873,
                                 p_security_group_id => 0,
                                 p_session_id => l_session_id,
				 p_transaction_id => l_transaction_id);

Line: 463

      SELECT max(transaction_id)
      INTO   l_transaction_id
      FROM   icx_transactions
      WHERE  session_id = icx_sec.g_session_id
      AND    responsibility_id = icx_sec.g_responsibility_id
      AND    security_group_id = icx_sec.g_security_group_id
      AND    function_id = icx_sec.g_function_id
      GROUP BY transaction_id;

Line: 475

          SELECT icx_transactions_s.nextval
          INTO   l_transaction_id
          FROM   sys.dual;

Line: 540

  SELECT responder
  INTO   l_responder
  FROM   wf_notifications
  WHERE  notification_id = p_notification_id;

Line: 554

  SELECT wc.from_user
  INTO   l_username
  FROM   wf_notifications wn,
         wf_comments wc
  WHERE  wn.notification_id = p_notification_id
    AND  wn.notification_id = wc.notification_id
    AND  wn.responder = wc.from_role
    AND  wc.action_type = 'RESPOND'
    AND  wc.action like 'RESPOND%'
    AND  rownum = 1;