DBA Data[Home] [Help]

APPS.OE_LINE_UTIL_EXT SQL Statements

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

Line: 1369

       SELECT set_status INTO l_set_status
       FROM   oe_sets
       WHERE  set_id = p_initial_line_rec.ship_set_id
       AND    set_type = 'SHIP_SET';
Line: 1654

    l_rowtype_rec.AUTO_SELECTED_QUANTITY	:= FND_API.G_MISS_NUM;
Line: 1760

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

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

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

    l_rowtype_rec.PROGRAM_UPDATE_DATE	:= FND_API.G_MISS_DATE;
Line: 1982

    x_rowtype_rec.AUTO_SELECTED_QUANTITY       := p_line_rec.AUTO_SELECTED_QUANTITY;
Line: 2096

    x_rowtype_rec.LAST_UPDATED_BY       := p_line_rec.LAST_UPDATED_BY;
Line: 2097

    x_rowtype_rec.LAST_UPDATE_DATE       := p_line_rec.LAST_UPDATE_DATE;
Line: 2098

    x_rowtype_rec.LAST_UPDATE_LOGIN       := p_line_rec.LAST_UPDATE_LOGIN;
Line: 2141

    x_rowtype_rec.PROGRAM_UPDATE_DATE       := p_line_rec.PROGRAM_UPDATE_DATE;
Line: 2352

    x_api_rec.AUTO_SELECTED_QUANTITY       := p_record.AUTO_SELECTED_QUANTITY;
Line: 2466

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

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

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

    x_api_rec.PROGRAM_UPDATE_DATE       := p_record.PROGRAM_UPDATE_DATE;
Line: 2989

    OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';