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

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

Line: 246


      IF p_old_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN
 	 NULL;

Line: 249


	 l_DiscreteJob_rec.last_updated_by := p_old_DiscreteJob_rec.last_updated_by;

Line: 252


      IF p_old_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN
 	 NULL;

Line: 255


	 l_DiscreteJob_rec.last_update_date := p_old_DiscreteJob_rec.last_update_date;

Line: 258


      IF p_old_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN
 	 NULL;

Line: 261


	 l_DiscreteJob_rec.last_update_login := p_old_DiscreteJob_rec.last_update_login;

Line: 372


      IF p_old_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN
 	 NULL;

Line: 375


	 l_DiscreteJob_rec.program_update_date := p_old_DiscreteJob_rec.program_update_date;

Line: 654


      IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN
	 l_DiscreteJob_rec.last_updated_by := p_old_DiscreteJob_rec.last_updated_by;

Line: 658


      IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN
	 l_DiscreteJob_rec.last_update_date := p_old_DiscreteJob_rec.last_update_date;

Line: 662


      IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN
	 l_DiscreteJob_rec.last_update_login := p_old_DiscreteJob_rec.last_update_login;

Line: 738


      IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN
	 l_DiscreteJob_rec.program_update_date := p_old_DiscreteJob_rec.program_update_date;

Line: 989


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

Line: 993


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

Line: 997


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

Line: 1073


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

Line: 1167


PROCEDURE Update_Row
(   p_DiscreteJob_rec               IN  WIP_Work_Order_PUB.Discretejob_Rec_Type
)
IS
BEGIN

    UPDATE  WIP_DISCRETE_JOBS
    SET     ALTERNATE_BOM_DESIGNATOR       = p_DiscreteJob_rec.alternate_bom_designator
    ,       ALTERNATE_ROUTING_DESIGNATOR   = p_DiscreteJob_rec.alternate_rout_designator
    ,       ATTRIBUTE1                     = p_DiscreteJob_rec.attribute1
    ,       ATTRIBUTE10                    = p_DiscreteJob_rec.attribute10
    ,       ATTRIBUTE11                    = p_DiscreteJob_rec.attribute11
    ,       ATTRIBUTE12                    = p_DiscreteJob_rec.attribute12
    ,       ATTRIBUTE13                    = p_DiscreteJob_rec.attribute13
    ,       ATTRIBUTE14                    = p_DiscreteJob_rec.attribute14
    ,       ATTRIBUTE15                    = p_DiscreteJob_rec.attribute15
    ,       ATTRIBUTE2                     = p_DiscreteJob_rec.attribute2
    ,       ATTRIBUTE3                     = p_DiscreteJob_rec.attribute3
    ,       ATTRIBUTE4                     = p_DiscreteJob_rec.attribute4
    ,       ATTRIBUTE5                     = p_DiscreteJob_rec.attribute5
    ,       ATTRIBUTE6                     = p_DiscreteJob_rec.attribute6
    ,       ATTRIBUTE7                     = p_DiscreteJob_rec.attribute7
    ,       ATTRIBUTE8                     = p_DiscreteJob_rec.attribute8
    ,       ATTRIBUTE9                     = p_DiscreteJob_rec.attribute9
    ,       ATTRIBUTE_CATEGORY             = p_DiscreteJob_rec.attribute_category
    ,       BOM_REFERENCE_ID               = p_DiscreteJob_rec.bom_reference_id
    ,       BOM_REVISION                   = p_DiscreteJob_rec.bom_revision
    ,       BOM_REVISION_DATE              = p_DiscreteJob_rec.bom_revision_date
    ,       BUILD_SEQUENCE                 = p_DiscreteJob_rec.build_sequence
    ,       CLASS_CODE                     = p_DiscreteJob_rec.class_code
    ,       COMMON_BOM_SEQUENCE_ID         = p_DiscreteJob_rec.common_bom_sequence_id
    ,       COMMON_ROUTING_SEQUENCE_ID     = p_DiscreteJob_rec.common_rout_sequence_id
    ,       COMPLETION_LOCATOR_ID          = p_DiscreteJob_rec.completion_locator_id
    ,       COMPLETION_SUBINVENTORY        = p_DiscreteJob_rec.completion_subinventory
    ,       CREATED_BY                     = p_DiscreteJob_rec.created_by
    ,       CREATION_DATE                  = p_DiscreteJob_rec.creation_date
    ,       DATE_CLOSED                    = p_DiscreteJob_rec.date_closed
    ,       DATE_COMPLETED                 = p_DiscreteJob_rec.date_completed
    ,       DATE_RELEASED                  = p_DiscreteJob_rec.date_released
    ,       DEMAND_CLASS                   = p_DiscreteJob_rec.demand_class
    ,       DESCRIPTION                    = p_DiscreteJob_rec.description
    ,       FIRM_PLANNED_FLAG              = p_DiscreteJob_rec.firm_planned_flag
    ,       JOB_TYPE                       = p_DiscreteJob_rec.job_type
    ,       KANBAN_CARD_ID                 = p_DiscreteJob_rec.kanban_card_id
    ,       LAST_UPDATED_BY                = p_DiscreteJob_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_DiscreteJob_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_DiscreteJob_rec.last_update_login
    ,       LINE_ID                        = p_DiscreteJob_rec.line_id
    ,       LOT_NUMBER                     = p_DiscreteJob_rec.lot_number
    ,       MATERIAL_ACCOUNT               = p_DiscreteJob_rec.material_account
    ,       MATERIAL_OVERHEAD_ACCOUNT      = p_DiscreteJob_rec.material_overhead_account
    ,       MATERIAL_VARIANCE_ACCOUNT      = p_DiscreteJob_rec.material_variance_account
    ,       MPS_NET_QUANTITY               = p_DiscreteJob_rec.mps_net_quantity
    ,       MPS_SCHEDULED_COMPLETION_DATE  = p_DiscreteJob_rec.mps_scheduled_cpl_date
    ,       NET_QUANTITY                   = p_DiscreteJob_rec.net_quantity
    ,       ORGANIZATION_ID                = p_DiscreteJob_rec.organization_id
    ,       OUTSIDE_PROCESSING_ACCOUNT     = p_DiscreteJob_rec.osp_account
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT  = p_DiscreteJob_rec.osp_variance_account
    ,       OVERCOMPLETION_TOLERANCE_TYPE  = p_DiscreteJob_rec.overcpl_tolerance_type
    ,       OVERCOMPLETION_TOLERANCE_VALUE = p_DiscreteJob_rec.overcpl_tolerance_value
    ,       OVERHEAD_ACCOUNT               = p_DiscreteJob_rec.overhead_account
    ,       OVERHEAD_VARIANCE_ACCOUNT      = p_DiscreteJob_rec.overhead_variance_account
    ,       PRIMARY_ITEM_ID                = p_DiscreteJob_rec.primary_item_id
    ,       PROGRAM_APPLICATION_ID         = p_DiscreteJob_rec.program_application_id
    ,       PROGRAM_ID                     = p_DiscreteJob_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_DiscreteJob_rec.program_update_date
