The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF p_old_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN
NULL;
l_DiscreteJob_rec.last_updated_by := p_old_DiscreteJob_rec.last_updated_by;
IF p_old_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN
NULL;
l_DiscreteJob_rec.last_update_date := p_old_DiscreteJob_rec.last_update_date;
IF p_old_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN
NULL;
l_DiscreteJob_rec.last_update_login := p_old_DiscreteJob_rec.last_update_login;
IF p_old_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN
NULL;
l_DiscreteJob_rec.program_update_date := p_old_DiscreteJob_rec.program_update_date;
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;
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;
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;
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;
IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_DiscreteJob_rec.last_updated_by := NULL;
IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_DiscreteJob_rec.last_update_date := NULL;
IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_DiscreteJob_rec.last_update_login := NULL;
IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_DiscreteJob_rec.program_update_date := NULL;
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
;
, 'Update_Row'
);
END Update_Row;
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
);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_wip_entity_id IN NUMBER
)
IS
BEGIN
DELETE FROM WIP_DISCRETE_JOBS
WHERE WIP_ENTITY_ID = p_wip_entity_id
;
, 'Delete_Row'
);
END Delete_Row;
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
);
l_DiscreteJob_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
l_DiscreteJob_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
l_DiscreteJob_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
l_DiscreteJob_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;
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;
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;
FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');
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;
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);
select wip_entity_name
from wip_entities
where wip_entity_id = p_wip_entity_id;
p_procedure_name => 'update_job_details',
p_error_text => x_err_msg);
p_procedure_name => 'update_job_details',
p_error_text => x_err_msg);
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;
p_procedure_name => 'update_job_details',
p_error_text => SQLERRM);
END update_job_details;