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_REPSCHEDULE_UTIL SQL Statements

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

Line: 159


      IF p_old_RepSchedule_rec.last_updated_by <> FND_API.G_MISS_NUM THEN
	 l_RepSchedule_rec.last_updated_by := p_old_RepSchedule_rec.last_updated_by;

Line: 163


      IF p_old_RepSchedule_rec.last_update_date <> FND_API.G_MISS_DATE THEN
	 l_RepSchedule_rec.last_update_date := p_old_RepSchedule_rec.last_update_date;

Line: 167


      IF p_old_RepSchedule_rec.last_update_login <> FND_API.G_MISS_NUM THEN
	 l_RepSchedule_rec.last_update_login := p_old_RepSchedule_rec.last_update_login;

Line: 219


      IF p_old_RepSchedule_rec.program_update_date <> FND_API.G_MISS_DATE THEN
	 l_RepSchedule_rec.program_update_date := p_old_RepSchedule_rec.program_update_date;

Line: 401


      IF l_RepSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
	 l_RepSchedule_rec.last_updated_by := p_old_RepSchedule_rec.last_updated_by;

Line: 405


      IF l_RepSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
	 l_RepSchedule_rec.last_update_date := p_old_RepSchedule_rec.last_update_date;

Line: 409


      IF l_RepSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
	 l_RepSchedule_rec.last_update_login := p_old_RepSchedule_rec.last_update_login;

Line: 461


      IF l_RepSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
	 l_RepSchedule_rec.program_update_date := p_old_RepSchedule_rec.program_update_date;

Line: 655


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

Line: 659


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

Line: 663


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

Line: 715


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

Line: 765