--    ,       PROJECT_COSTED                 = p_DiscreteJob_rec.project_costed
    ,       PROJECT_ID                     = p_DiscreteJob_rec.project_id
    ,       QUANTITY_COMPLETED             = p_DiscreteJob_rec.quantity_completed
    ,       QUANTITY_SCRAPPED              = p_DiscreteJob_rec.quantity_scrapped
    ,       REQUEST_ID                     = p_DiscreteJob_rec.request_id
    ,       RESOURCE_ACCOUNT               = p_DiscreteJob_rec.resource_account
    ,       RESOURCE_VARIANCE_ACCOUNT      = p_DiscreteJob_rec.resource_variance_account
    ,       ROUTING_REFERENCE_ID           = p_DiscreteJob_rec.routing_reference_id
    ,       ROUTING_REVISION               = p_DiscreteJob_rec.routing_revision
    ,       ROUTING_REVISION_DATE          = p_DiscreteJob_rec.routing_revision_date
    ,       SCHEDULED_COMPLETION_DATE      = p_DiscreteJob_rec.scheduled_completion_date
    ,       SCHEDULED_START_DATE           = p_DiscreteJob_rec.scheduled_start_date
    ,       SCHEDULE_GROUP_ID              = p_DiscreteJob_rec.schedule_group_id
    ,       SOURCE_CODE                    = p_DiscreteJob_rec.source_code
    ,       SOURCE_LINE_ID                 = p_DiscreteJob_rec.source_line_id
    ,       START_QUANTITY                 = p_DiscreteJob_rec.start_quantity
    ,       STATUS_TYPE                    = p_DiscreteJob_rec.status_type
    ,       STD_COST_ADJUSTMENT_ACCOUNT    = p_DiscreteJob_rec.std_cost_adj_account
    ,       TASK_ID                        = p_DiscreteJob_rec.task_id
    ,       WIP_ENTITY_ID                  = p_DiscreteJob_rec.wip_entity_id
    ,       WIP_SUPPLY_TYPE                = p_DiscreteJob_rec.wip_supply_type
    WHERE   WIP_ENTITY_ID = p_DiscreteJob_rec.wip_entity_id
    ;

