APPS.OE_OE_FORM_HEADER SQL Statements

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

Line: 733

        x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 883

, x_last_update_date OUT NOCOPY DATE
, x_last_updated_by OUT NOCOPY NUMBER
, x_last_update_login OUT NOCOPY NUMBER
, x_order_number OUT NOCOPY NUMBER
, x_lock_control OUT NOCOPY NUMBER
, x_quote_number OUT NOCOPY NUMBER
,x_shipping_method_code OUT NOCOPY VARCHAR2 --4159701
, x_freight_carrier_code OUT NOCOPY VARCHAR2 --4159701
, x_shipping_method  OUT NOCOPY VARCHAR2--4159701
, x_freight_carrier OUT NOCOPY VARCHAR2 --4159701
, x_freight_terms_code OUT NOCOPY VARCHAR2 --4348011
, x_freight_terms      OUT NOCOPY VARCHAR2
, x_payment_term_id   OUT NOCOPY NUMBER
, x_payment_term      OUT NOCOPY VARCHAR2
)
IS
l_x_old_header_rec              OE_Order_PUB.Header_Rec_Type;

Line: 951

        l_x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 1003

    x_last_update_date             := l_x_header_rec.last_update_date;

Line: 1004

    x_last_updated_by              := l_x_header_rec.last_updated_by;

Line: 1005

    x_last_update_login            := l_x_header_rec.last_update_login;

Line: 1116

PROCEDURE Delete_Row
( x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
,   p_header_id                     IN  NUMBER
)
IS
l_x_old_header_rec                  OE_Order_PUB.Header_Rec_Type;

Line: 1128

    SAVEPOINT  Header_Delete;

Line: 1129

    oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DELETE_ROW', 1);

Line: 1161

    l_x_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 1199

    oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DELETE_ROW', 1);

Line: 1204

       ROLLBACK TO SAVEPOINT Header_Delete ;

Line: 1217

       ROLLBACK TO SAVEPOINT Header_Delete ;

Line: 1231

       ROLLBACK TO SAVEPOINT Header_Delete ;

Line: 1241

            ,   'Delete_Row'
            );

Line: 1252

END Delete_Row;

Line: 1710

       OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
					p_entity_code  => OE_GLOBALS.G_ENTITY_HEADER
					,p_entity_id    => p_header_id
				     ,x_return_status => l_return_status);

Line: 1754

Procedure Delete_All_Requests
( x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_return_status                     Varchar2(30);

Line: 1773

            ,   'Delete_All_Requests'
            );

Line: 1783

END Delete_All_Requests;

Line: 1796

   Select count(sales_credit_id)
   from oe_sales_credits sc,
        oe_sales_credit_types sct
   where header_id = p_header_id
   and   sct.sales_Credit_type_id = sc.sales_credit_type_id
   and   sct.quota_flag = 'Y'
   and   line_id is null;

Line: 1879

      SELECT id_flex_num
      FROM   fnd_id_flex_structures
      WHERE  id_flex_code = X_Id_Flex_Code;

Line: 1921

 SELECT meaning,lookup_type
 FROM   AR_LOOKUPS
 WHERE  (lookup_code=fob_point_code
 AND     lookup_type='FOB')
 OR     (lookup_code=tax_exempt_flag
 AND     lookup_type='TAX_CONTROL_FLAG')
 OR     (lookup_code=tax_exempt_reason_code
 AND     lookup_type='TAX_REASON')
 OR     (lookup_code=return_reason_code
 AND     lookup_type='CREDIT_MEMO_REASON')
 OR     (lookup_code=tax_point_code
 AND     lookup_type='TAX_POINT_TYPE');

