APPS.OE_OE_FORM_LINE_SCREDIT SQL Statements

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

Line: 75

, x_dw_update_advice_flag OUT NOCOPY VARCHAR2

, x_header_id OUT NOCOPY NUMBER

, x_line_id OUT NOCOPY NUMBER

, x_percent OUT NOCOPY NUMBER

, x_salesrep_id OUT NOCOPY NUMBER

, x_sales_credit_type_id OUT NOCOPY NUMBER

, x_sales_credit_id OUT NOCOPY NUMBER

, x_wh_update_date OUT NOCOPY DATE

, x_salesrep OUT NOCOPY VARCHAR2

, x_sales_credit_type OUT NOCOPY VARCHAR2
--SG {
,   x_sales_group_id                OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_sales_group_updated_flag           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
--SG}
)
IS
l_Line_Scredit_val_rec        OE_Order_PUB.Line_Scredit_Val_Rec_Type;

Line: 211

    x_dw_update_advice_flag        := l_x_Line_Scredit_rec.dw_update_advice_flag;

Line: 218

    x_wh_update_date               := l_x_Line_Scredit_rec.wh_update_date;

Line: 336

,   p_sales_group_updated_flag           IN  VARCHAR2
--SG}
, x_attribute1 OUT NOCOPY VARCHAR2

, x_attribute10 OUT NOCOPY VARCHAR2

, x_attribute11 OUT NOCOPY VARCHAR2

, x_attribute12 OUT NOCOPY VARCHAR2

, x_attribute13 OUT NOCOPY VARCHAR2

, x_attribute14 OUT NOCOPY VARCHAR2

, x_attribute15 OUT NOCOPY VARCHAR2

, x_attribute2 OUT NOCOPY VARCHAR2

, x_attribute3 OUT NOCOPY VARCHAR2

, x_attribute4 OUT NOCOPY VARCHAR2

, x_attribute5 OUT NOCOPY VARCHAR2

, x_attribute6 OUT NOCOPY VARCHAR2

, x_attribute7 OUT NOCOPY VARCHAR2

, x_attribute8 OUT NOCOPY VARCHAR2

, x_attribute9 OUT NOCOPY VARCHAR2

, x_context OUT NOCOPY VARCHAR2

, x_dw_update_advice_flag OUT NOCOPY VARCHAR2

, x_header_id OUT NOCOPY NUMBER

, x_line_id OUT NOCOPY NUMBER

, x_percent OUT NOCOPY NUMBER

, x_salesrep_id OUT NOCOPY NUMBER

, x_sales_credit_type_id OUT NOCOPY NUMBER

, x_sales_credit_id OUT NOCOPY NUMBER

, x_wh_update_date OUT NOCOPY DATE

, x_salesrep OUT NOCOPY VARCHAR2

, x_sales_credit_type OUT NOCOPY VARCHAR2
--SG{
,   x_sales_group         OUT NOCOPY  VARCHAR2
,   x_sales_group_id      OUT NOCOPY  NUMBER
,   x_sales_group_updated_flag OUT NOCOPY  VARCHAR2
--SG}

)
IS
l_Line_Scredit_rec            OE_Order_PUB.Line_Scredit_Rec_Type;

Line: 445

    IF p_attr_id = OE_Line_Scredit_Util.G_DW_UPDATE_ADVICE THEN
        l_Line_Scredit_rec.dw_update_advice_flag := p_attr_value;

Line: 459

    ELSIF p_attr_id = OE_Line_Scredit_Util.G_WH_UPDATE_DATE THEN
        l_Line_Scredit_rec.wh_update_date := TO_DATE(p_attr_value,'YYYY/MM/DD');

Line: 464

    ELSIF p_attr_id =  OE_Line_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN
         l_line_scredit_rec.sales_group_updated_flag := p_attr_value;

Line: 520

        l_Line_Scredit_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 570

    x_dw_update_advice_flag        := FND_API.G_MISS_CHAR;

Line: 577

    x_wh_update_date               := FND_API.G_MISS_DATE;

Line: 583

    x_sales_group_updated_flag          := FND_API.G_MISS_CHAR;

Line: 691

    IF NOT OE_GLOBALS.Equal(l_x_Line_Scredit_rec.dw_update_advice_flag,
                            l_Line_Scredit_rec.dw_update_advice_flag)
    THEN
        x_dw_update_advice_flag := l_x_Line_Scredit_rec.dw_update_advice_flag;

Line: 734

    IF NOT OE_GLOBALS.Equal(l_x_Line_Scredit_rec.wh_update_date,
                            l_Line_Scredit_rec.wh_update_date)
    THEN
        x_wh_update_date := l_x_Line_Scredit_rec.wh_update_date;

Line: 749

     IF NOT OE_GLOBALS.Equal(l_x_Line_Scredit_Tbl(1).sales_group_updated_flag,
                            l_Line_Scredit_rec.sales_group_updated_flag)
    THEN
        x_sales_group_updated_flag    := l_Line_Scredit_rec.sales_group_updated_flag;

Line: 848

, x_last_update_date OUT NOCOPY DATE

, x_last_updated_by OUT NOCOPY NUMBER

, x_last_update_login OUT NOCOPY NUMBER

, x_lock_control OUT NOCOPY NUMBER

)
IS
l_Line_Scredit_rec            OE_Order_PUB.Line_Scredit_Rec_Type;

Line: 912

        l_Line_Scredit_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 972

    x_last_update_date             := l_x_Line_Scredit_tbl(1).last_update_date;

Line: 973

    x_last_updated_by              := l_x_Line_Scredit_tbl(1).last_updated_by;

Line: 974

    x_last_update_login            := l_x_Line_Scredit_tbl(1).last_update_login;

Line: 1058

PROCEDURE Delete_Row
( x_return_status OUT NOCOPY VARCHAR2

, x_msg_count OUT NOCOPY NUMBER

, x_msg_data OUT NOCOPY VARCHAR2

,   p_sales_credit_id               IN  NUMBER
, p_change_reason_code            IN  VARCHAR2 Default Null
, p_change_comments               IN  VARCHAR2 Default Null
)
IS
l_Line_Scredit_rec            OE_Order_PUB.Line_Scredit_Rec_Type;

Line: 1083

        oe_debug_pub.add(  'ENTERING OE_OE_FORM_LINE_SCREDIT.DELETE_ROW' , 1 ) ;

Line: 1116

    l_Line_Scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 1161

        oe_debug_pub.add(  'EXITING OE_OE_FORM_LINE_SCREDIT.DELETE_ROW' , 1 ) ;

Line: 1202

            ,   'Delete_Row'
            );

Line: 1213

END Delete_Row;