Line: 1265


            ,   'Update_Row'
            );

Line: 1271


END Update_Row;

Line: 1275


PROCEDURE Insert_Row
(   p_DiscreteJob_rec               IN  WIP_Work_Order_PUB.Discretejob_Rec_Type
)
IS
BEGIN

    INSERT  INTO WIP_DISCRETE_JOBS
    (       ALTERNATE_BOM_DESIGNATOR
    ,       ALTERNATE_ROUTING_DESIGNATOR
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_CATEGORY
    ,       BOM_REFERENCE_ID
    ,       BOM_REVISION
    ,       BOM_REVISION_DATE
    ,       BUILD_SEQUENCE
    ,       CLASS_CODE
    ,       COMMON_BOM_SEQUENCE_ID
    ,       COMMON_ROUTING_SEQUENCE_ID
    ,       COMPLETION_LOCATOR_ID
    ,       COMPLETION_SUBINVENTORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DATE_CLOSED
    ,       DATE_COMPLETED
    ,       DATE_RELEASED
    ,       DEMAND_CLASS
    ,       DESCRIPTION
    ,       FIRM_PLANNED_FLAG
    ,       JOB_TYPE
    ,       KANBAN_CARD_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       LOT_NUMBER
    ,       MATERIAL_ACCOUNT
    ,       MATERIAL_OVERHEAD_ACCOUNT
    ,       MATERIAL_VARIANCE_ACCOUNT
    ,       MPS_NET_QUANTITY
    ,       MPS_SCHEDULED_COMPLETION_DATE
    ,       NET_QUANTITY
    ,       ORGANIZATION_ID
    ,       OUTSIDE_PROCESSING_ACCOUNT
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT
    ,       OVERCOMPLETION_TOLERANCE_TYPE
    ,       OVERCOMPLETION_TOLERANCE_VALUE
    ,       OVERHEAD_ACCOUNT
    ,       OVERHEAD_VARIANCE_ACCOUNT
    ,       PRIMARY_ITEM_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
--    ,       PROJECT_COSTED
    ,       PROJECT_ID
    ,       QUANTITY_COMPLETED
    ,       QUANTITY_SCRAPPED
    ,       REQUEST_ID
    ,       RESOURCE_ACCOUNT
    ,       RESOURCE_VARIANCE_ACCOUNT
    ,       ROUTING_REFERENCE_ID
    ,       ROUTING_REVISION
    ,       ROUTING_REVISION_DATE
    ,       SCHEDULED_COMPLETION_DATE
    ,       SCHEDULED_START_DATE
    ,       SCHEDULE_GROUP_ID
    ,       SOURCE_CODE
    ,       SOURCE_LINE_ID
    ,       START_QUANTITY
    ,       STATUS_TYPE
    ,       STD_COST_ADJUSTMENT_ACCOUNT
    ,       TASK_ID
    ,       WIP_ENTITY_ID
    ,       WIP_SUPPLY_TYPE
    )
    VALUES
    (       p_DiscreteJob_rec.alternate_bom_designator
    ,       p_DiscreteJob_rec.alternate_rout_designator
    ,       p_DiscreteJob_rec.attribute1
    ,       p_DiscreteJob_rec.attribute10
    ,       p_DiscreteJob_rec.attribute11
    ,       p_DiscreteJob_rec.attribute12
    ,       p_DiscreteJob_rec.attribute13
    ,       p_DiscreteJob_rec.attribute14
    ,       p_DiscreteJob_rec.attribute15
    ,       p_DiscreteJob_rec.attribute2
    ,       p_DiscreteJob_rec.attribute3
    ,       p_DiscreteJob_rec.attribute4
    ,       p_DiscreteJob_rec.attribute5
    ,       p_DiscreteJob_rec.attribute6
    ,       p_DiscreteJob_rec.attribute7
    ,       p_DiscreteJob_rec.attribute8
    ,       p_DiscreteJob_rec.attribute9
    ,       p_DiscreteJob_rec.attribute_category
    ,       p_DiscreteJob_rec.bom_reference_id
    ,       p_DiscreteJob_rec.bom_revision
    ,       p_DiscreteJob_rec.bom_revision_date
    ,       p_DiscreteJob_rec.build_sequence
    ,       p_DiscreteJob_rec.class_code
    ,       p_DiscreteJob_rec.common_bom_sequence_id
    ,       p_DiscreteJob_rec.common_rout_sequence_id
    ,       p_DiscreteJob_rec.completion_locator_id
    ,       p_DiscreteJob_rec.completion_subinventory
    ,       p_DiscreteJob_rec.created_by
    ,       p_DiscreteJob_rec.creation_date
    ,       p_DiscreteJob_rec.date_closed
    ,       p_DiscreteJob_rec.date_completed
    ,       p_DiscreteJob_rec.date_released
    ,       p_DiscreteJob_rec.demand_class
    ,       p_DiscreteJob_rec.description
    ,       p_DiscreteJob_rec.firm_planned_flag
    ,       p_DiscreteJob_rec.job_type
    ,       p_DiscreteJob_rec.kanban_card_id
    ,       p_DiscreteJob_rec.last_updated_by
    ,       p_DiscreteJob_rec.last_update_date
    ,       p_DiscreteJob_rec.last_update_login
    ,       p_DiscreteJob_rec.line_id
    ,       p_DiscreteJob_rec.lot_number
    ,       p_DiscreteJob_rec.material_account
    ,       p_DiscreteJob_rec.material_overhead_account
    ,       p_DiscreteJob_rec.material_variance_account
    ,       p_DiscreteJob_rec.mps_net_quantity
    ,       p_DiscreteJob_rec.mps_scheduled_cpl_date
    ,       p_DiscreteJob_rec.net_quantity
    ,       p_DiscreteJob_rec.organization_id
    ,       p_DiscreteJob_rec.osp_account
    ,       p_DiscreteJob_rec.osp_variance_account
    ,       p_DiscreteJob_rec.overcpl_tolerance_type
    ,       p_DiscreteJob_rec.overcpl_tolerance_value
    ,       p_DiscreteJob_rec.overhead_account
    ,       p_DiscreteJob_rec.overhead_variance_account
    ,       p_DiscreteJob_rec.primary_item_id
    ,       p_DiscreteJob_rec.program_application_id
    ,       p_DiscreteJob_rec.program_id
    ,       p_DiscreteJob_rec.program_update_date
--    ,       p_DiscreteJob_rec.project_costed
    ,       p_DiscreteJob_rec.project_id
    ,       p_DiscreteJob_rec.quantity_completed
    ,       p_DiscreteJob_rec.quantity_scrapped
    ,       p_DiscreteJob_rec.request_id
    ,       p_DiscreteJob_rec.resource_account
    ,       p_DiscreteJob_rec.resource_variance_account
    ,       p_DiscreteJob_rec.routing_reference_id
    ,       p_DiscreteJob_rec.routing_revision
    ,       p_DiscreteJob_rec.routing_revision_date
    ,       p_DiscreteJob_rec.scheduled_completion_date
    ,       p_DiscreteJob_rec.scheduled_start_date
    ,       p_DiscreteJob_rec.schedule_group_id
    ,       p_DiscreteJob_rec.source_code
    ,       p_DiscreteJob_rec.source_line_id
    ,       p_DiscreteJob_rec.start_quantity
    ,       p_DiscreteJob_rec.status_type
    ,       p_DiscreteJob_rec.std_cost_adj_account
    ,       p_DiscreteJob_rec.task_id
    ,       p_DiscreteJob_rec.wip_entity_id
    ,       p_DiscreteJob_rec.wip_supply_type
    );

