DBA Data[Home] [Help]

APPS.OE_LINE_SCREDIT_UTIL SQL Statements

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

Line: 37

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

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

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

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

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

    x_rowtype_rec.DW_UPDATE_ADVICE_FLAG       := p_line_scredit_rec.DW_UPDATE_ADVICE_FLAG;
Line: 85

    x_rowtype_rec.LAST_UPDATED_BY       := p_line_scredit_rec.LAST_UPDATED_BY;
Line: 86

    x_rowtype_rec.LAST_UPDATE_DATE       := p_line_scredit_rec.LAST_UPDATE_DATE;
Line: 87

    x_rowtype_rec.LAST_UPDATE_LOGIN       := p_line_scredit_rec.LAST_UPDATE_LOGIN;
Line: 95

    x_rowtype_rec.WH_UPDATE_DATE       := p_line_scredit_rec.WH_UPDATE_DATE;
Line: 128

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

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

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

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

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

        IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)
        THEN
           l_index := l_index + 1;
Line: 279

           l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
Line: 288

        IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)
        THEN
           l_index := l_index + 1;
Line: 291

           l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;
Line: 294

        IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)
        THEN
           l_index := l_index + 1;
Line: 297

           l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
Line: 300

        IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)
        THEN
           l_index := l_index + 1;
Line: 303

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

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

           l_src_attr_tbl(l_index) := OE_LINE_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_LINE_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_LINE_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_LINE_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_LINE_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_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE;
Line: 476

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

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

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

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

            ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
                p_x_Line_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
Line: 652

    IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)
    THEN
        NULL;
Line: 662

    IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)
    THEN
        NULL;
Line: 667

    IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)
    THEN
        NULL;
Line: 672

    IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)
    THEN
        NULL;
Line: 810

          nvl(p_x_line_Scredit_rec.sales_group_updated_flag,'N') = 'Y' THEN
             oe_debug_pub.add('do not re-default sales group');
Line: 825

     IF nvl(p_x_line_Scredit_rec.sales_group_updated_flag,'N') <> 'Y'
        AND nvl(p_x_line_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_line_Scredit_rec.Header_Id IS NOT NULL THEN
             OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
Line: 862

    IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.wh_update_date,p_old_Line_Scredit_rec.wh_update_date)
    THEN
        NULL;
Line: 961

    IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
        p_x_Line_Scredit_rec.dw_update_advice_flag := p_old_Line_Scredit_rec.dw_update_advice_flag;
Line: 969

    IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        p_x_Line_Scredit_rec.last_updated_by := p_old_Line_Scredit_rec.last_updated_by;
Line: 973

    IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
        p_x_Line_Scredit_rec.last_update_date := p_old_Line_Scredit_rec.last_update_date;
Line: 977

    IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
        p_x_Line_Scredit_rec.last_update_login := p_old_Line_Scredit_rec.last_update_login;
Line: 1001

    IF p_x_Line_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
        p_x_Line_Scredit_rec.wh_update_date := p_old_Line_Scredit_rec.wh_update_date;
Line: 1098

    IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
        p_x_Line_Scredit_rec.dw_update_advice_flag := NULL;
Line: 1106

    IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        p_x_Line_Scredit_rec.last_updated_by := NULL;
Line: 1110

    IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
        p_x_Line_Scredit_rec.last_update_date := NULL;
Line: 1114

    IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
        p_x_Line_Scredit_rec.last_update_login := NULL;
Line: 1138

    IF p_x_Line_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
        p_x_Line_Scredit_rec.wh_update_date := NULL;
Line: 1150

