APPS.INV_DEFAULT_TROHDR SQL Statements

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

Line: 563

    IF g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_trohdr_rec.last_updated_by := NULL;

Line: 570

    IF g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_trohdr_rec.last_update_date := NULL;

Line: 577

    IF g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_trohdr_rec.last_update_login := NULL;

Line: 598

    IF g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_trohdr_rec.program_update_date := NULL;

Line: 637

    OR  g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_trohdr_rec.organization_id = FND_API.G_MISS_NUM
    OR  g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_trohdr_rec.program_id = FND_API.G_MISS_NUM
    OR  g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_trohdr_rec.request_id = FND_API.G_MISS_NUM
    OR  g_trohdr_rec.request_number = FND_API.G_MISS_CHAR
    OR  g_trohdr_rec.status_date = FND_API.G_MISS_DATE
    OR  g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM
    OR  g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR
    OR  g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM
    OR  g_trohdr_rec.transaction_type_id = FND_API.G_MISS_NUM
    THEN
       -- dbms_output.put_line('INV_Validate_default_trohdr big null');