Line: 1454


            ,   'Insert_Row'
            );

Line: 1460


END Insert_Row;

Line: 1464


PROCEDURE Delete_Row
(   p_wip_entity_id                 IN  NUMBER
)
IS
BEGIN

    DELETE  FROM WIP_DISCRETE_JOBS
    WHERE   WIP_ENTITY_ID = p_wip_entity_id
    ;

Line: 1482


            ,   'Delete_Row'
            );

Line: 1488


END Delete_Row;

Line: 1517


    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_REFERENCE_ID
    ,       BOM_REVISION
    ,       BOM_REVISION_DATE
    ,       BUILD_SEQUENCE
    ,       CLASS_CODE
    ,       COMMON_BOM_SEQUENCE_ID
    ,       COMMON_ROUTING_SEQUENCE_ID
    ,       COMPLETION_LOCATOR_ID
    ,       COMPLETION_SUBINVENTORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DATE_CLOSED
    ,       DATE_COMPLETED
    ,       DATE_RELEASED
    ,       DEMAND_CLASS
    ,       DESCRIPTION
    ,       FIRM_PLANNED_FLAG
    ,       JOB_TYPE
    ,       KANBAN_CARD_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       LOT_NUMBER
    ,       MATERIAL_ACCOUNT
    ,       MATERIAL_OVERHEAD_ACCOUNT
    ,       MATERIAL_VARIANCE_ACCOUNT
    ,       MPS_NET_QUANTITY
    ,       MPS_SCHEDULED_COMPLETION_DATE
    ,       NET_QUANTITY
    ,       ORGANIZATION_ID
    ,       OUTSIDE_PROCESSING_ACCOUNT
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT
    ,       OVERCOMPLETION_TOLERANCE_TYPE
    ,       OVERCOMPLETION_TOLERANCE_VALUE
    ,       OVERHEAD_ACCOUNT
    ,       OVERHEAD_VARIANCE_ACCOUNT
    ,       PRIMARY_ITEM_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
