DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER_ADJ SQL Statements

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

Line: 103

, x_updated_flag OUT NOCOPY VARCHAR2

, x_update_allowed OUT NOCOPY VARCHAR2

, x_applied_flag OUT NOCOPY VARCHAR2

, x_change_reason_code OUT NOCOPY VARCHAR2

, x_change_reason_text OUT NOCOPY VARCHAR2

, x_modified_from OUT NOCOPY VARCHAR2

, x_modified_to OUT NOCOPY VARCHAR2

, x_operand OUT NOCOPY NUMBER

, x_arithmetic_operator OUT NOCOPY varchar2

, x_adjusted_amount OUT NOCOPY NUMBER

, x_pricing_phase_id OUT NOCOPY NUMBER

, x_list_line_no OUT NOCOPY varchar2

, x_source_system_code OUT NOCOPY varchar2

, x_benefit_qty OUT NOCOPY NUMBER

, x_benefit_uom_code OUT NOCOPY varchar2

, x_print_on_invoice_flag OUT NOCOPY varchar2

, x_expiration_date OUT NOCOPY DATE

, x_rebate_transaction_type_code OUT NOCOPY varchar2

, x_rebate_transaction_reference OUT NOCOPY varchar2

, x_rebate_payment_system_code OUT NOCOPY varchar2

, x_redeemed_date OUT NOCOPY DATE

, x_redeemed_flag OUT NOCOPY varchar2

, x_accrual_flag OUT NOCOPY varchar2

, x_invoiced_flag OUT NOCOPY varchar2

, x_estimated_flag OUT NOCOPY varchar2

, x_credit_or_charge_flag OUT NOCOPY varchar2

, x_include_on_returns_flag OUT NOCOPY varchar2

, x_charge_type_code OUT NOCOPY varchar2

, x_charge_subtype_code OUT NOCOPY varchar2

, x_ac_context OUT NOCOPY VARCHAR2

, x_ac_attribute1 OUT NOCOPY VARCHAR2

, x_ac_attribute2 OUT NOCOPY VARCHAR2

, x_ac_attribute3 OUT NOCOPY VARCHAR2

, x_ac_attribute4 OUT NOCOPY VARCHAR2

, x_ac_attribute5 OUT NOCOPY VARCHAR2

, x_ac_attribute6 OUT NOCOPY VARCHAR2

, x_ac_attribute7 OUT NOCOPY VARCHAR2

, x_ac_attribute8 OUT NOCOPY VARCHAR2

, x_ac_attribute9 OUT NOCOPY VARCHAR2

, x_ac_attribute10 OUT NOCOPY VARCHAR2

, x_ac_attribute11 OUT NOCOPY VARCHAR2

, x_ac_attribute12 OUT NOCOPY VARCHAR2

, x_ac_attribute13 OUT NOCOPY VARCHAR2

, x_ac_attribute14 OUT NOCOPY VARCHAR2

, x_ac_attribute15 OUT NOCOPY VARCHAR2

--uom begin
, x_operand_per_pqty OUT NOCOPY NUMBER

, x_adjusted_amount_per_pqty OUT NOCOPY NUMBER

--uom end
)
IS
l_Header_Adj_rec              OE_Order_PUB.Header_Adj_Rec_Type;
Line: 305

   l_Header_Adj_rec.updated_flag	:=NULL;
Line: 306

   l_Header_Adj_rec.update_allowed	:=NULL;
Line: 426

    x_updated_flag		     := l_x_Header_Adj_rec.updated_flag;
Line: 427

    x_update_allowed	     := l_x_Header_Adj_rec.update_allowed;
Line: 678

, x_updated_flag OUT NOCOPY VARCHAR2

, x_update_allowed OUT NOCOPY VARCHAR2

, x_applied_flag OUT NOCOPY VARCHAR2

, x_change_reason_code OUT NOCOPY VARCHAR2

, x_change_reason_text OUT NOCOPY VARCHAR2

, x_modified_from OUT NOCOPY VARCHAR2

, x_modified_to OUT NOCOPY VARCHAR2

, x_operand OUT NOCOPY NUMBER

, x_arithmetic_operator OUT NOCOPY varchar2


, x_adjusted_amount OUT NOCOPY NUMBER

, x_pricing_phase_id OUT NOCOPY NUMBER

, x_list_line_no OUT NOCOPY varchar2

, x_source_system_code OUT NOCOPY varchar2

, x_benefit_qty OUT NOCOPY NUMBER

, x_benefit_uom_code OUT NOCOPY varchar2

