DBA Data[Home] [Help]

APPS.OE_HEADER_SCREDIT_UTIL SQL Statements

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

Line: 36

    l_rowtype_rec.DW_UPDATE_ADVICE_FLAG	:= FND_API.G_MISS_CHAR;
Line: 38

    l_rowtype_rec.LAST_UPDATED_BY	:= FND_API.G_MISS_NUM;
Line: 39

    l_rowtype_rec.LAST_UPDATE_DATE	:= FND_API.G_MISS_DATE;
Line: 40

    l_rowtype_rec.LAST_UPDATE_LOGIN	:= FND_API.G_MISS_NUM;
Line: 48

    l_rowtype_rec.WH_UPDATE_DATE	:= FND_API.G_MISS_DATE;
Line: 82

    x_rowtype_rec.DW_UPDATE_ADVICE_FLAG       := p_header_scredit_rec.DW_UPDATE_ADVICE_FLAG;
Line: 84

    x_rowtype_rec.LAST_UPDATED_BY       := p_header_scredit_rec.LAST_UPDATED_BY;
Line: 85

    x_rowtype_rec.LAST_UPDATE_DATE       := p_header_scredit_rec.LAST_UPDATE_DATE;
Line: 86

    x_rowtype_rec.LAST_UPDATE_LOGIN       := p_header_scredit_rec.LAST_UPDATE_LOGIN;
Line: 94

    x_rowtype_rec.WH_UPDATE_DATE       := p_header_scredit_rec.WH_UPDATE_DATE;
Line: 127

    x_api_rec.DW_UPDATE_ADVICE_FLAG       := p_record.DW_UPDATE_ADVICE_FLAG;
Line: 129

    x_api_rec.LAST_UPDATED_BY       := p_record.LAST_UPDATED_BY;
Line: 130

    x_api_rec.LAST_UPDATE_DATE       := p_record.LAST_UPDATE_DATE;
Line: 131

    x_api_rec.LAST_UPDATE_LOGIN       := p_record.LAST_UPDATE_LOGIN;
Line: 139

    x_api_rec.WH_UPDATE_DATE       := p_record.WH_UPDATE_DATE;
Line: 277

        IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.dw_update_advice_flag,p_old_Header_Scredit_rec.dw_update_advice_flag)
        THEN
           l_index := l_index + 1;
Line: 280

           l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
Line: 289

        IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_updated_by,p_old_Header_Scredit_rec.last_updated_by)
        THEN
           l_index := l_index + 1;
Line: 292

           l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY;
Line: 295

        IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_date,p_old_Header_Scredit_rec.last_update_date)
        THEN
           l_index := l_index + 1;
Line: 298

           l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
Line: 301

        IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_login,p_old_Header_Scredit_rec.last_update_login)
        THEN
           l_index := l_index + 1;
Line: 304

           l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
Line: 337

        IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.wh_update_date,p_old_Header_Scredit_rec.wh_update_date)
        THEN
           l_index := l_index + 1;
Line: 340

           l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_WH_UPDATE_DATE;
Line: 397

    ELSIF p_attr_id = G_DW_UPDATE_ADVICE THEN
        l_index := l_index + 1;
Line: 399

        l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
Line: 403

    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        l_index := l_index + 1;
Line: 405

        l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY;
Line: 406

    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        l_index := l_index + 1;
Line: 408

        l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
Line: 409

    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        l_index := l_index + 1;
Line: 411

        l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
Line: 427

    ELSIF p_attr_id = G_WH_UPDATE_DATE THEN
        l_index := l_index + 1;
Line: 429

        l_src_attr_tbl(l_index) := OE_HEADER_SCREDIT_UTIL.G_WH_UPDATE_DATE;
Line: 476

            ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
                p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
Line: 480

            ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
                p_x_Header_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
Line: 482

            ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
                p_x_Header_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
Line: 484

            ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
                p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
Line: 496

            ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
                p_x_Header_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
Line: 642

    IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.dw_update_advice_flag,p_old_Header_Scredit_rec.dw_update_advice_flag)
    THEN
        NULL;
Line: 652

    IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_updated_by,p_old_Header_Scredit_rec.last_updated_by)
    THEN
        NULL;
Line: 657

    IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_date,p_old_Header_Scredit_rec.last_update_date)
    THEN
        NULL;