PROCEDURE Update_Row
(   p_RepSchedule_rec               IN  WIP_Work_Order_PUB.Repschedule_Rec_Type
)
IS
BEGIN

    UPDATE  WIP_REPETITIVE_SCHEDULES
    SET     ALTERNATE_BOM_DESIGNATOR       = p_RepSchedule_rec.alternate_bom_designator
    ,       ALTERNATE_ROUTING_DESIGNATOR   = p_RepSchedule_rec.alternate_rout_designator
    ,       ATTRIBUTE1                     = p_RepSchedule_rec.attribute1
    ,       ATTRIBUTE10                    = p_RepSchedule_rec.attribute10
    ,       ATTRIBUTE11                    = p_RepSchedule_rec.attribute11
    ,       ATTRIBUTE12                    = p_RepSchedule_rec.attribute12
    ,       ATTRIBUTE13                    = p_RepSchedule_rec.attribute13
    ,       ATTRIBUTE14                    = p_RepSchedule_rec.attribute14
    ,       ATTRIBUTE15                    = p_RepSchedule_rec.attribute15
    ,       ATTRIBUTE2                     = p_RepSchedule_rec.attribute2
    ,       ATTRIBUTE3                     = p_RepSchedule_rec.attribute3
    ,       ATTRIBUTE4                     = p_RepSchedule_rec.attribute4
    ,       ATTRIBUTE5                     = p_RepSchedule_rec.attribute5
    ,       ATTRIBUTE6                     = p_RepSchedule_rec.attribute6
    ,       ATTRIBUTE7                     = p_RepSchedule_rec.attribute7
    ,       ATTRIBUTE8                     = p_RepSchedule_rec.attribute8
    ,       ATTRIBUTE9                     = p_RepSchedule_rec.attribute9
    ,       ATTRIBUTE_CATEGORY             = p_RepSchedule_rec.attribute_category
    ,       BOM_REVISION                   = p_RepSchedule_rec.bom_revision
    ,       BOM_REVISION_DATE              = p_RepSchedule_rec.bom_revision_date
    ,       COMMON_BOM_SEQUENCE_ID         = p_RepSchedule_rec.common_bom_sequence_id
    ,       COMMON_ROUTING_SEQUENCE_ID     = p_RepSchedule_rec.common_rout_sequence_id
    ,       CREATED_BY                     = p_RepSchedule_rec.created_by
    ,       CREATION_DATE                  = p_RepSchedule_rec.creation_date
    ,       DAILY_PRODUCTION_RATE          = p_RepSchedule_rec.daily_production_rate
    ,       DATE_CLOSED                    = p_RepSchedule_rec.date_closed
    ,       DATE_RELEASED                  = p_RepSchedule_rec.date_released
    ,       DEMAND_CLASS                   = p_RepSchedule_rec.demand_class
    ,       DESCRIPTION                    = p_RepSchedule_rec.description
    ,       FIRM_PLANNED_FLAG              = p_RepSchedule_rec.firm_planned_flag
    ,       FIRST_UNIT_COMPLETION_DATE     = p_RepSchedule_rec.first_unit_cpl_date
    ,       FIRST_UNIT_START_DATE          = p_RepSchedule_rec.first_unit_start_date
    ,       LAST_UNIT_COMPLETION_DATE      = p_RepSchedule_rec.last_unit_cpl_date
    ,       LAST_UNIT_START_DATE           = p_RepSchedule_rec.last_unit_start_date
    ,       LAST_UPDATED_BY                = p_RepSchedule_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_RepSchedule_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_RepSchedule_rec.last_update_login
    ,       LINE_ID                        = p_RepSchedule_rec.line_id
    ,       MATERIAL_ACCOUNT               = p_RepSchedule_rec.material_account
    ,       MATERIAL_OVERHEAD_ACCOUNT      = p_RepSchedule_rec.material_overhead_account
    ,       MATERIAL_VARIANCE_ACCOUNT      = p_RepSchedule_rec.material_variance_account
    ,       ORGANIZATION_ID                = p_RepSchedule_rec.organization_id
    ,       OUTSIDE_PROCESSING_ACCOUNT     = p_RepSchedule_rec.osp_account
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT  = p_RepSchedule_rec.osp_variance_account
    ,       OVERHEAD_ACCOUNT               = p_RepSchedule_rec.overhead_account
    ,       OVERHEAD_VARIANCE_ACCOUNT      = p_RepSchedule_rec.overhead_variance_account
    ,       PROCESSING_WORK_DAYS           = p_RepSchedule_rec.processing_work_days
    ,       PROGRAM_APPLICATION_ID         = p_RepSchedule_rec.program_application_id
    ,       PROGRAM_ID                     = p_RepSchedule_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_RepSchedule_rec.program_update_date
    ,       QUANTITY_COMPLETED             = p_RepSchedule_rec.quantity_completed
    ,       REPETITIVE_SCHEDULE_ID         = p_RepSchedule_rec.repetitive_schedule_id
    ,       REQUEST_ID                     = p_RepSchedule_rec.request_id
    ,       RESOURCE_ACCOUNT               = p_RepSchedule_rec.resource_account
    ,       RESOURCE_VARIANCE_ACCOUNT      = p_RepSchedule_rec.resource_variance_account
    ,       ROUTING_REVISION               = p_RepSchedule_rec.routing_revision
    ,       ROUTING_REVISION_DATE          = p_RepSchedule_rec.routing_revision_date
    ,       STATUS_TYPE                    = p_RepSchedule_rec.status_type
    ,       WIP_ENTITY_ID                  = p_RepSchedule_rec.wip_entity_id
    WHERE   REPETITIVE_SCHEDULE_ID = p_RepSchedule_rec.repetitive_schedule_id
    ;

Line: 842


            ,   'Update_Row'
            );

Line: 848


END Update_Row;

Line: 852


