eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_FLOWSCHEDULE_UTIL SQL Statements

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

Line: 155


    IF p_old_FlowSchedule_rec.last_updated_by <> FND_API.G_MISS_NUM THEN
        l_FlowSchedule_rec.last_updated_by := p_old_FlowSchedule_rec.last_updated_by;

Line: 159


    IF p_old_FlowSchedule_rec.last_update_date <> FND_API.G_MISS_DATE THEN
        l_FlowSchedule_rec.last_update_date := p_old_FlowSchedule_rec.last_update_date;

Line: 163


    IF p_old_FlowSchedule_rec.last_update_login <> FND_API.G_MISS_NUM THEN
        l_FlowSchedule_rec.last_update_login := p_old_FlowSchedule_rec.last_update_login;

Line: 227


    IF p_old_FlowSchedule_rec.program_update_date <> FND_API.G_MISS_DATE THEN
        l_FlowSchedule_rec.program_update_date := p_old_FlowSchedule_rec.program_update_date;

Line: 429


    IF l_FlowSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_FlowSchedule_rec.last_updated_by := p_old_FlowSchedule_rec.last_updated_by;

Line: 433


    IF l_FlowSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_FlowSchedule_rec.last_update_date := p_old_FlowSchedule_rec.last_update_date;

Line: 437


    IF l_FlowSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_FlowSchedule_rec.last_update_login := p_old_FlowSchedule_rec.last_update_login;

Line: 501


    IF l_FlowSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_FlowSchedule_rec.program_update_date := p_old_FlowSchedule_rec.program_update_date;

Line: 715


    IF l_FlowSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_FlowSchedule_rec.last_updated_by := NULL;

Line: 719


    IF l_FlowSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_FlowSchedule_rec.last_update_date := NULL;

Line: 723


    IF l_FlowSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_FlowSchedule_rec.last_update_login := NULL;

Line: 787


    IF l_FlowSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_FlowSchedule_rec.program_update_date := NULL;

Line: 861