Line: 662

    IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.last_update_login,p_old_Header_Scredit_rec.last_update_login)
    THEN
        NULL;
Line: 744

     IF nvl(p_x_Header_Scredit_rec.sales_group_updated_flag,'N') <> 'Y'
        AND nvl(p_x_Header_Scredit_rec.salesrep_id,FND_API.G_MISS_NUM)<>FND_API.G_MISS_NUM
     THEN

          IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
             --header not available in cache, load info to cache
            IF p_x_Header_Scredit_rec.Header_Id IS NOT NULL THEN
             OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Scredit_rec.Header_Id);
Line: 782

    IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.wh_update_date,p_old_Header_Scredit_rec.wh_update_date)
    THEN
        NULL;
Line: 873

    IF p_x_Header_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
        p_x_Header_Scredit_rec.dw_update_advice_flag := p_old_Header_Scredit_rec.dw_update_advice_flag;
Line: 881

    IF p_x_Header_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        p_x_Header_Scredit_rec.last_updated_by := p_old_Header_Scredit_rec.last_updated_by;
Line: 885

    IF p_x_Header_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
        p_x_Header_Scredit_rec.last_update_date := p_old_Header_Scredit_rec.last_update_date;
Line: 889

    IF p_x_Header_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
        p_x_Header_Scredit_rec.last_update_login := p_old_Header_Scredit_rec.last_update_login;
Line: 913

    IF p_x_Header_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
        p_x_Header_Scredit_rec.wh_update_date := p_old_Header_Scredit_rec.wh_update_date;
Line: 1005

    IF p_x_Header_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
        p_x_Header_Scredit_rec.dw_update_advice_flag := NULL;
Line: 1013

    IF p_x_Header_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        p_x_Header_Scredit_rec.last_updated_by := NULL;
Line: 1017

    IF p_x_Header_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
        p_x_Header_Scredit_rec.last_update_date := NULL;
Line: 1021

    IF p_x_Header_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
        p_x_Header_Scredit_rec.last_update_login := NULL;
Line: 1045

    IF p_x_Header_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
        p_x_Header_Scredit_rec.wh_update_date := NULL;
Line: 1055

PROCEDURE Update_Row
(   p_Header_Scredit_rec            IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
)
IS
    l_lock_control   NUMBER;
Line: 1070

    SELECT lock_control
    INTO   l_lock_control
    FROM   OE_SALES_CREDITS
    WHERE  sales_credit_id = p_Header_Scredit_rec.sales_credit_id;
Line: 1083

       OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
                    p_Hdr_scr_rec =>p_header_scredit_rec,
                    p_hdr_scr_id => p_header_scredit_rec.sales_credit_id,
                    x_index => l_index,
                    x_return_status => l_return_status);