PROCEDURE Insert_Row
(   p_RepSchedule_rec               IN  WIP_Work_Order_PUB.Repschedule_Rec_Type
)
IS
BEGIN

    INSERT  INTO WIP_REPETITIVE_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
    ,       COMMON_BOM_SEQUENCE_ID
    ,       COMMON_ROUTING_SEQUENCE_ID
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DAILY_PRODUCTION_RATE
    ,       DATE_CLOSED
    ,       DATE_RELEASED
    ,       DEMAND_CLASS
    ,       DESCRIPTION
    ,       FIRM_PLANNED_FLAG
    ,       FIRST_UNIT_COMPLETION_DATE
    ,       FIRST_UNIT_START_DATE
    ,       LAST_UNIT_COMPLETION_DATE
    ,       LAST_UNIT_START_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       MATERIAL_ACCOUNT
    ,       MATERIAL_OVERHEAD_ACCOUNT
    ,       MATERIAL_VARIANCE_ACCOUNT
    ,       ORGANIZATION_ID
    ,       OUTSIDE_PROCESSING_ACCOUNT
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT
    ,       OVERHEAD_ACCOUNT
    ,       OVERHEAD_VARIANCE_ACCOUNT
    ,       PROCESSING_WORK_DAYS
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QUANTITY_COMPLETED
    ,       REPETITIVE_SCHEDULE_ID
    ,       REQUEST_ID
    ,       RESOURCE_ACCOUNT
    ,       RESOURCE_VARIANCE_ACCOUNT
    ,       ROUTING_REVISION
    ,       ROUTING_REVISION_DATE
    ,       STATUS_TYPE
    ,       WIP_ENTITY_ID
    )
    VALUES
    (       p_RepSchedule_rec.alternate_bom_designator
    ,       p_RepSchedule_rec.alternate_rout_designator
    ,       p_RepSchedule_rec.attribute1
    ,       p_RepSchedule_rec.attribute10
    ,       p_RepSchedule_rec.attribute11
    ,       p_RepSchedule_rec.attribute12
    ,       p_RepSchedule_rec.attribute13
    ,       p_RepSchedule_rec.attribute14
    ,       p_RepSchedule_rec.attribute15
    ,       p_RepSchedule_rec.attribute2
    ,       p_RepSchedule_rec.attribute3
    ,       p_RepSchedule_rec.attribute4
    ,       p_RepSchedule_rec.attribute5
    ,       p_RepSchedule_rec.attribute6
    ,       p_RepSchedule_rec.attribute7
    ,       p_RepSchedule_rec.attribute8
    ,       p_RepSchedule_rec.attribute9
    ,       p_RepSchedule_rec.attribute_category
    ,       p_RepSchedule_rec.bom_revision
    ,       p_RepSchedule_rec.bom_revision_date
    ,       p_RepSchedule_rec.common_bom_sequence_id
    ,       p_RepSchedule_rec.common_rout_sequence_id
    ,       p_RepSchedule_rec.created_by
    ,       p_RepSchedule_rec.creation_date
    ,       p_RepSchedule_rec.daily_production_rate
    ,       p_RepSchedule_rec.date_closed
    ,       p_RepSchedule_rec.date_released
    ,       p_RepSchedule_rec.demand_class
    ,       p_RepSchedule_rec.description
    ,       p_RepSchedule_rec.firm_planned_flag
    ,       p_RepSchedule_rec.first_unit_cpl_date
    ,       p_RepSchedule_rec.first_unit_start_date
    ,       p_RepSchedule_rec.last_unit_cpl_date
    ,       p_RepSchedule_rec.last_unit_start_date
    ,       p_RepSchedule_rec.last_updated_by
    ,       p_RepSchedule_rec.last_update_date
    ,       p_RepSchedule_rec.last_update_login
    ,       p_RepSchedule_rec.line_id
    ,       p_RepSchedule_rec.material_account
    ,       p_RepSchedule_rec.material_overhead_account
    ,       p_RepSchedule_rec.material_variance_account
    ,       p_RepSchedule_rec.organization_id
    ,       p_RepSchedule_rec.osp_account
    ,       p_RepSchedule_rec.osp_variance_account
    ,       p_RepSchedule_rec.overhead_account
    ,       p_RepSchedule_rec.overhead_variance_account
    ,       p_RepSchedule_rec.processing_work_days
    ,       p_RepSchedule_rec.program_application_id
    ,       p_RepSchedule_rec.program_id
    ,       p_RepSchedule_rec.program_update_date
    ,       p_RepSchedule_rec.quantity_completed
    ,       p_RepSchedule_rec.repetitive_schedule_id
    ,       p_RepSchedule_rec.request_id
    ,       p_RepSchedule_rec.resource_account
    ,       p_RepSchedule_rec.resource_variance_account
    ,       p_RepSchedule_rec.routing_revision
    ,       p_RepSchedule_rec.routing_revision_date
    ,       p_RepSchedule_rec.status_type
    ,       p_RepSchedule_rec.wip_entity_id
    );