PROCEDURE Update_Row
(   p_FlowSchedule_rec              IN  WIP_Work_Order_PUB.Flowschedule_Rec_Type
)
IS
BEGIN

    UPDATE  WIP_FLOW_SCHEDULES
    SET     ALTERNATE_BOM_DESIGNATOR       = p_FlowSchedule_rec.alternate_bom_designator
    ,       ALTERNATE_ROUTING_DESIGNATOR   = p_FlowSchedule_rec.alternate_rout_designator
    ,       ATTRIBUTE1                     = p_FlowSchedule_rec.attribute1
    ,       ATTRIBUTE10                    = p_FlowSchedule_rec.attribute10
    ,       ATTRIBUTE11                    = p_FlowSchedule_rec.attribute11
    ,       ATTRIBUTE12                    = p_FlowSchedule_rec.attribute12
    ,       ATTRIBUTE13                    = p_FlowSchedule_rec.attribute13
    ,       ATTRIBUTE14                    = p_FlowSchedule_rec.attribute14
    ,       ATTRIBUTE15                    = p_FlowSchedule_rec.attribute15
    ,       ATTRIBUTE2                     = p_FlowSchedule_rec.attribute2
    ,       ATTRIBUTE3                     = p_FlowSchedule_rec.attribute3
    ,       ATTRIBUTE4                     = p_FlowSchedule_rec.attribute4
    ,       ATTRIBUTE5                     = p_FlowSchedule_rec.attribute5
    ,       ATTRIBUTE6                     = p_FlowSchedule_rec.attribute6
    ,       ATTRIBUTE7                     = p_FlowSchedule_rec.attribute7
    ,       ATTRIBUTE8                     = p_FlowSchedule_rec.attribute8
    ,       ATTRIBUTE9                     = p_FlowSchedule_rec.attribute9
    ,       ATTRIBUTE_CATEGORY             = p_FlowSchedule_rec.attribute_category
    ,       BOM_REVISION                   = p_FlowSchedule_rec.bom_revision
    ,       BOM_REVISION_DATE              = p_FlowSchedule_rec.bom_revision_date
    ,       BUILD_SEQUENCE                 = p_FlowSchedule_rec.build_sequence
    ,       CLASS_CODE                     = p_FlowSchedule_rec.class_code
    ,       COMPLETION_LOCATOR_ID          = p_FlowSchedule_rec.completion_locator_id
    ,       COMPLETION_SUBINVENTORY        = p_FlowSchedule_rec.completion_subinventory
    ,       CREATED_BY                     = p_FlowSchedule_rec.created_by
    ,       CREATION_DATE                  = p_FlowSchedule_rec.creation_date
    ,       DATE_CLOSED                    = p_FlowSchedule_rec.date_closed
    ,       DEMAND_CLASS                   = p_FlowSchedule_rec.demand_class
    ,       DEMAND_SOURCE_DELIVERY         = p_FlowSchedule_rec.demand_source_delivery
    ,       DEMAND_SOURCE_HEADER_ID        = p_FlowSchedule_rec.demand_source_header_id
    ,       DEMAND_SOURCE_LINE             = p_FlowSchedule_rec.demand_source_line
    ,       DEMAND_SOURCE_TYPE             = p_FlowSchedule_rec.demand_source_type
    ,       KANBAN_CARD_ID                 = p_FlowSchedule_rec.kanban_card_id
    ,       LAST_UPDATED_BY                = p_FlowSchedule_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_FlowSchedule_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_FlowSchedule_rec.last_update_login
    ,       LINE_ID                        = p_FlowSchedule_rec.line_id
    ,       MATERIAL_ACCOUNT               = p_FlowSchedule_rec.material_account
    ,       MATERIAL_OVERHEAD_ACCOUNT      = p_FlowSchedule_rec.material_overhead_account
    ,       MATERIAL_VARIANCE_ACCOUNT      = p_FlowSchedule_rec.material_variance_account
    ,       MPS_NET_QUANTITY               = p_FlowSchedule_rec.mps_net_quantity
    ,       MPS_SCHEDULED_COMPLETION_DATE  = p_FlowSchedule_rec.mps_scheduled_cpl_date
    ,       ORGANIZATION_ID                = p_FlowSchedule_rec.organization_id
    ,       OUTSIDE_PROCESSING_ACCOUNT     = p_FlowSchedule_rec.osp_account
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT  = p_FlowSchedule_rec.osp_variance_account
    ,       OVERHEAD_ACCOUNT               = p_FlowSchedule_rec.overhead_account
    ,       OVERHEAD_VARIANCE_ACCOUNT      = p_FlowSchedule_rec.overhead_variance_account
    ,       PLANNED_QUANTITY               = p_FlowSchedule_rec.planned_quantity
    ,       PRIMARY_ITEM_ID                = p_FlowSchedule_rec.primary_item_id
    ,       PROGRAM_APPLICATION_ID         = p_FlowSchedule_rec.program_application_id
    ,       PROGRAM_ID                     = p_FlowSchedule_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_FlowSchedule_rec.program_update_date
    ,       PROJECT_ID                     = p_FlowSchedule_rec.project_id
    ,       QUANTITY_COMPLETED             = p_FlowSchedule_rec.quantity_completed
    ,       REQUEST_ID                     = p_FlowSchedule_rec.request_id
    ,       RESOURCE_ACCOUNT               = p_FlowSchedule_rec.resource_account
    ,       RESOURCE_VARIANCE_ACCOUNT      = p_FlowSchedule_rec.resource_variance_account
    ,       ROUTING_REVISION               = p_FlowSchedule_rec.routing_revision
    ,       ROUTING_REVISION_DATE          = p_FlowSchedule_rec.routing_revision_date
    ,       SCHEDULED_COMPLETION_DATE      = p_FlowSchedule_rec.scheduled_completion_date
    ,       SCHEDULED_FLAG                 = p_FlowSchedule_rec.scheduled_flag
    ,       SCHEDULED_START_DATE           = p_FlowSchedule_rec.scheduled_start_date
    ,       SCHEDULE_GROUP_ID              = p_FlowSchedule_rec.schedule_group_id
    ,       SCHEDULE_NUMBER                = p_FlowSchedule_rec.schedule_number
    ,       STATUS                         = p_FlowSchedule_rec.status
    ,       STD_COST_ADJUSTMENT_ACCOUNT    = p_FlowSchedule_rec.std_cost_adj_account
    ,       TASK_ID                        = p_FlowSchedule_rec.task_id
    ,       WIP_ENTITY_ID                  = p_FlowSchedule_rec.wip_entity_id
    WHERE   SCHEDULE_NUMBER = p_FlowSchedule_rec.schedule_number
    ;

