[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;
l_eam_direct_items_rec.PROGRAM_UPDATE_DATE := sysdate;
l_eam_direct_items_rec.TRANSACTION_TYPE := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
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;