Line: 989


            ,   'Insert_Row'
            );

Line: 995


END Insert_Row;

Line: 999


PROCEDURE Delete_Row
(   p_repetitive_schedule_id        IN  NUMBER
)
IS
BEGIN

    DELETE  FROM WIP_REPETITIVE_SCHEDULES
    WHERE   REPETITIVE_SCHEDULE_ID = p_repetitive_schedule_id
    ;

Line: 1017


            ,   'Delete_Row'
            );

Line: 1023


END Delete_Row;

Line: 1066


    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
    ,       COMMON_BOM_SEQUENCE_ID
    ,       COMMON_ROUTING_SEQUENCE_ID
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DAILY_PRODUCTION_RATE
    ,       DATE_CLOSED
    ,       DATE_RELEASED
    ,       DEMAND_CLASS
    ,       DESCRIPTION
    ,       FIRM_PLANNED_FLAG
    ,       FIRST_UNIT_COMPLETION_DATE
    ,       FIRST_UNIT_START_DATE
    ,       LAST_UNIT_COMPLETION_DATE
    ,       LAST_UNIT_START_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       MATERIAL_ACCOUNT
    ,       MATERIAL_OVERHEAD_ACCOUNT
    ,       MATERIAL_VARIANCE_ACCOUNT
    ,       ORGANIZATION_ID
    ,       OUTSIDE_PROCESSING_ACCOUNT
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT
    ,       OVERHEAD_ACCOUNT
    ,       OVERHEAD_VARIANCE_ACCOUNT
    ,       PROCESSING_WORK_DAYS
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QUANTITY_COMPLETED
    ,       REPETITIVE_SCHEDULE_ID
    ,       REQUEST_ID
    ,       RESOURCE_ACCOUNT
    ,       RESOURCE_VARIANCE_ACCOUNT
    ,       ROUTING_REVISION
    ,       ROUTING_REVISION_DATE
    ,       STATUS_TYPE
    ,       WIP_ENTITY_ID
    FROM    WIP_REPETITIVE_SCHEDULES
    WHERE ( REPETITIVE_SCHEDULE_ID = nvl(p_repetitive_schedule_id,FND_API.G_MISS_NUM)
    )
    OR (    WIP_ENTITY_ID = nvl(p_wip_entity_id,FND_API.G_MISS_NUM)
    );