Line: 947


            ,   'Update_Row'
            );

Line: 953


END Update_Row;

Line: 957


PROCEDURE Insert_Row
(   p_FlowSchedule_rec              IN  WIP_Work_Order_PUB.Flowschedule_Rec_Type
)
IS
BEGIN

    INSERT  INTO WIP_FLOW_SCHEDULES
    (       ALTERNATE_BOM_DESIGNATOR
    ,       ALTERNATE_ROUTING_DESIGNATOR
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       BOM_REVISION
    ,       BOM_REVISION_DATE
    ,       BUILD_SEQUENCE
    ,       CLASS_CODE
    ,       COMPLETION_LOCATOR_ID
    ,       COMPLETION_SUBINVENTORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DATE_CLOSED
    ,       DEMAND_CLASS
    ,       DEMAND_SOURCE_DELIVERY
    ,       DEMAND_SOURCE_HEADER_ID
    ,       DEMAND_SOURCE_LINE
    ,       DEMAND_SOURCE_TYPE
    ,       KANBAN_CARD_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       MATERIAL_ACCOUNT
    ,       MATERIAL_OVERHEAD_ACCOUNT
    ,       MATERIAL_VARIANCE_ACCOUNT
    ,       MPS_NET_QUANTITY
    ,       MPS_SCHEDULED_COMPLETION_DATE
    ,       ORGANIZATION_ID
    ,       OUTSIDE_PROCESSING_ACCOUNT
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT
    ,       OVERHEAD_ACCOUNT
    ,       OVERHEAD_VARIANCE_ACCOUNT
    ,       PLANNED_QUANTITY
    ,       PRIMARY_ITEM_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PROJECT_ID
    ,       QUANTITY_COMPLETED
    ,       REQUEST_ID
    ,       RESOURCE_ACCOUNT
    ,       RESOURCE_VARIANCE_ACCOUNT
    ,       ROUTING_REVISION
    ,       ROUTING_REVISION_DATE
    ,       SCHEDULED_COMPLETION_DATE
    ,       SCHEDULED_FLAG
    ,       SCHEDULED_START_DATE
    ,       SCHEDULE_GROUP_ID
    ,       SCHEDULE_NUMBER
    ,       STATUS
    ,       STD_COST_ADJUSTMENT_ACCOUNT
    ,       TASK_ID
    ,       WIP_ENTITY_ID
    )
    VALUES
    (       p_FlowSchedule_rec.alternate_bom_designator
    ,       p_FlowSchedule_rec.alternate_rout_designator
    ,       p_FlowSchedule_rec.attribute1
    ,       p_FlowSchedule_rec.attribute10
    ,       p_FlowSchedule_rec.attribute11
    ,       p_FlowSchedule_rec.attribute12
    ,       p_FlowSchedule_rec.attribute13
    ,       p_FlowSchedule_rec.attribute14
    ,       p_FlowSchedule_rec.attribute15
    ,       p_FlowSchedule_rec.attribute2
    ,       p_FlowSchedule_rec.attribute3
    ,       p_FlowSchedule_rec.attribute4
    ,       p_FlowSchedule_rec.attribute5
    ,       p_FlowSchedule_rec.attribute6
    ,       p_FlowSchedule_rec.attribute7
    ,       p_FlowSchedule_rec.attribute8
    ,       p_FlowSchedule_rec.attribute9
    ,       p_FlowSchedule_rec.attribute_category
    ,       p_FlowSchedule_rec.bom_revision
    ,       p_FlowSchedule_rec.bom_revision_date
    ,       p_FlowSchedule_rec.build_sequence
    ,       p_FlowSchedule_rec.class_code
    ,       p_FlowSchedule_rec.completion_locator_id
    ,       p_FlowSchedule_rec.completion_subinventory
    ,       p_FlowSchedule_rec.created_by
    ,       p_FlowSchedule_rec.creation_date
    ,       p_FlowSchedule_rec.date_closed
    ,       p_FlowSchedule_rec.demand_class
    ,       p_FlowSchedule_rec.demand_source_delivery
    ,       p_FlowSchedule_rec.demand_source_header_id
    ,       p_FlowSchedule_rec.demand_source_line
    ,       p_FlowSchedule_rec.demand_source_type
    ,       p_FlowSchedule_rec.kanban_card_id
    ,       p_FlowSchedule_rec.last_updated_by
    ,       p_FlowSchedule_rec.last_update_date
    ,       p_FlowSchedule_rec.last_update_login
    ,       p_FlowSchedule_rec.line_id
    ,       p_FlowSchedule_rec.material_account
    ,       p_FlowSchedule_rec.material_overhead_account
    ,       p_FlowSchedule_rec.material_variance_account
    ,       p_FlowSchedule_rec.mps_net_quantity
    ,       p_FlowSchedule_rec.mps_scheduled_cpl_date
    ,       p_FlowSchedule_rec.organization_id
    ,       p_FlowSchedule_rec.osp_account
    ,       p_FlowSchedule_rec.osp_variance_account
    ,       p_FlowSchedule_rec.overhead_account
    ,       p_FlowSchedule_rec.overhead_variance_account
    ,       p_FlowSchedule_rec.planned_quantity
    ,       p_FlowSchedule_rec.primary_item_id
    ,       p_FlowSchedule_rec.program_application_id
    ,       p_FlowSchedule_rec.program_id
    ,       p_FlowSchedule_rec.program_update_date
    ,       p_FlowSchedule_rec.project_id
    ,       p_FlowSchedule_rec.quantity_completed
    ,       p_FlowSchedule_rec.request_id
    ,       p_FlowSchedule_rec.resource_account
    ,       p_FlowSchedule_rec.resource_variance_account
    ,       p_FlowSchedule_rec.routing_revision
    ,       p_FlowSchedule_rec.routing_revision_date
    ,       p_FlowSchedule_rec.scheduled_completion_date
    ,       p_FlowSchedule_rec.scheduled_flag
    ,       p_FlowSchedule_rec.scheduled_start_date
    ,       p_FlowSchedule_rec.schedule_group_id
    ,       p_FlowSchedule_rec.schedule_number
    ,       p_FlowSchedule_rec.status
    ,       p_FlowSchedule_rec.std_cost_adj_account
    ,       p_FlowSchedule_rec.task_id
    ,       p_FlowSchedule_rec.wip_entity_id
    );