Line: 1089

           oe_debug_pub.add(  'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
Line: 1096

              oe_debug_pub.add(  'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
Line: 1101

              oe_debug_pub.add(  'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' ) ;
Line: 1104

             oe_debug_pub.add(  'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
Line: 1111

    UPDATE  OE_SALES_CREDITS
    SET     ATTRIBUTE1                     = p_Header_Scredit_rec.attribute1
    ,       ATTRIBUTE10                    = p_Header_Scredit_rec.attribute10
    ,       ATTRIBUTE11                    = p_Header_Scredit_rec.attribute11
    ,       ATTRIBUTE12                    = p_Header_Scredit_rec.attribute12
    ,       ATTRIBUTE13                    = p_Header_Scredit_rec.attribute13
    ,       ATTRIBUTE14                    = p_Header_Scredit_rec.attribute14
    ,       ATTRIBUTE15                    = p_Header_Scredit_rec.attribute15
    ,       ATTRIBUTE2                     = p_Header_Scredit_rec.attribute2
    ,       ATTRIBUTE3                     = p_Header_Scredit_rec.attribute3
    ,       ATTRIBUTE4                     = p_Header_Scredit_rec.attribute4
    ,       ATTRIBUTE5                     = p_Header_Scredit_rec.attribute5
    ,       ATTRIBUTE6                     = p_Header_Scredit_rec.attribute6
    ,       ATTRIBUTE7                     = p_Header_Scredit_rec.attribute7
    ,       ATTRIBUTE8                     = p_Header_Scredit_rec.attribute8
    ,       ATTRIBUTE9                     = p_Header_Scredit_rec.attribute9
    ,       CONTEXT                        = p_Header_Scredit_rec.context
    ,       CREATED_BY                     = p_Header_Scredit_rec.created_by
    ,       CREATION_DATE                  = p_Header_Scredit_rec.creation_date
    ,       DW_UPDATE_ADVICE_FLAG          = p_Header_Scredit_rec.dw_update_advice_flag
    ,       HEADER_ID                      = p_Header_Scredit_rec.header_id
    ,       LAST_UPDATED_BY                = p_Header_Scredit_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_Header_Scredit_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_Header_Scredit_rec.last_update_login
    ,       LINE_ID                        = p_Header_Scredit_rec.line_id
    ,       PERCENT                        = p_Header_Scredit_rec.percent
    ,       SALESREP_ID                    = p_Header_Scredit_rec.salesrep_id
    ,       sales_credit_type_id           = p_Header_Scredit_rec.sales_credit_type_id
    ,       SALES_CREDIT_ID                = p_Header_Scredit_rec.sales_credit_id
    ,       WH_UPDATE_DATE                 = p_Header_Scredit_rec.wh_update_date
    ,       LOCK_CONTROL                   = l_lock_control
--SG{
    ,       sales_group_id                 =  p_Header_Scredit_rec.sales_group_id
    ,       sales_group_updated_flag            =  p_Header_Scredit_rec.sales_group_updated_flag
--SG}
    WHERE   SALES_CREDIT_ID = p_Header_Scredit_rec.sales_credit_id
    ;
Line: 1159

            ,   'Update_Row'
            );
Line: 1165

END Update_Row;
Line: 1169

PROCEDURE Insert_Row
(   p_Header_Scredit_rec       IN OUT NOCOPY  OE_Order_PUB.Header_Scredit_Rec_Type
)
IS
    l_lock_control   NUMBER:= 1;
Line: 1181

       oe_debug_pub.add(  'ENTERING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
Line: 1184

    INSERT  INTO OE_SALES_CREDITS
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DW_UPDATE_ADVICE_FLAG
    ,       HEADER_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       PERCENT
    ,       SALESREP_ID
    ,       sales_credit_type_id
    ,       SALES_CREDIT_ID
    ,       WH_UPDATE_DATE
    ,       ORIG_SYS_CREDIT_REF
--SG{
    ,       sales_group_id
    ,       sales_group_updated_flag
--SG}
    ,       LOCK_CONTROL
    )
    VALUES
    (       p_Header_Scredit_rec.attribute1
    ,       p_Header_Scredit_rec.attribute10
    ,       p_Header_Scredit_rec.attribute11
    ,       p_Header_Scredit_rec.attribute12
    ,       p_Header_Scredit_rec.attribute13
    ,       p_Header_Scredit_rec.attribute14
    ,       p_Header_Scredit_rec.attribute15
    ,       p_Header_Scredit_rec.attribute2
    ,       p_Header_Scredit_rec.attribute3
    ,       p_Header_Scredit_rec.attribute4
    ,       p_Header_Scredit_rec.attribute5
    ,       p_Header_Scredit_rec.attribute6
    ,       p_Header_Scredit_rec.attribute7
    ,       p_Header_Scredit_rec.attribute8
    ,       p_Header_Scredit_rec.attribute9
    ,       p_Header_Scredit_rec.context
    ,       p_Header_Scredit_rec.created_by
    ,       p_Header_Scredit_rec.creation_date
    ,       p_Header_Scredit_rec.dw_update_advice_flag
    ,       p_Header_Scredit_rec.header_id
    ,       p_Header_Scredit_rec.last_updated_by
    ,       p_Header_Scredit_rec.last_update_date
    ,       p_Header_Scredit_rec.last_update_login
    ,       p_Header_Scredit_rec.line_id
    ,       p_Header_Scredit_rec.percent
    ,       p_Header_Scredit_rec.salesrep_id
    ,       p_Header_Scredit_rec.sales_credit_type_id
    ,       p_Header_Scredit_rec.sales_credit_id
    ,       p_Header_Scredit_rec.wh_update_date
    ,       p_Header_Scredit_rec.orig_sys_credit_ref
--SG{
    ,       p_header_scredit_rec.sales_group_id
    ,       p_header_scredit_rec.sales_group_updated_flag
--SG}
    ,       l_lock_control
    );
Line: 1264

      OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
                    p_old_hdr_scr_rec => NULL,
                    p_Hdr_scr_rec =>p_header_scredit_rec,
                    p_hdr_scr_id => p_header_scredit_rec.sales_credit_id,
                    x_index => l_index,
                    x_return_status => l_return_status);
Line: 1271

           oe_debug_pub.add(  'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
Line: 1282

            oe_debug_pub.add(  'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
Line: 1287

            oe_debug_pub.add(  'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.INSERT_ROW' ) ;
Line: 1290

            oe_debug_pub.add(  'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
Line: 1298

        oe_debug_pub.add(  'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
Line: 1309

            ,   'Insert_Row'
            );
Line: 1315

END Insert_Row;
Line: 1319

PROCEDURE Delete_Row
(   p_sales_credit_id               IN  NUMBER :=
                                        FND_API.G_MISS_NUM
,   p_header_id                     IN  NUMBER :=
                                        FND_API.G_MISS_NUM
)
IS
l_return_status		VARCHAR2(30);
Line: 1328

	SELECT sales_credit_id
	FROM OE_SALES_CREDITS
	WHERE   HEADER_ID = p_header_id;
Line: 1339

      oe_debug_pub.add(  'ENTERING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1349

      /* Set the operation on the record so that globals are updated as well */
        l_new_header_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;
Line: 1353

        OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
                    p_Hdr_scr_rec =>l_new_header_scredit_rec,
                    p_hdr_scr_id => l_scr.sales_credit_id,
                    x_index => l_index,
                    x_return_status => l_return_status);
Line: 1359

             oe_debug_pub.add(  'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
Line: 1366

               oe_debug_pub.add(  'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1371

               oe_debug_pub.add(  'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
Line: 1374

                oe_debug_pub.add(  'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1381

      OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
        p_entity_code  => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
        p_entity_id     => l_scr.sales_credit_id,
        x_return_status => l_return_status
        );
Line: 1389

    DELETE  FROM OE_SALES_CREDIT_HISTORY
    WHERE   HEADER_ID = p_header_id;
Line: 1393

    DELETE  FROM OE_SALES_CREDITS
    WHERE   HEADER_ID = p_header_id;
Line: 1399

      /* Set the operation on the record so that globals are updated as well */
        l_new_header_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;
Line: 1402

       OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
                    p_Hdr_scr_rec =>l_new_header_scredit_rec,
                    p_hdr_scr_id => p_sales_credit_id,
                    x_index => l_index,
                    x_return_status => l_return_status);
Line: 1408

           oe_debug_pub.add(  'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
Line: 1416

              oe_debug_pub.add(  'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1421

              oe_debug_pub.add(  'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
Line: 1424

              oe_debug_pub.add(  'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1431

     OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
        p_entity_code  => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,
        p_entity_id     => p_sales_credit_id,
        x_return_status => l_return_status
        );
Line: 1438

    DELETE  FROM OE_SALES_CREDIT_HISTORY
    WHERE   SALES_CREDIT_ID = p_sales_credit_id
    AND     NVL(AUDIT_FLAG, 'Y') = 'Y'
    AND     NVL(VERSION_FLAG, 'N') = 'N'
    AND     NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
Line: 1444

    UPDATE OE_SALES_CREDIT_HISTORY
    SET    AUDIT_FLAG = 'N'
    WHERE  SALES_CREDIT_ID = p_sales_credit_id
    AND    NVL(AUDIT_FLAG, 'Y') = 'Y'
    AND   (NVL(VERSION_FLAG, 'N') = 'Y'
    OR     NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
Line: 1452

    DELETE  FROM OE_SALES_CREDITS
    WHERE   SALES_CREDIT_ID = p_sales_credit_id
    ;
Line: 1465

            ,   'Delete_Row'
            );
Line: 1471

END Delete_Row;
Line: 1510

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DW_UPDATE_ADVICE_FLAG
    ,       HEADER_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       PERCENT
    ,       SALESREP_ID
    ,       sales_credit_type_id
    ,       SALES_CREDIT_ID
    ,       WH_UPDATE_DATE
    --SG {
    ,       SALES_GROUP_ID
    ,       SALES_GROUP_UPDATED_FLAG
    --SG }
    ,       LOCK_CONTROL
    FROM    OE_SALES_CREDITS
    WHERE   SALES_CREDIT_ID = p_sales_credit_id;
Line: 1548

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DW_UPDATE_ADVICE_FLAG
    ,       HEADER_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       PERCENT
    ,       SALESREP_ID
    ,       sales_credit_type_id
    ,       SALES_CREDIT_ID
    ,       WH_UPDATE_DATE
    --SG {
    ,       SALES_GROUP_ID
    ,       SALES_GROUP_UPDATED_FLAG
    --SG }
    ,       LOCK_CONTROL
    FROM    OE_SALES_CREDITS
    WHERE   HEADER_ID = p_header_id
    	    AND LINE_ID IS NULL;
Line: 1655

        x_header_scredit_tbl(l_count).dw_update_advice_flag := l_implicit_rec.DW_UPDATE_ADVICE_FLAG;
Line: 1657

        x_header_scredit_tbl(l_count).last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
Line: 1658

        x_header_scredit_tbl(l_count).last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
Line: 1659

        x_header_scredit_tbl(l_count).last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
Line: 1665

        x_header_scredit_tbl(l_count).wh_update_date := l_implicit_rec.WH_UPDATE_DATE;
Line: 1668

        x_header_scredit_tbl(l_count).sales_group_updated_flag:=l_implicit_rec.sales_group_updated_flag;
Line: 1751

   SELECT  sales_credit_id
    INTO   l_sales_credit_id
    FROM   oe_sales_credits
    WHERE  sales_credit_id = l_sales_credit_id
    FOR UPDATE NOWAIT;
Line: 1758

        oe_debug_pub.add(  'SELECTED FOR UPDATE' , 1 ) ;
Line: 1825

            FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
Line: 1866

  SELECT sales_credit_id
  FROM   oe_sales_credits
  WHERE  header_id = p_header_id
    FOR UPDATE NOWAIT;
Line: 1901

     SELECT sales_credit_id
     INTO   l_sales_credit_id
     FROM   OE_SALES_CREDITS
     WHERE  sales_credit_id   = p_sales_credit_id
     FOR UPDATE NOWAIT;
Line: 1960

       fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
Line: 2028

     /*Select group_name into l_sg_name
     From   jtf_rs_groups_vl
     Where  Group_Id=p_Header_Scredit_rec.sales_group_id;
Line: 2174

IF (p_x_header_scredit_rec.operation  = OE_GLOBALS.G_OPR_UPDATE) THEN

    IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
       IF l_debug_level  > 0 THEN
           oe_debug_pub.add(  'AUDIT TRAIL , CHANGE ATTRIBUTE REQUIRES REASON' , 1 ) ;
Line: 2209

                                           p_hist_type_code =>  'UPDATE');
Line: 2223

         p_hist_type_code => 'UPDATE',
         p_reason_code => p_x_header_scredit_rec.change_reason,
         p_comments => p_x_header_scredit_rec.change_comments,
         p_wf_activity_code => null,
         p_wf_result_code => null,
         x_return_status => l_return_status);
Line: 2232

		     oe_debug_pub.add(  'INSERTING HEADER SCREDIT HISTORY CAUSED ERROR' , 1 ) ;
Line: 2299

   SELECT count(sales_credit_id), max(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: 2308

   SELECT nvl(Sales_Credit_Type_id,1)
   FROM   ra_salesreps
   WHERE  salesrep_id = p_salesrep_id;
Line: 2335

    SELECT header_id INTO l_header_id
    FROM   oe_order_headers_all
    WHERE  header_id = p_header_id;
Line: 2390

       l_Header_Scredit_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
Line: 2487

    IF l_sales_credits_count = 1 THEN -- issue message update with new salesrep
       fnd_message.set_name('ONT','OE_OE_UPDATED_ORDER_CREDIT');
Line: 2555

Select salesrep_id,
       sales_credit_id,
       sales_group_id
From   OE_SALES_CREDITS
Where  Sales_Group_Updated_Flag = 'N'
And    header_id = p_header_id;
Line: 2606

     UPDATE OE_SALES_CREDITS
     SET   Sales_Group_Id = l_sales_group_id_tbl(i)
     WHERE Sales_Credit_Id = l_sales_credit_id_tbl(i);