Line: 1194


        l_RepSchedule_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1195


        l_RepSchedule_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1196


        l_RepSchedule_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1209


        l_RepSchedule_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1274


    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
    ,       COMMON_BOM_SEQUENCE_ID
    ,       COMMON_ROUTING_SEQUENCE_ID
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DAILY_PRODUCTION_RATE
    ,       DATE_CLOSED
    ,       DATE_RELEASED
    ,       DEMAND_CLASS
    ,       DESCRIPTION
    ,       FIRM_PLANNED_FLAG
    ,       FIRST_UNIT_COMPLETION_DATE
    ,       FIRST_UNIT_START_DATE
    ,       LAST_UNIT_COMPLETION_DATE
    ,       LAST_UNIT_START_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       MATERIAL_ACCOUNT
    ,       MATERIAL_OVERHEAD_ACCOUNT
    ,       MATERIAL_VARIANCE_ACCOUNT
    ,       ORGANIZATION_ID
    ,       OUTSIDE_PROCESSING_ACCOUNT
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT
    ,       OVERHEAD_ACCOUNT
    ,       OVERHEAD_VARIANCE_ACCOUNT
    ,       PROCESSING_WORK_DAYS
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       QUANTITY_COMPLETED
    ,       REPETITIVE_SCHEDULE_ID
    ,       REQUEST_ID
    ,       RESOURCE_ACCOUNT
    ,       RESOURCE_VARIANCE_ACCOUNT
    ,       ROUTING_REVISION
    ,       ROUTING_REVISION_DATE
    ,       STATUS_TYPE
    ,       WIP_ENTITY_ID
    INTO    l_RepSchedule_rec.alternate_bom_designator
    ,       l_RepSchedule_rec.alternate_rout_designator
    ,       l_RepSchedule_rec.attribute1
    ,       l_RepSchedule_rec.attribute10
    ,       l_RepSchedule_rec.attribute11
    ,       l_RepSchedule_rec.attribute12
    ,       l_RepSchedule_rec.attribute13
    ,       l_RepSchedule_rec.attribute14
    ,       l_RepSchedule_rec.attribute15
    ,       l_RepSchedule_rec.attribute2
    ,       l_RepSchedule_rec.attribute3
    ,       l_RepSchedule_rec.attribute4
    ,       l_RepSchedule_rec.attribute5
    ,       l_RepSchedule_rec.attribute6
    ,       l_RepSchedule_rec.attribute7
    ,       l_RepSchedule_rec.attribute8
    ,       l_RepSchedule_rec.attribute9
    ,       l_RepSchedule_rec.attribute_category
    ,       l_RepSchedule_rec.bom_revision
    ,       l_RepSchedule_rec.bom_revision_date
    ,       l_RepSchedule_rec.common_bom_sequence_id
    ,       l_RepSchedule_rec.common_rout_sequence_id
    ,       l_RepSchedule_rec.created_by
    ,       l_RepSchedule_rec.creation_date
    ,       l_RepSchedule_rec.daily_production_rate
    ,       l_RepSchedule_rec.date_closed
    ,       l_RepSchedule_rec.date_released
    ,       l_RepSchedule_rec.demand_class
    ,       l_RepSchedule_rec.description
    ,       l_RepSchedule_rec.firm_planned_flag
    ,       l_RepSchedule_rec.first_unit_cpl_date
    ,       l_RepSchedule_rec.first_unit_start_date
    ,       l_RepSchedule_rec.last_unit_cpl_date
    ,       l_RepSchedule_rec.last_unit_start_date
    ,       l_RepSchedule_rec.last_updated_by
    ,       l_RepSchedule_rec.last_update_date
    ,       l_RepSchedule_rec.last_update_login
    ,       l_RepSchedule_rec.line_id
    ,       l_RepSchedule_rec.material_account
    ,       l_RepSchedule_rec.material_overhead_account
    ,       l_RepSchedule_rec.material_variance_account
    ,       l_RepSchedule_rec.organization_id
    ,       l_RepSchedule_rec.osp_account
    ,       l_RepSchedule_rec.osp_variance_account
    ,       l_RepSchedule_rec.overhead_account
    ,       l_RepSchedule_rec.overhead_variance_account
    ,       l_RepSchedule_rec.processing_work_days
    ,       l_RepSchedule_rec.program_application_id
    ,       l_RepSchedule_rec.program_id
    ,       l_RepSchedule_rec.program_update_date
    ,       l_RepSchedule_rec.quantity_completed
    ,       l_RepSchedule_rec.repetitive_schedule_id
    ,       l_RepSchedule_rec.request_id
    ,       l_RepSchedule_rec.resource_account
    ,       l_RepSchedule_rec.resource_variance_account
    ,       l_RepSchedule_rec.routing_revision
    ,       l_RepSchedule_rec.routing_revision_date
    ,       l_RepSchedule_rec.status_type
    ,       l_RepSchedule_rec.wip_entity_id
    FROM    WIP_REPETITIVE_SCHEDULES
    WHERE   REPETITIVE_SCHEDULE_ID = p_RepSchedule_rec.repetitive_schedule_id
        FOR UPDATE NOWAIT;