Line: 1112


            ,   'Insert_Row'
            );

Line: 1118


END Insert_Row;

Line: 1122


PROCEDURE Delete_Row
(   p_schedule_number               IN  VARCHAR2
)
IS
BEGIN

    DELETE  FROM WIP_FLOW_SCHEDULES
    WHERE   SCHEDULE_NUMBER = p_schedule_number
    ;

Line: 1140


            ,   'Delete_Row'
            );

Line: 1146


END Delete_Row;

Line: 1190


    SELECT  ALTERNATE_BOM_DESIGNATOR
    ,       ALTERNATE_ROUTING_DESIGNATOR
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       BOM_REVISION
    ,       BOM_REVISION_DATE
    ,       BUILD_SEQUENCE
    ,       CLASS_CODE
    ,       COMPLETION_LOCATOR_ID
    ,       COMPLETION_SUBINVENTORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DATE_CLOSED
    ,       DEMAND_CLASS
    ,       DEMAND_SOURCE_DELIVERY
    ,       DEMAND_SOURCE_HEADER_ID
    ,       DEMAND_SOURCE_LINE
    ,       DEMAND_SOURCE_TYPE
    ,       KANBAN_CARD_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       MATERIAL_ACCOUNT
    ,       MATERIAL_OVERHEAD_ACCOUNT
    ,       MATERIAL_VARIANCE_ACCOUNT
    ,       MPS_NET_QUANTITY
    ,       MPS_SCHEDULED_COMPLETION_DATE
    ,       ORGANIZATION_ID
    ,       OUTSIDE_PROCESSING_ACCOUNT
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT
    ,       OVERHEAD_ACCOUNT
    ,       OVERHEAD_VARIANCE_ACCOUNT
    ,       PLANNED_QUANTITY
    ,       PRIMARY_ITEM_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PROJECT_ID
    ,       QUANTITY_COMPLETED
    ,       REQUEST_ID
    ,       RESOURCE_ACCOUNT
    ,       RESOURCE_VARIANCE_ACCOUNT
    ,       ROUTING_REVISION
    ,       ROUTING_REVISION_DATE
    ,       SCHEDULED_COMPLETION_DATE
    ,       SCHEDULED_FLAG
    ,       SCHEDULED_START_DATE
    ,       SCHEDULE_GROUP_ID
    ,       SCHEDULE_NUMBER
    ,       STATUS
    ,       STD_COST_ADJUSTMENT_ACCOUNT
    ,       TASK_ID
    ,       WIP_ENTITY_ID
    FROM    WIP_FLOW_SCHEDULES
    WHERE ( SCHEDULE_NUMBER = p_schedule_number
    )
    OR (    WIP_ENTITY_ID = p_wip_entity_id
    );