--    ,       PROJECT_COSTED
    ,       PROJECT_ID
    ,       QUANTITY_COMPLETED
    ,       QUANTITY_SCRAPPED
    ,       REQUEST_ID
    ,       RESOURCE_ACCOUNT
    ,       RESOURCE_VARIANCE_ACCOUNT
    ,       ROUTING_REFERENCE_ID
    ,       ROUTING_REVISION
    ,       ROUTING_REVISION_DATE
    ,       SCHEDULED_COMPLETION_DATE
    ,       SCHEDULED_START_DATE
    ,       SCHEDULE_GROUP_ID
    ,       SOURCE_CODE
    ,       SOURCE_LINE_ID
    ,       START_QUANTITY
    ,       STATUS_TYPE
    ,       STD_COST_ADJUSTMENT_ACCOUNT
    ,       TASK_ID
    ,       WIP_ENTITY_ID
    ,       WIP_SUPPLY_TYPE
    FROM    WIP_DISCRETE_JOBS
    WHERE ( WIP_ENTITY_ID = p_wip_entity_id
    );

Line: 1644


        l_DiscreteJob_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 1645


        l_DiscreteJob_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 1646


        l_DiscreteJob_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 1665


        l_DiscreteJob_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 1742


    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_REFERENCE_ID
    ,       BOM_REVISION
    ,       BOM_REVISION_DATE
    ,       BUILD_SEQUENCE
    ,       CLASS_CODE
    ,       COMMON_BOM_SEQUENCE_ID
    ,       COMMON_ROUTING_SEQUENCE_ID
    ,       COMPLETION_LOCATOR_ID
    ,       COMPLETION_SUBINVENTORY
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       DATE_CLOSED
    ,       DATE_COMPLETED
    ,       DATE_RELEASED
    ,       DEMAND_CLASS
    ,       DESCRIPTION
    ,       FIRM_PLANNED_FLAG
    ,       JOB_TYPE
    ,       KANBAN_CARD_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LINE_ID
    ,       LOT_NUMBER
    ,       MATERIAL_ACCOUNT
    ,       MATERIAL_OVERHEAD_ACCOUNT
    ,       MATERIAL_VARIANCE_ACCOUNT
    ,       MPS_NET_QUANTITY
    ,       MPS_SCHEDULED_COMPLETION_DATE
    ,       NET_QUANTITY
    ,       ORGANIZATION_ID
    ,       OUTSIDE_PROCESSING_ACCOUNT
    ,       OUTSIDE_PROC_VARIANCE_ACCOUNT
    ,       OVERCOMPLETION_TOLERANCE_TYPE
    ,       OVERCOMPLETION_TOLERANCE_VALUE
    ,       OVERHEAD_ACCOUNT
    ,       OVERHEAD_VARIANCE_ACCOUNT
    ,       PRIMARY_ITEM_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