Line: 1466


    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_updated_by,
                         l_RepSchedule_rec.last_updated_by)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_date,
                         l_RepSchedule_rec.last_update_date)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.last_update_login,
                         l_RepSchedule_rec.last_update_login)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.line_id,
                         l_RepSchedule_rec.line_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_account,
                         l_RepSchedule_rec.material_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_overhead_account,
                         l_RepSchedule_rec.material_overhead_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.material_variance_account,
                         l_RepSchedule_rec.material_variance_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.organization_id,
                         l_RepSchedule_rec.organization_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_account,
                         l_RepSchedule_rec.osp_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.osp_variance_account,
                         l_RepSchedule_rec.osp_variance_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_account,
                         l_RepSchedule_rec.overhead_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.overhead_variance_account,
                         l_RepSchedule_rec.overhead_variance_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.processing_work_days,
                         l_RepSchedule_rec.processing_work_days)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_application_id,
                         l_RepSchedule_rec.program_application_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_id,
                         l_RepSchedule_rec.program_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.program_update_date,
                         l_RepSchedule_rec.program_update_date)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.quantity_completed,
                         l_RepSchedule_rec.quantity_completed)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.repetitive_schedule_id,
                         l_RepSchedule_rec.repetitive_schedule_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.request_id,
                         l_RepSchedule_rec.request_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_account,
                         l_RepSchedule_rec.resource_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.resource_variance_account,
                         l_RepSchedule_rec.resource_variance_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision,
                         l_RepSchedule_rec.routing_revision)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.routing_revision_date,
                         l_RepSchedule_rec.routing_revision_date)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.status_type,
                         l_RepSchedule_rec.status_type)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec.wip_entity_id,
                         l_RepSchedule_rec.wip_entity_id)
    THEN

        --  Row has not changed. Set out parameter.

        x_RepSchedule_rec              := l_RepSchedule_rec;

Line: 1554


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

Line: 1660


    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_updated_by,
                         p_RepSchedule_rec2.last_updated_by)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_date,
                         p_RepSchedule_rec2.last_update_date)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.last_update_login,
                         p_RepSchedule_rec2.last_update_login)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.line_id,
                         p_RepSchedule_rec2.line_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_account,
                         p_RepSchedule_rec2.material_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_overhead_account,
                         p_RepSchedule_rec2.material_overhead_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.material_variance_account,
                         p_RepSchedule_rec2.material_variance_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.organization_id,
                         p_RepSchedule_rec2.organization_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_account,
                         p_RepSchedule_rec2.osp_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.osp_variance_account,
                         p_RepSchedule_rec2.osp_variance_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_account,
                         p_RepSchedule_rec2.overhead_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.overhead_variance_account,
                         p_RepSchedule_rec2.overhead_variance_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.processing_work_days,
                         p_RepSchedule_rec2.processing_work_days)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_application_id,
                         p_RepSchedule_rec2.program_application_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_id,
                         p_RepSchedule_rec2.program_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.program_update_date,
                         p_RepSchedule_rec2.program_update_date)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.quantity_completed,
                         p_RepSchedule_rec2.quantity_completed)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.repetitive_schedule_id,
                         p_RepSchedule_rec2.repetitive_schedule_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.request_id,
                         p_RepSchedule_rec2.request_id)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_account,
                         p_RepSchedule_rec2.resource_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.resource_variance_account,
                         p_RepSchedule_rec2.resource_variance_account)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision,
                         p_RepSchedule_rec2.routing_revision)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.routing_revision_date,
                         p_RepSchedule_rec2.routing_revision_date)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.status_type,
                         p_RepSchedule_rec2.status_type)
    AND WIP_GLOBALS.Equal(p_RepSchedule_rec1.wip_entity_id,
                         p_RepSchedule_rec2.wip_entity_id)
    THEN
          RETURN TRUE;