Line: 1326


        l_FlowSchedule_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1327


        l_FlowSchedule_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1328


        l_FlowSchedule_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1344


        l_FlowSchedule_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1416


    SELECT  ALTERNATE_BOM_DESIGNATOR
    ,       ALTERNATE_ROUTING_DESIGNATOR
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       BOM_REVISION
    ,       BOM_REVISION_DATE
    ,       BUILD_SEQUENCE
    ,       CLASS_CODE
    ,       COMPLETION_LOCATOR_ID
    ,       COMPLETION_SUBINVENTORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DATE_CLOSED
    ,       DEMAND_CLASS
    ,       DEMAND_SOURCE_DELIVERY
    ,       DEMAND_SOURCE_HEADER_ID
    ,       DEMAND_SOURCE_LINE
    ,       DEMAND_SOURCE_TYPE
    ,       KANBAN_CARD_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       MATERIAL_ACCOUNT
    ,       MATERIAL_OVERHEAD_ACCOUNT
    ,       MATERIAL_VARIANCE_ACCOUNT
    ,       MPS_NET_QUANTITY
    ,       MPS_SCHEDULED_COMPLETION_DATE
    ,       ORGANIZATION_ID
    ,       OUTSIDE_PROCESSING_ACCOUNT
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT
    ,       OVERHEAD_ACCOUNT
    ,       OVERHEAD_VARIANCE_ACCOUNT
    ,       PLANNED_QUANTITY
    ,       PRIMARY_ITEM_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       PROJECT_ID
    ,       QUANTITY_COMPLETED
    ,       REQUEST_ID
    ,       RESOURCE_ACCOUNT
    ,       RESOURCE_VARIANCE_ACCOUNT
    ,       ROUTING_REVISION
    ,       ROUTING_REVISION_DATE
    ,       SCHEDULED_COMPLETION_DATE
    ,       SCHEDULED_FLAG
    ,       SCHEDULED_START_DATE
    ,       SCHEDULE_GROUP_ID
    ,       SCHEDULE_NUMBER
    ,       STATUS
    ,       STD_COST_ADJUSTMENT_ACCOUNT
    ,       TASK_ID
    ,       WIP_ENTITY_ID
    INTO    l_FlowSchedule_rec.alternate_bom_designator
    ,       l_FlowSchedule_rec.alternate_rout_designator
    ,       l_FlowSchedule_rec.attribute1
    ,       l_FlowSchedule_rec.attribute10
    ,       l_FlowSchedule_rec.attribute11
    ,       l_FlowSchedule_rec.attribute12
    ,       l_FlowSchedule_rec.attribute13
    ,       l_FlowSchedule_rec.attribute14
    ,       l_FlowSchedule_rec.attribute15
    ,       l_FlowSchedule_rec.attribute2
    ,       l_FlowSchedule_rec.attribute3
    ,       l_FlowSchedule_rec.attribute4
    ,       l_FlowSchedule_rec.attribute5
    ,       l_FlowSchedule_rec.attribute6
    ,       l_FlowSchedule_rec.attribute7
    ,       l_FlowSchedule_rec.attribute8
    ,       l_FlowSchedule_rec.attribute9
    ,       l_FlowSchedule_rec.attribute_category
    ,       l_FlowSchedule_rec.bom_revision
    ,       l_FlowSchedule_rec.bom_revision_date
    ,       l_FlowSchedule_rec.build_sequence
    ,       l_FlowSchedule_rec.class_code
    ,       l_FlowSchedule_rec.completion_locator_id
    ,       l_FlowSchedule_rec.completion_subinventory
    ,       l_FlowSchedule_rec.created_by
    ,       l_FlowSchedule_rec.creation_date
    ,       l_FlowSchedule_rec.date_closed
    ,       l_FlowSchedule_rec.demand_class
    ,       l_FlowSchedule_rec.demand_source_delivery
    ,       l_FlowSchedule_rec.demand_source_header_id
    ,       l_FlowSchedule_rec.demand_source_line
    ,       l_FlowSchedule_rec.demand_source_type
    ,       l_FlowSchedule_rec.kanban_card_id
    ,       l_FlowSchedule_rec.last_updated_by
    ,       l_FlowSchedule_rec.last_update_date
    ,       l_FlowSchedule_rec.last_update_login
    ,       l_FlowSchedule_rec.line_id
    ,       l_FlowSchedule_rec.material_account
    ,       l_FlowSchedule_rec.material_overhead_account
    ,       l_FlowSchedule_rec.material_variance_account
    ,       l_FlowSchedule_rec.mps_net_quantity
    ,       l_FlowSchedule_rec.mps_scheduled_cpl_date
    ,       l_FlowSchedule_rec.organization_id
    ,       l_FlowSchedule_rec.osp_account
    ,       l_FlowSchedule_rec.osp_variance_account
    ,       l_FlowSchedule_rec.overhead_account
    ,       l_FlowSchedule_rec.overhead_variance_account
    ,       l_FlowSchedule_rec.planned_quantity
    ,       l_FlowSchedule_rec.primary_item_id
    ,       l_FlowSchedule_rec.program_application_id
    ,       l_FlowSchedule_rec.program_id
    ,       l_FlowSchedule_rec.program_update_date
    ,       l_FlowSchedule_rec.project_id
    ,       l_FlowSchedule_rec.quantity_completed
    ,       l_FlowSchedule_rec.request_id
    ,       l_FlowSchedule_rec.resource_account
    ,       l_FlowSchedule_rec.resource_variance_account
    ,       l_FlowSchedule_rec.routing_revision
    ,       l_FlowSchedule_rec.routing_revision_date
    ,       l_FlowSchedule_rec.scheduled_completion_date
    ,       l_FlowSchedule_rec.scheduled_flag
    ,       l_FlowSchedule_rec.scheduled_start_date
    ,       l_FlowSchedule_rec.schedule_group_id
    ,       l_FlowSchedule_rec.schedule_number
    ,       l_FlowSchedule_rec.status
    ,       l_FlowSchedule_rec.std_cost_adj_account
    ,       l_FlowSchedule_rec.task_id
    ,       l_FlowSchedule_rec.wip_entity_id
    FROM    WIP_FLOW_SCHEDULES
    WHERE   SCHEDULE_NUMBER = p_FlowSchedule_rec.schedule_number
        FOR UPDATE NOWAIT;