--    ,       PROJECT_COSTED
    ,       PROJECT_ID
    ,       QUANTITY_COMPLETED
    ,       QUANTITY_SCRAPPED
    ,       REQUEST_ID
    ,       RESOURCE_ACCOUNT
    ,       RESOURCE_VARIANCE_ACCOUNT
    ,       ROUTING_REFERENCE_ID
    ,       ROUTING_REVISION
    ,       ROUTING_REVISION_DATE
    ,       SCHEDULED_COMPLETION_DATE
    ,       SCHEDULED_START_DATE
    ,       SCHEDULE_GROUP_ID
    ,       SOURCE_CODE
    ,       SOURCE_LINE_ID
    ,       START_QUANTITY
    ,       STATUS_TYPE
    ,       STD_COST_ADJUSTMENT_ACCOUNT
    ,       TASK_ID
    ,       WIP_ENTITY_ID
    ,       WIP_SUPPLY_TYPE
    INTO    l_DiscreteJob_rec.alternate_bom_designator
    ,       l_DiscreteJob_rec.alternate_rout_designator
    ,       l_DiscreteJob_rec.attribute1
    ,       l_DiscreteJob_rec.attribute10
    ,       l_DiscreteJob_rec.attribute11
    ,       l_DiscreteJob_rec.attribute12
    ,       l_DiscreteJob_rec.attribute13
    ,       l_DiscreteJob_rec.attribute14
    ,       l_DiscreteJob_rec.attribute15
    ,       l_DiscreteJob_rec.attribute2
    ,       l_DiscreteJob_rec.attribute3
    ,       l_DiscreteJob_rec.attribute4
    ,       l_DiscreteJob_rec.attribute5
    ,       l_DiscreteJob_rec.attribute6
    ,       l_DiscreteJob_rec.attribute7
    ,       l_DiscreteJob_rec.attribute8
    ,       l_DiscreteJob_rec.attribute9
    ,       l_DiscreteJob_rec.attribute_category
    ,       l_DiscreteJob_rec.bom_reference_id
    ,       l_DiscreteJob_rec.bom_revision
    ,       l_DiscreteJob_rec.bom_revision_date
    ,       l_DiscreteJob_rec.build_sequence
    ,       l_DiscreteJob_rec.class_code
    ,       l_DiscreteJob_rec.common_bom_sequence_id
    ,       l_DiscreteJob_rec.common_rout_sequence_id
    ,       l_DiscreteJob_rec.completion_locator_id
    ,       l_DiscreteJob_rec.completion_subinventory
    ,       l_DiscreteJob_rec.created_by
    ,       l_DiscreteJob_rec.creation_date
    ,       l_DiscreteJob_rec.date_closed
    ,       l_DiscreteJob_rec.date_completed
    ,       l_DiscreteJob_rec.date_released
    ,       l_DiscreteJob_rec.demand_class
    ,       l_DiscreteJob_rec.description
    ,       l_DiscreteJob_rec.firm_planned_flag
    ,       l_DiscreteJob_rec.job_type
    ,       l_DiscreteJob_rec.kanban_card_id
    ,       l_DiscreteJob_rec.last_updated_by
    ,       l_DiscreteJob_rec.last_update_date
    ,       l_DiscreteJob_rec.last_update_login
    ,       l_DiscreteJob_rec.line_id
    ,       l_DiscreteJob_rec.lot_number
    ,       l_DiscreteJob_rec.material_account
    ,       l_DiscreteJob_rec.material_overhead_account
    ,       l_DiscreteJob_rec.material_variance_account
    ,       l_DiscreteJob_rec.mps_net_quantity
    ,       l_DiscreteJob_rec.mps_scheduled_cpl_date
    ,       l_DiscreteJob_rec.net_quantity
    ,       l_DiscreteJob_rec.organization_id
    ,       l_DiscreteJob_rec.osp_account
    ,       l_DiscreteJob_rec.osp_variance_account
    ,       l_DiscreteJob_rec.overcpl_tolerance_type
    ,       l_DiscreteJob_rec.overcpl_tolerance_value
    ,       l_DiscreteJob_rec.overhead_account
    ,       l_DiscreteJob_rec.overhead_variance_account
    ,       l_DiscreteJob_rec.primary_item_id
    ,       l_DiscreteJob_rec.program_application_id
    ,       l_DiscreteJob_rec.program_id
    ,       l_DiscreteJob_rec.program_update_date