Line: 1941

     SELECT meaning,lookup_type
     FROM FND_LOOKUP_VALUES LV
     WHERE LANGUAGE = userenv('LANG')
     and VIEW_APPLICATION_ID = 660
     and((lookup_code= shipment_priority_code
     and lookup_type='SHIPMENT_PRIORITY')
     or (lookup_code=freight_terms_code
     and lookup_type='FREIGHT_TERMS')
     or (lookup_code=payment_type_code
     and lookup_type='PAYMENT TYPE')
     or (lookup_code=flow_status_code
     and lookup_type='FLOW_STATUS')
     --or (lookup_code=credit_card_code  --R12 CC Encryption
     --and lookup_type='CREDIT_CARD')
     or (lookup_code=sales_channel_code
     and lookup_type='SALES_CHANNEL'))
     and security_group_id =fnd_global.Lookup_Security_Group(lv.lookup_type,lv.view_application_id);

Line: 1998

    SELECT Name
    INTO   x_header_val_rec.salesrep
    FROM   ra_salesreps
    WHERE  salesrep_id=p_header_rec_type.salesrep_id
    AND   org_id=p_header_rec_type.org_id;

Line: 2021

   Select phone_area_code,phone_number,phone_extension,phone_country_code
   Into x_header_val_rec.phone_area_code,x_header_val_rec.phone_number,
        x_header_val_rec.phone_extension,x_header_val_rec.phone_country_code
   From hz_contact_points
   Where contact_point_id=p_header_rec_type.sold_to_phone_id;

Line: 2098

    Select meaning
    INTO x_header_val_rec.shipping_method
    FROM   oe_ship_methods_v
    WHERE  lookup_code =p_header_rec_type.shipping_method_code ;

Line: 2114

         Select description
         INTO x_header_val_rec.freight_carrier
         FROM   org_freight
         WHERE  freight_code=p_header_rec_type.freight_carrier_code
         and organization_id = p_header_rec_type.ship_from_org_id;

Line: 2132

	   SELECT 'Y'
	   INTO x_header_val_rec.hold_exists_flag
	   FROM OE_ORDER_HOLDS
	   WHERE HEADER_ID = p_header_rec_type.header_id
	   AND   RELEASED_FLAG = 'N';

Line: 2154

             SELECT 'Y'
             INTO   x_header_val_rec.Messages_exists_flag
             FROM   OE_PROCESSING_MSGS
             WHERE  header_id = p_header_rec_type.header_id
             AND NVL(message_status_code, '0') <> 'CLOSED'  --datafix_begin_end
             AND    rownum < 2;

Line: 2170

      select meaning
      into x_header_val_rec.order_date_type
      from oe_lookups
      where lookup_type = 'REQUEST_DATE_TYPE'
      AND lookup_code=p_header_rec_type.order_date_type_code;

Line: 2189

      select meaning
      into x_header_val_rec.demand_class
      from oe_fnd_common_lookups_v
      where lookup_type = 'DEMAND_CLASS'
      AND lookup_code=p_header_rec_type.demand_class_code;

Line: 2332

        SELECT   /* MOAC_SQL_CHANGE */   cas.cust_account_id,
                party.party_name,
                cust.account_number,
                site.location,
                addr.address1,
                addr.address2,
                addr.address3,
                addr.address4,
                DECODE(addr.city, NULL, NULL,addr.city || ', ') ||
                DECODE(addr.state, NULL, addr.province || ', ', addr.state || ', ') || -- 3603600
	        DECODE(addr.postal_code, NULL, NULL,addr.postal_code || ', ') ||
	        DECODE(addr.country, NULL, NULL,addr.country)
        INTO    x_header_val_rec.deliver_to_customer_id,
                x_header_val_rec.deliver_to_customer_name,
                x_header_val_rec.deliver_to_customer_number,
                x_header_val_rec.deliver_to,
	        x_header_val_rec.deliver_to_address1,
	        x_header_val_rec.deliver_to_address2,
	        x_header_val_rec.deliver_to_address3,
	        x_header_val_rec.deliver_to_address4,
	        x_header_val_rec.deliver_to_address5

        FROM    HZ_CUST_SITE_USES_ALL site,
                HZ_CUST_ACCT_SITES_ALL cas,
                hz_cust_accounts cust,
                hz_parties party,
                hz_party_sites ps,
                hz_locations addr
        WHERE   site.cust_acct_site_id = cas.cust_acct_site_id
        AND     site.site_use_code='DELIVER_TO'
        AND     site.site_use_id=p_header_rec_type.deliver_to_org_id
        AND     cust.cust_account_id = cas.cust_account_id
        AND     party.party_id = cust.party_id
        AND     cas.party_site_id = ps.party_site_id
        AND     ps.location_id = addr.location_id;