Line: 1624


    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_updated_by,
                         l_FlowSchedule_rec.last_updated_by)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_date,
                         l_FlowSchedule_rec.last_update_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_login,
                         l_FlowSchedule_rec.last_update_login)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.line_id,
                         l_FlowSchedule_rec.line_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_account,
                         l_FlowSchedule_rec.material_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_overhead_account,
                         l_FlowSchedule_rec.material_overhead_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_variance_account,
                         l_FlowSchedule_rec.material_variance_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_net_quantity,
                         l_FlowSchedule_rec.mps_net_quantity)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_scheduled_cpl_date,
                         l_FlowSchedule_rec.mps_scheduled_cpl_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.organization_id,
                         l_FlowSchedule_rec.organization_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_account,
                         l_FlowSchedule_rec.osp_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_variance_account,
                         l_FlowSchedule_rec.osp_variance_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_account,
                         l_FlowSchedule_rec.overhead_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_variance_account,
                         l_FlowSchedule_rec.overhead_variance_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.planned_quantity,
                         l_FlowSchedule_rec.planned_quantity)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.primary_item_id,
                         l_FlowSchedule_rec.primary_item_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_application_id,
                         l_FlowSchedule_rec.program_application_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_id,
                         l_FlowSchedule_rec.program_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_update_date,
                         l_FlowSchedule_rec.program_update_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.project_id,
                         l_FlowSchedule_rec.project_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.quantity_completed,
                         l_FlowSchedule_rec.quantity_completed)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.request_id,
                         l_FlowSchedule_rec.request_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_account,
                         l_FlowSchedule_rec.resource_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_variance_account,
                         l_FlowSchedule_rec.resource_variance_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision,
                         l_FlowSchedule_rec.routing_revision)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision_date,
                         l_FlowSchedule_rec.routing_revision_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_completion_date,
                         l_FlowSchedule_rec.scheduled_completion_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_flag,
                         l_FlowSchedule_rec.scheduled_flag)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_start_date,
                         l_FlowSchedule_rec.scheduled_start_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_group_id,
                         l_FlowSchedule_rec.schedule_group_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_number,
                         l_FlowSchedule_rec.schedule_number)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.status,
                         l_FlowSchedule_rec.status)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.std_cost_adj_account,
                         l_FlowSchedule_rec.std_cost_adj_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.task_id,
                         l_FlowSchedule_rec.task_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.wip_entity_id,
                         l_FlowSchedule_rec.wip_entity_id)
    THEN

        --  Row has not changed. Set out parameter.

        x_FlowSchedule_rec             := l_FlowSchedule_rec;