--    ,       l_DiscreteJob_rec.project_costed
    ,       l_DiscreteJob_rec.project_id
    ,       l_DiscreteJob_rec.quantity_completed
    ,       l_DiscreteJob_rec.quantity_scrapped
    ,       l_DiscreteJob_rec.request_id
    ,       l_DiscreteJob_rec.resource_account
    ,       l_DiscreteJob_rec.resource_variance_account
    ,       l_DiscreteJob_rec.routing_reference_id
    ,       l_DiscreteJob_rec.routing_revision
    ,       l_DiscreteJob_rec.routing_revision_date
    ,       l_DiscreteJob_rec.scheduled_completion_date
    ,       l_DiscreteJob_rec.scheduled_start_date
    ,       l_DiscreteJob_rec.schedule_group_id
    ,       l_DiscreteJob_rec.source_code
    ,       l_DiscreteJob_rec.source_line_id
    ,       l_DiscreteJob_rec.start_quantity
    ,       l_DiscreteJob_rec.status_type
    ,       l_DiscreteJob_rec.std_cost_adj_account
    ,       l_DiscreteJob_rec.task_id
    ,       l_DiscreteJob_rec.wip_entity_id
    ,       l_DiscreteJob_rec.wip_supply_type
    FROM    WIP_DISCRETE_JOBS
    WHERE   WIP_ENTITY_ID = p_DiscreteJob_rec.wip_entity_id
        FOR UPDATE NOWAIT;

Line: 1982


    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
                         l_DiscreteJob_rec.last_updated_by)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
                         l_DiscreteJob_rec.last_update_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
                         l_DiscreteJob_rec.last_update_login)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
                         l_DiscreteJob_rec.line_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
                         l_DiscreteJob_rec.lot_number)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
                         l_DiscreteJob_rec.material_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
                         l_DiscreteJob_rec.material_overhead_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
                         l_DiscreteJob_rec.material_variance_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
                         l_DiscreteJob_rec.mps_net_quantity)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
                         l_DiscreteJob_rec.mps_scheduled_cpl_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
                         l_DiscreteJob_rec.net_quantity)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
                         l_DiscreteJob_rec.organization_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
                         l_DiscreteJob_rec.osp_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
                         l_DiscreteJob_rec.osp_variance_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
                         l_DiscreteJob_rec.overcpl_tolerance_type)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
                         l_DiscreteJob_rec.overcpl_tolerance_value)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
                         l_DiscreteJob_rec.overhead_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
                         l_DiscreteJob_rec.overhead_variance_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
                         l_DiscreteJob_rec.primary_item_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
                         l_DiscreteJob_rec.program_application_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
                         l_DiscreteJob_rec.program_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
                         l_DiscreteJob_rec.program_update_date)
--    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
--                         l_DiscreteJob_rec.project_costed)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
                         l_DiscreteJob_rec.project_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
                         l_DiscreteJob_rec.quantity_completed)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
                         l_DiscreteJob_rec.quantity_scrapped)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
                         l_DiscreteJob_rec.request_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
                         l_DiscreteJob_rec.resource_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
                         l_DiscreteJob_rec.resource_variance_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
                         l_DiscreteJob_rec.routing_reference_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
                         l_DiscreteJob_rec.routing_revision)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
                         l_DiscreteJob_rec.routing_revision_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
                         l_DiscreteJob_rec.scheduled_completion_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
                         l_DiscreteJob_rec.scheduled_start_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
                         l_DiscreteJob_rec.schedule_group_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
                         l_DiscreteJob_rec.source_code)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
                         l_DiscreteJob_rec.source_line_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
                         l_DiscreteJob_rec.start_quantity)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
                         l_DiscreteJob_rec.status_type)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
                         l_DiscreteJob_rec.std_cost_adj_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
                         l_DiscreteJob_rec.task_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,
                         l_DiscreteJob_rec.wip_entity_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_supply_type,
                         l_DiscreteJob_rec.wip_supply_type)
    THEN

        --  Row has not changed. Set out parameter.

        x_DiscreteJob_rec              := l_DiscreteJob_rec;

