APPS.OE_OE_HTML_HEADER SQL Statements

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

Line: 274

        x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 440

        x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 493

        x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 615

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: 627

    SAVEPOINT  Header_Delete;

Line: 628

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

Line: 654

    l_x_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 690

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

Line: 695

       ROLLBACK TO SAVEPOINT Header_Delete ;

Line: 708

       ROLLBACK TO SAVEPOINT Header_Delete ;

Line: 722

       ROLLBACK TO SAVEPOINT Header_Delete ;

Line: 732

            ,   'Delete_Row'
            );

Line: 743

END Delete_Row;

Line: 1032

       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: 1067

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: 1086

            ,   'Delete_All_Requests'
            );

Line: 1096

END Delete_All_Requests;

Line: 1114

		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: 1174

      select meaning
      into x_header_val_rec.status
      from oe_lookups
      where lookup_type = 'FLOW_STATUS'
      AND lookup_code = p_header_rec.flow_status_code;

Line: 1192

    SELECT Name
    INTO   x_header_val_rec.salesrep
    FROM   ra_salesreps
    WHERE  salesrep_id=p_header_rec.salesrep_id;