Line: 1732


            FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');

Line: 1836


    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_updated_by,
                         p_FlowSchedule_rec2.last_updated_by)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_date,
                         p_FlowSchedule_rec2.last_update_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_login,
                         p_FlowSchedule_rec2.last_update_login)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.line_id,
                         p_FlowSchedule_rec2.line_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_account,
                         p_FlowSchedule_rec2.material_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_overhead_account,
                         p_FlowSchedule_rec2.material_overhead_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_variance_account,
                         p_FlowSchedule_rec2.material_variance_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_net_quantity,
                         p_FlowSchedule_rec2.mps_net_quantity)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_scheduled_cpl_date,
                         p_FlowSchedule_rec2.mps_scheduled_cpl_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.organization_id,
                         p_FlowSchedule_rec2.organization_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_account,
                         p_FlowSchedule_rec2.osp_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_variance_account,
                         p_FlowSchedule_rec2.osp_variance_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_account,
                         p_FlowSchedule_rec2.overhead_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_variance_account,
                         p_FlowSchedule_rec2.overhead_variance_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.planned_quantity,
                         p_FlowSchedule_rec2.planned_quantity)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.primary_item_id,
                         p_FlowSchedule_rec2.primary_item_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_application_id,
                         p_FlowSchedule_rec2.program_application_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_id,
                         p_FlowSchedule_rec2.program_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_update_date,
                         p_FlowSchedule_rec2.program_update_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.project_id,
                         p_FlowSchedule_rec2.project_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.quantity_completed,
                         p_FlowSchedule_rec2.quantity_completed)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.request_id,
                         p_FlowSchedule_rec2.request_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_account,
                         p_FlowSchedule_rec2.resource_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_variance_account,
                         p_FlowSchedule_rec2.resource_variance_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision,
                         p_FlowSchedule_rec2.routing_revision)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision_date,
                         p_FlowSchedule_rec2.routing_revision_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_completion_date,
                         p_FlowSchedule_rec2.scheduled_completion_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_flag,
                         p_FlowSchedule_rec2.scheduled_flag)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_start_date,
                         p_FlowSchedule_rec2.scheduled_start_date)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_group_id,
                         p_FlowSchedule_rec2.schedule_group_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_number,
                         p_FlowSchedule_rec2.schedule_number)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.status,
                         p_FlowSchedule_rec2.status)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.std_cost_adj_account,
                         p_FlowSchedule_rec2.std_cost_adj_account)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.task_id,
                         p_FlowSchedule_rec2.task_id)
    AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.wip_entity_id,
                         p_FlowSchedule_rec2.wip_entity_id)
    THEN
       RETURN TRUE;