APPS.PON_COPY_UDAS_GRP SQL Statements

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

Line: 179

       select lookup_code from po_lookup_codes where lookup_type = 'SOL_AMD_UDA_ADDRESS_TYPES'
       MINUS
       select lookup_code from po_lookup_codes where lookup_type = 'SOL_UDA_ADDRESS_TYPES';

Line: 185

       SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
	  (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
	   WHERE template_id = p_template_id and  ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING');

Line: 191

     select uda_template_id into l_template_id from pon_auction_headers_all where
       auction_header_id = p_source_auction_header_id;

Line: 229

      select nvl(amendment_flag,'N') into l_amd_flag from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;

Line: 232

	 select auction_header_id_prev_amend into l_prev_hdr_id1 from pon_auction_headers_all where auction_header_id = p_source_auction_header_id;

Line: 233

	 select auction_header_id_prev_amend into l_prev_hdr_id2 from pon_auction_headers_all where auction_header_id = p_target_auction_header_id;

Line: 345

     select uda_template_id into l_template_id from pon_auction_item_prices_all where
       auction_header_id = p_source_auction_header_id and line_number = p_source_line_number;

Line: 369

SELECT eagv.ATTR_GROUP_NAME
    INTO l_complex_attr_grp
    FROM
    po_uda_ag_templates  puat
    ,po_uda_ag_template_usages puatu
    ,pon_bid_item_prices pbip
    ,ego_attr_groups_v eagv

    WHERE puat.template_id = p_bid_template_id
    AND puatu.template_id = puat.template_id
    AND pbip.bid_number = p_bid_number
    AND pbip.line_number = p_line_number
    AND puatu.ATTRIBUTE1= pbip.CLM_IDC_TYPE
    AND puatu.ATTRIBUTE2= pbip.CLM_CONTRACT_TYPE
    AND eagv.ATTR_GROUP_ID =  puatu.ATTRIBUTE_GROUP_ID
    AND eagv.ATTR_GROUP_TYPE = puat.ENTITY_CODE;

Line: 413

    /*insert into vhk_debug_msg values('line_number :'||p_line_number
				||'  uda_template_id : '||p_auction_template_id
				||'  bid_uda_template_id : '||p_bid_template_id
				||'  copyfrom : '||p_copyfrom);*/

Line: 426

	    /*insert into vhk_debug_msg values('line_number : '||p_line_number
					      ||' g_auc_header_pkey_col  : '||g_auc_header_pkey_col);*/

Line: 460

     /*insert into vhk_debug_msg values('Calling Copy UDA : '||'  l_source_template_id :'||l_source_template_id
					||' p_bid_template_id : '||p_bid_template_id);*/

Line: 515

select al.auction_header_id, al.line_number,al.uda_template_id,
bl.bid_number,bl.line_number bid_line_number,bl.auction_header_id bid_auc_head_id,
decode(al.modified_date-old_al.modified_date,0,'B','A') copyfrom
FROM pon_auction_item_prices_all al,
pon_auction_item_prices_all old_al,
pon_bid_item_prices bl
WHERE al.auction_header_id = p_auction_header_id
AND bl.bid_number(+) = p_source_bid_number
AND bl.line_number(+) = al.line_number
AND old_al.auction_header_id(+)  = bl.auction_header_id
AND old_al.line_number (+) = bl.line_number
AND al.line_number BETWEEN p_batch_start AND p_batch_end;

Line: 529

	/*insert into vhk_debug_msg values('p_auction_header_id : '||p_auction_header_id
					 ||'  p_bid_number : '||p_bid_number
					 ||'  p_source_bid_num : '||p_source_bid_num
					 ||'  p_batch_start : '||p_batch_start
					 ||'  p_batch_end : '||p_batch_end);*/

Line: 537

		/*insert into vhk_debug_msg values('Calling COPY_BID_LINE_UDA');*/

Line: 549

		/*insert into vhk_debug_msg values('line_number :'||line.line_number
						 ||'  uda_template_id : '||line.uda_template_id
						 ||'  bid_uda_template_id : '||p_bid_template_id
						 ||'  copyfrom : '||line.copyfrom
						 ||'  x_return_status : '||x_return_status);*/

Line: 654

     SELECT DISTINCT ag.attr_group_name
      BULK COLLECT INTO  x_attr_group_tbl
     FROM   po_uda_ag_template_usages tu, ego_attr_groups_v ag
     WHERE  tu.template_id =  p_uda_template_id
      AND   ag.attr_group_id = tu.attribute_group_id
      AND   tu.attribute_category NOT IN ('PRICING','DOCUMENT_NUMBERING','ADDRESS'); --12611018 Document numbering added

Line: 692

     select nvl(clm_cost_constraint,'X')
     into l_cost_constraint
     from pon_auction_item_prices_all
     where auction_header_id=p_auction_header_id
     and line_number=p_auction_line_number;

Line: 721

     /* CLM QA Bug : 9835426 : When copying from req lines, need to delete complex
      * pricing uda's for NSP/NC lines.
     */
     if (x_return_status = 'S') then

         select nvl(clm_cost_constraint,'X'),clm_idc_type,clm_contract_type
         into l_cost_constraint,l_idc_type,l_contract_type
         from pon_auction_item_prices_all
         where auction_header_id=p_auction_header_id
         and line_number=p_auction_line_number;

Line: 733

            delete pon_auction_item_prices_ext_b
            where auction_header_id = p_auction_header_id
            and line_number=p_auction_line_number
            and attr_group_id in
            (select attribute_group_id from po_uda_ag_template_usages
             where template_id=p_dest_template_id
             and nvl(attribute1,'X')=nvl(l_idc_type,'X')
             and nvl(attribute2,'X')=nvl(l_contract_type,'X'));

Line: 765

    select distinct(ATTR_GROUP_NAME) ATTR_GROUP_NAME
    FROM ego_attr_groups_v ag_v, po_uda_ag_template_usages ag, pon_bid_item_prices bid_lines
    where bid_lines.bid_number = p_bid_number
    and bid_lines.line_number = p_bid_line_number
    and bid_lines.uda_template_id = ag.template_id
    and Nvl(ag.attribute1,'A') = Decode(ag.attribute1,NULL,'A',bid_lines.clm_idc_type)
    and Nvl(ag.attribute2,'A') = Decode(ag.attribute2,NULL,'A',bid_lines.clm_contract_type)
    and ag.attribute_group_id = ag_v.attr_group_id;

Line: 776

        select uda_template_id,contract_type,clm_idc_type
        into l_src_template_id,l_clm_contract_type,l_clm_idc_type
        from
        po_lines_all
        where
        po_line_id = p_po_line_id;

Line: 791

        select uda_template_id into l_dest_template_id
        from
        pon_bid_item_prices
        where
        bid_number = p_bid_header_id
        and line_number = p_bid_line_number;

Line: 842

        update pon_bid_item_prices
        set clm_contract_type = l_clm_contract_type,clm_idc_type =l_clm_idc_type
        where
        bid_number = p_bid_header_id and
        line_number = p_bid_line_number;

Line: 869

      open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE (attr_group_id IN
	 (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
	  WHERE template_id = p_tar_template_id and  ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING' and ATTRIBUTE_CATEGORY <> 'ADDRESS')
          AND ATTR_GROUP_NAME <> 'AQ_PLAN1');

Line: 874

      open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
	 (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
	  WHERE template_id = p_tar_template_id  and attribute_category <> 'FED_FIELDS');

Line: 878

      open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
	 (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
	  WHERE template_id = p_tar_template_id and attribute_category = 'FED_FIELDS');

Line: 884

      open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
	 (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
	  WHERE template_id = p_tar_template_id and  ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING' and ATTRIBUTE_CATEGORY <> 'ADDRESS');

Line: 888

      open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
	 (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
	  WHERE template_id = p_src_template_id);

Line: 1086

        SELECT  END_USER_COLUMN_NAME
        FROM    FND_DESCR_FLEX_COLUMN_USAGES
        WHERE   DESCRIPTIVE_FLEXFIELD_NAME = p_ag_type
        AND     DESCRIPTIVE_FLEX_CONTEXT_CODE = 'addresses';

Line: 1106

	 select attribute_group_id into l_attr_grp_id from po_uda_ag_template_usages where template_id = p_src_template_id
	    and attribute_category = 'ADDRESS';

Line: 1110

	 select attribute_group_id into l_tar_attr_grp_id from po_uda_ag_template_usages where template_id = p_tar_template_id
	    and attribute_category = 'ADDRESS';

Line: 1124

	    SELECT data_level_name into l_src_data_level FROM  ego_data_level_b
	        WHERE attr_group_type = l_src_attr_grp_type
	       AND data_level_name NOT LIKE '%ARCHIVE%';

Line: 1129

	    SELECT data_level_name into l_tar_data_level FROM  ego_data_level_b
	        WHERE attr_group_type = l_tar_attr_grp_type
	       AND data_level_name NOT LIKE '%ARCHIVE%';

Line: 1167

	     open addrExtnCur for select extension_id from po_req_headers_ext_b where
	     requisition_header_id = p_src_pkey(1) and attr_group_id =  l_attr_grp_id order by extension_id;

Line: 1170

	     open addrExtnCur for select extension_id from pon_auction_headers_ext_b where
	     auction_header_id = p_src_pkey(1) and attr_group_id =  l_attr_grp_id order by extension_id;

Line: 1196

		 SELECT  Value(a)
		 BULK COLLECT INTO l_process_attr_row_tbl
		 FROM TABLE(x_attributes_row_table)  a
		 WHERE  a.row_identifier = l_extn_id_list(i);

Line: 1201

		 SELECT Value(b)
		 BULK COLLECT INTO l_process_attr_data_tbl
		 FROM TABLE(x_attributes_data_table)  b
		 WHERE  b.ROW_IDENTIFIER = l_extn_id_list(i);

Line: 1206

		 SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
		 INTO l_new_extension_id
		 FROM dual;

Line: 1249

	 --delete irrelevant addresses
         if ( p_excl_addr_types.count > 0 ) Then
	    for  i in p_excl_addr_types.FIRST..p_excl_addr_types.LAST
	    loop
	       delete from pon_auction_headers_ext_b
	       where auction_header_id = p_tar_pkey(1)
	       and c_ext_attr39 = p_excl_addr_types(i);