APPS.PO_ONLINE_AUTHORING_WF_ACTIONS SQL Statements

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

Line: 76

     'poMode=update' || '&' ||
     'poCallingModule=notification' || '&' ||
     'poCallingNotifId=-&#NID-' || '&' ||
     'retainAM=Y' || '&' ||
     'addBreadCrumb=Y' || '&' ||
     'role=SUPPLIER';

Line: 117

  select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
  into l_seq_for_item_key
  from sys.dual;

Line: 277

  SELECT PO_WF_ITEMKEY_S.NEXTVAL
  INTO   l_seq_for_item_key
  FROM   DUAL;

Line: 421

        select vendor_name
          into l_role_display_name
          from po_vendors
          where vendor_id=l_vendor_id;

Line: 553

    SELECT employee_id
    INTO   l_emp_id
		FROM   fnd_user
    WHERE  user_id = p_lock_owner_user_id;

Line: 569

    SELECT user_name
    INTO   l_user_name
    FROM   fnd_user
    WHERE  user_id = p_lock_owner_user_id;

Line: 574

    SELECT PV.vendor_name
    INTO   x_wf_role_name_dsp
    FROM   po_headers_all POH,
           po_vendors PV
    WHERE  POH.po_header_id = p_po_header_id
    AND    POH.vendor_id = PV.vendor_id;

Line: 586

    SELECT MAX(role_name)
    INTO   x_wf_role_name
    FROM   WF_USER_ROLES
    WHERE  role_name = l_expected_wf_role_name;