PROCEDURE Update_Row
(   p_Line_Scredit_rec              IN  OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
)
IS
l_lock_control   NUMBER;
Line: 1168

        oe_debug_pub.add(  'ENTERING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
Line: 1171

    SELECT lock_control
    INTO   l_lock_control
    FROM   OE_SALES_CREDITS
    WHERE  sales_credit_id = p_Line_Scredit_rec.sales_credit_id;
Line: 1187

         oe_debug_pub.add(  'BEFORE UPDATE , SALES_CREDIT_ID= '|| L_LINE_SCREDIT_REC.SALES_CREDIT_ID , 1 ) ;
Line: 1191

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

      oe_debug_pub.add(  'AFTER UPDATE , OLD SALES CREDIT ID= ' || L_LINE_SCREDIT_REC.SALES_CREDIT_ID ) ;
Line: 1239

      oe_debug_pub.add(  'AFTER UPDATE , NEW SALES CREDIT ID= ' || P_LINE_SCREDIT_REC.SALES_CREDIT_ID ) ;
Line: 1242

   OE_ORDER_UTIL.Update_Global_Picture
			(p_Upd_New_Rec_If_Exists =>True,
                    	 p_line_scr_rec =>	p_line_scredit_rec,
                    	 p_old_line_scr_rec =>	l_line_scredit_rec,
                    	 p_line_scr_id => 	p_line_scredit_rec.sales_credit_id,
                    	 x_index => 		l_index,
                    	 x_return_status => 	l_return_status);
Line: 1251

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

            oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
Line: 1264

            oe_debug_pub.add(  'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.UPDATE_ROW' ) ;
Line: 1267

            oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
Line: 1276

        oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
Line: 1287

            ,   'Update_Row'
            );
Line: 1293

END Update_Row;
Line: 1297

PROCEDURE Insert_Row
(   p_Line_Scredit_rec              IN  OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
)
IS
l_lock_control    NUMBER:= 1;
Line: 1314

        oe_debug_pub.add(  'ENTERING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
Line: 1317

    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_Line_Scredit_rec.attribute1
    ,       p_Line_Scredit_rec.attribute10
    ,       p_Line_Scredit_rec.attribute11
    ,       p_Line_Scredit_rec.attribute12
    ,       p_Line_Scredit_rec.attribute13
    ,       p_Line_Scredit_rec.attribute14
    ,       p_Line_Scredit_rec.attribute15
    ,       p_Line_Scredit_rec.attribute2
    ,       p_Line_Scredit_rec.attribute3
    ,       p_Line_Scredit_rec.attribute4
    ,       p_Line_Scredit_rec.attribute5
    ,       p_Line_Scredit_rec.attribute6
    ,       p_Line_Scredit_rec.attribute7
    ,       p_Line_Scredit_rec.attribute8
    ,       p_Line_Scredit_rec.attribute9
    ,       p_Line_Scredit_rec.context
    ,       p_Line_Scredit_rec.created_by
    ,       p_Line_Scredit_rec.creation_date
    ,       p_Line_Scredit_rec.dw_update_advice_flag
    ,       p_Line_Scredit_rec.header_id
    ,       p_Line_Scredit_rec.last_updated_by
    ,       p_Line_Scredit_rec.last_update_date
    ,       p_Line_Scredit_rec.last_update_login
    ,       p_Line_Scredit_rec.line_id
    ,       p_Line_Scredit_rec.percent
    ,       p_Line_Scredit_rec.salesrep_id
    ,       p_Line_Scredit_rec.sales_credit_type_id
    ,       p_Line_Scredit_rec.sales_credit_id
    ,       p_Line_Scredit_rec.wh_update_date
    ,       p_Line_Scredit_rec.orig_sys_credit_ref
--SG{
    ,       p_line_scredit_rec.sales_group_id
    ,       p_line_scredit_rec.sales_group_updated_flag
--SG}
    ,       l_lock_control
    );
Line: 1398

   OE_ORDER_UTIL.Update_Global_Picture
			(p_Upd_New_Rec_If_Exists =>True,
                    	 p_line_scr_rec =>	p_line_scredit_rec,
                    	 p_old_line_scr_rec =>	NULL,
                    	 p_line_scr_id => 	p_line_scredit_rec.sales_credit_id,
                    	 x_index => 		l_index,
                    	 x_return_status => 	l_return_status);
Line: 1407

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

            oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
Line: 1423

            oe_debug_pub.add(  'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.INSERT_ROW' ) ;
Line: 1426

            oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
Line: 1435

        oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
Line: 1446

            ,   'Insert_Row'
            );
Line: 1452