Line: 2383

      select name
      into x_header_val_rec.deliver_to_contact
      from oe_contacts_v
      where contact_id=p_header_rec_type.deliver_to_contact_id;

Line: 2404

      select name||' : '||revision
      into x_header_val_rec.agreement
      from oe_agreements
      where agreement_id=p_header_rec_type.agreement_id;

Line: 2423

      select name
      into x_header_val_rec.order_source
      from oe_order_sources
      where order_source_id=p_header_rec_type.order_source_id;

Line: 2443

      select name
      into x_header_val_rec.source_document_type
      from oe_order_sources
      where order_source_id=p_header_rec_type.source_document_type_id;

Line: 2462

      select user_conversion_type
      into x_header_val_rec.conversion_type
      from gl_daily_conversion_types
      where conversion_type=p_header_rec_type.conversion_type_code;

Line: 2481

    select meaning into x_header_val_rec.ib_owner_dsp
     from oe_lookups
     where lookup_type='ITEM_OWNER' and lookup_code=p_header_rec_type.ib_owner;

Line: 2496

    select meaning into x_header_val_rec.ib_installed_at_location_dsp
     from oe_lookups
     where lookup_type='ITEM_INSTALL_LOCATION' and lookup_code=p_header_rec_type.ib_installed_at_location;

Line: 2511

    select meaning into x_header_val_rec.ib_current_location_dsp
     from oe_lookups
     where lookup_type='ITEM_CURRENT_LOCATION' and lookup_code=p_header_rec_type.ib_current_location;

Line: 2560

             SELECT NVL(SUM(NVL(commitment_applied_amount, 0)), 0)
             INTO l_commitment_amount
             FROM oe_payments
             WHERE header_id = p_header_rec_type.header_id;

Line: 2613

		SELECT
		CREDIT_CARD_CODE
	       ,CREDIT_CARD_HOLDER_NAME
	       ,CREDIT_CARD_NUMBER
	       ,CREDIT_CARD_EXPIRATION_DATE
	       ,CREDIT_CARD_APPROVAL_CODE
	       ,CREDIT_CARD_APPROVAL_DATE
		into
		l_credit_card_code,
		l_credit_card_holder_name,
		l_credit_card_number,
		l_credit_card_expiration_date,
		l_credit_card_approval_code ,
		l_credit_card_approval_date
		FROM OE_ORDER_HEADERS_ALL
		WHERE HEADER_ID = p_header_rec_type.header_id;

Line: 2640

          SELECT trxn_extension_id
          INTO   l_trxn_extension_id
          FROM   oe_payments
          WHERE  header_id = p_header_rec_type.header_id
          AND    nvl(payment_collection_event,'PREPAY') = 'INVOICE'
          AND    payment_type_code = 'CREDIT_CARD'
          AND    line_id is null;

Line: 2732

         SELECT  SET_OF_BOOKS_ID
         ,         CURRENCY_CODE
         INTO    g_set_of_books_rec.set_of_books_id
         ,         g_set_of_books_rec.currency_code
         FROM    OE_GL_SETS_OF_BOOKS_V
         WHERE   SET_OF_BOOKS_ID = l_set_of_books_id;

Line: 2772

	   SELECT  /* MOAC_SQL_CHANGE */   cas.cust_account_id
        INTO    x_invoice_to_customer_id
        FROM    HZ_CUST_SITE_USES_ALL site,
                HZ_CUST_ACCT_SITES_ALL cas
        WHERE   site.cust_acct_site_id = cas.cust_acct_site_id
        AND     site.site_use_code=l_site_use_code
        AND     site.site_use_id=p_site_use_id;

