APPS.OE_VALIDATE_ATTR SQL Statements

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

Line: 20

    FND_API.g_attr_tbl.DELETE;

Line: 37

    FND_API.g_attr_tbl(I).name     := 'last_updated_by';

Line: 39

    FND_API.g_attr_tbl(I).name     := 'last_update_date';

Line: 41

    FND_API.g_attr_tbl(I).name     := 'last_update_login';

Line: 104

    FND_API.g_attr_tbl(I).name     := 'program_update_date';

Line: 459

FUNCTION Last_Updated_By ( p_last_updated_by IN NUMBER )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 465

    IF p_last_updated_by IS NULL OR
        p_last_updated_by = FND_API.G_MISS_NUM
    THEN
        RETURN TRUE;

Line: 486

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_updated_by');

Line: 499

            ,   'Last_Updated_By'
            );

Line: 505

END Last_Updated_By;

Line: 507

FUNCTION Last_Update_Date ( p_last_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 513

    IF p_last_update_date IS NULL OR
        p_last_update_date = FND_API.G_MISS_DATE
    THEN
        RETURN TRUE;

Line: 534

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_date');

Line: 547

            ,   'Last_Update_Date'
            );

Line: 553

END Last_Update_Date;

Line: 555

FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 561

    IF p_last_update_login IS NULL OR
        p_last_update_login = FND_API.G_MISS_NUM
    THEN
        RETURN TRUE;

Line: 582

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_login');

Line: 595

            ,   'Last_Update_Login'
            );

Line: 601

END Last_Update_Login;

Line: 2338

FUNCTION Program_Update_Date ( p_program_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 2344

    IF p_program_update_date IS NULL OR
        p_program_update_date = FND_API.G_MISS_DATE
    THEN
        RETURN TRUE;

Line: 2365

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','program_update_date');

Line: 2378

            ,   'Program_Update_Date'
            );

Line: 2384

END Program_Update_Date;

Line: 4674

      SELECT   SI.PRIMARY_UOM_CODE,
              NVL(SERVICE_ITEM_FLAG,0)
       INTO   x_unit_code,
              x_service_item_flag
       FROM   MTL_SYSTEM_ITEMS SI,
              MTL_UNITS_OF_MEASURE MUOM
      WHERE   SI.PRIMARY_UOM_CODE = MUOM.UOM_CODE
       AND    SI.ORGANIZATION_ID = p_organization_id
       AND    SI.INVENTORY_ITEM_ID = p_inventory_item_id;

Line: 4717

             select count(*)
             into l_row_count
             from qp_price_list_lines_v
             where inventory_item_id = p_inventory_item_id
             and price_list_id =  p_price_list_id
             and nvl(customer_item_id, -1) = nvl(p_customer_item_id, -1)
             and nvl(pricing_attribute1, -1) = nvl(p_pricing_attribute1, -1)
             and nvl(pricing_attribute2, -1) = nvl(p_pricing_attribute2, -1)
             and nvl(pricing_attribute3, -1) = nvl(p_pricing_attribute3, -1)
             and nvl(pricing_attribute4, -1) = nvl(p_pricing_attribute4, -1)
             and nvl(pricing_attribute5, -1) = nvl(p_pricing_attribute5, -1)
             and nvl(pricing_attribute6, -1) = nvl(p_pricing_attribute6, -1)
             and nvl(pricing_attribute7, -1) = nvl(p_pricing_attribute7, -1)
             and nvl(pricing_attribute8, -1) = nvl(p_pricing_attribute8, -1)
             and nvl(pricing_attribute9, -1) = nvl(p_pricing_attribute9, -1)
             and nvl(pricing_attribute10, -1) = nvl(p_pricing_attribute10, -1)
             and nvl(pricing_attribute11, -1) = nvl(p_pricing_attribute11, -1)
             and nvl(pricing_attribute12, -1) = nvl(p_pricing_attribute12, -1)
             and nvl(pricing_attribute13, -1) = nvl(p_pricing_attribute13, -1)
             and nvl(pricing_attribute14, -1) = nvl(p_pricing_attribute14, -1)
             and nvl(pricing_attribute15, -1) = nvl(p_pricing_attribute15, -1)
             and nvl(primary, 'N') = 'Y'
	     and (( p_start_date_active between
                        start_date_active and end_date_active)
                OR
                (p_end_date_active  between
                        start_date_active and end_date_active ));