END Insert_Row;
Line: 1456

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

	SELECT sales_credit_id
	FROM OE_SALES_CREDITS
	WHERE   LINE_ID = p_line_id;
Line: 1481

        oe_debug_pub.add(  'ENTERING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1496

         oe_debug_pub.add(  'IN DELETE ROW , SALES_CREDIT_ID= '|| L_SCR.SALES_CREDIT_ID , 1 ) ;
Line: 1499

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

   OE_ORDER_UTIL.Update_Global_Picture
			(p_Upd_New_Rec_If_Exists =>True,
                    	 p_line_scr_rec =>	l_new_line_scredit_rec,
                    	 p_old_line_scr_rec =>	l_line_scredit_rec,
                    	 p_line_scr_id => 	l_scr.sales_credit_id,
                    	 x_index => 		l_index,
                    	 x_return_status => 	l_return_status);
Line: 1512

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

            oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1525

            oe_debug_pub.add(  'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
Line: 1528

            oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1537

      OE_Delayed_Requests_Pvt.Delete_Reqs_for_Deleted_Entity(
        p_entity_code  => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
        p_entity_id     => l_scr.sales_credit_id,
        x_return_status => l_return_status
        );
Line: 1546

    DELETE  FROM OE_SALES_CREDIT_HISTORY
    WHERE   LINE_ID = p_line_id
    AND     NVL(AUDIT_FLAG, 'Y') = 'Y'
    AND     NVL(VERSION_FLAG, 'N') = 'N'
    AND     NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
Line: 1552

    UPDATE OE_SALES_CREDIT_HISTORY
    SET    AUDIT_FLAG = 'N'
    WHERE  LINE_ID = p_line_id
    AND    NVL(AUDIT_FLAG, 'Y') = 'Y'
    AND   (NVL(VERSION_FLAG, 'N') = 'Y'
    OR     NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
Line: 1560

    DELETE  FROM OE_SALES_CREDITS
    WHERE   LINE_ID = p_line_id;
Line: 1573

         oe_debug_pub.add(  'IN DELETE ROW , LINE_ID IS G_MISS_NUM , SALES_CREDIT_ID= '|| P_SALES_CREDIT_ID , 1 ) ;
Line: 1576

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

      OE_ORDER_UTIL.Update_Global_Picture(
			p_Upd_New_Rec_If_Exists => True,
                    	p_line_scr_rec =>	l_new_line_scredit_rec,
                    	p_old_line_scr_rec => 	l_line_scredit_rec,
                    	p_line_scr_id => 	p_sales_credit_id,
                    	x_index => 		l_index,
                    	x_return_status => 	l_return_status);
Line: 1589

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

            oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1602

            oe_debug_pub.add(  'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
Line: 1605

            oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1614

     OE_Delayed_Requests_Pvt.Delete_Reqs_for_Deleted_Entity(
        p_entity_code  => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
        p_entity_id     => p_sales_credit_id,
        x_return_status => l_return_status
        );
Line: 1621

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

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

    DELETE  FROM OE_SALES_CREDITS
    WHERE   SALES_CREDIT_ID = p_sales_credit_id
    ;
Line: 1641

        oe_debug_pub.add(  'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
Line: 1652

            ,   'Delete_Row'
            );
Line: 1658

END Delete_Row;
Line: 1701

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

    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   LINE_ID = p_line_id;
Line: 1777

    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 NOT NULL;
Line: 1892

        x_line_scredit_tbl(l_count).dw_update_advice_flag := l_implicit_rec.DW_UPDATE_ADVICE_FLAG;
Line: 1894

        x_line_scredit_tbl(l_count).last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
Line: 1895

        x_line_scredit_tbl(l_count).last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
Line: 1896

        x_line_scredit_tbl(l_count).last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
Line: 1902

        x_line_scredit_tbl(l_count).wh_update_date := l_implicit_rec.WH_UPDATE_DATE;
Line: 1905

        x_line_scredit_tbl(l_count).sales_group_updated_flag:=l_implicit_rec.sales_group_updated_flag;
Line: 1994

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

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

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

  SELECT sales_credit_id
  FROM   oe_sales_credits
  WHERE  line_id = p_line_id
    FOR UPDATE NOWAIT;
Line: 2144

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

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

l_update_flag 			boolean := FALSE;
Line: 2375

   Select count(sales_credit_id), max(sales_credit_id)
   from oe_sales_credits sc,
   oe_sales_credit_types sct
   where header_id = p_line_rec.header_id
   and sc.sales_credit_type_id = sct.sales_credit_type_id
   and   sct.quota_flag = 'Y'
   and line_id =  p_line_rec.line_id;
Line: 2383

   SELECT nvl(Sales_Credit_Type_id,1)
   FROM   ra_salesreps
   WHERE  salesrep_id = p_line_rec.salesrep_id;
Line: 2414

    /*select salesrep_id
    into G_SALESREP_ID
    from oe_order_headers
    where header_id = p_line_rec.header_id; */
Line: 2424

        OR  (p_line_rec.operation = oe_globals.g_opr_update AND       --Added condition for bug 8242058
               NOT OE_GLOBALS.EQUAL( p_line_rec.salesrep_id,
                                     p_old_line_rec.salesrep_id)) THEN


       IF (p_line_rec.operation = oe_globals.g_opr_create AND
             p_line_rec.salesrep_id IS NOT NULL  AND
             p_line_rec.salesrep_id <> FND_API.G_MISS_NUM) THEN

         l_create_flag := TRUE;
Line: 2438

       ELSIF (p_line_rec.operation = oe_globals.g_opr_update AND
               NOT OE_GLOBALS.EQUAL( p_line_rec.salesrep_id,
                                     p_old_line_rec.salesrep_id)) THEN
             IF l_debug_level  > 0 THEN
                 oe_debug_pub.add(  'IN OPERATION UPDATE ' ) ;
Line: 2449

                 oe_debug_pub.add(  'IN CREATE FOR UPDATE OPERATION' ) ;
Line: 2482

         elsif l_sales_credits_count = 1 then -- update with new salesrep

            OE_Line_Scredit_Util.Lock_Rows
               (   p_sales_credit_id  => l_sales_credit_id,
			    x_line_scredit_tbl => l_old_line_scredit_tbl,
			    x_return_status    => l_return_status
               );
Line: 2504

		OE_Line_Scredit_Util.Delete_Row
		(   p_sales_credit_id => l_sales_credit_id,
		    p_line_id => p_line_rec.line_id
		);
Line: 2519

		  l_line_scredit_tbl(1).operation := oe_globals.g_opr_update;
Line: 2520

		  l_update_flag := TRUE;
Line: 2555

       IF l_create_flag OR L_update_flag  THEN
             IF l_debug_level  > 0 THEN
                 oe_debug_pub.add(  'BEFORE CALLING PROCESS ORDER' ) ;
Line: 2600

    OE_ORDER_UTIL.Update_Global_Picture
	(p_Upd_New_Rec_If_Exists =>TRUE
	, p_line_scr_rec	=> l_line_scredit_tbl(1)
	, p_old_line_scr_rec	=> l_old_line_scredit_tbl(1)
        , p_line_scr_id 	=> l_line_scredit_tbl(1).sales_credit_id
        , x_index 		=> l_notify_index
        , x_return_status 	=> l_return_status);
Line: 2609

        oe_debug_pub.add(  'UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_SCREDIT_TBL ( 1 ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;
Line: 2612

        oe_debug_pub.add(  'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_SCREDIT_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
Line: 2640

	        if l_sales_credits_count = 1 then -- issue message update with new salesrep
                fnd_message.set_name('ONT','OE_OE_UPDATED_LINE_CREDIT');
Line: 2645

       END IF; -- if l_create_flag or l_update_flag
Line: 2710

IF (p_x_line_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(  'OEXULSCB: AUDIT TRAIL - CHANGE REQUIRES REASON' , 2 ) ;
Line: 2741

                                           p_hist_type_code =>  'UPDATE');
Line: 2758

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

	     oe_debug_pub.add(  'INSERTING LINE SALES CREDIT HISTORY CAUSED ERROR ' , 1 ) ;