, x_print_on_invoice_flag OUT NOCOPY varchar2

, x_expiration_date OUT NOCOPY DATE

, x_rebate_transaction_type_code OUT NOCOPY varchar2

, x_rebate_transaction_reference OUT NOCOPY varchar2

, x_rebate_payment_system_code OUT NOCOPY varchar2

, x_redeemed_date OUT NOCOPY DATE

, x_redeemed_flag OUT NOCOPY varchar2

, x_accrual_flag OUT NOCOPY varchar2

, x_invoiced_flag OUT NOCOPY varchar2

, x_estimated_flag OUT NOCOPY varchar2

, x_credit_or_charge_flag OUT NOCOPY varchar2

, x_include_on_returns_flag OUT NOCOPY varchar2

, x_charge_type_code OUT NOCOPY varchar2

, x_charge_subtype_code OUT NOCOPY varchar2

--uom begin
, x_operand_per_pqty OUT NOCOPY number

, x_adjusted_amount_per_pqty OUT NOCOPY number

--uom end
)
IS
l_request_rec		      OE_Order_Pub.Request_Rec_Type;
Line: 863

    ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATE_ALLOWED  then
		l_x_Header_Adj_rec.update_allowed := p_attr_value1 ;
Line: 865

    ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATED_FLAG  then
		l_x_Header_Adj_rec.updated_flag := p_attr_value1 ;
Line: 945

         l_x_Header_Adj_rec.update_allowed:= p_attr_value1;
Line: 1036

        l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
Line: 1087

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 1098

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 1164

	x_update_allowed	:= FND_API.G_MISS_CHAR;
Line: 1165

	x_updated_flag	:= FND_API.G_MISS_CHAR;
Line: 1234

    IF NOT OE_GLOBALS.Equal(l_x_Header_Adj_rec.update_allowed,

                            l_Header_Adj_rec.update_allowed)
    THEN
        x_update_allowed := l_x_Header_Adj_rec.update_allowed;
Line: 1241

    IF NOT OE_GLOBALS.Equal(l_x_Header_Adj_rec.updated_flag,

                            l_Header_Adj_rec.updated_flag)
    THEN
        x_updated_flag := l_x_Header_Adj_rec.updated_flag;
Line: 1769

, x_last_update_date OUT NOCOPY DATE

, x_last_updated_by OUT NOCOPY NUMBER

, x_last_update_login OUT NOCOPY NUMBER

,   p_ok_flag			    		 IN  VARCHAR2
, x_program_id OUT NOCOPY NUMBER

, x_program_application_id OUT NOCOPY NUMBER

, x_program_update_date OUT NOCOPY DATE

, x_request_id OUT NOCOPY NUMBER

, x_lock_control OUT NOCOPY NUMBER

)
IS
l_request_rec		      OE_order_pub.Request_Rec_Type;
Line: 1878

          l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
Line: 1969

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 1982

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 1996

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 2009

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 2022

    x_last_update_date             := l_x_Header_Adj_rec.last_update_date;
Line: 2023

    x_last_updated_by              := l_x_Header_Adj_rec.last_updated_by;
Line: 2024

    x_last_update_login            := l_x_Header_Adj_rec.last_update_login;
Line: 2027

    x_program_update_date      	:= l_x_Line_Adj_rec.program_update_date;
Line: 2113

PROCEDURE Delete_Row
( x_return_status OUT NOCOPY VARCHAR2

, x_msg_count OUT NOCOPY NUMBER

, x_msg_data OUT NOCOPY VARCHAR2

,   p_price_adjustment_id           IN  NUMBER
, p_change_reason_code            IN  VARCHAR2 Default Null
, p_change_comments               IN  VARCHAR2 Default Null
)
IS
l_Header_Adj_rec              OE_Order_PUB.Header_Adj_Rec_Type;
Line: 2163

        oe_debug_pub.add(  'ENTERING OE_OE_FORM_HEADER_ADJ.DELETE_ROW' , 1 ) ;
Line: 2195

    l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
Line: 2272

        oe_debug_pub.add(  'EXITING OE_OE_FORM_HEADER_ADJ.DELETE_ROW' , 1 ) ;
Line: 2311

            ,   'Delete_Row'
            );
Line: 2321

END Delete_Row;
Line: 2379

		,p_delete        => FND_API.G_TRUE
		,x_return_status => l_return_status
		);
Line: 2391

		,p_delete        => FND_API.G_TRUE
		,x_return_status => l_return_status
		);
Line: 2403

		,p_delete        => FND_API.G_TRUE
		,x_return_status => l_return_status
		);