APPS.OE_UPG_INSTALL_DETAILS SQL Statements

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

Line: 4

Procedure Upgrade_Insert_Errors
   (
      L_header_id             IN  Varchar2,
      L_comments              IN  varchar2
   )
   is

--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 15

       insert into oe_upgrade_errors
       (
           header_id,
           comments,
           creation_date
       )
       values
       (
           l_header_id,
           substr(l_comments,1,240),
           sysdate
       );

Line: 28

End Upgrade_Insert_Errors;

Line: 49

      'SELECT sld.line_service_detail_id, sld.line_id' ||
      ' FROM so_line_service_details sld,' ||
      '      oe_order_lines_all ol' ||
      ' WHERE ol.line_id = sld.line_id' ||
      ' AND NOT exists' ||
      ' (SELECT 1' ||
      '  FROM cs_line_inst_details csd' ||
      '  WHERE csd.line_inst_detail_id = sld.line_service_detail_id)';

Line: 91

	 SELECT  start_header_id, end_header_id
	   INTO  l_start_id, l_end_id
	   FROM  oe_upgrade_distribution
	   WHERE slab = p_slab
	   AND   line_type = 'I';

Line: 100

	    oe_upg_install_details.upgrade_insert_errors
	      (
	       l_header_id => 0,
	       l_comments => 'FYI Only: Parallel process of '
	       || 'Installation Details. Marking not used for slab: '
	       || To_char(p_slab)
	       );

Line: 202

	   select header_id into l_header_id
	     from so_lines_all where line_id = l_parent_line_id;

Line: 213

              oe_upg_install_details.upgrade_insert_errors
		(
		 L_header_id => l_header_id,
		 L_comments =>
		 'Upgrade of Installation details failed for detail:'
		 || to_char(l_install_detail_line_id)||' with error: '
                 || 'Line ID: ' || l_parent_line_id || ' does not exist'
		 );

Line: 226

	   oe_upg_install_details.upgrade_insert_errors
	     (
	      L_header_id => l_header_id,
	      L_comments =>
	      'Upgrade of Installation details failed for detail :'
	      ||to_char(l_install_detail_line_id)||' with error: '
	      || l_msg_data
	      );

Line: 273

   SELECT
	lsd.line_service_detail_id,
	lsd.line_id,
	lsd.source_line_service_detail_id,
	lsd.transaction_type_id,
	lsd.system_id,
	--lsd.system_type_code,
	lsd.customer_product_id,
	lsd.customer_product_type_code,
	lsd.customer_product_quantity,
	lsd.installation_site_use_id,
	lsd.installed_cp_return_by_date,
	lsd.new_cp_return_by_date,
	--lsd.technical_contact_id,
	--lsd.service_admin_contact_id,
	lsd.context,
	lsd.attribute1,
	lsd.attribute2,
	lsd.attribute3,
	lsd.attribute4,
	lsd.attribute5,
	lsd.attribute6,
	lsd.attribute7,
	lsd.attribute8,
	lsd.attribute9,
	lsd.attribute10,
	lsd.attribute11,
	lsd.attribute12,
	lsd.attribute13,
	lsd.attribute14,
	lsd.attribute15,
        cas.party_site_id
     INTO
	l_line_inst_dtl_rec.line_inst_detail_id,
	l_line_inst_dtl_rec.order_line_id,
	l_line_inst_dtl_rec.source_line_inst_detail_id,
	l_line_inst_dtl_rec.transaction_type_id,
	l_line_inst_dtl_rec.system_id,
	--l_line_inst_dtl_rec.system_type_code,
	l_line_inst_dtl_rec.customer_product_id,
	l_line_inst_dtl_rec.type_code,
	l_line_inst_dtl_rec.quantity,
	l_line_inst_dtl_rec.installed_at_party_site_id,
	l_line_inst_dtl_rec.installed_cp_return_by_date,
	l_line_inst_dtl_rec.new_cp_return_by_date,
	l_line_inst_dtl_desc_flex.context,
	l_line_inst_dtl_desc_flex.attribute1,
	l_line_inst_dtl_desc_flex.attribute2,
	l_line_inst_dtl_desc_flex.attribute3,
	l_line_inst_dtl_desc_flex.attribute4,
	l_line_inst_dtl_desc_flex.attribute5,
	l_line_inst_dtl_desc_flex.attribute6,
	l_line_inst_dtl_desc_flex.attribute7,
	l_line_inst_dtl_desc_flex.attribute8,
	l_line_inst_dtl_desc_flex.attribute9,
	l_line_inst_dtl_desc_flex.attribute10,
	l_line_inst_dtl_desc_flex.attribute11,
	l_line_inst_dtl_desc_flex.attribute12,
	l_line_inst_dtl_desc_flex.attribute13,
	l_line_inst_dtl_desc_flex.attribute14,
	l_line_inst_dtl_desc_flex.attribute15,
        l_party_site_id
	FROM
           HZ_CUST_ACCT_SITES_ALL CAS,
           HZ_CUST_SITE_USES_ALL CSU,
	   SO_LINE_SERVICE_DETAILS LSD
     WHERE
           csu.cust_acct_site_id = cas.cust_acct_site_id (+)
     AND   lsd.installation_site_use_id = csu.site_use_id (+)
     AND   lsd.line_service_detail_id = p_line_inst_details_id;