The following lines contain the word 'select', 'insert', 'update' or 'delete':
, 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;
l_Header_Adj_rec.updated_flag :=NULL;
l_Header_Adj_rec.update_allowed :=NULL;
x_updated_flag := l_x_Header_Adj_rec.updated_flag;
x_update_allowed := l_x_Header_Adj_rec.update_allowed;
, 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;
ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATE_ALLOWED then
l_x_Header_Adj_rec.update_allowed := p_attr_value1 ;
ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATED_FLAG then
l_x_Header_Adj_rec.updated_flag := p_attr_value1 ;
l_x_Header_Adj_rec.update_allowed:= p_attr_value1;
l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
x_update_allowed := FND_API.G_MISS_CHAR;
x_updated_flag := FND_API.G_MISS_CHAR;
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;
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;
, 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;
l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
x_last_update_date := l_x_Header_Adj_rec.last_update_date;
x_last_updated_by := l_x_Header_Adj_rec.last_updated_by;
x_last_update_login := l_x_Header_Adj_rec.last_update_login;
x_program_update_date := l_x_Line_Adj_rec.program_update_date;
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;
oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_ADJ.DELETE_ROW' , 1 ) ;
l_x_Header_Adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_ADJ.DELETE_ROW' , 1 ) ;
, 'Delete_Row'
);
END Delete_Row;
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);
,p_delete => FND_API.G_TRUE
,x_return_status => l_return_status
);