APPS.PON_CLM_UTIL_PKG SQL Statements

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

Line: 9

  SELECT count(*)
  INTO  l_rule_count
  FROM  PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules,
	PON_AUC_BIZRULES pon_auc_bizrules
  WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
  AND pon_auc_doctype_rules.DOCTYPE_ID = p_doc_type_id
  AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION'
  AND pon_auc_doctype_rules.default_value = 'Y';

Line: 28

   select nvl(amendment_flag,'N') into l_is_amendment from pon_auction_headers_all
      where auction_header_id = p_auction_header_id;

Line: 38

   select auh.doctype_id
   into l_doctype_id
   from pon_auction_headers_all auh
   where auh.auction_header_id = p_auction_header_id;

Line: 79

PROCEDURE UPDATE_HEADER_STYLE_ID(p_auction_header_id IN NUMBER,
                                 p_style_id          IN NUMBER) IS

l_api_name 	  CONSTANT 	VARCHAR2(30) := 'UPDATE_HEADER_STYLE_ID';

Line: 93

        update pon_auction_headers_all
        set po_style_id = p_style_id
        where
        auction_header_id = p_auction_header_id;

Line: 101

		               message   => 'Updated style id successfully.');

Line: 112

END UPDATE_HEADER_STYLE_ID;

Line: 171

     SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;

Line: 189

         return ' exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE
                  PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND
                  PAB.NAME = ''FEDERAL_NEGOTIATION'' AND PADR.DEFAULT_VALUE = ''Y'') ';

Line: 193

         return ' not exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE
                  PADR.BIZRULE_ID = PAB.BIZRULE_ID AND PADR.DOCTYPE_ID = PON_AUCTION_HEADERS.DOCTYPE_ID AND
                  PAB.NAME = ''FEDERAL_NEGOTIATION'' AND PADR.DEFAULT_VALUE = ''Y'') ';

Line: 212

   select group_line_id into l_group_line_id
      from pon_auction_item_prices_all
      where auction_header_id = p_auction_header_id
      and line_number = p_line_number;

Line: 228

      select nvl(clm_info_flag,'N') into l_info_flag
      from pon_auction_item_prices_all
      where auction_header_id = p_auction_header_id
      and line_number = p_line_number;

Line: 244

	 select count(*) into l_child_count
      from pon_auction_item_prices_all
      where auction_header_id = p_auction_header_id
      and group_line_id = p_line_number;

Line: 260

	 select count(*) into l_child_count
      from pon_auction_item_prices_all
      where auction_header_id = p_auction_header_id
      and CLM_BASE_LINE_NUM = p_line_number;

Line: 277

  SELECT document_number INTO docNumber FROM pon_auction_headers_all
  WHERE  auction_header_id = p_auction_header_id;

Line: 332

SELECT DOCUMENT_NUMBER INTO L_DOCUMENT_NUMBER
FROM
PON_AUCTION_HEADERS
WHERE
AUCTION_HEADER_ID=(SELECT AUCTION_HEADER_ID_ORIG_ROUND
                    FROM
                    PON_AUCTION_HEADERS PAH2
                    WHERE
                    PAH2.AUCTION_HEADER_ID=P_AUCTION_HEADER_ID
                  );

Line: 343

SELECT DOCUMENT_NUMBER INTO L_DOCUMENT_NUMBER
FROM
PON_AUCTION_HEADERS
WHERE
AUCTION_HEADER_ID=P_AUCTION_HEADER_ID;

Line: 354

PROCEDURE UPDATE_UMBRELLA_PROG(p_auction_header_id IN NUMBER,
		               p_program_id        IN NUMBER ) IS

		      l_api_name 	  CONSTANT 	VARCHAR2(30) := 'UPDATE_UMBRELLA_PROG';

Line: 367

		              update pon_auction_headers_all
		             set umbrella_program_id = p_program_id
		             where
		             auction_header_id = p_auction_header_id;

Line: 374

		     		               message   => 'Updated program id successfully.');

Line: 383

		     END UPDATE_UMBRELLA_PROG;

Line: 403

 SELECT nvl(fsp.purch_encumbrance_flag, 'N'), pah.contract_type INTO l_encumberence_flag,l_outcome_document_type
     FROM financials_system_params_all fsp, pon_auction_headers_all pah
     where pah.auction_header_id = p_auction_header_id
     and fsp.org_id = pah.org_id ;