[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
* Procedure : Insert_Row
* Parameters IN : Direct Items column record
* Parameters OUT NOCOPY: Return Status
* Purpose : Procedure will perfrom an insert into the
* wip_eam_direct_items table.
*********************************************************************/
PROCEDURE Insert_Row
( X_DESCRIPTION IN VARCHAR2 ,
X_DIRECT_ITEM_TYPE IN NUMBER ,
X_PURCHASING_CATEGORY_ID IN NUMBER ,
X_DIRECT_ITEM_SEQUENCE_ID IN OUT NOCOPY NUMBER, -- Fix for Bug 3745360
X_INVENTORY_ITEM_ID IN NUMBER ,
X_OPERATION_SEQ_NUM IN NUMBER ,
X_DEPARTMENT_ID IN NUMBER ,
X_WIP_ENTITY_ID IN NUMBER ,
X_ORGANIZATION_ID IN NUMBER ,
X_SUGGESTED_VENDOR_NAME IN VARCHAR2 ,
X_SUGGESTED_VENDOR_ID IN NUMBER ,
X_SUGGESTED_VENDOR_SITE IN VARCHAR2 ,
X_SUGGESTED_VENDOR_SITE_ID IN NUMBER ,
X_SUGGESTED_VENDOR_CONTACT IN VARCHAR2 ,
X_SUGGESTED_VENDOR_CONTACT_ID IN NUMBER ,
X_SUGGESTED_VENDOR_PHONE IN VARCHAR2 ,
X_SUGGESTED_VENDOR_ITEM_NUM IN VARCHAR2 ,
X_UNIT_PRICE IN NUMBER ,
X_AUTO_REQUEST_MATERIAL IN VARCHAR2 ,
X_REQUIRED_QUANTITY IN NUMBER ,
X_UOM IN VARCHAR2 ,
X_NEED_BY_DATE IN DATE ,
X_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
X_ATTRIBUTE1 IN VARCHAR2 ,
X_ATTRIBUTE2 IN VARCHAR2 ,
X_ATTRIBUTE3 IN VARCHAR2 ,
X_ATTRIBUTE4 IN VARCHAR2 ,
X_ATTRIBUTE5 IN VARCHAR2 ,
X_ATTRIBUTE6 IN VARCHAR2 ,
X_ATTRIBUTE7 IN VARCHAR2 ,
X_ATTRIBUTE8 IN VARCHAR2 ,
X_ATTRIBUTE9 IN VARCHAR2 ,
X_ATTRIBUTE10 IN VARCHAR2 ,
X_ATTRIBUTE11 IN VARCHAR2 ,
X_ATTRIBUTE12 IN VARCHAR2 ,
X_ATTRIBUTE13 IN VARCHAR2 ,
X_ATTRIBUTE14 IN VARCHAR2 ,
X_ATTRIBUTE15 IN VARCHAR2 ,
X_PROGRAM_APPLICATION_ID IN NUMBER ,
X_PROGRAM_ID IN NUMBER ,
X_PROGRAM_UPDATE_DATE IN DATE ,
X_REQUEST_ID IN NUMBER ,
x_return_Status OUT NOCOPY VARCHAR2,
x_material_shortage_flag OUT NOCOPY VARCHAR2,
x_material_shortage_check_date OUT NOCOPY DATE
)
IS
l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
l_eam_direct_items_tbl.delete;
l_eam_mat_req_tbl.delete;
l_eam_direct_items_rec.PROGRAM_UPDATE_DATE := sysdate;
l_eam_mat_req_rec.PROGRAM_UPDATE_DATE := sysdate;
END Insert_Row;
* Procedure : Update_Row
* Parameters IN : Direct Items column record
* Parameters OUT NOCOPY: Message Token Table
* Return Status
* Purpose : Procedure will perfrom an Update on the
* wip_eam_direct_items
*********************************************************************/
PROCEDURE Update_Row
( X_DESCRIPTION IN VARCHAR2 ,
X_DIRECT_ITEM_TYPE IN NUMBER ,
X_PURCHASING_CATEGORY_ID IN NUMBER ,
X_DIRECT_ITEM_SEQUENCE_ID IN NUMBER ,
X_INVENTORY_ITEM_ID IN NUMBER ,
X_OPERATION_SEQ_NUM IN NUMBER ,
X_DEPARTMENT_ID IN NUMBER ,
X_WIP_ENTITY_ID IN NUMBER ,
X_ORGANIZATION_ID IN NUMBER ,
X_SUGGESTED_VENDOR_NAME IN VARCHAR2 ,
X_SUGGESTED_VENDOR_ID IN NUMBER ,
X_SUGGESTED_VENDOR_SITE IN VARCHAR2 ,
X_SUGGESTED_VENDOR_SITE_ID IN NUMBER ,
X_SUGGESTED_VENDOR_CONTACT IN VARCHAR2 ,
X_SUGGESTED_VENDOR_CONTACT_ID IN NUMBER ,
X_SUGGESTED_VENDOR_PHONE IN VARCHAR2 ,
X_SUGGESTED_VENDOR_ITEM_NUM IN VARCHAR2 ,
X_UNIT_PRICE IN NUMBER ,
X_AUTO_REQUEST_MATERIAL IN VARCHAR2 ,
X_REQUIRED_QUANTITY IN NUMBER ,
X_UOM IN VARCHAR2 ,
X_NEED_BY_DATE IN DATE ,
X_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
X_ATTRIBUTE1 IN VARCHAR2 ,
X_ATTRIBUTE2 IN VARCHAR2 ,
X_ATTRIBUTE3 IN VARCHAR2 ,
X_ATTRIBUTE4 IN VARCHAR2 ,
X_ATTRIBUTE5 IN VARCHAR2 ,
X_ATTRIBUTE6 IN VARCHAR2 ,
X_ATTRIBUTE7 IN VARCHAR2 ,
X_ATTRIBUTE8 IN VARCHAR2 ,
X_ATTRIBUTE9 IN VARCHAR2 ,
X_ATTRIBUTE10 IN VARCHAR2 ,
X_ATTRIBUTE11 IN VARCHAR2 ,
X_ATTRIBUTE12 IN VARCHAR2 ,
X_ATTRIBUTE13 IN VARCHAR2 ,
X_ATTRIBUTE14 IN VARCHAR2 ,
X_ATTRIBUTE15 IN VARCHAR2 ,
X_PROGRAM_APPLICATION_ID IN NUMBER ,
X_PROGRAM_ID IN NUMBER ,
X_PROGRAM_UPDATE_DATE IN DATE ,
X_REQUEST_ID IN NUMBER ,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MATERIAL_SHORTAGE_FLAG OUT NOCOPY VARCHAR2,
X_MATERIAL_SHORTAGE_CHECK_DATe OUT NOCOPY DATE
)
IS
l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
select attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
into
l_prev_attribute_category
,l_prev_attribute1
,l_prev_attribute2
,l_prev_attribute3
,l_prev_attribute4
,l_prev_attribute5
,l_prev_attribute6
,l_prev_attribute7
,l_prev_attribute8
,l_prev_attribute9
,l_prev_attribute10
,l_prev_attribute11
,l_prev_attribute12
,l_prev_attribute13
,l_prev_attribute14
,l_prev_attribute15
from WIP_EAM_DIRECT_ITEMS
where wip_entity_id =X_wip_Entity_Id
and organization_id = X_organization_id
and operation_seq_num= X_Operation_Seq_Num
and Direct_Item_Sequence_Id = X_Direct_Item_Sequence_Id;
l_eam_direct_items_rec.PROGRAM_UPDATE_DATE := sysdate;
l_eam_direct_items_rec.TRANSACTION_TYPE := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
select attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
into
l_prev_attribute_category
,l_prev_attribute1
,l_prev_attribute2
,l_prev_attribute3
,l_prev_attribute4
,l_prev_attribute5
,l_prev_attribute6
,l_prev_attribute7
,l_prev_attribute8
,l_prev_attribute9
,l_prev_attribute10
,l_prev_attribute11
,l_prev_attribute12
,l_prev_attribute13
,l_prev_attribute14
,l_prev_attribute15
from WIP_REQUIREMENT_OPERATIONS
where wip_entity_id =X_wip_Entity_Id
and organization_id = X_organization_id
and operation_seq_num= X_Operation_Seq_Num
and INVENTORY_ITEM_ID = X_inventory_item_id;
l_eam_mat_req_rec.PROGRAM_UPDATE_DATE := sysdate;
l_eam_mat_req_rec.TRANSACTION_TYPE := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
END Update_Row;
* Procedure : Delete_Row
* Parameters IN : Direct Items column record
* Parameters OUT NOCOPY: Message Token Table
* Return Status
* Purpose : Procedure will perfrom an Delete on the
* wip_eam_direct_items
*********************************************************************/
PROCEDURE Delete_Row
( X_DIRECT_ITEM_TYPE IN NUMBER,
X_DIRECT_ITEM_SEQUENCE_ID IN NUMBER,
X_INVENTORY_ITEM_ID IN NUMBER,
X_OPERATION_SEQ_NUM IN NUMBER,
X_WIP_ENTITY_ID IN NUMBER,
X_ORGANIZATION_ID IN NUMBER,
x_return_Status OUT NOCOPY VARCHAR2,
x_material_shortage_flag OUT NOCOPY VARCHAR2,
x_material_shortage_check_date OUT NOCOPY DATE
)
IS
l_eam_direct_items_rec EAM_PROCESS_WO_PUB.eam_direct_items_rec_type;
l_eam_direct_items_tbl.delete;
l_eam_mat_req_tbl.delete;
l_eam_direct_items_rec.TRANSACTION_TYPE := EAM_PROCESS_WO_PVT.G_OPR_DELETE;
l_eam_mat_req_rec.TRANSACTION_TYPE := EAM_PROCESS_WO_PVT.G_OPR_DELETE;
END Delete_Row;