Line: 2800

	   SELECT  /* MOAC_SQL_CHANGE */   cas.cust_account_id
        INTO    x_ship_to_customer_id
        FROM    HZ_CUST_SITE_USES_ALL site,
                HZ_CUST_ACCT_SITES_ALL cas
        WHERE   site.cust_acct_site_id = cas.cust_acct_site_id
        AND     site.site_use_code=l_site_use_code
        AND     site.site_use_id=p_site_use_id;

Line: 2844

   SELECT  nvl(gsa_indicator_flag,'N')
     INTO  x_gsa_indicator
     FROM  hz_parties party,
           hz_cust_accounts acct
    WHERE  acct.cust_account_id=p_sold_to_org_id
      AND  party.party_id = acct.party_id;

Line: 3258

        l_x_line_tbl(i).operation:= OE_GLOBALS.G_OPR_UPDATE;

Line: 3393

		select  /* MOAC_SQL_CHANGE */ cust.cust_account_id,
		       party.party_name,
		       cust.account_number
        	INTO   x_customer_id,
               	       x_customer_name,
                       x_customer_number
		from
		       hz_cust_site_uses_all site,
		       hz_cust_acct_sites_all cas,
                       hz_cust_accounts cust,
                       hz_parties party
                where site.site_use_code = p_site_use_code
		and site_use_id = p_site_use_id
		and site.cust_acct_site_id = cas.cust_acct_site_id
		and cas.cust_account_id = cust.cust_account_id
		and cust.party_id=party.party_id;

Line: 3469

p_agreement_rec.last_update_date := sysdate;

Line: 3470

p_agreement_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 4022

      select phone_format_style,area_code_size
      from hz_phone_formats
      where territory_code=l_territory_code;

Line: 4040

    SELECT COUNT(bug_id)
    INTO   l_bug_count
    FROM ad_bugs where bug_number IN ('2116159','2239222','2488745');

Line: 4057

   select customer_id into l_customer_id
   from fnd_user
   where user_id = l_user_id;

Line: 4062

    select 1 into l_dummy
    from hz_parties
    where party_id = l_customer_id;

Line: 4082

        select default_country into l_user_territory_code
        from ar_system_parameters;

Line: 4100

      select Count(territory_code)
      into l_count
      from hz_phone_formats
      where territory_code=l_user_territory_code
      and area_code_size=length(p_area_code);

Line: 4107

       select Count(territory_code)
       into l_count
       from hz_phone_formats
       where territory_code=l_user_territory_code
       and area_code_size=0;

Line: 4113

       select Count(territory_code)
       into l_total_count
       from hz_phone_formats
       where territory_code=l_user_territory_code;

Line: 4120

        l_sql_stmt := 'SELECT Count(territory_code)'||
                      ' FROM hz_phone_country_codes'||
                      ' where territory_code=:1 and'||
                      ' NVL(area_code_length,length(:2))=length(:3)';

Line: 4153

        l_sql_stmt:='SELECT area_code_length'||
                  ' FROM hz_phone_country_codes'||
                  ' WHERE territory_code=:l_territory_code';

Line: 4189

        l_sql_stmt:='SELECT phone_length-NVL(AREA_CODE_LENGTH,0)'||
                    ' FROM hz_phone_country_codes'||
                    ' where territory_code=:l_user_territory_code';

Line: 4235

        l_sql_stmt:='SELECT phone_length - NVL(area_code_length,0)'||
                  ' FROM hz_phone_country_codes'||
                  ' WHERE territory_code=:l_territory_code';

Line: 4328

     ELSIF l_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE then
       l_operation := OE_PC_GLOBALS.UPDATE_OP;

Line: 4366

     FUNCTION Get_Opr_Update
----------------------------------------------------------
     RETURN varchar2
     IS
     BEGIN
         RETURN OE_GLOBALS.G_OPR_UPDATE;

Line: 4406

   Select enabled_flag from oe_lookups where lookup_type=p_lookup_type1 and lookup_code=p_lookup_code1;