The following lines contain the word 'select', 'insert', 'update' or 'delete':
P_LAST_UPDATE_DATE IN DATE ,
P_LAST_UPDATED_BY IN NUMBER ,
P_CREATION_DATE IN DATE ,
P_CREATED_BY IN NUMBER ,
P_LAST_UPDATE_LOGIN IN NUMBER ,
X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
) IS
BEGIN
-- Initialize the Error Stack
PA_DEBUG.init_err_stack('PA_STATUS_LIST_ITEMS_PUB.CreateStatusListItem');
P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
P_CREATION_DATE => P_CREATION_DATE,
P_CREATED_BY => P_CREATED_BY,
P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
X_RETURN_STATUS => X_RETURN_STATUS,
X_MSG_COUNT => X_MSG_COUNT,
X_MSG_DATA => X_MSG_DATA
);
PROCEDURE UpdateStatusListItem (
P_RECORD_VERSION_NUMBER IN NUMBER,
P_STATUS_LIST_ITEM_ID IN NUMBER,
P_STATUS_LIST_ID IN NUMBER,
P_PROJECT_STATUS_CODE IN VARCHAR2,
P_LAST_UPDATE_DATE IN DATE ,
P_LAST_UPDATED_BY IN NUMBER ,
P_CREATION_DATE IN DATE ,
P_CREATED_BY IN NUMBER ,
P_LAST_UPDATE_LOGIN IN NUMBER ,
X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
) IS
l_rec_version_no NUMBER;
PA_DEBUG.init_err_stack('PA_STATUS_LIST_ITEMS_PUB.UpdateStatusListItem');
PA_STATUS_LIST_ITEMS_PVT.UpdateStatusListItem
(
P_RECORD_VERSION_NUMBER=> P_RECORD_VERSION_NUMBER,
P_STATUS_LIST_ITEM_ID => P_STATUS_LIST_ITEM_ID,
P_STATUS_LIST_ID => P_STATUS_LIST_ID,
P_PROJECT_STATUS_CODE => P_PROJECT_STATUS_CODE,
P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
P_CREATION_DATE => P_CREATION_DATE,
P_CREATED_BY => P_CREATED_BY,
P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
X_RETURN_STATUS => X_RETURN_STATUS,
X_MSG_COUNT => X_MSG_COUNT,
X_MSG_DATA => X_MSG_DATA
);
END UpdateStatusListItem;
PROCEDURE DeleteStatusListItem (
P_STATUS_LIST_ITEM_ID IN NUMBER,
P_RECORD_VERSION_NUMBER IN NUMBER,
X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
BEGIN
-- Initialize the Error Stack
PA_DEBUG.init_err_stack('PA_STATUS_LIST_ITEMS_PUB.DeleteStatusListItem');
PA_STATUS_LIST_ITEMS_PVT.DeleteStatusListItem
( P_STATUS_LIST_ITEM_ID => P_STATUS_LIST_ITEM_ID,
P_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
X_RETURN_STATUS => X_RETURN_STATUS,
X_MSG_COUNT => X_MSG_COUNT,
X_MSG_DATA => X_MSG_DATA
);
END DeleteStatusListItem;