Line: 2106


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

Line: 2219


    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
                         p_DiscreteJob_rec2.last_updated_by)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
                         p_DiscreteJob_rec2.last_update_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
                         p_DiscreteJob_rec2.last_update_login)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
                         p_DiscreteJob_rec2.line_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
                         p_DiscreteJob_rec2.lot_number)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
                         p_DiscreteJob_rec2.material_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
                         p_DiscreteJob_rec2.material_overhead_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
                         p_DiscreteJob_rec2.material_variance_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
                         p_DiscreteJob_rec2.mps_net_quantity)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
                         p_DiscreteJob_rec2.mps_scheduled_cpl_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
                         p_DiscreteJob_rec2.net_quantity)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
                         p_DiscreteJob_rec2.organization_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
                         p_DiscreteJob_rec2.osp_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
                         p_DiscreteJob_rec2.osp_variance_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
                         p_DiscreteJob_rec2.overcpl_tolerance_type)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
                         p_DiscreteJob_rec2.overcpl_tolerance_value)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
                         p_DiscreteJob_rec2.overhead_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
                         p_DiscreteJob_rec2.overhead_variance_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
                         p_DiscreteJob_rec2.primary_item_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
                         p_DiscreteJob_rec2.program_application_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
                         p_DiscreteJob_rec2.program_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
                         p_DiscreteJob_rec2.program_update_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
                         p_DiscreteJob_rec2.project_costed)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
                         p_DiscreteJob_rec2.project_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
                         p_DiscreteJob_rec2.quantity_completed)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
                         p_DiscreteJob_rec2.quantity_scrapped)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
                         p_DiscreteJob_rec2.request_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
                         p_DiscreteJob_rec2.resource_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
                         p_DiscreteJob_rec2.resource_variance_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
                         p_DiscreteJob_rec2.routing_reference_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
                         p_DiscreteJob_rec2.routing_revision)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
                         p_DiscreteJob_rec2.routing_revision_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
                         p_DiscreteJob_rec2.scheduled_completion_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
                         p_DiscreteJob_rec2.scheduled_start_date)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
                         p_DiscreteJob_rec2.schedule_group_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
                         p_DiscreteJob_rec2.source_code)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
                         p_DiscreteJob_rec2.source_line_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
                         p_DiscreteJob_rec2.start_quantity)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
                         p_DiscreteJob_rec2.status_type)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
                         p_DiscreteJob_rec2.std_cost_adj_account)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
                         p_DiscreteJob_rec2.task_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,
                         p_DiscreteJob_rec2.wip_entity_id)
    AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_supply_type,
                         p_DiscreteJob_rec2.wip_supply_type)
      THEN
       RETURN TRUE;

Line: 2347


PROCEDURE update_job_details(p_org_id IN NUMBER,
                             p_wip_entity_id IN NUMBER,
                             p_due_date IN DATE,
                             p_line_id IN NUMBER,
                             p_schedule_group_id IN NUMBER,
                             p_build_sequence IN NUMBER,
                             p_expedited IN VARCHAR2,
                             p_initialize IN VARCHAR2,
                             x_err_msg OUT NOCOPY VARCHAR2,
                             x_return_status OUT NOCOPY VARCHAR2) IS
CURSOR c_build_seq IS
	SELECT 1
	FROM WIP_DISCRETE_JOBS
	WHERE SCHEDULE_GROUP_ID = p_schedule_group_id
	AND   BUILD_SEQUENCE = p_build_sequence
	AND   WIP_ENTITY_ID <> NVL(p_wip_entity_id, -1);

Line: 2365


  select wip_entity_name
  from wip_entities
  where wip_entity_id = p_wip_entity_id;

Line: 2388


                              p_procedure_name => 'update_job_details',
                              p_error_text => x_err_msg);

Line: 2404


                              p_procedure_name => 'update_job_details',
                              p_error_text => x_err_msg);

Line: 2415


  update wip_discrete_jobs
    set due_date = p_due_date,
        line_id = p_line_id,
        schedule_group_id = p_schedule_group_id,
        build_sequence = p_build_sequence,
        expedited = p_expedited
    where organization_id = p_org_id and
          wip_entity_id = p_wip_entity_id;

Line: 2434


                              p_procedure_name => 'update_job_details',
                              p_error_text => SQLERRM);

Line: 2437


END update_job_details;