APPS.PON_WF_UTL_PKG SQL Statements

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

Line: 303

     *                x_neg_deleted   - Is negotiation deleted (hard delete)
     *
     *  The following is the list of destination pages with appropriate parameters needed to launch.
     * -------------------------------------------------------------------------
     * PAGE#    PAGE_NAME                     PAGE_PARAMETERS
     * -------------------------------------------------------------------------
     * PAGE-1:  Negotiation Summary           AuctionId; SiteId

Line: 334

              x_neg_deleted	OUT NOCOPY VARCHAR2) is
CURSOR wf_item_cur IS
  SELECT item_type,
         item_key
  FROM   wf_item_activity_statuses
  WHERE  notification_id  = p_ntf_id;

Line: 348

  SELECT SUBSTR(context,1,INSTR(context,':',1)-1),
         SUBSTR(context,INSTR(context,':')+1,
                       (INSTR(context,':',1,2) - INSTR(context,':')-1)),
         message_name
  FROM   wf_notifications
  WHERE  notification_id   = p_ntf_id;

Line: 437

                       select number_value
                       into   x_site_id
                       from   WF_NOTIFICATION_ATTRIBUTES
                       where  notification_id = p_ntf_id and
                              name = 'VENDOR_SITE_ID';

Line: 500

         SELECT 'N'
         INTO  x_neg_deleted
         FROM  PON_AUCTION_HEADERS_ALL
         WHERE auction_header_id = x_auction_id;

Line: 506

            x_neg_deleted := 'Y';

Line: 608

  select to_char(p_auction_header_id) || '-' ||
         to_char(p_request_id)
   into l_item_key from dual;

Line: 614

  SELECT
    auc.trading_partner_contact_name,
    auc.trading_partner_name,
    auc.auction_title,
    auc.document_number,
    dt.doctype_group_name
  INTO
    l_trading_partner_contact_name,
    l_trading_partner_name,
    l_auction_title,
    l_document_number,
    l_doctype_group_name
  FROM
    pon_auction_headers_all auc,
    pon_auc_doctypes dt
  WHERE
        dt.doctype_id= auc.doctype_id
    AND auc.auction_header_id = p_auction_header_id;

Line: 723

    select auction_header_id_prev_amend,revision
    into   l_auc_head_id_prev_amend,l_revision
    from pon_auction_headers_all
    where auction_header_id = p_auction_header_id;

Line: 728

    select document_number
    into l_amendment_number
    from pon_auction_headers_all
    where auction_header_id_prev_amend = l_auc_head_id_prev_amend
    and nvl(amendment_flag,'N') = 'Y';

Line: 834

	SELECT 	docTypes.DOCTYPE_GROUP_NAME
          INTO  l_document_type
	FROM   	PON_AUCTION_HEADERS_ALL   auctionHdr,
		PON_AUC_DOCTYPES          docTypes
	WHERE   auctionHdr.AUCTION_HEADER_ID = p_auction_id
   	AND	auctionHdr.DOCTYPE_ID = docTypes.DOCTYPE_ID;

Line: 906

	SELECT DECODE(P_DOCTYPE,SRC_AUCTION, notifGroups.AUCTION_SUBSCRIPTION_FLAG,
		            	SRC_RFQ,    notifGroups.RFQ_SUBSCRIPTION_FLAG,
                      	    	SRC_RFI,    notifGroups.RFI_SUBSCRIPTION_FLAG,
                                SRC_SOL,    notifGroups.SOL_SUBSCRIPTION_FLAG, --
                      		l_yes)
   	INTO 	l_notif_pref
	FROM 	PON_NOTIF_SUBSCRIPTION_GROUPS 	notifGroups,
        	PON_NOTIF_GROUP_MEMBERS 	notifMessages
    	WHERE
		notifGroups.NOTIF_GROUP_CODE 	=  notifMessages.NOTIF_GROUP_CODE
    	AND	notifMessages.NOTIF_MESSAGE_NAME = P_WF_MESSAGE_NAME;

Line: 1011

              SELECT application_id, responsibility_id
              INTO   l_application_id, l_responsibility_id
              FROM   fnd_responsibility
              WHERE  responsibility_key = l_def_ext_user_resp
              AND    (end_date IS NULL OR end_date > sysdate);

Line: 1050

         select fpov.profile_option_value
                 from fnd_profile_options fpo,
                          fnd_profile_option_values fpov
                 where   fpo.profile_option_name = p_name
         and  fpo.start_date_active  <= sysdate
         and  nvl(fpo.end_date_active, sysdate) >= sysdate
                 and  fpo.profile_option_id=fpov.profile_option_id
                 and  fpov.application_id=a_id
                 and fpov.level_id=l_id
                 and fpov.level_value=l_val
                 and fpov.profile_option_value is not null;